APPS.CN_COMPGROUPS_PVT dependencies on JTF_RS_GROUPS_B

Line 116: l_group_number jtf_rs_groups_b.group_number%TYPE;

112: l_group_relate_id number := 0;
113: l_relation_type varchar2 (30) := 'PARENT_GROUP';
114: l_object_version_number
115: jtf_rs_grp_relations.object_version_number%TYPE;
116: l_group_number jtf_rs_groups_b.group_number%TYPE;
117: l_parent_group_number jtf_rs_groups_b.group_number%TYPE;
118:
119: BEGIN
120: -- Standard Start of API savepoint

Line 117: l_parent_group_number jtf_rs_groups_b.group_number%TYPE;

113: l_relation_type varchar2 (30) := 'PARENT_GROUP';
114: l_object_version_number
115: jtf_rs_grp_relations.object_version_number%TYPE;
116: l_group_number jtf_rs_groups_b.group_number%TYPE;
117: l_parent_group_number jtf_rs_groups_b.group_number%TYPE;
118:
119: BEGIN
120: -- Standard Start of API savepoint
121: SAVEPOINT Move_Group_PUB;

Line 149: FROM jtf_rs_groups_b

145: AND relation_type = l_relation_type;
146:
147: SELECT group_number
148: INTO l_group_number
149: FROM jtf_rs_groups_b
150: WHERE group_id = p_comp_group_rec.comp_group_id;
151:
152: SELECT group_number
153: INTO l_parent_group_number

Line 154: FROM jtf_rs_groups_b

150: WHERE group_id = p_comp_group_rec.comp_group_id;
151:
152: SELECT group_number
153: INTO l_parent_group_number
154: FROM jtf_rs_groups_b
155: WHERE group_id = p_comp_group_rec.parent_comp_group_id;
156:
157: jtf_rs_group_relate_pub.update_resource_group_relate
158: (p_api_version => p_api_version,