55: procedure update_budget_version
56: (
57: p_validate in boolean default false
58: ,p_budget_version_id in number
59: ,p_budget_id in number default hr_api.g_number
60: ,p_version_number in number default hr_api.g_number
61: ,p_date_from in date default hr_api.g_date
62: ,p_date_to in date default hr_api.g_date
63: ,p_transfered_to_gl_flag in varchar2 default hr_api.g_varchar2
56: (
57: p_validate in boolean default false
58: ,p_budget_version_id in number
59: ,p_budget_id in number default hr_api.g_number
60: ,p_version_number in number default hr_api.g_number
61: ,p_date_from in date default hr_api.g_date
62: ,p_date_to in date default hr_api.g_date
63: ,p_transfered_to_gl_flag in varchar2 default hr_api.g_varchar2
64: ,p_gl_status in varchar2 default hr_api.g_varchar2
57: p_validate in boolean default false
58: ,p_budget_version_id in number
59: ,p_budget_id in number default hr_api.g_number
60: ,p_version_number in number default hr_api.g_number
61: ,p_date_from in date default hr_api.g_date
62: ,p_date_to in date default hr_api.g_date
63: ,p_transfered_to_gl_flag in varchar2 default hr_api.g_varchar2
64: ,p_gl_status in varchar2 default hr_api.g_varchar2
65: ,p_xfer_to_other_apps_cd in varchar2 default hr_api.g_varchar2
58: ,p_budget_version_id in number
59: ,p_budget_id in number default hr_api.g_number
60: ,p_version_number in number default hr_api.g_number
61: ,p_date_from in date default hr_api.g_date
62: ,p_date_to in date default hr_api.g_date
63: ,p_transfered_to_gl_flag in varchar2 default hr_api.g_varchar2
64: ,p_gl_status in varchar2 default hr_api.g_varchar2
65: ,p_xfer_to_other_apps_cd in varchar2 default hr_api.g_varchar2
66: ,p_object_version_number in out nocopy number
59: ,p_budget_id in number default hr_api.g_number
60: ,p_version_number in number default hr_api.g_number
61: ,p_date_from in date default hr_api.g_date
62: ,p_date_to in date default hr_api.g_date
63: ,p_transfered_to_gl_flag in varchar2 default hr_api.g_varchar2
64: ,p_gl_status in varchar2 default hr_api.g_varchar2
65: ,p_xfer_to_other_apps_cd in varchar2 default hr_api.g_varchar2
66: ,p_object_version_number in out nocopy number
67: ,p_budget_unit1_value in number default hr_api.g_number
60: ,p_version_number in number default hr_api.g_number
61: ,p_date_from in date default hr_api.g_date
62: ,p_date_to in date default hr_api.g_date
63: ,p_transfered_to_gl_flag in varchar2 default hr_api.g_varchar2
64: ,p_gl_status in varchar2 default hr_api.g_varchar2
65: ,p_xfer_to_other_apps_cd in varchar2 default hr_api.g_varchar2
66: ,p_object_version_number in out nocopy number
67: ,p_budget_unit1_value in number default hr_api.g_number
68: ,p_budget_unit2_value in number default hr_api.g_number
61: ,p_date_from in date default hr_api.g_date
62: ,p_date_to in date default hr_api.g_date
63: ,p_transfered_to_gl_flag in varchar2 default hr_api.g_varchar2
64: ,p_gl_status in varchar2 default hr_api.g_varchar2
65: ,p_xfer_to_other_apps_cd in varchar2 default hr_api.g_varchar2
66: ,p_object_version_number in out nocopy number
67: ,p_budget_unit1_value in number default hr_api.g_number
68: ,p_budget_unit2_value in number default hr_api.g_number
69: ,p_budget_unit3_value in number default hr_api.g_number
63: ,p_transfered_to_gl_flag in varchar2 default hr_api.g_varchar2
64: ,p_gl_status in varchar2 default hr_api.g_varchar2
65: ,p_xfer_to_other_apps_cd in varchar2 default hr_api.g_varchar2
66: ,p_object_version_number in out nocopy number
67: ,p_budget_unit1_value in number default hr_api.g_number
68: ,p_budget_unit2_value in number default hr_api.g_number
69: ,p_budget_unit3_value in number default hr_api.g_number
70: ,p_budget_unit1_available in number default hr_api.g_number
71: ,p_budget_unit2_available in number default hr_api.g_number
64: ,p_gl_status in varchar2 default hr_api.g_varchar2
65: ,p_xfer_to_other_apps_cd in varchar2 default hr_api.g_varchar2
66: ,p_object_version_number in out nocopy number
67: ,p_budget_unit1_value in number default hr_api.g_number
68: ,p_budget_unit2_value in number default hr_api.g_number
69: ,p_budget_unit3_value in number default hr_api.g_number
70: ,p_budget_unit1_available in number default hr_api.g_number
71: ,p_budget_unit2_available in number default hr_api.g_number
72: ,p_budget_unit3_available in number default hr_api.g_number
65: ,p_xfer_to_other_apps_cd in varchar2 default hr_api.g_varchar2
66: ,p_object_version_number in out nocopy number
67: ,p_budget_unit1_value in number default hr_api.g_number
68: ,p_budget_unit2_value in number default hr_api.g_number
69: ,p_budget_unit3_value in number default hr_api.g_number
70: ,p_budget_unit1_available in number default hr_api.g_number
71: ,p_budget_unit2_available in number default hr_api.g_number
72: ,p_budget_unit3_available in number default hr_api.g_number
73: ,p_effective_date in date
66: ,p_object_version_number in out nocopy number
67: ,p_budget_unit1_value in number default hr_api.g_number
68: ,p_budget_unit2_value in number default hr_api.g_number
69: ,p_budget_unit3_value in number default hr_api.g_number
70: ,p_budget_unit1_available in number default hr_api.g_number
71: ,p_budget_unit2_available in number default hr_api.g_number
72: ,p_budget_unit3_available in number default hr_api.g_number
73: ,p_effective_date in date
74: ) is
67: ,p_budget_unit1_value in number default hr_api.g_number
68: ,p_budget_unit2_value in number default hr_api.g_number
69: ,p_budget_unit3_value in number default hr_api.g_number
70: ,p_budget_unit1_available in number default hr_api.g_number
71: ,p_budget_unit2_available in number default hr_api.g_number
72: ,p_budget_unit3_available in number default hr_api.g_number
73: ,p_effective_date in date
74: ) is
75: l_object_version_number number := p_object_version_number;
68: ,p_budget_unit2_value in number default hr_api.g_number
69: ,p_budget_unit3_value in number default hr_api.g_number
70: ,p_budget_unit1_available in number default hr_api.g_number
71: ,p_budget_unit2_available in number default hr_api.g_number
72: ,p_budget_unit3_available in number default hr_api.g_number
73: ,p_effective_date in date
74: ) is
75: l_object_version_number number := p_object_version_number;
76: begin
129: procedure update_budget_element
130: (
131: p_validate in boolean default false
132: ,p_budget_element_id in number
133: ,p_budget_set_id in number default hr_api.g_number
134: ,p_element_type_id in number default hr_api.g_number
135: ,p_distribution_percentage in number default hr_api.g_number
136: ,p_object_version_number in out nocopy number
137: ) is
130: (
131: p_validate in boolean default false
132: ,p_budget_element_id in number
133: ,p_budget_set_id in number default hr_api.g_number
134: ,p_element_type_id in number default hr_api.g_number
135: ,p_distribution_percentage in number default hr_api.g_number
136: ,p_object_version_number in out nocopy number
137: ) is
138: l_object_version_number number := p_object_version_number;
131: p_validate in boolean default false
132: ,p_budget_element_id in number
133: ,p_budget_set_id in number default hr_api.g_number
134: ,p_element_type_id in number default hr_api.g_number
135: ,p_distribution_percentage in number default hr_api.g_number
136: ,p_object_version_number in out nocopy number
137: ) is
138: l_object_version_number number := p_object_version_number;
139: begin
191: procedure update_budget_fund_src
192: (
193: p_validate in boolean default false
194: ,p_budget_fund_src_id in number
195: ,p_budget_element_id in number default hr_api.g_number
196: ,p_cost_allocation_keyflex_id in number default hr_api.g_number
197: ,p_project_id in number default hr_api.g_number
198: ,p_award_id in number default hr_api.g_number
199: ,p_task_id in number default hr_api.g_number
192: (
193: p_validate in boolean default false
194: ,p_budget_fund_src_id in number
195: ,p_budget_element_id in number default hr_api.g_number
196: ,p_cost_allocation_keyflex_id in number default hr_api.g_number
197: ,p_project_id in number default hr_api.g_number
198: ,p_award_id in number default hr_api.g_number
199: ,p_task_id in number default hr_api.g_number
200: ,p_expenditure_type in varchar2 default hr_api.g_varchar2
193: p_validate in boolean default false
194: ,p_budget_fund_src_id in number
195: ,p_budget_element_id in number default hr_api.g_number
196: ,p_cost_allocation_keyflex_id in number default hr_api.g_number
197: ,p_project_id in number default hr_api.g_number
198: ,p_award_id in number default hr_api.g_number
199: ,p_task_id in number default hr_api.g_number
200: ,p_expenditure_type in varchar2 default hr_api.g_varchar2
201: ,p_organization_id in number default hr_api.g_number
194: ,p_budget_fund_src_id in number
195: ,p_budget_element_id in number default hr_api.g_number
196: ,p_cost_allocation_keyflex_id in number default hr_api.g_number
197: ,p_project_id in number default hr_api.g_number
198: ,p_award_id in number default hr_api.g_number
199: ,p_task_id in number default hr_api.g_number
200: ,p_expenditure_type in varchar2 default hr_api.g_varchar2
201: ,p_organization_id in number default hr_api.g_number
202: ,p_distribution_percentage in number default hr_api.g_number
195: ,p_budget_element_id in number default hr_api.g_number
196: ,p_cost_allocation_keyflex_id in number default hr_api.g_number
197: ,p_project_id in number default hr_api.g_number
198: ,p_award_id in number default hr_api.g_number
199: ,p_task_id in number default hr_api.g_number
200: ,p_expenditure_type in varchar2 default hr_api.g_varchar2
201: ,p_organization_id in number default hr_api.g_number
202: ,p_distribution_percentage in number default hr_api.g_number
203: ,p_object_version_number in out nocopy number
196: ,p_cost_allocation_keyflex_id in number default hr_api.g_number
197: ,p_project_id in number default hr_api.g_number
198: ,p_award_id in number default hr_api.g_number
199: ,p_task_id in number default hr_api.g_number
200: ,p_expenditure_type in varchar2 default hr_api.g_varchar2
201: ,p_organization_id in number default hr_api.g_number
202: ,p_distribution_percentage in number default hr_api.g_number
203: ,p_object_version_number in out nocopy number
204: ) is
197: ,p_project_id in number default hr_api.g_number
198: ,p_award_id in number default hr_api.g_number
199: ,p_task_id in number default hr_api.g_number
200: ,p_expenditure_type in varchar2 default hr_api.g_varchar2
201: ,p_organization_id in number default hr_api.g_number
202: ,p_distribution_percentage in number default hr_api.g_number
203: ,p_object_version_number in out nocopy number
204: ) is
205: l_object_version_number number := p_object_version_number;
198: ,p_award_id in number default hr_api.g_number
199: ,p_task_id in number default hr_api.g_number
200: ,p_expenditure_type in varchar2 default hr_api.g_varchar2
201: ,p_organization_id in number default hr_api.g_number
202: ,p_distribution_percentage in number default hr_api.g_number
203: ,p_object_version_number in out nocopy number
204: ) is
205: l_object_version_number number := p_object_version_number;
206: begin
277: procedure update_budget_period
278: (
279: p_validate in boolean default false
280: ,p_budget_period_id in number
281: ,p_budget_detail_id in number default hr_api.g_number
282: ,p_start_time_period_id in number default hr_api.g_number
283: ,p_end_time_period_id in number default hr_api.g_number
284: ,p_budget_unit1_percent in number default hr_api.g_number
285: ,p_budget_unit2_percent in number default hr_api.g_number
278: (
279: p_validate in boolean default false
280: ,p_budget_period_id in number
281: ,p_budget_detail_id in number default hr_api.g_number
282: ,p_start_time_period_id in number default hr_api.g_number
283: ,p_end_time_period_id in number default hr_api.g_number
284: ,p_budget_unit1_percent in number default hr_api.g_number
285: ,p_budget_unit2_percent in number default hr_api.g_number
286: ,p_budget_unit3_percent in number default hr_api.g_number
279: p_validate in boolean default false
280: ,p_budget_period_id in number
281: ,p_budget_detail_id in number default hr_api.g_number
282: ,p_start_time_period_id in number default hr_api.g_number
283: ,p_end_time_period_id in number default hr_api.g_number
284: ,p_budget_unit1_percent in number default hr_api.g_number
285: ,p_budget_unit2_percent in number default hr_api.g_number
286: ,p_budget_unit3_percent in number default hr_api.g_number
287: ,p_budget_unit1_value in number default hr_api.g_number
280: ,p_budget_period_id in number
281: ,p_budget_detail_id in number default hr_api.g_number
282: ,p_start_time_period_id in number default hr_api.g_number
283: ,p_end_time_period_id in number default hr_api.g_number
284: ,p_budget_unit1_percent in number default hr_api.g_number
285: ,p_budget_unit2_percent in number default hr_api.g_number
286: ,p_budget_unit3_percent in number default hr_api.g_number
287: ,p_budget_unit1_value in number default hr_api.g_number
288: ,p_budget_unit2_value in number default hr_api.g_number
281: ,p_budget_detail_id in number default hr_api.g_number
282: ,p_start_time_period_id in number default hr_api.g_number
283: ,p_end_time_period_id in number default hr_api.g_number
284: ,p_budget_unit1_percent in number default hr_api.g_number
285: ,p_budget_unit2_percent in number default hr_api.g_number
286: ,p_budget_unit3_percent in number default hr_api.g_number
287: ,p_budget_unit1_value in number default hr_api.g_number
288: ,p_budget_unit2_value in number default hr_api.g_number
289: ,p_budget_unit3_value in number default hr_api.g_number
282: ,p_start_time_period_id in number default hr_api.g_number
283: ,p_end_time_period_id in number default hr_api.g_number
284: ,p_budget_unit1_percent in number default hr_api.g_number
285: ,p_budget_unit2_percent in number default hr_api.g_number
286: ,p_budget_unit3_percent in number default hr_api.g_number
287: ,p_budget_unit1_value in number default hr_api.g_number
288: ,p_budget_unit2_value in number default hr_api.g_number
289: ,p_budget_unit3_value in number default hr_api.g_number
290: ,p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2
283: ,p_end_time_period_id in number default hr_api.g_number
284: ,p_budget_unit1_percent in number default hr_api.g_number
285: ,p_budget_unit2_percent in number default hr_api.g_number
286: ,p_budget_unit3_percent in number default hr_api.g_number
287: ,p_budget_unit1_value in number default hr_api.g_number
288: ,p_budget_unit2_value in number default hr_api.g_number
289: ,p_budget_unit3_value in number default hr_api.g_number
290: ,p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2
291: ,p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2
284: ,p_budget_unit1_percent in number default hr_api.g_number
285: ,p_budget_unit2_percent in number default hr_api.g_number
286: ,p_budget_unit3_percent in number default hr_api.g_number
287: ,p_budget_unit1_value in number default hr_api.g_number
288: ,p_budget_unit2_value in number default hr_api.g_number
289: ,p_budget_unit3_value in number default hr_api.g_number
290: ,p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2
291: ,p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2
292: ,p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2
285: ,p_budget_unit2_percent in number default hr_api.g_number
286: ,p_budget_unit3_percent in number default hr_api.g_number
287: ,p_budget_unit1_value in number default hr_api.g_number
288: ,p_budget_unit2_value in number default hr_api.g_number
289: ,p_budget_unit3_value in number default hr_api.g_number
290: ,p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2
291: ,p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2
292: ,p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2
293: ,p_budget_unit1_available in number default hr_api.g_number
286: ,p_budget_unit3_percent in number default hr_api.g_number
287: ,p_budget_unit1_value in number default hr_api.g_number
288: ,p_budget_unit2_value in number default hr_api.g_number
289: ,p_budget_unit3_value in number default hr_api.g_number
290: ,p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2
291: ,p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2
292: ,p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2
293: ,p_budget_unit1_available in number default hr_api.g_number
294: ,p_budget_unit2_available in number default hr_api.g_number
287: ,p_budget_unit1_value in number default hr_api.g_number
288: ,p_budget_unit2_value in number default hr_api.g_number
289: ,p_budget_unit3_value in number default hr_api.g_number
290: ,p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2
291: ,p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2
292: ,p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2
293: ,p_budget_unit1_available in number default hr_api.g_number
294: ,p_budget_unit2_available in number default hr_api.g_number
295: ,p_budget_unit3_available in number default hr_api.g_number
288: ,p_budget_unit2_value in number default hr_api.g_number
289: ,p_budget_unit3_value in number default hr_api.g_number
290: ,p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2
291: ,p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2
292: ,p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2
293: ,p_budget_unit1_available in number default hr_api.g_number
294: ,p_budget_unit2_available in number default hr_api.g_number
295: ,p_budget_unit3_available in number default hr_api.g_number
296: ,p_object_version_number in out nocopy number
289: ,p_budget_unit3_value in number default hr_api.g_number
290: ,p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2
291: ,p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2
292: ,p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2
293: ,p_budget_unit1_available in number default hr_api.g_number
294: ,p_budget_unit2_available in number default hr_api.g_number
295: ,p_budget_unit3_available in number default hr_api.g_number
296: ,p_object_version_number in out nocopy number
297: ) is
290: ,p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2
291: ,p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2
292: ,p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2
293: ,p_budget_unit1_available in number default hr_api.g_number
294: ,p_budget_unit2_available in number default hr_api.g_number
295: ,p_budget_unit3_available in number default hr_api.g_number
296: ,p_object_version_number in out nocopy number
297: ) is
298: l_object_version_number number := p_object_version_number;
291: ,p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2
292: ,p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2
293: ,p_budget_unit1_available in number default hr_api.g_number
294: ,p_budget_unit2_available in number default hr_api.g_number
295: ,p_budget_unit3_available in number default hr_api.g_number
296: ,p_object_version_number in out nocopy number
297: ) is
298: l_object_version_number number := p_object_version_number;
299: begin
377: procedure update_budget_set
378: (
379: p_validate in boolean default false
380: ,p_budget_set_id in number
381: ,p_dflt_budget_set_id in number default hr_api.g_number
382: ,p_budget_period_id in number default hr_api.g_number
383: ,p_budget_unit1_percent in number default hr_api.g_number
384: ,p_budget_unit2_percent in number default hr_api.g_number
385: ,p_budget_unit3_percent in number default hr_api.g_number
378: (
379: p_validate in boolean default false
380: ,p_budget_set_id in number
381: ,p_dflt_budget_set_id in number default hr_api.g_number
382: ,p_budget_period_id in number default hr_api.g_number
383: ,p_budget_unit1_percent in number default hr_api.g_number
384: ,p_budget_unit2_percent in number default hr_api.g_number
385: ,p_budget_unit3_percent in number default hr_api.g_number
386: ,p_budget_unit1_value in number default hr_api.g_number
379: p_validate in boolean default false
380: ,p_budget_set_id in number
381: ,p_dflt_budget_set_id in number default hr_api.g_number
382: ,p_budget_period_id in number default hr_api.g_number
383: ,p_budget_unit1_percent in number default hr_api.g_number
384: ,p_budget_unit2_percent in number default hr_api.g_number
385: ,p_budget_unit3_percent in number default hr_api.g_number
386: ,p_budget_unit1_value in number default hr_api.g_number
387: ,p_budget_unit2_value in number default hr_api.g_number
380: ,p_budget_set_id in number
381: ,p_dflt_budget_set_id in number default hr_api.g_number
382: ,p_budget_period_id in number default hr_api.g_number
383: ,p_budget_unit1_percent in number default hr_api.g_number
384: ,p_budget_unit2_percent in number default hr_api.g_number
385: ,p_budget_unit3_percent in number default hr_api.g_number
386: ,p_budget_unit1_value in number default hr_api.g_number
387: ,p_budget_unit2_value in number default hr_api.g_number
388: ,p_budget_unit3_value in number default hr_api.g_number
381: ,p_dflt_budget_set_id in number default hr_api.g_number
382: ,p_budget_period_id in number default hr_api.g_number
383: ,p_budget_unit1_percent in number default hr_api.g_number
384: ,p_budget_unit2_percent in number default hr_api.g_number
385: ,p_budget_unit3_percent in number default hr_api.g_number
386: ,p_budget_unit1_value in number default hr_api.g_number
387: ,p_budget_unit2_value in number default hr_api.g_number
388: ,p_budget_unit3_value in number default hr_api.g_number
389: ,p_budget_unit1_available in number default hr_api.g_number
382: ,p_budget_period_id in number default hr_api.g_number
383: ,p_budget_unit1_percent in number default hr_api.g_number
384: ,p_budget_unit2_percent in number default hr_api.g_number
385: ,p_budget_unit3_percent in number default hr_api.g_number
386: ,p_budget_unit1_value in number default hr_api.g_number
387: ,p_budget_unit2_value in number default hr_api.g_number
388: ,p_budget_unit3_value in number default hr_api.g_number
389: ,p_budget_unit1_available in number default hr_api.g_number
390: ,p_budget_unit2_available in number default hr_api.g_number
383: ,p_budget_unit1_percent in number default hr_api.g_number
384: ,p_budget_unit2_percent in number default hr_api.g_number
385: ,p_budget_unit3_percent in number default hr_api.g_number
386: ,p_budget_unit1_value in number default hr_api.g_number
387: ,p_budget_unit2_value in number default hr_api.g_number
388: ,p_budget_unit3_value in number default hr_api.g_number
389: ,p_budget_unit1_available in number default hr_api.g_number
390: ,p_budget_unit2_available in number default hr_api.g_number
391: ,p_budget_unit3_available in number default hr_api.g_number
384: ,p_budget_unit2_percent in number default hr_api.g_number
385: ,p_budget_unit3_percent in number default hr_api.g_number
386: ,p_budget_unit1_value in number default hr_api.g_number
387: ,p_budget_unit2_value in number default hr_api.g_number
388: ,p_budget_unit3_value in number default hr_api.g_number
389: ,p_budget_unit1_available in number default hr_api.g_number
390: ,p_budget_unit2_available in number default hr_api.g_number
391: ,p_budget_unit3_available in number default hr_api.g_number
392: ,p_object_version_number in out nocopy number
385: ,p_budget_unit3_percent in number default hr_api.g_number
386: ,p_budget_unit1_value in number default hr_api.g_number
387: ,p_budget_unit2_value in number default hr_api.g_number
388: ,p_budget_unit3_value in number default hr_api.g_number
389: ,p_budget_unit1_available in number default hr_api.g_number
390: ,p_budget_unit2_available in number default hr_api.g_number
391: ,p_budget_unit3_available in number default hr_api.g_number
392: ,p_object_version_number in out nocopy number
393: ,p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2
386: ,p_budget_unit1_value in number default hr_api.g_number
387: ,p_budget_unit2_value in number default hr_api.g_number
388: ,p_budget_unit3_value in number default hr_api.g_number
389: ,p_budget_unit1_available in number default hr_api.g_number
390: ,p_budget_unit2_available in number default hr_api.g_number
391: ,p_budget_unit3_available in number default hr_api.g_number
392: ,p_object_version_number in out nocopy number
393: ,p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2
394: ,p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2
387: ,p_budget_unit2_value in number default hr_api.g_number
388: ,p_budget_unit3_value in number default hr_api.g_number
389: ,p_budget_unit1_available in number default hr_api.g_number
390: ,p_budget_unit2_available in number default hr_api.g_number
391: ,p_budget_unit3_available in number default hr_api.g_number
392: ,p_object_version_number in out nocopy number
393: ,p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2
394: ,p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2
395: ,p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2
389: ,p_budget_unit1_available in number default hr_api.g_number
390: ,p_budget_unit2_available in number default hr_api.g_number
391: ,p_budget_unit3_available in number default hr_api.g_number
392: ,p_object_version_number in out nocopy number
393: ,p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2
394: ,p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2
395: ,p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2
396: ,p_effective_date in date
397: ) is
390: ,p_budget_unit2_available in number default hr_api.g_number
391: ,p_budget_unit3_available in number default hr_api.g_number
392: ,p_object_version_number in out nocopy number
393: ,p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2
394: ,p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2
395: ,p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2
396: ,p_effective_date in date
397: ) is
398: l_object_version_number number := p_object_version_number;
391: ,p_budget_unit3_available in number default hr_api.g_number
392: ,p_object_version_number in out nocopy number
393: ,p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2
394: ,p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2
395: ,p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2
396: ,p_effective_date in date
397: ) is
398: l_object_version_number number := p_object_version_number;
399: begin
483: procedure update_budget_detail
484: (
485: p_validate in boolean default false
486: ,p_budget_detail_id in number
487: ,p_organization_id in number default hr_api.g_number
488: ,p_job_id in number default hr_api.g_number
489: ,p_position_id in number default hr_api.g_number
490: ,p_grade_id in number default hr_api.g_number
491: ,p_budget_version_id in number default hr_api.g_number
484: (
485: p_validate in boolean default false
486: ,p_budget_detail_id in number
487: ,p_organization_id in number default hr_api.g_number
488: ,p_job_id in number default hr_api.g_number
489: ,p_position_id in number default hr_api.g_number
490: ,p_grade_id in number default hr_api.g_number
491: ,p_budget_version_id in number default hr_api.g_number
492: ,p_budget_unit1_percent in number default hr_api.g_number
485: p_validate in boolean default false
486: ,p_budget_detail_id in number
487: ,p_organization_id in number default hr_api.g_number
488: ,p_job_id in number default hr_api.g_number
489: ,p_position_id in number default hr_api.g_number
490: ,p_grade_id in number default hr_api.g_number
491: ,p_budget_version_id in number default hr_api.g_number
492: ,p_budget_unit1_percent in number default hr_api.g_number
493: ,p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2
486: ,p_budget_detail_id in number
487: ,p_organization_id in number default hr_api.g_number
488: ,p_job_id in number default hr_api.g_number
489: ,p_position_id in number default hr_api.g_number
490: ,p_grade_id in number default hr_api.g_number
491: ,p_budget_version_id in number default hr_api.g_number
492: ,p_budget_unit1_percent in number default hr_api.g_number
493: ,p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2
494: ,p_budget_unit1_value in number default hr_api.g_number
487: ,p_organization_id in number default hr_api.g_number
488: ,p_job_id in number default hr_api.g_number
489: ,p_position_id in number default hr_api.g_number
490: ,p_grade_id in number default hr_api.g_number
491: ,p_budget_version_id in number default hr_api.g_number
492: ,p_budget_unit1_percent in number default hr_api.g_number
493: ,p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2
494: ,p_budget_unit1_value in number default hr_api.g_number
495: ,p_budget_unit1_available in number default hr_api.g_number
488: ,p_job_id in number default hr_api.g_number
489: ,p_position_id in number default hr_api.g_number
490: ,p_grade_id in number default hr_api.g_number
491: ,p_budget_version_id in number default hr_api.g_number
492: ,p_budget_unit1_percent in number default hr_api.g_number
493: ,p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2
494: ,p_budget_unit1_value in number default hr_api.g_number
495: ,p_budget_unit1_available in number default hr_api.g_number
496: ,p_budget_unit2_percent in number default hr_api.g_number
489: ,p_position_id in number default hr_api.g_number
490: ,p_grade_id in number default hr_api.g_number
491: ,p_budget_version_id in number default hr_api.g_number
492: ,p_budget_unit1_percent in number default hr_api.g_number
493: ,p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2
494: ,p_budget_unit1_value in number default hr_api.g_number
495: ,p_budget_unit1_available in number default hr_api.g_number
496: ,p_budget_unit2_percent in number default hr_api.g_number
497: ,p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2
490: ,p_grade_id in number default hr_api.g_number
491: ,p_budget_version_id in number default hr_api.g_number
492: ,p_budget_unit1_percent in number default hr_api.g_number
493: ,p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2
494: ,p_budget_unit1_value in number default hr_api.g_number
495: ,p_budget_unit1_available in number default hr_api.g_number
496: ,p_budget_unit2_percent in number default hr_api.g_number
497: ,p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2
498: ,p_budget_unit2_value in number default hr_api.g_number
491: ,p_budget_version_id in number default hr_api.g_number
492: ,p_budget_unit1_percent in number default hr_api.g_number
493: ,p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2
494: ,p_budget_unit1_value in number default hr_api.g_number
495: ,p_budget_unit1_available in number default hr_api.g_number
496: ,p_budget_unit2_percent in number default hr_api.g_number
497: ,p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2
498: ,p_budget_unit2_value in number default hr_api.g_number
499: ,p_budget_unit2_available in number default hr_api.g_number
492: ,p_budget_unit1_percent in number default hr_api.g_number
493: ,p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2
494: ,p_budget_unit1_value in number default hr_api.g_number
495: ,p_budget_unit1_available in number default hr_api.g_number
496: ,p_budget_unit2_percent in number default hr_api.g_number
497: ,p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2
498: ,p_budget_unit2_value in number default hr_api.g_number
499: ,p_budget_unit2_available in number default hr_api.g_number
500: ,p_budget_unit3_percent in number default hr_api.g_number
493: ,p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2
494: ,p_budget_unit1_value in number default hr_api.g_number
495: ,p_budget_unit1_available in number default hr_api.g_number
496: ,p_budget_unit2_percent in number default hr_api.g_number
497: ,p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2
498: ,p_budget_unit2_value in number default hr_api.g_number
499: ,p_budget_unit2_available in number default hr_api.g_number
500: ,p_budget_unit3_percent in number default hr_api.g_number
501: ,p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2
494: ,p_budget_unit1_value in number default hr_api.g_number
495: ,p_budget_unit1_available in number default hr_api.g_number
496: ,p_budget_unit2_percent in number default hr_api.g_number
497: ,p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2
498: ,p_budget_unit2_value in number default hr_api.g_number
499: ,p_budget_unit2_available in number default hr_api.g_number
500: ,p_budget_unit3_percent in number default hr_api.g_number
501: ,p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2
502: ,p_budget_unit3_value in number default hr_api.g_number
495: ,p_budget_unit1_available in number default hr_api.g_number
496: ,p_budget_unit2_percent in number default hr_api.g_number
497: ,p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2
498: ,p_budget_unit2_value in number default hr_api.g_number
499: ,p_budget_unit2_available in number default hr_api.g_number
500: ,p_budget_unit3_percent in number default hr_api.g_number
501: ,p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2
502: ,p_budget_unit3_value in number default hr_api.g_number
503: ,p_budget_unit3_available in number default hr_api.g_number
496: ,p_budget_unit2_percent in number default hr_api.g_number
497: ,p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2
498: ,p_budget_unit2_value in number default hr_api.g_number
499: ,p_budget_unit2_available in number default hr_api.g_number
500: ,p_budget_unit3_percent in number default hr_api.g_number
501: ,p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2
502: ,p_budget_unit3_value in number default hr_api.g_number
503: ,p_budget_unit3_available in number default hr_api.g_number
504: ,p_gl_status in varchar2 default hr_api.g_varchar2
497: ,p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2
498: ,p_budget_unit2_value in number default hr_api.g_number
499: ,p_budget_unit2_available in number default hr_api.g_number
500: ,p_budget_unit3_percent in number default hr_api.g_number
501: ,p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2
502: ,p_budget_unit3_value in number default hr_api.g_number
503: ,p_budget_unit3_available in number default hr_api.g_number
504: ,p_gl_status in varchar2 default hr_api.g_varchar2
505: ,p_object_version_number in out nocopy number
498: ,p_budget_unit2_value in number default hr_api.g_number
499: ,p_budget_unit2_available in number default hr_api.g_number
500: ,p_budget_unit3_percent in number default hr_api.g_number
501: ,p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2
502: ,p_budget_unit3_value in number default hr_api.g_number
503: ,p_budget_unit3_available in number default hr_api.g_number
504: ,p_gl_status in varchar2 default hr_api.g_varchar2
505: ,p_object_version_number in out nocopy number
506: ) is
499: ,p_budget_unit2_available in number default hr_api.g_number
500: ,p_budget_unit3_percent in number default hr_api.g_number
501: ,p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2
502: ,p_budget_unit3_value in number default hr_api.g_number
503: ,p_budget_unit3_available in number default hr_api.g_number
504: ,p_gl_status in varchar2 default hr_api.g_varchar2
505: ,p_object_version_number in out nocopy number
506: ) is
507: l_object_version_number number := p_object_version_number;
500: ,p_budget_unit3_percent in number default hr_api.g_number
501: ,p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2
502: ,p_budget_unit3_value in number default hr_api.g_number
503: ,p_budget_unit3_available in number default hr_api.g_number
504: ,p_gl_status in varchar2 default hr_api.g_varchar2
505: ,p_object_version_number in out nocopy number
506: ) is
507: l_object_version_number number := p_object_version_number;
508: begin