APPS.FND_OBJECT_TABLESPACES_PUB dependencies on FND_ORACLE_USERID

Line 26: l_oracle_username FND_ORACLE_USERID.ORACLE_USERNAME%TYPE;

22: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_OBJECT_TABLESPACES';
23: l_api_version_number CONSTANT NUMBER := 1.0;
24: l_row_id VARCHAR2(4000);
25: l_application_id NUMBER;
26: l_oracle_username FND_ORACLE_USERID.ORACLE_USERNAME%TYPE;
27: BEGIN
28:
29: -- Standard Start of API savepoint
30: SAVEPOINT CREATE_OBJECT_TABLESPACES_PUB;

Line 141: l_oracle_username FND_ORACLE_USERID.ORACLE_USERNAME%TYPE;

137: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_OBJECT_TABLESPACES';
138: l_api_version_number CONSTANT NUMBER := 1.0;
139: l_row_id VARCHAR2(4000);
140: l_application_id NUMBER;
141: l_oracle_username FND_ORACLE_USERID.ORACLE_USERNAME%TYPE;
142: BEGIN
143:
144: -- Standard Start of API savepoint
145: SAVEPOINT UPDATE_OBJECT_TABLESPACES_PUB;

Line 263: fnd_oracle_userid fou

259:
260: cursor c4(l_app_id NUMBER) is
261: select oracle_username
262: from fnd_product_installations fpi,
263: fnd_oracle_userid fou
264: where fpi.oracle_id = fou.oracle_id
265: and fpi.application_id = l_app_id;
266:
267: cursor c5(l_app_id NUMBER) is

Line 278: AND EXISTS (select 1 from fnd_oracle_userid fou

274: select 1
275: from dba_tables dt
276: where dt.owner = l_oracle_user
277: AND dt.table_name = p_object_name
278: AND EXISTS (select 1 from fnd_oracle_userid fou
279: where fou.oracle_username = dt.owner
280: and read_only_flag IN ('E','A','U','K','M'))
281: AND NVL(dt.temporary, 'N') = 'N'
282: AND NVL(dt.iot_type, 'X') NOT IN ('IOT', 'IOT_OVERFLOW')

Line 301: l_oracle_username FND_ORACLE_USERID.ORACLE_USERNAME%TYPE;

297: AND dt.table_name NOT LIKE 'RUPD$%'
298: AND dt.table_name NOT LIKE 'MDRT%$';
299: l_dummy NUMBER;
300: l_application_id NUMBER;
301: l_oracle_username FND_ORACLE_USERID.ORACLE_USERNAME%TYPE;
302: BEGIN
303:
304: -- validate NOT NULL column
305: IF (p_APPLICATION_SHORT_NAME is NULL OR p_APPLICATION_SHORT_NAME = FND_API.G_MISS_CHAR)