eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AS_SALES_LEAD_REFERRAL dependencies on AS_SALES_LEADS

Line 27: P_SALES_LEAD_Rec IN AS_SALES_LEADS_PUB.SALES_LEAD_Rec_Type

23: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
24: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
25: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
26: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
27: P_SALES_LEAD_Rec IN AS_SALES_LEADS_PUB.SALES_LEAD_Rec_Type
28: DEFAULT AS_SALES_LEADS_PUB.G_MISS_SALES_LEAD_REC,
29: p_overriding_usernames IN t_overriding_usernames,
30: X_Return_Status OUT NOCOPY VARCHAR2,
31: X_Msg_Count OUT NOCOPY NUMBER,

Line 28: DEFAULT AS_SALES_LEADS_PUB.G_MISS_SALES_LEAD_REC,

24: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
25: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
26: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
27: P_SALES_LEAD_Rec IN AS_SALES_LEADS_PUB.SALES_LEAD_Rec_Type
28: DEFAULT AS_SALES_LEADS_PUB.G_MISS_SALES_LEAD_REC,
29: p_overriding_usernames IN t_overriding_usernames,
30: X_Return_Status OUT NOCOPY VARCHAR2,
31: X_Msg_Count OUT NOCOPY NUMBER,
32: X_Msg_Data OUT NOCOPY VARCHAR2

Line 43: l_sales_lead_id AS_SALES_LEADS.sales_lead_id%type;

39:
40: l_return_status VARCHAR2(1);
41:
42:
43: l_sales_lead_id AS_SALES_LEADS.sales_lead_id%type;
44: l_referral_status AS_SALES_LEADS.referral_status%type;
45: l_referred_by AS_SALES_LEADS.referred_by%type;
46: l_sales_lead_log_id number;
47: l_lead_referral_status VARCHAR2(100);

Line 44: l_referral_status AS_SALES_LEADS.referral_status%type;

40: l_return_status VARCHAR2(1);
41:
42:
43: l_sales_lead_id AS_SALES_LEADS.sales_lead_id%type;
44: l_referral_status AS_SALES_LEADS.referral_status%type;
45: l_referred_by AS_SALES_LEADS.referred_by%type;
46: l_sales_lead_log_id number;
47: l_lead_referral_status VARCHAR2(100);
48: l_msg_data VARCHAR2(10000):='';

Line 45: l_referred_by AS_SALES_LEADS.referred_by%type;

41:
42:
43: l_sales_lead_id AS_SALES_LEADS.sales_lead_id%type;
44: l_referral_status AS_SALES_LEADS.referral_status%type;
45: l_referred_by AS_SALES_LEADS.referred_by%type;
46: l_sales_lead_log_id number;
47: l_lead_referral_status VARCHAR2(100);
48: l_msg_data VARCHAR2(10000):='';
49: my_message VARCHAR2(2000);

Line 52: FROM AS_SALES_LEADS LEAD

48: l_msg_data VARCHAR2(10000):='';
49: my_message VARCHAR2(2000);
50: CURSOR lc_sales_lead (pc_sales_lead_id number) IS
51: SELECT lead.referred_by, lead.referral_status
52: FROM AS_SALES_LEADS LEAD
53: WHERE LEAD.SALES_LEAD_ID = pc_sales_lead_id;
54:
55: BEGIN
56:

Line 122: AS_SALES_LEADS_LOG_PKG.Insert_Row(

118: AS_Utility_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, l_full_name ||': status changed');
119: -- Call API to create log entry
120:
121:
122: AS_SALES_LEADS_LOG_PKG.Insert_Row(
123: px_log_id => l_sales_lead_log_id ,
124: p_sales_lead_id => P_SALES_LEAD_Rec.sales_lead_id,
125: p_created_by => fnd_global.user_id,
126: p_creation_date => sysdate,

Line 184: -- Update the referral status in as_sales_leads table

180: END IF;
181:
182: END IF;
183:
184: -- Update the referral status in as_sales_leads table
185:
186: l_msg_data:=l_msg_data || '** before calling Update sales lead';
187:
188: as_sales_leads_pub.update_sales_lead(

Line 188: as_sales_leads_pub.update_sales_lead(

184: -- Update the referral status in as_sales_leads table
185:
186: l_msg_data:=l_msg_data || '** before calling Update sales lead';
187:
188: as_sales_leads_pub.update_sales_lead(
189:
190: P_Api_Version_Number => l_api_version,
191: P_Init_Msg_List => FND_API.G_FALSE,
192: P_Commit => FND_API.G_FALSE,

Line 354: from as_sales_leads asl, as_lookups lkp1, as_lookups lkp2, as_lookups lkp3

350: select asl.description, asl.referred_by, asl.referral_type,lkp1.meaning referral_type_meaning,
351: asl.referral_status,lkp2.meaning referral_status_meaning, asl.ref_order_number, asl.ref_order_amt,
352: asl.ref_comm_amt, asl.ref_decline_reason,lkp3.meaning decline_reason_meaning,
353: asl.ref_comm_ltr_status,asl.created_by
354: from as_sales_leads asl, as_lookups lkp1, as_lookups lkp2, as_lookups lkp3
355: where asl.sales_lead_id = pc_lead_id
356: and asl.referral_type = lkp1.lookup_code(+)
357: and lkp1.lookup_type(+) = 'REFERRAL_TYPE'
358: and asl.referral_status = lkp2.lookup_code(+)

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 384: FROM as_sales_leads asl, hz_parties hp

380:
381: -- Get Customer Information
382: CURSOR lc_customer (pc_lead_id number) IS
383: SELECT hp.party_name, hp.city, hp.state, hp.country
384: FROM as_sales_leads asl, hz_parties hp
385: WHERE asl.sales_lead_id = pc_lead_id
386: AND hp.party_id = asl.customer_id;
387:
388:

Line 391: from AS_SALES_LEADS LEAD, HZ_PARTIES PARTNER, HZ_RELATIONSHIPS REL,HZ_ORGANIZATION_PROFILES ORG

387:
388:
389: CURSOR lc_ptnr_org_name(pc_party_id NUMBER) IS
390: SELECT ORG.PARTY_ID, partner.party_name
391: from AS_SALES_LEADS LEAD, HZ_PARTIES PARTNER, HZ_RELATIONSHIPS REL,HZ_ORGANIZATION_PROFILES ORG
392: where LEAD.REFERRED_BY=REL.PARTY_ID and REL.SUBJECT_ID=PARTNER.PARTY_ID
393: and REL.OBJECT_ID=ORG.PARTY_ID
394: and ORG.internal_flag = 'Y'
395: and ORG.effective_end_date is null

Line 458: l_lead_name as_sales_leads.description%TYPE;

454: where user_id = c_created_by;
455:
456:
457:
458: l_lead_name as_sales_leads.description%TYPE;
459: l_referred_by as_sales_leads.referred_by%TYPE;
460: l_referral_type as_sales_leads.referral_type%TYPE;
461: l_referral_type_meaning varchar2(100);
462: l_referral_status as_sales_leads.referral_status%TYPE;

Line 459: l_referred_by as_sales_leads.referred_by%TYPE;

455:
456:
457:
458: l_lead_name as_sales_leads.description%TYPE;
459: l_referred_by as_sales_leads.referred_by%TYPE;
460: l_referral_type as_sales_leads.referral_type%TYPE;
461: l_referral_type_meaning varchar2(100);
462: l_referral_status as_sales_leads.referral_status%TYPE;
463: l_referral_status_meaning varchar2(100);

Line 460: l_referral_type as_sales_leads.referral_type%TYPE;

456:
457:
458: l_lead_name as_sales_leads.description%TYPE;
459: l_referred_by as_sales_leads.referred_by%TYPE;
460: l_referral_type as_sales_leads.referral_type%TYPE;
461: l_referral_type_meaning varchar2(100);
462: l_referral_status as_sales_leads.referral_status%TYPE;
463: l_referral_status_meaning varchar2(100);
464: l_ref_order_number as_sales_leads.ref_order_number%TYPE;

Line 462: l_referral_status as_sales_leads.referral_status%TYPE;

458: l_lead_name as_sales_leads.description%TYPE;
459: l_referred_by as_sales_leads.referred_by%TYPE;
460: l_referral_type as_sales_leads.referral_type%TYPE;
461: l_referral_type_meaning varchar2(100);
462: l_referral_status as_sales_leads.referral_status%TYPE;
463: l_referral_status_meaning varchar2(100);
464: l_ref_order_number as_sales_leads.ref_order_number%TYPE;
465: l_ref_order_amt as_sales_leads.ref_order_amt%TYPE;
466: l_ref_comm_amt as_sales_leads.ref_comm_amt%TYPE;

Line 464: l_ref_order_number as_sales_leads.ref_order_number%TYPE;

460: l_referral_type as_sales_leads.referral_type%TYPE;
461: l_referral_type_meaning varchar2(100);
462: l_referral_status as_sales_leads.referral_status%TYPE;
463: l_referral_status_meaning varchar2(100);
464: l_ref_order_number as_sales_leads.ref_order_number%TYPE;
465: l_ref_order_amt as_sales_leads.ref_order_amt%TYPE;
466: l_ref_comm_amt as_sales_leads.ref_comm_amt%TYPE;
467: l_ref_decline_reason as_sales_leads.ref_decline_reason%TYPE;
468: l_ref_decline_reason_meaning varchar2(100);

Line 465: l_ref_order_amt as_sales_leads.ref_order_amt%TYPE;

461: l_referral_type_meaning varchar2(100);
462: l_referral_status as_sales_leads.referral_status%TYPE;
463: l_referral_status_meaning varchar2(100);
464: l_ref_order_number as_sales_leads.ref_order_number%TYPE;
465: l_ref_order_amt as_sales_leads.ref_order_amt%TYPE;
466: l_ref_comm_amt as_sales_leads.ref_comm_amt%TYPE;
467: l_ref_decline_reason as_sales_leads.ref_decline_reason%TYPE;
468: l_ref_decline_reason_meaning varchar2(100);
469: l_ref_comm_ltr_status as_sales_leads.ref_comm_ltr_status%TYPE;

Line 466: l_ref_comm_amt as_sales_leads.ref_comm_amt%TYPE;

462: l_referral_status as_sales_leads.referral_status%TYPE;
463: l_referral_status_meaning varchar2(100);
464: l_ref_order_number as_sales_leads.ref_order_number%TYPE;
465: l_ref_order_amt as_sales_leads.ref_order_amt%TYPE;
466: l_ref_comm_amt as_sales_leads.ref_comm_amt%TYPE;
467: l_ref_decline_reason as_sales_leads.ref_decline_reason%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;

Line 467: l_ref_decline_reason as_sales_leads.ref_decline_reason%TYPE;

463: l_referral_status_meaning varchar2(100);
464: l_ref_order_number as_sales_leads.ref_order_number%TYPE;
465: l_ref_order_amt as_sales_leads.ref_order_amt%TYPE;
466: l_ref_comm_amt as_sales_leads.ref_comm_amt%TYPE;
467: l_ref_decline_reason as_sales_leads.ref_decline_reason%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;

Line 469: l_ref_comm_ltr_status as_sales_leads.ref_comm_ltr_status%TYPE;

465: l_ref_order_amt as_sales_leads.ref_order_amt%TYPE;
466: l_ref_comm_amt as_sales_leads.ref_comm_amt%TYPE;
467: l_ref_decline_reason as_sales_leads.ref_decline_reason%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;

Line 517: -- Get Lead Details using sales_lead_id from as_sales_leads

513: -- Initialize API return status to SUCCESS
514: x_return_status := FND_API.G_RET_STS_SUCCESS;
515:
516: -- Notify_Party processing steps
517: -- Get Lead Details using sales_lead_id from as_sales_leads
518: -- Get a workflow item key from the sequence
519: -- Create a workflow process
520: -- Set Item Attributes i.e all the info reqd by the wf for that lead. eg. status
521: -- Based on the referral_status, figure OUT NOCOPY who to send the notification to