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