552: FROM dual;
553: --
554: SELECT
555: DECODE(p_ele_classification,
556: 'Earnings',nvl(p_ele_category, hr_api.g_varchar2),
557: 'Supplemental Earnings',nvl(p_ele_category, hr_api.g_varchar2),
558: 'Taxable Benefits',nvl(p_ele_category, hr_api.g_varchar2),
559: '')
560: INTO l_sf_ele_category
553: --
554: SELECT
555: DECODE(p_ele_classification,
556: 'Earnings',nvl(p_ele_category, hr_api.g_varchar2),
557: 'Supplemental Earnings',nvl(p_ele_category, hr_api.g_varchar2),
558: 'Taxable Benefits',nvl(p_ele_category, hr_api.g_varchar2),
559: '')
560: INTO l_sf_ele_category
561: FROM dual;
554: SELECT
555: DECODE(p_ele_classification,
556: 'Earnings',nvl(p_ele_category, hr_api.g_varchar2),
557: 'Supplemental Earnings',nvl(p_ele_category, hr_api.g_varchar2),
558: 'Taxable Benefits',nvl(p_ele_category, hr_api.g_varchar2),
559: '')
560: INTO l_sf_ele_category
561: FROM dual;
562: --
561: FROM dual;
562: --
563: SELECT
564: DECODE(p_ele_classification,
565: 'Earnings', nvl(upper(g_template_leg_code||'_'||p_ele_classification), hr_api.g_varchar2),
566: 'Supplemental Earnings', nvl(upper(g_template_leg_code||'_'||p_ele_classification), hr_api.g_varchar2),
567: 'Taxable Benefits', nvl(upper(g_template_leg_code||'_'||p_ele_classification), hr_api.g_varchar2),
568: '')
569: INTO l_sf_ele_info_category
562: --
563: SELECT
564: DECODE(p_ele_classification,
565: 'Earnings', nvl(upper(g_template_leg_code||'_'||p_ele_classification), hr_api.g_varchar2),
566: 'Supplemental Earnings', nvl(upper(g_template_leg_code||'_'||p_ele_classification), hr_api.g_varchar2),
567: 'Taxable Benefits', nvl(upper(g_template_leg_code||'_'||p_ele_classification), hr_api.g_varchar2),
568: '')
569: INTO l_sf_ele_info_category
570: FROM dual;
563: SELECT
564: DECODE(p_ele_classification,
565: 'Earnings', nvl(upper(g_template_leg_code||'_'||p_ele_classification), hr_api.g_varchar2),
566: 'Supplemental Earnings', nvl(upper(g_template_leg_code||'_'||p_ele_classification), hr_api.g_varchar2),
567: 'Taxable Benefits', nvl(upper(g_template_leg_code||'_'||p_ele_classification), hr_api.g_varchar2),
568: '')
569: INTO l_sf_ele_info_category
570: FROM dual;
571: --
575: pay_shadow_element_api.update_shadow_element
576: (p_validate => false
577: ,p_effective_date => p_ele_eff_start_date
578: ,p_element_type_id => l_element_type_id
579: ,p_classification_name => nvl(p_ele_classification, hr_api.g_varchar2)
580: ,p_processing_type => nvl(p_ele_processing_type, hr_api.g_varchar2)
581: ,p_standard_link_flag => nvl(p_ele_standard_link, hr_api.g_varchar2)
582: ,p_description => p_ele_description
583: ,p_reporting_name => p_ele_reporting_name
576: (p_validate => false
577: ,p_effective_date => p_ele_eff_start_date
578: ,p_element_type_id => l_element_type_id
579: ,p_classification_name => nvl(p_ele_classification, hr_api.g_varchar2)
580: ,p_processing_type => nvl(p_ele_processing_type, hr_api.g_varchar2)
581: ,p_standard_link_flag => nvl(p_ele_standard_link, hr_api.g_varchar2)
582: ,p_description => p_ele_description
583: ,p_reporting_name => p_ele_reporting_name
584: ,p_element_information_category => nvl(upper(g_template_leg_code||'_'||p_ele_classification), hr_api.g_varchar2)
577: ,p_effective_date => p_ele_eff_start_date
578: ,p_element_type_id => l_element_type_id
579: ,p_classification_name => nvl(p_ele_classification, hr_api.g_varchar2)
580: ,p_processing_type => nvl(p_ele_processing_type, hr_api.g_varchar2)
581: ,p_standard_link_flag => nvl(p_ele_standard_link, hr_api.g_varchar2)
582: ,p_description => p_ele_description
583: ,p_reporting_name => p_ele_reporting_name
584: ,p_element_information_category => nvl(upper(g_template_leg_code||'_'||p_ele_classification), hr_api.g_varchar2)
585: ,p_element_information1 => nvl(p_ele_category, hr_api.g_varchar2)
580: ,p_processing_type => nvl(p_ele_processing_type, hr_api.g_varchar2)
581: ,p_standard_link_flag => nvl(p_ele_standard_link, hr_api.g_varchar2)
582: ,p_description => p_ele_description
583: ,p_reporting_name => p_ele_reporting_name
584: ,p_element_information_category => nvl(upper(g_template_leg_code||'_'||p_ele_classification), hr_api.g_varchar2)
585: ,p_element_information1 => nvl(p_ele_category, hr_api.g_varchar2)
586: ,p_element_information2 => p_ele_calc_method
587: ,p_element_information4 => p_ele_eoy_type
588: ,p_element_information18 => p_ele_t4a_footnote
581: ,p_standard_link_flag => nvl(p_ele_standard_link, hr_api.g_varchar2)
582: ,p_description => p_ele_description
583: ,p_reporting_name => p_ele_reporting_name
584: ,p_element_information_category => nvl(upper(g_template_leg_code||'_'||p_ele_classification), hr_api.g_varchar2)
585: ,p_element_information1 => nvl(p_ele_category, hr_api.g_varchar2)
586: ,p_element_information2 => p_ele_calc_method
587: ,p_element_information4 => p_ele_eoy_type
588: ,p_element_information18 => p_ele_t4a_footnote
589: ,p_element_information19 => p_ele_rl1_footnote
602: pay_shadow_element_api.update_shadow_element
603: (p_validate => false
604: ,p_effective_date => p_ele_eff_start_date
605: ,p_element_type_id => l_sf_element_type_id
606: ,p_classification_name => nvl(p_ele_classification, hr_api.g_varchar2)
607: ,p_element_information_category => l_sf_ele_info_category
608: ,p_reporting_name => p_ele_reporting_name||' SF'
609: ,p_element_information1 => l_sf_ele_category
610: ,p_element_information3 => l_roe_allocation_by
621: pay_shadow_element_api.update_shadow_element
622: (p_validate => false
623: ,p_effective_date => p_ele_eff_start_date
624: ,p_element_type_id => l_si_element_type_id
625: ,p_classification_name => nvl(p_ele_classification, hr_api.g_varchar2)
626: ,p_reporting_name => p_ele_reporting_name||' SI'
627: ,p_object_version_number => l_si_ele_obj_ver_number);
628: end if;
629: --