99: Procedure upd
100: (
101: p_effective_date in date,
102: p_worksheet_detail_id in number,
103: p_worksheet_id in number default hr_api.g_number,
104: p_organization_id in number default hr_api.g_number,
105: p_job_id in number default hr_api.g_number,
106: p_position_id in number default hr_api.g_number,
107: p_grade_id in number default hr_api.g_number,
100: (
101: p_effective_date in date,
102: p_worksheet_detail_id in number,
103: p_worksheet_id in number default hr_api.g_number,
104: p_organization_id in number default hr_api.g_number,
105: p_job_id in number default hr_api.g_number,
106: p_position_id in number default hr_api.g_number,
107: p_grade_id in number default hr_api.g_number,
108: p_position_transaction_id in number default hr_api.g_number,
101: p_effective_date in date,
102: p_worksheet_detail_id in number,
103: p_worksheet_id in number default hr_api.g_number,
104: p_organization_id in number default hr_api.g_number,
105: p_job_id in number default hr_api.g_number,
106: p_position_id in number default hr_api.g_number,
107: p_grade_id in number default hr_api.g_number,
108: p_position_transaction_id in number default hr_api.g_number,
109: p_budget_detail_id in number default hr_api.g_number,
102: p_worksheet_detail_id in number,
103: p_worksheet_id in number default hr_api.g_number,
104: p_organization_id in number default hr_api.g_number,
105: p_job_id in number default hr_api.g_number,
106: p_position_id in number default hr_api.g_number,
107: p_grade_id in number default hr_api.g_number,
108: p_position_transaction_id in number default hr_api.g_number,
109: p_budget_detail_id in number default hr_api.g_number,
110: p_parent_worksheet_detail_id in number default hr_api.g_number,
103: p_worksheet_id in number default hr_api.g_number,
104: p_organization_id in number default hr_api.g_number,
105: p_job_id in number default hr_api.g_number,
106: p_position_id in number default hr_api.g_number,
107: p_grade_id in number default hr_api.g_number,
108: p_position_transaction_id in number default hr_api.g_number,
109: p_budget_detail_id in number default hr_api.g_number,
110: p_parent_worksheet_detail_id in number default hr_api.g_number,
111: p_user_id in number default hr_api.g_number,
104: p_organization_id in number default hr_api.g_number,
105: p_job_id in number default hr_api.g_number,
106: p_position_id in number default hr_api.g_number,
107: p_grade_id in number default hr_api.g_number,
108: p_position_transaction_id in number default hr_api.g_number,
109: p_budget_detail_id in number default hr_api.g_number,
110: p_parent_worksheet_detail_id in number default hr_api.g_number,
111: p_user_id in number default hr_api.g_number,
112: p_action_cd in varchar2 default hr_api.g_varchar2,
105: p_job_id in number default hr_api.g_number,
106: p_position_id in number default hr_api.g_number,
107: p_grade_id in number default hr_api.g_number,
108: p_position_transaction_id in number default hr_api.g_number,
109: p_budget_detail_id in number default hr_api.g_number,
110: p_parent_worksheet_detail_id in number default hr_api.g_number,
111: p_user_id in number default hr_api.g_number,
112: p_action_cd in varchar2 default hr_api.g_varchar2,
113: p_budget_unit1_percent in number default hr_api.g_number,
106: p_position_id in number default hr_api.g_number,
107: p_grade_id in number default hr_api.g_number,
108: p_position_transaction_id in number default hr_api.g_number,
109: p_budget_detail_id in number default hr_api.g_number,
110: p_parent_worksheet_detail_id in number default hr_api.g_number,
111: p_user_id in number default hr_api.g_number,
112: p_action_cd in varchar2 default hr_api.g_varchar2,
113: p_budget_unit1_percent in number default hr_api.g_number,
114: p_budget_unit1_value in number default hr_api.g_number,
107: p_grade_id in number default hr_api.g_number,
108: p_position_transaction_id in number default hr_api.g_number,
109: p_budget_detail_id in number default hr_api.g_number,
110: p_parent_worksheet_detail_id in number default hr_api.g_number,
111: p_user_id in number default hr_api.g_number,
112: p_action_cd in varchar2 default hr_api.g_varchar2,
113: p_budget_unit1_percent in number default hr_api.g_number,
114: p_budget_unit1_value in number default hr_api.g_number,
115: p_budget_unit2_percent in number default hr_api.g_number,
108: p_position_transaction_id in number default hr_api.g_number,
109: p_budget_detail_id in number default hr_api.g_number,
110: p_parent_worksheet_detail_id in number default hr_api.g_number,
111: p_user_id in number default hr_api.g_number,
112: p_action_cd in varchar2 default hr_api.g_varchar2,
113: p_budget_unit1_percent in number default hr_api.g_number,
114: p_budget_unit1_value in number default hr_api.g_number,
115: p_budget_unit2_percent in number default hr_api.g_number,
116: p_budget_unit2_value in number default hr_api.g_number,
109: p_budget_detail_id in number default hr_api.g_number,
110: p_parent_worksheet_detail_id in number default hr_api.g_number,
111: p_user_id in number default hr_api.g_number,
112: p_action_cd in varchar2 default hr_api.g_varchar2,
113: p_budget_unit1_percent in number default hr_api.g_number,
114: p_budget_unit1_value in number default hr_api.g_number,
115: p_budget_unit2_percent in number default hr_api.g_number,
116: p_budget_unit2_value in number default hr_api.g_number,
117: p_budget_unit3_percent in number default hr_api.g_number,
110: p_parent_worksheet_detail_id in number default hr_api.g_number,
111: p_user_id in number default hr_api.g_number,
112: p_action_cd in varchar2 default hr_api.g_varchar2,
113: p_budget_unit1_percent in number default hr_api.g_number,
114: p_budget_unit1_value in number default hr_api.g_number,
115: p_budget_unit2_percent in number default hr_api.g_number,
116: p_budget_unit2_value in number default hr_api.g_number,
117: p_budget_unit3_percent in number default hr_api.g_number,
118: p_budget_unit3_value in number default hr_api.g_number,
111: p_user_id in number default hr_api.g_number,
112: p_action_cd in varchar2 default hr_api.g_varchar2,
113: p_budget_unit1_percent in number default hr_api.g_number,
114: p_budget_unit1_value in number default hr_api.g_number,
115: p_budget_unit2_percent in number default hr_api.g_number,
116: p_budget_unit2_value in number default hr_api.g_number,
117: p_budget_unit3_percent in number default hr_api.g_number,
118: p_budget_unit3_value in number default hr_api.g_number,
119: p_object_version_number in out nocopy number,
112: p_action_cd in varchar2 default hr_api.g_varchar2,
113: p_budget_unit1_percent in number default hr_api.g_number,
114: p_budget_unit1_value in number default hr_api.g_number,
115: p_budget_unit2_percent in number default hr_api.g_number,
116: p_budget_unit2_value in number default hr_api.g_number,
117: p_budget_unit3_percent in number default hr_api.g_number,
118: p_budget_unit3_value in number default hr_api.g_number,
119: p_object_version_number in out nocopy number,
120: p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2,
113: p_budget_unit1_percent in number default hr_api.g_number,
114: p_budget_unit1_value in number default hr_api.g_number,
115: p_budget_unit2_percent in number default hr_api.g_number,
116: p_budget_unit2_value in number default hr_api.g_number,
117: p_budget_unit3_percent in number default hr_api.g_number,
118: p_budget_unit3_value in number default hr_api.g_number,
119: p_object_version_number in out nocopy number,
120: p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2,
121: p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2,
114: p_budget_unit1_value in number default hr_api.g_number,
115: p_budget_unit2_percent in number default hr_api.g_number,
116: p_budget_unit2_value in number default hr_api.g_number,
117: p_budget_unit3_percent in number default hr_api.g_number,
118: p_budget_unit3_value in number default hr_api.g_number,
119: p_object_version_number in out nocopy number,
120: p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2,
121: p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2,
122: p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2,
116: p_budget_unit2_value in number default hr_api.g_number,
117: p_budget_unit3_percent in number default hr_api.g_number,
118: p_budget_unit3_value in number default hr_api.g_number,
119: p_object_version_number in out nocopy number,
120: p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2,
121: p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2,
122: p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2,
123: p_status in varchar2 default hr_api.g_varchar2,
124: p_budget_unit1_available in number default hr_api.g_number,
117: p_budget_unit3_percent in number default hr_api.g_number,
118: p_budget_unit3_value in number default hr_api.g_number,
119: p_object_version_number in out nocopy number,
120: p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2,
121: p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2,
122: p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2,
123: p_status in varchar2 default hr_api.g_varchar2,
124: p_budget_unit1_available in number default hr_api.g_number,
125: p_budget_unit2_available in number default hr_api.g_number,
118: p_budget_unit3_value in number default hr_api.g_number,
119: p_object_version_number in out nocopy number,
120: p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2,
121: p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2,
122: p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2,
123: p_status in varchar2 default hr_api.g_varchar2,
124: p_budget_unit1_available in number default hr_api.g_number,
125: p_budget_unit2_available in number default hr_api.g_number,
126: p_budget_unit3_available in number default hr_api.g_number,
119: p_object_version_number in out nocopy number,
120: p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2,
121: p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2,
122: p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2,
123: p_status in varchar2 default hr_api.g_varchar2,
124: p_budget_unit1_available in number default hr_api.g_number,
125: p_budget_unit2_available in number default hr_api.g_number,
126: p_budget_unit3_available in number default hr_api.g_number,
127: p_old_unit1_value in number default hr_api.g_number,
120: p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2,
121: p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2,
122: p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2,
123: p_status in varchar2 default hr_api.g_varchar2,
124: p_budget_unit1_available in number default hr_api.g_number,
125: p_budget_unit2_available in number default hr_api.g_number,
126: p_budget_unit3_available in number default hr_api.g_number,
127: p_old_unit1_value in number default hr_api.g_number,
128: p_old_unit2_value in number default hr_api.g_number,
121: p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2,
122: p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2,
123: p_status in varchar2 default hr_api.g_varchar2,
124: p_budget_unit1_available in number default hr_api.g_number,
125: p_budget_unit2_available in number default hr_api.g_number,
126: p_budget_unit3_available in number default hr_api.g_number,
127: p_old_unit1_value in number default hr_api.g_number,
128: p_old_unit2_value in number default hr_api.g_number,
129: p_old_unit3_value in number default hr_api.g_number,
122: p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2,
123: p_status in varchar2 default hr_api.g_varchar2,
124: p_budget_unit1_available in number default hr_api.g_number,
125: p_budget_unit2_available in number default hr_api.g_number,
126: p_budget_unit3_available in number default hr_api.g_number,
127: p_old_unit1_value in number default hr_api.g_number,
128: p_old_unit2_value in number default hr_api.g_number,
129: p_old_unit3_value in number default hr_api.g_number,
130: p_defer_flag in varchar2 default hr_api.g_varchar2,
123: p_status in varchar2 default hr_api.g_varchar2,
124: p_budget_unit1_available in number default hr_api.g_number,
125: p_budget_unit2_available in number default hr_api.g_number,
126: p_budget_unit3_available in number default hr_api.g_number,
127: p_old_unit1_value in number default hr_api.g_number,
128: p_old_unit2_value in number default hr_api.g_number,
129: p_old_unit3_value in number default hr_api.g_number,
130: p_defer_flag in varchar2 default hr_api.g_varchar2,
131: p_propagation_method in varchar2 default hr_api.g_varchar2
124: p_budget_unit1_available in number default hr_api.g_number,
125: p_budget_unit2_available in number default hr_api.g_number,
126: p_budget_unit3_available in number default hr_api.g_number,
127: p_old_unit1_value in number default hr_api.g_number,
128: p_old_unit2_value in number default hr_api.g_number,
129: p_old_unit3_value in number default hr_api.g_number,
130: p_defer_flag in varchar2 default hr_api.g_varchar2,
131: p_propagation_method in varchar2 default hr_api.g_varchar2
132: );
125: p_budget_unit2_available in number default hr_api.g_number,
126: p_budget_unit3_available in number default hr_api.g_number,
127: p_old_unit1_value in number default hr_api.g_number,
128: p_old_unit2_value in number default hr_api.g_number,
129: p_old_unit3_value in number default hr_api.g_number,
130: p_defer_flag in varchar2 default hr_api.g_varchar2,
131: p_propagation_method in varchar2 default hr_api.g_varchar2
132: );
133: --
126: p_budget_unit3_available in number default hr_api.g_number,
127: p_old_unit1_value in number default hr_api.g_number,
128: p_old_unit2_value in number default hr_api.g_number,
129: p_old_unit3_value in number default hr_api.g_number,
130: p_defer_flag in varchar2 default hr_api.g_varchar2,
131: p_propagation_method in varchar2 default hr_api.g_varchar2
132: );
133: --
134: end pqh_wdt_upd;
127: p_old_unit1_value in number default hr_api.g_number,
128: p_old_unit2_value in number default hr_api.g_number,
129: p_old_unit3_value in number default hr_api.g_number,
130: p_defer_flag in varchar2 default hr_api.g_varchar2,
131: p_propagation_method in varchar2 default hr_api.g_varchar2
132: );
133: --
134: end pqh_wdt_upd;