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_PCL_BUS dependencies on PER_CAGR_ENTITLEMENT_LINES_F

Line 22: ,p_value IN per_cagr_entitlement_lines_f.value%TYPE

18: -- ----------------------------------------------------------------------------
19: --
20: PROCEDURE chk_dates_are_valid
21: (p_cagr_entitlement_item_id IN per_cagr_entitlements.cagr_entitlement_item_id%TYPE
22: ,p_value IN per_cagr_entitlement_lines_f.value%TYPE
23: ,p_range_from IN per_cagr_entitlement_lines_f.range_from%TYPE
24: ,p_range_to IN per_cagr_entitlement_lines_f.range_to%TYPE
25: ,p_effective_date IN DATE) IS
26: --

Line 23: ,p_range_from IN per_cagr_entitlement_lines_f.range_from%TYPE

19: --
20: PROCEDURE chk_dates_are_valid
21: (p_cagr_entitlement_item_id IN per_cagr_entitlements.cagr_entitlement_item_id%TYPE
22: ,p_value IN per_cagr_entitlement_lines_f.value%TYPE
23: ,p_range_from IN per_cagr_entitlement_lines_f.range_from%TYPE
24: ,p_range_to IN per_cagr_entitlement_lines_f.range_to%TYPE
25: ,p_effective_date IN DATE) IS
26: --
27: l_proc VARCHAR2(72) := g_package||'check_dates_are_valid';

Line 24: ,p_range_to IN per_cagr_entitlement_lines_f.range_to%TYPE

20: PROCEDURE chk_dates_are_valid
21: (p_cagr_entitlement_item_id IN per_cagr_entitlements.cagr_entitlement_item_id%TYPE
22: ,p_value IN per_cagr_entitlement_lines_f.value%TYPE
23: ,p_range_from IN per_cagr_entitlement_lines_f.range_from%TYPE
24: ,p_range_to IN per_cagr_entitlement_lines_f.range_to%TYPE
25: ,p_effective_date IN DATE) IS
26: --
27: l_proc VARCHAR2(72) := g_package||'check_dates_are_valid';
28: l_column_type per_cagr_entitlement_items.column_type%TYPE;

Line 250: , per_cagr_entitlement_lines_f pcl

246: --
247: cursor csr_sec_grp is
248: select pbg.security_group_id
249: from per_business_groups pbg
250: , per_cagr_entitlement_lines_f pcl
251: , per_cagr_entitlements pce
252: , per_cagr_entitlement_items pci
253:
254: where pcl.cagr_entitlement_line_id = p_cagr_entitlement_line_id

Line 318: , per_cagr_entitlement_lines_f pcl

314:
315: cursor csr_leg_code is
316: select pbg.legislation_code
317: from per_business_groups pbg
318: , per_cagr_entitlement_lines_f pcl
319: , per_cagr_entitlements pce
320: , per_cagr_entitlement_items pci
321:
322: where pcl.cagr_entitlement_line_id = p_cagr_entitlement_line_id

