APPS.MSC_CL_EXCHANGE_PARTTBL dependencies on FND_INSTALLATION

Line 134: lv_retval := FND_INSTALLATION.GET_APP_INFO(

130:
131: BEGIN
132: trc( 'st:Initialize_Schema_PVT');
133: /* APPLSYS */
134: lv_retval := FND_INSTALLATION.GET_APP_INFO(
135: 'FND', lv_dummy1,lv_dummy2, v_applsys_schema);
136: /* MSC */
137: OPEN c_msc;
138: FETCH c_msc INTO v_msc_schema;

Line 1462: lv_retval := FND_INSTALLATION.GET_APP_INFO(

1458: INTO lv_appl_short_nm
1459: FROM fnd_application
1460: WHERE application_id = 724;
1461:
1462: lv_retval := FND_INSTALLATION.GET_APP_INFO(
1463: lv_appl_short_nm, lv_dummy1,lv_dummy2, lv_msc_schema);
1464: /*End 8800601 */
1465:
1466: EXCEPTION

Line 1572: lv_retval := FND_INSTALLATION.GET_APP_INFO (lv_prod_short_name, lv_dummy1, lv_dummy2, lv_schema);

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
1576: || ' SPLIT PARTITION ' || SUBSTR(c_rec.table_name, 5) || '_DEF '

Line 1641: lv_retval := FND_INSTALLATION.GET_APP_INFO (lv_prod_short_name, lv_dummy1, lv_dummy2, lv_schema);

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;
1645: EXECUTE IMMEDIATE lv_sql_stmt;

Line 1687: lv_retval := FND_INSTALLATION.GET_APP_INFO (lv_prod_short_name, lv_dummy1, lv_dummy2, lv_schema);

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 || '.'
1691: || c_rec.table_name || ' MODIFY PARTITION '

Line 1744: lv_retval := FND_INSTALLATION.GET_APP_INFO (lv_prod_short_name, lv_dummy1, lv_dummy2, lv_schema);

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
1748: || ' MODIFY PARTITION ' || SUBSTR(c_rec.table_name, 5) || '_LEG '