DBA Data[Home] [Help]

APPS.AS_OPP_COPY_PVT dependencies on FND_PROFILE

Line 70: l_default_status VARCHAR2(30) := fnd_profile.value('AS_OPP_STATUS');

66: l_identity_sales_member_rec AS_SALES_MEMBER_PUB.Sales_member_rec_Type;
67: l_access_profile_rec AS_ACCESS_PUB.Access_Profile_Rec_Type;
68: l_customer_id NUMBER;
69: l_new_status VARCHAR2(30);
70: l_default_status VARCHAR2(30) := fnd_profile.value('AS_OPP_STATUS');
71: l_new_total_amount NUMBER;
72: l_TOT_REVENUE_OPP_FORECAST_AMT NUMBER := NULL; -- Added for ASNB
73:
74: l_sales_credit_tbl AS_OPPORTUNITY_PUB.Sales_Credit_Tbl_type;

Line 77: l_forecast_credit_type_id NUMBER := FND_PROFILE.Value('AS_FORECAST_CREDIT_TYPE_ID');

73:
74: l_sales_credit_tbl AS_OPPORTUNITY_PUB.Sales_Credit_Tbl_type;
75: l_sales_credit_rec AS_OPPORTUNITY_PUB.Sales_Credit_Rec_type;
76: x_sales_credit_out_tbl AS_OPPORTUNITY_PUB.Sales_Credit_Out_Tbl_Type;
77: l_forecast_credit_type_id NUMBER := FND_PROFILE.Value('AS_FORECAST_CREDIT_TYPE_ID');
78: l_val NUMBER;
79: l_date DATE;
80: l_copy_opp_lines VARCHAR2(1) := p_copy_opp_lines;
81: l_cre_st_for_sc_flag VARCHAR2(1) := 'N';

Line 344: -- l_header_rec.ORG_ID := FND_PROFILE.Value('DEFAULT_ORG_ID');

340: l_header_rec.OWNER_SALESFORCE_ID := hdr.OWNER_SALESFORCE_ID;
341: l_header_rec.OWNER_SALES_GROUP_ID := hdr.OWNER_SALES_GROUP_ID;
342: --l_header_rec.OWNER_ASSIGN_DATE := hdr.OWNER_ASSIGN_DATE;
343: --l_header_rec.ORG_ID := hdr.ORG_ID; commented for bug 5477698
344: -- l_header_rec.ORG_ID := FND_PROFILE.Value('DEFAULT_ORG_ID');
345: l_header_rec.ORG_ID := MO_UTILS.get_default_org_id; -- added for bug 5219495
346: l_header_rec.NO_OPP_ALLOWED_FLAG := hdr.NO_OPP_ALLOWED_FLAG;
347: l_header_rec.DELETE_ALLOWED_FLAG := hdr.DELETE_ALLOWED_FLAG;
348: l_header_rec.ATTRIBUTE_CATEGORY := hdr.ATTRIBUTE_CATEGORY;

Line 445: IF ((p_copy_Salesteam <> 'Y') AND (p_copy_sales_credits = 'Y') AND ( FND_PROFILE.Value('AS_ENFORCE_SALES_TEAM') = 'Y')) THEN

441: END LOOP;
442:
443: -- Bug 3426788
444: -- Add the persons having sales credits to the sales team if profile is ON
445: IF ((p_copy_Salesteam <> 'Y') AND (p_copy_sales_credits = 'Y') AND ( FND_PROFILE.Value('AS_ENFORCE_SALES_TEAM') = 'Y')) THEN
446: l_cre_st_for_sc_flag := 'Y';
447: END IF;
448:
449: --

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

505: l_Sales_Team_Rec.Partner_Cont_Party_Id := str.partner_cont_party_id;
506: l_Sales_Team_Rec.Salesforce_Role_Code := str.salesforce_role_code;
507: l_Sales_Team_Rec.Salesforce_Relationship_Code := str.salesforce_relationship_code;
508: -- Added for ASNB
509: IF nvl(fnd_profile.value('AS_ACTIVATE_SALES_INTEROP'), 'N') = 'Y' THEN
510: l_Sales_Team_Rec.contributor_flag := str.contributor_flag;
511: END IF;
512:
513: l_insert := true;

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

555: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
556: RAISE FND_API.G_EXC_ERROR;
557: END IF;
558: -- Begin Added for ASNB
559: IF nvl(fnd_profile.value('AS_ACTIVATE_SALES_INTEROP'), 'N') = 'Y' AND
560: P_Identity_Salesforce_Id = l_Sales_Team_Rec.salesforce_id AND
561: nvl(l_Sales_Team_Rec.contributor_flag,'N') = 'Y'
562: THEN
563: open c_log_user_in_salesTeam(x_lead_id,l_Sales_Team_Rec.salesforce_id,l_Sales_Team_Rec.sales_group_id);