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