324: Procedure update_worksheet_detail
325: (
326: p_effective_date in date,
327: p_worksheet_detail_id in number,
328: p_worksheet_id in number default hr_api.g_number,
329: p_organization_id in number default hr_api.g_number,
330: p_job_id in number default hr_api.g_number,
331: p_position_id in number default hr_api.g_number,
332: p_grade_id in number default hr_api.g_number,
325: (
326: p_effective_date in date,
327: p_worksheet_detail_id in number,
328: p_worksheet_id in number default hr_api.g_number,
329: p_organization_id in number default hr_api.g_number,
330: p_job_id in number default hr_api.g_number,
331: p_position_id in number default hr_api.g_number,
332: p_grade_id in number default hr_api.g_number,
333: p_position_transaction_id in number default hr_api.g_number,
326: p_effective_date in date,
327: p_worksheet_detail_id in number,
328: p_worksheet_id in number default hr_api.g_number,
329: p_organization_id in number default hr_api.g_number,
330: p_job_id in number default hr_api.g_number,
331: p_position_id in number default hr_api.g_number,
332: p_grade_id in number default hr_api.g_number,
333: p_position_transaction_id in number default hr_api.g_number,
334: p_budget_detail_id in number default hr_api.g_number,
327: p_worksheet_detail_id in number,
328: p_worksheet_id in number default hr_api.g_number,
329: p_organization_id in number default hr_api.g_number,
330: p_job_id in number default hr_api.g_number,
331: p_position_id in number default hr_api.g_number,
332: p_grade_id in number default hr_api.g_number,
333: p_position_transaction_id in number default hr_api.g_number,
334: p_budget_detail_id in number default hr_api.g_number,
335: p_parent_worksheet_detail_id in number default hr_api.g_number,
328: p_worksheet_id in number default hr_api.g_number,
329: p_organization_id in number default hr_api.g_number,
330: p_job_id in number default hr_api.g_number,
331: p_position_id in number default hr_api.g_number,
332: p_grade_id in number default hr_api.g_number,
333: p_position_transaction_id in number default hr_api.g_number,
334: p_budget_detail_id in number default hr_api.g_number,
335: p_parent_worksheet_detail_id in number default hr_api.g_number,
336: p_user_id in number default hr_api.g_number,
329: p_organization_id in number default hr_api.g_number,
330: p_job_id in number default hr_api.g_number,
331: p_position_id in number default hr_api.g_number,
332: p_grade_id in number default hr_api.g_number,
333: p_position_transaction_id in number default hr_api.g_number,
334: p_budget_detail_id in number default hr_api.g_number,
335: p_parent_worksheet_detail_id in number default hr_api.g_number,
336: p_user_id in number default hr_api.g_number,
337: p_action_cd in varchar2 default hr_api.g_varchar2,
330: p_job_id in number default hr_api.g_number,
331: p_position_id in number default hr_api.g_number,
332: p_grade_id in number default hr_api.g_number,
333: p_position_transaction_id in number default hr_api.g_number,
334: p_budget_detail_id in number default hr_api.g_number,
335: p_parent_worksheet_detail_id in number default hr_api.g_number,
336: p_user_id in number default hr_api.g_number,
337: p_action_cd in varchar2 default hr_api.g_varchar2,
338: p_budget_unit1_percent in number default hr_api.g_number,
331: p_position_id in number default hr_api.g_number,
332: p_grade_id in number default hr_api.g_number,
333: p_position_transaction_id in number default hr_api.g_number,
334: p_budget_detail_id in number default hr_api.g_number,
335: p_parent_worksheet_detail_id in number default hr_api.g_number,
336: p_user_id in number default hr_api.g_number,
337: p_action_cd in varchar2 default hr_api.g_varchar2,
338: p_budget_unit1_percent in number default hr_api.g_number,
339: p_budget_unit1_value in number default hr_api.g_number,
332: p_grade_id in number default hr_api.g_number,
333: p_position_transaction_id in number default hr_api.g_number,
334: p_budget_detail_id in number default hr_api.g_number,
335: p_parent_worksheet_detail_id in number default hr_api.g_number,
336: p_user_id in number default hr_api.g_number,
337: p_action_cd in varchar2 default hr_api.g_varchar2,
338: p_budget_unit1_percent in number default hr_api.g_number,
339: p_budget_unit1_value in number default hr_api.g_number,
340: p_budget_unit2_percent in number default hr_api.g_number,
333: p_position_transaction_id in number default hr_api.g_number,
334: p_budget_detail_id in number default hr_api.g_number,
335: p_parent_worksheet_detail_id in number default hr_api.g_number,
336: p_user_id in number default hr_api.g_number,
337: p_action_cd in varchar2 default hr_api.g_varchar2,
338: p_budget_unit1_percent in number default hr_api.g_number,
339: p_budget_unit1_value in number default hr_api.g_number,
340: p_budget_unit2_percent in number default hr_api.g_number,
341: p_budget_unit2_value in number default hr_api.g_number,
334: p_budget_detail_id in number default hr_api.g_number,
335: p_parent_worksheet_detail_id in number default hr_api.g_number,
336: p_user_id in number default hr_api.g_number,
337: p_action_cd in varchar2 default hr_api.g_varchar2,
338: p_budget_unit1_percent in number default hr_api.g_number,
339: p_budget_unit1_value in number default hr_api.g_number,
340: p_budget_unit2_percent in number default hr_api.g_number,
341: p_budget_unit2_value in number default hr_api.g_number,
342: p_budget_unit3_percent in number default hr_api.g_number,
335: p_parent_worksheet_detail_id in number default hr_api.g_number,
336: p_user_id in number default hr_api.g_number,
337: p_action_cd in varchar2 default hr_api.g_varchar2,
338: p_budget_unit1_percent in number default hr_api.g_number,
339: p_budget_unit1_value in number default hr_api.g_number,
340: p_budget_unit2_percent in number default hr_api.g_number,
341: p_budget_unit2_value in number default hr_api.g_number,
342: p_budget_unit3_percent in number default hr_api.g_number,
343: p_budget_unit3_value in number default hr_api.g_number,
336: p_user_id in number default hr_api.g_number,
337: p_action_cd in varchar2 default hr_api.g_varchar2,
338: p_budget_unit1_percent in number default hr_api.g_number,
339: p_budget_unit1_value in number default hr_api.g_number,
340: p_budget_unit2_percent in number default hr_api.g_number,
341: p_budget_unit2_value in number default hr_api.g_number,
342: p_budget_unit3_percent in number default hr_api.g_number,
343: p_budget_unit3_value in number default hr_api.g_number,
344: p_object_version_number in out nocopy number,
337: p_action_cd in varchar2 default hr_api.g_varchar2,
338: p_budget_unit1_percent in number default hr_api.g_number,
339: p_budget_unit1_value in number default hr_api.g_number,
340: p_budget_unit2_percent in number default hr_api.g_number,
341: p_budget_unit2_value in number default hr_api.g_number,
342: p_budget_unit3_percent in number default hr_api.g_number,
343: p_budget_unit3_value in number default hr_api.g_number,
344: p_object_version_number in out nocopy number,
345: p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2,
338: p_budget_unit1_percent in number default hr_api.g_number,
339: p_budget_unit1_value in number default hr_api.g_number,
340: p_budget_unit2_percent in number default hr_api.g_number,
341: p_budget_unit2_value in number default hr_api.g_number,
342: p_budget_unit3_percent in number default hr_api.g_number,
343: p_budget_unit3_value in number default hr_api.g_number,
344: p_object_version_number in out nocopy number,
345: p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2,
346: p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2,
339: p_budget_unit1_value in number default hr_api.g_number,
340: p_budget_unit2_percent in number default hr_api.g_number,
341: p_budget_unit2_value in number default hr_api.g_number,
342: p_budget_unit3_percent in number default hr_api.g_number,
343: p_budget_unit3_value in number default hr_api.g_number,
344: p_object_version_number in out nocopy number,
345: p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2,
346: p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2,
347: p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2,
341: p_budget_unit2_value in number default hr_api.g_number,
342: p_budget_unit3_percent in number default hr_api.g_number,
343: p_budget_unit3_value in number default hr_api.g_number,
344: p_object_version_number in out nocopy number,
345: p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2,
346: p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2,
347: p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2,
348: p_status in varchar2 default hr_api.g_varchar2,
349: p_budget_unit1_available in number default hr_api.g_number,
342: p_budget_unit3_percent in number default hr_api.g_number,
343: p_budget_unit3_value in number default hr_api.g_number,
344: p_object_version_number in out nocopy number,
345: p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2,
346: p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2,
347: p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2,
348: p_status in varchar2 default hr_api.g_varchar2,
349: p_budget_unit1_available in number default hr_api.g_number,
350: p_budget_unit2_available in number default hr_api.g_number,
343: p_budget_unit3_value in number default hr_api.g_number,
344: p_object_version_number in out nocopy number,
345: p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2,
346: p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2,
347: p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2,
348: p_status in varchar2 default hr_api.g_varchar2,
349: p_budget_unit1_available in number default hr_api.g_number,
350: p_budget_unit2_available in number default hr_api.g_number,
351: p_budget_unit3_available in number default hr_api.g_number,
344: p_object_version_number in out nocopy number,
345: p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2,
346: p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2,
347: p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2,
348: p_status in varchar2 default hr_api.g_varchar2,
349: p_budget_unit1_available in number default hr_api.g_number,
350: p_budget_unit2_available in number default hr_api.g_number,
351: p_budget_unit3_available in number default hr_api.g_number,
352: p_old_unit1_value in number default hr_api.g_number,
345: p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2,
346: p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2,
347: p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2,
348: p_status in varchar2 default hr_api.g_varchar2,
349: p_budget_unit1_available in number default hr_api.g_number,
350: p_budget_unit2_available in number default hr_api.g_number,
351: p_budget_unit3_available in number default hr_api.g_number,
352: p_old_unit1_value in number default hr_api.g_number,
353: p_old_unit2_value in number default hr_api.g_number,
346: p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2,
347: p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2,
348: p_status in varchar2 default hr_api.g_varchar2,
349: p_budget_unit1_available in number default hr_api.g_number,
350: p_budget_unit2_available in number default hr_api.g_number,
351: p_budget_unit3_available in number default hr_api.g_number,
352: p_old_unit1_value in number default hr_api.g_number,
353: p_old_unit2_value in number default hr_api.g_number,
354: p_old_unit3_value in number default hr_api.g_number,
347: p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2,
348: p_status in varchar2 default hr_api.g_varchar2,
349: p_budget_unit1_available in number default hr_api.g_number,
350: p_budget_unit2_available in number default hr_api.g_number,
351: p_budget_unit3_available in number default hr_api.g_number,
352: p_old_unit1_value in number default hr_api.g_number,
353: p_old_unit2_value in number default hr_api.g_number,
354: p_old_unit3_value in number default hr_api.g_number,
355: p_defer_flag in varchar2 default hr_api.g_varchar2,
348: p_status in varchar2 default hr_api.g_varchar2,
349: p_budget_unit1_available in number default hr_api.g_number,
350: p_budget_unit2_available in number default hr_api.g_number,
351: p_budget_unit3_available in number default hr_api.g_number,
352: p_old_unit1_value in number default hr_api.g_number,
353: p_old_unit2_value in number default hr_api.g_number,
354: p_old_unit3_value in number default hr_api.g_number,
355: p_defer_flag in varchar2 default hr_api.g_varchar2,
356: p_propagation_method in varchar2 default hr_api.g_varchar2
349: p_budget_unit1_available in number default hr_api.g_number,
350: p_budget_unit2_available in number default hr_api.g_number,
351: p_budget_unit3_available in number default hr_api.g_number,
352: p_old_unit1_value in number default hr_api.g_number,
353: p_old_unit2_value in number default hr_api.g_number,
354: p_old_unit3_value in number default hr_api.g_number,
355: p_defer_flag in varchar2 default hr_api.g_varchar2,
356: p_propagation_method in varchar2 default hr_api.g_varchar2
357: ) ;
350: p_budget_unit2_available in number default hr_api.g_number,
351: p_budget_unit3_available in number default hr_api.g_number,
352: p_old_unit1_value in number default hr_api.g_number,
353: p_old_unit2_value in number default hr_api.g_number,
354: p_old_unit3_value in number default hr_api.g_number,
355: p_defer_flag in varchar2 default hr_api.g_varchar2,
356: p_propagation_method in varchar2 default hr_api.g_varchar2
357: ) ;
358: procedure copy_budget_periods(p_budget_detail_id in number,
351: p_budget_unit3_available in number default hr_api.g_number,
352: p_old_unit1_value in number default hr_api.g_number,
353: p_old_unit2_value in number default hr_api.g_number,
354: p_old_unit3_value in number default hr_api.g_number,
355: p_defer_flag in varchar2 default hr_api.g_varchar2,
356: p_propagation_method in varchar2 default hr_api.g_varchar2
357: ) ;
358: procedure copy_budget_periods(p_budget_detail_id in number,
359: p_worksheet_detail_id in number,
352: p_old_unit1_value in number default hr_api.g_number,
353: p_old_unit2_value in number default hr_api.g_number,
354: p_old_unit3_value in number default hr_api.g_number,
355: p_defer_flag in varchar2 default hr_api.g_varchar2,
356: p_propagation_method in varchar2 default hr_api.g_varchar2
357: ) ;
358: procedure copy_budget_periods(p_budget_detail_id in number,
359: p_worksheet_detail_id in number,
360: p_copy_budget_periods in varchar2,