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 377: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);

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

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

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

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

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

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

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

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

2599: l_pass_commit := fnd_api.g_true;
2600: END IF;
2601:
2602: l_date := sysdate;
2603: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);
2604: l_login_id := NVL(FND_PROFILE.Value('LOGIN_ID'), -1);
2605:
2606: --
2607: --get all the denorm id's for the role relate id and delete the rows from rep manager table

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

2600: END IF;
2601:
2602: l_date := sysdate;
2603: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);
2604: l_login_id := NVL(FND_PROFILE.Value('LOGIN_ID'), -1);
2605:
2606: --
2607: --get all the denorm id's for the role relate id and delete the rows from rep manager table
2608: OPEN denorm_cur(l_role_relate_id);

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

2733: l_pass_commit := fnd_api.g_true;
2734: END IF;
2735:
2736: l_date := sysdate;
2737: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);
2738: l_login_id := NVL(FND_PROFILE.Value('LOGIN_ID'), -1);
2739:
2740: --
2741: --get all the denorm id's for the role relate id and delete the rows from rep manager table

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

2734: END IF;
2735:
2736: l_date := sysdate;
2737: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);
2738: l_login_id := NVL(FND_PROFILE.Value('LOGIN_ID'), -1);
2739:
2740: --
2741: --get all the denorm id's for the role relate id and delete the rows from rep manager table
2742: /* OPEN denorm_cur(l_role_relate_id);

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

2893: FND_MSG_PUB.Initialize;
2894: END IF;
2895:
2896: l_date := sysdate;
2897: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);
2898: l_login_id := NVL(FND_PROFILE.Value('LOGIN_ID'), -1);
2899:
2900: IF fnd_api.to_boolean (p_commit)
2901: THEN

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

2894: END IF;
2895:
2896: l_date := sysdate;
2897: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);
2898: l_login_id := NVL(FND_PROFILE.Value('LOGIN_ID'), -1);
2899:
2900: IF fnd_api.to_boolean (p_commit)
2901: THEN
2902: l_pass_commit := fnd_api.g_true;

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

3198: END IF;
3199:
3200:
3201: l_date := sysdate;
3202: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);
3203: l_login_id := NVL(FND_PROFILE.Value('LOGIN_ID'), -1);
3204:
3205: -- if no group id or person id is passed in then return
3206: IF p_role_relate_id IS NULL

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

3199:
3200:
3201: l_date := sysdate;
3202: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);
3203: l_login_id := NVL(FND_PROFILE.Value('LOGIN_ID'), -1);
3204:
3205: -- if no group id or person id is passed in then return
3206: IF p_role_relate_id IS NULL
3207: THEN

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

3782: END IF;
3783:
3784:
3785: l_date := sysdate;
3786: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);
3787: l_login_id := NVL(FND_PROFILE.Value('LOGIN_ID'), -1);
3788:
3789: IF(p_group_id <> p_parent_group_id)
3790: THEN

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

3783:
3784:
3785: l_date := sysdate;
3786: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);
3787: l_login_id := NVL(FND_PROFILE.Value('LOGIN_ID'), -1);
3788:
3789: IF(p_group_id <> p_parent_group_id)
3790: THEN
3791: --dbms_output.put_line('xxx'||to_char(p_group_id));

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

3919: END IF;
3920:
3921:
3922: l_date := sysdate;
3923: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);
3924: l_login_id := NVL(FND_PROFILE.Value('LOGIN_ID'), -1);
3925:
3926: --get all the child role relate id for this group
3927: OPEN c_child_role_relate_cur(p_group_id);

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

3920:
3921:
3922: l_date := sysdate;
3923: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);
3924: l_login_id := NVL(FND_PROFILE.Value('LOGIN_ID'), -1);
3925:
3926: --get all the child role relate id for this group
3927: OPEN c_child_role_relate_cur(p_group_id);
3928: FETCH c_child_role_relate_cur INTO r_child_role_relate_rec;

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

4201: END IF;
4202:
4203:
4204: l_date := sysdate;
4205: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);
4206: l_login_id := NVL(FND_PROFILE.Value('LOGIN_ID'), -1);
4207:
4208: --
4209: OPEN rel_grp_cur(l_group_relate_id);

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

4202:
4203:
4204: l_date := sysdate;
4205: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);
4206: l_login_id := NVL(FND_PROFILE.Value('LOGIN_ID'), -1);
4207:
4208: --
4209: OPEN rel_grp_cur(l_group_relate_id);
4210: FETCH rel_grp_cur INTO rel_grp_rec;