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.OKL_AM_ASSET_RETURN_WF dependencies on WF_USERS

Line 175: l_user WF_USERS.NAME%TYPE;

171: p_art_id IN NUMBER) AS
172:
173: l_art_id NUMBER;
174: l_no_data_found BOOLEAN;
175: l_user WF_USERS.NAME%TYPE;
176: l_name WF_USERS.DISPLAY_NAME%TYPE;
177: -- cursor to populate notification attributes
178: --Bug # 6174484 ssdeshpa Fixed for SQL Performance Start
179: CURSOR okl_asset_return_csr(c_art_id NUMBER)

Line 176: l_name WF_USERS.DISPLAY_NAME%TYPE;

172:
173: l_art_id NUMBER;
174: l_no_data_found BOOLEAN;
175: l_user WF_USERS.NAME%TYPE;
176: l_name WF_USERS.DISPLAY_NAME%TYPE;
177: -- cursor to populate notification attributes
178: --Bug # 6174484 ssdeshpa Fixed for SQL Performance Start
179: CURSOR okl_asset_return_csr(c_art_id NUMBER)
180: IS

Line 322: l_user WF_USERS.NAME%TYPE;

318: resultout OUT NOCOPY VARCHAR2 ) AS
319:
320: l_art_id NUMBER;
321: l_no_data_found BOOLEAN;
322: l_user WF_USERS.NAME%TYPE;
323: l_name WF_USERS.DESCRIPTION%TYPE;
324:
325: -- cursor to populate notification attributes
326: CURSOR okl_asset_return_csr(c_art_id NUMBER)

Line 323: l_name WF_USERS.DESCRIPTION%TYPE;

319:
320: l_art_id NUMBER;
321: l_no_data_found BOOLEAN;
322: l_user WF_USERS.NAME%TYPE;
323: l_name WF_USERS.DESCRIPTION%TYPE;
324:
325: -- cursor to populate notification attributes
326: CURSOR okl_asset_return_csr(c_art_id NUMBER)
327: IS

Line 549: l_user WF_USERS.NAME%TYPE;

545: resultout OUT NOCOPY VARCHAR2 ) AS
546:
547: l_art_id NUMBER;
548: l_no_data_found BOOLEAN;
549: l_user WF_USERS.NAME%TYPE;
550:
551: -- cursor to populate notification attributes
552: --Added by cdubey for bug 5253787
553: --Made changes to split the original cursor okl_asset_return_csr into two cursors for performance issue

Line 583: CURSOR wf_users_csr(c_team_id NUMBER)

579:
580: l_asset_return okl_asset_return_csr%rowtype;
581:
582: -- cursor to find valid notification user
583: CURSOR wf_users_csr(c_team_id NUMBER)
584: IS
585: SELECT count(*)
586: FROM jtf_rs_teams_vl t,
587: jtf_rs_role_relations_vl jtfr,

Line 592: wf_users wu

588: jtf_rs_Resource_extns a,
589: jtf_rs_Team_Members b,
590: jtf_rs_Groups_b d,
591: jtf_rs_resource_extns re,
592: wf_users wu
593: WHERE t.team_id = c_team_id
594: AND nvl (t.start_date_active, sysdate - 1) <= sysdate
595: AND nvl (t.end_date_active, sysdate + 1) >= sysdate
596: AND jtfr.role_code = 'REMARKETER'

Line 624: OPEN wf_users_csr(l_asset_return.RMR_ID);

