DBA Data[Home] [Help]

APPS.AZ_PROFILEVALUE_CONVERT_PKG dependencies on FND_ORACLE_USERID

Line 150: from FND_ORACLE_USERID ou, FND_TABLES t

146: L_APP_CODE := '';
147:
148: BEGIN
149: select ou.ORACLE_USERNAME into L_APP_CODE
150: from FND_ORACLE_USERID ou, FND_TABLES t
151: where ou.ORACLE_ID = t.APPLICATION_ID AND t.TABLE_NAME = P_TBL_NAME;
152: EXCEPTION
153: when OTHERS then L_APP_CODE := '';
154: END;

Line 165: from FND_ORACLE_USERID ou, FND_VIEWS v

161: END IF;
162:
163: BEGIN
164: select ou.ORACLE_USERNAME into L_APP_CODE
165: from FND_ORACLE_USERID ou, FND_VIEWS v
166: where ou.ORACLE_ID = v.APPLICATION_ID AND v.VIEW_NAME = P_TBL_NAME;
167: EXCEPTION
168: when OTHERS then L_APP_CODE := '';
169: END;

Line 195: from fnd_oracle_userid where read_only_flag = 'U';

191:
192: IF ( P_TBL_TYPE = 'VIEW' ) THEN
193: BEGIN
194: select oracle_username into L_OWNER
195: from fnd_oracle_userid where read_only_flag = 'U';
196: EXCEPTION
197: when OTHERS then L_OWNER := 'APPS';
198: END;
199: ELSE -- 'TABLE'