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_PCL_SHD

Line 413: ,p_rec in per_pcl_shd.g_rec_type

409: -- {End Of Comments}
410: -- ----------------------------------------------------------------------------
411: Procedure chk_non_updateable_args
412: (p_effective_date in date
413: ,p_rec in per_pcl_shd.g_rec_type
414: ) IS
415: --
416: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
417: l_error EXCEPTION;

Line 425: IF NOT per_pcl_shd.api_updating

421: --
422: -- Only proceed with the validation if a row exists for the current
423: -- record in the HR Schema.
424: --
425: IF NOT per_pcl_shd.api_updating
426: (p_cagr_entitlement_line_id => p_rec.cagr_entitlement_line_id
427: ,p_effective_date => p_effective_date
428: ,p_object_version_number => p_rec.object_version_number
429: ) THEN

Line 438: nvl(per_pcl_shd.g_old_rec.cagr_entitlement_id,hr_api.g_number) THEN

434: END IF;
435:
436:
437: IF nvl(p_rec.cagr_entitlement_id, hr_api.g_number) <>
438: nvl(per_pcl_shd.g_old_rec.cagr_entitlement_id,hr_api.g_number) THEN
439: --
440: l_argument := 'cagr_entitlement_id';
441: RAISE l_error;
442: --

Line 518: (per_pcl_shd.g_old_rec.mandatory <> p_mandatory))) THEN

514: -- b) The value for mandatory has changed
515: --
516: IF ( (p_cagr_entitlement_line_id IS NULL) OR
517: ((p_cagr_entitlement_line_id IS NOT NULL) AND
518: (per_pcl_shd.g_old_rec.mandatory <> p_mandatory))) THEN
519: --
520: hr_utility.set_location(l_proc, 20);
521: --
522: -- Check that the type exists in HR_LOOKUPS

Line 619: l_non_value_category := per_pcl_shd.non_value_category

615: --
616: -- Function to see if the value field is supported
617: -- by the category name passed in.
618: --
619: l_non_value_category := per_pcl_shd.non_value_category
620: (p_category_name => p_category_name);
621: --
622: -- If the value field has been populated for a category
623: -- that does not use the value field then raise an error.

Line 652: (per_pcl_shd.g_old_rec.value <> p_value))) THEN

648: -- b) The value for value has changed
649: --
650: IF ( (p_cagr_entitlement_line_id IS NULL) OR
651: ((p_cagr_entitlement_line_id IS NOT NULL) AND
652: (per_pcl_shd.g_old_rec.value <> p_value))) THEN
653: --
654: hr_utility.set_location(l_proc,30);
655: --
656: -- Fetch the flex_value_set_id if one has

Line 659: l_flex_value_set_id := per_pcl_shd.retrieve_value_set_id

655: --
656: -- Fetch the flex_value_set_id if one has
657: -- been set for the entitlement item
658: --
659: l_flex_value_set_id := per_pcl_shd.retrieve_value_set_id
660: (p_cagr_entitlement_item_id => p_cagr_entitlement_item_id);
661: --
662: hr_utility.set_location(l_proc, 40);
663: --

Line 791: l_non_value_category := per_pcl_shd.non_value_category

787: --
788: -- Function to see if the range_from field is supported
789: -- by the category name passed in.
790: --
791: l_non_value_category := per_pcl_shd.non_value_category
792: (p_category_name => p_category_name);
793: --
794: -- If the range_from field has been populated for a category
795: -- that does not use the range_from field then raise an error.

Line 816: (per_pcl_shd.g_old_rec.range_from <> p_range_from)))THEN

812: -- b) The value for range_from has changed
813: --
814: IF ( (p_cagr_entitlement_line_id IS NULL) OR
815: ((p_cagr_entitlement_line_id IS NOT NULL) AND
816: (per_pcl_shd.g_old_rec.range_from <> p_range_from)))THEN
817: --
818: hr_utility.set_location(l_proc,30);
819: --
820: -- Fetch the flex_value_set_id if one has

Line 823: l_flex_value_set_id := per_pcl_shd.retrieve_value_set_id

819: --
820: -- Fetch the flex_value_set_id if one has
821: -- been set for the entitlement item
822: --
823: l_flex_value_set_id := per_pcl_shd.retrieve_value_set_id
824: (p_cagr_entitlement_item_id => p_cagr_entitlement_item_id);
825: --
826: hr_utility.set_location(l_proc, 40);
827: --

Line 955: l_non_value_category := per_pcl_shd.non_value_category

951: --
952: -- Function to see if the range_to field is supported
953: -- by the category name passed in.
954: --
955: l_non_value_category := per_pcl_shd.non_value_category
956: (p_category_name => p_category_name);
957: --
958: -- If the range_to field has been populated for a category
959: -- that does not use the range_to field then raise an error.

Line 982: (per_pcl_shd.g_old_rec.range_to <> p_range_to))) THEN

978: -- b) The value for range_to has changed
979: --
980: IF ( (p_cagr_entitlement_line_id IS NULL) OR
981: ((p_cagr_entitlement_line_id IS NOT NULL) AND
982: (per_pcl_shd.g_old_rec.range_to <> p_range_to))) THEN
983: --
984: hr_utility.set_location(l_proc,30);
985: --
986: -- Fetch the flex_value_set_id if one has

Line 989: l_flex_value_set_id := per_pcl_shd.retrieve_value_set_id

985: --
986: -- Fetch the flex_value_set_id if one has
987: -- been set for the entitlement item
988: --
989: l_flex_value_set_id := per_pcl_shd.retrieve_value_set_id
990: (p_cagr_entitlement_item_id => p_cagr_entitlement_item_id);
991: --
992: hr_utility.set_location(l_proc, 40);
993: --

Line 1149: (per_pcl_shd.g_old_rec.grade_spine_id <> p_grade_spine_id))) THEN

1145: -- check while inserting or updating grade_spine_id
1146:
1147: IF ((p_cagr_entitlement_line_id IS NULL) OR
1148: ((p_cagr_entitlement_line_id IS NOT NULL) AND
1149: (per_pcl_shd.g_old_rec.grade_spine_id <> p_grade_spine_id))) THEN
1150:
1151: hr_utility.set_location('Leaving:'||l_proc, 40);
1152:
1153: OPEN csr_chk_grd_fk_start;

Line 1278: (per_pcl_shd.g_old_rec.parent_spine_id <> p_parent_spine_id))) THEN

1274: --
1275:
1276: IF ((p_cagr_entitlement_line_id IS NULL) OR
1277: ((p_cagr_entitlement_line_id IS NOT NULL) AND
1278: (per_pcl_shd.g_old_rec.parent_spine_id <> p_parent_spine_id))) THEN
1279:
1280:
1281: hr_utility.set_location(l_proc,40);
1282: OPEN csr_chk_parent_spine_fk;

Line 1366: (per_pcl_shd.g_old_rec.status <> p_status))) THEN

1362: --
1363: hr_utility.set_location(l_proc, 20);
1364: IF ((p_cagr_entitlement_line_id IS NULL) OR
1365: ((p_cagr_entitlement_line_id IS NOT NULL) AND
1366: (per_pcl_shd.g_old_rec.status <> p_status))) THEN
1367:
1368: hr_utility.set_location(l_proc, 30);
1369: --
1370: -- Check that the type exists in HR_LOOKUPS

Line 1475: (per_pcl_shd.g_old_rec.oipl_id <> p_oipl_id))) THEN

1471: -- b) The value for oipl_id has changed
1472: --
1473: IF ( (p_cagr_entitlement_line_id IS NULL) OR
1474: ((p_cagr_entitlement_line_id IS NOT NULL) AND
1475: (per_pcl_shd.g_old_rec.oipl_id <> p_oipl_id))) THEN
1476:
1477: hr_utility.set_location('Leaving:'||l_proc, 20);
1478: OPEN csr_chk_oipl_fk_start;
1479: FETCH csr_chk_oipl_fk_start INTO l_dummy;

Line 1653: ((per_pcl_shd.g_old_rec.eligy_prfl_id <> p_eligy_prfl_id) OR

1649: -- b) The value for eligy_prfl_id has changed
1650: --
1651: IF ( (p_cagr_entitlement_line_id IS NULL) OR
1652: ((p_cagr_entitlement_line_id IS NOT NULL) AND
1653: ((per_pcl_shd.g_old_rec.eligy_prfl_id <> p_eligy_prfl_id) OR
1654: (per_pcl_shd.g_old_rec.grade_spine_id <> p_grade_spine_id))
1655: )
1656: ) THEN
1657: --

Line 1654: (per_pcl_shd.g_old_rec.grade_spine_id <> p_grade_spine_id))

1650: --
1651: IF ( (p_cagr_entitlement_line_id IS NULL) OR
1652: ((p_cagr_entitlement_line_id IS NOT NULL) AND
1653: ((per_pcl_shd.g_old_rec.eligy_prfl_id <> p_eligy_prfl_id) OR
1654: (per_pcl_shd.g_old_rec.grade_spine_id <> p_grade_spine_id))
1655: )
1656: ) THEN
1657: --
1658: hr_utility.set_location(l_proc, 20);

Line 1827: (per_pcl_shd.g_old_rec.step_id <> p_step_id))) THEN

1823: --
1824:
1825: IF ((p_cagr_entitlement_line_id IS NULL) OR
1826: ((p_cagr_entitlement_line_id IS NOT NULL) AND
1827: (per_pcl_shd.g_old_rec.step_id <> p_step_id))) THEN
1828:
1829: hr_utility.set_location(l_proc, 40);
1830: OPEN csr_chk_step_fk_start;
1831: FETCH csr_chk_step_fk_start INTO l_dummy;

Line 2166: (p_rec in per_pcl_shd.g_rec_type

2162: -- ----------------------------------------------------------------------------
2163: -- |---------------------------< insert_validate >----------------------------|
2164: -- ----------------------------------------------------------------------------
2165: PROCEDURE insert_validate
2166: (p_rec in per_pcl_shd.g_rec_type
2167: ,p_effective_date in date
2168: ,p_datetrack_mode in varchar2
2169: ,p_validation_start_date in date
2170: ,p_validation_end_date in date

Line 2187: per_pcl_shd.retrieve_cagr_info

2183: --
2184: -- Call procedure that returns the collective agreement id
2185: -- and business_group_id that will be used in the chk procedures
2186: --
2187: per_pcl_shd.retrieve_cagr_info
2188: (p_cagr_entitlement_id => p_rec.cagr_entitlement_id
2189: ,p_collective_agreement_id => l_collective_agreement_id
2190: ,p_business_group_id => l_business_group_id);
2191: --

Line 2202: per_pcl_shd.retrieve_entitlement_item_info

2198: ,p_collective_agreement_id => l_collective_agreement_id);
2199: --
2200: -- Retrieve the entitlement_item_id and category name
2201: --
2202: per_pcl_shd.retrieve_entitlement_item_info
2203: (p_cagr_entitlement_id => p_rec.cagr_entitlement_id
2204: ,p_cagr_entitlement_item_id => l_cagr_entitlement_item_id
2205: ,p_category_name => l_category_name
2206: ,p_formula_criteria => l_formula_criteria);

Line 2342: (p_rec in per_pcl_shd.g_rec_type

2338: -- ----------------------------------------------------------------------------
2339: -- |---------------------------< update_validate >----------------------------|
2340: -- ----------------------------------------------------------------------------
2341: Procedure update_validate
2342: (p_rec in per_pcl_shd.g_rec_type
2343: ,p_effective_date in date
2344: ,p_datetrack_mode in varchar2
2345: ,p_validation_start_date in date
2346: ,p_validation_end_date in date

Line 2363: per_pcl_shd.retrieve_cagr_info

2359: --
2360: -- Call procedure that returns the collective agreement id
2361: -- and business_group_id that will be used in the chk procedures
2362: --
2363: per_pcl_shd.retrieve_cagr_info
2364: (p_cagr_entitlement_id => p_rec.cagr_entitlement_id
2365: ,p_collective_agreement_id => l_collective_agreement_id
2366: ,p_business_group_id => l_business_group_id);
2367: --

Line 2382: per_pcl_shd.retrieve_entitlement_item_info

2378: ,p_rec => p_rec);
2379: --
2380: -- Retrieve the entitlement_item_id and category name
2381: --
2382: per_pcl_shd.retrieve_entitlement_item_info
2383: (p_cagr_entitlement_id => p_rec.cagr_entitlement_id
2384: ,p_cagr_entitlement_item_id => l_cagr_entitlement_item_id
2385: ,p_category_name => l_category_name
2386: ,p_formula_criteria => l_formula_criteria);

Line 2544: (p_rec in per_pcl_shd.g_rec_type

2540: -- ----------------------------------------------------------------------------
2541: -- |---------------------------< delete_validate >----------------------------|
2542: -- ----------------------------------------------------------------------------
2543: Procedure delete_validate
2544: (p_rec in per_pcl_shd.g_rec_type
2545: ,p_effective_date in date
2546: ,p_datetrack_mode in varchar2
2547: ,p_validation_start_date in date
2548: ,p_validation_end_date in date