APPS.XLA_EVENTS_PKG dependencies on XLA_EVENT_TYPES_B

Line 1372: FROM xla_event_types_b

1368: AND event_type_code = NVL(p_event_type_code, event_type_code)
1369: AND entity_id = g_entity_id
1370: AND event_type_code IN
1371: (SELECT event_type_code
1372: FROM xla_event_types_b
1373: WHERE application_id = g_application_id
1374: AND entity_code = g_entity_type_code
1375: AND event_class_code = NVL(p_event_class_code,
1376: event_class_code));

Line 1393: FROM xla_event_types_b

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

Line 3212: FROM xla_event_types_b

3208: AND event_type_code = NVL(p_event_type_code, event_type_code)
3209: AND entity_id = g_entity_id
3210: AND event_type_code IN
3211: (SELECT event_type_code
3212: FROM xla_event_types_b
3213: WHERE application_id = g_application_id
3214: AND entity_code = g_entity_type_code
3215: AND event_class_code = NVL(p_event_class_code,
3216: event_class_code));

Line 3227: FROM xla_event_types_b

3223: AND event_type_code = NVL(p_event_type_code, event_type_code)
3224: AND entity_id = g_entity_id
3225: AND event_type_code IN
3226: (SELECT event_type_code
3227: FROM xla_event_types_b
3228: WHERE application_id = g_application_id
3229: AND entity_code = g_entity_type_code
3230: AND event_class_code = NVL(p_event_class_code,
3231: event_class_code))

Line 4051: FROM xla_event_types_b

4047: AND event_number = NVL(p_event_number, event_number)
4048: AND event_id = NVL(p_event_id, event_id)
4049: AND entity_id = g_entity_id
4050: AND event_type_code IN (SELECT event_type_code
4051: FROM xla_event_types_b
4052: WHERE application_id = g_application_id
4053: AND entity_code = g_entity_type_code
4054: AND event_class_code = NVL(p_event_class_code,
4055: event_class_code));

Line 4866: FROM xla_events_int_gt xeg, xla_event_types_b xet

4862: WHERE event_status_code not in ('I', 'U', 'N');
4863:
4864: CURSOR csr_event_type_error(p_entity_code VARCHAR2, p_app_id NUMBER) is
4865: SELECT 1
4866: FROM xla_events_int_gt xeg, xla_event_types_b xet
4867: WHERE xet.entity_code(+) = p_entity_code
4868: AND xet.application_id(+) = p_app_id
4869: AND xeg.event_type_code = xet.event_type_code (+)
4870: AND nvl(xet.enabled_flag, 'N') = 'N';

Line 5040: FROM xla_event_types_b

5036: OR xeg.application_id <> :2
5037: OR xeg.event_status_code not in (''I'', ''U'', ''N'')
5038: OR xeg.event_type_code not in
5039: (SELECT event_type_code
5040: FROM xla_event_types_b
5041: WHERE application_id = :3
5042: AND entity_code = :4
5043: AND enabled_flag = ''Y'') OR '
5044: || validate_id_where_clause || ')';

Line 6214: FROM xla_event_types_b

6210: AND event_status_code = NVL(p_event_status_code,event_status_code)
6211: AND event_type_code = NVL(p_event_type_code ,event_type_code)
6212: AND entity_id = g_entity_id
6213: AND event_type_code IN (SELECT event_type_code
6214: FROM xla_event_types_b
6215: WHERE application_id = g_application_id
6216: AND entity_code = g_entity_type_code
6217: AND event_class_code = NVL(p_event_class_code,
6218: event_class_code));

Line 7312: FROM xla_event_types_b a

7308: SELECT a.entity_code
7309: ,a.event_class_code
7310: ,a.event_type_code
7311: ,a.enabled_flag
7312: FROM xla_event_types_b a
7313: WHERE a.application_id = g_application_id;
7314:
7315: l_count INTEGER;
7316: