APPS.FND_TS_MIG_UTIL dependencies on FND_PRODUCT_INSTALLATIONS

Line 49: fnd_product_installations fpi

45: IS
46: CURSOR tsp_csr IS
47: SELECT distinct dt.tablespace_name
48: FROM dba_tablespaces dt,
49: fnd_product_installations fpi
50: WHERE dt.extent_management = 'DICTIONARY'
51: AND (dt.tablespace_name = fpi.tablespace
52: OR dt.tablespace_name = fpi.index_tablespace);
53: l_tablespace_name DBA_TABLESPACES.TABLESPACE_NAME%TYPE;

Line 163: FROM fnd_product_installations

159: where tablespace_type = l_def_tab_tsp);
160:
161: CURSOR prd_inst_csr IS
162: SELECT '1'
163: FROM fnd_product_installations
164: WHERE oracle_id in (select oracle_id
165: from fnd_oracle_userid
166: where read_only_flag in ('E','A','U','K','M'))
167: AND (index_tablespace <> (select tablespace

Line 191: raise_application_error(-20001, 'The Tablespace and Index Tablespace for Oracle products in FND_PRODUCT_INSTALLATIONS is not changed for the new tablesapce design.');

187:
188: OPEN prd_inst_csr;
189: FETCH prd_inst_csr INTO l_dummy;
190: if prd_inst_csr%FOUND then
191: raise_application_error(-20001, 'The Tablespace and Index Tablespace for Oracle products in FND_PRODUCT_INSTALLATIONS is not changed for the new tablesapce design.');
192: end if;
193: CLOSE prd_inst_csr;
194:
195: -- check if the new tablespace design flag is set in FND_PRODUCT_GROUPS.

Line 247: from fnd_product_installations fpi,

243: PROCEDURE upd_fot_username IS
244: BEGIN
245: UPDATE fnd_object_tablespaces fot
246: SET oracle_username = (select fou.oracle_username
247: from fnd_product_installations fpi,
248: fnd_oracle_userid fou
249: where fpi.oracle_id = fou.oracle_id
250: and fpi.application_id = fot.application_id)
251: WHERE oracle_username IS NULL;

Line 306: FROM fnd_product_installations fpi,

302: l_rowid ROWID;
303:
304: CURSOR app_csr(l_oracle_username VARCHAR2) IS
305: SELECT fpi.application_id
306: FROM fnd_product_installations fpi,
307: fnd_oracle_userid fou
308: WHERE fpi.oracle_id = fou.oracle_id
309: AND fou.oracle_username = l_oracle_username
310: ORDER BY fpi.application_id;

Line 311: l_app_id FND_PRODUCT_INSTALLATIONS.APPLICATION_ID%TYPE;

307: fnd_oracle_userid fou
308: WHERE fpi.oracle_id = fou.oracle_id
309: AND fou.oracle_username = l_oracle_username
310: ORDER BY fpi.application_id;
311: l_app_id FND_PRODUCT_INSTALLATIONS.APPLICATION_ID%TYPE;
312: BEGIN
313:
314: FOR gl_rec IN gl_csr
315: LOOP

Line 332: raise_application_error(-20001, 'Application Id not found for '||l_owner||' in FND_PRODUCT_INSTALLATIONS.');

328: else
329: OPEN app_csr(l_owner);
330: FETCH app_csr INTO l_app_id;
331: if app_csr%NOTFOUND then
332: raise_application_error(-20001, 'Application Id not found for '||l_owner||' in FND_PRODUCT_INSTALLATIONS.');
333: end if;
334: CLOSE app_csr;
335: end if;
336: end if;

Line 394: FROM fnd_product_installations fpi,

390: l_object_source FND_OBJECT_TABLESPACES.OBJECT_SOURCE%TYPE;
391: l_rowid ROWID;
392: CURSOR app_csr(l_oracle_username VARCHAR2) IS
393: SELECT fpi.application_id
394: FROM fnd_product_installations fpi,
395: fnd_oracle_userid fou
396: WHERE fpi.oracle_id = fou.oracle_id
397: AND fou.oracle_username = l_oracle_username
398: ORDER BY fpi.application_id;

Line 399: l_app_id FND_PRODUCT_INSTALLATIONS.APPLICATION_ID%TYPE;

395: fnd_oracle_userid fou
396: WHERE fpi.oracle_id = fou.oracle_id
397: AND fou.oracle_username = l_oracle_username
398: ORDER BY fpi.application_id;
399: l_app_id FND_PRODUCT_INSTALLATIONS.APPLICATION_ID%TYPE;
400: BEGIN
401:
402: upd_fot_username;
403:

Line 452: raise_application_error(-20001, 'Application Id not found for '||l_owner||' in FND_PRODUCT_INSTALLATIONS.');

448: else
449: OPEN app_csr(l_owner);
450: FETCH app_csr INTO l_app_id;
451: if app_csr%NOTFOUND then
452: raise_application_error(-20001, 'Application Id not found for '||l_owner||' in FND_PRODUCT_INSTALLATIONS.');
453: end if;
454: CLOSE app_csr;
455: end if;
456: end if;

Line 572: -- Set the data tablespace and index tablespace as TRANSACTION_TABLES in fnd_product_installations.

568: l_string := 'ALTER USER '||usr_rec.oracle_username||' QUOTA UNLIMITED ON '||tsp_rec.tablespace;
569: EXECUTE IMMEDIATE l_string;
570: END LOOP;
571:
572: -- Set the data tablespace and index tablespace as TRANSACTION_TABLES in fnd_product_installations.
573: UPDATE fnd_product_installations
574: SET tablespace = l_txn_tablespace,
575: index_tablespace = l_txn_ind_tablespace
576: WHERE oracle_id = usr_rec.oracle_id;

Line 573: UPDATE fnd_product_installations

569: EXECUTE IMMEDIATE l_string;
570: END LOOP;
571:
572: -- Set the data tablespace and index tablespace as TRANSACTION_TABLES in fnd_product_installations.
573: UPDATE fnd_product_installations
574: SET tablespace = l_txn_tablespace,
575: index_tablespace = l_txn_ind_tablespace
576: WHERE oracle_id = usr_rec.oracle_id;
577: END LOOP;