APPS.HR_LOC_ABSENCE dependencies on HRUSERDT

Line 778: --hruserdt.set_g_effective_date(sysdate);

774: OPEN csr_absence_details(p_absence_attendance_id);
775: FETCH csr_absence_details INTO l_abs_rec;
776: CLOSE csr_absence_details;
777:
778: --hruserdt.set_g_effective_date(sysdate);
779: OPEN csr_legislation_code (l_abs_rec.business_group_id);
780: FETCH csr_legislation_code INTO l_legislation_code;
781: CLOSE csr_legislation_code;
782:

Line 788: hruserdt.set_g_effective_date(sysdate);

784: OPEN csr_get_session_eff_date ;
785: FETCH csr_get_session_eff_date INTO l_dummy_effective_date;
786: CLOSE csr_get_session_eff_date;
787: IF l_dummy_effective_date is NULL THEN
788: hruserdt.set_g_effective_date(sysdate);
789: END IF;
790:
791:
792: BEGIN

Line 794: l_element_name := hruserdt.GET_TABLE_VALUE (l_abs_rec.business_group_id, l_legislation_code ||'_ABSENCE_TYPE_AND_DETAILS',

790:
791:
792: BEGIN
793:
794: l_element_name := hruserdt.GET_TABLE_VALUE (l_abs_rec.business_group_id, l_legislation_code ||'_ABSENCE_TYPE_AND_DETAILS',
795: 'ELEMENT',
796: l_abs_rec.name);
797:
798: hr_utility.set_location('l_element_name: '|| l_element_name, 10);

Line 807: l_element_name := hruserdt.GET_TABLE_VALUE (l_abs_rec.business_group_id, l_legislation_code ||'_ABSENCE_CATEGORY_AND_DETAILS',

803:
804: IF l_element_name IS NULL THEN
805:
806: BEGIN
807: l_element_name := hruserdt.GET_TABLE_VALUE (l_abs_rec.business_group_id, l_legislation_code ||'_ABSENCE_CATEGORY_AND_DETAILS',
808: 'ELEMENT',
809: l_abs_rec.absence_category);
810: EXCEPTION
811: WHEN NO_DATA_FOUND THEN

Line 863: -- hruserdt.set_g_effective_date(sysdate);

859: OPEN csr_absence_details(p_absence_attendance_id);
860: FETCH csr_absence_details INTO l_abs_rec;
861: CLOSE csr_absence_details;
862:
863: -- hruserdt.set_g_effective_date(sysdate);
864:
865: OPEN csr_legislation_code (l_abs_rec.business_group_id);
866: FETCH csr_legislation_code INTO l_legislation_code;
867: CLOSE csr_legislation_code;

Line 870: l_package_name := hruserdt.GET_TABLE_VALUE (l_abs_rec.business_group_id, l_legislation_code|| '_ABSENCE_TYPE_AND_DETAILS',

866: FETCH csr_legislation_code INTO l_legislation_code;
867: CLOSE csr_legislation_code;
868:
869: BEGIN
870: l_package_name := hruserdt.GET_TABLE_VALUE (l_abs_rec.business_group_id, l_legislation_code|| '_ABSENCE_TYPE_AND_DETAILS',
871: 'ELEMENT_ENTRY_LOGIC',
872: l_abs_rec.name);
873: EXCEPTION
874: WHEN NO_DATA_FOUND THEN

Line 880: l_package_name := hruserdt.GET_TABLE_VALUE (l_abs_rec.business_group_id, l_legislation_code|| '_ABSENCE_CATEGORY_AND_DETAILS',

876: END;
877:
878: IF l_package_name IS NULL THEN
879: BEGIN
880: l_package_name := hruserdt.GET_TABLE_VALUE (l_abs_rec.business_group_id, l_legislation_code|| '_ABSENCE_CATEGORY_AND_DETAILS',
881: 'ELEMENT_ENTRY_LOGIC',
882: l_abs_rec.absence_category);
883: EXCEPTION
884: WHEN NO_DATA_FOUND THEN