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 568: p_batch_number In Fun_Interface_Batches.batch_number%type,

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

Line 569: p_initiator_name In Fun_Interface_Batches.initiator_name%type,

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

Line 570: p_currency_code In Fun_Interface_Batches.currency_code%type,

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

Line 571: p_batch_date In Fun_Interface_Batches.batch_date%type,

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

Line 572: p_gl_date In Fun_Interface_Batches.gl_date%type,

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

Line 573: p_trx_type_name In Fun_Interface_Batches.trx_type_name%type,

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

Line 574: p_description In Fun_Interface_Batches.description%type,

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

Line 575: p_note In Fun_Interface_Batches.note%type,

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

Line 576: p_attribute1 In Fun_Interface_Batches.attribute1%type,

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

Line 577: p_attribute2 In Fun_Interface_Batches.attribute2%type,

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

Line 578: p_attribute3 In Fun_Interface_Batches.attribute3%type,

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

Line 579: p_attribute4 In Fun_Interface_Batches.attribute4%type,

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

Line 580: p_attribute5 In Fun_Interface_Batches.attribute5%type,

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

Line 581: p_attribute6 In Fun_Interface_Batches.attribute6%type,

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

Line 582: p_attribute7 In Fun_Interface_Batches.attribute7%type,

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

Line 583: p_attribute8 In Fun_Interface_Batches.attribute8%type,

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

Line 584: p_attribute9 In Fun_Interface_Batches.attribute9%type,

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

Line 585: p_attribute10 In Fun_Interface_Batches.attribute10%type,

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

Line 586: p_attribute11 In Fun_Interface_Batches.attribute11%type,

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

Line 587: p_attribute12 In Fun_Interface_Batches.attribute12%type,

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

Line 588: p_attribute13 In Fun_Interface_Batches.attribute13%type,

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

Line 589: p_attribute14 In Fun_Interface_Batches.attribute14%type,

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

Line 590: p_attribute15 In Fun_Interface_Batches.attribute15%type,

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

Line 591: p_attribute_category In Fun_Interface_Batches.attribute_category%type,

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

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

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

Line 641: From Fun_Interface_Batches

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

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

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

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

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

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

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

Line 746: l_from_le_name Fun_Interface_Batches.from_le_name%type;

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