395: FUNCTION element_set_rec(
396: p_element_set_name IN VARCHAR2,
397: p_business_group_id IN NUMBER DEFAULT NULL,
398: p_legislation_code IN VARCHAR2 DEFAULT NULL,
399: p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PAY_ELEMENT_SETS%ROWTYPE
400: --------------------------------------------------------------------------------
401: IS
402: l_csr RefCsr;
403: l_rec PAY_ELEMENT_SETS%ROWTYPE;
399: p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PAY_ELEMENT_SETS%ROWTYPE
400: --------------------------------------------------------------------------------
401: IS
402: l_csr RefCsr;
403: l_rec PAY_ELEMENT_SETS%ROWTYPE;
404: BEGIN
405: l_csr := csr_with_bus_leg('PAY_ELEMENT_SETS','ELEMENT_SET_NAME','T',p_element_set_name,p_business_group_id,p_legislation_code);
406: fetch l_csr into l_rec;
407: if not csr_found_and_close(l_csr,p_error_when_not_exist) then
401: IS
402: l_csr RefCsr;
403: l_rec PAY_ELEMENT_SETS%ROWTYPE;
404: BEGIN
405: l_csr := csr_with_bus_leg('PAY_ELEMENT_SETS','ELEMENT_SET_NAME','T',p_element_set_name,p_business_group_id,p_legislation_code);
406: fetch l_csr into l_rec;
407: if not csr_found_and_close(l_csr,p_error_when_not_exist) then
408: l_rec := NULL;
409: end if;