DBA Data[Home] [Help]

APPS.XLA_DESCRIPTIONS_F_PKG dependencies on XLA_DESCRIPTIONS_B

Line 84: FROM xla_descriptions_b

80: IS
81:
82: CURSOR c IS
83: SELECT rowid
84: FROM xla_descriptions_b
85: WHERE application_id = x_application_id
86: AND amb_context_code = x_amb_context_code
87: AND description_type_code = x_description_type_code
88: AND description_code = x_description_code

Line 103: INSERT INTO xla_descriptions_b

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

Line 206: FROM xla_descriptions_b

202: CURSOR c IS
203: SELECT amb_context_code
204: ,enabled_flag
205: ,transaction_coa_id
206: FROM xla_descriptions_b
207: WHERE application_id = x_application_id
208: AND amb_context_code = x_amb_context_code
209: AND description_type_code = x_description_type_code
210: AND description_code = x_description_code

Line 314: UPDATE xla_descriptions_b

310: p_module => l_log_module,
311: p_level => C_LEVEL_PROCEDURE);
312: END IF;
313:
314: UPDATE xla_descriptions_b
315: SET
316: last_update_date = x_last_update_date
317: ,enabled_flag = x_enabled_flag
318: ,transaction_coa_id = x_transaction_coa_id

Line 391: DELETE FROM xla_descriptions_b

387: IF (SQL%NOTFOUND) THEN
388: RAISE NO_DATA_FOUND;
389: END IF;
390:
391: DELETE FROM xla_descriptions_b
392: WHERE application_id = x_application_id
393: AND amb_context_code = x_amb_context_code
394: AND description_type_code = x_description_type_code
395: AND description_code = x_description_code;

Line 432: FROM xla_descriptions_b b

428:
429: DELETE FROM xla_descriptions_tl T
430: WHERE NOT EXISTS
431: (SELECT NULL
432: FROM xla_descriptions_b b
433: WHERE b.application_id = t.application_id
434: AND b.amb_context_code = t.amb_context_code
435: AND b.description_type_code = t.description_type_code
436: AND b.description_code = t.description_code);