9202: ,lookup_type
9203: ,'N'
9204: ,1
9205: ,sysdate
9206: ,xla_environment_pkg.g_usr_id
9207: ,sysdate
9208: ,xla_environment_pkg.g_usr_id
9209: ,xla_environment_pkg.g_login_id
9210: ,sysdate
9204: ,1
9205: ,sysdate
9206: ,xla_environment_pkg.g_usr_id
9207: ,sysdate
9208: ,xla_environment_pkg.g_usr_id
9209: ,xla_environment_pkg.g_login_id
9210: ,sysdate
9211: ,xla_environment_pkg.g_prog_appl_id
9212: ,xla_environment_pkg.g_prog_id
9205: ,sysdate
9206: ,xla_environment_pkg.g_usr_id
9207: ,sysdate
9208: ,xla_environment_pkg.g_usr_id
9209: ,xla_environment_pkg.g_login_id
9210: ,sysdate
9211: ,xla_environment_pkg.g_prog_appl_id
9212: ,xla_environment_pkg.g_prog_id
9213: ,xla_environment_pkg.g_req_Id
9207: ,sysdate
9208: ,xla_environment_pkg.g_usr_id
9209: ,xla_environment_pkg.g_login_id
9210: ,sysdate
9211: ,xla_environment_pkg.g_prog_appl_id
9212: ,xla_environment_pkg.g_prog_id
9213: ,xla_environment_pkg.g_req_Id
9214: FROM (SELECT component_type
9215: ,component_key
9208: ,xla_environment_pkg.g_usr_id
9209: ,xla_environment_pkg.g_login_id
9210: ,sysdate
9211: ,xla_environment_pkg.g_prog_appl_id
9212: ,xla_environment_pkg.g_prog_id
9213: ,xla_environment_pkg.g_req_Id
9214: FROM (SELECT component_type
9215: ,component_key
9216: ,parent_component_type
9209: ,xla_environment_pkg.g_login_id
9210: ,sysdate
9211: ,xla_environment_pkg.g_prog_appl_id
9212: ,xla_environment_pkg.g_prog_id
9213: ,xla_environment_pkg.g_req_Id
9214: FROM (SELECT component_type
9215: ,component_key
9216: ,parent_component_type
9217: ,parent_component_key
9289: ,l_merge_impact
9290: ,'N'
9291: ,1
9292: ,sysdate
9293: ,xla_environment_pkg.g_usr_id
9294: ,sysdate
9295: ,xla_environment_pkg.g_usr_id
9296: ,xla_environment_pkg.g_login_id
9297: ,sysdate
9291: ,1
9292: ,sysdate
9293: ,xla_environment_pkg.g_usr_id
9294: ,sysdate
9295: ,xla_environment_pkg.g_usr_id
9296: ,xla_environment_pkg.g_login_id
9297: ,sysdate
9298: ,xla_environment_pkg.g_prog_appl_id
9299: ,xla_environment_pkg.g_prog_id
9292: ,sysdate
9293: ,xla_environment_pkg.g_usr_id
9294: ,sysdate
9295: ,xla_environment_pkg.g_usr_id
9296: ,xla_environment_pkg.g_login_id
9297: ,sysdate
9298: ,xla_environment_pkg.g_prog_appl_id
9299: ,xla_environment_pkg.g_prog_id
9300: ,xla_environment_pkg.g_req_Id
9294: ,sysdate
9295: ,xla_environment_pkg.g_usr_id
9296: ,xla_environment_pkg.g_login_id
9297: ,sysdate
9298: ,xla_environment_pkg.g_prog_appl_id
9299: ,xla_environment_pkg.g_prog_id
9300: ,xla_environment_pkg.g_req_Id
9301: FROM DUAL;
9302:
9295: ,xla_environment_pkg.g_usr_id
9296: ,xla_environment_pkg.g_login_id
9297: ,sysdate
9298: ,xla_environment_pkg.g_prog_appl_id
9299: ,xla_environment_pkg.g_prog_id
9300: ,xla_environment_pkg.g_req_Id
9301: FROM DUAL;
9302:
9303: UPDATE xla_appli_amb_contexts
9296: ,xla_environment_pkg.g_login_id
9297: ,sysdate
9298: ,xla_environment_pkg.g_prog_appl_id
9299: ,xla_environment_pkg.g_prog_id
9300: ,xla_environment_pkg.g_req_Id
9301: FROM DUAL;
9302:
9303: UPDATE xla_appli_amb_contexts
9304: SET updated_flag = 'N'
9304: SET updated_flag = 'N'
9305: , batch_name = g_batch_name
9306: , last_analyzed_date = sysdate
9307: , last_update_date = sysdate
9308: , last_updated_by = xla_environment_pkg.g_usr_id
9309: , last_update_login = xla_environment_pkg.g_login_id
9310: WHERE application_id = g_application_id
9311: AND amb_context_code = g_amb_context_code;
9312:
9305: , batch_name = g_batch_name
9306: , last_analyzed_date = sysdate
9307: , last_update_date = sysdate
9308: , last_updated_by = xla_environment_pkg.g_usr_id
9309: , last_update_login = xla_environment_pkg.g_login_id
9310: WHERE application_id = g_application_id
9311: AND amb_context_code = g_amb_context_code;
9312:
9313: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN