[Home] [Help]
PACKAGE: APPS.BEN_BATCH_LER_INFO_API
Source
1 Package ben_batch_ler_info_api as
2 /* $Header: bebliapi.pkh 120.0 2005/05/28 00:41:30 appldev noship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |------------------------< create_batch_ler_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_ler_id Yes number
20 -- p_lf_evt_ocrd_dt Yes date
21 -- p_replcd_flag Yes varchar2
22 -- p_crtd_flag Yes varchar2
23 -- p_tmprl_flag Yes varchar2
24 -- p_dltd_flag Yes varchar2
25 -- p_per_in_ler_id Yes number
26 -- p_business_group_id Yes number Business Group of Record
27 -- p_effective_date Yes date Session Date.
28 --
29 -- Post Success:
30 --
31 -- Out Parameters:
32 -- Name Type Description
33 -- p_batch_ler_id Yes number PK of record
34 -- p_object_version_number Yes number OVN of record
35 --
36 -- Post Failure:
37 --
38 -- Access Status:
39 -- Public.
40 --
41 -- {End Of Comments}
42 --
43 procedure create_batch_ler_info
44 (p_validate in boolean default false
45 ,p_batch_ler_id out nocopy number
46 ,p_benefit_action_id in number default null
47 ,p_person_id in number default null
48 ,p_ler_id in number default null
49 ,p_lf_evt_ocrd_dt in date default null
50 ,p_replcd_flag in varchar2 default 'N'
51 ,p_crtd_flag in varchar2 default 'N'
52 ,p_tmprl_flag in varchar2 default 'N'
53 ,p_dltd_flag in varchar2 default 'N'
54 ,p_open_and_clsd_flag in varchar2 default 'N'
55 ,p_clsd_flag in varchar2 default 'N'
56 ,p_not_crtd_flag in varchar2 default 'N'
57 ,p_stl_actv_flag in varchar2 default 'N'
58 ,p_clpsd_flag in varchar2 default 'N'
59 ,p_clsn_flag in varchar2 default 'N'
60 ,p_no_effect_flag in varchar2 default 'N'
61 ,p_cvrge_rt_prem_flag in varchar2 default 'N'
62 ,p_per_in_ler_id in number default null
63 ,p_business_group_id in number default null
64 ,p_object_version_number out nocopy number
65 ,p_effective_date in date);
66 -- ----------------------------------------------------------------------------
67 -- |------------------------< update_batch_ler_info >-------------------------|
68 -- ----------------------------------------------------------------------------
69 -- {Start Of Comments}
70 --
71 -- Description:
72 --
73 -- Prerequisites:
74 --
75 --
76 -- In Parameters:
77 -- Name Reqd Type Description
78 -- p_validate Yes boolean Commit or Rollback.
79 -- p_batch_ler_id Yes number PK of record
80 -- p_benefit_action_id Yes number
81 -- p_person_id Yes number
82 -- p_ler_id Yes number
83 -- p_lf_evt_ocrd_dt Yes date
84 -- p_replcd_flag Yes varchar2
85 -- p_crtd_flag Yes varchar2
86 -- p_tmprl_flag Yes varchar2
87 -- p_dltd_flag Yes varchar2
88 -- p_per_in_ler_id Yes number
89 -- p_business_group_id Yes number Business Group of Record
90 -- p_effective_date Yes date Session Date.
91 --
92 -- Post Success:
93 --
94 -- Name Type Description
95 -- p_object_version_number Yes number OVN of record
96 --
97 -- Post Failure:
98 --
99 -- Access Status:
100 -- Public.
101 --
102 -- {End Of Comments}
103 --
104 procedure update_batch_ler_info
105 (p_validate in boolean default false
106 ,p_batch_ler_id in number
107 ,p_benefit_action_id in number default hr_api.g_number
108 ,p_person_id in number default hr_api.g_number
109 ,p_ler_id in number default hr_api.g_number
110 ,p_lf_evt_ocrd_dt in date default hr_api.g_date
111 ,p_replcd_flag in varchar2 default hr_api.g_varchar2
112 ,p_crtd_flag in varchar2 default hr_api.g_varchar2
113 ,p_tmprl_flag in varchar2 default hr_api.g_varchar2
114 ,p_dltd_flag in varchar2 default hr_api.g_varchar2
115 ,p_open_and_clsd_flag in varchar2 default hr_api.g_varchar2
116 ,p_clsd_flag in varchar2 default hr_api.g_varchar2
117 ,p_not_crtd_flag in varchar2 default hr_api.g_varchar2
118 ,p_stl_actv_flag in varchar2 default hr_api.g_varchar2
119 ,p_clpsd_flag in varchar2 default hr_api.g_varchar2
120 ,p_clsn_flag in varchar2 default hr_api.g_varchar2
121 ,p_no_effect_flag in varchar2 default hr_api.g_varchar2
122 ,p_cvrge_rt_prem_flag in varchar2 default hr_api.g_varchar2
123 ,p_per_in_ler_id in number default hr_api.g_number
124 ,p_business_group_id in number default hr_api.g_number
125 ,p_object_version_number in out nocopy number
126 ,p_effective_date in date);
127 --
128 -- ----------------------------------------------------------------------------
129 -- |------------------------< delete_batch_ler_info >-------------------------|
130 -- ----------------------------------------------------------------------------
131 -- {Start Of Comments}
132 --
133 -- Description:
134 --
135 -- Prerequisites:
136 --
137 --
138 -- In Parameters:
139 -- Name Reqd Type Description
140 -- p_validate Yes boolean Commit or Rollback.
141 -- p_batch_ler_id Yes number PK of record
142 -- p_effective_date Yes date Session Date.
143 --
144 -- Post Success:
145 --
146 -- Name Type Description
147 -- p_object_version_number Yes number OVN of record
148 --
149 -- Post Failure:
150 --
151 -- Access Status:
152 -- Public.
153 --
154 -- {End Of Comments}
155 --
156 procedure delete_batch_ler_info
157 (p_validate in boolean default false
158 ,p_batch_ler_id in number
159 ,p_object_version_number in out nocopy number
160 ,p_effective_date in date);
161 --
162 -- ----------------------------------------------------------------------------
163 -- |----------------------------------< lck >---------------------------------|
164 -- ----------------------------------------------------------------------------
165 -- {Start Of Comments}
166 --
167 -- Description:
168 --
169 -- Prerequisites:
170 --
171 --
172 -- In Parameters:
173 -- Name Reqd Type Description
174 -- p_batch_ler_id Yes number PK of record
175 -- p_object_version_number Yes number OVN of record
176 --
177 -- Post Success:
178 --
179 -- Name Type Description
180 --
181 -- Post Failure:
182 --
183 -- Access Status:
184 -- Public.
185 --
186 -- {End Of Comments}
187 --
188 procedure lck
189 (p_batch_ler_id in number
190 ,p_object_version_number in number);
191 --
192 end ben_batch_ler_info_api;