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.PER_RCF_BUS dependencies on PER_RECRUITMENT_ACTIVITY_FOR

Line 30: , per_recruitment_activity_for rcf

26: --
27: cursor csr_sec_grp is
28: select pbg.security_group_id
29: from per_business_groups pbg
30: , per_recruitment_activity_for rcf
31: where rcf.recruitment_activity_for_id = p_rec_activity_for_id
32: and pbg.business_group_id = rcf.business_group_id;
33: --
34: -- Declare local variables

Line 94: , per_recruitment_activity_for rcf

90: --
91: cursor csr_leg_code is
92: select pbg.legislation_code
93: from per_business_groups pbg
94: , per_recruitment_activity_for rcf
95: where rcf.recruitment_activity_for_id = p_rec_activity_for_id
96: and pbg.business_group_id = rcf.business_group_id;
97: --
98: -- Declare local variables

Line 244: (p_vacancy_id in per_recruitment_activity_for.vacancy_id%type,

240: --
241: -- {End Of Comments}
242: -- ----------------------------------------------------------------------------
243: Procedure chk_vacancy_id
244: (p_vacancy_id in per_recruitment_activity_for.vacancy_id%type,
245: p_business_group_id in
246: per_recruitment_activity_for.business_group_id%type,
247: p_rec_activity_for_id in
248: per_recruitment_activity_for.recruitment_activity_for_id%type,

Line 246: per_recruitment_activity_for.business_group_id%type,

242: -- ----------------------------------------------------------------------------
243: Procedure chk_vacancy_id
244: (p_vacancy_id in per_recruitment_activity_for.vacancy_id%type,
245: p_business_group_id in
246: per_recruitment_activity_for.business_group_id%type,
247: p_rec_activity_for_id in
248: per_recruitment_activity_for.recruitment_activity_for_id%type,
249: p_object_version_number in
250: per_recruitment_activity_for.object_version_number%type

Line 248: per_recruitment_activity_for.recruitment_activity_for_id%type,

244: (p_vacancy_id in per_recruitment_activity_for.vacancy_id%type,
245: p_business_group_id in
246: per_recruitment_activity_for.business_group_id%type,
247: p_rec_activity_for_id in
248: per_recruitment_activity_for.recruitment_activity_for_id%type,
249: p_object_version_number in
250: per_recruitment_activity_for.object_version_number%type
251: ) IS
252: --

Line 250: per_recruitment_activity_for.object_version_number%type

246: per_recruitment_activity_for.business_group_id%type,
247: p_rec_activity_for_id in
248: per_recruitment_activity_for.recruitment_activity_for_id%type,
249: p_object_version_number in
250: per_recruitment_activity_for.object_version_number%type
251: ) IS
252: --
253: l_proc varchar2(72) := g_package || 'chk_vacancy_id';
254: l_business_group_id per_recruitment_activity_for.business_group_id%type;

Line 254: l_business_group_id per_recruitment_activity_for.business_group_id%type;

250: per_recruitment_activity_for.object_version_number%type
251: ) IS
252: --
253: l_proc varchar2(72) := g_package || 'chk_vacancy_id';
254: l_business_group_id per_recruitment_activity_for.business_group_id%type;
255: l_vacancy_id per_recruitment_activity_for.vacancy_id%type;
256: l_api_updating boolean;
257: --
258: -- Cursor to check that the vacancy id exists in the reference table

Line 255: l_vacancy_id per_recruitment_activity_for.vacancy_id%type;

251: ) IS
252: --
253: l_proc varchar2(72) := g_package || 'chk_vacancy_id';
254: l_business_group_id per_recruitment_activity_for.business_group_id%type;
255: l_vacancy_id per_recruitment_activity_for.vacancy_id%type;
256: l_api_updating boolean;
257: --
258: -- Cursor to check that the vacancy id exists in the reference table
259: -- PER_ALL_VACANCIES.

Line 301: (p_associated_column1 => 'PER_RECRUITMENT_ACTIVITY_FOR.VACANCY_ID'

297: hr_utility.set_location(l_proc, 41);
298: close csr_vacancy_id;
299: fnd_message.set_name('PER','PER_289469_RCF_INV_VAC_ID');
300: hr_multi_message.add
301: (p_associated_column1 => 'PER_RECRUITMENT_ACTIVITY_FOR.VACANCY_ID'
302: );
303: else
304: --
305: -- Check that the business group id is the same as that in the

Line 315: 'PER_RECRUITMENT_ACTIVITY_FOR.VACANCY_ID'

311: close csr_vacancy_id;
312: fnd_message.set_name('PER', 'PER_289468_RCF_INV_VAC_BG');
313: hr_multi_message.add
314: (p_associated_column1 =>
315: 'PER_RECRUITMENT_ACTIVITY_FOR.VACANCY_ID'
316: ,p_associated_column2 =>
317: 'PER_RECRUITMENT_ACTIVITY_FOR.BUSINESS_GROUP_ID'
318: );
319: else

Line 317: 'PER_RECRUITMENT_ACTIVITY_FOR.BUSINESS_GROUP_ID'

313: hr_multi_message.add
314: (p_associated_column1 =>
315: 'PER_RECRUITMENT_ACTIVITY_FOR.VACANCY_ID'
316: ,p_associated_column2 =>
317: 'PER_RECRUITMENT_ACTIVITY_FOR.BUSINESS_GROUP_ID'
318: );
319: else
320: hr_utility.set_location(l_proc, 60);
321: close csr_vacancy_id;

Line 359: per_recruitment_activity_for.recruitment_activity_id%type,

355: -- {End Of Comments}
356: -- ----------------------------------------------------------------------------
357: Procedure chk_rec_activity_id
358: (p_rec_activity_id in
359: per_recruitment_activity_for.recruitment_activity_id%type,
360: p_business_group_id in
361: per_recruitment_activity_for.business_group_id%type,
362: p_rec_activity_for_id in
363: per_recruitment_activity_for.recruitment_activity_for_id%type,

Line 361: per_recruitment_activity_for.business_group_id%type,

357: Procedure chk_rec_activity_id
358: (p_rec_activity_id in
359: per_recruitment_activity_for.recruitment_activity_id%type,
360: p_business_group_id in
361: per_recruitment_activity_for.business_group_id%type,
362: p_rec_activity_for_id in
363: per_recruitment_activity_for.recruitment_activity_for_id%type,
364: p_object_version_number in
365: per_recruitment_activity_for.object_version_number%type

Line 363: per_recruitment_activity_for.recruitment_activity_for_id%type,

359: per_recruitment_activity_for.recruitment_activity_id%type,
360: p_business_group_id in
361: per_recruitment_activity_for.business_group_id%type,
362: p_rec_activity_for_id in
363: per_recruitment_activity_for.recruitment_activity_for_id%type,
364: p_object_version_number in
365: per_recruitment_activity_for.object_version_number%type
366: ) IS
367: --

Line 365: per_recruitment_activity_for.object_version_number%type

361: per_recruitment_activity_for.business_group_id%type,
362: p_rec_activity_for_id in
363: per_recruitment_activity_for.recruitment_activity_for_id%type,
364: p_object_version_number in
365: per_recruitment_activity_for.object_version_number%type
366: ) IS
367: --
368: l_proc varchar2(72) := g_package || 'chk_rec_activity_id';
369: l_rec_activity_id per_recruitment_activity_for.recruitment_activity_id%type;

Line 369: l_rec_activity_id per_recruitment_activity_for.recruitment_activity_id%type;

365: per_recruitment_activity_for.object_version_number%type
366: ) IS
367: --
368: l_proc varchar2(72) := g_package || 'chk_rec_activity_id';
369: l_rec_activity_id per_recruitment_activity_for.recruitment_activity_id%type;
370: l_business_group_id per_recruitment_activity_for.business_group_id%type;
371: l_api_updating boolean;
372: --
373: -- Cursor to check that the recruitment activity id exists in the reference

