APPS.XLA_MAPPING_SETS_F_PKG dependencies on XLA_MAPPING_SETS_B

Line 88: FROM xla_mapping_sets_b

84: IS
85:
86: CURSOR c IS
87: SELECT rowid
88: FROM xla_mapping_sets_b
89: WHERE mapping_set_code = x_mapping_set_code
90: AND amb_context_code = x_amb_context_code
91: ;
92:

Line 106: INSERT INTO xla_mapping_sets_b

102: p_level => C_LEVEL_PROCEDURE);
103: END IF;
104:
105:
106: INSERT INTO xla_mapping_sets_b
107: (creation_date
108: ,created_by
109: ,amb_context_code
110: ,view_application_id

Line 225: FROM xla_mapping_sets_b

221: ,flexfield_assign_mode_code
222: ,flexfield_segment_code
223: ,enabled_flag
224: ,flex_value_set_id
225: FROM xla_mapping_sets_b
226: WHERE mapping_set_code = x_mapping_set_code
227: AND amb_context_code = x_amb_context_code
228: FOR UPDATE OF mapping_set_code NOWAIT;
229:

Line 353: UPDATE xla_mapping_sets_b

349: p_module => l_log_module,
350: p_level => C_LEVEL_PROCEDURE);
351: END IF;
352:
353: UPDATE xla_mapping_sets_b
354: SET
355: last_update_date = x_last_update_date
356: ,view_application_id = x_view_application_id
357: ,lookup_type = x_lookup_type

Line 430: DELETE FROM xla_mapping_sets_b

426: IF (SQL%NOTFOUND) THEN
427: RAISE NO_DATA_FOUND;
428: END IF;
429:
430: DELETE FROM xla_mapping_sets_b
431: WHERE mapping_set_code = x_mapping_set_code
432: AND amb_context_code = x_amb_context_code;
433:
434:

Line 473: FROM xla_mapping_sets_b b

469:
470: DELETE FROM xla_mapping_sets_tl T
471: WHERE NOT EXISTS
472: (SELECT NULL
473: FROM xla_mapping_sets_b b
474: WHERE b.mapping_set_code = t.mapping_set_code
475: AND b.amb_context_code = t.amb_context_code);
476:
477: UPDATE xla_mapping_sets_tl t