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 FND_PROFILE

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

192: FND_MSG_PUB.Initialize;
193: END IF;
194:
195: l_date := sysdate;
196: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);
197: l_login_id := NVL(FND_PROFILE.Value('LOGIN_ID'), -1);
198:
199: -- if no group id is passed in then raise error
200: IF p_group_id IS NULL

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

193: END IF;
194:
195: l_date := sysdate;
196: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);
197: l_login_id := NVL(FND_PROFILE.Value('LOGIN_ID'), -1);
198:
199: -- if no group id is passed in then raise error
200: IF p_group_id IS NULL
201: THEN

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

206: RETURN;
207: END IF;
208:
209: l_date := sysdate;
210: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);
211: l_login_id := NVL(FND_PROFILE.Value('LOGIN_ID'), -1);
212:
213:
214: --fetch the start date and the end date for the group

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

207: END IF;
208:
209: l_date := sysdate;
210: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);
211: l_login_id := NVL(FND_PROFILE.Value('LOGIN_ID'), -1);
212:
213:
214: --fetch the start date and the end date for the group
215: OPEN c_date(p_group_id);

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

360: FND_MSG_PUB.Initialize;
361: END IF;
362:
363: l_date := sysdate;
364: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);
365: l_login_id := NVL(FND_PROFILE.Value('LOGIN_ID'), -1);
366:
367: -- if no group id is passed in then raise error
368: IF p_group_id IS NULL

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

361: END IF;
362:
363: l_date := sysdate;
364: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);
365: l_login_id := NVL(FND_PROFILE.Value('LOGIN_ID'), -1);
366:
367: -- if no group id is passed in then raise error
368: IF p_group_id IS NULL
369: THEN

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

374: RETURN;
375: END IF;
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:
382: -- delete the rescord and create it again in denorm

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

375: END IF;
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:
382: -- delete the rescord and create it again in denorm
383: OPEN denorm_cur(p_group_id);

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

716: FND_MSG_PUB.Initialize;
717: END IF;
718:
719: l_date := sysdate;
720: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);
721: l_login_id := NVL(FND_PROFILE.Value('LOGIN_ID'), -1);
722:
723: -- if no group id is passed in then raise error
724: IF p_group_id IS NULL

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

717: END IF;
718:
719: l_date := sysdate;
720: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);
721: l_login_id := NVL(FND_PROFILE.Value('LOGIN_ID'), -1);
722:
723: -- if no group id is passed in then raise error
724: IF p_group_id IS NULL
725: THEN

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

730: RETURN;
731: END IF;
732:
733: l_date := sysdate;
734: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);
735: l_login_id := NVL(FND_PROFILE.Value('LOGIN_ID'), -1);
736:
737:
738: --fetch the start date and the end date for the group

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

731: END IF;
732:
733: l_date := sysdate;
734: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);
735: l_login_id := NVL(FND_PROFILE.Value('LOGIN_ID'), -1);
736:
737:
738: --fetch the start date and the end date for the group
739: OPEN c_date(p_group_id);

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

1301: FND_MSG_PUB.Initialize;
1302: END IF;
1303:
1304: l_date := sysdate;
1305: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);
1306: l_login_id := NVL(FND_PROFILE.Value('LOGIN_ID'), -1);
1307: --delete the previous hierarchy for the group
1308: for r_group_denorm IN c_group_denorm(p_group_id)
1309: loop

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

1302: END IF;
1303:
1304: l_date := sysdate;
1305: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);
1306: l_login_id := NVL(FND_PROFILE.Value('LOGIN_ID'), -1);
1307: --delete the previous hierarchy for the group
1308: for r_group_denorm IN c_group_denorm(p_group_id)
1309: loop
1310: JTF_RS_REP_MGR_DENORM_PVT.DELETE_REP_MGR (

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

1602: END IF;
1603:
1604:
1605: l_date := sysdate;
1606: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);
1607: --to add the grooup_id as child as this will not be included in cursor
1608: k := 0;
1609: i := i + 1;
1610: l_child_tab(i).p_group_id := p_group_id;

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

2056: FND_MSG_PUB.Initialize;
2057: END IF;
2058:
2059: l_date := sysdate;
2060: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);
2061: l_login_id := NVL(FND_PROFILE.Value('LOGIN_ID'), -1);
2062:
2063: -- if no group id is passed in then raise error
2064: IF p_group_id IS NULL

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

2057: END IF;
2058:
2059: l_date := sysdate;
2060: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);
2061: l_login_id := NVL(FND_PROFILE.Value('LOGIN_ID'), -1);
2062:
2063: -- if no group id is passed in then raise error
2064: IF p_group_id IS NULL
2065: THEN

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

