99: Procedure upd
100: (
101: p_effective_date in date,
102: p_budget_set_id in number,
103: p_dflt_budget_set_id in number default hr_api.g_number,
104: p_budget_period_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_budget_set_id in number,
103: p_dflt_budget_set_id in number default hr_api.g_number,
104: p_budget_period_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_budget_set_id in number,
103: p_dflt_budget_set_id in number default hr_api.g_number,
104: p_budget_period_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_budget_set_id in number,
103: p_dflt_budget_set_id in number default hr_api.g_number,
104: p_budget_period_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_dflt_budget_set_id in number default hr_api.g_number,
104: p_budget_period_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_budget_unit1_available in number default hr_api.g_number,
104: p_budget_period_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_budget_unit1_available in number default hr_api.g_number,
112: p_budget_unit2_available 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_budget_unit1_available in number default hr_api.g_number,
112: p_budget_unit2_available in number default hr_api.g_number,
113: p_budget_unit3_available 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_budget_unit1_available in number default hr_api.g_number,
112: p_budget_unit2_available in number default hr_api.g_number,
113: p_budget_unit3_available in number default hr_api.g_number,
114: p_object_version_number in out nocopy 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_budget_unit1_available in number default hr_api.g_number,
112: p_budget_unit2_available in number default hr_api.g_number,
113: p_budget_unit3_available in number default hr_api.g_number,
114: p_object_version_number in out nocopy number,
115: p_budget_unit1_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_budget_unit1_available in number default hr_api.g_number,
112: p_budget_unit2_available in number default hr_api.g_number,
113: p_budget_unit3_available in number default hr_api.g_number,
114: p_object_version_number in out nocopy number,
115: p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2,
116: p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2,
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_budget_unit1_available in number default hr_api.g_number,
112: p_budget_unit2_available in number default hr_api.g_number,
113: p_budget_unit3_available in number default hr_api.g_number,
114: p_object_version_number in out nocopy number,
115: p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2,
116: p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2,
117: p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2
111: p_budget_unit1_available in number default hr_api.g_number,
112: p_budget_unit2_available in number default hr_api.g_number,
113: p_budget_unit3_available in number default hr_api.g_number,
114: p_object_version_number in out nocopy number,
115: p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2,
116: p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2,
117: p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2
118: );
119: --
112: p_budget_unit2_available in number default hr_api.g_number,
113: p_budget_unit3_available in number default hr_api.g_number,
114: p_object_version_number in out nocopy number,
115: p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2,
116: p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2,
117: p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2
118: );
119: --
120: end pqh_bst_upd;
113: p_budget_unit3_available in number default hr_api.g_number,
114: p_object_version_number in out nocopy number,
115: p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2,
116: p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2,
117: p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2
118: );
119: --
120: end pqh_bst_upd;