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.IGS_RE_WORKFLOW dependencies on FND_USER

Line 13: stutta 13-Apr-2005 Replaced all references to FND_USER.customer_id to

9: Change History
10: Who When What
11: DDEY 8-Sep-2003 The changes are done as per the
12: Enrollments Notifications TD Bug # 3052429
13: stutta 13-Apr-2005 Replaced all references to FND_USER.customer_id to
14: FND_USER.person_party_id. Bug #4293911
15: ckasu 17-JAN-2006 Added igs_ge_gen_003.set_org_id(NULL)
16: in enrp_assign_timeslot procedure as a part of bug#4958173.
17: ******************************************************************/

Line 14: FND_USER.person_party_id. Bug #4293911

10: Who When What
11: DDEY 8-Sep-2003 The changes are done as per the
12: Enrollments Notifications TD Bug # 3052429
13: stutta 13-Apr-2005 Replaced all references to FND_USER.customer_id to
14: FND_USER.person_party_id. Bug #4293911
15: ckasu 17-JAN-2006 Added igs_ge_gen_003.set_org_id(NULL)
16: in enrp_assign_timeslot procedure as a part of bug#4958173.
17: ******************************************************************/
18:

Line 666: FROM fnd_user

662: -- cursor to get the user_name corresponding to the person_id
663:
664: CURSOR c_user_name (cp_person_id igs_as_ord_itm_int.person_id%TYPE) IS
665: SELECT user_name
666: FROM fnd_user
667: WHERE person_party_id = cp_person_id
668: AND ( end_date IS NULL OR end_date > SYSDATE );
669:
670: CURSOR c_user_name_admin (cp_person_id fnd_user.user_id%TYPE) IS

Line 670: CURSOR c_user_name_admin (cp_person_id fnd_user.user_id%TYPE) IS

666: FROM fnd_user
667: WHERE person_party_id = cp_person_id
668: AND ( end_date IS NULL OR end_date > SYSDATE );
669:
670: CURSOR c_user_name_admin (cp_person_id fnd_user.user_id%TYPE) IS
671: SELECT user_name
672: FROM fnd_user
673: WHERE user_id = cp_person_id
674: AND ( end_date IS NULL OR end_date > SYSDATE );

Line 672: FROM fnd_user

668: AND ( end_date IS NULL OR end_date > SYSDATE );
669:
670: CURSOR c_user_name_admin (cp_person_id fnd_user.user_id%TYPE) IS
671: SELECT user_name
672: FROM fnd_user
673: WHERE user_id = cp_person_id
674: AND ( end_date IS NULL OR end_date > SYSDATE );
675:
676: l_user_name fnd_user.user_name%TYPE;

Line 676: l_user_name fnd_user.user_name%TYPE;

672: FROM fnd_user
673: WHERE user_id = cp_person_id
674: AND ( end_date IS NULL OR end_date > SYSDATE );
675:
676: l_user_name fnd_user.user_name%TYPE;
677: l_user_name_admin fnd_user.user_name%TYPE;
678:
679: CURSOR c_dup_user (cp_user_name VARCHAR2,
680: cp_role_name VARCHAR2) IS

Line 677: l_user_name_admin fnd_user.user_name%TYPE;

673: WHERE user_id = cp_person_id
674: AND ( end_date IS NULL OR end_date > SYSDATE );
675:
676: l_user_name fnd_user.user_name%TYPE;
677: l_user_name_admin fnd_user.user_name%TYPE;
678:
679: CURSOR c_dup_user (cp_user_name VARCHAR2,
680: cp_role_name VARCHAR2) IS
681: SELECT count(1)

Line 822: FROM fnd_user

818: -- cursor to get the user_name corresponding to the person_id
819:
820: CURSOR c_user_name (cp_person_id igs_as_ord_itm_int.person_id%TYPE) IS
821: SELECT user_name
822: FROM fnd_user
823: WHERE person_party_id = cp_person_id
824: AND ( end_date IS NULL OR end_date > SYSDATE );
825:
826:

Line 827: CURSOR c_user_name_admin (cp_person_id fnd_user.user_id%TYPE) IS

823: WHERE person_party_id = cp_person_id
824: AND ( end_date IS NULL OR end_date > SYSDATE );
825:
826:
827: CURSOR c_user_name_admin (cp_person_id fnd_user.user_id%TYPE) IS
828: SELECT user_name
829: FROM fnd_user
830: WHERE user_id = cp_person_id
831: AND ( end_date IS NULL OR end_date > SYSDATE );

Line 829: FROM fnd_user

825:
826:
827: CURSOR c_user_name_admin (cp_person_id fnd_user.user_id%TYPE) IS
828: SELECT user_name
829: FROM fnd_user
830: WHERE user_id = cp_person_id
831: AND ( end_date IS NULL OR end_date > SYSDATE );
832:
833:

Line 834: l_user_name fnd_user.user_name%TYPE;

830: WHERE user_id = cp_person_id
831: AND ( end_date IS NULL OR end_date > SYSDATE );
832:
833:
834: l_user_name fnd_user.user_name%TYPE;
835: l_user_name_admin fnd_user.user_name%TYPE;
836:
837: CURSOR c_dup_user (cp_user_name VARCHAR2,
838: cp_role_name VARCHAR2) IS

Line 835: l_user_name_admin fnd_user.user_name%TYPE;

831: AND ( end_date IS NULL OR end_date > SYSDATE );
832:
833:
834: l_user_name fnd_user.user_name%TYPE;
835: l_user_name_admin fnd_user.user_name%TYPE;
836:
837: CURSOR c_dup_user (cp_user_name VARCHAR2,
838: cp_role_name VARCHAR2) IS
839: SELECT count(1)

Line 1017: FROM fnd_user

1013: -- cursor to get the user_name corresponding to the person_id
1014:
1015: CURSOR c_user_name (cp_person_id igs_as_ord_itm_int.person_id%TYPE) IS
1016: SELECT user_name
1017: FROM fnd_user
1018: WHERE person_party_id = cp_person_id
1019: AND ( end_date IS NULL OR end_date > SYSDATE );
1020:
1021:

Line 1022: CURSOR c_user_name_admin (cp_person_id fnd_user.user_id%TYPE) IS

1018: WHERE person_party_id = cp_person_id
1019: AND ( end_date IS NULL OR end_date > SYSDATE );
1020:
1021:
1022: CURSOR c_user_name_admin (cp_person_id fnd_user.user_id%TYPE) IS
1023: SELECT user_name
1024: FROM fnd_user
1025: WHERE user_id = cp_person_id
1026: AND ( end_date IS NULL OR end_date > SYSDATE );

Line 1024: FROM fnd_user

1020:
1021:
1022: CURSOR c_user_name_admin (cp_person_id fnd_user.user_id%TYPE) IS
1023: SELECT user_name
1024: FROM fnd_user
1025: WHERE user_id = cp_person_id
1026: AND ( end_date IS NULL OR end_date > SYSDATE );
1027:
1028:

Line 1029: l_user_name_stu fnd_user.user_name%TYPE;

1025: WHERE user_id = cp_person_id
1026: AND ( end_date IS NULL OR end_date > SYSDATE );
1027:
1028:
1029: l_user_name_stu fnd_user.user_name%TYPE;
1030: l_user_name_adm fnd_user.user_name%TYPE;
1031: l_user_name_sup fnd_user.user_name%TYPE;
1032:
1033: CURSOR c_dup_user (cp_user_name VARCHAR2,

Line 1030: l_user_name_adm fnd_user.user_name%TYPE;

1026: AND ( end_date IS NULL OR end_date > SYSDATE );
1027:
1028:
1029: l_user_name_stu fnd_user.user_name%TYPE;
1030: l_user_name_adm fnd_user.user_name%TYPE;
1031: l_user_name_sup fnd_user.user_name%TYPE;
1032:
1033: CURSOR c_dup_user (cp_user_name VARCHAR2,
1034: cp_role_name VARCHAR2) IS

Line 1031: l_user_name_sup fnd_user.user_name%TYPE;

1027:
1028:
1029: l_user_name_stu fnd_user.user_name%TYPE;
1030: l_user_name_adm fnd_user.user_name%TYPE;
1031: l_user_name_sup fnd_user.user_name%TYPE;
1032:
1033: CURSOR c_dup_user (cp_user_name VARCHAR2,
1034: cp_role_name VARCHAR2) IS
1035: SELECT count(1)

Line 1353: FROM fnd_user

1349: -- cursor to get the user_name corresponding to the person_id
1350:
1351: CURSOR c_user_name (cp_person_id igs_as_ord_itm_int.person_id%TYPE) IS
1352: SELECT user_name
1353: FROM fnd_user
1354: WHERE person_party_id = cp_person_id
1355: AND ( end_date IS NULL OR end_date > SYSDATE );
1356:
1357:

Line 1358: CURSOR c_user_name_admin (cp_person_id fnd_user.user_id%TYPE) IS

1354: WHERE person_party_id = cp_person_id
1355: AND ( end_date IS NULL OR end_date > SYSDATE );
1356:
1357:
1358: CURSOR c_user_name_admin (cp_person_id fnd_user.user_id%TYPE) IS
1359: SELECT user_name
1360: FROM fnd_user
1361: WHERE user_id = cp_person_id
1362: AND ( end_date IS NULL OR end_date > SYSDATE );

Line 1360: FROM fnd_user

1356:
1357:
1358: CURSOR c_user_name_admin (cp_person_id fnd_user.user_id%TYPE) IS
1359: SELECT user_name
1360: FROM fnd_user
1361: WHERE user_id = cp_person_id
1362: AND ( end_date IS NULL OR end_date > SYSDATE );
1363:
1364: l_user_name_stu fnd_user.user_name%TYPE;

Line 1364: l_user_name_stu fnd_user.user_name%TYPE;

1360: FROM fnd_user
1361: WHERE user_id = cp_person_id
1362: AND ( end_date IS NULL OR end_date > SYSDATE );
1363:
1364: l_user_name_stu fnd_user.user_name%TYPE;
1365: l_user_name_adm fnd_user.user_name%TYPE;
1366: l_user_name fnd_user.user_name%TYPE;
1367: l_sup_name VARCHAR2(32000);
1368:

Line 1365: l_user_name_adm fnd_user.user_name%TYPE;

1361: WHERE user_id = cp_person_id
1362: AND ( end_date IS NULL OR end_date > SYSDATE );
1363:
1364: l_user_name_stu fnd_user.user_name%TYPE;
1365: l_user_name_adm fnd_user.user_name%TYPE;
1366: l_user_name fnd_user.user_name%TYPE;
1367: l_sup_name VARCHAR2(32000);
1368:
1369: CURSOR c_dup_user (cp_user_name VARCHAR2,

Line 1366: l_user_name fnd_user.user_name%TYPE;

1362: AND ( end_date IS NULL OR end_date > SYSDATE );
1363:
1364: l_user_name_stu fnd_user.user_name%TYPE;
1365: l_user_name_adm fnd_user.user_name%TYPE;
1366: l_user_name fnd_user.user_name%TYPE;
1367: l_sup_name VARCHAR2(32000);
1368:
1369: CURSOR c_dup_user (cp_user_name VARCHAR2,
1370: cp_role_name VARCHAR2) IS

Line 2506: FROM fnd_user

2502: -- cursor to get the user_name corresponding to the person_id
2503:
2504: CURSOR c_user_name (cp_person_id igs_as_ord_itm_int.person_id%TYPE) IS
2505: SELECT user_name
2506: FROM fnd_user
2507: WHERE person_party_id = cp_person_id
2508: AND ( end_date IS NULL OR end_date > SYSDATE );
2509:
2510:

Line 2511: CURSOR c_user_name_admin (cp_person_id fnd_user.user_id%TYPE) IS

2507: WHERE person_party_id = cp_person_id
2508: AND ( end_date IS NULL OR end_date > SYSDATE );
2509:
2510:
2511: CURSOR c_user_name_admin (cp_person_id fnd_user.user_id%TYPE) IS
2512: SELECT user_name
2513: FROM fnd_user
2514: WHERE user_id = cp_person_id
2515: AND ( end_date IS NULL OR end_date > SYSDATE );

Line 2513: FROM fnd_user

2509:
2510:
2511: CURSOR c_user_name_admin (cp_person_id fnd_user.user_id%TYPE) IS
2512: SELECT user_name
2513: FROM fnd_user
2514: WHERE user_id = cp_person_id
2515: AND ( end_date IS NULL OR end_date > SYSDATE );
2516:
2517: l_user_name_stu fnd_user.user_name%TYPE;

Line 2517: l_user_name_stu fnd_user.user_name%TYPE;

2513: FROM fnd_user
2514: WHERE user_id = cp_person_id
2515: AND ( end_date IS NULL OR end_date > SYSDATE );
2516:
2517: l_user_name_stu fnd_user.user_name%TYPE;
2518: l_user_name_adm fnd_user.user_name%TYPE;
2519: l_user_name fnd_user.user_name%TYPE;
2520: l_sup_name VARCHAR2(32000);
2521:

Line 2518: l_user_name_adm fnd_user.user_name%TYPE;

2514: WHERE user_id = cp_person_id
2515: AND ( end_date IS NULL OR end_date > SYSDATE );
2516:
2517: l_user_name_stu fnd_user.user_name%TYPE;
2518: l_user_name_adm fnd_user.user_name%TYPE;
2519: l_user_name fnd_user.user_name%TYPE;
2520: l_sup_name VARCHAR2(32000);
2521:
2522: CURSOR c_dup_user (cp_user_name VARCHAR2,

Line 2519: l_user_name fnd_user.user_name%TYPE;

2515: AND ( end_date IS NULL OR end_date > SYSDATE );
2516:
2517: l_user_name_stu fnd_user.user_name%TYPE;
2518: l_user_name_adm fnd_user.user_name%TYPE;
2519: l_user_name fnd_user.user_name%TYPE;
2520: l_sup_name VARCHAR2(32000);
2521:
2522: CURSOR c_dup_user (cp_user_name VARCHAR2,
2523: cp_role_name VARCHAR2) IS