1 PACKAGE CSC_PROF_COLOR_CODE_PVT AUTHID CURRENT_USER as
2 /* $Header: cscvpccs.pls 115.5 2002/12/03 19:31:38 jamose ship $ */
3 -- Start of Comments
4 -- Package name : CSC_PROF_COLOR_CODE_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 -- *******************************************************
14 -- Start of Comments
15 -- -------------------------------------------------------
16 -- Record name:prof_color_Rec_Type
17 -- -------------------------------------------------------
18 -- Parameters:
19 -- COLOR_CODE
20 -- RATING_CODE
21 -- LAST_UPDATE_DATE
22 -- LAST_UPDATED_BY
23 -- CREATION_DATE
24 -- CREATED_BY
25 -- LAST_UPDATE_LOGIN
26 --
27 --
28 -- End of Comments
29
30 TYPE prof_color_Rec_Type IS RECORD
31 (
32 COLOR_CODE VARCHAR2(30),
33 RATING_CODE VARCHAR2(30),
34 LAST_UPDATE_DATE DATE,
35 LAST_UPDATED_BY NUMBER,
36 CREATION_DATE DATE,
37 CREATED_BY NUMBER,
38 LAST_UPDATE_LOGIN NUMBER
39 );
40
41 G_MISS_prof_color_rec_type_REC prof_color_Rec_Type;
42 TYPE prof_color_rec_type_Tbl_Type IS TABLE OF prof_color_Rec_Type
43 INDEX BY BINARY_INTEGER;
44 G_MISS_prof_color_rec_type_TBL prof_color_rec_type_Tbl_Type;
45
46 -- *******************************************************
47 -- Start of Comments
48 -- *******************************************************
49 -- API Name: Create_prof_color_code
50 -- Type : Private
51 -- Pre-Req :
52 -- Parameters:
53 -- IN
54 -- p_api_version_number IN NUMBER Required
55 -- p_init_msg_list IN VARCHAR2 Optional Default = CSC_CORE_UTILS_PVT_G_FALSE
56 -- p_commit IN VARCHAR2 Optional Default = CSC_CORE_UTILS_PVT.G_FALSE
57 -- p_validation_level IN NUMBER Optional Default = CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL
58 -- P_prof_color_rec_type_Rec IN prof_color_Rec_Type Required
59 --
60 -- OUT:
61 -- x_return_status OUT VARCHAR2
62 -- x_msg_count OUT NUMBER
63 -- x_msg_data OUT VARCHAR2
64 -- Version : Current version 2.0
65 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
66 -- and basic operation, developer must manually add parameters and business logic as necessary.
67 --
68 -- End of Comments
69 --
70 PROCEDURE Create_prof_color_code(
71 P_Api_Version_Number IN NUMBER,
72 P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
73 P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
74 p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
75 px_COLOR_CODE IN OUT NOCOPY VARCHAR2 ,
76 p_RATING_CODE IN VARCHAR2,
77 p_LAST_UPDATE_DATE IN DATE ,
78 p_LAST_UPDATED_BY IN NUMBER,
79 p_CREATION_DATE IN DATE,
80 p_CREATED_BY IN NUMBER,
81 p_LAST_UPDATE_LOGIN IN NUMBER,
82 X_Return_Status OUT NOCOPY VARCHAR2,
83 X_Msg_Count OUT NOCOPY NUMBER,
84 X_Msg_Data OUT NOCOPY VARCHAR2
85 );
86
87 PROCEDURE Create_prof_color_code(
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 P_prof_color_rec IN prof_color_Rec_Type := G_MISS_prof_color_rec_type_REC,
93 px_COLOR_CODE IN OUT NOCOPY VARCHAR2,
94 X_Return_Status OUT NOCOPY VARCHAR2,
95 X_Msg_Count OUT NOCOPY NUMBER,
96 X_Msg_Data OUT NOCOPY VARCHAR2
97 );
98
99 -- *******************************************************
100 -- Start of Comments
101 -- *******************************************************
102 -- API Name: Update_prof_color_code
103 -- Type : Private
104 -- Pre-Req :
105 -- Parameters:
106 -- IN
107 -- p_api_version_number IN NUMBER Required
108 -- p_init_msg_list IN VARCHAR2 Optional Default = CSC_CORE_UTILS_PVT_G_FALSE
109 -- p_commit IN VARCHAR2 Optional Default = CSC_CORE_UTILS_PVT.G_FALSE
110 -- p_validation_level IN NUMBER Optional Default = CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL
111 -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
112 -- P_prof_color_rec_type_Rec IN prof_color_Rec_Type Required
113 --
114 -- OUT:
115 -- x_return_status OUT VARCHAR2
116 -- x_msg_count OUT NUMBER
117 -- x_msg_data OUT VARCHAR2
118 -- Version : Current version 2.0
119 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
120 -- and basic operation, developer must manually add parameters and business logic as necessary.
121 --
122 -- End of Comments
123 --
124
125 PROCEDURE Update_prof_color_code(
126 P_Api_Version_Number IN NUMBER,
127 P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
128 P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
129 p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
130 p_COLOR_CODE IN VARCHAR2,
131 p_RATING_CODE IN VARCHAR2,
132 p_LAST_UPDATE_DATE IN DATE ,
133 p_LAST_UPDATED_BY IN NUMBER,
134 p_CREATION_DATE IN DATE DEFAULT NULL,
135 p_CREATED_BY IN NUMBER DEFAULT NULL,
136 p_LAST_UPDATE_LOGIN IN NUMBER ,
137 X_Return_Status OUT NOCOPY VARCHAR2,
138 X_Msg_Count OUT NOCOPY NUMBER,
139 X_Msg_Data OUT NOCOPY VARCHAR2
140 );
141
142 PROCEDURE Update_prof_color_code(
143 P_Api_Version_Number IN NUMBER,
144 P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
145 P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
146 p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
147 P_prof_color_rec IN prof_color_Rec_Type,
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: Delete_prof_color_code
157 -- Type : Private
158 -- Pre-Req :
159 -- Parameters:
160 -- IN
161 -- p_api_version_number IN NUMBER Required
162 -- p_init_msg_list IN VARCHAR2 Optional Default = CSC_CORE_UTILS_PVT_G_FALSE
163 -- p_commit IN VARCHAR2 Optional Default = CSC_CORE_UTILS_PVT.G_FALSE
164 -- p_validation_level IN NUMBER Optional Default = CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL
165 -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
166 -- P_prof_color_rec_type_Rec IN prof_color_Rec_Type Required
167 --
168 -- OUT:
169 -- x_return_status OUT VARCHAR2
170 -- x_msg_count OUT NUMBER
171 -- x_msg_data OUT VARCHAR2
172 -- Version : Current version 2.0
173 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
174 -- and basic operation, developer must manually add parameters and business logic as necessary.
175 --
176 -- End of Comments
177 --
178 -- Hint: Add corresponding delete detail table procedures if it's master-detail relationship.
179 -- The Master delete procedure may not be needed depends on different business requirements.
180 PROCEDURE Delete_prof_color_code(
181 P_Api_Version_Number IN NUMBER,
182 P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
183 P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
184 p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
185 P_COLOR_CODE IN VARCHAR2,
186 X_Return_Status OUT NOCOPY VARCHAR2,
187 X_Msg_Count OUT NOCOPY NUMBER,
188 X_Msg_Data OUT NOCOPY VARCHAR2
189 );
190
191
192 -- Start of Comments
193 --
194 -- Item level validation procedures
195 --
196 -- p_validation_mode is a constant defined in CSC_CORE_UTILS_PVT package
197 -- For create: G_CREATE, for update: G_UPDATE
198 -- Note: 1. This is automated generated item level validation procedure.
199 -- The actual validation detail is needed to be added.
200 --
201 -- End of Comments
202
203 PROCEDURE Validate_COLOR_CODE (
204 P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
205 P_Validation_mode IN VARCHAR2,
206 P_COLOR_CODE IN VARCHAR2,
207 X_Return_Status OUT NOCOPY VARCHAR2,
208 X_Msg_Count OUT NOCOPY NUMBER,
209 X_Msg_Data OUT NOCOPY VARCHAR2
210 );
211
212 -- Start of Comments
213 --
214 -- Item level validation procedures
215 --
216 -- p_validation_mode is a constant defined in CSC_CORE_UTILS_PVT package
217 -- For create: G_CREATE, for update: G_UPDATE
218 -- Note: 1. This is automated generated item level validation procedure.
219 -- The actual validation detail is needed to be added.
220 --
221 -- End of Comments
222
223 PROCEDURE Validate_RATING_CODE (
224 P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
225 P_Validation_mode IN VARCHAR2,
226 P_RATING_CODE IN VARCHAR2,
227 X_Return_Status OUT NOCOPY VARCHAR2,
228 X_Msg_Count OUT NOCOPY NUMBER,
229 X_Msg_Data OUT NOCOPY VARCHAR2
230 );
231
232
233 -- Start of Comments
234 --
235 -- validation procedures
236 --
237 -- p_validation_mode is a constant defined in CSC_CORE_UTILS_PVT package
238 -- For create: G_CREATE, for update: G_UPDATE
239 -- Note: 1. This is automated generated item level validation procedure.
240 -- The actual validation detail is needed to be added.
241 -- 2. We can also validate table instead of record. There will be an option for user to choose.
242 -- End of Comments
243
244 PROCEDURE Validate_prof_color_code(
245 P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
246 P_Validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
247 P_Validation_mode IN VARCHAR2,
248 P_prof_color_rec_type_Rec IN prof_color_Rec_Type,
249 X_Return_Status OUT NOCOPY VARCHAR2,
250 X_Msg_Count OUT NOCOPY NUMBER,
251 X_Msg_Data OUT NOCOPY VARCHAR2
252 );
253 End CSC_PROF_COLOR_CODE_PVT;