1 PACKAGE CSP_RS_CUST_RELATION_PVT AUTHID CURRENT_USER as
2 /* $Header: cspvrcrs.pls 115.6 2003/05/02 16:31:01 hhaugeru noship $ */
3 -- Start of Comments
4 -- Package name : CSP_RS_CUST_RELATION_PVT
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:RCR_Rec_Type
16 -- -------------------------------------------------------
17 -- Parameters:
18 -- RS_CUST_RELATION_ID
19 -- RESOURCE_TYPE
20 -- RESOURCE_ID
21 -- CUSTOMER_ID
22 -- CREATED_BY
23 -- CREATION_DATE
24 -- LAST_UPDATED_BY
25 -- LAST_UPDATE_DATE
26 -- LAST_UPDATE_LOGIN
27 -- ATTRIBUTE_CATEGORY
28 -- ATTRIBUTE1
29 -- ATTRIBUTE2
30 -- ATTRIBUTE3
31 -- ATTRIBUTE4
32 -- ATTRIBUTE5
33 -- ATTRIBUTE6
34 -- ATTRIBUTE7
35 -- ATTRIBUTE8
36 -- ATTRIBUTE9
37 -- ATTRIBUTE10
38 -- ATTRIBUTE11
39 -- ATTRIBUTE12
40 -- ATTRIBUTE13
41 -- ATTRIBUTE14
42 -- ATTRIBUTE15
43 --
44 -- Required:
45 -- Defaults:
46 -- Note: This is automatic generated record definition, it includes all columns
47 -- defined in the table, developer must manually add or delete some of the attributes.
48 --
49 -- End of Comments
50
51 TYPE RCR_Rec_Type IS RECORD
52 (
53 RS_CUST_RELATION_ID NUMBER := FND_API.G_MISS_NUM,
54 RESOURCE_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
55 RESOURCE_ID NUMBER := FND_API.G_MISS_NUM,
56 CUSTOMER_ID NUMBER := FND_API.G_MISS_NUM,
57 CREATED_BY NUMBER := FND_API.G_MISS_NUM,
58 CREATION_DATE DATE := FND_API.G_MISS_DATE,
59 LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
60 LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
61 LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
62 ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
63 ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
64 ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
65 ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
66 ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
67 ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
68 ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
69 ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
70 ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
71 ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
72 ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
73 ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
74 ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
75 ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
76 ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
77 ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR
78 );
79
80 G_MISS_RCR_REC RCR_Rec_Type;
81 TYPE RCR_Tbl_Type IS TABLE OF RCR_Rec_Type
82 INDEX BY BINARY_INTEGER;
83 G_MISS_RCR_TBL RCR_Tbl_Type;
84
85 -- *******************************************************
86 -- Start of Comments
87 -- *******************************************************
88 -- API Name: Create_rs_cust_relation
89 -- Type : Private
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_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
97 -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
98 -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
99 -- p_admin_group_id IN NUMBER Required
100 -- P_RCR_Rec IN RCR_Rec_Type Required
101 -- p_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE Required
102 --
103 -- OUT:
104 -- x_return_status OUT NOCOPY VARCHAR2
105 -- x_msg_count OUT NOCOPY NUMBER
106 -- x_msg_data OUT NOCOPY VARCHAR2
107 -- Version : Current version 2.0
108 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
109 -- and basic operation, developer must manually add parameters and business logic as necessary.
110 --
111 -- End of Comments
112 --
113 PROCEDURE Create_rs_cust_relation(
114 P_Api_Version_Number IN NUMBER,
115 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
116 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
117 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
118 P_RCR_Rec IN RCR_Rec_Type := G_MISS_RCR_REC,
119 --Hint: Add detail tables as parameter lists if it's master-detail relationship.
120 X_RS_CUST_RELATION_ID OUT NOCOPY NUMBER,
121 X_Return_Status OUT NOCOPY VARCHAR2,
122 X_Msg_Count OUT NOCOPY NUMBER,
123 X_Msg_Data OUT NOCOPY VARCHAR2
124 );
125
126 -- *******************************************************
127 -- Start of Comments
128 -- *******************************************************
129 -- API Name: Update_rs_cust_relation
130 -- Type : Private
131 -- Pre-Req :
132 -- Parameters:
133 -- IN
134 -- p_api_version_number IN NUMBER Required
135 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
136 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
137 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
138 -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
139 -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
140 -- p_admin_group_id IN NUMBER Required
141 -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
142 -- P_RCR_Rec IN RCR_Rec_Type Required
143 -- p_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE Required
144 --
145 -- OUT:
146 -- x_return_status OUT NOCOPY VARCHAR2
147 -- x_msg_count OUT NOCOPY NUMBER
148 -- x_msg_data OUT NOCOPY VARCHAR2
149 -- Version : Current version 2.0
150 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
151 -- and basic operation, developer must manually add parameters and business logic as necessary.
152 --
153 -- End of Comments
154 --
155 -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
156 PROCEDURE Update_rs_cust_relation(
157 P_Api_Version_Number IN NUMBER,
158 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
159 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
160 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
161 P_Identity_Salesforce_Id IN NUMBER := NULL,
162 P_RCR_Rec IN RCR_Rec_Type,
163 X_Return_Status OUT NOCOPY VARCHAR2,
164 X_Msg_Count OUT NOCOPY NUMBER,
165 X_Msg_Data OUT NOCOPY VARCHAR2
166 );
167
168 -- *******************************************************
169 -- Start of Comments
170 -- *******************************************************
171 -- API Name: Delete_rs_cust_relation
172 -- Type : Private
173 -- Pre-Req :
174 -- Parameters:
175 -- IN
176 -- p_api_version_number IN NUMBER Required
177 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
178 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
179 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
180 -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
181 -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
182 -- p_admin_group_id IN NUMBER Required
183 -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
184 -- P_RCR_Rec IN RCR_Rec_Type Required
185 -- p_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE Required
186 --
187 -- OUT:
188 -- x_return_status OUT NOCOPY VARCHAR2
189 -- x_msg_count OUT NOCOPY NUMBER
190 -- x_msg_data OUT NOCOPY VARCHAR2
191 -- Version : Current version 2.0
192 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
193 -- and basic operation, developer must manually add parameters and business logic as necessary.
194 --
195 -- End of Comments
196 --
197 -- Hint: Add corresponding delete detail table procedures if it's master-detail relationship.
198 -- The Master delete procedure may not be needed depends on different business requirements.
199 PROCEDURE Delete_rs_cust_relation(
200 P_Api_Version_Number IN NUMBER,
201 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
202 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
203 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
204 P_Identity_Salesforce_Id IN NUMBER := NULL,
205 P_RCR_Rec IN RCR_Rec_Type,
206 X_Return_Status OUT NOCOPY VARCHAR2,
207 X_Msg_Count OUT NOCOPY NUMBER,
208 X_Msg_Data OUT NOCOPY VARCHAR2
209 );
210
211 -- Start of Comments
212 --
213 -- Item level validation procedures
214 --
215 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
216 -- For create: G_CREATE, for update: G_UPDATE
217 -- Note: 1. This is automated generated item level validation procedure.
218 -- The actual validation detail is needed to be added.
219 --
220 -- End of Comments
221
222 PROCEDURE Validate_RS_CUST_RELATION_ID (
223 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
224 P_Validation_mode IN VARCHAR2,
225 P_RS_CUST_RELATION_ID IN NUMBER,
226 -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
227 X_Return_Status OUT NOCOPY VARCHAR2,
228 X_Msg_Count OUT NOCOPY NUMBER,
229 X_Msg_Data OUT NOCOPY VARCHAR2
230 );
231
232 -- Start of Comments
233 --
234 -- Item level validation procedures
235 --
236 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
237 -- For create: G_CREATE, for update: G_UPDATE
238 -- Note: 1. This is automated generated item level validation procedure.
239 -- The actual validation detail is needed to be added.
240 --
241 -- End of Comments
242
243 PROCEDURE Validate_RESOURCE_TYPE (
244 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
245 P_Validation_mode IN VARCHAR2,
246 P_RESOURCE_TYPE IN VARCHAR2,
247 -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
248 X_Return_Status OUT NOCOPY VARCHAR2,
249 X_Msg_Count OUT NOCOPY NUMBER,
250 X_Msg_Data OUT NOCOPY VARCHAR2
251 );
252
253 -- Start of Comments
254 --
255 -- Item level validation procedures
256 --
257 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
258 -- For create: G_CREATE, for update: G_UPDATE
259 -- Note: 1. This is automated generated item level validation procedure.
260 -- The actual validation detail is needed to be added.
261 --
262 -- End of Comments
263
264 PROCEDURE Validate_RESOURCE_ID (
265 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
266 P_Validation_mode IN VARCHAR2,
267 P_RESOURCE_ID IN NUMBER,
268 -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
269 X_Return_Status OUT NOCOPY VARCHAR2,
270 X_Msg_Count OUT NOCOPY NUMBER,
271 X_Msg_Data OUT NOCOPY VARCHAR2
272 );
273
274
275 -- Start of Comments
276 --
277 -- Item level validation procedures
278 --
279 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
280 -- For create: G_CREATE, for update: G_UPDATE
281 -- Note: 1. This is automated generated item level validation procedure.
282 -- The actual validation detail is needed to be added.
283 --
284 -- End of Comments
285
286 PROCEDURE Validate_CUSTOMER_ID (
287 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
288 P_Validation_mode IN VARCHAR2,
289 P_CUSTOMER_ID IN NUMBER,
290 -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
291 X_Return_Status OUT NOCOPY VARCHAR2,
292 X_Msg_Count OUT NOCOPY NUMBER,
293 X_Msg_Data OUT NOCOPY VARCHAR2
294 );
295
296 -- Start of Comments
297 --
298 -- Record level validation procedures
299 --
300 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
301 -- For create: G_CREATE, for update: G_UPDATE
302 -- Note: 1. This is automated generated item level validation procedure.
303 -- The actual validation detail is needed to be added.
304 -- 2. Developer can manually added inter-field level validation.
305 -- End of Comments
306
307 PROCEDURE Validate_RCR_rec(
308 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
309 P_Validation_mode IN VARCHAR2,
310 P_RCR_Rec IN RCR_Rec_Type,
311 X_Return_Status OUT NOCOPY VARCHAR2,
312 X_Msg_Count OUT NOCOPY NUMBER,
313 X_Msg_Data OUT NOCOPY VARCHAR2
314 );
315
316 -- Start of Comments
317 --
318 -- validation procedures
319 --
320 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
321 -- For create: G_CREATE, for update: G_UPDATE
322 -- Note: 1. This is automated generated item level validation procedure.
323 -- The actual validation detail is needed to be added.
324 -- 2. We can also validate table instead of record. There will be an option for user to choose.
325 -- End of Comments
326
327 PROCEDURE Validate_rs_cust_relation(
328 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
329 P_Validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
330 P_Validation_mode IN VARCHAR2,
331 P_RCR_Rec IN RCR_Rec_Type,
332 X_Return_Status OUT NOCOPY VARCHAR2,
333 X_Msg_Count OUT NOCOPY NUMBER,
334 X_Msg_Data OUT NOCOPY VARCHAR2
335 );
336 End CSP_RS_CUST_RELATION_PVT;