1 Package ota_cert_mbr_enrollment_swi As
2 /* $Header: otcmeswi.pkh 120.0 2005/06/03 08:32 appldev noship $ */
3 -- ----------------------------------------------------------------------------
4 -- |----------------------< create_cert_mbr_enrollment >----------------------|
5 -- ----------------------------------------------------------------------------
6 -- {Start of comments}
7 --
8 -- Description:
9 -- This procedure is the self-service wrapper procedure to the following
10 -- API: ota_cert_mbr_enrollment_api.create_cert_mbr_enrollment
11 --
12 -- Pre-requisites
13 -- All 'IN' parameters to this procedure have been appropriately derived.
14 --
15 -- Post Success:
16 -- p_return_status will return value indicating success.
17 --
18 -- Post Failure:
19 -- p_return_status will return value indication failure.
20 --
21 -- Access Status:
22 -- Internal Development use only.
23 --
24 -- {End of comments}
25 -- ----------------------------------------------------------------------------
26 PROCEDURE create_cert_mbr_enrollment
27 (p_effective_date in date
28 ,p_validate in number default hr_api.g_false_num
29 ,p_cert_prd_enrollment_id in number
30 ,p_cert_member_id in number
31 ,p_member_status_code in varchar2
32 ,p_completion_date in date default null
33 ,p_business_group_id in number
34 ,p_attribute_category in varchar2 default null
35 ,p_attribute1 in varchar2 default null
36 ,p_attribute2 in varchar2 default null
37 ,p_attribute3 in varchar2 default null
38 ,p_attribute4 in varchar2 default null
39 ,p_attribute5 in varchar2 default null
40 ,p_attribute6 in varchar2 default null
41 ,p_attribute7 in varchar2 default null
42 ,p_attribute8 in varchar2 default null
43 ,p_attribute9 in varchar2 default null
44 ,p_attribute10 in varchar2 default null
45 ,p_attribute11 in varchar2 default null
46 ,p_attribute12 in varchar2 default null
47 ,p_attribute13 in varchar2 default null
48 ,p_attribute14 in varchar2 default null
49 ,p_attribute15 in varchar2 default null
50 ,p_attribute16 in varchar2 default null
51 ,p_attribute17 in varchar2 default null
52 ,p_attribute18 in varchar2 default null
53 ,p_attribute19 in varchar2 default null
54 ,p_attribute20 in varchar2 default null
55 ,p_cert_mbr_enrollment_id in number
56 ,p_object_version_number out nocopy number
57 ,p_return_status out nocopy varchar2
58 );
59 -- ----------------------------------------------------------------------------
60 -- |----------------------< update_cert_mbr_enrollment >----------------------|
61 -- ----------------------------------------------------------------------------
62 -- {Start of comments}
63 --
64 -- Description:
65 -- This procedure is the self-service wrapper procedure to the following
66 -- API: ota_cert_mbr_enrollment_api.update_cert_mbr_enrollment
67 --
68 -- Pre-requisites
69 -- All 'IN' parameters to this procedure have been appropriately derived.
70 --
71 -- Post Success:
72 -- p_return_status will return value indicating success.
73 --
74 -- Post Failure:
75 -- p_return_status will return value indication failure.
76 --
77 -- Access Status:
78 -- Internal Development use only.
79 --
80 -- {End of comments}
81 -- ----------------------------------------------------------------------------
82 PROCEDURE update_cert_mbr_enrollment
83 (p_effective_date in date
84 ,p_cert_mbr_enrollment_id in number
85 ,p_object_version_number in out nocopy number
86 ,p_cert_prd_enrollment_id in number
87 ,p_cert_member_id in number
88 ,p_member_status_code in varchar2
89 ,p_completion_date in date default hr_api.g_date
90 ,p_business_group_id in number default hr_api.g_number
91 ,p_attribute_category in varchar2 default hr_api.g_varchar2
92 ,p_attribute1 in varchar2 default hr_api.g_varchar2
93 ,p_attribute2 in varchar2 default hr_api.g_varchar2
94 ,p_attribute3 in varchar2 default hr_api.g_varchar2
95 ,p_attribute4 in varchar2 default hr_api.g_varchar2
96 ,p_attribute5 in varchar2 default hr_api.g_varchar2
97 ,p_attribute6 in varchar2 default hr_api.g_varchar2
98 ,p_attribute7 in varchar2 default hr_api.g_varchar2
99 ,p_attribute8 in varchar2 default hr_api.g_varchar2
100 ,p_attribute9 in varchar2 default hr_api.g_varchar2
101 ,p_attribute10 in varchar2 default hr_api.g_varchar2
102 ,p_attribute11 in varchar2 default hr_api.g_varchar2
103 ,p_attribute12 in varchar2 default hr_api.g_varchar2
104 ,p_attribute13 in varchar2 default hr_api.g_varchar2
105 ,p_attribute14 in varchar2 default hr_api.g_varchar2
106 ,p_attribute15 in varchar2 default hr_api.g_varchar2
107 ,p_attribute16 in varchar2 default hr_api.g_varchar2
108 ,p_attribute17 in varchar2 default hr_api.g_varchar2
109 ,p_attribute18 in varchar2 default hr_api.g_varchar2
110 ,p_attribute19 in varchar2 default hr_api.g_varchar2
111 ,p_attribute20 in varchar2 default hr_api.g_varchar2
112 ,p_validate in number default hr_api.g_false_num
113 ,p_return_status out nocopy varchar2
114 );
115 -- ----------------------------------------------------------------------------
116 -- |----------------------< delete_cert_mbr_enrollment >----------------------|
117 -- ----------------------------------------------------------------------------
118 -- {Start of comments}
119 --
120 -- Description:
121 -- This procedure is the self-service wrapper procedure to the following
122 -- API: ota_cert_mbr_enrollment_api.delete_cert_mbr_enrollment
123 --
124 -- Pre-requisites
125 -- All 'IN' parameters to this procedure have been appropriately derived.
126 --
127 -- Post Success:
128 -- p_return_status will return value indicating success.
129 --
130 -- Post Failure:
131 -- p_return_status will return value indication failure.
132 --
133 -- Access Status:
134 -- Internal Development use only.
135 --
136 -- {End of comments}
137 -- ----------------------------------------------------------------------------
138 PROCEDURE delete_cert_mbr_enrollment
139 (p_cert_mbr_enrollment_id in number
140 ,p_object_version_number in number
141 ,p_validate in number default hr_api.g_false_num
142 ,p_return_status out nocopy varchar2
143 );
144 end ota_cert_mbr_enrollment_swi;