2: /* $Header: apwdbvis.pls 120.2 2006/02/24 07:34:21 sbalaji noship $ */
3:
4: -------------------------------------------------------------------
5: PROCEDURE deleteViolationEntry(
6: p_report_header_id IN AP_EXPENSE_REPORT_HEADERS.report_header_id%TYPE);
7:
8: -------------------------------------------------------------------
9: FUNCTION updateViolationsHeaderId(
10: p_ReportHeaderID IN AP_EXPENSE_REPORT_LINES.report_header_id%TYPE,
12: RETURN BOOLEAN;
13:
14: --------------------------------------------------------------------------------
15: PROCEDURE SetVioPolicyShortpaidReportID(
16: p_orig_expense_report_id IN AP_EXPENSE_REPORT_HEADERS.report_header_id%TYPE,
17: p_new_report_header_id IN AP_EXPENSE_REPORT_HEADERS.report_header_id%TYPE);
18: -------------------------------------------------------------------------------
19: PROCEDURE SetVioReceiptShortpaidReportID(
20: p_orig_expense_report_id IN AP_EXPENSE_REPORT_HEADERS.report_header_id%TYPE,
13:
14: --------------------------------------------------------------------------------
15: PROCEDURE SetVioPolicyShortpaidReportID(
16: p_orig_expense_report_id IN AP_EXPENSE_REPORT_HEADERS.report_header_id%TYPE,
17: p_new_report_header_id IN AP_EXPENSE_REPORT_HEADERS.report_header_id%TYPE);
18: -------------------------------------------------------------------------------
19: PROCEDURE SetVioReceiptShortpaidReportID(
20: p_orig_expense_report_id IN AP_EXPENSE_REPORT_HEADERS.report_header_id%TYPE,
21: p_new_report_header_id IN AP_EXPENSE_REPORT_HEADERS.report_header_id%TYPE);
16: p_orig_expense_report_id IN AP_EXPENSE_REPORT_HEADERS.report_header_id%TYPE,
17: p_new_report_header_id IN AP_EXPENSE_REPORT_HEADERS.report_header_id%TYPE);
18: -------------------------------------------------------------------------------
19: PROCEDURE SetVioReceiptShortpaidReportID(
20: p_orig_expense_report_id IN AP_EXPENSE_REPORT_HEADERS.report_header_id%TYPE,
21: p_new_report_header_id IN AP_EXPENSE_REPORT_HEADERS.report_header_id%TYPE);
22: -------------------------------------------------------------------------------
23: PROCEDURE SetViolationBothpaidReportID(
24: p_orig_expense_report_id IN AP_EXPENSE_REPORT_HEADERS.report_header_id%TYPE,
17: p_new_report_header_id IN AP_EXPENSE_REPORT_HEADERS.report_header_id%TYPE);
18: -------------------------------------------------------------------------------
19: PROCEDURE SetVioReceiptShortpaidReportID(
20: p_orig_expense_report_id IN AP_EXPENSE_REPORT_HEADERS.report_header_id%TYPE,
21: p_new_report_header_id IN AP_EXPENSE_REPORT_HEADERS.report_header_id%TYPE);
22: -------------------------------------------------------------------------------
23: PROCEDURE SetViolationBothpaidReportID(
24: p_orig_expense_report_id IN AP_EXPENSE_REPORT_HEADERS.report_header_id%TYPE,
25: p_new_report_header_id IN AP_EXPENSE_REPORT_HEADERS.report_header_id%TYPE);
20: p_orig_expense_report_id IN AP_EXPENSE_REPORT_HEADERS.report_header_id%TYPE,
21: p_new_report_header_id IN AP_EXPENSE_REPORT_HEADERS.report_header_id%TYPE);
22: -------------------------------------------------------------------------------
23: PROCEDURE SetViolationBothpaidReportID(
24: p_orig_expense_report_id IN AP_EXPENSE_REPORT_HEADERS.report_header_id%TYPE,
25: p_new_report_header_id IN AP_EXPENSE_REPORT_HEADERS.report_header_id%TYPE);
26: -------------------------------------------------------------------------------
27:
28:
21: p_new_report_header_id IN AP_EXPENSE_REPORT_HEADERS.report_header_id%TYPE);
22: -------------------------------------------------------------------------------
23: PROCEDURE SetViolationBothpaidReportID(
24: p_orig_expense_report_id IN AP_EXPENSE_REPORT_HEADERS.report_header_id%TYPE,
25: p_new_report_header_id IN AP_EXPENSE_REPORT_HEADERS.report_header_id%TYPE);
26: -------------------------------------------------------------------------------
27:
28:
29: END AP_WEB_DB_VIOLATIONS_PKG;