APPS.AP_WEB_AME_PKG dependencies on OIE_AME_NOTIF_GT

Line 590: Inserts data into table OIE_AME_NOTIF_GT

586: END GetItemAmount;
587:
588:
589: /*
590: Inserts data into table OIE_AME_NOTIF_GT
591: */
592: -------------------------------------------------------------------------
593: PROCEDURE InsertToAMENotifGT(
594: p_report_header_id IN NUMBER,

Line 607: insert into OIE_AME_NOTIF_GT(

603: -------------------------------------------------------------------------
604: BEGIN
605: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_AME_PKG', 'Start InsertToAMENotifGT');
606:
607: insert into OIE_AME_NOTIF_GT(
608: report_header_id,
609: orig_system,
610: orig_system_id,
611: item_class,

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 640: data in OIE_AME_NOTIF_GT will be used for displaying instructions to

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
644: Amount in the approval notification.

Line 682: DELETE FROM OIE_AME_NOTIF_GT;

678: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_AME_PKG', 'Start InitOieAmeNotifGT');
679:
680: p_display_instr := 'Y';
681:
682: DELETE FROM OIE_AME_NOTIF_GT;
683:
684: -----------------------------------------------------------
685: l_debug_info := 'Before call to ame_api2.getallapprovers1';
686: -----------------------------------------------------------

Line 834: in oie_ame_notif_gt.

830: otherwise the approver amount is calculated as sum of amount
831: in the distributions for which the approver is on the approver
832: list i.e, project or cost center or award.
833: The information why the approver is on the approver list exist
834: in oie_ame_notif_gt.
835: */
836: PROCEDURE InitOieAmeApproverAmtGT(p_report_header_id IN NUMBER) IS
837:
838: -- 5213228: include only itemization parent lines in the cursor as we

Line 863: from oie_ame_notif_gt gt

859: begin
860: -- gt.item_id -> will have distribution_line_number if the gt.item_class is C_LINE_ITEM
861: select 'Y'
862: into l_line_approver
863: from oie_ame_notif_gt gt
864: where gt.item_class = C_LINE_ITEM
865: and gt.item_id = i.distribution_line_number;
866: -- and gt.item_id = i.report_line_id;
867:

Line 885: oie_ame_notif_gt gt

881: */
882: select sum(xd.amount)
883: into l_approver_amount
884: from ap_exp_report_dists_all xd,
885: oie_ame_notif_gt gt
886: where xd.report_header_id = p_report_header_id
887: and xd.report_line_id = i.report_line_id
888: and ( (xd.cost_center = gt.item_id
889: and