SYSTEM.AD_APPS_PRIVATE dependencies on FND_ORACLE_USERID

Line 28: FROM fnd_oracle_userid

24: BEGIN
25:
26: SELECT oracle_username
27: INTO l_apps_schema
28: FROM fnd_oracle_userid
29: WHERE read_only_flag='U';
30:
31: execute immediate 'select ' || l_apps_schema || '.ad_zd.get_edition(''' ||
32: x_edition_type || ''') from dual' into l_edition;

Line 50: from fnd_oracle_userid f,

46: if p_username is null
47: then
48: select u.editions_enabled
49: into l_enabled
50: from fnd_oracle_userid f,
51: dba_users u
52: where f.read_only_flag='U'
53: and u.username=f.oracle_username;
54: else

Line 93: FROM fnd_oracle_userid

89:
90: CUR := DBMS_SQL.OPEN_CURSOR;
91: SELECT oracle_username
92: INTO l_apps_schema
93: FROM fnd_oracle_userid
94: WHERE read_only_flag='U';
95:
96: stmt := 'select ' ||l_apps_schema||'.AD_ZD_TABLE.EV_VIEW('''||p_obj_name||''') from DUAL';
97: DBMS_SQL.PARSE(CUR, STMT, DBMS_SQL.native);

Line 676: aol_or_apps_schema||'.fnd_oracle_userid '||

672: BEGIN --Block 1
673: c := dbms_sql.open_cursor;
674: -- select APPS account for given IGN, or if IGN is 0 then the min
675: c_statement:= 'select oracle_username from '||
676: aol_or_apps_schema||'.fnd_oracle_userid '||
677: 'where (install_group_num = :install_group_num '||
678: ' or install_group_num = '||
679: ' (select min(install_group_num) from '||
680: aol_or_apps_schema||'.fnd_oracle_userid '||

Line 680: aol_or_apps_schema||'.fnd_oracle_userid '||

676: aol_or_apps_schema||'.fnd_oracle_userid '||
677: 'where (install_group_num = :install_group_num '||
678: ' or install_group_num = '||
679: ' (select min(install_group_num) from '||
680: aol_or_apps_schema||'.fnd_oracle_userid '||
681: ' where 1 = decode (:install_group_num,0,1,2) '||
682: ' and read_only_flag = ''U'')) '||
683: 'and read_only_flag = ''U'' ';
684: dbms_sql.parse(c, c_statement, dbms_sql.native);

Line 720: aol_or_apps_schema||'.fnd_oracle_userid '||

716: ELSE -- if cache check 2
717: BEGIN --BLock 2
718: c := dbms_sql.open_cursor;
719: c_statement:= 'select oracle_username from '||
720: aol_or_apps_schema||'.fnd_oracle_userid '||
721: 'where (install_group_num = :install_group_num '||
722: ' or install_group_num = '||
723: ' (select min(install_group_num) from '||
724: aol_or_apps_schema||'.fnd_oracle_userid '||

Line 724: aol_or_apps_schema||'.fnd_oracle_userid '||

720: aol_or_apps_schema||'.fnd_oracle_userid '||
721: 'where (install_group_num = :install_group_num '||
722: ' or install_group_num = '||
723: ' (select min(install_group_num) from '||
724: aol_or_apps_schema||'.fnd_oracle_userid '||
725: ' where 1 = decode (:install_group_num,0,1,2) '||
726: ' and read_only_flag = ''M'')) '||
727: 'and read_only_flag = ''M'' ';
728: dbms_sql.parse(c, c_statement, dbms_sql.native);

Line 1845: FROM fnd_oracle_userid

1841: -- Create grants (whether they exist already or not)
1842:
1843: SELECT oracle_username
1844: INTO l_fnd_schema
1845: FROM fnd_oracle_userid
1846: WHERE read_only_flag='E';
1847:
1848: what_part := 'In Grants Loop:';
1849:

Line 4004: from fnd_oracle_userid

4000: l_first_space_in_rl number;
4001: l_rel_comp_result boolean;
4002: cursor GET_MRC_SCHEMA_NAME is
4003: select oracle_username
4004: from fnd_oracle_userid
4005: where read_only_flag = 'K';
4006: begin
4007: -- only perform the work if the variables are null, meaning that
4008: -- this routine has not been called before

Line 4037: -- get mrc schema name from FND_ORACLE_USERID

4033: -- may have dropped it or the release might be 11.5.10 or more.
4034: -- In both these cases, we have to set "ad_apps_private.is_mc"
4035: -- to 'FALSE'.
4036:
4037: -- get mrc schema name from FND_ORACLE_USERID
4038:
4039: open GET_MRC_SCHEMA_NAME;
4040:
4041: fetch GET_MRC_SCHEMA_NAME

Line 4046: -- MRC schema not registered in FND_ORACLE_USERID.

4042: into l_mrc_schema_name;
4043:
4044: if GET_MRC_SCHEMA_NAME%NOTFOUND then
4045:
4046: -- MRC schema not registered in FND_ORACLE_USERID.
4047: -- Reset MRC flag to FALSE.
4048:
4049: close GET_MRC_SCHEMA_NAME;
4050:

Line 4054: -- MRC schema registered in FND_ORACLE_USERID, Check in DBA_USERS.

4050:
4051: ad_apps_private.is_mc := FALSE;
4052: else
4053:
4054: -- MRC schema registered in FND_ORACLE_USERID, Check in DBA_USERS.
4055:
4056: close GET_MRC_SCHEMA_NAME;
4057:
4058: if ad_apps_private.check_if_schema_exists(l_mrc_schema_name) then

Line 4106: -- end if block for MRC schema registered in FND_ORACLE_USERID

4102: ad_apps_private.is_mc := FALSE;
4103: end if;
4104:
4105: end if;
4106: -- end if block for MRC schema registered in FND_ORACLE_USERID
4107:
4108: else -- if not fnd_product_groups.multi_currency_flag
4109:
4110: ad_apps_private.is_mc := FALSE;

Line 4312: FROM fnd_oracle_userid

4308: log_message('run_edition_name:<'||l_run_edition||'>');
4309:
4310: SELECT oracle_username
4311: INTO l_apps_schema
4312: FROM fnd_oracle_userid
4313: WHERE read_only_flag='U';
4314: execute immediate 'select '||l_apps_schema||'.ad_zd.get_edition_type from dual'
4315: into l_edition_type;
4316: if l_edition_type = 'PATCH' then