DBA Data[Home] [Help]

APPS.PER_FR_UPGRADE_DATA_PKG dependencies on HR_LOOKUPS

Line 102: l_meaning hr_lookups.meaning%type := hr_general.decode_lookup(p_lookup_type => 'NAME_TRANSLATIONS'

98: *************************************************************/
99: function get_translation(p_lookup_code in varchar2) return varchar2
100: IS
101: l_proc varchar2(72) := g_package||'.get_translation';
102: l_meaning hr_lookups.meaning%type := hr_general.decode_lookup(p_lookup_type => 'NAME_TRANSLATIONS'
103: ,p_lookup_code => p_lookup_code);
104: --
105: begin
106: --

Line 129: lookups for any dates. hr_lookups only gets lookup at session date

125: IS
126: --
127: /* Find which lookups are in the french lookup but not the core lookup
128: Note: fnd_lookup_values is used for the source table as we need to check
129: lookups for any dates. hr_lookups only gets lookup at session date
130: The destination table is hr_leg_lookups. This is necessary as some
131: APIs validate to this view and we need to ensure that the TAG column
132: is taken into account. This view obtains at session date, this is
133: acceptable as the API will expect the lookups to be available on

Line 295: l_upg_type_meaning hr_lookups.meaning%type := hr_general.decode_lookup(p_lookup_type => 'FR_DATA_UPGRADE_TYPES'

291: IS
292: l_status number :=0; /* Zero means upgrade OK. 1 means error */
293: l_proc varchar2(72) := g_package||'.run_upgrade';
294: --
295: l_upg_type_meaning hr_lookups.meaning%type := hr_general.decode_lookup(p_lookup_type => 'FR_DATA_UPGRADE_TYPES'
296: ,p_lookup_code => p_upgrade_type);
297: --
298: begin
299: