30: procedure update_budget_version
31: (
32: p_validate in boolean default false
33: ,p_budget_version_id in number
34: ,p_budget_id in number default hr_api.g_number
35: ,p_version_number in number default hr_api.g_number
36: ,p_date_from in date default hr_api.g_date
37: ,p_date_to in date default hr_api.g_date
38: ,p_transfered_to_gl_flag in varchar2 default hr_api.g_varchar2
31: (
32: p_validate in boolean default false
33: ,p_budget_version_id in number
34: ,p_budget_id in number default hr_api.g_number
35: ,p_version_number in number default hr_api.g_number
36: ,p_date_from in date default hr_api.g_date
37: ,p_date_to in date default hr_api.g_date
38: ,p_transfered_to_gl_flag in varchar2 default hr_api.g_varchar2
39: ,p_gl_status in varchar2 default hr_api.g_varchar2
32: p_validate in boolean default false
33: ,p_budget_version_id in number
34: ,p_budget_id in number default hr_api.g_number
35: ,p_version_number in number default hr_api.g_number
36: ,p_date_from in date default hr_api.g_date
37: ,p_date_to in date default hr_api.g_date
38: ,p_transfered_to_gl_flag in varchar2 default hr_api.g_varchar2
39: ,p_gl_status in varchar2 default hr_api.g_varchar2
40: ,p_xfer_to_other_apps_cd in varchar2 default hr_api.g_varchar2
33: ,p_budget_version_id in number
34: ,p_budget_id in number default hr_api.g_number
35: ,p_version_number in number default hr_api.g_number
36: ,p_date_from in date default hr_api.g_date
37: ,p_date_to in date default hr_api.g_date
38: ,p_transfered_to_gl_flag in varchar2 default hr_api.g_varchar2
39: ,p_gl_status in varchar2 default hr_api.g_varchar2
40: ,p_xfer_to_other_apps_cd in varchar2 default hr_api.g_varchar2
41: ,p_object_version_number in out nocopy number
34: ,p_budget_id in number default hr_api.g_number
35: ,p_version_number in number default hr_api.g_number
36: ,p_date_from in date default hr_api.g_date
37: ,p_date_to in date default hr_api.g_date
38: ,p_transfered_to_gl_flag in varchar2 default hr_api.g_varchar2
39: ,p_gl_status in varchar2 default hr_api.g_varchar2
40: ,p_xfer_to_other_apps_cd in varchar2 default hr_api.g_varchar2
41: ,p_object_version_number in out nocopy number
42: ,p_budget_unit1_value in number default hr_api.g_number
35: ,p_version_number in number default hr_api.g_number
36: ,p_date_from in date default hr_api.g_date
37: ,p_date_to in date default hr_api.g_date
38: ,p_transfered_to_gl_flag in varchar2 default hr_api.g_varchar2
39: ,p_gl_status in varchar2 default hr_api.g_varchar2
40: ,p_xfer_to_other_apps_cd in varchar2 default hr_api.g_varchar2
41: ,p_object_version_number in out nocopy number
42: ,p_budget_unit1_value in number default hr_api.g_number
43: ,p_budget_unit2_value in number default hr_api.g_number
36: ,p_date_from in date default hr_api.g_date
37: ,p_date_to in date default hr_api.g_date
38: ,p_transfered_to_gl_flag in varchar2 default hr_api.g_varchar2
39: ,p_gl_status in varchar2 default hr_api.g_varchar2
40: ,p_xfer_to_other_apps_cd in varchar2 default hr_api.g_varchar2
41: ,p_object_version_number in out nocopy number
42: ,p_budget_unit1_value in number default hr_api.g_number
43: ,p_budget_unit2_value in number default hr_api.g_number
44: ,p_budget_unit3_value in number default hr_api.g_number
38: ,p_transfered_to_gl_flag in varchar2 default hr_api.g_varchar2
39: ,p_gl_status in varchar2 default hr_api.g_varchar2
40: ,p_xfer_to_other_apps_cd in varchar2 default hr_api.g_varchar2
41: ,p_object_version_number in out nocopy number
42: ,p_budget_unit1_value in number default hr_api.g_number
43: ,p_budget_unit2_value in number default hr_api.g_number
44: ,p_budget_unit3_value in number default hr_api.g_number
45: ,p_budget_unit1_available in number default hr_api.g_number
46: ,p_budget_unit2_available in number default hr_api.g_number
39: ,p_gl_status in varchar2 default hr_api.g_varchar2
40: ,p_xfer_to_other_apps_cd in varchar2 default hr_api.g_varchar2
41: ,p_object_version_number in out nocopy number
42: ,p_budget_unit1_value in number default hr_api.g_number
43: ,p_budget_unit2_value in number default hr_api.g_number
44: ,p_budget_unit3_value in number default hr_api.g_number
45: ,p_budget_unit1_available in number default hr_api.g_number
46: ,p_budget_unit2_available in number default hr_api.g_number
47: ,p_budget_unit3_available in number default hr_api.g_number
40: ,p_xfer_to_other_apps_cd in varchar2 default hr_api.g_varchar2
41: ,p_object_version_number in out nocopy number
42: ,p_budget_unit1_value in number default hr_api.g_number
43: ,p_budget_unit2_value in number default hr_api.g_number
44: ,p_budget_unit3_value in number default hr_api.g_number
45: ,p_budget_unit1_available in number default hr_api.g_number
46: ,p_budget_unit2_available in number default hr_api.g_number
47: ,p_budget_unit3_available in number default hr_api.g_number
48: ,p_effective_date in date
41: ,p_object_version_number in out nocopy number
42: ,p_budget_unit1_value in number default hr_api.g_number
43: ,p_budget_unit2_value in number default hr_api.g_number
44: ,p_budget_unit3_value in number default hr_api.g_number
45: ,p_budget_unit1_available in number default hr_api.g_number
46: ,p_budget_unit2_available in number default hr_api.g_number
47: ,p_budget_unit3_available in number default hr_api.g_number
48: ,p_effective_date in date
49: );
42: ,p_budget_unit1_value in number default hr_api.g_number
43: ,p_budget_unit2_value in number default hr_api.g_number
44: ,p_budget_unit3_value in number default hr_api.g_number
45: ,p_budget_unit1_available in number default hr_api.g_number
46: ,p_budget_unit2_available in number default hr_api.g_number
47: ,p_budget_unit3_available in number default hr_api.g_number
48: ,p_effective_date in date
49: );
50: -- ----------------------------------------------------------------------------
43: ,p_budget_unit2_value in number default hr_api.g_number
44: ,p_budget_unit3_value in number default hr_api.g_number
45: ,p_budget_unit1_available in number default hr_api.g_number
46: ,p_budget_unit2_available in number default hr_api.g_number
47: ,p_budget_unit3_available in number default hr_api.g_number
48: ,p_effective_date in date
49: );
50: -- ----------------------------------------------------------------------------
51: -- |------------------------< create_budget_element >------------------------|
65: procedure update_budget_element
66: (
67: p_validate in boolean default false
68: ,p_budget_element_id in number
69: ,p_budget_set_id in number default hr_api.g_number
70: ,p_element_type_id in number default hr_api.g_number
71: ,p_distribution_percentage in number default hr_api.g_number
72: ,p_object_version_number in out nocopy number
73: );
66: (
67: p_validate in boolean default false
68: ,p_budget_element_id in number
69: ,p_budget_set_id in number default hr_api.g_number
70: ,p_element_type_id in number default hr_api.g_number
71: ,p_distribution_percentage in number default hr_api.g_number
72: ,p_object_version_number in out nocopy number
73: );
74: -- ----------------------------------------------------------------------------
67: p_validate in boolean default false
68: ,p_budget_element_id in number
69: ,p_budget_set_id in number default hr_api.g_number
70: ,p_element_type_id in number default hr_api.g_number
71: ,p_distribution_percentage in number default hr_api.g_number
72: ,p_object_version_number in out nocopy number
73: );
74: -- ----------------------------------------------------------------------------
75: -- |------------------------< create_budget_fund_src >------------------------|
94: procedure update_budget_fund_src
95: (
96: p_validate in boolean default false
97: ,p_budget_fund_src_id in number
98: ,p_budget_element_id in number default hr_api.g_number
99: ,p_cost_allocation_keyflex_id in number default hr_api.g_number
100: ,p_project_id in number default hr_api.g_number
101: ,p_award_id in number default hr_api.g_number
102: ,p_task_id in number default hr_api.g_number
95: (
96: p_validate in boolean default false
97: ,p_budget_fund_src_id in number
98: ,p_budget_element_id in number default hr_api.g_number
99: ,p_cost_allocation_keyflex_id in number default hr_api.g_number
100: ,p_project_id in number default hr_api.g_number
101: ,p_award_id in number default hr_api.g_number
102: ,p_task_id in number default hr_api.g_number
103: ,p_expenditure_type in varchar2 default hr_api.g_varchar2
96: p_validate in boolean default false
97: ,p_budget_fund_src_id in number
98: ,p_budget_element_id in number default hr_api.g_number
99: ,p_cost_allocation_keyflex_id in number default hr_api.g_number
100: ,p_project_id in number default hr_api.g_number
101: ,p_award_id in number default hr_api.g_number
102: ,p_task_id in number default hr_api.g_number
103: ,p_expenditure_type in varchar2 default hr_api.g_varchar2
104: ,p_organization_id in number default hr_api.g_number
97: ,p_budget_fund_src_id in number
98: ,p_budget_element_id in number default hr_api.g_number
99: ,p_cost_allocation_keyflex_id in number default hr_api.g_number
100: ,p_project_id in number default hr_api.g_number
101: ,p_award_id in number default hr_api.g_number
102: ,p_task_id in number default hr_api.g_number
103: ,p_expenditure_type in varchar2 default hr_api.g_varchar2
104: ,p_organization_id in number default hr_api.g_number
105: ,p_distribution_percentage in number default hr_api.g_number
98: ,p_budget_element_id in number default hr_api.g_number
99: ,p_cost_allocation_keyflex_id in number default hr_api.g_number
100: ,p_project_id in number default hr_api.g_number
101: ,p_award_id in number default hr_api.g_number
102: ,p_task_id in number default hr_api.g_number
103: ,p_expenditure_type in varchar2 default hr_api.g_varchar2
104: ,p_organization_id in number default hr_api.g_number
105: ,p_distribution_percentage in number default hr_api.g_number
106: ,p_object_version_number in out nocopy number
99: ,p_cost_allocation_keyflex_id in number default hr_api.g_number
100: ,p_project_id in number default hr_api.g_number
101: ,p_award_id in number default hr_api.g_number
102: ,p_task_id in number default hr_api.g_number
103: ,p_expenditure_type in varchar2 default hr_api.g_varchar2
104: ,p_organization_id in number default hr_api.g_number
105: ,p_distribution_percentage in number default hr_api.g_number
106: ,p_object_version_number in out nocopy number
107: );
100: ,p_project_id in number default hr_api.g_number
101: ,p_award_id in number default hr_api.g_number
102: ,p_task_id in number default hr_api.g_number
103: ,p_expenditure_type in varchar2 default hr_api.g_varchar2
104: ,p_organization_id in number default hr_api.g_number
105: ,p_distribution_percentage in number default hr_api.g_number
106: ,p_object_version_number in out nocopy number
107: );
108: -- ----------------------------------------------------------------------------
101: ,p_award_id in number default hr_api.g_number
102: ,p_task_id in number default hr_api.g_number
103: ,p_expenditure_type in varchar2 default hr_api.g_varchar2
104: ,p_organization_id in number default hr_api.g_number
105: ,p_distribution_percentage in number default hr_api.g_number
106: ,p_object_version_number in out nocopy number
107: );
108: -- ----------------------------------------------------------------------------
109: -- |------------------------< create_budget_period >------------------------|
135: procedure update_budget_period
136: (
137: p_validate in boolean default false
138: ,p_budget_period_id in number
139: ,p_budget_detail_id in number default hr_api.g_number
140: ,p_start_time_period_id in number default hr_api.g_number
141: ,p_end_time_period_id in number default hr_api.g_number
142: ,p_budget_unit1_percent in number default hr_api.g_number
143: ,p_budget_unit2_percent in number default hr_api.g_number
136: (
137: p_validate in boolean default false
138: ,p_budget_period_id in number
139: ,p_budget_detail_id in number default hr_api.g_number
140: ,p_start_time_period_id in number default hr_api.g_number
141: ,p_end_time_period_id in number default hr_api.g_number
142: ,p_budget_unit1_percent in number default hr_api.g_number
143: ,p_budget_unit2_percent in number default hr_api.g_number
144: ,p_budget_unit3_percent in number default hr_api.g_number
137: p_validate in boolean default false
138: ,p_budget_period_id in number
139: ,p_budget_detail_id in number default hr_api.g_number
140: ,p_start_time_period_id in number default hr_api.g_number
141: ,p_end_time_period_id in number default hr_api.g_number
142: ,p_budget_unit1_percent in number default hr_api.g_number
143: ,p_budget_unit2_percent in number default hr_api.g_number
144: ,p_budget_unit3_percent in number default hr_api.g_number
145: ,p_budget_unit1_value in number default hr_api.g_number
138: ,p_budget_period_id in number
139: ,p_budget_detail_id in number default hr_api.g_number
140: ,p_start_time_period_id in number default hr_api.g_number
141: ,p_end_time_period_id in number default hr_api.g_number
142: ,p_budget_unit1_percent in number default hr_api.g_number
143: ,p_budget_unit2_percent in number default hr_api.g_number
144: ,p_budget_unit3_percent in number default hr_api.g_number
145: ,p_budget_unit1_value in number default hr_api.g_number
146: ,p_budget_unit2_value in number default hr_api.g_number
139: ,p_budget_detail_id in number default hr_api.g_number
140: ,p_start_time_period_id in number default hr_api.g_number
141: ,p_end_time_period_id in number default hr_api.g_number
142: ,p_budget_unit1_percent in number default hr_api.g_number
143: ,p_budget_unit2_percent in number default hr_api.g_number
144: ,p_budget_unit3_percent in number default hr_api.g_number
145: ,p_budget_unit1_value in number default hr_api.g_number
146: ,p_budget_unit2_value in number default hr_api.g_number
147: ,p_budget_unit3_value in number default hr_api.g_number
140: ,p_start_time_period_id in number default hr_api.g_number
141: ,p_end_time_period_id in number default hr_api.g_number
142: ,p_budget_unit1_percent in number default hr_api.g_number
143: ,p_budget_unit2_percent in number default hr_api.g_number
144: ,p_budget_unit3_percent in number default hr_api.g_number
145: ,p_budget_unit1_value in number default hr_api.g_number
146: ,p_budget_unit2_value in number default hr_api.g_number
147: ,p_budget_unit3_value in number default hr_api.g_number
148: ,p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2
141: ,p_end_time_period_id in number default hr_api.g_number
142: ,p_budget_unit1_percent in number default hr_api.g_number
143: ,p_budget_unit2_percent in number default hr_api.g_number
144: ,p_budget_unit3_percent in number default hr_api.g_number
145: ,p_budget_unit1_value in number default hr_api.g_number
146: ,p_budget_unit2_value in number default hr_api.g_number
147: ,p_budget_unit3_value in number default hr_api.g_number
148: ,p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2
149: ,p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2
142: ,p_budget_unit1_percent in number default hr_api.g_number
143: ,p_budget_unit2_percent in number default hr_api.g_number
144: ,p_budget_unit3_percent in number default hr_api.g_number
145: ,p_budget_unit1_value in number default hr_api.g_number
146: ,p_budget_unit2_value in number default hr_api.g_number
147: ,p_budget_unit3_value in number default hr_api.g_number
148: ,p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2
149: ,p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2
150: ,p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2
143: ,p_budget_unit2_percent in number default hr_api.g_number
144: ,p_budget_unit3_percent in number default hr_api.g_number
145: ,p_budget_unit1_value in number default hr_api.g_number
146: ,p_budget_unit2_value in number default hr_api.g_number
147: ,p_budget_unit3_value in number default hr_api.g_number
148: ,p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2
149: ,p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2
150: ,p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2
151: ,p_budget_unit1_available in number default hr_api.g_number
144: ,p_budget_unit3_percent in number default hr_api.g_number
145: ,p_budget_unit1_value in number default hr_api.g_number
146: ,p_budget_unit2_value in number default hr_api.g_number
147: ,p_budget_unit3_value in number default hr_api.g_number
148: ,p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2
149: ,p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2
150: ,p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2
151: ,p_budget_unit1_available in number default hr_api.g_number
152: ,p_budget_unit2_available in number default hr_api.g_number
145: ,p_budget_unit1_value in number default hr_api.g_number
146: ,p_budget_unit2_value in number default hr_api.g_number
147: ,p_budget_unit3_value in number default hr_api.g_number
148: ,p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2
149: ,p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2
150: ,p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2
151: ,p_budget_unit1_available in number default hr_api.g_number
152: ,p_budget_unit2_available in number default hr_api.g_number
153: ,p_budget_unit3_available in number default hr_api.g_number
146: ,p_budget_unit2_value in number default hr_api.g_number
147: ,p_budget_unit3_value in number default hr_api.g_number
148: ,p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2
149: ,p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2
150: ,p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2
151: ,p_budget_unit1_available in number default hr_api.g_number
152: ,p_budget_unit2_available in number default hr_api.g_number
153: ,p_budget_unit3_available in number default hr_api.g_number
154: ,p_object_version_number in out nocopy number
147: ,p_budget_unit3_value in number default hr_api.g_number
148: ,p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2
149: ,p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2
150: ,p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2
151: ,p_budget_unit1_available in number default hr_api.g_number
152: ,p_budget_unit2_available in number default hr_api.g_number
153: ,p_budget_unit3_available in number default hr_api.g_number
154: ,p_object_version_number in out nocopy number
155: );
148: ,p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2
149: ,p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2
150: ,p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2
151: ,p_budget_unit1_available in number default hr_api.g_number
152: ,p_budget_unit2_available in number default hr_api.g_number
153: ,p_budget_unit3_available in number default hr_api.g_number
154: ,p_object_version_number in out nocopy number
155: );
156: -- ----------------------------------------------------------------------------
149: ,p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2
150: ,p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2
151: ,p_budget_unit1_available in number default hr_api.g_number
152: ,p_budget_unit2_available in number default hr_api.g_number
153: ,p_budget_unit3_available in number default hr_api.g_number
154: ,p_object_version_number in out nocopy number
155: );
156: -- ----------------------------------------------------------------------------
157: -- |------------------------< create_budget_set >------------------------|
183: procedure update_budget_set
184: (
185: p_validate in boolean default false
186: ,p_budget_set_id in number
187: ,p_dflt_budget_set_id in number default hr_api.g_number
188: ,p_budget_period_id in number default hr_api.g_number
189: ,p_budget_unit1_percent in number default hr_api.g_number
190: ,p_budget_unit2_percent in number default hr_api.g_number
191: ,p_budget_unit3_percent in number default hr_api.g_number
184: (
185: p_validate in boolean default false
186: ,p_budget_set_id in number
187: ,p_dflt_budget_set_id in number default hr_api.g_number
188: ,p_budget_period_id in number default hr_api.g_number
189: ,p_budget_unit1_percent in number default hr_api.g_number
190: ,p_budget_unit2_percent in number default hr_api.g_number
191: ,p_budget_unit3_percent in number default hr_api.g_number
192: ,p_budget_unit1_value in number default hr_api.g_number
185: p_validate in boolean default false
186: ,p_budget_set_id in number
187: ,p_dflt_budget_set_id in number default hr_api.g_number
188: ,p_budget_period_id in number default hr_api.g_number
189: ,p_budget_unit1_percent in number default hr_api.g_number
190: ,p_budget_unit2_percent in number default hr_api.g_number
191: ,p_budget_unit3_percent in number default hr_api.g_number
192: ,p_budget_unit1_value in number default hr_api.g_number
193: ,p_budget_unit2_value in number default hr_api.g_number
186: ,p_budget_set_id in number
187: ,p_dflt_budget_set_id in number default hr_api.g_number
188: ,p_budget_period_id in number default hr_api.g_number
189: ,p_budget_unit1_percent in number default hr_api.g_number
190: ,p_budget_unit2_percent in number default hr_api.g_number
191: ,p_budget_unit3_percent in number default hr_api.g_number
192: ,p_budget_unit1_value in number default hr_api.g_number
193: ,p_budget_unit2_value in number default hr_api.g_number
194: ,p_budget_unit3_value in number default hr_api.g_number
187: ,p_dflt_budget_set_id in number default hr_api.g_number
188: ,p_budget_period_id in number default hr_api.g_number
189: ,p_budget_unit1_percent in number default hr_api.g_number
190: ,p_budget_unit2_percent in number default hr_api.g_number
191: ,p_budget_unit3_percent in number default hr_api.g_number
192: ,p_budget_unit1_value in number default hr_api.g_number
193: ,p_budget_unit2_value in number default hr_api.g_number
194: ,p_budget_unit3_value in number default hr_api.g_number
195: ,p_budget_unit1_available in number default hr_api.g_number
188: ,p_budget_period_id in number default hr_api.g_number
189: ,p_budget_unit1_percent in number default hr_api.g_number
190: ,p_budget_unit2_percent in number default hr_api.g_number
191: ,p_budget_unit3_percent in number default hr_api.g_number
192: ,p_budget_unit1_value in number default hr_api.g_number
193: ,p_budget_unit2_value in number default hr_api.g_number
194: ,p_budget_unit3_value in number default hr_api.g_number
195: ,p_budget_unit1_available in number default hr_api.g_number
196: ,p_budget_unit2_available in number default hr_api.g_number
189: ,p_budget_unit1_percent in number default hr_api.g_number
190: ,p_budget_unit2_percent in number default hr_api.g_number
191: ,p_budget_unit3_percent in number default hr_api.g_number
192: ,p_budget_unit1_value in number default hr_api.g_number
193: ,p_budget_unit2_value in number default hr_api.g_number
194: ,p_budget_unit3_value in number default hr_api.g_number
195: ,p_budget_unit1_available in number default hr_api.g_number
196: ,p_budget_unit2_available in number default hr_api.g_number
197: ,p_budget_unit3_available in number default hr_api.g_number
190: ,p_budget_unit2_percent in number default hr_api.g_number
191: ,p_budget_unit3_percent in number default hr_api.g_number
192: ,p_budget_unit1_value in number default hr_api.g_number
193: ,p_budget_unit2_value in number default hr_api.g_number
194: ,p_budget_unit3_value in number default hr_api.g_number
195: ,p_budget_unit1_available in number default hr_api.g_number
196: ,p_budget_unit2_available in number default hr_api.g_number
197: ,p_budget_unit3_available in number default hr_api.g_number
198: ,p_object_version_number in out nocopy number
191: ,p_budget_unit3_percent in number default hr_api.g_number
192: ,p_budget_unit1_value in number default hr_api.g_number
193: ,p_budget_unit2_value in number default hr_api.g_number
194: ,p_budget_unit3_value in number default hr_api.g_number
195: ,p_budget_unit1_available in number default hr_api.g_number
196: ,p_budget_unit2_available in number default hr_api.g_number
197: ,p_budget_unit3_available in number default hr_api.g_number
198: ,p_object_version_number in out nocopy number
199: ,p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2
192: ,p_budget_unit1_value in number default hr_api.g_number
193: ,p_budget_unit2_value in number default hr_api.g_number
194: ,p_budget_unit3_value in number default hr_api.g_number
195: ,p_budget_unit1_available in number default hr_api.g_number
196: ,p_budget_unit2_available in number default hr_api.g_number
197: ,p_budget_unit3_available in number default hr_api.g_number
198: ,p_object_version_number in out nocopy number
199: ,p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2
200: ,p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2
193: ,p_budget_unit2_value in number default hr_api.g_number
194: ,p_budget_unit3_value in number default hr_api.g_number
195: ,p_budget_unit1_available in number default hr_api.g_number
196: ,p_budget_unit2_available in number default hr_api.g_number
197: ,p_budget_unit3_available in number default hr_api.g_number
198: ,p_object_version_number in out nocopy number
199: ,p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2
200: ,p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2
201: ,p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2
195: ,p_budget_unit1_available in number default hr_api.g_number
196: ,p_budget_unit2_available in number default hr_api.g_number
197: ,p_budget_unit3_available in number default hr_api.g_number
198: ,p_object_version_number in out nocopy number
199: ,p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2
200: ,p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2
201: ,p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2
202: ,p_effective_date in date
203: );
196: ,p_budget_unit2_available in number default hr_api.g_number
197: ,p_budget_unit3_available in number default hr_api.g_number
198: ,p_object_version_number in out nocopy number
199: ,p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2
200: ,p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2
201: ,p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2
202: ,p_effective_date in date
203: );
204: -- ----------------------------------------------------------------------------
197: ,p_budget_unit3_available in number default hr_api.g_number
198: ,p_object_version_number in out nocopy number
199: ,p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2
200: ,p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2
201: ,p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2
202: ,p_effective_date in date
203: );
204: -- ----------------------------------------------------------------------------
205: -- |------------------------< create_budget_detail >------------------------|
234: procedure update_budget_detail
235: (
236: p_validate in boolean default false
237: ,p_budget_detail_id in number
238: ,p_organization_id in number default hr_api.g_number
239: ,p_job_id in number default hr_api.g_number
240: ,p_position_id in number default hr_api.g_number
241: ,p_grade_id in number default hr_api.g_number
242: ,p_budget_version_id in number default hr_api.g_number
235: (
236: p_validate in boolean default false
237: ,p_budget_detail_id in number
238: ,p_organization_id in number default hr_api.g_number
239: ,p_job_id in number default hr_api.g_number
240: ,p_position_id in number default hr_api.g_number
241: ,p_grade_id in number default hr_api.g_number
242: ,p_budget_version_id in number default hr_api.g_number
243: ,p_budget_unit1_percent in number default hr_api.g_number
236: p_validate in boolean default false
237: ,p_budget_detail_id in number
238: ,p_organization_id in number default hr_api.g_number
239: ,p_job_id in number default hr_api.g_number
240: ,p_position_id in number default hr_api.g_number
241: ,p_grade_id in number default hr_api.g_number
242: ,p_budget_version_id in number default hr_api.g_number
243: ,p_budget_unit1_percent in number default hr_api.g_number
244: ,p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2
237: ,p_budget_detail_id in number
238: ,p_organization_id in number default hr_api.g_number
239: ,p_job_id in number default hr_api.g_number
240: ,p_position_id in number default hr_api.g_number
241: ,p_grade_id in number default hr_api.g_number
242: ,p_budget_version_id in number default hr_api.g_number
243: ,p_budget_unit1_percent in number default hr_api.g_number
244: ,p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2
245: ,p_budget_unit1_value in number default hr_api.g_number
238: ,p_organization_id in number default hr_api.g_number
239: ,p_job_id in number default hr_api.g_number
240: ,p_position_id in number default hr_api.g_number
241: ,p_grade_id in number default hr_api.g_number
242: ,p_budget_version_id in number default hr_api.g_number
243: ,p_budget_unit1_percent in number default hr_api.g_number
244: ,p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2
245: ,p_budget_unit1_value in number default hr_api.g_number
246: ,p_budget_unit1_available in number default hr_api.g_number
239: ,p_job_id in number default hr_api.g_number
240: ,p_position_id in number default hr_api.g_number
241: ,p_grade_id in number default hr_api.g_number
242: ,p_budget_version_id in number default hr_api.g_number
243: ,p_budget_unit1_percent in number default hr_api.g_number
244: ,p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2
245: ,p_budget_unit1_value in number default hr_api.g_number
246: ,p_budget_unit1_available in number default hr_api.g_number
247: ,p_budget_unit2_percent in number default hr_api.g_number
240: ,p_position_id in number default hr_api.g_number
241: ,p_grade_id in number default hr_api.g_number
242: ,p_budget_version_id in number default hr_api.g_number
243: ,p_budget_unit1_percent in number default hr_api.g_number
244: ,p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2
245: ,p_budget_unit1_value in number default hr_api.g_number
246: ,p_budget_unit1_available in number default hr_api.g_number
247: ,p_budget_unit2_percent in number default hr_api.g_number
248: ,p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2
241: ,p_grade_id in number default hr_api.g_number
242: ,p_budget_version_id in number default hr_api.g_number
243: ,p_budget_unit1_percent in number default hr_api.g_number
244: ,p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2
245: ,p_budget_unit1_value in number default hr_api.g_number
246: ,p_budget_unit1_available in number default hr_api.g_number
247: ,p_budget_unit2_percent in number default hr_api.g_number
248: ,p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2
249: ,p_budget_unit2_value in number default hr_api.g_number
242: ,p_budget_version_id in number default hr_api.g_number
243: ,p_budget_unit1_percent in number default hr_api.g_number
244: ,p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2
245: ,p_budget_unit1_value in number default hr_api.g_number
246: ,p_budget_unit1_available in number default hr_api.g_number
247: ,p_budget_unit2_percent in number default hr_api.g_number
248: ,p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2
249: ,p_budget_unit2_value in number default hr_api.g_number
250: ,p_budget_unit2_available in number default hr_api.g_number
243: ,p_budget_unit1_percent in number default hr_api.g_number
244: ,p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2
245: ,p_budget_unit1_value in number default hr_api.g_number
246: ,p_budget_unit1_available in number default hr_api.g_number
247: ,p_budget_unit2_percent in number default hr_api.g_number
248: ,p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2
249: ,p_budget_unit2_value in number default hr_api.g_number
250: ,p_budget_unit2_available in number default hr_api.g_number
251: ,p_budget_unit3_percent in number default hr_api.g_number
244: ,p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2
245: ,p_budget_unit1_value in number default hr_api.g_number
246: ,p_budget_unit1_available in number default hr_api.g_number
247: ,p_budget_unit2_percent in number default hr_api.g_number
248: ,p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2
249: ,p_budget_unit2_value in number default hr_api.g_number
250: ,p_budget_unit2_available in number default hr_api.g_number
251: ,p_budget_unit3_percent in number default hr_api.g_number
252: ,p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2
245: ,p_budget_unit1_value in number default hr_api.g_number
246: ,p_budget_unit1_available in number default hr_api.g_number
247: ,p_budget_unit2_percent in number default hr_api.g_number
248: ,p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2
249: ,p_budget_unit2_value in number default hr_api.g_number
250: ,p_budget_unit2_available in number default hr_api.g_number
251: ,p_budget_unit3_percent in number default hr_api.g_number
252: ,p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2
253: ,p_budget_unit3_value in number default hr_api.g_number
246: ,p_budget_unit1_available in number default hr_api.g_number
247: ,p_budget_unit2_percent in number default hr_api.g_number
248: ,p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2
249: ,p_budget_unit2_value in number default hr_api.g_number
250: ,p_budget_unit2_available in number default hr_api.g_number
251: ,p_budget_unit3_percent in number default hr_api.g_number
252: ,p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2
253: ,p_budget_unit3_value in number default hr_api.g_number
254: ,p_budget_unit3_available in number default hr_api.g_number
247: ,p_budget_unit2_percent in number default hr_api.g_number
248: ,p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2
249: ,p_budget_unit2_value in number default hr_api.g_number
250: ,p_budget_unit2_available in number default hr_api.g_number
251: ,p_budget_unit3_percent in number default hr_api.g_number
252: ,p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2
253: ,p_budget_unit3_value in number default hr_api.g_number
254: ,p_budget_unit3_available in number default hr_api.g_number
255: ,p_gl_status in varchar2 default hr_api.g_varchar2
248: ,p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2
249: ,p_budget_unit2_value in number default hr_api.g_number
250: ,p_budget_unit2_available in number default hr_api.g_number
251: ,p_budget_unit3_percent in number default hr_api.g_number
252: ,p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2
253: ,p_budget_unit3_value in number default hr_api.g_number
254: ,p_budget_unit3_available in number default hr_api.g_number
255: ,p_gl_status in varchar2 default hr_api.g_varchar2
256: ,p_object_version_number in out nocopy number
249: ,p_budget_unit2_value in number default hr_api.g_number
250: ,p_budget_unit2_available in number default hr_api.g_number
251: ,p_budget_unit3_percent in number default hr_api.g_number
252: ,p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2
253: ,p_budget_unit3_value in number default hr_api.g_number
254: ,p_budget_unit3_available in number default hr_api.g_number
255: ,p_gl_status in varchar2 default hr_api.g_varchar2
256: ,p_object_version_number in out nocopy number
257: );
250: ,p_budget_unit2_available in number default hr_api.g_number
251: ,p_budget_unit3_percent in number default hr_api.g_number
252: ,p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2
253: ,p_budget_unit3_value in number default hr_api.g_number
254: ,p_budget_unit3_available in number default hr_api.g_number
255: ,p_gl_status in varchar2 default hr_api.g_varchar2
256: ,p_object_version_number in out nocopy number
257: );
258: -- ---------------------------------------------------------------------------
251: ,p_budget_unit3_percent in number default hr_api.g_number
252: ,p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2
253: ,p_budget_unit3_value in number default hr_api.g_number
254: ,p_budget_unit3_available in number default hr_api.g_number
255: ,p_gl_status in varchar2 default hr_api.g_varchar2
256: ,p_object_version_number in out nocopy number
257: );
258: -- ---------------------------------------------------------------------------
259: -- |-----------------< POSITION_CONTROL_ENABLED >---------------------|