DBA Data[Home] [Help]

APPS.HR_API dependencies on FND_LOOKUPS

Line 971: -- |---------------------< not_exists_in_fnd_lookups >------------------------|

967: end if;
968: end not_exists_in_hrstanlookups;
969: --
970: -- ----------------------------------------------------------------------------
971: -- |---------------------< not_exists_in_fnd_lookups >------------------------|
972: -- ----------------------------------------------------------------------------
973: --
974: function not_exists_in_fnd_lookups
975: (p_effective_date in date

Line 974: function not_exists_in_fnd_lookups

970: -- ----------------------------------------------------------------------------
971: -- |---------------------< not_exists_in_fnd_lookups >------------------------|
972: -- ----------------------------------------------------------------------------
973: --
974: function not_exists_in_fnd_lookups
975: (p_effective_date in date
976: ,p_lookup_type in varchar2
977: ,p_lookup_code in varchar2
978: ) return boolean is

Line 988: from fnd_lookups

984: -- Declare Local cursors
985: --
986: cursor csr_fnd_look is
987: select null
988: from fnd_lookups
989: where lookup_code = p_lookup_code
990: and lookup_type = p_lookup_type
991: and enabled_flag = 'Y'
992: and p_effective_date between

Line 1010: hr_utility.set_location(hr_api.g_package||'not_exists_in_fnd_lookups', 10);

1006: -- If the value is not known then go onto check against the
1007: -- hr_lookups view. Just in case there has been a change to
1008: -- the system defined lookup.
1009: end if;
1010: hr_utility.set_location(hr_api.g_package||'not_exists_in_fnd_lookups', 10);
1011: --
1012: open csr_fnd_look;
1013: fetch csr_fnd_look into l_exists;
1014: if csr_fnd_look%notfound then

Line 1021: end not_exists_in_fnd_lookups;

1017: else
1018: close csr_fnd_look;
1019: return false;
1020: end if;
1021: end not_exists_in_fnd_lookups;
1022: --
1023: -- ----------------------------------------------------------------------------
1024: -- |--------------------< not_exists_in_dt_hr_lookups >-----------------------|
1025: -- ----------------------------------------------------------------------------

Line 1044: -- not_exists_in_dt_fnd_lookups functions.

1040: -- i.e. Check the lookup_code start_date_active end_date_active values span
1041: -- the vaidation_start_date to validation_end_date range of the DateTrack
1042: -- operation.
1043: -- The same issue applies to the not_exists_in_dt_hrstanlookups and
1044: -- not_exists_in_dt_fnd_lookups functions.
1045: --
1046: begin
1047: --
1048: return not_exists_in_hr_lookups

Line 1078: -- not_exists_in_dt_fnd_lookups functions.

1074: -- the vaidation_start_date to validation_end_date range of the DateTrack
1075: -- operation.
1076: -- The same issue applies to the not_exists_in_dt_hr_lookups,
1077: -- and not_exists_in_dt_hrstanlookups and
1078: -- not_exists_in_dt_fnd_lookups functions.
1079: --
1080: begin
1081: --
1082: return not_exists_in_leg_lookups

Line 1117: -- |--------------------< not_exists_in_dt_fnd_lookups >----------------------|

1113: --
1114: end not_exists_in_dt_hrstanlookups;
1115: --
1116: -- ----------------------------------------------------------------------------
1117: -- |--------------------< not_exists_in_dt_fnd_lookups >----------------------|
1118: -- ----------------------------------------------------------------------------
1119: --
1120: function not_exists_in_dt_fnd_lookups
1121: (p_effective_date in date

Line 1120: function not_exists_in_dt_fnd_lookups

1116: -- ----------------------------------------------------------------------------
1117: -- |--------------------< not_exists_in_dt_fnd_lookups >----------------------|
1118: -- ----------------------------------------------------------------------------
1119: --
1120: function not_exists_in_dt_fnd_lookups
1121: (p_effective_date in date
1122: ,p_validation_start_date in date
1123: ,p_validation_end_date in date
1124: ,p_lookup_type in varchar2

Line 1130: -- validation as not_exists_in_fnd_lookups.

1126: ) return boolean is
1127: --
1128: -- Refer to code comments in not_exists_in_dt_hr_lookups for details of
1129: -- why this procedure exists and is currently coded to do the same
1130: -- validation as not_exists_in_fnd_lookups.
1131: --
1132: begin
1133: --
1134: return not_exists_in_fnd_lookups

Line 1134: return not_exists_in_fnd_lookups

1130: -- validation as not_exists_in_fnd_lookups.
1131: --
1132: begin
1133: --
1134: return not_exists_in_fnd_lookups
1135: (p_effective_date => p_effective_date
1136: ,p_lookup_type => p_lookup_type
1137: ,p_lookup_code => p_lookup_code
1138: );

Line 1140: end not_exists_in_dt_fnd_lookups;

1136: ,p_lookup_type => p_lookup_type
1137: ,p_lookup_code => p_lookup_code
1138: );
1139: --
1140: end not_exists_in_dt_fnd_lookups;
1141: --
1142: -- ----------------------------------------------------------------------------
1143: -- |-----------------------< cannot_find_prog_unit_error >--------------------|
1144: -- ----------------------------------------------------------------------------