APPS.JTF_RS_ROLES_PVT dependencies on JTF_RS_ROLES_TL

Line 27: P_ROLE_NAME IN JTF_RS_ROLES_TL.ROLE_NAME%TYPE,

23: P_INIT_MSG_LIST IN VARCHAR2,
24: P_COMMIT IN VARCHAR2,
25: P_ROLE_TYPE_CODE IN JTF_RS_ROLES_B.ROLE_TYPE_CODE%TYPE,
26: P_ROLE_CODE IN JTF_RS_ROLES_B.ROLE_CODE%TYPE,
27: P_ROLE_NAME IN JTF_RS_ROLES_TL.ROLE_NAME%TYPE,
28: P_ROLE_DESC IN JTF_RS_ROLES_TL.ROLE_DESC%TYPE,
29: P_ACTIVE_FLAG IN JTF_RS_ROLES_B.ACTIVE_FLAG%TYPE,
30: P_SEEDED_FLAG IN JTF_RS_ROLES_B.SEEDED_FLAG%TYPE,
31: P_MEMBER_FLAG IN JTF_RS_ROLES_B.MEMBER_FLAG%TYPE,

Line 28: P_ROLE_DESC IN JTF_RS_ROLES_TL.ROLE_DESC%TYPE,

24: P_COMMIT IN VARCHAR2,
25: P_ROLE_TYPE_CODE IN JTF_RS_ROLES_B.ROLE_TYPE_CODE%TYPE,
26: P_ROLE_CODE IN JTF_RS_ROLES_B.ROLE_CODE%TYPE,
27: P_ROLE_NAME IN JTF_RS_ROLES_TL.ROLE_NAME%TYPE,
28: P_ROLE_DESC IN JTF_RS_ROLES_TL.ROLE_DESC%TYPE,
29: P_ACTIVE_FLAG IN JTF_RS_ROLES_B.ACTIVE_FLAG%TYPE,
30: P_SEEDED_FLAG IN JTF_RS_ROLES_B.SEEDED_FLAG%TYPE,
31: P_MEMBER_FLAG IN JTF_RS_ROLES_B.MEMBER_FLAG%TYPE,
32: P_ADMIN_FLAG IN JTF_RS_ROLES_B.ADMIN_FLAG%TYPE,

Line 617: P_ROLE_NAME IN JTF_RS_ROLES_TL.ROLE_NAME%TYPE,

613: P_COMMIT IN VARCHAR2,
614: P_ROLE_ID IN JTF_RS_ROLES_B.ROLE_ID%TYPE,
615: P_ROLE_CODE IN JTF_RS_ROLES_B.ROLE_CODE%TYPE,
616: P_ROLE_TYPE_CODE IN JTF_RS_ROLES_B.ROLE_TYPE_CODE%TYPE,
617: P_ROLE_NAME IN JTF_RS_ROLES_TL.ROLE_NAME%TYPE,
618: P_ROLE_DESC IN JTF_RS_ROLES_TL.ROLE_DESC%TYPE,
619: P_ACTIVE_FLAG IN JTF_RS_ROLES_B.ACTIVE_FLAG%TYPE,
620: P_SEEDED_FLAG IN JTF_RS_ROLES_B.SEEDED_FLAG%TYPE,
621: P_MEMBER_FLAG IN JTF_RS_ROLES_B.MEMBER_FLAG%TYPE,

Line 618: P_ROLE_DESC IN JTF_RS_ROLES_TL.ROLE_DESC%TYPE,

614: P_ROLE_ID IN JTF_RS_ROLES_B.ROLE_ID%TYPE,
615: P_ROLE_CODE IN JTF_RS_ROLES_B.ROLE_CODE%TYPE,
616: P_ROLE_TYPE_CODE IN JTF_RS_ROLES_B.ROLE_TYPE_CODE%TYPE,
617: P_ROLE_NAME IN JTF_RS_ROLES_TL.ROLE_NAME%TYPE,
618: P_ROLE_DESC IN JTF_RS_ROLES_TL.ROLE_DESC%TYPE,
619: P_ACTIVE_FLAG IN JTF_RS_ROLES_B.ACTIVE_FLAG%TYPE,
620: P_SEEDED_FLAG IN JTF_RS_ROLES_B.SEEDED_FLAG%TYPE,
621: P_MEMBER_FLAG IN JTF_RS_ROLES_B.MEMBER_FLAG%TYPE,
622: P_ADMIN_FLAG IN JTF_RS_ROLES_B.ADMIN_FLAG%TYPE,

Line 1337: role_name jtf_Rs_roles_tl.role_name%type;

1333: return false;
1334: END role_used;
1335:
1336: FUNCTION get_role_name(p_role_id IN NUMBER) return VARCHAR2 IS
1337: role_name jtf_Rs_roles_tl.role_name%type;
1338: cursor c_role_name is
1339: SELECT role_name from jtf_rs_roles_vl
1340: WHERE role_id = p_role_id;
1341: BEGIN