APPS.XLA_AAD_LOADER_UTIL_PVT dependencies on XLA_AADS_H

Line 1282: MERGE INTO xla_aads_h h

1278: p_level => C_LEVEL_PROCEDURE);
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

Line 1298: UPDATE xla_aads_h h

1294: , version_comment = s.version_comment
1295: , leapfrog_flag = s.leapfrog_flag;
1296: */
1297:
1298: UPDATE xla_aads_h h
1299: SET (base_version_num
1300: ,user_version
1301: ,version_comment
1302: ,leapfrog_flag) =

Line 1307: FROM xla_aads_h h2

1303: (SELECT NVL(s.base_version_num, h2.base_version_num)
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

Line 1323: trace(p_msg => '# xla_aads_h updated = '||SQL%ROWCOUNT,

1319: AND s.component_type_code(+) = 'AAD');
1320:
1321:
1322: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
1323: trace(p_msg => '# xla_aads_h updated = '||SQL%ROWCOUNT,
1324: p_module => l_log_module,
1325: p_level => C_LEVEL_PROCEDURE);
1326: END IF;
1327:

Line 1328: INSERT INTO xla_aads_h

1324: p_module => l_log_module,
1325: p_level => C_LEVEL_PROCEDURE);
1326: END IF;
1327:
1328: INSERT INTO xla_aads_h
1329: (application_id
1330: ,product_rule_type_code
1331: ,product_rule_code
1332: ,version_num

Line 1371: FROM xla_aads_h h

1367: AND s.staging_amb_context_code = p_staging_context_code
1368: AND s.component_type_code = 'AAD'
1369: AND NOT EXISTS
1370: (SELECT 1
1371: FROM xla_aads_h h
1372: WHERE h.application_id = s.application_id
1373: AND h.product_rule_type_code = s.component_owner_code
1374: AND h.product_rule_code = s.component_code
1375: AND h.version_num = s.version_num);

Line 1378: trace(p_msg => '# xla_aads_h inserted = '||SQL%ROWCOUNT,

1374: AND h.product_rule_code = s.component_code
1375: AND h.version_num = s.version_num);
1376:
1377: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
1378: trace(p_msg => '# xla_aads_h inserted = '||SQL%ROWCOUNT,
1379: p_module => l_log_module,
1380: p_level => C_LEVEL_PROCEDURE);
1381: END IF;
1382:

Line 3135: DELETE FROM xla_aads_h

3131:
3132: -- Initialize global variables
3133: x_return_status := FND_API.G_RET_STS_SUCCESS;
3134:
3135: DELETE FROM xla_aads_h
3136: WHERE application_id = p_application_id;
3137:
3138: DELETE FROM xla_amb_components_h
3139: WHERE application_id = p_application_id;