460: ,product_rule_type_code
461: ,version_num
462: ,1
463: ,sysdate
464: ,xla_environment_pkg.g_usr_id
465: ,sysdate
466: ,xla_environment_pkg.g_usr_id
467: ,xla_environment_pkg.g_login_id
468: ,sysdate
462: ,1
463: ,sysdate
464: ,xla_environment_pkg.g_usr_id
465: ,sysdate
466: ,xla_environment_pkg.g_usr_id
467: ,xla_environment_pkg.g_login_id
468: ,sysdate
469: ,xla_environment_pkg.g_prog_appl_id
470: ,xla_environment_pkg.g_prog_id
463: ,sysdate
464: ,xla_environment_pkg.g_usr_id
465: ,sysdate
466: ,xla_environment_pkg.g_usr_id
467: ,xla_environment_pkg.g_login_id
468: ,sysdate
469: ,xla_environment_pkg.g_prog_appl_id
470: ,xla_environment_pkg.g_prog_id
471: ,xla_environment_pkg.g_req_Id
465: ,sysdate
466: ,xla_environment_pkg.g_usr_id
467: ,xla_environment_pkg.g_login_id
468: ,sysdate
469: ,xla_environment_pkg.g_prog_appl_id
470: ,xla_environment_pkg.g_prog_id
471: ,xla_environment_pkg.g_req_Id
472: FROM xla_product_rules_b
473: WHERE application_id = p_application_id
466: ,xla_environment_pkg.g_usr_id
467: ,xla_environment_pkg.g_login_id
468: ,sysdate
469: ,xla_environment_pkg.g_prog_appl_id
470: ,xla_environment_pkg.g_prog_id
471: ,xla_environment_pkg.g_req_Id
472: FROM xla_product_rules_b
473: WHERE application_id = p_application_id
474: AND amb_context_code = p_staging_context_code;
467: ,xla_environment_pkg.g_login_id
468: ,sysdate
469: ,xla_environment_pkg.g_prog_appl_id
470: ,xla_environment_pkg.g_prog_id
471: ,xla_environment_pkg.g_req_Id
472: FROM xla_product_rules_b
473: WHERE application_id = p_application_id
474: AND amb_context_code = p_staging_context_code;
475:
523:
524: UPDATE xla_appli_amb_contexts
525: SET updated_flag = 'Y'
526: ,creation_date = sysdate
527: ,created_by = xla_environment_pkg.g_usr_id
528: ,last_update_date = sysdate
529: ,last_updated_by = xla_environment_pkg.g_usr_id
530: ,last_update_login = xla_environment_pkg.g_login_id
531: WHERE amb_context_code = p_amb_context_code
525: SET updated_flag = 'Y'
526: ,creation_date = sysdate
527: ,created_by = xla_environment_pkg.g_usr_id
528: ,last_update_date = sysdate
529: ,last_updated_by = xla_environment_pkg.g_usr_id
530: ,last_update_login = xla_environment_pkg.g_login_id
531: WHERE amb_context_code = p_amb_context_code
532: AND application_id = p_application_id;
533:
526: ,creation_date = sysdate
527: ,created_by = xla_environment_pkg.g_usr_id
528: ,last_update_date = sysdate
529: ,last_updated_by = xla_environment_pkg.g_usr_id
530: ,last_update_login = xla_environment_pkg.g_login_id
531: WHERE amb_context_code = p_amb_context_code
532: AND application_id = p_application_id;
533:
534: record_log(p_application_id => p_application_id