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.

[Home] [Help]

APPS.IGS_RE_WORKFLOW dependencies on IGS_AS_ORD_ITM_INT

Line 664: CURSOR c_user_name (cp_person_id igs_as_ord_itm_int.person_id%TYPE) IS

660: l_person_id VARCHAR2(30);
661:
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 );

Line 820: CURSOR c_user_name (cp_person_id igs_as_ord_itm_int.person_id%TYPE) IS

816: l_delete VARCHAR2(10);
817: l_approved VARCHAR2(10);
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 );

Line 1015: CURSOR c_user_name (cp_person_id igs_as_ord_itm_int.person_id%TYPE) IS

1011: l_person_id VARCHAR2(30);
1012: l_staff_ind VARCHAR2(10);
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 );

Line 1351: CURSOR c_user_name (cp_person_id igs_as_ord_itm_int.person_id%TYPE) IS

1347: l_person_id VARCHAR2(30);
1348:
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 );

Line 2504: CURSOR c_user_name (cp_person_id igs_as_ord_itm_int.person_id%TYPE) IS

2500: l_person_id VARCHAR2(30);
2501:
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 );