eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AS_SALES_LEAD_CONTACTS_PVT dependencies on AS_SALES_LEADS

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 421: AS_SALES_LEADS_PVT.Validate_CUSTOMER_ID(

417:
418: IF ( P_validation_level >= AS_UTILITY_PUB.G_VALID_LEVEL_ITEM)
419: THEN
420: -- Perform item level validation
421: AS_SALES_LEADS_PVT.Validate_CUSTOMER_ID(
422: p_init_msg_list => FND_API.G_FALSE,
423: p_validation_mode => p_validation_mode,
424: p_CUSTOMER_ID => P_SALES_LEAD_CONTACT_Rec.CUSTOMER_ID,
425: x_return_status => x_return_status,

Line 437: AS_SALES_LEADS_PVT.Validate_ADDRESS_ID(

433: -- ffang 081001, bug 1930170, if no addres_id, then skip validation
434: IF (P_SALES_LEAD_CONTACT_Rec.ADDRESS_ID IS NOT NULL and
435: P_SALES_LEAD_CONTACT_Rec.ADDRESS_ID <> FND_API.G_MISS_NUM)
436: THEN
437: AS_SALES_LEADS_PVT.Validate_ADDRESS_ID(
438: p_init_msg_list => FND_API.G_FALSE,
439: p_validation_mode => p_validation_mode,
440: p_CUSTOMER_ID => P_SALES_LEAD_CONTACT_Rec.CUSTOMER_ID,
441: p_ADDRESS_ID => P_SALES_LEAD_CONTACT_Rec.ADDRESS_ID,

Line 503: AS_SALES_LEADS_PVT.Validate_FLAGS(

499: l_return_status := FND_API.G_RET_STS_ERROR;
500: -- raise FND_API.G_EXC_ERROR;
501: END IF;
502:
503: AS_SALES_LEADS_PVT.Validate_FLAGS(
504: p_init_msg_list => FND_API.G_FALSE,
505: p_validation_mode => p_validation_mode,
506: p_Flag_Value =>
507: P_SALES_LEAD_CONTACT_Rec.PRIMARY_CONTACT_FLAG,

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 882: UPDATE as_sales_leads

878: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
879: 'Updating the header table for last updated');
880: END IF;
881:
882: UPDATE as_sales_leads
883: SET last_update_date = SYSDATE,
884: last_updated_by = FND_GLOBAL.USER_ID,
885: last_update_login = FND_GLOBAL.CONC_LOGIN_ID
886: WHERE sales_lead_id = p_sales_lead_id;

Line 917: -- contact_party_id to as_sales_leads.primary_contact_party_id

913: RAISE FND_API.G_EXC_ERROR;
914: END IF;
915:
916: -- ffang 082801, for bug 1939730, denorm primary contact's
917: -- contact_party_id to as_sales_leads.primary_contact_party_id
918: -- ckapoor 011102 , for bug 2098158, denorm the party id of the
919: -- primary contact (not the relationship) to as_sales_leads.primary_cnt_person_party_id
920: -- also denorm the phone_id of primary contact to as_sales_leads.primary_contact_phone_id
921:

Line 919: -- primary contact (not the relationship) to as_sales_leads.primary_cnt_person_party_id

915:
916: -- ffang 082801, for bug 1939730, denorm primary contact's
917: -- contact_party_id to as_sales_leads.primary_contact_party_id
918: -- ckapoor 011102 , for bug 2098158, denorm the party id of the
919: -- primary contact (not the relationship) to as_sales_leads.primary_cnt_person_party_id
920: -- also denorm the phone_id of primary contact to as_sales_leads.primary_contact_phone_id
921:
922: OPEN C_Get_Primary_Contact(p_SALES_LEAD_ID);
923: FETCH C_Get_Primary_Contact into l_lead_contact_id, l_contact_party_id, l_contact_phone_id, l_cnt_person_party_id;

Line 920: -- also denorm the phone_id of primary contact to as_sales_leads.primary_contact_phone_id

916: -- ffang 082801, for bug 1939730, denorm primary contact's
917: -- contact_party_id to as_sales_leads.primary_contact_party_id
918: -- ckapoor 011102 , for bug 2098158, denorm the party id of the
919: -- primary contact (not the relationship) to as_sales_leads.primary_cnt_person_party_id
920: -- also denorm the phone_id of primary contact to as_sales_leads.primary_contact_phone_id
921:
922: OPEN C_Get_Primary_Contact(p_SALES_LEAD_ID);
923: FETCH C_Get_Primary_Contact into l_lead_contact_id, l_contact_party_id, l_contact_phone_id, l_cnt_person_party_id;
924: IF C_Get_Primary_Contact%FOUND THEN

Line 925: UPDATE AS_SALES_LEADS

921:
922: OPEN C_Get_Primary_Contact(p_SALES_LEAD_ID);
923: FETCH C_Get_Primary_Contact into l_lead_contact_id, l_contact_party_id, l_contact_phone_id, l_cnt_person_party_id;
924: IF C_Get_Primary_Contact%FOUND THEN
925: UPDATE AS_SALES_LEADS
926: SET PRIMARY_CONTACT_PARTY_ID = l_contact_party_id,
927: PRIMARY_CONTACT_PHONE_ID = l_contact_phone_id,
928: PRIMARY_CNT_PERSON_PARTY_ID = l_cnt_person_party_id
929: WHERE sales_lead_id = p_SALES_LEAD_ID;

Line 931: UPDATE AS_SALES_LEADS

927: PRIMARY_CONTACT_PHONE_ID = l_contact_phone_id,
928: PRIMARY_CNT_PERSON_PARTY_ID = l_cnt_person_party_id
929: WHERE sales_lead_id = p_SALES_LEAD_ID;
930: ELSE -- no primary contact found
931: UPDATE AS_SALES_LEADS
932: SET PRIMARY_CONTACT_PARTY_ID = NULL,
933: PRIMARY_CONTACT_PHONE_ID = NULL,
934: PRIMARY_CNT_PERSON_PARTY_ID = NULL
935: WHERE sales_lead_id = p_SALES_LEAD_ID;

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 1379: UPDATE as_sales_leads

1375: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1376: 'Updating the header table for last updated');
1377: END IF;
1378:
1379: UPDATE as_sales_leads
1380: SET last_update_date = SYSDATE,
1381: last_updated_by = FND_GLOBAL.USER_ID,
1382: last_update_login = FND_GLOBAL.CONC_LOGIN_ID
1383: WHERE sales_lead_id = l_tar_SALES_LEAD_CONTACT_Rec.sales_lead_id;

Line 1415: -- contact_party_id to as_sales_leads.primary_contact_party_id

1411: RAISE FND_API.G_EXC_ERROR;
1412: END IF;
1413:
1414: -- ffang 082801, for bug 1939730, denorm primary contact's
1415: -- contact_party_id to as_sales_leads.primary_contact_party_id
1416:
1417: -- ckapoor 011102 , for bug 2098158, denorm the party id of the
1418: -- primary contact (not the relationship) to as_sales_leads.primary_cnt_person_party_id
1419: -- also denorm the phone_id of primary contact to as_sales_leads.primary_contact_phone_id

Line 1418: -- primary contact (not the relationship) to as_sales_leads.primary_cnt_person_party_id

1414: -- ffang 082801, for bug 1939730, denorm primary contact's
1415: -- contact_party_id to as_sales_leads.primary_contact_party_id
1416:
1417: -- ckapoor 011102 , for bug 2098158, denorm the party id of the
1418: -- primary contact (not the relationship) to as_sales_leads.primary_cnt_person_party_id
1419: -- also denorm the phone_id of primary contact to as_sales_leads.primary_contact_phone_id
1420:
1421:
1422: OPEN C_Get_Pri_Contact(l_tar_SALES_LEAD_CONTACT_rec.SALES_LEAD_ID);

Line 1419: -- also denorm the phone_id of primary contact to as_sales_leads.primary_contact_phone_id

1415: -- contact_party_id to as_sales_leads.primary_contact_party_id
1416:
1417: -- ckapoor 011102 , for bug 2098158, denorm the party id of the
1418: -- primary contact (not the relationship) to as_sales_leads.primary_cnt_person_party_id
1419: -- also denorm the phone_id of primary contact to as_sales_leads.primary_contact_phone_id
1420:
1421:
1422: OPEN C_Get_Pri_Contact(l_tar_SALES_LEAD_CONTACT_rec.SALES_LEAD_ID);
1423: FETCH C_Get_Pri_Contact into l_contact_party_id, l_contact_phone_id, l_cnt_person_party_id;

Line 1425: UPDATE AS_SALES_LEADS

1421:
1422: OPEN C_Get_Pri_Contact(l_tar_SALES_LEAD_CONTACT_rec.SALES_LEAD_ID);
1423: FETCH C_Get_Pri_Contact into l_contact_party_id, l_contact_phone_id, l_cnt_person_party_id;
1424: IF C_Get_Pri_Contact%FOUND THEN
1425: UPDATE AS_SALES_LEADS
1426: SET PRIMARY_CONTACT_PARTY_ID = l_contact_party_id,
1427: PRIMARY_CONTACT_PHONE_ID = l_contact_phone_id,
1428: PRIMARY_CNT_PERSON_PARTY_ID = l_cnt_person_party_id
1429: WHERE sales_lead_id = l_tar_SALES_LEAD_CONTACT_rec.SALES_LEAD_ID;

Line 1431: UPDATE AS_SALES_LEADS

1427: PRIMARY_CONTACT_PHONE_ID = l_contact_phone_id,
1428: PRIMARY_CNT_PERSON_PARTY_ID = l_cnt_person_party_id
1429: WHERE sales_lead_id = l_tar_SALES_LEAD_CONTACT_rec.SALES_LEAD_ID;
1430: ELSE -- no primary contact found
1431: UPDATE AS_SALES_LEADS
1432: SET PRIMARY_CONTACT_PARTY_ID = NULL,
1433: PRIMARY_CONTACT_PHONE_ID = NULL,
1434: PRIMARY_CNT_PERSON_PARTY_ID = NULL
1435:

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

Line 1739: UPDATE as_sales_leads

1735: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1736: 'Updating the header table for last updated');
1737: END IF;
1738:
1739: UPDATE as_sales_leads
1740: SET last_update_date = SYSDATE,
1741: last_updated_by = FND_GLOBAL.USER_ID,
1742: last_update_login = FND_GLOBAL.CONC_LOGIN_ID
1743: WHERE sales_lead_id = l_sales_lead_id;

Line 1746: -- ffang 090601, if primary contact is deleted, update as_sales_leads

1742: last_update_login = FND_GLOBAL.CONC_LOGIN_ID
1743: WHERE sales_lead_id = l_sales_lead_id;
1744:
1745:
1746: -- ffang 090601, if primary contact is deleted, update as_sales_leads
1747: -- to clean up primary_contact_party_id
1748: -- ckapoor 011102 bug 2098158 clean up primary_contact_phone_id and primary_cnt_person_party_id
1749: IF l_PRIMARY_CONTACT_FLAG = 'Y' THEN
1750: IF (AS_DEBUG_LOW_ON) THEN

Line 1755: update as_sales_leads

1751:
1752: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1753: 'Primary contact is deleted');
1754: END IF;
1755: update as_sales_leads
1756: set primary_contact_party_id = NULL,
1757: primary_contact_phone_id = NULL,
1758: primary_cnt_person_party_id = NULL
1759: where sales_lead_id = l_sales_lead_id