2: /* $Header: apwdbvib.pls 120.4.12010000.3 2010/06/22 10:51:19 rveliche ship $ */
3:
4: --------------------------------------------------------------------------------
5: PROCEDURE deleteViolationEntry(
6: p_report_header_id IN AP_EXPENSE_REPORT_HEADERS.report_header_id%TYPE) IS
7: -------------------------------------------------------------------------------
8: l_debug_info VARCHAR2(200);
9:
10: BEGIN
46: END updateViolationsHeaderId;
47:
48: --------------------------------------------------------------------------------
49: PROCEDURE SetVioPolicyShortpaidReportID(
50: p_orig_expense_report_id IN AP_EXPENSE_REPORT_HEADERS.report_header_id%TYPE,
51: p_new_report_header_id IN AP_EXPENSE_REPORT_HEADERS.report_header_id%TYPE)IS
52: -------------------------------------------------------------------------------
53: l_debug_info VARCHAR2(200);
54:
47:
48: --------------------------------------------------------------------------------
49: PROCEDURE SetVioPolicyShortpaidReportID(
50: p_orig_expense_report_id IN AP_EXPENSE_REPORT_HEADERS.report_header_id%TYPE,
51: p_new_report_header_id IN AP_EXPENSE_REPORT_HEADERS.report_header_id%TYPE)IS
52: -------------------------------------------------------------------------------
53: l_debug_info VARCHAR2(200);
54:
55: BEGIN
82: APP_EXCEPTION.RAISE_EXCEPTION;
83: END SetVioPolicyShortpaidReportID;
84: --------------------------------------------------------------------------------
85: PROCEDURE SetVioReceiptShortpaidReportID(
86: p_orig_expense_report_id IN AP_EXPENSE_REPORT_HEADERS.report_header_id%TYPE,
87: p_new_report_header_id IN AP_EXPENSE_REPORT_HEADERS.report_header_id%TYPE)IS
88: -------------------------------------------------------------------------------
89: l_debug_info VARCHAR2(200);
90:
83: END SetVioPolicyShortpaidReportID;
84: --------------------------------------------------------------------------------
85: PROCEDURE SetVioReceiptShortpaidReportID(
86: p_orig_expense_report_id IN AP_EXPENSE_REPORT_HEADERS.report_header_id%TYPE,
87: p_new_report_header_id IN AP_EXPENSE_REPORT_HEADERS.report_header_id%TYPE)IS
88: -------------------------------------------------------------------------------
89: l_debug_info VARCHAR2(200);
90:
91: BEGIN
123: END SetVioReceiptShortpaidReportID;
124: --------------------------------------------------------------------------------
125:
126: PROCEDURE SetViolationBothpaidReportID(
127: p_orig_expense_report_id IN AP_EXPENSE_REPORT_HEADERS.report_header_id%TYPE,
128: p_new_report_header_id IN AP_EXPENSE_REPORT_HEADERS.report_header_id%TYPE)IS
129: -------------------------------------------------------------------------------
130: l_debug_info VARCHAR2(200);
131:
124: --------------------------------------------------------------------------------
125:
126: PROCEDURE SetViolationBothpaidReportID(
127: p_orig_expense_report_id IN AP_EXPENSE_REPORT_HEADERS.report_header_id%TYPE,
128: p_new_report_header_id IN AP_EXPENSE_REPORT_HEADERS.report_header_id%TYPE)IS
129: -------------------------------------------------------------------------------
130: l_debug_info VARCHAR2(200);
131:
132: BEGIN
149: END SetViolationBothpaidReportID;
150: --------------------------------------------------------------------------------
151:
152: PROCEDURE deleteDupViolationEntry(
153: p_report_header_id IN AP_EXPENSE_REPORT_HEADERS.report_header_id%TYPE) IS
154: --------------------------------------------------------------------------------
155:
156: l_report_prefix VARCHAR2(10);
157: l_report_header_id VARCHAR2(30);