APPS.AR_CMGT_WF_ENGINE dependencies on FND_USER

Line 380: l_user_name fnd_user.user_name%type;

376: itemkey in varchar2 ) IS
377:
378: l_role_name VARCHAR2(30):= 'AR_CMGT_CREDIT_ANALYST_ROLE';
379: l_role_display_name VARCHAR2(240) := 'Credit Analyst Role';
380: l_user_name fnd_user.user_name%type;
381: l_display_name per_people_f.full_name%type;
382:
383: CURSOR c_get_resource_id IS
384: SELECT c.resource_id, c.source_id --employee id

Line 446: l_employee_id fnd_user.employee_id%type;

442: actid in number,
443: funcmode in varchar2,
444: resultout out NOCOPY varchar2) IS
445:
446: l_employee_id fnd_user.employee_id%type;
447: l_resource_id jtf_rs_resource_extns_vl.resource_id%type;
448: l_notification_id NUMBER;
449: l_user_name VARCHAR2(60);
450: l_display_name VARCHAR2(240);

Line 461: FROM FND_USER

457: -- get resource id for credit analyst user
458: BEGIN
459: SELECT employee_id
460: INTO l_employee_id
461: FROM FND_USER
462: WHERE user_name = wf_engine.context_text;
463: EXCEPTION
464: WHEN NO_DATA_FOUND THEN
465: wf_core.context('AR_CMGT_WF_ENGINE','GET_CREDIT_ANALYST',itemtype, itemkey,

Line 1165: l_requestor_user_name fnd_user.user_name%type;

1161: l_review_type_meaning ar_lookups.meaning%type;
1162: l_application_number ar_cmgt_credit_requests.application_number%type;
1163: l_score_model_already_set VARCHAR2(1) := 'F';
1164: l_requestor_id ar_cmgt_credit_requests.requestor_id%type;
1165: l_requestor_user_name fnd_user.user_name%type;
1166: l_requestor_display_name per_people_f.full_name%type;
1167: l_party_id hz_parties.party_id%type;
1168: l_cust_account_id hz_cust_accounts.cust_account_id%type;
1169: l_party_name hz_parties.party_name%type;

Line 1370: FROM fnd_user

1366: -- get user id
1367: BEGIN
1368: SELECT user_name
1369: INTO l_requestor_user_name
1370: FROM fnd_user
1371: WHERE user_id = l_requestor_id;
1372:
1373: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
1374: itemkey => itemkey,

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

1381: avalue => l_requestor_user_name );
1382: EXCEPTION
1383: WHEN NO_DATA_FOUND THEN
1384: wf_core.context ('AR_CMGT_WF_ENGINE','CHECK_CREDIT_POLICY',itemtype,itemkey,
1385: 'FND User Not Found'|| sqlerrm);
1386: raise;
1387: WHEN OTHERS THEN
1388: wf_core.context ('AR_CMGT_WF_ENGINE','CHECK_CREDIT_POLICY',itemtype,itemkey,
1389: 'Other Error '|| sqlerrm);

Line 3820: l_requestor_user_name fnd_user.user_name%type;

3816: l_review_type_meaning ar_lookups.meaning%type;
3817: l_application_number ar_cmgt_credit_requests.application_number%type;
3818: l_score_model_already_set VARCHAR2(1) := 'F';
3819: l_requestor_id ar_cmgt_credit_requests.requestor_id%type;
3820: l_requestor_user_name fnd_user.user_name%type;
3821: l_requestor_display_name per_people_f.full_name%type;
3822: l_party_id hz_parties.party_id%type;
3823: l_cust_account_id hz_cust_accounts.cust_account_id%type;
3824: l_party_name hz_parties.party_name%type;

Line 4013: FROM fnd_user

4009: -- get user id
4010: BEGIN
4011: SELECT user_name
4012: INTO l_requestor_user_name
4013: FROM fnd_user
4014: WHERE user_id = l_requestor_id;
4015:
4016: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
4017: itemkey => itemkey,

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

4024: avalue => l_requestor_user_name );
4025: EXCEPTION
4026: WHEN NO_DATA_FOUND THEN
4027: wf_core.context ('AR_CMGT_WF_ENGINE','POPULATE_WF_ATTRIBUTE',itemtype,itemkey,
4028: 'FND User Not Found'|| sqlerrm);
4029: raise;
4030: WHEN OTHERS THEN
4031: wf_core.context ('AR_CMGT_WF_ENGINE','POPULATE_WF_ATTRIBUTE',itemtype,itemkey,
4032: 'Other Error '|| sqlerrm);