DBA Data[Home] [Help]

APPS.PQH_WORKSHEET_BUDGET_SETS_API dependencies on HR_API

Line 74: when hr_api.cannot_find_prog_unit then

70: ,p_budget_unit3_available => p_budget_unit3_available
71: ,p_effective_date => trunc(p_effective_date)
72: );
73: exception
74: when hr_api.cannot_find_prog_unit then
75: hr_api.cannot_find_prog_unit_error
76: (
77: p_module_name => 'CREATE_WORKSHEET_BUDGET_SET'
78: ,p_hook_type => 'BP'

Line 75: hr_api.cannot_find_prog_unit_error

71: ,p_effective_date => trunc(p_effective_date)
72: );
73: exception
74: when hr_api.cannot_find_prog_unit then
75: hr_api.cannot_find_prog_unit_error
76: (
77: p_module_name => 'CREATE_WORKSHEET_BUDGET_SET'
78: ,p_hook_type => 'BP'
79: );

Line 131: when hr_api.cannot_find_prog_unit then

127: ,p_budget_unit3_available => p_budget_unit3_available
128: ,p_effective_date => trunc(p_effective_date)
129: );
130: exception
131: when hr_api.cannot_find_prog_unit then
132: hr_api.cannot_find_prog_unit_error
133: (p_module_name => 'CREATE_WORKSHEET_BUDGET_SET'
134: ,p_hook_type => 'AP'
135: );

Line 132: hr_api.cannot_find_prog_unit_error

128: ,p_effective_date => trunc(p_effective_date)
129: );
130: exception
131: when hr_api.cannot_find_prog_unit then
132: hr_api.cannot_find_prog_unit_error
133: (p_module_name => 'CREATE_WORKSHEET_BUDGET_SET'
134: ,p_hook_type => 'AP'
135: );
136: --

Line 146: raise hr_api.validate_enabled;

142: --
143: -- When in validation only mode raise the Validate_Enabled exception
144: --
145: if p_validate then
146: raise hr_api.validate_enabled;
147: end if;
148: --
149: -- Set all output arguments
150: --

Line 158: when hr_api.validate_enabled then

154: hr_utility.set_location(' Leaving:'||l_proc, 70);
155: --
156: exception
157: --
158: when hr_api.validate_enabled then
159: --
160: -- As the Validate_Enabled exception has been raised
161: -- we must rollback to the savepoint
162: --

Line 190: ,p_dflt_budget_set_id in number default hr_api.g_number

186: --
187: procedure update_WORKSHEET_BUDGET_SET
188: (p_validate in boolean default false
189: ,p_worksheet_budget_set_id in number
190: ,p_dflt_budget_set_id in number default hr_api.g_number
191: ,p_worksheet_period_id in number default hr_api.g_number
192: ,p_budget_unit1_percent in number default hr_api.g_number
193: ,p_budget_unit2_percent in number default hr_api.g_number
194: ,p_budget_unit3_percent in number default hr_api.g_number

Line 191: ,p_worksheet_period_id in number default hr_api.g_number

187: procedure update_WORKSHEET_BUDGET_SET
188: (p_validate in boolean default false
189: ,p_worksheet_budget_set_id in number
190: ,p_dflt_budget_set_id in number default hr_api.g_number
191: ,p_worksheet_period_id in number default hr_api.g_number
192: ,p_budget_unit1_percent in number default hr_api.g_number
193: ,p_budget_unit2_percent in number default hr_api.g_number
194: ,p_budget_unit3_percent in number default hr_api.g_number
195: ,p_budget_unit1_value in number default hr_api.g_number

Line 192: ,p_budget_unit1_percent in number default hr_api.g_number

188: (p_validate in boolean default false
189: ,p_worksheet_budget_set_id in number
190: ,p_dflt_budget_set_id in number default hr_api.g_number
191: ,p_worksheet_period_id in number default hr_api.g_number
192: ,p_budget_unit1_percent in number default hr_api.g_number
193: ,p_budget_unit2_percent in number default hr_api.g_number
194: ,p_budget_unit3_percent in number default hr_api.g_number
195: ,p_budget_unit1_value in number default hr_api.g_number
196: ,p_budget_unit2_value in number default hr_api.g_number

Line 193: ,p_budget_unit2_percent in number default hr_api.g_number

189: ,p_worksheet_budget_set_id in number
190: ,p_dflt_budget_set_id in number default hr_api.g_number
191: ,p_worksheet_period_id in number default hr_api.g_number
192: ,p_budget_unit1_percent in number default hr_api.g_number
193: ,p_budget_unit2_percent in number default hr_api.g_number
194: ,p_budget_unit3_percent in number default hr_api.g_number
195: ,p_budget_unit1_value in number default hr_api.g_number
196: ,p_budget_unit2_value in number default hr_api.g_number
197: ,p_budget_unit3_value in number default hr_api.g_number

Line 194: ,p_budget_unit3_percent in number default hr_api.g_number

190: ,p_dflt_budget_set_id in number default hr_api.g_number
191: ,p_worksheet_period_id in number default hr_api.g_number
192: ,p_budget_unit1_percent in number default hr_api.g_number
193: ,p_budget_unit2_percent in number default hr_api.g_number
194: ,p_budget_unit3_percent in number default hr_api.g_number
195: ,p_budget_unit1_value in number default hr_api.g_number
196: ,p_budget_unit2_value in number default hr_api.g_number
197: ,p_budget_unit3_value in number default hr_api.g_number
198: ,p_object_version_number in out nocopy number

Line 195: ,p_budget_unit1_value in number default hr_api.g_number

191: ,p_worksheet_period_id in number default hr_api.g_number
192: ,p_budget_unit1_percent in number default hr_api.g_number
193: ,p_budget_unit2_percent in number default hr_api.g_number
194: ,p_budget_unit3_percent in number default hr_api.g_number
195: ,p_budget_unit1_value in number default hr_api.g_number
196: ,p_budget_unit2_value in number default hr_api.g_number
197: ,p_budget_unit3_value 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

Line 196: ,p_budget_unit2_value in number default hr_api.g_number

192: ,p_budget_unit1_percent in number default hr_api.g_number
193: ,p_budget_unit2_percent in number default hr_api.g_number
194: ,p_budget_unit3_percent in number default hr_api.g_number
195: ,p_budget_unit1_value in number default hr_api.g_number
196: ,p_budget_unit2_value in number default hr_api.g_number
197: ,p_budget_unit3_value 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

Line 197: ,p_budget_unit3_value in number default hr_api.g_number

193: ,p_budget_unit2_percent in number default hr_api.g_number
194: ,p_budget_unit3_percent in number default hr_api.g_number
195: ,p_budget_unit1_value in number default hr_api.g_number
196: ,p_budget_unit2_value in number default hr_api.g_number
197: ,p_budget_unit3_value 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

Line 199: ,p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2

195: ,p_budget_unit1_value in number default hr_api.g_number
196: ,p_budget_unit2_value in number default hr_api.g_number
197: ,p_budget_unit3_value 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_budget_unit1_available in number default hr_api.g_number
203: ,p_budget_unit2_available in number default hr_api.g_number

Line 200: ,p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2

196: ,p_budget_unit2_value in number default hr_api.g_number
197: ,p_budget_unit3_value 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_budget_unit1_available in number default hr_api.g_number
203: ,p_budget_unit2_available in number default hr_api.g_number
204: ,p_budget_unit3_available in number default hr_api.g_number

Line 201: ,p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2

197: ,p_budget_unit3_value 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_budget_unit1_available in number default hr_api.g_number
203: ,p_budget_unit2_available in number default hr_api.g_number
204: ,p_budget_unit3_available in number default hr_api.g_number
205: ,p_effective_date in date

Line 202: ,p_budget_unit1_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_budget_unit1_available in number default hr_api.g_number
203: ,p_budget_unit2_available in number default hr_api.g_number
204: ,p_budget_unit3_available in number default hr_api.g_number
205: ,p_effective_date in date
206: ) is

Line 203: ,p_budget_unit2_available in number default hr_api.g_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_budget_unit1_available in number default hr_api.g_number
203: ,p_budget_unit2_available in number default hr_api.g_number
204: ,p_budget_unit3_available in number default hr_api.g_number
205: ,p_effective_date in date
206: ) is
207: --

Line 204: ,p_budget_unit3_available in number default hr_api.g_number

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_budget_unit1_available in number default hr_api.g_number
203: ,p_budget_unit2_available in number default hr_api.g_number
204: ,p_budget_unit3_available in number default hr_api.g_number
205: ,p_effective_date in date
206: ) is
207: --
208: -- Declare cursors and local variables

Line 252: when hr_api.cannot_find_prog_unit then

