oadbtransactionimpl in oaf

oadbtransactionimpl in oaf

 

OADBTransaction in oaf is used perform data base operations in the OAF page controller. If we want to execute sql statements in the OAF page controller then we should create the handle of OADBTransaction and with this handle we can able to execute the sql statement in the OAF page. In the similar way , if we want to execute the PLSQL block or database procedures or function in the OAF page then we still need to use this OADBTransaction object of OA framework.

 

TO used OADBTransaction we first need to import its class in the oaf page controller to used in the   controller class file.

 

here below is the import class of OADBTransaction.        

 

import oracle.apps.fnd.framework.server.OADBTransaction; 

 

 

Example of using oadbtransactionimpl in oaf

 

 

Number rptHdrId;

rptHdrId = new Number(paramOAPageContext.getDecryptedParameter("ReportHeaderId"));

if (rptHdrId!=null)

Connection conn = paramOAPageContext.getApplicationModule(paramOAWebBean).getOADBTransaction().getJdbcConnection();

String Query = "SELECT NVL(expense_status_code,'NEW') status FROM ap_expense_report_headers_all WHERE report_header_id=TO_NUMBER(:1)";

 

PreparedStatement stmt = conn.prepareStatement(Query);

String RptHdrId = ""+rptHdrId;

stmt.setString(1,RptHdrId);

for(ResultSet resultset = stmt.executeQuery(); resultset.next();)

                                   {

  result = resultset.getString("status");

paramOAPageContext.writeDiagnostics(this, "comparison"+comparison,2);

 if("REJECTED".equals(result))

                                                {

Here below I will write the code to perform some action if we found expense report status ‘Rejected’

                                   }

}

 

oadbtransactionimpl in oaf