APPS.XLA_AAD_MERGE_ANALYSIS_PVT dependencies on XLA_AMB_UPDATED_COMPS

Line 159: DELETE FROM xla_amb_updated_comps

155: l_retcode := 'ERROR';
156: END IF;
157: END IF;
158:
159: DELETE FROM xla_amb_updated_comps
160: WHERE application_id = g_application_id
161: AND amb_context_code = g_amb_context_code;
162:
163: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN

Line 9143: INSERT INTO xla_amb_updated_comps

9139: p_module => l_log_module,
9140: p_level => C_LEVEL_PROCEDURE);
9141: END IF;
9142:
9143: INSERT INTO xla_amb_updated_comps
9144: (amb_updated_comp_id
9145: ,application_id
9146: ,amb_context_code
9147: ,component_type_code

Line 9179: SELECT xla_amb_updated_comps_s.nextval

9175: ,program_update_date
9176: ,program_application_id
9177: ,program_id
9178: ,request_id)
9179: SELECT xla_amb_updated_comps_s.nextval
9180: ,g_application_id
9181: ,g_amb_context_code
9182: ,component_type
9183: ,component_key

Line 9266: INSERT INTO xla_amb_updated_comps

9262: ELSE
9263: l_merge_impact := C_MERGE_IMPACT_UNCHANGED;
9264: END IF;
9265:
9266: INSERT INTO xla_amb_updated_comps
9267: (amb_updated_comp_id
9268: ,application_id
9269: ,amb_context_code
9270: ,component_type_code

Line 9284: SELECT xla_amb_updated_comps_s.nextval

9280: ,program_update_date
9281: ,program_application_id
9282: ,program_id
9283: ,request_id)
9284: SELECT xla_amb_updated_comps_s.nextval
9285: ,g_application_id
9286: ,g_amb_context_code
9287: ,'APPLICATION'
9288: ,TO_CHAR(g_application_id)