DBA Data[Home] [Help]

APPS.PAY_CA_USER_INIT_EARN dependencies on HR_API

Line 561: 'Earnings',nvl(p_ele_category, hr_api.g_varchar2),

557: FROM dual;
558: --
559: SELECT
560: DECODE(p_ele_classification,
561: 'Earnings',nvl(p_ele_category, hr_api.g_varchar2),
562: 'Supplemental Earnings',nvl(p_ele_category, hr_api.g_varchar2),
563: 'Taxable Benefits',nvl(p_ele_category, hr_api.g_varchar2),
564: '')
565: INTO l_sf_ele_category

Line 562: 'Supplemental Earnings',nvl(p_ele_category, hr_api.g_varchar2),

558: --
559: SELECT
560: DECODE(p_ele_classification,
561: 'Earnings',nvl(p_ele_category, hr_api.g_varchar2),
562: 'Supplemental Earnings',nvl(p_ele_category, hr_api.g_varchar2),
563: 'Taxable Benefits',nvl(p_ele_category, hr_api.g_varchar2),
564: '')
565: INTO l_sf_ele_category
566: FROM dual;

Line 563: 'Taxable Benefits',nvl(p_ele_category, hr_api.g_varchar2),

559: SELECT
560: DECODE(p_ele_classification,
561: 'Earnings',nvl(p_ele_category, hr_api.g_varchar2),
562: 'Supplemental Earnings',nvl(p_ele_category, hr_api.g_varchar2),
563: 'Taxable Benefits',nvl(p_ele_category, hr_api.g_varchar2),
564: '')
565: INTO l_sf_ele_category
566: FROM dual;
567: --

Line 570: 'Earnings', nvl(upper(g_template_leg_code||'_'||p_ele_classification), hr_api.g_varchar2),

566: FROM dual;
567: --
568: SELECT
569: DECODE(p_ele_classification,
570: 'Earnings', nvl(upper(g_template_leg_code||'_'||p_ele_classification), hr_api.g_varchar2),
571: 'Supplemental Earnings', nvl(upper(g_template_leg_code||'_'||p_ele_classification), hr_api.g_varchar2),
572: 'Taxable Benefits', nvl(upper(g_template_leg_code||'_'||p_ele_classification), hr_api.g_varchar2),
573: '')
574: INTO l_sf_ele_info_category

Line 571: 'Supplemental Earnings', nvl(upper(g_template_leg_code||'_'||p_ele_classification), hr_api.g_varchar2),

567: --
568: SELECT
569: DECODE(p_ele_classification,
570: 'Earnings', nvl(upper(g_template_leg_code||'_'||p_ele_classification), hr_api.g_varchar2),
571: 'Supplemental Earnings', nvl(upper(g_template_leg_code||'_'||p_ele_classification), hr_api.g_varchar2),
572: 'Taxable Benefits', nvl(upper(g_template_leg_code||'_'||p_ele_classification), hr_api.g_varchar2),
573: '')
574: INTO l_sf_ele_info_category
575: FROM dual;

Line 572: 'Taxable Benefits', nvl(upper(g_template_leg_code||'_'||p_ele_classification), hr_api.g_varchar2),

568: SELECT
569: DECODE(p_ele_classification,
570: 'Earnings', nvl(upper(g_template_leg_code||'_'||p_ele_classification), hr_api.g_varchar2),
571: 'Supplemental Earnings', nvl(upper(g_template_leg_code||'_'||p_ele_classification), hr_api.g_varchar2),
572: 'Taxable Benefits', nvl(upper(g_template_leg_code||'_'||p_ele_classification), hr_api.g_varchar2),
573: '')
574: INTO l_sf_ele_info_category
575: FROM dual;
576: --

Line 584: ,p_classification_name => nvl(p_ele_classification, hr_api.g_varchar2)

