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 9133: INSERT INTO xla_amb_updated_comps

9129: p_module => l_log_module,
9130: p_level => C_LEVEL_PROCEDURE);
9131: END IF;
9132:
9133: INSERT INTO xla_amb_updated_comps
9134: (amb_updated_comp_id
9135: ,application_id
9136: ,amb_context_code
9137: ,component_type_code

Line 9169: SELECT xla_amb_updated_comps_s.nextval

9165: ,program_update_date
9166: ,program_application_id
9167: ,program_id
9168: ,request_id)
9169: SELECT xla_amb_updated_comps_s.nextval
9170: ,g_application_id
9171: ,g_amb_context_code
9172: ,component_type
9173: ,component_key

Line 9256: INSERT INTO xla_amb_updated_comps

9252: ELSE
9253: l_merge_impact := C_MERGE_IMPACT_UNCHANGED;
9254: END IF;
9255:
9256: INSERT INTO xla_amb_updated_comps
9257: (amb_updated_comp_id
9258: ,application_id
9259: ,amb_context_code
9260: ,component_type_code

Line 9274: SELECT xla_amb_updated_comps_s.nextval

9270: ,program_update_date
9271: ,program_application_id
9272: ,program_id
9273: ,request_id)
9274: SELECT xla_amb_updated_comps_s.nextval
9275: ,g_application_id
9276: ,g_amb_context_code
9277: ,'APPLICATION'
9278: ,TO_CHAR(g_application_id)