1 PACKAGE jai_ap_utils_pkg AS
2 /* $Header: jai_ap_utils.pls 120.7.12010000.2 2008/11/25 10:44:02 mbremkum ship $ */
3
4 /*----------------------------------------------------------------------------------------------------------------
5
6 Filename:
7
8 Change History:
9
10 Date Remarks
11 ---------------------------------------------------------------------------------------------------------
12 08-Jun-2005 File Version 116.2 Object is Modified to refer to New DB Entity names in place of
13 Old DB Entity Names as required for CASE COMPLAINCE.
14
15 14-Jun-2005 rchandan for bug#4428980, Version 116.3
16 Modified the object to remove literals from DML statements and CURSORS.
17 As part OF R12 Initiative Inventory conversion the OPM code is commented
18
19 23-Jun-2005 Brathod , File Version 112.0 , Bug# 4445989
20 Signature for procedure get_aportion_factor is modified to use invoice_id and invoice_line_number
21
22 02-Sep-2005 Ramananda for Bug#4418550, File Version 120.2
23 Added the new function get_tds_invoice_batch
24
25 Dependency Due to this Bug (Functional)
26 --------------------------
27 jai_ap_utils.plb (120.2)
28 jai_ap_tds_old.plb (120.3)
29 jai_ap_tds_gen.plb (120.8)
30 jai_constants.pls (120.3)
31 jaiorgdffsetup.sql (120.2)
32 ja12alu.ldt, jaivmlu.ldt
33 16-apr-2007 Vkaranam for bug #5989740,File version 120.3
34 Forward porting the changes done in 11i bug#5583832
35 Signature for procedure get_aportion_factor is modified.
36
37 ---------------------------------------------------------------------------------------------------------*/
38
39 PROCEDURE create_pla_invoice(
40 P_PLA_ID IN NUMBER,
41 P_SET_OF_BOOK_ID IN NUMBER,
42 P_ORG_ID IN NUMBER
43 );
44
45 PROCEDURE create_boe_invoice(
46 P_BOE_ID IN NUMBER,
47 P_SET_OF_BOOK_ID IN NUMBER,
48 P_ORG_ID IN NUMBER
49 );
50
51
52 PROCEDURE insert_ap_inv_interface(
53 p_jai_source IN VARCHAR2,
54 p_invoice_id OUT NOCOPY ap_invoices_interface.INVOICE_ID%TYPE,
55 p_invoice_num IN ap_invoices_interface.INVOICE_NUM%TYPE DEFAULT NULL,
56 p_invoice_type_lookup_code IN ap_invoices_interface.INVOICE_TYPE_LOOKUP_CODE%TYPE DEFAULT NULL,
57 p_invoice_date IN ap_invoices_interface.INVOICE_DATE%TYPE DEFAULT NULL,
58 p_po_number IN ap_invoices_interface.PO_NUMBER%TYPE DEFAULT NULL,
59 p_vendor_id IN ap_invoices_interface.VENDOR_ID%TYPE DEFAULT NULL,
60 p_vendor_num IN ap_invoices_interface.VENDOR_NUM%TYPE DEFAULT NULL,
61 p_vendor_name IN ap_invoices_interface.VENDOR_NAME%TYPE DEFAULT NULL,
62 p_vendor_site_id IN ap_invoices_interface.VENDOR_SITE_ID%TYPE DEFAULT NULL,
63 p_vendor_site_code IN ap_invoices_interface.VENDOR_SITE_CODE%TYPE DEFAULT NULL,
64 p_invoice_amount IN ap_invoices_interface.INVOICE_AMOUNT%TYPE DEFAULT NULL,
65 p_invoice_currency_code IN ap_invoices_interface.INVOICE_CURRENCY_CODE%TYPE DEFAULT NULL,
66 p_exchange_rate IN ap_invoices_interface.EXCHANGE_RATE%TYPE DEFAULT NULL,
67 p_exchange_rate_type IN ap_invoices_interface.EXCHANGE_RATE_TYPE%TYPE DEFAULT NULL,
68 p_exchange_date IN ap_invoices_interface.EXCHANGE_DATE%TYPE DEFAULT NULL,
69 p_terms_id IN ap_invoices_interface.TERMS_ID%TYPE DEFAULT NULL,
70 p_terms_name IN ap_invoices_interface.TERMS_NAME%TYPE DEFAULT NULL,
71 p_description IN ap_invoices_interface.DESCRIPTION%TYPE DEFAULT NULL,
72 p_awt_group_id IN ap_invoices_interface.AWT_GROUP_ID%TYPE DEFAULT NULL,
73 p_awt_group_name IN ap_invoices_interface.AWT_GROUP_NAME%TYPE DEFAULT NULL,
74 p_last_update_date IN ap_invoices_interface.LAST_UPDATE_DATE%TYPE DEFAULT NULL,
75 p_last_updated_by IN ap_invoices_interface.LAST_UPDATED_BY%TYPE DEFAULT NULL,
76 p_last_update_login IN ap_invoices_interface.LAST_UPDATE_LOGIN%TYPE DEFAULT NULL,
77 p_creation_date IN ap_invoices_interface.CREATION_DATE%TYPE DEFAULT NULL,
78 p_created_by IN ap_invoices_interface.CREATED_BY%TYPE DEFAULT NULL,
79 --Added below the attribute category and attribute parameters for Bug #3841637
80 p_attribute_category IN ap_invoices_interface.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
81 p_attribute1 IN ap_invoices_interface.ATTRIBUTE1%TYPE DEFAULT NULL,
82 p_attribute2 IN ap_invoices_interface.ATTRIBUTE2%TYPE DEFAULT NULL,
83 p_attribute3 IN ap_invoices_interface.ATTRIBUTE3%TYPE DEFAULT NULL,
84 p_attribute4 IN ap_invoices_interface.ATTRIBUTE4%TYPE DEFAULT NULL,
85 p_attribute5 IN ap_invoices_interface.ATTRIBUTE5%TYPE DEFAULT NULL,
86 p_attribute6 IN ap_invoices_interface.ATTRIBUTE6%TYPE DEFAULT NULL,
87 p_attribute7 IN ap_invoices_interface.ATTRIBUTE7%TYPE DEFAULT NULL,
88 p_attribute8 IN ap_invoices_interface.ATTRIBUTE8%TYPE DEFAULT NULL,
89 p_attribute9 IN ap_invoices_interface.ATTRIBUTE9%TYPE DEFAULT NULL,
90 p_attribute10 IN ap_invoices_interface.ATTRIBUTE10%TYPE DEFAULT NULL,
91 p_attribute11 IN ap_invoices_interface.ATTRIBUTE11%TYPE DEFAULT NULL,
92 p_attribute12 IN ap_invoices_interface.ATTRIBUTE12%TYPE DEFAULT NULL,
93 p_attribute13 IN ap_invoices_interface.ATTRIBUTE13%TYPE DEFAULT NULL,
94 p_attribute14 IN ap_invoices_interface.ATTRIBUTE14%TYPE DEFAULT NULL,
95 p_attribute15 IN ap_invoices_interface.ATTRIBUTE15%TYPE DEFAULT NULL,
96 p_status IN ap_invoices_interface.STATUS%TYPE DEFAULT NULL,
97 p_source IN ap_invoices_interface.SOURCE%TYPE DEFAULT NULL,
98 p_group_id IN ap_invoices_interface.GROUP_ID%TYPE DEFAULT NULL,
99 p_request_id IN ap_invoices_interface.REQUEST_ID%TYPE DEFAULT NULL,
100 p_payment_cross_rate_type IN ap_invoices_interface.PAYMENT_CROSS_RATE_TYPE%TYPE DEFAULT NULL,
101 p_payment_cross_rate_date IN ap_invoices_interface.PAYMENT_CROSS_RATE_DATE%TYPE DEFAULT NULL,
102 p_payment_cross_rate IN ap_invoices_interface.PAYMENT_CROSS_RATE%TYPE DEFAULT NULL,
103 p_payment_currency_code IN ap_invoices_interface.PAYMENT_CURRENCY_CODE%TYPE DEFAULT NULL,
104 p_workflow_flag IN ap_invoices_interface.WORKFLOW_FLAG%TYPE DEFAULT NULL,
105 p_doc_category_code IN ap_invoices_interface.DOC_CATEGORY_CODE%TYPE DEFAULT NULL,
106 p_voucher_num IN ap_invoices_interface.VOUCHER_NUM%TYPE DEFAULT NULL,
107 p_payment_method_lookup_code IN ap_invoices_interface.PAYMENT_METHOD_LOOKUP_CODE%TYPE DEFAULT NULL,
108 p_pay_group_lookup_code IN ap_invoices_interface.PAY_GROUP_LOOKUP_CODE%TYPE DEFAULT NULL,
109 p_goods_received_date IN ap_invoices_interface.GOODS_RECEIVED_DATE%TYPE DEFAULT NULL,
110 p_invoice_received_date IN ap_invoices_interface.INVOICE_RECEIVED_DATE%TYPE DEFAULT NULL,
111 p_gl_date IN ap_invoices_interface.GL_DATE%TYPE DEFAULT NULL,
112 p_accts_pay_ccid IN ap_invoices_interface.ACCTS_PAY_CODE_COMBINATION_ID%TYPE DEFAULT NULL,
113 p_ussgl_transaction_code IN ap_invoices_interface.USSGL_TRANSACTION_CODE%TYPE DEFAULT NULL,
114 p_exclusive_payment_flag IN ap_invoices_interface.EXCLUSIVE_PAYMENT_FLAG%TYPE DEFAULT NULL,
115 p_org_id IN ap_invoices_interface.ORG_ID%TYPE DEFAULT NULL,
116 p_amount_applicable_to_dis IN ap_invoices_interface.AMOUNT_APPLICABLE_TO_DISCOUNT%TYPE DEFAULT NULL,
117 p_prepay_num IN ap_invoices_interface.PREPAY_NUM%TYPE DEFAULT NULL,
118 p_prepay_dist_num IN ap_invoices_interface.PREPAY_DIST_NUM%TYPE DEFAULT NULL,
119 p_prepay_apply_amount IN ap_invoices_interface.PREPAY_APPLY_AMOUNT%TYPE DEFAULT NULL,
120 p_prepay_gl_date IN ap_invoices_interface.PREPAY_GL_DATE%TYPE DEFAULT NULL,
121 -- Bug4240179. Added by LGOPALSA. Changed the data type
122 -- for the following 4 fields.
123 p_invoice_includes_prepay_flag IN VARCHAR2 DEFAULT NULL,
124 p_no_xrate_base_amount IN NUMBER DEFAULT NULL,
125 p_vendor_email_address IN VARCHAR2 DEFAULT NULL,
126 p_terms_date IN DATE DEFAULT NULL,
127 p_requester_id IN NUMBER DEFAULT NULL,
128 p_ship_to_location IN VARCHAR2 DEFAULT NULL,
129 p_external_doc_ref IN VARCHAR2 DEFAULT NULL,
130 -- bug 7109056. Added by Lakshmi Gopalsami
131 p_payment_method_code IN VARCHAR2 DEFAULT NULL);
132
133 PROCEDURE insert_ap_inv_lines_interface(
134 p_jai_source IN VARCHAR2,
135 p_invoice_id IN ap_invoice_lines_interface.INVOICE_ID%TYPE,
136 p_invoice_line_id OUT NOCOPY ap_invoice_lines_interface.INVOICE_LINE_ID%TYPE,
137 p_line_number IN ap_invoice_lines_interface.LINE_NUMBER%TYPE DEFAULT NULL,
138 p_line_type_lookup_code IN ap_invoice_lines_interface.LINE_TYPE_LOOKUP_CODE%TYPE DEFAULT NULL,
139 p_line_group_number IN ap_invoice_lines_interface.LINE_GROUP_NUMBER%TYPE DEFAULT NULL,
140 p_amount IN ap_invoice_lines_interface.AMOUNT%TYPE DEFAULT NULL,
141 p_accounting_date IN ap_invoice_lines_interface.ACCOUNTING_DATE%TYPE DEFAULT NULL,
142 p_description IN ap_invoice_lines_interface.DESCRIPTION%TYPE DEFAULT NULL,
143 p_amount_includes_tax_flag IN ap_invoice_lines_interface.AMOUNT_INCLUDES_TAX_FLAG%TYPE DEFAULT NULL,
144 p_prorate_across_flag IN ap_invoice_lines_interface.PRORATE_ACROSS_FLAG%TYPE DEFAULT NULL,
145 p_tax_code IN ap_invoice_lines_interface.TAX_CODE%TYPE DEFAULT NULL,
146 p_final_match_flag IN ap_invoice_lines_interface.FINAL_MATCH_FLAG%TYPE DEFAULT NULL,
147 p_po_header_id IN ap_invoice_lines_interface.PO_HEADER_ID%TYPE DEFAULT NULL,
148 p_po_number IN ap_invoice_lines_interface.PO_NUMBER%TYPE DEFAULT NULL,
149 p_po_line_id IN ap_invoice_lines_interface.PO_LINE_ID%TYPE DEFAULT NULL,
150 p_po_line_number IN ap_invoice_lines_interface.PO_LINE_NUMBER%TYPE DEFAULT NULL,
151 p_po_line_location_id IN ap_invoice_lines_interface.PO_LINE_LOCATION_ID%TYPE DEFAULT NULL,
152 p_po_shipment_num IN ap_invoice_lines_interface.PO_SHIPMENT_NUM%TYPE DEFAULT NULL,
153 p_po_distribution_id IN ap_invoice_lines_interface.PO_DISTRIBUTION_ID%TYPE DEFAULT NULL,
154 p_po_distribution_num IN ap_invoice_lines_interface.PO_DISTRIBUTION_NUM%TYPE DEFAULT NULL,
155 p_po_unit_of_measure IN ap_invoice_lines_interface.PO_UNIT_OF_MEASURE%TYPE DEFAULT NULL,
156 p_inventory_item_id IN ap_invoice_lines_interface.INVENTORY_ITEM_ID%TYPE DEFAULT NULL,
157 p_item_description IN ap_invoice_lines_interface.ITEM_DESCRIPTION%TYPE DEFAULT NULL,
158 p_quantity_invoiced IN ap_invoice_lines_interface.QUANTITY_INVOICED%TYPE DEFAULT NULL,
159 p_ship_to_location_code IN ap_invoice_lines_interface.SHIP_TO_LOCATION_CODE%TYPE DEFAULT NULL,
160 p_unit_price IN ap_invoice_lines_interface.UNIT_PRICE%TYPE DEFAULT NULL,
161 p_distribution_set_id IN ap_invoice_lines_interface.DISTRIBUTION_SET_ID%TYPE DEFAULT NULL,
162 p_distribution_set_name IN ap_invoice_lines_interface.DISTRIBUTION_SET_NAME%TYPE DEFAULT NULL,
163 p_dist_code_concatenated IN ap_invoice_lines_interface.DIST_CODE_CONCATENATED%TYPE DEFAULT NULL,
164 p_dist_code_combination_id IN ap_invoice_lines_interface.DIST_CODE_COMBINATION_ID%TYPE DEFAULT NULL,
165 p_awt_group_id IN ap_invoice_lines_interface.AWT_GROUP_ID%TYPE DEFAULT NULL,
166 p_awt_group_name IN ap_invoice_lines_interface.AWT_GROUP_NAME%TYPE DEFAULT NULL,
167 p_last_updated_by IN ap_invoice_lines_interface.LAST_UPDATED_BY%TYPE DEFAULT NULL,
168 p_last_update_date IN ap_invoice_lines_interface.LAST_UPDATE_DATE%TYPE DEFAULT NULL,
169 p_last_update_login IN ap_invoice_lines_interface.LAST_UPDATE_LOGIN%TYPE DEFAULT NULL,
170 p_created_by IN ap_invoice_lines_interface.CREATED_BY%TYPE DEFAULT NULL,
171 p_creation_date IN ap_invoice_lines_interface.CREATION_DATE%TYPE DEFAULT NULL,
172 --Added below the attribute category and attribute parameters for Bug #3841637
173 p_attribute_category IN ap_invoices_interface.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
174 p_attribute1 IN ap_invoices_interface.ATTRIBUTE1%TYPE DEFAULT NULL,
175 p_attribute2 IN ap_invoices_interface.ATTRIBUTE2%TYPE DEFAULT NULL,
176 p_attribute3 IN ap_invoices_interface.ATTRIBUTE3%TYPE DEFAULT NULL,
177 p_attribute4 IN ap_invoices_interface.ATTRIBUTE4%TYPE DEFAULT NULL,
178 p_attribute5 IN ap_invoices_interface.ATTRIBUTE5%TYPE DEFAULT NULL,
179 p_attribute6 IN ap_invoices_interface.ATTRIBUTE6%TYPE DEFAULT NULL,
180 p_attribute7 IN ap_invoices_interface.ATTRIBUTE7%TYPE DEFAULT NULL,
181 p_attribute8 IN ap_invoices_interface.ATTRIBUTE8%TYPE DEFAULT NULL,
182 p_attribute9 IN ap_invoices_interface.ATTRIBUTE9%TYPE DEFAULT NULL,
183 p_attribute10 IN ap_invoices_interface.ATTRIBUTE10%TYPE DEFAULT NULL,
184 p_attribute11 IN ap_invoices_interface.ATTRIBUTE11%TYPE DEFAULT NULL,
185 p_attribute12 IN ap_invoices_interface.ATTRIBUTE12%TYPE DEFAULT NULL,
186 p_attribute13 IN ap_invoices_interface.ATTRIBUTE13%TYPE DEFAULT NULL,
187 p_attribute14 IN ap_invoices_interface.ATTRIBUTE14%TYPE DEFAULT NULL,
188 p_attribute15 IN ap_invoices_interface.ATTRIBUTE15%TYPE DEFAULT NULL,
189 p_po_release_id IN ap_invoice_lines_interface.PO_RELEASE_ID%TYPE DEFAULT NULL,
190 p_release_num IN ap_invoice_lines_interface.RELEASE_NUM%TYPE DEFAULT NULL,
191 p_account_segment IN ap_invoice_lines_interface.ACCOUNT_SEGMENT%TYPE DEFAULT NULL,
192 p_balancing_segment IN ap_invoice_lines_interface.BALANCING_SEGMENT%TYPE DEFAULT NULL,
196 p_expenditure_type IN ap_invoice_lines_interface.EXPENDITURE_TYPE%TYPE DEFAULT NULL,
193 p_cost_center_segment IN ap_invoice_lines_interface.COST_CENTER_SEGMENT%TYPE DEFAULT NULL,
194 p_project_id IN ap_invoice_lines_interface.PROJECT_ID%TYPE DEFAULT NULL,
195 p_task_id IN ap_invoice_lines_interface.TASK_ID%TYPE DEFAULT NULL,
197 p_expenditure_item_date IN ap_invoice_lines_interface.EXPENDITURE_ITEM_DATE%TYPE DEFAULT NULL,
198 p_expenditure_organization_id IN ap_invoice_lines_interface.EXPENDITURE_ORGANIZATION_ID%TYPE DEFAULT NULL,
199 p_project_accounting_context IN ap_invoice_lines_interface.PROJECT_ACCOUNTING_CONTEXT%TYPE DEFAULT NULL,
200 p_pa_addition_flag IN ap_invoice_lines_interface.PA_ADDITION_FLAG%TYPE DEFAULT NULL,
201 p_pa_quantity IN ap_invoice_lines_interface.PA_QUANTITY%TYPE DEFAULT NULL,
202 p_ussgl_transaction_code IN ap_invoice_lines_interface.USSGL_TRANSACTION_CODE%TYPE DEFAULT NULL,
203 p_stat_amount IN ap_invoice_lines_interface.STAT_AMOUNT%TYPE DEFAULT NULL,
204 p_type_1099 IN ap_invoice_lines_interface.TYPE_1099%TYPE DEFAULT NULL,
205 p_income_tax_region IN ap_invoice_lines_interface.INCOME_TAX_REGION%TYPE DEFAULT NULL,
206 p_assets_tracking_flag IN ap_invoice_lines_interface.ASSETS_TRACKING_FLAG%TYPE DEFAULT NULL,
207 p_price_correction_flag IN ap_invoice_lines_interface.PRICE_CORRECTION_FLAG%TYPE DEFAULT NULL,
208 p_org_id IN ap_invoice_lines_interface.ORG_ID%TYPE DEFAULT NULL,
209 p_receipt_number IN ap_invoice_lines_interface.RECEIPT_NUMBER%TYPE DEFAULT NULL,
210 p_receipt_line_number IN ap_invoice_lines_interface.RECEIPT_LINE_NUMBER%TYPE DEFAULT NULL,
211 p_match_option IN ap_invoice_lines_interface.MATCH_OPTION%TYPE DEFAULT NULL,
212 p_packing_slip IN ap_invoice_lines_interface.PACKING_SLIP%TYPE DEFAULT NULL,
213 p_rcv_transaction_id IN ap_invoice_lines_interface.RCV_TRANSACTION_ID%TYPE DEFAULT NULL,
214 p_pa_cc_ar_invoice_id IN ap_invoice_lines_interface.PA_CC_AR_INVOICE_ID%TYPE DEFAULT NULL,
215 p_pa_cc_ar_invoice_line_num IN ap_invoice_lines_interface.PA_CC_AR_INVOICE_LINE_NUM%TYPE DEFAULT NULL,
216 p_reference_1 IN ap_invoice_lines_interface.REFERENCE_1%TYPE DEFAULT NULL,
217 p_reference_2 IN ap_invoice_lines_interface.REFERENCE_2%TYPE DEFAULT NULL,
218 p_pa_cc_processed_code IN ap_invoice_lines_interface.PA_CC_PROCESSED_CODE%TYPE DEFAULT NULL,
219 p_tax_recovery_rate IN ap_invoice_lines_interface.TAX_RECOVERY_RATE%TYPE DEFAULT NULL,
220 p_tax_recovery_override_flag IN ap_invoice_lines_interface.TAX_RECOVERY_OVERRIDE_FLAG%TYPE DEFAULT NULL,
221 p_tax_recoverable_flag IN ap_invoice_lines_interface.TAX_RECOVERABLE_FLAG%TYPE DEFAULT NULL,
222 p_tax_code_override_flag IN ap_invoice_lines_interface.TAX_CODE_OVERRIDE_FLAG%TYPE DEFAULT NULL,
223 p_tax_code_id IN ap_invoice_lines_interface.TAX_CODE_ID%TYPE DEFAULT NULL,
224 p_credit_card_trx_id IN ap_invoice_lines_interface.CREDIT_CARD_TRX_ID%TYPE DEFAULT NULL,
225 -- Bug 4240179. Changed data for vendor_item_num and award_id
226 -- Added by LGOPALSA
227 p_award_id IN NUMBER DEFAULT NULL,
228 p_vendor_item_num IN VARCHAR2 DEFAULT NULL,
229 p_taxable_flag IN VARCHAR2 DEFAULT NULL,
230 p_price_correct_inv_num IN VARCHAR2 DEFAULT NULL,
231 p_external_doc_line_ref IN VARCHAR2 DEFAULT NULL);
232
233 /* Brathod, For Bug# 4445989, get_apportion_factor signature is modified to use invoice_id and line_number*/
234 FUNCTION get_apportion_factor(
235 -- p_invoice_distribution_id in number
236 pn_invoice_id AP_INVOICE_LINES_ALL.INVOICE_ID%TYPE
237 , pn_invoice_line_number AP_INVOICE_LINES_ALL.LINE_NUMBER%TYPE
238 --added the foll parameter by vkarnam for bug #5989740
239 , p_factor_type varchar2 default null
240 ) return number ;
241
242 PROCEDURE submit_pla_boe_for_approval(
243 ERRBUF OUT NOCOPY VARCHAR2,
244 RETCODE OUT NOCOPY VARCHAR2,
245 p_boe_id In VARCHAR2,
246 p_set_of_books_id In Number,
247 p_prv_req_id In Number,
248 p_vendor_id In Number
249 ) ;
250
251 --As part OF R12 Inititive Inventory conversion the following code IS commented BY Ravi
252 --FUNCTION get_opm_assessable_value(p_item_id number,p_qty number,p_exted_price number,P_Cust_Id Number Default 0 ) RETURN NUMBER ;
253
254
255 PROCEDURE pan_update( P_errbuf OUT NOCOPY varchar2,
256 P_return_code OUT NOCOPY varchar2,
257 P_vendor_id in PO_VENDORS.vendor_id%TYPE ,
258 P_old_pan_num IN JAI_AP_TDS_VENDOR_HDRS.pan_no%TYPE,
259 P_new_pan_num IN JAI_AP_TDS_VENDOR_HDRS.pan_no%TYPE,
260 P_debug_flag IN varchar2
261 );
262
263 /*
264 || Added by Ramananda for bug#4584221
265 */
266
267 /* Begin 4579729 */
268
269 FUNCTION get_tds_invoice_batch(p_invoice_id IN NUMBER)
270 RETURN VARCHAR2;
271
272 procedure jai_calc_ipv_erv ( P_errmsg OUT NOCOPY VARCHAR2,
273 P_retcode OUT NOCOPY Number,
274 P_invoice_id in number,
275 P_po_dist_id in number,
276 P_invoice_distribution_id IN NUMBER,
277 P_amount IN NUMBER,
278 P_base_amount IN NUMBER,
279 P_rcv_transaction_id IN NUMBER,
280 P_invoice_price_variance IN NUMBER,
281 P_base_invoice_price_variance IN NUMBER,
282 P_price_var_ccid IN NUMBER,
283 P_Exchange_rate_variance IN NUMBER,
284 P_rate_var_ccid IN NUMBER
285 );
286
287 FUNCTION fetch_tax_target_amt
288 ( p_invoice_id IN NUMBER ,
289 p_line_location_id IN NUMBER ,
290 p_transaction_id IN NUMBER ,
291 p_parent_dist_id IN NUMBER,
292 p_tax_id IN NUMBER
293 )
294 RETURN NUMBER ;
295
296 /* End 4579729 */
297 -- Added by Jia Li for Tax inclusive computation on 2007/12/17, Begin
298 --==========================================================================
299 -- PROCEDURE NAME:
300 --
301 -- acct_inclu_taxes Public
302 --
303 -- DESCRIPTION:
304 --
305 -- This procedure is written that would pass GL entries for inclusive taxes in GL interface
306 --
307 -- PARAMETERS:
308 -- In: pn_invoice_id pass the invoice id for which the accounting needs to done
309 -- pn_invoice_distribution_id pass the invoice distribution id for the item line which the accounting needs to done
310 -- OUt: xv_process_flag Indicates the process flag, 'SS' for success
311 -- 'EE' for expected error
312 -- 'UE' for unexpected error
313 -- xv_process_message Indicates the process message
314 --
315 --
316 -- DESIGN REFERENCES:
317 -- Inclusive Tax Technical Design V1.4.doc
318 --
319 -- CHANGE HISTORY:
320 --
321 -- 17-DEC-2007 Jia Li created
322 --==========================================================================
323 PROCEDURE acct_inclu_taxes
324 ( pn_invoice_id IN NUMBER
325 , pn_invoice_distribution_id IN NUMBER
326 , xv_process_flag OUT NOCOPY VARCHAR2
327 , xv_process_message OUT NOCOPY VARCHAR2
328 );
329
330
331 END jai_ap_utils_pkg ;