APPS.JTF_RS_GROUP_DENORM_PVT dependencies on JTF_RS_GROUPS_DENORM_S

Line 30: p_start_date JTF_RS_GROUPS_DENORM.start_date_active%TYPE,

26:
27: FUNCTION getDirectParent(p_group_id JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
28: p_level JTF_RS_GROUPS_DENORM.DENORM_LEVEL%type,
29: p_parent_group_id JTF_RS_GROUPS_DENORM.parent_group_id%type,
30: p_start_date JTF_RS_GROUPS_DENORM.start_date_active%TYPE,
31: p_end_date JTF_RS_GROUPS_DENORM.end_date_active%TYPE) RETURN NUMBER
32: IS
33: CURSOR prnt_cur IS
34: SELECT A.RELATED_GROUP_ID FROM JTF_RS_GRP_RELATIONS A

Line 228: SELECT jtf_rs_groups_denorm_s.nextval

224: THEN
225:
226: --insert the record for the group with itself as the parent group
227:
228: SELECT jtf_rs_groups_denorm_s.nextval
229: INTO l_DENORM_GRP_ID
230: FROM dual;
231:
232: l_actual_parent_id := getDirectParent(p_group_id,

Line 823: SELECT jtf_rs_groups_denorm_s.nextval

819: FETCH c_dup into dup;
820: IF (c_dup%NOTFOUND)
821: THEN
822:
823: SELECT jtf_rs_groups_denorm_s.nextval
824: INTO l_denorm_grp_id
825: FROM dual;
826:
827:

Line 951: SELECT jtf_rs_groups_denorm_s.nextval

947: FETCH c_dup into dup;
948: IF (c_dup%NOTFOUND)
949: THEN
950:
951: SELECT jtf_rs_groups_denorm_s.nextval
952: INTO l_denorm_grp_id
953: FROM dual;
954:
955: l_actual_parent_id := getDirectParent(p_group_id,

Line 1067: SELECT jtf_rs_groups_denorm_s.nextval

1063: FETCH c_dup into dup;
1064: IF (c_dup%NOTFOUND)
1065: THEN
1066:
1067: SELECT jtf_rs_groups_denorm_s.nextval
1068: INTO l_denorm_grp_id
1069: FROM dual;
1070:
1071: l_actual_parent_id := getDirectParent(l_child_tab(i).p_group_id,

Line 2137: SELECT jtf_rs_groups_denorm_s.nextval

2133: FETCH c_dup into dup;
2134: IF (c_dup%NOTFOUND)
2135: THEN
2136:
2137: SELECT jtf_rs_groups_denorm_s.nextval
2138: INTO l_denorm_grp_id
2139: FROM dual;
2140:
2141: l_actual_parent_id := getDirectParent(p_group_id,

Line 2943: SELECT jtf_rs_groups_denorm_s.nextval

2939: FETCH c_dup into dup;
2940: IF (c_dup%NOTFOUND)
2941: THEN
2942:
2943: SELECT jtf_rs_groups_denorm_s.nextval
2944: INTO l_denorm_grp_id
2945: FROM dual;
2946:
2947:

Line 3070: SELECT jtf_rs_groups_denorm_s.nextval

3066: FETCH c_dup into dup;
3067: IF (c_dup%NOTFOUND)
3068: THEN
3069:
3070: SELECT jtf_rs_groups_denorm_s.nextval
3071: INTO l_denorm_grp_id
3072: FROM dual;
3073:
3074: l_actual_parent_id := getDirectParent(p_group_id,

Line 3185: SELECT jtf_rs_groups_denorm_s.nextval

3181: FETCH c_dup into dup;
3182: IF (c_dup%NOTFOUND)
3183: THEN
3184:
3185: SELECT jtf_rs_groups_denorm_s.nextval
3186: INTO l_denorm_grp_id
3187: FROM dual;
3188:
3189: l_actual_parent_id := getDirectParent(l_child_tab(i).p_group_id,

Line 4067: SELECT jtf_rs_groups_denorm_s.nextval

4063: FETCH c_dup into dup;
4064: IF (c_dup%NOTFOUND)
4065: THEN
4066:
4067: SELECT jtf_rs_groups_denorm_s.nextval
4068: INTO l_denorm_grp_id
4069: FROM dual;
4070:
4071: l_actual_parent_id := getDirectParent(p_group_id,