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_LEAD_CONTACTS

Line 1: PACKAGE BODY AS_SALES_LEAD_CONTACTS_PVT as

1: PACKAGE BODY AS_SALES_LEAD_CONTACTS_PVT as
2: /* $Header: asxvslcb.pls 115.19 2004/01/12 23:30:02 chchandr ship $ */
3: -- Start of Comments
4: -- Package name : AS_SALES_LEAD_CONTACTS_PVT
5: -- Purpose : Sales Leads Contacts

Line 4: -- Package name : AS_SALES_LEAD_CONTACTS_PVT

1: PACKAGE BODY AS_SALES_LEAD_CONTACTS_PVT as
2: /* $Header: asxvslcb.pls 115.19 2004/01/12 23:30:02 chchandr ship $ */
3: -- Start of Comments
4: -- Package name : AS_SALES_LEAD_CONTACTS_PVT
5: -- Purpose : Sales Leads Contacts
6: -- NOTE :
7: -- History :
8: -- 04/09/2001 FFANG Created.

Line 13: G_PKG_NAME CONSTANT VARCHAR2(30):= 'AS_SALES_LEAD_CONTACTS_PVT';

9: --
10: -- END of Comments
11:
12:
13: G_PKG_NAME CONSTANT VARCHAR2(30):= 'AS_SALES_LEAD_CONTACTS_PVT';
14: G_FILE_NAME CONSTANT VARCHAR2(12) := 'asxvslcb.pls';
15:
16:
17: -- *************************

Line 565: FROM as_sales_lead_contacts slc, hz_relationships r

561: IS
562: -- for bug 2098158 ckapoor - change cursor to retrieve the phone and party id of contact also
563: Cursor C_Get_Primary_Contact ( c_SALES_LEAD_ID NUMBER ) IS
564: SELECT slc.LEAD_CONTACT_ID, slc.CONTACT_PARTY_ID, slc.PHONE_ID, r.subject_id
565: FROM as_sales_lead_contacts slc, hz_relationships r
566: WHERE slc.sales_lead_id = c_SALES_LEAD_ID
567: and slc.enabled_flag = 'Y'
568: and slc.primary_contact_flag = 'Y'
569: and r.party_id = slc.contact_party_id

Line 576: FROM as_sales_lead_contacts

572: -- Bug 3357273 - MASS1R10:11510:FUNC:CONTACT NOT MARKED'PRIMARY'WHEN LEAD HAS MORE THAN 1 CONTACT
573:
574: CURSOR C_Sales_Lead_Id_Exists ( c_SALES_LEAD_ID NUMBER ) IS
575: SELECT count(1)
576: FROM as_sales_lead_contacts
577: WHERE sales_lead_id = c_SALES_LEAD_ID;
578:
579:
580: l_val VARCHAR2(1);

Line 808: UPDATE AS_SALES_LEAD_CONTACTS

804: FETCH C_Get_Primary_Contact into l_lead_contact_id,
805: l_contact_party_id, l_contact_phone_id, l_cnt_person_party_id;
806:
807: IF C_Get_Primary_Contact%FOUND THEN
808: UPDATE AS_SALES_LEAD_CONTACTS
809: SET primary_contact_flag = 'N'
810: WHERE lead_contact_id = l_lead_contact_id;
811: END IF;
812: CLOSE C_Get_Primary_Contact;

Line 825: AS_SALES_LEAD_CONTACTS_PKG.SALES_LEAD_CONTACTS_Insert_Row(

821:
822: l_lead_contact_id := l_sales_lead_contact_rec.lead_contact_id;
823:
824: -- Invoke table handler
825: AS_SALES_LEAD_CONTACTS_PKG.SALES_LEAD_CONTACTS_Insert_Row(
826: px_LEAD_CONTACT_ID => l_LEAD_CONTACT_ID,
827: p_SALES_LEAD_ID => l_SALES_LEAD_CONTACT_rec.SALES_LEAD_ID,
828: p_CONTACT_ID => l_SALES_LEAD_CONTACT_rec.CONTACT_ID,
829: p_CONTACT_PARTY_ID => l_SALES_LEAD_CONTACT_rec.CONTACT_PARTY_ID,

Line 1030: From AS_SALES_LEAD_CONTACTS

1026: )
1027: IS
1028: Cursor C_Get_contact(c_LEAD_CONTACT_ID Number) IS
1029: Select LAST_UPDATE_DATE
1030: From AS_SALES_LEAD_CONTACTS
1031: Where lead_contact_id = c_LEAD_CONTACT_ID
1032: For Update NOWAIT;
1033:
1034: l_api_name CONSTANT VARCHAR2(30) := 'Update_sales_lead_contacts';

Line 1054: FROM as_sales_lead_contacts slc, hz_relationships r

1050:
1051: -- for bug 2098158 ckapoor - change cursor to retrieve the phone and party id of contact also
1052: Cursor C_Get_Pri_Contact ( c_SALES_LEAD_ID NUMBER ) IS
1053: SELECT slc.CONTACT_PARTY_ID, slc.PHONE_ID, r.subject_id
1054: FROM as_sales_lead_contacts slc, hz_relationships r
1055: WHERE slc.sales_lead_id = c_SALES_LEAD_ID
1056: and slc.enabled_flag = 'Y'
1057: and slc.primary_contact_flag = 'Y'
1058: and r.party_id = slc.contact_party_id

Line 1305: UPDATE as_sales_lead_contacts

1301: END IF;
1302:
1303: IF l_tar_SALES_LEAD_CONTACT_Rec.primary_contact_flag = 'Y'
1304: THEN
1305: UPDATE as_sales_lead_contacts
1306: SET primary_contact_flag = 'N'
1307: WHERE sales_lead_id = l_tar_SALES_LEAD_CONTACT_Rec.sales_lead_id
1308: and PRIMARY_CONTACT_FLAG = 'Y'
1309: and enabled_flag = 'Y';

Line 1319: AS_SALES_LEAD_CONTACTS_PKG.SALES_LEAD_CONTACTS_Update_Row(

1315: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1316: 'Calling CONTACTS_Update_Row');
1317: END IF;
1318: -- Invoke table handler
1319: AS_SALES_LEAD_CONTACTS_PKG.SALES_LEAD_CONTACTS_Update_Row(
1320: p_LEAD_CONTACT_ID => l_tar_SALES_LEAD_CONTACT_rec.LEAD_CONTACT_ID,
1321: p_SALES_LEAD_ID => l_tar_SALES_LEAD_CONTACT_rec.SALES_LEAD_ID,
1322: p_CONTACT_ID => l_tar_SALES_LEAD_CONTACT_rec.CONTACT_ID,
1323: p_CONTACT_PARTY_ID => l_tar_SALES_LEAD_CONTACT_rec.CONTACT_PARTY_ID,

Line 1533: FROM AS_SALES_LEAD_CONTACTS

1529: SELECT
1530: SALES_LEAD_ID,
1531: PRIMARY_CONTACT_FLAG,
1532: CONTACT_PARTY_ID
1533: FROM AS_SALES_LEAD_CONTACTS
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;

Line 1721: AS_SALES_LEAD_CONTACTS_PKG.SALES_LEAD_CONTACTS_Delete_Row(

1717: 'Calling CONTACTS_Delete_Row');
1718: END IF;
1719:
1720: -- Invoke table handler
1721: AS_SALES_LEAD_CONTACTS_PKG.SALES_LEAD_CONTACTS_Delete_Row(
1722: p_LEAD_CONTACT_ID => l_SALES_LEAD_CONTACT_rec.LEAD_CONTACT_ID);
1723:
1724: x_sales_lead_cnt_out_tbl(l_curr_row).lead_contact_id
1725: := l_sales_lead_contact_rec.lead_contact_id;

Line 1843: FROM as_sales_lead_contacts

1839: )
1840: IS
1841: Cursor C_Get_Primary_Contact_Count ( X_SALES_LEAD_ID NUMBER) IS
1842: SELECT count(*)
1843: FROM as_sales_lead_contacts
1844: WHERE sales_lead_id = X_SALES_LEAD_ID
1845: and enabled_flag = 'Y'
1846: and primary_contact_flag = 'Y';
1847: l_count NUMBER;

Line 1987: END AS_SALES_LEAD_CONTACTS_PVT;

1983: ,X_RETURN_STATUS => X_RETURN_STATUS);
1984: END Check_primary_contact;
1985:
1986:
1987: END AS_SALES_LEAD_CONTACTS_PVT;