The following lines contain the word 'select', 'insert', 'update' or 'delete':
/*Call AMEs UpdateApprovalStatus api to let AME know the expense report
is Approved by previous approver. */
l_recApprover.person_id := l_approver_id;
l_debug_info := 'Call AMEs updateApprovalAtatus api';
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);
/* Place some custom code here, i.e. update statement */
null;