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 54: l_xla_ev_rec arp_xla_events.xla_events_type;

50:
51: PROCEDURE process_events(p_gt_id NUMBER,
52: p_batch_id NUMBER) IS
53:
54: l_xla_ev_rec arp_xla_events.xla_events_type;
55: l_from_doc_id NUMBER;
56: l_to_doc_id NUMBER;
57: l_from_ra_doc_id NUMBER;
58: l_to_ra_doc_id NUMBER;

Line 200: arp_xla_events.Create_Events( l_xla_ev_rec );

196: l_xla_ev_rec.xla_to_doc_id := l_to_doc_id;
197: l_xla_ev_rec.xla_mode := 'B';
198: l_xla_ev_rec.xla_call := 'C';
199:
200: arp_xla_events.Create_Events( l_xla_ev_rec );
201:
202: l_xla_ev_rec.xla_doc_table := 'CRH';
203: l_xla_ev_rec.xla_req_id := pg_request_id;
204: l_xla_ev_rec.xla_from_doc_id := l_from_doc_id;

Line 209: arp_xla_events.Create_Events( l_xla_ev_rec );

205: l_xla_ev_rec.xla_to_doc_id := l_to_doc_id;
206: l_xla_ev_rec.xla_mode := 'B';
207: l_xla_ev_rec.xla_call := 'D';
208:
209: arp_xla_events.Create_Events( l_xla_ev_rec );
210:
211: l_xla_ev_rec.xla_doc_table := 'APP';
212: l_xla_ev_rec.xla_req_id := pg_request_id;
213: l_xla_ev_rec.xla_from_doc_id := l_from_ra_doc_id;

Line 218: arp_xla_events.Create_Events( l_xla_ev_rec );

214: l_xla_ev_rec.xla_to_doc_id := l_to_ra_doc_id;
215: l_xla_ev_rec.xla_mode := 'B';
216: l_xla_ev_rec.xla_call := 'D';
217:
218: arp_xla_events.Create_Events( l_xla_ev_rec );
219:
220: Select min(ra.receivable_application_id),
221: max(ra.receivable_application_id)
222: into l_from_ra_doc_id,

Line 246: arp_xla_events.Create_Events( l_xla_ev_rec );

242: l_xla_ev_rec.xla_to_doc_id := l_to_ra_doc_id;
243: l_xla_ev_rec.xla_mode := 'O';
244: l_xla_ev_rec.xla_call := 'B';
245:
246: arp_xla_events.Create_Events( l_xla_ev_rec );
247:
248: END IF;
249:
250: IF PG_DEBUG in ('Y', 'C') THEN

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

2486:
2487: /* end unapply */
2488: arp_debug.debug('delete the bad receipts');
2489:
2490: /* Start of delete XLA events code. Doing this is bulk */
2491: Begin
2492: IF PG_DEBUG in ('Y','C') THEN
2493: arp_debug.debug ( 'Start calling xla delete_bulk_events');
2494: arp_debug.debug ( 'Inserting into xla_events_int_gt...');

Line 2494: arp_debug.debug ( 'Inserting into xla_events_int_gt...');

2490: /* Start of delete XLA events code. Doing this is bulk */
2491: Begin
2492: IF PG_DEBUG in ('Y','C') THEN
2493: arp_debug.debug ( 'Start calling xla delete_bulk_events');
2494: arp_debug.debug ( 'Inserting into xla_events_int_gt...');
2495: END IF;
2496:
2497: INSERT INTO xla_events_int_gt
2498: (event_id

Line 2497: INSERT INTO xla_events_int_gt

2493: arp_debug.debug ( 'Start calling xla delete_bulk_events');
2494: arp_debug.debug ( 'Inserting into xla_events_int_gt...');
2495: END IF;
2496:
2497: INSERT INTO xla_events_int_gt
2498: (event_id
2499: ,ledger_id
2500: ,entity_code
2501: ,application_id

Line 2549: xla_events xe

2545: ,reference_date_3
2546: ,reference_date_4
2547: ,on_hold_flag
2548: from xla_transaction_entities_upg xte,
2549: xla_events xe
2550: where xte.application_id = 222
2551: and xte.entity_code = 'RECEIPTS'
2552: and xe.application_id = 222
2553: and xe.event_number > 0

Line 2563: arp_debug.debug ( 'Calling xla_events_pub_pkg.delete_bulk_events()');

2559: where request_id = pg_request_id));
2560:
2561: IF PG_DEBUG in ('Y','C') THEN
2562: arp_debug.debug ( 'rows inserted into xla gt table = '|| sql%rowcount);
2563: arp_debug.debug ( 'Calling xla_events_pub_pkg.delete_bulk_events()');
2564: END IF;
2565:
2566: xla_events_pub_pkg.delete_bulk_events(222);
2567:

Line 2566: xla_events_pub_pkg.delete_bulk_events(222);

2562: arp_debug.debug ( 'rows inserted into xla gt table = '|| sql%rowcount);
2563: arp_debug.debug ( 'Calling xla_events_pub_pkg.delete_bulk_events()');
2564: END IF;
2565:
2566: xla_events_pub_pkg.delete_bulk_events(222);
2567:
2568: IF PG_DEBUG in ('Y','C') THEN
2569: arp_debug.debug ( 'End calling xla delete_bulk_events');
2570: END IF;

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

2571:
2572: EXCEPTION
2573: WHEN OTHERS THEN
2574: IF PG_DEBUG in ('Y', 'C') THEN
2575: arp_debug.debug('Error in call to xla_events_pub_pkg.delete_bulk_events ' || sqlerrm);
2576: END IF;
2577: END;
2578: /* End of delete XLA events code */
2579:

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

2574: IF PG_DEBUG in ('Y', 'C') THEN
2575: arp_debug.debug('Error in call to xla_events_pub_pkg.delete_bulk_events ' || sqlerrm);
2576: END IF;
2577: END;
2578: /* End of delete XLA events code */
2579:
2580: update ar_payment_schedules
2581: set selected_for_receipt_batch_id = null,
2582: gl_date_closed = TO_DATE('4712/12/31', 'YYYY/MM/DD'),