[Home] [Help]
PACKAGE: APPS.OZF_SUPP_TRADE_PROFILE_PUB
Source
1 PACKAGE OZF_SUPP_TRADE_PROFILE_PUB AUTHID CURRENT_USER AS
2 /* $Header: ozfpstps.pls 120.3 2012/01/04 08:41:24 nirprasa noship $ */
3 /*#
4 * This package can be used to Create and Update Supplier Trade profile and related
5 * code conversion and price protection setup data
6 * @rep:scope public
7 * @rep:product OZF
8 * @rep:lifecycle active
9 * @rep:displayname OZF_SUPP_TRADE_PROFILE Public API
10 * @rep:compatibility S
11 * @rep:businessevent None
12 * @rep:category BUSINESS_ENTITY OZF_STP
13 */
14
15 -- -------------------------------------------------------
16 -- Record name supp_trade_profile_rec_type
17 -- -------------------------------------------------------
18
19
20 TYPE supp_trade_profile_rec_type IS RECORD
21 (
22 supp_trade_profile_id NUMBER := FND_API.g_miss_num,
23 object_version_number NUMBER := FND_API.g_miss_num,
24 last_update_date DATE := FND_API.G_MISS_DATE,
25 last_updated_by NUMBER := FND_API.g_miss_num,
26 creation_date DATE := FND_API.G_MISS_DATE,
27 created_by NUMBER := FND_API.g_miss_num,
28 last_update_login NUMBER := FND_API.g_miss_num,
29 request_id NUMBER := FND_API.g_miss_num,
30 program_application_id NUMBER := FND_API.g_miss_num,
31 program_update_date DATE := FND_API.G_MISS_DATE,
32 program_id NUMBER := FND_API.g_miss_num,
33 created_from VARCHAR2(30) := FND_API.g_miss_char,
34 supplier_id NUMBER := FND_API.g_miss_num,
35 supplier_site_id NUMBER := FND_API.g_miss_num,
36 party_id NUMBER := FND_API.g_miss_num,
37 cust_account_id NUMBER := FND_API.g_miss_num,
38 cust_acct_site_id NUMBER := FND_API.g_miss_num,
39 site_use_id NUMBER := FND_API.g_miss_num,
40 pre_approval_flag VARCHAR2(1) := FND_API.g_miss_char,
41 approval_communication VARCHAR2(30) := FND_API.g_miss_char,
42 gl_contra_liability_acct NUMBER := FND_API.g_miss_num,
43 gl_cost_adjustment_acct NUMBER := FND_API.g_miss_num,
44 default_days_covered NUMBER := FND_API.g_miss_num,
45 create_claim_price_increase VARCHAR2(1) := FND_API.g_miss_char,
46 skip_approval_flag VARCHAR2(1) := FND_API.g_miss_char,
47 skip_adjustment_flag VARCHAR2(1) := FND_API.g_miss_char,
48 settlement_method_supplier_inc VARCHAR2(30) := FND_API.g_miss_char,
49 settlement_method_supplier_dec VARCHAR2(30) := FND_API.g_miss_char,
50 settlement_method_customer VARCHAR2(30) := FND_API.g_miss_char,
51 authorization_period NUMBER := FND_API.g_miss_num,
52 grace_days NUMBER := FND_API.g_miss_num,
53 allow_qty_increase VARCHAR2(1) := FND_API.g_miss_char,
54 qty_increase_tolerance NUMBER := FND_API.g_miss_num,
55 request_communication VARCHAR2(30) := FND_API.g_miss_char,
56 claim_communication VARCHAR2(30) := FND_API.g_miss_char,
57 claim_frequency NUMBER := FND_API.g_miss_num,
58 claim_frequency_unit VARCHAR2(30) := FND_API.g_miss_char,
59 claim_computation_basis NUMBER := FND_API.g_miss_num,
60 attribute_category VARCHAR2(30) := FND_API.g_miss_char,
61 attribute1 VARCHAR2(150) := FND_API.g_miss_char,
62 attribute2 VARCHAR2(150) := FND_API.g_miss_char,
63 attribute3 VARCHAR2(150) := FND_API.g_miss_char,
64 attribute4 VARCHAR2(150) := FND_API.g_miss_char,
65 attribute5 VARCHAR2(150) := FND_API.g_miss_char,
66 attribute6 VARCHAR2(150) := FND_API.g_miss_char,
67 attribute7 VARCHAR2(150) := FND_API.g_miss_char,
68 attribute8 VARCHAR2(150) := FND_API.g_miss_char,
69 attribute9 VARCHAR2(150) := FND_API.g_miss_char,
70 attribute10 VARCHAR2(150) := FND_API.g_miss_char,
71 attribute11 VARCHAR2(150) := FND_API.g_miss_char,
72 attribute12 VARCHAR2(150) := FND_API.g_miss_char,
73 attribute13 VARCHAR2(150) := FND_API.g_miss_char,
74 attribute14 VARCHAR2(150) := FND_API.g_miss_char,
75 attribute15 VARCHAR2(150) := FND_API.g_miss_char,
76 attribute16 VARCHAR2(150) := FND_API.g_miss_char,
77 attribute17 VARCHAR2(150) := FND_API.g_miss_char,
78 attribute18 VARCHAR2(150) := FND_API.g_miss_char,
79 attribute19 VARCHAR2(150) := FND_API.g_miss_char,
80 attribute20 VARCHAR2(150) := FND_API.g_miss_char,
81 attribute21 VARCHAR2(150) := FND_API.g_miss_char,
82 attribute22 VARCHAR2(150) := FND_API.g_miss_char,
83 attribute23 VARCHAR2(150) := FND_API.g_miss_char,
84 attribute24 VARCHAR2(150) := FND_API.g_miss_char,
85 attribute25 VARCHAR2(150) := FND_API.g_miss_char,
86 attribute26 VARCHAR2(150) := FND_API.g_miss_char,
87 attribute27 VARCHAR2(150) := FND_API.g_miss_char,
88 attribute28 VARCHAR2(150) := FND_API.g_miss_char,
89 attribute29 VARCHAR2(150) := FND_API.g_miss_char,
90 attribute30 VARCHAR2(150) := FND_API.g_miss_char,
91 dpp_attribute_category VARCHAR2(30) := FND_API.g_miss_char,
92 dpp_attribute1 VARCHAR2(150) := FND_API.g_miss_char,
93 dpp_attribute2 VARCHAR2(150) := FND_API.g_miss_char,
94 dpp_attribute3 VARCHAR2(150) := FND_API.g_miss_char,
95 dpp_attribute4 VARCHAR2(150) := FND_API.g_miss_char,
96 dpp_attribute5 VARCHAR2(150) := FND_API.g_miss_char,
97 dpp_attribute6 VARCHAR2(150) := FND_API.g_miss_char,
98 dpp_attribute7 VARCHAR2(150) := FND_API.g_miss_char,
99 dpp_attribute8 VARCHAR2(150) := FND_API.g_miss_char,
100 dpp_attribute9 VARCHAR2(150) := FND_API.g_miss_char,
101 dpp_attribute10 VARCHAR2(150) := FND_API.g_miss_char,
102 dpp_attribute11 VARCHAR2(150) := FND_API.g_miss_char,
103 dpp_attribute12 VARCHAR2(150) := FND_API.g_miss_char,
104 dpp_attribute13 VARCHAR2(150) := FND_API.g_miss_char,
105 dpp_attribute14 VARCHAR2(150) := FND_API.g_miss_char,
106 dpp_attribute15 VARCHAR2(150) := FND_API.g_miss_char,
107 dpp_attribute16 VARCHAR2(150) := FND_API.g_miss_char,
108 dpp_attribute17 VARCHAR2(150) := FND_API.g_miss_char,
109 dpp_attribute18 VARCHAR2(150) := FND_API.g_miss_char,
110 dpp_attribute19 VARCHAR2(150) := FND_API.g_miss_char,
111 dpp_attribute20 VARCHAR2(150) := FND_API.g_miss_char,
112 dpp_attribute21 VARCHAR2(150) := FND_API.g_miss_char,
113 dpp_attribute22 VARCHAR2(150) := FND_API.g_miss_char,
114 dpp_attribute23 VARCHAR2(150) := FND_API.g_miss_char,
115 dpp_attribute24 VARCHAR2(150) := FND_API.g_miss_char,
116 dpp_attribute25 VARCHAR2(150) := FND_API.g_miss_char,
117 dpp_attribute26 VARCHAR2(150) := FND_API.g_miss_char,
118 dpp_attribute27 VARCHAR2(150) := FND_API.g_miss_char,
119 dpp_attribute28 VARCHAR2(150) := FND_API.g_miss_char,
120 dpp_attribute29 VARCHAR2(150) := FND_API.g_miss_char,
121 dpp_attribute30 VARCHAR2(150) := FND_API.g_miss_char,
122 org_id NUMBER := FND_API.g_miss_num,
123 security_group_id NUMBER := FND_API.g_miss_num,
124 claim_currency_code VARCHAR2(15) := FND_API.g_miss_char,
125 min_claim_amt NUMBER := FND_API.g_miss_num,
126 min_claim_amt_line_lvl NUMBER := FND_API.g_miss_num,
127 auto_debit VARCHAR2(1) := FND_API.g_miss_char,
128 days_before_claiming_debit NUMBER := FND_API.g_miss_num,
129 -- Fix for Bug 10056887
130 supplier_neg_batch_flag VARCHAR2(5):= FND_API.g_miss_char,
131 ssd_imd_claim_flag VARCHAR2(1) := FND_API.g_miss_char
132 );
133
134
135 -- -------------------------------------------------------
136 -- Record name supp_code_conversion_rec_type
137 -- -------------------------------------------------------
138 TYPE supp_code_conversion_rec_type IS RECORD
139 (
140 CODE_CONVERSION_ID NUMBER := FND_API.g_miss_num,
141 OBJECT_VERSION_NUMBER NUMBER := FND_API.g_miss_num,
142 LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
143 LAST_UPDATED_BY NUMBER := FND_API.g_miss_num,
144 CREATION_DATE DATE := FND_API.G_MISS_DATE,
145 CREATED_BY NUMBER := FND_API.g_miss_num,
146 LAST_UPDATE_LOGIN NUMBER := FND_API.g_miss_num,
147 ORG_ID NUMBER := FND_API.g_miss_num,
148 SUPP_TRADE_PROFILE_ID NUMBER := FND_API.g_miss_num,
149 CODE_CONVERSION_TYPE VARCHAR2(30) := FND_API.g_miss_char,
150 EXTERNAL_CODE VARCHAR2(240) := FND_API.g_miss_char,
151 INTERNAL_CODE VARCHAR2(240) := FND_API.g_miss_char,
152 DESCRIPTION VARCHAR2(240) := FND_API.g_miss_char,
153 START_DATE_ACTIVE DATE := FND_API.G_MISS_DATE,
154 END_DATE_ACTIVE DATE := FND_API.G_MISS_DATE,
155 ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.g_miss_char,
156 ATTRIBUTE1 VARCHAR2(150) := FND_API.g_miss_char,
157 ATTRIBUTE2 VARCHAR2(150) := FND_API.g_miss_char,
158 ATTRIBUTE3 VARCHAR2(150) := FND_API.g_miss_char,
159 ATTRIBUTE4 VARCHAR2(150) := FND_API.g_miss_char,
160 ATTRIBUTE5 VARCHAR2(150) := FND_API.g_miss_char,
161 ATTRIBUTE6 VARCHAR2(150) := FND_API.g_miss_char,
162 ATTRIBUTE7 VARCHAR2(150) := FND_API.g_miss_char,
163 ATTRIBUTE8 VARCHAR2(150) := FND_API.g_miss_char,
164 ATTRIBUTE9 VARCHAR2(150) := FND_API.g_miss_char,
165 ATTRIBUTE10 VARCHAR2(150) := FND_API.g_miss_char,
166 ATTRIBUTE11 VARCHAR2(150) := FND_API.g_miss_char,
167 ATTRIBUTE12 VARCHAR2(150) := FND_API.g_miss_char,
168 ATTRIBUTE13 VARCHAR2(150) := FND_API.g_miss_char,
169 ATTRIBUTE14 VARCHAR2(150) := FND_API.g_miss_char,
170 ATTRIBUTE15 VARCHAR2(150) := FND_API.g_miss_char,
171 SECURITY_GROUP_ID NUMBER := FND_API.g_miss_num,
172 CODE_CONVERSION_ACTION VARCHAR2(1) --'C'/'U'/'D'
173 );
174
175 -- -------------------------------------------------------
176 -- Record name code_conversion_tbl_type
177 -- -------------------------------------------------------
178 TYPE code_conversion_tbl_type IS TABLE OF supp_code_conversion_rec_type ;
179
180
181
182
183 -- -------------------------------------------------------
184 -- Record name process_setup_rec_type
185 -- -------------------------------------------------------
186
187 TYPE process_setup_rec_type IS RECORD
188 (
189 PROCESS_SETUP_ID NUMBER := FND_API.g_miss_num,
190 OBJECT_VERSION_NUMBER NUMBER := FND_API.g_miss_num,
191 LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
192 LAST_UPDATED_BY NUMBER := FND_API.g_miss_num,
193 CREATION_DATE DATE := FND_API.G_MISS_DATE,
194 CREATED_BY NUMBER := FND_API.g_miss_num,
195 LAST_UPDATE_LOGIN NUMBER := FND_API.g_miss_num,
196 REQUEST_ID NUMBER := FND_API.g_miss_num,
197 PROGRAM_APPLICATION_ID NUMBER := FND_API.g_miss_num,
198 PROGRAM_UPDATE_DATE DATE ,
199 PROGRAM_ID NUMBER := FND_API.g_miss_num,
200 CREATED_FROM VARCHAR2(30) := FND_API.g_miss_char,
201 ORG_ID NUMBER := FND_API.g_miss_num,
202 SUPP_TRADE_PROFILE_ID NUMBER := FND_API.g_miss_num,
203 PROCESS_CODE VARCHAR2(60),
204 ENABLED_FLAG VARCHAR2(30) := 'N',
205 AUTOMATIC_FLAG VARCHAR2(1) := 'N',
206 ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.g_miss_char,
207 ATTRIBUTE1 VARCHAR2(150) := FND_API.g_miss_char,
208 ATTRIBUTE2 VARCHAR2(150) := FND_API.g_miss_char,
209 ATTRIBUTE3 VARCHAR2(150) := FND_API.g_miss_char,
210 ATTRIBUTE4 VARCHAR2(150) := FND_API.g_miss_char,
211 ATTRIBUTE5 VARCHAR2(150) := FND_API.g_miss_char,
212 ATTRIBUTE6 VARCHAR2(150) := FND_API.g_miss_char,
213 ATTRIBUTE7 VARCHAR2(150) := FND_API.g_miss_char,
214 ATTRIBUTE8 VARCHAR2(150) := FND_API.g_miss_char,
215 ATTRIBUTE9 VARCHAR2(150) := FND_API.g_miss_char,
216 ATTRIBUTE10 VARCHAR2(150) := FND_API.g_miss_char,
217 ATTRIBUTE11 VARCHAR2(150) := FND_API.g_miss_char,
218 ATTRIBUTE12 VARCHAR2(150) := FND_API.g_miss_char,
219 ATTRIBUTE13 VARCHAR2(150) := FND_API.g_miss_char,
220 ATTRIBUTE14 VARCHAR2(150) := FND_API.g_miss_char,
221 ATTRIBUTE15 VARCHAR2(150) := FND_API.g_miss_char,
222 SECURITY_GROUP_ID NUMBER := FND_API.g_miss_num
223 ) ;
224
225 -- -------------------------------------------------------
226 -- Record name process_setup_tbl_type
227 -- -------------------------------------------------------
228 TYPE process_setup_tbl_type IS TABLE OF process_setup_rec_type ;
229
230
231
232
233 ---------------------------------------------------------------------
234 -- API Name
235 -- Create_Supp_Trade_Profile
236 --Type
237 -- Public
238 -- PURPOSE
239 -- This procedure creates Supplier trade profile, code conversion record and
240 -- price protection mapping
241 --
242 -- PARAMETERS
243 -- IN
244 -- OUT
245 -- NOTES
246 /*#
247 * This procedure creates a new Ship and Debit Request.
248 * @param p_api_version_number --> Version of the API.
249 * @param p_init_msg_list --> Whether to initialize the message stack.
250 * @param p_commit --> Indicates whether to commit within the program.
251 * @param p_validation_level --> Indicates the level of the validation.
252 * @param x_return_status --> Indicates the status of the program.
253 * @param x_msg_count --> Provides the number of the messages returned by the program.
254 * @param x_msg_data --> Returns messages by the program.
255 * @param p_supp_trade_profile_rec --> Contains details of the new trade profile to be created
256 * @param p_code_conversion_rec_tbl --> Table structure contains the code conversion information for the new trade profile
257 * @param p_price_protection_set_tbl --> Table structure contains the price protection information for the new trade profile
258 * @param x_supp_trade_profile_id --> Returns the id of the created trade profile
259 * @rep:scope public
260 * @rep:lifecycle active
261 * @rep:displayname Create Supplier Trade Profile
262 * @rep:compatibility S
263 * @rep:businessevent None
264 */
265
266 ---------------------------------------------------------------------
267
268
269
270 PROCEDURE Create_Supp_Trade_Profile(
271 p_api_version_number IN NUMBER,
272 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
273 p_commit IN VARCHAR2 := FND_API.G_FALSE,
274 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
275 x_return_status OUT NOCOPY VARCHAR2,
276 x_msg_count OUT NOCOPY NUMBER,
277 x_msg_data OUT NOCOPY VARCHAR2,
278 p_supp_trade_profile_rec IN supp_trade_profile_rec_type ,
279 p_code_conversion_rec_tbl IN code_conversion_tbl_type,
280 p_price_protection_set_tbl IN process_setup_tbl_type,
281 x_supp_trade_profile_id OUT NOCOPY NUMBER,
282 X_created_process_tbl OUT NOCOPY OZF_PROCESS_SETUP_PVT.process_setup_tbl_type,
283 X_created_codes_tbl OUT NOCOPY OZF_CODE_CONVERSION_PVT.supp_code_conversion_tbl_type
284 );
285
286
287 ---------------------------------------------------------------------
288 -- API Name
289 -- Update_Supp_Trade_Profile
290 --Type
291 -- Public
292 -- PURPOSE
293 -- This procedure updates Supplier trade profile and processes code conversion record
294 -- and price protection mapping
295 --
296 -- PARAMETERS
297 -- IN
298 -- OUT
299 -- NOTES
300 /*#
301 * This procedure creates a new Ship and Debit Request.
302 * @param p_api_version_number --> Version of the API.
303 * @param p_init_msg_list --> Whether to initialize the message stack.
304 * @param p_commit --> Indicates whether to commit within the program.
305 * @param p_validation_level --> Indicates the level of the validation.
306 * @param x_return_status --> Indicates the status of the program.
307 * @param x_msg_count --> Provides the number of the messages returned by the program.
308 * @param x_msg_data --> Returns messages by the program.
309 * @param p_supp_trade_profile_rec --> Contains details of the new trade profile to be updated
310 * @param p_code_conversion_rec_tbl --> Table structure contains the code conversion information for the respective trade profile
311 * @param p_price_protection_set_tbl --> Table structure contains the price protection information for the respective trade profile
312 * @rep:scope public
313 * @rep:lifecycle active
314 * @rep:displayname Update Supplier Trade Profile
315 * @rep:compatibility S
316 * @rep:businessevent None
317 */
318
319 ---------------------------------------------------------------------
320
321 PROCEDURE Update_Supp_Trade_Profile(
322 p_api_version_number IN NUMBER,
323 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
324 p_commit IN VARCHAR2 := FND_API.G_FALSE,
325 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
326 x_return_status OUT NOCOPY VARCHAR2,
327 x_msg_count OUT NOCOPY NUMBER,
328 x_msg_data OUT NOCOPY VARCHAR2,
329 p_supp_trade_profile_rec IN supp_trade_profile_rec_type ,
330 p_code_conversion_rec_tbl IN code_conversion_tbl_type,
331 p_price_protection_set_tbl IN process_setup_tbl_type,
332 X_created_process_tbl OUT NOCOPY OZF_PROCESS_SETUP_PVT.process_setup_tbl_type,
333 X_updated_process_tbl OUT NOCOPY OZF_PROCESS_SETUP_PVT.process_setup_tbl_type,
334 X_created_codes_tbl OUT NOCOPY OZF_CODE_CONVERSION_PVT.supp_code_conversion_tbl_type,
335 X_updated_codes_tbl OUT NOCOPY OZF_CODE_CONVERSION_PVT.supp_code_conversion_tbl_type,
336 X_deleted_codes_tbl OUT NOCOPY OZF_CODE_CONVERSION_PVT.supp_code_conversion_tbl_type
337 );
338
339
340 ---------------------------------------------------------------------
341 -- API Name
342 -- Update_Supp_Trade_Profile
343 --Type
344 -- Public
345 -- PURPOSE
346 -- This procedure updates Supplier trade profile
347 --
348 -- PARAMETERS
349 -- IN
350 -- OUT
351 -- NOTES
352 /*#
353 * This procedure creates a new Ship and Debit Request.
354 * @param p_api_version_number --> Version of the API.
355 * @param p_init_msg_list --> Whether to initialize the message stack.
356 * @param p_commit --> Indicates whether to commit within the program.
357 * @param p_validation_level --> Indicates the level of the validation.
358 * @param x_return_status --> Indicates the status of the program.
359 * @param x_msg_count --> Provides the number of the messages returned by the program.
360 * @param x_msg_data --> Returns messages by the program.
361 * @param p_supp_trade_profile_rec --> Contains details of the new trade profile to be updated
362 * @rep:scope public
363 * @rep:lifecycle active
364 * @rep:displayname Update Supplier Trade Profile
365 * @rep:compatibility S
366 * @rep:businessevent None
367 */
368
369 ---------------------------------------------------------------------
370
371 PROCEDURE Update_Supp_Trade_Profile(
372 p_api_version_number IN NUMBER,
373 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
374 p_commit IN VARCHAR2 := FND_API.G_FALSE,
375 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
376 x_return_status OUT NOCOPY VARCHAR2,
377 x_msg_count OUT NOCOPY NUMBER,
378 x_msg_data OUT NOCOPY VARCHAR2,
379 p_supp_trade_profile_rec IN supp_trade_profile_rec_type
380 );
381
382
383 ---------------------------------------------------------------------
384 -- API Name
385 -- Process_code_conversion
386 --Type
387 -- Public
388 -- PURPOSE
389 -- This procedure creates/updates/deletes the code conversion details
390 --
391 -- PARAMETERS
392 -- IN
393 -- OUT
394 -- NOTES
395 /*#
396 * This procedure creates a new Ship and Debit Request.
397 * @param p_api_version_number --> Version of the API.
398 * @param p_init_msg_list --> Whether to initialize the message stack.
399 * @param p_commit --> Indicates whether to commit within the program.
400 * @param p_validation_level --> Indicates the level of the validation.
401 * @param x_return_status --> Indicates the status of the program.
402 * @param x_msg_count --> Provides the number of the messages returned by the program.
403 * @param x_msg_data --> Returns messages by the program.
404 * @param p_code_conversion_tbl --> Table structure contains the code conversion information
405 * @rep:scope public
406 * @rep:lifecycle active
407 * @rep:displayname Update Supplier Trade Profile
408 * @rep:compatibility S
409 * @rep:businessevent None
410 */
411
412 ---------------------------------------------------------------------
413 PROCEDURE Process_code_conversion(
414 p_api_version_number IN NUMBER,
415 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
416 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
417 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
418 x_return_status OUT NOCOPY VARCHAR2,
419 x_msg_count OUT NOCOPY NUMBER,
420 x_msg_data OUT NOCOPY VARCHAR2,
421 p_code_conversion_tbl IN code_conversion_tbl_type ,
422 X_created_code_con_tbl OUT NOCOPY OZF_CODE_CONVERSION_PVT.supp_code_conversion_tbl_type ,
423 X_updated_code_con_tbl OUT NOCOPY OZF_CODE_CONVERSION_PVT.supp_code_conversion_tbl_type ,
424 X_deleted_code_con_tbl OUT NOCOPY OZF_CODE_CONVERSION_PVT.supp_code_conversion_tbl_type);
425
426
427
428
429
430
431 ---------------------------------------------------------------------
432 -- API Name
433 -- Process_price_protection
434 --Type
435 -- Public
436 -- PURPOSE
437 -- This procedure creates/updates the price protection details
438 --
439 -- PARAMETERS
440 -- IN
441 -- OUT
442 -- NOTES
443 /*#
444 * This procedure creates a new Ship and Debit Request.
445 * @param p_api_version_number --> Version of the API.
446 * @param p_init_msg_list --> Whether to initialize the message stack.
447 * @param p_commit --> Indicates whether to commit within the program.
448 * @param p_validation_level --> Indicates the level of the validation.
449 * @param x_return_status --> Indicates the status of the program.
450 * @param x_msg_count --> Provides the number of the messages returned by the program.
451 * @param x_msg_data --> Returns messages by the program.
452 * @param p_process_setup_tbl --> Table structure contains the price protection information
453 * @rep:scope public
454 * @rep:lifecycle active
455 * @rep:displayname Update Supplier Trade Profile
456 * @rep:compatibility S
457 * @rep:businessevent None
458 */
459
460 ---------------------------------------------------------------------
461
462 PROCEDURE Process_price_protection(
463 P_Api_Version_Number IN NUMBER,
464 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
465 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
466 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
467 X_Return_Status OUT NOCOPY VARCHAR2,
468 X_Msg_Count OUT NOCOPY NUMBER,
469 X_Msg_Data OUT NOCOPY VARCHAR2,
470 p_trade_prf_id IN NUMBER,
471 p_process_setup_tbl IN process_setup_tbl_type ,
472 X_created_process_tbl OUT NOCOPY OZF_PROCESS_SETUP_PVT.process_setup_tbl_type,
473 X_updated_process_tbl OUT NOCOPY OZF_PROCESS_SETUP_PVT.process_setup_tbl_type);
474
475
476
477
478 END OZF_SUPP_TRADE_PROFILE_PUB;
479
480
481