1 package Pv_Enrq_Bins_PVT as
2 /* $Header: pvxvbins.pls 120.0 2005/05/27 16:18:19 appldev noship $*/
3
4
5
6 TYPe enrq_param_ref IS REF CURSOR;
7
8 PROCEDURE new_programs
9 (
10 p_api_version_number IN NUMBER
11 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
12 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
13 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
14 ,p_partner_id IN NUMBER
15 ,p_member_type IN VARCHAR2
16 ,p_isprereq_eval IN VARCHAR2 :='Y'
17 ,x_enrq_param_cur OUT NOCOPY enrq_param_ref
18 ,x_return_status OUT NOCOPY VARCHAR2
19 ,x_msg_count OUT NOCOPY NUMBER
20 ,x_msg_data OUT NOCOPY VARCHAR2
21 );
22
23
24
25 PROCEDURE renewable_programs
26 (
27 p_api_version_number IN NUMBER
28 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
29 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
30 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
31 ,p_partner_id IN NUMBER
32 ,p_member_type IN VARCHAR2
33 ,p_isprereq_eval IN VARCHAR2 :='Y'
34 ,x_enrq_param_cur OUT NOCOPY enrq_param_ref
35 ,x_return_status OUT NOCOPY VARCHAR2
36 ,x_msg_count OUT NOCOPY NUMBER
37 ,x_msg_data OUT NOCOPY VARCHAR2
38 );
39
40
41 PROCEDURE upgradable_programs
42 (
43 p_api_version_number IN NUMBER
44 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
45 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
46 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
47 ,p_partner_id IN NUMBER
48 ,p_member_type IN VARCHAR2
49 ,p_isprereq_eval IN VARCHAR2 :='Y'
50 ,x_enrq_param_cur OUT NOCOPY enrq_param_ref
51 ,x_return_status OUT NOCOPY VARCHAR2
52 ,x_msg_count OUT NOCOPY NUMBER
53 ,x_msg_data OUT NOCOPY VARCHAR2
54 );
55
56
57
58
59 PROCEDURE incomplete_programs
60 (
61 p_api_version_number IN NUMBER
62 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
63 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
64 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
65 ,p_partner_id IN NUMBER
66 ,p_member_type IN VARCHAR2
67 ,p_isprereq_eval IN VARCHAR2 :='Y'
68 ,x_enrq_param_cur OUT NOCOPY enrq_param_ref
69 ,x_return_status OUT NOCOPY VARCHAR2
70 ,x_msg_count OUT NOCOPY NUMBER
71 ,x_msg_data OUT NOCOPY VARCHAR2
72 );
73
74
75 PROCEDURE newAndInCompletePrograms
76 (
77 p_api_version_number IN NUMBER
78 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
79 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
80 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
81 ,p_partner_id IN NUMBER
82 ,p_member_type IN VARCHAR2
83 ,p_isprereq_eval IN VARCHAR2 :='Y'
84 ,x_enrq_param_cur OUT NOCOPY enrq_param_ref
85 ,x_return_status OUT NOCOPY VARCHAR2
86 ,x_msg_count OUT NOCOPY NUMBER
87 ,x_msg_data OUT NOCOPY VARCHAR2
88 );
89
90 PROCEDURE isPartnerEligible
91 (
92 p_api_version_number IN NUMBER
93 , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
94 , p_commit IN VARCHAR2 := FND_API.G_FALSE
95 , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
96 , p_partner_id IN NUMBER
97 , p_from_program_id IN NUMBER
98 , p_to_program_id IN NUMBER
99 , p_enrq_type IN VARCHAR -- permitted values here are 'NEW', 'UPGRADE' for 11.5.10.
100 , x_elig_flag OUT NOCOPY VARCHAR2 -- PASS 'Y' if eligible, PASS 'N' if not eligible
101 , x_return_status OUT NOCOPY VARCHAR2
102 , x_msg_count OUT NOCOPY NUMBER
103 , x_msg_data OUT NOCOPY VARCHAR2
104 );
105
106 END Pv_Enrq_Bins_PVT;