580: pay_shadow_element_api.update_shadow_element
581: (p_validate => false
582: ,p_effective_date => p_ele_eff_start_date
583: ,p_element_type_id => l_element_type_id
584: ,p_classification_name => nvl(p_ele_classification, hr_api.g_varchar2)
585: ,p_post_termination_rule => p_termination_rule -- bug 8491239
586: ,p_processing_type => nvl(p_ele_processing_type, hr_api.g_varchar2)
587: ,p_standard_link_flag => nvl(p_ele_standard_link, hr_api.g_varchar2)
588: ,p_description => p_ele_description

Line 586: ,p_processing_type => nvl(p_ele_processing_type, hr_api.g_varchar2)

582: ,p_effective_date => p_ele_eff_start_date
583: ,p_element_type_id => l_element_type_id
584: ,p_classification_name => nvl(p_ele_classification, hr_api.g_varchar2)
585: ,p_post_termination_rule => p_termination_rule -- bug 8491239
586: ,p_processing_type => nvl(p_ele_processing_type, hr_api.g_varchar2)
587: ,p_standard_link_flag => nvl(p_ele_standard_link, hr_api.g_varchar2)
588: ,p_description => p_ele_description
589: ,p_reporting_name => p_ele_reporting_name
590: ,p_element_information_category => nvl(upper(g_template_leg_code||'_'||p_ele_classification), hr_api.g_varchar2)

Line 587: ,p_standard_link_flag => nvl(p_ele_standard_link, hr_api.g_varchar2)

583: ,p_element_type_id => l_element_type_id
584: ,p_classification_name => nvl(p_ele_classification, hr_api.g_varchar2)
585: ,p_post_termination_rule => p_termination_rule -- bug 8491239
586: ,p_processing_type => nvl(p_ele_processing_type, hr_api.g_varchar2)
587: ,p_standard_link_flag => nvl(p_ele_standard_link, hr_api.g_varchar2)
588: ,p_description => p_ele_description
589: ,p_reporting_name => p_ele_reporting_name
590: ,p_element_information_category => nvl(upper(g_template_leg_code||'_'||p_ele_classification), hr_api.g_varchar2)
591: ,p_element_information1 => nvl(p_ele_category, hr_api.g_varchar2)

Line 590: ,p_element_information_category => nvl(upper(g_template_leg_code||'_'||p_ele_classification), hr_api.g_varchar2)

586: ,p_processing_type => nvl(p_ele_processing_type, hr_api.g_varchar2)
587: ,p_standard_link_flag => nvl(p_ele_standard_link, hr_api.g_varchar2)
588: ,p_description => p_ele_description
589: ,p_reporting_name => p_ele_reporting_name
590: ,p_element_information_category => nvl(upper(g_template_leg_code||'_'||p_ele_classification), hr_api.g_varchar2)
591: ,p_element_information1 => nvl(p_ele_category, hr_api.g_varchar2)
592: ,p_element_information2 => p_ele_calc_method
593: ,p_element_information4 => p_ele_eoy_type
594: ,p_element_information18 => p_ele_t4a_footnote

Line 591: ,p_element_information1 => nvl(p_ele_category, hr_api.g_varchar2)

587: ,p_standard_link_flag => nvl(p_ele_standard_link, hr_api.g_varchar2)
588: ,p_description => p_ele_description
589: ,p_reporting_name => p_ele_reporting_name
590: ,p_element_information_category => nvl(upper(g_template_leg_code||'_'||p_ele_classification), hr_api.g_varchar2)
591: ,p_element_information1 => nvl(p_ele_category, hr_api.g_varchar2)
592: ,p_element_information2 => p_ele_calc_method
593: ,p_element_information4 => p_ele_eoy_type
594: ,p_element_information18 => p_ele_t4a_footnote
595: ,p_element_information19 => p_ele_rl1_footnote

Line 612: ,p_classification_name => nvl(p_ele_classification, hr_api.g_varchar2)

608: pay_shadow_element_api.update_shadow_element
609: (p_validate => false
610: ,p_effective_date => p_ele_eff_start_date
611: ,p_element_type_id => l_sf_element_type_id
612: ,p_classification_name => nvl(p_ele_classification, hr_api.g_varchar2)
613: ,p_post_termination_rule => p_termination_rule -- bug 8491239
614: ,p_element_information_category => l_sf_ele_info_category
615: ,p_reporting_name => p_ele_reporting_name||' SF'
616: ,p_element_information1 => l_sf_ele_category

Line 632: ,p_classification_name => nvl(p_ele_classification, hr_api.g_varchar2)

628: pay_shadow_element_api.update_shadow_element
629: (p_validate => false
630: ,p_effective_date => p_ele_eff_start_date
631: ,p_element_type_id => l_si_element_type_id
632: ,p_classification_name => nvl(p_ele_classification, hr_api.g_varchar2)
633: ,p_post_termination_rule => p_termination_rule -- bug 8491239
634: ,p_reporting_name => p_ele_reporting_name||' SI'
635: ,p_object_version_number => l_si_ele_obj_ver_number);
636: end if;