DBA Data[Home] [Help]

APPS.HR_API dependencies on FND_LOOKUPS

Line 967: -- |---------------------< not_exists_in_fnd_lookups >------------------------|

963: end if;
964: end not_exists_in_hrstanlookups;
965: --
966: -- ----------------------------------------------------------------------------
967: -- |---------------------< not_exists_in_fnd_lookups >------------------------|
968: -- ----------------------------------------------------------------------------
969: --
970: function not_exists_in_fnd_lookups
971: (p_effective_date in date

Line 970: function not_exists_in_fnd_lookups

966: -- ----------------------------------------------------------------------------
967: -- |---------------------< not_exists_in_fnd_lookups >------------------------|
968: -- ----------------------------------------------------------------------------
969: --
970: function not_exists_in_fnd_lookups
971: (p_effective_date in date
972: ,p_lookup_type in varchar2
973: ,p_lookup_code in varchar2
974: ) return boolean is

Line 984: from fnd_lookups

980: -- Declare Local cursors
981: --
982: cursor csr_fnd_look is
983: select null
984: from fnd_lookups
985: where lookup_code = p_lookup_code
986: and lookup_type = p_lookup_type
987: and enabled_flag = 'Y'
988: and p_effective_date between

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

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

Line 1017: end not_exists_in_fnd_lookups;

1013: else
1014: close csr_fnd_look;
1015: return false;
1016: end if;
1017: end not_exists_in_fnd_lookups;
1018: --
1019: -- ----------------------------------------------------------------------------
1020: -- |--------------------< not_exists_in_dt_hr_lookups >-----------------------|
1021: -- ----------------------------------------------------------------------------

Line 1040: -- not_exists_in_dt_fnd_lookups functions.

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

Line 1074: -- not_exists_in_dt_fnd_lookups functions.

1070: -- the vaidation_start_date to validation_end_date range of the DateTrack
1071: -- operation.
1072: -- The same issue applies to the not_exists_in_dt_hr_lookups,
1073: -- and not_exists_in_dt_hrstanlookups and
1074: -- not_exists_in_dt_fnd_lookups functions.
1075: --
1076: begin
1077: --
1078: return not_exists_in_leg_lookups

Line 1113: -- |--------------------< not_exists_in_dt_fnd_lookups >----------------------|

1109: --
1110: end not_exists_in_dt_hrstanlookups;
1111: --
1112: -- ----------------------------------------------------------------------------
1113: -- |--------------------< not_exists_in_dt_fnd_lookups >----------------------|
1114: -- ----------------------------------------------------------------------------
1115: --
1116: function not_exists_in_dt_fnd_lookups
1117: (p_effective_date in date

Line 1116: function not_exists_in_dt_fnd_lookups

1112: -- ----------------------------------------------------------------------------
1113: -- |--------------------< not_exists_in_dt_fnd_lookups >----------------------|
1114: -- ----------------------------------------------------------------------------
1115: --
1116: function not_exists_in_dt_fnd_lookups
1117: (p_effective_date in date
1118: ,p_validation_start_date in date
1119: ,p_validation_end_date in date
1120: ,p_lookup_type in varchar2

Line 1126: -- validation as not_exists_in_fnd_lookups.

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

Line 1130: return not_exists_in_fnd_lookups

1126: -- validation as not_exists_in_fnd_lookups.
1127: --
1128: begin
1129: --
1130: return not_exists_in_fnd_lookups
1131: (p_effective_date => p_effective_date
1132: ,p_lookup_type => p_lookup_type
1133: ,p_lookup_code => p_lookup_code
1134: );

Line 1136: end not_exists_in_dt_fnd_lookups;

1132: ,p_lookup_type => p_lookup_type
1133: ,p_lookup_code => p_lookup_code
1134: );
1135: --
1136: end not_exists_in_dt_fnd_lookups;
1137: --
1138: -- ----------------------------------------------------------------------------
1139: -- |-----------------------< cannot_find_prog_unit_error >--------------------|
1140: -- ----------------------------------------------------------------------------