DBA Data[Home] [Help]

APPS.AS_SALES_LEAD_CONTACTS_PVT dependencies on AS_SALES_LEADS_PUB

Line 392: P_SALES_LEAD_CONTACT_Rec IN AS_SALES_LEADS_PUB.SALES_LEAD_CONTACT_Rec_Type,

388: PROCEDURE Validate_sales_lead_contact(
389: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
390: P_Validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
391: P_Validation_mode IN VARCHAR2,
392: P_SALES_LEAD_CONTACT_Rec IN AS_SALES_LEADS_PUB.SALES_LEAD_CONTACT_Rec_Type,
393: X_Return_Status OUT NOCOPY VARCHAR2,
394: X_Msg_Count OUT NOCOPY NUMBER,
395: X_Msg_Data OUT NOCOPY VARCHAR2
396: )

Line 552: P_SALES_LEAD_CONTACT_Tbl IN AS_SALES_LEADS_PUB.SALES_LEAD_CONTACT_Tbl_Type

548: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
549: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
550: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
551: := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
552: P_SALES_LEAD_CONTACT_Tbl IN AS_SALES_LEADS_PUB.SALES_LEAD_CONTACT_Tbl_Type
553: := AS_SALES_LEADS_PUB.G_MISS_SALES_LEAD_CONTACT_Tbl,
554: P_SALES_LEAD_ID IN NUMBER,
555: X_SALES_LEAD_CNT_OUT_Tbl OUT NOCOPY AS_SALES_LEADS_PUB.SALES_LEAD_CNT_OUT_Tbl_Type,
556: X_Return_Status OUT NOCOPY VARCHAR2,

Line 553: := AS_SALES_LEADS_PUB.G_MISS_SALES_LEAD_CONTACT_Tbl,

549: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
550: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
551: := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
552: P_SALES_LEAD_CONTACT_Tbl IN AS_SALES_LEADS_PUB.SALES_LEAD_CONTACT_Tbl_Type
553: := AS_SALES_LEADS_PUB.G_MISS_SALES_LEAD_CONTACT_Tbl,
554: P_SALES_LEAD_ID IN NUMBER,
555: X_SALES_LEAD_CNT_OUT_Tbl OUT NOCOPY AS_SALES_LEADS_PUB.SALES_LEAD_CNT_OUT_Tbl_Type,
556: X_Return_Status OUT NOCOPY VARCHAR2,
557: X_Msg_Count OUT NOCOPY NUMBER,

Line 555: X_SALES_LEAD_CNT_OUT_Tbl OUT NOCOPY AS_SALES_LEADS_PUB.SALES_LEAD_CNT_OUT_Tbl_Type,

551: := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
552: P_SALES_LEAD_CONTACT_Tbl IN AS_SALES_LEADS_PUB.SALES_LEAD_CONTACT_Tbl_Type
553: := AS_SALES_LEADS_PUB.G_MISS_SALES_LEAD_CONTACT_Tbl,
554: P_SALES_LEAD_ID IN NUMBER,
555: X_SALES_LEAD_CNT_OUT_Tbl OUT NOCOPY AS_SALES_LEADS_PUB.SALES_LEAD_CNT_OUT_Tbl_Type,
556: X_Return_Status OUT NOCOPY VARCHAR2,
557: X_Msg_Count OUT NOCOPY NUMBER,
558: X_Msg_Data OUT NOCOPY VARCHAR2
559: )

Line 589: l_SALES_LEAD_CONTACT_rec AS_SALES_LEADS_PUB.sales_lead_contact_rec_type;

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);
592: l_member_role VARCHAR2(5);
593: l_member_access VARCHAR2(5);

Line 752: AS_SALES_LEADS_PUB.Get_Access_Profiles(

748: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
749: 'Calling Get_Access_Profiles');
750: END IF;
751:
752: AS_SALES_LEADS_PUB.Get_Access_Profiles(
753: p_profile_tbl => p_sales_lead_profile_tbl,
754: x_access_profile_rec => l_access_profile_rec);
755:
756: IF (AS_DEBUG_LOW_ON) THEN

Line 1020: AS_SALES_LEADS_PUB.SALES_LEAD_CONTACT_Tbl_Type,

1016: P_Identity_Salesforce_Id IN NUMBER := FND_API.G_MISS_NUM,
1017: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
1018: := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
1019: P_SALES_LEAD_CONTACT_Tbl IN
1020: AS_SALES_LEADS_PUB.SALES_LEAD_CONTACT_Tbl_Type,
1021: X_SALES_LEAD_CNT_OUT_Tbl OUT
1022: AS_SALES_LEADS_PUB.SALES_LEAD_CNT_OUT_Tbl_Type,
1023: X_Return_Status OUT NOCOPY VARCHAR2,
1024: X_Msg_Count OUT NOCOPY NUMBER,

Line 1022: AS_SALES_LEADS_PUB.SALES_LEAD_CNT_OUT_Tbl_Type,

1018: := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
1019: P_SALES_LEAD_CONTACT_Tbl IN
1020: AS_SALES_LEADS_PUB.SALES_LEAD_CONTACT_Tbl_Type,
1021: X_SALES_LEAD_CNT_OUT_Tbl OUT
1022: AS_SALES_LEADS_PUB.SALES_LEAD_CNT_OUT_Tbl_Type,
1023: X_Return_Status OUT NOCOPY VARCHAR2,
1024: X_Msg_Count OUT NOCOPY NUMBER,
1025: X_Msg_Data OUT NOCOPY VARCHAR2
1026: )

Line 1039: l_tar_SALES_LEAD_CONTACT_rec AS_SALES_LEADS_PUB.SALES_LEAD_CONTACT_Rec_Type;

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;
1042: l_update_access_flag VARCHAR2(1);
1043: l_member_role VARCHAR2(5);

Line 1241: AS_SALES_LEADS_PUB.Get_Access_Profiles(

1237: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1238: 'Calling Get_Access_Profiles');
1239: END IF;
1240:
1241: AS_SALES_LEADS_PUB.Get_Access_Profiles(
1242: p_profile_tbl => p_sales_lead_profile_tbl,
1243: x_access_profile_rec => l_access_profile_rec);
1244:
1245: IF (AS_DEBUG_LOW_ON) THEN

Line 1519: AS_SALES_LEADS_PUB.SALES_LEAD_CONTACT_Tbl_Type,

1515: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
1516: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
1517: := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
1518: P_SALES_LEAD_CONTACT_Tbl IN
1519: AS_SALES_LEADS_PUB.SALES_LEAD_CONTACT_Tbl_Type,
1520: X_SALES_LEAD_CNT_OUT_Tbl OUT
1521: AS_SALES_LEADS_PUB.SALES_LEAD_CNT_OUT_Tbl_Type,
1522: X_Return_Status OUT NOCOPY VARCHAR2,
1523: X_Msg_Count OUT NOCOPY NUMBER,

Line 1521: AS_SALES_LEADS_PUB.SALES_LEAD_CNT_OUT_Tbl_Type,

1517: := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
1518: P_SALES_LEAD_CONTACT_Tbl IN
1519: AS_SALES_LEADS_PUB.SALES_LEAD_CONTACT_Tbl_Type,
1520: X_SALES_LEAD_CNT_OUT_Tbl OUT
1521: AS_SALES_LEADS_PUB.SALES_LEAD_CNT_OUT_Tbl_Type,
1522: X_Return_Status OUT NOCOPY VARCHAR2,
1523: X_Msg_Count OUT NOCOPY NUMBER,
1524: X_Msg_Data OUT NOCOPY VARCHAR2
1525: )

Line 1540: l_sales_lead_contact_rec AS_SALES_LEADS_PUB.Sales_Lead_Contact_Rec_Type;

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);
1543: l_contact_party_id NUMBER;
1544: l_update_access_flag VARCHAR2(1);

Line 1668: AS_SALES_LEADS_PUB.Get_Access_Profiles(

1664: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1665: 'Calling Get_Access_Profiles');
1666: END IF;
1667:
1668: AS_SALES_LEADS_PUB.Get_Access_Profiles(
1669: p_profile_tbl => p_sales_lead_profile_tbl,
1670: x_access_profile_rec => l_access_profile_rec);
1671:
1672: IF (AS_DEBUG_LOW_ON) THEN