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