[Home] [Help]
PACKAGE: APPS.FND_OBJECT_TABLESPACES_PUB
Source
1 PACKAGE FND_OBJECT_TABLESPACES_PUB AS
2 /* $Header: fndpobjs.pls 120.1 2005/07/02 03:35:51 appldev noship $ */
3 /*#
4 * This package contains procedures for registering or customizing object
5 * classifications. It is relevant only for objects that require explicit
6 * tablespace classification. All necessary validations are performed before
7 * propagating changes to FND_OBJECT_TABLESPACES.
8 *
9 * @rep:scope public
10 * @rep:product FND
11 * @rep:displayname Customize Object Classification
12 * @rep:lifecycle active
13 * @rep:category BUSINESS_ENTITY FND_OBJECT_CLASSIFICATION
14 */
15
16 /*#
17 * Use this API to create rows in the FND_OBJECT_TABLESPACES table.
18 *
19 * @param P_Api_Version_Number API version number.
20 * @param P_Init_Msg_List Set to TRUE to initialize message list.
21 * @param P_Commit Should we commit at the end?
22 * @param P_application_short_name Application short name.
23 * @param P_object_name Object name.
24 * @param P_tablespace_type New tablespace type.
25 * @param P_object_type Object type.
26 * @param X_Return_Status Return status.
27 * @param X_Msg_Count Number of message returned.
28 * @param X_Msg_Data Message data returned.
29 * @rep:scope public
30 * @rep:lifecycle active
31 * @rep:displayname Create Object Tablespaces Classification
32 */
33
34 PROCEDURE CREATE_OBJECT_TABLESPACES(
35 P_Api_Version_Number IN NUMBER,
36 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
37 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
38 P_application_short_name in varchar2,
39 P_object_name in varchar2,
40 P_tablespace_type in varchar2,
41 P_object_type in varchar2 := 'TABLE',
42 X_Return_Status OUT NOCOPY VARCHAR2,
43 X_Msg_Count OUT NOCOPY NUMBER,
44 X_Msg_Data OUT NOCOPY VARCHAR2);
45
46 /*#
47 * Use this API to update rows in the FND_OBJECT_TABLESPACES table.
48 *
49 * @param P_Api_Version_Number API version number.
50 * @param P_Init_Msg_List Set to TRUE to initialize message list.
51 * @param P_Commit Should we commit at the end?
52 * @param P_application_short_name Application short name.
53 * @param P_object_name Object name.
54 * @param P_tablespace_type New tablespace type.
55 * @param P_object_type Object type.
56 * @param X_Return_Status Return status.
57 * @param X_Msg_Count Number of the messages returned.
58 * @param X_Msg_Data Message data returned.
59 * @rep:scope public
60 * @rep:lifecycle active
61 * @rep:displayname Update Object Tablespaces Classification
62 */
63 PROCEDURE UPDATE_OBJECT_TABLESPACES(
64 P_Api_Version_Number IN NUMBER,
65 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
66 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
67 P_application_short_name in varchar2,
68 P_object_name in varchar2,
69 P_tablespace_type in varchar2,
70 P_object_type in varchar2 := 'TABLE',
71 X_Return_Status OUT NOCOPY VARCHAR2,
72 X_Msg_Count OUT NOCOPY NUMBER,
73 X_Msg_Data OUT NOCOPY VARCHAR2);
74
75
76 /*#
77 * This API validates changes before the changes are propagated to the
78 * FND_OBJECT_TABLESPACES table.
79 *
80 * @param P_Init_Msg_List Set to TRUE to initialize message list.
81 * @param P_Validation_mode Can be either AS_UTILITY_PVT.G_CREATE or AS_UTILITY_PVT.G_UPDATE.
82 * @param P_application_short_name application short name.
83 * @param P_object_name Object name.
84 * @param P_tablespace_type New tablespace type.
85 * @param P_object_type Object type.
86 * @param x_application_id Application id returned.
87 * @param x_oracle_username Oracle username returned.
88 * @param X_Return_Status Return status.
89 * @param X_Msg_Count Number of message returned.
90 * @param X_Msg_Data Message data returned.
91 * @rep:scope public
92 * @rep:lifecycle active
93 * @rep:displayname Validate Object Tablespace Classification
94 *
95 */
96
97 PROCEDURE VALIDATE_OBJECT_TABLESPACES (
98 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
99 P_Validation_mode IN VARCHAR2,
100 P_application_short_name in varchar2,
101 P_object_name in varchar2,
102 P_tablespace_type in varchar2,
103 P_object_type in varchar2,
104 x_application_id OUT NOCOPY NUMBER,
105 x_oracle_username OUT NOCOPY VARCHAR2,
106 X_Return_Status OUT NOCOPY VARCHAR2,
107 X_Msg_Count OUT NOCOPY NUMBER,
108 X_Msg_Data OUT NOCOPY VARCHAR2);
109
110 END FND_OBJECT_TABLESPACES_PUB;