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_REP_MGR_DENORM_PVT dependencies on FND_PROFILE

Line 378: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);

374: END IF;
375:
376:
377: l_date := sysdate;
378: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);
379: l_login_id := NVL(FND_PROFILE.Value('LOGIN_ID'), -1);
380:
381: -- if no group id or person id is passed in then return
382: IF p_role_relate_id IS NULL

Line 379: l_login_id := NVL(FND_PROFILE.Value('LOGIN_ID'), -1);

375:
376:
377: l_date := sysdate;
378: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);
379: l_login_id := NVL(FND_PROFILE.Value('LOGIN_ID'), -1);
380:
381: -- if no group id or person id is passed in then return
382: IF p_role_relate_id IS NULL
383: THEN

Line 1477: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);

1473: END IF;
1474:
1475:
1476: l_date := sysdate;
1477: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);
1478: l_login_id := NVL(FND_PROFILE.Value('LOGIN_ID'), -1);
1479:
1480: -- if no group id or person id is passed in then return
1481: IF p_role_relate_id IS NULL

Line 1478: l_login_id := NVL(FND_PROFILE.Value('LOGIN_ID'), -1);

1474:
1475:
1476: l_date := sysdate;
1477: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);
1478: l_login_id := NVL(FND_PROFILE.Value('LOGIN_ID'), -1);
1479:
1480: -- if no group id or person id is passed in then return
1481: IF p_role_relate_id IS NULL
1482: THEN

Line 2608: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);

2604: l_pass_commit := fnd_api.g_true;
2605: END IF;
2606:
2607: l_date := sysdate;
2608: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);
2609: l_login_id := NVL(FND_PROFILE.Value('LOGIN_ID'), -1);
2610:
2611: --Bug8261683
2612: /* --get all the denorm id's for the role relate id and delete the rows from rep manager table

Line 2609: l_login_id := NVL(FND_PROFILE.Value('LOGIN_ID'), -1);

2605: END IF;
2606:
2607: l_date := sysdate;
2608: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);
2609: l_login_id := NVL(FND_PROFILE.Value('LOGIN_ID'), -1);
2610:
2611: --Bug8261683
2612: /* --get all the denorm id's for the role relate id and delete the rows from rep manager table
2613: OPEN denorm_cur(l_role_relate_id);

Line 2750: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);

2746: l_pass_commit := fnd_api.g_true;
2747: END IF;
2748:
2749: l_date := sysdate;
2750: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);
2751: l_login_id := NVL(FND_PROFILE.Value('LOGIN_ID'), -1);
2752:
2753: --
2754: --get all the denorm id's for the role relate id and delete the rows from rep manager table

Line 2751: l_login_id := NVL(FND_PROFILE.Value('LOGIN_ID'), -1);

2747: END IF;
2748:
2749: l_date := sysdate;
2750: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);
2751: l_login_id := NVL(FND_PROFILE.Value('LOGIN_ID'), -1);
2752:
2753: --
2754: --get all the denorm id's for the role relate id and delete the rows from rep manager table
2755: /* OPEN denorm_cur(l_role_relate_id);

Line 2910: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);

2906: FND_MSG_PUB.Initialize;
2907: END IF;
2908:
2909: l_date := sysdate;
2910: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);
2911: l_login_id := NVL(FND_PROFILE.Value('LOGIN_ID'), -1);
2912:
2913: IF fnd_api.to_boolean (p_commit)
2914: THEN

Line 2911: l_login_id := NVL(FND_PROFILE.Value('LOGIN_ID'), -1);

2907: END IF;
2908:
2909: l_date := sysdate;
2910: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);
2911: l_login_id := NVL(FND_PROFILE.Value('LOGIN_ID'), -1);
2912:
2913: IF fnd_api.to_boolean (p_commit)
2914: THEN
2915: l_pass_commit := fnd_api.g_true;

Line 3215: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);

3211: END IF;
3212:
3213:
3214: l_date := sysdate;
3215: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);
3216: l_login_id := NVL(FND_PROFILE.Value('LOGIN_ID'), -1);
3217:
3218: -- if no group id or person id is passed in then return
3219: IF p_role_relate_id IS NULL

Line 3216: l_login_id := NVL(FND_PROFILE.Value('LOGIN_ID'), -1);

3212:
3213:
3214: l_date := sysdate;
3215: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);
3216: l_login_id := NVL(FND_PROFILE.Value('LOGIN_ID'), -1);
3217:
3218: -- if no group id or person id is passed in then return
3219: IF p_role_relate_id IS NULL
3220: THEN

Line 3799: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);

3795: END IF;
3796:
3797:
3798: l_date := sysdate;
3799: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);
3800: l_login_id := NVL(FND_PROFILE.Value('LOGIN_ID'), -1);
3801:
3802: IF(p_group_id <> p_parent_group_id)
3803: THEN

Line 3800: l_login_id := NVL(FND_PROFILE.Value('LOGIN_ID'), -1);

3796:
3797:
3798: l_date := sysdate;
3799: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);
3800: l_login_id := NVL(FND_PROFILE.Value('LOGIN_ID'), -1);
3801:
3802: IF(p_group_id <> p_parent_group_id)
3803: THEN
3804: --dbms_output.put_line('xxx'||to_char(p_group_id));

Line 3936: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);

3932: END IF;
3933:
3934:
3935: l_date := sysdate;
3936: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);
3937: l_login_id := NVL(FND_PROFILE.Value('LOGIN_ID'), -1);
3938:
3939: --get all the child role relate id for this group
3940: OPEN c_child_role_relate_cur(p_group_id);

Line 3937: l_login_id := NVL(FND_PROFILE.Value('LOGIN_ID'), -1);

3933:
3934:
3935: l_date := sysdate;
3936: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);
3937: l_login_id := NVL(FND_PROFILE.Value('LOGIN_ID'), -1);
3938:
3939: --get all the child role relate id for this group
3940: OPEN c_child_role_relate_cur(p_group_id);
3941: FETCH c_child_role_relate_cur INTO r_child_role_relate_rec;

Line 4218: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);

4214: END IF;
4215:
4216:
4217: l_date := sysdate;
4218: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);
4219: l_login_id := NVL(FND_PROFILE.Value('LOGIN_ID'), -1);
4220:
4221: --
4222: OPEN rel_grp_cur(l_group_relate_id);

Line 4219: l_login_id := NVL(FND_PROFILE.Value('LOGIN_ID'), -1);

4215:
4216:
4217: l_date := sysdate;
4218: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);
4219: l_login_id := NVL(FND_PROFILE.Value('LOGIN_ID'), -1);
4220:
4221: --
4222: OPEN rel_grp_cur(l_group_relate_id);
4223: FETCH rel_grp_cur INTO rel_grp_rec;