1 PACKAGE PV_PARTNER_PROGRAM_PVT AUTHID CURRENT_USER as
2 /* $Header: pvxvprgs.pls 120.0 2005/05/27 16:17:58 appldev noship $ */
3 -- ===============================================================
4 -- Start of Comments
5 -- Package name
6 -- PV_Partner_Program_PVT
7 -- Purpose
8 --
9 -- History
10 -- 28-FEB-2002 Ravi.Mikkilineni Created
11 -- 1-APR-2002 Peter.Nixon Modified
12 -- - MEMBERSHIP columns (4) made nullable
13 -- - removed SOURCE_LANG column
14 -- 22-APR-2002 Peter.Nixon Modified
15 -- - restored SOURCE_LANG column
16 -- - removed PROGRAM_SHORT_NAME column
17 -- - changed PROGRAM_SETUP_TYPE column to PROGRAM_TYPE_ID
18 -- - added CUSTOM_SETUP_ID column
19 -- - added ENABLED_FLAG column
20 -- - added ATTRIBUTE_CATEGORY column
21 -- - added ATTRIBUTE1 thru ATTRIBUTE15 columns
22 -- 09-Sep-2002 - added columns inventory_item_id ,inventory_item_org_id,
23 -- bus_user_resp_id ,admin_resp_id,no_fee_flag,qsnr_ttl_all_page_dsp_flag ,
24 -- qsnr_hdr_all_page_dsp_flag ,qsnr_ftr_all_page_dsp_flag ,allow_enrl_wout_chklst_flag,
25 -- qsnr_title ,qsnr_header,qsnr_footer
26 -- 10-Sep-2002 - removed columns membership_fees and membership_currency_names
27 -- 12/04/2002 SVEERAVE added Close_Ended_programs that will close the ended programs.
28 -- 12/04/2002 SVEERAVE added check_price_exists function.
29 -- 01/21/2003 SVEERAVE added Get_Object_Name procedure for integration with OCM
30 -- 06/27/2003 pukken Code changes for 3 new columns for 11.5.10 enhancements
31 -- 07/24/2003 ktsao Code changes for program copy functionality
32 -- 04/11/2005 ktsao Code changes for create_inv_item_if_not_exists
33 -- NOTE
34 --
35 -- Copyright (c) 2002 Oracle Corporation Redwood Shores, California, USA
36 -- All rights reserved.
37 --
38 -- -------------------------------------------------------
39 -- Record name
40 -- ptr_prgm_rec_type
41 -- -------------------------------------------------------
42 -- Parameters:
43 -- program_id
44 -- PROGRAM_TYPE_ID
45 -- custom_setup_id
46 -- program_level_code
47 -- program_parent_id
48 -- program_owner_resource_id
49 -- program_start_date
50 -- program_end_date
51 -- allow_enrl_until_date
52 -- citem_version_id
53 -- membership_valid_period
54 -- membership_period_unit
55 -- process_rule_id
56 -- prereq_process_rule_Id
57 -- program_status_code
58 -- submit_child_nodes
59 -- inventory_item_id
60 -- inventory_item_org_id
61 -- bus_user_resp_id
62 -- admin_resp_id
63 -- no_fee_flag
64 -- vad_invite_allow_flag
65 -- global_mmbr_reqd_flag
66 -- waive_subsidiary_fee_flag
67 -- qsnr_ttl_all_page_dsp_flag
68 -- qsnr_hdr_all_page_dsp_flag
69 -- qsnr_ftr_all_page_dsp_flag
70 -- allow_enrl_wout_chklst_flag
71 -- user_status_id
72 -- enabled_flag
73 -- attribute_category
74 -- attribute1
75 -- attribute2
76 -- attribute3
77 -- attribute4
78 -- attribute5
79 -- attribute6
80 -- attribute7
81 -- attribute8
82 -- attribute9
83 -- attribute10
84 -- attribute11
85 -- attribute12
86 -- attribute13
87 -- attribute14
88 -- attribute15
89 -- last_update_date
90 -- last_updated_by
91 -- creation_date
92 -- created_by
93 -- last_update_login
94 -- object_version_number
95 -- program_name
96 -- program_description
97 -- source_lang
98 -- qsnr_title
99 -- qsnr_header
100 -- qsnr_footer
101 --
102 -- Required
103 --
104 -- Defaults
105 --
106 -- Note: This is automatic generated record definition, it includes all columns
107 -- defined in the table, developer must manually add or delete some of the attributes.
108 --
109 -- End of Comments
110
111 --===================================================================
112 TYPE ptr_prgm_rec_type IS RECORD
113 (
114
115 program_id NUMBER
116 ,PROGRAM_TYPE_ID NUMBER
117 ,custom_setup_id NUMBER
118 ,program_level_code VARCHAR2(15)
119 ,program_parent_id NUMBER
120 ,program_owner_resource_id NUMBER
121 ,program_start_date DATE
122 ,program_end_date DATE
123 ,allow_enrl_until_date DATE
124 ,citem_version_id NUMBER
125 ,membership_valid_period NUMBER
126 ,membership_period_unit VARCHAR2(30)
127 ,process_rule_id NUMBER
128 ,prereq_process_rule_Id NUMBER
129 ,program_status_code VARCHAR2(30)
130 ,submit_child_nodes VARCHAR2(1)
131 ,inventory_item_id NUMBER
132 ,inventory_item_org_id NUMBER
133 ,bus_user_resp_id NUMBER
134 ,admin_resp_id NUMBER
135 ,no_fee_flag VARCHAR2(1)
136 ,vad_invite_allow_flag VARCHAR2(1)
137 ,global_mmbr_reqd_flag VARCHAR2(1)
138 ,waive_subsidiary_fee_flag VARCHAR2(1)
139 ,qsnr_ttl_all_page_dsp_flag VARCHAR2(1)
140 ,qsnr_hdr_all_page_dsp_flag VARCHAR2(1)
141 ,qsnr_ftr_all_page_dsp_flag VARCHAR2(1)
142 ,allow_enrl_wout_chklst_flag VARCHAR2(1)
143 ,user_status_id NUMBER
144 ,enabled_flag VARCHAR2(1)
145 ,attribute_category VARCHAR2(30)
146 ,attribute1 VARCHAR2(150)
147 ,attribute2 VARCHAR2(150)
148 ,attribute3 VARCHAR2(150)
149 ,attribute4 VARCHAR2(150)
150 ,attribute5 VARCHAR2(150)
151 ,attribute6 VARCHAR2(150)
152 ,attribute7 VARCHAR2(150)
153 ,attribute8 VARCHAR2(150)
154 ,attribute9 VARCHAR2(150)
155 ,attribute10 VARCHAR2(150)
156 ,attribute11 VARCHAR2(150)
157 ,attribute12 VARCHAR2(150)
158 ,attribute13 VARCHAR2(150)
159 ,attribute14 VARCHAR2(150)
160 ,attribute15 VARCHAR2(150)
161 ,last_update_date DATE
162 ,last_updated_by NUMBER
163 ,creation_date DATE
164 ,created_by NUMBER
165 ,last_update_login NUMBER
166 ,object_version_number NUMBER
167 ,program_name VARCHAR2(60)
168 ,program_description VARCHAR2(240)
169 ,source_lang VARCHAR2(60)
170 ,qsnr_title VARCHAR2(200)
171 ,qsnr_header VARCHAR2(1600)
172 ,qsnr_footer VARCHAR2(1600)
173 -- added by sranka, for Inventory creation, but its not part of the Table
174 ,membership_fees NUMBER
175 );
176
177 g_miss_ptr_prgm_rec ptr_prgm_rec_type;
178 TYPE partner_program_tbl_type IS TABLE OF ptr_prgm_rec_type INDEX BY BINARY_INTEGER;
179 g_miss_partner_program_tbl partner_program_tbl_type;
180
181 -- ==============================================================================
182 -- Start of Comments
183 -- ==============================================================================
184 -- API Name
185 -- Create_Partner_Program
186 -- Type
187 -- Private
188 -- Pre-Req
189 --
190 -- Parameters
191 --
192 -- IN
193 -- p_api_version_number IN NUMBER Required
194 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
195 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
196 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
197 -- p_ptr_prgm_rec IN ptr_prgm_rec_type Required
198 --
199 -- OUT
200 -- x_return_status OUT VARCHAR2
201 -- x_msg_count OUT NUMBER
202 -- x_msg_data OUT VARCHAR2
203 -- Version : Current version 1.0
204 -- Note: This automatic generated PROCEDURE definition, it includes standard IN/OUT parameters
205 -- and basic operation, developer must manually add parameters and business logic as necessary.
206 --
207 -- End of Comments
208 -- ==============================================================================
209 --
210 PROCEDURE Create_Partner_Program(
211 p_api_version_number IN NUMBER
212 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
213 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
214 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
215 ,p_ptr_prgm_rec IN ptr_prgm_rec_type := g_miss_ptr_prgm_rec
216 ,p_identity_resource_id IN NUMBER
217 ,x_return_status OUT NOCOPY VARCHAR2
218 ,x_msg_count OUT NOCOPY NUMBER
219 ,x_msg_data OUT NOCOPY VARCHAR2
220 ,x_program_id OUT NOCOPY NUMBER
221 );
222
223
224
225
226 -- ==============================================================================
227 -- Start of Comments
228 -- ==============================================================================
229 -- API Name
230 -- Update_Partner_Program
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_ptr_prgm_rec IN ptr_prgm_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 PROCEDURE Update_Partner_Program(
256 p_api_version_number IN NUMBER
257 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
258 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
259 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
260
261 ,x_return_status OUT NOCOPY VARCHAR2
262 ,x_msg_count OUT NOCOPY NUMBER
263 ,x_msg_data OUT NOCOPY VARCHAR2
264
265 ,p_ptr_prgm_rec IN ptr_prgm_rec_type
266 );
267
268
269
270
271 -- ==============================================================================
272 -- Start of Comments
273 -- ==============================================================================
274 -- API Name
275 -- Delete_Partner_Program
276 -- This procedure performs a soft delete by calling the UPDATE table handler
277 -- and setting ENABLED_FLAG to 'N'.
278 -- Type
279 -- Private
280 -- Pre-Req
281 --
282 -- Parameters
283 --
284 -- IN
285 -- p_api_version_number IN NUMBER Required
286 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
287 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
288 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
289 -- p_program_id IN NUMBER
290 -- p_object_version_number IN NUMBER Optional Default = NULL
291 --
292 -- OUT
293 -- x_return_status OUT VARCHAR2
294 -- x_msg_count OUT NUMBER
295 -- x_msg_data OUT VARCHAR2
296 -- Version : Current version 1.0
297 -- Note: This automatic generated PROCEDURE definition, it includes standard IN/OUT parameters
298 -- and basic operation, developer must manually add parameters and business logic as necessary.
299 --
300 -- End of Comments
301 -- ==============================================================================
302 --
303 PROCEDURE Delete_Partner_Program(
304 p_api_version_number IN NUMBER
305 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
306 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
310 ,x_msg_data OUT NOCOPY VARCHAR2
307 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
308 ,x_return_status OUT NOCOPY VARCHAR2
309 ,x_msg_count OUT NOCOPY NUMBER
311 ,p_program_id IN NUMBER
312 ,p_object_version_number IN NUMBER
313 );
314
315
316
317
318 -- ==============================================================================
319 -- Start of Comments
320 -- ==============================================================================
321 -- API Name
322 -- Lock_Partner_Program
323 -- Type
324 -- Private
325 -- Pre-Req
326 --
327 -- Parameters
328 --
329 -- IN
330 -- p_api_version_number IN NUMBER Required
331 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
332 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
333 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
334 -- p_ptr_prgm_rec IN ptr_prgm_rec_type Required
335 --
336 -- OUT
337 -- x_return_status OUT VARCHAR2
338 -- x_msg_count OUT NUMBER
339 -- x_msg_data OUT VARCHAR2
340 -- Version : Current version 1.0
341 -- Note: This automatic generated PROCEDURE definition, it includes standard IN/OUT parameters
342 -- and basic operation, developer must manually add parameters and business logic as necessary.
343 --
344 -- End of Comments
345 -- ==============================================================================
346 --
347 PROCEDURE Lock_Partner_Program(
348 p_api_version_number IN NUMBER
349 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
350
351 ,x_return_status OUT NOCOPY VARCHAR2
352 ,x_msg_count OUT NOCOPY NUMBER
353 ,x_msg_data OUT NOCOPY VARCHAR2
354
355 ,px_program_id IN NUMBER
356 ,p_object_version IN NUMBER
357 );
358
359
360
361
362 -- ==============================================================================
363 -- Start of Comments
364 -- ==============================================================================
365 -- API Name
366 -- Validate_partner_program
367 --
368 -- p_validation_mode is a constant defined in null_UTILITY_PVT package
369 -- For create: G_CREATE, for update: G_UPDATE
370 -- Note: 1. This is automated generated item level validation PROCEDURE.
371 -- The actual validation detail is needed to be added.
372 -- 2. We can also validate table instead of record. There will be an option for user to choose.
373 -- ==============================================================================
374 -- End of Comments
375 -- ==============================================================================
376 PROCEDURE Validate_partner_program(
377 p_api_version_number IN NUMBER
378 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
379 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
380 ,p_ptr_prgm_rec IN ptr_prgm_rec_type
381 ,p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.G_UPDATE
382 ,x_return_status OUT NOCOPY VARCHAR2
383 ,x_msg_count OUT NOCOPY NUMBER
384 ,x_msg_data OUT NOCOPY VARCHAR2
385 );
386
387
388
389 -- ==============================================================================
390 -- Start of Comments
391 -- ==============================================================================
392 -- API Name
393 -- Check_Items
394 --
395 -- p_validation_mode is a constant defined in null_UTILITY_PVT package
396 -- For create: G_CREATE, for update: G_UPDATE
397 -- Note: 1. This is automated generated item level validation PROCEDURE.
398 -- The actual validation detail is needed to be added.
399 -- 2. Validate the unique keys, lookups here
400 -- ==============================================================================
401 -- End of Comments
402 -- ==============================================================================
403 PROCEDURE Check_Items (
404 p_ptr_prgm_rec IN ptr_prgm_rec_type
405 ,p_validation_mode IN VARCHAR2
406 ,x_return_status OUT NOCOPY VARCHAR2
407 );
408
409
410
411
412 -- ==============================================================================
413 -- Start of Comments
414 -- ==============================================================================
415 -- API Name
416 -- Validate_Rec
417 -- Record level validation procedures
418 --
419 -- p_validation_mode is a constant defined in null_UTILITY_PVT package
420 -- For create: G_CREATE, for update: G_UPDATE
421 -- Note: 1. This is automated generated item level validation PROCEDURE.
422 -- The actual validation detail is needed to be added.
423 -- 2. Developer can manually added inter-field level validation.
424 -- ==============================================================================
425 -- End of Comments
429 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
426 -- ==============================================================================
427 PROCEDURE Validate_Rec(
428 p_api_version_number IN NUMBER
430 ,x_return_status OUT NOCOPY VARCHAR2
431 ,x_msg_count OUT NOCOPY NUMBER
432 ,x_msg_data OUT NOCOPY VARCHAR2
433 ,p_ptr_prgm_rec IN ptr_prgm_rec_type
434 ,p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_UPDATE
435 );
436
437
438
439
440 -- ==============================================================================
441 -- Start of Comments
442 -- ==============================================================================
443 -- API Name
444 -- Complete_Rec
445 --
446 -- p_validation_mode is a constant defined in null_UTILITY_PVT package
447 -- For create: G_CREATE, for update: G_UPDATE
448 -- Note: 1. This is automated generated item level validation PROCEDURE.
449 -- The actual validation detail is needed to be added.
450 -- 2. Developer can manually added inter-field level validation.
451 -- ==============================================================================
452 -- End of Comments
453 -- ==============================================================================
454 PROCEDURE Complete_Rec (
455 p_ptr_prgm_rec IN ptr_prgm_rec_type
456 ,x_complete_rec OUT NOCOPY ptr_prgm_rec_type
457 );
458
459
460 PROCEDURE create_inventory_item(
461 p_ptr_prgm_rec IN ptr_prgm_rec_type,
462 x_Item_rec OUT NOCOPY INV_Item_GRP.Item_rec_type,
463 x_return_status OUT NOCOPY VARCHAR2,
464 x_Error_tbl OUT NOCOPY INV_Item_GRP.Error_tbl_type
465 );
466
467 PROCEDURE create_pricelist_line(
468 p_ptr_prgm_rec IN ptr_prgm_rec_type,
469 p_inventory_item_id IN NUMBER,
470 p_operation IN VARCHAR2,
471 -- The following two variables will be used in case of Update only
472 p_list_header_id IN NUMBER,
473 p_pricing_attribute_id IN NUMBER,
474
475 x_return_status OUT NOCOPY VARCHAR2,
476 x_pricelist_line_id OUT NOCOPY NUMBER,
477 x_msg_count OUT NOCOPY NUMBER,
478 x_msg_data OUT NOCOPY VARCHAR2
479 );
480
481 --------------------------------------------------------------------------
482 -- PROCEDURE
483 -- Close_Ended_programs
484 --
485 -- PURPOSE
486 -- close all the partner programs which are end dated.
487 -- IN
488 -- std. conc. request parameters.
489 -- ERRBUF
490 -- RETCODE
491 -- OUT
492 -- USED BY
493 -- Concurrent program
494 -- HISTORY
495 -- 12/04/2002 sveerave CREATION
496 --------------------------------------------------------------------------
497
498
499 PROCEDURE Close_Ended_programs(
500 ERRBUF OUT NOCOPY VARCHAR2,
501 RETCODE OUT NOCOPY VARCHAR2 );
502
503 --------------------------------------------------------------------------
504 -- PROCEDURE
505 -- check_price_exists
506 --
507 -- PURPOSE
508 -- Checks whether any price exists for a given program.
509 -- IN
510 -- program_id NUMBER
511 -- OUT
512 -- 'Y' if exists
513 -- 'N' if not exists
514 -- USED BY
515 -- Program Approval API, and Activate API.
516 -- HISTORY
517 -- 12/04/2002 sveerave CREATION
518 --------------------------------------------------------------------------
519
520 FUNCTION check_price_exists(p_program_id IN NUMBER)
521 RETURN VARCHAR2;
522
523 --------------------------------------------------------------------------
524 -- PROCEDURE
525 -- Get_Object_Name
526 --
527 -- PURPOSE
528 -- Provides the program name to Oracle Content Manager given program_id.
529 -- This is needed so that IBC can display correct program name in their UI.
530 -- IN
531 -- p_association_type_code -- should be the association type code for Program in IBC, 'PV_PRGM'
532 -- p_associated_object_val_1 -- object_id, i.e. program_id
533 -- p_associated_object_val_2 -- optional
534 -- p_associated_object_val_3 -- optional
535 -- p_associated_object_val_4 -- optional
536 -- p_associated_object_val_5 -- optional
537
538 -- OUT
539 -- x_object_name program_name
540 -- x_object_code None
541 -- x_return_status return status
542 -- x_msg_count std. out params
543 -- x_msg_data std. out params
544
545 -- USED BY
546 -- IBC User Interfaces
547 -- HISTORY
548 -- 01/21/2003 sveerave CREATION
549 --------------------------------------------------------------------------
550 PROCEDURE Get_Object_Name
551 (
552 p_association_type_code IN VARCHAR2
553 ,p_associated_object_val_1 IN VARCHAR2
554 ,p_associated_object_val_2 IN VARCHAR2 DEFAULT NULL
555 ,p_associated_object_val_3 IN VARCHAR2 DEFAULT NULL
556 ,p_associated_object_val_4 IN VARCHAR2 DEFAULT NULL
557 ,p_associated_object_val_5 IN VARCHAR2 DEFAULT NULL
558 ,x_object_name OUT NOCOPY VARCHAR2
559 ,x_object_code OUT NOCOPY VARCHAR2
560 ,x_return_status OUT NOCOPY VARCHAR2
561 ,x_msg_count OUT NOCOPY NUMBER
562 ,x_msg_data OUT NOCOPY VARCHAR2
563 );
564
565
566 -- ==============================================================================
567 -- Start of Comments
568 -- ==============================================================================
569 -- API Name
570 -- Copy_Program
571 -- Type
572 -- Private
573 -- Pre-Req
574 --
575 -- Parameters
576 --
577 -- IN
578 -- p_api_version_number IN NUMBER Required
579 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
580 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
581 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
582 -- p_source_object_id IN NUMBER
583 -- p_attributes_table IN AMS_CpyUtility_PVT.copy_attributes_table_type Required
584 -- p_copy_columns_table IN AMS_CpyUtility_PVT.copy_columns_table_type Required
585 --
586 -- OUT
587 -- x_return_status OUT VARCHAR2
588 -- x_msg_count OUT NUMBER
589 -- x_msg_data OUT VARCHAR2
590 -- x_new_object_id OUT NUMBER
591 -- x_custom_setup_id OUT NUMBER
592 --
593 -- End of Comments
594 -- ==============================================================================
595
596 PROCEDURE Copy_Program
597 (
598 p_api_version_number IN NUMBER
599 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
600 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
601 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
602 ,x_return_status OUT NOCOPY VARCHAR2
603 ,x_msg_count OUT NOCOPY NUMBER
604 ,x_msg_data OUT NOCOPY VARCHAR2
605 ,p_source_object_id IN NUMBER
606 --,p_identity_resource_id IN NUMBER
607 ,p_attributes_table IN AMS_CpyUtility_PVT.copy_attributes_table_type
608 ,p_copy_columns_table IN AMS_CpyUtility_PVT.copy_columns_table_type
609 ,x_new_object_id OUT NOCOPY NUMBER
610 ,x_custom_setup_id OUT NOCOPY NUMBER
611 );
612
613 PROCEDURE Copy_Qualifications
614 (
615 p_api_version_number IN NUMBER
616 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
617 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
618 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
619 ,x_return_status OUT NOCOPY VARCHAR2
620 ,x_msg_count OUT NOCOPY NUMBER
621 ,x_msg_data OUT NOCOPY VARCHAR2
622 ,p_object_type IN VARCHAR2
623 ,p_src_object_id IN NUMBER
624 ,p_tar_object_id IN NUMBER
625 ,p_identity_resource_id IN NUMBER
626 );
627
628 PROCEDURE Copy_Benefits
629 (
630 p_api_version_number IN NUMBER
631 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
632 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
633 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
634 ,x_return_status OUT NOCOPY VARCHAR2
635 ,x_msg_count OUT NOCOPY NUMBER
636 ,x_msg_data OUT NOCOPY VARCHAR2
637 ,p_object_type IN VARCHAR2
638 ,p_src_object_id IN NUMBER
639 ,p_tar_object_id IN NUMBER
640 );
641
642 PROCEDURE Copy_Payments
643 (
644 p_api_version_number IN NUMBER
645 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
646 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
647 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
648 ,x_return_status OUT NOCOPY VARCHAR2
649 ,x_msg_count OUT NOCOPY NUMBER
650 ,x_msg_data OUT NOCOPY VARCHAR2
651 ,p_object_type IN VARCHAR2
652 ,p_src_object_id IN NUMBER
653 ,p_tar_object_id IN NUMBER
654 );
655
656 PROCEDURE Copy_Legal_Terms
657 (
658 p_api_version_number IN NUMBER
659 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
660 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
661 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
662 ,x_return_status OUT NOCOPY VARCHAR2
663 ,x_msg_count OUT NOCOPY NUMBER
664 ,x_msg_data OUT NOCOPY VARCHAR2
665 ,p_object_type IN VARCHAR2
666 ,p_src_object_id IN NUMBER
667 ,p_tar_object_id IN NUMBER
668 );
669
670 PROCEDURE Copy_Questionnaire
671 (
672 p_api_version_number IN NUMBER
673 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
674 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
675 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
676 ,x_return_status OUT NOCOPY VARCHAR2
677 ,x_msg_count OUT NOCOPY NUMBER
678 ,x_msg_data OUT NOCOPY VARCHAR2
679 ,p_object_type IN VARCHAR2
680 ,p_src_object_id IN NUMBER
681 ,p_tar_object_id IN NUMBER
682 );
683
684 PROCEDURE Copy_Notif_Rules
685 (
686 p_api_version_number IN NUMBER
687 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
688 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
689 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
690 ,x_return_status OUT NOCOPY VARCHAR2
691 ,x_msg_count OUT NOCOPY NUMBER
692 ,x_msg_data OUT NOCOPY VARCHAR2
693 ,p_object_type IN VARCHAR2
694 ,p_src_object_id IN NUMBER
695 ,p_tar_object_id IN NUMBER
696 );
697
698 PROCEDURE Copy_Checklist
699 (
700 p_api_version_number IN NUMBER
701 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
702 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
703 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
704 ,x_return_status OUT NOCOPY VARCHAR2
705 ,x_msg_count OUT NOCOPY NUMBER
706 ,x_msg_data OUT NOCOPY VARCHAR2
707 ,p_object_type IN VARCHAR2
708 ,p_src_object_id IN NUMBER
709 ,p_tar_object_id IN NUMBER
710 );
711
712 /*
713 PROCEDURE Copy_Team
714 (
715 p_api_version_number IN NUMBER
716 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
717 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
718 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
719 ,x_return_status OUT NOCOPY VARCHAR2
720 ,x_msg_count OUT NOCOPY NUMBER
721 ,x_msg_data OUT NOCOPY VARCHAR2
722 ,p_object_type IN VARCHAR2
723 ,p_src_object_id IN NUMBER
724 ,p_tar_object_id IN NUMBER
725 );
726 */
727 PROCEDURE create_prereqruleid(
728 p_api_version_number IN NUMBER
729 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
730 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
731 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
732 ,p_program_id IN NUMBER
733 ,p_identity_resource_id IN NUMBER
734 ,l_prereq_rule_id OUT NOCOPY NUMBER
735 ,x_return_status OUT NOCOPY VARCHAR2
736 ,x_msg_count OUT NOCOPY NUMBER
737 ,x_msg_data OUT NOCOPY VARCHAR2
738 );
739
740 PROCEDURE create_inv_item_if_not_exists(
741 p_api_version_number IN NUMBER
742 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
743 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
744 ,p_program_id IN NUMBER
745 ,p_update_program_table IN VARCHAR2
746 ,x_return_status OUT NOCOPY VARCHAR2
747 ,x_msg_count OUT NOCOPY NUMBER
748 ,x_msg_data OUT NOCOPY VARCHAR2
749 ,x_inventory_item_id OUT NOCOPY NUMBER
750 ,x_inventory_item_org_id OUT NOCOPY NUMBER
751 );
752
753 END PV_Partner_Program_PVT;
[Home] [Help]