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