1 Package ben_batch_proc_info_api as
2 /* $Header: bebpiapi.pkh 120.0 2005/05/28 00:46:35 appldev noship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |------------------------< create_batch_proc_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_strt_dt No date
19 -- p_end_dt No date
20 -- p_strt_tm No varchar2
21 -- p_end_tm No varchar2
22 -- p_elpsd_tm No varchar2
23 -- p_per_slctd No number
24 -- p_per_proc No number
25 -- p_per_unproc No number
26 -- p_per_proc_succ No number
27 -- p_per_err No number
28 -- p_business_group_id Yes number Business Group of Record
29 --
30 -- Post Success:
31 --
32 -- Out Parameters:
33 -- Name Type Description
34 -- p_batch_proc_id Yes number PK of record
35 -- p_object_version_number Yes number OVN of record
36 --
37 -- Post Failure:
38 --
39 -- Access Status:
40 -- Public.
41 --
42 -- {End Of Comments}
43 --
44 procedure create_batch_proc_info
45 (p_validate in boolean default false
46 ,p_batch_proc_id out nocopy number
47 ,p_benefit_action_id in number default null
48 ,p_strt_dt in date default null
49 ,p_end_dt in date default null
50 ,p_strt_tm in varchar2 default null
51 ,p_end_tm in varchar2 default null
52 ,p_elpsd_tm in varchar2 default null
53 ,p_per_slctd in number default null
54 ,p_per_proc in number default null
55 ,p_per_unproc in number default null
56 ,p_per_proc_succ in number default null
57 ,p_per_err in number default null
58 ,p_business_group_id in number default null
59 ,p_object_version_number out nocopy number);
60 -- ----------------------------------------------------------------------------
61 -- |------------------------< update_batch_proc_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_proc_id Yes number PK of record
74 -- p_benefit_action_id Yes number
75 -- p_strt_dt No date
76 -- p_end_dt No date
77 -- p_strt_tm No varchar2
78 -- p_end_tm No varchar2
79 -- p_elpsd_tm No varchar2
80 -- p_per_slctd No number
81 -- p_per_proc No number
82 -- p_per_unproc No number
83 -- p_per_proc_succ No number
84 -- p_per_err No number
85 -- p_business_group_id Yes number Business Group of Record
86 --
87 -- Post Success:
88 --
89 -- Name Type Description
90 -- p_object_version_number Yes number OVN of record
91 --
92 -- Post Failure:
93 --
94 -- Access Status:
95 -- Public.
96 --
97 -- {End Of Comments}
98 --
99 procedure update_batch_proc_info
100 (p_validate in boolean default false
101 ,p_batch_proc_id in number
102 ,p_benefit_action_id in number default hr_api.g_number
103 ,p_strt_dt in date default hr_api.g_date
104 ,p_end_dt in date default hr_api.g_date
105 ,p_strt_tm in varchar2 default hr_api.g_varchar2
106 ,p_end_tm in varchar2 default hr_api.g_varchar2
107 ,p_elpsd_tm in varchar2 default hr_api.g_varchar2
108 ,p_per_slctd in number default hr_api.g_number
109 ,p_per_proc in number default hr_api.g_number
110 ,p_per_unproc in number default hr_api.g_number
111 ,p_per_proc_succ in number default hr_api.g_number
112 ,p_per_err in number default hr_api.g_number
113 ,p_business_group_id in number default hr_api.g_number
114 ,p_object_version_number in out nocopy number);
115 --
116 -- ----------------------------------------------------------------------------
117 -- |------------------------< delete_batch_proc_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_proc_id Yes number PK of record
130 --
131 -- Post Success:
132 --
133 -- Name Type Description
134 -- p_object_version_number Yes number OVN of record
135 --
136 -- Post Failure:
137 --
138 -- Access Status:
139 -- Public.
140 --
141 -- {End Of Comments}
142 --
143 procedure delete_batch_proc_info
144 (p_validate in boolean default false
145 ,p_batch_proc_id in number
146 ,p_object_version_number in out nocopy number);
147 --
148 -- ----------------------------------------------------------------------------
149 -- |----------------------------------< lck >---------------------------------|
150 -- ----------------------------------------------------------------------------
151 -- {Start Of Comments}
152 --
153 -- Description:
154 --
155 -- Prerequisites:
156 --
157 --
158 -- In Parameters:
159 -- Name Reqd Type Description
160 -- p_batch_proc_id Yes number PK of record
161 -- p_object_version_number Yes number OVN of record
162 --
163 -- Post Success:
164 --
165 -- Name Type Description
166 --
167 -- Post Failure:
168 --
169 -- Access Status:
170 -- Public.
171 --
172 -- {End Of Comments}
173 --
174 procedure lck
175 (p_batch_proc_id in number
176 ,p_object_version_number in number);
177 --
178 end ben_batch_proc_info_api;
[Home] [Help]