[Home] [Help]
33: -- {Start Of Comments}
34: --
35: -- Description:
36: -- This function returns a new element name if an entry is present in
37: -- pqp_configuration_values table. Otherwise this function returns the
38: -- same element name as passed to it as input parameter.
39: -- Prerequisites:
40: -- None.
41: --
67: p_pay_basis VARCHAR2) IS
68: SELECT ghr_general.return_NUMBER(pcv.pcv_information2) element_type_id,
69: pcv.pcv_information1 element_old_name,
70: NVL(pcv.pcv_information3,'NULL') pay_basis
71: FROM pqp_configuration_values pcv
72: WHERE pcv.pcv_information_category = 'PQP_FEDHR_ELEMENT'
73: AND pcv.business_group_id = p_business_group_id
74: AND NVL(pcv_information3,'NULL') = NVL(p_pay_basis,'NULL')
75: -- picking Ele name based on Sal Basis esp BSR
99: BEGIN
100: hr_utility.set_location('Entering ' || g_package_name || l_proc_name, 10);
101:
102: -- is_script_run function will return TRUE, if GHR and Payroll were already
103: -- installed. Because this is the only way pqp_configuration_values table
104: -- will have any row of cv_information_category = 'PQP_FEDHR_ELEMENT'
105: -- We are checking for only one element(Federal Awards) and not for all
106: -- the elements for the performance reasons. We assume that if one element is
107: -- present then all the elements will be automatically present.
232: -- {Start Of Comments}
233: --
234: -- Description:
235: -- This function returns a new element name if an entry is present in
236: -- pqp_configuration_values table. Otherwise this function returns the
237: -- same element name as passed to it as input parameter.
238: -- Prerequisites:
239: -- None.
240: --
313: -- {Start Of Comments}
314: --
315: -- Description:
316: -- This function returns a new element name if an entry is present in
317: -- pqp_configuration_values table. Otherwise this function returns the
318: -- same element name as passed to it as input parameter.
319: -- Prerequisites:
320: -- None.
321: --
411: -- ----------------------------------------------------------------------------
412: -- {Start Of Comments}
413: --
414: -- Description:
415: -- This function return a TRUE if rows are present in pqp_configuration_values
416: -- table. Otherwise this function returns false.
417: -- Prerequisites:
418: -- None.
419: --
440:
441: CURSOR chk_pqp_config_tab
442: IS
443: SELECT pcv_information_category
444: FROM pqp_configuration_values
445: WHERE pcv_information_category = 'PQP_FEDHR_ELEMENT'
446: AND business_group_id = p_business_group_id
447: AND pcv_information1 = p_fedhr_element_name
448: AND ROWNUM < 2;
446: AND business_group_id = p_business_group_id
447: AND pcv_information1 = p_fedhr_element_name
448: AND ROWNUM < 2;
449:
450: l_info_category pqp_configuration_values.pcv_information_category%TYPE;
451: l_proc_name VARCHAR2(50) := 'is_script_run';
452:
453: BEGIN
454: hr_utility.set_location ('Entering ' || g_package_name || l_proc_name, 10);
452:
453: BEGIN
454: hr_utility.set_location ('Entering ' || g_package_name || l_proc_name, 10);
455:
456: -- The following loop gets the count of rows present in pqp_configuration_values
457: -- table.
458: l_info_category := NULL;
459: FOR c_pqp_config IN chk_pqp_config_tab
460: LOOP
461: l_info_category := c_pqp_config.pcv_information_category;
462: hr_utility.trace('In cursor loop');
463: END LOOP;
464:
465: -- If count > 0, that means some rows were present in pqp_configuration_Values
466: -- table. Therefore this function returns TRUE.
467:
468: IF l_info_category IS NOT NULL
469: THEN
611: CURSOR cur_pb_to_sb
612: IS
613: SELECT pcv_information1 pb,
614: pcv_information2 sb
615: FROM pqp_configuration_values pcv
616: WHERE pcv_information_category='PQP_PAY_SALARY_BASIS_MAPPING';
617:
618: l_index NUMBER:=0;
619:
647: -- {Start Of Comments}
648: --
649: -- Description:
650: -- This function returns a federal element name if an entry is present in
651: -- pqp_configuration_values table. Otherwise this function returns the
652: -- same element name as passed to it as input parameter.
653: -- Prerequisites:
654: -- None.
655: --
689: CURSOR chk_pqp_config_tab(p_business_group_id per_business_groups.business_group_id%TYPE) IS
690: SELECT ghr_general.return_NUMBER(pcv.pcv_information2) element_type_id,
691: pcv.pcv_information1 element_old_name,
692: NVL(pcv.pcv_information3,'NULL') pay_basis
693: FROM pqp_configuration_values pcv
694: WHERE pcv.pcv_information_category = 'PQP_FEDHR_ELEMENT'
695: AND pcv.business_group_id = p_business_group_id
696: AND ghr_general.return_number(pcv.pcv_information2) = l_element_type_id
697: ORDER BY pcv.pcv_information1;
726: l_element_type_id := chk_element_type_rec.element_type_id;
727: END LOOP;
728:
729: -- is_script_run function will return TRUE, if GHR and Payroll were already
730: -- installed. Because this is the only way pqp_configuration_values table
731: -- will have any row of cv_information_category = 'PQP_FEDHR_ELEMENT'
732: -- We are checking for only one element(Federal Awards) and not for all
733: -- the elements for the performance reasons. We assume that if one element is
734: -- present then all the elements will be automatically present.