APPS.AP_WEB_AME_PKG dependencies on AP_WEB_AME_PKG

Line 1: PACKAGE BODY AP_WEB_AME_PKG AS

1: PACKAGE BODY AP_WEB_AME_PKG AS
2: /* $Header: apwxameb.pls 120.13.12020000.3 2012/08/14 09:49:56 rveliche ship $ */
3:
4: -- Constants
5: C_HEADER VARCHAR2(50) := 'header';

Line 221: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_AME_PKG', 'start getTotalPerCostCenter');

217: l_line_item_total NUMBER := 0;
218:
219: BEGIN
220:
221: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_AME_PKG', 'start getTotalPerCostCenter');
222:
223: -- If project is enabled, then get the total reimbursable amount for the same project number. Otherwise, if line-level-accounting is enabled, get the total reimbursable amount for the same cost center
224:
225: SELECT SUM(AMOUNT)

Line 237: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_AME_PKG', 'end getTotalPerCostCenter');

233: AND DISTRIBUTION_LINE_NUMBER = p_line_number
234: )
235: AND itemization_parent_id <> -1;
236:
237: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_AME_PKG', 'end getTotalPerCostCenter');
238: return l_line_item_total;
239:
240: EXCEPTION
241: WHEN NO_DATA_FOUND THEN

Line 398: l_violationTotal := AP_WEB_AME_PKG.getViolationTotal(p_report_header_id);

394: l_reportTotal NUMBER;
395:
396: BEGIN
397:
398: l_violationTotal := AP_WEB_AME_PKG.getViolationTotal(p_report_header_id);
399:
400: -----------------------------------------------------
401: l_debug_info := 'If violation total less than 0 then return 0 percent violated.';
402: -----------------------------------------------------

Line 512: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_AME_PKG', 'Start GetAwardNumber');

508: -------------------------------------------------------------------
509: l_award_number GMS_AWARDS.AWARD_NUMBER%type;
510: BEGIN
511:
512: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_AME_PKG', 'Start GetAwardNumber');
513:
514: select award_number
515: into l_award_number
516: from GMS_AWARDS_ALL

Line 543: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_AME_PKG', 'Start GetItemAmount');

539: p_amount OUT NOCOPY NUMBER) IS
540: -------------------------------------------------------------------------
541: BEGIN
542:
543: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_AME_PKG', 'Start GetItemAmount');
544:
545: if (p_item_class = C_HEADER) then
546: select total
547: into p_amount

Line 577: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_AME_PKG', 'End GetItemAmount');

573: where report_header_id = p_report_header_id
574: and cost_center = p_item_id;
575: end if;
576:
577: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_AME_PKG', 'End GetItemAmount');
578:
579: EXCEPTION
580: WHEN NO_DATA_FOUND THEN
581: null;

Line 605: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_AME_PKG', 'Start InsertToAMENotifGT');

601: p_project_name IN VARCHAR2,
602: p_award_number IN VARCHAR2) as
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,

Line 630: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_AME_PKG', 'End InsertToAMENotifGT');

626: p_project_number,
627: p_project_name,
628: p_award_number
629: );
630: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_AME_PKG', 'End InsertToAMENotifGT');
631:
632: EXCEPTION
633: WHEN OTHERS THEN
634: AP_WEB_DB_UTIL_PKG.RaiseException( 'InsertToAMENotifGT' );

Line 678: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_AME_PKG', 'Start InitOieAmeNotifGT');

674: l_amount number;
675:
676: BEGIN
677:
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;

Line 812: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_AME_PKG', 'end InitOieAmeNotifGT');

808: l_debug_info := 'Before call to InitOieAmeApproverAmtGT';
809: -----------------------------------------------------------
810: InitOieAmeApproverAmtGT(p_report_header_id);
811:
812: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_AME_PKG', 'end InitOieAmeNotifGT');
813:
814: EXCEPTION
815: WHEN OTHERS THEN
816: IF (SQLCODE <> -20001) THEN

Line 854: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_AME_PKG', 'start InitOieAmeApproverAmtGT');

850: l_approver_amount number;
851:
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

Line 917: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_AME_PKG', 'end InitOieAmeApproverAmtGT');

913: i.report_line_id,
914: nvl(l_approver_amount,0));
915: end loop;
916:
917: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_AME_PKG', 'end InitOieAmeApproverAmtGT');
918:
919: EXCEPTION
920: WHEN OTHERS THEN
921: IF (SQLCODE <> -20001) THEN

Line 930: END AP_WEB_AME_PKG;

926: END IF;
927: APP_EXCEPTION.RAISE_EXCEPTION;
928: END InitOieAmeApproverAmtGT;
929:
930: END AP_WEB_AME_PKG;