APPS.AP_WEB_AME_PKG dependencies on OIE_AME_APPROVER_AMT_GT

Line 645: Populates data into OIE_AME_NOTIF_GT and OIE_AME_APPROVER_AMT_GT.

641: APP_EXCEPTION.RAISE_EXCEPTION;
642: END InsertToAMENotifGT;
643:
644: /*
645: Populates data into OIE_AME_NOTIF_GT and OIE_AME_APPROVER_AMT_GT.
646: data in OIE_AME_NOTIF_GT will be used for displaying instructions to
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

Line 649: data in OIE_AME_APPROVER_AMT_GT will be used for displaying Approver

645: Populates data into OIE_AME_NOTIF_GT and OIE_AME_APPROVER_AMT_GT.
646: data in OIE_AME_NOTIF_GT will be used for displaying instructions to
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.

Line 657: Data is populated into OIE_AME_APPROVER_AMT_GT by the call InitOieAmeApproverAmtGT

653: approval list.
654: p_display_instr -> is set to No if approver is on approval list due to
655: header rules.
656: Inserts only the data that is related to the p_approver_id.
657: Data is populated into OIE_AME_APPROVER_AMT_GT by the call InitOieAmeApproverAmtGT
658: */
659: -------------------------------------------------------------------------
660: PROCEDURE InitOieAmeNotifGT( p_report_header_id IN NUMBER,
661: p_approver_id IN NUMBER,

Line 832: populates the global temporary table OIE_AME_APPROVER_AMT_GT

828: APP_EXCEPTION.RAISE_EXCEPTION;
829: END InitOieAmeNotifGT;
830:
831: /*
832: populates the global temporary table OIE_AME_APPROVER_AMT_GT
833: with approver amount for each line.
834: If the approver is on the approver list due to line item rules
835: then approver amount is same as line amount.
836: otherwise the approver amount is calculated as sum of amount

Line 862: DELETE FROM OIE_AME_APPROVER_AMT_GT;

858: BEGIN
859:
860: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_AME_PKG', 'start InitOieAmeApproverAmtGT');
861:
862: DELETE FROM OIE_AME_APPROVER_AMT_GT;
863:
864: for i in c1(p_report_header_id) loop
865: begin
866: -- gt.item_id -> will have distribution_line_number if the gt.item_class is C_LINE_ITEM

Line 937: insert into OIE_AME_APPROVER_AMT_GT(

933:
934: end if; -- (l_line_approver = 'N')
935:
936:
937: insert into OIE_AME_APPROVER_AMT_GT(
938: report_header_id,
939: report_line_id,
940: approver_amount)
941: values (