99: Procedure upd
100: (
101: p_effective_date in date,
102: p_worksheet_period_id in number,
103: p_end_time_period_id in number default hr_api.g_number,
104: p_worksheet_detail_id in number default hr_api.g_number,
105: p_budget_unit1_percent in number default hr_api.g_number,
106: p_budget_unit2_percent in number default hr_api.g_number,
107: p_budget_unit3_percent in number default hr_api.g_number,
100: (
101: p_effective_date in date,
102: p_worksheet_period_id in number,
103: p_end_time_period_id in number default hr_api.g_number,
104: p_worksheet_detail_id in number default hr_api.g_number,
105: p_budget_unit1_percent in number default hr_api.g_number,
106: p_budget_unit2_percent in number default hr_api.g_number,
107: p_budget_unit3_percent in number default hr_api.g_number,
108: p_budget_unit1_value in number default hr_api.g_number,
101: p_effective_date in date,
102: p_worksheet_period_id in number,
103: p_end_time_period_id in number default hr_api.g_number,
104: p_worksheet_detail_id in number default hr_api.g_number,
105: p_budget_unit1_percent in number default hr_api.g_number,
106: p_budget_unit2_percent in number default hr_api.g_number,
107: p_budget_unit3_percent in number default hr_api.g_number,
108: p_budget_unit1_value in number default hr_api.g_number,
109: p_budget_unit2_value in number default hr_api.g_number,
102: p_worksheet_period_id in number,
103: p_end_time_period_id in number default hr_api.g_number,
104: p_worksheet_detail_id in number default hr_api.g_number,
105: p_budget_unit1_percent in number default hr_api.g_number,
106: p_budget_unit2_percent in number default hr_api.g_number,
107: p_budget_unit3_percent in number default hr_api.g_number,
108: p_budget_unit1_value in number default hr_api.g_number,
109: p_budget_unit2_value in number default hr_api.g_number,
110: p_budget_unit3_value in number default hr_api.g_number,
103: p_end_time_period_id in number default hr_api.g_number,
104: p_worksheet_detail_id in number default hr_api.g_number,
105: p_budget_unit1_percent in number default hr_api.g_number,
106: p_budget_unit2_percent in number default hr_api.g_number,
107: p_budget_unit3_percent in number default hr_api.g_number,
108: p_budget_unit1_value in number default hr_api.g_number,
109: p_budget_unit2_value in number default hr_api.g_number,
110: p_budget_unit3_value in number default hr_api.g_number,
111: p_object_version_number in out nocopy number,
104: p_worksheet_detail_id in number default hr_api.g_number,
105: p_budget_unit1_percent in number default hr_api.g_number,
106: p_budget_unit2_percent in number default hr_api.g_number,
107: p_budget_unit3_percent in number default hr_api.g_number,
108: p_budget_unit1_value in number default hr_api.g_number,
109: p_budget_unit2_value in number default hr_api.g_number,
110: p_budget_unit3_value in number default hr_api.g_number,
111: p_object_version_number in out nocopy number,
112: p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2,
105: p_budget_unit1_percent in number default hr_api.g_number,
106: p_budget_unit2_percent in number default hr_api.g_number,
107: p_budget_unit3_percent in number default hr_api.g_number,
108: p_budget_unit1_value in number default hr_api.g_number,
109: p_budget_unit2_value in number default hr_api.g_number,
110: p_budget_unit3_value in number default hr_api.g_number,
111: p_object_version_number in out nocopy number,
112: p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2,
113: p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2,
106: p_budget_unit2_percent in number default hr_api.g_number,
107: p_budget_unit3_percent in number default hr_api.g_number,
108: p_budget_unit1_value in number default hr_api.g_number,
109: p_budget_unit2_value in number default hr_api.g_number,
110: p_budget_unit3_value in number default hr_api.g_number,
111: p_object_version_number in out nocopy number,
112: p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2,
113: p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2,
114: p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2,
108: p_budget_unit1_value in number default hr_api.g_number,
109: p_budget_unit2_value in number default hr_api.g_number,
110: p_budget_unit3_value in number default hr_api.g_number,
111: p_object_version_number in out nocopy number,
112: p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2,
113: p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2,
114: p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2,
115: p_start_time_period_id in number default hr_api.g_number,
116: p_budget_unit3_available in number default hr_api.g_number,
109: p_budget_unit2_value in number default hr_api.g_number,
110: p_budget_unit3_value in number default hr_api.g_number,
111: p_object_version_number in out nocopy number,
112: p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2,
113: p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2,
114: p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2,
115: p_start_time_period_id in number default hr_api.g_number,
116: p_budget_unit3_available in number default hr_api.g_number,
117: p_budget_unit2_available in number default hr_api.g_number,
110: p_budget_unit3_value in number default hr_api.g_number,
111: p_object_version_number in out nocopy number,
112: p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2,
113: p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2,
114: p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2,
115: p_start_time_period_id in number default hr_api.g_number,
116: p_budget_unit3_available in number default hr_api.g_number,
117: p_budget_unit2_available in number default hr_api.g_number,
118: p_budget_unit1_available in number default hr_api.g_number
111: p_object_version_number in out nocopy number,
112: p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2,
113: p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2,
114: p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2,
115: p_start_time_period_id in number default hr_api.g_number,
116: p_budget_unit3_available in number default hr_api.g_number,
117: p_budget_unit2_available in number default hr_api.g_number,
118: p_budget_unit1_available in number default hr_api.g_number
119: );
112: p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2,
113: p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2,
114: p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2,
115: p_start_time_period_id in number default hr_api.g_number,
116: p_budget_unit3_available in number default hr_api.g_number,
117: p_budget_unit2_available in number default hr_api.g_number,
118: p_budget_unit1_available in number default hr_api.g_number
119: );
120: --
113: p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2,
114: p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2,
115: p_start_time_period_id in number default hr_api.g_number,
116: p_budget_unit3_available in number default hr_api.g_number,
117: p_budget_unit2_available in number default hr_api.g_number,
118: p_budget_unit1_available in number default hr_api.g_number
119: );
120: --
121: end pqh_wpr_upd;
114: p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2,
115: p_start_time_period_id in number default hr_api.g_number,
116: p_budget_unit3_available in number default hr_api.g_number,
117: p_budget_unit2_available in number default hr_api.g_number,
118: p_budget_unit1_available in number default hr_api.g_number
119: );
120: --
121: end pqh_wpr_upd;