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.25.12020000.2 2012/07/26 23:12:17 shnaraya 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.25.12020000.2 2012/07/26 23:12:17 shnaraya 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 593: p_trx_number In Fun_Interface_Headers.trx_number%type,

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

Line 594: p_recipient_name In Fun_Interface_Headers.recipient_name%type,

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

Line 595: p_init_amount_dr In Fun_Interface_Headers.init_amount_dr%type,

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

Line 596: p_init_amount_cr In Fun_Interface_Headers.init_amount_cr%type,

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

Line 597: p_h_attribute1 In Fun_Interface_Headers.attribute1%type,

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

Line 598: p_h_attribute2 In Fun_Interface_Headers.attribute2%type,

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

Line 599: p_h_attribute3 In Fun_Interface_Headers.attribute3%type,

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

Line 600: p_h_attribute4 In Fun_Interface_Headers.attribute4%type,

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

Line 601: p_h_attribute5 In Fun_Interface_Headers.attribute5%type,

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

Line 602: p_h_attribute6 In Fun_Interface_Headers.attribute6%type,

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

Line 603: p_h_attribute7 In Fun_Interface_Headers.attribute7%type,

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

Line 604: p_h_attribute8 In Fun_Interface_Headers.attribute8%type,

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

Line 605: p_h_attribute9 In Fun_Interface_Headers.attribute9%type,

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

Line 606: p_h_attribute10 In Fun_Interface_Headers.attribute10%type,

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

Line 607: p_h_attribute11 In Fun_Interface_Headers.attribute11%type,

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

Line 608: p_h_attribute12 In Fun_Interface_Headers.attribute12%type,

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

Line 609: p_h_attribute13 In Fun_Interface_Headers.attribute13%type,

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

Line 610: p_h_attribute14 In Fun_Interface_Headers.attribute14%type,

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

Line 611: p_h_attribute15 In Fun_Interface_Headers.attribute15%type,

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

Line 612: p_h_attribute_category In Fun_Interface_Headers.attribute_category%type,

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

Line 677: cp_batch_id In Fun_Interface_Headers.batch_id%type,

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

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

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

Line 680: From Fun_Interface_Headers

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

Line 689: cp_batch_id In Fun_Interface_Headers.batch_id%type,

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

Line 690: cp_trx_number In Fun_Interface_Headers.trx_number%type,

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

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

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

Line 693: From Fun_Interface_Headers

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

Line 748: l_reci_name Fun_Interface_Headers.recipient_name%type;

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

Line 751: l_to_le_name Fun_Interface_Headers.to_le_name%type;

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

Line 762: l_init_amount_cr Fun_Interface_Headers.init_amount_cr%type;

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

Line 763: l_init_amount_dr Fun_Interface_Headers.init_amount_dr%type;

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

Line 764: l_trx_number Fun_Interface_Headers.trx_number%type;

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

Line 1420: FROM Fun_Interface_Headers fih,

1416: BEGIN
1417:
1418: DELETE Fun_Interface_Dist_Lines
1419: WHERE trx_id in (SELECT trx_id
1420: FROM Fun_Interface_Headers fih,
1421: fun_interface_batches fib
1422: WHERE fih.batch_id = fib.batch_id
1423: AND fib.source = 'Global Intercompany'
1424: AND fib.batch_number = p_batch_number);

Line 1426: DELETE Fun_Interface_Headers

1422: WHERE fih.batch_id = fib.batch_id
1423: AND fib.source = 'Global Intercompany'
1424: AND fib.batch_number = p_batch_number);
1425:
1426: DELETE Fun_Interface_Headers
1427: WHERE batch_id in (SELECT batch_id
1428: FROM fun_interface_batches
1429: WHERE source = 'Global Intercompany'
1430: AND batch_number = p_batch_number);

Line 1459: FROM fun_interface_headers trxH,

1455:
1456: CURSOR c_dist_totals IS
1457: SELECT trxh.trx_number, party_type_flag, dist_amount,
1458: DECODE(init_amount_cr, null, init_amount_dr, init_amount_cr) trx_amount
1459: FROM fun_interface_headers trxH,
1460: (SELECT trxH.trx_id,
1461: fd.dist_type_flag,
1462: party_type_flag ,
1463: sum(decode(fd.amount_cr, null, fd.amount_dr, fd.amount_cr)) DIST_AMOUNT

Line 1464: FROM fun_interface_headers trxH, FUN_INTERFACE_DIST_LINES fd

1460: (SELECT trxH.trx_id,
1461: fd.dist_type_flag,
1462: party_type_flag ,
1463: sum(decode(fd.amount_cr, null, fd.amount_dr, fd.amount_cr)) DIST_AMOUNT
1464: FROM fun_interface_headers trxH, FUN_INTERFACE_DIST_LINES fd
1465: WHERE trxH.trx_id = fd.trx_id
1466: AND dist_type_flag = 'L'
1467: GROUP BY trxH.trx_id,
1468: fd.dist_type_flag,