eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_RAA_BUS dependencies on PER_RECRUITMENT_ACTIVITIES

Line 30: , per_recruitment_activities raa

26: --
27: cursor csr_sec_grp is
28: select pbg.security_group_id
29: from per_business_groups pbg
30: , per_recruitment_activities raa
31: where raa.recruitment_activity_id = p_recruitment_activity_id
32: and pbg.business_group_id = raa.business_group_id;
33: --
34: -- Declare local variables

Line 94: , per_recruitment_activities raa

90: --
91: cursor csr_leg_code is
92: select pbg.legislation_code
93: from per_business_groups pbg
94: , per_recruitment_activities raa
95: where raa.recruitment_activity_id = p_recruitment_activity_id
96: and pbg.business_group_id = raa.business_group_id;
97: --
98: -- Declare local variables

Line 242: ,p_descflex_name => 'PER_RECRUITMENT_ACTIVITIES'

238: -- b) During insert.
239: --
240: hr_dflex_utility.ins_or_upd_descflex_attribs
241: (p_appl_short_name => 'PER'
242: ,p_descflex_name => 'PER_RECRUITMENT_ACTIVITIES'
243: ,p_attribute_category => p_rec.attribute_category
244: ,p_attribute1_name => 'ATTRIBUTE1'
245: ,p_attribute1_value => p_rec.attribute1
246: ,p_attribute2_name => 'ATTRIBUTE2'

Line 384: (p_name in per_recruitment_activities.name%TYPE

380: -- Internal Row Handler Use Only.
381: --
382: -- ----------------------------------------------------------------------------
383: procedure chk_name
384: (p_name in per_recruitment_activities.name%TYPE
385: ,p_recruitment_activity_id in
386: per_recruitment_activities.recruitment_activity_id%TYPE
387: ,p_object_version_number in
388: per_recruitment_activities.object_version_number%TYPE

Line 386: per_recruitment_activities.recruitment_activity_id%TYPE

382: -- ----------------------------------------------------------------------------
383: procedure chk_name
384: (p_name in per_recruitment_activities.name%TYPE
385: ,p_recruitment_activity_id in
386: per_recruitment_activities.recruitment_activity_id%TYPE
387: ,p_object_version_number in
388: per_recruitment_activities.object_version_number%TYPE
389: ) is
390: --

Line 388: per_recruitment_activities.object_version_number%TYPE

384: (p_name in per_recruitment_activities.name%TYPE
385: ,p_recruitment_activity_id in
386: per_recruitment_activities.recruitment_activity_id%TYPE
387: ,p_object_version_number in
388: per_recruitment_activities.object_version_number%TYPE
389: ) is
390: --
391: l_proc varchar2(72) := g_package || 'chk_name';
392: l_name varchar2(1);

Line 396: from per_recruitment_activities

392: l_name varchar2(1);
393: l_api_updating boolean;
394: cursor csr_name is
395: select null
396: from per_recruitment_activities
397: where name = p_name;
398: --
399: begin
400: hr_utility.set_location('Entering:'||l_proc,10);

Line 433: (p_associated_column1 => 'PER_RECRUITMENT_ACTIVITIES.NAME'

429: hr_utility.set_location(' Leaving:'||l_proc,50);
430: exception
431: when app_exception.application_exception then
432: if hr_multi_message.exception_add
433: (p_associated_column1 => 'PER_RECRUITMENT_ACTIVITIES.NAME'
434: ) then
435: hr_utility.set_location(' Leaving:'||l_proc,60);
436: raise;
437: end if;

Line 473: per_recruitment_activities.authorising_person_id%TYPE

469: --
470: -- ----------------------------------------------------------------------------
471: procedure chk_authorising_person_id
472: (p_authorising_person_id in
473: per_recruitment_activities.authorising_person_id%TYPE
474: ,p_date_start in
475: per_recruitment_activities.date_start%TYPE
476: ,p_recruitment_activity_id in
477: per_recruitment_activities.recruitment_activity_id%TYPE

Line 475: per_recruitment_activities.date_start%TYPE

471: procedure chk_authorising_person_id
472: (p_authorising_person_id in
473: per_recruitment_activities.authorising_person_id%TYPE
474: ,p_date_start in
475: per_recruitment_activities.date_start%TYPE
476: ,p_recruitment_activity_id in
477: per_recruitment_activities.recruitment_activity_id%TYPE
478: ,p_object_version_number in
479: per_recruitment_activities.object_version_number%TYPE

Line 477: per_recruitment_activities.recruitment_activity_id%TYPE

473: per_recruitment_activities.authorising_person_id%TYPE
474: ,p_date_start in
475: per_recruitment_activities.date_start%TYPE
476: ,p_recruitment_activity_id in
477: per_recruitment_activities.recruitment_activity_id%TYPE
478: ,p_object_version_number in
479: per_recruitment_activities.object_version_number%TYPE
480: ) is
481: --

Line 479: per_recruitment_activities.object_version_number%TYPE

475: per_recruitment_activities.date_start%TYPE
476: ,p_recruitment_activity_id in
477: per_recruitment_activities.recruitment_activity_id%TYPE
478: ,p_object_version_number in
479: per_recruitment_activities.object_version_number%TYPE
480: ) is
481: --
482: l_proc varchar2(72) := g_package || 'chk_authorising_person_id';
483: l_authorising_person_id varchar2(1);

Line 542: (p_associated_column1 => 'PER_RECRUITMENT_ACTIVITIES.AUTHORISING_PERSON_ID'

538: hr_utility.set_location(' Leaving:'||l_proc,50);
539: exception
540: when app_exception.application_exception then
541: if hr_multi_message.exception_add
542: (p_associated_column1 => 'PER_RECRUITMENT_ACTIVITIES.AUTHORISING_PERSON_ID'
543: ) then
544: hr_utility.set_location(' Leaving:'||l_proc,60);
545: raise;
546: end if;

Line 581: per_recruitment_activities.run_by_organization_id%TYPE

577: --
578: -- ----------------------------------------------------------------------------
579: procedure chk_run_by_organization_id
580: (p_run_by_organization_id in
581: per_recruitment_activities.run_by_organization_id%TYPE
582: ,p_recruitment_activity_id in
583: per_recruitment_activities.recruitment_activity_id%TYPE
584: ,p_object_version_number in
585: per_recruitment_activities.object_version_number%TYPE

Line 583: per_recruitment_activities.recruitment_activity_id%TYPE

579: procedure chk_run_by_organization_id
580: (p_run_by_organization_id in
581: per_recruitment_activities.run_by_organization_id%TYPE
582: ,p_recruitment_activity_id in
583: per_recruitment_activities.recruitment_activity_id%TYPE
584: ,p_object_version_number in
585: per_recruitment_activities.object_version_number%TYPE
586: ) is
587: --

Line 585: per_recruitment_activities.object_version_number%TYPE

581: per_recruitment_activities.run_by_organization_id%TYPE
582: ,p_recruitment_activity_id in
583: per_recruitment_activities.recruitment_activity_id%TYPE
584: ,p_object_version_number in
585: per_recruitment_activities.object_version_number%TYPE
586: ) is
587: --
588: l_proc varchar2(72) := g_package || 'chk_run_by_organization_id';
589: l_run_by_organization_id varchar2(1);

Line 626: (p_associated_column1=> 'PER_RECRUITMENT_ACTIVITIES.RUN_BY_ORGANIZATION_ID'

622: hr_utility.set_location(' Leaving:'||l_proc,40);
623: exception
624: when app_exception.application_exception then
625: if hr_multi_message.exception_add
626: (p_associated_column1=> 'PER_RECRUITMENT_ACTIVITIES.RUN_BY_ORGANIZATION_ID'
627: ) then
628: hr_utility.set_location(' Leaving:'||l_proc,50);
629: raise;
630: end if;

Line 667: per_recruitment_activities.internal_contact_person_id%TYPE

663: --
664: -- ----------------------------------------------------------------------------
665: procedure chk_internal_contact_person_id
666: (p_internal_contact_person_id in
667: per_recruitment_activities.internal_contact_person_id%TYPE
668: ,p_date_start in
669: per_recruitment_activities.date_start%TYPE
670: ,p_recruitment_activity_id in
671: per_recruitment_activities.recruitment_activity_id%TYPE

Line 669: per_recruitment_activities.date_start%TYPE

665: procedure chk_internal_contact_person_id
666: (p_internal_contact_person_id in
667: per_recruitment_activities.internal_contact_person_id%TYPE
668: ,p_date_start in
669: per_recruitment_activities.date_start%TYPE
670: ,p_recruitment_activity_id in
671: per_recruitment_activities.recruitment_activity_id%TYPE
672: ,p_object_version_number in
673: per_recruitment_activities.object_version_number%TYPE

Line 671: per_recruitment_activities.recruitment_activity_id%TYPE

667: per_recruitment_activities.internal_contact_person_id%TYPE
668: ,p_date_start in
669: per_recruitment_activities.date_start%TYPE
670: ,p_recruitment_activity_id in
671: per_recruitment_activities.recruitment_activity_id%TYPE
672: ,p_object_version_number in
673: per_recruitment_activities.object_version_number%TYPE
674: ) is
675: --

Line 673: per_recruitment_activities.object_version_number%TYPE

669: per_recruitment_activities.date_start%TYPE
670: ,p_recruitment_activity_id in
671: per_recruitment_activities.recruitment_activity_id%TYPE
672: ,p_object_version_number in
673: per_recruitment_activities.object_version_number%TYPE
674: ) is
675: --
676: l_proc varchar2(72) := g_package || 'chk_internal_contact_person_id';
677: l_internal_contact_person_id varchar2(1);

Line 738: 'PER_RECRUITMENT_ACTIVITIES.INTERNAL_CONTACT_PERSON_ID'

734: exception
735: when app_exception.application_exception then
736: if hr_multi_message.exception_add
737: (p_associated_column1 =>
738: 'PER_RECRUITMENT_ACTIVITIES.INTERNAL_CONTACT_PERSON_ID'
739: ) then
740: hr_utility.set_location(' Leaving:'||l_proc,60);
741: raise;
742: end if;

Line 753: -- PER_RECRUITMENT_ACTIVITIES.

749: -- -----------------------------------------------------------------------------
750: --
751: -- Description:
752: -- Checks that parent recruitment activity id exists in
753: -- PER_RECRUITMENT_ACTIVITIES.
754: -- Checks that parent_recruitment_activity_id is not equal to
755: -- recruitment_activity_id of current row.
756: -- Checks that parent_recruitment_activity_id is not equal to
757: -- recruiment_activity_id of any row for which parent_recruitment_activity_id

Line 785: per_recruitment_activities.parent_recruitment_activity_id%TYPE

781: --
782: -- ----------------------------------------------------------------------------
783: procedure chk_parent_recruitment_activit
784: (p_parent_recruitment_activity in
785: per_recruitment_activities.parent_recruitment_activity_id%TYPE
786: ,p_date_start in
787: per_recruitment_activities.date_start%TYPE
788: ,p_business_group_id in
789: per_recruitment_activities.business_group_id%TYPE

Line 787: per_recruitment_activities.date_start%TYPE

783: procedure chk_parent_recruitment_activit
784: (p_parent_recruitment_activity in
785: per_recruitment_activities.parent_recruitment_activity_id%TYPE
786: ,p_date_start in
787: per_recruitment_activities.date_start%TYPE
788: ,p_business_group_id in
789: per_recruitment_activities.business_group_id%TYPE
790: ,p_recruitment_activity_id in
791: per_recruitment_activities.recruitment_activity_id%TYPE

Line 789: per_recruitment_activities.business_group_id%TYPE

785: per_recruitment_activities.parent_recruitment_activity_id%TYPE
786: ,p_date_start in
787: per_recruitment_activities.date_start%TYPE
788: ,p_business_group_id in
789: per_recruitment_activities.business_group_id%TYPE
790: ,p_recruitment_activity_id in
791: per_recruitment_activities.recruitment_activity_id%TYPE
792: ,p_object_version_number in
793: per_recruitment_activities.object_version_number%TYPE

Line 791: per_recruitment_activities.recruitment_activity_id%TYPE

787: per_recruitment_activities.date_start%TYPE
788: ,p_business_group_id in
789: per_recruitment_activities.business_group_id%TYPE
790: ,p_recruitment_activity_id in
791: per_recruitment_activities.recruitment_activity_id%TYPE
792: ,p_object_version_number in
793: per_recruitment_activities.object_version_number%TYPE
794: ) is
795: --

Line 793: per_recruitment_activities.object_version_number%TYPE

789: per_recruitment_activities.business_group_id%TYPE
790: ,p_recruitment_activity_id in
791: per_recruitment_activities.recruitment_activity_id%TYPE
792: ,p_object_version_number in
793: per_recruitment_activities.object_version_number%TYPE
794: ) is
795: --
796: l_proc varchar2(72) := g_package || 'chk_parent_recruitment_activit';
797: l_parent_recruitment_activity_ varchar2(1);

Line 802: select null from PER_RECRUITMENT_ACTIVITIES pra

798: l_recruitment_activity_id varchar2(1);
799: l_api_updating boolean;
800: --
801: cursor csr_parent_recruitment_activit is
802: select null from PER_RECRUITMENT_ACTIVITIES pra
803: where pra.recruitment_activity_id = p_parent_recruitment_activity;
804:
805: cursor csr_recruitment_activity_id is
806: select null from PER_RECRUITMENT_ACTIVITIES r1

Line 806: select null from PER_RECRUITMENT_ACTIVITIES r1

802: select null from PER_RECRUITMENT_ACTIVITIES pra
803: where pra.recruitment_activity_id = p_parent_recruitment_activity;
804:
805: cursor csr_recruitment_activity_id is
806: select null from PER_RECRUITMENT_ACTIVITIES r1
807: where r1.business_group_id = p_business_group_id and
808: p_recruitment_activity_id <> r1.recruitment_activity_id
809: and r1.recruitment_activity_id=p_parent_recruitment_activity
810: and p_date_start between r1.date_start and nvl(r1.date_end, hr_api.g_eot)

Line 812: from per_recruitment_activities r2 connect by

808: p_recruitment_activity_id <> r1.recruitment_activity_id
809: and r1.recruitment_activity_id=p_parent_recruitment_activity
810: and p_date_start between r1.date_start and nvl(r1.date_end, hr_api.g_eot)
811: and r1.recruitment_activity_id not in (select r2.recruitment_activity_id
812: from per_recruitment_activities r2 connect by
813: r2.parent_recruitment_activity_id = prior r2.recruitment_activity_id
814: start with r2.parent_recruitment_activity_id = p_recruitment_activity_id);
815: --
816: begin

Line 833: -- PER_RECRUITMENT_ACTIVITIES.

829: per_raa_shd.g_old_rec.recruitment_activity_id))
830: or (NOT l_api_updating) then
831:
832: -- Checks that parent recruitment activity id exists in
833: -- PER_RECRUITMENT_ACTIVITIES.
834: hr_utility.set_location(l_proc,30);
835: open csr_parent_recruitment_activit;
836: fetch csr_parent_recruitment_activit into l_parent_recruitment_activity_;
837: if csr_parent_recruitment_activit%NOTFOUND then

Line 876: 'PER_RECRUITMENT_ACTIVITIES.PARENT_RECRUITMENT_ACTIVITY_ID'

872: exception
873: when app_exception.application_exception then
874: if hr_multi_message.exception_add
875: (p_associated_column1 =>
876: 'PER_RECRUITMENT_ACTIVITIES.PARENT_RECRUITMENT_ACTIVITY_ID'
877: ) then
878: hr_utility.set_location(' Leaving:'||l_proc,70);
879: raise;
880: end if;

Line 916: per_recruitment_activities.currency_code%TYPE

912: --
913: -- ----------------------------------------------------------------------------
914: procedure chk_currency_code
915: (p_currency_code in
916: per_recruitment_activities.currency_code%TYPE
917: ,p_date_start in
918: per_recruitment_activities.date_start%TYPE
919: ,p_recruitment_activity_id in
920: per_recruitment_activities.recruitment_activity_id%TYPE

Line 918: per_recruitment_activities.date_start%TYPE

914: procedure chk_currency_code
915: (p_currency_code in
916: per_recruitment_activities.currency_code%TYPE
917: ,p_date_start in
918: per_recruitment_activities.date_start%TYPE
919: ,p_recruitment_activity_id in
920: per_recruitment_activities.recruitment_activity_id%TYPE
921: ,p_object_version_number in
922: per_recruitment_activities.object_version_number%TYPE

Line 920: per_recruitment_activities.recruitment_activity_id%TYPE

916: per_recruitment_activities.currency_code%TYPE
917: ,p_date_start in
918: per_recruitment_activities.date_start%TYPE
919: ,p_recruitment_activity_id in
920: per_recruitment_activities.recruitment_activity_id%TYPE
921: ,p_object_version_number in
922: per_recruitment_activities.object_version_number%TYPE
923: ) is
924: --

Line 922: per_recruitment_activities.object_version_number%TYPE

918: per_recruitment_activities.date_start%TYPE
919: ,p_recruitment_activity_id in
920: per_recruitment_activities.recruitment_activity_id%TYPE
921: ,p_object_version_number in
922: per_recruitment_activities.object_version_number%TYPE
923: ) is
924: --
925: l_proc varchar2(72) := g_package || 'chk_currency_code';
926: l_currency_code varchar2(1);

Line 966: 'PER_RECRUITMENT_ACTIVITIES.CURRENCY_CODE'

962: exception
963: when app_exception.application_exception then
964: if hr_multi_message.exception_add
965: (p_associated_column1 =>
966: 'PER_RECRUITMENT_ACTIVITIES.CURRENCY_CODE'
967: ) then
968: hr_utility.set_location(' Leaving:'||l_proc,50);
969: raise;
970: end if;

Line 1004: per_recruitment_activities.recruiting_site_id%TYPE

1000: --
1001: -- ----------------------------------------------------------------------------
1002: procedure chk_recruiting_site_id
1003: (p_recruiting_site_id in
1004: per_recruitment_activities.recruiting_site_id%TYPE
1005: ,p_recruitment_activity_id in
1006: per_recruitment_activities.RECRUITMENT_ACTIVITY_ID%TYPE
1007: ,p_object_version_number in
1008: per_recruitment_activities.OBJECT_VERSION_NUMBER%TYPE

Line 1006: per_recruitment_activities.RECRUITMENT_ACTIVITY_ID%TYPE

1002: procedure chk_recruiting_site_id
1003: (p_recruiting_site_id in
1004: per_recruitment_activities.recruiting_site_id%TYPE
1005: ,p_recruitment_activity_id in
1006: per_recruitment_activities.RECRUITMENT_ACTIVITY_ID%TYPE
1007: ,p_object_version_number in
1008: per_recruitment_activities.OBJECT_VERSION_NUMBER%TYPE
1009: ) is
1010: --

Line 1008: per_recruitment_activities.OBJECT_VERSION_NUMBER%TYPE

1004: per_recruitment_activities.recruiting_site_id%TYPE
1005: ,p_recruitment_activity_id in
1006: per_recruitment_activities.RECRUITMENT_ACTIVITY_ID%TYPE
1007: ,p_object_version_number in
1008: per_recruitment_activities.OBJECT_VERSION_NUMBER%TYPE
1009: ) is
1010: --
1011: l_proc varchar2(72) := g_package || 'chk_recruiting_site_id';
1012: l_recruiting_site_id varchar2(1);

Line 1049: 'PER_RECRUITMENT_ACTIVITIES.RECRUITING_SITE_ID'

1045: exception
1046: when app_exception.application_exception then
1047: if hr_multi_message.exception_add
1048: (p_associated_column1 =>
1049: 'PER_RECRUITMENT_ACTIVITIES.RECRUITING_SITE_ID'
1050: ) then
1051: hr_utility.set_location(' Leaving:'||l_proc,50);
1052: raise;
1053: end if;

Line 1087: per_recruitment_activities.POSTING_CONTENT_ID%TYPE

1083: --
1084: -- ----------------------------------------------------------------------------
1085: procedure chk_posting_content_id
1086: (p_posting_content_id in
1087: per_recruitment_activities.POSTING_CONTENT_ID%TYPE
1088: ,p_recruitment_activity_id in
1089: per_recruitment_activities.RECRUITMENT_ACTIVITY_ID%TYPE
1090: ,p_object_version_number in
1091: per_recruitment_activities.OBJECT_VERSION_NUMBER%TYPE

Line 1089: per_recruitment_activities.RECRUITMENT_ACTIVITY_ID%TYPE

1085: procedure chk_posting_content_id
1086: (p_posting_content_id in
1087: per_recruitment_activities.POSTING_CONTENT_ID%TYPE
1088: ,p_recruitment_activity_id in
1089: per_recruitment_activities.RECRUITMENT_ACTIVITY_ID%TYPE
1090: ,p_object_version_number in
1091: per_recruitment_activities.OBJECT_VERSION_NUMBER%TYPE
1092: ) is
1093: --

Line 1091: per_recruitment_activities.OBJECT_VERSION_NUMBER%TYPE

1087: per_recruitment_activities.POSTING_CONTENT_ID%TYPE
1088: ,p_recruitment_activity_id in
1089: per_recruitment_activities.RECRUITMENT_ACTIVITY_ID%TYPE
1090: ,p_object_version_number in
1091: per_recruitment_activities.OBJECT_VERSION_NUMBER%TYPE
1092: ) is
1093: --
1094: l_proc varchar2(72) := g_package || 'chk_posting_content_id';
1095: l_posting_content_id varchar2(1);

Line 1132: 'PER_RECRUITMENT_ACTIVITIES.POSTING_CONTENT_ID'

1128: exception
1129: when app_exception.application_exception then
1130: if hr_multi_message.exception_add
1131: (p_associated_column1 =>
1132: 'PER_RECRUITMENT_ACTIVITIES.POSTING_CONTENT_ID'
1133: ) then
1134: hr_utility.set_location(' Leaving:'||l_proc,50);
1135: raise;
1136: end if;

Line 1172: per_recruitment_activities.DATE_START%TYPE

1168: --
1169: -- ----------------------------------------------------------------------------
1170: procedure chk_dates
1171: (p_date_start in
1172: per_recruitment_activities.DATE_START%TYPE
1173: ,p_date_end in
1174: per_recruitment_activities.DATE_END%TYPE
1175: ,p_recruitment_activity_id in
1176: per_recruitment_activities.RECRUITMENT_ACTIVITY_ID%TYPE

Line 1174: per_recruitment_activities.DATE_END%TYPE

1170: procedure chk_dates
1171: (p_date_start in
1172: per_recruitment_activities.DATE_START%TYPE
1173: ,p_date_end in
1174: per_recruitment_activities.DATE_END%TYPE
1175: ,p_recruitment_activity_id in
1176: per_recruitment_activities.RECRUITMENT_ACTIVITY_ID%TYPE
1177: ,p_object_version_number in
1178: per_recruitment_activities.OBJECT_VERSION_NUMBER%TYPE

Line 1176: per_recruitment_activities.RECRUITMENT_ACTIVITY_ID%TYPE

1172: per_recruitment_activities.DATE_START%TYPE
1173: ,p_date_end in
1174: per_recruitment_activities.DATE_END%TYPE
1175: ,p_recruitment_activity_id in
1176: per_recruitment_activities.RECRUITMENT_ACTIVITY_ID%TYPE
1177: ,p_object_version_number in
1178: per_recruitment_activities.OBJECT_VERSION_NUMBER%TYPE
1179: ) is
1180: --

Line 1178: per_recruitment_activities.OBJECT_VERSION_NUMBER%TYPE

1174: per_recruitment_activities.DATE_END%TYPE
1175: ,p_recruitment_activity_id in
1176: per_recruitment_activities.RECRUITMENT_ACTIVITY_ID%TYPE
1177: ,p_object_version_number in
1178: per_recruitment_activities.OBJECT_VERSION_NUMBER%TYPE
1179: ) is
1180: --
1181: l_proc varchar2(72) := g_package || 'chk_date_start';
1182: l_api_updating boolean;

Line 1200: (p_associated_column1 => 'PER_RECRUITMENT_ACTIVITIES.DATE_START'

1196: hr_utility.set_location(l_proc,30);
1197: if p_date_start is null then
1198: fnd_message.set_name('PER','PER_289438_RAA_START_DATE_REQ');
1199: hr_multi_message.add
1200: (p_associated_column1 => 'PER_RECRUITMENT_ACTIVITIES.DATE_START'
1201: );
1202: -- Call to raise any errors on multi-message list
1203: hr_multi_message.end_validation_set;
1204: else

Line 1210: (p_associated_column1 => 'PER_RECRUITMENT_ACTIVITIES.DATE_START'

1206: hr_utility.set_location(l_proc,40);
1207: if p_date_start > p_date_end then
1208: fnd_message.set_name('PER','HR_6021_ALL_START_END_DATE');
1209: hr_multi_message.add
1210: (p_associated_column1 => 'PER_RECRUITMENT_ACTIVITIES.DATE_START'
1211: ,p_associated_column2 => 'PER_RECRUITMENT_ACTIVITIES.DATE_END'
1212: );
1213: end if;
1214: end if;

Line 1211: ,p_associated_column2 => 'PER_RECRUITMENT_ACTIVITIES.DATE_END'

1207: if p_date_start > p_date_end then
1208: fnd_message.set_name('PER','HR_6021_ALL_START_END_DATE');
1209: hr_multi_message.add
1210: (p_associated_column1 => 'PER_RECRUITMENT_ACTIVITIES.DATE_START'
1211: ,p_associated_column2 => 'PER_RECRUITMENT_ACTIVITIES.DATE_END'
1212: );
1213: end if;
1214: end if;
1215: end if;

Line 1251: per_recruitment_activities.TYPE%TYPE

1247: --
1248: -- ----------------------------------------------------------------------------
1249: procedure chk_type
1250: (p_type in
1251: per_recruitment_activities.TYPE%TYPE
1252: ,p_effective_date in
1253: per_recruitment_activities.DATE_START%TYPE
1254: ,p_recruitment_activity_id in
1255: per_recruitment_activities.RECRUITMENT_ACTIVITY_ID%TYPE

Line 1253: per_recruitment_activities.DATE_START%TYPE

1249: procedure chk_type
1250: (p_type in
1251: per_recruitment_activities.TYPE%TYPE
1252: ,p_effective_date in
1253: per_recruitment_activities.DATE_START%TYPE
1254: ,p_recruitment_activity_id in
1255: per_recruitment_activities.RECRUITMENT_ACTIVITY_ID%TYPE
1256: ,p_object_version_number in
1257: per_recruitment_activities.OBJECT_VERSION_NUMBER%TYPE

Line 1255: per_recruitment_activities.RECRUITMENT_ACTIVITY_ID%TYPE

1251: per_recruitment_activities.TYPE%TYPE
1252: ,p_effective_date in
1253: per_recruitment_activities.DATE_START%TYPE
1254: ,p_recruitment_activity_id in
1255: per_recruitment_activities.RECRUITMENT_ACTIVITY_ID%TYPE
1256: ,p_object_version_number in
1257: per_recruitment_activities.OBJECT_VERSION_NUMBER%TYPE
1258: ) is
1259: --

Line 1257: per_recruitment_activities.OBJECT_VERSION_NUMBER%TYPE

1253: per_recruitment_activities.DATE_START%TYPE
1254: ,p_recruitment_activity_id in
1255: per_recruitment_activities.RECRUITMENT_ACTIVITY_ID%TYPE
1256: ,p_object_version_number in
1257: per_recruitment_activities.OBJECT_VERSION_NUMBER%TYPE
1258: ) is
1259: --
1260: l_proc varchar2(72) := g_package || 'chk_date_end';
1261: l_api_updating boolean;

Line 1293: 'PER_RECRUITMENT_ACTIVITIES.TYPE'

1289: exception
1290: when app_exception.application_exception then
1291: if hr_multi_message.exception_add
1292: (p_associated_column1 =>
1293: 'PER_RECRUITMENT_ACTIVITIES.TYPE'
1294: ) then
1295: hr_utility.set_location(' Leaving:'||l_proc,50);
1296: raise;
1297: end if;

Line 1332: per_recruitment_activities.DATE_CLOSING%TYPE

1328: --
1329: -- ----------------------------------------------------------------------------
1330: procedure chk_date_closing
1331: (p_date_closing in
1332: per_recruitment_activities.DATE_CLOSING%TYPE
1333: ,p_date_start in
1334: per_recruitment_activities.DATE_START%TYPE
1335: ,p_recruitment_activity_id in
1336: per_recruitment_activities.RECRUITMENT_ACTIVITY_ID%TYPE

Line 1334: per_recruitment_activities.DATE_START%TYPE

1330: procedure chk_date_closing
1331: (p_date_closing in
1332: per_recruitment_activities.DATE_CLOSING%TYPE
1333: ,p_date_start in
1334: per_recruitment_activities.DATE_START%TYPE
1335: ,p_recruitment_activity_id in
1336: per_recruitment_activities.RECRUITMENT_ACTIVITY_ID%TYPE
1337: ,p_object_version_number in
1338: per_recruitment_activities.OBJECT_VERSION_NUMBER%TYPE

Line 1336: per_recruitment_activities.RECRUITMENT_ACTIVITY_ID%TYPE

1332: per_recruitment_activities.DATE_CLOSING%TYPE
1333: ,p_date_start in
1334: per_recruitment_activities.DATE_START%TYPE
1335: ,p_recruitment_activity_id in
1336: per_recruitment_activities.RECRUITMENT_ACTIVITY_ID%TYPE
1337: ,p_object_version_number in
1338: per_recruitment_activities.OBJECT_VERSION_NUMBER%TYPE
1339: ) is
1340: --

Line 1338: per_recruitment_activities.OBJECT_VERSION_NUMBER%TYPE

1334: per_recruitment_activities.DATE_START%TYPE
1335: ,p_recruitment_activity_id in
1336: per_recruitment_activities.RECRUITMENT_ACTIVITY_ID%TYPE
1337: ,p_object_version_number in
1338: per_recruitment_activities.OBJECT_VERSION_NUMBER%TYPE
1339: ) is
1340: --
1341: l_proc varchar2(72) := g_package || 'chk_date_closing';
1342: l_api_updating boolean;

Line 1371: 'PER_RECRUITMENT_ACTIVITIES.DATE_CLOSING'

1367: exception
1368: when app_exception.application_exception then
1369: if hr_multi_message.exception_add
1370: (p_associated_column1 =>
1371: 'PER_RECRUITMENT_ACTIVITIES.DATE_CLOSING'
1372: ) then
1373: hr_utility.set_location(' Leaving:'||l_proc,50);
1374: raise;
1375: end if;

Line 1410: per_recruitment_activities.STATUS%TYPE

1406: --
1407: -- ----------------------------------------------------------------------------
1408: procedure chk_status
1409: (p_status in
1410: per_recruitment_activities.STATUS%TYPE
1411: ,p_effective_date in
1412: per_recruitment_activities.DATE_START%TYPE
1413: ,p_recruitment_activity_id in
1414: per_recruitment_activities.RECRUITMENT_ACTIVITY_ID%TYPE

Line 1412: per_recruitment_activities.DATE_START%TYPE

1408: procedure chk_status
1409: (p_status in
1410: per_recruitment_activities.STATUS%TYPE
1411: ,p_effective_date in
1412: per_recruitment_activities.DATE_START%TYPE
1413: ,p_recruitment_activity_id in
1414: per_recruitment_activities.RECRUITMENT_ACTIVITY_ID%TYPE
1415: ,p_object_version_number in
1416: per_recruitment_activities.OBJECT_VERSION_NUMBER%TYPE

Line 1414: per_recruitment_activities.RECRUITMENT_ACTIVITY_ID%TYPE

1410: per_recruitment_activities.STATUS%TYPE
1411: ,p_effective_date in
1412: per_recruitment_activities.DATE_START%TYPE
1413: ,p_recruitment_activity_id in
1414: per_recruitment_activities.RECRUITMENT_ACTIVITY_ID%TYPE
1415: ,p_object_version_number in
1416: per_recruitment_activities.OBJECT_VERSION_NUMBER%TYPE
1417: ) is
1418: --

Line 1416: per_recruitment_activities.OBJECT_VERSION_NUMBER%TYPE

1412: per_recruitment_activities.DATE_START%TYPE
1413: ,p_recruitment_activity_id in
1414: per_recruitment_activities.RECRUITMENT_ACTIVITY_ID%TYPE
1415: ,p_object_version_number in
1416: per_recruitment_activities.OBJECT_VERSION_NUMBER%TYPE
1417: ) is
1418: --
1419: l_proc varchar2(72) := g_package || 'chk_date_end';
1420: l_status varchar2(1);

Line 1453: 'PER_RECRUITMENT_ACTIVITIES.STATUS'

1449: exception
1450: when app_exception.application_exception then
1451: if hr_multi_message.exception_add
1452: (p_associated_column1 =>
1453: 'PER_RECRUITMENT_ACTIVITIES.STATUS'
1454: ) then
1455: hr_utility.set_location(' Leaving:'||l_proc,50);
1456: raise;
1457: end if;

Line 1491: per_recruitment_activities.ACTUAL_COST%TYPE

1487: --
1488: -- ----------------------------------------------------------------------------
1489: procedure chk_actual_cost
1490: (p_actual_cost in
1491: per_recruitment_activities.ACTUAL_COST%TYPE
1492: ,p_recruitment_activity_id in
1493: per_recruitment_activities.RECRUITMENT_ACTIVITY_ID%TYPE
1494: ,p_object_version_number in
1495: per_recruitment_activities.OBJECT_VERSION_NUMBER%TYPE

Line 1493: per_recruitment_activities.RECRUITMENT_ACTIVITY_ID%TYPE

1489: procedure chk_actual_cost
1490: (p_actual_cost in
1491: per_recruitment_activities.ACTUAL_COST%TYPE
1492: ,p_recruitment_activity_id in
1493: per_recruitment_activities.RECRUITMENT_ACTIVITY_ID%TYPE
1494: ,p_object_version_number in
1495: per_recruitment_activities.OBJECT_VERSION_NUMBER%TYPE
1496: ) is
1497: --

Line 1495: per_recruitment_activities.OBJECT_VERSION_NUMBER%TYPE

1491: per_recruitment_activities.ACTUAL_COST%TYPE
1492: ,p_recruitment_activity_id in
1493: per_recruitment_activities.RECRUITMENT_ACTIVITY_ID%TYPE
1494: ,p_object_version_number in
1495: per_recruitment_activities.OBJECT_VERSION_NUMBER%TYPE
1496: ) is
1497: --
1498: l_proc varchar2(72) := g_package || 'chk_actual_cost';
1499: l_api_updating boolean;

Line 1527: 'PER_RECRUITMENT_ACTIVITIES.ACTUAL_COST'

1523: exception
1524: when app_exception.application_exception then
1525: if hr_multi_message.exception_add
1526: (p_associated_column1 =>
1527: 'PER_RECRUITMENT_ACTIVITIES.ACTUAL_COST'
1528: ) then
1529: hr_utility.set_location(' Leaving:'||l_proc,50);
1530: raise;
1531: end if;

Line 1566: per_recruitment_activities.PLANNED_COST%TYPE

1562: --
1563: -- ----------------------------------------------------------------------------
1564: procedure chk_planned_cost
1565: (p_planned_cost in
1566: per_recruitment_activities.PLANNED_COST%TYPE
1567: ,p_recruitment_activity_id in
1568: per_recruitment_activities.RECRUITMENT_ACTIVITY_ID%TYPE
1569: ,p_object_version_number in
1570: per_recruitment_activities.OBJECT_VERSION_NUMBER%TYPE

Line 1568: per_recruitment_activities.RECRUITMENT_ACTIVITY_ID%TYPE

1564: procedure chk_planned_cost
1565: (p_planned_cost in
1566: per_recruitment_activities.PLANNED_COST%TYPE
1567: ,p_recruitment_activity_id in
1568: per_recruitment_activities.RECRUITMENT_ACTIVITY_ID%TYPE
1569: ,p_object_version_number in
1570: per_recruitment_activities.OBJECT_VERSION_NUMBER%TYPE
1571: ) is
1572: --

Line 1570: per_recruitment_activities.OBJECT_VERSION_NUMBER%TYPE

1566: per_recruitment_activities.PLANNED_COST%TYPE
1567: ,p_recruitment_activity_id in
1568: per_recruitment_activities.RECRUITMENT_ACTIVITY_ID%TYPE
1569: ,p_object_version_number in
1570: per_recruitment_activities.OBJECT_VERSION_NUMBER%TYPE
1571: ) is
1572: --
1573: l_proc varchar2(72) := g_package || 'chk_planned_cost';
1574: l_api_updating boolean;

Line 1602: 'PER_RECRUITMENT_ACTIVITIES.PLANNED_COST'

1598: exception
1599: when app_exception.application_exception then
1600: if hr_multi_message.exception_add
1601: (p_associated_column1 =>
1602: 'PER_RECRUITMENT_ACTIVITIES.PLANNED_COST'
1603: ) then
1604: hr_utility.set_location(' Leaving:'||l_proc,50);
1605: raise;
1606: end if;