[Home] [Help]
641: the approver in the approval notification.
642: like, You are responsible for approving expenses that total 250.00 USD for cost center 420.
643: data in OIE_AME_APPROVER_AMT_GT will be used for displaying Approver
644: Amount in the approval notification.
645: Calls ame_api2.getallapprovers1 to get the list of approver in the approval
646: list, which would also have info on why the approver is placed on the
647: approval list.
648: p_display_instr -> is set to No if approver is on approval list due to
649: header rules.
681:
682: DELETE FROM OIE_AME_NOTIF_GT;
683:
684: -----------------------------------------------------------
685: l_debug_info := 'Before call to ame_api2.getallapprovers1';
686: -----------------------------------------------------------
687: ame_api2.getallapprovers1(
688: applicationIdIn => AP_WEB_DB_UTIL_PKG.GetApplicationID,
689: transactionTypeIn => 'APEXP',
683:
684: -----------------------------------------------------------
685: l_debug_info := 'Before call to ame_api2.getallapprovers1';
686: -----------------------------------------------------------
687: ame_api2.getallapprovers1(
688: applicationIdIn => AP_WEB_DB_UTIL_PKG.GetApplicationID,
689: transactionTypeIn => 'APEXP',
690: transactionIdIn => to_char(p_report_header_id),
691: approvalProcessCompleteYNOut => l_approvalProcessCompleteYNOut,
695: itemIdsOut => l_itemIdsOut,
696: itemSourcesOut => l_itemSourcesOut);
697:
698: -----------------------------------------------------------
699: l_debug_info := 'After call to ame_api2.getallapprovers1';
700: -----------------------------------------------------------
701:
702: FOR i IN 1 .. l_approversOut.count LOOP
703: