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.PQP_GB_OSP_FUNCTIONS dependencies on HR_LOOKUPS

Line 2362: l_column_name hr_lookups.meaning%TYPE;

2358: l_proc_name VARCHAR2(61):=
2359: g_package_name||'get_LOS_based_entitlements';
2360:
2361: i BINARY_INTEGER;
2362: l_column_name hr_lookups.meaning%TYPE;
2363: l_lookup_code hr_lookups.lookup_code%TYPE;
2364:
2365: --l_fte csr_get_asg_fte_value%ROWTYPE;
2366: l_fte_value per_assignment_budget_values.value%TYPE;

Line 2363: l_lookup_code hr_lookups.lookup_code%TYPE;

2359: g_package_name||'get_LOS_based_entitlements';
2360:
2361: i BINARY_INTEGER;
2362: l_column_name hr_lookups.meaning%TYPE;
2363: l_lookup_code hr_lookups.lookup_code%TYPE;
2364:
2365: --l_fte csr_get_asg_fte_value%ROWTYPE;
2366: l_fte_value per_assignment_budget_values.value%TYPE;
2367:

Line 2729: l_lookup_code hr_lookups.lookup_code%TYPE;

2725: IS
2726: l_user_column_id pay_user_columns.user_column_id%TYPE;
2727: l_band_ent_rows r_entitlement_parameters;
2728: l_band_percentage NUMBER;
2729: l_lookup_code hr_lookups.lookup_code%TYPE;
2730: l_row_val hr_lookups.meaning%TYPE;
2731: l_row_earn_type hr_lookups.meaning%TYPE;
2732: l_band_avg_rec_ind hr_lookups.meaning%TYPE;
2733: l_retval NUMBER;

Line 2730: l_row_val hr_lookups.meaning%TYPE;

2726: l_user_column_id pay_user_columns.user_column_id%TYPE;
2727: l_band_ent_rows r_entitlement_parameters;
2728: l_band_percentage NUMBER;
2729: l_lookup_code hr_lookups.lookup_code%TYPE;
2730: l_row_val hr_lookups.meaning%TYPE;
2731: l_row_earn_type hr_lookups.meaning%TYPE;
2732: l_band_avg_rec_ind hr_lookups.meaning%TYPE;
2733: l_retval NUMBER;
2734: l_proc_step NUMBER(38,10):=0;

Line 2731: l_row_earn_type hr_lookups.meaning%TYPE;

2727: l_band_ent_rows r_entitlement_parameters;
2728: l_band_percentage NUMBER;
2729: l_lookup_code hr_lookups.lookup_code%TYPE;
2730: l_row_val hr_lookups.meaning%TYPE;
2731: l_row_earn_type hr_lookups.meaning%TYPE;
2732: l_band_avg_rec_ind hr_lookups.meaning%TYPE;
2733: l_retval NUMBER;
2734: l_proc_step NUMBER(38,10):=0;
2735: l_proc_name VARCHAR2(61):=

Line 2732: l_band_avg_rec_ind hr_lookups.meaning%TYPE;

2728: l_band_percentage NUMBER;
2729: l_lookup_code hr_lookups.lookup_code%TYPE;
2730: l_row_val hr_lookups.meaning%TYPE;
2731: l_row_earn_type hr_lookups.meaning%TYPE;
2732: l_band_avg_rec_ind hr_lookups.meaning%TYPE;
2733: l_retval NUMBER;
2734: l_proc_step NUMBER(38,10):=0;
2735: l_proc_name VARCHAR2(61):=
2736: g_package_name||'pqp_get_band_ent_parameters';

Line 2882: l_column_name hr_lookups.meaning%TYPE;

2878: l_proc_step NUMBER(38,10):=0;
2879: l_proc_name VARCHAR2(61):=
2880: g_package_name||'get_entitlement_parameters';
2881: i NUMBER;
2882: l_column_name hr_lookups.meaning%TYPE;
2883: l_lookup_code hr_lookups.lookup_code%TYPE;
2884:
2885: l_is_ent_override BOOLEAN := FALSE ;
2886: BEGIN

Line 2883: l_lookup_code hr_lookups.lookup_code%TYPE;

2879: l_proc_name VARCHAR2(61):=
2880: g_package_name||'get_entitlement_parameters';
2881: i NUMBER;
2882: l_column_name hr_lookups.meaning%TYPE;
2883: l_lookup_code hr_lookups.lookup_code%TYPE;
2884:
2885: l_is_ent_override BOOLEAN := FALSE ;
2886: BEGIN
2887:

Line 6684: debug('Call hr_api.not_exists_in_hr_lookups');

6680: IF csr_exists_in_gap_lookup%NOTFOUND
6681: THEN
6682: -- Check whether the lookup code exists
6683: -- for global security group id
6684: debug('Call hr_api.not_exists_in_hr_lookups');
6685:
6686: IF hr_api.not_exists_in_hr_lookups(p_effective_date, p_lookup_type
6687: ,p_lookup_code)
6688: THEN

Line 6686: IF hr_api.not_exists_in_hr_lookups(p_effective_date, p_lookup_type

6682: -- Check whether the lookup code exists
6683: -- for global security group id
6684: debug('Call hr_api.not_exists_in_hr_lookups');
6685:
6686: IF hr_api.not_exists_in_hr_lookups(p_effective_date, p_lookup_type
6687: ,p_lookup_code)
6688: THEN
6689: l_return := FALSE;
6690: ELSE

Line 6692: END IF; -- End if of lookup code in hr_lookups check...

6688: THEN
6689: l_return := FALSE;
6690: ELSE
6691: l_return := TRUE;
6692: END IF; -- End if of lookup code in hr_lookups check...
6693: ELSE -- exists in fnd_lookups
6694: l_return := TRUE;
6695: END IF; -- End if of lookup code in fnd_lookups check...
6696:

Line 9592: l_absence_category hr_lookups.lookup_code%TYPE ;

9588: l_proc_step NUMBER(38,10);
9589: l_proc_name VARCHAR2(61):=
9590: g_package_name||'get_range_and_absence_smp';
9591:
9592: l_absence_category hr_lookups.lookup_code%TYPE ;
9593:
9594: BEGIN
9595:
9596: IF g_debug THEN