DBA Data[Home] [Help]

APPS.FND_TS_MIG_UTIL dependencies on FND_PRODUCT_GROUPS

Line 178: FROM fnd_product_groups;

174: l_dummy VARCHAR2(1);
175:
176: CURSOR prd_grps_csr IS
177: SELECT is_new_ts_mode
178: FROM fnd_product_groups;
179: l_new_ts_mode FND_PRODUCT_GROUPS.IS_NEW_TS_MODE%TYPE;
180: BEGIN
181: OPEN usr_def_csr;
182: FETCH usr_def_csr INTO l_dummy;

Line 179: l_new_ts_mode FND_PRODUCT_GROUPS.IS_NEW_TS_MODE%TYPE;

175:
176: CURSOR prd_grps_csr IS
177: SELECT is_new_ts_mode
178: FROM fnd_product_groups;
179: l_new_ts_mode FND_PRODUCT_GROUPS.IS_NEW_TS_MODE%TYPE;
180: BEGIN
181: OPEN usr_def_csr;
182: FETCH usr_def_csr INTO l_dummy;
183: if usr_def_csr%FOUND then

Line 195: -- check if the new tablespace design flag is set in FND_PRODUCT_GROUPS.

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.
196: OPEN prd_grps_csr;
197: FETCH prd_grps_csr INTO l_new_ts_mode;
198: CLOSE prd_grps_csr;
199: if l_new_ts_mode <> 'Y' then

Line 200: raise_application_error(-20001, 'The New Tablespace Mode flag for the new tablesapce design is not set in FND_PRODUCT_GROUPS.');

196: OPEN prd_grps_csr;
197: FETCH prd_grps_csr INTO l_new_ts_mode;
198: CLOSE prd_grps_csr;
199: if l_new_ts_mode <> 'Y' then
200: raise_application_error(-20001, 'The New Tablespace Mode flag for the new tablesapce design is not set in FND_PRODUCT_GROUPS.');
201: end if;
202:
203: END chk_product_defaults;
204:

Line 582: -- Set the new tablespace design flag to Y in fnd_product_groups.

578:
579: -- Set the TABLESPACE_NAME in gl_storage_parameters to INTERFACE.
580: fnd_ts_mig_util.upd_gl_storage_param('INTERFACE');
581:
582: -- Set the new tablespace design flag to Y in fnd_product_groups.
583: UPDATE fnd_product_groups
584: SET is_new_ts_mode = 'Y';
585: END set_defaults;
586:

Line 583: UPDATE fnd_product_groups

579: -- Set the TABLESPACE_NAME in gl_storage_parameters to INTERFACE.
580: fnd_ts_mig_util.upd_gl_storage_param('INTERFACE');
581:
582: -- Set the new tablespace design flag to Y in fnd_product_groups.
583: UPDATE fnd_product_groups
584: SET is_new_ts_mode = 'Y';
585: END set_defaults;
586:
587: PROCEDURE crt_txn_ind_pref