APPS.FND_XDFDICTIONARY_PKG dependencies on FND_OBJECT_TABLESPACES

Line 3882: from FND_OBJECT_TABLESPACES

3878: f_ludate := nvl(to_date(P_last_update_date, 'YYYY/MM/DD'), sysdate);
3879:
3880: select last_updated_by, last_update_date
3881: into db_luby, db_ludate
3882: from FND_OBJECT_TABLESPACES
3883: where object_name = P_OBJECT_NAME
3884: and application_id =P_application_id
3885: and object_type =P_object_type;
3886:

Line 3907: --select FND_OBJECT_TABLESPACES_S.nextval into man_id from duaL;

3903: exception
3904: when NO_DATA_FOUND then
3905:
3906: -- select fnd_menus_s.nextval into man_id from dual;
3907: --select FND_OBJECT_TABLESPACES_S.nextval into man_id from duaL;
3908:
3909: Fnd_XdfDictionary_pkg.INSERT_ROW(
3910: X_ROWID => ROW_ID,
3911: P_APPLICATION_ID => P_application_id,

Line 3943: cursor C is select ROWID from FND_OBJECT_TABLESPACES

3939: P_LAST_UPDATE_DATE IN DATE,
3940: P_LAST_UPDATED_BY IN NUMBER,
3941: P_LAST_UPDATE_LOGIN IN NUMBER
3942: ) is
3943: cursor C is select ROWID from FND_OBJECT_TABLESPACES
3944: where APPLICATION_ID = P_APPLICATION_ID
3945: and object_name =P_object_name
3946: and object_type=P_object_type ;
3947:

Line 3949: insert into FND_OBJECT_TABLESPACES (

3945: and object_name =P_object_name
3946: and object_type=P_object_type ;
3947:
3948: begin
3949: insert into FND_OBJECT_TABLESPACES (
3950: APPLICATION_ID,
3951: OBJECT_NAME,
3952: OBJECT_TYPE,
3953: TABLESPACE_TYPE,

Line 3988: from FND_OBJECT_TABLESPACES

3984: P_OBJECT_NAME in VARCHAR2,
3985: P_OBJECT_TYPE in VARCHAR2,
3986: P_TABLESPACE_TYPE in VARCHAR2) is
3987: cursor c is select OBJECT_NAME, OBJECT_TYPE
3988: from FND_OBJECT_TABLESPACES
3989: where APPLICATION_ID = P_APPLICATION_ID
3990: for update of APPLICATION_ID nowait;
3991: recinfo c%rowtype;
3992: begin

Line 4027: update FND_OBJECT_TABLESPACES set

4023: P_LAST_UPDATED_BY in NUMBER,
4024: P_LAST_UPDATE_LOGIN in NUMBER
4025: ) is
4026: begin
4027: update FND_OBJECT_TABLESPACES set
4028: OBJECT_NAME = P_OBJECT_NAME,
4029: OBJECT_TYPE = P_OBJECT_TYPE,
4030: TABLESPACE_TYPE = P_TABLESPACE_TYPE,
4031: CUSTOM_TABLESPACE_TYPE = P_CUSTOM_TABLESPACE_TYPE,