DBA Data[Home] [Help]

APPS.XLA_LINE_DEFINITIONS_PVT dependencies on XLA_ENVIRONMENT_PKG

Line 11826: l_created_by INTEGER := xla_environment_pkg.g_usr_id;

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

Line 11827: l_last_update_login INTEGER := xla_environment_pkg.g_login_id;

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

Line 11828: l_last_updated_by INTEGER := xla_environment_pkg.g_usr_id;

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

Line 13082: , last_updated_by = xla_environment_pkg.g_usr_id

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)

Line 13083: , last_update_login = xla_environment_pkg.g_login_id

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)

Line 13101: , last_updated_by = xla_environment_pkg.g_usr_id

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)

Line 13102: , last_update_login = xla_environment_pkg.g_login_id

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)

Line 13119: , last_updated_by = xla_environment_pkg.g_usr_id

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

Line 13120: , last_update_login = xla_environment_pkg.g_login_id

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:

Line 13137: ,last_updated_by = xla_environment_pkg.g_usr_id

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

Line 13138: ,last_update_login = xla_environment_pkg.g_login_id

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

Line 13276: l_created_by INTEGER := xla_environment_pkg.g_usr_id;

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

Line 13277: l_last_update_login INTEGER := xla_environment_pkg.g_login_id;

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

Line 13278: l_last_updated_by INTEGER := xla_environment_pkg.g_usr_id;

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

Line 13845: xla_environment_pkg.refresh;

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: