APPS.AS_SALES_LEAD_ASSIGN_PVT dependencies on AS_SALES_LEADS_LOG

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

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

Line 4484: AS_SALES_LEADS_LOG_PKG.Insert_Row(

4480: -- IF (AS_DEBUG_LOW_ON) THEN AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4481: -- 'Lead Status on Routing:'|| l_routing_status); END IF;
4482:
4483: -- Call API to create log entry
4484: AS_SALES_LEADS_LOG_PKG.Insert_Row(
4485: px_log_id => l_sales_lead_log_id ,
4486: p_sales_lead_id => p_sales_lead_id,
4487: p_created_by => fnd_global.user_id,
4488: p_creation_date => SYSDATE,

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

4805: -- code modified for bug12766399
4806: Set_Default_Lead_Owner(p_sales_lead_id, p_salesgroup_id,
4807: p_request_id,p_resource_id, x_return_status, x_msg_count, x_msg_data);
4808: ELSE
4809: -- Customer return owner, update AS_SALES_LEADS_LOG and
4810: -- AS_ACCESSES_ALL, AS_SALES_LEADS
4811: IF (AS_DEBUG_LOW_ON) THEN
4812: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4813: 'res id in upd=' || l_Resource_Id);

Line 4827: AS_SALES_LEADS_LOG_PKG.Insert_Row(

4823:
4824: -- l_routing_status := fnd_profile.value('AS_LEAD_ROUTING_STATUS');
4825:
4826: -- Call API to create log entry
4827: AS_SALES_LEADS_LOG_PKG.Insert_Row(
4828: px_log_id => l_sales_lead_log_id ,
4829: p_sales_lead_id => p_sales_lead_id,
4830: p_created_by => fnd_global.user_id,
4831: p_creation_date => SYSDATE,

Line 5164: AS_SALES_LEADS_LOG_PKG.Insert_Row(

5160:
5161: -- l_routing_status := fnd_profile.value('AS_LEAD_ROUTING_STATUS');
5162:
5163: -- Call API to create log entry
5164: AS_SALES_LEADS_LOG_PKG.Insert_Row(
5165: px_log_id => l_sales_lead_log_id ,
5166: p_sales_lead_id => p_sales_lead_id,
5167: p_created_by => fnd_global.user_id,
5168: p_creation_date => SYSDATE,

Line 5530: FROM AS_SALES_LEADS_LOG LOG

5526: WHERE ACC.SALES_LEAD_ID = c_sales_lead_id
5527: AND ACC.CREATED_BY_TAP_FLAG = 'Y'
5528: AND NOT EXISTS (
5529: SELECT 1
5530: FROM AS_SALES_LEADS_LOG LOG
5531: WHERE LOG.SALES_LEAD_ID = c_sales_lead_id
5532: AND LOG.ASSIGN_TO_SALESFORCE_ID = ACC.SALESFORCE_ID
5533: AND (LOG.ASSIGN_SALES_GROUP_ID = ACC.SALES_GROUP_ID
5534: OR LOG.ASSIGN_SALES_GROUP_ID IS NULL AND ACC.SALES_GROUP_ID IS NULL))

Line 5962: AS_SALES_LEADS_LOG_PKG.Insert_Row(

5958:
5959: -- l_routing_status := fnd_profile.value('AS_LEAD_ROUTING_STATUS');
5960:
5961: -- Call API to create log entry
5962: AS_SALES_LEADS_LOG_PKG.Insert_Row(
5963: px_log_id => l_sales_lead_log_id ,
5964: p_sales_lead_id => p_sales_lead_id,
5965: p_created_by => fnd_global.user_id,
5966: p_creation_date => SYSDATE,