9192: ,lookup_type
9193: ,'N'
9194: ,1
9195: ,sysdate
9196: ,xla_environment_pkg.g_usr_id
9197: ,sysdate
9198: ,xla_environment_pkg.g_usr_id
9199: ,xla_environment_pkg.g_login_id
9200: ,sysdate
9194: ,1
9195: ,sysdate
9196: ,xla_environment_pkg.g_usr_id
9197: ,sysdate
9198: ,xla_environment_pkg.g_usr_id
9199: ,xla_environment_pkg.g_login_id
9200: ,sysdate
9201: ,xla_environment_pkg.g_prog_appl_id
9202: ,xla_environment_pkg.g_prog_id
9195: ,sysdate
9196: ,xla_environment_pkg.g_usr_id
9197: ,sysdate
9198: ,xla_environment_pkg.g_usr_id
9199: ,xla_environment_pkg.g_login_id
9200: ,sysdate
9201: ,xla_environment_pkg.g_prog_appl_id
9202: ,xla_environment_pkg.g_prog_id
9203: ,xla_environment_pkg.g_req_Id
9197: ,sysdate
9198: ,xla_environment_pkg.g_usr_id
9199: ,xla_environment_pkg.g_login_id
9200: ,sysdate
9201: ,xla_environment_pkg.g_prog_appl_id
9202: ,xla_environment_pkg.g_prog_id
9203: ,xla_environment_pkg.g_req_Id
9204: FROM (SELECT component_type
9205: ,component_key
9198: ,xla_environment_pkg.g_usr_id
9199: ,xla_environment_pkg.g_login_id
9200: ,sysdate
9201: ,xla_environment_pkg.g_prog_appl_id
9202: ,xla_environment_pkg.g_prog_id
9203: ,xla_environment_pkg.g_req_Id
9204: FROM (SELECT component_type
9205: ,component_key
9206: ,parent_component_type
9199: ,xla_environment_pkg.g_login_id
9200: ,sysdate
9201: ,xla_environment_pkg.g_prog_appl_id
9202: ,xla_environment_pkg.g_prog_id
9203: ,xla_environment_pkg.g_req_Id
9204: FROM (SELECT component_type
9205: ,component_key
9206: ,parent_component_type
9207: ,parent_component_key
9279: ,l_merge_impact
9280: ,'N'
9281: ,1
9282: ,sysdate
9283: ,xla_environment_pkg.g_usr_id
9284: ,sysdate
9285: ,xla_environment_pkg.g_usr_id
9286: ,xla_environment_pkg.g_login_id
9287: ,sysdate
9281: ,1
9282: ,sysdate
9283: ,xla_environment_pkg.g_usr_id
9284: ,sysdate
9285: ,xla_environment_pkg.g_usr_id
9286: ,xla_environment_pkg.g_login_id
9287: ,sysdate
9288: ,xla_environment_pkg.g_prog_appl_id
9289: ,xla_environment_pkg.g_prog_id
9282: ,sysdate
9283: ,xla_environment_pkg.g_usr_id
9284: ,sysdate
9285: ,xla_environment_pkg.g_usr_id
9286: ,xla_environment_pkg.g_login_id
9287: ,sysdate
9288: ,xla_environment_pkg.g_prog_appl_id
9289: ,xla_environment_pkg.g_prog_id
9290: ,xla_environment_pkg.g_req_Id
9284: ,sysdate
9285: ,xla_environment_pkg.g_usr_id
9286: ,xla_environment_pkg.g_login_id
9287: ,sysdate
9288: ,xla_environment_pkg.g_prog_appl_id
9289: ,xla_environment_pkg.g_prog_id
9290: ,xla_environment_pkg.g_req_Id
9291: FROM DUAL;
9292:
9285: ,xla_environment_pkg.g_usr_id
9286: ,xla_environment_pkg.g_login_id
9287: ,sysdate
9288: ,xla_environment_pkg.g_prog_appl_id
9289: ,xla_environment_pkg.g_prog_id
9290: ,xla_environment_pkg.g_req_Id
9291: FROM DUAL;
9292:
9293: UPDATE xla_appli_amb_contexts
9286: ,xla_environment_pkg.g_login_id
9287: ,sysdate
9288: ,xla_environment_pkg.g_prog_appl_id
9289: ,xla_environment_pkg.g_prog_id
9290: ,xla_environment_pkg.g_req_Id
9291: FROM DUAL;
9292:
9293: UPDATE xla_appli_amb_contexts
9294: SET updated_flag = 'N'
9294: SET updated_flag = 'N'
9295: , batch_name = g_batch_name
9296: , last_analyzed_date = sysdate
9297: , last_update_date = sysdate
9298: , last_updated_by = xla_environment_pkg.g_usr_id
9299: , last_update_login = xla_environment_pkg.g_login_id
9300: WHERE application_id = g_application_id
9301: AND amb_context_code = g_amb_context_code;
9302:
9295: , batch_name = g_batch_name
9296: , last_analyzed_date = sysdate
9297: , last_update_date = sysdate
9298: , last_updated_by = xla_environment_pkg.g_usr_id
9299: , last_update_login = xla_environment_pkg.g_login_id
9300: WHERE application_id = g_application_id
9301: AND amb_context_code = g_amb_context_code;
9302:
9303: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN