[Home] [Help]
1297: p_bg_id => p_earn(l_index).bg_id,
1298: p_termination_rule => p_earn(l_index).termination_rule);
1299:
1300: --****************************************************************
1301: -- Make an Entry into PQP_CONFIGURATION_VALUES Table once
1302: -- the element is created after calling template wrapper
1303: --****************************************************************
1304: IF ( p_earn(l_index).org_ele_name = 'Basic Salary Rate' )
1305: THEN
1811: -- ---------------------------------------------------------------------------
1812: -- {Start of Comments}
1813: --
1814: -- Description:
1815: -- Checks for the existence of Old Element name under PQP_CONFIGURATION_VALUES
1816: -- 1) If exists then UPDATE the entry in pqp_configuration_values for
1817: -- element_type_id with the new element element_type_id
1818: -- ELSE
1819: -- 2) INSERT a row into pqp_configuration_values table.
1812: -- {Start of Comments}
1813: --
1814: -- Description:
1815: -- Checks for the existence of Old Element name under PQP_CONFIGURATION_VALUES
1816: -- 1) If exists then UPDATE the entry in pqp_configuration_values for
1817: -- element_type_id with the new element element_type_id
1818: -- ELSE
1819: -- 2) INSERT a row into pqp_configuration_values table.
1820: --
1815: -- Checks for the existence of Old Element name under PQP_CONFIGURATION_VALUES
1816: -- 1) If exists then UPDATE the entry in pqp_configuration_values for
1817: -- element_type_id with the new element element_type_id
1818: -- ELSE
1819: -- 2) INSERT a row into pqp_configuration_values table.
1820: --
1821: --
1822: -- Prerequisites:
1823: --
1861: ) IS
1862:
1863: l_proc VARCHAR2(80):='update_or_ins_pqp_config_vals';
1864: ----**********************************************************************
1865: -- Check for old element name under PQP_CONFIGURATION_VALUES
1866: -- Exists if already script is run
1867: ----**********************************************************************
1868:
1869: CURSOR c_ele_exists_pcv(
1872: ) IS
1873: SELECT pcv_information2 ele_type_id,
1874: configuration_value_id confg_val_id,
1875: object_version_number ovn
1876: FROM pqp_configuration_values
1877: WHERE pcv_information1 = p_old_ele_name
1878: and business_group_id = p_business_group_id
1879: and NVL(pcv_information3,'NULL') = NVL(p_pay_basis,'NULL');
1880:
1919: IS
1920: SELECT pcv_information1 ele_name,
1921: pcv_information2 ele_type_id,
1922: pcv_information3 pay_basis
1923: FROM pqp_configuration_values
1924: WHERE business_group_id=p_business_group_id
1925: AND pcv_information_category='PQP_FEDHR_ELEMENT'
1926: --AND (pcv_information1 <> p_old_ele_name
1927: --OR pcv_information3 <> p_pay_basis)
1958: SELECT configuration_value_id confg_val_id,
1959: object_version_number ovn,
1960: pcv_information1 ele_name,
1961: pcv_information3 pay_basis
1962: FROM pqp_configuration_values
1963: WHERE ghr_general.return_number(pcv_information2) = p_ele_type_id
1964: AND business_group_id = p_business_group_id
1965: AND pcv_information_category='PQP_FEDHR_ELEMENT';
1966:
2255: END LOOP;
2256: END LOOP;
2257:
2258: -- *****************************************************************
2259: -- Check to see if the Element exists under pqp_configuration_values
2260: -- Table and if exists the element type id is updated otherwise, the
2261: -- Element is inserted into pqp_configuration_values table
2262:
2263: -- *****************************************************************
2257:
2258: -- *****************************************************************
2259: -- Check to see if the Element exists under pqp_configuration_values
2260: -- Table and if exists the element type id is updated otherwise, the
2261: -- Element is inserted into pqp_configuration_values table
2262:
2263: -- *****************************************************************
2264:
2265: IF l_old_ele_type_id is not NULL