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.

[Home] [Help]

APPS.IRC_RTM_BUS dependencies on IRC_REC_TEAM_MEMBERS

Line 181: (p_person_id in irc_rec_team_members.person_id%type

177: -- Internal Row Handler Use Only.
178: --
179: -- ----------------------------------------------------------------------------
180: Procedure chk_person_id
181: (p_person_id in irc_rec_team_members.person_id%type
182: ,p_party_id in out nocopy irc_rec_team_members.party_id%type
183: ,p_effective_date in date
184: ) is
185: --

Line 182: ,p_party_id in out nocopy irc_rec_team_members.party_id%type

178: --
179: -- ----------------------------------------------------------------------------
180: Procedure chk_person_id
181: (p_person_id in irc_rec_team_members.person_id%type
182: ,p_party_id in out nocopy irc_rec_team_members.party_id%type
183: ,p_effective_date in date
184: ) is
185: --
186: l_proc varchar2(72) := g_package||'chk_person_id';

Line 187: l_party_id irc_rec_team_members.party_id%type;

183: ,p_effective_date in date
184: ) is
185: --
186: l_proc varchar2(72) := g_package||'chk_person_id';
187: l_party_id irc_rec_team_members.party_id%type;
188: l_var varchar2(1);
189: --
190: cursor l_person is
191: select party_id

Line 236: (p_associated_column1 => 'IRC_REC_TEAM_MEMBERS.PERSON_ID'

232: close csr_system_person_type;
233: hr_utility.set_location(l_proc, 30);
234: fnd_message.set_name('PER','IRC_412034_RTM_INV_EMP');
235: hr_multi_message.add
236: (p_associated_column1 => 'IRC_REC_TEAM_MEMBERS.PERSON_ID'
237: );
238: else
239: close csr_system_person_type;
240: end if;

Line 258: (p_associated_column1 => 'IRC_REC_TEAM_MEMBERS.PERSON_ID'

254: --
255: exception
256: when app_exception.application_exception then
257: if hr_multi_message.exception_add
258: (p_associated_column1 => 'IRC_REC_TEAM_MEMBERS.PERSON_ID'
259: ) then
260: --
261: hr_utility.set_location(' Leaving:'||l_proc,60);
262: --

Line 300: (p_vacancy_id in irc_rec_team_members.vacancy_id%type

296: --
297: -- {End Of Comments}
298: -- ----------------------------------------------------------------------------
299: Procedure chk_vacancy_id
300: (p_vacancy_id in irc_rec_team_members.vacancy_id%type
301: ,p_start_date in irc_rec_team_members.start_date%type
302: ) IS
303: --
304: l_proc varchar2(72) := g_package || 'chk_vacancy_id';

Line 301: ,p_start_date in irc_rec_team_members.start_date%type

297: -- {End Of Comments}
298: -- ----------------------------------------------------------------------------
299: Procedure chk_vacancy_id
300: (p_vacancy_id in irc_rec_team_members.vacancy_id%type
301: ,p_start_date in irc_rec_team_members.start_date%type
302: ) IS
303: --
304: l_proc varchar2(72) := g_package || 'chk_vacancy_id';
305: l_vacancy_id irc_rec_team_members.vacancy_id%type;

Line 305: l_vacancy_id irc_rec_team_members.vacancy_id%type;

301: ,p_start_date in irc_rec_team_members.start_date%type
302: ) IS
303: --
304: l_proc varchar2(72) := g_package || 'chk_vacancy_id';
305: l_vacancy_id irc_rec_team_members.vacancy_id%type;
306: --
307: --
308: -- Cursor to check that the vacancy_id exists in PER_ALL_VACANCIES
309: -- and is current at the p_start_date.

Line 343: (p_associated_column1 => 'IRC_REC_TEAM_MEMBERS.VACANCY_ID'

339: --
340: exception
341: when app_exception.application_exception then
342: if hr_multi_message.exception_add
343: (p_associated_column1 => 'IRC_REC_TEAM_MEMBERS.VACANCY_ID'
344: ) then
345: hr_utility.set_location(' Leaving:'||l_proc, 40);
346: raise;
347: end if;

Line 382: (p_job_id in irc_rec_team_members.job_id%type

378: --
379: -- {End Of Comments}
380: -- ----------------------------------------------------------------------------
381: Procedure chk_job_id
382: (p_job_id in irc_rec_team_members.job_id%type
383: ,p_rec_team_member_id in irc_rec_team_members.rec_team_member_id%type
384: ,p_vacancy_id in irc_rec_team_members.vacancy_id%type
385: ,p_object_version_number in irc_rec_team_members.object_version_number%type
386: ,p_start_date in irc_rec_team_members.start_date%type

Line 383: ,p_rec_team_member_id in irc_rec_team_members.rec_team_member_id%type

379: -- {End Of Comments}
380: -- ----------------------------------------------------------------------------
381: Procedure chk_job_id
382: (p_job_id in irc_rec_team_members.job_id%type
383: ,p_rec_team_member_id in irc_rec_team_members.rec_team_member_id%type
384: ,p_vacancy_id in irc_rec_team_members.vacancy_id%type
385: ,p_object_version_number in irc_rec_team_members.object_version_number%type
386: ,p_start_date in irc_rec_team_members.start_date%type
387: ) IS

Line 384: ,p_vacancy_id in irc_rec_team_members.vacancy_id%type

380: -- ----------------------------------------------------------------------------
381: Procedure chk_job_id
382: (p_job_id in irc_rec_team_members.job_id%type
383: ,p_rec_team_member_id in irc_rec_team_members.rec_team_member_id%type
384: ,p_vacancy_id in irc_rec_team_members.vacancy_id%type
385: ,p_object_version_number in irc_rec_team_members.object_version_number%type
386: ,p_start_date in irc_rec_team_members.start_date%type
387: ) IS
388: --

Line 385: ,p_object_version_number in irc_rec_team_members.object_version_number%type

381: Procedure chk_job_id
382: (p_job_id in irc_rec_team_members.job_id%type
383: ,p_rec_team_member_id in irc_rec_team_members.rec_team_member_id%type
384: ,p_vacancy_id in irc_rec_team_members.vacancy_id%type
385: ,p_object_version_number in irc_rec_team_members.object_version_number%type
386: ,p_start_date in irc_rec_team_members.start_date%type
387: ) IS
388: --
389: l_proc varchar2(72) := g_package || 'chk_job_id';

Line 386: ,p_start_date in irc_rec_team_members.start_date%type

382: (p_job_id in irc_rec_team_members.job_id%type
383: ,p_rec_team_member_id in irc_rec_team_members.rec_team_member_id%type
384: ,p_vacancy_id in irc_rec_team_members.vacancy_id%type
385: ,p_object_version_number in irc_rec_team_members.object_version_number%type
386: ,p_start_date in irc_rec_team_members.start_date%type
387: ) IS
388: --
389: l_proc varchar2(72) := g_package || 'chk_job_id';
390: l_job_id varchar2(1);

Line 420: (p_check_column1 => 'IRC_REC_TEAM_MEMBERS.VACANCY_ID'

416: --
417: -- Check if the job_id exists in PER_JOBS
418: --
419: if hr_multi_message.no_exclusive_error
420: (p_check_column1 => 'IRC_REC_TEAM_MEMBERS.VACANCY_ID'
421: ) then
422: open csr_job_id;
423: fetch csr_job_id into l_job_id;
424: hr_utility.set_location(l_proc, 40);

Line 439: (p_associated_column1 => 'IRC_REC_TEAM_MEMBERS.JOB_ID'

435: --
436: exception
437: when app_exception.application_exception then
438: if hr_multi_message.exception_add
439: (p_associated_column1 => 'IRC_REC_TEAM_MEMBERS.JOB_ID'
440: ) then
441: hr_utility.set_location(' Leaving:'||l_proc, 50);
442: raise;
443: end if;

Line 477: (p_rec_team_member_id irc_rec_team_members.rec_team_member_id%type

473: --
474: -- {End Of Comments}
475: -- ----------------------------------------------------------------------------
476: Procedure chk_job_id_job_group_id
477: (p_rec_team_member_id irc_rec_team_members.rec_team_member_id%type
478: ,p_job_id in irc_rec_team_members.job_id%type
479: ,p_object_version_number irc_rec_team_members.object_version_number%type
480: ) IS
481: --

Line 478: ,p_job_id in irc_rec_team_members.job_id%type

474: -- {End Of Comments}
475: -- ----------------------------------------------------------------------------
476: Procedure chk_job_id_job_group_id
477: (p_rec_team_member_id irc_rec_team_members.rec_team_member_id%type
478: ,p_job_id in irc_rec_team_members.job_id%type
479: ,p_object_version_number irc_rec_team_members.object_version_number%type
480: ) IS
481: --
482: l_proc varchar2(72) := g_package || 'chk_job_id_job_group_id';

Line 479: ,p_object_version_number irc_rec_team_members.object_version_number%type

475: -- ----------------------------------------------------------------------------
476: Procedure chk_job_id_job_group_id
477: (p_rec_team_member_id irc_rec_team_members.rec_team_member_id%type
478: ,p_job_id in irc_rec_team_members.job_id%type
479: ,p_object_version_number irc_rec_team_members.object_version_number%type
480: ) IS
481: --
482: l_proc varchar2(72) := g_package || 'chk_job_id_job_group_id';
483: l_job_id_job_group_id varchar2(1);

Line 515: (p_check_column1 => 'IRC_REC_TEAM_MEMBERS.JOB_ID'

511: --
512: -- Check if the job_group_id exists in PER_JOB_GROUPS and is valid.
513: --
514: if hr_multi_message.no_exclusive_error
515: (p_check_column1 => 'IRC_REC_TEAM_MEMBERS.JOB_ID'
516: ,p_check_column2 => 'IRC_REC_TEAM_MEMBERS.VACANCY_ID'
517: ) then
518: open csr_job_id_job_group_id;
519: fetch csr_job_id_job_group_id into l_job_id_job_group_id;

Line 516: ,p_check_column2 => 'IRC_REC_TEAM_MEMBERS.VACANCY_ID'

512: -- Check if the job_group_id exists in PER_JOB_GROUPS and is valid.
513: --
514: if hr_multi_message.no_exclusive_error
515: (p_check_column1 => 'IRC_REC_TEAM_MEMBERS.JOB_ID'
516: ,p_check_column2 => 'IRC_REC_TEAM_MEMBERS.VACANCY_ID'
517: ) then
518: open csr_job_id_job_group_id;
519: fetch csr_job_id_job_group_id into l_job_id_job_group_id;
520: hr_utility.set_location(l_proc, 30);

Line 535: (p_associated_column1 => 'IRC_REC_TEAM_MEMBERS.JOB_ID'

531: --
532: exception
533: when app_exception.application_exception then
534: if hr_multi_message.exception_add
535: (p_associated_column1 => 'IRC_REC_TEAM_MEMBERS.JOB_ID'
536: ) then
537: hr_utility.set_location(' Leaving:'||l_proc, 40);
538: raise;
539: end if;

Line 572: (p_start_date in irc_rec_team_members.start_date%type

568: --
569: -- {End Of Comments}
570: -- ----------------------------------------------------------------------------
571: Procedure chk_team_dates
572: (p_start_date in irc_rec_team_members.start_date%type
573: ,p_end_date in irc_rec_team_members.end_date%type
574: ,p_rec_team_member_id in irc_rec_team_members.rec_team_member_id%type
575: ,p_object_version_number in irc_rec_team_members.object_version_number%type
576: ) IS

Line 573: ,p_end_date in irc_rec_team_members.end_date%type

569: -- {End Of Comments}
570: -- ----------------------------------------------------------------------------
571: Procedure chk_team_dates
572: (p_start_date in irc_rec_team_members.start_date%type
573: ,p_end_date in irc_rec_team_members.end_date%type
574: ,p_rec_team_member_id in irc_rec_team_members.rec_team_member_id%type
575: ,p_object_version_number in irc_rec_team_members.object_version_number%type
576: ) IS
577: --

Line 574: ,p_rec_team_member_id in irc_rec_team_members.rec_team_member_id%type

570: -- ----------------------------------------------------------------------------
571: Procedure chk_team_dates
572: (p_start_date in irc_rec_team_members.start_date%type
573: ,p_end_date in irc_rec_team_members.end_date%type
574: ,p_rec_team_member_id in irc_rec_team_members.rec_team_member_id%type
575: ,p_object_version_number in irc_rec_team_members.object_version_number%type
576: ) IS
577: --
578: l_proc varchar2(72) := g_package || 'chk_team_dates';

Line 575: ,p_object_version_number in irc_rec_team_members.object_version_number%type

571: Procedure chk_team_dates
572: (p_start_date in irc_rec_team_members.start_date%type
573: ,p_end_date in irc_rec_team_members.end_date%type
574: ,p_rec_team_member_id in irc_rec_team_members.rec_team_member_id%type
575: ,p_object_version_number in irc_rec_team_members.object_version_number%type
576: ) IS
577: --
578: l_proc varchar2(72) := g_package || 'chk_team_dates';
579: l_api_updating boolean;

Line 612: (p_associated_column1 => 'IRC_REC_TEAM_MEMBERS.START_DATE'

608: hr_utility.set_location(' Leaving:'||l_proc,45);
609: exception
610: when app_exception.application_exception then
611: if hr_multi_message.exception_add
612: (p_associated_column1 => 'IRC_REC_TEAM_MEMBERS.START_DATE'
613: ,p_associated_column2 => 'IRC_REC_TEAM_MEMBERS.END_DATE'
614: ) then
615: hr_utility.set_location(' Leaving:'||l_proc, 50);
616: raise;

Line 613: ,p_associated_column2 => 'IRC_REC_TEAM_MEMBERS.END_DATE'

609: exception
610: when app_exception.application_exception then
611: if hr_multi_message.exception_add
612: (p_associated_column1 => 'IRC_REC_TEAM_MEMBERS.START_DATE'
613: ,p_associated_column2 => 'IRC_REC_TEAM_MEMBERS.END_DATE'
614: ) then
615: hr_utility.set_location(' Leaving:'||l_proc, 50);
616: raise;
617: end if;

Line 651: (p_update_allowed in irc_rec_team_members.update_allowed%type

647: --
648: -- {End Of Comments}
649: -- ----------------------------------------------------------------------------
650: Procedure chk_update_allowed
651: (p_update_allowed in irc_rec_team_members.update_allowed%type
652: ,p_start_date in irc_rec_team_members.start_date%type
653: ,p_rec_team_member_id in irc_rec_team_members.rec_team_member_id%type
654: ,p_object_version_number in irc_rec_team_members.object_version_number%type
655: ) IS

Line 652: ,p_start_date in irc_rec_team_members.start_date%type

648: -- {End Of Comments}
649: -- ----------------------------------------------------------------------------
650: Procedure chk_update_allowed
651: (p_update_allowed in irc_rec_team_members.update_allowed%type
652: ,p_start_date in irc_rec_team_members.start_date%type
653: ,p_rec_team_member_id in irc_rec_team_members.rec_team_member_id%type
654: ,p_object_version_number in irc_rec_team_members.object_version_number%type
655: ) IS
656: --

Line 653: ,p_rec_team_member_id in irc_rec_team_members.rec_team_member_id%type

649: -- ----------------------------------------------------------------------------
650: Procedure chk_update_allowed
651: (p_update_allowed in irc_rec_team_members.update_allowed%type
652: ,p_start_date in irc_rec_team_members.start_date%type
653: ,p_rec_team_member_id in irc_rec_team_members.rec_team_member_id%type
654: ,p_object_version_number in irc_rec_team_members.object_version_number%type
655: ) IS
656: --
657: l_proc varchar2(72) := g_package || 'chk_update_allowed';

Line 654: ,p_object_version_number in irc_rec_team_members.object_version_number%type

650: Procedure chk_update_allowed
651: (p_update_allowed in irc_rec_team_members.update_allowed%type
652: ,p_start_date in irc_rec_team_members.start_date%type
653: ,p_rec_team_member_id in irc_rec_team_members.rec_team_member_id%type
654: ,p_object_version_number in irc_rec_team_members.object_version_number%type
655: ) IS
656: --
657: l_proc varchar2(72) := g_package || 'chk_update_allowed';
658: l_var boolean;

Line 695: (p_associated_column1 => 'IRC_REC_TEAM_MEMBERS.UPDATE_ALLOWED'

691: hr_utility.set_location(' Leaving:'||l_proc,45);
692: exception
693: when app_exception.application_exception then
694: if hr_multi_message.exception_add
695: (p_associated_column1 => 'IRC_REC_TEAM_MEMBERS.UPDATE_ALLOWED'
696: ) then
697: hr_utility.set_location(' Leaving:'||l_proc, 50);
698: raise;
699: end if;

Line 733: (p_delete_allowed in irc_rec_team_members.delete_allowed%type

729: --
730: -- {End Of Comments}
731: -- ----------------------------------------------------------------------------
732: Procedure chk_delete_allowed
733: (p_delete_allowed in irc_rec_team_members.delete_allowed%type
734: ,p_start_date in irc_rec_team_members.start_date%type
735: ,p_rec_team_member_id in irc_rec_team_members.rec_team_member_id%type
736: ,p_object_version_number in irc_rec_team_members.object_version_number%type
737: ) IS

Line 734: ,p_start_date in irc_rec_team_members.start_date%type

730: -- {End Of Comments}
731: -- ----------------------------------------------------------------------------
732: Procedure chk_delete_allowed
733: (p_delete_allowed in irc_rec_team_members.delete_allowed%type
734: ,p_start_date in irc_rec_team_members.start_date%type
735: ,p_rec_team_member_id in irc_rec_team_members.rec_team_member_id%type
736: ,p_object_version_number in irc_rec_team_members.object_version_number%type
737: ) IS
738: --

Line 735: ,p_rec_team_member_id in irc_rec_team_members.rec_team_member_id%type

731: -- ----------------------------------------------------------------------------
732: Procedure chk_delete_allowed
733: (p_delete_allowed in irc_rec_team_members.delete_allowed%type
734: ,p_start_date in irc_rec_team_members.start_date%type
735: ,p_rec_team_member_id in irc_rec_team_members.rec_team_member_id%type
736: ,p_object_version_number in irc_rec_team_members.object_version_number%type
737: ) IS
738: --
739: l_proc varchar2(72) := g_package || 'chk_delete_allowed';

Line 736: ,p_object_version_number in irc_rec_team_members.object_version_number%type

732: Procedure chk_delete_allowed
733: (p_delete_allowed in irc_rec_team_members.delete_allowed%type
734: ,p_start_date in irc_rec_team_members.start_date%type
735: ,p_rec_team_member_id in irc_rec_team_members.rec_team_member_id%type
736: ,p_object_version_number in irc_rec_team_members.object_version_number%type
737: ) IS
738: --
739: l_proc varchar2(72) := g_package || 'chk_delete_allowed';
740: l_var boolean;

Line 776: (p_associated_column1 => 'IRC_REC_TEAM_MEMBERS.DELETE_ALLOWED'

772: --
773: exception
774: when app_exception.application_exception then
775: if hr_multi_message.exception_add
776: (p_associated_column1 => 'IRC_REC_TEAM_MEMBERS.DELETE_ALLOWED'
777: ) then
778: hr_utility.set_location(' Leaving:'||l_proc, 50);
779: raise;
780: end if;

Line 801: -- If the person_id ,vacancy_id is not existing in IRC_REC_TEAM_MEMBERS

797: -- p_person_id
798: -- p_vacancy_id
799: --
800: -- Post Success:
801: -- If the person_id ,vacancy_id is not existing in IRC_REC_TEAM_MEMBERS
802: -- then continue.
803: --
804: -- Post Failure:
805: -- If the person_id, vacancy_id is present in IRC_REC_TEAM_MEMBERS

Line 805: -- If the person_id, vacancy_id is present in IRC_REC_TEAM_MEMBERS

801: -- If the person_id ,vacancy_id is not existing in IRC_REC_TEAM_MEMBERS
802: -- then continue.
803: --
804: -- Post Failure:
805: -- If the person_id, vacancy_id is present in IRC_REC_TEAM_MEMBERS
806: -- then throw an error indicating the same.
807: --
808: -- Access Status:
809: -- Internal Row Handler Use Only.

Line 813: (p_person_id in irc_rec_team_members.person_id%type

809: -- Internal Row Handler Use Only.
810: --
811: -- ----------------------------------------------------------------------------
812: Procedure chk_rec_team_member
813: (p_person_id in irc_rec_team_members.person_id%type
814: ,p_vacancy_id in irc_rec_team_members.vacancy_id%type
815: ) is
816: --
817: l_proc varchar2(72) := g_package||'chk_rec_team_member';

Line 814: ,p_vacancy_id in irc_rec_team_members.vacancy_id%type

810: --
811: -- ----------------------------------------------------------------------------
812: Procedure chk_rec_team_member
813: (p_person_id in irc_rec_team_members.person_id%type
814: ,p_vacancy_id in irc_rec_team_members.vacancy_id%type
815: ) is
816: --
817: l_proc varchar2(72) := g_package||'chk_rec_team_member';
818: l_var varchar2(1);

Line 822: from irc_rec_team_members

818: l_var varchar2(1);
819: --
820: cursor csr_rec_team_member is
821: select null
822: from irc_rec_team_members
823: where person_id = p_person_id
824: and vacancy_id = p_vacancy_id;
825: --
826: Begin

Line 832: (p_check_column1 => 'IRC_REC_TEAM_MEMBERS.PERSON_ID'

828: hr_utility.set_location(' Entering:'||l_proc,10);
829: --
830:
831: if hr_multi_message.no_exclusive_error
832: (p_check_column1 => 'IRC_REC_TEAM_MEMBERS.PERSON_ID'
833: ,p_check_column2 => 'IRC_REC_TEAM_MEMBERS.VACANCY_ID'
834: ) then
835: open csr_rec_team_member;
836: fetch csr_rec_team_member into l_var;

Line 833: ,p_check_column2 => 'IRC_REC_TEAM_MEMBERS.VACANCY_ID'

829: --
830:
831: if hr_multi_message.no_exclusive_error
832: (p_check_column1 => 'IRC_REC_TEAM_MEMBERS.PERSON_ID'
833: ,p_check_column2 => 'IRC_REC_TEAM_MEMBERS.VACANCY_ID'
834: ) then
835: open csr_rec_team_member;
836: fetch csr_rec_team_member into l_var;
837: hr_utility.set_location(l_proc, 20);

Line 852: (p_associated_column1 => 'IRC_REC_TEAM_MEMBERS.PERSON_ID'

848: --
849: exception
850: when app_exception.application_exception then
851: if hr_multi_message.exception_add
852: (p_associated_column1 => 'IRC_REC_TEAM_MEMBERS.PERSON_ID'
853: ,p_associated_column2 => 'IRC_REC_TEAM_MEMBERS.VACANCY_ID'
854: ) then
855: --
856: hr_utility.set_location(' Leaving:'||l_proc,50);

Line 853: ,p_associated_column2 => 'IRC_REC_TEAM_MEMBERS.VACANCY_ID'

849: exception
850: when app_exception.application_exception then
851: if hr_multi_message.exception_add
852: (p_associated_column1 => 'IRC_REC_TEAM_MEMBERS.PERSON_ID'
853: ,p_associated_column2 => 'IRC_REC_TEAM_MEMBERS.VACANCY_ID'
854: ) then
855: --
856: hr_utility.set_location(' Leaving:'||l_proc,50);
857: --