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.IEX_STRATEGY_WF dependencies on JTF_RS_RESOURCE_EXTNS

Line 291: from jtf_rs_resource_extns

287:
288: cursor c_getname(p_resource_id NUMBER) is
289: --Select user_name -- bug 6717880/7170165 by Ehuh
290: Select user_name,source_name -- bug 6717880/7170165 by Ehuh
291: from jtf_rs_resource_extns
292: where resource_id =p_resource_id;
293:
294: BEGIN
295: -- IF PG_DEBUG < 10 THEN

Line 322: FROM JTF_RS_RESOURCE_EXTNS a

318: l_mgr_id number;
319:
320: CURSOR c_manager(p_resource_id NUMBER) IS
321: SELECT b.user_id, b.user_name , b.resource_id
322: FROM JTF_RS_RESOURCE_EXTNS a
323: , JTF_RS_RESOURCE_EXTNS b
324: WHERE b.source_id = a.source_mgr_id
325: AND a.resource_id = p_resource_id;
326:

Line 323: , JTF_RS_RESOURCE_EXTNS b

319:
320: CURSOR c_manager(p_resource_id NUMBER) IS
321: SELECT b.user_id, b.user_name , b.resource_id
322: FROM JTF_RS_RESOURCE_EXTNS a
323: , JTF_RS_RESOURCE_EXTNS b
324: WHERE b.source_id = a.source_mgr_id
325: AND a.resource_id = p_resource_id;
326:
327: --Start bug 6717880/7170165 by Ehuh

Line 329: select source_name from JTF_RS_RESOURCE_EXTNS

325: AND a.resource_id = p_resource_id;
326:
327: --Start bug 6717880/7170165 by Ehuh
328: Cursor c_get_assignee(p_resource_id number) is
329: select source_name from JTF_RS_RESOURCE_EXTNS
330: where resource_id = p_resource_id;
331: l_source_name varchar2(50);
332: --End bug 6717880/7170165 by Ehuh
333:

Line 340: -- get user name from jtf_rs_resource_extns

336: -- IF PG_DEBUG < 10 THEN
337: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
338: iex_debug_pub.logmessage ('**** BEGIN set_notification_resources ************');
339: END IF;
340: -- get user name from jtf_rs_resource_extns
341: --Start bug 6717880/7170165 by Ehuh
342: --get_username
343: -- ( p_resource_id =>p_resource_id,
344: -- x_username =>l_username);

Line 360: -- get mgr name from jtf_rs_resource_extns

356: itemkey => itemkey,
357: aname => 'NOTIFICATION_USERNAME',
358: avalue => l_username);
359:
360: -- get mgr name from jtf_rs_resource_extns
361: -- haveto get the mgr resource id
362: -- for the time being assign mgr =resource_id
363: BEGIN
364: open c_manager(p_resource_id);