APPS.PQP_GB_OMP_TEMPLATE dependencies on STANDARD

Line 2154: -- Check if this Element is Linked to Benefit Standard Rates

2150: FETCH csr_get_ele_type_id INTO l_element_type_id;
2151: EXIT WHEN csr_get_ele_type_id%NOTFOUND;
2152:
2153:
2154: -- Check if this Element is Linked to Benefit Standard Rates
2155: check_ben_standard_rates_link (
2156: p_business_group_id => p_business_group_id
2157: ,p_plan_id => p_plan_id
2158: ,p_element_type_id => l_element_type_id ) ;

Line 2155: check_ben_standard_rates_link (

2151: EXIT WHEN csr_get_ele_type_id%NOTFOUND;
2152:
2153:
2154: -- Check if this Element is Linked to Benefit Standard Rates
2155: check_ben_standard_rates_link (
2156: p_business_group_id => p_business_group_id
2157: ,p_plan_id => p_plan_id
2158: ,p_element_type_id => l_element_type_id ) ;
2159:

Line 2413: p_standard_link_flag => 'N',

2409: p_pay_basis_id => NULL,
2410: p_costable_type => 'N',
2411: p_link_to_all_payrolls_flag => 'N',
2412: p_multiply_value_flag => 'N',
2413: p_standard_link_flag => 'N',
2414: p_transfer_to_gl_flag => 'N',
2415: p_comment_id => NULL,
2416: p_employment_category => NULL,
2417: p_qualifying_age => NULL,

Line 2570: -- This Procedure checks if there are any Standard Rates exists

2566:
2567: END delete_element_links ;
2568:
2569:
2570: -- This Procedure checks if there are any Standard Rates exists
2571: -- for the Scheme. If any exists it raises a error.
2572: -- This shud be called before deleting a Scheme.
2573:
2574:

Line 2575: PROCEDURE check_ben_standard_rates_link (

2571: -- for the Scheme. If any exists it raises a error.
2572: -- This shud be called before deleting a Scheme.
2573:
2574:
2575: PROCEDURE check_ben_standard_rates_link (
2576: p_business_group_id in number
2577: ,p_plan_id in number
2578: ,p_element_type_id in number ) IS
2579:

Line 2595: -- standard rate formula before deleting them

2591:
2592: BEGIN
2593:
2594: -- Check whether elements are attached to benefits
2595: -- standard rate formula before deleting them
2596:
2597: OPEN csr_chk_ele_in_ben (
2598: p_business_group_id => p_business_group_id
2599: ,p_plan_id => p_plan_id

Line 2608: hr_utility.set_message_token('TYPE','Standard Rates, Table: BEN_ACTY_BASE_RT_F');

2604:
2605: -- Raise Error
2606: Close csr_chk_ele_in_ben;
2607: hr_utility.set_message (800,'PER_74880_CHILD_RECORD');
2608: hr_utility.set_message_token('TYPE','Standard Rates, Table: BEN_ACTY_BASE_RT_F');
2609: hr_utility.raise_error;
2610:
2611: END IF; -- End if of element in ben check ...
2612: CLOSE csr_chk_ele_in_ben;

Line 2614: END check_ben_standard_rates_link ;

2610:
2611: END IF; -- End if of element in ben check ...
2612: CLOSE csr_chk_ele_in_ben;
2613:
2614: END check_ben_standard_rates_link ;
2615:
2616:
2617:
2618: --