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

Line 355: l_usertype_status jtf_um_usertype_reg.status_code%TYPE;

351: x_enrollment_reg_id out NOCOPY number) is
352:
353: METHOD_NAME varchar2 (22) := 'ASSIGN_USER_ENROLLMENT';
354: l_wf_item_type jtf_um_subscription_reg.wf_item_type%TYPE;
355: l_usertype_status jtf_um_usertype_reg.status_code%TYPE;
356:
357: cursor get_wf_item_type is
358: select wf_item_type
359: from jtf_um_approvals_b

Line 366: from jtf_um_usertype_reg

362: and nvl (effective_end_date, sysdate + 1) > sysdate;
363:
364: cursor get_user_usertype_status is
365: select status_code
366: from jtf_um_usertype_reg
367: where user_id = p_user_id
368: and effective_start_date <= sysdate
369: and nvl (effective_end_date, sysdate + 1) > sysdate;
370: