141: x_msg_data OUT NOCOPY VARCHAR2) IS
142:
143: CURSOR C_SCHEMA IS
144: SELECT a.oracle_username
145: FROM FND_ORACLE_USERID a, FND_PRODUCT_INSTALLATIONS b
146: WHERE a.oracle_id = b.oracle_id
147: AND b.application_id = 724;
148:
149: l_partition_name VARCHAR2(100);
227: IS
228:
229: CURSOR C_SCHEMA IS
230: SELECT a.oracle_username
231: FROM FND_ORACLE_USERID a, FND_PRODUCT_INSTALLATIONS b
232: WHERE a.oracle_id = b.oracle_id
233: AND b.application_id = 724;
234:
235:
388: IS
389:
390: CURSOR C_SCHEMA IS
391: SELECT a.oracle_username
392: FROM FND_ORACLE_USERID a, FND_PRODUCT_INSTALLATIONS b
393: WHERE a.oracle_id = b.oracle_id
394: AND b.application_id = 724;
395:
396: l_dummy_partition_name VARCHAR2(100);
1406:
1407:
1408: Cursor msc_schema IS
1409: SELECT a.oracle_username
1410: FROM FND_ORACLE_USERID a, FND_PRODUCT_INSTALLATIONS b
1411: WHERE a.oracle_id = b.oracle_id
1412: AND b.application_id= 724;
1413:
1414: /* --bug 3274373: Refresh Materialized view in ATP post plan processing.