Line 370: l_business_group_id per_recruitment_activity_for.business_group_id%type;

366: ) IS
367: --
368: l_proc varchar2(72) := g_package || 'chk_rec_activity_id';
369: l_rec_activity_id per_recruitment_activity_for.recruitment_activity_id%type;
370: l_business_group_id per_recruitment_activity_for.business_group_id%type;
371: l_api_updating boolean;
372: --
373: -- Cursor to check that the recruitment activity id exists in the reference
374: -- table PER_RECRUITMENT_ACTIVITIES.

Line 418: 'PER_RECRUITMENT_ACTIVITY_FOR.RECRUITMENT_ACTIVITY_ID'

414: close csr_rec_activity_id;
415: fnd_message.set_name('PER','PER_289470_RCF_INV_ACT_ID');
416: hr_multi_message.add
417: (p_associated_column1 =>
418: 'PER_RECRUITMENT_ACTIVITY_FOR.RECRUITMENT_ACTIVITY_ID'
419: );
420: else
421: --
422: -- Check that the business group id is the same as that in the

Line 423: -- PER_RECRUITMENT_ACTIVITY_FOR table for this recruitment_activity_id.

419: );
420: else
421: --
422: -- Check that the business group id is the same as that in the
423: -- PER_RECRUITMENT_ACTIVITY_FOR table for this recruitment_activity_id.
424: --
425: hr_utility.set_location(l_proc, 50);
426: if (l_business_group_id <> p_business_group_id) then
427: hr_utility.set_location(l_proc, 51);

Line 432: 'PER_RECRUITMENT_ACTIVITY_FOR.RECRUITMENT_ACTIVITY_ID'

428: close csr_rec_activity_id;
429: fnd_message.set_name('PER', 'PER_289471_RCF_INV_ACT_BG');
430: hr_multi_message.add
431: (p_associated_column1 =>
432: 'PER_RECRUITMENT_ACTIVITY_FOR.RECRUITMENT_ACTIVITY_ID'
433: ,p_associated_column2 =>
434: 'PER_RECRUITMENT_ACTIVITY_FOR.BUSINESS_GROUP_ID'
435: );
436: else

Line 434: 'PER_RECRUITMENT_ACTIVITY_FOR.BUSINESS_GROUP_ID'

430: hr_multi_message.add
431: (p_associated_column1 =>
432: 'PER_RECRUITMENT_ACTIVITY_FOR.RECRUITMENT_ACTIVITY_ID'
433: ,p_associated_column2 =>
434: 'PER_RECRUITMENT_ACTIVITY_FOR.BUSINESS_GROUP_ID'
435: );
436: else
437: hr_utility.set_location(l_proc, 60);
438: close csr_rec_activity_id;

Line 477: (p_vacancy_id in per_recruitment_activity_for.vacancy_id%type

473: --
474: -- {End Of Comments}
475: -- ----------------------------------------------------------------------------
476: Procedure chk_vacancy_rec_activity
477: (p_vacancy_id in per_recruitment_activity_for.vacancy_id%type
478: ,p_rec_activity_id in
479: per_recruitment_activity_for.recruitment_activity_id%type
480: ) IS
481: --

Line 479: per_recruitment_activity_for.recruitment_activity_id%type

475: -- ----------------------------------------------------------------------------
476: Procedure chk_vacancy_rec_activity
477: (p_vacancy_id in per_recruitment_activity_for.vacancy_id%type
478: ,p_rec_activity_id in
479: per_recruitment_activity_for.recruitment_activity_id%type
480: ) IS
481: --
482: l_proc varchar2(72) := g_package || 'chk_vacancy_rec_activity';
483: l_vacancy_id per_recruitment_activity_for.vacancy_id%type;

Line 483: l_vacancy_id per_recruitment_activity_for.vacancy_id%type;

479: per_recruitment_activity_for.recruitment_activity_id%type
480: ) IS
481: --
482: l_proc varchar2(72) := g_package || 'chk_vacancy_rec_activity';
483: l_vacancy_id per_recruitment_activity_for.vacancy_id%type;
484: l_internal irc_all_recruiting_sites.internal%type;
485: l_external irc_all_recruiting_sites.external%type;
486: l_ret varchar2(1);
487: --

Line 492: ,per_recruitment_activity_for prf

488: cursor csr_internal is
489: select null
490: from irc_all_recruiting_sites irs
491: ,per_recruitment_activities pra
492: ,per_recruitment_activity_for prf
493: where irs.recruiting_site_id = pra.recruiting_site_id
494: and pra.recruitment_activity_id = prf.recruitment_activity_id
495: and pra.recruitment_activity_id <> p_rec_activity_id
496: and irs.internal = 'Y'

Line 503: ,per_recruitment_activity_for prf

499: cursor csr_external is
500: select null
501: from irc_all_recruiting_sites irs
502: ,per_recruitment_activities pra
503: ,per_recruitment_activity_for prf
504: where irs.recruiting_site_id = pra.recruiting_site_id
505: and pra.recruitment_activity_id = prf.recruitment_activity_id
506: and pra.recruitment_activity_id <> p_rec_activity_id
507: and irs.external = 'Y' and

Line 522: (p_check_column1 => 'PER_RECRUITMENT_ACTIVITY_FOR.VACANCY_ID'

518: Begin
519: hr_utility.set_location('Entering:'|| l_proc, 10);
520: --
521: if hr_multi_message.no_exclusive_error
522: (p_check_column1 => 'PER_RECRUITMENT_ACTIVITY_FOR.VACANCY_ID'
523: ,p_check_column2 => 'PER_RECRUITMENT_ACTIVITY_FOR.RECRUITMENT_ACTIVITY_ID'
524: ) then
525: open csr_rse;
526: fetch csr_rse into l_internal,l_external;

Line 523: ,p_check_column2 => 'PER_RECRUITMENT_ACTIVITY_FOR.RECRUITMENT_ACTIVITY_ID'

519: hr_utility.set_location('Entering:'|| l_proc, 10);
520: --
521: if hr_multi_message.no_exclusive_error
522: (p_check_column1 => 'PER_RECRUITMENT_ACTIVITY_FOR.VACANCY_ID'
523: ,p_check_column2 => 'PER_RECRUITMENT_ACTIVITY_FOR.RECRUITMENT_ACTIVITY_ID'
524: ) then
525: open csr_rse;
526: fetch csr_rse into l_internal,l_external;
527: close csr_rse;

Line 568: 'per_recruitment_activity_for.VACANCY_ID'

564: exception
565: when app_exception.application_exception then
566: if hr_multi_message.exception_add
567: (p_associated_column1 =>
568: 'per_recruitment_activity_for.VACANCY_ID'
569: ,p_associated_column2 =>
570: 'per_recruitment_activity_for.RECRUITMENT_ACTIVITY_ID'
571: ) then
572: hr_utility.set_location(' Exception :'||l_proc,90);

Line 570: 'per_recruitment_activity_for.RECRUITMENT_ACTIVITY_ID'

566: if hr_multi_message.exception_add
567: (p_associated_column1 =>
568: 'per_recruitment_activity_for.VACANCY_ID'
569: ,p_associated_column2 =>
570: 'per_recruitment_activity_for.RECRUITMENT_ACTIVITY_ID'
571: ) then
572: hr_utility.set_location(' Exception :'||l_proc,90);
573: raise;
574: end if;

Line 608: (p_vacancy_id in per_recruitment_activity_for.vacancy_id%type

604: --
605: -- {End Of Comments}
606: -- ---------------------------------------------------------------------------
607: Procedure chk_rec_activity_dates
608: (p_vacancy_id in per_recruitment_activity_for.vacancy_id%type
609: ,p_rec_activity_id in
610: per_recruitment_activity_for.recruitment_activity_id%type
611: ) IS
612: --

Line 610: per_recruitment_activity_for.recruitment_activity_id%type

606: -- ---------------------------------------------------------------------------
607: Procedure chk_rec_activity_dates
608: (p_vacancy_id in per_recruitment_activity_for.vacancy_id%type
609: ,p_rec_activity_id in
610: per_recruitment_activity_for.recruitment_activity_id%type
611: ) IS
612: --
613: l_proc varchar2(72) := g_package || 'chk_rec_activity_dates';
614: l_ret varchar2(1);

Line 619: l_vacancy_id per_recruitment_activity_for.vacancy_id%type;

615: l_internal irc_all_recruiting_sites.internal%type;
616: l_external irc_all_recruiting_sites.external%type;
617: l_start_date per_recruitment_activities.date_start%type;
618: l_start_date_exists per_recruitment_activities.date_start%type;
619: l_vacancy_id per_recruitment_activity_for.vacancy_id%type;
620: cursor csr_internal is
621: --
622: select pra.date_start
623: from irc_all_recruiting_sites irs

Line 625: ,per_recruitment_activity_for prf

621: --
622: select pra.date_start
623: from irc_all_recruiting_sites irs
624: ,per_recruitment_activities pra
625: ,per_recruitment_activity_for prf
626: where irs.recruiting_site_id = pra.recruiting_site_id
627: and pra.recruitment_activity_id = prf.recruitment_activity_id
628: and irs.internal = 'Y'
629: and prf.vacancy_id = p_vacancy_id;

Line 635: ,per_recruitment_activity_for prf

631: cursor csr_external is
632: select pra.date_start
633: from irc_all_recruiting_sites irs
634: ,per_recruitment_activities pra
635: ,per_recruitment_activity_for prf
636: where irs.recruiting_site_id = pra.recruiting_site_id
637: and pra.recruitment_activity_id = prf.recruitment_activity_id
638: and irs.external = 'Y' and
639: prf.vacancy_id = p_vacancy_id;

Line 655: (p_check_column1 => 'PER_RECRUITMENT_ACTIVITY_FOR.VACANCY_ID'

651: --
652: hr_utility.set_location('Entering:'|| l_proc, 10);
653: --
654: if hr_multi_message.no_exclusive_error
655: (p_check_column1 => 'PER_RECRUITMENT_ACTIVITY_FOR.VACANCY_ID'
656: ,p_check_column2 => 'PER_RECRUITMENT_ACTIVITY_FOR.RECRUITMENT_ACTIVITY_ID'
657: ) then
658: --
659: hr_utility.set_location(l_proc, 15);

Line 656: ,p_check_column2 => 'PER_RECRUITMENT_ACTIVITY_FOR.RECRUITMENT_ACTIVITY_ID'

652: hr_utility.set_location('Entering:'|| l_proc, 10);
653: --
654: if hr_multi_message.no_exclusive_error
655: (p_check_column1 => 'PER_RECRUITMENT_ACTIVITY_FOR.VACANCY_ID'
656: ,p_check_column2 => 'PER_RECRUITMENT_ACTIVITY_FOR.RECRUITMENT_ACTIVITY_ID'
657: ) then
658: --
659: hr_utility.set_location(l_proc, 15);
660: --

Line 741: 'per_recruitment_activity_for.VACANCY_ID'

737: exception
738: when app_exception.application_exception then
739: if hr_multi_message.exception_add
740: (p_associated_column1 =>
741: 'per_recruitment_activity_for.VACANCY_ID'
742: ,p_associated_column2 =>
743: 'per_recruitment_activity_for.RECRUITMENT_ACTIVITY_ID'
744: ) then
745: hr_utility.set_location(' Exception :'||l_proc,90);

Line 743: 'per_recruitment_activity_for.RECRUITMENT_ACTIVITY_ID'

739: if hr_multi_message.exception_add
740: (p_associated_column1 =>
741: 'per_recruitment_activity_for.VACANCY_ID'
742: ,p_associated_column2 =>
743: 'per_recruitment_activity_for.RECRUITMENT_ACTIVITY_ID'
744: ) then
745: hr_utility.set_location(' Exception :'||l_proc,90);
746: raise;
747: end if;