1 PACKAGE AP_IMPORT_UTILITIES_PKG AS
2 /* $Header: apiimuts.pls 120.19 2006/11/11 00:08:51 schitlap noship $ */
3
4 FUNCTION Check_control_table(
5 p_source IN VARCHAR2,
6 p_group_id IN VARCHAR2,
7 p_calling_sequence IN VARCHAR2) RETURN BOOLEAN;
8
9 PROCEDURE Print (
10 P_debug IN VARCHAR2,
11 P_string IN VARCHAR2);
12
13 FUNCTION insert_rejections (
14 p_parent_table IN VARCHAR2,
15 p_parent_id IN NUMBER,
16 p_reject_code IN VARCHAR2,
17 p_last_updated_by IN NUMBER,
18 p_last_update_login IN NUMBER,
19 p_calling_sequence IN VARCHAR2,
20 p_notify_vendor_flag IN VARCHAR2 DEFAULT NULL,
21 p_token_name1 IN VARCHAR2 DEFAULT NULL,
22 p_token_value1 IN VARCHAR2 DEFAULT NULL,
23 p_token_name2 IN VARCHAR2 DEFAULT NULL,
24 p_token_value2 IN VARCHAR2 DEFAULT NULL,
25 p_token_name3 IN VARCHAR2 DEFAULT NULL,
26 p_token_value3 IN VARCHAR2 DEFAULT NULL,
27 p_token_name4 IN VARCHAR2 DEFAULT NULL,
28 p_token_value4 IN VARCHAR2 DEFAULT NULL,
29 p_token_name5 IN VARCHAR2 DEFAULT NULL,
30 p_token_value5 IN VARCHAR2 DEFAULT NULL,
31 p_token_name6 IN VARCHAR2 DEFAULT NULL,
32 p_token_value6 IN VARCHAR2 DEFAULT NULL,
33 p_token_name7 IN VARCHAR2 DEFAULT NULL,
34 p_token_value7 IN VARCHAR2 DEFAULT NULL,
35 p_token_name8 IN VARCHAR2 DEFAULT NULL,
36 p_token_value8 IN VARCHAR2 DEFAULT NULL,
37 p_token_name9 IN VARCHAR2 DEFAULT NULL,
38 p_token_value9 IN VARCHAR2 DEFAULT NULL,
39 p_token_name10 IN VARCHAR2 DEFAULT NULL,
40 p_token_value10 IN VARCHAR2 DEFAULT NULL) RETURN BOOLEAN;
41
42
43 FUNCTION get_overbill_for_shipment (
44 p_po_shipment_id IN NUMBER,
45 p_quantity_invoiced IN NUMBER,
46 p_amount_invoiced IN NUMBER,
47 p_overbilled OUT NOCOPY VARCHAR2,
48 p_quantity_outstanding OUT NOCOPY NUMBER,
49 p_quantity_ordered OUT NOCOPY NUMBER,
50 p_qty_already_billed OUT NOCOPY NUMBER,
51 p_amount_outstanding OUT NOCOPY NUMBER,
52 p_amount_ordered OUT NOCOPY NUMBER,
53 p_amt_already_billed OUT NOCOPY NUMBER,
54 p_calling_sequence IN VARCHAR2) RETURN BOOLEAN;
55
56 FUNCTION get_batch_id (
57 p_batch_name IN VARCHAR2,
58 P_batch_id OUT NOCOPY NUMBER,
59 p_batch_type OUT NOCOPY VARCHAR2,
60 P_calling_sequence IN VARCHAR2) RETURN BOOLEAN;
61
62 FUNCTION get_info (
63 p_org_id IN NUMBER,
64 p_set_of_books_id OUT NOCOPY NUMBER,
65 p_multi_currency_flag OUT NOCOPY VARCHAR2,
66 p_make_rate_mandatory_flag OUT NOCOPY VARCHAR2,
67 p_default_exchange_rate_type OUT NOCOPY VARCHAR2,
68 p_base_currency_code OUT NOCOPY VARCHAR2,
69 p_batch_control_flag OUT NOCOPY VARCHAR2,
70 p_invoice_currency_code OUT NOCOPY VARCHAR2,
71 p_base_min_acct_unit OUT NOCOPY NUMBER,
72 p_base_precision OUT NOCOPY NUMBER,
73 p_sequence_numbering OUT NOCOPY VARCHAR2,
74 p_awt_include_tax_amt OUT NOCOPY VARCHAR2,
75 p_gl_date IN OUT NOCOPY DATE,
76 -- Removed for bug 4277744
77 -- p_ussgl_transcation_code OUT NOCOPY VARCHAR2,
78 p_trnasfer_desc_flex_flag OUT NOCOPY VARCHAR2,
79 p_gl_date_from_receipt_flag OUT NOCOPY VARCHAR2,
80 p_purch_encumbrance_flag OUT NOCOPY VARCHAR2,
81 p_retainage_ccid OUT NOCOPY NUMBER,
82 P_pa_installed OUT NOCOPY VARCHAR2,
83 p_chart_of_accounts_id OUT NOCOPY NUMBER,
84 p_inv_doc_cat_override OUT NOCOPY VARCHAR2,
85 p_calc_user_xrate OUT NOCOPY VARCHAR2,
86 p_calling_sequence IN VARCHAR2,
87 p_approval_workflow_flag OUT NOCOPY VARCHAR2,
88 p_freight_code_combination_id OUT NOCOPY NUMBER,
89 p_allow_interest_invoices OUT NOCOPY VARCHAR2, --bug4113223
90 p_add_days_settlement_date OUT NOCOPY NUMBER, --bug4930111
91 p_disc_is_inv_less_tax_flag OUT NOCOPY VARCHAR2, /* bug4931755. Exc Tax fr Disc */
92 p_source IN VARCHAR2, -- bug 5382889. LE TimeZone
93 p_invoice_date IN DATE, -- bug 5382889. LE TimeZone
94 p_goods_received_date IN DATE, -- bug 5382889. LE TimeZone
95 p_asset_book_type OUT NOCOPY VARCHAR2 -- bug 5448579
96 ) RETURN BOOLEAN;
97
98 FUNCTION get_tolerance_info(
99 p_vendor_site_id IN NUMBER,
100 p_positive_price_tolerance OUT NOCOPY NUMBER,
101 p_negative_price_tolerance OUT NOCOPY NUMBER,
102 p_qty_tolerance OUT NOCOPY NUMBER,
103 p_qty_rec_tolerance OUT NOCOPY NUMBER,
104 p_max_qty_ord_tolerance OUT NOCOPY NUMBER,
105 p_max_qty_rec_tolerance OUT NOCOPY NUMBER,
106 p_amt_tolerance OUT NOCOPY NUMBER,
107 p_amt_rec_tolerance OUT NOCOPY NUMBER,
108 p_max_amt_ord_tolerance OUT NOCOPY NUMBER,
109 p_max_amt_rec_tolerance OUT NOCOPY NUMBER,
110 p_goods_ship_amt_tolerance OUT NOCOPY NUMBER,
111 p_goods_rate_amt_tolerance OUT NOCOPY NUMBER,
112 p_goods_total_amt_tolerance OUT NOCOPY NUMBER,
113 p_services_ship_amt_tolerance OUT NOCOPY NUMBER,
114 p_services_rate_amt_tolerance OUT NOCOPY NUMBER,
115 p_services_total_amt_tolerance OUT NOCOPY NUMBER,
116 p_calling_sequence IN VARCHAR2)
117 RETURN BOOLEAN;
118
119 FUNCTION find_vendor_primary_paysite(
120 p_vendor_id IN NUMBER,
121 p_vendor_primary_paysite_id OUT NOCOPY NUMBER,
122 p_calling_sequence IN VARCHAR2) RETURN BOOLEAN;
123
124 FUNCTION get_employee_id(
125 p_invoice_id IN NUMBER,
126 p_vendor_id IN NUMBER,
127 p_employee_id OUT NOCOPY NUMBER,
128 p_default_last_updated_by IN NUMBER,
129 p_default_last_update_login IN NUMBER,
130 p_current_invoice_status OUT NOCOPY VARCHAR2,
131 p_calling_sequence IN VARCHAR2) RETURN BOOLEAN;
132
133 FUNCTION get_overbill_for_po_line(
134 p_po_line_id IN NUMBER,
135 p_quantity_invoiced IN NUMBER,
136 p_amount_invoiced IN NUMBER,
137 p_overbilled OUT NOCOPY VARCHAR2,
138 p_outstanding OUT NOCOPY NUMBER,
139 p_ordered OUT NOCOPY NUMBER,
140 p_already_billed OUT NOCOPY NUMBER,
141 p_po_line_matching_basis OUT NOCOPY VARCHAR2,
142 P_calling_sequence IN VARCHAR2) RETURN BOOLEAN;
143
144 FUNCTION pa_flexbuild (
145 p_invoice_rec IN
146 AP_IMPORT_INVOICES_PKG.r_invoice_info_rec,
147 p_invoice_lines_rec IN OUT NOCOPY
148 AP_IMPORT_INVOICES_PKG.r_line_info_rec,
149 p_accounting_date IN DATE,
150 p_pa_installed IN VARCHAR2,
151 p_employee_id IN NUMBER,
152 p_base_currency_code IN VARCHAR2,
153 p_chart_of_accounts_id IN NUMBER,
154 p_default_last_updated_by IN NUMBER,
155 p_default_last_update_login IN NUMBER,
156 p_pa_default_dist_ccid OUT NOCOPY NUMBER,
157 p_pa_concatenated_segments OUT NOCOPY VARCHAR2,
158 p_current_invoice_status OUT NOCOPY VARCHAR2,
159 p_calling_sequence IN VARCHAR2) RETURN BOOLEAN;
160
161 FUNCTION get_doc_sequence(
162 p_invoice_rec IN OUT
163 AP_IMPORT_INVOICES_PKG.r_invoice_info_rec,
164 p_inv_doc_cat_override IN VARCHAR2,
165 p_set_of_books_id IN NUMBER,
166 p_sequence_numbering IN VARCHAR2,
167 p_default_last_updated_by IN NUMBER,
168 p_default_last_update_login IN NUMBER,
169 p_db_sequence_value OUT NOCOPY NUMBER,
170 p_db_seq_name OUT NOCOPY VARCHAR2,
171 p_db_sequence_id OUT NOCOPY NUMBER,
172 p_current_invoice_status OUT NOCOPY VARCHAR2,
173 p_calling_sequence IN VARCHAR2) RETURN BOOLEAN;
174
175 FUNCTION get_invoice_info(
176 p_invoice_rec IN OUT NOCOPY
177 AP_IMPORT_INVOICES_PKG.r_invoice_info_rec,
178 p_default_last_updated_by IN NUMBER,
179 p_default_last_update_login IN NUMBER,
180 p_pay_curr_invoice_amount OUT NOCOPY NUMBER,
181 p_payment_priority OUT NOCOPY NUMBER,
182 p_invoice_amount_limit OUT NOCOPY NUMBER,
183 p_hold_future_payments_flag OUT NOCOPY VARCHAR2,
184 p_supplier_hold_reason OUT NOCOPY VARCHAR2,
185 p_exclude_freight_from_disc OUT NOCOPY VARCHAR2, /*bug 4931755.Excl Tax fr Discount */
186 p_calling_sequence IN VARCHAR2) RETURN BOOLEAN;
187
188 --Payment Request: Added p_needs_invoice_approval for payment request invoices
189 FUNCTION insert_ap_invoices(
190 p_invoice_rec IN OUT
191 AP_IMPORT_INVOICES_PKG.r_invoice_info_rec,
192 p_base_invoice_id OUT NOCOPY NUMBER,
193 p_set_of_books_id IN NUMBER,
194 p_doc_sequence_id IN
195 AP_INVOICES.doc_sequence_id%TYPE,
196 p_doc_sequence_value IN
197 AP_INVOICES.doc_sequence_value%TYPE,
198 p_batch_id IN
199 AP_INVOICES.batch_id%TYPE,
200 p_pay_curr_invoice_amount IN NUMBER,
201 p_approval_workflow_flag IN VARCHAR2,
202 p_needs_invoice_approval IN VARCHAR2,
203 p_add_days_settlement_date IN NUMBER, --bugfix:4930111
204 p_disc_is_inv_less_tax_flag IN VARCHAR2, /*bug 4931755.Excl Tax fr Discount */
205 p_exclude_freight_from_disc IN VARCHAR2, /*bug 4931755.Excl Tax fr Discount */
206 p_calling_sequence IN VARCHAR2) RETURN BOOLEAN;
207
208 FUNCTION change_invoice_status(
209 p_status IN VARCHAR2,
210 p_import_invoice_id IN NUMBER,
211 P_calling_sequence IN VARCHAR2) RETURN BOOLEAN;
212
213 FUNCTION Update_temp_invoice_status(
214 p_source IN VARCHAR2,
215 p_group_id IN VARCHAR2,
216 p_calling_sequence IN VARCHAR2) RETURN BOOLEAN;
217 FUNCTION get_auto_batch_name(
218 p_source IN VARCHAR2,
219 p_batch_name OUT NOCOPY VARCHAR2,
220 p_calling_sequence IN VARCHAR2) RETURN BOOLEAN;
221
222 FUNCTION Insert_ap_batches(
223 p_batch_id IN NUMBER,
224 p_batch_name IN VARCHAR2,
225 p_invoice_currency_code IN VARCHAR2,
226 p_payment_currency_code IN VARCHAR2,
227 p_actual_invoice_count IN NUMBER,
228 p_actual_invoice_total IN NUMBER,
229 p_last_updated_by IN NUMBER,
230 p_calling_sequence IN VARCHAR2) RETURN BOOLEAN;
231
232 FUNCTION Update_Ap_Batches(
233 p_batch_id IN NUMBER,
234 p_batch_name IN VARCHAR2,
235 p_actual_invoice_count IN NUMBER,
236 p_actual_invoice_total IN NUMBER,
237 p_last_updated_by IN NUMBER,
238 p_calling_sequence IN VARCHAR2) RETURN BOOLEAN;
239
240 FUNCTION insert_ap_invoice_lines(
241 p_base_invoice_id IN NUMBER,
242 p_invoice_lines_tab IN
243 AP_IMPORT_INVOICES_PKG.t_lines_table,
244 p_set_of_books_id IN NUMBER,
245 p_approval_workflow_flag IN VARCHAR2,
246 p_tax_only_flag IN VARCHAR2,
247 p_tax_only_rcv_matched_flag IN VARCHAR2,
248 p_default_last_updated_by IN NUMBER,
249 p_default_last_update_login IN NUMBER,
250 p_calling_sequence IN VARCHAR2) RETURN BOOLEAN;
251
252 FUNCTION Create_Lines(
253 p_batch_id IN NUMBER,
254 p_base_invoice_id IN NUMBER,
255 p_invoice_lines_tab IN
256 AP_IMPORT_INVOICES_PKG.t_lines_table,
257 p_base_currency_code IN VARCHAR2,
258 p_set_of_books_id IN NUMBER,
259 p_approval_workflow_flag IN VARCHAR2,
260 p_tax_only_flag IN VARCHAR2,
261 p_tax_only_rcv_matched_flag IN VARCHAR2,
262 p_default_last_updated_by IN NUMBER,
263 p_default_last_update_login IN NUMBER,
267 p_base_invoice_id IN NUMBER,
264 p_calling_sequence IN VARCHAR2) RETURN BOOLEAN;
265
266 FUNCTION insert_holds(
268 p_hold_code IN VARCHAR2,
269 p_hold_reason IN VARCHAR2,
270 p_hold_future_payments_flag IN VARCHAR2,
271 p_supplier_hold_reason IN VARCHAR2,
272 p_invoice_amount_limit IN NUMBER,
273 p_invoice_base_amount IN NUMBER,
274 p_last_updated_by IN NUMBER,
275 P_calling_sequence IN VARCHAR2) RETURN BOOLEAN ;
276
277 FUNCTION get_tax_only_rcv_matched_flag(
278 P_invoice_id IN NUMBER) RETURN VARCHAR2;
279
280 FUNCTION get_tax_only_flag(
281 P_invoice_id IN NUMBER) RETURN VARCHAR2;
282
283
284 /* 5039042. Function for Checking if Distribution Generation Event is rgeistered for the
285 source application */
286 FUNCTION Is_Product_Registered(P_Application_Id IN NUMBER,
287 X_Registration_Api OUT NOCOPY VARCHAR2,
288 X_Registration_View OUT NOCOPY VARCHAR2,
289 P_Calling_Sequence IN VARCHAR2) RETURN BOOLEAN;
290
291 -- Bug 5448579. This function will be used for caching org_id, name
292 FUNCTION Cache_Org_Id_Name (
293 P_Moac_Org_Table OUT NOCOPY AP_IMPORT_INVOICES_PKG.moac_ou_tab_type,
294 P_Fsp_Org_Table OUT NOCOPY AP_IMPORT_INVOICES_PKG.fsp_org_tab_type,
295 P_Calling_Sequence IN VARCHAR2) RETURN BOOLEAN;
296
297 -- Bug 5448579. This function will be used for checking term claendar based on terms_id
298 PROCEDURE Check_For_Calendar_Term
299 (p_terms_id IN number,
300 p_terms_date IN date,
301 p_no_cal IN OUT NOCOPY varchar2,
302 p_calling_sequence IN varchar2);
303
304 -- Bug 5448579. This function will be used for caching Pay Group
305 FUNCTION Cache_Pay_Group (
306 P_Pay_Group_Table OUT NOCOPY AP_IMPORT_INVOICES_PKG.pay_group_tab_type,
307 P_Calling_Sequence IN VARCHAR2) RETURN BOOLEAN;
308
309
310 -- Bug 5448579. This function will be used for caching Pay Group
311 FUNCTION Cache_Payment_Method (
312 P_Payment_Method_Table OUT NOCOPY AP_IMPORT_INVOICES_PKG.payment_method_tab_type,
313 P_Calling_Sequence IN VARCHAR2) RETURN BOOLEAN;
314
315 -- Bug 5448579. This function will be used for cachin Currency
316 FUNCTION Cache_Fnd_Currency (
317 P_Fnd_Currency_Table OUT NOCOPY AP_IMPORT_INVOICES_PKG.fnd_currency_tab_type,
318 P_Calling_Sequence IN VARCHAR2) RETURN BOOLEAN;
319
320 END AP_IMPORT_UTILITIES_PKG;