APPS.AP_WEB_AME_PKG dependencies on OIE_AME_APPROVER_AMT_GT

Line 639: Populates data into OIE_AME_NOTIF_GT and OIE_AME_APPROVER_AMT_GT.

635: APP_EXCEPTION.RAISE_EXCEPTION;
636: END InsertToAMENotifGT;
637:
638: /*
639: Populates data into OIE_AME_NOTIF_GT and OIE_AME_APPROVER_AMT_GT.
640: data in OIE_AME_NOTIF_GT will be used for displaying instructions to
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

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

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

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

647: approval list.
648: p_display_instr -> is set to No if approver is on approval list due to
649: header rules.
650: Inserts only the data that is related to the p_approver_id.
651: Data is populated into OIE_AME_APPROVER_AMT_GT by the call InitOieAmeApproverAmtGT
652: */
653: -------------------------------------------------------------------------
654: PROCEDURE InitOieAmeNotifGT( p_report_header_id IN NUMBER,
655: p_approver_id IN NUMBER,

Line 826: populates the global temporary table OIE_AME_APPROVER_AMT_GT

822: APP_EXCEPTION.RAISE_EXCEPTION;
823: END InitOieAmeNotifGT;
824:
825: /*
826: populates the global temporary table OIE_AME_APPROVER_AMT_GT
827: with approver amount for each line.
828: If the approver is on the approver list due to line item rules
829: then approver amount is same as line amount.
830: otherwise the approver amount is calculated as sum of amount

Line 856: DELETE FROM OIE_AME_APPROVER_AMT_GT;

852: BEGIN
853:
854: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_AME_PKG', 'start InitOieAmeApproverAmtGT');
855:
856: DELETE FROM OIE_AME_APPROVER_AMT_GT;
857:
858: for i in c1(p_report_header_id) loop
859: begin
860: -- gt.item_id -> will have distribution_line_number if the gt.item_class is C_LINE_ITEM

Line 907: insert into OIE_AME_APPROVER_AMT_GT(

903:
904: end if; -- (l_line_approver = 'N')
905:
906:
907: insert into OIE_AME_APPROVER_AMT_GT(
908: report_header_id,
909: report_line_id,
910: approver_amount)
911: values (