APPS.JTF_RS_ROLE_RELATE_PUB dependencies on JTF_RS_ROLES_B

Line 31: P_ROLE_CODE IN JTF_RS_ROLES_B.ROLE_CODE%TYPE,

27: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
28: P_ROLE_RESOURCE_TYPE IN JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_TYPE%TYPE,
29: P_ROLE_RESOURCE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_ID%TYPE,
30: P_ROLE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_ID%TYPE,
31: P_ROLE_CODE IN JTF_RS_ROLES_B.ROLE_CODE%TYPE,
32: P_START_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE,
33: P_END_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE DEFAULT NULL,
34: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
35: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 46: l_role_code JTF_RS_ROLES_B.ROLE_CODE%TYPE := p_role_code;

42:
43: l_role_resource_type JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_TYPE%TYPE := 'X';
44: l_role_resource_id JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_ID%TYPE := p_role_resource_id;
45: l_role_id JTF_RS_ROLE_RELATIONS.ROLE_ID%TYPE := p_role_id;
46: l_role_code JTF_RS_ROLES_B.ROLE_CODE%TYPE := p_role_code;
47: l_start_date_active JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE := p_start_date_active;
48: l_end_date_active JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE := p_end_date_active;
49:
50: l_role_relate_id JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE;

Line 64: CURSOR role_cur(l_role_id JTF_RS_ROLES_B.ROLE_ID%TYPE,

60: AND b.object_code = a.object_code;
61:
62: role_relate_type_rec role_relate_type_cur%rowtype;
63:
64: CURSOR role_cur(l_role_id JTF_RS_ROLES_B.ROLE_ID%TYPE,
65: l_role_code JTF_RS_ROLES_B.ROLE_CODE%TYPE)
66: IS
67: select role_id
68: from jtf_rs_roles_b

Line 65: l_role_code JTF_RS_ROLES_B.ROLE_CODE%TYPE)

61:
62: role_relate_type_rec role_relate_type_cur%rowtype;
63:
64: CURSOR role_cur(l_role_id JTF_RS_ROLES_B.ROLE_ID%TYPE,
65: l_role_code JTF_RS_ROLES_B.ROLE_CODE%TYPE)
66: IS
67: select role_id
68: from jtf_rs_roles_b
69: where (role_id = l_role_id )

Line 68: from jtf_rs_roles_b

64: CURSOR role_cur(l_role_id JTF_RS_ROLES_B.ROLE_ID%TYPE,
65: l_role_code JTF_RS_ROLES_B.ROLE_CODE%TYPE)
66: IS
67: select role_id
68: from jtf_rs_roles_b
69: where (role_id = l_role_id )
70: OR (role_code = l_role_code );
71:
72: role_rec role_cur%rowtype;