1 PACKAGE AP_INVOICES_UTILITY_PKG AUTHID CURRENT_USER AS
2 /* $Header: apinvuts.pls 120.23 2012/01/06 12:36:33 sbonala ship $ */
3
4 PROCEDURE CHECK_UNIQUE (
5 X_ROWID VARCHAR2,
6 X_INVOICE_NUM VARCHAR2,
7 X_VENDOR_ID NUMBER,
8 X_ORG_ID NUMBER, -- Bug 5407785
9 X_PARTY_SITE_ID NUMBER, /*Bug9105666*/
10 X_VENDOR_SITE_ID NUMBER, /*Bug9105666*/
11 X_calling_sequence VARCHAR2);
12
13 PROCEDURE CHECK_UNIQUE_VOUCHER_NUM(
14 X_ROWID VARCHAR2,
15 X_VOUCHER_NUM VARCHAR2,
16 X_calling_sequence VARCHAR2);
17
18 FUNCTION get_prepay_number(l_prepay_dist_id IN NUMBER) RETURN VARCHAR2;
19
20 FUNCTION get_prepay_dist_number(l_prepay_dist_id IN NUMBER) RETURN VARCHAR2;
21
22 FUNCTION get_distribution_total(l_invoice_id IN NUMBER) RETURN NUMBER;
23
24 FUNCTION get_posting_status(l_invoice_id IN NUMBER) RETURN VARCHAR2;
25
26 FUNCTION get_approval_status(
27 l_invoice_id IN NUMBER,
28 l_invoice_amount IN NUMBER,
29 l_payment_status_flag IN VARCHAR2,
30 l_invoice_type_lookup_code IN VARCHAR2) return VARCHAR2;
31
32 FUNCTION get_po_number(l_invoice_id IN NUMBER) RETURN VARCHAR2;
33
34 FUNCTION get_release_number(l_invoice_id IN NUMBER) RETURN VARCHAR2;
35
36 FUNCTION get_receipt_number(l_invoice_id IN NUMBER) RETURN VARCHAR2;
37
38 FUNCTION get_po_number_list(l_invoice_id IN NUMBER) RETURN VARCHAR2;
39
40 FUNCTION get_amount_withheld(l_invoice_id IN NUMBER) RETURN NUMBER;
41
42 FUNCTION get_prepaid_amount(l_invoice_id IN NUMBER) RETURN NUMBER;
43
44 FUNCTION get_notes_count(l_invoice_id IN NUMBER) RETURN NUMBER;
45
46 FUNCTION get_holds_count(l_invoice_id IN NUMBER) RETURN NUMBER;
47
48 FUNCTION get_sched_holds_count(l_invoice_id IN NUMBER) RETURN NUMBER; -- Bug 5334577
49
50 FUNCTION get_amount_hold_flag(l_invoice_id IN NUMBER) RETURN VARCHAR2;
51
52 FUNCTION get_vendor_hold_flag(l_invoice_id IN NUMBER) RETURN VARCHAR2;
53
54 FUNCTION get_total_prepays(
55 l_vendor_id IN NUMBER,
56 l_org_id IN NUMBER) RETURN NUMBER;
57
58 FUNCTION get_available_prepays(
59 l_vendor_id IN NUMBER,
60 l_org_id IN NUMBER) RETURN NUMBER;
61
62 FUNCTION get_encumbered_flag(l_invoice_id IN NUMBER) RETURN VARCHAR2;
63
64 FUNCTION get_similar_drcr_memo(
65 P_vendor_id IN number,
66 P_vendor_site_id IN number,
67 P_invoice_amount IN number,
68 P_invoice_type_lookup_code IN varchar2,
69 P_invoice_currency_code IN varchar2,
70 P_calling_sequence IN varchar2) RETURN varchar2;
71
72 FUNCTION eft_bank_details_exist (
73 P_vendor_site_id IN number,
74 P_calling_sequence IN varchar2) RETURN boolean;
75
76 FUNCTION eft_bank_curr_details_exist (
77 P_vendor_site_id IN number,
78 P_currency_code IN varchar2,
79 P_calling_sequence IN varchar2) RETURN boolean;
80
81 FUNCTION selected_for_payment_flag (P_invoice_id IN number) RETURN varchar2;
82
83 FUNCTION get_unposted_void_payment (P_invoice_id IN number) RETURN varchar2;
84
85 FUNCTION get_discount_pay_dists_flag (P_invoice_id IN number) RETURN varchar2;
86
87 FUNCTION get_prepayments_applied_flag (P_invoice_id IN number) RETURN varchar2;
88
89 FUNCTION get_payments_exist_flag (P_invoice_id IN number) RETURN varchar2;
90
91 FUNCTION get_prepay_amount_applied (P_invoice_id IN number) RETURN number;
92
93 FUNCTION get_prepay_amount_remaining (P_invoice_id IN number) RETURN number;
94
95 FUNCTION get_prepay_amt_rem_set (P_invoice_id IN number) RETURN number; -- BUG 4413272
96
97 FUNCTION get_prepayment_type (P_invoice_id IN number) RETURN VARCHAR2;
98
99 FUNCTION get_packet_id (P_invoice_id IN number) RETURN number;
100
101 FUNCTION get_payment_status( p_invoice_id IN NUMBER ) RETURN VARCHAR2;
102
103 FUNCTION is_inv_pmt_prepay_posted(
104 P_invoice_id IN NUMBER,
105 P_org_id IN NUMBER,
106 P_discount_taken IN NUMBER,
107 P_prepaid_amount IN NUMBER,
108 P_automatic_offsets_flag IN VARCHAR2,
109 P_discount_dist_method IN VARCHAR2,
110 P_payment_status_flag IN VARCHAR2) RETURN boolean;
111
112 FUNCTION get_pp_amt_applied_on_date (
113 P_invoice_id IN NUMBER,
114 P_prepay_id IN NUMBER,
115 P_application_date IN DATE) RETURN number;
116
117 FUNCTION get_dist_count (p_invoice_id IN NUMBER) RETURN NUMBER;
118
119 FUNCTION get_amt_applied_per_prepay (
120 P_invoice_id IN NUMBER,
121 P_prepay_id IN NUMBER) RETURN number;
122
123 FUNCTION get_explines_count (p_expense_report_id IN NUMBER) RETURN NUMBER;
124
125 FUNCTION get_expense_type (
126 p_source in varchar2,
127 p_invoice_id in number) RETURN varchar2;
128
129 FUNCTION GET_MAX_INV_LINE_NUM(P_invoice_id IN NUMBER) RETURN NUMBER;
130
131 FUNCTION GET_LINE_TOTAL(P_invoice_id IN NUMBER) RETURN NUMBER;
132
133 -- table to hold the lines that can be adjusted for rounding -- bug 6892789
134 TYPE inv_line_num_tab_type IS
135 TABLE OF AP_INVOICE_LINES_ALL.LINE_NUMBER%TYPE
136 INDEX BY BINARY_INTEGER;
137
138 -- function modified to get the lines that can be adjusted -- bug 6892789
139 FUNCTION round_base_amts(
140 X_Invoice_Id IN NUMBER,
141 X_Reporting_Ledger_Id IN NUMBER DEFAULT NULL,
142 X_Rounded_Line_Numbers OUT NOCOPY inv_line_num_tab_type,
143 X_Rounded_Amt OUT NOCOPY NUMBER,
144 X_Debug_Info OUT NOCOPY VARCHAR2,
145 X_Debug_Context OUT NOCOPY VARCHAR2,
146 X_Calling_sequence IN VARCHAR2) RETURN BOOLEAN;
147
148 FUNCTION Is_Inv_Credit_Referenced( P_invoice_id IN NUMBER ) RETURN BOOLEAN;
149
150 FUNCTION Inv_With_PQ_Corrections(
151 P_Invoice_Id IN NUMBER,
152 P_Calling_sequence IN VARCHAR2) RETURN BOOLEAN;
153
154 FUNCTION Inv_With_Prepayments(
155 P_Invoice_Id IN NUMBER,
156 P_Calling_sequence IN VARCHAR2) RETURN BOOLEAN;
157
158 FUNCTION Invoice_Includes_Awt(
159 P_Invoice_Id IN NUMBER,
160 P_Calling_sequence IN VARCHAR2) RETURN BOOLEAN;
161
162 FUNCTION Inv_Matched_Finally_Closed_Po(
163 P_Invoice_Id IN NUMBER,
164 P_Calling_sequence IN VARCHAR2) RETURN BOOLEAN;
165
166 --Invoice Lines: Distributions
167 FUNCTION get_max_dist_line_num (P_invoice_id IN number,
168 P_invoice_line_number IN number) RETURN NUMBER;
169
170 --ETAX: Invwkb
171 FUNCTION get_invoice_num (P_Invoice_Id IN Number) RETURN VARCHAR2;
172
173 FUNCTION Get_Retained_Total
174 (P_Invoice_Id IN NUMBER, P_Org_Id IN NUMBER) RETURN NUMBER;
175
176 FUNCTION Get_Item_Total
177 (P_Invoice_Id IN NUMBER, P_Org_Id IN NUMBER) RETURN NUMBER;
178
179 FUNCTION Get_Freight_Total
180 (P_Invoice_Id IN NUMBER, P_Org_Id IN NUMBER) RETURN NUMBER;
181
182 FUNCTION Get_Misc_Total
183 (P_Invoice_Id IN NUMBER, P_Org_Id IN NUMBER) RETURN NUMBER;
184
185 FUNCTION Get_Prepay_App_Total
186 (P_Invoice_Id IN NUMBER, P_Org_Id IN NUMBER) RETURN NUMBER;
187
188 FUNCTION get_invoice_status(
189 p_invoice_id IN NUMBER,
190 p_invoice_amount IN NUMBER,
191 p_payment_status_flag IN VARCHAR2,
192 p_invoice_type_lookup_code IN VARCHAR2) return VARCHAR2;
193
194 PROCEDURE get_bank_details(
195 p_invoice_currency_code IN VARCHAR2,
196 p_party_id IN NUMBER,
197 p_party_site_id IN NUMBER,
198 p_supplier_site_id IN NUMBER,
199 p_org_id IN NUMBER,
200 x_bank_account_name OUT NOCOPY VARCHAR2,
201 x_bank_account_id OUT NOCOPY VARCHAR2,
202 x_bank_account_number OUT NOCOPY VARCHAR2);
203
204 -- FUNCTION get_interface_po_number added for CLM Bug 9503239
205 FUNCTION get_interface_po_number(p_po_number IN VARCHAR2,
206 p_org_id IN NUMBER) RETURN VARCHAR2;
207
208 /* Bug 10425573 Starts */
209 FUNCTION Update_Invoice_Description ( p_invoice_id IN NUMBER,
210 p_description IN VARCHAR2,
211 p_calling_sequence IN VARCHAR2)
212 RETURN BOOLEAN;
213 /* Bug 10425573 Ends */
214
215 --Introduced below 2 procedures for GTAS Project
216 --Bug#13464635
217
218 FUNCTION FV_ENABLED RETURN BOOLEAN;
219 PROCEDURE CHECK_GDF_VALID(P_id IN NUMBER,
220 P_calling_mode IN VARCHAR2,
221 P_table_name IN VARCHAR2,
222 P_hold_reject_exists_flag OUT NOCOPY VARCHAR2,
223 P_return_code OUT NOCOPY VARCHAR2,
224 P_calling_sequence IN VARCHAR2);
225 --End Bug#13464635
226
227 END AP_INVOICES_UTILITY_PKG;