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_RESOURCE_PUB dependencies on JTF_OBJECTS_VL

Line 25: cursor c1 is select select_id , from_table , where_clause from jtf_objects_vl

21: passed by calling routines. */
22: Function get_wf_role ( resource_id in number )
23: RETURN varchar2 IS
24:
25: cursor c1 is select select_id , from_table , where_clause from jtf_objects_vl
26: where object_code in ( select object_code from jtf_object_usages
27: where object_user_code = 'RESOURCE_WORKFLOW' ) ;
28:
29: --Adding this cursor to display the resource name in the message (repuri 03/12/01)

Line 72: -- seed data. Currently only 2 rows are seeded in jtf_objects_vl. As a buffer providing

68:
69: -- Fix for Bug 4673722 (21-Oct-2005), changed the resource_id to bind variable (for perf).
70: -- Done after discussion with Hari regarding number of records to be supported. Since this
71: -- method of fetching wf_roles is obsoleted, it will not be enhanced in future regarding
72: -- seed data. Currently only 2 rows are seeded in jtf_objects_vl. As a buffer providing
73: -- extra 3 bind queries.
74: IF (x = 1) THEN
75: EXECUTE IMMEDIATE select_statement INTO wf_rolename USING bind_table(1).bind_value;
76: ELSIF (x = 2) THEN