[Home] [Help]
2348: ,p_is_ent_override IN OUT NOCOPY BOOLEAN
2349: )
2350: RETURN NUMBER
2351: IS
2352: l_user_column_id pay_user_columns.user_column_id%TYPE;
2353: l_band_ent pqp_absval_pkg.t_entitlements;
2354: l_band_entitlement NUMBER;
2355: l_retval NUMBER;
2356:
2722: ,p_error_msg OUT NOCOPY VARCHAR2
2723: )
2724: RETURN NUMBER
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;
2868: ,p_entitlement_bands_list_name IN VARCHAR2
2869: )
2870: RETURN NUMBER
2871: IS
2872: l_user_column_id pay_user_columns.user_column_id%TYPE;
2873: l_band_ent pqp_absval_pkg.t_entitlements;
2874: l_band_ent_rows r_entitlement_parameters;
2875: l_ent_parameters t_entitlement_parameters;
2876: l_band_entitlement NUMBER;
3035: 'PQP_GAP_ENTITLEMENT_BANDS'
3036: ,p_override_effective_date IN DATE DEFAULT NULL
3037: ) RETURN NUMBER
3038: IS
3039: l_user_column_id pay_user_columns.user_column_id%TYPE;
3040: l_retval NUMBER;
3041: l_row_val NUMBER := -1;
3042: l_proc_step NUMBER(38,10):=0;
3043: l_proc_name VARCHAR2(61):=
3557: l_proc_step NUMBER(38,10):=0;
3558: l_proc_name VARCHAR2(61):=
3559: g_package_name||'pqp_gb_get_no_holidays';
3560: l_abs_end_date DATE; -- Added to handle Open ended absences
3561: l_column_name pay_user_columns.user_column_name%TYPE;
3562: BEGIN
3563: IF g_debug THEN
3564: debug_enter(l_proc_name);
3565: debug('p_business_group_id:'||p_business_group_id);
3824: l_value pay_user_column_instances_f.VALUE%TYPE;
3825: l_proc_step NUMBER(38,10):=0;
3826: l_proc_name VARCHAR2(61):=
3827: g_package_name||'pqp_gb_get_no_of_work_holidays';
3828: l_column_name pay_user_columns.user_column_name%TYPE;
3829: BEGIN
3830: IF g_debug THEN
3831: debug_enter(l_proc_name);
3832: debug('p_business_group_id:'||p_business_group_id);
4091: 'PQP_GAP_ENTITLEMENT_BANDS'
4092: ,p_override_effective_date IN DATE DEFAULT NULL
4093: ) RETURN NUMBER
4094: IS
4095: l_user_column_id pay_user_columns.user_column_id%TYPE;
4096: l_retval NUMBER;
4097: l_row_val NUMBER := -1;
4098: l_proc_step NUMBER(38,10):=0;
4099: l_proc_name VARCHAR2(61):=
4237: ---- from pay_user_rows_f pur
4238: ---- where pur.user_row_id in(
4239: ---- select distinct uci.user_row_id
4240: ---- from pay_user_tables put,
4241: ---- pay_user_columns puc,
4242: ---- pay_user_column_instances_f uci
4243: ---- where put.user_table_id = puc.user_table_id
4244: ---- and uci.user_column_id = puc.user_column_id
4245: ---- and put.user_table_name = g_udt_name
4262: -- FROM pay_user_rows_f pur
4263: -- WHERE pur.user_row_id IN(
4264: -- SELECT DISTINCT uci.user_row_id
4265: -- FROM pay_user_tables put
4266: -- ,pay_user_columns puc
4267: -- ,pay_user_column_instances_f uci
4268: -- ,per_business_groups_perf pbg
4269: -- WHERE put.user_table_name = g_udt_name
4270: -- AND pbg.business_group_id =
5269: IS
5270: l_proc_step NUMBER(38,10):=0;
5271: l_proc_name VARCHAR2(61):=
5272: g_package_name||'get_osp_band_entitlements';
5273: -- l_udt_column_name pay_user_columns.user_column_name%TYPE ;
5274: l_error_code NUMBER;
5275: BEGIN
5276:
5277: IF g_debug THEN
10759: ,p_entitlement_bands_list_name IN VARCHAR2 DEFAULT
10760: 'PQP_GAP_ENTITLEMENT_BANDS'
10761: )
10762: IS
10763: l_user_column_id pay_user_columns.user_column_id%TYPE;
10764: l_band_ent pqp_absval_pkg.t_entitlements;
10765: l_band_entitlement NUMBER;
10766: l_retval NUMBER;
10767: