DBA Data[Home] [Help]

APPS.LNS_WORK_FLOW dependencies on FND_USER

Line 127: from fnd_user

123: ITEM_KEY = p_itemkey;
124:
125: CURSOR csr_user_id (p_user_name varchar2) IS
126: select USER_ID
127: from fnd_user
128: where USER_NAME = p_user_name;
129:
130: CURSOR csr_get_resp (p_user_id NUMBER, p_resp_id NUMBER) IS
131: select usr.user_name,

Line 136: from fnd_user usr,

132: resp.responsibility_id,
133: resp.responsibility_key,
134: resp.request_group_id,
135: rgr.request_group_name
136: from fnd_user usr,
137: FND_USER_RESP_GROUPS urg,
138: fnd_responsibility resp,
139: FND_REQUEST_GROUPS rgr
140: where

Line 137: FND_USER_RESP_GROUPS urg,

133: resp.responsibility_key,
134: resp.request_group_id,
135: rgr.request_group_name
136: from fnd_user usr,
137: FND_USER_RESP_GROUPS urg,
138: fnd_responsibility resp,
139: FND_REQUEST_GROUPS rgr
140: where
141: usr.user_id = p_user_id and

Line 856: FROM fnd_user_resp_groups usr_resp

852: l_appl_id NUMBER;
853: --Get all valid lns responsibilities for the user_id
854: CURSOR C_GET_USER_RESPS(p_user_id NUMBER,p_appl_id NUMBER) IS
855: SELECT usr_resp.responsibility_id
856: FROM fnd_user_resp_groups usr_resp
857: WHERE usr_resp.responsibility_application_id = p_appl_id
858: AND trunc(sysdate) between trunc(nvl(usr_resp.start_date, sysdate)) and trunc(nvl(usr_resp.end_date, sysdate))
859: -- AND usr_resp.start_date < sysdate AND nvl(usr_resp.end_date,sysdate-1) > sysdate -- Bug#8247186
860: AND usr_resp.user_id = p_user_id;

Line 947: l_user_name FND_USER.user_name%TYPE;

943: l_api_name CONSTANT VARCHAR2(30)
944: := 'CREATE_NOTIFICATION_DETAILS';
945: l_api_version CONSTANT NUMBER := 1.0;
946: l_user_roles VARCHAR2(32000);
947: l_user_name FND_USER.user_name%TYPE;
948: l_role_name VARCHAR2(100);
949: l_loan_number LNS_LOAN_HEADERS.LOAN_NUMBER%TYPE;
950: l_primary_recipient_type lns_event_actions.primary_recipient_type%TYPE;
951: l_primary_recipient_name lns_event_actions.primary_recipient_name%TYPE;

Line 956: l_loan_assigned_user fnd_user.user_name%TYPE;

952: l_priority_num lns_event_actions.priority_num%TYPE;
953: l_active_for_num lns_event_actions.active_for_num%TYPE;
954: l_delivery_method lns_event_actions.delivery_method%TYPE;
955: l_loan_assigned_name jtf_rs_resource_extns.source_name%TYPE;
956: l_loan_assigned_user fnd_user.user_name%TYPE;
957: l_current_user fnd_user.user_name%TYPE;
958: l_borrower_name hz_parties.party_name%TYPE;
959: l_loan_class lns_lookups.meaning%TYPE;
960: l_loan_type lns_loan_types.loan_type_name%TYPE;

Line 957: l_current_user fnd_user.user_name%TYPE;

953: l_active_for_num lns_event_actions.active_for_num%TYPE;
954: l_delivery_method lns_event_actions.delivery_method%TYPE;
955: l_loan_assigned_name jtf_rs_resource_extns.source_name%TYPE;
956: l_loan_assigned_user fnd_user.user_name%TYPE;
957: l_current_user fnd_user.user_name%TYPE;
958: l_borrower_name hz_parties.party_name%TYPE;
959: l_loan_class lns_lookups.meaning%TYPE;
960: l_loan_type lns_loan_types.loan_type_name%TYPE;
961: l_loan_purpose lns_lookups.meaning%TYPE;

Line 1000: FROM fnd_user fndu

996: AND lea.loan_type_id = p_loan_type_id;
997:
998: CURSOR csr_current_user IS
999: SELECT fndu.user_name
1000: FROM fnd_user fndu
1001: WHERE fndu.user_id = p_current_user_id;
1002:
1003: CURSOR csr_loan_role_users IS
1004: SELECT fndu.user_name

Line 1009: ,fnd_user fndu

1005: ,fndu.user_id
1006: FROM jtf_rs_role_relations rel
1007: ,jtf_rs_roles_b rol
1008: ,jtf_rs_resource_extns res
1009: ,fnd_user fndu
1010: WHERE rel.role_id = rol.role_id
1011: AND rel.delete_flag <> 'Y'
1012: AND SYSDATE BETWEEN NVL(rel.start_date_active,sysdate)
1013: AND NVL(rel.end_date_active,sysdate)

Line 1025: ,fnd.user_name

1021: AND fndu.user_id = res.user_id;
1022:
1023: CURSOR csr_loan_details IS
1024: SELECT hp.party_name borrower_name
1025: ,fnd.user_name
1026: ,res.source_name
1027: ,llklc.meaning loan_class
1028: ,llklt.loan_type_name loan_type
1029: ,llkst.meaning loan_subtype

Line 1039: jtf_rs_resource_extns res, fnd_user fnd,

1035: ,llkp.meaning loan_purpose
1036: ,llh.org_id
1037: ,lprod.loan_product_name
1038: FROM lns_loan_headers_all_vl llh, hz_parties hp,
1039: jtf_rs_resource_extns res, fnd_user fnd,
1040: lns_payments_summary_v ps,
1041: lns_lookups llktt,
1042: lns_lookups llklc,
1043: lns_loan_types_vl llklt,

Line 1050: AND fnd.user_id = res.user_id

1046: lns_loan_products_all_vl lprod
1047: WHERE llh.primary_borrower_id = hp.party_id
1048: AND llh.loan_assigned_to = res.resource_id
1049: AND res.category = 'EMPLOYEE'
1050: AND fnd.user_id = res.user_id
1051: AND llktt.lookup_code = llh.loan_term_period
1052: AND llktt.lookup_type = 'PERIOD'
1053: AND llklc.lookup_code = llh.loan_class_code
1054: AND llklc.lookup_type = 'LOAN_CLASS'

Line 1273: -- to the user (FND_USER)

1269: -- l_user_roles := l_loan_assigned_user;
1270: -- l_role_name :=l_loan_assigned_name || '(' ||l_loan_number || '-'|| ItemKey || ')'
1271:
1272: -- Bug#8709307 - Instead of creating Adhoc Role, directly sending notification
1273: -- to the user (FND_USER)
1274: l_role_name := l_loan_assigned_user;
1275:
1276: wf_engine.SetItemAttrText (itemtype => itemtype,
1277: itemkey => itemkey,

Line 1438: l_current_user_name fnd_user.user_name%TYPE;

1434: l_event_name LNS_EVENTS.EVENT_NAME%TYPE;
1435: l_return_status Varchar2(1);
1436: l_notification_id WF_NOTIFICATIONS.NOTIFICATION_ID%TYPE;
1437: l_search_criteria LNS_LOAN_HEADERS_ALL.LOAN_NUMBER%TYPE;
1438: l_current_user_name fnd_user.user_name%TYPE;
1439:
1440: /*-----------------------------------------------------------------------+
1441: | Cursor Declarations |
1442: +-----------------------------------------------------------------------*/

Line 1446: FROM fnd_user fndu

1442: +-----------------------------------------------------------------------*/
1443:
1444: CURSOR csr_current_user(current_user_id number) IS
1445: SELECT fndu.user_name
1446: FROM fnd_user fndu
1447: WHERE fndu.user_id = current_user_id;
1448:
1449: CURSOR get_notifications_for_close(search_criteria varchar2) IS
1450: SELECT notification_id

Line 3000: l_user_id FND_USER.user_id%TYPE;

2996: funcmode in varchar2,
2997: resultout out NOCOPY varchar2 ) IS
2998: l_approver_user_name VARCHAR2(320);
2999: l_manager_flag VARCHAR2(30);
3000: l_user_id FND_USER.user_id%TYPE;
3001: l_api_name CONSTANT VARCHAR2(30) := 'AME_VERIFY_LOANS_MGR_ROLE';
3002:
3003:
3004: CURSOR verify_lns_mgr_role (p_user_id IN FND_USER.user_id%TYPE ) IS

Line 3004: CURSOR verify_lns_mgr_role (p_user_id IN FND_USER.user_id%TYPE ) IS

3000: l_user_id FND_USER.user_id%TYPE;
3001: l_api_name CONSTANT VARCHAR2(30) := 'AME_VERIFY_LOANS_MGR_ROLE';
3002:
3003:
3004: CURSOR verify_lns_mgr_role (p_user_id IN FND_USER.user_id%TYPE ) IS
3005: select
3006: nvl(manager.manager_flag,'N') manager_flag
3007: from
3008: (select

Line 3029: select user_id from fnd_user where user_name = p_approver_user_name;

3025: and (res.end_date_active is null or res.end_date_active >= sysdate)
3026: and res.user_id = p_user_id;
3027:
3028: CURSOR find_userId_from_user_name(p_approver_user_name IN varchar2) IS
3029: select user_id from fnd_user where user_name = p_approver_user_name;
3030:
3031: BEGIN
3032:
3033: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');