DBA Data[Home] [Help]

APPS.PQH_BUDGET_VERSIONS_API dependencies on HR_API

Line 72: when hr_api.cannot_find_prog_unit then

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

Line 73: hr_api.cannot_find_prog_unit_error

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

Line 127: when hr_api.cannot_find_prog_unit then

123: ,p_budget_unit3_available => p_budget_unit3_available
124: ,p_effective_date => trunc(p_effective_date)
125: );
126: exception
127: when hr_api.cannot_find_prog_unit then
128: hr_api.cannot_find_prog_unit_error
129: (p_module_name => 'create_budget_version'
130: ,p_hook_type => 'AP'
131: );

Line 128: hr_api.cannot_find_prog_unit_error

124: ,p_effective_date => trunc(p_effective_date)
125: );
126: exception
127: when hr_api.cannot_find_prog_unit then
128: hr_api.cannot_find_prog_unit_error
129: (p_module_name => 'create_budget_version'
130: ,p_hook_type => 'AP'
131: );
132: --

Line 142: raise hr_api.validate_enabled;

138: --
139: -- When in validation only mode raise the Validate_Enabled exception
140: --
141: if p_validate then
142: raise hr_api.validate_enabled;
143: end if;
144: --
145: -- Set all output arguments
146: --

Line 154: when hr_api.validate_enabled then

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

Line 186: ,p_budget_id in number default hr_api.g_number

