1 PACKAGE AS_COMPETITOR_PROD_PVT AUTHID CURRENT_USER as
2 /* $Header: asxvcpds.pls 115.6 2002/12/13 12:24:09 nkamble ship $ */
3 -- Start of Comments
4 -- Package name : AS_COMPETITOR_PROD_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_competitor_prods
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_competitor_prod_Tbl IN As_Opportunity_Pub.Competitor_Prod_Tbl_Type
30 -- Required
31 --
32 -- OUT:
33 -- x_competitor_prod_out_tbl OUT as_opportunity_pub.competitor_prod_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_competitor_prods(
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_Admin_Group_Id IN NUMBER,
47 P_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE,
48 P_competitor_prod_Tbl IN As_Opportunity_Pub.Competitor_Prod_Tbl_Type :=
49 AS_OPPORTUNITY_PUB.G_MISS_competitor_prod_Tbl,
50 X_competitor_prod_out_tbl OUT NOCOPY as_opportunity_pub.competitor_prod_out_tbl_type,
51 P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,
52 P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,
53 P_Identity_Salesforce_Id IN NUMBER := NULL,
54 P_Partner_Cont_Party_id IN NUMBER := FND_API.G_MISS_NUM,
55 X_Return_Status OUT NOCOPY VARCHAR2,
56 X_Msg_Count OUT NOCOPY NUMBER,
57 X_Msg_Data OUT NOCOPY VARCHAR2
58 );
59
60 -- *******************************************************
61 -- Start of Comments
62 -- *******************************************************
63 -- API Name: Update_competitor_prods
64 -- Type : Private
65 -- Pre-Req :
66 -- Parameters:
67 -- IN
68 -- p_api_version_number IN NUMBER Required
69 -- p_init_msg_list IN VARCHAR2 Optional
70 -- Default = FND_API_G_FALSE
71 -- p_commit IN VARCHAR2 Optional
72 -- Default = FND_API.G_FALSE
73 -- p_validation_level IN NUMBER Optional
74 -- Default = FND_API.G_VALID_LEVEL_FULL
75 -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
76 -- P_competitor_prod_Tbl IN As_Opportunity_Pub.Competitor_Prod_Tbl_Type
77 -- Required
78 --
79 -- OUT:
80 -- x_competitor_prod_out_tbl OUT as_opportunity_pub.competitor_prod_out_tbl_type
81 -- x_return_status OUT VARCHAR2
82 -- x_msg_count OUT NUMBER
83 -- x_msg_data OUT VARCHAR2
84 -- Version : Current version 2.0
85 --
86 -- End of Comments
87 --
88 PROCEDURE Update_competitor_prods(
89 P_Api_Version_Number IN NUMBER,
90 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
91 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
92 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
93 P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,
94 P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,
95 P_Admin_Group_Id IN NUMBER,
96 P_Identity_Salesforce_Id IN NUMBER,
97 P_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE,
98 P_Partner_Cont_Party_id IN NUMBER := FND_API.G_MISS_NUM,
99 P_competitor_prod_Tbl IN As_Opportunity_Pub.Competitor_Prod_Tbl_Type,
100 X_competitor_prod_out_tbl OUT NOCOPY as_opportunity_pub.competitor_prod_out_tbl_type,
101 X_Return_Status OUT NOCOPY VARCHAR2,
102 X_Msg_Count OUT NOCOPY NUMBER,
103 X_Msg_Data OUT NOCOPY VARCHAR2
104 );
105
106 -- *******************************************************
107 -- Start of Comments
108 -- *******************************************************
109 -- API Name: Delete_competitor_prod
110 -- Type : Private
111 -- Pre-Req :
112 -- Parameters:
113 -- IN
114 -- p_api_version_number IN NUMBER Required
115 -- p_init_msg_list IN VARCHAR2 Optional
116 -- Default = FND_API_G_FALSE
117 -- p_commit IN VARCHAR2 Optional
118 -- Default = FND_API.G_FALSE
119 -- p_validation_level IN NUMBER Optional
120 -- Default = FND_API.G_VALID_LEVEL_FULL
121 -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
122 -- P_competitor_prod_Tbl IN As_Opportunity_Pub.Competitor_Prod_Tbl_Type
123 -- Required
124 --
125 -- OUT:
126 -- x_competitor_prod_out_tbl OUT as_opportunity_pub.competitor_prod_out_tbl_type
127 -- x_return_status OUT VARCHAR2
128 -- x_msg_count OUT NUMBER
129 -- x_msg_data OUT VARCHAR2
130 -- Version : Current version 2.0
131 --
132 -- End of Comments
133 --
134 PROCEDURE Delete_competitor_prods(
135 P_Api_Version_Number IN NUMBER,
136 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
137 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
138 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
139 P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,
140 P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,
141 P_Admin_Group_Id IN NUMBER,
142 P_identity_salesforce_id IN NUMBER := NULL,
143 P_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE,
144 P_Partner_Cont_Party_id IN NUMBER := FND_API.G_MISS_NUM,
145 P_competitor_prod_Tbl IN As_Opportunity_Pub.Competitor_Prod_Tbl_Type,
146 X_competitor_prod_out_tbl OUT NOCOPY as_opportunity_pub.competitor_prod_out_tbl_type,
147 X_Return_Status OUT NOCOPY VARCHAR2,
148 X_Msg_Count OUT NOCOPY NUMBER,
149 X_Msg_Data OUT NOCOPY VARCHAR2
150 );
151
152 -- Start of Comments
153 --
154 -- Item level validation procedures
155 --
156 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
157 -- For create: G_CREATE, for update: G_UPDATE
158 -- Note: 1. This is automated generated item level validation procedure.
159 -- The actual validation detail is needed to be added.
160 --
161 -- End of Comments
162
163 PROCEDURE Validate_REQUEST_ID (
164 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
165 P_Validation_mode IN VARCHAR2,
166 P_REQUEST_ID IN NUMBER,
167 X_Return_Status OUT NOCOPY VARCHAR2,
168 X_Msg_Count OUT NOCOPY NUMBER,
169 X_Msg_Data OUT NOCOPY VARCHAR2
170 );
171
172 -- Start of Comments
173 --
174 -- Item level validation procedures
175 --
176 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
177 -- For create: G_CREATE, for update: G_UPDATE
178 -- Note: 1. This is automated generated item level validation procedure.
179 -- The actual validation detail is needed to be added.
180 --
181 -- End of Comments
182
183 PROCEDURE Validate_WIN_LOSS_STATUS (
184 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
185 P_Validation_mode IN VARCHAR2,
186 P_WIN_LOSS_STATUS IN VARCHAR2,
187 X_Return_Status OUT NOCOPY VARCHAR2,
188 X_Msg_Count OUT NOCOPY NUMBER,
189 X_Msg_Data OUT NOCOPY VARCHAR2
190 );
191
192
193 PROCEDURE Validate_COMPETITOR_PRODUCT_ID (
194 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
195 P_Validation_mode IN VARCHAR2,
196 P_COMPETITOR_PRODUCT_ID IN NUMBER,
197 X_Return_Status OUT NOCOPY VARCHAR2,
198 X_Msg_Count OUT NOCOPY NUMBER,
199 X_Msg_Data OUT NOCOPY VARCHAR2
200 );
201
202 -- Start of Comments
203 --
204 -- Item level validation procedures
205 --
206 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
207 -- For create: G_CREATE, for update: G_UPDATE
208 -- Note: 1. This is automated generated item level validation procedure.
209 -- The actual validation detail is needed to be added.
210 --
211 -- End of Comments
212
213 PROCEDURE Validate_LEAD_LINE_ID (
214 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
215 P_Validation_mode IN VARCHAR2,
216 P_LEAD_LINE_ID IN NUMBER,
217 X_Return_Status OUT NOCOPY VARCHAR2,
218 X_Msg_Count OUT NOCOPY NUMBER,
219 X_Msg_Data OUT NOCOPY VARCHAR2
220 );
221
222 -- Start of Comments
223 --
224 -- Item level validation procedures
225 --
226 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
227 -- For create: G_CREATE, for update: G_UPDATE
228 -- Note: 1. This is automated generated item level validation procedure.
229 -- The actual validation detail is needed to be added.
230 --
231 -- End of Comments
232
233 PROCEDURE Validate_LEAD_ID (
234 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
235 P_Validation_mode IN VARCHAR2,
236 P_LEAD_ID IN NUMBER,
237 X_Return_Status OUT NOCOPY VARCHAR2,
238 X_Msg_Count OUT NOCOPY NUMBER,
239 X_Msg_Data OUT NOCOPY VARCHAR2
240 );
241
242 -- Start of Comments
243 --
244 -- Item level validation procedures
245 --
246 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
247 -- For create: G_CREATE, for update: G_UPDATE
248 -- Note: 1. This is automated generated item level validation procedure.
249 -- The actual validation detail is needed to be added.
250 --
251 -- End of Comments
252
253 PROCEDURE Validate_L_COMPETITOR_PROD_ID (
254 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
255 P_Validation_mode IN VARCHAR2,
256 P_LEAD_COMPETITOR_PROD_ID IN NUMBER,
257 X_Return_Status OUT NOCOPY VARCHAR2,
258 X_Msg_Count OUT NOCOPY NUMBER,
259 X_Msg_Data OUT NOCOPY VARCHAR2
260 );
261
262 -- Start of Comments
263 --
264 -- Record level validation procedures
265 --
266 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
267 -- For create: G_CREATE, for update: G_UPDATE
268 -- Note: 1. This is automated generated item level validation procedure.
269 -- The actual validation detail is needed to be added.
270 -- 2. Developer can manually added inter-field level validation.
271 -- End of Comments
272
273 PROCEDURE Validate_Competitor_Prod_rec(
274 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
275 P_Validation_mode IN VARCHAR2,
276 P_Competitor_Prod_Rec IN As_Opportunity_Pub.Competitor_Prod_Rec_Type,
277 X_Return_Status OUT NOCOPY VARCHAR2,
278 X_Msg_Count OUT NOCOPY NUMBER,
279 X_Msg_Data OUT NOCOPY VARCHAR2
280 );
281
282 -- Start of Comments
283 --
284 -- validation procedures
285 --
286 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
287 -- For create: G_CREATE, for update: G_UPDATE
288 -- Note: 1. This is automated generated item level validation procedure.
289 -- The actual validation detail is needed to be added.
290 -- 2. We can also validate table instead of record. There will be an option for user to choose.
291 -- End of Comments
292
293 PROCEDURE Validate_competitor_prod(
294 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
295 P_Validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
296 P_Validation_mode IN VARCHAR2,
297 P_Competitor_Prod_Rec IN As_Opportunity_Pub.Competitor_Prod_Rec_Type,
298 X_Return_Status OUT NOCOPY VARCHAR2,
299 X_Msg_Count OUT NOCOPY NUMBER,
300 X_Msg_Data OUT NOCOPY VARCHAR2
301 );
302
303 End AS_COMPETITOR_PROD_PVT;