1 PACKAGE PO_INVOICES_SV1 AS
2 /* $Header: POXIVCRS.pls 120.4 2006/04/26 08:05:51 szaveri noship $ */
3
4 /*==================================================================
5 PROCEDURE NAME: create_ap_invoices
6
7 DESCRIPTION: This Api automatically creates AP invoices for either
8 Receipt transactions combined with purchase order or shipment
9 and billing notice.
10
11 PARAMETERS: X_transaction_source IN VARCHAR2,
12 X_commit_interval IN NUMBER,
13 X_shipment_header_id IN NUMBER
14
15 DESIGN
16 REFERENCES: 857proc.doc
17
18 CHANGE Created 19-March-96 SODAYAR
19 HISTORY:
20
21 =======================================================================*/
22 PROCEDURE create_ap_invoices(X_transaction_source IN VARCHAR2,
23 X_commit_interval IN NUMBER,
24 X_shipment_header_id IN NUMBER,
25 X_aging_period IN NUMBER DEFAULT NULL);
26
27 /*==================================================================
28 PROCEDURE NAME: get_ap_parameters
29
30 DESCRIPTION: This procedure is used to obtain options defined in
31 AP_SYSTEM_PARAMETERS and FINANCIAL_SYSTEM_PARAMETERS.
32
33 PARAMETERS: X_def_sets_of_books_id OUT NUMBER,
34 X_def_base_currency_code OUT VARCHAR2,
35 X_def_batch_control_flag OUT VARCHAR2,
36 X_def_exchange_rate_type OUT VARCHAR2,
37 X_def_multi_currency_flag OUT VARCHAR2,
38 X_def_gl_dat_fr_rec_flag OUT VARCHAR2,
39 X_def_dis_inv_less_tax_flag OUT VARCHAR2,
40 X_def_income_tax_region OUT VARCHAR2,
41 X_def_income_tax_region_flag OUT VARCHAR2,
42 X_def_vat_country_code OUT VARCHAR2,
43 X_def_transfer_desc_flex_flag OUT VARCHAR2,
44 X_def_org_id OUT NUMBER,
45 X_def_awt_include_tax_amt OUT VARCHAR2
46
47
48 DESIGN
49 REFERENCES: 857proc.doc
50
51 CHANGE Created 19-March-96 SODAYAR
52 HISTORY: Changed 07-july-99 SRIKRISH
53
54 =======================================================================*/
55
56 PROCEDURE get_ap_parameters( X_def_sets_of_books_id OUT NOCOPY NUMBER,
57 X_def_base_currency_code OUT NOCOPY VARCHAR2,
58 X_def_batch_control_flag OUT NOCOPY VARCHAR2,
59 X_def_exchange_rate_type OUT NOCOPY VARCHAR2,
60 X_def_multi_currency_flag OUT NOCOPY VARCHAR2,
61 X_def_gl_dat_fr_rec_flag OUT NOCOPY VARCHAR2,
62 X_def_dis_inv_less_tax_flag OUT NOCOPY VARCHAR2,
63 X_def_income_tax_region OUT NOCOPY VARCHAR2,
64 X_def_income_tax_region_flag OUT NOCOPY VARCHAR2,
65 X_def_vat_country_code OUT NOCOPY VARCHAR2,
66 X_def_transfer_desc_flex_flag OUT NOCOPY VARCHAR2,
67 X_def_org_id OUT NOCOPY NUMBER,
68 X_def_awt_include_tax_amt OUT NOCOPY VARCHAR2 );
69
70 /*==================================================================
71 PROCEDURE NAME: get_vendor_related_info
72
73 DESCRIPTION: This API is used to obtain vendor/vendor pay-site related
74 info needed by the invoice creation program.
75
76 PARAMETERS: X_vendor_id IN NUMBER,
77 X_default_pay_site_id IN NUMBER,
78 X_pay_group_lookup_code OUT VARCHAR2,
79 X_accts_pay_combination_id OUT NUMBER,
80 X_payment_method_lookup_code OUT VARCHAR2,
81 X_payment_priority OUT VARCHAR2,
82 X_terms_date_basis OUT VARCHAR2,
83 X_vendor_income_tax_region OUT VARCHAR2,
84 X_type_1099 OUT VARCHAR2,
85 X_awt_flag OUT VARCHAR2,
86 X_awt_group_id OUT NUMBER,
87 X_exclude_freight_from_disc OUT VARCHAR2,
88 X_payment_currency_code OUT VARCHAR2
89
90 DESIGN
91 REFERENCES: 857proc.doc
92
93 CHANGE Created 19-March-96 SODAYAR
94 HISTORY: Modified 29-APR-96 KKCHAN
95
96 =======================================================================*/
97
98 PROCEDURE get_vendor_related_info ( X_vendor_id IN NUMBER,
99 X_default_pay_site_id IN NUMBER,
100 X_pay_group_lookup_code OUT NOCOPY VARCHAR2,
101 X_payment_method_lookup_code OUT NOCOPY VARCHAR2,
102 X_payment_priority OUT NOCOPY VARCHAR2,
103 X_terms_date_basis OUT NOCOPY VARCHAR2,
104 X_vendor_income_tax_region OUT NOCOPY VARCHAR2,
105 X_type_1099 OUT NOCOPY VARCHAR2,
106 X_awt_flag OUT NOCOPY VARCHAR2,
107 X_awt_group_id OUT NOCOPY NUMBER,
108 X_exclude_freight_from_disc OUT NOCOPY VARCHAR2,
109 X_payment_currency_code OUT NOCOPY VARCHAR2
110 );
111
112 /*==================================================================
113 PROCEDURE NAME: create_ap_batches
114
115 DESCRIPTION: This API is used by the AP invoice creation program to
116 create an invoice batch header record (depending on the
117 system option). However no defaulting info will be populated
118 in this API.
119
120 PARAMETERS: X_batch_source IN VARCHAR2
121 X_currency_code IN VARCHAR2
122 X_batch_id OUT NUMBER
123
124
125 DESIGN
126 REFERENCES: 857proc.doc
127
128 CHANGE Created 19-March-96 SODAYAR
129 HISTORY:
130
131 =======================================================================*/
132
133 -- Bug 4723269 : Added parameter p_org_id
134
135 PROCEDURE create_ap_batches( X_batch_source IN VARCHAR2,
136 X_currency_code IN VARCHAR2,
137 p_org_id IN NUMBER,
138 X_batch_id OUT NOCOPY NUMBER);
139
140
141 /*==================================================================
142 PROCEDURE NAME: update_ap_batches
143
144 DESCRIPTION: This API is used to update the invoice control count and
145 invoice running total for a given invoice batch.
146
147 PARAMETERS: X_batch_id IN NUMBER,
148 X_invoice_count IN NUMBER,
149 X_invoice_total IN NUMBER
150
151 DESIGN
152 REFERENCES: 857proc.doc
153
154 CHANGE Created 19-March-96 SODAYAR
155 HISTORY:
156
157 =======================================================================*/
158
159 PROCEDURE update_ap_batches( X_batch_id IN NUMBER,
160 X_invoice_count IN NUMBER,
161 X_invoice_total IN NUMBER);
162
163
164
165
166
167 /*==================================================================
168 PROCEDURE NAME: get_accounting_date_and_period
169
170 DESCRIPTION: This Api is used to determine the accounting date used in
171 the in voice distribution based on the gl daate setup in
172 payables.
173
174 PARAMETERS: X_def_gl_date_from_receipt_flag IN VARCHAR2,
175 X_def_sets_of_books_id IN NUMBER,
176 X_invoice_date IN DATE,
177 X_receipt_date IN DATE
178 X_batch_id IN NUMBER,
179 X_transaction_type IN VARCHAR2,
180 X_unique_id IN NUMBER,
181 -- The above 3 variables are used for error handling.
182 X_accounting_date OUT DATE,
183 X_period_name OUT VARCHAR2 ,
184 X_curr_inv_process_flag IN OUT VARCHAR2
185
186 DESIGN
187 REFERENCES: 857proc.doc
188
189 CHANGE Created 19-March-96 SODAYAR
190 HISTORY:
191
192 =======================================================================*/
193
194 PROCEDURE get_accounting_date_and_period(
195 X_def_gl_dat_fr_rec_flag IN VARCHAR2,
196 X_def_sets_of_books_id IN NUMBER,
197 X_invoice_date IN DATE,
198 X_receipt_date IN DATE,
199 X_batch_id IN NUMBER,
200 X_transaction_type IN VARCHAR2,
201 X_unique_id IN NUMBER,
202 X_accounting_date OUT NOCOPY DATE,
203 X_period_name OUT NOCOPY VARCHAR2,
204 X_curr_inv_process_flag IN OUT NOCOPY VARCHAR2 );
205
206
207 /*==================================================================
208 <CANCEL ASBN FPI, bug # 2569530>
209 PROCEDURE NAME: cancel_asbn_invoices
210
211 DESCRIPTION: Calls AP's API Ap_Cancel_Single_Invoice to cancel invoices
212 in ASBN cancellation
213
214 PARAMETERS: p_invoice_num IN VARCHAR2,
215 p_vendor_id IN NUMBER
216
217 DESIGN
218 REFERENCES:
219
220 CHANGE Created 21-AUGUST-02 DXIE
221 HISTORY:
222
223 =======================================================================*/
224 PROCEDURE cancel_asbn_invoices(
225 p_invoice_num IN VARCHAR2,
226 p_vendor_id IN NUMBER);
227
228
229 /* <PAY ON USE FPI START> */
230 /*=================================================================
231 PROCEDURE NAME: submit_invoice_import
232
233 DESCRIPTION: Submit a concurrent request "Payable Open Interface Import"
234 to process data that have been inserted into AP Interface
235 tables.
236
237 PARAMETERS:
238 x_return_status : return status of the procedure
239 p_source : what kind of invoices this call is creating for
240 p_group_id : group id for invoice import
241 p_batch_name : batch name
242 p_user_id : user id
243 p_login_id : login id
244 x_request_id : return request id after submitting the request
245
246 DESIGN REFERENCES:
247
248 CHANGE HISTORY: Created 08-October-02 BAO
249
250 ==================================================================*/
251 PROCEDURE submit_invoice_import (
252 x_return_status OUT NOCOPY VARCHAR2,
253 p_source IN VARCHAR2,
254 p_group_id IN VARCHAR2,
255 p_batch_name IN VARCHAR2,
256 p_user_id IN NUMBER,
257 p_login_id IN NUMBER,
258 x_request_id OUT NOCOPY NUMBER);
259
260
261 /*=================================================================
262 PROCEDURE NAME: delete_interface_records
263
264 DESCRIPTION: Deletes all the records in AP_INVOICES_INTERFACE and
265 AP_INVOICE_LINES_INTERFACE tables based on group_id
266
267 PARAMETERS:
268 x_return_status : return status of the procedure
269 p_group_id : group id for import program
270
271 DESIGN REFERENCES:
272
273 CHANGE HISTORY: Created 08-October-02 BAO
274
275 ==================================================================*/
276 PROCEDURE delete_interface_records(
277 x_return_status OUT NOCOPY VARCHAR2,
278 p_group_id IN VARCHAR2);
279
280 /* <PAY ON USE FPI END> */
281
282
283 END PO_INVOICES_SV1;