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

Line 2655: FROM xla_events xe

2651:
2652: --Bug 9385883
2653: CURSOR D(l_event_id NUMBER) IS
2654: SELECT 'Locked'
2655: FROM xla_events xe
2656: WHERE xe.event_id = l_event_id
2657: AND xe.application_id= 200
2658: FOR UPDATE OF event_id NOWAIT;
2659:

Line 2660: Rec_xla_events_Info D%ROWTYPE;

2656: WHERE xe.event_id = l_event_id
2657: AND xe.application_id= 200
2658: FOR UPDATE OF event_id NOWAIT;
2659:
2660: Rec_xla_events_Info D%ROWTYPE;
2661:
2662: BEGIN
2663:
2664: -- Update the calling sequence

Line 2686: debug_info := 'Select from xla_events';

2682: CLOSE C;
2683:
2684: --Bug 9385883
2685: IF (Recinfo.accounting_event_id IS NOT NULL) THEN
2686: debug_info := 'Select from xla_events';
2687: OPEN D(Recinfo.accounting_event_id);
2688: debug_info := 'Fetch curson D';
2689: FETCH D INTO Rec_xla_events_Info;
2690:

Line 2689: FETCH D INTO Rec_xla_events_Info;

2685: IF (Recinfo.accounting_event_id IS NOT NULL) THEN
2686: debug_info := 'Select from xla_events';
2687: OPEN D(Recinfo.accounting_event_id);
2688: debug_info := 'Fetch curson D';
2689: FETCH D INTO Rec_xla_events_Info;
2690:
2691: IF (D%NOTFOUND) THEN
2692: debug_info := 'Close cursor D - ROW NOTFOUND';
2693: CLOSE D;

Line 5562: FROM xla_events xe

5558: FOR i in 1..l_accounting_event_id_list.count LOOP
5559:
5560: SELECT count(*)
5561: INTO l_no_dists_exists
5562: FROM xla_events xe
5563: WHERE xe.event_id = l_accounting_event_id_list(i)
5564: AND xe.event_status_code <> 'P'
5565: AND xe.application_id = 200
5566: AND NOT EXISTS (SELECT 'No self assessed tax rows exists for this event'