1 PACKAGE AP_APPROVAL_MATCHED_PKG AUTHID CURRENT_USER AS
2 /* $Header: aprmtchs.pls 120.5.12010000.5 2010/03/22 13:48:35 sjetti ship $ */
3
4
5 /*===========================================================================
6 | Public Procedure Specifications
7 *==========================================================================*/
8 g_debug_mode VARCHAR2(1):= 'N';
9
10 /*===========================================================================
11 | Public Procedure Specifications
12 *==========================================================================*/
13
14 PROCEDURE Exec_Matched_Variance_Checks(
15 p_invoice_id IN NUMBER,
16 p_inv_line_number IN NUMBER,
17 p_base_currency_code IN VARCHAR2,
18 p_inv_currency_code IN VARCHAR2,
19 p_sys_xrate_gain_ccid IN NUMBER,
20 p_sys_xrate_loss_ccid IN NUMBER,
21 p_system_user IN NUMBER,
22 p_holds IN OUT NOCOPY AP_APPROVAL_PKG.HOLDSARRAY,
23 p_hold_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
24 p_release_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
25 p_calling_sequence IN VARCHAR2);
26
27 PROCEDURE Exec_Qty_Variance_Check(
28 p_invoice_id IN NUMBER,
29 p_base_currency_code IN VARCHAR2,
30 p_inv_currency_code IN VARCHAR2,
31 p_system_user IN NUMBER,
32 p_calling_sequence IN VARCHAR2);
33
34 /* New Procedure for Amount Vriance Check for Amount Based Matching */
35 PROCEDURE Exec_Amt_Variance_Check(
36 p_invoice_id IN NUMBER,
37 p_base_currency_code IN VARCHAR2,
38 p_inv_currency_code IN VARCHAR2,
39 p_system_user IN NUMBER,
40 p_calling_sequence IN VARCHAR2);
41
42 PROCEDURE Exec_PO_Final_Close(
43 p_invoice_id IN NUMBER,
44 p_system_user IN NUMBER,
45 p_conc_flag IN VARCHAR2,
46 p_holds IN OUT NOCOPY AP_APPROVAL_PKG.HOLDSARRAY,
47 p_holds_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
48 p_release_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
49 p_calling_sequence IN VARCHAR2);
50
51 PROCEDURE Execute_Matched_Checks(
52 p_invoice_id IN NUMBER,
53 p_base_currency_code IN VARCHAR2,
54 p_price_tol IN NUMBER,
55 p_qty_tol IN NUMBER,
56 p_qty_rec_tol IN NUMBER,
57 p_max_qty_ord_tol IN NUMBER,
58 p_max_qty_rec_tol IN NUMBER,
59 p_amt_tol IN NUMBER,
60 p_amt_rec_tol IN NUMBER,
61 p_max_amt_ord_tol IN NUMBER,
62 p_max_amt_rec_tol IN NUMBER,
63 p_goods_ship_amt_tolerance IN NUMBER,
64 p_goods_rate_amt_tolerance IN NUMBER,
65 p_goods_total_amt_tolerance IN NUMBER,
66 p_services_ship_amt_tolerance IN NUMBER,
67 p_services_rate_amt_tolerance IN NUMBER,
68 p_services_total_amt_tolerance IN NUMBER,
69 p_system_user IN NUMBER,
70 p_conc_flag IN VARCHAR2,
71 p_holds IN OUT NOCOPY AP_APPROVAL_PKG.HOLDSARRAY,
72 p_holds_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
73 p_release_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
74 p_calling_sequence IN VARCHAR2);
75
76 -- 7299826 EnC Project
77 PROCEDURE exec_pay_when_paid_check(p_invoice_id IN NUMBER,
78 p_system_user IN NUMBER,
79 p_holds IN OUT NOCOPY AP_APPROVAL_PKG.holdsarray,
80 p_holds_count IN OUT NOCOPY AP_APPROVAL_PKG.countarray,
81 p_release_count IN OUT NOCOPY AP_APPROVAL_PKG.countarray,
82 p_calling_sequence IN VARCHAR2);
83
84 -- 7299826 EnC Project
85 PROCEDURE exec_po_deliverable_check(p_invoice_id IN NUMBER,
86 p_system_user IN NUMBER,
87 p_holds IN OUT NOCOPY AP_APPROVAL_PKG.holdsarray,
88 p_holds_count IN OUT NOCOPY AP_APPROVAL_PKG.countarray,
89 p_release_count IN OUT NOCOPY AP_APPROVAL_PKG.countarray,
90 p_calling_sequence IN VARCHAR2);
91
92 --for CLM project - bug 9494400
93 PROCEDURE exec_partial_funds_check (p_invoice_id IN NUMBER,
94 p_system_user IN NUMBER,
95 p_holds IN OUT NOCOPY AP_APPROVAL_PKG.holdsarray,
96 p_holds_count IN OUT NOCOPY AP_APPROVAL_PKG.countarray,
97 p_release_count IN OUT NOCOPY AP_APPROVAL_PKG.countarray,
98 p_calling_sequence IN VARCHAR2) ;
99
100 END AP_APPROVAL_MATCHED_PKG;