[Home] [Help]
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.
375: --
376: cursor csr_rec_activity_id is
377: select recruitment_activity_id, business_group_id
378: from per_recruitment_activities
374: -- table PER_RECRUITMENT_ACTIVITIES.
375: --
376: cursor csr_rec_activity_id is
377: select recruitment_activity_id, business_group_id
378: from per_recruitment_activities
379: where recruitment_activity_id = p_rec_activity_id;
380: --
381: Begin
382: hr_utility.set_location('Entering:'|| l_proc, 10);
403: );
404: end if;
405: --
406: -- Check that the recruitment activity id exists in the
407: -- PER_RECRUITMENT_ACTIVITIES table.
408: --
409: open csr_rec_activity_id;
410: fetch csr_rec_activity_id into l_rec_activity_id, l_business_group_id;
411: hr_utility.set_location(l_proc, 40);
487: --
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
498: --
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
510: cursor csr_rse is
511: select irs.internal
512: ,irs.external
513: from irc_all_recruiting_sites irs
514: ,per_recruitment_activities pra
515: where pra.recruitment_activity_id = p_rec_activity_id
516: and pra.recruiting_site_id = irs.recruiting_site_id;
517: --
518: Begin
613: l_proc varchar2(72) := g_package || 'chk_rec_activity_dates';
614: l_ret varchar2(1);
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: --
614: l_ret varchar2(1);
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
620: cursor csr_internal is
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'
630: --
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
642: select irs.internal
643: ,irs.external
644: ,pra.date_start
645: from irc_all_recruiting_sites irs
646: ,per_recruitment_activities pra
647: where pra.recruitment_activity_id = p_rec_activity_id
648: and pra.recruiting_site_id = irs.recruiting_site_id;
649: --
650: Begin