2: /* $Header: apwdbvib.pls 120.4 2006/03/16 01:40:51 skoukunt noship $ */
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