DBA Data[Home] [Help]

APPS.XLA_DESCRIPTIONS_PKG dependencies on XLA_ENVIRONMENT_PKG

Line 282: l_created_by := xla_environment_pkg.g_usr_id;

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;

Line 283: l_last_update_login := xla_environment_pkg.g_login_id;

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

Line 284: l_last_updated_by := xla_environment_pkg.g_usr_id;

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

Line 1223: , last_updated_by = xla_environment_pkg.g_usr_id

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'

Line 1224: , last_update_login = xla_environment_pkg.g_login_id

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

Line 1259: , last_updated_by = xla_environment_pkg.g_usr_id

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)

Line 1260: , last_update_login = xla_environment_pkg.g_login_id

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)

Line 1272: , last_updated_by = xla_environment_pkg.g_usr_id

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)

Line 1273: , last_update_login = xla_environment_pkg.g_login_id

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)

Line 1286: , last_updated_by = xla_environment_pkg.g_usr_id

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';

Line 1287: , last_update_login = xla_environment_pkg.g_login_id

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: