44: IS
45: l_api_name CONSTANT VARCHAR2(30) := 'Copy_Opportunity';
46: l_api_version_number CONSTANT NUMBER := 2.0;
47:
48: l_header_rec AS_OPPORTUNITY_PUB.Header_Rec_Type;
49: l_line_tbl AS_OPPORTUNITY_PUB.Line_Tbl_Type;
50: l_Sales_Team_Rec AS_ACCESS_PUB.Sales_Team_Rec_Type;
51:
52: l_index NUMBER;
45: l_api_name CONSTANT VARCHAR2(30) := 'Copy_Opportunity';
46: l_api_version_number CONSTANT NUMBER := 2.0;
47:
48: l_header_rec AS_OPPORTUNITY_PUB.Header_Rec_Type;
49: l_line_tbl AS_OPPORTUNITY_PUB.Line_Tbl_Type;
50: l_Sales_Team_Rec AS_ACCESS_PUB.Sales_Team_Rec_Type;
51:
52: l_index NUMBER;
53: l_lead_number NUMBER;
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;
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;
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;
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;
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;
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;
226: END IF;
227:
228: IF(P_Check_Access_Flag = 'Y') THEN
229: -- Call Get_Access_Profiles to get access_profile_rec
230: AS_OPPORTUNITY_PUB.Get_Access_Profiles(
231: p_profile_tbl => p_profile_tbl,
232: x_access_profile_rec => l_access_profile_rec);
233:
234: OPEN c_customer(p_lead_id);
401: END IF;
402:
403: -- Calling Private package: Create_OPP_HEADER
404: -- Hint: Primary key needs to be returned
405: AS_OPPORTUNITY_PUB.Create_opp_header(
406: P_Api_Version_Number => 2.0,
407: P_Init_Msg_List => FND_API.G_FALSE,
408: P_Commit => FND_API.G_FALSE,
409: P_Validation_Level => P_Validation_Level,