eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OTA_ADD_TRAINING_SS dependencies on HR_API

Line 326: ,p_contact_id in NUMBER DEFAULT hr_api.g_NUMBER

322: Procedure update_add_training
323: (p_effective_date in date
324: ,p_nota_history_id in NUMBER
325: ,p_person_id in NUMBER
326: ,p_contact_id in NUMBER DEFAULT hr_api.g_NUMBER
327: ,p_trng_title in VARCHAR2
328: ,p_provider in VARCHAR2
329: ,p_type in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
330: ,p_centre in VARCHAR2 DEFAULT hr_api.g_VARCHAR2

Line 329: ,p_type in VARCHAR2 DEFAULT hr_api.g_VARCHAR2

325: ,p_person_id in NUMBER
326: ,p_contact_id in NUMBER DEFAULT hr_api.g_NUMBER
327: ,p_trng_title in VARCHAR2
328: ,p_provider in VARCHAR2
329: ,p_type in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
330: ,p_centre in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
331: ,p_completion_date in date
332: ,p_award in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
333: ,p_rating in VARCHAR2 DEFAULT hr_api.g_VARCHAR2

Line 330: ,p_centre in VARCHAR2 DEFAULT hr_api.g_VARCHAR2

326: ,p_contact_id in NUMBER DEFAULT hr_api.g_NUMBER
327: ,p_trng_title in VARCHAR2
328: ,p_provider in VARCHAR2
329: ,p_type in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
330: ,p_centre in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
331: ,p_completion_date in date
332: ,p_award in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
333: ,p_rating in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
334: ,p_duration in NUMBER DEFAULT hr_api.g_NUMBER

Line 332: ,p_award in VARCHAR2 DEFAULT hr_api.g_VARCHAR2

328: ,p_provider in VARCHAR2
329: ,p_type in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
330: ,p_centre in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
331: ,p_completion_date in date
332: ,p_award in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
333: ,p_rating in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
334: ,p_duration in NUMBER DEFAULT hr_api.g_NUMBER
335: ,p_duration_units in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
336: ,p_activity_version_id in NUMBER DEFAULT hr_api.g_NUMBER

Line 333: ,p_rating in VARCHAR2 DEFAULT hr_api.g_VARCHAR2

329: ,p_type in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
330: ,p_centre in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
331: ,p_completion_date in date
332: ,p_award in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
333: ,p_rating in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
334: ,p_duration in NUMBER DEFAULT hr_api.g_NUMBER
335: ,p_duration_units in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
336: ,p_activity_version_id in NUMBER DEFAULT hr_api.g_NUMBER
337: ,p_status in VARCHAR2 DEFAULT hr_api.g_VARCHAR2

Line 334: ,p_duration in NUMBER DEFAULT hr_api.g_NUMBER

330: ,p_centre in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
331: ,p_completion_date in date
332: ,p_award in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
333: ,p_rating in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
334: ,p_duration in NUMBER DEFAULT hr_api.g_NUMBER
335: ,p_duration_units in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
336: ,p_activity_version_id in NUMBER DEFAULT hr_api.g_NUMBER
337: ,p_status in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
338: ,p_verified_by_id in NUMBER DEFAULT hr_api.g_NUMBER

Line 335: ,p_duration_units in VARCHAR2 DEFAULT hr_api.g_VARCHAR2

331: ,p_completion_date in date
332: ,p_award in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
333: ,p_rating in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
334: ,p_duration in NUMBER DEFAULT hr_api.g_NUMBER
335: ,p_duration_units in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
336: ,p_activity_version_id in NUMBER DEFAULT hr_api.g_NUMBER
337: ,p_status in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
338: ,p_verified_by_id in NUMBER DEFAULT hr_api.g_NUMBER
339: ,p_nth_information_category in VARCHAR2 DEFAULT hr_api.g_VARCHAR2

Line 336: ,p_activity_version_id in NUMBER DEFAULT hr_api.g_NUMBER

332: ,p_award in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
333: ,p_rating in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
334: ,p_duration in NUMBER DEFAULT hr_api.g_NUMBER
335: ,p_duration_units in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
336: ,p_activity_version_id in NUMBER DEFAULT hr_api.g_NUMBER
337: ,p_status in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
338: ,p_verified_by_id in NUMBER DEFAULT hr_api.g_NUMBER
339: ,p_nth_information_category in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
340: ,p_nth_information1 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2

Line 337: ,p_status in VARCHAR2 DEFAULT hr_api.g_VARCHAR2

333: ,p_rating in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
334: ,p_duration in NUMBER DEFAULT hr_api.g_NUMBER
335: ,p_duration_units in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
336: ,p_activity_version_id in NUMBER DEFAULT hr_api.g_NUMBER
337: ,p_status in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
338: ,p_verified_by_id in NUMBER DEFAULT hr_api.g_NUMBER
339: ,p_nth_information_category in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
340: ,p_nth_information1 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
341: ,p_nth_information2 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2

Line 338: ,p_verified_by_id in NUMBER DEFAULT hr_api.g_NUMBER

334: ,p_duration in NUMBER DEFAULT hr_api.g_NUMBER
335: ,p_duration_units in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
336: ,p_activity_version_id in NUMBER DEFAULT hr_api.g_NUMBER
337: ,p_status in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
338: ,p_verified_by_id in NUMBER DEFAULT hr_api.g_NUMBER
339: ,p_nth_information_category in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
340: ,p_nth_information1 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
341: ,p_nth_information2 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
342: ,p_nth_information3 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2

Line 339: ,p_nth_information_category in VARCHAR2 DEFAULT hr_api.g_VARCHAR2

335: ,p_duration_units in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
336: ,p_activity_version_id in NUMBER DEFAULT hr_api.g_NUMBER
337: ,p_status in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
338: ,p_verified_by_id in NUMBER DEFAULT hr_api.g_NUMBER
339: ,p_nth_information_category in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
340: ,p_nth_information1 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
341: ,p_nth_information2 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
342: ,p_nth_information3 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
343: ,p_nth_information4 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2

Line 340: ,p_nth_information1 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2

336: ,p_activity_version_id in NUMBER DEFAULT hr_api.g_NUMBER
337: ,p_status in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
338: ,p_verified_by_id in NUMBER DEFAULT hr_api.g_NUMBER
339: ,p_nth_information_category in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
340: ,p_nth_information1 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
341: ,p_nth_information2 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
342: ,p_nth_information3 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
343: ,p_nth_information4 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
344: ,p_nth_information5 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2

Line 341: ,p_nth_information2 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2

337: ,p_status in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
338: ,p_verified_by_id in NUMBER DEFAULT hr_api.g_NUMBER
339: ,p_nth_information_category in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
340: ,p_nth_information1 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
341: ,p_nth_information2 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
342: ,p_nth_information3 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
343: ,p_nth_information4 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
344: ,p_nth_information5 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
345: ,p_nth_information6 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2

Line 342: ,p_nth_information3 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2

338: ,p_verified_by_id in NUMBER DEFAULT hr_api.g_NUMBER
339: ,p_nth_information_category in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
340: ,p_nth_information1 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
341: ,p_nth_information2 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
342: ,p_nth_information3 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
343: ,p_nth_information4 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
344: ,p_nth_information5 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
345: ,p_nth_information6 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
346: ,p_nth_information7 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2

Line 343: ,p_nth_information4 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2

339: ,p_nth_information_category in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
340: ,p_nth_information1 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
341: ,p_nth_information2 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
342: ,p_nth_information3 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
343: ,p_nth_information4 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
344: ,p_nth_information5 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
345: ,p_nth_information6 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
346: ,p_nth_information7 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
347: ,p_nth_information8 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2

Line 344: ,p_nth_information5 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2

340: ,p_nth_information1 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
341: ,p_nth_information2 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
342: ,p_nth_information3 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
343: ,p_nth_information4 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
344: ,p_nth_information5 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
345: ,p_nth_information6 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
346: ,p_nth_information7 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
347: ,p_nth_information8 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
348: ,p_nth_information9 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2

Line 345: ,p_nth_information6 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2

341: ,p_nth_information2 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
342: ,p_nth_information3 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
343: ,p_nth_information4 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
344: ,p_nth_information5 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
345: ,p_nth_information6 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
346: ,p_nth_information7 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
347: ,p_nth_information8 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
348: ,p_nth_information9 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
349: ,p_nth_information10 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2

Line 346: ,p_nth_information7 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2

342: ,p_nth_information3 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
343: ,p_nth_information4 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
344: ,p_nth_information5 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
345: ,p_nth_information6 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
346: ,p_nth_information7 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
347: ,p_nth_information8 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
348: ,p_nth_information9 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
349: ,p_nth_information10 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
350: ,p_nth_information11 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2

Line 347: ,p_nth_information8 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2

343: ,p_nth_information4 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
344: ,p_nth_information5 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
345: ,p_nth_information6 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
346: ,p_nth_information7 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
347: ,p_nth_information8 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
348: ,p_nth_information9 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
349: ,p_nth_information10 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
350: ,p_nth_information11 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
351: ,p_nth_information12 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2

Line 348: ,p_nth_information9 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2

344: ,p_nth_information5 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
345: ,p_nth_information6 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
346: ,p_nth_information7 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
347: ,p_nth_information8 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
348: ,p_nth_information9 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
349: ,p_nth_information10 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
350: ,p_nth_information11 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
351: ,p_nth_information12 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
352: ,p_nth_information13 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2

Line 349: ,p_nth_information10 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2

345: ,p_nth_information6 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
346: ,p_nth_information7 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
347: ,p_nth_information8 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
348: ,p_nth_information9 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
349: ,p_nth_information10 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
350: ,p_nth_information11 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
351: ,p_nth_information12 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
352: ,p_nth_information13 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
353: ,p_nth_information14 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2

Line 350: ,p_nth_information11 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2

346: ,p_nth_information7 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
347: ,p_nth_information8 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
348: ,p_nth_information9 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
349: ,p_nth_information10 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
350: ,p_nth_information11 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
351: ,p_nth_information12 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
352: ,p_nth_information13 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
353: ,p_nth_information14 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
354: ,p_nth_information15 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2

Line 351: ,p_nth_information12 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2

347: ,p_nth_information8 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
348: ,p_nth_information9 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
349: ,p_nth_information10 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
350: ,p_nth_information11 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
351: ,p_nth_information12 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
352: ,p_nth_information13 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
353: ,p_nth_information14 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
354: ,p_nth_information15 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
355: ,p_nth_information16 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2

Line 352: ,p_nth_information13 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2

348: ,p_nth_information9 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
349: ,p_nth_information10 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
350: ,p_nth_information11 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
351: ,p_nth_information12 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
352: ,p_nth_information13 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
353: ,p_nth_information14 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
354: ,p_nth_information15 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
355: ,p_nth_information16 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
356: ,p_nth_information17 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2

Line 353: ,p_nth_information14 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2

349: ,p_nth_information10 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
350: ,p_nth_information11 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
351: ,p_nth_information12 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
352: ,p_nth_information13 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
353: ,p_nth_information14 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
354: ,p_nth_information15 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
355: ,p_nth_information16 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
356: ,p_nth_information17 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
357: ,p_nth_information18 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2

Line 354: ,p_nth_information15 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2

350: ,p_nth_information11 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
351: ,p_nth_information12 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
352: ,p_nth_information13 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
353: ,p_nth_information14 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
354: ,p_nth_information15 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
355: ,p_nth_information16 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
356: ,p_nth_information17 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
357: ,p_nth_information18 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
358: ,p_nth_information19 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2

Line 355: ,p_nth_information16 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2

351: ,p_nth_information12 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
352: ,p_nth_information13 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
353: ,p_nth_information14 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
354: ,p_nth_information15 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
355: ,p_nth_information16 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
356: ,p_nth_information17 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
357: ,p_nth_information18 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
358: ,p_nth_information19 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
359: ,p_nth_information20 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2

Line 356: ,p_nth_information17 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2

352: ,p_nth_information13 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
353: ,p_nth_information14 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
354: ,p_nth_information15 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
355: ,p_nth_information16 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
356: ,p_nth_information17 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
357: ,p_nth_information18 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
358: ,p_nth_information19 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
359: ,p_nth_information20 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
360: ,p_org_id in NUMBER DEFAULT hr_api.g_NUMBER

Line 357: ,p_nth_information18 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2

353: ,p_nth_information14 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
354: ,p_nth_information15 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
355: ,p_nth_information16 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
356: ,p_nth_information17 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
357: ,p_nth_information18 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
358: ,p_nth_information19 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
359: ,p_nth_information20 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
360: ,p_org_id in NUMBER DEFAULT hr_api.g_NUMBER
361: ,p_old_object_version_NUMBER in NUMBER

Line 358: ,p_nth_information19 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2

354: ,p_nth_information15 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
355: ,p_nth_information16 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
356: ,p_nth_information17 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
357: ,p_nth_information18 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
358: ,p_nth_information19 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
359: ,p_nth_information20 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
360: ,p_org_id in NUMBER DEFAULT hr_api.g_NUMBER
361: ,p_old_object_version_NUMBER in NUMBER
362: ,p_business_group_id in NUMBER

Line 359: ,p_nth_information20 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2

355: ,p_nth_information16 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
356: ,p_nth_information17 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
357: ,p_nth_information18 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
358: ,p_nth_information19 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
359: ,p_nth_information20 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
360: ,p_org_id in NUMBER DEFAULT hr_api.g_NUMBER
361: ,p_old_object_version_NUMBER in NUMBER
362: ,p_business_group_id in NUMBER
363: ,p_customer_id in NUMBER DEFAULT hr_api.g_NUMBER

Line 360: ,p_org_id in NUMBER DEFAULT hr_api.g_NUMBER

356: ,p_nth_information17 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
357: ,p_nth_information18 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
358: ,p_nth_information19 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
359: ,p_nth_information20 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
360: ,p_org_id in NUMBER DEFAULT hr_api.g_NUMBER
361: ,p_old_object_version_NUMBER in NUMBER
362: ,p_business_group_id in NUMBER
363: ,p_customer_id in NUMBER DEFAULT hr_api.g_NUMBER
364: ,p_organization_id in NUMBER DEFAULT hr_api.g_NUMBER

Line 363: ,p_customer_id in NUMBER DEFAULT hr_api.g_NUMBER

359: ,p_nth_information20 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
360: ,p_org_id in NUMBER DEFAULT hr_api.g_NUMBER
361: ,p_old_object_version_NUMBER in NUMBER
362: ,p_business_group_id in NUMBER
363: ,p_customer_id in NUMBER DEFAULT hr_api.g_NUMBER
364: ,p_organization_id in NUMBER DEFAULT hr_api.g_NUMBER
365: ,p_some_warning out nocopy NUMBER
366: ,p_message out nocopy VARCHAR2
367: ,p_new_object_version_NUMBER out nocopy NUMBER

Line 364: ,p_organization_id in NUMBER DEFAULT hr_api.g_NUMBER

360: ,p_org_id in NUMBER DEFAULT hr_api.g_NUMBER
361: ,p_old_object_version_NUMBER in NUMBER
362: ,p_business_group_id in NUMBER
363: ,p_customer_id in NUMBER DEFAULT hr_api.g_NUMBER
364: ,p_organization_id in NUMBER DEFAULT hr_api.g_NUMBER
365: ,p_some_warning out nocopy NUMBER
366: ,p_message out nocopy VARCHAR2
367: ,p_new_object_version_NUMBER out nocopy NUMBER
368: ,p_item_type IN WF_ITEMS.ITEM_TYPE%TYPE

Line 499: ,p_contact_id in NUMBER DEFAULT hr_api.g_NUMBER

495: -- ----------------------------------------------------------------------------
496:
497: Procedure check_changes
498: (p_nota_history_id in NUMBER
499: ,p_contact_id in NUMBER DEFAULT hr_api.g_NUMBER
500: ,p_trng_title in VARCHAR2
501: ,p_provider in VARCHAR2
502: ,p_type in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
503: ,p_centre in VARCHAR2 DEFAULT hr_api.g_VARCHAR2

Line 502: ,p_type in VARCHAR2 DEFAULT hr_api.g_VARCHAR2

498: (p_nota_history_id in NUMBER
499: ,p_contact_id in NUMBER DEFAULT hr_api.g_NUMBER
500: ,p_trng_title in VARCHAR2
501: ,p_provider in VARCHAR2
502: ,p_type in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
503: ,p_centre in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
504: ,p_completion_date in date
505: ,p_award in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
506: ,p_rating in VARCHAR2 DEFAULT hr_api.g_VARCHAR2

Line 503: ,p_centre in VARCHAR2 DEFAULT hr_api.g_VARCHAR2

499: ,p_contact_id in NUMBER DEFAULT hr_api.g_NUMBER
500: ,p_trng_title in VARCHAR2
501: ,p_provider in VARCHAR2
502: ,p_type in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
503: ,p_centre in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
504: ,p_completion_date in date
505: ,p_award in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
506: ,p_rating in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
507: ,p_duration in NUMBER DEFAULT hr_api.g_NUMBER

Line 505: ,p_award in VARCHAR2 DEFAULT hr_api.g_VARCHAR2

501: ,p_provider in VARCHAR2
502: ,p_type in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
503: ,p_centre in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
504: ,p_completion_date in date
505: ,p_award in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
506: ,p_rating in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
507: ,p_duration in NUMBER DEFAULT hr_api.g_NUMBER
508: ,p_duration_units in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
509: ,p_activity_version_id in NUMBER DEFAULT hr_api.g_NUMBER

Line 506: ,p_rating in VARCHAR2 DEFAULT hr_api.g_VARCHAR2

502: ,p_type in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
503: ,p_centre in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
504: ,p_completion_date in date
505: ,p_award in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
506: ,p_rating in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
507: ,p_duration in NUMBER DEFAULT hr_api.g_NUMBER
508: ,p_duration_units in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
509: ,p_activity_version_id in NUMBER DEFAULT hr_api.g_NUMBER
510: ,p_status in VARCHAR2 DEFAULT hr_api.g_VARCHAR2

Line 507: ,p_duration in NUMBER DEFAULT hr_api.g_NUMBER

503: ,p_centre in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
504: ,p_completion_date in date
505: ,p_award in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
506: ,p_rating in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
507: ,p_duration in NUMBER DEFAULT hr_api.g_NUMBER
508: ,p_duration_units in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
509: ,p_activity_version_id in NUMBER DEFAULT hr_api.g_NUMBER
510: ,p_status in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
511: ,p_nth_information_category in VARCHAR2 DEFAULT hr_api.g_VARCHAR2

Line 508: ,p_duration_units in VARCHAR2 DEFAULT hr_api.g_VARCHAR2

504: ,p_completion_date in date
505: ,p_award in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
506: ,p_rating in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
507: ,p_duration in NUMBER DEFAULT hr_api.g_NUMBER
508: ,p_duration_units in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
509: ,p_activity_version_id in NUMBER DEFAULT hr_api.g_NUMBER
510: ,p_status in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
511: ,p_nth_information_category in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
512: ,p_nth_information1 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2

Line 509: ,p_activity_version_id in NUMBER DEFAULT hr_api.g_NUMBER

505: ,p_award in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
506: ,p_rating in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
507: ,p_duration in NUMBER DEFAULT hr_api.g_NUMBER
508: ,p_duration_units in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
509: ,p_activity_version_id in NUMBER DEFAULT hr_api.g_NUMBER
510: ,p_status in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
511: ,p_nth_information_category in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
512: ,p_nth_information1 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
513: ,p_nth_information2 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2

Line 510: ,p_status in VARCHAR2 DEFAULT hr_api.g_VARCHAR2

506: ,p_rating in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
507: ,p_duration in NUMBER DEFAULT hr_api.g_NUMBER
508: ,p_duration_units in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
509: ,p_activity_version_id in NUMBER DEFAULT hr_api.g_NUMBER
510: ,p_status in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
511: ,p_nth_information_category in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
512: ,p_nth_information1 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
513: ,p_nth_information2 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
514: ,p_nth_information3 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2

Line 511: ,p_nth_information_category in VARCHAR2 DEFAULT hr_api.g_VARCHAR2

507: ,p_duration in NUMBER DEFAULT hr_api.g_NUMBER
508: ,p_duration_units in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
509: ,p_activity_version_id in NUMBER DEFAULT hr_api.g_NUMBER
510: ,p_status in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
511: ,p_nth_information_category in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
512: ,p_nth_information1 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
513: ,p_nth_information2 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
514: ,p_nth_information3 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
515: ,p_nth_information4 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2

Line 512: ,p_nth_information1 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2

508: ,p_duration_units in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
509: ,p_activity_version_id in NUMBER DEFAULT hr_api.g_NUMBER
510: ,p_status in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
511: ,p_nth_information_category in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
512: ,p_nth_information1 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
513: ,p_nth_information2 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
514: ,p_nth_information3 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
515: ,p_nth_information4 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
516: ,p_nth_information5 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2

Line 513: ,p_nth_information2 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2

509: ,p_activity_version_id in NUMBER DEFAULT hr_api.g_NUMBER
510: ,p_status in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
511: ,p_nth_information_category in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
512: ,p_nth_information1 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
513: ,p_nth_information2 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
514: ,p_nth_information3 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
515: ,p_nth_information4 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
516: ,p_nth_information5 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
517: ,p_nth_information6 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2

Line 514: ,p_nth_information3 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2

510: ,p_status in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
511: ,p_nth_information_category in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
512: ,p_nth_information1 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
513: ,p_nth_information2 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
514: ,p_nth_information3 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
515: ,p_nth_information4 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
516: ,p_nth_information5 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
517: ,p_nth_information6 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
518: ,p_nth_information7 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2

Line 515: ,p_nth_information4 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2

511: ,p_nth_information_category in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
512: ,p_nth_information1 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
513: ,p_nth_information2 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
514: ,p_nth_information3 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
515: ,p_nth_information4 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
516: ,p_nth_information5 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
517: ,p_nth_information6 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
518: ,p_nth_information7 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
519: ,p_nth_information8 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2

Line 516: ,p_nth_information5 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2

512: ,p_nth_information1 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
513: ,p_nth_information2 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
514: ,p_nth_information3 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
515: ,p_nth_information4 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
516: ,p_nth_information5 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
517: ,p_nth_information6 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
518: ,p_nth_information7 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
519: ,p_nth_information8 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
520: ,p_nth_information9 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2

Line 517: ,p_nth_information6 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2

513: ,p_nth_information2 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
514: ,p_nth_information3 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
515: ,p_nth_information4 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
516: ,p_nth_information5 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
517: ,p_nth_information6 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
518: ,p_nth_information7 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
519: ,p_nth_information8 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
520: ,p_nth_information9 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
521: ,p_nth_information10 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2

Line 518: ,p_nth_information7 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2

514: ,p_nth_information3 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
515: ,p_nth_information4 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
516: ,p_nth_information5 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
517: ,p_nth_information6 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
518: ,p_nth_information7 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
519: ,p_nth_information8 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
520: ,p_nth_information9 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
521: ,p_nth_information10 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
522: ,p_nth_information11 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2

Line 519: ,p_nth_information8 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2

515: ,p_nth_information4 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
516: ,p_nth_information5 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
517: ,p_nth_information6 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
518: ,p_nth_information7 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
519: ,p_nth_information8 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
520: ,p_nth_information9 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
521: ,p_nth_information10 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
522: ,p_nth_information11 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
523: ,p_nth_information12 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2

Line 520: ,p_nth_information9 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2

516: ,p_nth_information5 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
517: ,p_nth_information6 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
518: ,p_nth_information7 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
519: ,p_nth_information8 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
520: ,p_nth_information9 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
521: ,p_nth_information10 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
522: ,p_nth_information11 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
523: ,p_nth_information12 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
524: ,p_nth_information13 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2

Line 521: ,p_nth_information10 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2

517: ,p_nth_information6 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
518: ,p_nth_information7 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
519: ,p_nth_information8 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
520: ,p_nth_information9 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
521: ,p_nth_information10 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
522: ,p_nth_information11 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
523: ,p_nth_information12 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
524: ,p_nth_information13 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
525: ,p_nth_information14 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2

Line 522: ,p_nth_information11 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2

518: ,p_nth_information7 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
519: ,p_nth_information8 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
520: ,p_nth_information9 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
521: ,p_nth_information10 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
522: ,p_nth_information11 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
523: ,p_nth_information12 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
524: ,p_nth_information13 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
525: ,p_nth_information14 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
526: ,p_nth_information15 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2

Line 523: ,p_nth_information12 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2

519: ,p_nth_information8 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
520: ,p_nth_information9 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
521: ,p_nth_information10 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
522: ,p_nth_information11 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
523: ,p_nth_information12 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
524: ,p_nth_information13 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
525: ,p_nth_information14 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
526: ,p_nth_information15 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
527: ,p_nth_information16 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2

Line 524: ,p_nth_information13 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2

520: ,p_nth_information9 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
521: ,p_nth_information10 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
522: ,p_nth_information11 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
523: ,p_nth_information12 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
524: ,p_nth_information13 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
525: ,p_nth_information14 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
526: ,p_nth_information15 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
527: ,p_nth_information16 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
528: ,p_nth_information17 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2

Line 525: ,p_nth_information14 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2

521: ,p_nth_information10 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
522: ,p_nth_information11 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
523: ,p_nth_information12 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
524: ,p_nth_information13 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
525: ,p_nth_information14 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
526: ,p_nth_information15 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
527: ,p_nth_information16 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
528: ,p_nth_information17 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
529: ,p_nth_information18 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2

Line 526: ,p_nth_information15 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2

522: ,p_nth_information11 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
523: ,p_nth_information12 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
524: ,p_nth_information13 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
525: ,p_nth_information14 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
526: ,p_nth_information15 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
527: ,p_nth_information16 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
528: ,p_nth_information17 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
529: ,p_nth_information18 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
530: ,p_nth_information19 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2

Line 527: ,p_nth_information16 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2

523: ,p_nth_information12 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
524: ,p_nth_information13 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
525: ,p_nth_information14 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
526: ,p_nth_information15 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
527: ,p_nth_information16 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
528: ,p_nth_information17 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
529: ,p_nth_information18 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
530: ,p_nth_information19 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
531: ,p_nth_information20 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2

Line 528: ,p_nth_information17 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2

524: ,p_nth_information13 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
525: ,p_nth_information14 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
526: ,p_nth_information15 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
527: ,p_nth_information16 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
528: ,p_nth_information17 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
529: ,p_nth_information18 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
530: ,p_nth_information19 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
531: ,p_nth_information20 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
532: ,p_result out nocopy NUMBER

Line 529: ,p_nth_information18 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2

525: ,p_nth_information14 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
526: ,p_nth_information15 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
527: ,p_nth_information16 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
528: ,p_nth_information17 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
529: ,p_nth_information18 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
530: ,p_nth_information19 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
531: ,p_nth_information20 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
532: ,p_result out nocopy NUMBER
533: );

Line 530: ,p_nth_information19 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2

526: ,p_nth_information15 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
527: ,p_nth_information16 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
528: ,p_nth_information17 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
529: ,p_nth_information18 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
530: ,p_nth_information19 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
531: ,p_nth_information20 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
532: ,p_result out nocopy NUMBER
533: );
534:

Line 531: ,p_nth_information20 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2

527: ,p_nth_information16 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
528: ,p_nth_information17 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
529: ,p_nth_information18 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
530: ,p_nth_information19 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
531: ,p_nth_information20 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
532: ,p_result out nocopy NUMBER
533: );
534:
535: Procedure chk_pending_approval