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 737: wf_users WU

733: jtf_rs_Resource_extns a,
734: jtf_rs_Team_Members b,
735: jtf_rs_Groups_b d,
736: jtf_rs_resource_extns re,
737: wf_users WU
738: WHERE t.team_id = c_team_id
739: AND nvl (t.start_date_active, sysdate - 1) <= sysdate
740: AND nvl (t.end_date_active, sysdate + 1) >= sysdate
741: AND jtfr.role_code = 'REMARKETER'

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

772: itemkey => itemkey,
773: aname => 'PERFORMING_AGENT');
774:
775:
776: OPEN wf_users_csr(l_rmr_id, l_current_rec, l_current_user);
777: FETCH wf_users_csr INTO l_user, l_name ;
778: CLOSE wf_users_csr;
779:
780: wf_engine.SetItemAttrText ( itemtype=> itemtype,

Line 777: FETCH wf_users_csr INTO l_user, l_name ;

773: aname => 'PERFORMING_AGENT');
774:
775:
776: OPEN wf_users_csr(l_rmr_id, l_current_rec, l_current_user);
777: FETCH wf_users_csr INTO l_user, l_name ;
778: CLOSE wf_users_csr;
779:
780: wf_engine.SetItemAttrText ( itemtype=> itemtype,
781: itemkey => itemkey,

Line 778: CLOSE wf_users_csr;

774:
775:
776: OPEN wf_users_csr(l_rmr_id, l_current_rec, l_current_user);
777: FETCH wf_users_csr INTO l_user, l_name ;
778: CLOSE wf_users_csr;
779:
780: wf_engine.SetItemAttrText ( itemtype=> itemtype,
781: itemkey => itemkey,
782: aname => 'PERFORMING_AGENT',

Line 828: IF wf_users_csr%ISOPEN THEN

824: END IF;
825:
826: EXCEPTION
827: WHEN OTHERS THEN
828: IF wf_users_csr%ISOPEN THEN
829: CLOSE wf_users_csr;
830: END IF;
831:
832: wf_core.context('OKL_AM_ASSET_RETURN_WF' , 'NOTIFY_REMK_USER', itemtype, itemkey, actid, funcmode);

Line 829: CLOSE wf_users_csr;

825:
826: EXCEPTION
827: WHEN OTHERS THEN
828: IF wf_users_csr%ISOPEN THEN
829: CLOSE wf_users_csr;
830: END IF;
831:
832: wf_core.context('OKL_AM_ASSET_RETURN_WF' , 'NOTIFY_REMK_USER', itemtype, itemkey, actid, funcmode);
833: RAISE;

Line 1335: l_user_name WF_USERS.name%type;

1331: AND ist_id IS NOT NULL;
1332:
1333: l_csr_rec okl_check_req_csr%rowtype;
1334:
1335: l_user_name WF_USERS.name%type;
1336: l_name WF_USERS.description%type;
1337:
1338: l_recipient_name varchar2(100);
1339: l_recipient_id number;

Line 1336: l_name WF_USERS.description%type;

1332:
1333: l_csr_rec okl_check_req_csr%rowtype;
1334:
1335: l_user_name WF_USERS.name%type;
1336: l_name WF_USERS.description%type;
1337:
1338: l_recipient_name varchar2(100);
1339: l_recipient_id number;
1340: l_party_object_tbl okl_am_parties_pvt.party_object_tbl_type;

Line 1741: l_user WF_USERS.NAME%TYPE;

1737: resultout OUT NOCOPY VARCHAR2 ) AS
1738:
1739: l_id NUMBER;
1740: l_no_data_found BOOLEAN;
1741: l_user WF_USERS.NAME%TYPE;
1742: l_name WF_USERS.DESCRIPTION%TYPE;
1743: l_message VARCHAR2(30000);
1744:
1745: -- cursor to populate notification attributes

Line 1742: l_name WF_USERS.DESCRIPTION%TYPE;

1738:
1739: l_id NUMBER;
1740: l_no_data_found BOOLEAN;
1741: l_user WF_USERS.NAME%TYPE;
1742: l_name WF_USERS.DESCRIPTION%TYPE;
1743: l_message VARCHAR2(30000);
1744:
1745: -- cursor to populate notification attributes
1746: --Bug # 6174484 ssdeshpa Fixed Cursor for SQL Performance start

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

1897: resultout OUT NOCOPY VARCHAR2) AS
1898:
1899: l_art_id NUMBER;
1900: l_no_data_found BOOLEAN;
1901: -- l_performer WF_USERS.NAME%TYPE;
1902: l_requester WF_USERS.NAME%TYPE;
1903: l_name WF_USERS.DISPLAY_NAME%TYPE;
1904: -- cursor to populate notification attributes
1905:

Line 1902: l_requester WF_USERS.NAME%TYPE;

1898:
1899: l_art_id NUMBER;
1900: l_no_data_found BOOLEAN;
1901: -- l_performer WF_USERS.NAME%TYPE;
1902: l_requester WF_USERS.NAME%TYPE;
1903: l_name WF_USERS.DISPLAY_NAME%TYPE;
1904: -- cursor to populate notification attributes
1905:
1906: CURSOR okl_asset_return_csr(c_art_id NUMBER)

Line 1903: l_name WF_USERS.DISPLAY_NAME%TYPE;

1899: l_art_id NUMBER;
1900: l_no_data_found BOOLEAN;
1901: -- l_performer WF_USERS.NAME%TYPE;
1902: l_requester WF_USERS.NAME%TYPE;
1903: l_name WF_USERS.DISPLAY_NAME%TYPE;
1904: -- cursor to populate notification attributes
1905:
1906: CURSOR okl_asset_return_csr(c_art_id NUMBER)
1907: IS

Line 2087: l_user WF_USERS.NAME%TYPE;

2083: resultout OUT NOCOPY VARCHAR2) IS
2084:
2085: l_id NUMBER;
2086: l_no_data_found BOOLEAN;
2087: l_user WF_USERS.NAME%TYPE;
2088:
2089: l_message VARCHAR2(30000);
2090: -- cursor to populate notification attributes
2091:

Line 2113: l_user_name WF_USERS.name%type;

2109: AND FND.LOOKUP_TYPE = 'OKL_ASSET_TRACK_STRATEGIES'
2110: AND TMB_ID = T.TEAM_ID;
2111:
2112: l_header_done BOOLEAN := FALSE;
2113: l_user_name WF_USERS.name%type;
2114: l_name WF_USERS.description%type;
2115:
2116: BEGIN
2117:

Line 2114: l_name WF_USERS.description%type;

2110: AND TMB_ID = T.TEAM_ID;
2111:
2112: l_header_done BOOLEAN := FALSE;
2113: l_user_name WF_USERS.name%type;
2114: l_name WF_USERS.description%type;
2115:
2116: BEGIN
2117:
2118: IF (funcmode = 'RUN') THEN

Line 2324: l_user WF_USERS.NAME%TYPE;

2320: resultout OUT NOCOPY VARCHAR2) IS
2321:
2322: l_id NUMBER;
2323: l_no_data_found BOOLEAN;
2324: l_user WF_USERS.NAME%TYPE;
2325:
2326: l_message VARCHAR2(30000);
2327: -- cursor to populate notification attributes
2328: CURSOR okl_pfc_csr(c_id NUMBER)

Line 2350: CURSOR wf_users_csr(c_team_id NUMBER)

2346:
2347: l_pfc_rec okl_pfc_csr%rowtype;
2348:
2349: -- cursor to find valid notification user
2350: CURSOR wf_users_csr(c_team_id NUMBER)
2351: IS
2352: SELECT count(1)
2353: FROM jtf_rs_teams_b t,
2354: jtf_rs_role_relations_vl jtfr,

Line 2359: wf_users WU

2355: jtf_rs_Resource_extns a,
2356: jtf_rs_Team_Members b,
2357: jtf_rs_Groups_b d,
2358: jtf_rs_resource_extns re,
2359: wf_users WU
2360: WHERE
2361: t.team_id = c_team_id
2362: AND nvl (t.start_date_active, sysdate - 1) <= sysdate
2363: AND nvl (t.end_date_active, sysdate + 1) >= sysdate

Line 2375: l_user_name WF_USERS.name%type;

2371: AND b.Team_Resource_Id = d.Group_Id (+)
2372: AND re.user_name = wu.name
2373: AND re.source_id = wu.orig_system_id;
2374:
2375: l_user_name WF_USERS.name%type;
2376: l_name WF_USERS.description%type;
2377:
2378: BEGIN
2379:

Line 2376: l_name WF_USERS.description%type;

2372: AND re.user_name = wu.name
2373: AND re.source_id = wu.orig_system_id;
2374:
2375: l_user_name WF_USERS.name%type;
2376: l_name WF_USERS.description%type;
2377:
2378: BEGIN
2379:
2380: IF (funcmode = 'RUN') THEN

Line 2389: OPEN wf_users_csr(l_pfc_rec.TMB_ID);

2385: OPEN okl_pfc_csr(l_id);
2386: FETCH okl_pfc_csr INTO l_pfc_rec;
2387: CLOSE okl_pfc_csr;
2388:
2389: OPEN wf_users_csr(l_pfc_rec.TMB_ID);
2390: FETCH wf_users_csr INTO l_user;
2391: CLOSE wf_users_csr;
2392:
2393: wf_engine.SetItemAttrText ( itemtype=> itemtype,

Line 2390: FETCH wf_users_csr INTO l_user;

2386: FETCH okl_pfc_csr INTO l_pfc_rec;
2387: CLOSE okl_pfc_csr;
2388:
2389: OPEN wf_users_csr(l_pfc_rec.TMB_ID);
2390: FETCH wf_users_csr INTO l_user;
2391: CLOSE wf_users_csr;
2392:
2393: wf_engine.SetItemAttrText ( itemtype=> itemtype,
2394: itemkey => itemkey,

Line 2391: CLOSE wf_users_csr;

2387: CLOSE okl_pfc_csr;
2388:
2389: OPEN wf_users_csr(l_pfc_rec.TMB_ID);
2390: FETCH wf_users_csr INTO l_user;
2391: CLOSE wf_users_csr;
2392:
2393: wf_engine.SetItemAttrText ( itemtype=> itemtype,
2394: itemkey => itemkey,
2395: aname => 'TOTAL_RECIPIENTS',

Line 2471: IF wf_users_csr%ISOPEN THEN

2467: IF okl_pfc_csr%ISOPEN THEN
2468: CLOSE okl_pfc_csr;
2469: END IF;
2470:
2471: IF wf_users_csr%ISOPEN THEN
2472: CLOSE wf_users_csr;
2473: END IF;
2474:
2475: wf_core.context('OKL_AM_ASSET_RETURN_WF' , 'POP_REMK_NOTIFY_ATT', itemtype, itemkey, actid, funcmode);

Line 2472: CLOSE wf_users_csr;

2468: CLOSE okl_pfc_csr;
2469: END IF;
2470:
2471: IF wf_users_csr%ISOPEN THEN
2472: CLOSE wf_users_csr;
2473: END IF;
2474:
2475: wf_core.context('OKL_AM_ASSET_RETURN_WF' , 'POP_REMK_NOTIFY_ATT', itemtype, itemkey, actid, funcmode);
2476: RAISE;

Line 2501: l_user WF_USERS.NAME%TYPE;

2497: l_rmr_id NUMBER;
2498: l_total_rec NUMBER;
2499: l_current_rec NUMBER := 0;
2500: l_no_data_found BOOLEAN;
2501: l_user WF_USERS.NAME%TYPE;
2502: l_name WF_USERS.DISPLAY_NAME%TYPE;
2503: l_current_user WF_USERS.NAME%TYPE;
2504:
2505: -- cursor to populate notification attributes

Line 2502: l_name WF_USERS.DISPLAY_NAME%TYPE;

2498: l_total_rec NUMBER;
2499: l_current_rec NUMBER := 0;
2500: l_no_data_found BOOLEAN;
2501: l_user WF_USERS.NAME%TYPE;
2502: l_name WF_USERS.DISPLAY_NAME%TYPE;
2503: l_current_user WF_USERS.NAME%TYPE;
2504:
2505: -- cursor to populate notification attributes
2506: CURSOR wf_users_csr(c_team_id NUMBER,

Line 2503: l_current_user WF_USERS.NAME%TYPE;

2499: l_current_rec NUMBER := 0;
2500: l_no_data_found BOOLEAN;
2501: l_user WF_USERS.NAME%TYPE;
2502: l_name WF_USERS.DISPLAY_NAME%TYPE;
2503: l_current_user WF_USERS.NAME%TYPE;
2504:
2505: -- cursor to populate notification attributes
2506: CURSOR wf_users_csr(c_team_id NUMBER,
2507: c_current_user NUMBER,

Line 2506: CURSOR wf_users_csr(c_team_id NUMBER,

2502: l_name WF_USERS.DISPLAY_NAME%TYPE;
2503: l_current_user WF_USERS.NAME%TYPE;
2504:
2505: -- cursor to populate notification attributes
2506: CURSOR wf_users_csr(c_team_id NUMBER,
2507: c_current_user NUMBER,
2508: c_name VARCHAR)
2509: IS
2510: SELECT wu.name, wu.display_name

Line 2517: wf_users WU

2513: jtf_rs_Resource_extns a,
2514: jtf_rs_Team_Members b,
2515: jtf_rs_Groups_b d,
2516: jtf_rs_resource_extns re,
2517: wf_users WU
2518: WHERE t.team_id = c_team_id
2519: AND nvl (t.start_date_active, sysdate - 1) <= sysdate
2520: AND nvl (t.end_date_active, sysdate + 1) >= sysdate
2521: AND jtfr.role_code = 'PORTFOLIO_GROUP'

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

2552: itemkey => itemkey,
2553: aname => 'PERFORMING_AGENT');
2554:
2555:
2556: OPEN wf_users_csr(l_rmr_id, l_current_rec, l_current_user);
2557: FETCH wf_users_csr INTO l_user, l_name ;
2558: CLOSE wf_users_csr;
2559:
2560: wf_engine.SetItemAttrText ( itemtype=> itemtype,

Line 2557: FETCH wf_users_csr INTO l_user, l_name ;

2553: aname => 'PERFORMING_AGENT');
2554:
2555:
2556: OPEN wf_users_csr(l_rmr_id, l_current_rec, l_current_user);
2557: FETCH wf_users_csr INTO l_user, l_name ;
2558: CLOSE wf_users_csr;
2559:
2560: wf_engine.SetItemAttrText ( itemtype=> itemtype,
2561: itemkey => itemkey,

Line 2558: CLOSE wf_users_csr;

2554:
2555:
2556: OPEN wf_users_csr(l_rmr_id, l_current_rec, l_current_user);
2557: FETCH wf_users_csr INTO l_user, l_name ;
2558: CLOSE wf_users_csr;
2559:
2560: wf_engine.SetItemAttrText ( itemtype=> itemtype,
2561: itemkey => itemkey,
2562: aname => 'PERFORMING_AGENT',

Line 2608: IF wf_users_csr%ISOPEN THEN

2604: END IF;
2605:
2606: EXCEPTION
2607: WHEN OTHERS THEN
2608: IF wf_users_csr%ISOPEN THEN
2609: CLOSE wf_users_csr;
2610: END IF;
2611:
2612: wf_core.context('OKL_AM_ASSET_RETURN_WF' , 'NOTIFY_ASS_GRP_USER', itemtype, itemkey, actid, funcmode);

Line 2609: CLOSE wf_users_csr;

2605:
2606: EXCEPTION
2607: WHEN OTHERS THEN
2608: IF wf_users_csr%ISOPEN THEN
2609: CLOSE wf_users_csr;
2610: END IF;
2611:
2612: wf_core.context('OKL_AM_ASSET_RETURN_WF' , 'NOTIFY_ASS_GRP_USER', itemtype, itemkey, actid, funcmode);
2613: RAISE;