The following lines contain the word 'select', 'insert', 'update' or 'delete':
select application_short_name
into l_appl_short_name
from fnd_application
where application_id = dep_appl_id;
select min(install_group_num) into l_install_group_num
from fnd_oracle_userid
where oracle_username = target_schema;
since the select from FPI will always return either one row or no rows
See note above as well as note below in the code.
BUGS:
If you do not pass install_group_num and the user account has a
null install_group_num in fnd_oracle_userid and you have multiple installs
of the product you will not be able to determine the information about
the product.
If you do not pass the install_group_num and the user account has a
an install_group_num of 0 and you have multiple installs of the
product and the product is a multiple install product (ie not
install_group_num 0) you will not be able to determine the information
about the product. (eg. asking from applsys info about AP when
multiple APs exist)
Both of these problems go away in R11 when no more multiple installs.
*/
-- dbms_output.put_line( 'entering private_get()' );
select fpi.status,
fpi.industry,
fpi.product_version,
fou.oracle_username,
fpi.tablespace,
fpi.index_tablespace,
fpi.temporary_tablespace,
fpi.sizing_factor
from FND_PRODUCT_INSTALLATIONS FPI,
FND_ORACLE_USERID FOU,
FND_APPLICATION FA
where fpi.application_id = fa.application_id
and fpi.oracle_id = fou.oracle_id
and fa.application_short_name = private_get.appl_short_name;
select fpi.status,
fpi.industry,
fpi.product_version,
fou.oracle_username,
fpi.tablespace,
fpi.index_tablespace,
fpi.temporary_tablespace,
fpi.sizing_factor
from FND_PRODUCT_INSTALLATIONS FPI,
FND_ORACLE_USERID FOU,
FND_APPLICATION FA
where fpi.application_id = fa.application_id
and fpi.oracle_id = fou.oracle_id
and fa.application_short_name = private_get.appl_short_name
and fpi.install_group_num = c_install_group_num;
select install_group_num
into l_install_group_num
from fnd_oracle_userid
where oracle_username = user
and install_group_num is not null;