1 PACKAGE AS_OPP_SALES_CREDIT_PVT as
2 /* $Header: asxvlscs.pls 120.1 2006/03/25 04:26:43 savadhan noship $ */
3 -- Start of Comments
4 -- Package name : AS_OPP_SALES_CREDIT_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 FUNCTION Apply_Forecast_Defaults(
14 p_old_win_probability IN NUMBER,
15 p_old_win_loss_indicator IN VARCHAR2,
16 p_old_forecast_rollup_flag IN VARCHAR2,
17 p_old_sales_credit_amount IN NUMBER,
18 p_win_probability IN NUMBER,
19 p_win_loss_indicator IN VARCHAR2,
20 p_forecast_rollup_flag IN VARCHAR2,
21 p_sales_credit_amount IN NUMBER,
22 p_Trigger_Mode IN VARCHAR2,
23 x_opp_worst_forecast_amount IN OUT NOCOPY NUMBER,
24 x_opp_forecast_amount IN OUT NOCOPY NUMBER,
25 x_opp_best_forecast_amount IN OUT NOCOPY NUMBER
26 )
27 RETURN BOOLEAN;
28
29 -- *******************************************************
30 -- Start of Comments
31 -- *******************************************************
32
33 -- API Name: Create_sales_credits
34 -- Type : Private
35 -- Pre-Req :
36 -- Parameters:
37 -- IN
38 -- p_api_version_number IN NUMBER Required
39 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
40 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
41 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
42 -- P_SALES_CREDIT_Rec IN SALES_CREDIT_Rec_Type Required
43 --
44 -- OUT:
45 -- x_return_status OUT VARCHAR2
46 -- x_msg_count OUT NUMBER
47 -- x_msg_data OUT VARCHAR2
48 -- Version : Current version 2.0
49 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
50 -- and basic operation, developer must manually add parameters and business logic as necessary.
51 --
52 -- End of Comments
53 --
54 PROCEDURE Create_sales_credits(
55 P_Api_Version_Number IN NUMBER,
56 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
57 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
58 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
59 P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,
60 P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,
61 P_Admin_Group_Id IN NUMBER,
62 P_Identity_Salesforce_Id IN NUMBER := NULL,
63 P_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE,
64 p_partner_cont_party_id IN NUMBER := FND_API.G_MISS_NUM,
65 P_SALES_CREDIT_Tbl IN AS_OPPORTUNITY_PUB.SALES_CREDIT_tbl_Type
66 := AS_OPPORTUNITY_PUB.G_MISS_SALES_CREDIT_tbl,
67 --Hint: Add detail tables as parameter lists if it's master-detail relationship.
68 X_SALES_CREDIT_out_tbl OUT NOCOPY AS_OPPORTUNITY_PUB.sales_credit_out_tbl_type,
69 X_Return_Status OUT NOCOPY VARCHAR2,
70 X_Msg_Count OUT NOCOPY NUMBER,
71 X_Msg_Data OUT NOCOPY VARCHAR2
72 );
73
74 -- *******************************************************
75 -- Start of Comments
76 -- *******************************************************
77 -- API Name: Update_sales_credits
78 -- Type : Private
79 -- Pre-Req :
80 -- Parameters:
81 -- IN
82 -- p_api_version_number IN NUMBER Required
83 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
84 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
85 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
86 -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
87 -- P_SALES_CREDIT_Rec IN SALES_CREDIT_Rec_Type Required
88 --
89 -- OUT:
90 -- x_return_status OUT VARCHAR2
91 -- x_msg_count OUT NUMBER
92 -- x_msg_data OUT VARCHAR2
93 -- Version : Current version 2.0
94 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
95 -- and basic operation, developer must manually add parameters and business logic as necessary.
96 --
97 -- End of Comments
98 --
99 -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
100 PROCEDURE Update_sales_credits(
101 P_Api_Version_Number IN NUMBER,
102 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
103 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
104 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
105 P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,
106 P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,
107 P_Admin_Group_Id IN NUMBER,
108 P_Identity_Salesforce_Id IN NUMBER := NULL,
109 P_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE,
110 p_partner_cont_party_id IN NUMBER := FND_API.G_MISS_NUM,
111 P_SALES_CREDIT_tbl IN AS_OPPORTUNITY_PUB.SALES_CREDIT_tbl_Type,
112 X_SALES_CREDIT_out_tbl OUT NOCOPY AS_OPPORTUNITY_PUB.sales_credit_out_tbl_type,
113 X_Return_Status OUT NOCOPY VARCHAR2,
114 X_Msg_Count OUT NOCOPY NUMBER,
115 X_Msg_Data OUT NOCOPY VARCHAR2
116 );
117
118 PROCEDURE Modify_sales_credits(
119 P_Api_Version_Number IN NUMBER,
120 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
121 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
122 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
123 P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,
124 P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,
125 P_Admin_Group_Id IN NUMBER,
126 P_Identity_Salesforce_Id IN NUMBER := NULL,
127 P_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE,
128 p_partner_cont_party_id IN NUMBER := FND_API.G_MISS_NUM,
129 P_SALES_CREDIT_tbl IN AS_OPPORTUNITY_PUB.SALES_CREDIT_tbl_Type,
130 X_SALES_CREDIT_out_tbl OUT NOCOPY AS_OPPORTUNITY_PUB.sales_credit_out_tbl_type,
131 X_Return_Status OUT NOCOPY VARCHAR2,
132 X_Msg_Count OUT NOCOPY NUMBER,
133 X_Msg_Data OUT NOCOPY VARCHAR2
134 );
135
136 -- *******************************************************
137 -- Start of Comments
138 -- *******************************************************
139 -- API Name: Delete_sales_credits
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 = FND_API.G_FALSE
147 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
148 -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
149 -- P_SALES_CREDIT_Rec IN SALES_CREDIT_Rec_Type Required
150 --
151 -- OUT:
152 -- x_return_status OUT VARCHAR2
153 -- x_msg_count OUT NUMBER
154 -- x_msg_data OUT VARCHAR2
155 -- Version : Current version 2.0
156 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
157 -- and basic operation, developer must manually add parameters and business logic as necessary.
158 --
159 -- End of Comments
160 --
161 -- Hint: Add corresponding delete detail table procedures if it's master-detail relationship.
162 -- The Master delete procedure may not be needed depends on different business requirements.
163 PROCEDURE Delete_sales_credits(
164 P_Api_Version_Number IN NUMBER,
165 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
166 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
167 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
168 P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,
169 P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,
170 P_Admin_Group_Id IN NUMBER,
171 P_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE,
172 P_identity_salesforce_id IN NUMBER := NULL,
173 p_partner_cont_party_id IN NUMBER := FND_API.G_MISS_NUM,
174 P_SALES_CREDIT_tbl IN AS_OPPORTUNITY_PUB.SALES_CREDIT_tbl_Type,
175 X_SALES_CREDIT_out_tbl OUT NOCOPY AS_OPPORTUNITY_PUB.sales_credit_out_tbl_type,
176 X_Return_Status OUT NOCOPY VARCHAR2,
177 X_Msg_Count OUT NOCOPY NUMBER,
178 X_Msg_Data OUT NOCOPY VARCHAR2
179 );
180
181
182 -- Start of Comments
183 --
184 -- Item level validation procedures
185 --
186 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
187 -- For create: G_CREATE, for update: G_UPDATE
188 -- Note: 1. This is automated generated item level validation procedure.
189 -- The actual validation detail is needed to be added.
190 --
191 -- End of Comments
192
193 PROCEDURE Validate_SALES_CREDIT_ID (
194 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
195 P_Validation_mode IN VARCHAR2,
196 P_SALES_CREDIT_ID IN NUMBER,
197 -- 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.
198 X_Return_Status OUT NOCOPY VARCHAR2,
199 X_Msg_Count OUT NOCOPY NUMBER,
200 X_Msg_Data OUT NOCOPY VARCHAR2
201 );
202
203 -- Start of Comments
204 --
205 -- Item level validation procedures
206 --
207 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
208 -- For create: G_CREATE, for update: G_UPDATE
209 -- Note: 1. This is automated generated item level validation procedure.
210 -- The actual validation detail is needed to be added.
211 --
212 -- End of Comments
213
214 PROCEDURE Validate_LEAD_ID (
215 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
216 P_Validation_mode IN VARCHAR2,
217 P_LEAD_ID IN NUMBER,
218 -- 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.
219 X_Return_Status OUT NOCOPY VARCHAR2,
220 X_Msg_Count OUT NOCOPY NUMBER,
221 X_Msg_Data OUT NOCOPY VARCHAR2
222 );
223
224 -- Start of Comments
225 --
226 -- Item level validation procedures
227 --
228 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
229 -- For create: G_CREATE, for update: G_UPDATE
230 -- Note: 1. This is automated generated item level validation procedure.
231 -- The actual validation detail is needed to be added.
232 --
233 -- End of Comments
234
235 PROCEDURE Validate_LEAD_LINE_ID (
236 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
237 P_Validation_mode IN VARCHAR2,
238 P_LEAD_LINE_ID IN NUMBER,
239 -- 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.
240 X_Return_Status OUT NOCOPY VARCHAR2,
241 X_Msg_Count OUT NOCOPY NUMBER,
242 X_Msg_Data OUT NOCOPY VARCHAR2
243 );
244
245 -- Start of Comments
246 --
247 -- Item level validation procedures
248 --
249 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
250 -- For create: G_CREATE, for update: G_UPDATE
251 -- Note: 1. This is automated generated item level validation procedure.
252 -- The actual validation detail is needed to be added.
253 --
254 -- End of Comments
255
256 PROCEDURE Validate_SALESFORCE_ID (
257 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
258 P_Validation_mode IN VARCHAR2,
259 P_SALESFORCE_ID IN NUMBER,
260 -- 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.
261 X_Return_Status OUT NOCOPY VARCHAR2,
262 X_Msg_Count OUT NOCOPY NUMBER,
263 X_Msg_Data OUT NOCOPY VARCHAR2
264 );
265
266 -- Start of Comments
267 --
268 -- Item level validation procedures
269 --
270 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
271 -- For create: G_CREATE, for update: G_UPDATE
272 -- Note: 1. This is automated generated item level validation procedure.
273 -- The actual validation detail is needed to be added.
274 --
275 -- End of Comments
276
277 PROCEDURE Validate_PERSON_ID (
278 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
279 P_Validation_mode IN VARCHAR2,
280 P_PERSON_ID IN NUMBER,
281 -- 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.
282 X_Return_Status OUT NOCOPY VARCHAR2,
283 X_Msg_Count OUT NOCOPY NUMBER,
284 X_Msg_Data OUT NOCOPY VARCHAR2
285 );
286
287 -- Start of Comments
288 --
289 -- Item level validation procedures
290 --
291 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
292 -- For create: G_CREATE, for update: G_UPDATE
293 -- Note: 1. This is automated generated item level validation procedure.
294 -- The actual validation detail is needed to be added.
295 --
296 -- End of Comments
297
298 PROCEDURE Validate_SALESGROUP_ID (
299 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
300 P_Validation_mode IN VARCHAR2,
301 P_SALESGROUP_ID IN NUMBER,
302 -- 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.
303 P_PERSON_ID IN NUMBER,
304 X_Return_Status OUT NOCOPY VARCHAR2,
305 X_Msg_Count OUT NOCOPY NUMBER,
306 X_Msg_Data OUT NOCOPY VARCHAR2
307 );
308
309 -- Start of Comments
310 --
311 -- Item level validation procedures
312 --
313 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
314 -- For create: G_CREATE, for update: G_UPDATE
315 -- Note: 1. This is automated generated item level validation procedure.
316 -- The actual validation detail is needed to be added.
317 --
318 -- End of Comments
319
320 PROCEDURE Validate_PARTNER_CUSTOMER_ID (
321 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
322 P_Validation_mode IN VARCHAR2,
323 P_PARTNER_CUSTOMER_ID IN NUMBER,
324 -- 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.
325 X_Return_Status OUT NOCOPY VARCHAR2,
326 X_Msg_Count OUT NOCOPY NUMBER,
327 X_Msg_Data OUT NOCOPY VARCHAR2
328 );
329
330 -- Start of Comments
331 --
332 -- Item level validation procedures
333 --
334 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
335 -- For create: G_CREATE, for update: G_UPDATE
336 -- Note: 1. This is automated generated item level validation procedure.
337 -- The actual validation detail is needed to be added.
338 --
339 -- End of Comments
340
341 PROCEDURE Validate_PARTNER_ADDRESS_ID (
342 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
346 X_Return_Status OUT NOCOPY VARCHAR2,
343 P_Validation_mode IN VARCHAR2,
344 P_PARTNER_ADDRESS_ID IN NUMBER,
345 -- 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.
347 X_Msg_Count OUT NOCOPY NUMBER,
348 X_Msg_Data OUT NOCOPY VARCHAR2
349 );
350
351
352 -- Start of Comments
353 --
354 -- Item level validation procedures
355 --
356 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
357 -- For create: G_CREATE, for update: G_UPDATE
358 -- Note: 1. This is automated generated item level validation procedure.
359 -- The actual validation detail is needed to be added.
360 --
361 -- End of Comments
362
363 PROCEDURE Validate_CREDIT_TYPE_ID (
364 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
365 P_Validation_mode IN VARCHAR2,
366 P_CREDIT_TYPE_ID IN NUMBER,
367 -- 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.
368 X_Return_Status OUT NOCOPY VARCHAR2,
369 X_Msg_Count OUT NOCOPY NUMBER,
370 X_Msg_Data OUT NOCOPY VARCHAR2
371 );
372
373 -- Start of Comments
374 --
375 -- Record level validation procedures
376 --
377 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
378 -- For create: G_CREATE, for update: G_UPDATE
379 -- Note: 1. This is automated generated item level validation procedure.
380 -- The actual validation detail is needed to be added.
381 -- 2. Developer can manually added inter-field level validation.
382 -- End of Comments
383
384 PROCEDURE Validate_SALES_CREDIT_rec(
385 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
386 P_Validation_mode IN VARCHAR2,
387 P_SALES_CREDIT_Rec IN AS_OPPORTUNITY_PUB.SALES_CREDIT_Rec_Type,
388 X_Return_Status OUT NOCOPY VARCHAR2,
389 X_Msg_Count OUT NOCOPY NUMBER,
390 X_Msg_Data OUT NOCOPY VARCHAR2
391 );
392
393 -- Start of Comments
394 --
395 -- validation procedures
396 --
397 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
398 -- For create: G_CREATE, for update: G_UPDATE
399 -- Note: 1. This is automated generated item level validation procedure.
400 -- The actual validation detail is needed to be added.
401 -- 2. We can also validate table instead of record. There will be an option for user to choose.
402 -- End of Comments
403
404 PROCEDURE Validate_sales_credit(
405 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
406 P_Validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
407 P_Validation_mode IN VARCHAR2,
408 P_SALES_CREDIT_Rec IN AS_OPPORTUNITY_PUB.SALES_CREDIT_Rec_Type,
409 X_Return_Status OUT NOCOPY VARCHAR2,
410 X_Msg_Count OUT NOCOPY NUMBER,
411 X_Msg_Data OUT NOCOPY VARCHAR2
412 );
413 -- the following procedure added for ASNB
414 PROCEDURE duplicate_sales_credit(
415 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
416 P_Validation_mode IN VARCHAR2,
417 P_SALES_CREDIT_Rec IN AS_OPPORTUNITY_PUB.SALES_CREDIT_Rec_Type,
418 X_Return_Status OUT NOCOPY VARCHAR2,
419 X_Msg_Count OUT NOCOPY NUMBER,
420 X_Msg_Data OUT NOCOPY VARCHAR2
421 );
422 End AS_OPP_SALES_CREDIT_PVT;