eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FUN_WEBADI_PKG dependencies on FUN_INTERFACE_HEADERS

Line 5: p_recipient_name In Fun_Interface_Headers.recipient_name%type,

1: Package Body FUN_WEBADI_PKG As
2: -- $Header: funwadib.pls 120.13.12010000.3 2008/09/02 07:49:31 srampure ship $
3:
4: Procedure Insert_Header(
5: p_recipient_name In Fun_Interface_Headers.recipient_name%type,
6: p_to_le_name In Fun_Interface_Headers.to_le_name%type,
7: p_trx_tbl In FUN_TRX_PUB.full_trx_tbl_type) Is
8: Begin
9: If p_trx_tbl.count = 1 Then

Line 6: p_to_le_name In Fun_Interface_Headers.to_le_name%type,

2: -- $Header: funwadib.pls 120.13.12010000.3 2008/09/02 07:49:31 srampure ship $
3:
4: Procedure Insert_Header(
5: p_recipient_name In Fun_Interface_Headers.recipient_name%type,
6: p_to_le_name In Fun_Interface_Headers.to_le_name%type,
7: p_trx_tbl In FUN_TRX_PUB.full_trx_tbl_type) Is
8: Begin
9: If p_trx_tbl.count = 1 Then
10: Insert Into Fun_Interface_Headers(

Line 10: Insert Into Fun_Interface_Headers(

6: p_to_le_name In Fun_Interface_Headers.to_le_name%type,
7: p_trx_tbl In FUN_TRX_PUB.full_trx_tbl_type) Is
8: Begin
9: If p_trx_tbl.count = 1 Then
10: Insert Into Fun_Interface_Headers(
11: trx_id,
12: trx_number,
13: recipient_id,
14: recipient_name,

Line 167: p_from_le_name In Fun_Interface_Headers.to_le_name%type,

163: Procedure Insert_Batch(
164: p_batch_rec In FUN_TRX_PUB.full_batch_rec_type,
165: p_initiator_name In Fun_Interface_Batches.initiator_name%type,
166: p_trx_type_name In Fun_Interface_Batches.trx_type_name%type,
167: p_from_le_name In Fun_Interface_Headers.to_le_name%type,
168: p_insert_flag In Varchar2) Is
169:
170: l_group_id NUMBER;
171: Begin

Line 592: p_trx_number In Fun_Interface_Headers.trx_number%type,

588: p_attribute13 In Fun_Interface_Batches.attribute13%type,
589: p_attribute14 In Fun_Interface_Batches.attribute14%type,
590: p_attribute15 In Fun_Interface_Batches.attribute15%type,
591: p_attribute_category In Fun_Interface_Batches.attribute_category%type,
592: p_trx_number In Fun_Interface_Headers.trx_number%type,
593: p_recipient_name In Fun_Interface_Headers.recipient_name%type,
594: p_init_amount_dr In Fun_Interface_Headers.init_amount_dr%type,
595: p_init_amount_cr In Fun_Interface_Headers.init_amount_cr%type,
596: p_h_attribute1 In Fun_Interface_Headers.attribute1%type,

Line 593: p_recipient_name In Fun_Interface_Headers.recipient_name%type,

589: p_attribute14 In Fun_Interface_Batches.attribute14%type,
590: p_attribute15 In Fun_Interface_Batches.attribute15%type,
591: p_attribute_category In Fun_Interface_Batches.attribute_category%type,
592: p_trx_number In Fun_Interface_Headers.trx_number%type,
593: p_recipient_name In Fun_Interface_Headers.recipient_name%type,
594: p_init_amount_dr In Fun_Interface_Headers.init_amount_dr%type,
595: p_init_amount_cr In Fun_Interface_Headers.init_amount_cr%type,
596: p_h_attribute1 In Fun_Interface_Headers.attribute1%type,
597: p_h_attribute2 In Fun_Interface_Headers.attribute2%type,

Line 594: p_init_amount_dr In Fun_Interface_Headers.init_amount_dr%type,

590: p_attribute15 In Fun_Interface_Batches.attribute15%type,
591: p_attribute_category In Fun_Interface_Batches.attribute_category%type,
592: p_trx_number In Fun_Interface_Headers.trx_number%type,
593: p_recipient_name In Fun_Interface_Headers.recipient_name%type,
594: p_init_amount_dr In Fun_Interface_Headers.init_amount_dr%type,
595: p_init_amount_cr In Fun_Interface_Headers.init_amount_cr%type,
596: p_h_attribute1 In Fun_Interface_Headers.attribute1%type,
597: p_h_attribute2 In Fun_Interface_Headers.attribute2%type,
598: p_h_attribute3 In Fun_Interface_Headers.attribute3%type,

Line 595: p_init_amount_cr In Fun_Interface_Headers.init_amount_cr%type,

591: p_attribute_category In Fun_Interface_Batches.attribute_category%type,
592: p_trx_number In Fun_Interface_Headers.trx_number%type,
593: p_recipient_name In Fun_Interface_Headers.recipient_name%type,
594: p_init_amount_dr In Fun_Interface_Headers.init_amount_dr%type,
595: p_init_amount_cr In Fun_Interface_Headers.init_amount_cr%type,
596: p_h_attribute1 In Fun_Interface_Headers.attribute1%type,
597: p_h_attribute2 In Fun_Interface_Headers.attribute2%type,
598: p_h_attribute3 In Fun_Interface_Headers.attribute3%type,
599: p_h_attribute4 In Fun_Interface_Headers.attribute4%type,

Line 596: p_h_attribute1 In Fun_Interface_Headers.attribute1%type,

592: p_trx_number In Fun_Interface_Headers.trx_number%type,
593: p_recipient_name In Fun_Interface_Headers.recipient_name%type,
594: p_init_amount_dr In Fun_Interface_Headers.init_amount_dr%type,
595: p_init_amount_cr In Fun_Interface_Headers.init_amount_cr%type,
596: p_h_attribute1 In Fun_Interface_Headers.attribute1%type,
597: p_h_attribute2 In Fun_Interface_Headers.attribute2%type,
598: p_h_attribute3 In Fun_Interface_Headers.attribute3%type,
599: p_h_attribute4 In Fun_Interface_Headers.attribute4%type,
600: p_h_attribute5 In Fun_Interface_Headers.attribute5%type,

Line 597: p_h_attribute2 In Fun_Interface_Headers.attribute2%type,

593: p_recipient_name In Fun_Interface_Headers.recipient_name%type,
594: p_init_amount_dr In Fun_Interface_Headers.init_amount_dr%type,
595: p_init_amount_cr In Fun_Interface_Headers.init_amount_cr%type,
596: p_h_attribute1 In Fun_Interface_Headers.attribute1%type,
597: p_h_attribute2 In Fun_Interface_Headers.attribute2%type,
598: p_h_attribute3 In Fun_Interface_Headers.attribute3%type,
599: p_h_attribute4 In Fun_Interface_Headers.attribute4%type,
600: p_h_attribute5 In Fun_Interface_Headers.attribute5%type,
601: p_h_attribute6 In Fun_Interface_Headers.attribute6%type,

Line 598: p_h_attribute3 In Fun_Interface_Headers.attribute3%type,

594: p_init_amount_dr In Fun_Interface_Headers.init_amount_dr%type,
595: p_init_amount_cr In Fun_Interface_Headers.init_amount_cr%type,
596: p_h_attribute1 In Fun_Interface_Headers.attribute1%type,
597: p_h_attribute2 In Fun_Interface_Headers.attribute2%type,
598: p_h_attribute3 In Fun_Interface_Headers.attribute3%type,
599: p_h_attribute4 In Fun_Interface_Headers.attribute4%type,
600: p_h_attribute5 In Fun_Interface_Headers.attribute5%type,
601: p_h_attribute6 In Fun_Interface_Headers.attribute6%type,
602: p_h_attribute7 In Fun_Interface_Headers.attribute7%type,

Line 599: p_h_attribute4 In Fun_Interface_Headers.attribute4%type,

595: p_init_amount_cr In Fun_Interface_Headers.init_amount_cr%type,
596: p_h_attribute1 In Fun_Interface_Headers.attribute1%type,
597: p_h_attribute2 In Fun_Interface_Headers.attribute2%type,
598: p_h_attribute3 In Fun_Interface_Headers.attribute3%type,
599: p_h_attribute4 In Fun_Interface_Headers.attribute4%type,
600: p_h_attribute5 In Fun_Interface_Headers.attribute5%type,
601: p_h_attribute6 In Fun_Interface_Headers.attribute6%type,
602: p_h_attribute7 In Fun_Interface_Headers.attribute7%type,
603: p_h_attribute8 In Fun_Interface_Headers.attribute8%type,

Line 600: p_h_attribute5 In Fun_Interface_Headers.attribute5%type,

596: p_h_attribute1 In Fun_Interface_Headers.attribute1%type,
597: p_h_attribute2 In Fun_Interface_Headers.attribute2%type,
598: p_h_attribute3 In Fun_Interface_Headers.attribute3%type,
599: p_h_attribute4 In Fun_Interface_Headers.attribute4%type,
600: p_h_attribute5 In Fun_Interface_Headers.attribute5%type,
601: p_h_attribute6 In Fun_Interface_Headers.attribute6%type,
602: p_h_attribute7 In Fun_Interface_Headers.attribute7%type,
603: p_h_attribute8 In Fun_Interface_Headers.attribute8%type,
604: p_h_attribute9 In Fun_Interface_Headers.attribute9%type,

Line 601: p_h_attribute6 In Fun_Interface_Headers.attribute6%type,

597: p_h_attribute2 In Fun_Interface_Headers.attribute2%type,
598: p_h_attribute3 In Fun_Interface_Headers.attribute3%type,
599: p_h_attribute4 In Fun_Interface_Headers.attribute4%type,
600: p_h_attribute5 In Fun_Interface_Headers.attribute5%type,
601: p_h_attribute6 In Fun_Interface_Headers.attribute6%type,
602: p_h_attribute7 In Fun_Interface_Headers.attribute7%type,
603: p_h_attribute8 In Fun_Interface_Headers.attribute8%type,
604: p_h_attribute9 In Fun_Interface_Headers.attribute9%type,
605: p_h_attribute10 In Fun_Interface_Headers.attribute10%type,

Line 602: p_h_attribute7 In Fun_Interface_Headers.attribute7%type,

598: p_h_attribute3 In Fun_Interface_Headers.attribute3%type,
599: p_h_attribute4 In Fun_Interface_Headers.attribute4%type,
600: p_h_attribute5 In Fun_Interface_Headers.attribute5%type,
601: p_h_attribute6 In Fun_Interface_Headers.attribute6%type,
602: p_h_attribute7 In Fun_Interface_Headers.attribute7%type,
603: p_h_attribute8 In Fun_Interface_Headers.attribute8%type,
604: p_h_attribute9 In Fun_Interface_Headers.attribute9%type,
605: p_h_attribute10 In Fun_Interface_Headers.attribute10%type,
606: p_h_attribute11 In Fun_Interface_Headers.attribute11%type,

Line 603: p_h_attribute8 In Fun_Interface_Headers.attribute8%type,

599: p_h_attribute4 In Fun_Interface_Headers.attribute4%type,
600: p_h_attribute5 In Fun_Interface_Headers.attribute5%type,
601: p_h_attribute6 In Fun_Interface_Headers.attribute6%type,
602: p_h_attribute7 In Fun_Interface_Headers.attribute7%type,
603: p_h_attribute8 In Fun_Interface_Headers.attribute8%type,
604: p_h_attribute9 In Fun_Interface_Headers.attribute9%type,
605: p_h_attribute10 In Fun_Interface_Headers.attribute10%type,
606: p_h_attribute11 In Fun_Interface_Headers.attribute11%type,
607: p_h_attribute12 In Fun_Interface_Headers.attribute12%type,

Line 604: p_h_attribute9 In Fun_Interface_Headers.attribute9%type,

600: p_h_attribute5 In Fun_Interface_Headers.attribute5%type,
601: p_h_attribute6 In Fun_Interface_Headers.attribute6%type,
602: p_h_attribute7 In Fun_Interface_Headers.attribute7%type,
603: p_h_attribute8 In Fun_Interface_Headers.attribute8%type,
604: p_h_attribute9 In Fun_Interface_Headers.attribute9%type,
605: p_h_attribute10 In Fun_Interface_Headers.attribute10%type,
606: p_h_attribute11 In Fun_Interface_Headers.attribute11%type,
607: p_h_attribute12 In Fun_Interface_Headers.attribute12%type,
608: p_h_attribute13 In Fun_Interface_Headers.attribute13%type,

Line 605: p_h_attribute10 In Fun_Interface_Headers.attribute10%type,

601: p_h_attribute6 In Fun_Interface_Headers.attribute6%type,
602: p_h_attribute7 In Fun_Interface_Headers.attribute7%type,
603: p_h_attribute8 In Fun_Interface_Headers.attribute8%type,
604: p_h_attribute9 In Fun_Interface_Headers.attribute9%type,
605: p_h_attribute10 In Fun_Interface_Headers.attribute10%type,
606: p_h_attribute11 In Fun_Interface_Headers.attribute11%type,
607: p_h_attribute12 In Fun_Interface_Headers.attribute12%type,
608: p_h_attribute13 In Fun_Interface_Headers.attribute13%type,
609: p_h_attribute14 In Fun_Interface_Headers.attribute14%type,

Line 606: p_h_attribute11 In Fun_Interface_Headers.attribute11%type,

602: p_h_attribute7 In Fun_Interface_Headers.attribute7%type,
603: p_h_attribute8 In Fun_Interface_Headers.attribute8%type,
604: p_h_attribute9 In Fun_Interface_Headers.attribute9%type,
605: p_h_attribute10 In Fun_Interface_Headers.attribute10%type,
606: p_h_attribute11 In Fun_Interface_Headers.attribute11%type,
607: p_h_attribute12 In Fun_Interface_Headers.attribute12%type,
608: p_h_attribute13 In Fun_Interface_Headers.attribute13%type,
609: p_h_attribute14 In Fun_Interface_Headers.attribute14%type,
610: p_h_attribute15 In Fun_Interface_Headers.attribute15%type,

Line 607: p_h_attribute12 In Fun_Interface_Headers.attribute12%type,

603: p_h_attribute8 In Fun_Interface_Headers.attribute8%type,
604: p_h_attribute9 In Fun_Interface_Headers.attribute9%type,
605: p_h_attribute10 In Fun_Interface_Headers.attribute10%type,
606: p_h_attribute11 In Fun_Interface_Headers.attribute11%type,
607: p_h_attribute12 In Fun_Interface_Headers.attribute12%type,
608: p_h_attribute13 In Fun_Interface_Headers.attribute13%type,
609: p_h_attribute14 In Fun_Interface_Headers.attribute14%type,
610: p_h_attribute15 In Fun_Interface_Headers.attribute15%type,
611: p_h_attribute_category In Fun_Interface_Headers.attribute_category%type,

Line 608: p_h_attribute13 In Fun_Interface_Headers.attribute13%type,

604: p_h_attribute9 In Fun_Interface_Headers.attribute9%type,
605: p_h_attribute10 In Fun_Interface_Headers.attribute10%type,
606: p_h_attribute11 In Fun_Interface_Headers.attribute11%type,
607: p_h_attribute12 In Fun_Interface_Headers.attribute12%type,
608: p_h_attribute13 In Fun_Interface_Headers.attribute13%type,
609: p_h_attribute14 In Fun_Interface_Headers.attribute14%type,
610: p_h_attribute15 In Fun_Interface_Headers.attribute15%type,
611: p_h_attribute_category In Fun_Interface_Headers.attribute_category%type,
612: p_id_ccid In Fun_Interface_Dist_Lines.ccid%type,

Line 609: p_h_attribute14 In Fun_Interface_Headers.attribute14%type,

605: p_h_attribute10 In Fun_Interface_Headers.attribute10%type,
606: p_h_attribute11 In Fun_Interface_Headers.attribute11%type,
607: p_h_attribute12 In Fun_Interface_Headers.attribute12%type,
608: p_h_attribute13 In Fun_Interface_Headers.attribute13%type,
609: p_h_attribute14 In Fun_Interface_Headers.attribute14%type,
610: p_h_attribute15 In Fun_Interface_Headers.attribute15%type,
611: p_h_attribute_category In Fun_Interface_Headers.attribute_category%type,
612: p_id_ccid In Fun_Interface_Dist_Lines.ccid%type,
613: p_id_amount_dr In Fun_Interface_Dist_Lines.amount_dr%type,

Line 610: p_h_attribute15 In Fun_Interface_Headers.attribute15%type,

606: p_h_attribute11 In Fun_Interface_Headers.attribute11%type,
607: p_h_attribute12 In Fun_Interface_Headers.attribute12%type,
608: p_h_attribute13 In Fun_Interface_Headers.attribute13%type,
609: p_h_attribute14 In Fun_Interface_Headers.attribute14%type,
610: p_h_attribute15 In Fun_Interface_Headers.attribute15%type,
611: p_h_attribute_category In Fun_Interface_Headers.attribute_category%type,
612: p_id_ccid In Fun_Interface_Dist_Lines.ccid%type,
613: p_id_amount_dr In Fun_Interface_Dist_Lines.amount_dr%type,
614: p_id_amount_cr In Fun_Interface_Dist_Lines.amount_cr%type,

Line 611: p_h_attribute_category In Fun_Interface_Headers.attribute_category%type,

607: p_h_attribute12 In Fun_Interface_Headers.attribute12%type,
608: p_h_attribute13 In Fun_Interface_Headers.attribute13%type,
609: p_h_attribute14 In Fun_Interface_Headers.attribute14%type,
610: p_h_attribute15 In Fun_Interface_Headers.attribute15%type,
611: p_h_attribute_category In Fun_Interface_Headers.attribute_category%type,
612: p_id_ccid In Fun_Interface_Dist_Lines.ccid%type,
613: p_id_amount_dr In Fun_Interface_Dist_Lines.amount_dr%type,
614: p_id_amount_cr In Fun_Interface_Dist_Lines.amount_cr%type,
615: p_id_description In Fun_Interface_Dist_Lines.description%type,

Line 676: cp_batch_id In Fun_Interface_Headers.batch_id%type,

672: From Fun_Trx_Types_Vl
673: Where trx_type_name = cp_trx_type_name;
674:
675: Cursor C_Trx_Number_Exists(
676: cp_batch_id In Fun_Interface_Headers.batch_id%type,
677: cp_trx_number In Fun_Interface_Headers.trx_number%type) Is
678: Select *
679: From Fun_Interface_Headers
680: Where batch_id = cp_batch_id

Line 677: cp_trx_number In Fun_Interface_Headers.trx_number%type) Is

673: Where trx_type_name = cp_trx_type_name;
674:
675: Cursor C_Trx_Number_Exists(
676: cp_batch_id In Fun_Interface_Headers.batch_id%type,
677: cp_trx_number In Fun_Interface_Headers.trx_number%type) Is
678: Select *
679: From Fun_Interface_Headers
680: Where batch_id = cp_batch_id
681: And trx_number = cp_trx_number;

Line 679: From Fun_Interface_Headers

675: Cursor C_Trx_Number_Exists(
676: cp_batch_id In Fun_Interface_Headers.batch_id%type,
677: cp_trx_number In Fun_Interface_Headers.trx_number%type) Is
678: Select *
679: From Fun_Interface_Headers
680: Where batch_id = cp_batch_id
681: And trx_number = cp_trx_number;
682:
683: Cursor C_Trx_Id Is

Line 688: cp_batch_id In Fun_Interface_Headers.batch_id%type,

684: Select Fun_Trx_Headers_S.nextval trx_id
685: From Dual;
686:
687: Cursor C_Dupl_Reci_In_Batch(
688: cp_batch_id In Fun_Interface_Headers.batch_id%type,
689: cp_trx_number In Fun_Interface_Headers.trx_number%type,
690: cp_party_name In Fun_Interface_Headers.recipient_name%type) Is
691: Select count(distinct trx_number) dupl_reci_count
692: From Fun_Interface_Headers

Line 689: cp_trx_number In Fun_Interface_Headers.trx_number%type,

685: From Dual;
686:
687: Cursor C_Dupl_Reci_In_Batch(
688: cp_batch_id In Fun_Interface_Headers.batch_id%type,
689: cp_trx_number In Fun_Interface_Headers.trx_number%type,
690: cp_party_name In Fun_Interface_Headers.recipient_name%type) Is
691: Select count(distinct trx_number) dupl_reci_count
692: From Fun_Interface_Headers
693: Where batch_id = cp_batch_id

Line 690: cp_party_name In Fun_Interface_Headers.recipient_name%type) Is

