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_ENT_BUS dependencies on PER_CALENDAR_ENTRIES

Line 30: , per_calendar_entries ent

26: --
27: cursor csr_sec_grp is
28: select pbg.security_group_id
29: from per_business_groups pbg
30: , per_calendar_entries ent
31: where ent.calendar_entry_id = p_calendar_entry_id
32: and pbg.business_group_id = ent.business_group_id;
33: --
34: -- Declare local variables

Line 94: , per_calendar_entries ent

90: --
91: cursor csr_leg_code is
92: select pbg.legislation_code
93: from per_business_groups_perf pbg
94: , per_calendar_entries ent
95: where ent.calendar_entry_id = p_calendar_entry_id
96: and pbg.business_group_id (+) = ent.business_group_id;
97: --
98: -- Declare local variables

Line 210: ,p_base_table => 'PER_CALENDAR_ENTRIES'

206: then
207: hr_api.argument_changed_error
208: (p_api_name => l_proc
209: ,p_argument => 'LEGISLATION_CODE'
210: ,p_base_table => 'PER_CALENDAR_ENTRIES'
211: );
212: end if;
213:
214: -- check identifier key is not updated

Line 221: ,p_base_table => 'PER_CALENDAR_ENTRIES'

217: then
218: hr_api.argument_changed_error
219: (p_api_name => l_proc
220: ,p_argument => 'IDENTIFIER_KEY'
221: ,p_base_table => 'PER_CALENDAR_ENTRIES'
222: );
223: end if;
224:
225:

Line 257: (p_associated_column1 => 'PER_CALENDAR_ENTRIES.NAME');

253: IF p_name IS NULL THEN
254: -- Add to MM list as non-fatal
255: fnd_message.set_name('PER','PER_289958_CAL_NAME_NULL');
256: hr_multi_message.add
257: (p_associated_column1 => 'PER_CALENDAR_ENTRIES.NAME');
258: --
259: END IF;
260: --
261: hr_utility.set_location('Leaving:'||l_proc, 40);

Line 300: (p_associated_column1 => 'PER_CALENDAR_ENTRIES.TYPE');

296: IF p_type IS NULL THEN
297: -- Add to MM list
298: fnd_message.set_name('PER','PER_289959_CAL_TYPE_NULL');
299: hr_multi_message.add
300: (p_associated_column1 => 'PER_CALENDAR_ENTRIES.TYPE');
301: --
302: ELSIF ((p_calendar_entry_id is null) or
303: ((p_calendar_entry_id is not null) and
304: (per_ent_shd.g_old_rec.type <> p_type))) then

Line 315: (p_associated_column1 => 'PER_CALENDAR_ENTRIES.TYPE');

311: then
312: -- Add to MM list
313: fnd_message.set_name('PER','PER_289960_CAL_TYPE_INV');
314: hr_multi_message.add
315: (p_associated_column1 => 'PER_CALENDAR_ENTRIES.TYPE');
316: --
317: end if;
318: END IF;
319: --

Line 390: (p_associated_column1 => 'PER_CALENDAR_ENTRIES.START_DATE');

386: if p_start_date is null then
387: -- Add to MM list
388: fnd_message.set_name('PER','PER_289961_ENT_SDATE_NULL');
389: hr_multi_message.add
390: (p_associated_column1 => 'PER_CALENDAR_ENTRIES.START_DATE');
391: end if;
392:
393: if p_end_date is NULL then
394: -- Add to MM list

Line 397: (p_associated_column1 => 'PER_CALENDAR_ENTRIES.END_DATE');

393: if p_end_date is NULL then
394: -- Add to MM list
395: fnd_message.set_name('PER','PER_289962_ENT_EDATE_NULL');
396: hr_multi_message.add
397: (p_associated_column1 => 'PER_CALENDAR_ENTRIES.END_DATE');
398: end if;
399:
400: if ((p_end_date is NOT NULL and p_start_date is NOT NULL) and
401: (p_start_date > p_end_date)) then

Line 405: (p_associated_column1 => 'PER_CALENDAR_ENTRIES.START_DATE');

