Requirement is to Hide Formatted text filed based on conditions in OAF Notification Page.
the screen looks like below.
We have to write below code in CO process request method.
String AdditionalmsgNoti = "SELECT xx_inv_wf_notif_pkg.auto_approve_check_notif_page(:1) FROM dual";
String eligibleAutoApprove = "";
oapagecontext.writeDiagnostics(this,"Executing Query: \n"+AdditionalmsgNoti ,1);
try
{
PreparedStatement preparedstatement = oadbtransaction.createPreparedStatement(AdditionalmsgNoti,0);
preparedstatement.setString(1,s1);
for (ResultSet resultset = preparedstatement.executeQuery();
resultset.next(); )
eligibleAutoApprove= resultset.getString(1);
}
catch (Exception e)
{
oapagecontext.writeDiagnostics(this,"Exception in executing Query: \n"+AdditionalmsgNoti ,1);
throw OAException.wrapperException(e);
}
if (eligibleAutoApprove.equals("N"))
{
OAFormattedTextBean omb19 =
(OAFormattedTextBean)oawebbean.findChildRecursive("AddLinkText");
omb19.setText(" ");
omb19.setRendered(false);
}
the screen looks like below.
We have to write below code in CO process request method.
String AdditionalmsgNoti = "SELECT xx_inv_wf_notif_pkg.auto_approve_check_notif_page(:1) FROM dual";
String eligibleAutoApprove = "";
oapagecontext.writeDiagnostics(this,"Executing Query: \n"+AdditionalmsgNoti ,1);
try
{
PreparedStatement preparedstatement = oadbtransaction.createPreparedStatement(AdditionalmsgNoti,0);
preparedstatement.setString(1,s1);
for (ResultSet resultset = preparedstatement.executeQuery();
resultset.next(); )
eligibleAutoApprove= resultset.getString(1);
}
catch (Exception e)
{
oapagecontext.writeDiagnostics(this,"Exception in executing Query: \n"+AdditionalmsgNoti ,1);
throw OAException.wrapperException(e);
}
if (eligibleAutoApprove.equals("N"))
{
OAFormattedTextBean omb19 =
(OAFormattedTextBean)oawebbean.findChildRecursive("AddLinkText");
omb19.setText(" ");
omb19.setRendered(false);
}
No comments:
Post a Comment