[Home] [Help]
PACKAGE: APPS.CSC_PROF_GROUP_CAT_PVT
Source
1 PACKAGE CSC_PROF_GROUP_CAT_PVT AUTHID CURRENT_USER as
2 /* $Header: cscvpcas.pls 115.7 2002/12/03 19:27:16 jamose ship $ */
3 -- Start of Comments
4 -- Package name : CSC_PROF_GROUP_CAT_PVT
5 -- Purpose :
6 -- History :
7 -- 27 Nov 02 jamose For Fnd_Api_G_Miss* and NOCOPY changes
8 -- NOTE :
9 -- End of Comments
10
11 -- Default number of records fetch per call
12 G_DEFAULT_NUM_REC_FETCH NUMBER := 30;
13 l_dummy varchar2(100);
14 -- *******************************************************
15 -- Start of Comments
16 -- -------------------------------------------------------
17 -- Record name:PROF_GRP_CAT_Rec_Type
18 -- -------------------------------------------------------
19 -- Parameters:
20 -- GROUP_CATEGORY_ID
21 -- GROUP_ID
22 -- CATEGORY_CODE
23 -- CATEGORY_SEQUENCE
24 -- CREATED_BY
25 -- CREATION_DATE
26 -- LAST_UPDATED_BY
27 -- LAST_UPDATE_DATE
28 -- LAST_UPDATE_LOGIN
29 -- SEEDED_FLAG
30 --
31 -- Required:
32 -- Defaults:
33 --
34 -- End of Comments
35
36 TYPE PROF_GRP_CAT_Rec_Type IS RECORD
37 (
38 GROUP_CATEGORY_ID NUMBER,
39 GROUP_ID NUMBER,
40 CATEGORY_CODE VARCHAR2(30),
41 CATEGORY_SEQUENCE NUMBER,
42 CREATED_BY NUMBER,
43 CREATION_DATE DATE,
44 LAST_UPDATED_BY NUMBER,
45 LAST_UPDATE_DATE DATE,
46 LAST_UPDATE_LOGIN NUMBER,
47 SEEDED_FLAG VARCHAR2(3)
48 );
49
50 G_MISS_PROF_GRP_CAT_REC PROF_GRP_CAT_Rec_Type;
51 TYPE PROF_GRP_CAT_Tbl_Type IS TABLE OF PROF_GRP_CAT_Rec_Type
52 INDEX BY BINARY_INTEGER;
53 G_MISS_PROF_GRP_CAT_TBL PROF_GRP_CAT_Tbl_Type;
54
55 -- *******************************************************
56 -- Start of Comments
57 -- *******************************************************
58 -- API Name: Create_csc_prof_group_cat
59 -- Type : Private
60 -- Pre-Req :
61 -- Parameters:
62 -- IN
63 -- p_api_version_number IN NUMBER Required
64 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
65 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
66 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
67 -- P_PROF_GRP_CAT_Rec IN PROF_GRP_CAT_Rec_Type Required
68 --
69 -- OUT:
70 -- x_return_status OUT VARCHAR2
71 -- x_msg_count OUT NUMBER
72 -- x_msg_data OUT VARCHAR2
73 -- Version : Current version 1.0
74 --
75 -- End of Comments
76 --
77 PROCEDURE Create_csc_prof_group_cat(
78 P_Api_Version_Number IN NUMBER,
79 P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
80 P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
81 p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
82 px_GROUP_CATEGORY_ID IN OUT NOCOPY NUMBER,
83 p_GROUP_ID IN NUMBER,
84 p_CATEGORY_CODE IN VARCHAR2,
85 p_CATEGORY_SEQUENCE IN NUMBER,
86 p_CREATED_BY IN NUMBER,
87 p_CREATION_DATE IN DATE,
88 p_LAST_UPDATED_BY IN NUMBER,
89 p_LAST_UPDATE_DATE IN DATE,
90 p_LAST_UPDATE_LOGIN IN NUMBER,
91 p_SEEDED_FLAG 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
97 PROCEDURE Create_csc_prof_group_cat(
98 P_Api_Version_Number IN NUMBER,
99 P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
100 P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
101 p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
102 PX_GROUP_CATEGORY_ID IN OUT NOCOPY NUMBER,
103 P_PROF_GRP_CAT_Rec IN PROF_GRP_CAT_Rec_Type := G_MISS_PROF_GRP_CAT_REC,
104 X_Return_Status OUT NOCOPY VARCHAR2,
105 X_Msg_Count OUT NOCOPY NUMBER,
106 X_Msg_Data OUT NOCOPY VARCHAR2
107 );
108
109 -- *******************************************************
110 -- Start of Comments
111 -- *******************************************************
112 -- API Name: Update_csc_prof_group_cat
113 -- Type : Private
114 -- Pre-Req :
115 -- Parameters:
116 -- IN
117 -- p_api_version_number IN NUMBER Required
118 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
119 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
120 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
121 -- P_PROF_GRP_CAT_Rec IN PROF_GRP_CAT_Rec_Type Required
122 --
123 -- OUT:
124 -- x_return_status OUT VARCHAR2
125 -- x_msg_count OUT NUMBER
126 -- x_msg_data OUT VARCHAR2
127 -- Version : Current version 1.0
128 --
129 -- End of Comments
130 --
131 PROCEDURE Update_csc_prof_group_cat(
132 P_Api_Version_Number IN NUMBER,
133 P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
134 P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
135 p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
136 p_GROUP_CATEGORY_ID IN NUMBER,
137 p_GROUP_ID IN NUMBER,
138 p_CATEGORY_CODE IN VARCHAR2,
139 p_CATEGORY_SEQUENCE IN NUMBER,
140 p_CREATED_BY IN NUMBER DEFAULT NULL,
141 p_CREATION_DATE IN DATE DEFAULT NULL,
142 p_LAST_UPDATED_BY IN NUMBER,
143 p_LAST_UPDATE_DATE IN DATE,
144 p_LAST_UPDATE_LOGIN IN NUMBER,
145 p_SEEDED_FLAG IN VARCHAR2,
146 X_Return_Status OUT NOCOPY VARCHAR2,
147 X_Msg_Count OUT NOCOPY NUMBER,
148 X_Msg_Data OUT NOCOPY VARCHAR2
149 );
150
151 PROCEDURE Update_csc_prof_group_cat(
152 P_Api_Version_Number IN NUMBER,
153 P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
154 P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
155 p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
156 P_PROF_GRP_CAT_Rec IN PROF_GRP_CAT_Rec_Type,
157 X_Return_Status OUT NOCOPY VARCHAR2,
158 X_Msg_Count OUT NOCOPY NUMBER,
159 X_Msg_Data OUT NOCOPY VARCHAR2
160 );
161
162 -- *******************************************************
163 -- Start of Comments
164 -- *******************************************************
165 -- API Name: Delete_csc_prof_group_cat
166 -- Type : Private
167 -- Pre-Req :
168 -- Parameters:
169 -- IN
170 -- p_api_version_number IN NUMBER Required
171 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
172 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
173 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
174 -- P_PROF_GRP_CAT_Rec IN PROF_GRP_CAT_Rec_Type Required
175 --
176 -- OUT:
177 -- x_return_status OUT VARCHAR2
178 -- x_msg_count OUT NUMBER
179 -- x_msg_data OUT VARCHAR2
180 -- Version : Current version 1.0
181 --
182 -- End of Comments
183 --
184
185 PROCEDURE Delete_csc_prof_group_cat(
186 P_Api_Version_Number IN NUMBER,
187 P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
188 P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
189 p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
190 P_PROF_GRP_CAT_Rec IN PROF_GRP_CAT_Rec_Type,
191 X_Return_Status OUT NOCOPY VARCHAR2,
192 X_Msg_Count OUT NOCOPY NUMBER,
193 X_Msg_Data OUT NOCOPY VARCHAR2
194 );
195
196
197
198
199 -- Start of Comments
200 --
201 -- Item level validation procedures
202 --
203 --
204 -- End of Comments
205
206 PROCEDURE Validate_GROUP_CATEGORY_ID (
207 P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
208 P_Validation_mode IN VARCHAR2,
209 P_GROUP_CATEGORY_ID IN NUMBER,
210 X_Return_Status OUT NOCOPY VARCHAR2,
211 X_Msg_Count OUT NOCOPY NUMBER,
212 X_Msg_Data OUT NOCOPY VARCHAR2
213 );
214
215 -- Start of Comments
216 --
217 -- Item level validation procedures
218 --
219 --
220 -- End of Comments
221
222 PROCEDURE Validate_GROUP_ID (
223 P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
224 P_Validation_mode IN VARCHAR2,
225 P_GROUP_ID IN NUMBER,
226 X_Return_Status OUT NOCOPY VARCHAR2,
227 X_Msg_Count OUT NOCOPY NUMBER,
228 X_Msg_Data OUT NOCOPY VARCHAR2
229 );
230
231 -- Start of Comments
232 --
233 -- Item level validation procedures
234 --
235 --
236 -- End of Comments
237
238 PROCEDURE Validate_CATEGORY_CODE (
239 P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
240 P_Validation_mode IN VARCHAR2,
241 P_CATEGORY_CODE IN VARCHAR2,
242 P_GROUP_ID IN NUMBER,
243 X_Return_Status OUT NOCOPY VARCHAR2,
244 X_Msg_Count OUT NOCOPY NUMBER,
245 X_Msg_Data OUT NOCOPY VARCHAR2
246 );
247
248
249 -- Start of Comments
250 --
251 -- Item level validation procedures
252 --
253 -- End of Comments
254
255 PROCEDURE Validate_CATEGORY_SEQUENCE (
256 P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
257 P_Validation_mode IN VARCHAR2,
258 P_CATEGORY_SEQUENCE IN NUMBER,
259 X_Return_Status OUT NOCOPY VARCHAR2,
260 X_Msg_Count OUT NOCOPY NUMBER,
261 X_Msg_Data OUT NOCOPY VARCHAR2
262 );
263
264 -- Start of Comments
265 --
266 -- Record level validation procedures
267 --
268 -- End of Comments
269
270
271 -- Start of Comments
272 --
273 -- validation procedures
274 --
275 -- End of Comments
276
277 PROCEDURE Validate_csc_prof_group_cat(
278 P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
279 P_Validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
280 P_Validation_mode IN VARCHAR2,
281 P_PROF_GRP_CAT_Rec IN PROF_GRP_CAT_Rec_Type,
282 X_Return_Status OUT NOCOPY VARCHAR2,
283 X_Msg_Count OUT NOCOPY NUMBER,
284 X_Msg_Data OUT NOCOPY VARCHAR2
285 );
286 End CSC_PROF_GROUP_CAT_PVT;