APPS.AP_WEB_AME_PKG dependencies on OIE_AME_NOTIF_GT

Line 596: Inserts data into table OIE_AME_NOTIF_GT

592: END GetItemAmount;
593:
594:
595: /*
596: Inserts data into table OIE_AME_NOTIF_GT
597: */
598: -------------------------------------------------------------------------
599: PROCEDURE InsertToAMENotifGT(
600: p_report_header_id IN NUMBER,

Line 613: insert into OIE_AME_NOTIF_GT(

609: -------------------------------------------------------------------------
610: BEGIN
611: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_AME_PKG', 'Start InsertToAMENotifGT');
612:
613: insert into OIE_AME_NOTIF_GT(
614: report_header_id,
615: orig_system,
616: orig_system_id,
617: item_class,

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

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

Line 688: DELETE FROM OIE_AME_NOTIF_GT;

684: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_AME_PKG', 'Start InitOieAmeNotifGT');
685:
686: p_display_instr := 'Y';
687:
688: DELETE FROM OIE_AME_NOTIF_GT;
689:
690: -----------------------------------------------------------
691: l_debug_info := 'Before call to ame_api2.getallapprovers1';
692: -----------------------------------------------------------

Line 840: in oie_ame_notif_gt.

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

Line 869: from oie_ame_notif_gt gt

865: begin
866: -- gt.item_id -> will have distribution_line_number if the gt.item_class is C_LINE_ITEM
867: select 'Y'
868: into l_line_approver
869: from oie_ame_notif_gt gt
870: where gt.item_class = C_LINE_ITEM
871: and gt.item_id = i.distribution_line_number;
872: -- and gt.item_id = i.report_line_id;
873:

Line 892: oie_ame_notif_gt gt

888: if i.itemization_parent_id = -1 then
889: select nvl(sum(xd.amount),0)
890: into l_approver_amount
891: from ap_exp_report_dists_all xd,
892: oie_ame_notif_gt gt
893: where xd.report_header_id = p_report_header_id
894: and xd.report_line_id in (
895: select report_line_id
896: from ap_expense_report_lines_all

Line 914: oie_ame_notif_gt gt

910: else
911: select nvl(sum(xd.amount),0)
912: into l_approver_amount
913: from ap_exp_report_dists_all xd,
914: oie_ame_notif_gt gt
915: where xd.report_header_id = p_report_header_id
916: and xd.report_line_id = i.report_line_id
917: and ( (xd.cost_center = gt.item_id
918: and