320: ,product_rule_type_code
321: ,version_num
322: ,1
323: ,sysdate
324: ,xla_environment_pkg.g_usr_id
325: ,sysdate
326: ,xla_environment_pkg.g_usr_id
327: ,xla_environment_pkg.g_login_id
328: ,sysdate
322: ,1
323: ,sysdate
324: ,xla_environment_pkg.g_usr_id
325: ,sysdate
326: ,xla_environment_pkg.g_usr_id
327: ,xla_environment_pkg.g_login_id
328: ,sysdate
329: ,xla_environment_pkg.g_prog_appl_id
330: ,xla_environment_pkg.g_prog_id
323: ,sysdate
324: ,xla_environment_pkg.g_usr_id
325: ,sysdate
326: ,xla_environment_pkg.g_usr_id
327: ,xla_environment_pkg.g_login_id
328: ,sysdate
329: ,xla_environment_pkg.g_prog_appl_id
330: ,xla_environment_pkg.g_prog_id
331: ,xla_environment_pkg.g_req_Id
325: ,sysdate
326: ,xla_environment_pkg.g_usr_id
327: ,xla_environment_pkg.g_login_id
328: ,sysdate
329: ,xla_environment_pkg.g_prog_appl_id
330: ,xla_environment_pkg.g_prog_id
331: ,xla_environment_pkg.g_req_Id
332: FROM xla_product_rules_b
333: WHERE application_id = p_application_id
326: ,xla_environment_pkg.g_usr_id
327: ,xla_environment_pkg.g_login_id
328: ,sysdate
329: ,xla_environment_pkg.g_prog_appl_id
330: ,xla_environment_pkg.g_prog_id
331: ,xla_environment_pkg.g_req_Id
332: FROM xla_product_rules_b
333: WHERE application_id = p_application_id
334: AND amb_context_code = p_staging_context_code;
327: ,xla_environment_pkg.g_login_id
328: ,sysdate
329: ,xla_environment_pkg.g_prog_appl_id
330: ,xla_environment_pkg.g_prog_id
331: ,xla_environment_pkg.g_req_Id
332: FROM xla_product_rules_b
333: WHERE application_id = p_application_id
334: AND amb_context_code = p_staging_context_code;
335:
383:
384: UPDATE xla_appli_amb_contexts
385: SET updated_flag = 'Y'
386: ,creation_date = sysdate
387: ,created_by = xla_environment_pkg.g_usr_id
388: ,last_update_date = sysdate
389: ,last_updated_by = xla_environment_pkg.g_usr_id
390: ,last_update_login = xla_environment_pkg.g_login_id
391: WHERE amb_context_code = p_amb_context_code
385: SET updated_flag = 'Y'
386: ,creation_date = sysdate
387: ,created_by = xla_environment_pkg.g_usr_id
388: ,last_update_date = sysdate
389: ,last_updated_by = xla_environment_pkg.g_usr_id
390: ,last_update_login = xla_environment_pkg.g_login_id
391: WHERE amb_context_code = p_amb_context_code
392: AND application_id = p_application_id;
393:
386: ,creation_date = sysdate
387: ,created_by = xla_environment_pkg.g_usr_id
388: ,last_update_date = sysdate
389: ,last_updated_by = xla_environment_pkg.g_usr_id
390: ,last_update_login = xla_environment_pkg.g_login_id
391: WHERE amb_context_code = p_amb_context_code
392: AND application_id = p_application_id;
393:
394: record_log(p_application_id => p_application_id