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.AR_AUTOREC_API dependencies on XLA_EVENTS

Line 4656: /* Start of delete XLA events code. Doing this is bulk */

4652: /* end unapply */
4653:
4654: arp_standard.debug('delete the bad receipts');
4655:
4656: /* Start of delete XLA events code. Doing this is bulk */
4657: Begin
4658: IF PG_DEBUG in ('Y','C') THEN
4659: arp_standard.debug ( 'Start calling xla delete_bulk_events');
4660: arp_standard.debug ( 'Inserting into xla_events_int_gt...');

Line 4660: arp_standard.debug ( 'Inserting into xla_events_int_gt...');

4656: /* Start of delete XLA events code. Doing this is bulk */
4657: Begin
4658: IF PG_DEBUG in ('Y','C') THEN
4659: arp_standard.debug ( 'Start calling xla delete_bulk_events');
4660: arp_standard.debug ( 'Inserting into xla_events_int_gt...');
4661: END IF;
4662:
4663: INSERT INTO xla_events_int_gt
4664: (event_id

Line 4663: INSERT INTO xla_events_int_gt

4659: arp_standard.debug ( 'Start calling xla delete_bulk_events');
4660: arp_standard.debug ( 'Inserting into xla_events_int_gt...');
4661: END IF;
4662:
4663: INSERT INTO xla_events_int_gt
4664: (event_id
4665: ,ledger_id
4666: ,entity_code
4667: ,application_id

Line 4715: xla_events xe

4711: ,reference_date_3
4712: ,reference_date_4
4713: ,on_hold_flag
4714: from xla_transaction_entities_upg xte,
4715: xla_events xe
4716: where xte.application_id = 222
4717: and xte.entity_code = 'RECEIPTS'
4718: and xe.application_id = 222
4719: and xe.event_number > 0

Line 4729: arp_standard.debug ( 'Calling xla_events_pub_pkg.delete_bulk_events()');

4725: where request_id = l_request_id));
4726:
4727: IF PG_DEBUG in ('Y','C') THEN
4728: arp_standard.debug ( 'rows inserted into xla gt table = '|| sql%rowcount);
4729: arp_standard.debug ( 'Calling xla_events_pub_pkg.delete_bulk_events()');
4730: END IF;
4731:
4732: xla_events_pub_pkg.delete_bulk_events(222);
4733:

Line 4732: xla_events_pub_pkg.delete_bulk_events(222);

4728: arp_standard.debug ( 'rows inserted into xla gt table = '|| sql%rowcount);
4729: arp_standard.debug ( 'Calling xla_events_pub_pkg.delete_bulk_events()');
4730: END IF;
4731:
4732: xla_events_pub_pkg.delete_bulk_events(222);
4733:
4734: IF PG_DEBUG in ('Y','C') THEN
4735: arp_standard.debug ( 'End calling xla delete_bulk_events');
4736: END IF;

Line 4741: arp_standard.debug('Error in call to xla_events_pub_pkg.delete_bulk_events ' || sqlerrm);

4737:
4738: EXCEPTION
4739: WHEN OTHERS THEN
4740: IF PG_DEBUG in ('Y', 'C') THEN
4741: arp_standard.debug('Error in call to xla_events_pub_pkg.delete_bulk_events ' || sqlerrm);
4742: END IF;
4743: END;
4744: /* End of delete XLA events code */
4745:

Line 4744: /* End of delete XLA events code */

4740: IF PG_DEBUG in ('Y', 'C') THEN
4741: arp_standard.debug('Error in call to xla_events_pub_pkg.delete_bulk_events ' || sqlerrm);
4742: END IF;
4743: END;
4744: /* End of delete XLA events code */
4745:
4746:
4747: update ar_payment_schedules
4748: set selected_for_receipt_batch_id = null,