[Home] [Help]
17: -- |--------------------------< check_for_correct_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
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
255: and pcl.cagr_entitlement_id = pce.cagr_entitlement_id
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
323: and pcl.cagr_entitlement_id = pce.cagr_entitlement_id
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: --
596: -- Declare Local Variables
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:
1102:
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:
1240: --
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:
1779: CURSOR csr_chk_step_fk_start IS
2172: --
2173: l_collective_agreement_id NUMBER;
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
2346: ,p_validation_end_date in date
2347: ) is
2348: --
2349: l_proc varchar2(72) := g_package||'update_validate';
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;
2347: ) is
2348: --
2349: l_proc varchar2(72) := g_package||'update_validate';
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: --