[Home] [Help]
PACKAGE: APPS.OZF_SUPP_TRADE_PROFILE_PVT
Source
1 PACKAGE OZF_SUPP_TRADE_PROFILE_PVT AS
2 /* $Header: ozfvstps.pls 120.0.12010000.3 2008/10/10 09:36:31 kdass ship $ */
3 -- ===============================================================
4 -- Start of Comments
5 -- Package name
6 -- OZF_SUPP_TRADE_PROFILE_PVT
7 -- Purpose
8 --
9 -- History
10 -- 16-SEP-2008 kdass ER 7377460 - added DFFs for DPP section
11 -- 09-OCT-2008 kdass ER 7475578 - Supplier Trade Profile changes for Price Protection price increase enhancement
12 --
13 -- NOTE
14 --
15 -- End of Comments
16 -- ===============================================================
17
18 -- Default number of records fetch per call
19 G_DEFAULT_NUM_REC_FETCH NUMBER := 30;
20 --===================================================================
21 -- Start of Comments
22 -- -------------------------------------------------------
23 -- Record name
24 -- supp_trade_profile_rec_type
25 -- -------------------------------------------------------
26 -- Parameters:
27 -- supp_trade_profile_id
28 -- object_version_number
29 -- last_update_date
30 -- last_updated_by
31 -- creation_date
32 -- created_by
33 -- last_update_login
34 -- request_id
35 -- program_application_id
36 -- program_update_date
37 -- program_id
38 -- created_from
39 -- supplier_id
40 -- supplier_site_id
41 -- party_id
42 -- cust_account_id
43 -- cust_acct_site_id
44 -- site_use_id
45 -- pre_approval_flag
46 -- approval_communication
47 -- gl_contra_liability_acct
48 -- gl_cost_adjustment_acct
49 -- default_days_covered
50 -- create_claim_price_increase
51 -- authorization_period
52 -- grace_days
53 -- allow_qty_increase
54 -- qty_increase_tolerance
55 -- request_communication
56 -- claim_communication
57 -- claim_frequency
58 -- claim_frequency_unit
59 -- claim_computation_basis
60 -- attribute_category
61 -- attribute1
62 -- attribute2
63 -- attribute3
64 -- attribute4
65 -- attribute5
66 -- attribute6
67 -- attribute7
68 -- attribute8
69 -- attribute9
70 -- attribute10
71 -- attribute11
72 -- attribute12
73 -- attribute13
74 -- attribute14
75 -- attribute15
76 -- org_id
77 -- security_group_id
78 -- last_paid_date
79 -- claim_currency_code
80 -- min_claim_amt
81 -- min_claim_amt_line_lvl
82 -- auto_debit
83 -- days_before_claiming_debit
84 -- Required
85 --
86 -- Defaults
87 --
88 -- Note: This is automatic generated record definition, it includes all columns
89 -- defined in the table, developer must manually add or delete some of the attributes.
90 --
91 -- End of Comments
92
93 --===================================================================
94 TYPE supp_trade_profile_rec_type IS RECORD
95 (
96
97 supp_trade_profile_id NUMBER,
98 object_version_number NUMBER,
99 last_update_date DATE,
100 last_updated_by NUMBER,
101 creation_date DATE,
102 created_by NUMBER,
103 last_update_login NUMBER,
104 request_id NUMBER,
105 program_application_id NUMBER,
106 program_update_date DATE,
107 program_id NUMBER,
108 created_from VARCHAR2(30),
109 supplier_id NUMBER,
110 supplier_site_id NUMBER,
111 party_id NUMBER,
112 cust_account_id NUMBER,
113 cust_acct_site_id NUMBER,
114 site_use_id NUMBER,
115 pre_approval_flag VARCHAR2(1),
116 approval_communication VARCHAR2(30),
117 gl_contra_liability_acct NUMBER,
118 gl_cost_adjustment_acct NUMBER,
119 default_days_covered NUMBER,
120 create_claim_price_increase VARCHAR2(1),
121 authorization_period NUMBER,
122 grace_days NUMBER,
123 allow_qty_increase VARCHAR2(1),
124 qty_increase_tolerance NUMBER,
125 request_communication VARCHAR2(30),
126 claim_communication VARCHAR2(30),
127 claim_frequency NUMBER,
128 claim_frequency_unit VARCHAR2(30),
129 claim_computation_basis NUMBER,
130 attribute_category VARCHAR2(30),
131 attribute1 VARCHAR2(150),
132 attribute2 VARCHAR2(150),
133 attribute3 VARCHAR2(150),
134 attribute4 VARCHAR2(150),
135 attribute5 VARCHAR2(150),
136 attribute6 VARCHAR2(150),
137 attribute7 VARCHAR2(150),
138 attribute8 VARCHAR2(150),
139 attribute9 VARCHAR2(150),
140 attribute10 VARCHAR2(150),
141 attribute11 VARCHAR2(150),
142 attribute12 VARCHAR2(150),
143 attribute13 VARCHAR2(150),
144 attribute14 VARCHAR2(150),
145 attribute15 VARCHAR2(150),
146 attribute16 VARCHAR2(150),
147 attribute17 VARCHAR2(150),
148 attribute18 VARCHAR2(150),
149 attribute19 VARCHAR2(150),
150 attribute20 VARCHAR2(150),
151 attribute21 VARCHAR2(150),
152 attribute22 VARCHAR2(150),
153 attribute23 VARCHAR2(150),
154 attribute24 VARCHAR2(150),
155 attribute25 VARCHAR2(150),
156 attribute26 VARCHAR2(150),
157 attribute27 VARCHAR2(150),
158 attribute28 VARCHAR2(150),
159 attribute29 VARCHAR2(150),
160 attribute30 VARCHAR2(150),
161 dpp_attribute_category VARCHAR2(30),
162 dpp_attribute1 VARCHAR2(150),
163 dpp_attribute2 VARCHAR2(150),
164 dpp_attribute3 VARCHAR2(150),
165 dpp_attribute4 VARCHAR2(150),
166 dpp_attribute5 VARCHAR2(150),
167 dpp_attribute6 VARCHAR2(150),
168 dpp_attribute7 VARCHAR2(150),
169 dpp_attribute8 VARCHAR2(150),
170 dpp_attribute9 VARCHAR2(150),
171 dpp_attribute10 VARCHAR2(150),
172 dpp_attribute11 VARCHAR2(150),
173 dpp_attribute12 VARCHAR2(150),
174 dpp_attribute13 VARCHAR2(150),
175 dpp_attribute14 VARCHAR2(150),
176 dpp_attribute15 VARCHAR2(150),
177 dpp_attribute16 VARCHAR2(150),
178 dpp_attribute17 VARCHAR2(150),
179 dpp_attribute18 VARCHAR2(150),
180 dpp_attribute19 VARCHAR2(150),
181 dpp_attribute20 VARCHAR2(150),
182 dpp_attribute21 VARCHAR2(150),
183 dpp_attribute22 VARCHAR2(150),
184 dpp_attribute23 VARCHAR2(150),
185 dpp_attribute24 VARCHAR2(150),
186 dpp_attribute25 VARCHAR2(150),
187 dpp_attribute26 VARCHAR2(150),
188 dpp_attribute27 VARCHAR2(150),
189 dpp_attribute28 VARCHAR2(150),
190 dpp_attribute29 VARCHAR2(150),
191 dpp_attribute30 VARCHAR2(150),
192 org_id NUMBER,
193 security_group_id NUMBER,
194 claim_currency_code VARCHAR2(15),
195 min_claim_amt NUMBER,
196 min_claim_amt_line_lvl NUMBER,
197 auto_debit VARCHAR2(1),
198 days_before_claiming_debit NUMBER
199
200 );
201
202 g_miss_supp_trade_profile_rec supp_trade_profile_rec_type;
203 TYPE supp_trade_profile_tbl_type IS TABLE OF supp_trade_profile_rec_type INDEX BY BINARY_INTEGER;
204 g_miss_supp_trade_profile_tbl supp_trade_profile_tbl_type;
205
206 -- ==============================================================================
207 -- Start of Comments
208 -- ==============================================================================
209 -- API Name
210 -- Create_Supp_Trade_Profile
211 -- Type
212 -- Private
213 -- Pre-Req
214 --
215 -- Parameters
216 --
217 -- IN
218 -- p_api_version_number IN NUMBER Required
219 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
220 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
221 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
222 -- p_supp_trade_profile_rec IN supp_trade_profile_rec_type Required
223 --
224 -- OUT
225 -- x_return_status OUT VARCHAR2
226 -- x_msg_count OUT NUMBER
227 -- x_msg_data OUT VARCHAR2
228 -- Version : Current version 1.0
229 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
230 -- and basic operation, developer must manually add parameters and business logic as necessary.
231 --
232 -- End of Comments
233 -- ==============================================================================
234 --
235
236 PROCEDURE Create_Supp_Trade_Profile(
237 p_api_version_number IN NUMBER,
238 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
239 p_commit IN VARCHAR2 := FND_API.G_FALSE,
240 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
241
242 x_return_status OUT NOCOPY VARCHAR2,
243 x_msg_count OUT NOCOPY NUMBER,
244 x_msg_data OUT NOCOPY VARCHAR2,
245
246 p_supp_trade_profile_rec IN supp_trade_profile_rec_type := g_miss_supp_trade_profile_rec,
247 x_supp_trade_profile_id OUT NOCOPY NUMBER
248 );
249
250 -- ==============================================================================
251 -- Start of Comments
252 -- ==============================================================================
253 -- API Name
254 -- Update_Supp_Trade_Profile
255 -- Type
256 -- Private
257 -- Pre-Req
258 --
259 -- Parameters
260 --
261 -- IN
262 -- p_api_version_number IN NUMBER Required
263 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
264 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
265 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
266 -- p_supp_trade_profile_rec IN supp_trade_profile_rec_type Required
267 --
268 -- OUT
269 -- x_return_status OUT VARCHAR2
270 -- x_msg_count OUT NUMBER
271 -- x_msg_data OUT VARCHAR2
272 -- Version : Current version 1.0
273 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
274 -- and basic operation, developer must manually add parameters and business logic as necessary.
275 --
276 -- End of Comments
277 -- ==============================================================================
278 --
279
280 PROCEDURE Update_Supp_Trade_Profile(
281 p_api_version_number IN NUMBER,
282 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
283 p_commit IN VARCHAR2 := FND_API.G_FALSE,
284 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
285
286 x_return_status OUT NOCOPY VARCHAR2,
287 x_msg_count OUT NOCOPY NUMBER,
288 x_msg_data OUT NOCOPY VARCHAR2,
289
290 p_supp_trade_profile_rec IN supp_trade_profile_rec_type,
291 x_object_version_number OUT NOCOPY NUMBER
292 );
293
294 -- ==============================================================================
295 -- Start of Comments
296 -- ==============================================================================
297 -- API Name
298 -- Supp_Delete_Trade_Profile
299 -- Type
300 -- Private
301 -- Pre-Req
302 --
303 -- Parameters
304 --
305 -- IN
306 -- p_api_version_number IN NUMBER Required
307 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
308 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
309 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
310 -- p_SUPP_TRADE_PROFILE_ID IN NUMBER
311 -- p_object_version_number IN NUMBER Optional Default = NULL
312 --
313 -- OUT
314 -- x_return_status OUT VARCHAR2
315 -- x_msg_count OUT NUMBER
316 -- x_msg_data OUT VARCHAR2
317 -- Version : Current version 1.0
318 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
319 -- and basic operation, developer must manually add parameters and business logic as necessary.
320 --
321 -- End of Comments
322 -- ==============================================================================
323 --
324
325 PROCEDURE Delete_Supp_Trade_Profile(
326 p_api_version_number IN NUMBER,
327 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
328 p_commit IN VARCHAR2 := FND_API.G_FALSE,
329 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
330 x_return_status OUT NOCOPY VARCHAR2,
331 x_msg_count OUT NOCOPY NUMBER,
332 x_msg_data OUT NOCOPY VARCHAR2,
333 p_supp_trade_profile_id IN NUMBER,
334 p_object_version_number IN NUMBER
335 );
336
337 -- ==============================================================================
338 -- Start of Comments
339 -- ==============================================================================
340 -- API Name
341 -- Lock_Trade_Profile
342 -- Type
343 -- Private
344 -- Pre-Req
345 --
346 -- Parameters
347 --
348 -- IN
349 -- p_api_version_number IN NUMBER Required
350 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
351 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
352 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
353 -- p_supp_trade_profile_rec IN supp_trade_profile_rec_type Required
354 --
355 -- OUT
356 -- x_return_status OUT VARCHAR2
357 -- x_msg_count OUT NUMBER
358 -- x_msg_data OUT VARCHAR2
359 -- Version : Current version 1.0
360 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
361 -- and basic operation, developer must manually add parameters and business logic as necessary.
362 --
363 -- End of Comments
364 -- ==============================================================================
365 --
366
367 PROCEDURE Lock_Supp_Trade_Profile(
368 p_api_version_number IN NUMBER,
369 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
370
371 x_return_status OUT NOCOPY VARCHAR2,
372 x_msg_count OUT NOCOPY NUMBER,
373 x_msg_data OUT NOCOPY VARCHAR2,
374
375 p_supp_trade_profile_id IN NUMBER,
376 p_object_version IN NUMBER
377 );
378
379
380 -- Start of Comments
381 --
382 -- validation procedures
383 --
384 -- p_validation_mode is a constant defined in OZF_UTILITY_PVT package
385 -- For create: G_CREATE, for update: G_UPDATE
386 -- Note: 1. This is automated generated item level validation procedure.
387 -- The actual validation detail is needed to be added.
388 -- 2. We can also validate table instead of record. There will be an option for user to choose.
389 -- End of Comments
390
391 PROCEDURE Validate_supp_trade_profile(
392 p_api_version_number IN NUMBER,
393 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
394 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
395 p_supp_trade_profile_rec IN supp_trade_profile_rec_type,
396 x_return_status OUT NOCOPY VARCHAR2,
397 x_msg_count OUT NOCOPY NUMBER,
398 x_msg_data OUT NOCOPY VARCHAR2
399 );
400
401 -- Start of Comments
402 --
403 -- validation procedures
404 --
405 -- p_validation_mode is a constant defined in OZF_UTILITY_PVT package
406 -- For create: G_CREATE, for update: G_UPDATE
407 -- Note: 1. This is automated generated item level validation procedure.
408 -- The actual validation detail is needed to be added.
409 -- 2. Validate the unique keys, lookups here
410 -- End of Comments
411
412 PROCEDURE Check_supp_trd_prfl_Items (
413 P_supp_trade_profile_rec IN supp_trade_profile_rec_type,
414 p_validation_mode IN VARCHAR2,
415 x_return_status OUT NOCOPY VARCHAR2
416 );
417
418 -- Start of Comments
419 --
420 -- Record level validation procedures
421 --
422 -- p_validation_mode is a constant defined in OZF_UTILITY_PVT package
423 -- For create: G_CREATE, for update: G_UPDATE
424 -- Note: 1. This is automated generated item level validation procedure.
425 -- The actual validation detail is needed to be added.
426 -- 2. Developer can manually added inter-field level validation.
427 -- End of Comments
428
429 PROCEDURE Validate_supp_trd_prfl_rec(
430 p_api_version_number IN NUMBER,
431 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
432 x_return_status OUT NOCOPY VARCHAR2,
433 x_msg_count OUT NOCOPY NUMBER,
434 x_msg_data OUT NOCOPY VARCHAR2,
435 p_supp_trade_profile_rec IN supp_trade_profile_rec_type
436 );
437
438 END OZF_SUPP_TRADE_PROFILE_PVT;
439
440
441