DBA Data[Home] [Help]

APPS.XLA_EVENT_MAPPINGS_F_PKG dependencies on XLA_EVENT_MAPPINGS_B

Line 86: FROM xla_event_mappings_b

82: IS
83:
84: CURSOR c IS
85: SELECT rowid
86: FROM xla_event_mappings_b
87: WHERE event_mapping_id = x_event_mapping_id
88: ;
89:
90: l_log_module VARCHAR2(240);

Line 103: INSERT INTO xla_event_mappings_b

99: p_module => l_log_module,
100: p_level => C_LEVEL_PROCEDURE);
101: END IF;
102:
103: INSERT INTO xla_event_mappings_b
104: (creation_date
105: ,created_by
106: ,event_mapping_id
107: ,application_id

Line 197: FROM xla_event_mappings_b

193: ,entity_code
194: ,event_class_code
195: ,user_sequence
196: ,column_name
197: FROM xla_event_mappings_b
198: WHERE event_mapping_id = x_event_mapping_id
199: FOR UPDATE OF event_mapping_id NOWAIT;
200:
201: recinfo c%ROWTYPE;

Line 301: UPDATE xla_event_mappings_b

297: p_module => l_log_module,
298: p_level => C_LEVEL_PROCEDURE);
299: END IF;
300:
301: UPDATE xla_event_mappings_b
302: SET
303: last_update_date = x_last_update_date
304: ,application_id = x_application_id
305: ,entity_code = x_entity_code

Line 370: DELETE FROM xla_event_mappings_b

366: IF (SQL%NOTFOUND) THEN
367: RAISE NO_DATA_FOUND;
368: END IF;
369:
370: DELETE FROM xla_event_mappings_b
371: WHERE event_mapping_id = x_event_mapping_id;
372:
373:
374: IF (SQL%NOTFOUND) THEN

Line 412: FROM xla_event_mappings_b b

408:
409: DELETE FROM xla_event_mappings_tl T
410: WHERE NOT EXISTS
411: (SELECT NULL
412: FROM xla_event_mappings_b b
413: WHERE b.event_mapping_id = t.event_mapping_id);
414:
415: UPDATE xla_event_mappings_tl t
416: SET (column_title)

Line 574: FROM xla_event_mappings_b

570: WHEN TOO_MANY_ROWS THEN
571: DELETE FROM xla_event_mappings_tl
572: WHERE event_mapping_id IN
573: (SELECT event_mapping_id
574: FROM xla_event_mappings_b
575: WHERE application_id = l_application_id
576: AND entity_code = p_entity_code
577: AND event_class_code = p_event_class_code
578: AND (user_sequence = p_user_sequence or

Line 581: DELETE FROM xla_event_mappings_b

577: AND event_class_code = p_event_class_code
578: AND (user_sequence = p_user_sequence or
579: column_name = p_column_name));
580:
581: DELETE FROM xla_event_mappings_b
582: WHERE application_id = l_application_id
583: AND entity_code = p_entity_code
584: AND event_class_code = p_event_class_code
585: AND (user_sequence = p_user_sequence or