APPS.JTF_RS_GROUP_RELATE_PUB dependencies on JTF_RS_GROUPS_B

Line 28: P_GROUP_ID IN JTF_RS_GROUPS_B.GROUP_ID%TYPE,

24: PROCEDURE create_resource_group_relate
25: (P_API_VERSION IN NUMBER,
26: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
27: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
28: P_GROUP_ID IN JTF_RS_GROUPS_B.GROUP_ID%TYPE,
29: P_GROUP_NUMBER IN JTF_RS_GROUPS_B.GROUP_NUMBER%TYPE,
30: P_RELATED_GROUP_ID IN JTF_RS_GRP_RELATIONS.RELATED_GROUP_ID%TYPE,
31: P_RELATED_GROUP_NUMBER IN JTF_RS_GROUPS_B.GROUP_NUMBER%TYPE,
32: P_RELATION_TYPE IN JTF_RS_GRP_RELATIONS.RELATION_TYPE%TYPE,

Line 29: P_GROUP_NUMBER IN JTF_RS_GROUPS_B.GROUP_NUMBER%TYPE,

25: (P_API_VERSION IN NUMBER,
26: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
27: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
28: P_GROUP_ID IN JTF_RS_GROUPS_B.GROUP_ID%TYPE,
29: P_GROUP_NUMBER IN JTF_RS_GROUPS_B.GROUP_NUMBER%TYPE,
30: P_RELATED_GROUP_ID IN JTF_RS_GRP_RELATIONS.RELATED_GROUP_ID%TYPE,
31: P_RELATED_GROUP_NUMBER IN JTF_RS_GROUPS_B.GROUP_NUMBER%TYPE,
32: P_RELATION_TYPE IN JTF_RS_GRP_RELATIONS.RELATION_TYPE%TYPE,
33: P_START_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE,

Line 31: P_RELATED_GROUP_NUMBER IN JTF_RS_GROUPS_B.GROUP_NUMBER%TYPE,

27: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
28: P_GROUP_ID IN JTF_RS_GROUPS_B.GROUP_ID%TYPE,
29: P_GROUP_NUMBER IN JTF_RS_GROUPS_B.GROUP_NUMBER%TYPE,
30: P_RELATED_GROUP_ID IN JTF_RS_GRP_RELATIONS.RELATED_GROUP_ID%TYPE,
31: P_RELATED_GROUP_NUMBER IN JTF_RS_GROUPS_B.GROUP_NUMBER%TYPE,
32: P_RELATION_TYPE IN JTF_RS_GRP_RELATIONS.RELATION_TYPE%TYPE,
33: P_START_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE,
34: P_END_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE DEFAULT NULL,
35: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

Line 59: CURSOR grp_cur(l_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE,

55:
56: l_group_id JTF_RS_GROUP_MEMBERS.GROUP_ID%TYPE;
57: l_related_group_id JTF_RS_GROUP_MEMBERS.GROUP_ID%TYPE;
58:
59: CURSOR grp_cur(l_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE,
60: l_group_number JTF_RS_GROUPS_B.GROUP_NUMBER%TYPE)
61: IS
62: SELECT group_id
63: FROM jtf_rs_groups_b

Line 60: l_group_number JTF_RS_GROUPS_B.GROUP_NUMBER%TYPE)

56: l_group_id JTF_RS_GROUP_MEMBERS.GROUP_ID%TYPE;
57: l_related_group_id JTF_RS_GROUP_MEMBERS.GROUP_ID%TYPE;
58:
59: CURSOR grp_cur(l_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE,
60: l_group_number JTF_RS_GROUPS_B.GROUP_NUMBER%TYPE)
61: IS
62: SELECT group_id
63: FROM jtf_rs_groups_b
64: WHERE group_id = l_group_id

Line 63: FROM jtf_rs_groups_b

59: CURSOR grp_cur(l_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE,
60: l_group_number JTF_RS_GROUPS_B.GROUP_NUMBER%TYPE)
61: IS
62: SELECT group_id
63: FROM jtf_rs_groups_b
64: WHERE group_id = l_group_id
65: OR group_number = l_group_number;
66:
67: grp_rec grp_cur%rowtype;