APPS.XLA_AAD_LOADER_UTIL_PVT dependencies on XLA_ENVIRONMENT_PKG

Line 136: ,xla_environment_pkg.g_usr_id

132: ,NULL
133: ,NULL
134: ,1
135: ,sysdate
136: ,xla_environment_pkg.g_usr_id
137: ,sysdate
138: ,xla_environment_pkg.g_usr_id
139: ,xla_environment_pkg.g_login_id
140: FROM dual

Line 138: ,xla_environment_pkg.g_usr_id

134: ,1
135: ,sysdate
136: ,xla_environment_pkg.g_usr_id
137: ,sysdate
138: ,xla_environment_pkg.g_usr_id
139: ,xla_environment_pkg.g_login_id
140: FROM dual
141: WHERE NOT EXISTS (SELECT 1
142: FROM xla_appli_amb_contexts

Line 139: ,xla_environment_pkg.g_login_id

135: ,sysdate
136: ,xla_environment_pkg.g_usr_id
137: ,sysdate
138: ,xla_environment_pkg.g_usr_id
139: ,xla_environment_pkg.g_login_id
140: FROM dual
141: WHERE NOT EXISTS (SELECT 1
142: FROM xla_appli_amb_contexts
143: WHERE staging_amb_context_code = l_code);

Line 1896: ,xla_environment_pkg.g_usr_id

1892: ,s.version_comment
1893: ,s.leapfrog_flag
1894: ,1
1895: ,sysdate
1896: ,xla_environment_pkg.g_usr_id
1897: ,sysdate
1898: ,xla_environment_pkg.g_usr_id
1899: ,xla_environment_pkg.g_login_id
1900: ,sysdate

Line 1898: ,xla_environment_pkg.g_usr_id

1894: ,1
1895: ,sysdate
1896: ,xla_environment_pkg.g_usr_id
1897: ,sysdate
1898: ,xla_environment_pkg.g_usr_id
1899: ,xla_environment_pkg.g_login_id
1900: ,sysdate
1901: ,xla_environment_pkg.g_prog_appl_id
1902: ,xla_environment_pkg.g_prog_id

Line 1899: ,xla_environment_pkg.g_login_id

1895: ,sysdate
1896: ,xla_environment_pkg.g_usr_id
1897: ,sysdate
1898: ,xla_environment_pkg.g_usr_id
1899: ,xla_environment_pkg.g_login_id
1900: ,sysdate
1901: ,xla_environment_pkg.g_prog_appl_id
1902: ,xla_environment_pkg.g_prog_id
1903: ,xla_environment_pkg.g_req_Id

Line 1901: ,xla_environment_pkg.g_prog_appl_id

1897: ,sysdate
1898: ,xla_environment_pkg.g_usr_id
1899: ,xla_environment_pkg.g_login_id
1900: ,sysdate
1901: ,xla_environment_pkg.g_prog_appl_id
1902: ,xla_environment_pkg.g_prog_id
1903: ,xla_environment_pkg.g_req_Id
1904: FROM xla_staging_components_h s
1905: WHERE s.application_id = p_application_id

Line 1902: ,xla_environment_pkg.g_prog_id

1898: ,xla_environment_pkg.g_usr_id
1899: ,xla_environment_pkg.g_login_id
1900: ,sysdate
1901: ,xla_environment_pkg.g_prog_appl_id
1902: ,xla_environment_pkg.g_prog_id
1903: ,xla_environment_pkg.g_req_Id
1904: FROM xla_staging_components_h s
1905: WHERE s.application_id = p_application_id
1906: AND s.staging_amb_context_code = p_staging_context_code

Line 1903: ,xla_environment_pkg.g_req_Id

1899: ,xla_environment_pkg.g_login_id
1900: ,sysdate
1901: ,xla_environment_pkg.g_prog_appl_id
1902: ,xla_environment_pkg.g_prog_id
1903: ,xla_environment_pkg.g_req_Id
1904: FROM xla_staging_components_h s
1905: WHERE s.application_id = p_application_id
1906: AND s.staging_amb_context_code = p_staging_context_code
1907: AND s.component_type_code = 'AAD'

Line 1987: ,xla_environment_pkg.g_usr_id

1983: ,s.base_version_num
1984: ,s.leapfrog_flag
1985: ,1
1986: ,sysdate
1987: ,xla_environment_pkg.g_usr_id
1988: ,sysdate
1989: ,xla_environment_pkg.g_usr_id
1990: ,xla_environment_pkg.g_login_id
1991: ,sysdate

Line 1989: ,xla_environment_pkg.g_usr_id

1985: ,1
1986: ,sysdate
1987: ,xla_environment_pkg.g_usr_id
1988: ,sysdate
1989: ,xla_environment_pkg.g_usr_id
1990: ,xla_environment_pkg.g_login_id
1991: ,sysdate
1992: ,xla_environment_pkg.g_prog_appl_id
1993: ,xla_environment_pkg.g_prog_id

Line 1990: ,xla_environment_pkg.g_login_id

1986: ,sysdate
1987: ,xla_environment_pkg.g_usr_id
1988: ,sysdate
1989: ,xla_environment_pkg.g_usr_id
1990: ,xla_environment_pkg.g_login_id
1991: ,sysdate
1992: ,xla_environment_pkg.g_prog_appl_id
1993: ,xla_environment_pkg.g_prog_id
1994: ,xla_environment_pkg.g_req_Id

Line 1992: ,xla_environment_pkg.g_prog_appl_id

1988: ,sysdate
1989: ,xla_environment_pkg.g_usr_id
1990: ,xla_environment_pkg.g_login_id
1991: ,sysdate
1992: ,xla_environment_pkg.g_prog_appl_id
1993: ,xla_environment_pkg.g_prog_id
1994: ,xla_environment_pkg.g_req_Id
1995: FROM xla_staging_components_h s
1996: WHERE s.staging_amb_context_code = p_staging_context_code

Line 1993: ,xla_environment_pkg.g_prog_id

1989: ,xla_environment_pkg.g_usr_id
1990: ,xla_environment_pkg.g_login_id
1991: ,sysdate
1992: ,xla_environment_pkg.g_prog_appl_id
1993: ,xla_environment_pkg.g_prog_id
1994: ,xla_environment_pkg.g_req_Id
1995: FROM xla_staging_components_h s
1996: WHERE s.staging_amb_context_code = p_staging_context_code
1997: AND s.component_type_code <> 'AAD'

Line 1994: ,xla_environment_pkg.g_req_Id

1990: ,xla_environment_pkg.g_login_id
1991: ,sysdate
1992: ,xla_environment_pkg.g_prog_appl_id
1993: ,xla_environment_pkg.g_prog_id
1994: ,xla_environment_pkg.g_req_Id
1995: FROM xla_staging_components_h s
1996: WHERE s.staging_amb_context_code = p_staging_context_code
1997: AND s.component_type_code <> 'AAD'
1998: AND NOT EXISTS

Line 2472: ,xla_environment_pkg.g_usr_id

2468: ,g_err_msgs(i)
2469: ,g_err_nums(i)
2470: ,1
2471: ,sysdate
2472: ,xla_environment_pkg.g_usr_id
2473: ,sysdate
2474: ,xla_environment_pkg.g_usr_id
2475: ,xla_environment_pkg.g_login_id
2476: ,sysdate

Line 2474: ,xla_environment_pkg.g_usr_id

2470: ,1
2471: ,sysdate
2472: ,xla_environment_pkg.g_usr_id
2473: ,sysdate
2474: ,xla_environment_pkg.g_usr_id
2475: ,xla_environment_pkg.g_login_id
2476: ,sysdate
2477: ,xla_environment_pkg.g_prog_appl_id
2478: ,xla_environment_pkg.g_prog_id

Line 2475: ,xla_environment_pkg.g_login_id

2471: ,sysdate
2472: ,xla_environment_pkg.g_usr_id
2473: ,sysdate
2474: ,xla_environment_pkg.g_usr_id
2475: ,xla_environment_pkg.g_login_id
2476: ,sysdate
2477: ,xla_environment_pkg.g_prog_appl_id
2478: ,xla_environment_pkg.g_prog_id
2479: ,xla_environment_pkg.g_req_Id);

