1 PACKAGE PA_CMT_UTILS AS
2 /* $Header: PAXCMTUS.pls 120.9 2007/10/19 11:23:30 rthumma ship $ */
3
4 /* Added for bug#6408874 */
5 g_po_distr_id number ;
6 g_rcpt_qty number ;
7 g_qty_ordered number;
8 g_qty_cancel number;
9 g_qty_billed number;
10 g_module varchar2(255);
11 g_pa_quantity NUMBER;
12 g_inv_source VARCHAR2(255);
13 g_line_type_lookup_code VARCHAR2(255);
14 /* Added for bug#6408874 */
15
16 function get_rcpt_qty(p_po_dist in number,
17 p_qty_ordered in number,
18 p_qty_cancel in number,
19 p_qty_billed in number,
20 p_module in varchar2,
21 --Pa.M Added below parameters
22 p_po_line_id in number,
23 p_project_id in number,
24 p_task_id in number,
25 p_ccid in number,
26 p_pa_quantity in number, -- Bug 3556021
27 p_inv_source IN VARCHAR2, -- Bug 3556021
28 p_line_type_lookup_code IN VARCHAR2, -- Bug 3556021
29 p_matching_basis IN VARCHAR2 DEFAULT NULL, -- Bug 3642604
30 p_nrtax_amt IN NUMBER DEFAULT NULL, -- Bug 3642604
31 P_CASH_BASIS_ACCTG in varchar2 DEFAULT 'N', /* Bug 4905552 */
32 p_accrue_on_receipt_flag IN varchar2 default NULL /* Bug 5014034 */
33 ) return number;
34
35 function get_inv_cmt(p_po_dist in number,
36 p_denom_amt_flag in varchar2,
37 p_pa_add_flag in varchar2,
38 p_var_amt in number,
39 p_ccid in number,
40 p_module in varchar2,
41 p_invoice_id in number DEFAULT NULL , /* Added for Bug 3394153 */
42 p_dist_line_num in number DEFAULT NULL , /* Added for Bug 3394153 */
43 p_inv_dist_id in number DEFAULT NULL, /* Added for Bug 3394153 */
44 P_CASH_BASIS_ACCTG in varchar2 DEFAULT 'N' /* Bug 4905552 */
45 ) return number;
46
47 /* Bug:4914006 R12.PJ:XB3:QA:APL:PREPAYMENT COMMITMENT AMOUNT NOT REDUCED AFTER */
48 function get_inv_cmt(p_po_dist in number,
49 p_denom_amt_flag in varchar2,
50 p_pa_add_flag in varchar2,
51 p_var_amt in number,
52 p_ccid in number,
53 p_module in varchar2,
54 p_invoice_id in number DEFAULT NULL, /* Added for Bug 3394153 */
55 p_dist_line_num in number DEFAULT NULL, /* Added for Bug 3394153 */
56 p_inv_dist_id in number DEFAULT NULL,
57 p_accrue_on_rcpt_flag in varchar2,
58 p_po_line_id in number,
59 p_forqty in varchar2,
60 p_cost in number,
61 p_project_id in number,
62 p_dist_type in varchar2,
63 p_pa_quantity in number, -- Bug 3556021
64 p_inv_source in varchar2, -- Bug 3556021
65 P_CASH_BASIS_ACCTG in varchar2 DEFAULT 'N', /* Bug 4905552 */
66 p_inv_type in varchar2,
67 p_hist_flag in varchar2,
68 p_prepay_amt_remaining in number
69 ) return number;
70
71
72 TYPE CommCostRecord is RECORD (
73 Project_Id NUmBER,
74 Task_Id NUMBER,
75 Po_Line_Id NUMBER,
76 CommCosts NUMBER);
77
78 TYPE CommCostTabTyp is TABLE of CommCostRecord INDEX BY BINARY_INTEGER;
79 G_CommCostTab CommCostTabTyp;
80
81 --R12 changes for AP LINES uptake
82 function get_inv_var(p_inv_dist in number,
83 p_denom_amt_flag in varchar2,
84 p_amt_var in number,
85 p_qty_var in number
86 ) return number; -- Bug 3556021
87
88 --G_CASH_BASIS_ACCTG varchar2(1); -- Global variable to capture if cash basis accounting is impletented.
89
90
91 --bug:4610727 determine outstanding qty on ap distribution.
92
93 function get_apdist_qty( p_inv_dist_id in NUMBER,
94 p_invoice_id in NUMBER,
95 p_cost in NUMBER,
96 p_quantity in NUMBER,
97 p_calling_module in varchar2,
98 p_denom_amt_flag in varchar2,
99 P_CASH_BASIS_ACCTG in varchar2 DEFAULT 'N' /* Bug 4905552 */
100 ) return number ;
101
102 --bug:4610727 determine outstanding amount on ap distribution.
103
104 function get_apdist_amt( p_inv_dist_id in NUMBER,
105 p_invoice_id in NUMBER,
106 p_cost in NUMBER,
107 p_denom_amt_flag in varchar2,
108 p_calling_module in varchar2,
109 P_CASH_BASIS_ACCTG in varchar2 DEFAULT 'N' /* Bug 4905552 */
110 ) return number ;
111
112 /*Added for Bug 5946201*/
113 Function is_eIB_item (p_po_dist_id IN number)
114 return varchar2;
115
116 END PA_CMT_UTILS;