APPS.XLA_AAD_LOADER_UTIL_PVT dependencies on XLA_STAGING_COMPONENTS_H

Line 1283: USING xla_staging_components_h s

1279: END IF;
1280:
1281: /*
1282: MERGE INTO xla_aads_h h
1283: USING xla_staging_components_h s
1284: ON (h.application_id = s.application_id
1285: AND h.product_rule_type_code = s.component_owner_code
1286: AND h.product_rule_code = s.component_code
1287: AND h.version_num = s.version_num

Line 1308: , xla_staging_components_h s

1304: ,NVL(s.product_rule_version, h2.user_version)
1305: ,NVL(s.version_comment, h2.version_comment)
1306: ,NVL(s.leapfrog_flag, h2.leapfrog_flag)
1307: FROM xla_aads_h h2
1308: , xla_staging_components_h s
1309: WHERE h.application_id = h2.application_id
1310: AND h.product_rule_type_code = h2.product_rule_type_code
1311: AND h.product_rule_code = h2.product_rule_code
1312: AND h.version_num = h2.version_num

Line 1365: FROM xla_staging_components_h s

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'
1369: AND NOT EXISTS

Line 1385: USING xla_staging_components_h s

1381: END IF;
1382:
1383: /*
1384: MERGE INTO xla_amb_components_h h
1385: USING xla_staging_components_h s
1386: ON (h.component_type_code = s.component_type_code
1387: AND h.component_owner_code = s.component_owner_code
1388: AND h.component_code = s.component_code
1389: AND h.version_num = s.version_num

Line 1400: , xla_staging_components_h s

1396: UPDATE xla_amb_components_h h
1397: SET base_version_num =
1398: (SELECT nvl(s.base_version_num, h2.base_version_num)
1399: FROM xla_amb_components_h h2
1400: , xla_staging_components_h s
1401: WHERE h.component_type_code = h2.component_type_code
1402: AND h.component_owner_code = h2.component_owner_code
1403: AND h.component_code = h2.component_code
1404: AND h.application_id = h2.application_id

Line 1456: FROM xla_staging_components_h s

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
1460: (SELECT 1

Line 2445: DELETE FROM xla_staging_components_h

2441: p_module => l_log_module,
2442: p_level => C_LEVEL_PROCEDURE);
2443: END IF;
2444:
2445: DELETE FROM xla_staging_components_h
2446: WHERE staging_amb_context_code = l_staging_context_code;
2447:
2448: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
2449: trace(p_msg => '# xla_staging_components_h deleted = '||SQL%ROWCOUNT,

Line 2449: trace(p_msg => '# xla_staging_components_h deleted = '||SQL%ROWCOUNT,

2445: DELETE FROM xla_staging_components_h
2446: WHERE staging_amb_context_code = l_staging_context_code;
2447:
2448: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
2449: trace(p_msg => '# xla_staging_components_h deleted = '||SQL%ROWCOUNT,
2450: p_module => l_log_module,
2451: p_level => C_LEVEL_PROCEDURE);
2452: END IF;
2453:

Line 2483: DELETE FROM xla_staging_components_h

2479: p_module => l_log_module,
2480: p_level => C_LEVEL_PROCEDURE);
2481: END IF;
2482:
2483: DELETE FROM xla_staging_components_h
2484: WHERE staging_amb_context_code = p_amb_context_code;
2485:
2486: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
2487: trace(p_msg => '# xla_staging_components_h deleted = '||SQL%ROWCOUNT,

Line 2487: trace(p_msg => '# xla_staging_components_h deleted = '||SQL%ROWCOUNT,

2483: DELETE FROM xla_staging_components_h
2484: WHERE staging_amb_context_code = p_amb_context_code;
2485:
2486: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
2487: trace(p_msg => '# xla_staging_components_h deleted = '||SQL%ROWCOUNT,
2488: p_module => l_log_module,
2489: p_level => C_LEVEL_PROCEDURE);
2490: END IF;
2491: