DBA Data[Home] [Help]

APPS.AS_OPP_CONTACT_PVT dependencies on AS_SALES_MEMBER_PUB

Line 38: l_identity_sales_member_rec AS_SALES_MEMBER_PUB.Sales_member_rec_Type;

34: IS
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);

Line 420: l_identity_sales_member_rec AS_SALES_MEMBER_PUB.Sales_member_rec_Type;

416: For Update NOWAIT;
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;

Line 810: l_identity_sales_member_rec AS_SALES_MEMBER_PUB.Sales_member_rec_Type;

806:
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;