DBA Data[Home] [Help]

APPS.AS_SALES_LEAD_CONTACTS_PVT dependencies on AS_SALES_MEMBER_PUB

Line 587: l_identity_sales_member_rec AS_SALES_MEMBER_PUB.Sales_member_rec_Type;

583:
584:
585: l_api_name CONSTANT VARCHAR2(30) := 'Create_sales_lead_contacts';
586: l_api_version_number CONSTANT NUMBER := 2.0;
587: l_identity_sales_member_rec AS_SALES_MEMBER_PUB.Sales_member_rec_Type;
588: l_access_profile_rec AS_ACCESS_PUB.Access_Profile_Rec_Type;
589: l_SALES_LEAD_CONTACT_rec AS_SALES_LEADS_PUB.sales_lead_contact_rec_type;
590: l_lead_contact_id NUMBER;
591: l_update_access_flag VARCHAR2(1);

Line 1037: l_identity_sales_member_rec AS_SALES_MEMBER_PUB.Sales_member_rec_Type;

1033:
1034: l_api_name CONSTANT VARCHAR2(30) := 'Update_sales_lead_contacts';
1035: l_api_version_number CONSTANT NUMBER := 2.0;
1036: -- Local Variables
1037: l_identity_sales_member_rec AS_SALES_MEMBER_PUB.Sales_member_rec_Type;
1038: l_access_profile_rec AS_ACCESS_PUB.Access_Profile_Rec_Type;
1039: l_tar_SALES_LEAD_CONTACT_rec AS_SALES_LEADS_PUB.SALES_LEAD_CONTACT_Rec_Type;
1040: l_sales_lead_id NUMBER;
1041: l_last_update_date DATE;

Line 1538: l_identity_sales_member_rec AS_SALES_MEMBER_PUB.Sales_member_rec_Type;

1534: WHERE lead_contact_id = c_LEAD_CONTACT_ID;
1535:
1536: l_api_name CONSTANT VARCHAR2(30) := 'Delete_sales_lead_contacts';
1537: l_api_version_number CONSTANT NUMBER := 2.0;
1538: l_identity_sales_member_rec AS_SALES_MEMBER_PUB.Sales_member_rec_Type;
1539: l_access_profile_rec AS_ACCESS_PUB.Access_Profile_Rec_Type;
1540: l_sales_lead_contact_rec AS_SALES_LEADS_PUB.Sales_Lead_Contact_Rec_Type;
1541: l_sales_lead_id NUMBER;
1542: l_primary_contact_flag VARCHAR2(1);

Line 1850: l_identity_sales_member_rec AS_SALES_MEMBER_PUB.Sales_member_rec_Type;

1846: and primary_contact_flag = 'Y';
1847: l_count NUMBER;
1848: l_api_name CONSTANT VARCHAR2(30) := 'Check_primary_contact';
1849: l_api_version_number CONSTANT NUMBER := 2.0;
1850: l_identity_sales_member_rec AS_SALES_MEMBER_PUB.Sales_member_rec_Type;
1851: l_access_profile_rec AS_ACCESS_PUB.Access_Profile_Rec_Type;
1852: l_cnt varchar2(2);
1853: l_update_access_flag VARCHAR2(1);
1854: l_member_role VARCHAR2(5);