APPS.XLA_EVENTS_PKG dependencies on XLA_EVENT_TYPES_B

Line 1392: FROM xla_event_types_b

1388: AND entity_id = g_entity_id
1389: AND application_id = g_application_id -- 8967771
1390: AND event_type_code IN
1391: (SELECT event_type_code
1392: FROM xla_event_types_b
1393: WHERE application_id = g_application_id
1394: AND entity_code = g_entity_type_code
1395: AND event_class_code = NVL(p_event_class_code,
1396: event_class_code));

Line 1415: FROM xla_event_types_b

1411: AND entity_id = g_entity_id
1412: AND application_id = g_application_id -- 8967771
1413: AND event_type_code IN
1414: (SELECT event_type_code
1415: FROM xla_event_types_b
1416: WHERE application_id = g_application_id
1417: AND entity_code = g_entity_type_code
1418: AND event_class_code = NVL(p_event_class_code,
1419: event_class_code))

Line 3272: FROM xla_event_types_b

3268: AND entity_id = g_entity_id
3269: AND application_id = g_application_id -- 8967771
3270: AND event_type_code IN
3271: (SELECT event_type_code
3272: FROM xla_event_types_b
3273: WHERE application_id = g_application_id
3274: AND entity_code = g_entity_type_code
3275: AND event_class_code = NVL(p_event_class_code,
3276: event_class_code));

Line 3288: FROM xla_event_types_b

3284: AND entity_id = g_entity_id
3285: AND application_id = g_application_id -- 8967771
3286: AND event_type_code IN
3287: (SELECT event_type_code
3288: FROM xla_event_types_b
3289: WHERE application_id = g_application_id
3290: AND entity_code = g_entity_type_code
3291: AND event_class_code = NVL(p_event_class_code,
3292: event_class_code))

Line 4133: FROM xla_event_types_b

4129: AND event_id = NVL(p_event_id, event_id)
4130: AND entity_id = g_entity_id
4131: AND application_id = g_application_id -- 8967771
4132: AND event_type_code IN (SELECT event_type_code
4133: FROM xla_event_types_b
4134: WHERE application_id = g_application_id
4135: AND entity_code = g_entity_type_code
4136: AND event_class_code = NVL(p_event_class_code,
4137: event_class_code));

Line 4416: (SELECT event_type_code FROM xla_event_types_b WHERE application_id =:'||l_evt_status_bind_count;

4412:
4413:
4414: v_event_status_cur_stmt:=v_event_status_cur_stmt||'
4415: AND event_type_code IN
4416: (SELECT event_type_code FROM xla_event_types_b WHERE application_id =:'||l_evt_status_bind_count;
4417: l_evt_status_bind_array(l_evt_status_bind_count):=to_char(g_application_id);
4418: l_evt_status_bind_count := l_evt_status_bind_count + 1;
4419:
4420: if p_event_class_code is not null then

Line 5327: FROM xla_events_int_gt xeg, xla_event_types_b xet

5323: WHERE event_status_code not in ('I', 'U', 'N');
5324:
5325: CURSOR csr_event_type_error(p_entity_code VARCHAR2, p_app_id NUMBER) is
5326: SELECT 1
5327: FROM xla_events_int_gt xeg, xla_event_types_b xet
5328: WHERE xet.entity_code(+) = p_entity_code
5329: AND xet.application_id(+) = p_app_id
5330: AND xeg.event_type_code = xet.event_type_code (+)
5331: AND nvl(xet.enabled_flag, 'N') = 'N';

Line 5501: FROM xla_event_types_b

5497: OR xeg.application_id <> :2
5498: OR xeg.event_status_code not in (''I'', ''U'', ''N'')
5499: OR xeg.event_type_code not in
5500: (SELECT event_type_code
5501: FROM xla_event_types_b
5502: WHERE application_id = :3
5503: AND entity_code = :4
5504: AND enabled_flag = ''Y'') OR '
5505: || validate_id_where_clause || ')';

Line 6802: FROM xla_event_types_b

6798: AND event_type_code = NVL(p_event_type_code ,event_type_code)
6799: AND entity_id = g_entity_id
6800: AND application_id = g_application_id -- 8967771
6801: AND event_type_code IN (SELECT event_type_code
6802: FROM xla_event_types_b
6803: WHERE application_id = g_application_id
6804: AND entity_code = g_entity_type_code
6805: AND event_class_code = NVL(p_event_class_code,
6806: event_class_code));

Line 7900: FROM xla_event_types_b a

7896: SELECT a.entity_code
7897: ,a.event_class_code
7898: ,a.event_type_code
7899: ,a.enabled_flag
7900: FROM xla_event_types_b a
7901: WHERE a.application_id = g_application_id;
7902:
7903: l_count INTEGER;
7904: