DBA Data[Home] [Help]

APPS.AP_WEB_EXPENSE_CUST_WF SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 741

      /*Call AMEs UpdateApprovalStatus api to let AME know the expense report
      is Approved by previous approver. */

      l_recApprover.person_id := l_approver_id;
Line: 748

      l_debug_info := 'Call AMEs updateApprovalAtatus api';
Line: 750

      AME_API.updateApprovalStatus2(applicationIdIn    => AP_WEB_DB_UTIL_PKG.GetApplicationID,
                               	    transactionIdIn    => p_item_key,
                                    approvalStatusIn   => AME_UTIL.approvedStatus,
                                    approverPersonIdIn => l_approver_id,
                                    approverUserIdIn   => NULL,
                              	    transactionTypeIn  => p_item_type);
Line: 826

   /* Place some custom code here, i.e. update statement */

  null;