278: END IF;
279:
280: l_creation_date := sysdate;
281: l_last_update_date := sysdate;
282: l_created_by := xla_environment_pkg.g_usr_id;
283: l_last_update_login := xla_environment_pkg.g_login_id;
284: l_last_updated_by := xla_environment_pkg.g_usr_id;
285:
286: OPEN c_description_priorities;
279:
280: l_creation_date := sysdate;
281: l_last_update_date := sysdate;
282: l_created_by := xla_environment_pkg.g_usr_id;
283: l_last_update_login := xla_environment_pkg.g_login_id;
284: l_last_updated_by := xla_environment_pkg.g_usr_id;
285:
286: OPEN c_description_priorities;
287: LOOP
280: l_creation_date := sysdate;
281: l_last_update_date := sysdate;
282: l_created_by := xla_environment_pkg.g_usr_id;
283: l_last_update_login := xla_environment_pkg.g_login_id;
284: l_last_updated_by := xla_environment_pkg.g_usr_id;
285:
286: OPEN c_description_priorities;
287: LOOP
288: FETCH c_description_priorities
1219: ELSE
1220: UPDATE xla_line_definitions_b xld
1221: SET validation_status_code = 'N'
1222: , last_update_date = sysdate
1223: , last_updated_by = xla_environment_pkg.g_usr_id
1224: , last_update_login = xla_environment_pkg.g_login_id
1225: WHERE xld.application_id = p_application_id
1226: AND xld.amb_context_code = p_amb_context_code
1227: AND xld.validation_status_code <> 'N'
1220: UPDATE xla_line_definitions_b xld
1221: SET validation_status_code = 'N'
1222: , last_update_date = sysdate
1223: , last_updated_by = xla_environment_pkg.g_usr_id
1224: , last_update_login = xla_environment_pkg.g_login_id
1225: WHERE xld.application_id = p_application_id
1226: AND xld.amb_context_code = p_amb_context_code
1227: AND xld.validation_status_code <> 'N'
1228: AND EXISTS
1255: UPDATE xla_product_rules_b
1256: SET compile_status_code = 'N'
1257: , updated_flag = 'Y'
1258: , last_update_date = sysdate
1259: , last_updated_by = xla_environment_pkg.g_usr_id
1260: , last_update_login = xla_environment_pkg.g_login_id
1261: WHERE application_id = p_application_id
1262: AND amb_context_code = p_amb_context_code
1263: AND product_rule_type_code = l_product_rule_type_codes(i)
1256: SET compile_status_code = 'N'
1257: , updated_flag = 'Y'
1258: , last_update_date = sysdate
1259: , last_updated_by = xla_environment_pkg.g_usr_id
1260: , last_update_login = xla_environment_pkg.g_login_id
1261: WHERE application_id = p_application_id
1262: AND amb_context_code = p_amb_context_code
1263: AND product_rule_type_code = l_product_rule_type_codes(i)
1264: AND product_rule_code = l_product_rule_codes(i)
1268: FORALL i IN 1..l_event_class_codes.LAST
1269: UPDATE xla_prod_acct_headers
1270: SET validation_status_code = 'N'
1271: , last_update_date = sysdate
1272: , last_updated_by = xla_environment_pkg.g_usr_id
1273: , last_update_login = xla_environment_pkg.g_login_id
1274: WHERE application_id = p_application_id
1275: AND amb_context_code = p_amb_context_code
1276: AND event_class_code = l_event_class_codes(i)
1269: UPDATE xla_prod_acct_headers
1270: SET validation_status_code = 'N'
1271: , last_update_date = sysdate
1272: , last_updated_by = xla_environment_pkg.g_usr_id
1273: , last_update_login = xla_environment_pkg.g_login_id
1274: WHERE application_id = p_application_id
1275: AND amb_context_code = p_amb_context_code
1276: AND event_class_code = l_event_class_codes(i)
1277: AND product_rule_type_code = l_product_rule_type_codes(i)
1282:
1283: UPDATE xla_appli_amb_contexts
1284: SET updated_flag = 'Y'
1285: , last_update_date = sysdate
1286: , last_updated_by = xla_environment_pkg.g_usr_id
1287: , last_update_login = xla_environment_pkg.g_login_id
1288: WHERE application_id = p_application_id
1289: AND amb_context_code = p_amb_context_code
1290: AND updated_flag <> 'Y';
1283: UPDATE xla_appli_amb_contexts
1284: SET updated_flag = 'Y'
1285: , last_update_date = sysdate
1286: , last_updated_by = xla_environment_pkg.g_usr_id
1287: , last_update_login = xla_environment_pkg.g_login_id
1288: WHERE application_id = p_application_id
1289: AND amb_context_code = p_amb_context_code
1290: AND updated_flag <> 'Y';
1291: