APPS.XLA_ANALYTICAL_HDRS_PKG dependencies on XLA_ENVIRONMENT_PKG

Line 283: , last_updated_by = xla_environment_pkg.g_usr_id

279:
280: UPDATE xla_line_definitions_b xld
281: SET validation_status_code = 'N'
282: , last_update_date = sysdate
283: , last_updated_by = xla_environment_pkg.g_usr_id
284: , last_update_login = xla_environment_pkg.g_login_id
285: WHERE xld.amb_context_code = p_amb_context_code
286: AND xld.validation_status_code <> 'N'
287: AND EXISTS

Line 284: , last_update_login = xla_environment_pkg.g_login_id

280: UPDATE xla_line_definitions_b xld
281: SET validation_status_code = 'N'
282: , last_update_date = sysdate
283: , last_updated_by = xla_environment_pkg.g_usr_id
284: , last_update_login = xla_environment_pkg.g_login_id
285: WHERE xld.amb_context_code = p_amb_context_code
286: AND xld.validation_status_code <> 'N'
287: AND EXISTS
288: (SELECT 'X'

Line 319: , last_updated_by = xla_environment_pkg.g_usr_id

315: UPDATE xla_product_rules_b
316: SET compile_status_code = 'N'
317: , updated_flag = 'Y'
318: , last_update_date = sysdate
319: , last_updated_by = xla_environment_pkg.g_usr_id
320: , last_update_login = xla_environment_pkg.g_login_id
321: WHERE application_id = l_application_ids(i)
322: AND amb_context_code = p_amb_context_code
323: AND product_rule_type_code = l_product_rule_type_codes(i)

Line 320: , last_update_login = xla_environment_pkg.g_login_id

316: SET compile_status_code = 'N'
317: , updated_flag = 'Y'
318: , last_update_date = sysdate
319: , last_updated_by = xla_environment_pkg.g_usr_id
320: , last_update_login = xla_environment_pkg.g_login_id
321: WHERE application_id = l_application_ids(i)
322: AND amb_context_code = p_amb_context_code
323: AND product_rule_type_code = l_product_rule_type_codes(i)
324: AND product_rule_code = l_product_rule_codes(i)

Line 332: , last_updated_by = xla_environment_pkg.g_usr_id

328: FORALL i IN 1..l_event_class_codes.LAST
329: UPDATE xla_prod_acct_headers
330: SET validation_status_code = 'N'
331: , last_update_date = sysdate
332: , last_updated_by = xla_environment_pkg.g_usr_id
333: , last_update_login = xla_environment_pkg.g_login_id
334: WHERE application_id = l_application_ids(i)
335: AND amb_context_code = p_amb_context_code
336: AND event_class_code = l_event_class_codes(i)

Line 333: , last_update_login = xla_environment_pkg.g_login_id

329: UPDATE xla_prod_acct_headers
330: SET validation_status_code = 'N'
331: , last_update_date = sysdate
332: , last_updated_by = xla_environment_pkg.g_usr_id
333: , last_update_login = xla_environment_pkg.g_login_id
334: WHERE application_id = l_application_ids(i)
335: AND amb_context_code = p_amb_context_code
336: AND event_class_code = l_event_class_codes(i)
337: AND product_rule_type_code = l_product_rule_type_codes(i)

Line 345: , last_updated_by = xla_environment_pkg.g_usr_id

341: FORALL i IN 1..l_application_ids.LAST
342: UPDATE xla_appli_amb_contexts
343: SET updated_flag = 'Y'
344: , last_update_date = sysdate
345: , last_updated_by = xla_environment_pkg.g_usr_id
346: , last_update_login = xla_environment_pkg.g_login_id
347: WHERE application_id = l_application_ids(i)
348: AND amb_context_code = p_amb_context_code
349: AND updated_flag <> 'Y';

Line 346: , last_update_login = xla_environment_pkg.g_login_id

342: UPDATE xla_appli_amb_contexts
343: SET updated_flag = 'Y'
344: , last_update_date = sysdate
345: , last_updated_by = xla_environment_pkg.g_usr_id
346: , last_update_login = xla_environment_pkg.g_login_id
347: WHERE application_id = l_application_ids(i)
348: AND amb_context_code = p_amb_context_code
349: AND updated_flag <> 'Y';
350: