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 750: from irc_offers

746: and ios2.offer_status_history_id > ios1.offer_status_history_id);
747: --
748: cursor csr_prev_offer_status is
749: select offer_status
750: from irc_offers
751: where offer_id = p_offer_id;
752: --
753: cursor csr_offer_count is
754: select count(*)

Line 755: from irc_offers iof

751: where offer_id = p_offer_id;
752: --
753: cursor csr_offer_count is
754: select count(*)
755: from irc_offers iof
756: ,per_all_vacancies pav
757: ,irc_offer_status_history iosh
758: where pav.vacancy_id = p_vacancy_id
759: and iof.vacancy_id = pav.vacancy_id

Line 828: p_check_column1 => 'IRC_OFFERS.APPLICANT_ASSIGNMENT_ID'

824: if l_chk_vacancy_count = true
825: then
826: --
827: if hr_multi_message.no_exclusive_error(
828: p_check_column1 => 'IRC_OFFERS.APPLICANT_ASSIGNMENT_ID'
829: ,p_check_column2 => 'IRC_OFFERS.OFFER_ASSIGNMENT_ID'
830: ,p_check_column3 => 'IRC_OFFERS.VACANCY_ID'
831: )
832: then

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

825: then
826: --
827: if hr_multi_message.no_exclusive_error(
828: p_check_column1 => 'IRC_OFFERS.APPLICANT_ASSIGNMENT_ID'
829: ,p_check_column2 => 'IRC_OFFERS.OFFER_ASSIGNMENT_ID'
830: ,p_check_column3 => 'IRC_OFFERS.VACANCY_ID'
831: )
832: then
833: --

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

826: --
827: if hr_multi_message.no_exclusive_error(
828: p_check_column1 => 'IRC_OFFERS.APPLICANT_ASSIGNMENT_ID'
829: ,p_check_column2 => 'IRC_OFFERS.OFFER_ASSIGNMENT_ID'
830: ,p_check_column3 => 'IRC_OFFERS.VACANCY_ID'
831: )
832: then
833: --
834: hr_api.mandatory_arg_error

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

864: hr_utility.set_location(' Leaving:'||l_proc,30);
865: exception
866: when app_exception.application_exception then
867: if hr_multi_message.exception_add
868: (p_associated_column1 => 'IRC_OFFERS.VACANCY_ID'
869: ) then
870: hr_utility.set_location(' Leaving:'|| l_proc, 40);
871: raise;
872: end if;

Line 901: (p_respondent_id in irc_offers.respondent_id%TYPE

897: --
898: -- {End Of Comments}
899: -- ----------------------------------------------------------------------------
900: Procedure chk_respondent_id
901: (p_respondent_id in irc_offers.respondent_id%TYPE
902: ,p_offer_id in irc_offers.offer_id%TYPE
903: ,p_object_version_number in irc_offers.object_version_number%TYPE
904: ) IS
905: --

Line 902: ,p_offer_id in irc_offers.offer_id%TYPE

898: -- {End Of Comments}
899: -- ----------------------------------------------------------------------------
900: Procedure chk_respondent_id
901: (p_respondent_id in irc_offers.respondent_id%TYPE
902: ,p_offer_id in irc_offers.offer_id%TYPE
903: ,p_object_version_number in irc_offers.object_version_number%TYPE
904: ) IS
905: --
906: l_proc varchar2(72) := g_package || 'chk_respondent_id';

Line 903: ,p_object_version_number in irc_offers.object_version_number%TYPE

899: -- ----------------------------------------------------------------------------
900: Procedure chk_respondent_id
901: (p_respondent_id in irc_offers.respondent_id%TYPE
902: ,p_offer_id in irc_offers.offer_id%TYPE
903: ,p_object_version_number in irc_offers.object_version_number%TYPE
904: ) IS
905: --
906: l_proc varchar2(72) := g_package || 'chk_respondent_id';
907: l_api_updating boolean;

Line 919: p_check_column1 => 'IRC_OFFERS.APPLICANT_ASSIGNMENT_ID'

915: Begin
916: hr_utility.set_location('Entering:'||l_proc,10);
917: --
918: if hr_multi_message.no_exclusive_error(
919: p_check_column1 => 'IRC_OFFERS.APPLICANT_ASSIGNMENT_ID'
920: ,p_check_column2 => 'IRC_OFFERS.OFFER_ASSIGNMENT_ID'
921: ,p_check_column3 => 'IRC_OFFERS.VACANCY_ID'
922: ) then
923: --

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

916: hr_utility.set_location('Entering:'||l_proc,10);
917: --
918: if hr_multi_message.no_exclusive_error(
919: p_check_column1 => 'IRC_OFFERS.APPLICANT_ASSIGNMENT_ID'
920: ,p_check_column2 => 'IRC_OFFERS.OFFER_ASSIGNMENT_ID'
921: ,p_check_column3 => 'IRC_OFFERS.VACANCY_ID'
922: ) then
923: --
924: -- Only proceed with validation if :

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

917: --
918: if hr_multi_message.no_exclusive_error(
919: p_check_column1 => 'IRC_OFFERS.APPLICANT_ASSIGNMENT_ID'
920: ,p_check_column2 => 'IRC_OFFERS.OFFER_ASSIGNMENT_ID'
921: ,p_check_column3 => 'IRC_OFFERS.VACANCY_ID'
922: ) then
923: --
924: -- Only proceed with validation if :
925: -- a) The current g_old_rec is current and

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

963: --
964: exception
965: when app_exception.application_exception then
966: if hr_multi_message.exception_add
967: (p_associated_column1 => 'IRC_OFFERS.RESPONDENT_ID'
968: ) then
969: hr_utility.set_location(' Leaving:'|| l_proc, 60);
970: raise;
971: end if;

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

999: --
1000: -- {End Of Comments}
1001: -- ----------------------------------------------------------------------------
1002: Procedure chk_expiry_date
1003: (p_expiry_date in out nocopy irc_offers.expiry_date%TYPE
1004: ,p_offer_status in irc_offers.offer_status%TYPE
1005: ,p_offer_id in irc_offers.offer_id%TYPE
1006: ,p_offer_postal_service in irc_offers.offer_postal_service%TYPE
1007: ,p_offer_letter_tracking_code in irc_offers.offer_letter_tracking_code%TYPE

Line 1004: ,p_offer_status in irc_offers.offer_status%TYPE

1000: -- {End Of Comments}
1001: -- ----------------------------------------------------------------------------
1002: Procedure chk_expiry_date
1003: (p_expiry_date in out nocopy irc_offers.expiry_date%TYPE
1004: ,p_offer_status in irc_offers.offer_status%TYPE
1005: ,p_offer_id in irc_offers.offer_id%TYPE
1006: ,p_offer_postal_service in irc_offers.offer_postal_service%TYPE
1007: ,p_offer_letter_tracking_code in irc_offers.offer_letter_tracking_code%TYPE
1008: ,p_offer_shipping_date in irc_offers.offer_shipping_date%TYPE

Line 1005: ,p_offer_id in irc_offers.offer_id%TYPE

1001: -- ----------------------------------------------------------------------------
1002: Procedure chk_expiry_date
1003: (p_expiry_date in out nocopy irc_offers.expiry_date%TYPE
1004: ,p_offer_status in irc_offers.offer_status%TYPE
1005: ,p_offer_id in irc_offers.offer_id%TYPE
1006: ,p_offer_postal_service in irc_offers.offer_postal_service%TYPE
1007: ,p_offer_letter_tracking_code in irc_offers.offer_letter_tracking_code%TYPE
1008: ,p_offer_shipping_date in irc_offers.offer_shipping_date%TYPE
1009: ,p_effective_date date

Line 1006: ,p_offer_postal_service in irc_offers.offer_postal_service%TYPE

1002: Procedure chk_expiry_date
1003: (p_expiry_date in out nocopy irc_offers.expiry_date%TYPE
1004: ,p_offer_status in irc_offers.offer_status%TYPE
1005: ,p_offer_id in irc_offers.offer_id%TYPE
1006: ,p_offer_postal_service in irc_offers.offer_postal_service%TYPE
1007: ,p_offer_letter_tracking_code in irc_offers.offer_letter_tracking_code%TYPE
1008: ,p_offer_shipping_date in irc_offers.offer_shipping_date%TYPE
1009: ,p_effective_date date
1010: ) IS

Line 1007: ,p_offer_letter_tracking_code in irc_offers.offer_letter_tracking_code%TYPE

1003: (p_expiry_date in out nocopy irc_offers.expiry_date%TYPE
1004: ,p_offer_status in irc_offers.offer_status%TYPE
1005: ,p_offer_id in irc_offers.offer_id%TYPE
1006: ,p_offer_postal_service in irc_offers.offer_postal_service%TYPE
1007: ,p_offer_letter_tracking_code in irc_offers.offer_letter_tracking_code%TYPE
1008: ,p_offer_shipping_date in irc_offers.offer_shipping_date%TYPE
1009: ,p_effective_date date
1010: ) IS
1011: --

Line 1008: ,p_offer_shipping_date in irc_offers.offer_shipping_date%TYPE

1004: ,p_offer_status in irc_offers.offer_status%TYPE
1005: ,p_offer_id in irc_offers.offer_id%TYPE
1006: ,p_offer_postal_service in irc_offers.offer_postal_service%TYPE
1007: ,p_offer_letter_tracking_code in irc_offers.offer_letter_tracking_code%TYPE
1008: ,p_offer_shipping_date in irc_offers.offer_shipping_date%TYPE
1009: ,p_effective_date date
1010: ) IS
1011: --
1012: l_proc varchar2(72) := g_package || 'chk_expiry_date';

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

1011: --
1012: l_proc varchar2(72) := g_package || 'chk_expiry_date';
1013: l_offer_duration_value varchar2(30);
1014: l_offer_duration_measurement varchar2(30);
1015: l_expiry_date irc_offers.expiry_date%TYPE := p_expiry_date;
1016: l_prev_expiry_date irc_offers.expiry_date%TYPE := irc_iof_shd.g_old_rec.expiry_date;
1017: l_prev_offer_postal_service irc_offers.offer_postal_service%TYPE := irc_iof_shd.g_old_rec.offer_postal_service;
1018: l_prev_letter_tracking_code irc_offers.offer_letter_tracking_code%TYPE := irc_iof_shd.g_old_rec.offer_letter_tracking_code;
1019: l_prev_offer_shipping_date irc_offers.offer_shipping_date%TYPE := irc_iof_shd.g_old_rec.offer_shipping_date;

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

1012: l_proc varchar2(72) := g_package || 'chk_expiry_date';
1013: l_offer_duration_value varchar2(30);
1014: l_offer_duration_measurement varchar2(30);
1015: l_expiry_date irc_offers.expiry_date%TYPE := p_expiry_date;
1016: l_prev_expiry_date irc_offers.expiry_date%TYPE := irc_iof_shd.g_old_rec.expiry_date;
1017: l_prev_offer_postal_service irc_offers.offer_postal_service%TYPE := irc_iof_shd.g_old_rec.offer_postal_service;
1018: l_prev_letter_tracking_code irc_offers.offer_letter_tracking_code%TYPE := irc_iof_shd.g_old_rec.offer_letter_tracking_code;
1019: l_prev_offer_shipping_date irc_offers.offer_shipping_date%TYPE := irc_iof_shd.g_old_rec.offer_shipping_date;
1020: l_effective_date date;

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

1013: l_offer_duration_value varchar2(30);
1014: l_offer_duration_measurement varchar2(30);
1015: l_expiry_date irc_offers.expiry_date%TYPE := p_expiry_date;
1016: l_prev_expiry_date irc_offers.expiry_date%TYPE := irc_iof_shd.g_old_rec.expiry_date;
1017: l_prev_offer_postal_service irc_offers.offer_postal_service%TYPE := irc_iof_shd.g_old_rec.offer_postal_service;
1018: l_prev_letter_tracking_code irc_offers.offer_letter_tracking_code%TYPE := irc_iof_shd.g_old_rec.offer_letter_tracking_code;
1019: l_prev_offer_shipping_date irc_offers.offer_shipping_date%TYPE := irc_iof_shd.g_old_rec.offer_shipping_date;
1020: l_effective_date date;
1021: --

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

1014: l_offer_duration_measurement varchar2(30);
1015: l_expiry_date irc_offers.expiry_date%TYPE := p_expiry_date;
1016: l_prev_expiry_date irc_offers.expiry_date%TYPE := irc_iof_shd.g_old_rec.expiry_date;
1017: l_prev_offer_postal_service irc_offers.offer_postal_service%TYPE := irc_iof_shd.g_old_rec.offer_postal_service;
1018: l_prev_letter_tracking_code irc_offers.offer_letter_tracking_code%TYPE := irc_iof_shd.g_old_rec.offer_letter_tracking_code;
1019: l_prev_offer_shipping_date irc_offers.offer_shipping_date%TYPE := irc_iof_shd.g_old_rec.offer_shipping_date;
1020: l_effective_date date;
1021: --
1022: Begin

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

1015: l_expiry_date irc_offers.expiry_date%TYPE := p_expiry_date;
1016: l_prev_expiry_date irc_offers.expiry_date%TYPE := irc_iof_shd.g_old_rec.expiry_date;
1017: l_prev_offer_postal_service irc_offers.offer_postal_service%TYPE := irc_iof_shd.g_old_rec.offer_postal_service;
1018: l_prev_letter_tracking_code irc_offers.offer_letter_tracking_code%TYPE := irc_iof_shd.g_old_rec.offer_letter_tracking_code;
1019: l_prev_offer_shipping_date irc_offers.offer_shipping_date%TYPE := irc_iof_shd.g_old_rec.offer_shipping_date;
1020: l_effective_date date;
1021: --
1022: Begin
1023: hr_utility.set_location('Entering:'||l_proc,10);

Line 1026: p_check_column1 => 'IRC_OFFERS.APPLICANT_ASSIGNMENT_ID'

1022: Begin
1023: hr_utility.set_location('Entering:'||l_proc,10);
1024: --
1025: if hr_multi_message.no_exclusive_error(
1026: p_check_column1 => 'IRC_OFFERS.APPLICANT_ASSIGNMENT_ID'
1027: ,p_check_column2 => 'IRC_OFFERS.OFFER_ASSIGNMENT_ID'
1028: ,p_check_column3 => 'IRC_OFFERS.VACANCY_ID'
1029: ) then
1030: --

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

1023: hr_utility.set_location('Entering:'||l_proc,10);
1024: --
1025: if hr_multi_message.no_exclusive_error(
1026: p_check_column1 => 'IRC_OFFERS.APPLICANT_ASSIGNMENT_ID'
1027: ,p_check_column2 => 'IRC_OFFERS.OFFER_ASSIGNMENT_ID'
1028: ,p_check_column3 => 'IRC_OFFERS.VACANCY_ID'
1029: ) then
1030: --
1031: if p_offer_status = 'EXTENDED'

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

1024: --
1025: if hr_multi_message.no_exclusive_error(
1026: p_check_column1 => 'IRC_OFFERS.APPLICANT_ASSIGNMENT_ID'
1027: ,p_check_column2 => 'IRC_OFFERS.OFFER_ASSIGNMENT_ID'
1028: ,p_check_column3 => 'IRC_OFFERS.VACANCY_ID'
1029: ) then
1030: --
1031: if p_offer_status = 'EXTENDED'
1032: then

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

1127: --
1128: exception
1129: when app_exception.application_exception then
1130: if hr_multi_message.exception_add
1131: (p_associated_column1 => 'IRC_OFFERS.EXPIRY_DATE'
1132: ) then
1133: hr_utility.set_location(' Leaving:'|| l_proc, 80);
1134: raise;
1135: end if;

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

1165: --
1166: -- {End Of Comments}
1167: -- ----------------------------------------------------------------------------
1168: Procedure set_address_id
1169: (p_address_id in out nocopy irc_offers.address_id%TYPE
1170: ,p_applicant_assignment_id in irc_offers.applicant_assignment_id%TYPE
1171: ,p_effective_date date
1172: ) IS
1173: --

Line 1170: ,p_applicant_assignment_id in irc_offers.applicant_assignment_id%TYPE

1166: -- {End Of Comments}
1167: -- ----------------------------------------------------------------------------
1168: Procedure set_address_id
1169: (p_address_id in out nocopy irc_offers.address_id%TYPE
1170: ,p_applicant_assignment_id in irc_offers.applicant_assignment_id%TYPE
1171: ,p_effective_date date
1172: ) IS
1173: --
1174: l_proc varchar2(72) := g_package || 'set_address_id';

Line 1175: l_rec_address_id irc_offers.address_id%TYPE;

1171: ,p_effective_date date
1172: ) IS
1173: --
1174: l_proc varchar2(72) := g_package || 'set_address_id';
1175: l_rec_address_id irc_offers.address_id%TYPE;
1176: --
1177: cursor csr_rec_address_id is
1178: select adr.address_id
1179: from per_addresses adr

Line 1192: p_check_column1 => 'IRC_OFFERS.APPLICANT_ASSIGNMENT_ID'

1188: Begin
1189: hr_utility.set_location('Entering:'||l_proc,10);
1190: --
1191: if hr_multi_message.no_exclusive_error(
1192: p_check_column1 => 'IRC_OFFERS.APPLICANT_ASSIGNMENT_ID'
1193: ,p_check_column2 => 'IRC_OFFERS.OFFER_ASSIGNMENT_ID'
1194: ,p_check_column3 => 'IRC_OFFERS.VACANCY_ID'
1195: ) then
1196: --

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

1189: hr_utility.set_location('Entering:'||l_proc,10);
1190: --
1191: if hr_multi_message.no_exclusive_error(
1192: p_check_column1 => 'IRC_OFFERS.APPLICANT_ASSIGNMENT_ID'
1193: ,p_check_column2 => 'IRC_OFFERS.OFFER_ASSIGNMENT_ID'
1194: ,p_check_column3 => 'IRC_OFFERS.VACANCY_ID'
1195: ) then
1196: --
1197: hr_utility.set_location(l_proc,20);

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

1190: --
1191: if hr_multi_message.no_exclusive_error(
1192: p_check_column1 => 'IRC_OFFERS.APPLICANT_ASSIGNMENT_ID'
1193: ,p_check_column2 => 'IRC_OFFERS.OFFER_ASSIGNMENT_ID'
1194: ,p_check_column3 => 'IRC_OFFERS.VACANCY_ID'
1195: ) then
1196: --
1197: hr_utility.set_location(l_proc,20);
1198: --

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

1221: --
1222: exception
1223: when app_exception.application_exception then
1224: if hr_multi_message.exception_add
1225: (p_associated_column1 => 'IRC_OFFERS.ADDRESS_ID'
1226: ) then
1227: hr_utility.set_location(' Leaving:'|| l_proc, 50);
1228: raise;
1229: end if;

Line 1258: (p_address_id in irc_offers.address_id%TYPE

1254: --
1255: -- {End Of Comments}
1256: -- ----------------------------------------------------------------------------
1257: Procedure chk_address_id
1258: (p_address_id in irc_offers.address_id%TYPE
1259: ,p_offer_id in irc_offers.offer_id%TYPE
1260: ,p_object_version_number in irc_offers.object_version_number%TYPE
1261: ) IS
1262: --

Line 1259: ,p_offer_id in irc_offers.offer_id%TYPE

1255: -- {End Of Comments}
1256: -- ----------------------------------------------------------------------------
1257: Procedure chk_address_id
1258: (p_address_id in irc_offers.address_id%TYPE
1259: ,p_offer_id in irc_offers.offer_id%TYPE
1260: ,p_object_version_number in irc_offers.object_version_number%TYPE
1261: ) IS
1262: --
1263: l_proc varchar2(72) := g_package || 'chk_address_id';

Line 1260: ,p_object_version_number in irc_offers.object_version_number%TYPE

1256: -- ----------------------------------------------------------------------------
1257: Procedure chk_address_id
1258: (p_address_id in irc_offers.address_id%TYPE
1259: ,p_offer_id in irc_offers.offer_id%TYPE
1260: ,p_object_version_number in irc_offers.object_version_number%TYPE
1261: ) IS
1262: --
1263: l_proc varchar2(72) := g_package || 'chk_address_id';
1264: l_address_id number;

Line 1276: p_check_column1 => 'IRC_OFFERS.APPLICANT_ASSIGNMENT_ID'

1272: Begin
1273: hr_utility.set_location('Entering:'||l_proc,10);
1274: --
1275: if hr_multi_message.no_exclusive_error(
1276: p_check_column1 => 'IRC_OFFERS.APPLICANT_ASSIGNMENT_ID'
1277: ,p_check_column2 => 'IRC_OFFERS.OFFER_ASSIGNMENT_ID'
1278: ,p_check_column3 => 'IRC_OFFERS.VACANCY_ID'
1279: ) then
1280: --

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

1273: hr_utility.set_location('Entering:'||l_proc,10);
1274: --
1275: if hr_multi_message.no_exclusive_error(
1276: p_check_column1 => 'IRC_OFFERS.APPLICANT_ASSIGNMENT_ID'
1277: ,p_check_column2 => 'IRC_OFFERS.OFFER_ASSIGNMENT_ID'
1278: ,p_check_column3 => 'IRC_OFFERS.VACANCY_ID'
1279: ) then
1280: --
1281: -- Only proceed with validation if :

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

1274: --
1275: if hr_multi_message.no_exclusive_error(
1276: p_check_column1 => 'IRC_OFFERS.APPLICANT_ASSIGNMENT_ID'
1277: ,p_check_column2 => 'IRC_OFFERS.OFFER_ASSIGNMENT_ID'
1278: ,p_check_column3 => 'IRC_OFFERS.VACANCY_ID'
1279: ) then
1280: --
1281: -- Only proceed with validation if :
1282: -- a) The current g_old_rec is current and

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

1317: --
1318: exception
1319: when app_exception.application_exception then
1320: if hr_multi_message.exception_add
1321: (p_associated_column1 => 'IRC_OFFERS.ADDRESS_ID'
1322: ) then
1323: hr_utility.set_location(' Leaving:'|| l_proc, 50);
1324: raise;
1325: end if;

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

1354: --
1355: -- {End Of Comments}
1356: -- ----------------------------------------------------------------------------
1357: Procedure chk_template_id
1358: (p_template_id in out nocopy irc_offers.template_id%TYPE
1359: ,p_offer_id in irc_offers.offer_id%TYPE
1360: ,p_object_version_number in irc_offers.object_version_number%TYPE
1361: ,p_effective_date date
1362: ) IS

Line 1359: ,p_offer_id in irc_offers.offer_id%TYPE

1355: -- {End Of Comments}
1356: -- ----------------------------------------------------------------------------
1357: Procedure chk_template_id
1358: (p_template_id in out nocopy irc_offers.template_id%TYPE
1359: ,p_offer_id in irc_offers.offer_id%TYPE
1360: ,p_object_version_number in irc_offers.object_version_number%TYPE
1361: ,p_effective_date date
1362: ) IS
1363: --

Line 1360: ,p_object_version_number in irc_offers.object_version_number%TYPE

1356: -- ----------------------------------------------------------------------------
1357: Procedure chk_template_id
1358: (p_template_id in out nocopy irc_offers.template_id%TYPE
1359: ,p_offer_id in irc_offers.offer_id%TYPE
1360: ,p_object_version_number in irc_offers.object_version_number%TYPE
1361: ,p_effective_date date
1362: ) IS
1363: --
1364: l_proc varchar2(72) := g_package || 'chk_template_id';

Line 1380: ,irc_offers iof

1376: cursor csr_default_template_job is
1377: select ita.template_id
1378: from irc_template_associations ita
1379: ,per_all_assignments_f ppaf
1380: ,irc_offers iof
1381: where ita.default_association = 'Y'
1382: and iof.offer_id = p_offer_id
1383: and iof.offer_assignment_id = ppaf.assignment_id
1384: and ita.job_id = ppaf.job_id;

Line 1390: ,irc_offers iof

1386: cursor csr_default_template_pos is
1387: select ita.template_id
1388: from irc_template_associations ita
1389: ,per_all_assignments_f ppaf
1390: ,irc_offers iof
1391: where ita.default_association = 'Y'
1392: and iof.offer_id = p_offer_id
1393: and iof.offer_assignment_id = ppaf.assignment_id
1394: and ita.position_id = ppaf.position_id;

Line 1400: ,irc_offers iof

1396: cursor csr_default_template_org is
1397: select ita.template_id
1398: from irc_template_associations ita
1399: ,per_all_assignments_f ppaf
1400: ,irc_offers iof
1401: where ita.default_association = 'Y'
1402: and iof.offer_id = p_offer_id
1403: and iof.offer_assignment_id = ppaf.assignment_id
1404: and ita.organization_id = ppaf.organization_id;

Line 1410: p_check_column1 => 'IRC_OFFERS.APPLICANT_ASSIGNMENT_ID'

1406: Begin
1407: hr_utility.set_location('Entering:'||l_proc,10);
1408: --
1409: if hr_multi_message.no_exclusive_error(
1410: p_check_column1 => 'IRC_OFFERS.APPLICANT_ASSIGNMENT_ID'
1411: ,p_check_column2 => 'IRC_OFFERS.OFFER_ASSIGNMENT_ID'
1412: ,p_check_column3 => 'IRC_OFFERS.VACANCY_ID'
1413: ) then
1414: --

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

1407: hr_utility.set_location('Entering:'||l_proc,10);
1408: --
1409: if hr_multi_message.no_exclusive_error(
1410: p_check_column1 => 'IRC_OFFERS.APPLICANT_ASSIGNMENT_ID'
1411: ,p_check_column2 => 'IRC_OFFERS.OFFER_ASSIGNMENT_ID'
1412: ,p_check_column3 => 'IRC_OFFERS.VACANCY_ID'
1413: ) then
1414: --
1415: -- Only proceed with validation if :

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

1408: --
1409: if hr_multi_message.no_exclusive_error(
1410: p_check_column1 => 'IRC_OFFERS.APPLICANT_ASSIGNMENT_ID'
1411: ,p_check_column2 => 'IRC_OFFERS.OFFER_ASSIGNMENT_ID'
1412: ,p_check_column3 => 'IRC_OFFERS.VACANCY_ID'
1413: ) then
1414: --
1415: -- Only proceed with validation if :
1416: -- a) The current g_old_rec is current and

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

1493: --
1494: exception
1495: when app_exception.application_exception then
1496: if hr_multi_message.exception_add
1497: (p_associated_column1 => 'IRC_OFFERS.TEMPLATE_ID'
1498: ) then
1499: hr_utility.set_location(' Leaving:'|| l_proc, 100);
1500: raise;
1501: end if;

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

1522: --
1523: -- {End Of Comments}
1524: -- ----------------------------------------------------------------------------
1525: Procedure gen_offer_version
1526: (p_offer_version out nocopy irc_offers.offer_version%TYPE
1527: ,p_applicant_assignment_id in irc_offers.applicant_assignment_id%TYPE
1528: ) IS
1529: --
1530: l_proc varchar2(72) := g_package || 'gen_offer_version';

Line 1527: ,p_applicant_assignment_id in irc_offers.applicant_assignment_id%TYPE

1523: -- {End Of Comments}
1524: -- ----------------------------------------------------------------------------
1525: Procedure gen_offer_version
1526: (p_offer_version out nocopy irc_offers.offer_version%TYPE
1527: ,p_applicant_assignment_id in irc_offers.applicant_assignment_id%TYPE
1528: ) IS
1529: --
1530: l_proc varchar2(72) := g_package || 'gen_offer_version';
1531: l_offer_version irc_offers.offer_version%TYPE;

Line 1531: l_offer_version irc_offers.offer_version%TYPE;

1527: ,p_applicant_assignment_id in irc_offers.applicant_assignment_id%TYPE
1528: ) IS
1529: --
1530: l_proc varchar2(72) := g_package || 'gen_offer_version';
1531: l_offer_version irc_offers.offer_version%TYPE;
1532: --
1533: cursor csr_get_offer_version is
1534: select nvl(max(offer_version),0) + 1
1535: from irc_offers

Line 1535: from irc_offers

1531: l_offer_version irc_offers.offer_version%TYPE;
1532: --
1533: cursor csr_get_offer_version is
1534: select nvl(max(offer_version),0) + 1
1535: from irc_offers
1536: where applicant_assignment_id = p_applicant_assignment_id;
1537: --
1538: Begin
1539: hr_utility.set_location('Entering:'||l_proc,10);

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

1556: --
1557: exception
1558: when app_exception.application_exception then
1559: if hr_multi_message.exception_add
1560: (p_associated_column1 => 'IRC_OFFERS.OFFER_VERSION'
1561: ) then
1562: hr_utility.set_location(' Leaving:'|| l_proc, 30);
1563: raise;
1564: end if;

Line 1618: (p_latest_offer in irc_offers.latest_offer%TYPE

1614: --
1615: -- {End Of Comments}
1616: -- ----------------------------------------------------------------------------
1617: Procedure chk_latest_offer
1618: (p_latest_offer in irc_offers.latest_offer%TYPE
1619: ,p_offer_id in irc_offers.offer_id%TYPE
1620: ,p_offer_status in irc_offers.offer_status%TYPE
1621: ,p_applicant_assignment_id in irc_offers.applicant_assignment_id%TYPE
1622: ,p_effective_date in date

Line 1619: ,p_offer_id in irc_offers.offer_id%TYPE

1615: -- {End Of Comments}
1616: -- ----------------------------------------------------------------------------
1617: Procedure chk_latest_offer
1618: (p_latest_offer in irc_offers.latest_offer%TYPE
1619: ,p_offer_id in irc_offers.offer_id%TYPE
1620: ,p_offer_status in irc_offers.offer_status%TYPE
1621: ,p_applicant_assignment_id in irc_offers.applicant_assignment_id%TYPE
1622: ,p_effective_date in date
1623: ,p_object_version_number in irc_offers.object_version_number%TYPE

Line 1620: ,p_offer_status in irc_offers.offer_status%TYPE

1616: -- ----------------------------------------------------------------------------
1617: Procedure chk_latest_offer
1618: (p_latest_offer in irc_offers.latest_offer%TYPE
1619: ,p_offer_id in irc_offers.offer_id%TYPE
1620: ,p_offer_status in irc_offers.offer_status%TYPE
1621: ,p_applicant_assignment_id in irc_offers.applicant_assignment_id%TYPE
1622: ,p_effective_date in date
1623: ,p_object_version_number in irc_offers.object_version_number%TYPE
1624: ) IS

Line 1621: ,p_applicant_assignment_id in irc_offers.applicant_assignment_id%TYPE

1617: Procedure chk_latest_offer
1618: (p_latest_offer in irc_offers.latest_offer%TYPE
1619: ,p_offer_id in irc_offers.offer_id%TYPE
1620: ,p_offer_status in irc_offers.offer_status%TYPE
1621: ,p_applicant_assignment_id in irc_offers.applicant_assignment_id%TYPE
1622: ,p_effective_date in date
1623: ,p_object_version_number in irc_offers.object_version_number%TYPE
1624: ) IS
1625: --

Line 1623: ,p_object_version_number in irc_offers.object_version_number%TYPE

1619: ,p_offer_id in irc_offers.offer_id%TYPE
1620: ,p_offer_status in irc_offers.offer_status%TYPE
1621: ,p_applicant_assignment_id in irc_offers.applicant_assignment_id%TYPE
1622: ,p_effective_date in date
1623: ,p_object_version_number in irc_offers.object_version_number%TYPE
1624: ) IS
1625: --
1626: l_proc varchar2(72) := g_package || 'chk_latest_offer';
1627: l_latest_offer number;

Line 1632: from irc_offers

1628: l_api_updating boolean;
1629: --
1630: cursor csr_latest_offer_upd is
1631: select 1
1632: from irc_offers
1633: where latest_offer = 'Y'
1634: and applicant_assignment_id = p_applicant_assignment_id
1635: and offer_id <> p_offer_id;
1636: --

Line 1639: from irc_offers

1635: and offer_id <> p_offer_id;
1636: --
1637: cursor csr_latest_offer_ins is
1638: select 1
1639: from irc_offers
1640: where latest_offer = 'Y'
1641: and applicant_assignment_id = p_applicant_assignment_id;
1642: --
1643: Begin

Line 1647: p_check_column1 => 'IRC_OFFERS.APPLICANT_ASSIGNMENT_ID'

1643: Begin
1644: hr_utility.set_location('Entering:'||l_proc,10);
1645: --
1646: if hr_multi_message.no_exclusive_error(
1647: p_check_column1 => 'IRC_OFFERS.APPLICANT_ASSIGNMENT_ID'
1648: ,p_check_column2 => 'IRC_OFFERS.OFFER_ASSIGNMENT_ID'
1649: ,p_check_column3 => 'IRC_OFFERS.VACANCY_ID'
1650: ) then
1651: --

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

1644: hr_utility.set_location('Entering:'||l_proc,10);
1645: --
1646: if hr_multi_message.no_exclusive_error(
1647: p_check_column1 => 'IRC_OFFERS.APPLICANT_ASSIGNMENT_ID'
1648: ,p_check_column2 => 'IRC_OFFERS.OFFER_ASSIGNMENT_ID'
1649: ,p_check_column3 => 'IRC_OFFERS.VACANCY_ID'
1650: ) then
1651: --
1652: -- Only proceed with validation if :

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

1645: --
1646: if hr_multi_message.no_exclusive_error(
1647: p_check_column1 => 'IRC_OFFERS.APPLICANT_ASSIGNMENT_ID'
1648: ,p_check_column2 => 'IRC_OFFERS.OFFER_ASSIGNMENT_ID'
1649: ,p_check_column3 => 'IRC_OFFERS.VACANCY_ID'
1650: ) then
1651: --
1652: -- Only proceed with validation if :
1653: -- a) The current g_old_rec is current and

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

1735: --
1736: exception
1737: when app_exception.application_exception then
1738: if hr_multi_message.exception_add
1739: (p_associated_column1 => 'IRC_OFFERS.LATEST_OFFER'
1740: ) then
1741: hr_utility.set_location(' Leaving:'|| l_proc, 70);
1742: raise;
1743: end if;

Line 1775: (p_offer_id in irc_offers.offer_id%TYPE

1771: --
1772: -- {End Of Comments}
1773: -- ----------------------------------------------------------------------------
1774: Procedure chk_offer_version_combination
1775: (p_offer_id in irc_offers.offer_id%TYPE
1776: ,p_offer_version in irc_offers.offer_version%TYPE
1777: ,p_applicant_assignment_id in irc_offers.applicant_assignment_id%TYPE
1778: ,p_object_version_number in irc_offers.object_version_number%TYPE
1779: ) IS

Line 1776: ,p_offer_version in irc_offers.offer_version%TYPE

1772: -- {End Of Comments}
1773: -- ----------------------------------------------------------------------------
1774: Procedure chk_offer_version_combination
1775: (p_offer_id in irc_offers.offer_id%TYPE
1776: ,p_offer_version in irc_offers.offer_version%TYPE
1777: ,p_applicant_assignment_id in irc_offers.applicant_assignment_id%TYPE
1778: ,p_object_version_number in irc_offers.object_version_number%TYPE
1779: ) IS
1780: --

Line 1777: ,p_applicant_assignment_id in irc_offers.applicant_assignment_id%TYPE

1773: -- ----------------------------------------------------------------------------
1774: Procedure chk_offer_version_combination
1775: (p_offer_id in irc_offers.offer_id%TYPE
1776: ,p_offer_version in irc_offers.offer_version%TYPE
1777: ,p_applicant_assignment_id in irc_offers.applicant_assignment_id%TYPE
1778: ,p_object_version_number in irc_offers.object_version_number%TYPE
1779: ) IS
1780: --
1781: l_proc varchar2(72) := g_package || 'chk_offer_version_combination';

Line 1778: ,p_object_version_number in irc_offers.object_version_number%TYPE

1774: Procedure chk_offer_version_combination
1775: (p_offer_id in irc_offers.offer_id%TYPE
1776: ,p_offer_version in irc_offers.offer_version%TYPE
1777: ,p_applicant_assignment_id in irc_offers.applicant_assignment_id%TYPE
1778: ,p_object_version_number in irc_offers.object_version_number%TYPE
1779: ) IS
1780: --
1781: l_proc varchar2(72) := g_package || 'chk_offer_version_combination';
1782: l_version number;

Line 1787: from irc_offers

1783: l_api_updating boolean;
1784: --
1785: cursor csr_version is
1786: select 1
1787: from irc_offers
1788: where offer_version = p_offer_version
1789: and applicant_assignment_id = p_applicant_assignment_id;
1790: --
1791: Begin

Line 1796: p_check_column1 => 'IRC_OFFERS.APPLICANT_ASSIGNMENT_ID'

1792: --
1793: hr_utility.set_location(' Entering:'||l_proc,10);
1794: --
1795: if hr_multi_message.no_exclusive_error(
1796: p_check_column1 => 'IRC_OFFERS.APPLICANT_ASSIGNMENT_ID'
1797: ,p_check_column2 => 'IRC_OFFERS.OFFER_ASSIGNMENT_ID'
1798: ,p_check_column3 => 'IRC_OFFERS.VACANCY_ID'
1799: ) then
1800: --

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

1793: hr_utility.set_location(' Entering:'||l_proc,10);
1794: --
1795: if hr_multi_message.no_exclusive_error(
1796: p_check_column1 => 'IRC_OFFERS.APPLICANT_ASSIGNMENT_ID'
1797: ,p_check_column2 => 'IRC_OFFERS.OFFER_ASSIGNMENT_ID'
1798: ,p_check_column3 => 'IRC_OFFERS.VACANCY_ID'
1799: ) then
1800: --
1801: -- Only proceed with validation if :

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

1794: --
1795: if hr_multi_message.no_exclusive_error(
1796: p_check_column1 => 'IRC_OFFERS.APPLICANT_ASSIGNMENT_ID'
1797: ,p_check_column2 => 'IRC_OFFERS.OFFER_ASSIGNMENT_ID'
1798: ,p_check_column3 => 'IRC_OFFERS.VACANCY_ID'
1799: ) then
1800: --
1801: -- Only proceed with validation if :
1802: -- a) The current g_old_rec is current and

Line 1872: (p_offer_id in irc_offers.offer_id%TYPE

1868: --
1869: -- {End Of Comments}
1870: -- ----------------------------------------------------------------------------
1871: procedure chk_offer_status
1872: (p_offer_id in irc_offers.offer_id%TYPE
1873: ,p_offer_status in irc_offers.offer_status%TYPE
1874: ,p_effective_date in date
1875: ,p_object_version_number in irc_offers.object_version_number%TYPE
1876: )IS

Line 1873: ,p_offer_status in irc_offers.offer_status%TYPE

1869: -- {End Of Comments}
1870: -- ----------------------------------------------------------------------------
1871: procedure chk_offer_status
1872: (p_offer_id in irc_offers.offer_id%TYPE
1873: ,p_offer_status in irc_offers.offer_status%TYPE
1874: ,p_effective_date in date
1875: ,p_object_version_number in irc_offers.object_version_number%TYPE
1876: )IS
1877: --

Line 1875: ,p_object_version_number in irc_offers.object_version_number%TYPE

1871: procedure chk_offer_status
1872: (p_offer_id in irc_offers.offer_id%TYPE
1873: ,p_offer_status in irc_offers.offer_status%TYPE
1874: ,p_effective_date in date
1875: ,p_object_version_number in irc_offers.object_version_number%TYPE
1876: )IS
1877: --
1878: l_proc varchar2(72) := g_package||'chk_offer_status';
1879: l_api_updating boolean;

Line 1885: p_check_column1 => 'IRC_OFFERS.APPLICANT_ASSIGNMENT_ID'

1881: begin
1882: hr_utility.set_location('Entering:'|| l_proc, 10);
1883: --
1884: if hr_multi_message.no_exclusive_error(
1885: p_check_column1 => 'IRC_OFFERS.APPLICANT_ASSIGNMENT_ID'
1886: ,p_check_column2 => 'IRC_OFFERS.OFFER_ASSIGNMENT_ID'
1887: ,p_check_column3 => 'IRC_OFFERS.VACANCY_ID'
1888: ) then
1889: --

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

1882: hr_utility.set_location('Entering:'|| l_proc, 10);
1883: --
1884: if hr_multi_message.no_exclusive_error(
1885: p_check_column1 => 'IRC_OFFERS.APPLICANT_ASSIGNMENT_ID'
1886: ,p_check_column2 => 'IRC_OFFERS.OFFER_ASSIGNMENT_ID'
1887: ,p_check_column3 => 'IRC_OFFERS.VACANCY_ID'
1888: ) then
1889: --
1890: --

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

1883: --
1884: if hr_multi_message.no_exclusive_error(
1885: p_check_column1 => 'IRC_OFFERS.APPLICANT_ASSIGNMENT_ID'
1886: ,p_check_column2 => 'IRC_OFFERS.OFFER_ASSIGNMENT_ID'
1887: ,p_check_column3 => 'IRC_OFFERS.VACANCY_ID'
1888: ) then
1889: --
1890: --
1891: -- Check mandatory parameters have been set

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

1952: hr_utility.set_location(' Leaving:'|| l_proc, 60);
1953: exception
1954: when app_exception.application_exception then
1955: if hr_multi_message.exception_add
1956: (p_associated_column1 => 'IRC_OFFERS.OFFER_STATUS'
1957: ) then
1958: hr_utility.set_location(' Leaving:'|| l_proc, 70);
1959: raise;
1960: end if;

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

1968: --
1969: -- Description:
1970: -- This procedure ensures the following:
1971: -- 1) If the offer_status is 'CLOSED' do nothing - This is because we have already
1972: -- checked for offer_status 'CLOSED' in update_offer procedure of irc_offers_api.
1973: --
1974: -- 2) If the offer is in 'HOLD' state now, and the offer_status was previously 'HOLD'
1975: -- too, throw an error saying that an offer in HOLD status cannot be updated.
1976: --

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

1995: ( p_current_offer_record in irc_iof_shd.g_rec_type
1996: )IS
1997: --
1998: l_proc varchar2(72) := g_package||'chk_offer_status_update';
1999: l_prev_offer_status irc_offers.offer_status%TYPE := irc_iof_shd.g_old_rec.offer_status;
2000: l_prev_to_prev_offer_status irc_offers.offer_status%TYPE;
2001: l_mutiple_fields_updated boolean;
2002: --
2003: cursor csr_prev_to_prev_offer_status is

Line 2000: l_prev_to_prev_offer_status irc_offers.offer_status%TYPE;

1996: )IS
1997: --
1998: l_proc varchar2(72) := g_package||'chk_offer_status_update';
1999: l_prev_offer_status irc_offers.offer_status%TYPE := irc_iof_shd.g_old_rec.offer_status;
2000: l_prev_to_prev_offer_status irc_offers.offer_status%TYPE;
2001: l_mutiple_fields_updated boolean;
2002: --
2003: cursor csr_prev_to_prev_offer_status is
2004: select ios1.offer_status

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

2136: hr_utility.set_location(' Leaving:'|| l_proc, 80);
2137: exception
2138: when app_exception.application_exception then
2139: if hr_multi_message.exception_add
2140: (p_associated_column1 => 'IRC_OFFERS.OFFER_STATUS'
2141: ) then
2142: hr_utility.set_location(' Leaving:'|| l_proc, 90);
2143: raise;
2144: end if;

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

2157: -- Pre Conditions:
2158: -- None
2159: --
2160: -- In Arguments:
2161: -- All the IRC_OFFERS table fields except object_version_number and respondent_id.
2162: --
2163: -- Post Success:
2164: -- If only one field has been updated, p_mutiple_fields_updated will be set to
2165: -- 'false'. If multiple fields have been updated, p_mutiple_fields_updated will be

Line 2279: from irc_offers

2275: ,attribute28
2276: ,attribute29
2277: ,attribute30
2278: ,object_version_number
2279: from irc_offers
2280: where offer_id = p_offer_id;
2281: --
2282: l_offer_old_rec C_Sel1%ROWTYPE;
2283: Begin

Line 2993: (p_offer_id in irc_offers.offer_id%TYPE

2989: --
2990: -- {End Of Comments}
2991: -- ----------------------------------------------------------------------------
2992: procedure chk_offer_extended_method
2993: (p_offer_id in irc_offers.offer_id%TYPE
2994: ,p_offer_extended_method in irc_offers.offer_extended_method%TYPE
2995: ,p_effective_date in date
2996: ,p_object_version_number in irc_offers.object_version_number%TYPE
2997: )IS

Line 2994: ,p_offer_extended_method in irc_offers.offer_extended_method%TYPE

2990: -- {End Of Comments}
2991: -- ----------------------------------------------------------------------------
2992: procedure chk_offer_extended_method
2993: (p_offer_id in irc_offers.offer_id%TYPE
2994: ,p_offer_extended_method in irc_offers.offer_extended_method%TYPE
2995: ,p_effective_date in date
2996: ,p_object_version_number in irc_offers.object_version_number%TYPE
2997: )IS
2998: --

Line 2996: ,p_object_version_number in irc_offers.object_version_number%TYPE

2992: procedure chk_offer_extended_method
2993: (p_offer_id in irc_offers.offer_id%TYPE
2994: ,p_offer_extended_method in irc_offers.offer_extended_method%TYPE
2995: ,p_effective_date in date
2996: ,p_object_version_number in irc_offers.object_version_number%TYPE
2997: )IS
2998: --
2999: l_proc varchar2(72) := g_package||'chk_offer_extended_method';
3000: l_api_updating boolean;

Line 3006: p_check_column1 => 'IRC_OFFERS.APPLICANT_ASSIGNMENT_ID'

3002: begin
3003: hr_utility.set_location('Entering:'|| l_proc, 10);
3004: --
3005: if hr_multi_message.no_exclusive_error(
3006: p_check_column1 => 'IRC_OFFERS.APPLICANT_ASSIGNMENT_ID'
3007: ,p_check_column2 => 'IRC_OFFERS.OFFER_ASSIGNMENT_ID'
3008: ,p_check_column3 => 'IRC_OFFERS.VACANCY_ID'
3009: ) then
3010: --

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

3003: hr_utility.set_location('Entering:'|| l_proc, 10);
3004: --
3005: if hr_multi_message.no_exclusive_error(
3006: p_check_column1 => 'IRC_OFFERS.APPLICANT_ASSIGNMENT_ID'
3007: ,p_check_column2 => 'IRC_OFFERS.OFFER_ASSIGNMENT_ID'
3008: ,p_check_column3 => 'IRC_OFFERS.VACANCY_ID'
3009: ) then
3010: --
3011: -- Check mandatory parameters have been set

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

3004: --
3005: if hr_multi_message.no_exclusive_error(
3006: p_check_column1 => 'IRC_OFFERS.APPLICANT_ASSIGNMENT_ID'
3007: ,p_check_column2 => 'IRC_OFFERS.OFFER_ASSIGNMENT_ID'
3008: ,p_check_column3 => 'IRC_OFFERS.VACANCY_ID'
3009: ) then
3010: --
3011: -- Check mandatory parameters have been set
3012: --

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

3057: hr_utility.set_location(' Leaving:'|| l_proc, 30);
3058: exception
3059: when app_exception.application_exception then
3060: if hr_multi_message.exception_add
3061: (p_associated_column1 => 'IRC_OFFERS.OFFER_EXTENDED_METHOD'
3062: ) then
3063: hr_utility.set_location(' Leaving:'|| l_proc, 40);
3064: raise;
3065: end if;

Line 3097: (p_offer_id in irc_offers.offer_id%TYPE

3093: --
3094: -- {End Of Comments}
3095: -- ----------------------------------------------------------------------------
3096: procedure chk_offer_postal_service
3097: (p_offer_id in irc_offers.offer_id%TYPE
3098: ,p_offer_postal_service in irc_offers.offer_postal_service%TYPE
3099: ,p_effective_date in date
3100: ,p_object_version_number in irc_offers.object_version_number%TYPE
3101: )IS

Line 3098: ,p_offer_postal_service in irc_offers.offer_postal_service%TYPE

3094: -- {End Of Comments}
3095: -- ----------------------------------------------------------------------------
3096: procedure chk_offer_postal_service
3097: (p_offer_id in irc_offers.offer_id%TYPE
3098: ,p_offer_postal_service in irc_offers.offer_postal_service%TYPE
3099: ,p_effective_date in date
3100: ,p_object_version_number in irc_offers.object_version_number%TYPE
3101: )IS
3102: --

Line 3100: ,p_object_version_number in irc_offers.object_version_number%TYPE

3096: procedure chk_offer_postal_service
3097: (p_offer_id in irc_offers.offer_id%TYPE
3098: ,p_offer_postal_service in irc_offers.offer_postal_service%TYPE
3099: ,p_effective_date in date
3100: ,p_object_version_number in irc_offers.object_version_number%TYPE
3101: )IS
3102: --
3103: l_proc varchar2(72) := g_package||'chk_offer_postal_service';
3104: l_api_updating boolean;

Line 3110: p_check_column1 => 'IRC_OFFERS.APPLICANT_ASSIGNMENT_ID'

3106: begin
3107: hr_utility.set_location('Entering:'|| l_proc, 10);
3108: --
3109: if hr_multi_message.no_exclusive_error(
3110: p_check_column1 => 'IRC_OFFERS.APPLICANT_ASSIGNMENT_ID'
3111: ,p_check_column2 => 'IRC_OFFERS.OFFER_ASSIGNMENT_ID'
3112: ,p_check_column3 => 'IRC_OFFERS.VACANCY_ID'
3113: ) then
3114: --

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

3107: hr_utility.set_location('Entering:'|| l_proc, 10);
3108: --
3109: if hr_multi_message.no_exclusive_error(
3110: p_check_column1 => 'IRC_OFFERS.APPLICANT_ASSIGNMENT_ID'
3111: ,p_check_column2 => 'IRC_OFFERS.OFFER_ASSIGNMENT_ID'
3112: ,p_check_column3 => 'IRC_OFFERS.VACANCY_ID'
3113: ) then
3114: --
3115: -- Check mandatory parameters have been set

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

3108: --
3109: if hr_multi_message.no_exclusive_error(
3110: p_check_column1 => 'IRC_OFFERS.APPLICANT_ASSIGNMENT_ID'
3111: ,p_check_column2 => 'IRC_OFFERS.OFFER_ASSIGNMENT_ID'
3112: ,p_check_column3 => 'IRC_OFFERS.VACANCY_ID'
3113: ) then
3114: --
3115: -- Check mandatory parameters have been set
3116: --

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

3161: hr_utility.set_location(' Leaving:'|| l_proc, 30);
3162: exception
3163: when app_exception.application_exception then
3164: if hr_multi_message.exception_add
3165: (p_associated_column1 => 'IRC_OFFERS.OFFER_POSTAL_SERVICE'
3166: ) then
3167: hr_utility.set_location(' Leaving:'|| l_proc, 40);
3168: raise;
3169: end if;

Line 3199: (p_offer_id in irc_offers.offer_id%TYPE

3195: --
3196: -- {End Of Comments}
3197: -- ----------------------------------------------------------------------------
3198: procedure chk_offer_letter
3199: (p_offer_id in irc_offers.offer_id%TYPE
3200: ,p_offer_status in irc_offers.offer_status%TYPE
3201: )IS
3202: --
3203: l_proc varchar2(72) := g_package||'chk_offer_letter';

Line 3200: ,p_offer_status in irc_offers.offer_status%TYPE

3196: -- {End Of Comments}
3197: -- ----------------------------------------------------------------------------
3198: procedure chk_offer_letter
3199: (p_offer_id in irc_offers.offer_id%TYPE
3200: ,p_offer_status in irc_offers.offer_status%TYPE
3201: )IS
3202: --
3203: l_proc varchar2(72) := g_package||'chk_offer_letter';
3204: l_offer_letter irc_offers.offer_letter%TYPE;

Line 3204: l_offer_letter irc_offers.offer_letter%TYPE;

3200: ,p_offer_status in irc_offers.offer_status%TYPE
3201: )IS
3202: --
3203: l_proc varchar2(72) := g_package||'chk_offer_letter';
3204: l_offer_letter irc_offers.offer_letter%TYPE;
3205: --
3206: cursor csr_offer_letter is
3207: select offer_letter
3208: from irc_offers

Line 3208: from irc_offers

3204: l_offer_letter irc_offers.offer_letter%TYPE;
3205: --
3206: cursor csr_offer_letter is
3207: select offer_letter
3208: from irc_offers
3209: where offer_id = p_offer_id;
3210: --
3211: begin
3212: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 3215: p_check_column1 => 'IRC_OFFERS.APPLICANT_ASSIGNMENT_ID'

3211: begin
3212: hr_utility.set_location('Entering:'|| l_proc, 10);
3213: --
3214: if hr_multi_message.no_exclusive_error(
3215: p_check_column1 => 'IRC_OFFERS.APPLICANT_ASSIGNMENT_ID'
3216: ,p_check_column2 => 'IRC_OFFERS.OFFER_ASSIGNMENT_ID'
3217: ,p_check_column3 => 'IRC_OFFERS.VACANCY_ID'
3218: ) then
3219: --

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

3212: hr_utility.set_location('Entering:'|| l_proc, 10);
3213: --
3214: if hr_multi_message.no_exclusive_error(
3215: p_check_column1 => 'IRC_OFFERS.APPLICANT_ASSIGNMENT_ID'
3216: ,p_check_column2 => 'IRC_OFFERS.OFFER_ASSIGNMENT_ID'
3217: ,p_check_column3 => 'IRC_OFFERS.VACANCY_ID'
3218: ) then
3219: --
3220: if p_offer_status = 'APPROVED'

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

3213: --
3214: if hr_multi_message.no_exclusive_error(
3215: p_check_column1 => 'IRC_OFFERS.APPLICANT_ASSIGNMENT_ID'
3216: ,p_check_column2 => 'IRC_OFFERS.OFFER_ASSIGNMENT_ID'
3217: ,p_check_column3 => 'IRC_OFFERS.VACANCY_ID'
3218: ) then
3219: --
3220: if p_offer_status = 'APPROVED'
3221: and nvl(irc_iof_shd.g_old_rec.offer_status, hr_api.g_varchar2) <>

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

3257: hr_utility.set_location(' Leaving:'|| l_proc, 50);
3258: exception
3259: when app_exception.application_exception then
3260: if hr_multi_message.exception_add
3261: (p_associated_column1 => 'IRC_OFFERS.OFFER_LETTER'
3262: ) then
3263: hr_utility.set_location(' Leaving:'|| l_proc, 60);
3264: raise;
3265: end if;

Line 3298: (p_offer_id in irc_offers.offer_id%TYPE

3294: --
3295: -- {End Of Comments}
3296: -- ----------------------------------------------------------------------------
3297: procedure chk_offer_letter_file_type
3298: (p_offer_id in irc_offers.offer_id%TYPE
3299: ,p_offer_letter_file_type in irc_offers.offer_letter_file_type%TYPE
3300: ,p_effective_date in date
3301: ,p_object_version_number in irc_offers.object_version_number%TYPE
3302: )IS

Line 3299: ,p_offer_letter_file_type in irc_offers.offer_letter_file_type%TYPE

3295: -- {End Of Comments}
3296: -- ----------------------------------------------------------------------------
3297: procedure chk_offer_letter_file_type
3298: (p_offer_id in irc_offers.offer_id%TYPE
3299: ,p_offer_letter_file_type in irc_offers.offer_letter_file_type%TYPE
3300: ,p_effective_date in date
3301: ,p_object_version_number in irc_offers.object_version_number%TYPE
3302: )IS
3303: --

Line 3301: ,p_object_version_number in irc_offers.object_version_number%TYPE

3297: procedure chk_offer_letter_file_type
3298: (p_offer_id in irc_offers.offer_id%TYPE
3299: ,p_offer_letter_file_type in irc_offers.offer_letter_file_type%TYPE
3300: ,p_effective_date in date
3301: ,p_object_version_number in irc_offers.object_version_number%TYPE
3302: )IS
3303: --
3304: l_proc varchar2(72) := g_package||'chk_offer_letter_file_type';
3305: l_api_updating boolean;

Line 3311: p_check_column1 => 'IRC_OFFERS.APPLICANT_ASSIGNMENT_ID'

3307: begin
3308: hr_utility.set_location('Entering:'|| l_proc, 10);
3309: --
3310: if hr_multi_message.no_exclusive_error(
3311: p_check_column1 => 'IRC_OFFERS.APPLICANT_ASSIGNMENT_ID'
3312: ,p_check_column2 => 'IRC_OFFERS.OFFER_ASSIGNMENT_ID'
3313: ,p_check_column3 => 'IRC_OFFERS.VACANCY_ID'
3314: ) then
3315: --

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

3308: hr_utility.set_location('Entering:'|| l_proc, 10);
3309: --
3310: if hr_multi_message.no_exclusive_error(
3311: p_check_column1 => 'IRC_OFFERS.APPLICANT_ASSIGNMENT_ID'
3312: ,p_check_column2 => 'IRC_OFFERS.OFFER_ASSIGNMENT_ID'
3313: ,p_check_column3 => 'IRC_OFFERS.VACANCY_ID'
3314: ) then
3315: --
3316: -- Check mandatory parameters have been set

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

3309: --
3310: if hr_multi_message.no_exclusive_error(
3311: p_check_column1 => 'IRC_OFFERS.APPLICANT_ASSIGNMENT_ID'
3312: ,p_check_column2 => 'IRC_OFFERS.OFFER_ASSIGNMENT_ID'
3313: ,p_check_column3 => 'IRC_OFFERS.VACANCY_ID'
3314: ) then
3315: --
3316: -- Check mandatory parameters have been set
3317: --

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

3361: hr_utility.set_location(' Leaving:'|| l_proc, 30);
3362: exception
3363: when app_exception.application_exception then
3364: if hr_multi_message.exception_add
3365: (p_associated_column1 => 'IRC_OFFERS.OFFER_LETTER_FILE_TYPE'
3366: ) then
3367: hr_utility.set_location(' Leaving:'|| l_proc, 40);
3368: raise;
3369: end if;