Line 2477: ,xla_environment_pkg.g_prog_appl_id

2473: ,sysdate
2474: ,xla_environment_pkg.g_usr_id
2475: ,xla_environment_pkg.g_login_id
2476: ,sysdate
2477: ,xla_environment_pkg.g_prog_appl_id
2478: ,xla_environment_pkg.g_prog_id
2479: ,xla_environment_pkg.g_req_Id);
2480:
2481: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 2478: ,xla_environment_pkg.g_prog_id

2474: ,xla_environment_pkg.g_usr_id
2475: ,xla_environment_pkg.g_login_id
2476: ,sysdate
2477: ,xla_environment_pkg.g_prog_appl_id
2478: ,xla_environment_pkg.g_prog_id
2479: ,xla_environment_pkg.g_req_Id);
2480:
2481: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
2482: trace(p_msg => '# errors inserted into xla_aad_loader_logs = '||SQL%ROWCOUNT

Line 2479: ,xla_environment_pkg.g_req_Id);

2475: ,xla_environment_pkg.g_login_id
2476: ,sysdate
2477: ,xla_environment_pkg.g_prog_appl_id
2478: ,xla_environment_pkg.g_prog_id
2479: ,xla_environment_pkg.g_req_Id);
2480:
2481: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
2482: trace(p_msg => '# errors inserted into xla_aad_loader_logs = '||SQL%ROWCOUNT
2483: ,p_module => l_log_module

Line 4183: ,p_component_code ,1,SYSDATE ,xla_environment_pkg.g_usr_id ,SYSDATE ,xla_environment_pkg.g_usr_id ,xla_environment_pkg.g_login_id

4179: ,component_code ,object_version_number ,creation_date ,created_by ,last_update_date ,last_updated_by ,last_update_login
4180: ,program_update_date ,program_application_id ,program_id ,request_id)
4181: VALUES
4182: (xla_aad_loader_logs_s.NEXTVAL ,p_amb_context_code ,p_application_id ,p_request_code ,p_log_type_code ,p_encoded_message,0
4183: ,p_component_code ,1,SYSDATE ,xla_environment_pkg.g_usr_id ,SYSDATE ,xla_environment_pkg.g_usr_id ,xla_environment_pkg.g_login_id
4184: ,sysdate,xla_environment_pkg.g_prog_appl_id ,xla_environment_pkg.g_prog_id ,xla_environment_pkg.g_req_Id);
4185: COMMIT;
4186: EXCEPTION
4187: WHEN xla_exceptions_pkg.application_exception THEN

Line 4184: ,sysdate,xla_environment_pkg.g_prog_appl_id ,xla_environment_pkg.g_prog_id ,xla_environment_pkg.g_req_Id);

4180: ,program_update_date ,program_application_id ,program_id ,request_id)
4181: VALUES
4182: (xla_aad_loader_logs_s.NEXTVAL ,p_amb_context_code ,p_application_id ,p_request_code ,p_log_type_code ,p_encoded_message,0
4183: ,p_component_code ,1,SYSDATE ,xla_environment_pkg.g_usr_id ,SYSDATE ,xla_environment_pkg.g_usr_id ,xla_environment_pkg.g_login_id
4184: ,sysdate,xla_environment_pkg.g_prog_appl_id ,xla_environment_pkg.g_prog_id ,xla_environment_pkg.g_req_Id);
4185: COMMIT;
4186: EXCEPTION
4187: WHEN xla_exceptions_pkg.application_exception THEN
4188: RAISE;