APPS.PER_CAGR_EVALUATION_PKG dependencies on HR_CAGR_FF_PKG

Line 551: l_cagr_FF_record hr_cagr_ff_pkg.cagr_FF_record;

547: AND p_params.effective_date BETWEEN asg.effective_start_date AND asg.effective_end_date
548: AND asg.primary_flag = 'Y';
549:
550:
551: l_cagr_FF_record hr_cagr_ff_pkg.cagr_FF_record;
552: t_eligibility_table eligibility_table;
553: v_eligibility_counter NUMBER(10) := 0;
554: t_assignments_table assignment_table; -- holds all asg ids for SC mode process
555: t_cagr_assignments_table cagr_asg_table; -- holds all cagr and asg ids for BE mode process

Line 1823: l_cagr_FF_record hr_cagr_ff_pkg.cagr_FF_record;

1819: v_parent_spine_id per_cagr_retained_rights.parent_spine_id%TYPE;
1820: v_step_id per_cagr_retained_rights.step_id%TYPE;
1821: v_from_step_id per_cagr_retained_rights.from_step_id%TYPE;
1822: v_to_step_id per_cagr_retained_rights.to_step_id%TYPE;
1823: l_cagr_FF_record hr_cagr_ff_pkg.cagr_FF_record;
1824: l_source_name varchar2(200) := NULL;
1825: v_counter NUMBER(15) := NULL;
1826: v_dup_record NUMBER(15) := null;
1827: l_proc constant VARCHAR2(80) := g_pkg || '.' || 'add_related_ret_rights';

Line 1874: hr_cagr_ff_pkg.cagr_entitlement_ff(p_formula_id => v_cagr_ents_rec.FORMULA_ID

1870: fetch csr_cagr_ents into v_cagr_ents_rec;
1871: if csr_cagr_ents%found then
1872: v_units_of_measure := v_cagr_ents_rec.UNITS_OF_MEASURE;
1873:
1874: hr_cagr_ff_pkg.cagr_entitlement_ff(p_formula_id => v_cagr_ents_rec.FORMULA_ID
1875: ,p_effective_date => p_effective_date
1876: ,p_assignment_id => p_assignment_id
1877: ,p_category_name => v_csr_rr_rec.category_name
1878: ,p_out_rec => l_cagr_FF_record);

Line 2184: l_cagr_FF_record hr_cagr_ff_pkg.cagr_FF_record;

2180: v_parent_spine_id per_cagr_retained_rights.PARENT_SPINE_ID%TYPE;
2181: v_step_id per_cagr_retained_rights.STEP_ID%TYPE;
2182: v_from_step_id per_cagr_retained_rights.FROM_STEP_ID%TYPE;
2183: v_to_step_id per_cagr_retained_rights.TO_STEP_ID%TYPE;
2184: l_cagr_FF_record hr_cagr_ff_pkg.cagr_FF_record;
2185:
2186: l_proc constant VARCHAR2(80) := g_pkg || '.' || 'add_other_ret_rights';
2187:
2188: BEGIN

Line 2277: hr_cagr_ff_pkg.cagr_entitlement_ff(p_formula_id => v_cagr_ents_rec.FORMULA_ID

2273: fetch csr_cagr_ents into v_cagr_ents_rec;
2274: if csr_cagr_ents%found then
2275: v_units_of_measure := v_cagr_ents_rec.UNITS_OF_MEASURE;
2276:
2277: hr_cagr_ff_pkg.cagr_entitlement_ff(p_formula_id => v_cagr_ents_rec.FORMULA_ID
2278: ,p_effective_date => p_params.effective_date
2279: ,p_assignment_id => p_params.assignment_id
2280: ,p_category_name => v_csr_rr_rec.category_name
2281: ,p_out_rec => l_cagr_FF_record);

Line 2630: hr_cagr_ff_pkg.cagr_entitlement_ff(p_formula_id => v_ents.FORMULA_ID

2626: ,p_params.effective_date);
2627: per_cagr_utility_pkg.put_log(' Evaluating entitlement fast formula: '||l_source_name,1);
2628:
2629:
2630: hr_cagr_ff_pkg.cagr_entitlement_ff(p_formula_id => v_ents.FORMULA_ID
2631: ,p_effective_date => p_params.effective_date
2632: ,p_assignment_id => p_params.assignment_id
2633: ,p_category_name => v_ents.category_name
2634: ,p_out_rec => l_cagr_FF_record);

Line 2914: hr_cagr_ff_pkg.cagr_entitlement_ff(p_formula_id => v_ents.FORMULA_ID

2910: if v_ents.FORMULA_ID is not null then
2911: per_cagr_utility_pkg.put_log(' Processing entitlement: '||v_ents.cagr_entitlement_id||' '
2912: ||v_ents.item_name||', calling ff');
2913:
2914: hr_cagr_ff_pkg.cagr_entitlement_ff(p_formula_id => v_ents.FORMULA_ID
2915: ,p_effective_date => p_params.effective_date
2916: ,p_assignment_id => p_params.assignment_id
2917: ,p_category_name => v_ents.category_name
2918: ,p_out_rec => l_cagr_FF_record);

Line 3356: hr_cagr_ff_pkg.cagr_entitlement_ff(p_formula_id => v_ents.FORMULA_ID

3352: ,p_params.effective_date);
3353: per_cagr_utility_pkg.put_log(' Evaluating entitlement fast formula: '||l_source_name,1);
3354:
3355:
3356: hr_cagr_ff_pkg.cagr_entitlement_ff(p_formula_id => v_ents.FORMULA_ID
3357: ,p_effective_date => p_params.effective_date
3358: ,p_assignment_id => p_params.assignment_id
3359: ,p_category_name => v_ents.category_name
3360: ,p_out_rec => l_cagr_FF_record);

Line 3679: hr_cagr_ff_pkg.cagr_entitlement_ff(p_formula_id => v_ents.FORMULA_ID

3675: if v_ents.FORMULA_ID is not null then
3676: per_cagr_utility_pkg.put_log(' Processing entitlement: '||v_ents.cagr_entitlement_id||' '
3677: ||v_ents.item_name||', calling ff');
3678:
3679: hr_cagr_ff_pkg.cagr_entitlement_ff(p_formula_id => v_ents.FORMULA_ID
3680: ,p_effective_date => p_params.effective_date
3681: ,p_assignment_id => p_params.assignment_id
3682: ,p_category_name => v_ents.category_name
3683: ,p_out_rec => l_cagr_FF_record);