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_BATCHES

Line 165: p_initiator_name In Fun_Interface_Batches.initiator_name%type,

161: End Insert_Dists;
162:
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:

Line 166: p_trx_type_name In Fun_Interface_Batches.trx_type_name%type,

162:
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;

Line 178: Insert Into Fun_Interface_Batches(

174: INTO l_group_id
175: FROM dual;
176:
177: If p_insert_flag = 'Y' Then
178: Insert Into Fun_Interface_Batches(
179: source,
180: group_id,
181: batch_id,
182: batch_number,

Line 278: Update Fun_Interface_Batches Set

274: Values(
275: 'Global Intercompany',
276: l_group_id);
277: Elsif p_insert_flag = 'N' Then
278: Update Fun_Interface_Batches Set
279: currency_code = p_batch_rec.currency_code,
280: exchange_rate_type = p_batch_rec.exchange_rate_type,
281: description = p_batch_rec.description,
282: trx_type_id = p_batch_rec.trx_type_id,

Line 569: p_batch_number In Fun_Interface_Batches.batch_number%type,

565: p_encoded => Fnd_Api.G_FALSE);
566: End Get_Message_Text;
567:
568: Procedure Upload_Batch(
569: p_batch_number In Fun_Interface_Batches.batch_number%type,
570: p_initiator_name In Fun_Interface_Batches.initiator_name%type,
571: p_currency_code In Fun_Interface_Batches.currency_code%type,
572: p_batch_date In Fun_Interface_Batches.batch_date%type,
573: p_gl_date In Fun_Interface_Batches.gl_date%type,

Line 570: p_initiator_name In Fun_Interface_Batches.initiator_name%type,

566: End Get_Message_Text;
567:
568: Procedure Upload_Batch(
569: p_batch_number In Fun_Interface_Batches.batch_number%type,
570: p_initiator_name In Fun_Interface_Batches.initiator_name%type,
571: p_currency_code In Fun_Interface_Batches.currency_code%type,
572: p_batch_date In Fun_Interface_Batches.batch_date%type,
573: p_gl_date In Fun_Interface_Batches.gl_date%type,
574: p_trx_type_name In Fun_Interface_Batches.trx_type_name%type,

Line 571: p_currency_code In Fun_Interface_Batches.currency_code%type,

567:
568: Procedure Upload_Batch(
569: p_batch_number In Fun_Interface_Batches.batch_number%type,
570: p_initiator_name In Fun_Interface_Batches.initiator_name%type,
571: p_currency_code In Fun_Interface_Batches.currency_code%type,
572: p_batch_date In Fun_Interface_Batches.batch_date%type,
573: p_gl_date In Fun_Interface_Batches.gl_date%type,
574: p_trx_type_name In Fun_Interface_Batches.trx_type_name%type,
575: p_description In Fun_Interface_Batches.description%type,

Line 572: p_batch_date In Fun_Interface_Batches.batch_date%type,

568: Procedure Upload_Batch(
569: p_batch_number In Fun_Interface_Batches.batch_number%type,
570: p_initiator_name In Fun_Interface_Batches.initiator_name%type,
571: p_currency_code In Fun_Interface_Batches.currency_code%type,
572: p_batch_date In Fun_Interface_Batches.batch_date%type,
573: p_gl_date In Fun_Interface_Batches.gl_date%type,
574: p_trx_type_name In Fun_Interface_Batches.trx_type_name%type,
575: p_description In Fun_Interface_Batches.description%type,
576: p_note In Fun_Interface_Batches.note%type,

Line 573: p_gl_date In Fun_Interface_Batches.gl_date%type,

569: p_batch_number In Fun_Interface_Batches.batch_number%type,
570: p_initiator_name In Fun_Interface_Batches.initiator_name%type,
571: p_currency_code In Fun_Interface_Batches.currency_code%type,
572: p_batch_date In Fun_Interface_Batches.batch_date%type,
573: p_gl_date In Fun_Interface_Batches.gl_date%type,
574: p_trx_type_name In Fun_Interface_Batches.trx_type_name%type,
575: p_description In Fun_Interface_Batches.description%type,
576: p_note In Fun_Interface_Batches.note%type,
577: p_attribute1 In Fun_Interface_Batches.attribute1%type,

Line 574: p_trx_type_name In Fun_Interface_Batches.trx_type_name%type,

570: p_initiator_name In Fun_Interface_Batches.initiator_name%type,
571: p_currency_code In Fun_Interface_Batches.currency_code%type,
572: p_batch_date In Fun_Interface_Batches.batch_date%type,
573: p_gl_date In Fun_Interface_Batches.gl_date%type,
574: p_trx_type_name In Fun_Interface_Batches.trx_type_name%type,
575: p_description In Fun_Interface_Batches.description%type,
576: p_note In Fun_Interface_Batches.note%type,
577: p_attribute1 In Fun_Interface_Batches.attribute1%type,
578: p_attribute2 In Fun_Interface_Batches.attribute2%type,

Line 575: p_description In Fun_Interface_Batches.description%type,

571: p_currency_code In Fun_Interface_Batches.currency_code%type,
572: p_batch_date In Fun_Interface_Batches.batch_date%type,
573: p_gl_date In Fun_Interface_Batches.gl_date%type,
574: p_trx_type_name In Fun_Interface_Batches.trx_type_name%type,
575: p_description In Fun_Interface_Batches.description%type,
576: p_note In Fun_Interface_Batches.note%type,
577: p_attribute1 In Fun_Interface_Batches.attribute1%type,
578: p_attribute2 In Fun_Interface_Batches.attribute2%type,
579: p_attribute3 In Fun_Interface_Batches.attribute3%type,

Line 576: p_note In Fun_Interface_Batches.note%type,

572: p_batch_date In Fun_Interface_Batches.batch_date%type,
573: p_gl_date In Fun_Interface_Batches.gl_date%type,
574: p_trx_type_name In Fun_Interface_Batches.trx_type_name%type,
575: p_description In Fun_Interface_Batches.description%type,
576: p_note In Fun_Interface_Batches.note%type,
577: p_attribute1 In Fun_Interface_Batches.attribute1%type,
578: p_attribute2 In Fun_Interface_Batches.attribute2%type,
579: p_attribute3 In Fun_Interface_Batches.attribute3%type,
580: p_attribute4 In Fun_Interface_Batches.attribute4%type,

Line 577: p_attribute1 In Fun_Interface_Batches.attribute1%type,

573: p_gl_date In Fun_Interface_Batches.gl_date%type,
574: p_trx_type_name In Fun_Interface_Batches.trx_type_name%type,
575: p_description In Fun_Interface_Batches.description%type,
576: p_note In Fun_Interface_Batches.note%type,
577: p_attribute1 In Fun_Interface_Batches.attribute1%type,
578: p_attribute2 In Fun_Interface_Batches.attribute2%type,
579: p_attribute3 In Fun_Interface_Batches.attribute3%type,
580: p_attribute4 In Fun_Interface_Batches.attribute4%type,
581: p_attribute5 In Fun_Interface_Batches.attribute5%type,

Line 578: p_attribute2 In Fun_Interface_Batches.attribute2%type,

574: p_trx_type_name In Fun_Interface_Batches.trx_type_name%type,
575: p_description In Fun_Interface_Batches.description%type,
576: p_note In Fun_Interface_Batches.note%type,
577: p_attribute1 In Fun_Interface_Batches.attribute1%type,
578: p_attribute2 In Fun_Interface_Batches.attribute2%type,
579: p_attribute3 In Fun_Interface_Batches.attribute3%type,
580: p_attribute4 In Fun_Interface_Batches.attribute4%type,
581: p_attribute5 In Fun_Interface_Batches.attribute5%type,
582: p_attribute6 In Fun_Interface_Batches.attribute6%type,

Line 579: p_attribute3 In Fun_Interface_Batches.attribute3%type,

575: p_description In Fun_Interface_Batches.description%type,
576: p_note In Fun_Interface_Batches.note%type,
577: p_attribute1 In Fun_Interface_Batches.attribute1%type,
578: p_attribute2 In Fun_Interface_Batches.attribute2%type,
579: p_attribute3 In Fun_Interface_Batches.attribute3%type,
580: p_attribute4 In Fun_Interface_Batches.attribute4%type,
581: p_attribute5 In Fun_Interface_Batches.attribute5%type,
582: p_attribute6 In Fun_Interface_Batches.attribute6%type,
583: p_attribute7 In Fun_Interface_Batches.attribute7%type,

Line 580: p_attribute4 In Fun_Interface_Batches.attribute4%type,

576: p_note In Fun_Interface_Batches.note%type,
577: p_attribute1 In Fun_Interface_Batches.attribute1%type,
578: p_attribute2 In Fun_Interface_Batches.attribute2%type,
579: p_attribute3 In Fun_Interface_Batches.attribute3%type,
580: p_attribute4 In Fun_Interface_Batches.attribute4%type,
581: p_attribute5 In Fun_Interface_Batches.attribute5%type,
582: p_attribute6 In Fun_Interface_Batches.attribute6%type,
583: p_attribute7 In Fun_Interface_Batches.attribute7%type,
584: p_attribute8 In Fun_Interface_Batches.attribute8%type,

Line 581: p_attribute5 In Fun_Interface_Batches.attribute5%type,

577: p_attribute1 In Fun_Interface_Batches.attribute1%type,
578: p_attribute2 In Fun_Interface_Batches.attribute2%type,
579: p_attribute3 In Fun_Interface_Batches.attribute3%type,
580: p_attribute4 In Fun_Interface_Batches.attribute4%type,
581: p_attribute5 In Fun_Interface_Batches.attribute5%type,
582: p_attribute6 In Fun_Interface_Batches.attribute6%type,
583: p_attribute7 In Fun_Interface_Batches.attribute7%type,
584: p_attribute8 In Fun_Interface_Batches.attribute8%type,
585: p_attribute9 In Fun_Interface_Batches.attribute9%type,

Line 582: p_attribute6 In Fun_Interface_Batches.attribute6%type,

578: p_attribute2 In Fun_Interface_Batches.attribute2%type,
579: p_attribute3 In Fun_Interface_Batches.attribute3%type,
580: p_attribute4 In Fun_Interface_Batches.attribute4%type,
581: p_attribute5 In Fun_Interface_Batches.attribute5%type,
582: p_attribute6 In Fun_Interface_Batches.attribute6%type,
583: p_attribute7 In Fun_Interface_Batches.attribute7%type,
584: p_attribute8 In Fun_Interface_Batches.attribute8%type,
585: p_attribute9 In Fun_Interface_Batches.attribute9%type,
586: p_attribute10 In Fun_Interface_Batches.attribute10%type,

Line 583: p_attribute7 In Fun_Interface_Batches.attribute7%type,

579: p_attribute3 In Fun_Interface_Batches.attribute3%type,
580: p_attribute4 In Fun_Interface_Batches.attribute4%type,
581: p_attribute5 In Fun_Interface_Batches.attribute5%type,
582: p_attribute6 In Fun_Interface_Batches.attribute6%type,
583: p_attribute7 In Fun_Interface_Batches.attribute7%type,
584: p_attribute8 In Fun_Interface_Batches.attribute8%type,
585: p_attribute9 In Fun_Interface_Batches.attribute9%type,
586: p_attribute10 In Fun_Interface_Batches.attribute10%type,
587: p_attribute11 In Fun_Interface_Batches.attribute11%type,

Line 584: p_attribute8 In Fun_Interface_Batches.attribute8%type,

580: p_attribute4 In Fun_Interface_Batches.attribute4%type,
581: p_attribute5 In Fun_Interface_Batches.attribute5%type,
582: p_attribute6 In Fun_Interface_Batches.attribute6%type,
583: p_attribute7 In Fun_Interface_Batches.attribute7%type,
584: p_attribute8 In Fun_Interface_Batches.attribute8%type,
585: p_attribute9 In Fun_Interface_Batches.attribute9%type,
586: p_attribute10 In Fun_Interface_Batches.attribute10%type,
587: p_attribute11 In Fun_Interface_Batches.attribute11%type,
588: p_attribute12 In Fun_Interface_Batches.attribute12%type,

Line 585: p_attribute9 In Fun_Interface_Batches.attribute9%type,

581: p_attribute5 In Fun_Interface_Batches.attribute5%type,
582: p_attribute6 In Fun_Interface_Batches.attribute6%type,
583: p_attribute7 In Fun_Interface_Batches.attribute7%type,
584: p_attribute8 In Fun_Interface_Batches.attribute8%type,
585: p_attribute9 In Fun_Interface_Batches.attribute9%type,
586: p_attribute10 In Fun_Interface_Batches.attribute10%type,
587: p_attribute11 In Fun_Interface_Batches.attribute11%type,
588: p_attribute12 In Fun_Interface_Batches.attribute12%type,
589: p_attribute13 In Fun_Interface_Batches.attribute13%type,

Line 586: p_attribute10 In Fun_Interface_Batches.attribute10%type,

582: p_attribute6 In Fun_Interface_Batches.attribute6%type,
583: p_attribute7 In Fun_Interface_Batches.attribute7%type,
584: p_attribute8 In Fun_Interface_Batches.attribute8%type,
585: p_attribute9 In Fun_Interface_Batches.attribute9%type,
586: p_attribute10 In Fun_Interface_Batches.attribute10%type,
587: p_attribute11 In Fun_Interface_Batches.attribute11%type,
588: p_attribute12 In Fun_Interface_Batches.attribute12%type,
589: p_attribute13 In Fun_Interface_Batches.attribute13%type,
590: p_attribute14 In Fun_Interface_Batches.attribute14%type,

Line 587: p_attribute11 In Fun_Interface_Batches.attribute11%type,

583: p_attribute7 In Fun_Interface_Batches.attribute7%type,
584: p_attribute8 In Fun_Interface_Batches.attribute8%type,
585: p_attribute9 In Fun_Interface_Batches.attribute9%type,
586: p_attribute10 In Fun_Interface_Batches.attribute10%type,
587: p_attribute11 In Fun_Interface_Batches.attribute11%type,
588: p_attribute12 In Fun_Interface_Batches.attribute12%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,

Line 588: p_attribute12 In Fun_Interface_Batches.attribute12%type,

584: p_attribute8 In Fun_Interface_Batches.attribute8%type,
585: p_attribute9 In Fun_Interface_Batches.attribute9%type,
586: p_attribute10 In Fun_Interface_Batches.attribute10%type,
587: p_attribute11 In Fun_Interface_Batches.attribute11%type,
588: p_attribute12 In Fun_Interface_Batches.attribute12%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,

Line 589: p_attribute13 In Fun_Interface_Batches.attribute13%type,

585: p_attribute9 In Fun_Interface_Batches.attribute9%type,
586: p_attribute10 In Fun_Interface_Batches.attribute10%type,
587: p_attribute11 In Fun_Interface_Batches.attribute11%type,
588: p_attribute12 In Fun_Interface_Batches.attribute12%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,

Line 590: p_attribute14 In Fun_Interface_Batches.attribute14%type,

586: p_attribute10 In Fun_Interface_Batches.attribute10%type,
587: p_attribute11 In Fun_Interface_Batches.attribute11%type,
588: p_attribute12 In Fun_Interface_Batches.attribute12%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,

Line 591: p_attribute15 In Fun_Interface_Batches.attribute15%type,

587: p_attribute11 In Fun_Interface_Batches.attribute11%type,
588: p_attribute12 In Fun_Interface_Batches.attribute12%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,

Line 592: p_attribute_category In Fun_Interface_Batches.attribute_category%type,

588: p_attribute12 In Fun_Interface_Batches.attribute12%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,

Line 640: Cursor C_Batch_Exists(cp_batch_number In Fun_Interface_Batches.batch_number%type) Is

636: p_rd_amount_cr In Fun_Interface_Dist_Lines.amount_cr%type,
637: p_rd_description In Fun_Interface_Dist_Lines.description%type,
638: p_dist_number In Fun_Interface_Dist_Lines.dist_number%type) Is
639:
640: Cursor C_Batch_Exists(cp_batch_number In Fun_Interface_Batches.batch_number%type) Is
641: Select *
642: From Fun_Interface_Batches
643: Where batch_number = cp_batch_number;
644:

Line 642: From Fun_Interface_Batches

638: p_dist_number In Fun_Interface_Dist_Lines.dist_number%type) Is
639:
640: Cursor C_Batch_Exists(cp_batch_number In Fun_Interface_Batches.batch_number%type) Is
641: Select *
642: From Fun_Interface_Batches
643: Where batch_number = cp_batch_number;
644:
645: Cursor C_Batch_Id Is
646: Select Fun_Trx_Batches_S.nextval batch_id

Line 651: Cursor C_Party(cp_party_name In Fun_Interface_Batches.initiator_name%type) Is

647: From Dual;
648:
649: -- Bug No: 6134848. 2 more condetions added to validate Party_usage_code.
650:
651: Cursor C_Party(cp_party_name In Fun_Interface_Batches.initiator_name%type) Is
652: Select hzp.party_id
653: From Hz_Parties Hzp, hz_party_usg_assignments hu
654: Where hzp.party_type = 'ORGANIZATION'
655: And hzp.party_name = cp_party_name

Line 671: Cursor C_Trx_Type (cp_trx_type_name In Fun_Interface_Batches.trx_type_name%type) Is

667: Select name
668: From xle_firstparty_information_v
669: Where party_id = cp_party_id;
670:
671: Cursor C_Trx_Type (cp_trx_type_name In Fun_Interface_Batches.trx_type_name%type) Is
672: Select trx_type_code, trx_type_id, allow_invoicing_flag
673: From Fun_Trx_Types_Vl
674: Where trx_type_name = cp_trx_type_name;
675:

Line 716: Cursor C_Ccid(cp_party_name In Fun_Interface_Batches.initiator_name%type) Is

712: Cursor C_Dist_Id Is
713: Select Fun_Dist_Lines_S.nextval dist_id
714: From dual;
715:
716: Cursor C_Ccid(cp_party_name In Fun_Interface_Batches.initiator_name%type) Is
717: Select chart_of_accounts_id
718: From Hz_Parties hzp,
719: xle_firstparty_information_v xfi ,
720: Gl_Ledger_Le_V led

Line 747: l_from_le_name Fun_Interface_Batches.from_le_name%type;

743:
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;

Line 1413: p_batch_number In Fun_Interface_Batches.batch_number%type) IS

1409:
1410: --Bug: 10095345
1411:
1412: Procedure Delete_Batch(
1413: p_batch_number In Fun_Interface_Batches.batch_number%type) IS
1414:
1415:
1416: BEGIN
1417:

Line 1421: fun_interface_batches fib

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);
1425:

Line 1428: FROM fun_interface_batches

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);
1431:
1432: DELETE Fun_Interface_Controls

Line 1434: FROM fun_interface_batches

1430: AND batch_number = p_batch_number);
1431:
1432: DELETE Fun_Interface_Controls
1433: WHERE GROUP_ID IN (SELECT GROUP_ID
1434: FROM fun_interface_batches
1435: WHERE source = 'Global Intercompany'
1436: AND batch_number = p_batch_number)
1437: AND SOURCE = 'Global Intercompany';
1438:

Line 1439: DELETE fun_interface_batches

1435: WHERE source = 'Global Intercompany'
1436: AND batch_number = p_batch_number)
1437: AND SOURCE = 'Global Intercompany';
1438:
1439: DELETE fun_interface_batches
1440: WHERE source = 'Global Intercompany'
1441: AND batch_number = p_batch_number;
1442:
1443: COMMIT;

Line 1454: p_batch_number In Fun_Interface_Batches.batch_number%type) IS

1450: END;
1451:
1452: --Bug: 10095345
1453: Procedure Import_Batch(
1454: p_batch_number In Fun_Interface_Batches.batch_number%type) IS
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

Line 1473: FROM fun_interface_batches

1469: party_type_flag
1470: ORDER BY trxH.trx_id) fun_dists
1471: WHERE fun_dists.trx_id = trxh.trx_id
1472: AND trxh.batch_id in (SELECT batch_id
1473: FROM fun_interface_batches
1474: WHERE source = 'Global Intercompany'
1475: AND batch_number = p_batch_number)
1476: ORDER BY party_type_flag;
1477:

Line 1478: l_batch_number Fun_Interface_Batches.batch_number%TYPE;

1474: WHERE source = 'Global Intercompany'
1475: AND batch_number = p_batch_number)
1476: ORDER BY party_type_flag;
1477:
1478: l_batch_number Fun_Interface_Batches.batch_number%TYPE;
1479: l_trx_number NUMBER;
1480: INVALID_INIT_EXCPT EXCEPTION;
1481: INVALID_RECI_EXCPT EXCEPTION;
1482: v VARCHAR2(1000);