401: (p_start_date > p_end_date)) then
402: -- Add to MM list
403: fnd_message.set_name('PER','PER_289963_ENT_SDATE_INV');
404: hr_multi_message.add
405: (p_associated_column1 => 'PER_CALENDAR_ENTRIES.START_DATE');
406: end if;
407: --
408:
409: -- only validate time if date is OK....

Line 416: (p_associated_column1 => 'PER_CALENDAR_ENTRIES.START_HOUR'

412: (p_end_min is NOT NULL and p_end_hour is NULL) then
413: -- Add to MM list as invalid combination passed
414: fnd_message.set_name('PER','PER_289187_CAL_ENT_TIME_INV');
415: hr_multi_message.add
416: (p_associated_column1 => 'PER_CALENDAR_ENTRIES.START_HOUR'
417: ,p_associated_column2 => 'PER_CALENDAR_ENTRIES.START_MIN'
418: ,p_associated_column3 => 'PER_CALENDAR_ENTRIES.END_HOUR'
419: ,p_associated_column4 => 'PER_CALENDAR_ENTRIES.END_MIN');
420:

Line 417: ,p_associated_column2 => 'PER_CALENDAR_ENTRIES.START_MIN'

413: -- Add to MM list as invalid combination passed
414: fnd_message.set_name('PER','PER_289187_CAL_ENT_TIME_INV');
415: hr_multi_message.add
416: (p_associated_column1 => 'PER_CALENDAR_ENTRIES.START_HOUR'
417: ,p_associated_column2 => 'PER_CALENDAR_ENTRIES.START_MIN'
418: ,p_associated_column3 => 'PER_CALENDAR_ENTRIES.END_HOUR'
419: ,p_associated_column4 => 'PER_CALENDAR_ENTRIES.END_MIN');
420:
421: else

Line 418: ,p_associated_column3 => 'PER_CALENDAR_ENTRIES.END_HOUR'

414: fnd_message.set_name('PER','PER_289187_CAL_ENT_TIME_INV');
415: hr_multi_message.add
416: (p_associated_column1 => 'PER_CALENDAR_ENTRIES.START_HOUR'
417: ,p_associated_column2 => 'PER_CALENDAR_ENTRIES.START_MIN'
418: ,p_associated_column3 => 'PER_CALENDAR_ENTRIES.END_HOUR'
419: ,p_associated_column4 => 'PER_CALENDAR_ENTRIES.END_MIN');
420:
421: else
422: if (p_start_min is NOT NULL and p_end_min is NOT NULL) or

Line 419: ,p_associated_column4 => 'PER_CALENDAR_ENTRIES.END_MIN');

415: hr_multi_message.add
416: (p_associated_column1 => 'PER_CALENDAR_ENTRIES.START_HOUR'
417: ,p_associated_column2 => 'PER_CALENDAR_ENTRIES.START_MIN'
418: ,p_associated_column3 => 'PER_CALENDAR_ENTRIES.END_HOUR'
419: ,p_associated_column4 => 'PER_CALENDAR_ENTRIES.END_MIN');
420:
421: else
422: if (p_start_min is NOT NULL and p_end_min is NOT NULL) or
423: (p_start_hour is NOT NULL and p_end_hour is NOT NULL) then

Line 432: (p_associated_column1 => 'PER_CALENDAR_ENTRIES.START_HOUR'

428: or ( nvl(to_number(p_start_hour),0) > nvl(to_number(p_end_hour),23) ) then
429:
430: fnd_message.set_name('PER','PER_289188_CAL_ENT_TIME_INV2');
431: hr_multi_message.add
432: (p_associated_column1 => 'PER_CALENDAR_ENTRIES.START_HOUR'
433: ,p_associated_column2 => 'PER_CALENDAR_ENTRIES.START_MIN'
434: ,p_associated_column3 => 'PER_CALENDAR_ENTRIES.END_HOUR'
435: ,p_associated_column4 => 'PER_CALENDAR_ENTRIES.END_MIN');
436: end if;

Line 433: ,p_associated_column2 => 'PER_CALENDAR_ENTRIES.START_MIN'

429:
430: fnd_message.set_name('PER','PER_289188_CAL_ENT_TIME_INV2');
431: hr_multi_message.add
432: (p_associated_column1 => 'PER_CALENDAR_ENTRIES.START_HOUR'
433: ,p_associated_column2 => 'PER_CALENDAR_ENTRIES.START_MIN'
434: ,p_associated_column3 => 'PER_CALENDAR_ENTRIES.END_HOUR'
435: ,p_associated_column4 => 'PER_CALENDAR_ENTRIES.END_MIN');
436: end if;
437:

Line 434: ,p_associated_column3 => 'PER_CALENDAR_ENTRIES.END_HOUR'

430: fnd_message.set_name('PER','PER_289188_CAL_ENT_TIME_INV2');
431: hr_multi_message.add
432: (p_associated_column1 => 'PER_CALENDAR_ENTRIES.START_HOUR'
433: ,p_associated_column2 => 'PER_CALENDAR_ENTRIES.START_MIN'
434: ,p_associated_column3 => 'PER_CALENDAR_ENTRIES.END_HOUR'
435: ,p_associated_column4 => 'PER_CALENDAR_ENTRIES.END_MIN');
436: end if;
437:
438: end if;

Line 435: ,p_associated_column4 => 'PER_CALENDAR_ENTRIES.END_MIN');

431: hr_multi_message.add
432: (p_associated_column1 => 'PER_CALENDAR_ENTRIES.START_HOUR'
433: ,p_associated_column2 => 'PER_CALENDAR_ENTRIES.START_MIN'
434: ,p_associated_column3 => 'PER_CALENDAR_ENTRIES.END_HOUR'
435: ,p_associated_column4 => 'PER_CALENDAR_ENTRIES.END_MIN');
436: end if;
437:
438: end if;
439: end if;

Line 592: FROM per_calendar_entries ent

588: SELECT decode (ent.HIERARCHY_ID, NULL,
589: decode (ent.VALUE_SET_ID, NULL,'O','V'),
590: 'H')
591:
592: FROM per_calendar_entries ent
593: WHERE ent.calendar_entry_id = p_calendar_entry_id
594: AND exists (select 'Y' from per_cal_entry_values env
595: where env.calendar_entry_id = p_calendar_entry_id);
596: --

Line 615: (p_associated_column1 => 'PER_CALENDAR_ENTRIES.HIERARCHY_ID'

611: THEN
612: -- raise error as only one coverage source may be chosen
613: fnd_message.set_name('PER','PER_289966_CAL_ENT_TWO_SET');
614: hr_multi_message.add
615: (p_associated_column1 => 'PER_CALENDAR_ENTRIES.HIERARCHY_ID'
616: ,p_associated_column2 => 'PER_CALENDAR_ENTRIES.VALUE_SET_ID');
617: ELSE
618: -- only validate a specific id if > 1 are not set
619:

Line 616: ,p_associated_column2 => 'PER_CALENDAR_ENTRIES.VALUE_SET_ID');

612: -- raise error as only one coverage source may be chosen
613: fnd_message.set_name('PER','PER_289966_CAL_ENT_TWO_SET');
614: hr_multi_message.add
615: (p_associated_column1 => 'PER_CALENDAR_ENTRIES.HIERARCHY_ID'
616: ,p_associated_column2 => 'PER_CALENDAR_ENTRIES.VALUE_SET_ID');
617: ELSE
618: -- only validate a specific id if > 1 are not set
619:
620: --

Line 641: (p_associated_column1 => 'PER_CALENDAR_ENTRIES.VALUE_SET_ID');

637: -- i.e. id either was not found or is not F validation type
638: fnd_message.set_name('PER','PER_289967_CAL_ENT_VS_INV');
639: fnd_message.set_token('VSET',p_value_set_id);
640: hr_multi_message.add
641: (p_associated_column1 => 'PER_CALENDAR_ENTRIES.VALUE_SET_ID');
642: else
643: close csr_VS;
644: end if;
645: end if;

Line 670: (p_associated_column1 => 'PER_CALENDAR_ENTRIES.HIERARCHY_ID');

