576: FUNCTION assignment_status_type_rec(
577: p_user_status IN VARCHAR2,
578: p_business_group_id IN NUMBER DEFAULT NULL,
579: p_legislation_code IN VARCHAR2 DEFAULT NULL,
580: p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PER_ASSIGNMENT_STATUS_TYPES%ROWTYPE
581: --------------------------------------------------------------------------------
582: IS
583: l_csr RefCsr;
584: l_rec PER_ASSIGNMENT_STATUS_TYPES%ROWTYPE;
580: p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PER_ASSIGNMENT_STATUS_TYPES%ROWTYPE
581: --------------------------------------------------------------------------------
582: IS
583: l_csr RefCsr;
584: l_rec PER_ASSIGNMENT_STATUS_TYPES%ROWTYPE;
585: BEGIN
586: l_csr := csr_with_bus_leg('PER_ASSIGNMENT_STATUS_TYPES','USER_STATUS','T',p_user_status,p_business_group_id,p_legislation_code);
587: fetch l_csr into l_rec;
588: if not csr_found_and_close(l_csr,p_error_when_not_exist) then
582: IS
583: l_csr RefCsr;
584: l_rec PER_ASSIGNMENT_STATUS_TYPES%ROWTYPE;
585: BEGIN
586: l_csr := csr_with_bus_leg('PER_ASSIGNMENT_STATUS_TYPES','USER_STATUS','T',p_user_status,p_business_group_id,p_legislation_code);
587: fetch l_csr into l_rec;
588: if not csr_found_and_close(l_csr,p_error_when_not_exist) then
589: l_rec := NULL;
590: end if;