2: /* $Header: apwdbvis.pls 120.2.12010000.2 2010/04/16 11:57:19 dsadipir ship $ */
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: PROCEDURE deleteDupViolationEntry(
28: p_report_header_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: PROCEDURE deleteDupViolationEntry(
28: p_report_header_id IN AP_EXPENSE_REPORT_HEADERS.report_header_id%TYPE);
29: -------------------------------------------------------------------------------
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: PROCEDURE deleteDupViolationEntry(
28: p_report_header_id IN AP_EXPENSE_REPORT_HEADERS.report_header_id%TYPE);
29: -------------------------------------------------------------------------------
30:
31:
32: END AP_WEB_DB_VIOLATIONS_PKG;