686:
687: Cursor C_Dupl_Reci_In_Batch(
688: cp_batch_id In Fun_Interface_Headers.batch_id%type,
689: cp_trx_number In Fun_Interface_Headers.trx_number%type,
690: cp_party_name In Fun_Interface_Headers.recipient_name%type) Is
691: Select count(distinct trx_number) dupl_reci_count
692: From Fun_Interface_Headers
693: Where batch_id = cp_batch_id
694: And trx_number <> cp_trx_number

Line 692: From Fun_Interface_Headers

688: cp_batch_id In Fun_Interface_Headers.batch_id%type,
689: cp_trx_number In Fun_Interface_Headers.trx_number%type,
690: cp_party_name In Fun_Interface_Headers.recipient_name%type) Is
691: Select count(distinct trx_number) dupl_reci_count
692: From Fun_Interface_Headers
693: Where batch_id = cp_batch_id
694: And trx_number <> cp_trx_number
695: And recipient_name = cp_party_name;
696:

Line 747: l_reci_name Fun_Interface_Headers.recipient_name%type;

743: l_count Number;
744: l_batch_insert Varchar2(1);
745: l_le_party_id Xle_Firstparty_Information_V.party_id%type;
746: l_from_le_name Fun_Interface_Batches.from_le_name%type;
747: l_reci_name Fun_Interface_Headers.recipient_name%type;
748: l_trx_insert Varchar2(1);
749: l_dup_reci_count Number;
750: l_to_le_name Fun_Interface_Headers.to_le_name%type;
751: l_init_dist_line_insert Varchar2(1);