Line 488: ( p_mandatory IN per_cagr_entitlement_lines_f.mandatory%TYPE

484: --
485: -- ---------------------------------------------------------------------------
486: --
487: PROCEDURE chk_mandatory
488: ( p_mandatory IN per_cagr_entitlement_lines_f.mandatory%TYPE
489: ,p_cagr_entitlement_line_id IN per_cagr_entitlement_lines_f.cagr_entitlement_line_id%TYPE
490: ,p_effective_date IN DATE
491: ,p_validation_start_date IN DATE
492: ,p_validation_end_date IN DATE) IS

Line 489: ,p_cagr_entitlement_line_id IN per_cagr_entitlement_lines_f.cagr_entitlement_line_id%TYPE

485: -- ---------------------------------------------------------------------------
486: --
487: PROCEDURE chk_mandatory
488: ( p_mandatory IN per_cagr_entitlement_lines_f.mandatory%TYPE
489: ,p_cagr_entitlement_line_id IN per_cagr_entitlement_lines_f.cagr_entitlement_line_id%TYPE
490: ,p_effective_date IN DATE
491: ,p_validation_start_date IN DATE
492: ,p_validation_end_date IN DATE) IS
493:

Line 589: (p_value IN per_cagr_entitlement_lines_f.value%TYPE

585: --
586: -- ---------------------------------------------------------------------------
587: --
588: PROCEDURE chk_value
589: (p_value IN per_cagr_entitlement_lines_f.value%TYPE
590: ,p_cagr_entitlement_line_id IN per_cagr_entitlement_lines_f.cagr_entitlement_line_id%TYPE
591: ,p_cagr_entitlement_item_id IN per_cagr_entitlement_items.cagr_entitlement_item_id%TYPE
592: ,p_cagr_entitlement_id IN per_cagr_entitlements.cagr_entitlement_id%TYPE
593: ,p_category_name IN VARCHAR2

Line 590: ,p_cagr_entitlement_line_id IN per_cagr_entitlement_lines_f.cagr_entitlement_line_id%TYPE

586: -- ---------------------------------------------------------------------------
587: --
588: PROCEDURE chk_value
589: (p_value IN per_cagr_entitlement_lines_f.value%TYPE
590: ,p_cagr_entitlement_line_id IN per_cagr_entitlement_lines_f.cagr_entitlement_line_id%TYPE
591: ,p_cagr_entitlement_item_id IN per_cagr_entitlement_items.cagr_entitlement_item_id%TYPE
592: ,p_cagr_entitlement_id IN per_cagr_entitlements.cagr_entitlement_id%TYPE
593: ,p_category_name IN VARCHAR2
594: ,p_effective_date IN DATE) IS

Line 602: l_value per_cagr_entitlement_lines_f.value%TYPE;

598: l_proc VARCHAR2(72) := g_package || 'chk_values';
599: l_flex_value_set_id per_cagr_entitlement_items.flex_value_set_id%TYPE;
600: l_value_desc VARCHAR2(2000);
601: l_non_value_category BOOLEAN;
602: l_value per_cagr_entitlement_lines_f.value%TYPE;
603: l_formatted_value VARCHAR2(2000);
604: --
605: BEGIN
606: --

Line 762: (p_range_from IN per_cagr_entitlement_lines_f.range_from%TYPE

758: --
759: -- ---------------------------------------------------------------------------
760: --
761: PROCEDURE chk_range_from
762: (p_range_from IN per_cagr_entitlement_lines_f.range_from%TYPE
763: ,p_cagr_entitlement_line_id IN per_cagr_entitlement_lines_f.cagr_entitlement_line_id%TYPE
764: ,p_cagr_entitlement_item_id IN per_cagr_entitlement_items.cagr_entitlement_item_id%TYPE
765: ,p_category_name IN VARCHAR2
766: ,p_effective_date IN DATE) IS

Line 763: ,p_cagr_entitlement_line_id IN per_cagr_entitlement_lines_f.cagr_entitlement_line_id%TYPE

759: -- ---------------------------------------------------------------------------
760: --
761: PROCEDURE chk_range_from
762: (p_range_from IN per_cagr_entitlement_lines_f.range_from%TYPE
763: ,p_cagr_entitlement_line_id IN per_cagr_entitlement_lines_f.cagr_entitlement_line_id%TYPE
764: ,p_cagr_entitlement_item_id IN per_cagr_entitlement_items.cagr_entitlement_item_id%TYPE
765: ,p_category_name IN VARCHAR2
766: ,p_effective_date IN DATE) IS
767: --

Line 773: l_range_from per_cagr_entitlement_lines_f.range_to%TYPE;

769: --
770: l_proc VARCHAR2(72) := g_package || 'chk_range_from';
771: l_flex_value_set_id per_cagr_entitlement_items.flex_value_set_id%TYPE;
772: l_range_from_desc VARCHAR2(2000);
773: l_range_from per_cagr_entitlement_lines_f.range_to%TYPE;
774: l_non_value_category BOOLEAN;
775: l_formatted_value VARCHAR2(2000);
776: --
777: BEGIN

Line 926: (p_range_to IN per_cagr_entitlement_lines_f.range_to%TYPE

922: --
923: -- ---------------------------------------------------------------------------
924: --
925: PROCEDURE chk_range_to
926: (p_range_to IN per_cagr_entitlement_lines_f.range_to%TYPE
927: ,p_cagr_entitlement_line_id IN per_cagr_entitlement_lines_f.cagr_entitlement_line_id%TYPE
928: ,p_cagr_entitlement_item_id IN per_cagr_entitlement_items.cagr_entitlement_item_id%TYPE
929: ,p_category_name IN VARCHAR2
930: ,p_effective_date IN DATE) IS

Line 927: ,p_cagr_entitlement_line_id IN per_cagr_entitlement_lines_f.cagr_entitlement_line_id%TYPE

923: -- ---------------------------------------------------------------------------
924: --
925: PROCEDURE chk_range_to
926: (p_range_to IN per_cagr_entitlement_lines_f.range_to%TYPE
927: ,p_cagr_entitlement_line_id IN per_cagr_entitlement_lines_f.cagr_entitlement_line_id%TYPE
928: ,p_cagr_entitlement_item_id IN per_cagr_entitlement_items.cagr_entitlement_item_id%TYPE
929: ,p_category_name IN VARCHAR2
930: ,p_effective_date IN DATE) IS
931: --

Line 937: l_range_to per_cagr_entitlement_lines_f.range_to%TYPE;

933: --
934: l_proc VARCHAR2(72) := g_package || 'chk_range_to';
935: l_flex_value_set_id per_cagr_entitlement_items.flex_value_set_id%TYPE;
936: l_range_to_desc VARCHAR2(2000);
937: l_range_to per_cagr_entitlement_lines_f.range_to%TYPE;
938: l_non_value_category BOOLEAN;
939: l_formatted_value VARCHAR2(2000);
940: --
941: BEGIN

Line 1088: ( p_grade_spine_id IN per_cagr_entitlement_lines_f.grade_spine_id%TYPE

1084: --
1085: -- ---------------------------------------------------------------------------
1086: --
1087: PROCEDURE chk_grade_spine_id
1088: ( p_grade_spine_id IN per_cagr_entitlement_lines_f.grade_spine_id%TYPE
1089: ,p_cagr_entitlement_line_id IN per_cagr_entitlement_lines_f.cagr_entitlement_line_id%TYPE
1090: ,p_cagr_entitlement_id IN per_cagr_entitlement_lines_f.cagr_entitlement_id%TYPE
1091: ,p_effective_date IN DATE
1092: ,p_validation_start_date IN DATE

Line 1089: ,p_cagr_entitlement_line_id IN per_cagr_entitlement_lines_f.cagr_entitlement_line_id%TYPE

1085: -- ---------------------------------------------------------------------------
1086: --
1087: PROCEDURE chk_grade_spine_id
1088: ( p_grade_spine_id IN per_cagr_entitlement_lines_f.grade_spine_id%TYPE
1089: ,p_cagr_entitlement_line_id IN per_cagr_entitlement_lines_f.cagr_entitlement_line_id%TYPE
1090: ,p_cagr_entitlement_id IN per_cagr_entitlement_lines_f.cagr_entitlement_id%TYPE
1091: ,p_effective_date IN DATE
1092: ,p_validation_start_date IN DATE
1093: ,p_validation_end_date IN DATE) IS

Line 1090: ,p_cagr_entitlement_id IN per_cagr_entitlement_lines_f.cagr_entitlement_id%TYPE

1086: --
1087: PROCEDURE chk_grade_spine_id
1088: ( p_grade_spine_id IN per_cagr_entitlement_lines_f.grade_spine_id%TYPE
1089: ,p_cagr_entitlement_line_id IN per_cagr_entitlement_lines_f.cagr_entitlement_line_id%TYPE
1090: ,p_cagr_entitlement_id IN per_cagr_entitlement_lines_f.cagr_entitlement_id%TYPE
1091: ,p_effective_date IN DATE
1092: ,p_validation_start_date IN DATE
1093: ,p_validation_end_date IN DATE) IS
1094:

Line 1227: ( p_parent_spine_id IN per_cagr_entitlement_lines_f.parent_spine_id%TYPE

1223: --
1224: -- ---------------------------------------------------------------------------
1225: --
1226: PROCEDURE chk_parent_spine_id
1227: ( p_parent_spine_id IN per_cagr_entitlement_lines_f.parent_spine_id%TYPE
1228: ,p_cagr_entitlement_line_id IN
1229: per_cagr_entitlement_lines_f.cagr_entitlement_line_id%TYPE
1230: ,p_cagr_entitlement_id IN per_cagr_entitlement_lines_f.cagr_entitlement_id%TYPE ) IS
1231: --

Line 1229: per_cagr_entitlement_lines_f.cagr_entitlement_line_id%TYPE

1225: --
1226: PROCEDURE chk_parent_spine_id
1227: ( p_parent_spine_id IN per_cagr_entitlement_lines_f.parent_spine_id%TYPE
1228: ,p_cagr_entitlement_line_id IN
1229: per_cagr_entitlement_lines_f.cagr_entitlement_line_id%TYPE
1230: ,p_cagr_entitlement_id IN per_cagr_entitlement_lines_f.cagr_entitlement_id%TYPE ) IS
1231: --
1232:
1233: CURSOR csr_chk_category IS

Line 1230: ,p_cagr_entitlement_id IN per_cagr_entitlement_lines_f.cagr_entitlement_id%TYPE ) IS

1226: PROCEDURE chk_parent_spine_id
1227: ( p_parent_spine_id IN per_cagr_entitlement_lines_f.parent_spine_id%TYPE
1228: ,p_cagr_entitlement_line_id IN
1229: per_cagr_entitlement_lines_f.cagr_entitlement_line_id%TYPE
1230: ,p_cagr_entitlement_id IN per_cagr_entitlement_lines_f.cagr_entitlement_id%TYPE ) IS
1231: --
1232:
1233: CURSOR csr_chk_category IS
1234: SELECT category_name

Line 1342: (p_status IN per_cagr_entitlement_lines_f.status%TYPE

1338: --
1339: -- ---------------------------------------------------------------------------
1340: --
1341: PROCEDURE chk_status
1342: (p_status IN per_cagr_entitlement_lines_f.status%TYPE
1343: ,p_cagr_entitlement_line_id IN per_cagr_entitlement_lines_f.cagr_entitlement_line_id%TYPE
1344: ,p_effective_date IN DATE
1345: ,p_validation_start_date IN DATE
1346: ,p_validation_end_date IN DATE) IS

Line 1343: ,p_cagr_entitlement_line_id IN per_cagr_entitlement_lines_f.cagr_entitlement_line_id%TYPE

1339: -- ---------------------------------------------------------------------------
1340: --
1341: PROCEDURE chk_status
1342: (p_status IN per_cagr_entitlement_lines_f.status%TYPE
1343: ,p_cagr_entitlement_line_id IN per_cagr_entitlement_lines_f.cagr_entitlement_line_id%TYPE
1344: ,p_effective_date IN DATE
1345: ,p_validation_start_date IN DATE
1346: ,p_validation_end_date IN DATE) IS
1347:

Line 1432: ( p_oipl_id IN per_cagr_entitlement_lines_f.oipl_id%TYPE

1428: --
1429: -- ---------------------------------------------------------------------------
1430: --
1431: PROCEDURE chk_oipl_id
1432: ( p_oipl_id IN per_cagr_entitlement_lines_f.oipl_id%TYPE
1433: ,p_cagr_entitlement_line_id IN NUMBER
1434: ,p_effective_date IN DATE
1435: ,p_validation_start_date IN DATE
1436: ,p_validation_end_date IN DATE) IS

Line 1555: (p_eligy_prfl_id IN per_cagr_entitlement_lines_f.eligy_prfl_id%TYPE

1551: --
1552: -- ---------------------------------------------------------------------------
1553: --
1554: PROCEDURE chk_eligy_prfl_id
1555: (p_eligy_prfl_id IN per_cagr_entitlement_lines_f.eligy_prfl_id%TYPE
1556: ,p_grade_spine_id IN NUMBER
1557: ,p_category_name IN VARCHAR2
1558: ,p_cagr_entitlement_line_id IN NUMBER
1559: ,p_cagr_entitlement_id IN per_cagr_entitlement_lines_f.cagr_entitlement_id%TYPE

Line 1559: ,p_cagr_entitlement_id IN per_cagr_entitlement_lines_f.cagr_entitlement_id%TYPE

1555: (p_eligy_prfl_id IN per_cagr_entitlement_lines_f.eligy_prfl_id%TYPE
1556: ,p_grade_spine_id IN NUMBER
1557: ,p_category_name IN VARCHAR2
1558: ,p_cagr_entitlement_line_id IN NUMBER
1559: ,p_cagr_entitlement_id IN per_cagr_entitlement_lines_f.cagr_entitlement_id%TYPE
1560: ,p_business_group_id IN NUMBER
1561: ,p_formula_criteria IN VARCHAR2
1562: ,p_effective_date IN DATE) IS
1563: --

Line 1577: -- FROM per_cagr_entitlement_lines_f pcl

1573: --
1574: -- Fix for bug 2491566
1575: --
1576: --AND NOT EXISTS (SELECT 'X'
1577: -- FROM per_cagr_entitlement_lines_f pcl
1578: -- WHERE pcl.eligy_prfl_id = bep.eligy_prfl_id
1579: -- AND pcl.cagr_entitlement_id = p_cagr_entitlement_id
1580: -- AND p_effective_date BETWEEN pcl.effective_start_date AND
1581: -- pcl.effective_end_date)

Line 1589: -- FROM per_cagr_entitlement_lines_f pcl

1585: --
1586: -- Fix for bug 2491566
1587: --
1588: --WHERE NOT EXISTS (SELECT 'X'
1589: -- FROM per_cagr_entitlement_lines_f pcl
1590: -- WHERE pcl.eligy_prfl_id = 0
1591: -- AND pcl.cagr_entitlement_id = p_cagr_entitlement_id
1592: -- AND p_effective_date BETWEEN pcl.effective_start_date AND
1593: -- pcl.effective_end_date);

Line 1606: -- FROM per_cagr_entitlement_lines_f pcl

1602: --
1603: -- Fix for bug 2491566
1604: --
1605: --AND NOT EXISTS (SELECT 'X'
1606: -- FROM per_cagr_entitlement_lines_f pcl
1607: -- WHERE pcl.eligy_prfl_id = bep.eligy_prfl_id
1608: -- AND pcl.grade_spine_id = p_grade_spine_id
1609: -- AND pcl.cagr_entitlement_id = p_cagr_entitlement_id
1610: -- AND p_effective_date BETWEEN pcl.effective_start_date

Line 1619: -- FROM per_cagr_entitlement_lines_f pcl

1615: --
1616: -- Fix for bug 2491566
1617: --
1618: --WHERE NOT EXISTS (SELECT 'X'
1619: -- FROM per_cagr_entitlement_lines_f pcl
1620: -- WHERE pcl.eligy_prfl_id = 0
1621: -- AND pcl.grade_spine_id = p_grade_spine_id
1622: -- AND pcl.cagr_entitlement_id = p_cagr_entitlement_id
1623: -- AND p_effective_date BETWEEN pcl.effective_start_date

Line 1629: l_eligy_prfl_id per_cagr_entitlement_lines_f.oipl_id%TYPE;

1625: --
1626: -- Delcare Local Variables
1627: --
1628: l_proc VARCHAR2(72) := g_package || 'chk_eligy_prfl_id';
1629: l_eligy_prfl_id per_cagr_entitlement_lines_f.oipl_id%TYPE;
1630: --
1631: BEGIN
1632: --
1633: hr_utility.set_location('Entering:'||l_proc, 10);

Line 1762: ( p_step_id IN per_cagr_entitlement_lines_f.step_id%TYPE

1758: --
1759: -- ---------------------------------------------------------------------------
1760: --
1761: PROCEDURE chk_step_id
1762: ( p_step_id IN per_cagr_entitlement_lines_f.step_id%TYPE
1763: ,p_cagr_entitlement_line_id IN NUMBER
1764: ,p_cagr_entitlement_id IN per_cagr_entitlement_lines_f.cagr_entitlement_id%TYPE
1765: ,p_effective_date IN DATE
1766: ,p_validation_start_date IN DATE

Line 1764: ,p_cagr_entitlement_id IN per_cagr_entitlement_lines_f.cagr_entitlement_id%TYPE

1760: --
1761: PROCEDURE chk_step_id
1762: ( p_step_id IN per_cagr_entitlement_lines_f.step_id%TYPE
1763: ,p_cagr_entitlement_line_id IN NUMBER
1764: ,p_cagr_entitlement_id IN per_cagr_entitlement_lines_f.cagr_entitlement_id%TYPE
1765: ,p_effective_date IN DATE
1766: ,p_validation_start_date IN DATE
1767: ,p_validation_end_date IN DATE) IS
1768: --

Line 1901: p_object_version_number in per_cagr_entitlement_lines_f.object_version_number%TYPE

1897: --
1898: -- ---------------------------------------------------------------------------
1899: procedure chk_object_version_number
1900: (
1901: p_object_version_number in per_cagr_entitlement_lines_f.object_version_number%TYPE
1902: ) is
1903: --
1904: l_proc varchar2(72) := g_package||'chk_object_version_number';
1905: --