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 1751: l_cagr_FF_record hr_cagr_ff_pkg.cagr_FF_record;

1747: v_parent_spine_id per_cagr_retained_rights.parent_spine_id%TYPE;
1748: v_step_id per_cagr_retained_rights.step_id%TYPE;
1749: v_from_step_id per_cagr_retained_rights.from_step_id%TYPE;
1750: v_to_step_id per_cagr_retained_rights.to_step_id%TYPE;
1751: l_cagr_FF_record hr_cagr_ff_pkg.cagr_FF_record;
1752: l_source_name varchar2(200) := NULL;
1753: v_counter NUMBER(15) := NULL;
1754: v_dup_record NUMBER(15) := null;
1755: l_proc constant VARCHAR2(80) := g_pkg || '.' || 'add_related_ret_rights';

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

1798: fetch csr_cagr_ents into v_cagr_ents_rec;
1799: if csr_cagr_ents%found then
1800: v_units_of_measure := v_cagr_ents_rec.UNITS_OF_MEASURE;
1801:
1802: hr_cagr_ff_pkg.cagr_entitlement_ff(p_formula_id => v_cagr_ents_rec.FORMULA_ID
1803: ,p_effective_date => p_effective_date
1804: ,p_assignment_id => p_assignment_id
1805: ,p_category_name => v_csr_rr_rec.category_name
1806: ,p_out_rec => l_cagr_FF_record);

Line 2112: l_cagr_FF_record hr_cagr_ff_pkg.cagr_FF_record;

2108: v_parent_spine_id per_cagr_retained_rights.PARENT_SPINE_ID%TYPE;
2109: v_step_id per_cagr_retained_rights.STEP_ID%TYPE;
2110: v_from_step_id per_cagr_retained_rights.FROM_STEP_ID%TYPE;
2111: v_to_step_id per_cagr_retained_rights.TO_STEP_ID%TYPE;
2112: l_cagr_FF_record hr_cagr_ff_pkg.cagr_FF_record;
2113:
2114: l_proc constant VARCHAR2(80) := g_pkg || '.' || 'add_other_ret_rights';
2115:
2116: BEGIN

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

2201: fetch csr_cagr_ents into v_cagr_ents_rec;
2202: if csr_cagr_ents%found then
2203: v_units_of_measure := v_cagr_ents_rec.UNITS_OF_MEASURE;
2204:
2205: hr_cagr_ff_pkg.cagr_entitlement_ff(p_formula_id => v_cagr_ents_rec.FORMULA_ID
2206: ,p_effective_date => p_params.effective_date
2207: ,p_assignment_id => p_params.assignment_id
2208: ,p_category_name => v_csr_rr_rec.category_name
2209: ,p_out_rec => l_cagr_FF_record);

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

2554: ,p_params.effective_date);
2555: per_cagr_utility_pkg.put_log(' Evaluating entitlement fast formula: '||l_source_name,1);
2556:
2557:
2558: hr_cagr_ff_pkg.cagr_entitlement_ff(p_formula_id => v_ents.FORMULA_ID
2559: ,p_effective_date => p_params.effective_date
2560: ,p_assignment_id => p_params.assignment_id
2561: ,p_category_name => v_ents.category_name
2562: ,p_out_rec => l_cagr_FF_record);

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

2838: if v_ents.FORMULA_ID is not null then
2839: per_cagr_utility_pkg.put_log(' Processing entitlement: '||v_ents.cagr_entitlement_id||' '
2840: ||v_ents.item_name||', calling ff');
2841:
2842: hr_cagr_ff_pkg.cagr_entitlement_ff(p_formula_id => v_ents.FORMULA_ID
2843: ,p_effective_date => p_params.effective_date
2844: ,p_assignment_id => p_params.assignment_id
2845: ,p_category_name => v_ents.category_name
2846: ,p_out_rec => l_cagr_FF_record);

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

3279: ,p_params.effective_date);
3280: per_cagr_utility_pkg.put_log(' Evaluating entitlement fast formula: '||l_source_name,1);
3281:
3282:
3283: hr_cagr_ff_pkg.cagr_entitlement_ff(p_formula_id => v_ents.FORMULA_ID
3284: ,p_effective_date => p_params.effective_date
3285: ,p_assignment_id => p_params.assignment_id
3286: ,p_category_name => v_ents.category_name
3287: ,p_out_rec => l_cagr_FF_record);

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

3602: if v_ents.FORMULA_ID is not null then
3603: per_cagr_utility_pkg.put_log(' Processing entitlement: '||v_ents.cagr_entitlement_id||' '
3604: ||v_ents.item_name||', calling ff');
3605:
3606: hr_cagr_ff_pkg.cagr_entitlement_ff(p_formula_id => v_ents.FORMULA_ID
3607: ,p_effective_date => p_params.effective_date
3608: ,p_assignment_id => p_params.assignment_id
3609: ,p_category_name => v_ents.category_name
3610: ,p_out_rec => l_cagr_FF_record);