APPS.AD_TSPACE_UTIL dependencies on FND_OBJECT_TABLESPACES

Line 119: from FND_OBJECT_TABLESPACES

115: CURSOR OBJ_INFO (c_appl_id number,
116: c_object_name in varchar2)
117: is
118: select upper(TABLESPACE_TYPE), upper(OBJECT_TYPE)
119: from FND_OBJECT_TABLESPACES
120: where UPPER(OBJECT_NAME)=UPPER(c_object_name)
121: AND APPLICATION_ID = c_appl_id;
122:
123: CURSOR VALIDATE_TS (c_tspace in varchar2)

Line 248: else -- object classified in FND_OBJECT_TABLESPACES

244: '" is incorrect');
245: end if;
246:
247:
248: else -- object classified in FND_OBJECT_TABLESPACES
249:
250: -- check if object type match
251:
252: if (UPPER(l_object_type) <> UPPER(x_object_type))

Line 258: '" in FND_OBJECT_TABLESPACES.');

254: raise_application_error(-20001,
255: 'The passed object type "'||UPPER(x_object_type)||
256: '" for "'||UPPER(x_object_name)||
257: '" does not match seeded object type "'||UPPER(l_object_type)||
258: '" in FND_OBJECT_TABLESPACES.');
259: end if;
260:
261: end if; -- end if l_is_object_registered='N''
262:

Line 415: -- no row matched in FND_OBJECT_TABLESPACES with given x_object_name and l_appl_id

411: fetch VALIDATE_TS
412: into l_dummy;
413:
414: if VALIDATE_TS%NOTFOUND then
415: -- no row matched in FND_OBJECT_TABLESPACES with given x_object_name and l_appl_id
416: close VALIDATE_TS;
417: x_ts_exists:='N';
418:
419: else

Line 627: -- no row matched in FND_OBJECT_TABLESPACES

623: fetch VALIDATE_TS
624: into l_dummy;
625:
626: if VALIDATE_TS%NOTFOUND then
627: -- no row matched in FND_OBJECT_TABLESPACES
628: -- with given x_object_name and l_appl_id
629:
630: close VALIDATE_TS;
631: x_ts_exists:='N';