eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JTF_RS_GROUP_DENORM_PVT dependencies on JTF_RS_GROUPS_DENORM

Line 28: p_level JTF_RS_GROUPS_DENORM.DENORM_LEVEL%type,

24: g_child_tab rel_table;
25:
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

Line 29: p_parent_group_id JTF_RS_GROUPS_DENORM.parent_group_id%type,

25:
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

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 31: p_end_date JTF_RS_GROUPS_DENORM.end_date_active%TYPE) RETURN NUMBER

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
35: WHERE A.GROUP_ID = P_GROUP_ID

Line 141: FROM jtf_rs_groups_denorm den

137: CURSOR c_dup(x_group_id JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
138: x_parent_group_id JTF_RS_GROUPS_VL.GROUP_ID%TYPE)
139: IS
140: SELECT den.group_id
141: FROM jtf_rs_groups_denorm den
142: WHERE den.group_id = x_group_id
143: AND den.parent_group_id = x_parent_group_id;
144:
145: /*

Line 171: l_DENORM_GRP_ID JTF_RS_GROUPS_DENORM.DENORM_GRP_ID%TYPE;

167: l_end_date Date;
168:
169: l_start_date_1 Date;
170: l_end_date_1 Date;
171: l_DENORM_GRP_ID JTF_RS_GROUPS_DENORM.DENORM_GRP_ID%TYPE;
172: x_row_id varchar2(24) := null;
173:
174: l_actual_parent_id NUMBER := null;
175:

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 237: jtf_rs_groups_denorm_pkg.insert_row(

233: 0,
234: p_group_id,
235: trunc(l_start_date),
236: trunc(l_end_date));
237: jtf_rs_groups_denorm_pkg.insert_row(
238: X_ROWID => x_row_id,
239: X_DENORM_GRP_ID => l_DENORM_GRP_ID,
240: X_GROUP_ID => p_group_id,
241: X_PARENT_GROUP_ID => p_group_id,

Line 330: l_DENORM_GRP_ID JTF_RS_GROUPS_DENORM.DENORM_GRP_ID%TYPE;

326: l_end_date Date;
327:
328: l_start_date_1 Date;
329: l_end_date_1 Date;
330: l_DENORM_GRP_ID JTF_RS_GROUPS_DENORM.DENORM_GRP_ID%TYPE;
331: x_row_id varchar2(24) := null;
332: l_return_status VARCHAR2(30) := fnd_api.g_ret_sts_success;
333: L_MSG_DATA VARCHAR2(200);
334: L_MSG_COUNT number;

Line 340: FROM jtf_rs_groups_denorm

336:
337: CURSOR denorm_cur(l_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE)
338: IS
339: SELECT denorm_grp_id
340: FROM jtf_rs_groups_denorm
341: WHERE group_id = l_group_id
342: AND parent_group_id = l_group_id;
343:
344: BEGIN

Line 388: jtf_rs_groups_denorm_pkg.delete_row(X_DENORM_GRP_ID => l_DENORM_GRP_ID);

384: FETCH denorm_cur into l_denorm_grp_id;
385:
386: IF (denorm_cur%FOUND)
387: THEN
388: jtf_rs_groups_denorm_pkg.delete_row(X_DENORM_GRP_ID => l_DENORM_GRP_ID);
389:
390: JTF_RS_GROUP_DENORM_PVT.CREATE_RES_GROUPS(
391: P_API_VERSION => 1.0,
392: P_INIT_MSG_LIST => null,

Line 482: FROM jtf_rs_groups_denorm den

478: l_start_date_active date,
479: l_end_date_active date)
480: IS
481: SELECT den.group_id
482: FROM jtf_rs_groups_denorm den
483: WHERE den.group_id = x_group_id
484: AND den.parent_group_id = x_parent_group_id
485: --AND start_date_active = l_start_date_active
486: AND ((l_start_date_active between den.start_date_active and

Line 564: l_DENORM_GRP_ID JTF_RS_GROUPS_DENORM.DENORM_GRP_ID%TYPE;

560: l_end_date_active Date;
561:
562: l_start_date_1 Date;
563: l_end_date_1 Date;
564: l_DENORM_GRP_ID JTF_RS_GROUPS_DENORM.DENORM_GRP_ID%TYPE;
565: x_row_id varchar2(24) := null;
566:
567:
568: l_prev_level number := 0;

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 834: jtf_rs_groups_denorm_pkg.insert_row(

830: p_group_id,
831: trunc(l_start_date_active),
832: trunc(l_end_date_active));
833:
834: jtf_rs_groups_denorm_pkg.insert_row(
835: X_ROWID => x_row_id,
836: X_DENORM_GRP_ID => l_DENORM_GRP_ID,
837: X_GROUP_ID => l_child_tab(i).p_group_id,
838: X_PARENT_GROUP_ID => p_group_id,

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 961: jtf_rs_groups_denorm_pkg.insert_row(

957: r_parents.related_group_id,
958: trunc(l_start_date_1),
959: trunc(l_end_date_1));
960:
961: jtf_rs_groups_denorm_pkg.insert_row(
962: X_ROWID => x_row_id,
963: X_DENORM_GRP_ID => l_DENORM_GRP_ID,
964: X_GROUP_ID => p_group_id,
965: X_PARENT_GROUP_ID => r_parents.related_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 1076: jtf_rs_groups_denorm_pkg.insert_row(

1072: l_child_tab(i).level + r_parents.level,
1073: r_parents.related_group_id,
1074: trunc(l_start_date_active),
1075: trunc(l_end_date_active));
1076: jtf_rs_groups_denorm_pkg.insert_row(
1077: X_ROWID => x_row_id,
1078: X_DENORM_GRP_ID => l_DENORM_GRP_ID,
1079: X_GROUP_ID => l_child_tab(i).p_group_id,
1080: X_PARENT_GROUP_ID => r_parents.related_group_id,

Line 1247: FROM JTF_RS_GROUPS_DENORM

1243: IS
1244: SELECT denorm_grp_id,
1245: group_id,
1246: parent_group_id
1247: FROM JTF_RS_GROUPS_DENORM
1248: WHERE group_id = l_group_id
1249: AND PARENT_GROUP_ID <> L_GROUP_ID;
1250:
1251:

Line 1325: jtf_rs_groups_denorm_pkg.delete_row(r_group_denorm.DENORM_GRP_ID);

1321: THEN
1322: x_return_status := fnd_api.g_ret_sts_error;
1323: RAISE fnd_api.g_exc_error;
1324: END IF;
1325: jtf_rs_groups_denorm_pkg.delete_row(r_group_denorm.DENORM_GRP_ID);
1326: end loop;
1327:
1328:
1329:

Line 1350: jtf_rs_groups_denorm_pkg.delete_row(r_group_denorm.DENORM_GRP_ID);

1346: x_return_status := fnd_api.g_ret_sts_error;
1347: RAISE fnd_api.g_exc_error;
1348: END IF;
1349:
1350: jtf_rs_groups_denorm_pkg.delete_row(r_group_denorm.DENORM_GRP_ID);
1351: end loop;
1352: END LOOP;
1353:
1354:

Line 1711: delete jtf_rs_groups_denorm

1707: FOR i IN 1 .. l_child_tab.COUNT
1708: LOOP
1709: --delete group denorm
1710: begin
1711: delete jtf_rs_groups_denorm
1712: where group_id = l_child_tab(i).p_group_id
1713: and parent_group_id = l_parent_tab(j).p_related_group_id;
1714: exception
1715: when others then

Line 1801: /* this has been moved to jtf_rs_groups_denorm.insert_groups_parent

1797: then
1798: close check_parent_cur;
1799: end if;
1800:
1801: /* this has been moved to jtf_rs_groups_denorm.insert_groups_parent
1802: if(l_found)
1803: then
1804: --rebuild the parent rep managers for the parent role relate ids only
1805: FOR k IN 1 .. l_child_rol_rel_tab.COUNT

Line 1911: FROM jtf_rs_groups_denorm den

1907: l_start_date_active date,
1908: l_end_date_active date)
1909: IS
1910: SELECT den.group_id
1911: FROM jtf_rs_groups_denorm den
1912: WHERE den.group_id = x_group_id
1913: AND den.parent_group_id = x_parent_group_id
1914: --AND start_date_active = l_start_date_active
1915: AND ((l_start_date_active between den.start_date_active and

Line 1958: l_DENORM_GRP_ID JTF_RS_GROUPS_DENORM.DENORM_GRP_ID%TYPE;

1954: l_end_date_active Date;
1955:
1956: l_start_date_1 Date;
1957: l_end_date_1 Date;
1958: l_DENORM_GRP_ID JTF_RS_GROUPS_DENORM.DENORM_GRP_ID%TYPE;
1959: x_row_id varchar2(24) := null;
1960:
1961: l_actual_parent_id NUMBER := null;
1962:

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 2147: jtf_rs_groups_denorm_pkg.insert_row(

2143: r_parents.related_group_id,
2144: trunc(l_start_date_1),
2145: trunc(l_end_date_1));
2146:
2147: jtf_rs_groups_denorm_pkg.insert_row(
2148: X_ROWID => x_row_id,
2149: X_DENORM_GRP_ID => l_DENORM_GRP_ID,
2150: X_GROUP_ID => p_group_id,
2151: X_PARENT_GROUP_ID => r_parents.related_group_id,

Line 2289: FROM JTF_RS_GROUPS_DENORM

2285: CURSOR c_group_denorm(l_group_id JTF_RS_GROUPS_VL.GROUP_ID%TYPE)
2286: IS
2287: SELECT denorm_grp_id,
2288: parent_group_id
2289: FROM JTF_RS_GROUPS_DENORM
2290: WHERE group_id = l_group_id
2291: AND parent_group_id <> l_group_id; --added this
2292:
2293: CURSOR c_child_denorm(l_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE,

Line 2297: FROM JTF_RS_GROUPS_DENORM

2293: CURSOR c_child_denorm(l_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE,
2294: l_parent_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE )
2295: IS
2296: SELECT denorm_grp_id
2297: FROM JTF_RS_GROUPS_DENORM
2298: WHERE group_id = l_group_id
2299: AND parent_group_id = l_parent_group_id;
2300:
2301:

Line 2444: --jtf_rs_groups_denorm_pkg.delete_row(r_child_denorm.denorm_grp_id);

2440:
2441:
2442:
2443: --removing this and calling this in JTF_RS_REP_MGR_DENORM_PVT.DELETE_GROUP_DENORM
2444: --jtf_rs_groups_denorm_pkg.delete_row(r_child_denorm.denorm_grp_id);
2445: end loop;
2446: end if;
2447: END LOOP;
2448: END IF;

Line 2450: --jtf_rs_groups_denorm_pkg.delete_row(r_group_denorm.denorm_grp_id);

2446: end if;
2447: END LOOP;
2448: END IF;
2449: --removing this and calling this in JTF_RS_REP_MGR_DENORM_PVT.DELETE_GROUP_DENORM
2450: --jtf_rs_groups_denorm_pkg.delete_row(r_group_denorm.denorm_grp_id);
2451:
2452:
2453: end loop;
2454:

Line 2657: FROM jtf_rs_groups_denorm den

2653: l_start_date_active date,
2654: l_end_date_active date)
2655: IS
2656: SELECT den.group_id
2657: FROM jtf_rs_groups_denorm den
2658: WHERE den.group_id = x_group_id
2659: AND den.parent_group_id = x_parent_group_id
2660: --AND start_date_active = l_start_date_active
2661: AND ((l_start_date_active between den.start_date_active and

Line 2694: l_DENORM_GRP_ID JTF_RS_GROUPS_DENORM.DENORM_GRP_ID%TYPE;

2690: l_end_date_active Date;
2691:
2692: l_start_date_1 Date;
2693: l_end_date_1 Date;
2694: l_DENORM_GRP_ID JTF_RS_GROUPS_DENORM.DENORM_GRP_ID%TYPE;
2695: x_row_id varchar2(24) := null;
2696:
2697:
2698: l_prev_level number := 0;

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 2954: jtf_rs_groups_denorm_pkg.insert_row(

2950: p_group_id,
2951: trunc(l_start_date_active),
2952: trunc(l_end_date_active));
2953:
2954: jtf_rs_groups_denorm_pkg.insert_row(
2955: X_ROWID => x_row_id,
2956: X_DENORM_GRP_ID => l_DENORM_GRP_ID,
2957: X_GROUP_ID => l_child_tab(i).p_group_id,
2958: X_PARENT_GROUP_ID => p_group_id,

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 3079: jtf_rs_groups_denorm_pkg.insert_row(

3075: l_parent_tab(j).level,
3076: l_parent_tab(j).p_related_group_id,
3077: trunc(l_start_date_1),
3078: trunc(l_end_date_1));
3079: jtf_rs_groups_denorm_pkg.insert_row(
3080: X_ROWID => x_row_id,
3081: X_DENORM_GRP_ID => l_DENORM_GRP_ID,
3082: X_GROUP_ID => p_group_id,
3083: X_PARENT_GROUP_ID => l_parent_tab(j).p_related_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 3194: jtf_rs_groups_denorm_pkg.insert_row(

3190: l_child_tab(i).level + l_parent_tab(j).level,
3191: l_parent_tab(j).p_related_group_id,
3192: trunc(l_start_date_active),
3193: trunc(l_end_date_active));
3194: jtf_rs_groups_denorm_pkg.insert_row(
3195: X_ROWID => x_row_id,
3196: X_DENORM_GRP_ID => l_DENORM_GRP_ID,
3197: X_GROUP_ID => l_child_tab(i).p_group_id,
3198: X_PARENT_GROUP_ID => l_parent_tab(j).p_related_group_id,

Line 3335: FROM JTF_RS_GROUPS_DENORM

3331: IS
3332: SELECT denorm_grp_id,
3333: group_id,
3334: parent_group_id
3335: FROM JTF_RS_GROUPS_DENORM
3336: WHERE group_id = l_group_id
3337: AND PARENT_GROUP_ID <> L_GROUP_ID;
3338:
3339:

Line 3396: jtf_rs_groups_denorm_pkg.delete_row(r_group_denorm.DENORM_GRP_ID);

3392: THEN
3393: x_return_status := fnd_api.g_ret_sts_error;
3394: RAISE fnd_api.g_exc_error;
3395: END IF;
3396: jtf_rs_groups_denorm_pkg.delete_row(r_group_denorm.DENORM_GRP_ID);
3397: end loop;
3398:
3399:
3400:

Line 3423: jtf_rs_groups_denorm_pkg.delete_row(r_group_denorm.DENORM_GRP_ID);

3419: x_return_status := fnd_api.g_ret_sts_error;
3420: RAISE fnd_api.g_exc_error;
3421: END IF;
3422:
3423: jtf_rs_groups_denorm_pkg.delete_row(r_group_denorm.DENORM_GRP_ID);
3424: end loop;
3425: END LOOP;
3426:
3427:

Line 3699: delete jtf_rs_groups_denorm

3695: FOR i IN 1 .. l_child_tab.COUNT
3696: LOOP
3697: --delete group denorm
3698: begin
3699: delete jtf_rs_groups_denorm
3700: where group_id = l_child_tab(i).p_group_id
3701: and parent_group_id = l_parent_tab(j).p_related_group_id;
3702: exception
3703: when others then

Line 3857: FROM jtf_rs_groups_denorm den

3853: l_start_date_active date,
3854: l_end_date_active date)
3855: IS
3856: SELECT den.group_id
3857: FROM jtf_rs_groups_denorm den
3858: WHERE den.group_id = x_group_id
3859: AND den.parent_group_id = x_parent_group_id
3860: --AND start_date_active = l_start_date_active
3861: AND ((l_start_date_active between den.start_date_active and

Line 3890: l_DENORM_GRP_ID JTF_RS_GROUPS_DENORM.DENORM_GRP_ID%TYPE;

3886: l_end_date_active Date;
3887:
3888: l_start_date_1 Date;
3889: l_end_date_1 Date;
3890: l_DENORM_GRP_ID JTF_RS_GROUPS_DENORM.DENORM_GRP_ID%TYPE;
3891: x_row_id varchar2(24) := null;
3892:
3893: l_child_tab rel_table;
3894: l_parent_tab rel_table;

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,

Line 4077: jtf_rs_groups_denorm_pkg.insert_row(

4073: l_parent_tab(i).p_related_group_id,
4074: trunc(l_start_date_1),
4075: trunc(l_end_date_1));
4076:
4077: jtf_rs_groups_denorm_pkg.insert_row(
4078: X_ROWID => x_row_id,
4079: X_DENORM_GRP_ID => l_DENORM_GRP_ID,
4080: X_GROUP_ID => p_group_id,
4081: X_PARENT_GROUP_ID => l_parent_tab(i).p_related_group_id,