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_ITEMS

Line 28: l_column_type per_cagr_entitlement_items.column_type%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;
29: l_value_date DATE;
30: l_range_to_date DATE;
31: l_range_from_date DATE;
32: --

Line 104: l_column_type per_cagr_entitlement_items.column_type%TYPE;

100: --
101: -- Delcare Local Variables
102: --
103: l_proc VARCHAR2(72) := g_package||'check_for_correct_type';
104: l_column_type per_cagr_entitlement_items.column_type%TYPE;
105: l_column_size per_cagr_entitlement_items.column_size%TYPE;
106: l_number NUMBER;
107: l_date DATE;
108: l_value VARCHAR2(255);

Line 105: l_column_size per_cagr_entitlement_items.column_size%TYPE;

101: -- Delcare Local Variables
102: --
103: l_proc VARCHAR2(72) := g_package||'check_for_correct_type';
104: l_column_type per_cagr_entitlement_items.column_type%TYPE;
105: l_column_size per_cagr_entitlement_items.column_size%TYPE;
106: l_number NUMBER;
107: l_date DATE;
108: l_value VARCHAR2(255);
109: l_output VARCHAR2(255);

Line 122: per_cagr_entitlement_items cei

118: --
119: CURSOR csr_get_item_size IS
120: SELECT cap.column_size
121: FROM per_cagr_api_parameters cap,
122: per_cagr_entitlement_items cei
123: WHERE cap.cagr_api_param_id = cei.cagr_api_param_id
124: AND cei.cagr_entitlement_item_id = p_cagr_entitlement_item_id;
125: --
126: BEGIN

Line 252: , per_cagr_entitlement_items pci

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
255: and pcl.cagr_entitlement_id = pce.cagr_entitlement_id
256: and pce.cagr_entitlement_item_id = pci.cagr_entitlement_item_id

Line 320: , per_cagr_entitlement_items pci

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
323: and pcl.cagr_entitlement_id = pce.cagr_entitlement_id
324: and pce.cagr_entitlement_item_id = pci.cagr_entitlement_item_id

Line 591: ,p_cagr_entitlement_item_id IN per_cagr_entitlement_items.cagr_entitlement_item_id%TYPE

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
595: --

Line 599: l_flex_value_set_id per_cagr_entitlement_items.flex_value_set_id%TYPE;

595: --
596: -- Declare Local Variables
597: --
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);

Line 764: ,p_cagr_entitlement_item_id IN per_cagr_entitlement_items.cagr_entitlement_item_id%TYPE

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: --
768: -- Declare Local Variables

Line 771: l_flex_value_set_id per_cagr_entitlement_items.flex_value_set_id%TYPE;

767: --
768: -- Declare Local Variables
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);

Line 928: ,p_cagr_entitlement_item_id IN per_cagr_entitlement_items.cagr_entitlement_item_id%TYPE

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: --
932: -- Declare Local Variables

Line 935: l_flex_value_set_id per_cagr_entitlement_items.flex_value_set_id%TYPE;

931: --
932: -- Declare Local Variables
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);

Line 1097: FROM per_cagr_entitlement_items pci

1093: ,p_validation_end_date IN DATE) IS
1094:
1095: CURSOR csr_chk_category IS
1096: SELECT category_name
1097: FROM per_cagr_entitlement_items pci
1098: ,per_cagr_entitlements pce
1099: WHERE pci.CAGR_ENTITLEMENT_ITEM_ID = pce.CAGR_ENTITLEMENT_ITEM_ID
1100: AND pce.CAGR_ENTITLEMENT_ID = p_CAGR_ENTITLEMENT_ID;
1101:

Line 1119: l_cat per_cagr_entitlement_items.category_name%TYPE;

1115:
1116:
1117: --
1118: l_proc VARCHAR2(72) := g_package || 'chk_grade_spine_id';
1119: l_cat per_cagr_entitlement_items.category_name%TYPE;
1120: l_grd VARCHAR2(1);
1121: --
1122:
1123: BEGIN

Line 1235: FROM per_cagr_entitlement_items pci

1231: --
1232:
1233: CURSOR csr_chk_category IS
1234: SELECT category_name
1235: FROM per_cagr_entitlement_items pci
1236: ,per_cagr_entitlements pce
1237: WHERE pci.CAGR_ENTITLEMENT_ITEM_ID = pce.CAGR_ENTITLEMENT_ITEM_ID
1238: AND pce.CAGR_ENTITLEMENT_ID = p_CAGR_ENTITLEMENT_ID;
1239:

Line 1248: l_cat per_cagr_entitlement_items.category_name%TYPE;

1244: WHERE pps.parent_spine_id = p_parent_spine_id;
1245: --
1246: l_proc VARCHAR2(72) := g_package || 'chk_parent_spine_id';
1247: l_dummy VARCHAR2(1);
1248: l_cat per_cagr_entitlement_items.category_name%TYPE;
1249: --
1250: BEGIN
1251: --
1252: hr_utility.set_location('Entering:'||l_proc, 10);

Line 1774: FROM per_cagr_entitlement_items pci

1770: --
1771:
1772: CURSOR csr_chk_category IS
1773: SELECT category_name
1774: FROM per_cagr_entitlement_items pci
1775: ,per_cagr_entitlements pce
1776: WHERE pci.CAGR_ENTITLEMENT_ITEM_ID = pce.CAGR_ENTITLEMENT_ITEM_ID
1777: AND pce.CAGR_ENTITLEMENT_ID = p_CAGR_ENTITLEMENT_ID;
1778:

Line 1797: l_cat per_cagr_entitlement_items.category_name%TYPE;

1793: -- Declare Local Variables
1794: --
1795: l_proc VARCHAR2(72) := g_package || 'chk_step_id';
1796: l_dummy VARCHAR2(1);
1797: l_cat per_cagr_entitlement_items.category_name%TYPE;
1798: --
1799: BEGIN
1800: --
1801: hr_utility.set_location('Entering:'||l_proc, 10);

Line 2178: l_category_name per_cagr_entitlement_items.category_name%TYPE;

2174: l_proc VARCHAR2(72) := g_package||'insert_validate';
2175: l_cagr_entitlement_item_id NUMBER;
2176: l_formula_criteria per_cagr_entitlements.formula_criteria%TYPE;
2177: l_business_group_id NUMBER;
2178: l_category_name per_cagr_entitlement_items.category_name%TYPE;
2179: --
2180: BEGIN
2181: --
2182: hr_utility.set_location('Entering:'||l_proc, 10);

Line 2354: l_category_name per_cagr_entitlement_items.category_name%TYPE;

2350: l_cagr_entitlement_item_id per_cagr_entitlements.cagr_entitlement_item_id%TYPE;
2351: l_formula_criteria per_cagr_entitlements.formula_criteria%TYPE;
2352: l_collective_agreement_id NUMBER;
2353: l_business_group_id NUMBER;
2354: l_category_name per_cagr_entitlement_items.category_name%TYPE;
2355: --
2356: BEGIN
2357: --
2358: hr_utility.set_location('Entering:'||l_proc, 5);