1 PACKAGE AS_DECISION_FACTOR_PVT AUTHID CURRENT_USER as
2 /* $Header: asxvdfcs.pls 115.8 2002/12/13 12:28:38 nkamble ship $ */
3 -- Start of Comments
4 -- Package name : AS_DECISION_FACTOR_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
14 -- *******************************************************
15 -- Start of Comments
16 -- *******************************************************
17 -- API Name: Create_decision_factors
18 -- Type : Private
19 -- Pre-Req :
20 -- Parameters:
21 -- IN
22 -- p_api_version_number IN NUMBER Required
23 -- p_init_msg_list IN VARCHAR2 Optional
24 -- Default = FND_API_G_FALSE
25 -- p_commit IN VARCHAR2 Optional
26 -- Default = FND_API.G_FALSE
27 -- p_validation_level IN NUMBER Optional
28 -- Default = FND_API.G_VALID_LEVEL_FULL
29 -- P_decision_factor_Tbl IN As_Opportunity_Pub.Decision_Factor_Tbl_Type
30 -- Required
31 --
32 -- OUT:
33 -- x_decision_factor_out_tbl OUT as_opportunity_pub.decision_factor_out_tbl_type
34 -- x_return_status OUT VARCHAR2
35 -- x_msg_count OUT NUMBER
36 -- x_msg_data OUT VARCHAR2
37 -- Version : Current version 2.0
38 --
39 -- End of Comments
40 --
41 PROCEDURE Create_decision_factors(
42 P_Api_Version_Number IN NUMBER,
43 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
44 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
45 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
46 P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,
47 P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,
48 P_Admin_Group_Id IN NUMBER,
49 P_Identity_Salesforce_Id IN NUMBER := NULL,
50
51 P_Partner_Cont_Party_id IN NUMBER := FND_API.G_MISS_NUM,
52 P_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE,
53 P_decision_factor_Tbl IN As_Opportunity_Pub.Decision_Factor_Tbl_Type :=
54 AS_OPPORTUNITY_PUB.G_MISS_decision_factor_Tbl,
55 X_decision_factor_out_tbl OUT NOCOPY as_opportunity_pub.decision_factor_out_tbl_type,
56 X_Return_Status OUT NOCOPY VARCHAR2,
57 X_Msg_Count OUT NOCOPY NUMBER,
58 X_Msg_Data OUT NOCOPY VARCHAR2
59 );
60
61 -- *******************************************************
62 -- Start of Comments
63 -- *******************************************************
64 -- API Name: Update_decision_factors
65 -- Type : Private
66 -- Pre-Req :
67 -- Parameters:
68 -- IN
69 -- p_api_version_number IN NUMBER Required
70 -- p_init_msg_list IN VARCHAR2 Optional
71 -- Default = FND_API_G_FALSE
72 -- p_commit IN VARCHAR2 Optional
73 -- Default = FND_API.G_FALSE
74 -- p_validation_level IN NUMBER Optional
75 -- Default = FND_API.G_VALID_LEVEL_FULL
76 -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
77 -- P_decision_factor_Tbl IN As_Opportunity_Pub.Decision_Factor_Tbl_Type
78 -- Required
79 --
80 -- OUT:
81 -- x_decision_factor_out_tbl OUT as_opportunity_pub.decision_factor_out_tbl_type
82 -- x_return_status OUT VARCHAR2
83 -- x_msg_count OUT NUMBER
84 -- x_msg_data OUT VARCHAR2
85 -- Version : Current version 2.0
86 --
87 -- End of Comments
88 --
89 PROCEDURE Update_decision_factors(
90 P_Api_Version_Number IN NUMBER,
91 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
92 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
93 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
94 P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,
95 P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,
96 P_Admin_Group_Id IN NUMBER,
97 P_Identity_Salesforce_Id IN NUMBER,
98 P_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE,
99 P_Partner_Cont_Party_id IN NUMBER := FND_API.G_MISS_NUM,
100 P_decision_factor_Tbl IN As_Opportunity_Pub.Decision_Factor_Tbl_Type,
101 X_decision_factor_out_tbl OUT NOCOPY as_opportunity_pub.decision_factor_out_tbl_type,
102 X_Return_Status OUT NOCOPY VARCHAR2,
103 X_Msg_Count OUT NOCOPY NUMBER,
104 X_Msg_Data OUT NOCOPY VARCHAR2
105 );
106
107 -- *******************************************************
108 -- Start of Comments
109 -- *******************************************************
110 -- API Name: Delete_decision_factor
111 -- Type : Private
112 -- Pre-Req :
113 -- Parameters:
114 -- IN
115 -- p_api_version_number IN NUMBER Required
116 -- p_init_msg_list IN VARCHAR2 Optional
117 -- Default = FND_API_G_FALSE
118 -- p_commit IN VARCHAR2 Optional
119 -- Default = FND_API.G_FALSE
120 -- p_validation_level IN NUMBER Optional
121 -- Default = FND_API.G_VALID_LEVEL_FULL
122 -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
123 -- P_decision_factor_Tbl IN As_Opportunity_Pub.Decision_Factor_Tbl_Type
124 -- Required
125 --
126 -- OUT:
127 -- x_decision_factor_out_tbl OUT as_opportunity_pub.decision_factor_out_tbl_type
128 -- x_return_status OUT VARCHAR2
129 -- x_msg_count OUT NUMBER
130 -- x_msg_data OUT VARCHAR2
131 -- Version : Current version 2.0
132 --
133 -- End of Comments
134 --
135 PROCEDURE Delete_decision_factors(
136 P_Api_Version_Number IN NUMBER,
137 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
138 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
139 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
140 P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,
141 P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,
142 P_Admin_Group_Id IN NUMBER,
143 P_identity_salesforce_id IN NUMBER := NULL,
144 P_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE,
145 P_Partner_Cont_Party_id IN NUMBER := FND_API.G_MISS_NUM,
146 P_decision_factor_Tbl IN As_Opportunity_Pub.Decision_Factor_Tbl_Type,
147 X_decision_factor_out_tbl OUT NOCOPY as_opportunity_pub.decision_factor_out_tbl_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 -- Start of Comments
154 --
155 -- Item level validation procedures
156 --
157 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
158 -- For create: G_CREATE, for update: G_UPDATE
159 -- Note: 1. This is automated generated item level validation procedure.
160 -- The actual validation detail is needed to be added.
161 --
162 -- End of Comments
163
164
165 PROCEDURE Validate_REQUEST_ID (
166 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
167 P_Validation_mode IN VARCHAR2,
168 P_REQUEST_ID IN NUMBER,
169 X_Return_Status OUT NOCOPY VARCHAR2,
170 X_Msg_Count OUT NOCOPY NUMBER,
171 X_Msg_Data OUT NOCOPY VARCHAR2
172 );
173
174 -- Start of Comments
175 --
176 -- Item level validation procedures
177 --
178 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
179 -- For create: G_CREATE, for update: G_UPDATE
180 -- Note: 1. This is automated generated item level validation procedure.
181 -- The actual validation detail is needed to be added.
182 --
183 -- End of Comments
184
185 PROCEDURE Validate_DECISION_RANK (
186 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
187 P_Validation_mode IN VARCHAR2,
188 P_DECISION_RANK IN NUMBER,
189 X_Return_Status OUT NOCOPY VARCHAR2,
190 X_Msg_Count OUT NOCOPY NUMBER,
191 X_Msg_Data OUT NOCOPY VARCHAR2
192 );
193
194 -- Start of Comments
195 --
196 -- Item level validation procedures
197 --
198 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
199 -- For create: G_CREATE, for update: G_UPDATE
200 -- Note: 1. This is automated generated item level validation procedure.
201 -- The actual validation detail is needed to be added.
202 --
203 -- End of Comments
204
205 PROCEDURE Validate_DECISION_PRIOR_CODE (
206 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
207 P_Validation_mode IN VARCHAR2,
208 P_DECISION_PRIORITY_CODE IN VARCHAR2,
209 -- 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.
210 X_Return_Status OUT NOCOPY VARCHAR2,
211 X_Msg_Count OUT NOCOPY NUMBER,
212 X_Msg_Data OUT NOCOPY VARCHAR2
213 );
214
215 -- Start of Comments
216 --
217 -- Item level validation procedures
218 --
219 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
220 -- For create: G_CREATE, for update: G_UPDATE
221 -- Note: 1. This is automated generated item level validation procedure.
222 -- The actual validation detail is needed to be added.
223 --
224 -- End of Comments
225
226 PROCEDURE Validate_DECISION_FACTOR_CODE (
227 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
228 P_Validation_mode IN VARCHAR2,
229 P_DECISION_FACTOR_CODE IN VARCHAR2,
230 P_LEAD_LINE_ID IN NUMBER,
231 X_Return_Status OUT NOCOPY VARCHAR2,
232 X_Msg_Count OUT NOCOPY NUMBER,
233 X_Msg_Data OUT NOCOPY VARCHAR2
234 );
235
236
237 -- Start of Comments
238 --
239 -- Item level validation procedures
240 --
241 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
242 -- For create: G_CREATE, for update: G_UPDATE
243 -- Note: 1. This is automated generated item level validation procedure.
244 -- The actual validation detail is needed to be added.
245 --
246 -- End of Comments
247
248 PROCEDURE Validate_L_DECISION_FACTOR_ID (
249 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
250 P_Validation_mode IN VARCHAR2,
251 P_LEAD_DECISION_FACTOR_ID IN NUMBER,
252 X_Return_Status OUT NOCOPY VARCHAR2,
253 X_Msg_Count OUT NOCOPY NUMBER,
254 X_Msg_Data OUT NOCOPY VARCHAR2
255 );
256
257 -- Start of Comments
258 --
259 -- Item level validation procedures
260 --
261 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
262 -- For create: G_CREATE, for update: G_UPDATE
263 -- Note: 1. This is automated generated item level validation procedure.
264 -- The actual validation detail is needed to be added.
265 --
266 -- End of Comments
267
268 PROCEDURE Validate_LEAD_LINE_ID (
269 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
270 P_Validation_mode IN VARCHAR2,
271 P_LEAD_LINE_ID IN NUMBER,
272 X_Return_Status OUT NOCOPY VARCHAR2,
273 X_Msg_Count OUT NOCOPY NUMBER,
274 X_Msg_Data OUT NOCOPY VARCHAR2
275 );
276
277 -- Start of Comments
278 --
279 -- Item level validation procedures
280 --
281 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
282 -- For create: G_CREATE, for update: G_UPDATE
283 -- Note: 1. This is automated generated item level validation procedure.
284 -- The actual validation detail is needed to be added.
285 --
286 -- End of Comments
287
288 PROCEDURE Validate_CREATE_BY (
289 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
290 P_Validation_mode IN VARCHAR2,
291 P_CREATE_BY IN NUMBER,
292 X_Return_Status OUT NOCOPY VARCHAR2,
293 X_Msg_Count OUT NOCOPY NUMBER,
297 -- Start of Comments
294 X_Msg_Data OUT NOCOPY VARCHAR2
295 );
296
298 --
299 -- Record level validation procedures
300 --
301 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
302 -- For create: G_CREATE, for update: G_UPDATE
303 -- Note: 1. This is automated generated item level validation procedure.
304 -- The actual validation detail is needed to be added.
305 -- 2. Developer can manually added inter-field level validation.
306 -- End of Comments
307
308 PROCEDURE Validate_Decision_Factor_rec(
309 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
310 P_Validation_mode IN VARCHAR2,
311 P_Decision_Factor_Rec IN as_opportunity_pub.Decision_Factor_Rec_Type,
312 X_Return_Status OUT NOCOPY VARCHAR2,
313 X_Msg_Count OUT NOCOPY NUMBER,
314 X_Msg_Data OUT NOCOPY VARCHAR2
315 );
316
317 -- Start of Comments
318 --
319 -- validation procedures
320 --
321 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
322 -- For create: G_CREATE, for update: G_UPDATE
323 -- Note: 1. This is automated generated item level validation procedure.
324 -- The actual validation detail is needed to be added.
325 -- 2. We can also validate table instead of record. There will be an option for user to choose.
326 -- End of Comments
327
328 PROCEDURE Validate_decision_factor(
329 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
330 P_Validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
331 P_Validation_mode IN VARCHAR2,
332 P_Decision_Factor_Rec IN as_opportunity_pub.Decision_Factor_Rec_Type,
333 X_Return_Status OUT NOCOPY VARCHAR2,
334 X_Msg_Count OUT NOCOPY NUMBER,
335 X_Msg_Data OUT NOCOPY VARCHAR2
336 );
337
338 End AS_DECISION_FACTOR_PVT;