2: /* $Header: hrcagrff.pkh 115.2 2002/12/09 14:33:49 hjonnala noship $ */
3:
4: --
5: TYPE cagr_FF_record IS RECORD
6: (VALUE per_cagr_entitlement_lines_f.VALUE%TYPE
7: ,RANGE_FROM per_cagr_entitlement_lines_f.RANGE_FROM%TYPE
8: ,RANGE_TO per_cagr_entitlement_lines_f.RANGE_TO%TYPE
9: ,GRADE_SPINE_ID per_cagr_entitlement_lines_f.GRADE_SPINE_ID%TYPE
10: ,PARENT_SPINE_ID per_cagr_entitlement_lines_f.PARENT_SPINE_ID%TYPE
3:
4: --
5: TYPE cagr_FF_record IS RECORD
6: (VALUE per_cagr_entitlement_lines_f.VALUE%TYPE
7: ,RANGE_FROM per_cagr_entitlement_lines_f.RANGE_FROM%TYPE
8: ,RANGE_TO per_cagr_entitlement_lines_f.RANGE_TO%TYPE
9: ,GRADE_SPINE_ID per_cagr_entitlement_lines_f.GRADE_SPINE_ID%TYPE
10: ,PARENT_SPINE_ID per_cagr_entitlement_lines_f.PARENT_SPINE_ID%TYPE
11: ,STEP_ID per_cagr_entitlement_lines_f.STEP_ID%TYPE
4: --
5: TYPE cagr_FF_record IS RECORD
6: (VALUE per_cagr_entitlement_lines_f.VALUE%TYPE
7: ,RANGE_FROM per_cagr_entitlement_lines_f.RANGE_FROM%TYPE
8: ,RANGE_TO per_cagr_entitlement_lines_f.RANGE_TO%TYPE
9: ,GRADE_SPINE_ID per_cagr_entitlement_lines_f.GRADE_SPINE_ID%TYPE
10: ,PARENT_SPINE_ID per_cagr_entitlement_lines_f.PARENT_SPINE_ID%TYPE
11: ,STEP_ID per_cagr_entitlement_lines_f.STEP_ID%TYPE
12: ,FROM_STEP_ID per_cagr_entitlement_lines_f.FROM_STEP_ID%TYPE
5: TYPE cagr_FF_record IS RECORD
6: (VALUE per_cagr_entitlement_lines_f.VALUE%TYPE
7: ,RANGE_FROM per_cagr_entitlement_lines_f.RANGE_FROM%TYPE
8: ,RANGE_TO per_cagr_entitlement_lines_f.RANGE_TO%TYPE
9: ,GRADE_SPINE_ID per_cagr_entitlement_lines_f.GRADE_SPINE_ID%TYPE
10: ,PARENT_SPINE_ID per_cagr_entitlement_lines_f.PARENT_SPINE_ID%TYPE
11: ,STEP_ID per_cagr_entitlement_lines_f.STEP_ID%TYPE
12: ,FROM_STEP_ID per_cagr_entitlement_lines_f.FROM_STEP_ID%TYPE
13: ,TO_STEP_ID per_cagr_entitlement_lines_f.TO_STEP_ID%TYPE);
6: (VALUE per_cagr_entitlement_lines_f.VALUE%TYPE
7: ,RANGE_FROM per_cagr_entitlement_lines_f.RANGE_FROM%TYPE
8: ,RANGE_TO per_cagr_entitlement_lines_f.RANGE_TO%TYPE
9: ,GRADE_SPINE_ID per_cagr_entitlement_lines_f.GRADE_SPINE_ID%TYPE
10: ,PARENT_SPINE_ID per_cagr_entitlement_lines_f.PARENT_SPINE_ID%TYPE
11: ,STEP_ID per_cagr_entitlement_lines_f.STEP_ID%TYPE
12: ,FROM_STEP_ID per_cagr_entitlement_lines_f.FROM_STEP_ID%TYPE
13: ,TO_STEP_ID per_cagr_entitlement_lines_f.TO_STEP_ID%TYPE);
14: --
7: ,RANGE_FROM per_cagr_entitlement_lines_f.RANGE_FROM%TYPE
8: ,RANGE_TO per_cagr_entitlement_lines_f.RANGE_TO%TYPE
9: ,GRADE_SPINE_ID per_cagr_entitlement_lines_f.GRADE_SPINE_ID%TYPE
10: ,PARENT_SPINE_ID per_cagr_entitlement_lines_f.PARENT_SPINE_ID%TYPE
11: ,STEP_ID per_cagr_entitlement_lines_f.STEP_ID%TYPE
12: ,FROM_STEP_ID per_cagr_entitlement_lines_f.FROM_STEP_ID%TYPE
13: ,TO_STEP_ID per_cagr_entitlement_lines_f.TO_STEP_ID%TYPE);
14: --
15: procedure cagr_entitlement_ff
8: ,RANGE_TO per_cagr_entitlement_lines_f.RANGE_TO%TYPE
9: ,GRADE_SPINE_ID per_cagr_entitlement_lines_f.GRADE_SPINE_ID%TYPE
10: ,PARENT_SPINE_ID per_cagr_entitlement_lines_f.PARENT_SPINE_ID%TYPE
11: ,STEP_ID per_cagr_entitlement_lines_f.STEP_ID%TYPE
12: ,FROM_STEP_ID per_cagr_entitlement_lines_f.FROM_STEP_ID%TYPE
13: ,TO_STEP_ID per_cagr_entitlement_lines_f.TO_STEP_ID%TYPE);
14: --
15: procedure cagr_entitlement_ff
16: ( p_formula_id IN NUMBER,
9: ,GRADE_SPINE_ID per_cagr_entitlement_lines_f.GRADE_SPINE_ID%TYPE
10: ,PARENT_SPINE_ID per_cagr_entitlement_lines_f.PARENT_SPINE_ID%TYPE
11: ,STEP_ID per_cagr_entitlement_lines_f.STEP_ID%TYPE
12: ,FROM_STEP_ID per_cagr_entitlement_lines_f.FROM_STEP_ID%TYPE
13: ,TO_STEP_ID per_cagr_entitlement_lines_f.TO_STEP_ID%TYPE);
14: --
15: procedure cagr_entitlement_ff
16: ( p_formula_id IN NUMBER,
17: p_effective_date IN DATE,