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 1357: ,xla_environment_pkg.g_usr_id

1353: ,s.version_comment
1354: ,s.leapfrog_flag
1355: ,1
1356: ,sysdate
1357: ,xla_environment_pkg.g_usr_id
1358: ,sysdate
1359: ,xla_environment_pkg.g_usr_id
1360: ,xla_environment_pkg.g_login_id
1361: ,sysdate

Line 1359: ,xla_environment_pkg.g_usr_id

1355: ,1
1356: ,sysdate
1357: ,xla_environment_pkg.g_usr_id
1358: ,sysdate
1359: ,xla_environment_pkg.g_usr_id
1360: ,xla_environment_pkg.g_login_id
1361: ,sysdate
1362: ,xla_environment_pkg.g_prog_appl_id
1363: ,xla_environment_pkg.g_prog_id

Line 1360: ,xla_environment_pkg.g_login_id

1356: ,sysdate
1357: ,xla_environment_pkg.g_usr_id
1358: ,sysdate
1359: ,xla_environment_pkg.g_usr_id
1360: ,xla_environment_pkg.g_login_id
1361: ,sysdate
1362: ,xla_environment_pkg.g_prog_appl_id
1363: ,xla_environment_pkg.g_prog_id
1364: ,xla_environment_pkg.g_req_Id

Line 1362: ,xla_environment_pkg.g_prog_appl_id

1358: ,sysdate
1359: ,xla_environment_pkg.g_usr_id
1360: ,xla_environment_pkg.g_login_id
1361: ,sysdate
1362: ,xla_environment_pkg.g_prog_appl_id
1363: ,xla_environment_pkg.g_prog_id
1364: ,xla_environment_pkg.g_req_Id
1365: FROM xla_staging_components_h s
1366: WHERE s.application_id = p_application_id

Line 1363: ,xla_environment_pkg.g_prog_id

1359: ,xla_environment_pkg.g_usr_id
1360: ,xla_environment_pkg.g_login_id
1361: ,sysdate
1362: ,xla_environment_pkg.g_prog_appl_id
1363: ,xla_environment_pkg.g_prog_id
1364: ,xla_environment_pkg.g_req_Id
1365: FROM xla_staging_components_h s
1366: WHERE s.application_id = p_application_id
1367: AND s.staging_amb_context_code = p_staging_context_code

Line 1364: ,xla_environment_pkg.g_req_Id

1360: ,xla_environment_pkg.g_login_id
1361: ,sysdate
1362: ,xla_environment_pkg.g_prog_appl_id
1363: ,xla_environment_pkg.g_prog_id
1364: ,xla_environment_pkg.g_req_Id
1365: FROM xla_staging_components_h s
1366: WHERE s.application_id = p_application_id
1367: AND s.staging_amb_context_code = p_staging_context_code
1368: AND s.component_type_code = 'AAD'

Line 1448: ,xla_environment_pkg.g_usr_id

1444: ,s.base_version_num
1445: ,s.leapfrog_flag
1446: ,1
1447: ,sysdate
1448: ,xla_environment_pkg.g_usr_id
1449: ,sysdate
1450: ,xla_environment_pkg.g_usr_id
1451: ,xla_environment_pkg.g_login_id
1452: ,sysdate

Line 1450: ,xla_environment_pkg.g_usr_id

1446: ,1
1447: ,sysdate
1448: ,xla_environment_pkg.g_usr_id
1449: ,sysdate
1450: ,xla_environment_pkg.g_usr_id
1451: ,xla_environment_pkg.g_login_id
1452: ,sysdate
1453: ,xla_environment_pkg.g_prog_appl_id
1454: ,xla_environment_pkg.g_prog_id

Line 1451: ,xla_environment_pkg.g_login_id

1447: ,sysdate
1448: ,xla_environment_pkg.g_usr_id
1449: ,sysdate
1450: ,xla_environment_pkg.g_usr_id
1451: ,xla_environment_pkg.g_login_id
1452: ,sysdate
1453: ,xla_environment_pkg.g_prog_appl_id
1454: ,xla_environment_pkg.g_prog_id
1455: ,xla_environment_pkg.g_req_Id

Line 1453: ,xla_environment_pkg.g_prog_appl_id

1449: ,sysdate
1450: ,xla_environment_pkg.g_usr_id
1451: ,xla_environment_pkg.g_login_id
1452: ,sysdate
1453: ,xla_environment_pkg.g_prog_appl_id
1454: ,xla_environment_pkg.g_prog_id
1455: ,xla_environment_pkg.g_req_Id
1456: FROM xla_staging_components_h s
1457: WHERE s.staging_amb_context_code = p_staging_context_code

Line 1454: ,xla_environment_pkg.g_prog_id

1450: ,xla_environment_pkg.g_usr_id
1451: ,xla_environment_pkg.g_login_id
1452: ,sysdate
1453: ,xla_environment_pkg.g_prog_appl_id
1454: ,xla_environment_pkg.g_prog_id
1455: ,xla_environment_pkg.g_req_Id
1456: FROM xla_staging_components_h s
1457: WHERE s.staging_amb_context_code = p_staging_context_code
1458: AND s.component_type_code <> 'AAD'

Line 1455: ,xla_environment_pkg.g_req_Id

1451: ,xla_environment_pkg.g_login_id
1452: ,sysdate
1453: ,xla_environment_pkg.g_prog_appl_id
1454: ,xla_environment_pkg.g_prog_id
1455: ,xla_environment_pkg.g_req_Id
1456: FROM xla_staging_components_h s
1457: WHERE s.staging_amb_context_code = p_staging_context_code
1458: AND s.component_type_code <> 'AAD'
1459: AND NOT EXISTS

Line 1930: ,xla_environment_pkg.g_usr_id

1926: ,g_err_msgs(i)
1927: ,g_err_nums(i)
1928: ,1
1929: ,sysdate
1930: ,xla_environment_pkg.g_usr_id
1931: ,sysdate
1932: ,xla_environment_pkg.g_usr_id
1933: ,xla_environment_pkg.g_login_id
1934: ,sysdate

Line 1932: ,xla_environment_pkg.g_usr_id

1928: ,1
1929: ,sysdate
1930: ,xla_environment_pkg.g_usr_id
1931: ,sysdate
1932: ,xla_environment_pkg.g_usr_id
1933: ,xla_environment_pkg.g_login_id
1934: ,sysdate
1935: ,xla_environment_pkg.g_prog_appl_id
1936: ,xla_environment_pkg.g_prog_id

Line 1933: ,xla_environment_pkg.g_login_id

1929: ,sysdate
1930: ,xla_environment_pkg.g_usr_id
1931: ,sysdate
1932: ,xla_environment_pkg.g_usr_id
1933: ,xla_environment_pkg.g_login_id
1934: ,sysdate
1935: ,xla_environment_pkg.g_prog_appl_id
1936: ,xla_environment_pkg.g_prog_id
1937: ,xla_environment_pkg.g_req_Id);

Line 1935: ,xla_environment_pkg.g_prog_appl_id

1931: ,sysdate
1932: ,xla_environment_pkg.g_usr_id
1933: ,xla_environment_pkg.g_login_id
1934: ,sysdate
1935: ,xla_environment_pkg.g_prog_appl_id
1936: ,xla_environment_pkg.g_prog_id
1937: ,xla_environment_pkg.g_req_Id);
1938:
1939: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 1936: ,xla_environment_pkg.g_prog_id

1932: ,xla_environment_pkg.g_usr_id
1933: ,xla_environment_pkg.g_login_id
1934: ,sysdate
1935: ,xla_environment_pkg.g_prog_appl_id
1936: ,xla_environment_pkg.g_prog_id
1937: ,xla_environment_pkg.g_req_Id);
1938:
1939: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1940: trace(p_msg => '# errors inserted into xla_aad_loader_logs = '||SQL%ROWCOUNT

Line 1937: ,xla_environment_pkg.g_req_Id);

1933: ,xla_environment_pkg.g_login_id
1934: ,sysdate
1935: ,xla_environment_pkg.g_prog_appl_id
1936: ,xla_environment_pkg.g_prog_id
1937: ,xla_environment_pkg.g_req_Id);
1938:
1939: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1940: trace(p_msg => '# errors inserted into xla_aad_loader_logs = '||SQL%ROWCOUNT
1941: ,p_module => l_log_module