[Home] [Help]
PACKAGE: APPS.AMS_COMPETITOR_PRODUCT_PVT
Source
1 PACKAGE Ams_Competitor_Product_Pvt AS
2 /* $Header: amsvcprs.pls 120.1 2005/08/04 08:19:13 appldev ship $ */
3 -- ===============================================================
4 -- Start of Comments
5 -- Package name
6 -- Ams_Competitor_Product_Pvt
7 -- Purpose
8 --
9 -- History
10 -- 01-Oct-2001 musman Created.
11 -- 05-Nov-2001 musman Commented out the reference to security_group_id
12 -- 10-Sep-2003 Musman Added Changes reqd for interest type to category
13 -- 04-Aug-2005 inanaiah R12 change - added a DFF
14 -- NOTE
15 --
16 -- End of Comments
17 -- ===============================================================
18
19 -- Default number of records fetch per call
20 G_DEFAULT_NUM_REC_FETCH NUMBER := 30;
21 --===================================================================
22 -- Start of Comments
23 -- -------------------------------------------------------
24 -- Record name
25 -- comp_prod_rec_type
26 -- -------------------------------------------------------
27 -- Parameters:
28 -- competitor_product_id
29 -- object_version_number
30 -- last_update_date
31 -- last_updated_by
32 -- creation_date
33 -- created_by
34 -- last_update_login
35 -- competitor_party_id
36 -- competitor_product_code
37 -- interest_type_id
38 -- inventory_item_id
39 -- organization_id
40 -- comp_product_url
41 -- original_system_ref
42 -- security_group_id
43 -- competitor_product_name
44 -- description
45 -- start_date
46 -- end_date
47 -- category_id
48 -- category_set_id
49 --
50 -- Required
51 --
52 -- Defaults
53 --
54 -- Note: This is automatic generated record definition, it includes all columns
55 -- defined in the table, developer must manually add or delete some of the attributes.
56 --
57 -- End of Comments
58
59 --===================================================================
60 TYPE comp_prod_rec_type IS RECORD
61 (
62 competitor_product_id NUMBER := FND_API.G_MISS_NUM,
63 object_version_number NUMBER := FND_API.G_MISS_NUM,
64 last_update_date DATE := FND_API.G_MISS_DATE,
65 last_updated_by NUMBER := FND_API.G_MISS_NUM,
66 creation_date DATE := FND_API.G_MISS_DATE,
67 created_by NUMBER := FND_API.G_MISS_NUM,
68 last_update_login NUMBER := FND_API.G_MISS_NUM,
69 competitor_party_id NUMBER := FND_API.G_MISS_NUM,
70 competitor_product_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
71 interest_type_id NUMBER := FND_API.G_MISS_NUM,
72 inventory_item_id NUMBER := FND_API.G_MISS_NUM,
73 organization_id NUMBER := FND_API.G_MISS_NUM,
74 comp_product_url VARCHAR2(100) := FND_API.G_MISS_CHAR,
75 original_system_ref VARCHAR2(240) := FND_API.G_MISS_CHAR,
76 --security_group_id NUMBER := FND_API.G_MISS_NUM,
77 competitor_product_name VARCHAR2(240) := FND_API.G_MISS_CHAR,
78 description VARCHAR2(2000) := FND_API.G_MISS_CHAR,
79 start_date DATE := FND_API.G_MISS_DATE,
80 end_date DATE := FND_API.G_MISS_DATE,
81 category_id NUMBER := FND_API.G_MISS_NUM,
82 category_set_id NUMBER := FND_API.G_MISS_NUM,
83 context VARCHAR2(30),
84 attribute1 VARCHAR2(150),
85 attribute2 VARCHAR2(150),
86 attribute3 VARCHAR2(150),
87 attribute4 VARCHAR2(150),
88 attribute5 VARCHAR2(150),
89 attribute6 VARCHAR2(150),
90 attribute7 VARCHAR2(150),
91 attribute8 VARCHAR2(150),
92 attribute9 VARCHAR2(150),
93 attribute10 VARCHAR2(150),
94 attribute11 VARCHAR2(150),
95 attribute12 VARCHAR2(150),
96 attribute13 VARCHAR2(150),
97 attribute14 VARCHAR2(150),
98 attribute15 VARCHAR2(150)
99 );
100
101 g_miss_comp_prod_type_rec comp_prod_rec_type;
102
103 -- ==============================================================================
104 -- Start of Comments
105 -- ==============================================================================
106 -- API Name
107 -- Create_Comp_Product
108 -- Type
109 -- Private
110 -- Pre-Req
111 --
112 -- Parameters
113 --
114 -- IN
115 -- p_api_version_number IN NUMBER Required
116 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
117 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
118 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
119 -- p_comp_prod_rec IN comp_prod_rec_type Required
120 --
121 -- OUT
122 -- x_return_status OUT VARCHAR2
123 -- x_msg_count OUT NUMBER
124 -- x_msg_data OUT VARCHAR2
125 -- Version : Current version 1.0
126 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
127 -- and basic operation, developer must manually add parameters and business logic as necessary.
128 --
129 -- End of Comments
130 -- ==============================================================================
131 --
132
133 PROCEDURE Create_Comp_Product(
134 p_api_version_number IN NUMBER,
135 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
136 p_commit IN VARCHAR2 := FND_API.G_FALSE,
137 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
138
139 x_return_status OUT NOCOPY VARCHAR2,
140 x_msg_count OUT NOCOPY NUMBER,
141 x_msg_data OUT NOCOPY VARCHAR2,
142
143 p_comp_prod_rec IN comp_prod_rec_type := g_miss_comp_prod_type_rec ,
144 x_competitor_product_id OUT NOCOPY NUMBER
145 );
146
147 -- ==============================================================================
148 -- Start of Comments
149 -- ==============================================================================
150 -- API Name
151 -- Update_Comp_Product
152 -- Type
153 -- Private
154 -- Pre-Req
155 --
156 -- Parameters
157 --
158 -- IN
159 -- p_api_version_number IN NUMBER Required
160 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
161 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
162 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
163 -- p_comp_prod_rec IN comp_prod_rec_type Required
164 --
165 -- OUT
166 -- x_return_status OUT VARCHAR2
167 -- x_msg_count OUT NUMBER
168 -- x_msg_data OUT VARCHAR2
169 -- Version : Current version 1.0
170 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
171 -- and basic operation, developer must manually add parameters and business logic as necessary.
172 --
173 -- End of Comments
174 -- ==============================================================================
175 --
176
177 PROCEDURE Update_Comp_Product(
178 p_api_version_number IN NUMBER,
179 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
180 p_commit IN VARCHAR2 := FND_API.G_FALSE,
181 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
182
183 x_return_status OUT NOCOPY VARCHAR2,
184 x_msg_count OUT NOCOPY NUMBER,
185 x_msg_data OUT NOCOPY VARCHAR2,
186
187 p_comp_prod_rec IN comp_prod_rec_type,
188 x_object_version_number OUT NOCOPY NUMBER
189 );
190
191 -- ==============================================================================
192 -- Start of Comments
193 -- ==============================================================================
194 -- API Name
195 -- Delete_Comp_Product
196 -- Type
197 -- Private
198 -- Pre-Req
199 --
200 -- Parameters
201 --
202 -- IN
203 -- p_api_version_number IN NUMBER Required
204 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
205 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
206 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
207 -- p_COMPETITOR_PRODUCT_ID IN NUMBER
208 -- p_object_version_number IN NUMBER Optional Default = NULL
209 --
210 -- OUT
211 -- x_return_status OUT VARCHAR2
212 -- x_msg_count OUT NUMBER
213 -- x_msg_data OUT VARCHAR2
214 -- Version : Current version 1.0
215 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
216 -- and basic operation, developer must manually add parameters and business logic as necessary.
217 --
218 -- End of Comments
219 -- ==============================================================================
220 --
221
222 PROCEDURE Delete_Comp_Product(
223 p_api_version_number IN NUMBER,
224 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
225 p_commit IN VARCHAR2 := FND_API.G_FALSE,
226 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
227 x_return_status OUT NOCOPY VARCHAR2,
228 x_msg_count OUT NOCOPY NUMBER,
229 x_msg_data OUT NOCOPY VARCHAR2,
230 p_competitor_product_id IN NUMBER,
231 p_object_version_number IN NUMBER
232 );
233
234 -- ==============================================================================
235 -- Start of Comments
236 -- ==============================================================================
237 -- API Name
238 -- Lock_Ams_Competitor_Product_Pvt
239 -- Type
240 -- Private
241 -- Pre-Req
242 --
243 -- Parameters
244 --
245 -- IN
246 -- p_api_version_number IN NUMBER Required
247 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
248 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
249 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
250 -- p_comp_prod_rec IN comp_prod_rec_type Required
251 --
252 -- OUT
253 -- x_return_status OUT VARCHAR2
254 -- x_msg_count OUT NUMBER
255 -- x_msg_data OUT VARCHAR2
256 -- Version : Current version 1.0
257 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
258 -- and basic operation, developer must manually add parameters and business logic as necessary.
259 --
260 -- End of Comments
261 -- ==============================================================================
262 --
263
264 PROCEDURE Lock_Comp_Product(
265 p_api_version_number IN NUMBER,
266 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
267
268 x_return_status OUT NOCOPY VARCHAR2,
269 x_msg_count OUT NOCOPY NUMBER,
270 x_msg_data OUT NOCOPY VARCHAR2,
271
272 p_competitor_product_id IN NUMBER,
273 p_object_version IN NUMBER
274 );
275
276
277 -- Start of Comments
278 --
279 -- validation procedures
280 --
281 -- p_validation_mode is a constant defined in AMS_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 -- 2. We can also validate table instead of record. There will be an option for user to choose.
286 -- End of Comments
287
288 PROCEDURE Validate_comp_prod(
289 p_api_version_number IN NUMBER,
290 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
291 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
292 p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
293 p_comp_prod_rec IN comp_prod_rec_type,
294 x_return_status OUT NOCOPY VARCHAR2,
295 x_msg_count OUT NOCOPY NUMBER,
296 x_msg_data OUT NOCOPY VARCHAR2
297 );
298
299 END Ams_Competitor_Product_Pvt;