APPS.OKL_SSC_WF dependencies on FND_RESPONSIBILITY

Line 104: FROM fnd_responsibility

100:
101:
102: CURSOR approver_cur(respKey varchar2) IS
103: SELECT responsibility_id
104: FROM fnd_responsibility
105: WHERE responsibility_key = respKey
106: AND application_id = 540;
107:
108:

Line 320: FROM fnd_responsibility

316: WHERE user_id = p_id;
317:
318: CURSOR approver_cur(respKey varchar2) IS
319: SELECT responsibility_id
320: FROM fnd_responsibility
321: WHERE responsibility_key = respKey
322: AND application_id = 540;
323:
324: requestor_info_rec user_info%rowtype;

Line 592: FROM fnd_responsibility

588: WHERE user_id = p_id;
589:
590: CURSOR approver_cur(respKey varchar2) IS
591: SELECT responsibility_id
592: FROM fnd_responsibility
593: WHERE responsibility_key = respKey
594: AND application_id = 540;
595:
596: requestor_info_rec user_info%rowtype;

Line 1677: FROM fnd_responsibility

1673:
1674:
1675: SELECT responsibility_id
1676: INTO l_respId
1677: FROM fnd_responsibility
1678: WHERE responsibility_key = l_resp_key
1679: AND application_id = 540;
1680:
1681: wf_engine.SetItemAttrText (itemtype => itemtype,

Line 1764: FROM fnd_responsibility

1760:
1761:
1762: SELECT responsibility_id
1763: INTO l_respId
1764: FROM fnd_responsibility
1765: WHERE responsibility_key = l_resp_key
1766: AND application_id = 540;
1767:
1768: wf_engine.SetItemAttrText (itemtype => itemtype,

Line 1918: FROM fnd_responsibility

1914: close user_info;
1915:
1916: SELECT responsibility_id
1917: INTO l_respId
1918: FROM fnd_responsibility
1919: WHERE responsibility_key = l_resp_key
1920: AND application_id = 540;
1921:
1922: wf_engine.SetItemAttrText (itemtype => itemtype,

Line 2011: FROM fnd_responsibility

2007: AND dnz_chr_id = l_chr_id;
2008:
2009: CURSOR approver_cur (l_resp_key VARCHAR2)IS
2010: SELECT responsibility_id
2011: FROM fnd_responsibility
2012: WHERE responsibility_key = l_resp_key
2013: AND application_id = 540;
2014:
2015: begin

Line 2337: FROM fnd_responsibility

2333: l_respString := 'FND_RESP540:';
2334:
2335: SELECT responsibility_id
2336: INTO l_respId
2337: FROM fnd_responsibility
2338: WHERE responsibility_key = l_resp_key -- This example is for 'Lease Center Agent' responsibility
2339: AND application_id = 540;
2340:
2341: wf_engine.SetItemAttrText (itemtype => itemtype ,

Line 2662: FROM fnd_responsibility

2658:
2659:
2660: SELECT responsibility_id
2661: into l_resp_id
2662: FROM fnd_responsibility
2663: WHERE responsibility_key = l_resp_key
2664: AND application_id = 540;
2665:
2666:

Line 2853: FROM fnd_responsibility

2849:
2850:
2851: CURSOR receiver_cur(respKey varchar2) IS
2852: SELECT responsibility_id
2853: FROM fnd_responsibility
2854: WHERE responsibility_key = respKey
2855: AND application_id = 540;
2856:
2857:

Line 3464: FROM fnd_responsibility

3460: l_payee_role := WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCPAYEEROLE');
3461:
3462: SELECT responsibility_id
3463: into l_resp_id
3464: FROM fnd_responsibility
3465: WHERE responsibility_key = l_payee_role
3466: AND application_id = 540;
3467:
3468: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCACCOUNTNAME', l_cust_name );

Line 3751: FROM fnd_responsibility

3747: close requestor_info_cur;
3748:
3749:
3750: SELECT responsibility_id into l_resp_id
3751: FROM fnd_responsibility
3752: WHERE responsibility_key = l_resp_key
3753: AND application_id = 540;
3754:
3755: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCCONTRACTNUMBER', l_chr_number );