APPS.FND_OBJECT_TABLESPACES_PKG dependencies on FND_OBJECT_TABLESPACES

Line 1: package body FND_OBJECT_TABLESPACES_PKG as

1: package body FND_OBJECT_TABLESPACES_PKG as
2: /* $Header: fndtobjb.pls 115.10 2004/04/22 22:14:20 sakhtar noship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30):= 'FND_OBJECT_TABLESPACES_PKG';
5: G_FILE_NAME CONSTANT VARCHAR2(12) := 'fndtobjb.pls';

Line 4: G_PKG_NAME CONSTANT VARCHAR2(30):= 'FND_OBJECT_TABLESPACES_PKG';

1: package body FND_OBJECT_TABLESPACES_PKG as
2: /* $Header: fndtobjb.pls 115.10 2004/04/22 22:14:20 sakhtar noship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30):= 'FND_OBJECT_TABLESPACES_PKG';
5: G_FILE_NAME CONSTANT VARCHAR2(12) := 'fndtobjb.pls';
6:
7: function OWNER_ID(
8: p_name in varchar2)

Line 132: select ROWID from fnd_object_tablespaces

128: P_LAST_UPDATED_BY IN NUMBER DEFAULT NULL,
129: P_LAST_UPDATE_LOGIN IN NUMBER DEFAULT NULL
130: ) is
131: cursor C is
132: select ROWID from fnd_object_tablespaces
133: where application_id = p_application_id
134: and object_name = p_object_name;
135: CURSOR c1 IS
136: select fou.oracle_username

Line 149: insert into FND_OBJECT_TABLESPACES (

145: FETCH c1 INTO l_schema;
146: CLOSE c1;
147: end if;
148:
149: insert into FND_OBJECT_TABLESPACES (
150: APPLICATION_ID,
151: OBJECT_NAME,
152: OBJECT_TYPE,
153: TABLESPACE_TYPE,

Line 204: update FND_OBJECT_TABLESPACES set

200: P_LAST_UPDATED_BY in NUMBER DEFAULT NULL,
201: P_LAST_UPDATE_LOGIN in NUMBER DEFAULT NULL
202: ) is
203: BEGIN
204: update FND_OBJECT_TABLESPACES set
205: OBJECT_TYPE = decode(P_OBJECT_TYPE, NULL, OBJECT_TYPE, p_OBJECT_TYPE),
206: TABLESPACE_TYPE = decode(P_TABLESPACE_TYPE, NULL, TABLESPACE_TYPE, p_TABLESPACE_TYPE),
207: CUSTOM_TABLESPACE_TYPE = decode(P_CUSTOM_TABLESPACE_TYPE, NULL, CUSTOM_TABLESPACE_TYPE, p_CUSTOM_TABLESPACE_TYPE),
208: OBJECT_SOURCE = decode(P_OBJECT_SOURCE, NULL, OBJECT_SOURCE, p_OBJECT_SOURCE),

Line 236: FND_OBJECT_TABLESPACES_PKG.LOAD_ROW (

232: P_CUSTOM_FLAG in VARCHAR2,
233: P_CUSTOM_MODE in VARCHAR2
234: ) is
235: BEGIN
236: FND_OBJECT_TABLESPACES_PKG.LOAD_ROW (
237: P_APPLICATION_ID => P_APPLICATION_ID ,
238: P_OBJECT_NAME => P_OBJECT_NAME,
239: P_OBJECT_TYPE => P_OBJECT_TYPE,
240: P_TABLESPACE_TYPE => P_TABLESPACE_TYPE,

Line 279: from FND_OBJECT_TABLESPACES

275: f_ludate := nvl(to_date(P_last_update_date, 'YYYY/MM/DD'), sysdate);
276:
277: select last_updated_by, last_update_date
278: into db_luby, db_ludate
279: from FND_OBJECT_TABLESPACES
280: where application_id = p_application_id
281: and object_name = p_object_name;
282:
283: if (upload_test(f_luby, f_ludate, db_luby,db_ludate,

Line 285: FND_OBJECT_TABLESPACES_PKG.UPDATE_ROW (

281: and object_name = p_object_name;
282:
283: if (upload_test(f_luby, f_ludate, db_luby,db_ludate,
284: p_custom_mode)) then
285: FND_OBJECT_TABLESPACES_PKG.UPDATE_ROW (
286: P_APPLICATION_ID => P_application_id,
287: P_OBJECT_NAME => P_OBJECT_NAME,
288: P_OBJECT_TYPE => P_OBJECT_TYPE,
289: P_TABLESPACE_TYPE => P_TABLESPACE_TYPE,

Line 300: FND_OBJECT_TABLESPACES_PKG.INSERT_ROW(

296: P_LAST_UPDATE_LOGIN => -1 );
297: end if;
298: EXCEPTION
299: when NO_DATA_FOUND then
300: FND_OBJECT_TABLESPACES_PKG.INSERT_ROW(
301: X_ROWID => row_id,
302: P_APPLICATION_ID => P_APPLICATION_ID,
303: P_OBJECT_NAME => P_OBJECT_NAME,
304: P_OBJECT_TYPE => P_OBJECT_TYPE,

Line 323: delete from FND_OBJECT_TABLESPACES

319: P_OBJECT_NAME in VARCHAR2,
320: P_OBJECT_TYPE in VARCHAR2
321: ) is
322: BEGIN
323: delete from FND_OBJECT_TABLESPACES
324: where APPLICATION_ID = P_APPLICATION_ID
325: and OBJECT_NAME = P_OBJECT_NAME;
326:
327: if (sql%notfound) then

Line 332: END FND_OBJECT_TABLESPACES_PKG;

328: raise no_data_found;
329: end if;
330: END DELETE_ROW;
331:
332: END FND_OBJECT_TABLESPACES_PKG;