DBA Data[Home] [Help]

APPS.AS_OPP_CONTACT_PVT dependencies on AS_OPPORTUNITY_PUB

Line 26: P_Contact_Tbl IN AS_OPPORTUNITY_PUB.Contact_Tbl_Type :=

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,

Line 27: AS_OPPORTUNITY_PUB.G_MISS_Contact_Tbl,

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

Line 28: X_contact_out_tbl OUT NOCOPY AS_OPPORTUNITY_PUB.contact_out_tbl_type,

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

Line 39: l_CONTACT_Rec AS_OPPORTUNITY_PUB.CONTACT_Rec_Type;

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;

Line 147: AS_OPPORTUNITY_PUB.Get_Access_Profiles(

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

Line 404: P_Contact_Tbl IN AS_OPPORTUNITY_PUB.Contact_Tbl_Type,

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

Line 405: X_contact_out_tbl OUT NOCOPY AS_OPPORTUNITY_PUB.contact_out_tbl_type,

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

Line 421: --l_ref_Contact_rec AS_OPPORTUNITY_PUB.Contact_Rec_Type;

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;

Line 423: l_Contact_Rec AS_OPPORTUNITY_PUB.Contact_Rec_Type;

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;

Line 509: AS_OPPORTUNITY_PUB.Get_Access_Profiles(

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

Line 800: P_Contact_Tbl IN AS_OPPORTUNITY_PUB.Contact_Tbl_Type,

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

Line 801: X_contact_out_tbl OUT NOCOPY AS_OPPORTUNITY_PUB.contact_out_tbl_type,

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

Line 811: l_Contact_Rec AS_OPPORTUNITY_PUB.Contact_Rec_Type;

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

Line 895: AS_OPPORTUNITY_PUB.Get_Access_Profiles(

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

Line 1831: P_Contact_Rec IN AS_OPPORTUNITY_PUB.Contact_Rec_Type,

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

Line 1873: P_Contact_Rec IN AS_OPPORTUNITY_PUB.Contact_Rec_Type,

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