273:
274: /* Procedure to validate resource role. */
275:
276: PROCEDURE validate_resource_role
277: (p_role_id IN JTF_RS_ROLES_B.ROLE_ID%TYPE,
278: p_role_code IN JTF_RS_ROLES_B.ROLE_CODE%TYPE,
279: x_return_status OUT NOCOPY VARCHAR2,
280: x_role_id OUT NOCOPY JTF_RS_ROLES_B.ROLE_ID%TYPE
281: );
274: /* Procedure to validate resource role. */
275:
276: PROCEDURE validate_resource_role
277: (p_role_id IN JTF_RS_ROLES_B.ROLE_ID%TYPE,
278: p_role_code IN JTF_RS_ROLES_B.ROLE_CODE%TYPE,
279: x_return_status OUT NOCOPY VARCHAR2,
280: x_role_id OUT NOCOPY JTF_RS_ROLES_B.ROLE_ID%TYPE
281: );
282:
276: PROCEDURE validate_resource_role
277: (p_role_id IN JTF_RS_ROLES_B.ROLE_ID%TYPE,
278: p_role_code IN JTF_RS_ROLES_B.ROLE_CODE%TYPE,
279: x_return_status OUT NOCOPY VARCHAR2,
280: x_role_id OUT NOCOPY JTF_RS_ROLES_B.ROLE_ID%TYPE
281: );
282:
283: /*Procedure to validate resource role flags. */
284: