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_UM_USERTYPES_PKG dependencies on JTF_UM_USERTYPE_REG

Line 854: FROM jtf_um_usertype_reg

850: -- If any PENDING records are present no new records
851: -- for this FND User ID is possible
852:
853: SELECT COUNT(*) INTO lcnt
854: FROM jtf_um_usertype_reg
855: WHERE user_id =X_USER_ID and status_code in ( 'PENDING', 'UPGRADE_APPROVAL_PENDING') --- Changes done for Bug 7291138 / bug 6617457
856: AND NVL(effective_end_date, SYSDATE + 1) > SYSDATE;
857:
858: IF lcnt > 0 THEN

Line 864: UPDATE jtf_um_usertype_reg

860: END IF;
861:
862: -- As we allow re-registration (update in bug 4287135 )
863: -- any previous approved entry has to be end dated.
864: UPDATE jtf_um_usertype_reg
865: SET effective_end_date=SYSDATE
866: WHERE user_id =X_USER_ID and status_code in ( 'APPROVED', 'UPGRADE') --- Changes done for Bug 7291138 / bug 6617457
867: AND NVL(effective_end_date, SYSDATE + 1) > SYSDATE;
868:

Line 871: insert into JTF_UM_USERTYPE_REG (

867: AND NVL(effective_end_date, SYSDATE + 1) > SYSDATE;
868:
869: -- End of changes for 4287135
870:
871: insert into JTF_UM_USERTYPE_REG (
872: LAST_APPROVER_COMMENT,
873: APPROVER_USER_ID,
874: EFFECTIVE_END_DATE,
875: WF_ITEM_TYPE,