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_PKG

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 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 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 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 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 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 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 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 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 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 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 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 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,