DBA Data[Home] [Help]

APPS.AS_SALES_LEAD_OPP_PVT dependencies on FND_PROFILE

Line 1117: l_Sales_Lead_Rec.Status_Code := nvl(FND_PROFILE.Value('AS_LEAD_LINK_STATUS'),'CONVERTED_TO_OPPORTUNITY');

1113: raise FND_API.G_EXC_ERROR;
1114: END IF;
1115: */
1116:
1117: l_Sales_Lead_Rec.Status_Code := nvl(FND_PROFILE.Value('AS_LEAD_LINK_STATUS'),'CONVERTED_TO_OPPORTUNITY');
1118: -- has to be changed once the profile problem is solved
1119: --l_Sales_Lead_Rec.Status_Code := 'QUALIFIED';
1120:
1121:

Line 2054: l_Sales_Lead_Rec.Status_Code := nvl(FND_PROFILE.Value('AS_LEAD_LINK_STATUS'),'CONVERTED_TO_OPPORTUNITY');

2050: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2051: raise FND_API.G_EXC_ERROR;
2052: END IF;
2053:
2054: l_Sales_Lead_Rec.Status_Code := nvl(FND_PROFILE.Value('AS_LEAD_LINK_STATUS'),'CONVERTED_TO_OPPORTUNITY');
2055: -- has to be changed once the profile problem is solved
2056: --l_Sales_Lead_Rec.Status_Code := 'QUALIFIED';
2057:
2058: -- Validate if the sales lead owner is the opportunity team leader

Line 2753: IF nvl(fnd_profile.value('AS_ACTIVATE_SALES_INTEROP'), 'N') = 'Y' THEN

2749: RAISE FND_API.G_EXC_ERROR;
2750: END IF;
2751:
2752: -- Begin Added for Bug#3613374
2753: IF nvl(fnd_profile.value('AS_ACTIVATE_SALES_INTEROP'), 'N') = 'Y' THEN
2754: CHECK_SALES_STAGE(
2755: p_api_version_number => 2.0
2756: ,p_init_msg_list => FND_API.G_FALSE
2757: ,p_validation_level => p_validation_level

Line 3184: --l_SL_Rec.Status_Code := nvl(FND_PROFILE.Value('AS_LEAD_LINK_STATUS'),'QUALIFIED');

3180: l_SL_Rec.Sales_Lead_Id := p_Sales_Lead_Id;
3181: l_SL_Rec.last_update_date := l_last_update_date;
3182:
3183: -- has to be changed once the profile problem is solved
3184: --l_SL_Rec.Status_Code := nvl(FND_PROFILE.Value('AS_LEAD_LINK_STATUS'),'QUALIFIED');
3185: l_SL_Rec.Status_Code := nvl(FND_PROFILE.Value('AS_LEAD_LINK_STATUS'),'CONVERTED_TO_OPPORTUNITY');
3186: --l_SL_Rec.Status_Code := 'QUALIFIED';
3187:
3188: l_SL_Rec.assign_to_salesforce_id

Line 3185: l_SL_Rec.Status_Code := nvl(FND_PROFILE.Value('AS_LEAD_LINK_STATUS'),'CONVERTED_TO_OPPORTUNITY');

3181: l_SL_Rec.last_update_date := l_last_update_date;
3182:
3183: -- has to be changed once the profile problem is solved
3184: --l_SL_Rec.Status_Code := nvl(FND_PROFILE.Value('AS_LEAD_LINK_STATUS'),'QUALIFIED');
3185: l_SL_Rec.Status_Code := nvl(FND_PROFILE.Value('AS_LEAD_LINK_STATUS'),'CONVERTED_TO_OPPORTUNITY');
3186: --l_SL_Rec.Status_Code := 'QUALIFIED';
3187:
3188: l_SL_Rec.assign_to_salesforce_id
3189: := l_Sales_Lead_Rec.assign_to_salesforce_id;

Line 3276: IF nvl(FND_PROFILE.Value('AS_LEADLINK_MOVE_ST'), 'N') = 'Y' THEN

3272: raise FND_API.G_EXC_ERROR;
3273: END IF;
3274:
3275: -- ffang 051602, bug 2278318, copy lead's sales team to oppty
3276: IF nvl(FND_PROFILE.Value('AS_LEADLINK_MOVE_ST'), 'N') = 'Y' THEN
3277: FOR ST IN c_get_lead_salesteam (P_Sales_Lead_Id)
3278: LOOP
3279: l_sales_team_rec.freeze_flag := ST.freeze_flag;
3280: l_sales_team_rec.reassign_flag := ST.reassign_flag;

Line 3379: IF nvl(fnd_profile.value('AS_ACTIVATE_SALES_INTEROP'), 'N') = 'Y'

3375: NULL;
3376: END IF;
3377: --Enhancement related Bug#3913225 @ @ Callling the procedure Copy_Attachments--changes for ASN.B--End--
3378: -- Start Bug#3966128
3379: IF nvl(fnd_profile.value('AS_ACTIVATE_SALES_INTEROP'), 'N') = 'Y'
3380: AND l_Sales_Lead_Rec.incumbent_partner_party_id IS NOT NULL
3381: AND l_Sales_Lead_Rec.incumbent_partner_resource_id IS NOT NULL
3382: THEN
3383: open c_address_id(l_Sales_Lead_Rec.incumbent_partner_party_id);

Line 3605: l_sales_methodology_id := to_number(FND_PROFILE.VALUE ('AS_SALES_METHODOLOGY'));

3601:
3602: l_sales_methodology_id := P_sales_lead_methodology_id;
3603: l_sales_stage_id := P_sales_lead_stage_id;
3604: IF l_sales_methodology_id IS NULL THEN
3605: l_sales_methodology_id := to_number(FND_PROFILE.VALUE ('AS_SALES_METHODOLOGY'));
3606: l_sales_stage_id := to_number(FND_PROFILE.VALUE ('AS_OPP_SALES_STAGE'));
3607: END IF;
3608:
3609: IF l_sales_methodology_id IS NULL THEN

Line 3606: l_sales_stage_id := to_number(FND_PROFILE.VALUE ('AS_OPP_SALES_STAGE'));

3602: l_sales_methodology_id := P_sales_lead_methodology_id;
3603: l_sales_stage_id := P_sales_lead_stage_id;
3604: IF l_sales_methodology_id IS NULL THEN
3605: l_sales_methodology_id := to_number(FND_PROFILE.VALUE ('AS_SALES_METHODOLOGY'));
3606: l_sales_stage_id := to_number(FND_PROFILE.VALUE ('AS_OPP_SALES_STAGE'));
3607: END IF;
3608:
3609: IF l_sales_methodology_id IS NULL THEN
3610: l_sales_stage_id := NULL;