DBA Data[Home] [Help]

APPS.MSC_CL_EXCHANGE_PARTTBL dependencies on AD_TSPACE_UTIL

Line 1300: lv_prod_short_name := AD_TSPACE_UTIL.get_product_short_name(to_number(c_rec.application_id));

1296:
1297: FOR c_rec IN c_tab_list
1298: LOOP
1299:
1300: lv_prod_short_name := AD_TSPACE_UTIL.get_product_short_name(to_number(c_rec.application_id));
1301: lv_retval := FND_INSTALLATION.GET_APP_INFO (lv_prod_short_name, lv_dummy1, lv_dummy2, lv_schema);
1302:
1303: BEGIN
1304: lv_sql_stmt := ' ALTER TABLE ' || lv_schema || '.' || c_rec.table_name

Line 1369: lv_prod_short_name := AD_TSPACE_UTIL.get_product_short_name(to_number(c_rec.application_id));

1365:
1366: FOR c_rec IN c_tab_list
1367: LOOP
1368:
1369: lv_prod_short_name := AD_TSPACE_UTIL.get_product_short_name(to_number(c_rec.application_id));
1370: lv_retval := FND_INSTALLATION.GET_APP_INFO (lv_prod_short_name, lv_dummy1, lv_dummy2, lv_schema);
1371:
1372: lv_sql_stmt := 'ALTER TABLE ' || lv_schema || '.' || c_rec.table_name
1373: || ' DROP PARTITION ' || c_rec.partition_name;

Line 1415: lv_prod_short_name := AD_TSPACE_UTIL.get_product_short_name(to_number(c_rec.application_id));

1411:
1412: FOR c_rec IN c_tab_list
1413: LOOP
1414:
1415: lv_prod_short_name := AD_TSPACE_UTIL.get_product_short_name(to_number(c_rec.application_id));
1416: lv_retval := FND_INSTALLATION.GET_APP_INFO (lv_prod_short_name, lv_dummy1, lv_dummy2, lv_schema);
1417:
1418: BEGIN
1419: lv_sql_stmt := 'ALTER TABLE ' || lv_schema || '.'

Line 1472: lv_prod_short_name := AD_TSPACE_UTIL.get_product_short_name(to_number(c_rec.application_id));

1468:
1469: FOR c_rec IN c_tab_list
1470: LOOP
1471:
1472: lv_prod_short_name := AD_TSPACE_UTIL.get_product_short_name(to_number(c_rec.application_id));
1473: lv_retval := FND_INSTALLATION.GET_APP_INFO (lv_prod_short_name, lv_dummy1, lv_dummy2, lv_schema);
1474:
1475: BEGIN
1476: lv_sql_stmt := 'ALTER TABLE ' || lv_schema || '.' || c_rec.table_name