Key FlexField in OAF Pages

KFF in OAF Page-Gyan

Using Inline Custom CSS

 
import oracle.cabo.style.CSSStyle;
CSSStyle customUnCss = new CSSStyle();
customUnCss.setProperty("text-transform","uppercase");
customUnCss.setProperty("color", "#F6358A");//# -purple
OAStaticStyledTextBean staticbean = (OAStaticStyledTextBean) webBean.findChildRecursive("approvedIJPText");
if(staticbean!=null)
{
 staticbean.setInlineStyle(customCss); //set custom css style
}

Calling PL/SQL Procedures From OAF Page

To invoke a stored procedure from within an entity object or an application module, you need to:
1. Create a JDBC CallableStatement with the PL/SQL block containing the stored procedure invocation
2. Bind any variables.
3. Execute the statement.
4. Optionally retrieve the values of any OUT parameters.
5. Close the statement.

import java.sql.CallableStatement;
import java.sql.SQLException;
import java.sql.Types;
import oracle.apps.fnd.framework.server.OADBTransactionImpl;
String outParamValue = null;

OADBTransaction txn = getDBTransaction();
CallableStatement cs = txn.createCallableStatement("begin xx_pkg.xx_procedure(:1, :2); end;");
{
((OracleCallableStatement)cs.registerOutParameter(2, Types.VARCHAR, 0, 2000);
cs.setString(1, "gyan");
outParamValue = cs.getString(1);
cs.execute();
cs.close();
}
catch (SQLException sqle)
{
cs.close();

}