APPS.PQH_WORKSHEET_DETAILS_API dependencies on HR_API

Line 197: ,p_worksheet_id in number default hr_api.g_number

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

Line 198: ,p_organization_id in number default hr_api.g_number

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

Line 199: ,p_job_id in number default hr_api.g_number

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

Line 200: ,p_position_id in number default hr_api.g_number

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

Line 201: ,p_grade_id in number default hr_api.g_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

Line 202: ,p_position_transaction_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

Line 203: ,p_budget_detail_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

Line 204: ,p_parent_worksheet_detail_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

Line 205: ,p_user_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

Line 206: ,p_action_cd in varchar2 default hr_api.g_varchar2

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

Line 207: ,p_budget_unit1_percent 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

Line 208: ,p_budget_unit1_value 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

Line 209: ,p_budget_unit2_percent 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

Line 210: ,p_budget_unit2_value 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

Line 211: ,p_budget_unit3_percent in number default hr_api.g_number

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

Line 212: ,p_budget_unit3_value 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

Line 214: ,p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2

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

Line 215: ,p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2

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

Line 216: ,p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2

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

Line 217: ,p_status in varchar2 default hr_api.g_varchar2

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

Line 218: ,p_budget_unit1_available in number default hr_api.g_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

Line 219: ,p_budget_unit2_available in number default hr_api.g_number

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

Line 220: ,p_budget_unit3_available in number default hr_api.g_number

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

Line 221: ,p_old_unit1_value in number default hr_api.g_number

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

Line 222: ,p_old_unit2_value in number default hr_api.g_number

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

Line 223: ,p_old_unit3_value 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: );

Line 224: ,p_defer_flag in varchar2 default hr_api.g_varchar2

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: --

Line 225: ,p_propagation_method in varchar2 default hr_api.g_varchar2

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: -- ----------------------------------------------------------------------------