APPS.IEX_STRATEGY_WF dependencies on JTF_RS_RESOURCE_EXTNS

Line 325: from jtf_rs_resource_extns

321:
322: cursor c_getname(p_resource_id NUMBER) is
323: --Select user_name -- bug 6717880/7170165 by Ehuh
324: Select user_name,source_name -- bug 6717880/7170165 by Ehuh
325: from jtf_rs_resource_extns
326: where resource_id =p_resource_id;
327:
328: BEGIN
329: -- IF PG_DEBUG < 10 THEN

Line 356: FROM JTF_RS_RESOURCE_EXTNS a

352: l_mgr_id number;
353:
354: CURSOR c_manager(p_resource_id NUMBER) IS
355: SELECT b.user_id, b.user_name , b.resource_id
356: FROM JTF_RS_RESOURCE_EXTNS a
357: , JTF_RS_RESOURCE_EXTNS b
358: WHERE b.source_id = a.source_mgr_id
359: AND a.resource_id = p_resource_id;
360:

Line 357: , JTF_RS_RESOURCE_EXTNS b

353:
354: CURSOR c_manager(p_resource_id NUMBER) IS
355: SELECT b.user_id, b.user_name , b.resource_id
356: FROM JTF_RS_RESOURCE_EXTNS a
357: , JTF_RS_RESOURCE_EXTNS b
358: WHERE b.source_id = a.source_mgr_id
359: AND a.resource_id = p_resource_id;
360:
361: --Start bug 6717880/7170165 by Ehuh

Line 363: select source_name from JTF_RS_RESOURCE_EXTNS

359: AND a.resource_id = p_resource_id;
360:
361: --Start bug 6717880/7170165 by Ehuh
362: Cursor c_get_assignee(p_resource_id number) is
363: select source_name from JTF_RS_RESOURCE_EXTNS
364: where resource_id = p_resource_id;
365: l_source_name varchar2(50);
366: --End bug 6717880/7170165 by Ehuh
367:

Line 374: -- get user name from jtf_rs_resource_extns

370: -- IF PG_DEBUG < 10 THEN
371: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
372: iex_debug_pub.logmessage ('**** BEGIN set_notification_resources ************');
373: END IF;
374: -- get user name from jtf_rs_resource_extns
375: --Start bug 6717880/7170165 by Ehuh
376: --get_username
377: -- ( p_resource_id =>p_resource_id,
378: -- x_username =>l_username);

Line 394: -- get mgr name from jtf_rs_resource_extns

390: itemkey => itemkey,
391: aname => 'NOTIFICATION_USERNAME',
392: avalue => l_username);
393:
394: -- get mgr name from jtf_rs_resource_extns
395: -- haveto get the mgr resource id
396: -- for the time being assign mgr =resource_id
397: BEGIN
398: open c_manager(p_resource_id);