[Home] [Help]
PACKAGE: APPS.CSC_CHECK_RATINGS_PVT
Source
1 PACKAGE CSC_CHECK_RATINGS_PVT AUTHID CURRENT_USER as
2 /* $Header: cscvpras.pls 115.9 2002/12/03 18:01:41 jamose ship $ */
3 -- Start of Comments
4 -- Package name : CSC_CHECK_RATINGS_PVT
5 -- Purpose :
6 -- History :
7 -- 18 Nov 02 jamose made changes for the NOCOPY and FND_API.G_MISS*
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:CHK_RATING_Rec_Type
17 -- -------------------------------------------------------
18 -- Parameters:
19 -- CHECK_RATING_ID
20 -- CHECK_ID
21 -- CHECK_RATING_GRADE
22 -- RATING_COLOR_ID
23 -- RATING_CODE
24 -- COLOR_CODE
25 -- RANGE_LOW_VALUE
26 -- RANGE_HIGH_VALUE
27 -- LAST_UPDATE_DATE
28 -- LAST_UPDATED_BY
29 -- CREATION_DATE
30 -- CREATED_BY
31 -- LAST_UPDATE_LOGIN
32 -- SEEDED_FLAG
33 --
34 -- Defaults:
35 --
36 -- End of Comments
37
38 TYPE CHK_RATING_Rec_Type IS RECORD
39 (
40 CHECK_RATING_ID NUMBER,
41 CHECK_ID NUMBER,
42 CHECK_RATING_GRADE VARCHAR2(9),
43 RATING_COLOR_ID NUMBER,
44 RATING_CODE VARCHAR2(30),
45 COLOR_CODE VARCHAR2(30),
46 RANGE_LOW_VALUE VARCHAR2(240),
47 RANGE_HIGH_VALUE VARCHAR2(240),
48 LAST_UPDATE_DATE DATE,
49 LAST_UPDATED_BY NUMBER,
50 CREATION_DATE DATE,
51 CREATED_BY NUMBER,
52 LAST_UPDATE_LOGIN NUMBER,
53 SEEDED_FLAG VARCHAR2(3)
54 );
55
56 G_MISS_CHK_RATING_REC CHK_RATING_Rec_Type;
57 TYPE CHK_RATING_Tbl_Type IS TABLE OF CHK_RATING_Rec_Type
58 INDEX BY BINARY_INTEGER;
59 G_MISS_CHK_RATING_TBL CHK_RATING_Tbl_Type;
60
61 TYPE RATE_ID_Tbl_Type IS TABLE OF NUMBER
62 INDEX BY BINARY_INTEGER;
63
64
65 -- *******************************************************
66 -- Start of Comments
67 -- *******************************************************
68 -- API Name: Create_check_ratings
69 -- Type : Private
70 -- Pre-Req :
71 -- Parameters:
72 -- IN
73 -- p_api_version_number IN NUMBER Required
74 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
75 -- p_commit IN VARCHAR2 Optional Default = CSC_CORE_UTILS_PVT.G_FALSE
76 -- p_validation_level IN NUMBER Optional Default = CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL
77 -- P_CHK_RATING_Rec IN CHK_RATING_Rec_Type Required
78 --
79 -- OUT:
80 -- x_return_status OUT VARCHAR2
81 -- x_msg_count OUT NUMBER
82 -- x_msg_data OUT VARCHAR2
83 -- Version : Current version 1.0
84 --
85 -- End of Comments
86 --
87 PROCEDURE Create_check_ratings(
88 P_Api_Version_Number IN NUMBER,
89 P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
90 P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
91 p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
92 px_CHECK_RATING_ID IN OUT NOCOPY NUMBER ,
93 p_CHECK_ID IN NUMBER ,
94 p_CHECK_RATING_GRADE IN VARCHAR2,
95 p_RATING_COLOR_ID IN NUMBER DEFAULT NULL,
96 p_RATING_CODE IN VARCHAR2 ,
97 p_COLOR_CODE IN VARCHAR2 ,
98 p_RANGE_LOW_VALUE IN VARCHAR2 ,
99 p_RANGE_HIGH_VALUE IN VARCHAR2 ,
100 p_LAST_UPDATE_DATE IN DATE ,
101 p_LAST_UPDATED_BY IN NUMBER,
102 p_CREATION_DATE IN DATE ,
103 p_CREATED_BY IN NUMBER,
104 p_LAST_UPDATE_LOGIN IN NUMBER,
105 p_SEEDED_FLAG IN VARCHAR2,
106 -- X_RATE_ID OUT NOCOPY NUMBER,
107 X_Return_Status OUT NOCOPY VARCHAR2,
108 X_Msg_Count OUT NOCOPY NUMBER,
109 X_Msg_Data OUT NOCOPY VARCHAR2
110 );
111
112 PROCEDURE Create_check_ratings(
113 P_Api_Version_Number IN NUMBER,
114 P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
115 P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
116 p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
117 px_Check_Rating_ID IN OUT NOCOPY NUMBER,
118 P_CHK_RATING_Rec IN CHK_RATING_Rec_Type := G_MISS_CHK_RATING_Rec,
119 X_Return_Status OUT NOCOPY VARCHAR2,
120 X_Msg_Count OUT NOCOPY NUMBER,
121 X_Msg_Data OUT NOCOPY VARCHAR2
122 );
123
124 -- *******************************************************
125 -- Start of Comments
126 -- *******************************************************
127 -- API Name: Update_check_ratings
128 -- Type : Private
129 -- Pre-Req :
130 -- Parameters:
131 -- IN
132 -- p_api_version_number IN NUMBER Required
133 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
134 -- p_commit IN VARCHAR2 Optional Default = CSC_CORE_UTILS_PVT.G_FALSE
135 -- p_validation_level IN NUMBER Optional Default = CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL
136 -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
137 -- P_CHK_RATING_Rec IN CHK_RATING_Rec_Type Required
138 --
139 -- OUT:
140 -- x_return_status OUT VARCHAR2
141 -- x_msg_count OUT NUMBER
142 -- x_msg_data OUT VARCHAR2
143 -- Version : Current version 1.0
144 --
145 -- End of Comments
146 --
147 PROCEDURE Update_check_ratings(
148 P_Api_Version_Number IN NUMBER,
149 P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
150 P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
151 p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
152 p_CHECK_RATING_ID IN NUMBER,
153 p_CHECK_ID IN NUMBER,
154 p_CHECK_RATING_GRADE IN VARCHAR2,
155 p_RATING_COLOR_ID IN NUMBER DEFAULT NULL,
156 p_RATING_CODE IN VARCHAR2,
157 p_COLOR_CODE IN VARCHAR2,
158 p_RANGE_LOW_VALUE IN VARCHAR2,
159 p_RANGE_HIGH_VALUE IN VARCHAR2,
160 p_LAST_UPDATE_DATE IN DATE,
161 p_LAST_UPDATED_BY IN NUMBER,
162 p_CREATION_DATE IN DATE,
163 p_CREATED_BY IN NUMBER,
164 p_LAST_UPDATE_LOGIN IN NUMBER,
165 p_SEEDED_FLAG IN VARCHAR2 ,
166 X_Return_Status OUT NOCOPY VARCHAR2,
167 X_Msg_Count OUT NOCOPY NUMBER,
168 X_Msg_Data OUT NOCOPY VARCHAR2
169 );
170
171 PROCEDURE Update_check_ratings(
172 P_Api_Version_Number IN NUMBER,
173 P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
174 P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
175 p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
176 P_CHK_RATING_Rec IN CHK_RATING_Rec_Type := G_MISS_CHK_RATING_Rec,
177 X_Return_Status OUT NOCOPY VARCHAR2,
178 X_Msg_Count OUT NOCOPY NUMBER,
179 X_Msg_Data OUT NOCOPY VARCHAR2
180 );
181
182 -- *******************************************************
183 -- Start of Comments
184 -- *******************************************************
185 -- API Name: Delete_check_ratings
186 -- Type : Private
187 -- Pre-Req :
188 -- Parameters:
189 -- IN
190 -- p_api_version_number IN NUMBER Required
191 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
192 -- p_commit IN VARCHAR2 Optional Default = CSC_CORE_UTILS_PVT.G_FALSE
193 -- p_validation_level IN NUMBER Optional Default = CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL
194 -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
195 -- P_CHK_RATING_Rec IN CHK_RATING_Rec_Type Required
196 --
197 -- OUT:
198 -- x_return_status OUT VARCHAR2
199 -- x_msg_count OUT NUMBER
200 -- x_msg_data OUT VARCHAR2
201 -- Version : Current version 1.0
202 --
203 -- End of Comments
204 --
205 PROCEDURE Delete_check_ratings(
206 P_Api_Version_Number IN NUMBER,
207 P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
208 P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
209 p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
210 P_CHECK_RATING_ID IN NUMBER,
211 X_Return_Status OUT NOCOPY VARCHAR2,
212 X_Msg_Count OUT NOCOPY NUMBER,
213 X_Msg_Data OUT NOCOPY VARCHAR2
214 );
215
216 -- Start of Comments
217 --
218 -- Item level validation procedures
219 --
220
221 PROCEDURE Validate_check_ratings(
222 P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
223 P_Validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
224 P_Validation_mode IN VARCHAR2,
225 p_CHK_RATING_REC IN CHK_RATING_Rec_Type,
226 X_Return_Status OUT NOCOPY VARCHAR2,
227 X_Msg_Count OUT NOCOPY NUMBER,
228 X_Msg_Data OUT NOCOPY VARCHAR2
229 );
230 End CSC_CHECK_RATINGS_PVT;