APPS.FND_TABLESPACES_PKG dependencies on FND_TABLESPACES

Line 1: PACKAGE BODY FND_TABLESPACES_PKG as

1: PACKAGE BODY FND_TABLESPACES_PKG as
2: /* $Header: fndttblb.pls 115.6 2004/04/22 22:13:45 sakhtar noship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30):= 'FND_TABLESPACES_PKG';
5: G_FILE_NAME CONSTANT VARCHAR2(12) := 'fndttblb.pls';

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

1: PACKAGE BODY FND_TABLESPACES_PKG as
2: /* $Header: fndttblb.pls 115.6 2004/04/22 22:13:45 sakhtar noship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30):= 'FND_TABLESPACES_PKG';
5: G_FILE_NAME CONSTANT VARCHAR2(12) := 'fndttblb.pls';
6:
7: PROCEDURE INSERT_ROW (
8: X_ROWID IN OUT NOCOPY VARCHAR2,

Line 18: cursor C is select ROWID from FND_TABLESPACES

14: P_LAST_UPDATE_DATE IN DATE DEFAULT NULL,
15: P_LAST_UPDATED_BY IN NUMBER DEFAULT NULL,
16: P_LAST_UPDATE_LOGIN IN NUMBER DEFAULT NULL)
17: IS
18: cursor C is select ROWID from FND_TABLESPACES
19: where TABLESPACE_TYPE = P_TABLESPACE_TYPE ;
20:
21: BEGIN
22: insert into FND_TABLESPACES (

Line 22: insert into FND_TABLESPACES (

18: cursor C is select ROWID from FND_TABLESPACES
19: where TABLESPACE_TYPE = P_TABLESPACE_TYPE ;
20:
21: BEGIN
22: insert into FND_TABLESPACES (
23: TABLESPACE_TYPE,
24: TABLESPACE,
25: CUSTOM_FLAG ,
26: CREATION_DATE,

Line 62: update FND_TABLESPACES set

58: P_LAST_UPDATE_LOGIN in NUMBER DEFAULT NULL
59: )
60: IS
61: BEGIN
62: update FND_TABLESPACES set
63: TABLESPACE = decode(P_TABLESPACE, null, TABLESPACE, P_TABLESPACE),
64: CUSTOM_FLAG = decode(P_CUSTOM_FLAG, null, CUSTOM_FLAG, P_CUSTOM_FLAG),
65: LAST_UPDATE_DATE = decode(P_LAST_UPDATE_DATE, null, sysdate, P_LAST_UPDATE_DATE),
66: LAST_UPDATED_BY = decode(P_LAST_UPDATED_BY, null, -1, P_LAST_UPDATED_BY),

Line 80: delete from FND_TABLESPACES

76: PROCEDURE DELETE_ROW (
77: P_TABLESPACE_TYPE in VARCHAR2)
78: IS
79: BEGIN
80: delete from FND_TABLESPACES
81: where TABLESPACE_TYPE = P_TABLESPACE_TYPE ;
82: if (sql%notfound) then
83: raise no_data_found;
84: end if;

Line 87: END FND_TABLESPACES_PKG;

83: raise no_data_found;
84: end if;
85: END DELETE_ROW;
86:
87: END FND_TABLESPACES_PKG;