1 Package pqh_WORKSHEET_DETAILS_api as
2 /* $Header: pqwdtapi.pkh 120.1.12000000.1 2007/01/17 00:29:38 appldev noship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |------------------------< create_WORKSHEET_DETAIL >------------------------|
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_worksheet_id Yes number
18 -- p_organization_id No number
19 -- p_job_id No number
20 -- p_position_id No number
21 -- p_grade_id No number
22 -- p_position_transaction_id No number
23 -- p_budget_detail_id No number
24 -- p_parent_worksheet_detail_id No number
25 -- p_user_id No number
26 -- p_action_cd No varchar2
27 -- p_budget_unit1_percent No number
28 -- p_budget_unit1_value No number
29 -- p_budget_unit2_percent No number
30 -- p_budget_unit2_value No number
31 -- p_budget_unit3_percent No number
32 -- p_budget_unit3_value No number
33 -- p_budget_unit1_value_type_cd No varchar2
34 -- p_budget_unit2_value_type_cd No varchar2
35 -- p_budget_unit3_value_type_cd No varchar2
36 -- p_status No varchar2
37 -- p_budget_unit1_available No number
38 -- p_budget_unit2_available No number
39 -- p_budget_unit3_available No number
40 -- p_old_unit1_value No number
41 -- p_old_unit2_value No number
42 -- p_old_unit3_value No number
43 -- p_defer_flag No varchar2
44 -- p_propagation_method No varchar2
45 -- p_effective_date Yes date Session Date.
46 --
47 -- Post Success:
48 --
49 -- Out Parameters:
50 -- Name Type Description
51 -- p_worksheet_detail_id Yes number PK of record
52 -- p_object_version_number Yes number OVN of record
53 --
54 -- Post Failure:
55 --
56 -- Access Status:
57 -- Public.
58 --
59 -- {End Of Comments}
60 --
61 procedure create_WORKSHEET_DETAIL
62 (
63 p_validate in boolean default false
64 ,p_worksheet_detail_id out nocopy number
65 ,p_worksheet_id in number
66 ,p_organization_id in number default null
67 ,p_job_id in number default null
68 ,p_position_id in number default null
69 ,p_grade_id in number default null
70 ,p_position_transaction_id in number default null
71 ,p_budget_detail_id in number default null
72 ,p_parent_worksheet_detail_id in number default null
73 ,p_user_id in number default null
74 ,p_action_cd in varchar2 default null
75 ,p_budget_unit1_percent in number default null
76 ,p_budget_unit1_value in number default null
77 ,p_budget_unit2_percent in number default null
78 ,p_budget_unit2_value in number default null
79 ,p_budget_unit3_percent in number default null
80 ,p_budget_unit3_value in number default null
81 ,p_object_version_number out nocopy number
82 ,p_budget_unit1_value_type_cd in varchar2 default null
83 ,p_budget_unit2_value_type_cd in varchar2 default null
84 ,p_budget_unit3_value_type_cd in varchar2 default null
85 ,p_status in varchar2 default null
86 ,p_budget_unit1_available in number default null
87 ,p_budget_unit2_available in number default null
88 ,p_budget_unit3_available in number default null
89 ,p_old_unit1_value in number default null
90 ,p_old_unit2_value in number default null
91 ,p_old_unit3_value in number default null
92 ,p_defer_flag in varchar2 default null
93 ,p_propagation_method in varchar2 default null
94 ,p_effective_date in date
95 );
96 -- ----------------------------------------------------------------------------
97 -- ----------------------------------------------------------------------------
98 -- ----------------------------------------------------------------------------
99 -- ----------------------------------------------------------------------------
100
101 procedure create_WORKSHEET_DETAIL_BP
102 (
103 p_validate in boolean default false
104 ,p_worksheet_detail_id out nocopy number
105 ,p_worksheet_id in number
106 ,p_organization_id in number default null
107 ,p_job_id in number default null
108 ,p_position_id in number default null
109 ,p_grade_id in number default null
110 ,p_position_transaction_id in number default null
111 ,p_budget_detail_id in number default null
112 ,p_parent_worksheet_detail_id in number default null
113 ,p_user_id in number default null
114 ,p_action_cd in varchar2 default null
115 ,p_budget_unit1_percent in number default null
116 ,p_budget_unit1_value in number default null
117 ,p_budget_unit2_percent in number default null
118 ,p_budget_unit2_value in number default null
119 ,p_budget_unit3_percent in number default null
120 ,p_budget_unit3_value in number default null
121 ,p_object_version_number out nocopy number
122 ,p_budget_unit1_value_type_cd in varchar2 default null
123 ,p_budget_unit2_value_type_cd in varchar2 default null
124 ,p_budget_unit3_value_type_cd in varchar2 default null
125 ,p_status in varchar2 default null
126 ,p_budget_unit1_available in number default null
127 ,p_budget_unit2_available in number default null
128 ,p_budget_unit3_available in number default null
129 ,p_old_unit1_value in number default null
130 ,p_old_unit2_value in number default null
131 ,p_old_unit3_value in number default null
132 ,p_defer_flag in varchar2 default null
133 ,p_propagation_method in varchar2 default null
134 ,p_effective_date in date
135 ,p_copy_budget_periods in varchar2 default 'N'
136 );
137 -- ----------------------------------------------------------------------------
138 -- |------------------------< update_WORKSHEET_DETAIL >------------------------|
139 -- ----------------------------------------------------------------------------
140 -- {Start Of Comments}
141 --
142 -- Description:
143 --
144 -- Prerequisites:
145 --
146 --
147 -- In Parameters:
148 -- Name Reqd Type Description
149 -- p_validate Yes boolean Commit or Rollback.
150 -- p_worksheet_detail_id Yes number PK of record
151 -- p_worksheet_id Yes number
152 -- p_organization_id No number
153 -- p_job_id No number
154 -- p_position_id No number
155 -- p_grade_id No number
156 -- p_position_transaction_id No number
157 -- p_budget_detail_id No number
158 -- p_parent_worksheet_detail_id No number
159 -- p_user_id No number
160 -- p_action_cd No varchar2
161 -- p_budget_unit1_percent No number
162 -- p_budget_unit1_value No number
163 -- p_budget_unit2_percent No number
164 -- p_budget_unit2_value No number
165 -- p_budget_unit3_percent No number
166 -- p_budget_unit3_value No number
167 -- p_budget_unit1_value_type_cd No varchar2
168 -- p_budget_unit2_value_type_cd No varchar2
169 -- p_budget_unit3_value_type_cd No varchar2
170 -- p_status No varchar2
171 -- p_budget_unit1_available No number
172 -- p_budget_unit2_available No number
173 -- p_budget_unit3_available No number
174 -- p_old_unit1_value No number
175 -- p_old_unit2_value No number
176 -- p_old_unit3_value No number
177 -- p_defer_flag No varchar2
178 -- p_propagation_method No varchar2
179 -- p_effective_date Yes date Session Date.
180 --
181 -- Post Success:
182 --
183 -- Name Type Description
184 -- p_object_version_number Yes number OVN of record
185 --
186 -- Post Failure:
187 --
188 -- Access Status:
189 -- Public.
190 --
191 -- {End Of Comments}
192 --
193 procedure update_WORKSHEET_DETAIL
194 (
195 p_validate in boolean default false
196 ,p_worksheet_detail_id in number
197 ,p_worksheet_id in number default hr_api.g_number
198 ,p_organization_id in number default hr_api.g_number
199 ,p_job_id in number default hr_api.g_number
200 ,p_position_id in number default hr_api.g_number
201 ,p_grade_id in number default hr_api.g_number
202 ,p_position_transaction_id in number default hr_api.g_number
203 ,p_budget_detail_id in number default hr_api.g_number
204 ,p_parent_worksheet_detail_id in number default hr_api.g_number
205 ,p_user_id in number default hr_api.g_number
206 ,p_action_cd in varchar2 default hr_api.g_varchar2
207 ,p_budget_unit1_percent in number default hr_api.g_number
208 ,p_budget_unit1_value in number default hr_api.g_number
209 ,p_budget_unit2_percent in number default hr_api.g_number
210 ,p_budget_unit2_value in number default hr_api.g_number
211 ,p_budget_unit3_percent in number default hr_api.g_number
212 ,p_budget_unit3_value in number default hr_api.g_number
213 ,p_object_version_number in out nocopy number
214 ,p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2
215 ,p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2
216 ,p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2
217 ,p_status in varchar2 default hr_api.g_varchar2
218 ,p_budget_unit1_available in number default hr_api.g_number
219 ,p_budget_unit2_available in number default hr_api.g_number
220 ,p_budget_unit3_available in number default hr_api.g_number
221 ,p_old_unit1_value in number default hr_api.g_number
222 ,p_old_unit2_value in number default hr_api.g_number
223 ,p_old_unit3_value in number default hr_api.g_number
224 ,p_defer_flag in varchar2 default hr_api.g_varchar2
225 ,p_propagation_method in varchar2 default hr_api.g_varchar2
226 ,p_effective_date in date
227 );
228 --
229 -- ----------------------------------------------------------------------------
230 -- |------------------------< delete_WORKSHEET_DETAIL >------------------------|
231 -- ----------------------------------------------------------------------------
232 -- {Start Of Comments}
233 --
234 -- Description:
235 --
236 -- Prerequisites:
237 --
238 --
239 -- In Parameters:
240 -- Name Reqd Type Description
241 -- p_validate Yes boolean Commit or Rollback.
242 -- p_worksheet_detail_id Yes number PK of record
243 -- p_effective_date Yes date Session Date.
244 --
245 -- Post Success:
246 --
247 -- Name Type Description
248 -- p_object_version_number Yes number OVN of record
249 --
250 -- Post Failure:
251 --
252 -- Access Status:
253 -- Public.
254 --
255 -- {End Of Comments}
256 --
257 procedure delete_WORKSHEET_DETAIL
258 (
259 p_validate in boolean default false
260 ,p_worksheet_detail_id in number
261 ,p_object_version_number in number
262 ,p_effective_date in date
263 );
264 --
265 --
266 end pqh_WORKSHEET_DETAILS_api;