[Home] [Help]
125:
126: -- Derive install_group_num from the parameter target_schema
127:
128: select min(install_group_num) into l_install_group_num
129: from fnd_oracle_userid
130: where oracle_username = target_schema;
131:
132: l_return := private_get(application_short_name, l_install_group_num,
133: l_status, l_industry,
139: oracle_schema := l_oracle_schema;
140: return(l_return);
141: EXCEPTION
142: -- This should only execute if the target schema was not registered in
143: -- FND_ORACLE_USERID
144: when others then
145: return(FALSE);
146: END;
147:
185: the argument installation_group_num to private_get is no longer
186: needed as well.
187:
188: Next, if install_group_num is null then get the install_group_num from
189: fnd_oracle_userid for the current user.
190:
191: Next, try to get exactly one row from FND_PRODUCT_INSTALLATIONS
192: for the product, install_group_num pair
193:
208: See note above as well as note below in the code.
209:
210: BUGS:
211: If you do not pass install_group_num and the user account has a
212: null install_group_num in fnd_oracle_userid and you have multiple installs
213: of the product you will not be able to determine the information about
214: the product.
215:
216: If you do not pass the install_group_num and the user account has a
248: fpi.index_tablespace,
249: fpi.temporary_tablespace,
250: fpi.sizing_factor
251: from FND_PRODUCT_INSTALLATIONS FPI,
252: FND_ORACLE_USERID FOU,
253: FND_APPLICATION FA
254: where fpi.application_id = fa.application_id
255: and fpi.oracle_id = fou.oracle_id
256: and fa.application_short_name = private_get.appl_short_name;
367: fpi.index_tablespace,
368: fpi.temporary_tablespace,
369: fpi.sizing_factor
370: from FND_PRODUCT_INSTALLATIONS FPI,
371: FND_ORACLE_USERID FOU,
372: FND_APPLICATION FA
373: where fpi.application_id = fa.application_id
374: and fpi.oracle_id = fou.oracle_id
375: and fa.application_short_name = private_get.appl_short_name
393: if private_get.install_group_num is null then
394:
395: select install_group_num
396: into l_install_group_num
397: from fnd_oracle_userid
398: where oracle_username = user
399: and install_group_num is not null;
400:
401: else
453: return(TRUE);
454: else
455: -- more than one row. data corruption?
456: -- dbms_output.put('exiting private_get: ');
457: -- dbms_output.put_line('bad data in FND_ORACLE_USERID?');
458: status := 'N';
459: industry := 'N';
460: product_version := null;
461: oracle_schema := null;