PACKAGE: APPS.FND_OBJECT_TABLESPACES_PKG

Source

1 package FND_OBJECT_TABLESPACES_PKG AUTHID CURRENT_USER as
2 /* $Header: fndtobjs.pls 115.9 2004/04/22 22:14:10 sakhtar noship $ */
3 
4 G_PKG_NAME CONSTANT VARCHAR2(30):= 'FND_OBJECT_TABLESPACES_PKG';
5 G_FILE_NAME CONSTANT VARCHAR2(12) := 'fndtobjs.pls';
6 
7 PROCEDURE INSERT_ROW (
8   X_ROWID in out  NOCOPY VARCHAR2,
9   P_APPLICATION_ID in NUMBER,
10   P_OBJECT_NAME in VARCHAR2,
11   P_OBJECT_TYPE in VARCHAR2,
12   P_TABLESPACE_TYPE in VARCHAR2,
13   P_CUSTOM_TABLESPACE_TYPE in VARCHAR2 DEFAULT NULL,
14   P_OBJECT_SOURCE   in  VARCHAR2 DEFAULT NULL,
15   P_ORACLE_USERNAME  in VARCHAR2 DEFAULT NULL,
16   P_CUSTOM_FLAG in VARCHAR2 DEFAULT NULL,
17   P_CREATION_DATE in DATE DEFAULT NULL,
18   P_CREATED_BY in NUMBER DEFAULT NULL,
19   P_LAST_UPDATE_DATE in DATE DEFAULT NULL,
20   P_LAST_UPDATED_BY in NUMBER DEFAULT NULL,
21   P_LAST_UPDATE_LOGIN in NUMBER DEFAULT NULL);
22 
23 PROCEDURE UPDATE_ROW (
24   P_APPLICATION_ID in NUMBER,
25   P_OBJECT_NAME in VARCHAR2,
26   P_OBJECT_TYPE in VARCHAR2,
27   P_TABLESPACE_TYPE in VARCHAR2 DEFAULT NULL,
28   P_CUSTOM_TABLESPACE_TYPE in VARCHAR2 DEFAULT NULL,
29   P_OBJECT_SOURCE   in  VARCHAR2 DEFAULT NULL,
30   P_ORACLE_USERNAME  in VARCHAR2 DEFAULT NULL,
31   P_CUSTOM_FLAG in VARCHAR2 DEFAULT NULL,
32   P_LAST_UPDATE_DATE in DATE DEFAULT NULL,
33   P_LAST_UPDATED_BY in NUMBER DEFAULT NULL,
34   P_LAST_UPDATE_LOGIN in NUMBER DEFAULT NULL);
35 
36 PROCEDURE LOAD_ROW (
37   P_APPLICATION_ID  in NUMBER,
38   P_OBJECT_NAME     in VARCHAR2,
39   P_OBJECT_TYPE     in VARCHAR2,
40   P_TABLESPACE_TYPE in VARCHAR2,
41   P_CUSTOM_TABLESPACE_TYPE in VARCHAR2,
42   P_OBJECT_SOURCE   in VARCHAR2,
43   P_ORACLE_USERNAME in VARCHAR2,
44   P_CUSTOM_FLAG in VARCHAR2,
45   P_CUSTOM_MODE     in VARCHAR2);
46 
47 PROCEDURE DELETE_ROW (
48   P_APPLICATION_ID in NUMBER,
49   P_OBJECT_NAME in VARCHAR2,
50   P_OBJECT_TYPE in VARCHAR2);
51 
52 PROCEDURE LOAD_ROW (
53   P_APPLICATION_ID  in NUMBER,
54   P_OBJECT_NAME     in VARCHAR2,
55   P_OBJECT_TYPE      in VARCHAR2,
56   P_TABLESPACE_TYPE  in VARCHAR2,
57   P_CUSTOM_TABLESPACE_TYPE  in VARCHAR2,
58   P_OBJECT_SOURCE    in VARCHAR2,
59   P_ORACLE_USERNAME in VARCHAR2,
60   P_CUSTOM_FLAG in VARCHAR2,
61   P_LAST_UPDATED_BY  in VARCHAR2,
62   P_CUSTOM_MODE      in VARCHAR2,
63   P_LAST_UPDATE_DATE in VARCHAR2);
64 
65 END FND_OBJECT_TABLESPACES_PKG;