Line 750: l_to_le_name Fun_Interface_Headers.to_le_name%type;

746: l_from_le_name Fun_Interface_Batches.from_le_name%type;
747: l_reci_name Fun_Interface_Headers.recipient_name%type;
748: l_trx_insert Varchar2(1);
749: l_dup_reci_count Number;
750: l_to_le_name Fun_Interface_Headers.to_le_name%type;
751: l_init_dist_line_insert Varchar2(1);
752: l_init_chart_of_accounts Fnd_Id_Flex_Structures.id_flex_num%type;
753: l_reci_chart_of_accounts Fnd_Id_Flex_Structures.id_flex_num%type;
754: l_appl_short_name Fnd_Application.application_short_name%type;

Line 761: l_init_amount_cr Fun_Interface_Headers.init_amount_cr%type;

757: l_dr_sum Fun_Interface_Dist_Lines.amount_dr%type;
758: l_cr_sum Fun_Interface_Dist_Lines.amount_cr%type;
759: l_trx_id Fun_trx_headers.trx_id%type;
760: l_recipient_id Fun_trx_headers.recipient_id%type;
761: l_init_amount_cr Fun_Interface_Headers.init_amount_cr%type;
762: l_init_amount_dr Fun_Interface_Headers.init_amount_dr%type;
763: l_trx_number Fun_Interface_Headers.trx_number%type;
764:
765: l_batch_rec FUN_TRX_PUB.full_batch_rec_type;

Line 762: l_init_amount_dr Fun_Interface_Headers.init_amount_dr%type;

758: l_cr_sum Fun_Interface_Dist_Lines.amount_cr%type;
759: l_trx_id Fun_trx_headers.trx_id%type;
760: l_recipient_id Fun_trx_headers.recipient_id%type;
761: l_init_amount_cr Fun_Interface_Headers.init_amount_cr%type;
762: l_init_amount_dr Fun_Interface_Headers.init_amount_dr%type;
763: l_trx_number Fun_Interface_Headers.trx_number%type;
764:
765: l_batch_rec FUN_TRX_PUB.full_batch_rec_type;
766: l_trx_tbl FUN_TRX_PUB.full_trx_tbl_type;

Line 763: l_trx_number Fun_Interface_Headers.trx_number%type;

759: l_trx_id Fun_trx_headers.trx_id%type;
760: l_recipient_id Fun_trx_headers.recipient_id%type;
761: l_init_amount_cr Fun_Interface_Headers.init_amount_cr%type;
762: l_init_amount_dr Fun_Interface_Headers.init_amount_dr%type;
763: l_trx_number Fun_Interface_Headers.trx_number%type;
764:
765: l_batch_rec FUN_TRX_PUB.full_batch_rec_type;
766: l_trx_tbl FUN_TRX_PUB.full_trx_tbl_type;
767: l_dist_lines_tbl FUN_TRX_PUB.full_dist_line_tbl_type;