APPS.HR_JP_ID_PKG dependencies on HR_LOCATIONS_ALL

Line 641: p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN HR_LOCATIONS_ALL%ROWTYPE

637: --------------------------------------------------------------------------------
638: FUNCTION location_rec(
639: p_location_code IN VARCHAR2,
640: p_business_group_id IN NUMBER DEFAULT NULL,
641: p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN HR_LOCATIONS_ALL%ROWTYPE
642: --------------------------------------------------------------------------------
643: IS
644: l_csr RefCsr;
645: l_rec HR_LOCATIONS_ALL%ROWTYPE;

Line 645: l_rec HR_LOCATIONS_ALL%ROWTYPE;

641: p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN HR_LOCATIONS_ALL%ROWTYPE
642: --------------------------------------------------------------------------------
643: IS
644: l_csr RefCsr;
645: l_rec HR_LOCATIONS_ALL%ROWTYPE;
646: BEGIN
647: l_csr := csr_with_bus('HR_LOCATIONS_ALL','LOCATION_CODE','T',p_location_code,p_business_group_id);
648: fetch l_csr into l_rec;
649: if not csr_found_and_close(l_csr,p_error_when_not_exist) then

Line 647: l_csr := csr_with_bus('HR_LOCATIONS_ALL','LOCATION_CODE','T',p_location_code,p_business_group_id);

643: IS
644: l_csr RefCsr;
645: l_rec HR_LOCATIONS_ALL%ROWTYPE;
646: BEGIN
647: l_csr := csr_with_bus('HR_LOCATIONS_ALL','LOCATION_CODE','T',p_location_code,p_business_group_id);
648: fetch l_csr into l_rec;
649: if not csr_found_and_close(l_csr,p_error_when_not_exist) then
650: l_rec := NULL;
651: end if;