[Home] [Help]
155: FUNCTION get_template_id ( p_template_name IN VARCHAR2
156: ,p_legislation_code IN VARCHAR2 )
157: RETURN number IS
158: --
159: l_template_id pay_element_templates.template_id%TYPE ;
160: l_proc_step NUMBER(20,10);
161: l_proc_name VARCHAR2(72) := g_package_name || 'get_template_id';
162: --
163: CURSOR csr_get_temp_id is
161: l_proc_name VARCHAR2(72) := g_package_name || 'get_template_id';
162: --
163: CURSOR csr_get_temp_id is
164: SELECT template_id
165: FROM pay_element_templates
166: WHERE template_name = p_template_name
167: AND legislation_code = p_legislation_code
168: AND template_type = 'T'
169: AND business_group_id is NULL;
860:
861:
862: l_template_id pay_shadow_element_types.template_id%TYPE;
863: l_base_element_type_id pay_template_core_objects.core_object_id%TYPE;
864: l_source_template_id pay_element_templates.template_id%TYPE;
865: l_object_version_number pay_element_types_f.object_version_number%TYPE;
866:
867: l_proc_step NUMBER(20,10);
868: l_proc_name VARCHAR2(80) :=
883: l_lookup_type fnd_lookup_types_vl.lookup_type%TYPE;
884: l_lookup_meaning fnd_lookup_types_vl.meaning%TYPE;
885: l_exists VARCHAR2(1);
886: l_display_sequence NUMBER;
887: l_base_name pay_element_templates.base_name%TYPE
888: := UPPER(TRANSLATE(TRIM(p_abs_ele_name),' ','_'));
889:
890: l_exc_sec_days_bf VARCHAR2(1);
891:
889:
890: l_exc_sec_days_bf VARCHAR2(1);
891:
892: l_days_hours VARCHAR2(10) ;
893: l_template_name pay_element_templates.template_name%TYPE ;
894: l_configuration_information2 pay_element_templates.configuration_information2%TYPE;
895:
896: l_ele_name t_ele_name;
897: l_ele_new_name t_ele_name;
890: l_exc_sec_days_bf VARCHAR2(1);
891:
892: l_days_hours VARCHAR2(10) ;
893: l_template_name pay_element_templates.template_name%TYPE ;
894: l_configuration_information2 pay_element_templates.configuration_information2%TYPE;
895:
896: l_ele_name t_ele_name;
897: l_ele_new_name t_ele_name;
898: l_main_ele_name t_ele_name;
1581: IS
1582: SELECT DISTINCT(pete.eei_information18) lookup_type
1583: FROM pay_element_type_extra_info pete
1584: ,pay_element_types_f petf
1585: -- ,pay_element_templates pet
1586: WHERE pete.element_type_id = petf.element_type_id
1587: AND pete.information_type = 'PQP_GB_OSP_ABSENCE_PLAN_INFO'
1588: AND pete.eei_information16 = 'Y'
1589: AND petf.element_name = c_base_name || ' Unpaid Absence'
1591: ;
1592:
1593: CURSOR csr_template_names IS
1594: SELECT pet.base_name
1595: FROM pay_element_templates pet
1596: WHERE pet.template_name = p_template_name
1597: AND pet.template_type = 'U'
1598: AND pet.business_group_id = p_business_group_id ;
1599:
1611: l_lookup_code fnd_lookup_values_vl.lookup_code%TYPE;
1612: l_lookup_type fnd_lookup_types_vl.lookup_type%TYPE;
1613: l_proc_step NUMBER(20,10);
1614: l_proc_name VARCHAR2(72) := g_package_name || 'get_other_lookups';
1615: l_base_name pay_element_templates.base_name%TYPE ;
1616:
1617: --
1618: BEGIN
1619:
1966:
1967: l_entitlements_uom VARCHAR2(1) ;
1968: l_daily_rate_uom pay_element_type_extra_info.eei_information13%TYPE ;
1969: l_days_hours VARCHAR2(10) ;
1970: l_template_name pay_element_templates.template_name%TYPE ;
1971:
1972:
1973: CURSOR csr_get_scheme_type(p_ele_type_id IN NUMBER) IS
1974: SELECT pee.eei_information8 entitlements_uom
2029: CURSOR csr_chk_sec_ele (c_te_usrstr_id NUMBER
2030: ,p_template_name VARCHAR2
2031: ) IS
2032: SELECT 'X'
2033: FROM pay_element_templates pets
2034: ,pay_shadow_element_types pset
2035: ,pay_template_core_objects ptco
2036: ,pay_element_type_extra_info peei
2037: WHERE pets.template_id <> c_te_usrstr_id
2050: -- find the eei info
2051:
2052: CURSOR csr_get_template_id (p_template_name IN VARCHAR2) is
2053: SELECT template_id
2054: FROM pay_element_templates
2055: WHERE base_name = p_abs_ele_name
2056: AND template_name = p_template_name --'PQP OSP'
2057: AND business_group_id = p_business_group_id
2058: AND template_type = 'U';