DBA Data[Home] [Help]

APPS.AS_OPP_COPY_PVT dependencies on FND_GLOBAL

Line 459: l_Sales_Team_Rec.Last_Updated_By := FND_GLOBAL.User_Id;

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;

Line 461: l_Sales_Team_Rec.Created_By := FND_GLOBAL.User_Id;

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;

Line 462: l_Sales_Team_Rec.Last_Update_Login := FND_GLOBAL.Conc_Login_Id;

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;

Line 641: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,

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,

Line 643: p_CREATED_BY => FND_GLOBAL.USER_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,

Line 644: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_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,

Line 714: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,

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,

Line 716: p_CREATED_BY => FND_GLOBAL.USER_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,

Line 717: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_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,

Line 792: l_sales_credit_rec.last_updated_by := FND_GLOBAL.USER_ID;

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;

Line 794: l_sales_credit_rec.created_by := FND_GLOBAL.USER_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;

Line 795: l_sales_credit_rec.last_update_login := FND_GLOBAL.CONC_LOGIN_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;

Line 891: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_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);

Line 892: p_LAST_UPDATED_BY => FND_GLOBAL.USER_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);
896:

Line 894: p_CREATED_BY => FND_GLOBAL.USER_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:
897: IF l_lead_competitor_prod_id is null THEN
898: IF l_debug THEN

Line 942: p_CREATE_BY => FND_GLOBAL.USER_ID,

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);

Line 943: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,

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:

Line 945: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_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:
948: IF l_lead_decision_factor_id is null THEN
949: IF l_debug THEN

Line 979: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,

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,

Line 981: p_CREATED_BY => FND_GLOBAL.USER_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,

Line 982: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_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,

Line 1041: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,

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,

Line 1043: p_CREATED_BY => FND_GLOBAL.USER_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,

Line 1044: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_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,