2049:
2050: /* Procedure to validate the resource role */
2051:
2052: PROCEDURE validate_resource_role (
2053: p_role_id IN JTF_RS_ROLES_B.ROLE_ID%TYPE,
2054: p_role_code IN JTF_RS_ROLES_B.ROLE_CODE%TYPE,
2055: x_return_status OUT NOCOPY VARCHAR2,
2056: x_role_id OUT NOCOPY JTF_RS_ROLES_B.ROLE_ID%TYPE
2057: )
2050: /* Procedure to validate the resource role */
2051:
2052: PROCEDURE validate_resource_role (
2053: p_role_id IN JTF_RS_ROLES_B.ROLE_ID%TYPE,
2054: p_role_code IN JTF_RS_ROLES_B.ROLE_CODE%TYPE,
2055: x_return_status OUT NOCOPY VARCHAR2,
2056: x_role_id OUT NOCOPY JTF_RS_ROLES_B.ROLE_ID%TYPE
2057: )
2058: IS
2052: PROCEDURE validate_resource_role (
2053: p_role_id IN JTF_RS_ROLES_B.ROLE_ID%TYPE,
2054: p_role_code IN JTF_RS_ROLES_B.ROLE_CODE%TYPE,
2055: x_return_status OUT NOCOPY VARCHAR2,
2056: x_role_id OUT NOCOPY JTF_RS_ROLES_B.ROLE_ID%TYPE
2057: )
2058: IS
2059:
2060: CURSOR c_role_id IS