2070: RETURN;
2071: END IF;
2072:
2073: l_date := sysdate;
2074: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);
2075: l_login_id := NVL(FND_PROFILE.Value('LOGIN_ID'), -1);
2076:
2077:
2078: --fetch the start date and the end date for the group

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

2071: END IF;
2072:
2073: l_date := sysdate;
2074: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);
2075: l_login_id := NVL(FND_PROFILE.Value('LOGIN_ID'), -1);
2076:
2077:
2078: --fetch the start date and the end date for the group
2079: OPEN c_date(p_group_id);

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

2368: FND_MSG_PUB.Initialize;
2369: END IF;
2370:
2371: l_date := sysdate;
2372: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);
2373: l_login_id := NVL(FND_PROFILE.Value('LOGIN_ID'), -1);
2374:
2375: --get all the child groups for this group
2376: open c_child(p_group_id);

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

2369: END IF;
2370:
2371: l_date := sysdate;
2372: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);
2373: l_login_id := NVL(FND_PROFILE.Value('LOGIN_ID'), -1);
2374:
2375: --get all the child groups for this group
2376: open c_child(p_group_id);
2377: fetch c_child INTO r_child;

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

2847: FND_MSG_PUB.Initialize;
2848: END IF;
2849:
2850: l_date := sysdate;
2851: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);
2852: l_login_id := NVL(FND_PROFILE.Value('LOGIN_ID'), -1);
2853:
2854: -- if no group id is passed in then raise error
2855: IF p_group_id IS NULL

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

2848: END IF;
2849:
2850: l_date := sysdate;
2851: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);
2852: l_login_id := NVL(FND_PROFILE.Value('LOGIN_ID'), -1);
2853:
2854: -- if no group id is passed in then raise error
2855: IF p_group_id IS NULL
2856: THEN

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

2861: RETURN;
2862: END IF;
2863:
2864: l_date := sysdate;
2865: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);
2866: l_login_id := NVL(FND_PROFILE.Value('LOGIN_ID'), -1);
2867:
2868:
2869: --fetch the start date and the end date for the group

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

2862: END IF;
2863:
2864: l_date := sysdate;
2865: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);
2866: l_login_id := NVL(FND_PROFILE.Value('LOGIN_ID'), -1);
2867:
2868:
2869: --fetch the start date and the end date for the group
2870: OPEN c_date(p_group_id);

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

3372: END IF;
3373:
3374:
3375: l_date := sysdate;
3376: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);
3377: l_login_id := NVL(FND_PROFILE.Value('LOGIN_ID'), -1);
3378: --delete the previous hierarchy for the group
3379: for r_group_denorm IN c_group_denorm(p_group_id)
3380: loop

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

3373:
3374:
3375: l_date := sysdate;
3376: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);
3377: l_login_id := NVL(FND_PROFILE.Value('LOGIN_ID'), -1);
3378: --delete the previous hierarchy for the group
3379: for r_group_denorm IN c_group_denorm(p_group_id)
3380: loop
3381: JTF_RS_REP_MGR_DENORM_PVT.DELETE_REP_MGR (

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

3607: END IF;
3608:
3609:
3610: l_date := sysdate;
3611: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);
3612: --to add the grooup_id as child as this will not be included in cursor
3613: k := 0;
3614: -- get the role relate ids for this group
3615: open rr_cur(p_group_id);

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

3989: FND_MSG_PUB.Initialize;
3990: END IF;
3991:
3992: l_date := sysdate;
3993: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);
3994: l_login_id := NVL(FND_PROFILE.Value('LOGIN_ID'), -1);
3995:
3996: -- if no group id is passed in then raise error
3997: IF p_group_id IS NULL

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

3990: END IF;
3991:
3992: l_date := sysdate;
3993: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);
3994: l_login_id := NVL(FND_PROFILE.Value('LOGIN_ID'), -1);
3995:
3996: -- if no group id is passed in then raise error
3997: IF p_group_id IS NULL
3998: THEN

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

4003: RETURN;
4004: END IF;
4005:
4006: l_date := sysdate;
4007: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);
4008: l_login_id := NVL(FND_PROFILE.Value('LOGIN_ID'), -1);
4009:
4010:
4011: --fetch the start date and the end date for the group

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

4004: END IF;
4005:
4006: l_date := sysdate;
4007: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);
4008: l_login_id := NVL(FND_PROFILE.Value('LOGIN_ID'), -1);
4009:
4010:
4011: --fetch the start date and the end date for the group
4012: OPEN c_date(p_group_id);