455: -- Copy salesteam. At this point TAP/Owner logic has already run.
456: FOR str IN c_salesteam(p_lead_id,l_cre_st_for_sc_flag) LOOP
457:
458: l_Sales_Team_Rec.Last_Update_Date := SYSDATE;
459: l_Sales_Team_Rec.Last_Updated_By := FND_GLOBAL.User_Id;
460: l_Sales_Team_Rec.Creation_Date := SYSDATE;
461: l_Sales_Team_Rec.Created_By := FND_GLOBAL.User_Id;
462: l_Sales_Team_Rec.Last_Update_Login := FND_GLOBAL.Conc_Login_Id;
463: --l_Sales_Team_Rec.owner_flag := str.owner_flag;
457:
458: l_Sales_Team_Rec.Last_Update_Date := SYSDATE;
459: l_Sales_Team_Rec.Last_Updated_By := FND_GLOBAL.User_Id;
460: l_Sales_Team_Rec.Creation_Date := SYSDATE;
461: l_Sales_Team_Rec.Created_By := FND_GLOBAL.User_Id;
462: l_Sales_Team_Rec.Last_Update_Login := FND_GLOBAL.Conc_Login_Id;
463: --l_Sales_Team_Rec.owner_flag := str.owner_flag;
464: l_Sales_Team_Rec.Freeze_Flag := str.freeze_flag;
465: l_Sales_Team_Rec.Reassign_Flag := str.reassign_flag;
458: l_Sales_Team_Rec.Last_Update_Date := SYSDATE;
459: l_Sales_Team_Rec.Last_Updated_By := FND_GLOBAL.User_Id;
460: l_Sales_Team_Rec.Creation_Date := SYSDATE;
461: l_Sales_Team_Rec.Created_By := FND_GLOBAL.User_Id;
462: l_Sales_Team_Rec.Last_Update_Login := FND_GLOBAL.Conc_Login_Id;
463: --l_Sales_Team_Rec.owner_flag := str.owner_flag;
464: l_Sales_Team_Rec.Freeze_Flag := str.freeze_flag;
465: l_Sales_Team_Rec.Reassign_Flag := str.reassign_flag;
466: l_Sales_Team_Rec.Team_Leader_Flag := str.team_leader_flag;
637: -- Copy lines
638: AS_LEAD_LINES_PKG.Insert_Row(
639: px_LEAD_LINE_ID => l_LEAD_LINE_ID,
640: p_LAST_UPDATE_DATE => SYSDATE,
641: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
642: p_CREATION_DATE => SYSDATE,
643: p_CREATED_BY => FND_GLOBAL.USER_ID,
644: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,
645: p_REQUEST_ID => lr.REQUEST_ID,
639: px_LEAD_LINE_ID => l_LEAD_LINE_ID,
640: p_LAST_UPDATE_DATE => SYSDATE,
641: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
642: p_CREATION_DATE => SYSDATE,
643: p_CREATED_BY => FND_GLOBAL.USER_ID,
644: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,
645: p_REQUEST_ID => lr.REQUEST_ID,
646: p_PROGRAM_APPLICATION_ID => lr.PROGRAM_APPLICATION_ID,
647: p_PROGRAM_ID => lr.PROGRAM_ID,
640: p_LAST_UPDATE_DATE => SYSDATE,
641: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
642: p_CREATION_DATE => SYSDATE,
643: p_CREATED_BY => FND_GLOBAL.USER_ID,
644: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,
645: p_REQUEST_ID => lr.REQUEST_ID,
646: p_PROGRAM_APPLICATION_ID => lr.PROGRAM_APPLICATION_ID,
647: p_PROGRAM_ID => lr.PROGRAM_ID,
648: p_PROGRAM_UPDATE_DATE => lr.PROGRAM_UPDATE_DATE,
710: l_sales_credit_id := null;
711: AS_SALES_CREDITS_PKG.Insert_Row(
712: px_SALES_CREDIT_ID => l_SALES_CREDIT_ID,
713: p_LAST_UPDATE_DATE => SYSDATE,
714: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
715: p_CREATION_DATE => SYSDATE,
716: p_CREATED_BY => FND_GLOBAL.USER_ID,
717: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,
718: p_REQUEST_ID => scr.REQUEST_ID,
712: px_SALES_CREDIT_ID => l_SALES_CREDIT_ID,
713: p_LAST_UPDATE_DATE => SYSDATE,
714: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
715: p_CREATION_DATE => SYSDATE,
716: p_CREATED_BY => FND_GLOBAL.USER_ID,
717: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,
718: p_REQUEST_ID => scr.REQUEST_ID,
719: p_PROGRAM_APPLICATION_ID => scr.PROGRAM_APPLICATION_ID,
720: p_PROGRAM_ID => scr.PROGRAM_ID,
713: p_LAST_UPDATE_DATE => SYSDATE,
714: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
715: p_CREATION_DATE => SYSDATE,
716: p_CREATED_BY => FND_GLOBAL.USER_ID,
717: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,
718: p_REQUEST_ID => scr.REQUEST_ID,
719: p_PROGRAM_APPLICATION_ID => scr.PROGRAM_APPLICATION_ID,
720: p_PROGRAM_ID => scr.PROGRAM_ID,
721: p_PROGRAM_UPDATE_DATE => scr.PROGRAM_UPDATE_DATE,
788: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
789: END IF;
790:
791: l_sales_credit_rec.last_update_date := SYSDATE;
792: l_sales_credit_rec.last_updated_by := FND_GLOBAL.USER_ID;
793: l_sales_credit_rec.creation_Date := SYSDATE;
794: l_sales_credit_rec.created_by := FND_GLOBAL.USER_ID;
795: l_sales_credit_rec.last_update_login := FND_GLOBAL.CONC_LOGIN_ID;
796: l_sales_credit_rec.lead_id := x_lead_id;
790:
791: l_sales_credit_rec.last_update_date := SYSDATE;
792: l_sales_credit_rec.last_updated_by := FND_GLOBAL.USER_ID;
793: l_sales_credit_rec.creation_Date := SYSDATE;
794: l_sales_credit_rec.created_by := FND_GLOBAL.USER_ID;
795: l_sales_credit_rec.last_update_login := FND_GLOBAL.CONC_LOGIN_ID;
796: l_sales_credit_rec.lead_id := x_lead_id;
797: l_sales_credit_rec.lead_line_id := l_LEAD_LINE_ID;
798: l_sales_credit_rec.salesforce_id := l_identity_sales_member_rec.salesforce_id;
791: l_sales_credit_rec.last_update_date := SYSDATE;
792: l_sales_credit_rec.last_updated_by := FND_GLOBAL.USER_ID;
793: l_sales_credit_rec.creation_Date := SYSDATE;
794: l_sales_credit_rec.created_by := FND_GLOBAL.USER_ID;
795: l_sales_credit_rec.last_update_login := FND_GLOBAL.CONC_LOGIN_ID;
796: l_sales_credit_rec.lead_id := x_lead_id;
797: l_sales_credit_rec.lead_line_id := l_LEAD_LINE_ID;
798: l_sales_credit_rec.salesforce_id := l_identity_sales_member_rec.salesforce_id;
799: l_sales_credit_rec.person_id := l_identity_sales_member_rec.employee_person_id;
887: p_COMPETITOR_PRODUCT_ID => cpdr.COMPETITOR_PRODUCT_ID,
888: p_LEAD_LINE_ID => l_LEAD_LINE_ID,
889: p_LEAD_ID => x_LEAD_ID,
890: px_LEAD_COMPETITOR_PROD_ID => l_LEAD_COMPETITOR_PROD_ID,
891: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,
892: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
893: p_LAST_UPDATE_DATE => SYSDATE,
894: p_CREATED_BY => FND_GLOBAL.USER_ID,
895: p_CREATION_DATE => SYSDATE);
888: p_LEAD_LINE_ID => l_LEAD_LINE_ID,
889: p_LEAD_ID => x_LEAD_ID,
890: px_LEAD_COMPETITOR_PROD_ID => l_LEAD_COMPETITOR_PROD_ID,
891: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,
892: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
893: p_LAST_UPDATE_DATE => SYSDATE,
894: p_CREATED_BY => FND_GLOBAL.USER_ID,
895: p_CREATION_DATE => SYSDATE);
896:
890: px_LEAD_COMPETITOR_PROD_ID => l_LEAD_COMPETITOR_PROD_ID,
891: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,
892: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
893: p_LAST_UPDATE_DATE => SYSDATE,
894: p_CREATED_BY => FND_GLOBAL.USER_ID,
895: p_CREATION_DATE => SYSDATE);
896:
897: IF l_lead_competitor_prod_id is null THEN
898: IF l_debug THEN
938: p_DECISION_PRIORITY_CODE => dfcr.DECISION_PRIORITY_CODE,
939: p_DECISION_FACTOR_CODE => dfcr.DECISION_FACTOR_CODE,
940: px_LEAD_DECISION_FACTOR_ID => l_LEAD_DECISION_FACTOR_ID,
941: p_LEAD_LINE_ID => l_LEAD_LINE_ID,
942: p_CREATE_BY => FND_GLOBAL.USER_ID,
943: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
944: p_LAST_UPDATE_DATE => SYSDATE,
945: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,
946: p_CREATION_DATE => SYSDATE);
939: p_DECISION_FACTOR_CODE => dfcr.DECISION_FACTOR_CODE,
940: px_LEAD_DECISION_FACTOR_ID => l_LEAD_DECISION_FACTOR_ID,
941: p_LEAD_LINE_ID => l_LEAD_LINE_ID,
942: p_CREATE_BY => FND_GLOBAL.USER_ID,
943: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
944: p_LAST_UPDATE_DATE => SYSDATE,
945: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,
946: p_CREATION_DATE => SYSDATE);
947:
941: p_LEAD_LINE_ID => l_LEAD_LINE_ID,
942: p_CREATE_BY => FND_GLOBAL.USER_ID,
943: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
944: p_LAST_UPDATE_DATE => SYSDATE,
945: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,
946: p_CREATION_DATE => SYSDATE);
947:
948: IF l_lead_decision_factor_id is null THEN
949: IF l_debug THEN
975: px_LEAD_CONTACT_ID => l_LEAD_CONTACT_ID,
976: p_LEAD_ID => x_LEAD_ID,
977: p_CONTACT_ID => cnr.CONTACT_ID,
978: p_LAST_UPDATE_DATE => SYSDATE,
979: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
980: p_CREATION_DATE => SYSDATE,
981: p_CREATED_BY => FND_GLOBAL.USER_ID,
982: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,
983: p_REQUEST_ID => cnr.REQUEST_ID,
977: p_CONTACT_ID => cnr.CONTACT_ID,
978: p_LAST_UPDATE_DATE => SYSDATE,
979: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
980: p_CREATION_DATE => SYSDATE,
981: p_CREATED_BY => FND_GLOBAL.USER_ID,
982: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,
983: p_REQUEST_ID => cnr.REQUEST_ID,
984: p_PROGRAM_APPLICATION_ID => cnr.PROGRAM_APPLICATION_ID,
985: p_PROGRAM_ID => cnr.PROGRAM_ID,
978: p_LAST_UPDATE_DATE => SYSDATE,
979: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
980: p_CREATION_DATE => SYSDATE,
981: p_CREATED_BY => FND_GLOBAL.USER_ID,
982: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,
983: p_REQUEST_ID => cnr.REQUEST_ID,
984: p_PROGRAM_APPLICATION_ID => cnr.PROGRAM_APPLICATION_ID,
985: p_PROGRAM_ID => cnr.PROGRAM_ID,
986: p_PROGRAM_UPDATE_DATE => cnr.PROGRAM_UPDATE_DATE,
1037: IF (cmpr.COMPETITOR_ID <> nvl(l_close_competitor_id, -1)) THEN
1038: AS_LEAD_COMPETITORS_PKG.Insert_Row(
1039: px_LEAD_COMPETITOR_ID => l_LEAD_COMPETITOR_ID,
1040: p_LAST_UPDATE_DATE => SYSDATE,
1041: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
1042: p_CREATION_DATE => SYSDATE,
1043: p_CREATED_BY => FND_GLOBAL.USER_ID,
1044: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,
1045: p_REQUEST_ID => cmpr.REQUEST_ID,
1039: px_LEAD_COMPETITOR_ID => l_LEAD_COMPETITOR_ID,
1040: p_LAST_UPDATE_DATE => SYSDATE,
1041: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
1042: p_CREATION_DATE => SYSDATE,
1043: p_CREATED_BY => FND_GLOBAL.USER_ID,
1044: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,
1045: p_REQUEST_ID => cmpr.REQUEST_ID,
1046: p_PROGRAM_APPLICATION_ID =>cmpr.PROGRAM_APPLICATION_ID,
1047: p_PROGRAM_ID => cmpr.PROGRAM_ID,
1040: p_LAST_UPDATE_DATE => SYSDATE,
1041: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
1042: p_CREATION_DATE => SYSDATE,
1043: p_CREATED_BY => FND_GLOBAL.USER_ID,
1044: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,
1045: p_REQUEST_ID => cmpr.REQUEST_ID,
1046: p_PROGRAM_APPLICATION_ID =>cmpr.PROGRAM_APPLICATION_ID,
1047: p_PROGRAM_ID => cmpr.PROGRAM_ID,
1048: p_PROGRAM_UPDATE_DATE => cmpr.PROGRAM_UPDATE_DATE,