DBA Data[Home] [Help]

APPS.XLA_ACCT_LINE_TYPES_F_PKG dependencies on XLA_ACCT_LINE_TYPES_B

Line 100: FROM xla_acct_line_types_b

96: IS
97:
98: CURSOR c IS
99: SELECT rowid
100: FROM xla_acct_line_types_b
101: WHERE application_id = x_application_id
102: AND amb_context_code = x_amb_context_code
103: AND entity_code = x_entity_code
104: AND event_class_code = x_event_class_code

Line 121: INSERT INTO xla_acct_line_types_b

117: p_module => l_log_module,
118: p_level => C_LEVEL_PROCEDURE);
119: END IF;
120:
121: INSERT INTO xla_acct_line_types_b
122: (creation_date
123: ,created_by
124: ,amb_context_code
125: ,application_id

Line 284: FROM xla_acct_line_types_b

280: ,business_method_code
281: ,business_class_code
282: ,mpa_option_code
283: ,encumbrance_type_id
284: FROM xla_acct_line_types_b
285: WHERE application_id = x_application_id
286: AND amb_context_code = x_amb_context_code
287: AND entity_code = x_entity_code
288: AND event_class_code = x_event_class_code

Line 436: UPDATE xla_acct_line_types_b

432: p_module => l_log_module,
433: p_level => C_LEVEL_PROCEDURE);
434: END IF;
435:
436: UPDATE xla_acct_line_types_b
437: SET
438: last_update_date = x_last_update_date
439: ,transaction_coa_id = x_transaction_coa_id
440: ,accounting_entry_type_code = x_accounting_entry_type_code

Line 534: DELETE FROM xla_acct_line_types_b

530: IF (SQL%NOTFOUND) THEN
531: RAISE NO_DATA_FOUND;
532: END IF;
533:
534: DELETE FROM xla_acct_line_types_b
535: WHERE application_id = x_application_id
536: AND amb_context_code = x_amb_context_code
537: AND entity_code = x_entity_code
538: AND event_class_code = x_event_class_code

Line 580: FROM xla_acct_line_types_b b

576:
577: DELETE FROM xla_acct_line_types_tl T
578: WHERE NOT EXISTS
579: (SELECT NULL
580: FROM xla_acct_line_types_b b
581: WHERE b.application_id = t.application_id
582: AND b.amb_context_code = t.amb_context_code
583: AND b.entity_code = t.entity_code
584: AND b.event_class_code = t.event_class_code