DBA Data[Home] [Help]

APPS.XLA_EVENT_TYPES_F_PKG dependencies on XLA_EVENT_TYPES_B

Line 89: FROM xla_event_types_b

85: IS
86:
87: CURSOR c IS
88: SELECT rowid
89: FROM xla_event_types_b
90: WHERE application_id = x_application_id
91: AND entity_code = x_entity_code
92: AND event_class_code = x_event_class_code
93: AND event_type_code = x_event_type_code

Line 109: INSERT INTO xla_event_types_b

105: p_module => l_log_module,
106: p_level => C_LEVEL_PROCEDURE);
107: END IF;
108:
109: INSERT INTO xla_event_types_b
110: (creation_date
111: ,created_by
112: ,application_id
113: ,entity_code

Line 216: FROM xla_event_types_b

212: SELECT application_id
213: ,accounting_flag
214: ,tax_flag
215: ,enabled_flag
216: FROM xla_event_types_b
217: WHERE application_id = x_application_id
218: AND entity_code = x_entity_code
219: AND event_class_code = x_event_class_code
220: AND event_type_code = x_event_type_code

Line 330: UPDATE xla_event_types_b

326: p_module => l_log_module,
327: p_level => C_LEVEL_PROCEDURE);
328: END IF;
329:
330: UPDATE xla_event_types_b
331: SET
332: last_update_date = x_last_update_date
333: ,accounting_flag = x_accounting_flag
334: ,tax_flag = x_tax_flag

Line 410: DELETE FROM xla_event_types_b

406: IF (SQL%NOTFOUND) THEN
407: RAISE NO_DATA_FOUND;
408: END IF;
409:
410: DELETE FROM xla_event_types_b
411: WHERE application_id = x_application_id
412: AND entity_code = x_entity_code
413: AND event_class_code = x_event_class_code
414: AND event_type_code = x_event_type_code;

Line 456: FROM xla_event_types_b b

452:
453: DELETE FROM xla_event_types_tl T
454: WHERE NOT EXISTS
455: (SELECT NULL
456: FROM xla_event_types_b b
457: WHERE b.application_id = t.application_id
458: AND b.entity_code = t.entity_code
459: AND b.event_class_code = t.event_class_code
460: AND b.event_type_code = t.event_type_code);