182: --
183: procedure update_budget_version
184: (p_validate in boolean default false
185: ,p_budget_version_id in number
186: ,p_budget_id in number default hr_api.g_number
187: ,p_version_number in number default hr_api.g_number
188: ,p_date_from in date default hr_api.g_date
189: ,p_date_to in date default hr_api.g_date
190: ,p_transfered_to_gl_flag in varchar2 default hr_api.g_varchar2

Line 187: ,p_version_number in number default hr_api.g_number

183: procedure update_budget_version
184: (p_validate in boolean default false
185: ,p_budget_version_id in number
186: ,p_budget_id in number default hr_api.g_number
187: ,p_version_number in number default hr_api.g_number
188: ,p_date_from in date default hr_api.g_date
189: ,p_date_to in date default hr_api.g_date
190: ,p_transfered_to_gl_flag in varchar2 default hr_api.g_varchar2
191: ,p_gl_status in varchar2 default hr_api.g_varchar2

Line 188: ,p_date_from in date default hr_api.g_date

184: (p_validate in boolean default false
185: ,p_budget_version_id in number
186: ,p_budget_id in number default hr_api.g_number
187: ,p_version_number in number default hr_api.g_number
188: ,p_date_from in date default hr_api.g_date
189: ,p_date_to in date default hr_api.g_date
190: ,p_transfered_to_gl_flag in varchar2 default hr_api.g_varchar2
191: ,p_gl_status in varchar2 default hr_api.g_varchar2
192: ,p_xfer_to_other_apps_cd in varchar2 default hr_api.g_varchar2

Line 189: ,p_date_to in date default hr_api.g_date

185: ,p_budget_version_id in number
186: ,p_budget_id in number default hr_api.g_number
187: ,p_version_number in number default hr_api.g_number
188: ,p_date_from in date default hr_api.g_date
189: ,p_date_to in date default hr_api.g_date
190: ,p_transfered_to_gl_flag in varchar2 default hr_api.g_varchar2
191: ,p_gl_status in varchar2 default hr_api.g_varchar2
192: ,p_xfer_to_other_apps_cd in varchar2 default hr_api.g_varchar2
193: ,p_object_version_number in out nocopy number

Line 190: ,p_transfered_to_gl_flag in varchar2 default hr_api.g_varchar2

186: ,p_budget_id in number default hr_api.g_number
187: ,p_version_number in number default hr_api.g_number
188: ,p_date_from in date default hr_api.g_date
189: ,p_date_to in date default hr_api.g_date
190: ,p_transfered_to_gl_flag in varchar2 default hr_api.g_varchar2
191: ,p_gl_status in varchar2 default hr_api.g_varchar2
192: ,p_xfer_to_other_apps_cd in varchar2 default hr_api.g_varchar2
193: ,p_object_version_number in out nocopy number
194: ,p_budget_unit1_value in number default hr_api.g_number

Line 191: ,p_gl_status in varchar2 default hr_api.g_varchar2

187: ,p_version_number in number default hr_api.g_number
188: ,p_date_from in date default hr_api.g_date
189: ,p_date_to in date default hr_api.g_date
190: ,p_transfered_to_gl_flag in varchar2 default hr_api.g_varchar2
191: ,p_gl_status in varchar2 default hr_api.g_varchar2
192: ,p_xfer_to_other_apps_cd in varchar2 default hr_api.g_varchar2
193: ,p_object_version_number in out nocopy number
194: ,p_budget_unit1_value in number default hr_api.g_number
195: ,p_budget_unit2_value in number default hr_api.g_number

Line 192: ,p_xfer_to_other_apps_cd in varchar2 default hr_api.g_varchar2

188: ,p_date_from in date default hr_api.g_date
189: ,p_date_to in date default hr_api.g_date
190: ,p_transfered_to_gl_flag in varchar2 default hr_api.g_varchar2
191: ,p_gl_status in varchar2 default hr_api.g_varchar2
192: ,p_xfer_to_other_apps_cd in varchar2 default hr_api.g_varchar2
193: ,p_object_version_number in out nocopy number
194: ,p_budget_unit1_value in number default hr_api.g_number
195: ,p_budget_unit2_value in number default hr_api.g_number
196: ,p_budget_unit3_value in number default hr_api.g_number

Line 194: ,p_budget_unit1_value in number default hr_api.g_number

190: ,p_transfered_to_gl_flag in varchar2 default hr_api.g_varchar2
191: ,p_gl_status in varchar2 default hr_api.g_varchar2
192: ,p_xfer_to_other_apps_cd in varchar2 default hr_api.g_varchar2
193: ,p_object_version_number in out nocopy number
194: ,p_budget_unit1_value in number default hr_api.g_number
195: ,p_budget_unit2_value in number default hr_api.g_number
196: ,p_budget_unit3_value in number default hr_api.g_number
197: ,p_budget_unit1_available in number default hr_api.g_number
198: ,p_budget_unit2_available in number default hr_api.g_number

Line 195: ,p_budget_unit2_value in number default hr_api.g_number

191: ,p_gl_status in varchar2 default hr_api.g_varchar2
192: ,p_xfer_to_other_apps_cd in varchar2 default hr_api.g_varchar2
193: ,p_object_version_number in out nocopy number
194: ,p_budget_unit1_value in number default hr_api.g_number
195: ,p_budget_unit2_value in number default hr_api.g_number
196: ,p_budget_unit3_value in number default hr_api.g_number
197: ,p_budget_unit1_available in number default hr_api.g_number
198: ,p_budget_unit2_available in number default hr_api.g_number
199: ,p_budget_unit3_available in number default hr_api.g_number

Line 196: ,p_budget_unit3_value in number default hr_api.g_number

192: ,p_xfer_to_other_apps_cd in varchar2 default hr_api.g_varchar2
193: ,p_object_version_number in out nocopy number
194: ,p_budget_unit1_value in number default hr_api.g_number
195: ,p_budget_unit2_value in number default hr_api.g_number
196: ,p_budget_unit3_value in number default hr_api.g_number
197: ,p_budget_unit1_available in number default hr_api.g_number
198: ,p_budget_unit2_available in number default hr_api.g_number
199: ,p_budget_unit3_available in number default hr_api.g_number
200: ,p_effective_date in date

Line 197: ,p_budget_unit1_available in number default hr_api.g_number

193: ,p_object_version_number in out nocopy number
194: ,p_budget_unit1_value in number default hr_api.g_number
195: ,p_budget_unit2_value in number default hr_api.g_number
196: ,p_budget_unit3_value in number default hr_api.g_number
197: ,p_budget_unit1_available in number default hr_api.g_number
198: ,p_budget_unit2_available in number default hr_api.g_number
199: ,p_budget_unit3_available in number default hr_api.g_number
200: ,p_effective_date in date
201: ) is

Line 198: ,p_budget_unit2_available in number default hr_api.g_number

194: ,p_budget_unit1_value in number default hr_api.g_number
195: ,p_budget_unit2_value in number default hr_api.g_number
196: ,p_budget_unit3_value in number default hr_api.g_number
197: ,p_budget_unit1_available in number default hr_api.g_number
198: ,p_budget_unit2_available in number default hr_api.g_number
199: ,p_budget_unit3_available in number default hr_api.g_number
200: ,p_effective_date in date
201: ) is
202: --

Line 199: ,p_budget_unit3_available in number default hr_api.g_number

195: ,p_budget_unit2_value in number default hr_api.g_number
196: ,p_budget_unit3_value in number default hr_api.g_number
197: ,p_budget_unit1_available in number default hr_api.g_number
198: ,p_budget_unit2_available in number default hr_api.g_number
199: ,p_budget_unit3_available in number default hr_api.g_number
200: ,p_effective_date in date
201: ) is
202: --
203: -- Declare cursors and local variables