666: close csr_HIER;
667: -- raise error as gen hierarchy is invalid
668: fnd_message.set_name('PER', 'PER_289968_CAL_ENT_HIER_INV');
669: hr_multi_message.add
670: (p_associated_column1 => 'PER_CALENDAR_ENTRIES.HIERARCHY_ID');
671: else
672: close csr_HIER;
673: end if;
674: end if;

Line 688: (p_associated_column1 => 'PER_CALENDAR_ENTRIES.ORGANIZATION_STRUCTURE_ID');

684: IF (p_organization_structure_id is not null and p_org_structure_version_id is null)
685: OR (p_organization_structure_id is null and p_org_structure_version_id is not null) THEN
686: fnd_message.set_name('PER', 'HR_289971_CAL_OS_PARAMS');
687: hr_multi_message.add
688: (p_associated_column1 => 'PER_CALENDAR_ENTRIES.ORGANIZATION_STRUCTURE_ID');
689: hr_multi_message.add
690: (p_associated_column1 => 'PER_CALENDAR_ENTRIES.ORG_STRUCTURE_VERSION_ID');
691:
692: ELSIF (p_organization_structure_id is not null and p_org_structure_version_id is not null) THEN

Line 690: (p_associated_column1 => 'PER_CALENDAR_ENTRIES.ORG_STRUCTURE_VERSION_ID');

686: fnd_message.set_name('PER', 'HR_289971_CAL_OS_PARAMS');
687: hr_multi_message.add
688: (p_associated_column1 => 'PER_CALENDAR_ENTRIES.ORGANIZATION_STRUCTURE_ID');
689: hr_multi_message.add
690: (p_associated_column1 => 'PER_CALENDAR_ENTRIES.ORG_STRUCTURE_VERSION_ID');
691:
692: ELSIF (p_organization_structure_id is not null and p_org_structure_version_id is not null) THEN
693: -- Validate Org Hier and Version
694:

Line 711: (p_associated_column1 => 'PER_CALENDAR_ENTRIES.ORG_STRUCTURE_VERSION_ID');

707: close csr_ORG_HIER;
708: -- raise error as org Hierarchy is invalid
709: fnd_message.set_name('PER', 'PER_289968_CAL_ENT_HIER_INV');
710: hr_multi_message.add
711: (p_associated_column1 => 'PER_CALENDAR_ENTRIES.ORG_STRUCTURE_VERSION_ID');
712: else
713: close csr_ORG_HIER;
714: end if;
715:

Line 758: (p_associated_column1 => 'PER_CALENDAR_ENTRIES.HIERARCHY_ID');

754: -- fnd_message.set_token('PARAM1',l_param1 );
755: if l_dummy = 'H' then -- Gen Hier evs exist
756: -- updating to diff hierarchy
757: hr_multi_message.add
758: (p_associated_column1 => 'PER_CALENDAR_ENTRIES.HIERARCHY_ID');
759: elsif l_dummy = 'V' then -- VS evs exist
760: -- updating from VS to hierarchy
761: hr_multi_message.add
762: (p_associated_column1 => 'PER_CALENDAR_ENTRIES.VALUE_SET_ID');

Line 762: (p_associated_column1 => 'PER_CALENDAR_ENTRIES.VALUE_SET_ID');

758: (p_associated_column1 => 'PER_CALENDAR_ENTRIES.HIERARCHY_ID');
759: elsif l_dummy = 'V' then -- VS evs exist
760: -- updating from VS to hierarchy
761: hr_multi_message.add
762: (p_associated_column1 => 'PER_CALENDAR_ENTRIES.VALUE_SET_ID');
763: elsif l_dummy = 'O' then -- Org Hier evs exist
764: hr_multi_message.add
765: (p_associated_column1 => 'PER_CALENDAR_ENTRIES.ORG_STRUCTURE_VERSION_ID');
766: end if;

Line 765: (p_associated_column1 => 'PER_CALENDAR_ENTRIES.ORG_STRUCTURE_VERSION_ID');

