DBA Data[Home] [Help]

APPS.PQH_PSB_INTERFACE_API dependencies on HR_API

Line 59: ,p_budget_id in number default hr_api.g_number

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

Line 60: ,p_version_number in number default hr_api.g_number

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

Line 61: ,p_date_from in date default hr_api.g_date

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

Line 62: ,p_date_to in date default hr_api.g_date

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

Line 63: ,p_transfered_to_gl_flag in varchar2 default hr_api.g_varchar2

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

Line 64: ,p_gl_status in varchar2 default hr_api.g_varchar2

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

Line 65: ,p_xfer_to_other_apps_cd in varchar2 default hr_api.g_varchar2

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

Line 67: ,p_budget_unit1_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

Line 68: ,p_budget_unit2_value 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

Line 69: ,p_budget_unit3_value 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

Line 70: ,p_budget_unit1_available in number default hr_api.g_number

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

Line 71: ,p_budget_unit2_available in number default hr_api.g_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
75: l_object_version_number number := p_object_version_number;

Line 72: ,p_budget_unit3_available 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;
76: begin

Line 133: ,p_budget_set_id in number default hr_api.g_number

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

Line 134: ,p_element_type_id in number default hr_api.g_number

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;

Line 135: ,p_distribution_percentage in number default hr_api.g_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

Line 195: ,p_budget_element_id in number default hr_api.g_number

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

Line 196: ,p_cost_allocation_keyflex_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

Line 197: ,p_project_id in number default hr_api.g_number

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

Line 198: ,p_award_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

Line 199: ,p_task_id 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

Line 200: ,p_expenditure_type in varchar2 default hr_api.g_varchar2

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

Line 201: ,p_organization_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
205: l_object_version_number number := p_object_version_number;

Line 202: ,p_distribution_percentage 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;
206: begin

Line 281: ,p_budget_detail_id in number default hr_api.g_number

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

Line 282: ,p_start_time_period_id 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

Line 283: ,p_end_time_period_id 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

Line 284: ,p_budget_unit1_percent 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

Line 285: ,p_budget_unit2_percent 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

Line 286: ,p_budget_unit3_percent 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

Line 287: ,p_budget_unit1_value 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
291: ,p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2

Line 288: ,p_budget_unit2_value 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
292: ,p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2

Line 289: ,p_budget_unit3_value 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
293: ,p_budget_unit1_available in number default hr_api.g_number

Line 290: ,p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2

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

Line 291: ,p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2

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

Line 292: ,p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2

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

Line 293: ,p_budget_unit1_available 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
297: ) is

Line 294: ,p_budget_unit2_available 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
298: l_object_version_number number := p_object_version_number;

Line 295: ,p_budget_unit3_available in number default hr_api.g_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

Line 381: ,p_dflt_budget_set_id in number default hr_api.g_number

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

Line 382: ,p_budget_period_id 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

Line 383: ,p_budget_unit1_percent 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

Line 384: ,p_budget_unit2_percent 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

Line 385: ,p_budget_unit3_percent 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

Line 386: ,p_budget_unit1_value 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

Line 387: ,p_budget_unit2_value 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

Line 388: ,p_budget_unit3_value 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

Line 389: ,p_budget_unit1_available 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
393: ,p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2

Line 390: ,p_budget_unit2_available 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
394: ,p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2

Line 391: ,p_budget_unit3_available 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
395: ,p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2

Line 393: ,p_budget_unit1_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

Line 394: ,p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2

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;

Line 395: ,p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2

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

Line 487: ,p_organization_id in number default hr_api.g_number

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

Line 488: ,p_job_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

Line 489: ,p_position_id 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

Line 490: ,p_grade_id in number default hr_api.g_number

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

Line 491: ,p_budget_version_id 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

Line 492: ,p_budget_unit1_percent 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

Line 493: ,p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2

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

Line 494: ,p_budget_unit1_value 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
498: ,p_budget_unit2_value in number default hr_api.g_number

Line 495: ,p_budget_unit1_available 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

Line 496: ,p_budget_unit2_percent 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

Line 497: ,p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2

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

Line 498: ,p_budget_unit2_value in number default hr_api.g_number

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

Line 499: ,p_budget_unit2_available 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

Line 500: ,p_budget_unit3_percent 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

Line 501: ,p_budget_unit3_value_type_cd 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

Line 502: ,p_budget_unit3_value in number default hr_api.g_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

Line 503: ,p_budget_unit3_available 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
507: l_object_version_number number := p_object_version_number;

Line 504: ,p_gl_status in varchar2 default hr_api.g_varchar2

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