1 PACKAGE FND_TABLESPACES_PUB AUTHID CURRENT_USER AS
2 /* $Header: fndptbls.pls 120.1 2005/07/02 03:36:59 appldev noship $ */
3 /*#
4 * This package contains procedures for customizing the tablespace model by
5 * registering custom tablespace types that are not available by default with
6 * OATM and modifying tablespace names for any default OATM tablespaces or
7 * registered custom tablespaces. All necessary validation should be performed
8 * before propagating changes to FND_TABLESPACES.
9 *
10 * @rep:scope public
11 * @rep:product FND
12 * @rep:displayname Customize Tablespace Model
13 * @rep:lifecycle active
14 * @rep:category BUSINESS_ENTITY FND_TABLESPACE
15 */
16
17
18 /*#
19 * Use this procedure to register any custom tablespace types that are not
20 * available by default with OATM.
21 *
22 * @param P_Api_Version_Number API version number.
23 * @param P_Init_Msg_List Set to TRUE to initialize message list.
24 * @param P_Commit Should we commit at the end?
25 * @param P_TABLESPACE_TYPE New tablespace type.
26 * @param P_TABLESPACE New tablespace name.
27 * @param X_Return_Status Return status.
28 * @param X_Msg_Count Number of the messages returned.
29 * @param X_Msg_Data Message data returned.
30 * @rep:scope public
31 * @rep:lifecycle active
32 * @rep:displayname Create Custom Tablespace
33 */
34
35 PROCEDURE CREATE_TABLESPACES(
36 P_Api_Version_Number IN NUMBER,
37 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
38 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
39 P_TABLESPACE_TYPE IN VARCHAR2,
40 P_TABLESPACE IN VARCHAR2,
41 X_Return_Status OUT NOCOPY VARCHAR2,
42 X_Msg_Count OUT NOCOPY NUMBER,
43 X_Msg_Data OUT NOCOPY VARCHAR2);
44
45
46 /*#
47 * Use this procedure to modify tablespace names for any default OATM
48 * tablespaces or registered custom tablespaces.
49 *
50 * @param P_Api_Version_Number API version number.
51 * @param P_Init_Msg_List Set to TRUE to initialize message list.
52 * @param P_Commit Should we commit changes at the end?
53 * @param P_TABLESPACE_TYPE New tablespace type .
54 * @param P_TABLESPACE New tablespace name.
55 * @param X_Return_Status Return status.
56 * @param X_Msg_Count Number of the messages returned.
57 * @param X_Msg_Data Message data returned.
58 * @rep:scope public
59 * @rep:lifecycle active
60 * @rep:displayname Update Tablespace Name
61 */
62 PROCEDURE UPDATE_TABLESPACES(
63 P_Api_Version_Number IN NUMBER,
64 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
65 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
66 P_TABLESPACE_TYPE IN VARCHAR2,
67 P_TABLESPACE IN VARCHAR2,
68 X_Return_Status OUT NOCOPY VARCHAR2,
69 X_Msg_Count OUT NOCOPY NUMBER,
70 X_Msg_Data OUT NOCOPY VARCHAR2);
71
72 /*#
73 * Use this procedure to perform all necessary validation before propagating
74 * changes to FND_TABLESPACE.
75 *
76 * @param P_Init_Msg_List Set to TRUE to initialize message list (not used).
77 * @param P_Validation_mode Validation mode. Can be either AS_UTILITY_PVT.G_CREATE or AS_UTILITY_PVT.G_UPDATE.
78 * @param P_TABLESPACE_TYPE New tablespace type.
79 * @param P_TABLESPACE New tablespace name.
80 * @param X_Return_Status Return status.
81 * @param X_Msg_Count Number of the messages returned.
82 * @param X_Msg_Data Message data returned.
83 * @rep:scope public
84 * @rep:lifecycle active
85 * @rep:displayname Tablespace Validation
86 */
87 PROCEDURE VALIDATE_TABLESPACES (
88 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
89 P_Validation_mode IN VARCHAR2,
90 P_TABLESPACE_TYPE IN VARCHAR2,
91 P_TABLESPACE IN VARCHAR2,
92 X_Return_Status OUT NOCOPY VARCHAR2,
93 X_Msg_Count OUT NOCOPY NUMBER,
94 X_Msg_Data OUT NOCOPY VARCHAR2);
95
96 END FND_TABLESPACES_PUB;