APPS.AS_SALES_LEAD_REFERRAL dependencies on FND_USER

Line 325: l_user_name fnd_user.user_name%type;

321: l_notify_ptnr_role VARCHAR2(80);
322: l_itemType CONSTANT VARCHAR2(30) := g_wf_itemtype_notify;
323: l_itemKey VARCHAR2(30);
324: l_user_id NUMBER;
325: l_user_name fnd_user.user_name%type;
326: l_person_id NUMBER;--as_accesses_all.person_id%type;
327: l_resource_id NUMBER;
328: l_customer_name VARCHAR2(80);
329: l_customer_city VARCHAR2(50);

Line 341: user_name fnd_user.user_name%type

337: l_party_id NUMBER;
338:
339: TYPE UserRecType IS RECORD (
340: user_id NUMBER,
341: user_name fnd_user.user_name%type
342: );
343:
344: TYPE UserTableType IS TABLE OF UserRecType INDEX BY BINARY_INTEGER;
345: l_user_table UserTableType;

Line 363: -- get lead owner user name from fnd_user

359: and lkp2.lookup_type(+) = 'REFERRAL_STATUS'
360: and asl.ref_decline_reason = lkp3.lookup_code(+)
361: and lkp3.lookup_type(+) = 'DECLINE_REASON';
362:
363: -- get lead owner user name from fnd_user
364: CURSOR lc_lead_owner (pc_lead_id number) IS
365: SELECT lead.assign_to_person_id, usr.user_name, usr.user_id, res.source_id
366: FROM as_sales_leads lead, fnd_user usr, jtf_rs_resource_extns res
367: WHERE lead.sales_lead_id = pc_lead_id

Line 366: FROM as_sales_leads lead, fnd_user usr, jtf_rs_resource_extns res

362:
363: -- get lead owner user name from fnd_user
364: CURSOR lc_lead_owner (pc_lead_id number) IS
365: SELECT lead.assign_to_person_id, usr.user_name, usr.user_id, res.source_id
366: FROM as_sales_leads lead, fnd_user usr, jtf_rs_resource_extns res
367: WHERE lead.sales_lead_id = pc_lead_id
368: and lead.assign_to_person_id = res.source_id
369: and res.user_id = usr.user_id;
370:

Line 374: FROM as_accesses_all acc, jtf_rs_resource_extns res, fnd_user usr

370:
371: -- Get External Sales Team People - Partner user name
372: CURSOR lc_ptnr_users (pc_lead_id number) IS
373: SELECT acc.salesforce_id, usr.user_name, usr.user_id
374: FROM as_accesses_all acc, jtf_rs_resource_extns res, fnd_user usr
375: WHERE acc.sales_lead_id = pc_lead_id
376: -- AND acc. salesforce_role_code = 'REFERRAL'
377: AND acc.person_id IS NULL
378: AND acc.salesforce_id = res.resource_id

Line 472: l_owner_user_name fnd_user.user_name%TYPE;

468: l_ref_decline_reason_meaning varchar2(100);
469: l_ref_comm_ltr_status as_sales_leads.ref_comm_ltr_status%TYPE;
470: l_ptnr_salesforce_id as_accesses_all.salesforce_id%TYPE;
471: l_assign_to_person_id number;
472: l_owner_user_name fnd_user.user_name%TYPE;
473: l_owner_user_id fnd_user.user_id%TYPE;
474: l_owner_source_id number;
475: l_ptnr_user_id number;
476: l_overriding_usercount number;

Line 473: l_owner_user_id fnd_user.user_id%TYPE;

469: l_ref_comm_ltr_status as_sales_leads.ref_comm_ltr_status%TYPE;
470: l_ptnr_salesforce_id as_accesses_all.salesforce_id%TYPE;
471: l_assign_to_person_id number;
472: l_owner_user_name fnd_user.user_name%TYPE;
473: l_owner_user_id fnd_user.user_id%TYPE;
474: l_owner_source_id number;
475: l_ptnr_user_id number;
476: l_overriding_usercount number;
477: l_count number;

Line 631: -- get lead owner user name from fnd_user

627:
628: --
629: ELSE
630: -- If l_referral_status not in ('ACCEPTED','DECLINED') then
631: -- get lead owner user name from fnd_user
632: -- There can be only one owner.
633: OPEN lc_lead_owner (pc_lead_id => l_lead_id);
634: FETCH lc_lead_owner INTO l_assign_to_person_id, l_owner_user_name, l_owner_user_id, l_owner_source_id;
635: CLOSE lc_lead_owner;