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.PER_CAGR_EVALUATION_PKG dependencies on PER_CAGR_RETAINED_RIGHTS

Line 1765: SELECT * from per_cagr_retained_rights pcrr

1761: -- on the effective_date, checking the cagr, entitlement and line are still active
1762: -- and current on the effective_date.
1763: --
1764: CURSOR csr_cagr_retained_rights IS
1765: SELECT * from per_cagr_retained_rights pcrr
1766: WHERE pcrr.assignment_id = p_assignment_id
1767: AND cagr_entitlement_item_id = p_cagr_entitlement_item_id
1768: AND p_params.effective_date BETWEEN pcrr.START_DATE AND nvl(pcrr.END_DATE,hr_general.end_of_time)
1769: AND EXISTS (select 'x'

Line 1814: v_value per_cagr_retained_rights.value%TYPE;

1810: v_cagr_lines_rec csr_cagr_lines%ROWTYPE;
1811: v_local_counter NUMBER(10);
1812: v_dataitem_id NUMBER(10);
1813: v_write_flag BOOLEAN := FALSE;
1814: v_value per_cagr_retained_rights.value%TYPE;
1815: v_range_from per_cagr_retained_rights.range_from%TYPE;
1816: v_range_to per_cagr_retained_rights.range_to%TYPE;
1817: v_units_of_measure per_cagr_retained_rights.units_of_measure%TYPE;
1818: v_grade_spine_id per_cagr_retained_rights.grade_spine_id%TYPE;

Line 1815: v_range_from per_cagr_retained_rights.range_from%TYPE;

1811: v_local_counter NUMBER(10);
1812: v_dataitem_id NUMBER(10);
1813: v_write_flag BOOLEAN := FALSE;
1814: v_value per_cagr_retained_rights.value%TYPE;
1815: v_range_from per_cagr_retained_rights.range_from%TYPE;
1816: v_range_to per_cagr_retained_rights.range_to%TYPE;
1817: v_units_of_measure per_cagr_retained_rights.units_of_measure%TYPE;
1818: v_grade_spine_id per_cagr_retained_rights.grade_spine_id%TYPE;
1819: v_parent_spine_id per_cagr_retained_rights.parent_spine_id%TYPE;

Line 1816: v_range_to per_cagr_retained_rights.range_to%TYPE;

1812: v_dataitem_id NUMBER(10);
1813: v_write_flag BOOLEAN := FALSE;
1814: v_value per_cagr_retained_rights.value%TYPE;
1815: v_range_from per_cagr_retained_rights.range_from%TYPE;
1816: v_range_to per_cagr_retained_rights.range_to%TYPE;
1817: v_units_of_measure per_cagr_retained_rights.units_of_measure%TYPE;
1818: v_grade_spine_id per_cagr_retained_rights.grade_spine_id%TYPE;
1819: v_parent_spine_id per_cagr_retained_rights.parent_spine_id%TYPE;
1820: v_step_id per_cagr_retained_rights.step_id%TYPE;

Line 1817: v_units_of_measure per_cagr_retained_rights.units_of_measure%TYPE;

1813: v_write_flag BOOLEAN := FALSE;
1814: v_value per_cagr_retained_rights.value%TYPE;
1815: v_range_from per_cagr_retained_rights.range_from%TYPE;
1816: v_range_to per_cagr_retained_rights.range_to%TYPE;
1817: v_units_of_measure per_cagr_retained_rights.units_of_measure%TYPE;
1818: v_grade_spine_id per_cagr_retained_rights.grade_spine_id%TYPE;
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;

Line 1818: v_grade_spine_id per_cagr_retained_rights.grade_spine_id%TYPE;

1814: v_value per_cagr_retained_rights.value%TYPE;
1815: v_range_from per_cagr_retained_rights.range_from%TYPE;
1816: v_range_to per_cagr_retained_rights.range_to%TYPE;
1817: v_units_of_measure per_cagr_retained_rights.units_of_measure%TYPE;
1818: v_grade_spine_id per_cagr_retained_rights.grade_spine_id%TYPE;
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;

Line 1819: v_parent_spine_id per_cagr_retained_rights.parent_spine_id%TYPE;

1815: v_range_from per_cagr_retained_rights.range_from%TYPE;
1816: v_range_to per_cagr_retained_rights.range_to%TYPE;
1817: v_units_of_measure per_cagr_retained_rights.units_of_measure%TYPE;
1818: v_grade_spine_id per_cagr_retained_rights.grade_spine_id%TYPE;
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;

Line 1820: v_step_id per_cagr_retained_rights.step_id%TYPE;

1816: v_range_to per_cagr_retained_rights.range_to%TYPE;
1817: v_units_of_measure per_cagr_retained_rights.units_of_measure%TYPE;
1818: v_grade_spine_id per_cagr_retained_rights.grade_spine_id%TYPE;
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;

Line 1821: v_from_step_id per_cagr_retained_rights.from_step_id%TYPE;

1817: v_units_of_measure per_cagr_retained_rights.units_of_measure%TYPE;
1818: v_grade_spine_id per_cagr_retained_rights.grade_spine_id%TYPE;
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;

Line 1822: v_to_step_id per_cagr_retained_rights.to_step_id%TYPE;

1818: v_grade_spine_id per_cagr_retained_rights.grade_spine_id%TYPE;
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;

Line 2103: FROM per_cagr_retained_rights pcrr

2099: -- cagr, ent and lines (possibly) on the effective date. (And assuming the asg is primary)
2100: --
2101: CURSOR csr_cagr_other_ret_rights IS
2102: SELECT *
2103: FROM per_cagr_retained_rights pcrr
2104: WHERE pcrr.assignment_id = p_params.assignment_id
2105: AND p_params.effective_date BETWEEN pcrr.START_DATE
2106: AND nvl(pcrr.END_DATE,hr_general.end_of_time)
2107: AND EXISTS (select 'X' from per_all_assignments_f asg

Line 2175: v_value per_cagr_retained_rights.VALUE%TYPE;

2171: v_ben_row NUMBER(10);
2172: v_rule_inconclusive BOOLEAN := FALSE;
2173: v_dataitem_id NUMBER(10);
2174: v_write_flag BOOLEAN := FALSE;
2175: v_value per_cagr_retained_rights.VALUE%TYPE;
2176: v_range_from per_cagr_retained_rights.RANGE_FROM%TYPE;
2177: v_range_to per_cagr_retained_rights.RANGE_TO%TYPE;
2178: v_units_of_measure per_cagr_retained_rights.UNITS_OF_MEASURE%TYPE;
2179: v_grade_spine_id per_cagr_retained_rights.GRADE_SPINE_ID%TYPE;

Line 2176: v_range_from per_cagr_retained_rights.RANGE_FROM%TYPE;

2172: v_rule_inconclusive BOOLEAN := FALSE;
2173: v_dataitem_id NUMBER(10);
2174: v_write_flag BOOLEAN := FALSE;
2175: v_value per_cagr_retained_rights.VALUE%TYPE;
2176: v_range_from per_cagr_retained_rights.RANGE_FROM%TYPE;
2177: v_range_to per_cagr_retained_rights.RANGE_TO%TYPE;
2178: v_units_of_measure per_cagr_retained_rights.UNITS_OF_MEASURE%TYPE;
2179: v_grade_spine_id per_cagr_retained_rights.GRADE_SPINE_ID%TYPE;
2180: v_parent_spine_id per_cagr_retained_rights.PARENT_SPINE_ID%TYPE;

Line 2177: v_range_to per_cagr_retained_rights.RANGE_TO%TYPE;

2173: v_dataitem_id NUMBER(10);
2174: v_write_flag BOOLEAN := FALSE;
2175: v_value per_cagr_retained_rights.VALUE%TYPE;
2176: v_range_from per_cagr_retained_rights.RANGE_FROM%TYPE;
2177: v_range_to per_cagr_retained_rights.RANGE_TO%TYPE;
2178: v_units_of_measure per_cagr_retained_rights.UNITS_OF_MEASURE%TYPE;
2179: v_grade_spine_id per_cagr_retained_rights.GRADE_SPINE_ID%TYPE;
2180: v_parent_spine_id per_cagr_retained_rights.PARENT_SPINE_ID%TYPE;
2181: v_step_id per_cagr_retained_rights.STEP_ID%TYPE;

Line 2178: v_units_of_measure per_cagr_retained_rights.UNITS_OF_MEASURE%TYPE;

2174: v_write_flag BOOLEAN := FALSE;
2175: v_value per_cagr_retained_rights.VALUE%TYPE;
2176: v_range_from per_cagr_retained_rights.RANGE_FROM%TYPE;
2177: v_range_to per_cagr_retained_rights.RANGE_TO%TYPE;
2178: v_units_of_measure per_cagr_retained_rights.UNITS_OF_MEASURE%TYPE;
2179: v_grade_spine_id per_cagr_retained_rights.GRADE_SPINE_ID%TYPE;
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;

Line 2179: v_grade_spine_id per_cagr_retained_rights.GRADE_SPINE_ID%TYPE;

2175: v_value per_cagr_retained_rights.VALUE%TYPE;
2176: v_range_from per_cagr_retained_rights.RANGE_FROM%TYPE;
2177: v_range_to per_cagr_retained_rights.RANGE_TO%TYPE;
2178: v_units_of_measure per_cagr_retained_rights.UNITS_OF_MEASURE%TYPE;
2179: v_grade_spine_id per_cagr_retained_rights.GRADE_SPINE_ID%TYPE;
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;

Line 2180: v_parent_spine_id per_cagr_retained_rights.PARENT_SPINE_ID%TYPE;

2176: v_range_from per_cagr_retained_rights.RANGE_FROM%TYPE;
2177: v_range_to per_cagr_retained_rights.RANGE_TO%TYPE;
2178: v_units_of_measure per_cagr_retained_rights.UNITS_OF_MEASURE%TYPE;
2179: v_grade_spine_id per_cagr_retained_rights.GRADE_SPINE_ID%TYPE;
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;

Line 2181: v_step_id per_cagr_retained_rights.STEP_ID%TYPE;

2177: v_range_to per_cagr_retained_rights.RANGE_TO%TYPE;
2178: v_units_of_measure per_cagr_retained_rights.UNITS_OF_MEASURE%TYPE;
2179: v_grade_spine_id per_cagr_retained_rights.GRADE_SPINE_ID%TYPE;
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:

Line 2182: v_from_step_id per_cagr_retained_rights.FROM_STEP_ID%TYPE;

2178: v_units_of_measure per_cagr_retained_rights.UNITS_OF_MEASURE%TYPE;
2179: v_grade_spine_id per_cagr_retained_rights.GRADE_SPINE_ID%TYPE;
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';

Line 2183: v_to_step_id per_cagr_retained_rights.TO_STEP_ID%TYPE;

2179: v_grade_spine_id per_cagr_retained_rights.GRADE_SPINE_ID%TYPE;
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: