1 PACKAGE AS_OPP_COMPETITOR_PVT AUTHID CURRENT_USER as
2 /* $Header: asxvcmps.pls 115.7 2002/12/13 11:30:23 nkamble ship $ */
3 -- Start of Comments
4 -- Package name : AS_OPP_COMPETITOR_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_competitors
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_Tbl IN AS_OPPORTUNITY_PUB.Competitor_Tbl_Type
30 -- Required
31 --
32 -- OUT:
33 -- x_competitor_out_tbl OUT AS_OPPORTUNITY_PUB.competitor_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_competitors(
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_Tbl IN AS_OPPORTUNITY_PUB.Competitor_Tbl_Type :=
49 AS_OPPORTUNITY_PUB.G_MISS_Competitor_Tbl,
50 X_competitor_out_tbl OUT NOCOPY AS_OPPORTUNITY_PUB.competitor_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_competitors
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_Tbl IN AS_OPPORTUNITY_PUB.Competitor_Tbl_Type
77 -- Required
78 --
79 -- OUT:
80 -- x_competitor_out_tbl OUT AS_OPPORTUNITY_PUB.competitor_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_competitors(
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_Tbl IN AS_OPPORTUNITY_PUB.Competitor_Tbl_Type,
100 X_competitor_out_tbl OUT NOCOPY AS_OPPORTUNITY_PUB.competitor_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
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_Tbl IN AS_OPPORTUNITY_PUB.Competitor_Tbl_Type
123 -- Required
124 --
125 -- OUT:
126 -- x_competitor_out_tbl OUT AS_OPPORTUNITY_PUB.competitor_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_competitors(
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_Tbl IN AS_OPPORTUNITY_PUB.Competitor_Tbl_Type,
146 X_competitor_out_tbl OUT NOCOPY AS_OPPORTUNITY_PUB.competitor_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_LEAD_COMPETITOR_ID (
164 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
165 P_Validation_mode IN VARCHAR2,
166 P_LEAD_COMPETITOR_ID IN NUMBER,
167 X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PUB.ITEM_PROPERTY_REC_TYPE,
168 X_Return_Status OUT NOCOPY VARCHAR2,
169 X_Msg_Count OUT NOCOPY NUMBER,
170 X_Msg_Data OUT NOCOPY VARCHAR2
171 );
172
173 -- Start of Comments
174 --
175 -- Item level validation procedures
176 --
177 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
178 -- For create: G_CREATE, for update: G_UPDATE
179 -- Note: 1. This is automated generated item level validation procedure.
180 -- The actual validation detail is needed to be added.
181 --
182 -- End of Comments
183
184 PROCEDURE Validate_LEAD_ID (
185 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
186 P_Validation_mode IN VARCHAR2,
187 P_LEAD_ID IN NUMBER,
188 X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PUB.ITEM_PROPERTY_REC_TYPE,
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 /*
206 PROCEDURE Validate_COMPETITOR (
207 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
208 P_Validation_mode IN VARCHAR2,
209 P_COMPETITOR IN VARCHAR2,
210 X_Item_Property_Rec OUT AS_UTILITY_PUB.ITEM_PROPERTY_REC_TYPE,
211 X_Return_Status OUT VARCHAR2,
212 X_Msg_Count OUT NUMBER,
213 X_Msg_Data OUT VARCHAR2
214 );
215 */
216
217 -- Start of Comments
218 --
219 -- Item level validation procedures
220 --
221 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
222 -- For create: G_CREATE, for update: G_UPDATE
223 -- Note: 1. This is automated generated item level validation procedure.
224 -- The actual validation detail is needed to be added.
225 --
226 -- End of Comments
227
228 PROCEDURE Validate_COMPETITOR_ID (
229 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
230 P_Validation_mode IN VARCHAR2,
231 P_COMPETITOR_ID IN NUMBER,
232 X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PUB.ITEM_PROPERTY_REC_TYPE,
233 X_Return_Status OUT NOCOPY VARCHAR2,
234 X_Msg_Count OUT NOCOPY NUMBER,
235 X_Msg_Data OUT NOCOPY VARCHAR2
236 );
237
238 -- Start of Comments
239 --
240 -- Record level validation procedures
241 --
242 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
243 -- For create: G_CREATE, for update: G_UPDATE
244 -- Note: 1. This is automated generated item level validation procedure.
245 -- The actual validation detail is needed to be added.
246 -- 2. Developer can manually added inter-field level validation.
247 -- End of Comments
248
249 PROCEDURE Validate_Competitor_rec(
250 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
251 P_Validation_mode IN VARCHAR2,
252 P_Competitor_Rec IN AS_OPPORTUNITY_PUB.Competitor_Rec_Type,
253 X_Return_Status OUT NOCOPY VARCHAR2,
254 X_Msg_Count OUT NOCOPY NUMBER,
255 X_Msg_Data OUT NOCOPY VARCHAR2
256 );
257
258 -- Start of Comments
259 --
260 -- validation procedures
261 --
262 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
263 -- For create: G_CREATE, for update: G_UPDATE
264 -- Note: 1. This is automated generated item level validation procedure.
265 -- The actual validation detail is needed to be added.
266 -- 2. We can also validate table instead of record. There will be an
267 -- option for user to choose.
268 -- End of Comments
269
270 PROCEDURE Validate_competitor(
271 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
272 P_Validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
273 P_Validation_mode IN VARCHAR2,
274 P_Competitor_Rec IN AS_OPPORTUNITY_PUB.Competitor_Rec_Type,
275 X_Return_Status OUT NOCOPY VARCHAR2,
276 X_Msg_Count OUT NOCOPY NUMBER,
277 X_Msg_Data OUT NOCOPY VARCHAR2
278 );
279
280 End AS_OPP_COMPETITOR_PVT;