DBA Data[Home] [Help]

APPS.AS_SALES_LEAD_ENGINE_PVT dependencies on AS_SALES_LEADS_LOG

Line 46: -- as_sales_leads_log.manual_rank_flag

42: -- Creation date attribute doesn't work.
43: -- In cursor C_Get_Lead_Info, append '000000', instead
44: -- of '0000'
45: -- 12/17/2002 SOLIN Change for as_sales_leads.lead_rank_ind and
46: -- as_sales_leads_log.manual_rank_flag
47: -- 01/09/2003 SOLIN Bug 2740032
48: -- Obsolete profiles AS_RUN_NEW_LEAD_ENGINES,
49: -- AS_AUTO_QUALIFY, AS_RANK_LEAD_OPTION
50: -- 01/16/2003 SOLIN Remove Start_Partner_Matching.

Line 388: AS_SALES_LEADS_LOG_PKG.Insert_Row(

384: x_lead_engines_out_rec.lead_rank_id :=
385: l_sales_lead_rec.lead_rank_id;
386: -- ckapoor Disqualification project call sales lead table handler to save this value of lead_rank_id
387:
388: AS_SALES_LEADS_LOG_PKG.Insert_Row(
389: px_log_id => l_sales_lead_log_id ,
390: p_sales_lead_id => p_sales_lead_id,
391: p_created_by => fnd_global.user_id,
392: p_creation_date => SYSDATE,

Line 2097: AS_SALES_LEADS_LOG_PKG.Insert_Row(

2093:
2094:
2095: IF p_process_type = G_LEAD_RATING
2096: THEN
2097: AS_SALES_LEADS_LOG_PKG.Insert_Row(
2098: px_log_id => l_sales_lead_log_id ,
2099: p_sales_lead_id => p_sales_lead_id,
2100: p_created_by => fnd_global.user_id,
2101: p_creation_date => SYSDATE,

Line 2129: AS_SALES_LEADS_LOG_PKG.Insert_Row(

2125: -- ckapoor : disqualification project
2126: ELSIF p_process_type = G_LEAD_QUALIFICATION -- qualification case
2127: THEN
2128:
2129: AS_SALES_LEADS_LOG_PKG.Insert_Row(
2130: px_log_id => l_sales_lead_log_id ,
2131: p_sales_lead_id => p_sales_lead_id,
2132: p_created_by => fnd_global.user_id,
2133: p_creation_date => SYSDATE,

Line 2207: AS_SALES_LEADS_LOG_PKG.Insert_Row(

2203: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
2204: p_msg_name => 'AS_NO_DEFAULT_RATING');
2205: END IF;
2206:
2207: AS_SALES_LEADS_LOG_PKG.Insert_Row(
2208: px_log_id => l_sales_lead_log_id ,
2209: p_sales_lead_id => p_sales_lead_id,
2210: p_created_by => fnd_global.user_id,
2211: p_creation_date => SYSDATE,

Line 3097: FROM as_sales_leads_log

3093: -- swkhanna Jun17,03
3094: -- also added lead_rank_id in select clause
3095: CURSOR C_Get_Log(C_Sales_Lead_Id NUMBER) IS
3096: SELECT creation_date, assign_to_salesforce_id, lead_rank_id
3097: FROM as_sales_leads_log
3098: WHERE sales_lead_id = c_sales_lead_id
3099: ORDER BY log_id DESC;
3100:
3101: BEGIN