761: hr_multi_message.add
762: (p_associated_column1 => 'PER_CALENDAR_ENTRIES.VALUE_SET_ID');
763: elsif l_dummy = 'O' then -- Org Hier evs exist
764: hr_multi_message.add
765: (p_associated_column1 => 'PER_CALENDAR_ENTRIES.ORG_STRUCTURE_VERSION_ID');
766: end if;
767:
768: end if;
769: else

Line 814: (p_associated_column1 => 'PER_CALENDAR_ENTRIES.LEGISLATION_CODE');

810: IF l_value IS NULL then
811: -- Add to MM list as non-fatal
812: fnd_message.set_name('PER','PER_449075_CAL_LEG_CODE');
813: hr_multi_message.add
814: (p_associated_column1 => 'PER_CALENDAR_ENTRIES.LEGISLATION_CODE');
815: END IF;
816: --
817: END IF;
818: --

Line 843: FROM PER_CALENDAR_ENTRIES ENT

839: Procedure chk_identifier_key (p_identifier_key in VARCHAR2) IS
840: --
841: CURSOR c_unique IS
842: SELECT 'Y'
843: FROM PER_CALENDAR_ENTRIES ENT
844: WHERE ENT.IDENTIFIER_KEY = p_identifier_key;
845:
846: l_proc varchar2(72) := g_package||'chk_identifier_key';
847: l_value varchar2(240):= null;

Line 861: (p_associated_column1 => 'PER_CALENDAR_ENTRIES.identifier_key');

857: close c_unique;
858: -- Add to MM list as non-fatal
859: fnd_message.set_name('PER','PER_449074_CAL_IDK_EXISTS');
860: hr_multi_message.add
861: (p_associated_column1 => 'PER_CALENDAR_ENTRIES.identifier_key');
862: ELSE
863: close c_unique;
864: END IF;
865: --

Line 905: (p_associated_column1 => 'PER_CALENDAR_ENTRIES.LEGISLATION_CODE'

901:
902: -- Add to MM list as non-fatal
903: fnd_message.set_name('PER','PER_449076_CAL_LEG_ID_COMB');
904: hr_multi_message.add
905: (p_associated_column1 => 'PER_CALENDAR_ENTRIES.LEGISLATION_CODE'
906: ,p_associated_column2 => 'PER_CALENDAR_ENTRIES.IDENTIFIER_KEY');
907: END IF;
908: --
909: hr_utility.set_location('Leaving:'||l_proc, 40);

Line 906: ,p_associated_column2 => 'PER_CALENDAR_ENTRIES.IDENTIFIER_KEY');

902: -- Add to MM list as non-fatal
903: fnd_message.set_name('PER','PER_449076_CAL_LEG_ID_COMB');
904: hr_multi_message.add
905: (p_associated_column1 => 'PER_CALENDAR_ENTRIES.LEGISLATION_CODE'
906: ,p_associated_column2 => 'PER_CALENDAR_ENTRIES.IDENTIFIER_KEY');
907: END IF;
908: --
909: hr_utility.set_location('Leaving:'||l_proc, 40);
910: --

Line 962: (p_associated_column1 => 'PER_CALENDAR_ENTRIES.BUSINESS_GROUP_ID');

958: If p_rec.business_group_id is null then
959: If nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N') <> 'Y' then
960: fnd_message.set_name('PER', 'PER_289186_CAL_ENT_GLB_INV');
961: hr_multi_message.add
962: (p_associated_column1 => 'PER_CALENDAR_ENTRIES.BUSINESS_GROUP_ID');
963: End if;
964: End if;
965:
966: -- validate VS / Hierarchy id

Line 1051: (p_associated_column1 => 'PER_CALENDAR_ENTRIES.BUSINESS_GROUP_ID');

1047: If p_rec.business_group_id is null then
1048: If nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N') <> 'Y' then
1049: fnd_message.set_name('PER', 'PER_289186_CAL_ENT_GLB_INV');
1050: hr_multi_message.add
1051: (p_associated_column1 => 'PER_CALENDAR_ENTRIES.BUSINESS_GROUP_ID');
1052: End if;
1053: End if;
1054:
1055: -- validate VS / Hierarchy id