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 1591: FROM fnd_responsibility

1587:
1588:
1589: SELECT responsibility_id
1590: INTO l_respId
1591: FROM fnd_responsibility
1592: WHERE responsibility_key = l_resp_key
1593: AND application_id = 540;
1594:
1595: wf_engine.SetItemAttrText (itemtype => itemtype,

Line 1678: FROM fnd_responsibility

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

Line 1832: FROM fnd_responsibility

1828: close user_info;
1829:
1830: SELECT responsibility_id
1831: INTO l_respId
1832: FROM fnd_responsibility
1833: WHERE responsibility_key = l_resp_key
1834: AND application_id = 540;
1835:
1836: wf_engine.SetItemAttrText (itemtype => itemtype,

Line 1925: FROM fnd_responsibility

1921: AND dnz_chr_id = l_chr_id;
1922:
1923: CURSOR approver_cur (l_resp_key VARCHAR2)IS
1924: SELECT responsibility_id
1925: FROM fnd_responsibility
1926: WHERE responsibility_key = l_resp_key
1927: AND application_id = 540;
1928:
1929: begin

Line 2251: FROM fnd_responsibility

2247: l_respString := 'FND_RESP540:';
2248:
2249: SELECT responsibility_id
2250: INTO l_respId
2251: FROM fnd_responsibility
2252: WHERE responsibility_key = l_resp_key -- This example is for 'Lease Center Agent' responsibility
2253: AND application_id = 540;
2254:
2255: wf_engine.SetItemAttrText (itemtype => itemtype ,

Line 2576: FROM fnd_responsibility

2572:
2573:
2574: SELECT responsibility_id
2575: into l_resp_id
2576: FROM fnd_responsibility
2577: WHERE responsibility_key = l_resp_key
2578: AND application_id = 540;
2579:
2580:

Line 2767: FROM fnd_responsibility

2763:
2764:
2765: CURSOR receiver_cur(respKey varchar2) IS
2766: SELECT responsibility_id
2767: FROM fnd_responsibility
2768: WHERE responsibility_key = respKey
2769: AND application_id = 540;
2770:
2771:

Line 3378: FROM fnd_responsibility

3374: l_payee_role := WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCPAYEEROLE');
3375:
3376: SELECT responsibility_id
3377: into l_resp_id
3378: FROM fnd_responsibility
3379: WHERE responsibility_key = l_payee_role
3380: AND application_id = 540;
3381:
3382: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCACCOUNTNAME', l_cust_name );

Line 3665: FROM fnd_responsibility

3661: close requestor_info_cur;
3662:
3663:
3664: SELECT responsibility_id into l_resp_id
3665: FROM fnd_responsibility
3666: WHERE responsibility_key = l_resp_key
3667: AND application_id = 540;
3668:
3669: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCCONTRACTNUMBER', l_chr_number );