22: P_Admin_Group_Id IN NUMBER,
23: P_Identity_Salesforce_Id IN VARCHAR2 := FND_API.G_FALSE,
24: P_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE,
25: P_Partner_Cont_Party_id IN NUMBER := FND_API.G_MISS_NUM,
26: P_Contact_Tbl IN AS_OPPORTUNITY_PUB.Contact_Tbl_Type :=
27: AS_OPPORTUNITY_PUB.G_MISS_Contact_Tbl,
28: X_contact_out_tbl OUT NOCOPY AS_OPPORTUNITY_PUB.contact_out_tbl_type,
29: X_Return_Status OUT NOCOPY VARCHAR2,
30: X_Msg_Count OUT NOCOPY NUMBER,
23: P_Identity_Salesforce_Id IN VARCHAR2 := FND_API.G_FALSE,
24: P_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE,
25: P_Partner_Cont_Party_id IN NUMBER := FND_API.G_MISS_NUM,
26: P_Contact_Tbl IN AS_OPPORTUNITY_PUB.Contact_Tbl_Type :=
27: AS_OPPORTUNITY_PUB.G_MISS_Contact_Tbl,
28: X_contact_out_tbl OUT NOCOPY AS_OPPORTUNITY_PUB.contact_out_tbl_type,
29: X_Return_Status OUT NOCOPY VARCHAR2,
30: X_Msg_Count OUT NOCOPY NUMBER,
31: X_Msg_Data OUT NOCOPY VARCHAR2
24: P_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE,
25: P_Partner_Cont_Party_id IN NUMBER := FND_API.G_MISS_NUM,
26: P_Contact_Tbl IN AS_OPPORTUNITY_PUB.Contact_Tbl_Type :=
27: AS_OPPORTUNITY_PUB.G_MISS_Contact_Tbl,
28: X_contact_out_tbl OUT NOCOPY AS_OPPORTUNITY_PUB.contact_out_tbl_type,
29: X_Return_Status OUT NOCOPY VARCHAR2,
30: X_Msg_Count OUT NOCOPY NUMBER,
31: X_Msg_Data OUT NOCOPY VARCHAR2
32: )
35: l_api_name CONSTANT VARCHAR2(30) := 'Create_opp_contacts';
36: l_api_version_number CONSTANT NUMBER := 2.0;
37: l_return_status_full VARCHAR2(1);
38: l_identity_sales_member_rec AS_SALES_MEMBER_PUB.Sales_member_rec_Type;
39: l_CONTACT_Rec AS_OPPORTUNITY_PUB.CONTACT_Rec_Type;
40: l_LEAD_CONTACT_ID NUMBER;
41: l_line_count CONSTANT NUMBER := P_CONTACT_Tbl.count;
42: l_update_access_flag VARCHAR2(1);
43: l_access_profile_rec AS_ACCESS_PUB.Access_Profile_Rec_Type;
143: END IF;
144:
145:
146: -- Call Get_Access_Profiles to get access_profile_rec
147: AS_OPPORTUNITY_PUB.Get_Access_Profiles(
148: p_profile_tbl => p_profile_tbl,
149: x_access_profile_rec => l_access_profile_rec);
150:
151: AS_ACCESS_PUB.has_updateOpportunityAccess
400: P_Admin_Group_Id IN NUMBER,
401: P_Identity_Salesforce_Id IN NUMBER,
402: P_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE,
403: P_Partner_Cont_Party_id IN NUMBER := FND_API.G_MISS_NUM,
404: P_Contact_Tbl IN AS_OPPORTUNITY_PUB.Contact_Tbl_Type,
405: X_contact_out_tbl OUT NOCOPY AS_OPPORTUNITY_PUB.contact_out_tbl_type,
406: X_Return_Status OUT NOCOPY VARCHAR2,
407: X_Msg_Count OUT NOCOPY NUMBER,
408: X_Msg_Data OUT NOCOPY VARCHAR2
401: P_Identity_Salesforce_Id IN NUMBER,
402: P_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE,
403: P_Partner_Cont_Party_id IN NUMBER := FND_API.G_MISS_NUM,
404: P_Contact_Tbl IN AS_OPPORTUNITY_PUB.Contact_Tbl_Type,
405: X_contact_out_tbl OUT NOCOPY AS_OPPORTUNITY_PUB.contact_out_tbl_type,
406: X_Return_Status OUT NOCOPY VARCHAR2,
407: X_Msg_Count OUT NOCOPY NUMBER,
408: X_Msg_Data OUT NOCOPY VARCHAR2
409: )
417: l_api_name CONSTANT VARCHAR2(30) := 'Update_opp_contacts';
418: l_api_version_number CONSTANT NUMBER := 2.0;
419: -- Local Variables
420: l_identity_sales_member_rec AS_SALES_MEMBER_PUB.Sales_member_rec_Type;
421: --l_ref_Contact_rec AS_OPPORTUNITY_PUB.Contact_Rec_Type;
422: l_rowid ROWID;
423: l_Contact_Rec AS_OPPORTUNITY_PUB.Contact_Rec_Type;
424: l_line_count CONSTANT NUMBER := P_Contact_Tbl.count;
425: l_last_update_date DATE;
419: -- Local Variables
420: l_identity_sales_member_rec AS_SALES_MEMBER_PUB.Sales_member_rec_Type;
421: --l_ref_Contact_rec AS_OPPORTUNITY_PUB.Contact_Rec_Type;
422: l_rowid ROWID;
423: l_Contact_Rec AS_OPPORTUNITY_PUB.Contact_Rec_Type;
424: l_line_count CONSTANT NUMBER := P_Contact_Tbl.count;
425: l_last_update_date DATE;
426: l_update_access_flag VARCHAR2(1);
427: l_access_profile_rec AS_ACCESS_PUB.Access_Profile_Rec_Type;
505: END IF;
506:
507:
508: -- Call Get_Access_Profiles to get access_profile_rec
509: AS_OPPORTUNITY_PUB.Get_Access_Profiles(
510: p_profile_tbl => p_profile_tbl,
511: x_access_profile_rec => l_access_profile_rec);
512:
513: AS_ACCESS_PUB.has_updateOpportunityAccess
796: P_Admin_Group_Id IN NUMBER,
797: P_identity_salesforce_id IN NUMBER := NULL,
798: P_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE,
799: P_Partner_Cont_Party_id IN NUMBER := FND_API.G_MISS_NUM,
800: P_Contact_Tbl IN AS_OPPORTUNITY_PUB.Contact_Tbl_Type,
801: X_contact_out_tbl OUT NOCOPY AS_OPPORTUNITY_PUB.contact_out_tbl_type,
802: X_Return_Status OUT NOCOPY VARCHAR2,
803: X_Msg_Count OUT NOCOPY NUMBER,
804: X_Msg_Data OUT NOCOPY VARCHAR2
797: P_identity_salesforce_id IN NUMBER := NULL,
798: P_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE,
799: P_Partner_Cont_Party_id IN NUMBER := FND_API.G_MISS_NUM,
800: P_Contact_Tbl IN AS_OPPORTUNITY_PUB.Contact_Tbl_Type,
801: X_contact_out_tbl OUT NOCOPY AS_OPPORTUNITY_PUB.contact_out_tbl_type,
802: X_Return_Status OUT NOCOPY VARCHAR2,
803: X_Msg_Count OUT NOCOPY NUMBER,
804: X_Msg_Data OUT NOCOPY VARCHAR2
805: )
807: IS
808: l_api_name CONSTANT VARCHAR2(30) := 'Delete_opp_contacts';
809: l_api_version_number CONSTANT NUMBER := 2.0;
810: l_identity_sales_member_rec AS_SALES_MEMBER_PUB.Sales_member_rec_Type;
811: l_Contact_Rec AS_OPPORTUNITY_PUB.Contact_Rec_Type;
812: l_line_count CONSTANT NUMBER := P_Contact_Tbl.count;
813: l_update_access_flag VARCHAR2(1);
814: l_access_profile_rec AS_ACCESS_PUB.Access_Profile_Rec_Type;
815: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
891: END IF;
892:
893:
894: -- Call Get_Access_Profiles to get access_profile_rec
895: AS_OPPORTUNITY_PUB.Get_Access_Profiles(
896: p_profile_tbl => p_profile_tbl,
897: x_access_profile_rec => l_access_profile_rec);
898:
899: AS_ACCESS_PUB.has_updateOpportunityAccess
1827: -- table.
1828: PROCEDURE Validate_Contact_rec(
1829: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1830: P_Validation_mode IN VARCHAR2,
1831: P_Contact_Rec IN AS_OPPORTUNITY_PUB.Contact_Rec_Type,
1832: X_Return_Status OUT NOCOPY VARCHAR2,
1833: X_Msg_Count OUT NOCOPY NUMBER,
1834: X_Msg_Data OUT NOCOPY VARCHAR2
1835: )
1869: PROCEDURE Validate_opp_contact(
1870: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1871: P_Validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1872: P_Validation_mode IN VARCHAR2,
1873: P_Contact_Rec IN AS_OPPORTUNITY_PUB.Contact_Rec_Type,
1874: X_Return_Status OUT NOCOPY VARCHAR2,
1875: X_Msg_Count OUT NOCOPY NUMBER,
1876: X_Msg_Data OUT NOCOPY VARCHAR2
1877: )