APPS.AP_FUNDS_CONTROL_PKG dependencies on XLA_EVENTS

Line 167: FROM xla_events xla,

163: -- index XLA_TRANSACTION_ENTITIES_N1
164: --
165: CURSOR c_get_unprocessed_events IS
166: SELECT xla.event_id
167: FROM xla_events xla,
168: xla_transaction_entities xte,
169: ap_invoices_all ai
170: WHERE NVL(xla.budgetary_control_flag, 'N') ='Y'
171: AND xla.application_id = 200

Line 650: xla_events_gt e

646: FROM gl_lookups l
647: WHERE lookup_type = 'FUNDS_CHECK_RESULT_CODE'
648: AND EXISTS ( SELECT 'x'
649: FROM gl_bc_packets bc,
650: xla_events_gt e
651: WHERE bc.event_id = e.event_id
652: AND result_code like 'F%'
653: AND bc.result_code = l.lookup_code)
654: AND rownum = 1;

Line 966: l_bc_event_id XLA_EVENTS.EVENT_ID%TYPE;

962: l_cfc_hold_cnt NUMBER; --Bug 9168747
963: l_msg_data VARCHAR2(2000);
964: l_result_code VARCHAR2(30);
965: l_packet_id NUMBER; --Bug 4535804
966: l_bc_event_id XLA_EVENTS.EVENT_ID%TYPE;
967: l_bc_event_status XLA_EVENTS.EVENT_STATUS_CODE%TYPE;
968: l_count_unproc NUMBER;
969:
970: l_org_id NUMBER; --Bug 5487757

Line 967: l_bc_event_status XLA_EVENTS.EVENT_STATUS_CODE%TYPE;

963: l_msg_data VARCHAR2(2000);
964: l_result_code VARCHAR2(30);
965: l_packet_id NUMBER; --Bug 4535804
966: l_bc_event_id XLA_EVENTS.EVENT_ID%TYPE;
967: l_bc_event_status XLA_EVENTS.EVENT_STATUS_CODE%TYPE;
968: l_count_unproc NUMBER;
969:
970: l_org_id NUMBER; --Bug 5487757
971:

Line 1356: FROM xla_events xe

1352:
1353: IF l_bc_event_id IS NOT NULL THEN
1354: SELECT xe.event_status_code
1355: INTO l_bc_event_status
1356: FROM xla_events xe
1357: WHERE xe.application_id = 200
1358: AND xe.event_id = l_bc_event_id;
1359:
1360: IF l_bc_event_status <> 'P' THEN

Line 1454: FROM xla_events xe

1450:
1451: IF l_bc_event_id IS NOT NULL THEN
1452: SELECT xe.event_status_code
1453: INTO l_bc_event_status
1454: FROM xla_events xe
1455: WHERE xe.application_id = 200
1456: AND xe.event_id = l_bc_event_id;
1457:
1458: IF l_bc_event_status <> 'P' THEN