APPS.AS_SALES_LEADS_PVT dependencies on AS_SALES_LEADS_LOG

Line 11: -- 08/31/2000 FFANG Add assign_to_salesforce_id to AS_SALES_LEADS_LOG

7: -- History :
8: -- 06/05/2000 FFANG Created.
9: -- 06/06/2000 FFANG ModIFied according data schema changes.
10: -- 08/30/2000 FFANG Add assign_to_salesforce_id to AS_SALES_LEADS
11: -- 08/31/2000 FFANG Add assign_to_salesforce_id to AS_SALES_LEADS_LOG
12: -- 09/20/2000 FFANG For bug 1406777, add different logics to
13: -- validate_sales_lead_id when calling from create or
14: -- update
15: -- 09/20/2000 FFANG For bug 1406761, add different logics to

Line 107: -- Set as_sales_leads_log.manual_rank_flag:

103: -- 12/17/2002 SOLIN Populate column lead_rank_ind:
104: -- 'U': lead is upgraded.
105: -- 'D': lead is downgraded.
106: -- 'N': none of above.
107: -- Set as_sales_leads_log.manual_rank_flag:
108: -- 'Y': user manually sets rank
109: -- 'N': rating engine sets rank
110: -- null: rank is not updated
111: -- 11/08/2004 BMUTHUKR Modified validate_status_close_reason procedure to fix bug 3931489.

Line 3903: 'Calling AS_SALES_LEADS_LOG_PKG.Insert_Row');

3899: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3900: 'xSalesLeadID is '||l_sales_lead_id);
3901:
3902: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3903: 'Calling AS_SALES_LEADS_LOG_PKG.Insert_Row');
3904: END IF;
3905:
3906: -- Call API to create log entry
3907:

Line 3908: AS_SALES_LEADS_LOG_PKG.Insert_Row(

3904: END IF;
3905:
3906: -- Call API to create log entry
3907:
3908: AS_SALES_LEADS_LOG_PKG.Insert_Row(
3909: px_log_id => l_sales_lead_log_id ,
3910: p_sales_lead_id => l_sales_lead_id,
3911: p_created_by => fnd_global.user_id,
3912: p_creation_date => sysdate,

Line 3943: AS_SALES_LEADS_LOG_PKG.Insert_Row(

3939: if ( l_SALES_LEAD_rec.REFERRAL_TYPE is not null and l_sales_lead_rec.REFERRAL_TYPE <> FND_API.G_MISS_CHAR) then
3940:
3941: l_sales_lead_log_id := null;
3942:
3943: AS_SALES_LEADS_LOG_PKG.Insert_Row(
3944: px_log_id => l_sales_lead_log_id ,
3945: p_sales_lead_id => l_sales_lead_id,
3946: p_created_by => fnd_global.user_id,
3947: p_creation_date => sysdate,

Line 4464: FROM as_sales_leads_log

4460: where decision_timeframe_code = X_DECISION_TIMEFRAME_CODE and enabled_flag = 'Y';
4461:
4462: CURSOR C_get_last_system_rank (c_sales_lead_id NUMBER) IS
4463: SELECT lead_rank_id
4464: FROM as_sales_leads_log
4465: WHERE sales_lead_id = c_sales_lead_id
4466: AND manual_rank_flag = 'N'
4467: ORDER BY log_id DESC;
4468:

Line 5586: 'Calling AS_SALES_LEADS_LOG_PKG.Insert_Row');

5582: -- Debug Message
5583: IF (AS_DEBUG_LOW_ON) THEN
5584:
5585: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
5586: 'Calling AS_SALES_LEADS_LOG_PKG.Insert_Row');
5587: END IF;
5588:
5589: -- Call API to create log entry
5590: AS_SALES_LEADS_LOG_PKG.Insert_Row(

Line 5590: AS_SALES_LEADS_LOG_PKG.Insert_Row(

5586: 'Calling AS_SALES_LEADS_LOG_PKG.Insert_Row');
5587: END IF;
5588:
5589: -- Call API to create log entry
5590: AS_SALES_LEADS_LOG_PKG.Insert_Row(
5591: px_log_id => l_sales_lead_log_id ,
5592: p_sales_lead_id => l_tar_sales_lead_rec.sales_lead_id,
5593: p_created_by => fnd_global.user_id,
5594: p_creation_date => sysdate,

Line 5633: 'Not Calling AS_SALES_LEADS_LOG_PKG.Insert_Row');

5629: -- Debug Message
5630: IF (AS_DEBUG_LOW_ON) THEN
5631:
5632: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
5633: 'Not Calling AS_SALES_LEADS_LOG_PKG.Insert_Row');
5634: END IF;
5635:
5636: */
5637: END IF;

Line 5651: AS_SALES_LEADS_LOG_PKG.Insert_Row(

5647: then
5648:
5649: l_sales_lead_log_id := null;
5650:
5651: AS_SALES_LEADS_LOG_PKG.Insert_Row(
5652: px_log_id => l_sales_lead_log_id ,
5653: p_sales_lead_id => l_tar_sales_lead_rec.sales_lead_id,
5654: p_created_by => fnd_global.user_id,
5655: p_creation_date => sysdate,