248: ,p_budget_unit3_available => p_budget_unit3_available
249: ,p_effective_date => trunc(p_effective_date)
250: );
251: exception
252: when hr_api.cannot_find_prog_unit then
253: hr_api.cannot_find_prog_unit_error
254: (p_module_name => 'UPDATE_WORKSHEET_BUDGET_SET'
255: ,p_hook_type => 'BP'
256: );

Line 253: hr_api.cannot_find_prog_unit_error

249: ,p_effective_date => trunc(p_effective_date)
250: );
251: exception
252: when hr_api.cannot_find_prog_unit then
253: hr_api.cannot_find_prog_unit_error
254: (p_module_name => 'UPDATE_WORKSHEET_BUDGET_SET'
255: ,p_hook_type => 'BP'
256: );
257: --

Line 308: when hr_api.cannot_find_prog_unit then

304: ,p_budget_unit3_available => p_budget_unit3_available
305: ,p_effective_date => trunc(p_effective_date)
306: );
307: exception
308: when hr_api.cannot_find_prog_unit then
309: hr_api.cannot_find_prog_unit_error
310: (p_module_name => 'UPDATE_WORKSHEET_BUDGET_SET'
311: ,p_hook_type => 'AP'
312: );

Line 309: hr_api.cannot_find_prog_unit_error

305: ,p_effective_date => trunc(p_effective_date)
306: );
307: exception
308: when hr_api.cannot_find_prog_unit then
309: hr_api.cannot_find_prog_unit_error
310: (p_module_name => 'UPDATE_WORKSHEET_BUDGET_SET'
311: ,p_hook_type => 'AP'
312: );
313: --

Line 323: raise hr_api.validate_enabled;

319: --
320: -- When in validation only mode raise the Validate_Enabled exception
321: --
322: if p_validate then
323: raise hr_api.validate_enabled;
324: end if;
325: --
326: -- Set all output arguments
327: --

Line 334: when hr_api.validate_enabled then

330: hr_utility.set_location(' Leaving:'||l_proc, 70);
331: --
332: exception
333: --
334: when hr_api.validate_enabled then
335: --
336: -- As the Validate_Enabled exception has been raised
337: -- we must rollback to the savepoint
338: --

Line 398: when hr_api.cannot_find_prog_unit then

394: ,p_object_version_number => p_object_version_number
395: ,p_effective_date => trunc(p_effective_date)
396: );
397: exception
398: when hr_api.cannot_find_prog_unit then
399: hr_api.cannot_find_prog_unit_error
400: (p_module_name => 'DELETE_WORKSHEET_BUDGET_SET'
401: ,p_hook_type => 'BP'
402: );

Line 399: hr_api.cannot_find_prog_unit_error

395: ,p_effective_date => trunc(p_effective_date)
396: );
397: exception
398: when hr_api.cannot_find_prog_unit then
399: hr_api.cannot_find_prog_unit_error
400: (p_module_name => 'DELETE_WORKSHEET_BUDGET_SET'
401: ,p_hook_type => 'BP'
402: );
403: --

Line 426: when hr_api.cannot_find_prog_unit then

422: ,p_object_version_number => l_object_version_number
423: ,p_effective_date => trunc(p_effective_date)
424: );
425: exception
426: when hr_api.cannot_find_prog_unit then
427: hr_api.cannot_find_prog_unit_error
428: (p_module_name => 'DELETE_WORKSHEET_BUDGET_SET'
429: ,p_hook_type => 'AP'
430: );

Line 427: hr_api.cannot_find_prog_unit_error

423: ,p_effective_date => trunc(p_effective_date)
424: );
425: exception
426: when hr_api.cannot_find_prog_unit then
427: hr_api.cannot_find_prog_unit_error
428: (p_module_name => 'DELETE_WORKSHEET_BUDGET_SET'
429: ,p_hook_type => 'AP'
430: );
431: --

Line 441: raise hr_api.validate_enabled;

437: --
438: -- When in validation only mode raise the Validate_Enabled exception
439: --
440: if p_validate then
441: raise hr_api.validate_enabled;
442: end if;
443: --
444: hr_utility.set_location(' Leaving:'||l_proc, 70);
445: --

Line 448: when hr_api.validate_enabled then

444: hr_utility.set_location(' Leaving:'||l_proc, 70);
445: --
446: exception
447: --
448: when hr_api.validate_enabled then
449: --
450: -- As the Validate_Enabled exception has been raised
451: -- we must rollback to the savepoint
452: --