DBA Data[Home] [Help]

APPS.MSC_CL_EXCHANGE_PARTTBL dependencies on FND_INSTALLATION

Line 106: lv_retval := FND_INSTALLATION.GET_APP_INFO(

102:
103: BEGIN
104: trc( 'st:Initialize_Schema_PVT');
105: /* APPLSYS */
106: lv_retval := FND_INSTALLATION.GET_APP_INFO(
107: 'FND', lv_dummy1,lv_dummy2, v_applsys_schema);
108: /* MSC */
109: OPEN c_msc;
110: FETCH c_msc INTO v_msc_schema;

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

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

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

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

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

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

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

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