1 Package ben_batch_dpnt_info_api as
2 /* $Header: bebdiapi.pkh 120.0 2005/05/28 00:36:33 appldev noship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |------------------------< create_batch_dpnt_info >------------------------|
6 -- ----------------------------------------------------------------------------
7 -- {Start Of Comments}
8 --
9 -- Description:
10 --
11 -- Prerequisites:
12 --
13 --
14 -- In Parameters:
15 -- Name Reqd Type Description
16 -- p_validate Yes boolean Commit or Rollback.
17 -- p_benefit_action_id Yes number
18 -- p_person_id Yes number
19 -- p_pgm_id No number
20 -- p_pl_id No number
21 -- p_oipl_id No number
22 -- p_contact_typ_cd No varchar2
23 -- p_dpnt_person_id Yes number
24 -- p_business_group_id Yes number Business Group of Record
25 -- p_enrt_cvg_strt_dt No date
26 -- p_enrt_cvg_thru_dt No date
27 -- p_actn_cd No varchar2
28 -- p_effective_date Yes date Session Date.
29 --
30 -- Post Success:
31 --
32 -- Out Parameters:
33 -- Name Type Description
34 -- p_batch_dpnt_id Yes number PK of record
35 -- p_object_version_number Yes varchar2 OVN of record
36 --
37 -- Post Failure:
38 --
39 -- Access Status:
40 -- Public.
41 --
42 -- {End Of Comments}
43 --
44 procedure create_batch_dpnt_info
45 (p_validate in boolean default false
46 ,p_batch_dpnt_id out nocopy number
47 ,p_benefit_action_id in number default null
48 ,p_person_id in number default null
49 ,p_pgm_id in number default null
50 ,p_pl_id in number default null
51 ,p_oipl_id in number default null
52 ,p_contact_typ_cd in varchar2 default null
53 ,p_dpnt_person_id in number default null
54 ,p_business_group_id in number default null
55 ,p_object_version_number out nocopy varchar2
56 ,p_enrt_cvg_strt_dt in date default null
57 ,p_enrt_cvg_thru_dt in date default null
58 ,p_actn_cd in varchar2 default null
59 ,p_effective_date in date);
60 -- ----------------------------------------------------------------------------
61 -- |------------------------< update_batch_dpnt_info >------------------------|
62 -- ----------------------------------------------------------------------------
63 -- {Start Of Comments}
64 --
65 -- Description:
66 --
67 -- Prerequisites:
68 --
69 --
70 -- In Parameters:
71 -- Name Reqd Type Description
72 -- p_validate Yes boolean Commit or Rollback.
73 -- p_batch_dpnt_id Yes number PK of record
74 -- p_benefit_action_id Yes number
75 -- p_person_id Yes number
76 -- p_pgm_id No number
77 -- p_pl_id No number
78 -- p_oipl_id No number
79 -- p_contact_typ_cd No varchar2
80 -- p_dpnt_person_id Yes number
81 -- p_business_group_id Yes number Business Group of Record
82 -- p_enrt_cvg_strt_dt No date
83 -- p_enrt_cvg_thru_dt No date
84 -- p_actn_cd No varchar2
85 -- p_effective_date Yes date Session Date.
86 --
87 -- Post Success:
88 --
89 -- Name Type Description
90 -- p_object_version_number Yes varchar2 OVN of record
91 --
92 -- Post Failure:
93 --
94 -- Access Status:
95 -- Public.
96 --
97 -- {End Of Comments}
98 --
99 procedure update_batch_dpnt_info
100 (p_validate in boolean default false
101 ,p_batch_dpnt_id in number
102 ,p_benefit_action_id in number default hr_api.g_number
103 ,p_person_id in number default hr_api.g_number
104 ,p_pgm_id in number default hr_api.g_number
105 ,p_pl_id in number default hr_api.g_number
106 ,p_oipl_id in number default hr_api.g_number
107 ,p_contact_typ_cd in varchar2 default hr_api.g_varchar2
108 ,p_dpnt_person_id in number default hr_api.g_number
109 ,p_business_group_id in number default hr_api.g_number
110 ,p_object_version_number in out nocopy varchar2
111 ,p_enrt_cvg_strt_dt in date default hr_api.g_date
112 ,p_enrt_cvg_thru_dt in date default hr_api.g_date
113 ,p_actn_cd in varchar2 default hr_api.g_varchar2
114 ,p_effective_date in date);
115 --
116 -- ----------------------------------------------------------------------------
117 -- |------------------------< delete_batch_dpnt_info >------------------------|
118 -- ----------------------------------------------------------------------------
119 -- {Start Of Comments}
120 --
121 -- Description:
122 --
123 -- Prerequisites:
124 --
125 --
126 -- In Parameters:
127 -- Name Reqd Type Description
128 -- p_validate Yes boolean Commit or Rollback.
129 -- p_batch_dpnt_id Yes number PK of record
130 -- p_effective_date Yes date Session Date.
131 --
132 -- Post Success:
133 --
134 -- Name Type Description
135 -- p_object_version_number Yes varchar2 OVN of record
136 --
137 -- Post Failure:
138 --
139 -- Access Status:
140 -- Public.
141 --
142 -- {End Of Comments}
143 --
144 procedure delete_batch_dpnt_info
145 (p_validate in boolean default false
146 ,p_batch_dpnt_id in number
147 ,p_object_version_number in out nocopy varchar2
148 ,p_effective_date in date);
149 --
150 -- ----------------------------------------------------------------------------
151 -- |----------------------------------< lck >---------------------------------|
152 -- ----------------------------------------------------------------------------
153 -- {Start Of Comments}
154 --
155 -- Description:
156 --
157 -- Prerequisites:
158 --
159 --
160 -- In Parameters:
161 -- Name Reqd Type Description
162 -- p_batch_dpnt_id Yes number PK of record
163 -- p_object_version_number Yes number OVN of record
164 --
165 -- Post Success:
166 --
167 -- Name Type Description
168 --
169 -- Post Failure:
170 --
171 -- Access Status:
172 -- Public.
173 --
174 -- {End Of Comments}
175 --
176 procedure lck
177 (p_batch_dpnt_id in number
178 ,p_object_version_number in number);
179 --
180 end ben_batch_dpnt_info_api;
[Home] [Help]