APPS.AS_SALES_LEAD_ASSIGN_PVT dependencies on AS_SALES_LEADS_LOG

Line 4289: | AS_SALES_LEADS_LOG, AS_SALES_LEADS, AS_ACCESSES_ALL will be updated.

4285: | NOTES
4286: | This procedure will get resource_id from the profile
4287: | AS_DEFAULT_RESOURCE_ID. If this profile is not set, it will get
4288: | current user's resource_id. Once resource_id is gotten
4289: | AS_SALES_LEADS_LOG, AS_SALES_LEADS, AS_ACCESSES_ALL will be updated.
4290: |
4291: | HISTORY
4292: | 12/05/01 SOLIN Created
4293: *-------------------------------------------------------------------------*/

Line 4462: AS_SALES_LEADS_LOG_PKG.Insert_Row(

4458: -- IF (AS_DEBUG_LOW_ON) THEN AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4459: -- 'Lead Status on Routing:'|| l_routing_status); END IF;
4460:
4461: -- Call API to create log entry
4462: AS_SALES_LEADS_LOG_PKG.Insert_Row(
4463: px_log_id => l_sales_lead_log_id ,
4464: p_sales_lead_id => p_sales_lead_id,
4465: p_created_by => fnd_global.user_id,
4466: p_creation_date => SYSDATE,

Line 4785: -- Customer return owner, update AS_SALES_LEADS_LOG and

4781: -- user decides to use default resource.
4782: Set_Default_Lead_Owner(p_sales_lead_id, p_salesgroup_id,
4783: p_request_id, x_return_status, x_msg_count, x_msg_data);
4784: ELSE
4785: -- Customer return owner, update AS_SALES_LEADS_LOG and
4786: -- AS_ACCESSES_ALL, AS_SALES_LEADS
4787: IF (AS_DEBUG_LOW_ON) THEN
4788: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4789: 'res id in upd=' || l_Resource_Id);

Line 4803: AS_SALES_LEADS_LOG_PKG.Insert_Row(

4799:
4800: -- l_routing_status := fnd_profile.value('AS_LEAD_ROUTING_STATUS');
4801:
4802: -- Call API to create log entry
4803: AS_SALES_LEADS_LOG_PKG.Insert_Row(
4804: px_log_id => l_sales_lead_log_id ,
4805: p_sales_lead_id => p_sales_lead_id,
4806: p_created_by => fnd_global.user_id,
4807: p_creation_date => SYSDATE,

Line 5140: AS_SALES_LEADS_LOG_PKG.Insert_Row(

5136:
5137: -- l_routing_status := fnd_profile.value('AS_LEAD_ROUTING_STATUS');
5138:
5139: -- Call API to create log entry
5140: AS_SALES_LEADS_LOG_PKG.Insert_Row(
5141: px_log_id => l_sales_lead_log_id ,
5142: p_sales_lead_id => p_sales_lead_id,
5143: p_created_by => fnd_global.user_id,
5144: p_creation_date => SYSDATE,

Line 5506: FROM AS_SALES_LEADS_LOG LOG

5502: WHERE ACC.SALES_LEAD_ID = c_sales_lead_id
5503: AND ACC.CREATED_BY_TAP_FLAG = 'Y'
5504: AND NOT EXISTS (
5505: SELECT 1
5506: FROM AS_SALES_LEADS_LOG LOG
5507: WHERE LOG.SALES_LEAD_ID = c_sales_lead_id
5508: AND LOG.ASSIGN_TO_SALESFORCE_ID = ACC.SALESFORCE_ID
5509: AND (LOG.ASSIGN_SALES_GROUP_ID = ACC.SALES_GROUP_ID
5510: OR LOG.ASSIGN_SALES_GROUP_ID IS NULL AND ACC.SALES_GROUP_ID IS NULL))

Line 5938: AS_SALES_LEADS_LOG_PKG.Insert_Row(

5934:
5935: -- l_routing_status := fnd_profile.value('AS_LEAD_ROUTING_STATUS');
5936:
5937: -- Call API to create log entry
5938: AS_SALES_LEADS_LOG_PKG.Insert_Row(
5939: px_log_id => l_sales_lead_log_id ,
5940: p_sales_lead_id => p_sales_lead_id,
5941: p_created_by => fnd_global.user_id,
5942: p_creation_date => SYSDATE,