DBA Data[Home] [Help]

APPS.PQH_BUDGET_SETS_API dependencies on HR_API

Line 74: when hr_api.cannot_find_prog_unit then

70: ,p_budget_unit3_value_type_cd => p_budget_unit3_value_type_cd
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_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_budget_set'
78: ,p_hook_type => 'BP'
79: );

Line 131: when hr_api.cannot_find_prog_unit then

127: ,p_budget_unit3_value_type_cd => p_budget_unit3_value_type_cd
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_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_budget_set'
134: ,p_hook_type => 'AP'
135: );
136: --

Line 147: raise hr_api.validate_enabled;

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

Line 159: when hr_api.validate_enabled then

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

Line 191: ,p_dflt_budget_set_id in number default hr_api.g_number

187: --
188: procedure update_budget_set
189: (p_validate in boolean default false
190: ,p_budget_set_id in number
191: ,p_dflt_budget_set_id in number default hr_api.g_number
192: ,p_budget_period_id in number default hr_api.g_number
193: ,p_budget_unit1_percent in number default hr_api.g_number
194: ,p_budget_unit2_percent in number default hr_api.g_number
195: ,p_budget_unit3_percent in number default hr_api.g_number

Line 192: ,p_budget_period_id in number default hr_api.g_number

188: procedure update_budget_set
189: (p_validate in boolean default false
190: ,p_budget_set_id in number
191: ,p_dflt_budget_set_id in number default hr_api.g_number
192: ,p_budget_period_id in number default hr_api.g_number
193: ,p_budget_unit1_percent in number default hr_api.g_number
194: ,p_budget_unit2_percent in number default hr_api.g_number
195: ,p_budget_unit3_percent in number default hr_api.g_number
196: ,p_budget_unit1_value in number default hr_api.g_number

Line 193: ,p_budget_unit1_percent in number default hr_api.g_number

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

Line 194: ,p_budget_unit2_percent in number default hr_api.g_number

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

Line 195: ,p_budget_unit3_percent in number default hr_api.g_number

191: ,p_dflt_budget_set_id in number default hr_api.g_number
192: ,p_budget_period_id in number default hr_api.g_number
193: ,p_budget_unit1_percent in number default hr_api.g_number
194: ,p_budget_unit2_percent in number default hr_api.g_number
195: ,p_budget_unit3_percent in number default hr_api.g_number
196: ,p_budget_unit1_value in number default hr_api.g_number
197: ,p_budget_unit2_value in number default hr_api.g_number
198: ,p_budget_unit3_value in number default hr_api.g_number
199: ,p_budget_unit1_available in number default hr_api.g_number

Line 196: ,p_budget_unit1_value in number default hr_api.g_number

192: ,p_budget_period_id in number default hr_api.g_number
193: ,p_budget_unit1_percent in number default hr_api.g_number
194: ,p_budget_unit2_percent in number default hr_api.g_number
195: ,p_budget_unit3_percent in number default hr_api.g_number
196: ,p_budget_unit1_value in number default hr_api.g_number
197: ,p_budget_unit2_value in number default hr_api.g_number
198: ,p_budget_unit3_value in number default hr_api.g_number
199: ,p_budget_unit1_available in number default hr_api.g_number
200: ,p_budget_unit2_available in number default hr_api.g_number

Line 197: ,p_budget_unit2_value in number default hr_api.g_number

193: ,p_budget_unit1_percent in number default hr_api.g_number
194: ,p_budget_unit2_percent in number default hr_api.g_number
195: ,p_budget_unit3_percent in number default hr_api.g_number
196: ,p_budget_unit1_value in number default hr_api.g_number
197: ,p_budget_unit2_value in number default hr_api.g_number
198: ,p_budget_unit3_value in number default hr_api.g_number
199: ,p_budget_unit1_available in number default hr_api.g_number
200: ,p_budget_unit2_available in number default hr_api.g_number
201: ,p_budget_unit3_available in number default hr_api.g_number

Line 198: ,p_budget_unit3_value in number default hr_api.g_number

194: ,p_budget_unit2_percent in number default hr_api.g_number
195: ,p_budget_unit3_percent in number default hr_api.g_number
196: ,p_budget_unit1_value in number default hr_api.g_number
197: ,p_budget_unit2_value in number default hr_api.g_number
198: ,p_budget_unit3_value in number default hr_api.g_number
199: ,p_budget_unit1_available in number default hr_api.g_number
200: ,p_budget_unit2_available in number default hr_api.g_number
201: ,p_budget_unit3_available in number default hr_api.g_number
202: ,p_object_version_number in out nocopy number

Line 199: ,p_budget_unit1_available in number default hr_api.g_number

195: ,p_budget_unit3_percent in number default hr_api.g_number
196: ,p_budget_unit1_value in number default hr_api.g_number
197: ,p_budget_unit2_value in number default hr_api.g_number
198: ,p_budget_unit3_value in number default hr_api.g_number
199: ,p_budget_unit1_available in number default hr_api.g_number
200: ,p_budget_unit2_available in number default hr_api.g_number
201: ,p_budget_unit3_available in number default hr_api.g_number
202: ,p_object_version_number in out nocopy number
203: ,p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2

Line 200: ,p_budget_unit2_available in number default hr_api.g_number

196: ,p_budget_unit1_value in number default hr_api.g_number
197: ,p_budget_unit2_value in number default hr_api.g_number
198: ,p_budget_unit3_value in number default hr_api.g_number
199: ,p_budget_unit1_available in number default hr_api.g_number
200: ,p_budget_unit2_available in number default hr_api.g_number
201: ,p_budget_unit3_available in number default hr_api.g_number
202: ,p_object_version_number in out nocopy number
203: ,p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2
204: ,p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2

Line 201: ,p_budget_unit3_available in number default hr_api.g_number

197: ,p_budget_unit2_value in number default hr_api.g_number
198: ,p_budget_unit3_value in number default hr_api.g_number
199: ,p_budget_unit1_available in number default hr_api.g_number
200: ,p_budget_unit2_available in number default hr_api.g_number
201: ,p_budget_unit3_available in number default hr_api.g_number
202: ,p_object_version_number in out nocopy number
203: ,p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2
204: ,p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2
205: ,p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2

Line 203: ,p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2

199: ,p_budget_unit1_available in number default hr_api.g_number
200: ,p_budget_unit2_available in number default hr_api.g_number
201: ,p_budget_unit3_available in number default hr_api.g_number
202: ,p_object_version_number in out nocopy number
203: ,p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2
204: ,p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2
205: ,p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2
206: ,p_effective_date in date
207: ) is

Line 204: ,p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2

200: ,p_budget_unit2_available in number default hr_api.g_number
201: ,p_budget_unit3_available in number default hr_api.g_number
202: ,p_object_version_number in out nocopy number
203: ,p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2
204: ,p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2
205: ,p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2
206: ,p_effective_date in date
207: ) is
208: --

Line 205: ,p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2

201: ,p_budget_unit3_available in number default hr_api.g_number
202: ,p_object_version_number in out nocopy number
203: ,p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2
204: ,p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2
205: ,p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2
206: ,p_effective_date in date
207: ) is
208: --
209: -- Declare cursors and local variables

Line 253: when hr_api.cannot_find_prog_unit then

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

Line 254: hr_api.cannot_find_prog_unit_error

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

Line 309: when hr_api.cannot_find_prog_unit then

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

Line 310: hr_api.cannot_find_prog_unit_error

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

Line 324: raise hr_api.validate_enabled;

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

Line 335: when hr_api.validate_enabled then

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

Line 399: when hr_api.cannot_find_prog_unit then

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

Line 400: hr_api.cannot_find_prog_unit_error

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

Line 427: when hr_api.cannot_find_prog_unit then

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

Line 428: hr_api.cannot_find_prog_unit_error

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

Line 442: raise hr_api.validate_enabled;

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

Line 449: when hr_api.validate_enabled then

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