11822: ,p_new_accounting_coa_id IN NUMBER)
11823: IS
11824: l_creation_date DATE := sysdate;
11825: l_last_update_date DATE := sysdate;
11826: l_created_by INTEGER := xla_environment_pkg.g_usr_id;
11827: l_last_update_login INTEGER := xla_environment_pkg.g_login_id;
11828: l_last_updated_by INTEGER := xla_environment_pkg.g_usr_id;
11829:
11830: l_log_module VARCHAR2(240);
11823: IS
11824: l_creation_date DATE := sysdate;
11825: l_last_update_date DATE := sysdate;
11826: l_created_by INTEGER := xla_environment_pkg.g_usr_id;
11827: l_last_update_login INTEGER := xla_environment_pkg.g_login_id;
11828: l_last_updated_by INTEGER := xla_environment_pkg.g_usr_id;
11829:
11830: l_log_module VARCHAR2(240);
11831: BEGIN
11824: l_creation_date DATE := sysdate;
11825: l_last_update_date DATE := sysdate;
11826: l_created_by INTEGER := xla_environment_pkg.g_usr_id;
11827: l_last_update_login INTEGER := xla_environment_pkg.g_login_id;
11828: l_last_updated_by INTEGER := xla_environment_pkg.g_usr_id;
11829:
11830: l_log_module VARCHAR2(240);
11831: BEGIN
11832: IF g_log_enabled THEN
13078: UPDATE xla_product_rules_b xpr
13079: SET compile_status_code = 'N'
13080: , updated_flag = 'Y'
13081: , last_update_date = sysdate
13082: , last_updated_by = xla_environment_pkg.g_usr_id
13083: , last_update_login = xla_environment_pkg.g_login_id
13084: WHERE application_id = p_application_id
13085: AND amb_context_code = p_amb_context_code
13086: AND product_rule_type_code = l_product_rule_type_codes(i)
13079: SET compile_status_code = 'N'
13080: , updated_flag = 'Y'
13081: , last_update_date = sysdate
13082: , last_updated_by = xla_environment_pkg.g_usr_id
13083: , last_update_login = xla_environment_pkg.g_login_id
13084: WHERE application_id = p_application_id
13085: AND amb_context_code = p_amb_context_code
13086: AND product_rule_type_code = l_product_rule_type_codes(i)
13087: AND product_rule_code = l_product_rule_codes(i)
13097: FORALL i IN 1..l_event_class_codes.LAST
13098: UPDATE xla_prod_acct_headers xpa
13099: SET validation_status_code = 'N'
13100: , last_update_date = sysdate
13101: , last_updated_by = xla_environment_pkg.g_usr_id
13102: , last_update_login = xla_environment_pkg.g_login_id
13103: WHERE xpa.application_id = p_application_id
13104: AND xpa.amb_context_code = p_amb_context_code
13105: AND xpa.event_class_code = l_event_class_codes(i)
13098: UPDATE xla_prod_acct_headers xpa
13099: SET validation_status_code = 'N'
13100: , last_update_date = sysdate
13101: , last_updated_by = xla_environment_pkg.g_usr_id
13102: , last_update_login = xla_environment_pkg.g_login_id
13103: WHERE xpa.application_id = p_application_id
13104: AND xpa.amb_context_code = p_amb_context_code
13105: AND xpa.event_class_code = l_event_class_codes(i)
13106: AND xpa.product_rule_type_code = l_product_rule_type_codes(i)
13115:
13116: UPDATE xla_appli_amb_contexts
13117: SET updated_flag = 'Y'
13118: , last_update_date = sysdate
13119: , last_updated_by = xla_environment_pkg.g_usr_id
13120: , last_update_login = xla_environment_pkg.g_login_id
13121: WHERE application_id = p_application_id
13122: AND amb_context_code = p_amb_context_code
13123: AND updated_flag <> 'Y';
13116: UPDATE xla_appli_amb_contexts
13117: SET updated_flag = 'Y'
13118: , last_update_date = sysdate
13119: , last_updated_by = xla_environment_pkg.g_usr_id
13120: , last_update_login = xla_environment_pkg.g_login_id
13121: WHERE application_id = p_application_id
13122: AND amb_context_code = p_amb_context_code
13123: AND updated_flag <> 'Y';
13124:
13133:
13134: UPDATE xla_line_definitions_b
13135: SET validation_status_code = 'N'
13136: ,last_update_date = sysdate
13137: ,last_updated_by = xla_environment_pkg.g_usr_id
13138: ,last_update_login = xla_environment_pkg.g_login_id
13139: WHERE application_id = p_application_id
13140: AND amb_context_code = p_amb_context_code
13141: AND event_class_code = p_event_class_code
13134: UPDATE xla_line_definitions_b
13135: SET validation_status_code = 'N'
13136: ,last_update_date = sysdate
13137: ,last_updated_by = xla_environment_pkg.g_usr_id
13138: ,last_update_login = xla_environment_pkg.g_login_id
13139: WHERE application_id = p_application_id
13140: AND amb_context_code = p_amb_context_code
13141: AND event_class_code = p_event_class_code
13142: AND event_type_code = p_event_type_code
13272: IS
13273:
13274: l_creation_date DATE := sysdate;
13275: l_last_update_date DATE := sysdate;
13276: l_created_by INTEGER := xla_environment_pkg.g_usr_id;
13277: l_last_update_login INTEGER := xla_environment_pkg.g_login_id;
13278: l_last_updated_by INTEGER := xla_environment_pkg.g_usr_id;
13279:
13280: l_log_module VARCHAR2(240);
13273:
13274: l_creation_date DATE := sysdate;
13275: l_last_update_date DATE := sysdate;
13276: l_created_by INTEGER := xla_environment_pkg.g_usr_id;
13277: l_last_update_login INTEGER := xla_environment_pkg.g_login_id;
13278: l_last_updated_by INTEGER := xla_environment_pkg.g_usr_id;
13279:
13280: l_log_module VARCHAR2(240);
13281: BEGIN
13274: l_creation_date DATE := sysdate;
13275: l_last_update_date DATE := sysdate;
13276: l_created_by INTEGER := xla_environment_pkg.g_usr_id;
13277: l_last_update_login INTEGER := xla_environment_pkg.g_login_id;
13278: l_last_updated_by INTEGER := xla_environment_pkg.g_usr_id;
13279:
13280: l_log_module VARCHAR2(240);
13281: BEGIN
13282: IF g_log_enabled THEN
13841: ,p_level => C_LEVEL_STATEMENT);
13842: END IF;
13843:
13844: -- Set environment settings
13845: xla_environment_pkg.refresh;
13846:
13847: -- Initialize the error package
13848: xla_amb_setup_err_pkg.initialize;
13849: