[Home] [Help]
647: the approver in the approval notification.
648: like, You are responsible for approving expenses that total 250.00 USD for cost center 420.
649: data in OIE_AME_APPROVER_AMT_GT will be used for displaying Approver
650: Amount in the approval notification.
651: Calls ame_api2.getallapprovers1 to get the list of approver in the approval
652: list, which would also have info on why the approver is placed on the
653: approval list.
654: p_display_instr -> is set to No if approver is on approval list due to
655: header rules.
687:
688: DELETE FROM OIE_AME_NOTIF_GT;
689:
690: -----------------------------------------------------------
691: l_debug_info := 'Before call to ame_api2.getallapprovers1';
692: -----------------------------------------------------------
693: ame_api2.getallapprovers1(
694: applicationIdIn => AP_WEB_DB_UTIL_PKG.GetApplicationID,
695: transactionTypeIn => 'APEXP',
689:
690: -----------------------------------------------------------
691: l_debug_info := 'Before call to ame_api2.getallapprovers1';
692: -----------------------------------------------------------
693: ame_api2.getallapprovers1(
694: applicationIdIn => AP_WEB_DB_UTIL_PKG.GetApplicationID,
695: transactionTypeIn => 'APEXP',
696: transactionIdIn => to_char(p_report_header_id),
697: approvalProcessCompleteYNOut => l_approvalProcessCompleteYNOut,
701: itemIdsOut => l_itemIdsOut,
702: itemSourcesOut => l_itemSourcesOut);
703:
704: -----------------------------------------------------------
705: l_debug_info := 'After call to ame_api2.getallapprovers1';
706: -----------------------------------------------------------
707:
708: FOR i IN 1 .. l_approversOut.count LOOP
709: