DBA Data[Home] [Help]

APPS.MSC_CL_EXCHANGE_PARTTBL dependencies on AD_TSPACE_UTIL

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

1567:
1568: FOR c_rec IN c_tab_list
1569: LOOP
1570:
1571: lv_prod_short_name := AD_TSPACE_UTIL.get_product_short_name(to_number(c_rec.application_id));
1572: lv_retval := FND_INSTALLATION.GET_APP_INFO (lv_prod_short_name, lv_dummy1, lv_dummy2, lv_schema);
1573:
1574: BEGIN
1575: lv_sql_stmt := ' ALTER TABLE ' || lv_schema || '.' || c_rec.table_name

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

1636:
1637: FOR c_rec IN c_tab_list
1638: LOOP
1639:
1640: lv_prod_short_name := AD_TSPACE_UTIL.get_product_short_name(to_number(c_rec.application_id));
1641: lv_retval := FND_INSTALLATION.GET_APP_INFO (lv_prod_short_name, lv_dummy1, lv_dummy2, lv_schema);
1642:
1643: lv_sql_stmt := 'ALTER TABLE ' || lv_schema || '.' || c_rec.table_name
1644: || ' DROP PARTITION ' || c_rec.partition_name;

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

1682:
1683: FOR c_rec IN c_tab_list
1684: LOOP
1685:
1686: lv_prod_short_name := AD_TSPACE_UTIL.get_product_short_name(to_number(c_rec.application_id));
1687: lv_retval := FND_INSTALLATION.GET_APP_INFO (lv_prod_short_name, lv_dummy1, lv_dummy2, lv_schema);
1688:
1689: BEGIN
1690: lv_sql_stmt := 'ALTER TABLE ' || lv_schema || '.'

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

1739:
1740: FOR c_rec IN c_tab_list
1741: LOOP
1742:
1743: lv_prod_short_name := AD_TSPACE_UTIL.get_product_short_name(to_number(c_rec.application_id));
1744: lv_retval := FND_INSTALLATION.GET_APP_INFO (lv_prod_short_name, lv_dummy1, lv_dummy2, lv_schema);
1745:
1746: BEGIN
1747: lv_sql_stmt := 'ALTER TABLE ' || lv_schema || '.' || c_rec.table_name