APPS.PER_POS_BUS dependencies on FND_COMMON_LOOKUPS

Line 796: -- FND_COMMON_LOOKUPS where the LOOKUP_TYPE is 'FREQUENCY'. (I,U)

792: -- or if WORKING_HOURS is null and FREQUENCY is not null an error
793: -- is raised
794: --
795: -- Validate the FREQUENCY value against the table
796: -- FND_COMMON_LOOKUPS where the LOOKUP_TYPE is 'FREQUENCY'. (I,U)
797: --
798: -- Validate that if the value for WORKING_HOURS is NOT NULL,
799: -- that the FREQUENCY value is valid for the WORKING_HOURS value.
800: --

Line 840: from fnd_common_lookups

836: l_api_updating boolean;
837: --
838: cursor csr_valid_freq is
839: select 'x'
840: from fnd_common_lookups
841: where lookup_type = 'FREQUENCY'
842: and lookup_code = p_frequency
843: and enabled_flag = 'Y';
844: --

Line 876: -- Check for valid frequency against fnd_common_lookups

872: fnd_message.set_name('PER','PER_52981_POS_WORK_FREQ_NULL');
873: fnd_message.raise_error;
874: end if;
875: --
876: -- Check for valid frequency against fnd_common_lookups
877: --
878: hr_utility.set_location(l_proc, 6);
879: --
880: if p_frequency is not null then

Line 921: -- FND_COMMON_LOOKUPS where the LOOKUP_TYPE is 'QUALIFYING_UNITS'.

917: -- is not null or if PROBATION_PERIOD is not null and PROBATION_PERIOS_UNITS
918: -- is null then an error is raised
919: --
920: -- Validate the value for PROBATION_PERIOD_UNITS against the table
921: -- FND_COMMON_LOOKUPS where the LOOKUP_TYPE is 'QUALIFYING_UNITS'.
922: --
923: -- Pre-conditions:
924: -- None
925: --

Line 957: from fnd_common_lookups

953: l_exists varchar2(1);
954: --
955: cursor csr_valid_unit is
956: select 'x'
957: from fnd_common_lookups
958: where lookup_type = 'QUALIFYING_UNITS'
959: and lookup_code = p_probation_period_units;
960: --
961: begin

Line 992: -- Validate probation_period_units against fnd_common_lookups

988: hr_utility.set_message(801,'HR_51365_POS_PROB_UNITS_REQ');
989: hr_utility.raise_error;
990: else
991: --
992: -- Validate probation_period_units against fnd_common_lookups
993: --
994: hr_utility.set_location(l_proc, 3);
995: --
996: if p_probation_period is not null

Line 1018: -- FND_COMMON_LOOKUPS where lookup_type = 'YES_NO'

1014: --
1015: -- Desciption :
1016: --
1017: -- Validate that allowable values are ('Y','N') against
1018: -- FND_COMMON_LOOKUPS where lookup_type = 'YES_NO'
1019: --
1020: -- Validate that on insert, REPLACEMENT_REQUIRED_FLAG must be defaulted to
1021: -- 'N' when null
1022: --

Line 1054: from fnd_common_lookups

1050: l_api_updating boolean;
1051: --
1052: cursor csr_valid_flag is
1053: select 'x'
1054: from fnd_common_lookups
1055: where lookup_type = 'YES_NO'
1056: and lookup_code = p_replacement_required_flag;
1057: --
1058: begin

Line 1075: -- Validate flag replacement_required_flag against fnd_common_lookups

1071: (nvl(per_pos_shd.g_old_rec.replacement_required_flag,hr_api.g_varchar2) <>
1072: nvl(p_replacement_required_flag,hr_api.g_varchar2))) or
1073: (NOT l_api_updating)) then
1074: --
1075: -- Validate flag replacement_required_flag against fnd_common_lookups
1076: --
1077: hr_utility.set_location(l_proc, 3);
1078: --
1079: open csr_valid_flag;

Line 1206: -- FND_COMMON_LOOKUPS where the LOOKUP_TYPE is 'POSITION_STATUS'. (I,U)

1202: --
1203: -- Desciption :
1204: --
1205: -- Validate the STATUS value against the table
1206: -- FND_COMMON_LOOKUPS where the LOOKUP_TYPE is 'POSITION_STATUS'. (I,U)
1207: --
1208: --
1209: -- Pre-conditions:
1210: -- None

Line 1260: -- Check for valid status against fnd_common_lookups

1256: (nvl(per_pos_shd.g_old_rec.status,hr_api.g_varchar2) <>
1257: nvl(p_status,hr_api.g_varchar2))) or
1258: (NOT l_api_updating)) then
1259: --
1260: -- Check for valid status against fnd_common_lookups
1261: --
1262: hr_utility.set_location(l_proc, 2);
1263: --
1264: if p_status is not null and