620: CLOSE okl_asset_details_csr;
621: --end cdubey
622:
623:
624: OPEN wf_users_csr(l_asset_return.RMR_ID);
625: FETCH wf_users_csr INTO l_user;
626: CLOSE wf_users_csr;
627:
628: wf_engine.SetItemAttrText ( itemtype=> itemtype,

Line 625: FETCH wf_users_csr INTO l_user;

621: --end cdubey
622:
623:
624: OPEN wf_users_csr(l_asset_return.RMR_ID);
625: FETCH wf_users_csr INTO l_user;
626: CLOSE wf_users_csr;
627:
628: wf_engine.SetItemAttrText ( itemtype=> itemtype,
629: itemkey => itemkey,

Line 626: CLOSE wf_users_csr;

622:
623:
624: OPEN wf_users_csr(l_asset_return.RMR_ID);
625: FETCH wf_users_csr INTO l_user;
626: CLOSE wf_users_csr;
627:
628: wf_engine.SetItemAttrText ( itemtype=> itemtype,
629: itemkey => itemkey,
630: aname => 'TOTAL_RECIPIENTS',

Line 691: IF wf_users_csr%ISOPEN THEN

687: END IF;
688: --end cdubey
689:
690:
691: IF wf_users_csr%ISOPEN THEN
692: CLOSE wf_users_csr;
693: END IF;
694:
695: wf_core.context('OKL_AM_ASSET_RETURN_WF' , 'POP_REMK_NOTIFY_ATT', itemtype, itemkey, actid, funcmode);

Line 692: CLOSE wf_users_csr;

688: --end cdubey
689:
690:
691: IF wf_users_csr%ISOPEN THEN
692: CLOSE wf_users_csr;
693: END IF;
694:
695: wf_core.context('OKL_AM_ASSET_RETURN_WF' , 'POP_REMK_NOTIFY_ATT', itemtype, itemkey, actid, funcmode);
696: RAISE;

Line 721: l_user WF_USERS.NAME%TYPE;

717: l_rmr_id NUMBER;
718: l_total_rec NUMBER;
719: l_current_rec NUMBER := 0;
720: l_no_data_found BOOLEAN;
721: l_user WF_USERS.NAME%TYPE;
722: l_name WF_USERS.DISPLAY_NAME%TYPE;
723: l_current_user WF_USERS.NAME%TYPE;
724:
725: -- cursor to populate notification attributes

Line 722: l_name WF_USERS.DISPLAY_NAME%TYPE;

718: l_total_rec NUMBER;
719: l_current_rec NUMBER := 0;
720: l_no_data_found BOOLEAN;
721: l_user WF_USERS.NAME%TYPE;
722: l_name WF_USERS.DISPLAY_NAME%TYPE;
723: l_current_user WF_USERS.NAME%TYPE;
724:
725: -- cursor to populate notification attributes
726: CURSOR wf_users_csr(c_team_id NUMBER,

Line 723: l_current_user WF_USERS.NAME%TYPE;

719: l_current_rec NUMBER := 0;
720: l_no_data_found BOOLEAN;
721: l_user WF_USERS.NAME%TYPE;
722: l_name WF_USERS.DISPLAY_NAME%TYPE;
723: l_current_user WF_USERS.NAME%TYPE;
724:
725: -- cursor to populate notification attributes
726: CURSOR wf_users_csr(c_team_id NUMBER,
727: c_current_user NUMBER,

Line 726: CURSOR wf_users_csr(c_team_id NUMBER,

722: l_name WF_USERS.DISPLAY_NAME%TYPE;
723: l_current_user WF_USERS.NAME%TYPE;
724:
725: -- cursor to populate notification attributes
726: CURSOR wf_users_csr(c_team_id NUMBER,
727: c_current_user NUMBER,
728: c_name VARCHAR)
729: IS
730: SELECT wu.name, wu.display_name

Line 735: wf_users WU

731: FROM jtf_rs_teams_vl t,
732: jtf_rs_role_relations_vl jtfr,
733: jtf_rs_team_members_vl tm,
734: jtf_rs_resource_extns_vl re,
735: wf_users WU
736: WHERE t.team_id = c_team_id
737: AND nvl (t.start_date_active, sysdate - 1) <= sysdate
738: AND nvl (t.end_date_active, sysdate + 1) >= sysdate
739: AND jtfr.role_code = 'REMARKETER'

Line 758: wf_users WU

754: FROM jtf_rs_teams_vl t,
755: jtf_rs_role_relations_vl jtfr,
756: jtf_rs_team_members_vl tm,
757: jtf_rs_resource_extns_vl re,
758: wf_users WU
759: WHERE t.team_id = c_team_id
760: AND nvl (t.start_date_active, sysdate - 1) <= sysdate
761: AND nvl (t.end_date_active, sysdate + 1) >= sysdate
762: AND jtfr.role_code = 'REMARKETER'

Line 781: wf_users WU

777: FROM jtf_rs_teams_vl t,
778: jtf_rs_role_relations_vl jtfr,
779: jtf_rs_team_members_vl tm,
780: jtf_rs_resource_extns_vl re,
781: wf_users WU
782: WHERE t.team_id = c_team_id
783: AND nvl (t.start_date_active, sysdate - 1) <= sysdate
784: AND nvl (t.end_date_active, sysdate + 1) >= sysdate
785: AND jtfr.role_code = 'REMARKETER'

Line 821: OPEN wf_users_csr(l_rmr_id, l_current_rec, l_current_user);

817: itemkey => itemkey,
818: aname => 'PERFORMING_AGENT');
819:
820:
821: OPEN wf_users_csr(l_rmr_id, l_current_rec, l_current_user);
822: FETCH wf_users_csr INTO l_user, l_name ;
823: CLOSE wf_users_csr;
824:
825: wf_engine.SetItemAttrText ( itemtype=> itemtype,

Line 822: FETCH wf_users_csr INTO l_user, l_name ;

818: aname => 'PERFORMING_AGENT');
819:
820:
821: OPEN wf_users_csr(l_rmr_id, l_current_rec, l_current_user);
822: FETCH wf_users_csr INTO l_user, l_name ;
823: CLOSE wf_users_csr;
824:
825: wf_engine.SetItemAttrText ( itemtype=> itemtype,
826: itemkey => itemkey,

Line 823: CLOSE wf_users_csr;

819:
820:
821: OPEN wf_users_csr(l_rmr_id, l_current_rec, l_current_user);
822: FETCH wf_users_csr INTO l_user, l_name ;
823: CLOSE wf_users_csr;
824:
825: wf_engine.SetItemAttrText ( itemtype=> itemtype,
826: itemkey => itemkey,
827: aname => 'PERFORMING_AGENT',

Line 873: IF wf_users_csr%ISOPEN THEN

869: END IF;
870:
871: EXCEPTION
872: WHEN OTHERS THEN
873: IF wf_users_csr%ISOPEN THEN
874: CLOSE wf_users_csr;
875: END IF;
876:
877: wf_core.context('OKL_AM_ASSET_RETURN_WF' , 'NOTIFY_REMK_USER', itemtype, itemkey, actid, funcmode);

Line 874: CLOSE wf_users_csr;

870:
871: EXCEPTION
872: WHEN OTHERS THEN
873: IF wf_users_csr%ISOPEN THEN
874: CLOSE wf_users_csr;
875: END IF;
876:
877: wf_core.context('OKL_AM_ASSET_RETURN_WF' , 'NOTIFY_REMK_USER', itemtype, itemkey, actid, funcmode);
878: RAISE;

Line 1380: l_user_name WF_USERS.name%type;

1376: AND ist_id IS NOT NULL;
1377:
1378: l_csr_rec okl_check_req_csr%rowtype;
1379:
1380: l_user_name WF_USERS.name%type;
1381: l_name WF_USERS.description%type;
1382:
1383: l_recipient_name varchar2(100);
1384: l_recipient_id number;

Line 1381: l_name WF_USERS.description%type;

1377:
1378: l_csr_rec okl_check_req_csr%rowtype;
1379:
1380: l_user_name WF_USERS.name%type;
1381: l_name WF_USERS.description%type;
1382:
1383: l_recipient_name varchar2(100);
1384: l_recipient_id number;
1385: l_party_object_tbl okl_am_parties_pvt.party_object_tbl_type;

Line 1798: l_user WF_USERS.NAME%TYPE;

1794: resultout OUT NOCOPY VARCHAR2 ) AS
1795:
1796: l_id NUMBER;
1797: l_no_data_found BOOLEAN;
1798: l_user WF_USERS.NAME%TYPE;
1799: l_name WF_USERS.DESCRIPTION%TYPE;
1800: l_message VARCHAR2(30000);
1801:
1802: -- cursor to populate notification attributes

Line 1799: l_name WF_USERS.DESCRIPTION%TYPE;

1795:
1796: l_id NUMBER;
1797: l_no_data_found BOOLEAN;
1798: l_user WF_USERS.NAME%TYPE;
1799: l_name WF_USERS.DESCRIPTION%TYPE;
1800: l_message VARCHAR2(30000);
1801:
1802: -- cursor to populate notification attributes
1803: --Bug # 6174484 ssdeshpa Fixed Cursor for SQL Performance start

Line 1958: -- l_performer WF_USERS.NAME%TYPE;

1954: resultout OUT NOCOPY VARCHAR2) AS
1955:
1956: l_art_id NUMBER;
1957: l_no_data_found BOOLEAN;
1958: -- l_performer WF_USERS.NAME%TYPE;
1959: l_requester WF_USERS.NAME%TYPE;
1960: l_name WF_USERS.DISPLAY_NAME%TYPE;
1961: -- cursor to populate notification attributes
1962:

Line 1959: l_requester WF_USERS.NAME%TYPE;

1955:
1956: l_art_id NUMBER;
1957: l_no_data_found BOOLEAN;
1958: -- l_performer WF_USERS.NAME%TYPE;
1959: l_requester WF_USERS.NAME%TYPE;
1960: l_name WF_USERS.DISPLAY_NAME%TYPE;
1961: -- cursor to populate notification attributes
1962:
1963: CURSOR okl_asset_return_csr(c_art_id NUMBER)

Line 1960: l_name WF_USERS.DISPLAY_NAME%TYPE;

1956: l_art_id NUMBER;
1957: l_no_data_found BOOLEAN;
1958: -- l_performer WF_USERS.NAME%TYPE;
1959: l_requester WF_USERS.NAME%TYPE;
1960: l_name WF_USERS.DISPLAY_NAME%TYPE;
1961: -- cursor to populate notification attributes
1962:
1963: CURSOR okl_asset_return_csr(c_art_id NUMBER)
1964: IS

Line 2144: l_user WF_USERS.NAME%TYPE;

2140: resultout OUT NOCOPY VARCHAR2) IS
2141:
2142: l_id NUMBER;
2143: l_no_data_found BOOLEAN;
2144: l_user WF_USERS.NAME%TYPE;
2145:
2146: l_message VARCHAR2(30000);
2147: -- cursor to populate notification attributes
2148:

Line 2170: l_user_name WF_USERS.name%type;

2166: AND FND.LOOKUP_TYPE = 'OKL_ASSET_TRACK_STRATEGIES'
2167: AND TMB_ID = T.TEAM_ID;
2168:
2169: l_header_done BOOLEAN := FALSE;
2170: l_user_name WF_USERS.name%type;
2171: l_name WF_USERS.description%type;
2172:
2173: BEGIN
2174:

Line 2171: l_name WF_USERS.description%type;

2167: AND TMB_ID = T.TEAM_ID;
2168:
2169: l_header_done BOOLEAN := FALSE;
2170: l_user_name WF_USERS.name%type;
2171: l_name WF_USERS.description%type;
2172:
2173: BEGIN
2174:
2175: IF (funcmode = 'RUN') THEN

Line 2381: l_user WF_USERS.NAME%TYPE;

2377: resultout OUT NOCOPY VARCHAR2) IS
2378:
2379: l_id NUMBER;
2380: l_no_data_found BOOLEAN;
2381: l_user WF_USERS.NAME%TYPE;
2382:
2383: l_message VARCHAR2(30000);
2384: -- cursor to populate notification attributes
2385: CURSOR okl_pfc_csr(c_id NUMBER)

Line 2407: CURSOR wf_users_csr(c_team_id NUMBER)

2403:
2404: l_pfc_rec okl_pfc_csr%rowtype;
2405:
2406: -- cursor to find valid notification user
2407: CURSOR wf_users_csr(c_team_id NUMBER)
2408: IS
2409: SELECT count(1)
2410: FROM jtf_rs_teams_b t,
2411: jtf_rs_role_relations_vl jtfr,

Line 2416: wf_users WU

2412: jtf_rs_Resource_extns a,
2413: jtf_rs_Team_Members b,
2414: jtf_rs_Groups_b d,
2415: jtf_rs_resource_extns re,
2416: wf_users WU
2417: WHERE
2418: t.team_id = c_team_id
2419: AND nvl (t.start_date_active, sysdate - 1) <= sysdate
2420: AND nvl (t.end_date_active, sysdate + 1) >= sysdate

Line 2432: l_user_name WF_USERS.name%type;

2428: AND b.Team_Resource_Id = d.Group_Id (+)
2429: AND re.user_name = wu.name
2430: AND re.source_id = wu.orig_system_id;
2431:
2432: l_user_name WF_USERS.name%type;
2433: l_name WF_USERS.description%type;
2434:
2435: BEGIN
2436:

Line 2433: l_name WF_USERS.description%type;

2429: AND re.user_name = wu.name
2430: AND re.source_id = wu.orig_system_id;
2431:
2432: l_user_name WF_USERS.name%type;
2433: l_name WF_USERS.description%type;
2434:
2435: BEGIN
2436:
2437: IF (funcmode = 'RUN') THEN

Line 2446: OPEN wf_users_csr(l_pfc_rec.TMB_ID);

2442: OPEN okl_pfc_csr(l_id);
2443: FETCH okl_pfc_csr INTO l_pfc_rec;
2444: CLOSE okl_pfc_csr;
2445:
2446: OPEN wf_users_csr(l_pfc_rec.TMB_ID);
2447: FETCH wf_users_csr INTO l_user;
2448: CLOSE wf_users_csr;
2449:
2450: wf_engine.SetItemAttrText ( itemtype=> itemtype,

Line 2447: FETCH wf_users_csr INTO l_user;

2443: FETCH okl_pfc_csr INTO l_pfc_rec;
2444: CLOSE okl_pfc_csr;
2445:
2446: OPEN wf_users_csr(l_pfc_rec.TMB_ID);
2447: FETCH wf_users_csr INTO l_user;
2448: CLOSE wf_users_csr;
2449:
2450: wf_engine.SetItemAttrText ( itemtype=> itemtype,
2451: itemkey => itemkey,

Line 2448: CLOSE wf_users_csr;

2444: CLOSE okl_pfc_csr;
2445:
2446: OPEN wf_users_csr(l_pfc_rec.TMB_ID);
2447: FETCH wf_users_csr INTO l_user;
2448: CLOSE wf_users_csr;
2449:
2450: wf_engine.SetItemAttrText ( itemtype=> itemtype,
2451: itemkey => itemkey,
2452: aname => 'TOTAL_RECIPIENTS',

Line 2528: IF wf_users_csr%ISOPEN THEN

2524: IF okl_pfc_csr%ISOPEN THEN
2525: CLOSE okl_pfc_csr;
2526: END IF;
2527:
2528: IF wf_users_csr%ISOPEN THEN
2529: CLOSE wf_users_csr;
2530: END IF;
2531:
2532: wf_core.context('OKL_AM_ASSET_RETURN_WF' , 'POP_REMK_NOTIFY_ATT', itemtype, itemkey, actid, funcmode);

Line 2529: CLOSE wf_users_csr;

2525: CLOSE okl_pfc_csr;
2526: END IF;
2527:
2528: IF wf_users_csr%ISOPEN THEN
2529: CLOSE wf_users_csr;
2530: END IF;
2531:
2532: wf_core.context('OKL_AM_ASSET_RETURN_WF' , 'POP_REMK_NOTIFY_ATT', itemtype, itemkey, actid, funcmode);
2533: RAISE;

Line 2558: l_user WF_USERS.NAME%TYPE;

2554: l_rmr_id NUMBER;
2555: l_total_rec NUMBER;
2556: l_current_rec NUMBER := 0;
2557: l_no_data_found BOOLEAN;
2558: l_user WF_USERS.NAME%TYPE;
2559: l_name WF_USERS.DISPLAY_NAME%TYPE;
2560: l_current_user WF_USERS.NAME%TYPE;
2561:
2562: -- cursor to populate notification attributes

Line 2559: l_name WF_USERS.DISPLAY_NAME%TYPE;

2555: l_total_rec NUMBER;
2556: l_current_rec NUMBER := 0;
2557: l_no_data_found BOOLEAN;
2558: l_user WF_USERS.NAME%TYPE;
2559: l_name WF_USERS.DISPLAY_NAME%TYPE;
2560: l_current_user WF_USERS.NAME%TYPE;
2561:
2562: -- cursor to populate notification attributes
2563: CURSOR wf_users_csr(c_team_id NUMBER,

Line 2560: l_current_user WF_USERS.NAME%TYPE;

2556: l_current_rec NUMBER := 0;
2557: l_no_data_found BOOLEAN;
2558: l_user WF_USERS.NAME%TYPE;
2559: l_name WF_USERS.DISPLAY_NAME%TYPE;
2560: l_current_user WF_USERS.NAME%TYPE;
2561:
2562: -- cursor to populate notification attributes
2563: CURSOR wf_users_csr(c_team_id NUMBER,
2564: c_current_user NUMBER,

Line 2563: CURSOR wf_users_csr(c_team_id NUMBER,

2559: l_name WF_USERS.DISPLAY_NAME%TYPE;
2560: l_current_user WF_USERS.NAME%TYPE;
2561:
2562: -- cursor to populate notification attributes
2563: CURSOR wf_users_csr(c_team_id NUMBER,
2564: c_current_user NUMBER,
2565: c_name VARCHAR)
2566: IS
2567: SELECT wu.name, wu.display_name

Line 2574: wf_users WU

2570: jtf_rs_Resource_extns a,
2571: jtf_rs_Team_Members b,
2572: jtf_rs_Groups_b d,
2573: jtf_rs_resource_extns re,
2574: wf_users WU
2575: WHERE t.team_id = c_team_id
2576: AND nvl (t.start_date_active, sysdate - 1) <= sysdate
2577: AND nvl (t.end_date_active, sysdate + 1) >= sysdate
2578: AND jtfr.role_code = 'PORTFOLIO_GROUP'

Line 2613: OPEN wf_users_csr(l_rmr_id, l_current_rec, l_current_user);

2609: itemkey => itemkey,
2610: aname => 'PERFORMING_AGENT');
2611:
2612:
2613: OPEN wf_users_csr(l_rmr_id, l_current_rec, l_current_user);
2614: FETCH wf_users_csr INTO l_user, l_name ;
2615: CLOSE wf_users_csr;
2616:
2617: wf_engine.SetItemAttrText ( itemtype=> itemtype,

Line 2614: FETCH wf_users_csr INTO l_user, l_name ;

2610: aname => 'PERFORMING_AGENT');
2611:
2612:
2613: OPEN wf_users_csr(l_rmr_id, l_current_rec, l_current_user);
2614: FETCH wf_users_csr INTO l_user, l_name ;
2615: CLOSE wf_users_csr;
2616:
2617: wf_engine.SetItemAttrText ( itemtype=> itemtype,
2618: itemkey => itemkey,

Line 2615: CLOSE wf_users_csr;

2611:
2612:
2613: OPEN wf_users_csr(l_rmr_id, l_current_rec, l_current_user);
2614: FETCH wf_users_csr INTO l_user, l_name ;
2615: CLOSE wf_users_csr;
2616:
2617: wf_engine.SetItemAttrText ( itemtype=> itemtype,
2618: itemkey => itemkey,
2619: aname => 'PERFORMING_AGENT',

Line 2665: IF wf_users_csr%ISOPEN THEN

2661: END IF;
2662:
2663: EXCEPTION
2664: WHEN OTHERS THEN
2665: IF wf_users_csr%ISOPEN THEN
2666: CLOSE wf_users_csr;
2667: END IF;
2668:
2669: wf_core.context('OKL_AM_ASSET_RETURN_WF' , 'NOTIFY_ASS_GRP_USER', itemtype, itemkey, actid, funcmode);

Line 2666: CLOSE wf_users_csr;

2662:
2663: EXCEPTION
2664: WHEN OTHERS THEN
2665: IF wf_users_csr%ISOPEN THEN
2666: CLOSE wf_users_csr;
2667: END IF;
2668:
2669: wf_core.context('OKL_AM_ASSET_RETURN_WF' , 'NOTIFY_ASS_GRP_USER', itemtype, itemkey, actid, funcmode);
2670: RAISE;