DBA Data[Home] [Help]

APPS.BIM_I_LEAD_FACTS_PKG dependencies on FND_PROFILE

Line 337: l_conv_opp_status := nvl(FND_PROFILE.Value('AS_LEAD_LINK_STATUS'),'CONVERTED_TO_OPPORTUNITY');

333: -- Initialize API return status to SUCCESS
334: x_return_status := FND_API.G_RET_STS_SUCCESS;
335:
336: --Get status codes for 'opportunity created' and 'dead lead'
337: l_conv_opp_status := nvl(FND_PROFILE.Value('AS_LEAD_LINK_STATUS'),'CONVERTED_TO_OPPORTUNITY');
338: l_dead_status := nvl(FND_PROFILE.Value('AS_DEAD_LEAD_STATUS'),'DEAD_LEAD');
339:
340: --Find if the certification level is implemented or not
341: l_cert_level := nvl(FND_PROFILE.Value('HZ_DISPLAY_CERT_STATUS'),'NO');

Line 338: l_dead_status := nvl(FND_PROFILE.Value('AS_DEAD_LEAD_STATUS'),'DEAD_LEAD');

334: x_return_status := FND_API.G_RET_STS_SUCCESS;
335:
336: --Get status codes for 'opportunity created' and 'dead lead'
337: l_conv_opp_status := nvl(FND_PROFILE.Value('AS_LEAD_LINK_STATUS'),'CONVERTED_TO_OPPORTUNITY');
338: l_dead_status := nvl(FND_PROFILE.Value('AS_DEAD_LEAD_STATUS'),'DEAD_LEAD');
339:
340: --Find if the certification level is implemented or not
341: l_cert_level := nvl(FND_PROFILE.Value('HZ_DISPLAY_CERT_STATUS'),'NO');
342:

Line 341: l_cert_level := nvl(FND_PROFILE.Value('HZ_DISPLAY_CERT_STATUS'),'NO');

337: l_conv_opp_status := nvl(FND_PROFILE.Value('AS_LEAD_LINK_STATUS'),'CONVERTED_TO_OPPORTUNITY');
338: l_dead_status := nvl(FND_PROFILE.Value('AS_DEAD_LEAD_STATUS'),'DEAD_LEAD');
339:
340: --Find if the certification level is implemented or not
341: l_cert_level := nvl(FND_PROFILE.Value('HZ_DISPLAY_CERT_STATUS'),'NO');
342:
343:
344:
345: /* Dropping INdexes */

Line 894: l_conv_opp_status := nvl(FND_PROFILE.Value('AS_LEAD_LINK_STATUS'),'CONVERTED_TO_OPPORTUNITY');

890: -- Initialize API return status to SUCCESS
891: x_return_status := FND_API.G_RET_STS_SUCCESS;
892:
893: --Get status codes for 'opportunity created' and 'dead lead'
894: l_conv_opp_status := nvl(FND_PROFILE.Value('AS_LEAD_LINK_STATUS'),'CONVERTED_TO_OPPORTUNITY');
895: l_dead_status := nvl(FND_PROFILE.Value('AS_DEAD_LEAD_STATUS'),'DEAD_LEAD');
896:
897:
898: --Find if the certification level is implemented or not

Line 895: l_dead_status := nvl(FND_PROFILE.Value('AS_DEAD_LEAD_STATUS'),'DEAD_LEAD');

891: x_return_status := FND_API.G_RET_STS_SUCCESS;
892:
893: --Get status codes for 'opportunity created' and 'dead lead'
894: l_conv_opp_status := nvl(FND_PROFILE.Value('AS_LEAD_LINK_STATUS'),'CONVERTED_TO_OPPORTUNITY');
895: l_dead_status := nvl(FND_PROFILE.Value('AS_DEAD_LEAD_STATUS'),'DEAD_LEAD');
896:
897:
898: --Find if the certification level is implemented or not
899: l_cert_level := nvl(FND_PROFILE.Value('HZ_DISPLAY_CERT_STATUS'),'NO');

Line 899: l_cert_level := nvl(FND_PROFILE.Value('HZ_DISPLAY_CERT_STATUS'),'NO');

895: l_dead_status := nvl(FND_PROFILE.Value('AS_DEAD_LEAD_STATUS'),'DEAD_LEAD');
896:
897:
898: --Find if the certification level is implemented or not
899: l_cert_level := nvl(FND_PROFILE.Value('HZ_DISPLAY_CERT_STATUS'),'NO');
900:
901:
902: l_table_name := 'BIM_I_LEAD_FACTS';
903: bis_collection_utilities.log('Running Incremental Load of Lead Facts');