Line 246: when hr_api.cannot_find_prog_unit then

242: ,p_budget_unit3_available => p_budget_unit3_available
243: ,p_effective_date => trunc(p_effective_date)
244: );
245: exception
246: when hr_api.cannot_find_prog_unit then
247: hr_api.cannot_find_prog_unit_error
248: (p_module_name => 'update_budget_version'
249: ,p_hook_type => 'BP'
250: );

Line 247: hr_api.cannot_find_prog_unit_error

243: ,p_effective_date => trunc(p_effective_date)
244: );
245: exception
246: when hr_api.cannot_find_prog_unit then
247: hr_api.cannot_find_prog_unit_error
248: (p_module_name => 'update_budget_version'
249: ,p_hook_type => 'BP'
250: );
251: --

Line 300: when hr_api.cannot_find_prog_unit then

296: ,p_budget_unit3_available => p_budget_unit3_available
297: ,p_effective_date => trunc(p_effective_date)
298: );
299: exception
300: when hr_api.cannot_find_prog_unit then
301: hr_api.cannot_find_prog_unit_error
302: (p_module_name => 'update_budget_version'
303: ,p_hook_type => 'AP'
304: );

Line 301: hr_api.cannot_find_prog_unit_error

297: ,p_effective_date => trunc(p_effective_date)
298: );
299: exception
300: when hr_api.cannot_find_prog_unit then
301: hr_api.cannot_find_prog_unit_error
302: (p_module_name => 'update_budget_version'
303: ,p_hook_type => 'AP'
304: );
305: --

Line 315: raise hr_api.validate_enabled;

311: --
312: -- When in validation only mode raise the Validate_Enabled exception
313: --
314: if p_validate then
315: raise hr_api.validate_enabled;
316: end if;
317: --
318: -- Set all output arguments
319: --

Line 326: when hr_api.validate_enabled then

322: hr_utility.set_location(' Leaving:'||l_proc, 70);
323: --
324: exception
325: --
326: when hr_api.validate_enabled then
327: --
328: -- As the Validate_Enabled exception has been raised
329: -- we must rollback to the savepoint
330: --

Line 390: when hr_api.cannot_find_prog_unit then

386: ,p_object_version_number => p_object_version_number
387: ,p_effective_date => trunc(p_effective_date)
388: );
389: exception
390: when hr_api.cannot_find_prog_unit then
391: hr_api.cannot_find_prog_unit_error
392: (p_module_name => 'delete_budget_version'
393: ,p_hook_type => 'BP'
394: );

Line 391: hr_api.cannot_find_prog_unit_error

387: ,p_effective_date => trunc(p_effective_date)
388: );
389: exception
390: when hr_api.cannot_find_prog_unit then
391: hr_api.cannot_find_prog_unit_error
392: (p_module_name => 'delete_budget_version'
393: ,p_hook_type => 'BP'
394: );
395: --

Line 418: when hr_api.cannot_find_prog_unit then

414: ,p_object_version_number => l_object_version_number
415: ,p_effective_date => trunc(p_effective_date)
416: );
417: exception
418: when hr_api.cannot_find_prog_unit then
419: hr_api.cannot_find_prog_unit_error
420: (p_module_name => 'delete_budget_version'
421: ,p_hook_type => 'AP'
422: );

Line 419: hr_api.cannot_find_prog_unit_error

415: ,p_effective_date => trunc(p_effective_date)
416: );
417: exception
418: when hr_api.cannot_find_prog_unit then
419: hr_api.cannot_find_prog_unit_error
420: (p_module_name => 'delete_budget_version'
421: ,p_hook_type => 'AP'
422: );
423: --

Line 433: raise hr_api.validate_enabled;

429: --
430: -- When in validation only mode raise the Validate_Enabled exception
431: --
432: if p_validate then
433: raise hr_api.validate_enabled;
434: end if;
435: --
436: hr_utility.set_location(' Leaving:'||l_proc, 70);
437: --

Line 440: when hr_api.validate_enabled then

436: hr_utility.set_location(' Leaving:'||l_proc, 70);
437: --
438: exception
439: --
440: when hr_api.validate_enabled then
441: --
442: -- As the Validate_Enabled exception has been raised
443: -- we must rollback to the savepoint
444: --