[Home] [Help]
PACKAGE: APPS.CSC_PROFILE_CHECK_PVT
Source
1 PACKAGE CSC_PROFILE_CHECK_PVT AUTHID CURRENT_USER as
2 /* $Header: cscvpcks.pls 115.11 2002/12/03 17:52:08 jamose ship $ */
3 -- Start of Comments
4 -- Package name : CSC_CHECK_PVT
5 -- Purpose :
6 -- History :25 Nov 02, JAmose For FND_API_G_MISS* changes
7 -- for Performance
8 -- NOTE :
9 -- End of Comments
10
11 -- Default number of records fetch per call
12 G_DEFAULT_NUM_REC_FETCH NUMBER := 30;
13 -- *******************************************************
14 -- Start of Comments
15 -- -------------------------------------------------------
16 -- Record name:Check_Rec_Type
17 -- -------------------------------------------------------
18 -- Parameters:
19 -- CHECK_ID
20 -- CHECK_NAME
21 -- CHECK_NAME_CODE
22 -- DESCRIPTION
23 -- START_DATE_ACTIVE
24 -- END_DATE_ACTIVE
25 -- SEEDED_FLAG
26 -- SELECT_TYPE
27 -- SELECT_BLOCK_ID
28 -- DATA_TYPE
29 -- FORMAT_MASK
30 -- THRESHOLD_GRADE
31 -- THRESHOLD_RATING_CODE
32 -- CHECK_UPPER_LOWER_FLAG
33 -- THRESHOLD_COLOR_CODE
34 -- CHECK_LEVEL
35 -- CATEGORY_CODE
36 -- CREATED_BY
37 -- CREATION_DATE
38 -- LAST_UPDATED_BY
39 -- LAST_UPDATE_DATE
40 -- LAST_UPDATE_LOGIN
41 -- APPLICATION_ID
42 --
43 -- End of Comments
44
45 TYPE Check_Rec_Type IS RECORD
46 (
47 CHECK_ID NUMBER,
48 CHECK_NAME VARCHAR2(240),
49 CHECK_NAME_CODE VARCHAR2(240),
50 DESCRIPTION VARCHAR2(720),
51 START_DATE_ACTIVE DATE ,
52 END_DATE_ACTIVE DATE ,
53 SEEDED_FLAG VARCHAR2(3),
54 SELECT_TYPE VARCHAR2(3),
55 SELECT_BLOCK_ID NUMBER,
56 DATA_TYPE VARCHAR2(90),
57 FORMAT_MASK VARCHAR2(90),
58 THRESHOLD_GRADE VARCHAR2(9),
59 THRESHOLD_RATING_CODE VARCHAR2(90),
60 CHECK_UPPER_LOWER_FLAG VARCHAR2(3),
61 THRESHOLD_COLOR_CODE VARCHAR2(90),
62 CHECK_LEVEL VARCHAR2(20),
63 -- CATEGORY_CODE VARCHAR2(30),
64 CREATED_BY NUMBER,
65 CREATION_DATE DATE,
66 LAST_UPDATED_BY NUMBER,
67 LAST_UPDATE_DATE DATE ,
68 LAST_UPDATE_LOGIN NUMBER,
69 OBJECT_VERSION_NUMBER NUMBER,
70 APPLICATION_ID NUMBER
71 );
72
73 G_MISS_Check_REC Check_Rec_Type;
74 TYPE Check_Tbl_Type IS TABLE OF Check_Rec_Type
75 INDEX BY BINARY_INTEGER;
76 G_MISS_Check_TBL Check_Tbl_Type;
77
78
79 -- *******************************************************
80 -- Start of Comments
81 -- *******************************************************
82 -- API Name: Create_Profile_check
83 -- Type : Private
84 -- Pre-Req :
85 -- Parameters:
86 -- IN
87 -- p_api_version_number IN NUMBER Required
88 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
89 -- p_commit IN VARCHAR2 Optional Default = CSC_CORE_UTILS_PVT.G_FALSE
90 -- p_validation_level IN NUMBER Optional Default = CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL
91 -- P_Check_Rec IN Check_Rec_Type Required
92 --
93 -- OUT:
94 -- x_return_status OUT VARCHAR2
95 -- x_msg_count OUT NUMBER
96 -- x_msg_data OUT VARCHAR2
97 --
98 -- End of Comments
99 --
100
101 PROCEDURE Create_Profile_Check(
102 P_Api_Version_Number IN NUMBER,
103 P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
104 P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
105 p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
106 p_CHECK_NAME IN VARCHAR2 DEFAULT NULL,
107 p_CHECK_NAME_CODE IN VARCHAR2 DEFAULT NULL,
108 p_DESCRIPTION IN VARCHAR2 DEFAULT NULL,
109 p_START_DATE_ACTIVE IN DATE DEFAULT NULL,
110 p_END_DATE_ACTIVE IN DATE DEFAULT NULL,
111 p_SEEDED_FLAG IN VARCHAR2 DEFAULT NULL,
112 p_SELECT_TYPE IN VARCHAR2 DEFAULT NULL,
113 p_SELECT_BLOCK_ID IN NUMBER DEFAULT NULL,
114 p_DATA_TYPE IN VARCHAR2 DEFAULT NULL,
115 p_FORMAT_MASK IN VARCHAR2 DEFAULT NULL,
116 p_THRESHOLD_GRADE IN VARCHAR2 DEFAULT NULL,
117 p_THRESHOLD_RATING_CODE IN VARCHAR2 DEFAULT NULL,
118 p_CHECK_UPPER_LOWER_FLAG IN VARCHAR2 DEFAULT NULL,
119 p_THRESHOLD_COLOR_CODE IN VARCHAR2 DEFAULT NULL,
120 p_CHECK_LEVEL IN VARCHAR2 DEFAULT NULL,
121 --p_CATEGORY_CODE IN VARCHAR2 DEFAULT NULL,
122 p_CREATED_BY IN NUMBER DEFAULT NULL,
123 p_CREATION_DATE IN DATE DEFAULT NULL,
124 p_LAST_UPDATED_BY IN NUMBER DEFAULT NULL,
125 p_LAST_UPDATE_DATE IN DATE DEFAULT NULL,
126 p_LAST_UPDATE_LOGIN IN NUMBER DEFAULT NULL,
127 X_CHECK_ID OUT NOCOPY NUMBER,
128 X_Object_Version_Number OUT NOCOPY NUMBER,
129 p_APPLICATION_ID IN NUMBER DEFAULT NULL,
130 X_Return_Status OUT NOCOPY VARCHAR2,
131 X_Msg_Count OUT NOCOPY NUMBER,
132 X_Msg_Data OUT NOCOPY VARCHAR2
133 );
134
135
136 -- *******************************************************
137 -- Start of Comments
138 -- *******************************************************
139 -- API Name: Create_Profile_check
140 -- Type : Private
141 -- Pre-Req :
142 -- Parameters:
143 -- IN
144 -- p_api_version_number IN NUMBER Required
145 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
146 -- p_commit IN VARCHAR2 Optional Default = CSC_CORE_UTILS_PVT.G_FALSE
147 -- p_validation_level IN NUMBER Optional Default = CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL
148 -- P_Check_Rec IN Check_Rec_Type Required
149 --
150 -- OUT:
151 -- x_return_status OUT VARCHAR2
152 -- x_msg_count OUT NUMBER
153 -- x_msg_data OUT VARCHAR2
154 --
155 -- End of Comments
156 --
157
158
159 PROCEDURE Create_Profile_Check(
160 P_Api_Version_Number IN NUMBER,
161 P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
162 P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
163 p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
164 P_Check_Rec IN Check_Rec_Type := G_MISS_CHECK_REC,
165 X_CHECK_ID OUT NOCOPY NUMBER,
166 X_Object_Version_Number OUT NOCOPY NUMBER,
167 X_Return_Status OUT NOCOPY VARCHAR2,
168 X_Msg_Count OUT NOCOPY NUMBER,
169 X_Msg_Data OUT NOCOPY VARCHAR2
170 );
171
172 PROCEDURE Update_Profile_Check(
173 P_Api_Version_Number IN NUMBER,
174 P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
175 P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
176 p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
177 p_CHECK_ID IN NUMBER DEFAULT NULL,
178 p_CHECK_NAME IN VARCHAR2 DEFAULT NULL,
179 p_CHECK_NAME_CODE IN VARCHAR2 DEFAULT NULL,
180 p_DESCRIPTION IN VARCHAR2 DEFAULT NULL,
181 p_START_DATE_ACTIVE IN DATE DEFAULT NULL,
182 p_END_DATE_ACTIVE IN DATE DEFAULT NULL,
183 p_SEEDED_FLAG IN VARCHAR2 DEFAULT NULL,
184 p_SELECT_TYPE IN VARCHAR2 DEFAULT NULL,
185 p_SELECT_BLOCK_ID IN NUMBER DEFAULT NULL,
186 p_DATA_TYPE IN VARCHAR2 DEFAULT NULL,
187 p_FORMAT_MASK IN VARCHAR2 DEFAULT NULL,
188 p_THRESHOLD_GRADE IN VARCHAR2 DEFAULT NULL,
189 p_THRESHOLD_RATING_CODE IN VARCHAR2 DEFAULT NULL,
190 p_CHECK_UPPER_LOWER_FLAG IN VARCHAR2 DEFAULT NULL,
191 p_THRESHOLD_COLOR_CODE IN VARCHAR2 DEFAULT NULL,
192 p_CHECK_LEVEL IN VARCHAR2 DEFAULT NULL,
193 p_CREATED_BY IN NUMBER DEFAULT NULL,
194 p_CREATION_DATE IN DATE DEFAULT NULL,
195 p_LAST_UPDATED_BY IN NUMBER DEFAULT NULL,
196 p_LAST_UPDATE_DATE IN DATE DEFAULT NULL,
197 p_LAST_UPDATE_LOGIN IN NUMBER DEFAULT NULL,
198 px_OBJECT_VERSION_NUMBER IN OUT NOCOPY NUMBER,
199 p_APPLICATION_ID IN NUMBER DEFAULT NULL,
200 X_Return_Status OUT NOCOPY VARCHAR2,
201 X_Msg_Count OUT NOCOPY NUMBER,
202 X_Msg_Data OUT NOCOPY VARCHAR2
203 ) ;
204
205
206
207 -- *******************************************************
208 -- Start of Comments
209 -- *******************************************************
210 -- API Name: Update_check
211 -- Type : Private
212 -- Pre-Req :
213 -- Parameters:
214 -- IN
215 -- p_api_version_number IN NUMBER Required
216 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
217 -- p_commit IN VARCHAR2 Optional Default = CSC_CORE_UTILS_PVT.G_FALSE
218 -- p_validation_level IN NUMBER Optional Default = CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL
219 -- P_Check_Rec IN Check_Rec_Type Required
220 --
221 -- OUT:
222 -- x_return_status OUT VARCHAR2
223 -- x_msg_count OUT NUMBER
224 -- x_msg_data OUT VARCHAR2
225 --
226 -- End of Comments
227 --
228 PROCEDURE Update_Profile_check(
229 P_Api_Version_Number IN NUMBER,
230 P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
231 P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
232 p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
233 P_Check_Rec IN Check_Rec_Type,
234 PX_OBJECT_VERSION_NUMBER IN OUT NOCOPY NUMBER,
235 X_Return_Status OUT NOCOPY VARCHAR2,
236 X_Msg_Count OUT NOCOPY NUMBER,
237 X_Msg_Data OUT NOCOPY VARCHAR2
238 );
239
240 PROCEDURE Delete_profile_check(
241 P_Api_Version_Number IN NUMBER,
242 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
243 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
244 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
245 p_Check_Id IN NUMBER,
246 p_OBJECT_VERSION_NUMBER IN NUMBER,
247 X_Return_Status OUT NOCOPY VARCHAR2,
248 X_Msg_Count OUT NOCOPY NUMBER,
249 X_Msg_Data OUT NOCOPY VARCHAR2
250 );
251
252 PROCEDURE Validate_Check(
253 p_init_msg_list IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
254 p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
255 p_Validation_mode IN VARCHAR2,
256 p_check_rec IN Check_Rec_Type,
257 X_Return_Status OUT NOCOPY VARCHAR2,
258 X_MSg_count OUT NOCOPY NUMBER,
259 X_Msg_Data OUT NOCOPY VARCHAR2
260 );
261
262 PROCEDURE Validate_check_level
263 ( p_api_name IN VARCHAR2,
264 p_parameter_name IN VARCHAR2,
265 p_check_level IN VARCHAR2,
266 x_return_status OUT NOCOPY VARCHAR2
267 );
268
269
270
271 End CSC_PROFILE_CHECK_PVT;