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