DBA Data[Home] [Help]

APPS.XLA_LINE_DEFINITIONS_F_PVT dependencies on XLA_LINE_DEFINITIONS_B

Line 74: FROM xla_line_definitions_b

70: IS
71:
72: CURSOR c IS
73: SELECT rowid
74: FROM xla_line_definitions_b
75: WHERE application_id = x_application_id
76: AND amb_context_code = x_amb_context_code
77: AND event_class_code = x_event_class_code
78: AND event_type_code = x_event_type_code

Line 96: INSERT INTO xla_line_definitions_b

92: p_module => l_log_module,
93: p_level => C_LEVEL_PROCEDURE);
94: END IF;
95:
96: INSERT INTO xla_line_definitions_b
97: (creation_date
98: ,created_by
99: ,application_id
100: ,amb_context_code

Line 225: FROM xla_line_definitions_b

221: SELECT enabled_flag
222: ,transaction_coa_id
223: ,accounting_coa_id
224: ,budgetary_control_flag
225: FROM xla_line_definitions_b
226: WHERE application_id = x_application_id
227: AND amb_context_code = x_amb_context_code
228: AND event_class_code = x_event_class_code
229: AND event_type_code = x_event_type_code

Line 348: UPDATE xla_line_definitions_b

344: p_module => l_log_module,
345: p_level => C_LEVEL_PROCEDURE);
346: END IF;
347:
348: UPDATE xla_line_definitions_b
349: SET
350: last_update_date = x_last_update_date
351: ,validation_status_code = x_validation_status_code
352: ,enabled_flag = x_enabled_flag

Line 439: DELETE FROM xla_line_definitions_b

435: IF (SQL%NOTFOUND) THEN
436: RAISE NO_DATA_FOUND;
437: END IF;
438:
439: DELETE FROM xla_line_definitions_b
440: WHERE application_id = x_application_id
441: AND amb_context_code = x_amb_context_code
442: AND event_class_code = x_event_class_code
443: AND event_type_code = x_event_type_code

Line 482: FROM xla_line_definitions_b b

478:
479: DELETE FROM xla_line_definitions_tl T
480: WHERE NOT EXISTS
481: (SELECT NULL
482: FROM xla_line_definitions_b b
483: WHERE b.application_id = t.application_id
484: AND b.amb_context_code = t.amb_context_code
485: AND b.event_class_code = t.event_class_code
486: AND b.event_type_code = t.event_type_code