DBA Data[Home] [Help]

APPS.OTA_REPROCESS_CLASSIC_UPGRADE dependencies on FND_ORACLE_USERID

Line 16: ORACLE_USER_NAME constant fnd_oracle_userid.oracle_username%type

12:
13: CONC_UPGRADE_ID constant number := get_next_upgrade_id ;
14: l_request_id number;
15:
16: ORACLE_USER_NAME constant fnd_oracle_userid.oracle_username%type
17: := get_ota_schema;
18: -- ----------------------------------------------------------------------------
19: -- |-------------------------< get_next_upgrade_id >--------------------------|
20: -- ----------------------------------------------------------------------------

Line 39: l_schema FND_ORACLE_USERID.oracle_username%type := null;

35: function get_ota_schema return varchar2 is
36: OTA_APP_SHORT_NAME constant varchar2(10) := 'OTA';
37: l_status fnd_product_installations.status%type;
38: l_industry fnd_product_installations.industry%type;
39: l_schema FND_ORACLE_USERID.oracle_username%type := null;
40:
41: l_found boolean;
42: begin
43: l_found := fnd_installation.get_app_info( OTA_APP_SHORT_NAME