APPS.AR_CMGT_WF_ENGINE dependencies on FND_USER

Line 401: l_user_name fnd_user.user_name%type;

397: itemkey in varchar2 ) IS
398:
399: l_role_name VARCHAR2(30):= 'AR_CMGT_CREDIT_ANALYST_ROLE';
400: l_role_display_name VARCHAR2(240) := 'Credit Analyst Role';
401: l_user_name fnd_user.user_name%type;
402: l_display_name per_people_f.full_name%type;
403:
404: CURSOR c_get_resource_id IS
405: SELECT c.resource_id, c.source_id --employee id

Line 467: l_employee_id fnd_user.employee_id%type;

463: actid in number,
464: funcmode in varchar2,
465: resultout out NOCOPY varchar2) IS
466:
467: l_employee_id fnd_user.employee_id%type;
468: l_resource_id jtf_rs_resource_extns_vl.resource_id%type;
469: l_notification_id NUMBER;
470: l_user_name VARCHAR2(60);
471: l_display_name VARCHAR2(240);

Line 482: FROM FND_USER

478: -- get resource id for credit analyst user
479: BEGIN
480: SELECT employee_id
481: INTO l_employee_id
482: FROM FND_USER
483: WHERE user_name = wf_engine.context_text;
484: EXCEPTION
485: WHEN NO_DATA_FOUND THEN
486: wf_core.context('AR_CMGT_WF_ENGINE','GET_CREDIT_ANALYST',itemtype, itemkey,

Line 1409: l_requestor_user_name fnd_user.user_name%type;

1405: l_review_type_meaning ar_lookups.meaning%type;
1406: l_application_number ar_cmgt_credit_requests.application_number%type;
1407: l_score_model_already_set VARCHAR2(1) := 'F';
1408: l_requestor_id ar_cmgt_credit_requests.requestor_id%type;
1409: l_requestor_user_name fnd_user.user_name%type;
1410: l_requestor_display_name per_people_f.full_name%type;
1411: l_party_id hz_parties.party_id%type;
1412: l_cust_account_id hz_cust_accounts.cust_account_id%type;
1413: l_party_name hz_parties.party_name%type;

Line 1614: FROM fnd_user

1610: -- get user id
1611: BEGIN
1612: SELECT user_name
1613: INTO l_requestor_user_name
1614: FROM fnd_user
1615: WHERE user_id = l_requestor_id;
1616:
1617: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
1618: itemkey => itemkey,

Line 1629: 'FND User Not Found'|| sqlerrm);

1625: avalue => l_requestor_user_name );
1626: EXCEPTION
1627: WHEN NO_DATA_FOUND THEN
1628: wf_core.context ('AR_CMGT_WF_ENGINE','CHECK_CREDIT_POLICY',itemtype,itemkey,
1629: 'FND User Not Found'|| sqlerrm);
1630: raise;
1631: WHEN OTHERS THEN
1632: wf_core.context ('AR_CMGT_WF_ENGINE','CHECK_CREDIT_POLICY',itemtype,itemkey,
1633: 'Other Error '|| sqlerrm);

Line 4328: l_requestor_user_name fnd_user.user_name%type;

4324: l_review_type_meaning ar_lookups.meaning%type;
4325: l_application_number ar_cmgt_credit_requests.application_number%type;
4326: l_score_model_already_set VARCHAR2(1) := 'F';
4327: l_requestor_id ar_cmgt_credit_requests.requestor_id%type;
4328: l_requestor_user_name fnd_user.user_name%type;
4329: l_requestor_display_name per_people_f.full_name%type;
4330: l_party_id hz_parties.party_id%type;
4331: l_cust_account_id hz_cust_accounts.cust_account_id%type;
4332: l_party_name hz_parties.party_name%type;

Line 4522: FROM fnd_user

4518: -- get user id
4519: BEGIN
4520: SELECT user_name
4521: INTO l_requestor_user_name
4522: FROM fnd_user
4523: WHERE user_id = l_requestor_id;
4524:
4525: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
4526: itemkey => itemkey,

Line 4537: 'FND User Not Found'|| sqlerrm);

4533: avalue => l_requestor_user_name );
4534: EXCEPTION
4535: WHEN NO_DATA_FOUND THEN
4536: wf_core.context ('AR_CMGT_WF_ENGINE','POPULATE_WF_ATTRIBUTE',itemtype,itemkey,
4537: 'FND User Not Found'|| sqlerrm);
4538: raise;
4539: WHEN OTHERS THEN
4540: wf_core.context ('AR_CMGT_WF_ENGINE','POPULATE_WF_ATTRIBUTE',itemtype,itemkey,
4541: 'Other Error '|| sqlerrm);