APPS.AS_OPP_CONTACT_PVT dependencies on AS_LEAD_CONTACTS

Line 49: FROM as_lead_contacts

45: l_module CONSTANT VARCHAR2(255) := 'as.plsql.lcnpv.Create_opp_contacts';
46:
47: Cursor C_Get_Primary_Contact ( c_LEAD_ID NUMBER ) IS
48: SELECT lead_contact_id
49: FROM as_lead_contacts
50: WHERE lead_id = c_LEAD_ID
51: --and enabled_flag = 'Y' fix for 5285071
52: and primary_contact_flag = 'Y';
53:

Line 250: UPDATE AS_LEAD_CONTACTS

246: OPEN C_Get_Primary_Contact(l_Contact_rec.LEAD_ID);
247: FETCH C_Get_Primary_Contact into l_lead_contact_id;
248:
249: IF C_Get_Primary_Contact%FOUND THEN
250: UPDATE AS_LEAD_CONTACTS
251: SET primary_contact_flag = 'N'
252: WHERE lead_contact_id = l_lead_contact_id;
253: END IF;
254: CLOSE C_Get_Primary_Contact;

Line 259: -- Invoke table handler(AS_LEAD_CONTACTS_PKG.Insert_Row)

255: END IF;
256:
257: l_LEAD_CONTACT_ID := l_Contact_rec.LEAD_CONTACT_ID;
258:
259: -- Invoke table handler(AS_LEAD_CONTACTS_PKG.Insert_Row)
260: AS_LEAD_CONTACTS_PKG.Insert_Row(
261: px_LEAD_CONTACT_ID => l_LEAD_CONTACT_ID,
262: p_LEAD_ID => l_Contact_rec.LEAD_ID,
263: p_CONTACT_ID => l_Contact_rec.CONTACT_ID,

Line 260: AS_LEAD_CONTACTS_PKG.Insert_Row(

256:
257: l_LEAD_CONTACT_ID := l_Contact_rec.LEAD_CONTACT_ID;
258:
259: -- Invoke table handler(AS_LEAD_CONTACTS_PKG.Insert_Row)
260: AS_LEAD_CONTACTS_PKG.Insert_Row(
261: px_LEAD_CONTACT_ID => l_LEAD_CONTACT_ID,
262: p_LEAD_ID => l_Contact_rec.LEAD_ID,
263: p_CONTACT_ID => l_Contact_rec.CONTACT_ID,
264: p_LAST_UPDATE_DATE => SYSDATE,

Line 414: From AS_LEAD_CONTACTS

410:
411: IS
412: Cursor C_Get_opp_contact(c_LEAD_CONTACT_ID Number) IS
413: Select LAST_UPDATE_DATE
414: From AS_LEAD_CONTACTS
415: WHERE LEAD_CONTACT_ID = c_LEAD_CONTACT_ID
416: For Update NOWAIT;
417: l_api_name CONSTANT VARCHAR2(30) := 'Update_opp_contacts';
418: l_api_version_number CONSTANT NUMBER := 2.0;

Line 655: -- Invoke table handler(AS_LEAD_CONTACTS_PKG.Update_Row)

651: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
652: 'Private API: Calling update table handler');
653:
654: END IF;
655: -- Invoke table handler(AS_LEAD_CONTACTS_PKG.Update_Row)
656: AS_LEAD_CONTACTS_PKG.Update_Row(
657: p_LEAD_CONTACT_ID => l_Contact_rec.LEAD_CONTACT_ID,
658: p_LEAD_ID => l_Contact_rec.LEAD_ID,
659: p_CONTACT_ID => l_Contact_rec.CONTACT_ID,

Line 656: AS_LEAD_CONTACTS_PKG.Update_Row(

652: 'Private API: Calling update table handler');
653:
654: END IF;
655: -- Invoke table handler(AS_LEAD_CONTACTS_PKG.Update_Row)
656: AS_LEAD_CONTACTS_PKG.Update_Row(
657: p_LEAD_CONTACT_ID => l_Contact_rec.LEAD_CONTACT_ID,
658: p_LEAD_ID => l_Contact_rec.LEAD_ID,
659: p_CONTACT_ID => l_Contact_rec.CONTACT_ID,
660: p_LAST_UPDATE_DATE => SYSDATE,

Line 959: -- Invoke table handler(AS_LEAD_CONTACTS_PKG.Delete_Row)

955: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
956: 'Private API: Calling delete table handler');
957:
958: END IF;
959: -- Invoke table handler(AS_LEAD_CONTACTS_PKG.Delete_Row)
960: AS_LEAD_CONTACTS_PKG.Delete_Row(
961: p_LEAD_CONTACT_ID => l_Contact_rec.LEAD_CONTACT_ID);
962:
963: X_Contact_out_tbl(l_curr_row).LEAD_CONTACT_ID :=

Line 960: AS_LEAD_CONTACTS_PKG.Delete_Row(

956: 'Private API: Calling delete table handler');
957:
958: END IF;
959: -- Invoke table handler(AS_LEAD_CONTACTS_PKG.Delete_Row)
960: AS_LEAD_CONTACTS_PKG.Delete_Row(
961: p_LEAD_CONTACT_ID => l_Contact_rec.LEAD_CONTACT_ID);
962:
963: X_Contact_out_tbl(l_curr_row).LEAD_CONTACT_ID :=
964: l_Contact_rec.LEAD_CONTACT_ID;

Line 1068: FROM as_lead_contacts

1064:
1065:
1066: CURSOR C_Lead_Contact_Id_Exists (c_Lead_Contact_Id NUMBER) IS
1067: SELECT 'X'
1068: FROM as_lead_contacts
1069: WHERE lead_contact_id = c_Lead_Contact_Id;
1070:
1071: l_val VARCHAR2(1);
1072: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);

Line 1730: from as_lead_contacts

1726:
1727: -- Cursor to check for duplicate contacts , bug 5285071
1728: CURSOR C_Contact_party_id_dup( c_lead_id NUMBER, c_contact_party_id NUMBER) IS
1729: SELECT contact_party_id
1730: from as_lead_contacts
1731: where lead_id = c_lead_id
1732: and contact_party_id = c_contact_party_id;
1733:
1734: