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.IRC_IOF_BUS dependencies on IRC_OFFERS

Line 31: , irc_offers iof

27: --
28: cursor csr_sec_grp is
29: select pbg.security_group_id
30: from per_business_groups pbg
31: , irc_offers iof
32: , per_all_vacancies vac
33: where iof.offer_id = p_offer_id
34: and vac.vacancy_id = iof.vacancy_id
35: and pbg.business_group_id = vac.business_group_id;

Line 95: , irc_offers iof

91: --
92: cursor csr_leg_code is
93: select pbg.legislation_code
94: from per_business_groups_perf pbg
95: , irc_offers iof
96: , per_all_vacancies vac
97: where iof.offer_id = p_offer_id
98: and iof.vacancy_id = vac.vacancy_id
99: and pbg.business_group_id = vac.business_group_id;

Line 265: ,p_descflex_name => 'IRC_OFFERS'

261: -- b) During insert.
262: --
263: hr_dflex_utility.ins_or_upd_descflex_attribs
264: (p_appl_short_name => 'PER'
265: ,p_descflex_name => 'IRC_OFFERS'
266: ,p_attribute_category => p_rec.attribute_category
267: ,p_attribute1_name => 'ATTRIBUTE1'
268: ,p_attribute1_value => p_rec.attribute1
269: ,p_attribute2_name => 'ATTRIBUTE2'

Line 457: ,p_applicant_assignment_id in irc_offers.applicant_assignment_id%TYPE

453: -- {End Of Comments}
454: -- ----------------------------------------------------------------------------
455: Procedure chk_applicant_assignment_id
456: (p_effective_date in date
457: ,p_applicant_assignment_id in irc_offers.applicant_assignment_id%TYPE
458: ) IS
459: --
460: l_proc varchar2(72) := g_package || 'chk_applicant_assignment_id';
461: l_applicant_assignment_id number;

Line 503: (p_associated_column1 => 'IRC_OFFERS.APPLICANT_ASSIGNMENT_ID'

499: hr_utility.set_location(' Leaving:'||l_proc,30);
500: exception
501: when app_exception.application_exception then
502: if hr_multi_message.exception_add
503: (p_associated_column1 => 'IRC_OFFERS.APPLICANT_ASSIGNMENT_ID'
504: ) then
505: hr_utility.set_location(' Leaving:'|| l_proc, 40);
506: raise;
507: end if;

Line 535: (p_offer_assignment_id in irc_offers.offer_assignment_id%TYPE

531: --
532: -- {End Of Comments}
533: -- ----------------------------------------------------------------------------
534: Procedure chk_offer_assignment_id
535: (p_offer_assignment_id in irc_offers.offer_assignment_id%TYPE
536: ) IS
537: --
538: l_proc varchar2(72) := g_package || 'chk_offer_assignment_id';
539: l_offer_assignment_id number;

Line 550: from irc_offers

546: and assignment_type = 'O';
547: --
548: cursor csr_offer_assigment_exists is
549: select 1
550: from irc_offers
551: where offer_assignment_id = p_offer_assignment_id;
552: --
553: Begin
554: hr_utility.set_location('Entering:'||l_proc,10);

Line 557: p_check_column1 => 'IRC_OFFERS.APPLICANT_ASSIGNMENT_ID'

553: Begin
554: hr_utility.set_location('Entering:'||l_proc,10);
555: --
556: if hr_multi_message.no_exclusive_error(
557: p_check_column1 => 'IRC_OFFERS.APPLICANT_ASSIGNMENT_ID'
558: ) then
559: --
560: hr_api.mandatory_arg_error
561: (p_api_name => l_proc

Line 602: (p_associated_column1 => 'IRC_OFFERS.OFFER_ASSIGNMENT_ID'

598: hr_utility.set_location(' Leaving:'||l_proc,30);
599: exception
600: when app_exception.application_exception then
601: if hr_multi_message.exception_add
602: (p_associated_column1 => 'IRC_OFFERS.OFFER_ASSIGNMENT_ID'
603: ) then
604: hr_utility.set_location(' Leaving:'|| l_proc, 40);
605: raise;
606: end if;

Line 634: (p_vacancy_id out nocopy irc_offers.vacancy_id%TYPE

630: --
631: -- {End Of Comments}
632: -- ----------------------------------------------------------------------------
633: Procedure set_vacancy_id
634: (p_vacancy_id out nocopy irc_offers.vacancy_id%TYPE
635: ,p_effective_date in date
636: ,p_applicant_assignment_id in irc_offers.applicant_assignment_id%TYPE
637: ) IS
638: --

Line 636: ,p_applicant_assignment_id in irc_offers.applicant_assignment_id%TYPE

632: -- ----------------------------------------------------------------------------
633: Procedure set_vacancy_id
634: (p_vacancy_id out nocopy irc_offers.vacancy_id%TYPE
635: ,p_effective_date in date
636: ,p_applicant_assignment_id in irc_offers.applicant_assignment_id%TYPE
637: ) IS
638: --
639: l_proc varchar2(72) := g_package || 'set_vacancy_id';
640: l_vacancy_id irc_offers.vacancy_id%TYPE;

Line 640: l_vacancy_id irc_offers.vacancy_id%TYPE;

636: ,p_applicant_assignment_id in irc_offers.applicant_assignment_id%TYPE
637: ) IS
638: --
639: l_proc varchar2(72) := g_package || 'set_vacancy_id';
640: l_vacancy_id irc_offers.vacancy_id%TYPE;
641: --
642: cursor csr_appl_vac_id is
643: select paaf.vacancy_id
644: from per_all_assignments_f paaf

Line 654: p_check_column1 => 'IRC_OFFERS.APPLICANT_ASSIGNMENT_ID'

650: Begin
651: hr_utility.set_location('Entering:'||l_proc,10);
652: --
653: if hr_multi_message.no_exclusive_error(
654: p_check_column1 => 'IRC_OFFERS.APPLICANT_ASSIGNMENT_ID'
655: ,p_check_column2 => 'IRC_OFFERS.OFFER_ASSIGNMENT_ID'
656: ) then
657: --
658: -- Select the vacancy_id from Applicant assignment record.

Line 655: ,p_check_column2 => 'IRC_OFFERS.OFFER_ASSIGNMENT_ID'

651: hr_utility.set_location('Entering:'||l_proc,10);
652: --
653: if hr_multi_message.no_exclusive_error(
654: p_check_column1 => 'IRC_OFFERS.APPLICANT_ASSIGNMENT_ID'
655: ,p_check_column2 => 'IRC_OFFERS.OFFER_ASSIGNMENT_ID'
656: ) then
657: --
658: -- Select the vacancy_id from Applicant assignment record.
659: --

Line 683: (p_associated_column1 => 'IRC_OFFERS.VACANCY_ID'

679: hr_utility.set_location(' Leaving:'||l_proc,40);
680: exception
681: when app_exception.application_exception then
682: if hr_multi_message.exception_add
683: (p_associated_column1 => 'IRC_OFFERS.VACANCY_ID'
684: ) then
685: hr_utility.set_location(' Leaving:'|| l_proc, 50);
686: raise;
687: end if;

Line 719: (p_vacancy_id in irc_offers.vacancy_id%TYPE

715: --
716: -- {End Of Comments}
717: -- ----------------------------------------------------------------------------
718: Procedure chk_offers_exceeds_openings
719: (p_vacancy_id in irc_offers.vacancy_id%TYPE
720: ,p_offer_status in irc_offers.offer_status%TYPE
721: ,p_offer_id in irc_offers.offer_id%TYPE
722: ) IS
723: --

Line 720: ,p_offer_status in irc_offers.offer_status%TYPE

716: -- {End Of Comments}
717: -- ----------------------------------------------------------------------------
718: Procedure chk_offers_exceeds_openings
719: (p_vacancy_id in irc_offers.vacancy_id%TYPE
720: ,p_offer_status in irc_offers.offer_status%TYPE
721: ,p_offer_id in irc_offers.offer_id%TYPE
722: ) IS
723: --
724: l_proc varchar2(72) := g_package || 'chk_offers_exceeds_openings';

Line 721: ,p_offer_id in irc_offers.offer_id%TYPE

717: -- ----------------------------------------------------------------------------
718: Procedure chk_offers_exceeds_openings
719: (p_vacancy_id in irc_offers.vacancy_id%TYPE
720: ,p_offer_status in irc_offers.offer_status%TYPE
721: ,p_offer_id in irc_offers.offer_id%TYPE
722: ) IS
723: --
724: l_proc varchar2(72) := g_package || 'chk_offers_exceeds_openings';
725: l_offer_count number(15);

Line 726: l_prev_offer_status irc_offers.offer_status%TYPE;

722: ) IS
723: --
724: l_proc varchar2(72) := g_package || 'chk_offers_exceeds_openings';
725: l_offer_count number(15);
726: l_prev_offer_status irc_offers.offer_status%TYPE;
727: l_prev_change_reason irc_offer_status_history.change_reason%TYPE;
728: l_prev_to_prev_offer_status irc_offers.offer_status%TYPE;
729: l_prev_to_prev_change_reason irc_offer_status_history.change_reason%TYPE;
730: l_chk_vacancy_count boolean := false;

Line 728: l_prev_to_prev_offer_status irc_offers.offer_status%TYPE;

724: l_proc varchar2(72) := g_package || 'chk_offers_exceeds_openings';
725: l_offer_count number(15);
726: l_prev_offer_status irc_offers.offer_status%TYPE;
727: l_prev_change_reason irc_offer_status_history.change_reason%TYPE;
728: l_prev_to_prev_offer_status irc_offers.offer_status%TYPE;
729: l_prev_to_prev_change_reason irc_offer_status_history.change_reason%TYPE;
730: l_chk_vacancy_count boolean := false;
731: --
732: cursor csr_vacancy_opening_count is

Line 764: from irc_offers

760: );
761: --
762: cursor csr_prev_offer_status is
763: select offer_status
764: from irc_offers
765: where offer_id = p_offer_id;
766: --
767: cursor csr_offer_count is
768: select count(*)

Line 769: from irc_offers iof

765: where offer_id = p_offer_id;
766: --
767: cursor csr_offer_count is
768: select count(*)
769: from irc_offers iof
770: ,per_all_vacancies pav
771: ,irc_offer_status_history iosh
772: where pav.vacancy_id = p_vacancy_id
773: and iof.vacancy_id = pav.vacancy_id

Line 855: p_check_column1 => 'IRC_OFFERS.APPLICANT_ASSIGNMENT_ID'

851: if l_chk_vacancy_count = true
852: then
853: --
854: if hr_multi_message.no_exclusive_error(
855: p_check_column1 => 'IRC_OFFERS.APPLICANT_ASSIGNMENT_ID'
856: ,p_check_column2 => 'IRC_OFFERS.OFFER_ASSIGNMENT_ID'
857: ,p_check_column3 => 'IRC_OFFERS.VACANCY_ID'
858: )
859: then

Line 856: ,p_check_column2 => 'IRC_OFFERS.OFFER_ASSIGNMENT_ID'

852: then
853: --
854: if hr_multi_message.no_exclusive_error(
855: p_check_column1 => 'IRC_OFFERS.APPLICANT_ASSIGNMENT_ID'
856: ,p_check_column2 => 'IRC_OFFERS.OFFER_ASSIGNMENT_ID'
857: ,p_check_column3 => 'IRC_OFFERS.VACANCY_ID'
858: )
859: then
860: --

Line 857: ,p_check_column3 => 'IRC_OFFERS.VACANCY_ID'

853: --
854: if hr_multi_message.no_exclusive_error(
855: p_check_column1 => 'IRC_OFFERS.APPLICANT_ASSIGNMENT_ID'
856: ,p_check_column2 => 'IRC_OFFERS.OFFER_ASSIGNMENT_ID'
857: ,p_check_column3 => 'IRC_OFFERS.VACANCY_ID'
858: )
859: then
860: --
861: hr_api.mandatory_arg_error

Line 895: (p_associated_column1 => 'IRC_OFFERS.VACANCY_ID'

891: hr_utility.set_location(' Leaving:'||l_proc,30);
892: exception
893: when app_exception.application_exception then
894: if hr_multi_message.exception_add
895: (p_associated_column1 => 'IRC_OFFERS.VACANCY_ID'
896: ) then
897: hr_utility.set_location(' Leaving:'|| l_proc, 40);
898: raise;
899: end if;

Line 928: (p_respondent_id in irc_offers.respondent_id%TYPE

924: --
925: -- {End Of Comments}
926: -- ----------------------------------------------------------------------------
927: Procedure chk_respondent_id
928: (p_respondent_id in irc_offers.respondent_id%TYPE
929: ,p_offer_id in irc_offers.offer_id%TYPE
930: ,p_object_version_number in irc_offers.object_version_number%TYPE
931: ) IS
932: --

Line 929: ,p_offer_id in irc_offers.offer_id%TYPE

925: -- {End Of Comments}
926: -- ----------------------------------------------------------------------------
927: Procedure chk_respondent_id
928: (p_respondent_id in irc_offers.respondent_id%TYPE
929: ,p_offer_id in irc_offers.offer_id%TYPE
930: ,p_object_version_number in irc_offers.object_version_number%TYPE
931: ) IS
932: --
933: l_proc varchar2(72) := g_package || 'chk_respondent_id';

Line 930: ,p_object_version_number in irc_offers.object_version_number%TYPE

926: -- ----------------------------------------------------------------------------
927: Procedure chk_respondent_id
928: (p_respondent_id in irc_offers.respondent_id%TYPE
929: ,p_offer_id in irc_offers.offer_id%TYPE
930: ,p_object_version_number in irc_offers.object_version_number%TYPE
931: ) IS
932: --
933: l_proc varchar2(72) := g_package || 'chk_respondent_id';
934: l_api_updating boolean;

Line 946: p_check_column1 => 'IRC_OFFERS.APPLICANT_ASSIGNMENT_ID'

942: Begin
943: hr_utility.set_location('Entering:'||l_proc,10);
944: --
945: if hr_multi_message.no_exclusive_error(
946: p_check_column1 => 'IRC_OFFERS.APPLICANT_ASSIGNMENT_ID'
947: ,p_check_column2 => 'IRC_OFFERS.OFFER_ASSIGNMENT_ID'
948: ,p_check_column3 => 'IRC_OFFERS.VACANCY_ID'
949: ) then
950: --

Line 947: ,p_check_column2 => 'IRC_OFFERS.OFFER_ASSIGNMENT_ID'

943: hr_utility.set_location('Entering:'||l_proc,10);
944: --
945: if hr_multi_message.no_exclusive_error(
946: p_check_column1 => 'IRC_OFFERS.APPLICANT_ASSIGNMENT_ID'
947: ,p_check_column2 => 'IRC_OFFERS.OFFER_ASSIGNMENT_ID'
948: ,p_check_column3 => 'IRC_OFFERS.VACANCY_ID'
949: ) then
950: --
951: -- Only proceed with validation if :

Line 948: ,p_check_column3 => 'IRC_OFFERS.VACANCY_ID'

944: --
945: if hr_multi_message.no_exclusive_error(
946: p_check_column1 => 'IRC_OFFERS.APPLICANT_ASSIGNMENT_ID'
947: ,p_check_column2 => 'IRC_OFFERS.OFFER_ASSIGNMENT_ID'
948: ,p_check_column3 => 'IRC_OFFERS.VACANCY_ID'
949: ) then
950: --
951: -- Only proceed with validation if :
952: -- a) The current g_old_rec is current and

Line 994: (p_associated_column1 => 'IRC_OFFERS.RESPONDENT_ID'

990: --
991: exception
992: when app_exception.application_exception then
993: if hr_multi_message.exception_add
994: (p_associated_column1 => 'IRC_OFFERS.RESPONDENT_ID'
995: ) then
996: hr_utility.set_location(' Leaving:'|| l_proc, 60);
997: raise;
998: end if;

Line 1030: (p_expiry_date in out nocopy irc_offers.expiry_date%TYPE

1026: --
1027: -- {End Of Comments}
1028: -- ----------------------------------------------------------------------------
1029: Procedure chk_expiry_date
1030: (p_expiry_date in out nocopy irc_offers.expiry_date%TYPE
1031: ,p_offer_status in irc_offers.offer_status%TYPE
1032: ,p_offer_id in irc_offers.offer_id%TYPE
1033: ,p_offer_postal_service in irc_offers.offer_postal_service%TYPE
1034: ,p_offer_letter_tracking_code in irc_offers.offer_letter_tracking_code%TYPE

Line 1031: ,p_offer_status in irc_offers.offer_status%TYPE

1027: -- {End Of Comments}
1028: -- ----------------------------------------------------------------------------
1029: Procedure chk_expiry_date
1030: (p_expiry_date in out nocopy irc_offers.expiry_date%TYPE
1031: ,p_offer_status in irc_offers.offer_status%TYPE
1032: ,p_offer_id in irc_offers.offer_id%TYPE
1033: ,p_offer_postal_service in irc_offers.offer_postal_service%TYPE
1034: ,p_offer_letter_tracking_code in irc_offers.offer_letter_tracking_code%TYPE
1035: ,p_offer_shipping_date in irc_offers.offer_shipping_date%TYPE

Line 1032: ,p_offer_id in irc_offers.offer_id%TYPE

1028: -- ----------------------------------------------------------------------------
1029: Procedure chk_expiry_date
1030: (p_expiry_date in out nocopy irc_offers.expiry_date%TYPE
1031: ,p_offer_status in irc_offers.offer_status%TYPE
1032: ,p_offer_id in irc_offers.offer_id%TYPE
1033: ,p_offer_postal_service in irc_offers.offer_postal_service%TYPE
1034: ,p_offer_letter_tracking_code in irc_offers.offer_letter_tracking_code%TYPE
1035: ,p_offer_shipping_date in irc_offers.offer_shipping_date%TYPE
1036: ,p_effective_date date

Line 1033: ,p_offer_postal_service in irc_offers.offer_postal_service%TYPE

1029: Procedure chk_expiry_date
1030: (p_expiry_date in out nocopy irc_offers.expiry_date%TYPE
1031: ,p_offer_status in irc_offers.offer_status%TYPE
1032: ,p_offer_id in irc_offers.offer_id%TYPE
1033: ,p_offer_postal_service in irc_offers.offer_postal_service%TYPE
1034: ,p_offer_letter_tracking_code in irc_offers.offer_letter_tracking_code%TYPE
1035: ,p_offer_shipping_date in irc_offers.offer_shipping_date%TYPE
1036: ,p_effective_date date
1037: ) IS

Line 1034: ,p_offer_letter_tracking_code in irc_offers.offer_letter_tracking_code%TYPE

1030: (p_expiry_date in out nocopy irc_offers.expiry_date%TYPE
1031: ,p_offer_status in irc_offers.offer_status%TYPE
1032: ,p_offer_id in irc_offers.offer_id%TYPE
1033: ,p_offer_postal_service in irc_offers.offer_postal_service%TYPE
1034: ,p_offer_letter_tracking_code in irc_offers.offer_letter_tracking_code%TYPE
1035: ,p_offer_shipping_date in irc_offers.offer_shipping_date%TYPE
1036: ,p_effective_date date
1037: ) IS
1038: --

Line 1035: ,p_offer_shipping_date in irc_offers.offer_shipping_date%TYPE

1031: ,p_offer_status in irc_offers.offer_status%TYPE
1032: ,p_offer_id in irc_offers.offer_id%TYPE
1033: ,p_offer_postal_service in irc_offers.offer_postal_service%TYPE
1034: ,p_offer_letter_tracking_code in irc_offers.offer_letter_tracking_code%TYPE
1035: ,p_offer_shipping_date in irc_offers.offer_shipping_date%TYPE
1036: ,p_effective_date date
1037: ) IS
1038: --
1039: l_proc varchar2(72) := g_package || 'chk_expiry_date';

Line 1042: l_expiry_date irc_offers.expiry_date%TYPE := p_expiry_date;

1038: --
1039: l_proc varchar2(72) := g_package || 'chk_expiry_date';
1040: l_offer_duration_value varchar2(30);
1041: l_offer_duration_measurement varchar2(30);
1042: l_expiry_date irc_offers.expiry_date%TYPE := p_expiry_date;
1043: l_prev_expiry_date irc_offers.expiry_date%TYPE := irc_iof_shd.g_old_rec.expiry_date;
1044: l_prev_offer_postal_service irc_offers.offer_postal_service%TYPE := irc_iof_shd.g_old_rec.offer_postal_service;
1045: l_prev_letter_tracking_code irc_offers.offer_letter_tracking_code%TYPE := irc_iof_shd.g_old_rec.offer_letter_tracking_code;
1046: l_prev_offer_shipping_date irc_offers.offer_shipping_date%TYPE := irc_iof_shd.g_old_rec.offer_shipping_date;

Line 1043: l_prev_expiry_date irc_offers.expiry_date%TYPE := irc_iof_shd.g_old_rec.expiry_date;

1039: l_proc varchar2(72) := g_package || 'chk_expiry_date';
1040: l_offer_duration_value varchar2(30);
1041: l_offer_duration_measurement varchar2(30);
1042: l_expiry_date irc_offers.expiry_date%TYPE := p_expiry_date;
1043: l_prev_expiry_date irc_offers.expiry_date%TYPE := irc_iof_shd.g_old_rec.expiry_date;
1044: l_prev_offer_postal_service irc_offers.offer_postal_service%TYPE := irc_iof_shd.g_old_rec.offer_postal_service;
1045: l_prev_letter_tracking_code irc_offers.offer_letter_tracking_code%TYPE := irc_iof_shd.g_old_rec.offer_letter_tracking_code;
1046: l_prev_offer_shipping_date irc_offers.offer_shipping_date%TYPE := irc_iof_shd.g_old_rec.offer_shipping_date;
1047: l_effective_date date;

Line 1044: l_prev_offer_postal_service irc_offers.offer_postal_service%TYPE := irc_iof_shd.g_old_rec.offer_postal_service;

1040: l_offer_duration_value varchar2(30);
1041: l_offer_duration_measurement varchar2(30);
1042: l_expiry_date irc_offers.expiry_date%TYPE := p_expiry_date;
1043: l_prev_expiry_date irc_offers.expiry_date%TYPE := irc_iof_shd.g_old_rec.expiry_date;
1044: l_prev_offer_postal_service irc_offers.offer_postal_service%TYPE := irc_iof_shd.g_old_rec.offer_postal_service;
1045: l_prev_letter_tracking_code irc_offers.offer_letter_tracking_code%TYPE := irc_iof_shd.g_old_rec.offer_letter_tracking_code;
1046: l_prev_offer_shipping_date irc_offers.offer_shipping_date%TYPE := irc_iof_shd.g_old_rec.offer_shipping_date;
1047: l_effective_date date;
1048: --

Line 1045: l_prev_letter_tracking_code irc_offers.offer_letter_tracking_code%TYPE := irc_iof_shd.g_old_rec.offer_letter_tracking_code;

1041: l_offer_duration_measurement varchar2(30);
1042: l_expiry_date irc_offers.expiry_date%TYPE := p_expiry_date;
1043: l_prev_expiry_date irc_offers.expiry_date%TYPE := irc_iof_shd.g_old_rec.expiry_date;
1044: l_prev_offer_postal_service irc_offers.offer_postal_service%TYPE := irc_iof_shd.g_old_rec.offer_postal_service;
1045: l_prev_letter_tracking_code irc_offers.offer_letter_tracking_code%TYPE := irc_iof_shd.g_old_rec.offer_letter_tracking_code;
1046: l_prev_offer_shipping_date irc_offers.offer_shipping_date%TYPE := irc_iof_shd.g_old_rec.offer_shipping_date;
1047: l_effective_date date;
1048: --
1049: Begin

Line 1046: l_prev_offer_shipping_date irc_offers.offer_shipping_date%TYPE := irc_iof_shd.g_old_rec.offer_shipping_date;

1042: l_expiry_date irc_offers.expiry_date%TYPE := p_expiry_date;
1043: l_prev_expiry_date irc_offers.expiry_date%TYPE := irc_iof_shd.g_old_rec.expiry_date;
1044: l_prev_offer_postal_service irc_offers.offer_postal_service%TYPE := irc_iof_shd.g_old_rec.offer_postal_service;
1045: l_prev_letter_tracking_code irc_offers.offer_letter_tracking_code%TYPE := irc_iof_shd.g_old_rec.offer_letter_tracking_code;
1046: l_prev_offer_shipping_date irc_offers.offer_shipping_date%TYPE := irc_iof_shd.g_old_rec.offer_shipping_date;
1047: l_effective_date date;
1048: --
1049: Begin
1050: hr_utility.set_location('Entering:'||l_proc,10);

Line 1053: p_check_column1 => 'IRC_OFFERS.APPLICANT_ASSIGNMENT_ID'

1049: Begin
1050: hr_utility.set_location('Entering:'||l_proc,10);
1051: --
1052: if hr_multi_message.no_exclusive_error(
1053: p_check_column1 => 'IRC_OFFERS.APPLICANT_ASSIGNMENT_ID'
1054: ,p_check_column2 => 'IRC_OFFERS.OFFER_ASSIGNMENT_ID'
1055: ,p_check_column3 => 'IRC_OFFERS.VACANCY_ID'
1056: ) then
1057: --

Line 1054: ,p_check_column2 => 'IRC_OFFERS.OFFER_ASSIGNMENT_ID'

1050: hr_utility.set_location('Entering:'||l_proc,10);
1051: --
1052: if hr_multi_message.no_exclusive_error(
1053: p_check_column1 => 'IRC_OFFERS.APPLICANT_ASSIGNMENT_ID'
1054: ,p_check_column2 => 'IRC_OFFERS.OFFER_ASSIGNMENT_ID'
1055: ,p_check_column3 => 'IRC_OFFERS.VACANCY_ID'
1056: ) then
1057: --
1058: if p_offer_status = 'EXTENDED'

Line 1055: ,p_check_column3 => 'IRC_OFFERS.VACANCY_ID'

1051: --
1052: if hr_multi_message.no_exclusive_error(
1053: p_check_column1 => 'IRC_OFFERS.APPLICANT_ASSIGNMENT_ID'
1054: ,p_check_column2 => 'IRC_OFFERS.OFFER_ASSIGNMENT_ID'
1055: ,p_check_column3 => 'IRC_OFFERS.VACANCY_ID'
1056: ) then
1057: --
1058: if p_offer_status = 'EXTENDED'
1059: then

Line 1158: (p_associated_column1 => 'IRC_OFFERS.EXPIRY_DATE'

1154: --
1155: exception
1156: when app_exception.application_exception then
1157: if hr_multi_message.exception_add
1158: (p_associated_column1 => 'IRC_OFFERS.EXPIRY_DATE'
1159: ) then
1160: hr_utility.set_location(' Leaving:'|| l_proc, 80);
1161: raise;
1162: end if;

Line 1196: (p_address_id in out nocopy irc_offers.address_id%TYPE

1192: --
1193: -- {End Of Comments}
1194: -- ----------------------------------------------------------------------------
1195: Procedure set_address_id
1196: (p_address_id in out nocopy irc_offers.address_id%TYPE
1197: ,p_applicant_assignment_id in irc_offers.applicant_assignment_id%TYPE
1198: ,p_effective_date date
1199: ) IS
1200: --

Line 1197: ,p_applicant_assignment_id in irc_offers.applicant_assignment_id%TYPE

1193: -- {End Of Comments}
1194: -- ----------------------------------------------------------------------------
1195: Procedure set_address_id
1196: (p_address_id in out nocopy irc_offers.address_id%TYPE
1197: ,p_applicant_assignment_id in irc_offers.applicant_assignment_id%TYPE
1198: ,p_effective_date date
1199: ) IS
1200: --
1201: l_proc varchar2(72) := g_package || 'set_address_id';

Line 1202: l_rec_address_id irc_offers.address_id%TYPE;

1198: ,p_effective_date date
1199: ) IS
1200: --
1201: l_proc varchar2(72) := g_package || 'set_address_id';
1202: l_rec_address_id irc_offers.address_id%TYPE;
1203: --
1204: cursor csr_rec_address_id is
1205: select adr.address_id
1206: from per_addresses adr

Line 1219: p_check_column1 => 'IRC_OFFERS.APPLICANT_ASSIGNMENT_ID'

1215: Begin
1216: hr_utility.set_location('Entering:'||l_proc,10);
1217: --
1218: if hr_multi_message.no_exclusive_error(
1219: p_check_column1 => 'IRC_OFFERS.APPLICANT_ASSIGNMENT_ID'
1220: ,p_check_column2 => 'IRC_OFFERS.OFFER_ASSIGNMENT_ID'
1221: ,p_check_column3 => 'IRC_OFFERS.VACANCY_ID'
1222: ) then
1223: --

Line 1220: ,p_check_column2 => 'IRC_OFFERS.OFFER_ASSIGNMENT_ID'

1216: hr_utility.set_location('Entering:'||l_proc,10);
1217: --
1218: if hr_multi_message.no_exclusive_error(
1219: p_check_column1 => 'IRC_OFFERS.APPLICANT_ASSIGNMENT_ID'
1220: ,p_check_column2 => 'IRC_OFFERS.OFFER_ASSIGNMENT_ID'
1221: ,p_check_column3 => 'IRC_OFFERS.VACANCY_ID'
1222: ) then
1223: --
1224: hr_utility.set_location(l_proc,20);

Line 1221: ,p_check_column3 => 'IRC_OFFERS.VACANCY_ID'

1217: --
1218: if hr_multi_message.no_exclusive_error(
1219: p_check_column1 => 'IRC_OFFERS.APPLICANT_ASSIGNMENT_ID'
1220: ,p_check_column2 => 'IRC_OFFERS.OFFER_ASSIGNMENT_ID'
1221: ,p_check_column3 => 'IRC_OFFERS.VACANCY_ID'
1222: ) then
1223: --
1224: hr_utility.set_location(l_proc,20);
1225: --

Line 1252: (p_associated_column1 => 'IRC_OFFERS.ADDRESS_ID'

1248: --
1249: exception
1250: when app_exception.application_exception then
1251: if hr_multi_message.exception_add
1252: (p_associated_column1 => 'IRC_OFFERS.ADDRESS_ID'
1253: ) then
1254: hr_utility.set_location(' Leaving:'|| l_proc, 50);
1255: raise;
1256: end if;

Line 1285: (p_address_id in irc_offers.address_id%TYPE

1281: --
1282: -- {End Of Comments}
1283: -- ----------------------------------------------------------------------------
1284: Procedure chk_address_id
1285: (p_address_id in irc_offers.address_id%TYPE
1286: ,p_offer_id in irc_offers.offer_id%TYPE
1287: ,p_object_version_number in irc_offers.object_version_number%TYPE
1288: ) IS
1289: --

Line 1286: ,p_offer_id in irc_offers.offer_id%TYPE

1282: -- {End Of Comments}
1283: -- ----------------------------------------------------------------------------
1284: Procedure chk_address_id
1285: (p_address_id in irc_offers.address_id%TYPE
1286: ,p_offer_id in irc_offers.offer_id%TYPE
1287: ,p_object_version_number in irc_offers.object_version_number%TYPE
1288: ) IS
1289: --
1290: l_proc varchar2(72) := g_package || 'chk_address_id';

Line 1287: ,p_object_version_number in irc_offers.object_version_number%TYPE

1283: -- ----------------------------------------------------------------------------
1284: Procedure chk_address_id
1285: (p_address_id in irc_offers.address_id%TYPE
1286: ,p_offer_id in irc_offers.offer_id%TYPE
1287: ,p_object_version_number in irc_offers.object_version_number%TYPE
1288: ) IS
1289: --
1290: l_proc varchar2(72) := g_package || 'chk_address_id';
1291: l_address_id number;

Line 1303: p_check_column1 => 'IRC_OFFERS.APPLICANT_ASSIGNMENT_ID'

1299: Begin
1300: hr_utility.set_location('Entering:'||l_proc,10);
1301: --
1302: if hr_multi_message.no_exclusive_error(
1303: p_check_column1 => 'IRC_OFFERS.APPLICANT_ASSIGNMENT_ID'
1304: ,p_check_column2 => 'IRC_OFFERS.OFFER_ASSIGNMENT_ID'
1305: ,p_check_column3 => 'IRC_OFFERS.VACANCY_ID'
1306: ) then
1307: --

Line 1304: ,p_check_column2 => 'IRC_OFFERS.OFFER_ASSIGNMENT_ID'

1300: hr_utility.set_location('Entering:'||l_proc,10);
1301: --
1302: if hr_multi_message.no_exclusive_error(
1303: p_check_column1 => 'IRC_OFFERS.APPLICANT_ASSIGNMENT_ID'
1304: ,p_check_column2 => 'IRC_OFFERS.OFFER_ASSIGNMENT_ID'
1305: ,p_check_column3 => 'IRC_OFFERS.VACANCY_ID'
1306: ) then
1307: --
1308: -- Only proceed with validation if :

Line 1305: ,p_check_column3 => 'IRC_OFFERS.VACANCY_ID'

1301: --
1302: if hr_multi_message.no_exclusive_error(
1303: p_check_column1 => 'IRC_OFFERS.APPLICANT_ASSIGNMENT_ID'
1304: ,p_check_column2 => 'IRC_OFFERS.OFFER_ASSIGNMENT_ID'
1305: ,p_check_column3 => 'IRC_OFFERS.VACANCY_ID'
1306: ) then
1307: --
1308: -- Only proceed with validation if :
1309: -- a) The current g_old_rec is current and

Line 1348: (p_associated_column1 => 'IRC_OFFERS.ADDRESS_ID'

1344: --
1345: exception
1346: when app_exception.application_exception then
1347: if hr_multi_message.exception_add
1348: (p_associated_column1 => 'IRC_OFFERS.ADDRESS_ID'
1349: ) then
1350: hr_utility.set_location(' Leaving:'|| l_proc, 50);
1351: raise;
1352: end if;

Line 1385: (p_template_id in out nocopy irc_offers.template_id%TYPE

1381: --
1382: -- {End Of Comments}
1383: -- ----------------------------------------------------------------------------
1384: Procedure chk_template_id
1385: (p_template_id in out nocopy irc_offers.template_id%TYPE
1386: ,p_offer_id in irc_offers.offer_id%TYPE
1387: ,p_object_version_number in irc_offers.object_version_number%TYPE
1388: ,p_effective_date date
1389: ) IS

Line 1386: ,p_offer_id in irc_offers.offer_id%TYPE

1382: -- {End Of Comments}
1383: -- ----------------------------------------------------------------------------
1384: Procedure chk_template_id
1385: (p_template_id in out nocopy irc_offers.template_id%TYPE
1386: ,p_offer_id in irc_offers.offer_id%TYPE
1387: ,p_object_version_number in irc_offers.object_version_number%TYPE
1388: ,p_effective_date date
1389: ) IS
1390: --

Line 1387: ,p_object_version_number in irc_offers.object_version_number%TYPE

1383: -- ----------------------------------------------------------------------------
1384: Procedure chk_template_id
1385: (p_template_id in out nocopy irc_offers.template_id%TYPE
1386: ,p_offer_id in irc_offers.offer_id%TYPE
1387: ,p_object_version_number in irc_offers.object_version_number%TYPE
1388: ,p_effective_date date
1389: ) IS
1390: --
1391: l_proc varchar2(72) := g_package || 'chk_template_id';

Line 1407: ,irc_offers iof

1403: cursor csr_default_template_job is
1404: select ita.template_id
1405: from irc_template_associations ita
1406: ,per_all_assignments_f ppaf
1407: ,irc_offers iof
1408: where ita.default_association = 'Y'
1409: and iof.offer_id = p_offer_id
1410: and iof.offer_assignment_id = ppaf.assignment_id
1411: and ita.job_id = ppaf.job_id;

Line 1417: ,irc_offers iof

1413: cursor csr_default_template_pos is
1414: select ita.template_id
1415: from irc_template_associations ita
1416: ,per_all_assignments_f ppaf
1417: ,irc_offers iof
1418: where ita.default_association = 'Y'
1419: and iof.offer_id = p_offer_id
1420: and iof.offer_assignment_id = ppaf.assignment_id
1421: and ita.position_id = ppaf.position_id;

Line 1427: ,irc_offers iof

1423: cursor csr_default_template_org is
1424: select ita.template_id
1425: from irc_template_associations ita
1426: ,per_all_assignments_f ppaf
1427: ,irc_offers iof
1428: where ita.default_association = 'Y'
1429: and iof.offer_id = p_offer_id
1430: and iof.offer_assignment_id = ppaf.assignment_id
1431: and ita.organization_id = ppaf.organization_id;

Line 1437: p_check_column1 => 'IRC_OFFERS.APPLICANT_ASSIGNMENT_ID'

1433: Begin
1434: hr_utility.set_location('Entering:'||l_proc,10);
1435: --
1436: if hr_multi_message.no_exclusive_error(
1437: p_check_column1 => 'IRC_OFFERS.APPLICANT_ASSIGNMENT_ID'
1438: ,p_check_column2 => 'IRC_OFFERS.OFFER_ASSIGNMENT_ID'
1439: ,p_check_column3 => 'IRC_OFFERS.VACANCY_ID'
1440: ) then
1441: --

Line 1438: ,p_check_column2 => 'IRC_OFFERS.OFFER_ASSIGNMENT_ID'

1434: hr_utility.set_location('Entering:'||l_proc,10);
1435: --
1436: if hr_multi_message.no_exclusive_error(
1437: p_check_column1 => 'IRC_OFFERS.APPLICANT_ASSIGNMENT_ID'
1438: ,p_check_column2 => 'IRC_OFFERS.OFFER_ASSIGNMENT_ID'
1439: ,p_check_column3 => 'IRC_OFFERS.VACANCY_ID'
1440: ) then
1441: --
1442: -- Only proceed with validation if :

Line 1439: ,p_check_column3 => 'IRC_OFFERS.VACANCY_ID'

1435: --
1436: if hr_multi_message.no_exclusive_error(
1437: p_check_column1 => 'IRC_OFFERS.APPLICANT_ASSIGNMENT_ID'
1438: ,p_check_column2 => 'IRC_OFFERS.OFFER_ASSIGNMENT_ID'
1439: ,p_check_column3 => 'IRC_OFFERS.VACANCY_ID'
1440: ) then
1441: --
1442: -- Only proceed with validation if :
1443: -- a) The current g_old_rec is current and

Line 1524: (p_associated_column1 => 'IRC_OFFERS.TEMPLATE_ID'

1520: --
1521: exception
1522: when app_exception.application_exception then
1523: if hr_multi_message.exception_add
1524: (p_associated_column1 => 'IRC_OFFERS.TEMPLATE_ID'
1525: ) then
1526: hr_utility.set_location(' Leaving:'|| l_proc, 100);
1527: raise;
1528: end if;

Line 1553: (p_offer_version out nocopy irc_offers.offer_version%TYPE

1549: --
1550: -- {End Of Comments}
1551: -- ----------------------------------------------------------------------------
1552: Procedure gen_offer_version
1553: (p_offer_version out nocopy irc_offers.offer_version%TYPE
1554: ,p_applicant_assignment_id in irc_offers.applicant_assignment_id%TYPE
1555: ) IS
1556: --
1557: l_proc varchar2(72) := g_package || 'gen_offer_version';

Line 1554: ,p_applicant_assignment_id in irc_offers.applicant_assignment_id%TYPE

1550: -- {End Of Comments}
1551: -- ----------------------------------------------------------------------------
1552: Procedure gen_offer_version
1553: (p_offer_version out nocopy irc_offers.offer_version%TYPE
1554: ,p_applicant_assignment_id in irc_offers.applicant_assignment_id%TYPE
1555: ) IS
1556: --
1557: l_proc varchar2(72) := g_package || 'gen_offer_version';
1558: l_offer_version irc_offers.offer_version%TYPE;

Line 1558: l_offer_version irc_offers.offer_version%TYPE;

1554: ,p_applicant_assignment_id in irc_offers.applicant_assignment_id%TYPE
1555: ) IS
1556: --
1557: l_proc varchar2(72) := g_package || 'gen_offer_version';
1558: l_offer_version irc_offers.offer_version%TYPE;
1559: --
1560: cursor csr_get_offer_version is
1561: select nvl(max(offer_version),0) + 1
1562: from irc_offers

Line 1562: from irc_offers

1558: l_offer_version irc_offers.offer_version%TYPE;
1559: --
1560: cursor csr_get_offer_version is
1561: select nvl(max(offer_version),0) + 1
1562: from irc_offers
1563: where ( applicant_assignment_id = nvl(p_applicant_assignment_id,-1)
1564: OR
1565: applicant_assignment_id = nvl(irc_offers_api.g_src_apl_asg_id,-1)
1566: OR

Line 1565: applicant_assignment_id = nvl(irc_offers_api.g_src_apl_asg_id,-1)

1561: select nvl(max(offer_version),0) + 1
1562: from irc_offers
1563: where ( applicant_assignment_id = nvl(p_applicant_assignment_id,-1)
1564: OR
1565: applicant_assignment_id = nvl(irc_offers_api.g_src_apl_asg_id,-1)
1566: OR
1567: applicant_assignment_id in
1568: (
1569: select tgt_apl_asg_id from per_vac_linked_assignments

Line 1570: where src_apl_asg_id = irc_offers_api.g_src_apl_asg_id

1566: OR
1567: applicant_assignment_id in
1568: (
1569: select tgt_apl_asg_id from per_vac_linked_assignments
1570: where src_apl_asg_id = irc_offers_api.g_src_apl_asg_id
1571: )
1572: );
1573:
1574: --

Line 1597: (p_associated_column1 => 'IRC_OFFERS.OFFER_VERSION'

1593: --
1594: exception
1595: when app_exception.application_exception then
1596: if hr_multi_message.exception_add
1597: (p_associated_column1 => 'IRC_OFFERS.OFFER_VERSION'
1598: ) then
1599: hr_utility.set_location(' Leaving:'|| l_proc, 30);
1600: raise;
1601: end if;

Line 1655: (p_latest_offer in irc_offers.latest_offer%TYPE

1651: --
1652: -- {End Of Comments}
1653: -- ----------------------------------------------------------------------------
1654: Procedure chk_latest_offer
1655: (p_latest_offer in irc_offers.latest_offer%TYPE
1656: ,p_offer_id in irc_offers.offer_id%TYPE
1657: ,p_offer_status in irc_offers.offer_status%TYPE
1658: ,p_applicant_assignment_id in irc_offers.applicant_assignment_id%TYPE
1659: ,p_effective_date in date

Line 1656: ,p_offer_id in irc_offers.offer_id%TYPE

1652: -- {End Of Comments}
1653: -- ----------------------------------------------------------------------------
1654: Procedure chk_latest_offer
1655: (p_latest_offer in irc_offers.latest_offer%TYPE
1656: ,p_offer_id in irc_offers.offer_id%TYPE
1657: ,p_offer_status in irc_offers.offer_status%TYPE
1658: ,p_applicant_assignment_id in irc_offers.applicant_assignment_id%TYPE
1659: ,p_effective_date in date
1660: ,p_object_version_number in irc_offers.object_version_number%TYPE

Line 1657: ,p_offer_status in irc_offers.offer_status%TYPE

1653: -- ----------------------------------------------------------------------------
1654: Procedure chk_latest_offer
1655: (p_latest_offer in irc_offers.latest_offer%TYPE
1656: ,p_offer_id in irc_offers.offer_id%TYPE
1657: ,p_offer_status in irc_offers.offer_status%TYPE
1658: ,p_applicant_assignment_id in irc_offers.applicant_assignment_id%TYPE
1659: ,p_effective_date in date
1660: ,p_object_version_number in irc_offers.object_version_number%TYPE
1661: ) IS

Line 1658: ,p_applicant_assignment_id in irc_offers.applicant_assignment_id%TYPE

1654: Procedure chk_latest_offer
1655: (p_latest_offer in irc_offers.latest_offer%TYPE
1656: ,p_offer_id in irc_offers.offer_id%TYPE
1657: ,p_offer_status in irc_offers.offer_status%TYPE
1658: ,p_applicant_assignment_id in irc_offers.applicant_assignment_id%TYPE
1659: ,p_effective_date in date
1660: ,p_object_version_number in irc_offers.object_version_number%TYPE
1661: ) IS
1662: --

Line 1660: ,p_object_version_number in irc_offers.object_version_number%TYPE

1656: ,p_offer_id in irc_offers.offer_id%TYPE
1657: ,p_offer_status in irc_offers.offer_status%TYPE
1658: ,p_applicant_assignment_id in irc_offers.applicant_assignment_id%TYPE
1659: ,p_effective_date in date
1660: ,p_object_version_number in irc_offers.object_version_number%TYPE
1661: ) IS
1662: --
1663: l_proc varchar2(72) := g_package || 'chk_latest_offer';
1664: l_latest_offer number;

Line 1669: from irc_offers

1665: l_api_updating boolean;
1666: --
1667: cursor csr_latest_offer_upd is
1668: select 1
1669: from irc_offers
1670: where latest_offer = 'Y'
1671: and applicant_assignment_id = p_applicant_assignment_id
1672: and offer_id <> p_offer_id;
1673: --

Line 1676: from irc_offers

1672: and offer_id <> p_offer_id;
1673: --
1674: cursor csr_latest_offer_ins is
1675: select 1
1676: from irc_offers
1677: where latest_offer = 'Y'
1678: and applicant_assignment_id = p_applicant_assignment_id;
1679: --
1680: Begin

Line 1684: p_check_column1 => 'IRC_OFFERS.APPLICANT_ASSIGNMENT_ID'

1680: Begin
1681: hr_utility.set_location('Entering:'||l_proc,10);
1682: --
1683: if hr_multi_message.no_exclusive_error(
1684: p_check_column1 => 'IRC_OFFERS.APPLICANT_ASSIGNMENT_ID'
1685: ,p_check_column2 => 'IRC_OFFERS.OFFER_ASSIGNMENT_ID'
1686: ,p_check_column3 => 'IRC_OFFERS.VACANCY_ID'
1687: ) then
1688: --

Line 1685: ,p_check_column2 => 'IRC_OFFERS.OFFER_ASSIGNMENT_ID'

1681: hr_utility.set_location('Entering:'||l_proc,10);
1682: --
1683: if hr_multi_message.no_exclusive_error(
1684: p_check_column1 => 'IRC_OFFERS.APPLICANT_ASSIGNMENT_ID'
1685: ,p_check_column2 => 'IRC_OFFERS.OFFER_ASSIGNMENT_ID'
1686: ,p_check_column3 => 'IRC_OFFERS.VACANCY_ID'
1687: ) then
1688: --
1689: -- Only proceed with validation if :

Line 1686: ,p_check_column3 => 'IRC_OFFERS.VACANCY_ID'

1682: --
1683: if hr_multi_message.no_exclusive_error(
1684: p_check_column1 => 'IRC_OFFERS.APPLICANT_ASSIGNMENT_ID'
1685: ,p_check_column2 => 'IRC_OFFERS.OFFER_ASSIGNMENT_ID'
1686: ,p_check_column3 => 'IRC_OFFERS.VACANCY_ID'
1687: ) then
1688: --
1689: -- Only proceed with validation if :
1690: -- a) The current g_old_rec is current and

Line 1776: (p_associated_column1 => 'IRC_OFFERS.LATEST_OFFER'

1772: --
1773: exception
1774: when app_exception.application_exception then
1775: if hr_multi_message.exception_add
1776: (p_associated_column1 => 'IRC_OFFERS.LATEST_OFFER'
1777: ) then
1778: hr_utility.set_location(' Leaving:'|| l_proc, 70);
1779: raise;
1780: end if;

Line 1812: (p_offer_id in irc_offers.offer_id%TYPE

1808: --
1809: -- {End Of Comments}
1810: -- ----------------------------------------------------------------------------
1811: Procedure chk_offer_version_combination
1812: (p_offer_id in irc_offers.offer_id%TYPE
1813: ,p_offer_version in irc_offers.offer_version%TYPE
1814: ,p_applicant_assignment_id in irc_offers.applicant_assignment_id%TYPE
1815: ,p_object_version_number in irc_offers.object_version_number%TYPE
1816: ) IS

Line 1813: ,p_offer_version in irc_offers.offer_version%TYPE

1809: -- {End Of Comments}
1810: -- ----------------------------------------------------------------------------
1811: Procedure chk_offer_version_combination
1812: (p_offer_id in irc_offers.offer_id%TYPE
1813: ,p_offer_version in irc_offers.offer_version%TYPE
1814: ,p_applicant_assignment_id in irc_offers.applicant_assignment_id%TYPE
1815: ,p_object_version_number in irc_offers.object_version_number%TYPE
1816: ) IS
1817: --

Line 1814: ,p_applicant_assignment_id in irc_offers.applicant_assignment_id%TYPE

1810: -- ----------------------------------------------------------------------------
1811: Procedure chk_offer_version_combination
1812: (p_offer_id in irc_offers.offer_id%TYPE
1813: ,p_offer_version in irc_offers.offer_version%TYPE
1814: ,p_applicant_assignment_id in irc_offers.applicant_assignment_id%TYPE
1815: ,p_object_version_number in irc_offers.object_version_number%TYPE
1816: ) IS
1817: --
1818: l_proc varchar2(72) := g_package || 'chk_offer_version_combination';

Line 1815: ,p_object_version_number in irc_offers.object_version_number%TYPE

1811: Procedure chk_offer_version_combination
1812: (p_offer_id in irc_offers.offer_id%TYPE
1813: ,p_offer_version in irc_offers.offer_version%TYPE
1814: ,p_applicant_assignment_id in irc_offers.applicant_assignment_id%TYPE
1815: ,p_object_version_number in irc_offers.object_version_number%TYPE
1816: ) IS
1817: --
1818: l_proc varchar2(72) := g_package || 'chk_offer_version_combination';
1819: l_version number;

Line 1824: from irc_offers

1820: l_api_updating boolean;
1821: --
1822: cursor csr_version is
1823: select 1
1824: from irc_offers
1825: where offer_version = p_offer_version
1826: and applicant_assignment_id = p_applicant_assignment_id;
1827: --
1828: Begin

Line 1833: p_check_column1 => 'IRC_OFFERS.APPLICANT_ASSIGNMENT_ID'

1829: --
1830: hr_utility.set_location(' Entering:'||l_proc,10);
1831: --
1832: if hr_multi_message.no_exclusive_error(
1833: p_check_column1 => 'IRC_OFFERS.APPLICANT_ASSIGNMENT_ID'
1834: ,p_check_column2 => 'IRC_OFFERS.OFFER_ASSIGNMENT_ID'
1835: ,p_check_column3 => 'IRC_OFFERS.VACANCY_ID'
1836: ) then
1837: --

Line 1834: ,p_check_column2 => 'IRC_OFFERS.OFFER_ASSIGNMENT_ID'

1830: hr_utility.set_location(' Entering:'||l_proc,10);
1831: --
1832: if hr_multi_message.no_exclusive_error(
1833: p_check_column1 => 'IRC_OFFERS.APPLICANT_ASSIGNMENT_ID'
1834: ,p_check_column2 => 'IRC_OFFERS.OFFER_ASSIGNMENT_ID'
1835: ,p_check_column3 => 'IRC_OFFERS.VACANCY_ID'
1836: ) then
1837: --
1838: -- Only proceed with validation if :

Line 1835: ,p_check_column3 => 'IRC_OFFERS.VACANCY_ID'

1831: --
1832: if hr_multi_message.no_exclusive_error(
1833: p_check_column1 => 'IRC_OFFERS.APPLICANT_ASSIGNMENT_ID'
1834: ,p_check_column2 => 'IRC_OFFERS.OFFER_ASSIGNMENT_ID'
1835: ,p_check_column3 => 'IRC_OFFERS.VACANCY_ID'
1836: ) then
1837: --
1838: -- Only proceed with validation if :
1839: -- a) The current g_old_rec is current and

Line 1909: (p_offer_id in irc_offers.offer_id%TYPE

1905: --
1906: -- {End Of Comments}
1907: -- ----------------------------------------------------------------------------
1908: procedure chk_offer_status
1909: (p_offer_id in irc_offers.offer_id%TYPE
1910: ,p_offer_status in irc_offers.offer_status%TYPE
1911: ,p_effective_date in date
1912: ,p_object_version_number in irc_offers.object_version_number%TYPE
1913: )IS

Line 1910: ,p_offer_status in irc_offers.offer_status%TYPE

1906: -- {End Of Comments}
1907: -- ----------------------------------------------------------------------------
1908: procedure chk_offer_status
1909: (p_offer_id in irc_offers.offer_id%TYPE
1910: ,p_offer_status in irc_offers.offer_status%TYPE
1911: ,p_effective_date in date
1912: ,p_object_version_number in irc_offers.object_version_number%TYPE
1913: )IS
1914: --

Line 1912: ,p_object_version_number in irc_offers.object_version_number%TYPE

1908: procedure chk_offer_status
1909: (p_offer_id in irc_offers.offer_id%TYPE
1910: ,p_offer_status in irc_offers.offer_status%TYPE
1911: ,p_effective_date in date
1912: ,p_object_version_number in irc_offers.object_version_number%TYPE
1913: )IS
1914: --
1915: l_proc varchar2(72) := g_package||'chk_offer_status';
1916: l_api_updating boolean;

Line 1922: p_check_column1 => 'IRC_OFFERS.APPLICANT_ASSIGNMENT_ID'

1918: begin
1919: hr_utility.set_location('Entering:'|| l_proc, 10);
1920: --
1921: if hr_multi_message.no_exclusive_error(
1922: p_check_column1 => 'IRC_OFFERS.APPLICANT_ASSIGNMENT_ID'
1923: ,p_check_column2 => 'IRC_OFFERS.OFFER_ASSIGNMENT_ID'
1924: ,p_check_column3 => 'IRC_OFFERS.VACANCY_ID'
1925: ) then
1926: --

Line 1923: ,p_check_column2 => 'IRC_OFFERS.OFFER_ASSIGNMENT_ID'

1919: hr_utility.set_location('Entering:'|| l_proc, 10);
1920: --
1921: if hr_multi_message.no_exclusive_error(
1922: p_check_column1 => 'IRC_OFFERS.APPLICANT_ASSIGNMENT_ID'
1923: ,p_check_column2 => 'IRC_OFFERS.OFFER_ASSIGNMENT_ID'
1924: ,p_check_column3 => 'IRC_OFFERS.VACANCY_ID'
1925: ) then
1926: --
1927: --

Line 1924: ,p_check_column3 => 'IRC_OFFERS.VACANCY_ID'

1920: --
1921: if hr_multi_message.no_exclusive_error(
1922: p_check_column1 => 'IRC_OFFERS.APPLICANT_ASSIGNMENT_ID'
1923: ,p_check_column2 => 'IRC_OFFERS.OFFER_ASSIGNMENT_ID'
1924: ,p_check_column3 => 'IRC_OFFERS.VACANCY_ID'
1925: ) then
1926: --
1927: --
1928: -- Check mandatory parameters have been set

Line 1993: (p_associated_column1 => 'IRC_OFFERS.OFFER_STATUS'

1989: hr_utility.set_location(' Leaving:'|| l_proc, 60);
1990: exception
1991: when app_exception.application_exception then
1992: if hr_multi_message.exception_add
1993: (p_associated_column1 => 'IRC_OFFERS.OFFER_STATUS'
1994: ) then
1995: hr_utility.set_location(' Leaving:'|| l_proc, 70);
1996: raise;
1997: end if;

Line 2009: -- checked for offer_status 'CLOSED' in update_offer procedure of irc_offers_api.

2005: --
2006: -- Description:
2007: -- This procedure ensures the following:
2008: -- 1) If the offer_status is 'CLOSED' do nothing - This is because we have already
2009: -- checked for offer_status 'CLOSED' in update_offer procedure of irc_offers_api.
2010: --
2011: -- 2) If the offer is in 'HOLD' state now, and the offer_status was previously 'HOLD'
2012: -- too, throw an error saying that an offer in HOLD status cannot be updated.
2013: --

Line 2036: l_prev_offer_status irc_offers.offer_status%TYPE := irc_iof_shd.g_old_rec.offer_status;

2032: ( p_current_offer_record in irc_iof_shd.g_rec_type
2033: )IS
2034: --
2035: l_proc varchar2(72) := g_package||'chk_offer_status_update';
2036: l_prev_offer_status irc_offers.offer_status%TYPE := irc_iof_shd.g_old_rec.offer_status;
2037: l_prev_to_prev_offer_status irc_offers.offer_status%TYPE;
2038: l_mutiple_fields_updated boolean;
2039: --
2040: cursor csr_prev_to_prev_offer_status is

Line 2037: l_prev_to_prev_offer_status irc_offers.offer_status%TYPE;

2033: )IS
2034: --
2035: l_proc varchar2(72) := g_package||'chk_offer_status_update';
2036: l_prev_offer_status irc_offers.offer_status%TYPE := irc_iof_shd.g_old_rec.offer_status;
2037: l_prev_to_prev_offer_status irc_offers.offer_status%TYPE;
2038: l_mutiple_fields_updated boolean;
2039: --
2040: cursor csr_prev_to_prev_offer_status is
2041: select ios1.offer_status

Line 2191: (p_associated_column1 => 'IRC_OFFERS.OFFER_STATUS'

2187: hr_utility.set_location(' Leaving:'|| l_proc, 80);
2188: exception
2189: when app_exception.application_exception then
2190: if hr_multi_message.exception_add
2191: (p_associated_column1 => 'IRC_OFFERS.OFFER_STATUS'
2192: ) then
2193: hr_utility.set_location(' Leaving:'|| l_proc, 90);
2194: raise;
2195: end if;

Line 2212: -- All the IRC_OFFERS table fields except object_version_number and respondent_id.

2208: -- Pre Conditions:
2209: -- None
2210: --
2211: -- In Arguments:
2212: -- All the IRC_OFFERS table fields except object_version_number and respondent_id.
2213: --
2214: -- Post Success:
2215: -- If only one field has been updated, p_mutiple_fields_updated will be set to
2216: -- 'false'. If multiple fields have been updated, p_mutiple_fields_updated will be

Line 2330: from irc_offers

2326: ,attribute28
2327: ,attribute29
2328: ,attribute30
2329: ,object_version_number
2330: from irc_offers
2331: where offer_id = p_offer_id;
2332: --
2333: l_offer_old_rec C_Sel1%ROWTYPE;
2334: Begin

Line 3044: (p_offer_id in irc_offers.offer_id%TYPE

3040: --
3041: -- {End Of Comments}
3042: -- ----------------------------------------------------------------------------
3043: procedure chk_offer_extended_method
3044: (p_offer_id in irc_offers.offer_id%TYPE
3045: ,p_offer_extended_method in irc_offers.offer_extended_method%TYPE
3046: ,p_effective_date in date
3047: ,p_object_version_number in irc_offers.object_version_number%TYPE
3048: )IS

Line 3045: ,p_offer_extended_method in irc_offers.offer_extended_method%TYPE

3041: -- {End Of Comments}
3042: -- ----------------------------------------------------------------------------
3043: procedure chk_offer_extended_method
3044: (p_offer_id in irc_offers.offer_id%TYPE
3045: ,p_offer_extended_method in irc_offers.offer_extended_method%TYPE
3046: ,p_effective_date in date
3047: ,p_object_version_number in irc_offers.object_version_number%TYPE
3048: )IS
3049: --

Line 3047: ,p_object_version_number in irc_offers.object_version_number%TYPE

3043: procedure chk_offer_extended_method
3044: (p_offer_id in irc_offers.offer_id%TYPE
3045: ,p_offer_extended_method in irc_offers.offer_extended_method%TYPE
3046: ,p_effective_date in date
3047: ,p_object_version_number in irc_offers.object_version_number%TYPE
3048: )IS
3049: --
3050: l_proc varchar2(72) := g_package||'chk_offer_extended_method';
3051: l_api_updating boolean;

Line 3057: p_check_column1 => 'IRC_OFFERS.APPLICANT_ASSIGNMENT_ID'

3053: begin
3054: hr_utility.set_location('Entering:'|| l_proc, 10);
3055: --
3056: if hr_multi_message.no_exclusive_error(
3057: p_check_column1 => 'IRC_OFFERS.APPLICANT_ASSIGNMENT_ID'
3058: ,p_check_column2 => 'IRC_OFFERS.OFFER_ASSIGNMENT_ID'
3059: ,p_check_column3 => 'IRC_OFFERS.VACANCY_ID'
3060: ) then
3061: --

Line 3058: ,p_check_column2 => 'IRC_OFFERS.OFFER_ASSIGNMENT_ID'

3054: hr_utility.set_location('Entering:'|| l_proc, 10);
3055: --
3056: if hr_multi_message.no_exclusive_error(
3057: p_check_column1 => 'IRC_OFFERS.APPLICANT_ASSIGNMENT_ID'
3058: ,p_check_column2 => 'IRC_OFFERS.OFFER_ASSIGNMENT_ID'
3059: ,p_check_column3 => 'IRC_OFFERS.VACANCY_ID'
3060: ) then
3061: --
3062: -- Check mandatory parameters have been set

Line 3059: ,p_check_column3 => 'IRC_OFFERS.VACANCY_ID'

3055: --
3056: if hr_multi_message.no_exclusive_error(
3057: p_check_column1 => 'IRC_OFFERS.APPLICANT_ASSIGNMENT_ID'
3058: ,p_check_column2 => 'IRC_OFFERS.OFFER_ASSIGNMENT_ID'
3059: ,p_check_column3 => 'IRC_OFFERS.VACANCY_ID'
3060: ) then
3061: --
3062: -- Check mandatory parameters have been set
3063: --

Line 3112: (p_associated_column1 => 'IRC_OFFERS.OFFER_EXTENDED_METHOD'

3108: hr_utility.set_location(' Leaving:'|| l_proc, 30);
3109: exception
3110: when app_exception.application_exception then
3111: if hr_multi_message.exception_add
3112: (p_associated_column1 => 'IRC_OFFERS.OFFER_EXTENDED_METHOD'
3113: ) then
3114: hr_utility.set_location(' Leaving:'|| l_proc, 40);
3115: raise;
3116: end if;

Line 3148: (p_offer_id in irc_offers.offer_id%TYPE

3144: --
3145: -- {End Of Comments}
3146: -- ----------------------------------------------------------------------------
3147: procedure chk_offer_postal_service
3148: (p_offer_id in irc_offers.offer_id%TYPE
3149: ,p_offer_postal_service in irc_offers.offer_postal_service%TYPE
3150: ,p_effective_date in date
3151: ,p_object_version_number in irc_offers.object_version_number%TYPE
3152: )IS

Line 3149: ,p_offer_postal_service in irc_offers.offer_postal_service%TYPE

3145: -- {End Of Comments}
3146: -- ----------------------------------------------------------------------------
3147: procedure chk_offer_postal_service
3148: (p_offer_id in irc_offers.offer_id%TYPE
3149: ,p_offer_postal_service in irc_offers.offer_postal_service%TYPE
3150: ,p_effective_date in date
3151: ,p_object_version_number in irc_offers.object_version_number%TYPE
3152: )IS
3153: --

Line 3151: ,p_object_version_number in irc_offers.object_version_number%TYPE

3147: procedure chk_offer_postal_service
3148: (p_offer_id in irc_offers.offer_id%TYPE
3149: ,p_offer_postal_service in irc_offers.offer_postal_service%TYPE
3150: ,p_effective_date in date
3151: ,p_object_version_number in irc_offers.object_version_number%TYPE
3152: )IS
3153: --
3154: l_proc varchar2(72) := g_package||'chk_offer_postal_service';
3155: l_api_updating boolean;

Line 3161: p_check_column1 => 'IRC_OFFERS.APPLICANT_ASSIGNMENT_ID'

3157: begin
3158: hr_utility.set_location('Entering:'|| l_proc, 10);
3159: --
3160: if hr_multi_message.no_exclusive_error(
3161: p_check_column1 => 'IRC_OFFERS.APPLICANT_ASSIGNMENT_ID'
3162: ,p_check_column2 => 'IRC_OFFERS.OFFER_ASSIGNMENT_ID'
3163: ,p_check_column3 => 'IRC_OFFERS.VACANCY_ID'
3164: ) then
3165: --

Line 3162: ,p_check_column2 => 'IRC_OFFERS.OFFER_ASSIGNMENT_ID'

3158: hr_utility.set_location('Entering:'|| l_proc, 10);
3159: --
3160: if hr_multi_message.no_exclusive_error(
3161: p_check_column1 => 'IRC_OFFERS.APPLICANT_ASSIGNMENT_ID'
3162: ,p_check_column2 => 'IRC_OFFERS.OFFER_ASSIGNMENT_ID'
3163: ,p_check_column3 => 'IRC_OFFERS.VACANCY_ID'
3164: ) then
3165: --
3166: -- Check mandatory parameters have been set

Line 3163: ,p_check_column3 => 'IRC_OFFERS.VACANCY_ID'

3159: --
3160: if hr_multi_message.no_exclusive_error(
3161: p_check_column1 => 'IRC_OFFERS.APPLICANT_ASSIGNMENT_ID'
3162: ,p_check_column2 => 'IRC_OFFERS.OFFER_ASSIGNMENT_ID'
3163: ,p_check_column3 => 'IRC_OFFERS.VACANCY_ID'
3164: ) then
3165: --
3166: -- Check mandatory parameters have been set
3167: --

Line 3216: (p_associated_column1 => 'IRC_OFFERS.OFFER_POSTAL_SERVICE'

3212: hr_utility.set_location(' Leaving:'|| l_proc, 30);
3213: exception
3214: when app_exception.application_exception then
3215: if hr_multi_message.exception_add
3216: (p_associated_column1 => 'IRC_OFFERS.OFFER_POSTAL_SERVICE'
3217: ) then
3218: hr_utility.set_location(' Leaving:'|| l_proc, 40);
3219: raise;
3220: end if;

Line 3250: (p_offer_id in irc_offers.offer_id%TYPE

3246: --
3247: -- {End Of Comments}
3248: -- ----------------------------------------------------------------------------
3249: procedure chk_offer_letter
3250: (p_offer_id in irc_offers.offer_id%TYPE
3251: ,p_offer_status in irc_offers.offer_status%TYPE
3252: )IS
3253: --
3254: l_proc varchar2(72) := g_package||'chk_offer_letter';

Line 3251: ,p_offer_status in irc_offers.offer_status%TYPE

3247: -- {End Of Comments}
3248: -- ----------------------------------------------------------------------------
3249: procedure chk_offer_letter
3250: (p_offer_id in irc_offers.offer_id%TYPE
3251: ,p_offer_status in irc_offers.offer_status%TYPE
3252: )IS
3253: --
3254: l_proc varchar2(72) := g_package||'chk_offer_letter';
3255: l_offer_letter irc_offers.offer_letter%TYPE;

Line 3255: l_offer_letter irc_offers.offer_letter%TYPE;

3251: ,p_offer_status in irc_offers.offer_status%TYPE
3252: )IS
3253: --
3254: l_proc varchar2(72) := g_package||'chk_offer_letter';
3255: l_offer_letter irc_offers.offer_letter%TYPE;
3256: --
3257: cursor csr_offer_letter is
3258: select offer_letter
3259: from irc_offers

Line 3259: from irc_offers

3255: l_offer_letter irc_offers.offer_letter%TYPE;
3256: --
3257: cursor csr_offer_letter is
3258: select offer_letter
3259: from irc_offers
3260: where offer_id = p_offer_id;
3261: --
3262: begin
3263: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 3266: p_check_column1 => 'IRC_OFFERS.APPLICANT_ASSIGNMENT_ID'

3262: begin
3263: hr_utility.set_location('Entering:'|| l_proc, 10);
3264: --
3265: if hr_multi_message.no_exclusive_error(
3266: p_check_column1 => 'IRC_OFFERS.APPLICANT_ASSIGNMENT_ID'
3267: ,p_check_column2 => 'IRC_OFFERS.OFFER_ASSIGNMENT_ID'
3268: ,p_check_column3 => 'IRC_OFFERS.VACANCY_ID'
3269: ) then
3270: --

Line 3267: ,p_check_column2 => 'IRC_OFFERS.OFFER_ASSIGNMENT_ID'

3263: hr_utility.set_location('Entering:'|| l_proc, 10);
3264: --
3265: if hr_multi_message.no_exclusive_error(
3266: p_check_column1 => 'IRC_OFFERS.APPLICANT_ASSIGNMENT_ID'
3267: ,p_check_column2 => 'IRC_OFFERS.OFFER_ASSIGNMENT_ID'
3268: ,p_check_column3 => 'IRC_OFFERS.VACANCY_ID'
3269: ) then
3270: --
3271: if p_offer_status = 'APPROVED'

Line 3268: ,p_check_column3 => 'IRC_OFFERS.VACANCY_ID'

3264: --
3265: if hr_multi_message.no_exclusive_error(
3266: p_check_column1 => 'IRC_OFFERS.APPLICANT_ASSIGNMENT_ID'
3267: ,p_check_column2 => 'IRC_OFFERS.OFFER_ASSIGNMENT_ID'
3268: ,p_check_column3 => 'IRC_OFFERS.VACANCY_ID'
3269: ) then
3270: --
3271: if p_offer_status = 'APPROVED'
3272: and nvl(irc_iof_shd.g_old_rec.offer_status, hr_api.g_varchar2) <>

Line 3312: (p_associated_column1 => 'IRC_OFFERS.OFFER_LETTER'

3308: hr_utility.set_location(' Leaving:'|| l_proc, 50);
3309: exception
3310: when app_exception.application_exception then
3311: if hr_multi_message.exception_add
3312: (p_associated_column1 => 'IRC_OFFERS.OFFER_LETTER'
3313: ) then
3314: hr_utility.set_location(' Leaving:'|| l_proc, 60);
3315: raise;
3316: end if;

Line 3349: (p_offer_id in irc_offers.offer_id%TYPE

3345: --
3346: -- {End Of Comments}
3347: -- ----------------------------------------------------------------------------
3348: procedure chk_offer_letter_file_type
3349: (p_offer_id in irc_offers.offer_id%TYPE
3350: ,p_offer_letter_file_type in irc_offers.offer_letter_file_type%TYPE
3351: ,p_effective_date in date
3352: ,p_object_version_number in irc_offers.object_version_number%TYPE
3353: )IS

Line 3350: ,p_offer_letter_file_type in irc_offers.offer_letter_file_type%TYPE

3346: -- {End Of Comments}
3347: -- ----------------------------------------------------------------------------
3348: procedure chk_offer_letter_file_type
3349: (p_offer_id in irc_offers.offer_id%TYPE
3350: ,p_offer_letter_file_type in irc_offers.offer_letter_file_type%TYPE
3351: ,p_effective_date in date
3352: ,p_object_version_number in irc_offers.object_version_number%TYPE
3353: )IS
3354: --

Line 3352: ,p_object_version_number in irc_offers.object_version_number%TYPE

3348: procedure chk_offer_letter_file_type
3349: (p_offer_id in irc_offers.offer_id%TYPE
3350: ,p_offer_letter_file_type in irc_offers.offer_letter_file_type%TYPE
3351: ,p_effective_date in date
3352: ,p_object_version_number in irc_offers.object_version_number%TYPE
3353: )IS
3354: --
3355: l_proc varchar2(72) := g_package||'chk_offer_letter_file_type';
3356: l_api_updating boolean;

Line 3362: p_check_column1 => 'IRC_OFFERS.APPLICANT_ASSIGNMENT_ID'

3358: begin
3359: hr_utility.set_location('Entering:'|| l_proc, 10);
3360: --
3361: if hr_multi_message.no_exclusive_error(
3362: p_check_column1 => 'IRC_OFFERS.APPLICANT_ASSIGNMENT_ID'
3363: ,p_check_column2 => 'IRC_OFFERS.OFFER_ASSIGNMENT_ID'
3364: ,p_check_column3 => 'IRC_OFFERS.VACANCY_ID'
3365: ) then
3366: --

Line 3363: ,p_check_column2 => 'IRC_OFFERS.OFFER_ASSIGNMENT_ID'

3359: hr_utility.set_location('Entering:'|| l_proc, 10);
3360: --
3361: if hr_multi_message.no_exclusive_error(
3362: p_check_column1 => 'IRC_OFFERS.APPLICANT_ASSIGNMENT_ID'
3363: ,p_check_column2 => 'IRC_OFFERS.OFFER_ASSIGNMENT_ID'
3364: ,p_check_column3 => 'IRC_OFFERS.VACANCY_ID'
3365: ) then
3366: --
3367: -- Check mandatory parameters have been set

Line 3364: ,p_check_column3 => 'IRC_OFFERS.VACANCY_ID'

3360: --
3361: if hr_multi_message.no_exclusive_error(
3362: p_check_column1 => 'IRC_OFFERS.APPLICANT_ASSIGNMENT_ID'
3363: ,p_check_column2 => 'IRC_OFFERS.OFFER_ASSIGNMENT_ID'
3364: ,p_check_column3 => 'IRC_OFFERS.VACANCY_ID'
3365: ) then
3366: --
3367: -- Check mandatory parameters have been set
3368: --

Line 3416: (p_associated_column1 => 'IRC_OFFERS.OFFER_LETTER_FILE_TYPE'

3412: hr_utility.set_location(' Leaving:'|| l_proc, 30);
3413: exception
3414: when app_exception.application_exception then
3415: if hr_multi_message.exception_add
3416: (p_associated_column1 => 'IRC_OFFERS.OFFER_LETTER_FILE_TYPE'
3417: ) then
3418: hr_utility.set_location(' Leaving:'|| l_proc, 40);
3419: raise;
3420: end if;