[Home] [Help]
PACKAGE: APPS.BEN_CWB_WKSHT_GRP_API
Source
1 Package ben_cwb_wksht_grp_api as
2 /* $Header: becwgapi.pkh 120.0 2005/05/28 01:29:41 appldev noship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |------------------------< create_cwb_wksht_grp >------------------------|
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_cwb_wksht_grp_id Yes number PK
18 -- p_pl_id Yes number FK to ben_pl_f
19 -- p_label Yes varchar2 SS Label
20 -- p_ordr_num Yes number Sequence number
21 -- p_effective_date Yes date Session Date.
22 --
23 -- Post Success:
24 --
25 -- Out Parameters:
26 -- Name Type Description
27 -- p_cwb_wksht_grp_id Yes number PK of record
28 -- p_object_version_number No number OVN of record
29 --
30 -- Post Failure:
31 --
32 -- Access Status:
33 -- Public.
34 --
35 -- {End Of Comments}
36 --
37 procedure create_cwb_wksht_grp
38 (
39 p_validate in boolean default false
40 ,p_business_group_id in number
41 ,p_pl_id in number
42 ,p_ordr_num in number
43 ,p_wksht_grp_cd in varchar2
44 ,p_label in varchar2
45 ,p_cwg_attribute_category in varchar2 default null
46 ,p_cwg_attribute1 in varchar2 default null
47 ,p_cwg_attribute2 in varchar2 default null
48 ,p_cwg_attribute3 in varchar2 default null
49 ,p_cwg_attribute4 in varchar2 default null
50 ,p_cwg_attribute5 in varchar2 default null
51 ,p_cwg_attribute6 in varchar2 default null
52 ,p_cwg_attribute7 in varchar2 default null
53 ,p_cwg_attribute8 in varchar2 default null
54 ,p_cwg_attribute9 in varchar2 default null
55 ,p_cwg_attribute10 in varchar2 default null
56 ,p_cwg_attribute11 in varchar2 default null
57 ,p_cwg_attribute12 in varchar2 default null
58 ,p_cwg_attribute13 in varchar2 default null
59 ,p_cwg_attribute14 in varchar2 default null
60 ,p_cwg_attribute15 in varchar2 default null
61 ,p_cwg_attribute16 in varchar2 default null
62 ,p_cwg_attribute17 in varchar2 default null
63 ,p_cwg_attribute18 in varchar2 default null
64 ,p_cwg_attribute19 in varchar2 default null
65 ,p_cwg_attribute20 in varchar2 default null
66 ,p_cwg_attribute21 in varchar2 default null
67 ,p_cwg_attribute22 in varchar2 default null
68 ,p_cwg_attribute23 in varchar2 default null
69 ,p_cwg_attribute24 in varchar2 default null
70 ,p_cwg_attribute25 in varchar2 default null
71 ,p_cwg_attribute26 in varchar2 default null
72 ,p_cwg_attribute27 in varchar2 default null
73 ,p_cwg_attribute28 in varchar2 default null
74 ,p_cwg_attribute29 in varchar2 default null
75 ,p_cwg_attribute30 in varchar2 default null
76 ,p_status_cd in varchar2 default null
77 ,p_hidden_cd in varchar2 default null
78 ,p_effective_date in date
79 ,p_cwb_wksht_grp_id out nocopy number
80 ,p_object_version_number out nocopy number
81 );
82 -- ----------------------------------------------------------------------------
83 -- |------------------------< update_cwb_wksht_grp >------------------------|
84 -- ----------------------------------------------------------------------------
85 -- {Start Of Comments}
86 --
87 -- Description:
88 --
89 -- Prerequisites:
90 --
91 --
92 -- In Parameters:
93 -- Name Reqd Type Description
94 -- p_validate Yes boolean Commit or Rollback.
95 -- p_cwb_wksht_grp_id Yes number PK
96 -- p_pl_id Yes number FK to ben_pl_f
97 -- p_label Yes varchar2 SS Label
98 -- p_ordr_num Yes number Sequence number
99 -- p_effective_date Yes date Session Date.
100 --
101 -- Post Success:
102 --
103 -- Name Type Description
104 -- p_object_version_number No number OVN of record
105 --
106 -- Post Failure:
107 --
108 -- Access Status:
109 -- Public.
110 --
111 -- {End Of Comments}
112 --
113 procedure update_cwb_wksht_grp
114 (
115 p_validate in boolean default false
116 ,p_business_group_id in number
117 ,p_cwb_wksht_grp_id in number
118 ,p_pl_id in number default hr_api.g_number
119 ,p_ordr_num in number default hr_api.g_number
120 ,p_wksht_grp_cd in varchar2 default hr_api.g_varchar2
121 ,p_label in varchar2 default hr_api.g_varchar2
122 ,p_cwg_attribute_category in varchar2 default hr_api.g_varchar2
123 ,p_cwg_attribute1 in varchar2 default hr_api.g_varchar2
124 ,p_cwg_attribute2 in varchar2 default hr_api.g_varchar2
125 ,p_cwg_attribute3 in varchar2 default hr_api.g_varchar2
126 ,p_cwg_attribute4 in varchar2 default hr_api.g_varchar2
127 ,p_cwg_attribute5 in varchar2 default hr_api.g_varchar2
128 ,p_cwg_attribute6 in varchar2 default hr_api.g_varchar2
129 ,p_cwg_attribute7 in varchar2 default hr_api.g_varchar2
130 ,p_cwg_attribute8 in varchar2 default hr_api.g_varchar2
131 ,p_cwg_attribute9 in varchar2 default hr_api.g_varchar2
132 ,p_cwg_attribute10 in varchar2 default hr_api.g_varchar2
133 ,p_cwg_attribute11 in varchar2 default hr_api.g_varchar2
134 ,p_cwg_attribute12 in varchar2 default hr_api.g_varchar2
135 ,p_cwg_attribute13 in varchar2 default hr_api.g_varchar2
136 ,p_cwg_attribute14 in varchar2 default hr_api.g_varchar2
137 ,p_cwg_attribute15 in varchar2 default hr_api.g_varchar2
138 ,p_cwg_attribute16 in varchar2 default hr_api.g_varchar2
139 ,p_cwg_attribute17 in varchar2 default hr_api.g_varchar2
140 ,p_cwg_attribute18 in varchar2 default hr_api.g_varchar2
141 ,p_cwg_attribute19 in varchar2 default hr_api.g_varchar2
142 ,p_cwg_attribute20 in varchar2 default hr_api.g_varchar2
143 ,p_cwg_attribute21 in varchar2 default hr_api.g_varchar2
144 ,p_cwg_attribute22 in varchar2 default hr_api.g_varchar2
145 ,p_cwg_attribute23 in varchar2 default hr_api.g_varchar2
146 ,p_cwg_attribute24 in varchar2 default hr_api.g_varchar2
147 ,p_cwg_attribute25 in varchar2 default hr_api.g_varchar2
148 ,p_cwg_attribute26 in varchar2 default hr_api.g_varchar2
149 ,p_cwg_attribute27 in varchar2 default hr_api.g_varchar2
150 ,p_cwg_attribute28 in varchar2 default hr_api.g_varchar2
151 ,p_cwg_attribute29 in varchar2 default hr_api.g_varchar2
152 ,p_cwg_attribute30 in varchar2 default hr_api.g_varchar2
153 ,p_status_cd in varchar2 default hr_api.g_varchar2
154 ,p_hidden_cd in varchar2 default hr_api.g_varchar2
155 ,p_object_version_number in out nocopy number
156 ,p_effective_date in date
157 );
158 --
159 -- ----------------------------------------------------------------------------
160 -- |------------------------< delete_cwb_wksht_grp >------------------------|
161 -- ----------------------------------------------------------------------------
162 -- {Start Of Comments}
163 --
164 -- Description:
165 --
166 -- Prerequisites:
167 --
168 --
169 -- In Parameters:
170 -- Name Reqd Type Description
171 -- p_validate Yes boolean Commit or Rollback.
172 -- p_cwb_wksht_grp_id Yes number PK of record
173 -- p_effective_date Yes date Session Date.
174 --
175 -- Post Success:
176 --
177 -- Name Type Description
178 -- p_object_version_number No number OVN of record
179 --
180 -- Post Failure:
181 --
182 -- Access Status:
183 -- Public.
184 --
185 -- {End Of Comments}
186 --
187 procedure delete_cwb_wksht_grp
188 (
189 p_validate in boolean default false
190 ,p_cwb_wksht_grp_id in number
191 ,p_object_version_number in out nocopy number
192 ,p_effective_date in date
193 );
194 --
195 -- ----------------------------------------------------------------------------
196 -- |----------------------------------< lck >---------------------------------|
197 -- ----------------------------------------------------------------------------
198 -- {Start Of Comments}
199 --
200 -- Description:
201 --
202 -- Prerequisites:
203 --
204 --
205 -- In Parameters:
206 -- Name Reqd Type Description
207 -- p_cwb_wksht_grp_id Yes number PK of record
208 -- p_object_version_number Yes number OVN of record
209 -- p_effective_date Yes date Session Date.
210 --
211 -- Post Success:
212 --
213 -- Post Failure:
214 --
215 -- Access Status:
216 -- Public.
217 --
218 -- {End Of Comments}
219 --
220 procedure lck
221 (
222 p_cwb_wksht_grp_id in number
223 ,p_object_version_number in number
224 );
225 --
226 end ben_cwb_wksht_grp_api;