DBA Data[Home] [Help]

APPS.HR_PROGRESSION_POINT_API dependencies on HR_API

Line 133: when hr_api.cannot_find_prog_unit then

129: ,p_information29 => p_information29
130: ,p_information30 => p_information30
131: );
132: exception
133: when hr_api.cannot_find_prog_unit then
134: hr_api.cannot_find_prog_unit_error
135: (p_module_name => 'CREATE_PROGRESSION_POINT'
136: ,p_hook_type => 'BP'
137: );

Line 134: hr_api.cannot_find_prog_unit_error

130: ,p_information30 => p_information30
131: );
132: exception
133: when hr_api.cannot_find_prog_unit then
134: hr_api.cannot_find_prog_unit_error
135: (p_module_name => 'CREATE_PROGRESSION_POINT'
136: ,p_hook_type => 'BP'
137: );
138: --

Line 250: when hr_api.cannot_find_prog_unit then

246: ,p_information29 => p_information29
247: ,p_information30 => p_information30
248: );
249: exception
250: when hr_api.cannot_find_prog_unit then
251: hr_api.cannot_find_prog_unit_error
252: (p_module_name => 'CREATE_PREGORESSION_POINT'
253: ,p_hook_type => 'AP'
254: );

Line 251: hr_api.cannot_find_prog_unit_error

247: ,p_information30 => p_information30
248: );
249: exception
250: when hr_api.cannot_find_prog_unit then
251: hr_api.cannot_find_prog_unit_error
252: (p_module_name => 'CREATE_PREGORESSION_POINT'
253: ,p_hook_type => 'AP'
254: );
255: --

Line 264: raise hr_api.validate_enabled;

260: -- When in validation only mode raise the Validate_Enabled exception
261: --
262: if p_validate
263: then
264: raise hr_api.validate_enabled;
265: end if;
266: --
267: hr_utility.set_location(l_proc, 50);
268: --

Line 278: when hr_api.validate_enabled then

274: hr_utility.set_location(' Leaving:' ||l_proc, 60);
275: --
276: exception
277: --
278: when hr_api.validate_enabled then
279: --
280: -- As the Validate_Enabled exception has been raised
281: -- we must rollback to the savepoint
282: --

Line 318: ,p_effective_date in date default hr_api.g_date

314: --
315: procedure update_progression_point
316: (p_validate in boolean default false
317: ,p_spinal_point_id in number
318: ,p_effective_date in date default hr_api.g_date
319: ,p_business_group_id in number default hr_api.g_number
320: ,p_parent_spine_id in number default hr_api.g_number
321: ,p_sequence in number default hr_api.g_number
322: ,p_spinal_point in varchar2 default hr_api.g_varchar2

Line 319: ,p_business_group_id in number default hr_api.g_number

315: procedure update_progression_point
316: (p_validate in boolean default false
317: ,p_spinal_point_id in number
318: ,p_effective_date in date default hr_api.g_date
319: ,p_business_group_id in number default hr_api.g_number
320: ,p_parent_spine_id in number default hr_api.g_number
321: ,p_sequence in number default hr_api.g_number
322: ,p_spinal_point in varchar2 default hr_api.g_varchar2
323: ,p_request_id in number default hr_api.g_number

Line 320: ,p_parent_spine_id in number default hr_api.g_number

316: (p_validate in boolean default false
317: ,p_spinal_point_id in number
318: ,p_effective_date in date default hr_api.g_date
319: ,p_business_group_id in number default hr_api.g_number
320: ,p_parent_spine_id in number default hr_api.g_number
321: ,p_sequence in number default hr_api.g_number
322: ,p_spinal_point in varchar2 default hr_api.g_varchar2
323: ,p_request_id in number default hr_api.g_number
324: ,p_program_application_id in number default hr_api.g_number

Line 321: ,p_sequence in number default hr_api.g_number

317: ,p_spinal_point_id in number
318: ,p_effective_date in date default hr_api.g_date
319: ,p_business_group_id in number default hr_api.g_number
320: ,p_parent_spine_id in number default hr_api.g_number
321: ,p_sequence in number default hr_api.g_number
322: ,p_spinal_point in varchar2 default hr_api.g_varchar2
323: ,p_request_id in number default hr_api.g_number
324: ,p_program_application_id in number default hr_api.g_number
325: ,p_program_id in number default hr_api.g_number

Line 322: ,p_spinal_point in varchar2 default hr_api.g_varchar2

318: ,p_effective_date in date default hr_api.g_date
319: ,p_business_group_id in number default hr_api.g_number
320: ,p_parent_spine_id in number default hr_api.g_number
321: ,p_sequence in number default hr_api.g_number
322: ,p_spinal_point in varchar2 default hr_api.g_varchar2
323: ,p_request_id in number default hr_api.g_number
324: ,p_program_application_id in number default hr_api.g_number
325: ,p_program_id in number default hr_api.g_number
326: ,p_program_update_date in date default hr_api.g_date

Line 323: ,p_request_id in number default hr_api.g_number

319: ,p_business_group_id in number default hr_api.g_number
320: ,p_parent_spine_id in number default hr_api.g_number
321: ,p_sequence in number default hr_api.g_number
322: ,p_spinal_point in varchar2 default hr_api.g_varchar2
323: ,p_request_id in number default hr_api.g_number
324: ,p_program_application_id in number default hr_api.g_number
325: ,p_program_id in number default hr_api.g_number
326: ,p_program_update_date in date default hr_api.g_date
327: ,p_information_category in varchar2 default hr_api.g_varchar2

Line 324: ,p_program_application_id in number default hr_api.g_number

320: ,p_parent_spine_id in number default hr_api.g_number
321: ,p_sequence in number default hr_api.g_number
322: ,p_spinal_point in varchar2 default hr_api.g_varchar2
323: ,p_request_id in number default hr_api.g_number
324: ,p_program_application_id in number default hr_api.g_number
325: ,p_program_id in number default hr_api.g_number
326: ,p_program_update_date in date default hr_api.g_date
327: ,p_information_category in varchar2 default hr_api.g_varchar2
328: ,p_information1 in varchar2 default hr_api.g_varchar2

Line 325: ,p_program_id in number default hr_api.g_number

321: ,p_sequence in number default hr_api.g_number
322: ,p_spinal_point in varchar2 default hr_api.g_varchar2
323: ,p_request_id in number default hr_api.g_number
324: ,p_program_application_id in number default hr_api.g_number
325: ,p_program_id in number default hr_api.g_number
326: ,p_program_update_date in date default hr_api.g_date
327: ,p_information_category in varchar2 default hr_api.g_varchar2
328: ,p_information1 in varchar2 default hr_api.g_varchar2
329: ,p_information2 in varchar2 default hr_api.g_varchar2

Line 326: ,p_program_update_date in date default hr_api.g_date

322: ,p_spinal_point in varchar2 default hr_api.g_varchar2
323: ,p_request_id in number default hr_api.g_number
324: ,p_program_application_id in number default hr_api.g_number
325: ,p_program_id in number default hr_api.g_number
326: ,p_program_update_date in date default hr_api.g_date
327: ,p_information_category in varchar2 default hr_api.g_varchar2
328: ,p_information1 in varchar2 default hr_api.g_varchar2
329: ,p_information2 in varchar2 default hr_api.g_varchar2
330: ,p_information3 in varchar2 default hr_api.g_varchar2

Line 327: ,p_information_category in varchar2 default hr_api.g_varchar2

323: ,p_request_id in number default hr_api.g_number
324: ,p_program_application_id in number default hr_api.g_number
325: ,p_program_id in number default hr_api.g_number
326: ,p_program_update_date in date default hr_api.g_date
327: ,p_information_category in varchar2 default hr_api.g_varchar2
328: ,p_information1 in varchar2 default hr_api.g_varchar2
329: ,p_information2 in varchar2 default hr_api.g_varchar2
330: ,p_information3 in varchar2 default hr_api.g_varchar2
331: ,p_information4 in varchar2 default hr_api.g_varchar2

Line 328: ,p_information1 in varchar2 default hr_api.g_varchar2

324: ,p_program_application_id in number default hr_api.g_number
325: ,p_program_id in number default hr_api.g_number
326: ,p_program_update_date in date default hr_api.g_date
327: ,p_information_category in varchar2 default hr_api.g_varchar2
328: ,p_information1 in varchar2 default hr_api.g_varchar2
329: ,p_information2 in varchar2 default hr_api.g_varchar2
330: ,p_information3 in varchar2 default hr_api.g_varchar2
331: ,p_information4 in varchar2 default hr_api.g_varchar2
332: ,p_information5 in varchar2 default hr_api.g_varchar2

Line 329: ,p_information2 in varchar2 default hr_api.g_varchar2

325: ,p_program_id in number default hr_api.g_number
326: ,p_program_update_date in date default hr_api.g_date
327: ,p_information_category in varchar2 default hr_api.g_varchar2
328: ,p_information1 in varchar2 default hr_api.g_varchar2
329: ,p_information2 in varchar2 default hr_api.g_varchar2
330: ,p_information3 in varchar2 default hr_api.g_varchar2
331: ,p_information4 in varchar2 default hr_api.g_varchar2
332: ,p_information5 in varchar2 default hr_api.g_varchar2
333: ,p_information6 in varchar2 default hr_api.g_varchar2

Line 330: ,p_information3 in varchar2 default hr_api.g_varchar2

326: ,p_program_update_date in date default hr_api.g_date
327: ,p_information_category in varchar2 default hr_api.g_varchar2
328: ,p_information1 in varchar2 default hr_api.g_varchar2
329: ,p_information2 in varchar2 default hr_api.g_varchar2
330: ,p_information3 in varchar2 default hr_api.g_varchar2
331: ,p_information4 in varchar2 default hr_api.g_varchar2
332: ,p_information5 in varchar2 default hr_api.g_varchar2
333: ,p_information6 in varchar2 default hr_api.g_varchar2
334: ,p_information7 in varchar2 default hr_api.g_varchar2

Line 331: ,p_information4 in varchar2 default hr_api.g_varchar2

327: ,p_information_category in varchar2 default hr_api.g_varchar2
328: ,p_information1 in varchar2 default hr_api.g_varchar2
329: ,p_information2 in varchar2 default hr_api.g_varchar2
330: ,p_information3 in varchar2 default hr_api.g_varchar2
331: ,p_information4 in varchar2 default hr_api.g_varchar2
332: ,p_information5 in varchar2 default hr_api.g_varchar2
333: ,p_information6 in varchar2 default hr_api.g_varchar2
334: ,p_information7 in varchar2 default hr_api.g_varchar2
335: ,p_information8 in varchar2 default hr_api.g_varchar2

Line 332: ,p_information5 in varchar2 default hr_api.g_varchar2

328: ,p_information1 in varchar2 default hr_api.g_varchar2
329: ,p_information2 in varchar2 default hr_api.g_varchar2
330: ,p_information3 in varchar2 default hr_api.g_varchar2
331: ,p_information4 in varchar2 default hr_api.g_varchar2
332: ,p_information5 in varchar2 default hr_api.g_varchar2
333: ,p_information6 in varchar2 default hr_api.g_varchar2
334: ,p_information7 in varchar2 default hr_api.g_varchar2
335: ,p_information8 in varchar2 default hr_api.g_varchar2
336: ,p_information9 in varchar2 default hr_api.g_varchar2

Line 333: ,p_information6 in varchar2 default hr_api.g_varchar2

329: ,p_information2 in varchar2 default hr_api.g_varchar2
330: ,p_information3 in varchar2 default hr_api.g_varchar2
331: ,p_information4 in varchar2 default hr_api.g_varchar2
332: ,p_information5 in varchar2 default hr_api.g_varchar2
333: ,p_information6 in varchar2 default hr_api.g_varchar2
334: ,p_information7 in varchar2 default hr_api.g_varchar2
335: ,p_information8 in varchar2 default hr_api.g_varchar2
336: ,p_information9 in varchar2 default hr_api.g_varchar2
337: ,p_information10 in varchar2 default hr_api.g_varchar2

Line 334: ,p_information7 in varchar2 default hr_api.g_varchar2

330: ,p_information3 in varchar2 default hr_api.g_varchar2
331: ,p_information4 in varchar2 default hr_api.g_varchar2
332: ,p_information5 in varchar2 default hr_api.g_varchar2
333: ,p_information6 in varchar2 default hr_api.g_varchar2
334: ,p_information7 in varchar2 default hr_api.g_varchar2
335: ,p_information8 in varchar2 default hr_api.g_varchar2
336: ,p_information9 in varchar2 default hr_api.g_varchar2
337: ,p_information10 in varchar2 default hr_api.g_varchar2
338: ,p_information11 in varchar2 default hr_api.g_varchar2

Line 335: ,p_information8 in varchar2 default hr_api.g_varchar2

331: ,p_information4 in varchar2 default hr_api.g_varchar2
332: ,p_information5 in varchar2 default hr_api.g_varchar2
333: ,p_information6 in varchar2 default hr_api.g_varchar2
334: ,p_information7 in varchar2 default hr_api.g_varchar2
335: ,p_information8 in varchar2 default hr_api.g_varchar2
336: ,p_information9 in varchar2 default hr_api.g_varchar2
337: ,p_information10 in varchar2 default hr_api.g_varchar2
338: ,p_information11 in varchar2 default hr_api.g_varchar2
339: ,p_information12 in varchar2 default hr_api.g_varchar2

Line 336: ,p_information9 in varchar2 default hr_api.g_varchar2

332: ,p_information5 in varchar2 default hr_api.g_varchar2
333: ,p_information6 in varchar2 default hr_api.g_varchar2
334: ,p_information7 in varchar2 default hr_api.g_varchar2
335: ,p_information8 in varchar2 default hr_api.g_varchar2
336: ,p_information9 in varchar2 default hr_api.g_varchar2
337: ,p_information10 in varchar2 default hr_api.g_varchar2
338: ,p_information11 in varchar2 default hr_api.g_varchar2
339: ,p_information12 in varchar2 default hr_api.g_varchar2
340: ,p_information13 in varchar2 default hr_api.g_varchar2

Line 337: ,p_information10 in varchar2 default hr_api.g_varchar2

333: ,p_information6 in varchar2 default hr_api.g_varchar2
334: ,p_information7 in varchar2 default hr_api.g_varchar2
335: ,p_information8 in varchar2 default hr_api.g_varchar2
336: ,p_information9 in varchar2 default hr_api.g_varchar2
337: ,p_information10 in varchar2 default hr_api.g_varchar2
338: ,p_information11 in varchar2 default hr_api.g_varchar2
339: ,p_information12 in varchar2 default hr_api.g_varchar2
340: ,p_information13 in varchar2 default hr_api.g_varchar2
341: ,p_information14 in varchar2 default hr_api.g_varchar2

Line 338: ,p_information11 in varchar2 default hr_api.g_varchar2

334: ,p_information7 in varchar2 default hr_api.g_varchar2
335: ,p_information8 in varchar2 default hr_api.g_varchar2
336: ,p_information9 in varchar2 default hr_api.g_varchar2
337: ,p_information10 in varchar2 default hr_api.g_varchar2
338: ,p_information11 in varchar2 default hr_api.g_varchar2
339: ,p_information12 in varchar2 default hr_api.g_varchar2
340: ,p_information13 in varchar2 default hr_api.g_varchar2
341: ,p_information14 in varchar2 default hr_api.g_varchar2
342: ,p_information15 in varchar2 default hr_api.g_varchar2

Line 339: ,p_information12 in varchar2 default hr_api.g_varchar2

335: ,p_information8 in varchar2 default hr_api.g_varchar2
336: ,p_information9 in varchar2 default hr_api.g_varchar2
337: ,p_information10 in varchar2 default hr_api.g_varchar2
338: ,p_information11 in varchar2 default hr_api.g_varchar2
339: ,p_information12 in varchar2 default hr_api.g_varchar2
340: ,p_information13 in varchar2 default hr_api.g_varchar2
341: ,p_information14 in varchar2 default hr_api.g_varchar2
342: ,p_information15 in varchar2 default hr_api.g_varchar2
343: ,p_information16 in varchar2 default hr_api.g_varchar2

Line 340: ,p_information13 in varchar2 default hr_api.g_varchar2

336: ,p_information9 in varchar2 default hr_api.g_varchar2
337: ,p_information10 in varchar2 default hr_api.g_varchar2
338: ,p_information11 in varchar2 default hr_api.g_varchar2
339: ,p_information12 in varchar2 default hr_api.g_varchar2
340: ,p_information13 in varchar2 default hr_api.g_varchar2
341: ,p_information14 in varchar2 default hr_api.g_varchar2
342: ,p_information15 in varchar2 default hr_api.g_varchar2
343: ,p_information16 in varchar2 default hr_api.g_varchar2
344: ,p_information17 in varchar2 default hr_api.g_varchar2

Line 341: ,p_information14 in varchar2 default hr_api.g_varchar2

337: ,p_information10 in varchar2 default hr_api.g_varchar2
338: ,p_information11 in varchar2 default hr_api.g_varchar2
339: ,p_information12 in varchar2 default hr_api.g_varchar2
340: ,p_information13 in varchar2 default hr_api.g_varchar2
341: ,p_information14 in varchar2 default hr_api.g_varchar2
342: ,p_information15 in varchar2 default hr_api.g_varchar2
343: ,p_information16 in varchar2 default hr_api.g_varchar2
344: ,p_information17 in varchar2 default hr_api.g_varchar2
345: ,p_information18 in varchar2 default hr_api.g_varchar2

Line 342: ,p_information15 in varchar2 default hr_api.g_varchar2

338: ,p_information11 in varchar2 default hr_api.g_varchar2
339: ,p_information12 in varchar2 default hr_api.g_varchar2
340: ,p_information13 in varchar2 default hr_api.g_varchar2
341: ,p_information14 in varchar2 default hr_api.g_varchar2
342: ,p_information15 in varchar2 default hr_api.g_varchar2
343: ,p_information16 in varchar2 default hr_api.g_varchar2
344: ,p_information17 in varchar2 default hr_api.g_varchar2
345: ,p_information18 in varchar2 default hr_api.g_varchar2
346: ,p_information19 in varchar2 default hr_api.g_varchar2

Line 343: ,p_information16 in varchar2 default hr_api.g_varchar2

339: ,p_information12 in varchar2 default hr_api.g_varchar2
340: ,p_information13 in varchar2 default hr_api.g_varchar2
341: ,p_information14 in varchar2 default hr_api.g_varchar2
342: ,p_information15 in varchar2 default hr_api.g_varchar2
343: ,p_information16 in varchar2 default hr_api.g_varchar2
344: ,p_information17 in varchar2 default hr_api.g_varchar2
345: ,p_information18 in varchar2 default hr_api.g_varchar2
346: ,p_information19 in varchar2 default hr_api.g_varchar2
347: ,p_information20 in varchar2 default hr_api.g_varchar2

Line 344: ,p_information17 in varchar2 default hr_api.g_varchar2

340: ,p_information13 in varchar2 default hr_api.g_varchar2
341: ,p_information14 in varchar2 default hr_api.g_varchar2
342: ,p_information15 in varchar2 default hr_api.g_varchar2
343: ,p_information16 in varchar2 default hr_api.g_varchar2
344: ,p_information17 in varchar2 default hr_api.g_varchar2
345: ,p_information18 in varchar2 default hr_api.g_varchar2
346: ,p_information19 in varchar2 default hr_api.g_varchar2
347: ,p_information20 in varchar2 default hr_api.g_varchar2
348: ,p_information21 in varchar2 default hr_api.g_varchar2

Line 345: ,p_information18 in varchar2 default hr_api.g_varchar2

341: ,p_information14 in varchar2 default hr_api.g_varchar2
342: ,p_information15 in varchar2 default hr_api.g_varchar2
343: ,p_information16 in varchar2 default hr_api.g_varchar2
344: ,p_information17 in varchar2 default hr_api.g_varchar2
345: ,p_information18 in varchar2 default hr_api.g_varchar2
346: ,p_information19 in varchar2 default hr_api.g_varchar2
347: ,p_information20 in varchar2 default hr_api.g_varchar2
348: ,p_information21 in varchar2 default hr_api.g_varchar2
349: ,p_information22 in varchar2 default hr_api.g_varchar2

Line 346: ,p_information19 in varchar2 default hr_api.g_varchar2

342: ,p_information15 in varchar2 default hr_api.g_varchar2
343: ,p_information16 in varchar2 default hr_api.g_varchar2
344: ,p_information17 in varchar2 default hr_api.g_varchar2
345: ,p_information18 in varchar2 default hr_api.g_varchar2
346: ,p_information19 in varchar2 default hr_api.g_varchar2
347: ,p_information20 in varchar2 default hr_api.g_varchar2
348: ,p_information21 in varchar2 default hr_api.g_varchar2
349: ,p_information22 in varchar2 default hr_api.g_varchar2
350: ,p_information23 in varchar2 default hr_api.g_varchar2

Line 347: ,p_information20 in varchar2 default hr_api.g_varchar2

343: ,p_information16 in varchar2 default hr_api.g_varchar2
344: ,p_information17 in varchar2 default hr_api.g_varchar2
345: ,p_information18 in varchar2 default hr_api.g_varchar2
346: ,p_information19 in varchar2 default hr_api.g_varchar2
347: ,p_information20 in varchar2 default hr_api.g_varchar2
348: ,p_information21 in varchar2 default hr_api.g_varchar2
349: ,p_information22 in varchar2 default hr_api.g_varchar2
350: ,p_information23 in varchar2 default hr_api.g_varchar2
351: ,p_information24 in varchar2 default hr_api.g_varchar2

Line 348: ,p_information21 in varchar2 default hr_api.g_varchar2

344: ,p_information17 in varchar2 default hr_api.g_varchar2
345: ,p_information18 in varchar2 default hr_api.g_varchar2
346: ,p_information19 in varchar2 default hr_api.g_varchar2
347: ,p_information20 in varchar2 default hr_api.g_varchar2
348: ,p_information21 in varchar2 default hr_api.g_varchar2
349: ,p_information22 in varchar2 default hr_api.g_varchar2
350: ,p_information23 in varchar2 default hr_api.g_varchar2
351: ,p_information24 in varchar2 default hr_api.g_varchar2
352: ,p_information25 in varchar2 default hr_api.g_varchar2

Line 349: ,p_information22 in varchar2 default hr_api.g_varchar2

345: ,p_information18 in varchar2 default hr_api.g_varchar2
346: ,p_information19 in varchar2 default hr_api.g_varchar2
347: ,p_information20 in varchar2 default hr_api.g_varchar2
348: ,p_information21 in varchar2 default hr_api.g_varchar2
349: ,p_information22 in varchar2 default hr_api.g_varchar2
350: ,p_information23 in varchar2 default hr_api.g_varchar2
351: ,p_information24 in varchar2 default hr_api.g_varchar2
352: ,p_information25 in varchar2 default hr_api.g_varchar2
353: ,p_information26 in varchar2 default hr_api.g_varchar2

Line 350: ,p_information23 in varchar2 default hr_api.g_varchar2

346: ,p_information19 in varchar2 default hr_api.g_varchar2
347: ,p_information20 in varchar2 default hr_api.g_varchar2
348: ,p_information21 in varchar2 default hr_api.g_varchar2
349: ,p_information22 in varchar2 default hr_api.g_varchar2
350: ,p_information23 in varchar2 default hr_api.g_varchar2
351: ,p_information24 in varchar2 default hr_api.g_varchar2
352: ,p_information25 in varchar2 default hr_api.g_varchar2
353: ,p_information26 in varchar2 default hr_api.g_varchar2
354: ,p_information27 in varchar2 default hr_api.g_varchar2

Line 351: ,p_information24 in varchar2 default hr_api.g_varchar2

347: ,p_information20 in varchar2 default hr_api.g_varchar2
348: ,p_information21 in varchar2 default hr_api.g_varchar2
349: ,p_information22 in varchar2 default hr_api.g_varchar2
350: ,p_information23 in varchar2 default hr_api.g_varchar2
351: ,p_information24 in varchar2 default hr_api.g_varchar2
352: ,p_information25 in varchar2 default hr_api.g_varchar2
353: ,p_information26 in varchar2 default hr_api.g_varchar2
354: ,p_information27 in varchar2 default hr_api.g_varchar2
355: ,p_information28 in varchar2 default hr_api.g_varchar2

Line 352: ,p_information25 in varchar2 default hr_api.g_varchar2

348: ,p_information21 in varchar2 default hr_api.g_varchar2
349: ,p_information22 in varchar2 default hr_api.g_varchar2
350: ,p_information23 in varchar2 default hr_api.g_varchar2
351: ,p_information24 in varchar2 default hr_api.g_varchar2
352: ,p_information25 in varchar2 default hr_api.g_varchar2
353: ,p_information26 in varchar2 default hr_api.g_varchar2
354: ,p_information27 in varchar2 default hr_api.g_varchar2
355: ,p_information28 in varchar2 default hr_api.g_varchar2
356: ,p_information29 in varchar2 default hr_api.g_varchar2

Line 353: ,p_information26 in varchar2 default hr_api.g_varchar2

349: ,p_information22 in varchar2 default hr_api.g_varchar2
350: ,p_information23 in varchar2 default hr_api.g_varchar2
351: ,p_information24 in varchar2 default hr_api.g_varchar2
352: ,p_information25 in varchar2 default hr_api.g_varchar2
353: ,p_information26 in varchar2 default hr_api.g_varchar2
354: ,p_information27 in varchar2 default hr_api.g_varchar2
355: ,p_information28 in varchar2 default hr_api.g_varchar2
356: ,p_information29 in varchar2 default hr_api.g_varchar2
357: ,p_information30 in varchar2 default hr_api.g_varchar2

Line 354: ,p_information27 in varchar2 default hr_api.g_varchar2

350: ,p_information23 in varchar2 default hr_api.g_varchar2
351: ,p_information24 in varchar2 default hr_api.g_varchar2
352: ,p_information25 in varchar2 default hr_api.g_varchar2
353: ,p_information26 in varchar2 default hr_api.g_varchar2
354: ,p_information27 in varchar2 default hr_api.g_varchar2
355: ,p_information28 in varchar2 default hr_api.g_varchar2
356: ,p_information29 in varchar2 default hr_api.g_varchar2
357: ,p_information30 in varchar2 default hr_api.g_varchar2
358: ,p_object_version_number in out nocopy number

Line 355: ,p_information28 in varchar2 default hr_api.g_varchar2

351: ,p_information24 in varchar2 default hr_api.g_varchar2
352: ,p_information25 in varchar2 default hr_api.g_varchar2
353: ,p_information26 in varchar2 default hr_api.g_varchar2
354: ,p_information27 in varchar2 default hr_api.g_varchar2
355: ,p_information28 in varchar2 default hr_api.g_varchar2
356: ,p_information29 in varchar2 default hr_api.g_varchar2
357: ,p_information30 in varchar2 default hr_api.g_varchar2
358: ,p_object_version_number in out nocopy number
359: ) is

Line 356: ,p_information29 in varchar2 default hr_api.g_varchar2

352: ,p_information25 in varchar2 default hr_api.g_varchar2
353: ,p_information26 in varchar2 default hr_api.g_varchar2
354: ,p_information27 in varchar2 default hr_api.g_varchar2
355: ,p_information28 in varchar2 default hr_api.g_varchar2
356: ,p_information29 in varchar2 default hr_api.g_varchar2
357: ,p_information30 in varchar2 default hr_api.g_varchar2
358: ,p_object_version_number in out nocopy number
359: ) is
360: begin

Line 357: ,p_information30 in varchar2 default hr_api.g_varchar2

353: ,p_information26 in varchar2 default hr_api.g_varchar2
354: ,p_information27 in varchar2 default hr_api.g_varchar2
355: ,p_information28 in varchar2 default hr_api.g_varchar2
356: ,p_information29 in varchar2 default hr_api.g_varchar2
357: ,p_information30 in varchar2 default hr_api.g_varchar2
358: ,p_object_version_number in out nocopy number
359: ) is
360: begin
361: --

Line 420: ,p_effective_date in date default hr_api.g_date

416: --
417: procedure update_progression_point
418: (p_validate in boolean default false
419: ,p_spinal_point_id in number
420: ,p_effective_date in date default hr_api.g_date
421: ,p_business_group_id in number default hr_api.g_number
422: ,p_parent_spine_id in number default hr_api.g_number
423: ,p_sequence in number default hr_api.g_number
424: ,p_spinal_point in varchar2 default hr_api.g_varchar2

Line 421: ,p_business_group_id in number default hr_api.g_number

417: procedure update_progression_point
418: (p_validate in boolean default false
419: ,p_spinal_point_id in number
420: ,p_effective_date in date default hr_api.g_date
421: ,p_business_group_id in number default hr_api.g_number
422: ,p_parent_spine_id in number default hr_api.g_number
423: ,p_sequence in number default hr_api.g_number
424: ,p_spinal_point in varchar2 default hr_api.g_varchar2
425: ,p_request_id in number default hr_api.g_number

Line 422: ,p_parent_spine_id in number default hr_api.g_number

418: (p_validate in boolean default false
419: ,p_spinal_point_id in number
420: ,p_effective_date in date default hr_api.g_date
421: ,p_business_group_id in number default hr_api.g_number
422: ,p_parent_spine_id in number default hr_api.g_number
423: ,p_sequence in number default hr_api.g_number
424: ,p_spinal_point in varchar2 default hr_api.g_varchar2
425: ,p_request_id in number default hr_api.g_number
426: ,p_program_application_id in number default hr_api.g_number

Line 423: ,p_sequence in number default hr_api.g_number

419: ,p_spinal_point_id in number
420: ,p_effective_date in date default hr_api.g_date
421: ,p_business_group_id in number default hr_api.g_number
422: ,p_parent_spine_id in number default hr_api.g_number
423: ,p_sequence in number default hr_api.g_number
424: ,p_spinal_point in varchar2 default hr_api.g_varchar2
425: ,p_request_id in number default hr_api.g_number
426: ,p_program_application_id in number default hr_api.g_number
427: ,p_program_id in number default hr_api.g_number

Line 424: ,p_spinal_point in varchar2 default hr_api.g_varchar2

420: ,p_effective_date in date default hr_api.g_date
421: ,p_business_group_id in number default hr_api.g_number
422: ,p_parent_spine_id in number default hr_api.g_number
423: ,p_sequence in number default hr_api.g_number
424: ,p_spinal_point in varchar2 default hr_api.g_varchar2
425: ,p_request_id in number default hr_api.g_number
426: ,p_program_application_id in number default hr_api.g_number
427: ,p_program_id in number default hr_api.g_number
428: ,p_program_update_date in date default hr_api.g_date

Line 425: ,p_request_id in number default hr_api.g_number

421: ,p_business_group_id in number default hr_api.g_number
422: ,p_parent_spine_id in number default hr_api.g_number
423: ,p_sequence in number default hr_api.g_number
424: ,p_spinal_point in varchar2 default hr_api.g_varchar2
425: ,p_request_id in number default hr_api.g_number
426: ,p_program_application_id in number default hr_api.g_number
427: ,p_program_id in number default hr_api.g_number
428: ,p_program_update_date in date default hr_api.g_date
429: ,p_information_category in varchar2 default hr_api.g_varchar2

Line 426: ,p_program_application_id in number default hr_api.g_number

422: ,p_parent_spine_id in number default hr_api.g_number
423: ,p_sequence in number default hr_api.g_number
424: ,p_spinal_point in varchar2 default hr_api.g_varchar2
425: ,p_request_id in number default hr_api.g_number
426: ,p_program_application_id in number default hr_api.g_number
427: ,p_program_id in number default hr_api.g_number
428: ,p_program_update_date in date default hr_api.g_date
429: ,p_information_category in varchar2 default hr_api.g_varchar2
430: ,p_information1 in varchar2 default hr_api.g_varchar2

Line 427: ,p_program_id in number default hr_api.g_number

423: ,p_sequence in number default hr_api.g_number
424: ,p_spinal_point in varchar2 default hr_api.g_varchar2
425: ,p_request_id in number default hr_api.g_number
426: ,p_program_application_id in number default hr_api.g_number
427: ,p_program_id in number default hr_api.g_number
428: ,p_program_update_date in date default hr_api.g_date
429: ,p_information_category in varchar2 default hr_api.g_varchar2
430: ,p_information1 in varchar2 default hr_api.g_varchar2
431: ,p_information2 in varchar2 default hr_api.g_varchar2

Line 428: ,p_program_update_date in date default hr_api.g_date

424: ,p_spinal_point in varchar2 default hr_api.g_varchar2
425: ,p_request_id in number default hr_api.g_number
426: ,p_program_application_id in number default hr_api.g_number
427: ,p_program_id in number default hr_api.g_number
428: ,p_program_update_date in date default hr_api.g_date
429: ,p_information_category in varchar2 default hr_api.g_varchar2
430: ,p_information1 in varchar2 default hr_api.g_varchar2
431: ,p_information2 in varchar2 default hr_api.g_varchar2
432: ,p_information3 in varchar2 default hr_api.g_varchar2

Line 429: ,p_information_category in varchar2 default hr_api.g_varchar2

425: ,p_request_id in number default hr_api.g_number
426: ,p_program_application_id in number default hr_api.g_number
427: ,p_program_id in number default hr_api.g_number
428: ,p_program_update_date in date default hr_api.g_date
429: ,p_information_category in varchar2 default hr_api.g_varchar2
430: ,p_information1 in varchar2 default hr_api.g_varchar2
431: ,p_information2 in varchar2 default hr_api.g_varchar2
432: ,p_information3 in varchar2 default hr_api.g_varchar2
433: ,p_information4 in varchar2 default hr_api.g_varchar2

Line 430: ,p_information1 in varchar2 default hr_api.g_varchar2

426: ,p_program_application_id in number default hr_api.g_number
427: ,p_program_id in number default hr_api.g_number
428: ,p_program_update_date in date default hr_api.g_date
429: ,p_information_category in varchar2 default hr_api.g_varchar2
430: ,p_information1 in varchar2 default hr_api.g_varchar2
431: ,p_information2 in varchar2 default hr_api.g_varchar2
432: ,p_information3 in varchar2 default hr_api.g_varchar2
433: ,p_information4 in varchar2 default hr_api.g_varchar2
434: ,p_information5 in varchar2 default hr_api.g_varchar2

Line 431: ,p_information2 in varchar2 default hr_api.g_varchar2

427: ,p_program_id in number default hr_api.g_number
428: ,p_program_update_date in date default hr_api.g_date
429: ,p_information_category in varchar2 default hr_api.g_varchar2
430: ,p_information1 in varchar2 default hr_api.g_varchar2
431: ,p_information2 in varchar2 default hr_api.g_varchar2
432: ,p_information3 in varchar2 default hr_api.g_varchar2
433: ,p_information4 in varchar2 default hr_api.g_varchar2
434: ,p_information5 in varchar2 default hr_api.g_varchar2
435: ,p_information6 in varchar2 default hr_api.g_varchar2

Line 432: ,p_information3 in varchar2 default hr_api.g_varchar2

428: ,p_program_update_date in date default hr_api.g_date
429: ,p_information_category in varchar2 default hr_api.g_varchar2
430: ,p_information1 in varchar2 default hr_api.g_varchar2
431: ,p_information2 in varchar2 default hr_api.g_varchar2
432: ,p_information3 in varchar2 default hr_api.g_varchar2
433: ,p_information4 in varchar2 default hr_api.g_varchar2
434: ,p_information5 in varchar2 default hr_api.g_varchar2
435: ,p_information6 in varchar2 default hr_api.g_varchar2
436: ,p_information7 in varchar2 default hr_api.g_varchar2

Line 433: ,p_information4 in varchar2 default hr_api.g_varchar2

429: ,p_information_category in varchar2 default hr_api.g_varchar2
430: ,p_information1 in varchar2 default hr_api.g_varchar2
431: ,p_information2 in varchar2 default hr_api.g_varchar2
432: ,p_information3 in varchar2 default hr_api.g_varchar2
433: ,p_information4 in varchar2 default hr_api.g_varchar2
434: ,p_information5 in varchar2 default hr_api.g_varchar2
435: ,p_information6 in varchar2 default hr_api.g_varchar2
436: ,p_information7 in varchar2 default hr_api.g_varchar2
437: ,p_information8 in varchar2 default hr_api.g_varchar2

Line 434: ,p_information5 in varchar2 default hr_api.g_varchar2

430: ,p_information1 in varchar2 default hr_api.g_varchar2
431: ,p_information2 in varchar2 default hr_api.g_varchar2
432: ,p_information3 in varchar2 default hr_api.g_varchar2
433: ,p_information4 in varchar2 default hr_api.g_varchar2
434: ,p_information5 in varchar2 default hr_api.g_varchar2
435: ,p_information6 in varchar2 default hr_api.g_varchar2
436: ,p_information7 in varchar2 default hr_api.g_varchar2
437: ,p_information8 in varchar2 default hr_api.g_varchar2
438: ,p_information9 in varchar2 default hr_api.g_varchar2

Line 435: ,p_information6 in varchar2 default hr_api.g_varchar2

431: ,p_information2 in varchar2 default hr_api.g_varchar2
432: ,p_information3 in varchar2 default hr_api.g_varchar2
433: ,p_information4 in varchar2 default hr_api.g_varchar2
434: ,p_information5 in varchar2 default hr_api.g_varchar2
435: ,p_information6 in varchar2 default hr_api.g_varchar2
436: ,p_information7 in varchar2 default hr_api.g_varchar2
437: ,p_information8 in varchar2 default hr_api.g_varchar2
438: ,p_information9 in varchar2 default hr_api.g_varchar2
439: ,p_information10 in varchar2 default hr_api.g_varchar2

Line 436: ,p_information7 in varchar2 default hr_api.g_varchar2

432: ,p_information3 in varchar2 default hr_api.g_varchar2
433: ,p_information4 in varchar2 default hr_api.g_varchar2
434: ,p_information5 in varchar2 default hr_api.g_varchar2
435: ,p_information6 in varchar2 default hr_api.g_varchar2
436: ,p_information7 in varchar2 default hr_api.g_varchar2
437: ,p_information8 in varchar2 default hr_api.g_varchar2
438: ,p_information9 in varchar2 default hr_api.g_varchar2
439: ,p_information10 in varchar2 default hr_api.g_varchar2
440: ,p_information11 in varchar2 default hr_api.g_varchar2

Line 437: ,p_information8 in varchar2 default hr_api.g_varchar2

433: ,p_information4 in varchar2 default hr_api.g_varchar2
434: ,p_information5 in varchar2 default hr_api.g_varchar2
435: ,p_information6 in varchar2 default hr_api.g_varchar2
436: ,p_information7 in varchar2 default hr_api.g_varchar2
437: ,p_information8 in varchar2 default hr_api.g_varchar2
438: ,p_information9 in varchar2 default hr_api.g_varchar2
439: ,p_information10 in varchar2 default hr_api.g_varchar2
440: ,p_information11 in varchar2 default hr_api.g_varchar2
441: ,p_information12 in varchar2 default hr_api.g_varchar2

Line 438: ,p_information9 in varchar2 default hr_api.g_varchar2

434: ,p_information5 in varchar2 default hr_api.g_varchar2
435: ,p_information6 in varchar2 default hr_api.g_varchar2
436: ,p_information7 in varchar2 default hr_api.g_varchar2
437: ,p_information8 in varchar2 default hr_api.g_varchar2
438: ,p_information9 in varchar2 default hr_api.g_varchar2
439: ,p_information10 in varchar2 default hr_api.g_varchar2
440: ,p_information11 in varchar2 default hr_api.g_varchar2
441: ,p_information12 in varchar2 default hr_api.g_varchar2
442: ,p_information13 in varchar2 default hr_api.g_varchar2

Line 439: ,p_information10 in varchar2 default hr_api.g_varchar2

435: ,p_information6 in varchar2 default hr_api.g_varchar2
436: ,p_information7 in varchar2 default hr_api.g_varchar2
437: ,p_information8 in varchar2 default hr_api.g_varchar2
438: ,p_information9 in varchar2 default hr_api.g_varchar2
439: ,p_information10 in varchar2 default hr_api.g_varchar2
440: ,p_information11 in varchar2 default hr_api.g_varchar2
441: ,p_information12 in varchar2 default hr_api.g_varchar2
442: ,p_information13 in varchar2 default hr_api.g_varchar2
443: ,p_information14 in varchar2 default hr_api.g_varchar2

Line 440: ,p_information11 in varchar2 default hr_api.g_varchar2

436: ,p_information7 in varchar2 default hr_api.g_varchar2
437: ,p_information8 in varchar2 default hr_api.g_varchar2
438: ,p_information9 in varchar2 default hr_api.g_varchar2
439: ,p_information10 in varchar2 default hr_api.g_varchar2
440: ,p_information11 in varchar2 default hr_api.g_varchar2
441: ,p_information12 in varchar2 default hr_api.g_varchar2
442: ,p_information13 in varchar2 default hr_api.g_varchar2
443: ,p_information14 in varchar2 default hr_api.g_varchar2
444: ,p_information15 in varchar2 default hr_api.g_varchar2

Line 441: ,p_information12 in varchar2 default hr_api.g_varchar2

437: ,p_information8 in varchar2 default hr_api.g_varchar2
438: ,p_information9 in varchar2 default hr_api.g_varchar2
439: ,p_information10 in varchar2 default hr_api.g_varchar2
440: ,p_information11 in varchar2 default hr_api.g_varchar2
441: ,p_information12 in varchar2 default hr_api.g_varchar2
442: ,p_information13 in varchar2 default hr_api.g_varchar2
443: ,p_information14 in varchar2 default hr_api.g_varchar2
444: ,p_information15 in varchar2 default hr_api.g_varchar2
445: ,p_information16 in varchar2 default hr_api.g_varchar2

Line 442: ,p_information13 in varchar2 default hr_api.g_varchar2

438: ,p_information9 in varchar2 default hr_api.g_varchar2
439: ,p_information10 in varchar2 default hr_api.g_varchar2
440: ,p_information11 in varchar2 default hr_api.g_varchar2
441: ,p_information12 in varchar2 default hr_api.g_varchar2
442: ,p_information13 in varchar2 default hr_api.g_varchar2
443: ,p_information14 in varchar2 default hr_api.g_varchar2
444: ,p_information15 in varchar2 default hr_api.g_varchar2
445: ,p_information16 in varchar2 default hr_api.g_varchar2
446: ,p_information17 in varchar2 default hr_api.g_varchar2

Line 443: ,p_information14 in varchar2 default hr_api.g_varchar2

439: ,p_information10 in varchar2 default hr_api.g_varchar2
440: ,p_information11 in varchar2 default hr_api.g_varchar2
441: ,p_information12 in varchar2 default hr_api.g_varchar2
442: ,p_information13 in varchar2 default hr_api.g_varchar2
443: ,p_information14 in varchar2 default hr_api.g_varchar2
444: ,p_information15 in varchar2 default hr_api.g_varchar2
445: ,p_information16 in varchar2 default hr_api.g_varchar2
446: ,p_information17 in varchar2 default hr_api.g_varchar2
447: ,p_information18 in varchar2 default hr_api.g_varchar2

Line 444: ,p_information15 in varchar2 default hr_api.g_varchar2

440: ,p_information11 in varchar2 default hr_api.g_varchar2
441: ,p_information12 in varchar2 default hr_api.g_varchar2
442: ,p_information13 in varchar2 default hr_api.g_varchar2
443: ,p_information14 in varchar2 default hr_api.g_varchar2
444: ,p_information15 in varchar2 default hr_api.g_varchar2
445: ,p_information16 in varchar2 default hr_api.g_varchar2
446: ,p_information17 in varchar2 default hr_api.g_varchar2
447: ,p_information18 in varchar2 default hr_api.g_varchar2
448: ,p_information19 in varchar2 default hr_api.g_varchar2

Line 445: ,p_information16 in varchar2 default hr_api.g_varchar2

441: ,p_information12 in varchar2 default hr_api.g_varchar2
442: ,p_information13 in varchar2 default hr_api.g_varchar2
443: ,p_information14 in varchar2 default hr_api.g_varchar2
444: ,p_information15 in varchar2 default hr_api.g_varchar2
445: ,p_information16 in varchar2 default hr_api.g_varchar2
446: ,p_information17 in varchar2 default hr_api.g_varchar2
447: ,p_information18 in varchar2 default hr_api.g_varchar2
448: ,p_information19 in varchar2 default hr_api.g_varchar2
449: ,p_information20 in varchar2 default hr_api.g_varchar2

Line 446: ,p_information17 in varchar2 default hr_api.g_varchar2

442: ,p_information13 in varchar2 default hr_api.g_varchar2
443: ,p_information14 in varchar2 default hr_api.g_varchar2
444: ,p_information15 in varchar2 default hr_api.g_varchar2
445: ,p_information16 in varchar2 default hr_api.g_varchar2
446: ,p_information17 in varchar2 default hr_api.g_varchar2
447: ,p_information18 in varchar2 default hr_api.g_varchar2
448: ,p_information19 in varchar2 default hr_api.g_varchar2
449: ,p_information20 in varchar2 default hr_api.g_varchar2
450: ,p_information21 in varchar2 default hr_api.g_varchar2

Line 447: ,p_information18 in varchar2 default hr_api.g_varchar2

443: ,p_information14 in varchar2 default hr_api.g_varchar2
444: ,p_information15 in varchar2 default hr_api.g_varchar2
445: ,p_information16 in varchar2 default hr_api.g_varchar2
446: ,p_information17 in varchar2 default hr_api.g_varchar2
447: ,p_information18 in varchar2 default hr_api.g_varchar2
448: ,p_information19 in varchar2 default hr_api.g_varchar2
449: ,p_information20 in varchar2 default hr_api.g_varchar2
450: ,p_information21 in varchar2 default hr_api.g_varchar2
451: ,p_information22 in varchar2 default hr_api.g_varchar2

Line 448: ,p_information19 in varchar2 default hr_api.g_varchar2

444: ,p_information15 in varchar2 default hr_api.g_varchar2
445: ,p_information16 in varchar2 default hr_api.g_varchar2
446: ,p_information17 in varchar2 default hr_api.g_varchar2
447: ,p_information18 in varchar2 default hr_api.g_varchar2
448: ,p_information19 in varchar2 default hr_api.g_varchar2
449: ,p_information20 in varchar2 default hr_api.g_varchar2
450: ,p_information21 in varchar2 default hr_api.g_varchar2
451: ,p_information22 in varchar2 default hr_api.g_varchar2
452: ,p_information23 in varchar2 default hr_api.g_varchar2

Line 449: ,p_information20 in varchar2 default hr_api.g_varchar2

445: ,p_information16 in varchar2 default hr_api.g_varchar2
446: ,p_information17 in varchar2 default hr_api.g_varchar2
447: ,p_information18 in varchar2 default hr_api.g_varchar2
448: ,p_information19 in varchar2 default hr_api.g_varchar2
449: ,p_information20 in varchar2 default hr_api.g_varchar2
450: ,p_information21 in varchar2 default hr_api.g_varchar2
451: ,p_information22 in varchar2 default hr_api.g_varchar2
452: ,p_information23 in varchar2 default hr_api.g_varchar2
453: ,p_information24 in varchar2 default hr_api.g_varchar2

Line 450: ,p_information21 in varchar2 default hr_api.g_varchar2

446: ,p_information17 in varchar2 default hr_api.g_varchar2
447: ,p_information18 in varchar2 default hr_api.g_varchar2
448: ,p_information19 in varchar2 default hr_api.g_varchar2
449: ,p_information20 in varchar2 default hr_api.g_varchar2
450: ,p_information21 in varchar2 default hr_api.g_varchar2
451: ,p_information22 in varchar2 default hr_api.g_varchar2
452: ,p_information23 in varchar2 default hr_api.g_varchar2
453: ,p_information24 in varchar2 default hr_api.g_varchar2
454: ,p_information25 in varchar2 default hr_api.g_varchar2

Line 451: ,p_information22 in varchar2 default hr_api.g_varchar2

447: ,p_information18 in varchar2 default hr_api.g_varchar2
448: ,p_information19 in varchar2 default hr_api.g_varchar2
449: ,p_information20 in varchar2 default hr_api.g_varchar2
450: ,p_information21 in varchar2 default hr_api.g_varchar2
451: ,p_information22 in varchar2 default hr_api.g_varchar2
452: ,p_information23 in varchar2 default hr_api.g_varchar2
453: ,p_information24 in varchar2 default hr_api.g_varchar2
454: ,p_information25 in varchar2 default hr_api.g_varchar2
455: ,p_information26 in varchar2 default hr_api.g_varchar2

Line 452: ,p_information23 in varchar2 default hr_api.g_varchar2

448: ,p_information19 in varchar2 default hr_api.g_varchar2
449: ,p_information20 in varchar2 default hr_api.g_varchar2
450: ,p_information21 in varchar2 default hr_api.g_varchar2
451: ,p_information22 in varchar2 default hr_api.g_varchar2
452: ,p_information23 in varchar2 default hr_api.g_varchar2
453: ,p_information24 in varchar2 default hr_api.g_varchar2
454: ,p_information25 in varchar2 default hr_api.g_varchar2
455: ,p_information26 in varchar2 default hr_api.g_varchar2
456: ,p_information27 in varchar2 default hr_api.g_varchar2

Line 453: ,p_information24 in varchar2 default hr_api.g_varchar2

449: ,p_information20 in varchar2 default hr_api.g_varchar2
450: ,p_information21 in varchar2 default hr_api.g_varchar2
451: ,p_information22 in varchar2 default hr_api.g_varchar2
452: ,p_information23 in varchar2 default hr_api.g_varchar2
453: ,p_information24 in varchar2 default hr_api.g_varchar2
454: ,p_information25 in varchar2 default hr_api.g_varchar2
455: ,p_information26 in varchar2 default hr_api.g_varchar2
456: ,p_information27 in varchar2 default hr_api.g_varchar2
457: ,p_information28 in varchar2 default hr_api.g_varchar2

Line 454: ,p_information25 in varchar2 default hr_api.g_varchar2

450: ,p_information21 in varchar2 default hr_api.g_varchar2
451: ,p_information22 in varchar2 default hr_api.g_varchar2
452: ,p_information23 in varchar2 default hr_api.g_varchar2
453: ,p_information24 in varchar2 default hr_api.g_varchar2
454: ,p_information25 in varchar2 default hr_api.g_varchar2
455: ,p_information26 in varchar2 default hr_api.g_varchar2
456: ,p_information27 in varchar2 default hr_api.g_varchar2
457: ,p_information28 in varchar2 default hr_api.g_varchar2
458: ,p_information29 in varchar2 default hr_api.g_varchar2

Line 455: ,p_information26 in varchar2 default hr_api.g_varchar2

451: ,p_information22 in varchar2 default hr_api.g_varchar2
452: ,p_information23 in varchar2 default hr_api.g_varchar2
453: ,p_information24 in varchar2 default hr_api.g_varchar2
454: ,p_information25 in varchar2 default hr_api.g_varchar2
455: ,p_information26 in varchar2 default hr_api.g_varchar2
456: ,p_information27 in varchar2 default hr_api.g_varchar2
457: ,p_information28 in varchar2 default hr_api.g_varchar2
458: ,p_information29 in varchar2 default hr_api.g_varchar2
459: ,p_information30 in varchar2 default hr_api.g_varchar2

Line 456: ,p_information27 in varchar2 default hr_api.g_varchar2

452: ,p_information23 in varchar2 default hr_api.g_varchar2
453: ,p_information24 in varchar2 default hr_api.g_varchar2
454: ,p_information25 in varchar2 default hr_api.g_varchar2
455: ,p_information26 in varchar2 default hr_api.g_varchar2
456: ,p_information27 in varchar2 default hr_api.g_varchar2
457: ,p_information28 in varchar2 default hr_api.g_varchar2
458: ,p_information29 in varchar2 default hr_api.g_varchar2
459: ,p_information30 in varchar2 default hr_api.g_varchar2
460: ,p_object_version_number in out nocopy number

Line 457: ,p_information28 in varchar2 default hr_api.g_varchar2

453: ,p_information24 in varchar2 default hr_api.g_varchar2
454: ,p_information25 in varchar2 default hr_api.g_varchar2
455: ,p_information26 in varchar2 default hr_api.g_varchar2
456: ,p_information27 in varchar2 default hr_api.g_varchar2
457: ,p_information28 in varchar2 default hr_api.g_varchar2
458: ,p_information29 in varchar2 default hr_api.g_varchar2
459: ,p_information30 in varchar2 default hr_api.g_varchar2
460: ,p_object_version_number in out nocopy number
461: ,p_called_from in varchar2 --added for bug 9328526

Line 458: ,p_information29 in varchar2 default hr_api.g_varchar2

454: ,p_information25 in varchar2 default hr_api.g_varchar2
455: ,p_information26 in varchar2 default hr_api.g_varchar2
456: ,p_information27 in varchar2 default hr_api.g_varchar2
457: ,p_information28 in varchar2 default hr_api.g_varchar2
458: ,p_information29 in varchar2 default hr_api.g_varchar2
459: ,p_information30 in varchar2 default hr_api.g_varchar2
460: ,p_object_version_number in out nocopy number
461: ,p_called_from in varchar2 --added for bug 9328526
462: ) is

Line 459: ,p_information30 in varchar2 default hr_api.g_varchar2

455: ,p_information26 in varchar2 default hr_api.g_varchar2
456: ,p_information27 in varchar2 default hr_api.g_varchar2
457: ,p_information28 in varchar2 default hr_api.g_varchar2
458: ,p_information29 in varchar2 default hr_api.g_varchar2
459: ,p_information30 in varchar2 default hr_api.g_varchar2
460: ,p_object_version_number in out nocopy number
461: ,p_called_from in varchar2 --added for bug 9328526
462: ) is
463:

Line 544: when hr_api.cannot_find_prog_unit then

540: ,p_information29 => p_information29
541: ,p_information30 => p_information30
542: );
543: exception
544: when hr_api.cannot_find_prog_unit then
545: hr_api.cannot_find_prog_unit_error
546: (p_module_name => 'UPDATE_PROGRESSION_POINT'
547: ,p_hook_type => 'BP'
548: );

Line 545: hr_api.cannot_find_prog_unit_error

541: ,p_information30 => p_information30
542: );
543: exception
544: when hr_api.cannot_find_prog_unit then
545: hr_api.cannot_find_prog_unit_error
546: (p_module_name => 'UPDATE_PROGRESSION_POINT'
547: ,p_hook_type => 'BP'
548: );
549: --

Line 677: when hr_api.cannot_find_prog_unit then

673: ,p_information29 => p_information29
674: ,p_information30 => p_information30
675: );
676: exception
677: when hr_api.cannot_find_prog_unit then
678: hr_api.cannot_find_prog_unit_error
679: (p_module_name => 'UPDATE_PROGRESSION_POINT'
680: ,p_hook_type => 'AP'
681: );

Line 678: hr_api.cannot_find_prog_unit_error

674: ,p_information30 => p_information30
675: );
676: exception
677: when hr_api.cannot_find_prog_unit then
678: hr_api.cannot_find_prog_unit_error
679: (p_module_name => 'UPDATE_PROGRESSION_POINT'
680: ,p_hook_type => 'AP'
681: );
682: --

Line 691: raise hr_api.validate_enabled;

687: -- When in validation only mode raise the Validate_Enabled exception
688: --
689: if p_validate
690: then
691: raise hr_api.validate_enabled;
692: end if;
693: --
694: hr_utility.set_location(l_proc, 50);
695: --

Line 704: when hr_api.validate_enabled then

700: hr_utility.set_location(' Leaving:' ||l_proc, 60);
701: --
702: exception
703: --
704: when hr_api.validate_enabled then
705: --
706: -- As the Validate_Enabled exception has been raised
707: -- we must rollback to the savepoint
708: --

Line 806: when hr_api.cannot_find_prog_unit then

802: ,p_spinal_point_id => p_spinal_point_id
803: ,p_object_version_number => p_object_version_number
804: );
805: exception
806: when hr_api.cannot_find_prog_unit then
807: hr_api.cannot_find_prog_unit_error
808: (p_module_name => 'DELETE_PROGRESSSION_POINT'
809: ,p_hook_type => 'BP'
810: );

Line 807: hr_api.cannot_find_prog_unit_error

803: ,p_object_version_number => p_object_version_number
804: );
805: exception
806: when hr_api.cannot_find_prog_unit then
807: hr_api.cannot_find_prog_unit_error
808: (p_module_name => 'DELETE_PROGRESSSION_POINT'
809: ,p_hook_type => 'BP'
810: );
811: end;

Line 857: when hr_api.cannot_find_prog_unit then

853: (p_validate => p_validate
854: ,p_spinal_point_id => p_spinal_point_id
855: ,p_object_version_number => p_object_version_number);
856: exception
857: when hr_api.cannot_find_prog_unit then
858: hr_api.cannot_find_prog_unit_error
859: (p_module_name => 'DELETE_PROGRESSSION_POINT'
860: ,p_hook_type => 'AP'
861: );

Line 858: hr_api.cannot_find_prog_unit_error

854: ,p_spinal_point_id => p_spinal_point_id
855: ,p_object_version_number => p_object_version_number);
856: exception
857: when hr_api.cannot_find_prog_unit then
858: hr_api.cannot_find_prog_unit_error
859: (p_module_name => 'DELETE_PROGRESSSION_POINT'
860: ,p_hook_type => 'AP'
861: );
862: end;

Line 870: raise hr_api.validate_enabled;

866: --
867: -- When in validation only mode raise the Validate_Enabled exception
868: --
869: if p_validate then
870: raise hr_api.validate_enabled;
871: end if;
872:
873: hr_utility.set_location(' Leaving:'||l_proc, 100);
874: exception

Line 875: when hr_api.validate_enabled then

871: end if;
872:
873: hr_utility.set_location(' Leaving:'||l_proc, 100);
874: exception
875: when hr_api.validate_enabled then
876: hr_utility.set_location(' Leaving...:'||l_proc, 50);
877: --
878: -- As the Validate_Enabled exception has been raised
879: -- we must rollback to the savepoint