1 PACKAGE AR_GTA_TRX_HEADERS_ALL_PKG AUTHID CURRENT_USER AS
2 --$Header: ARGUGHAS.pls 120.0.12010000.3 2010/01/19 09:07:30 choli noship $
3 --+=======================================================================+
4 --| Copyright (c) 2005 Oracle Corporation |
5 --| Redwood Shores, CA, USA |
6 --| All rights reserved. |
7 --+=======================================================================+
8 --| FILENAME |
9 --| ARUGHAS.pls |
10 --| |
11 --| DESCRIPTION |
12 --| This package provides table handers for |
16 --| AR_GTA_TRX_HEADERS_ALL |
13 --| table AR_GTA_TRX_HEADERS_ALL,these handlers |
14 --| will be called by 'Golden Tax Workbench' form and 'Golden Tax |
15 --| invoie import' program to operate data in table |
17 --| |
18 --| HISTORY |
19 --| 05/17/05 Donghai Wang Created |
20 --| 06/21/05 Jogen Hu Added procedure Query_Row |
21 --| 09/26/05 Donghai Wang Add parameters for procedures |
22 --| 'Insert_Row','Update_Row' and |
23 --| 'Lock_Row' |
24 --| 06/18/07 Donghai Wang Update G_MODULE_PREFIX to follow |
25 --| FND log standard
26 --| 01/02/07 Subba Added parameter 'Invoice_Type'to all |
27 --| procedures |
28 --| 13/Jul/2009 Allen Yang added procedure Unmerge_Row for bug 8605196: |
29 --| ENHANCEMENT FOR GOLDEN TAX ADAPTER R12.1.2
30 --| 20/Jul/2009 Yao Zhang Modifed for bug#8605196 consolidate invoice|
31 --+======================================================================*/
32
33 --Declare global variable for package name
34 G_MODULE_PREFIX VARCHAR2(50) :='ar.plsql.AR_GTA_TRX_HEADERS_ALL_PKG';
35
36 --==========================================================================
37 -- PROCEDURE NAME:
38 --
39 -- Insert_Row Public
40 --
41 -- DESCRIPTION:
42 --
43 -- This procedure is to insert data that are passed in by parameters into
44 -- table AR_GTA_TRX_HEADERS_ALL to create a new record
45 --
46 -- PARAMETERS:
47 -- In: p_ra_gl_date GL date
48 -- p_ra_gl_period GL Period
49 -- p_set_of_books_id Identifier of a GL book
50 -- p_bill_to_customer_id Identifier of bill to customer
51 -- p_bill_to_customer_number Customer number
52 -- p_bill_to_customer_name Customer name
53 -- p_source Source of GTA invoice, alternative
54 -- value is 'AR' or 'GT'
55 -- p_org_id Identifier of operating unit
56 -- p_legal_entity_id Identifier of legal entity
57 -- p_rule_header_id Identifier of transfer rule
58 -- p_gta_trx_header_id Identifier of GTA invoice header
59 -- p_gta_trx_numbe Number of GTA invoice
60 -- p_group_number Identifier of group split
61 -- p_version Version of a GTA invoice
62 -- p_latest_version_flag Flag to identify if a GTA invoice
63 -- is the one with maximum version number
64 -- p_transaction_date AR transaction date
65 -- p_ra_trx_id Identifier of AR transaction
66 -- p_ra_trx_number Number of AR transaction
67 -- p_description Description of a GTA invoice
68 -- p_customer_address Customer address
69 -- p_customer_phone Phone number of a customer
70 -- p_customer_address_phone Address and phone number of a customer
71 -- p_bank_account_name Bank account name
72 -- p_bank_account_number Bank account number
73 -- p_bank_account_name_number Bank account name and number
74 -- p_fp_tax_registration_number Tax Registration Number of First Party
75 -- p_tp_tax_registration_number Tax Registratioin Number of Third Party
76 -- p_ra_currency_code Currency code of an AR transaction
77 -- p_conversion_type Conversion type of currency
78 -- p_conversion_date Currency conversion date
79 -- p_conversion_rate exchange rate of currency
80 -- p_gta_batch_number Batch number of GTA invoices
81 -- p_gt_invoice_number GT invoice number
82 -- p_gt_invoice_date GT invoice date
83 -- p_gt_invoice_net_amount Net amount of a GT invoice
84 -- P_gt_invoice_tax_amount Tax amount of a GT invoice
85 -- p_status Status of GTA invoice or GT invoice,
86 -- acceptable values is :'DRAFT',
87 -- 'GENERATED',
88 -- 'CANCELLED',
89 -- 'FAILED',
90 -- 'COMPLETED'
91 -- p_sales_list_flag Flag to identify if a GTA invoice is
92 -- sale list enbaled
93 -- p_cancel_flag Flag to identify if a GT invoice is
94 -- Cancelled or not
95 -- p_gt_invoice_type Type of GT invoice
96 -- p_gt_invoice_class Class of GT invoice
97 -- p_gt_tax_month Tax month of GT invoice
98 -- p_issuer_name Issuer name of GT invoice
99 -- p_reviewer_name Reviewer name of GT invoice
100 -- p_payee_name Payee name of GT invoice
101 -- p_tax_code Tax code
102 -- p_generator_id Generator id
103 -- p_export_request_id Conc request id of GTA invoice
104 -- export program
105 -- p_request_id Conc request id
106 -- p_program_application_id Program application id
107 -- p_program_id Program id
111 -- p_attribute1 Attribute1
108 -- p_program_update_date Program update date
109 -- p_attribute_category Attribute category of
110 -- descriptive flexfield
112 -- p_attribute2 Attribute2
113 -- p_attribute3 Attribute3
114 -- p_attribute4 Attribute4
115 -- p_attribute5 Attribute5
116 -- p_attribute6 Attribute6
117 -- p_attribute7 Attribute7
118 -- p_attribute8 Attribute8
119 -- p_attribute9 Attribute9
120 -- p_attribute10 Attribute10
121 -- p_attribute11 Attribute11
122 -- p_attribute12 Attribute12
123 -- p_attribute13 Attribute13
124 -- p_attribute14 Attribute14
125 -- p_attribute15 Attribute15
126 -- p_creation_date Creation date
127 -- p_created_by Identifier of user that creates
128 -- the record
129 -- p_last_update_date Last update date of the record
130 -- p_last_updated_by Last update by
131 -- p_last_update_login Last update login
132 -- p_invoice_type Invoice Type
133 --
134 -- In Out: p_row_id Row id of a table record
135 --
136 --
137 -- DESIGN REFERENCES:
138 -- GTA_Workbench_Form_TD.doc
139 --
140 -- CHANGE HISTORY:
141 --
142 -- 17-MAY-2005 Donghai Wang created
143 -- 26-SEP-2005 Donghai Wang add three parameters:
144 -- p_legal_entity_id
145 -- p_fp_tax_registration_number
146 -- p_tp_tax_registration_number
147 -- 02-JAN-2008 Subba add parameter 'invoice_type'
148 -- 20-Jul-2009 Yao Zhang Modified for bug#8605196 consolidation invoices
149 --===========================================================================
150 PROCEDURE Insert_Row
151 (p_row_id IN OUT NOCOPY VARCHAR2
152 ,p_ra_gl_date IN DATE
153 ,P_ra_gl_period IN VARCHAR
154 ,p_set_of_books_id IN NUMBER
155 ,p_bill_to_customer_id IN NUMBER
156 ,p_bill_to_customer_number IN VARCHAR2
157 ,p_bill_to_customer_name IN VARCHAR2
158 ,p_source IN VARCHAR2
159 ,p_org_id IN NUMBER
160 ,p_legal_entity_id IN NUMBER
161 ,p_rule_header_id IN NUMBER
162 ,p_gta_trx_header_id IN NUMBER
163 ,p_gta_trx_number IN VARCHAR2
164 ,p_group_number IN NUMBER
165 ,p_version IN NUMBER
166 ,p_latest_version_flag IN VARCHAR2
167 ,p_transaction_date IN DATE
168 ,p_ra_trx_id IN NUMBER
169 ,p_ra_trx_number IN VARCHAR2
170 ,p_description IN VARCHAR2
171 ,p_customer_address IN VARCHAR2
172 ,p_customer_phone IN VARCHAR2
173 ,p_customer_address_phone IN VARCHAR2
174 ,p_bank_account_name IN VARCHAR2
175 ,p_bank_account_number IN VARCHAR2
176 ,p_bank_account_name_number IN VARCHAR2
177 ,p_fp_tax_registration_number IN VARCHAR2
178 ,p_tp_tax_registration_number IN VARCHAR2
179 ,p_ra_currency_code IN VARCHAR2
180 ,p_conversion_type IN VARCHAR2
181 ,p_conversion_date IN DATE
182 ,p_conversion_rate IN NUMBER
183 ,p_gta_batch_number IN VARCHAR2
184 ,p_gt_invoice_number IN VARCHAR2
185 ,p_gt_invoice_date IN DATE
186 ,p_gt_invoice_net_amount IN NUMBER
187 ,P_gt_invoice_tax_amount IN NUMBER
188 ,p_status IN VARCHAR2
189 ,p_sales_list_flag IN VARCHAR2
190 ,p_cancel_flag IN VARCHAR2
191 ,p_gt_invoice_type IN VARCHAR2
192 ,p_gt_invoice_class IN VARCHAR2
193 ,p_gt_tax_month IN VARCHAR2
194 ,p_issuer_name IN VARCHAR2
195 ,p_reviewer_name IN VARCHAR2
196 ,p_payee_name IN VARCHAR2
197 ,p_tax_code IN VARCHAR2
198 ,p_tax_rate IN NUMBER
199 ,p_generator_id IN NUMBER
200 ,p_export_request_id IN NUMBER
201 ,p_request_id IN NUMBER
202 ,p_program_application_id IN NUMBER
203 ,p_program_id IN NUMBER
204 ,p_program_update_date IN DATE
205 ,p_attribute_category IN VARCHAR2
206 ,p_attribute1 IN VARCHAR2
207 ,p_attribute2 IN VARCHAR2
208 ,p_attribute3 IN VARCHAR2
209 ,p_attribute4 IN VARCHAR2
210 ,p_attribute5 IN VARCHAR2
211 ,p_attribute6 IN VARCHAR2
212 ,p_attribute7 IN VARCHAR2
213 ,p_attribute8 IN VARCHAR2
214 ,p_attribute9 IN VARCHAR2
215 ,p_attribute10 IN VARCHAR2
216 ,p_attribute11 IN VARCHAR2
217 ,p_attribute12 IN VARCHAR2
218 ,p_attribute13 IN VARCHAR2
219 ,p_attribute14 IN VARCHAR2
223 ,p_last_update_date IN DATE
220 ,p_attribute15 IN VARCHAR2
221 ,p_creation_date IN DATE
222 ,p_created_by IN NUMBER
224 ,p_last_updated_by IN NUMBER
225 ,p_last_update_login IN NUMBER
226 ,p_invoice_type IN VARCHAR2
227 --Yao Zhang add begin for bug#8605196 consolidation invoices
228 ,p_consolidation_id IN NUMBER
229 ,p_consolidation_flag IN VARCHAR2
230 ,p_consolidation_trx_num IN VARCHAR2
231 --Yao Zhang add end for bug#8605196 consolidation invoices
232 );
233
234
235 --==========================================================================
236 -- PROCEDURE NAME:
237 --
238 -- Update_Row Public
239 --
240 -- DESCRIPTION:
241 --
242 -- This procedure is used to update data in table AR_GTA_TRX_HEADERS_ALL
243 -- according to parameters passed in
244 --
245 -- PARAMETERS:
246 -- In: p_ra_gl_date GL date
247 -- p_ra_gl_period GL Period
248 -- p_set_of_books_id Identifier of a GL book
249 -- p_bill_to_customer_id Identifier of bill to customer
250 -- p_bill_to_customer_number Customer number
251 -- p_bill_to_customer_name Customer name
252 -- p_source Source of GTA invoice, alternative
253 -- value is 'AR' or 'GT'
254 -- p_org_id Identifier of operating unit
255 -- p_legal_entity_id Identifier of legal entity id
256 -- p_rule_header_id Identifier of transfer rule
257 -- p_gta_trx_header_id Identifier of GTA invoice header
258 -- p_gta_trx_numbe Number of GTA invoice
259 -- p_group_number Identifier of group split
260 -- p_version Version of a GTA invoice
261 -- p_latest_version_flag Flag to identify if a GTA invoice
262 -- is the one with maximum version number
263 -- p_transaction_date AR transaction date
264 -- p_ra_trx_id Identifier of AR transaction
265 -- p_ra_trx_number Number of AR transaction
266 -- p_description Description of a GTA invoice
267 -- p_customer_address Customer address
268 -- p_customer_phone Phone number of a customer
269 -- p_customer_address_phone Address and phone number of a customer
270 -- p_bank_account_name Bank account name
271 -- p_bank_account_number Bank account number
272 -- p_bank_account_name_number Bank account name and number
273 -- p_fp_tax_registration_number Tax Registration Number of First Party
274 -- p_tp_tax_registration_number Tax Registration Number of Third Party
275 -- p_ra_currency_code Currency code of an AR transaction
276 -- p_conversion_type Conversion type of currency
277 -- p_conversion_date Currency conversion date
278 -- p_conversion_rate Exchange rate of currency
279 -- p_gta_batch_number Batch number of GTA invoices
280 -- p_gt_invoice_number GT invoice number
281 -- p_gt_invoice_date GT invoice date
282 -- p_gt_invoice_net_amount Net amount of a GT invoice
283 -- P_gt_invoice_tax_amount Tax amount of a GT invoice
284 -- p_status Status of GTA invoice or GT invoice,
285 -- acceptable values is :'DRAFT',
286 -- 'GENERATED',
287 -- 'CANCELLED',
288 -- 'FAILED',
289 -- 'COMPLETED'
290 -- p_sales_list_flag Flag to identify if a GTA invoice is
291 -- sale list enbaled
292 -- p_cancel_flag Flag to identify if a GT invoice is
293 -- Cancelled or not
294 -- p_gt_invoice_type Type of GT invoice
295 -- p_gt_invoice_class Class of GT invoice
296 -- p_gt_tax_month Tax month of GT invoice
297 -- p_issuer_name Issuer name of GT invoice
298 -- p_reviewer_name Reviewer name of GT invoice
299 -- p_payee_name Payee name of GT invoice
300 -- p_tax_code Tax code
301 -- p_generator_id Generator id
302 -- p_export_request_id Conc request id of GTA invoice
303 -- export program
304 -- p_request_id Conc request id
305 -- p_program_application_id Program application id
306 -- p_program_id Program id
307 -- p_program_update_date Program update date
308 -- p_attribute_category Attribute category of
309 -- descriptive flexfield
310 -- p_attribute1 Attribute1
311 -- p_attribute2 Attribute2
312 -- p_attribute3 Attribute3
313 -- p_attribute4 Attribute4
314 -- p_attribute5 Attribute5
315 -- p_attribute6 Attribute6
316 -- p_attribute7 Attribute7
317 -- p_attribute8 Attribute8
321 -- p_attribute12 Attribute12
318 -- p_attribute9 Attribute9
319 -- p_attribute10 Attribute10
320 -- p_attribute11 Attribute11
322 -- p_attribute13 Attribute13
323 -- p_attribute14 Attribute14
324 -- p_attribute15 Attribute15
325 -- p_creation_date Creation date
326 -- p_created_by Identifier of user that creates
327 -- the record
328 -- p_last_update_date Last update date of the record
329 -- p_last_updated_by Last update by
330 -- p_last_update_login Last update login
331 -- p_invoice_type Invoice type
332 --
333 -- In Out: p_row_id Row id of a table record
334 --
335 --
336 -- DESIGN REFERENCES:
337 -- GTA_Workbench_Form_TD.doc
338 --
339 -- CHANGE HISTORY:
340 --
341 -- 17-MAY-2005 Donghai Wang created
342 -- 26-SEP-2005 Donghai Wang add three parameters:
343 -- p_legal_entity_id
344 -- p_fp_tax_registration_number
345 -- p_tp_tax_registration_number
346 -- 02-JAN-2008 Subba add parameter invoice_type
347 --===========================================================================
348 PROCEDURE Update_Row
349 (p_row_id IN OUT NOCOPY VARCHAR2
350 ,p_ra_gl_date IN DATE
351 ,P_ra_gl_period IN VARCHAR
352 ,p_set_of_books_id IN NUMBER
353 ,p_bill_to_customer_id IN NUMBER
354 ,p_bill_to_customer_number IN VARCHAR2
355 ,p_bill_to_customer_name IN VARCHAR2
356 ,p_source IN VARCHAR2
357 ,p_org_id IN NUMBER
358 ,p_legal_entity_id IN NUMBER
359 ,p_rule_header_id IN NUMBER
360 ,p_gta_trx_header_id IN NUMBER
361 ,p_gta_trx_number IN VARCHAR2
362 ,p_group_number IN NUMBER
363 ,p_version IN NUMBER
364 ,p_latest_version_flag IN VARCHAR2
365 ,p_transaction_date IN DATE
366 ,p_ra_trx_id IN NUMBER
367 ,p_ra_trx_number IN VARCHAR2
368 ,p_description IN VARCHAR2
369 ,p_customer_address IN VARCHAR2
370 ,p_customer_phone IN VARCHAR2
371 ,p_customer_address_phone IN VARCHAR2
372 ,p_bank_account_name IN VARCHAR2
373 ,p_bank_account_number IN VARCHAR2
374 ,p_bank_account_name_number IN VARCHAR2
375 ,p_fp_tax_registration_number IN VARCHAR2
376 ,p_tp_tax_registration_number IN VARCHAR2
377 ,p_ra_currency_code IN VARCHAR2
378 ,p_conversion_type IN VARCHAR2
379 ,p_conversion_date IN DATE
380 ,p_conversion_rate IN NUMBER
381 ,p_gta_batch_number IN VARCHAR2
382 ,p_gt_invoice_number IN VARCHAR2
383 ,p_gt_invoice_date IN DATE
384 ,p_gt_invoice_net_amount IN NUMBER
385 ,P_gt_invoice_tax_amount IN NUMBER
386 ,p_status IN VARCHAR2
387 ,p_sales_list_flag IN VARCHAR2
388 ,p_cancel_flag IN VARCHAR2
389 ,p_gt_invoice_type IN VARCHAR2
390 ,p_gt_invoice_class IN VARCHAR2
391 ,p_gt_tax_month IN VARCHAR2
392 ,p_issuer_name IN VARCHAR2
393 ,p_reviewer_name IN VARCHAR2
394 ,p_payee_name IN VARCHAR2
395 ,p_tax_code IN VARCHAR2
396 ,p_tax_rate IN NUMBER
397 ,p_generator_id IN NUMBER
398 ,p_export_request_id IN NUMBER
399 ,p_request_id IN NUMBER
400 ,p_program_application_id IN NUMBER
401 ,p_program_id IN NUMBER
402 ,p_program_update_date IN DATE
403 ,p_attribute_category IN VARCHAR2
404 ,p_attribute1 IN VARCHAR2
405 ,p_attribute2 IN VARCHAR2
406 ,p_attribute3 IN VARCHAR2
407 ,p_attribute4 IN VARCHAR2
408 ,p_attribute5 IN VARCHAR2
409 ,p_attribute6 IN VARCHAR2
410 ,p_attribute7 IN VARCHAR2
411 ,p_attribute8 IN VARCHAR2
412 ,p_attribute9 IN VARCHAR2
413 ,p_attribute10 IN VARCHAR2
414 ,p_attribute11 IN VARCHAR2
415 ,p_attribute12 IN VARCHAR2
416 ,p_attribute13 IN VARCHAR2
417 ,p_attribute14 IN VARCHAR2
418 ,p_attribute15 IN VARCHAR2
419 ,p_creation_date IN DATE
420 ,p_created_by IN NUMBER
421 ,p_last_update_date IN DATE
422 ,p_last_updated_by IN NUMBER
423 ,p_last_update_login IN NUMBER
424 ,p_invoice_type IN VARCHAR2
425 );
426
427 --==========================================================================
428 -- PROCEDURE NAME:
429 --
430 -- Lock_Row Public
431 --
432 -- DESCRIPTION:
433 --
434 -- This procedure is used to update implement lock on row level on table
435 -- AR_GTA_TRX_HEADERS_ALL
436 --
437 -- PARAMETERS:
438 -- In: p_ra_gl_date GL date
439 -- p_ra_gl_period GL Period
440 -- p_set_of_books_id Identifier of a GL book
441 -- p_bill_to_customer_id Identifier of bill to customer
442 -- p_bill_to_customer_number Customer number
443 -- p_bill_to_customer_name Customer name
447 -- p_legal_entity_id Idnetifier of Legal Entity
444 -- p_source Source of GTA invoice, alternative
445 -- value is 'AR' or 'GT'
446 -- p_org_id Identifier of operating unit
448 -- p_rule_header_id Identifier of transfer rule
449 -- p_gta_trx_header_id identifier of GTA invoice header
450 -- p_gta_trx_numbe Number of GTA invoice
451 -- p_group_number Identifier of group split
452 -- p_version Version of a GTA invoice
453 -- p_latest_version_flag Flag to identify if a GTA invoice
454 -- is the one with maximum version number
455 -- p_transaction_date AR transaction date
456 -- p_ra_trx_id Identifier of AR transaction
457 -- p_ra_trx_number Number of AR transaction
458 -- p_description Description of a GTA invoice
459 -- p_customer_address Customer address
460 -- p_customer_phone Phone number of a customer
461 -- p_customer_address_phone Address and phone number of a customer
462 -- p_bank_account_name Bank account name
463 -- p_bank_account_number Bank account number
464 -- p_bank_account_name_number Bank account name and number
465 -- p_fp_tax_registration_number Tax Registration Number of First Party
466 -- p_tp_tax_registration_number Tax Registration Number of Third Party
467 -- p_ra_currency_code Currency code of an AR transaction
468 -- p_conversion_type Conversion type of currency
469 -- p_conversion_date Currency conversion date
470 -- p_conversion_rate Exchange rate of currency
471 -- p_gta_batch_number Batch number of GTA invoices
472 -- p_gt_invoice_number GT invoice number
473 -- p_gt_invoice_date GT invoice date
474 -- p_gt_invoice_net_amount Net amount of a GT invoice
475 -- P_gt_invoice_tax_amount Tax amount of a GT invoice
476 -- p_status Status of GTA invoice or GT invoice,
477 -- acceptable values is :'DRAFT',
478 -- 'GENERATED',
479 -- 'CANCELLED',
480 -- 'FAILED',
481 -- 'COMPLETED'
482 -- p_sales_list_flag Flag to identify if a GTA invoice is
483 -- sale list enbaled
484 -- p_cancel_flag Flag to identify if a GT invoice is
485 -- Cancelled or not
486 -- p_gt_invoice_type Type of GT invoice
487 -- p_gt_invoice_class Class of GT invoice
488 -- p_gt_tax_month Tax month of GT invoice
489 -- p_issuer_name Issuer name of GT invoice
490 -- p_reviewer_name Reviewer name of GT invoice
491 -- p_payee_name Payee name of GT invoice
492 -- p_tax_code Tax code
493 -- p_generator_id Generator id
494 -- p_export_request_id Conc request id of GTA invoice
495 -- export program
496 -- p_request_id Conc request id
497 -- p_program_application_id Program application id
498 -- p_program_id Program id
499 -- p_program_update_date Program update date
500 -- p_attribute_category Attribute category of
501 -- descriptive flexfield
502 -- p_attribute1 Attribute1
503 -- p_attribute2 Attribute2
504 -- p_attribute3 Attribute3
505 -- p_attribute4 Attribute4
506 -- p_attribute5 Attribute5
507 -- p_attribute6 Attribute6
508 -- p_attribute7 Attribute7
509 -- p_attribute8 Attribute8
510 -- p_attribute9 Attribute9
511 -- p_attribute10 Attribute10
512 -- p_attribute11 Attribute11
513 -- p_attribute12 Attribute12
514 -- p_attribute13 Attribute13
515 -- p_attribute14 Attribute14
516 -- p_attribute15 Attribute15
517 -- p_creation_date Creation date
518 -- p_created_by Identifier of user that creates
519 -- the record
520 -- p_last_update_date Last update date of the record
521 -- p_last_updated_by Last update by
522 -- p_last_update_login Last update login
523 -- p_invoice_type Invoice type
524 --
525 -- In Out: p_row_id Row id of a table record
526 --
527 --
528 -- DESIGN REFERENCES:
529 -- GTA_Workbench_Form_TD.doc
530 --
531 -- CHANGE HISTORY:
532 --
533 -- 17-MAY-2005 Donghai Wang created
534 -- 26-SEP-2005 Donghai Wang add three parameters:
535 -- p_legal_entity_id
536 -- p_fp_tax_registration_number
540 PROCEDURE Lock_Row
537 -- p_tp_tax_registration_number
538 -- 02-JAN-2008 Subba add parameter invoice_type
539 --===========================================================================
541 (p_row_id IN OUT NOCOPY VARCHAR2
542 ,p_ra_gl_date IN DATE
543 ,P_ra_gl_period IN VARCHAR
544 ,p_set_of_books_id IN NUMBER
545 ,p_bill_to_customer_id IN NUMBER
546 ,p_bill_to_customer_number IN VARCHAR2
547 ,p_bill_to_customer_name IN VARCHAR2
548 ,p_source IN VARCHAR2
549 ,p_org_id IN NUMBER
550 ,p_legal_entity_id IN NUMBER
551 ,p_rule_header_id IN NUMBER
552 ,p_gta_trx_header_id IN NUMBER
553 ,p_gta_trx_number IN VARCHAR2
554 ,p_group_number IN NUMBER
555 ,p_version IN NUMBER
556 ,p_latest_version_flag IN VARCHAR2
557 ,p_transaction_date IN DATE
558 ,p_ra_trx_id IN NUMBER
559 ,p_ra_trx_number IN VARCHAR2
560 ,p_description IN VARCHAR2
561 ,p_customer_address IN VARCHAR2
562 ,p_customer_phone IN VARCHAR2
563 ,p_customer_address_phone IN VARCHAR2
564 ,p_bank_account_name IN VARCHAR2
565 ,p_bank_account_number IN VARCHAR2
566 ,p_bank_account_name_number IN VARCHAR2
567 ,p_fp_tax_registration_number IN VARCHAR2
568 ,p_tp_tax_registration_number IN VARCHAR2
569 ,p_ra_currency_code IN VARCHAR2
570 ,p_conversion_type IN VARCHAR2
571 ,p_conversion_date IN DATE
572 ,p_conversion_rate IN NUMBER
573 ,p_gta_batch_number IN VARCHAR2
574 ,p_gt_invoice_number IN VARCHAR2
575 ,p_gt_invoice_date IN DATE
576 ,p_gt_invoice_net_amount IN NUMBER
577 ,P_gt_invoice_tax_amount IN NUMBER
578 ,p_status IN VARCHAR2
579 ,p_sales_list_flag IN VARCHAR2
580 ,p_cancel_flag IN VARCHAR2
581 ,p_gt_invoice_type IN VARCHAR2
582 ,p_gt_invoice_class IN VARCHAR2
583 ,p_gt_tax_month IN VARCHAR2
584 ,p_issuer_name IN VARCHAR2
585 ,p_reviewer_name IN VARCHAR2
586 ,p_payee_name IN VARCHAR2
587 ,p_tax_code IN VARCHAR2
588 ,p_tax_rate IN NUMBER
589 ,p_generator_id IN NUMBER
590 ,p_export_request_id IN NUMBER
591 ,p_request_id IN NUMBER
592 ,p_program_application_id IN NUMBER
593 ,p_program_id IN NUMBER
594 ,p_program_update_date IN DATE
595 ,p_attribute_category IN VARCHAR2
596 ,p_attribute1 IN VARCHAR2
597 ,p_attribute2 IN VARCHAR2
598 ,p_attribute3 IN VARCHAR2
599 ,p_attribute4 IN VARCHAR2
600 ,p_attribute5 IN VARCHAR2
601 ,p_attribute6 IN VARCHAR2
602 ,p_attribute7 IN VARCHAR2
603 ,p_attribute8 IN VARCHAR2
604 ,p_attribute9 IN VARCHAR2
605 ,p_attribute10 IN VARCHAR2
606 ,p_attribute11 IN VARCHAR2
607 ,p_attribute12 IN VARCHAR2
608 ,p_attribute13 IN VARCHAR2
609 ,p_attribute14 IN VARCHAR2
610 ,p_attribute15 IN VARCHAR2
611 ,p_creation_date IN DATE
612 ,p_created_by IN NUMBER
613 ,p_last_update_date IN DATE
614 ,p_last_updated_by IN NUMBER
615 ,p_last_update_login IN NUMBER
616 ,p_invoice_type IN VARCHAR2
617 );
618
619 --==========================================================================
620 -- PROCEDURE NAME:
621 --
622 -- Delete_Row Public
623 --
624 -- DESCRIPTION:
625 --
626 -- This procedure is used to delete record from table
627 -- AR_GTA_TRX_HEADERS_ALL
628 --
629 -- PARAMETERS:
630 --
631 -- In Out: p_row_id Row id of a table record
632 --
633 --
634 -- DESIGN REFERENCES:
635 -- GTA_Workbench_Form_TD.doc
636 --
637 -- CHANGE HISTORY:
638 --
639 -- 17-MAY-2005 Donghai Wang created
640 --
641 --===========================================================================
642 PROCEDURE Delete_Row
643 (p_rowid IN OUT NOCOPY VARCHAR2
644 );
645
646 --==========================================================================
647 -- PROCEDURE NAME:
648 --
649 -- Query_Row Public
650 --
651 -- DESCRIPTION:
652 --
653 -- This procedure is used to retrieve record by parameter p_header
654 -- from table AR_GTA_TRX_HEADERS_ALL
655 --
656 -- PARAMETERS:
657 -- In: p_header_id Identifier of GTA invoice header
658 --
659 -- Out: x_trx_header_rec record to store a row fetched from
660 -- table AR_GTA_TRX_HEADERS_ALL
661 --
662 --
663 -- DESIGN REFERENCES:
664 -- GTA-Txt-Interface-TD.doc
665 --
666 -- CHANGE HISTORY:
667 --
668 -- 21-Jun-2005 Jogen Hu created
669 --
670 --===========================================================================
671 PROCEDURE Query_Row
672 ( p_header_id IN NUMBER
673 , x_trx_header_rec OUT NOCOPY AR_GTA_TRX_UTIL.Trx_Header_Rec_Type
674 );
675
676 --==========================================================================
677 -- PROCEDURE NAME:
678 --
679 -- Unmerge_Row Public
680 --
681 -- DESCRIPTION:
682 --
683 -- This procedure is to delete current consolidation invoice and
684 -- change status of its consolidated invoices to 'DRAFT'.
685 --
686 --
687 -- PARAMETERS:
688 --
689 -- In Out: p_rowid Row id of a table record
690 --
691 --
692 -- DESIGN REFERENCES:
693 -- GTA_12.1.2_Technical_Design.doc
694 --
695 -- CHANGE HISTORY:
696 --
697 -- 13-Jul-2009 Allen Yang created
698 --
699 --===========================================================================
700 PROCEDURE Unmerge_Row
701 (p_rowid IN OUT NOCOPY VARCHAR2
702 );
703 END AR_GTA_TRX_HEADERS_ALL_PKG;
704
[Home] [Help]