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_IMPORT_SL_PVT dependencies on HZ_CONTACT_POINT_V2PUB

Line 526: pHzcpRec in OUT NOCOPY hz_contact_point_v2pub.contact_point_rec_type,

522: --------------------------------------------------------
523: procedure do_assign_flex (
524: pHzpRec in OUT NOCOPY hz_party_v2pub.party_rec_type,
525: pHzlRec in OUT NOCOPY hz_location_v2pub.location_rec_type,
526: pHzcpRec in OUT NOCOPY hz_contact_point_v2pub.contact_point_rec_type,
527: pHzpsRec in OUT NOCOPY hz_party_site_v2pub.party_site_rec_type,
528: pHzocRec in OUT NOCOPY hz_party_contact_v2pub.org_contact_rec_type,
529: -- pHocrRec in out hz_party_pub.org_contact_role_rec_type,
530: pAsslRec in OUT NOCOPY as_sales_leads_pub.sales_lead_rec_type,

Line 893: l_dummy_rec3 hz_contact_point_v2pub.contact_point_rec_type;

889: -- aanjaria enh tcav2
890: -- Dummy
891: --l_dummy_rec1 hz_party_v2pub.party_rec_type;
892: l_dummy_rec2 hz_location_v2pub.location_rec_type;
893: l_dummy_rec3 hz_contact_point_v2pub.contact_point_rec_type;
894: l_dummy_rec4 hz_party_site_v2pub.party_site_rec_type;
895: l_dummy_rec5 hz_party_contact_v2pub.org_contact_rec_type;
896: l_dummy_rec7 as_sales_leads_pub.sales_lead_rec_type;
897: l_dummy_tbl8 as_sales_leads_pub.sales_lead_line_tbl_type;

Line 1018: -- calls HZ_CONTACT_POINT_V2PUB.create_contact_preference

1014:
1015: --------------------------------------------------------
1016: -- name: do_contact_preference
1017: -- scope: private
1018: -- calls HZ_CONTACT_POINT_V2PUB.create_contact_preference
1019: -- inserts contact preference for pary and party site
1020: ----------------------------------------------------------
1021: procedure do_contact_preference(
1022: pI IN OUT NOCOPY leadImpType,

Line 1270: -- calls HZ_CONTACT_POINT_V2PUB.do_create_contact_points

1266:
1267: --------------------------------------------------------
1268: -- name: do_create_contact_points_old
1269: -- scope: private
1270: -- calls HZ_CONTACT_POINT_V2PUB.do_create_contact_points
1271: -- inserts contact point (in as_import_interface) for pary and party site
1272: ----------------------------------------------------------
1273: procedure do_create_contact_points_old(
1274: pI IN OUT NOCOPY leadImpType,

Line 1281: l_cp_rec hz_contact_point_v2pub.contact_point_rec_type;

1277: l_dup_email IN VARCHAR2,
1278: l_dup_url IN VARCHAR2,
1279: G_return_status OUT NOCOPY varchar2)
1280: IS
1281: l_cp_rec hz_contact_point_v2pub.contact_point_rec_type;
1282: l_email_rec hz_contact_point_v2pub.email_rec_type;
1283: l_ph_rec hz_contact_point_v2pub.phone_rec_type;
1284: l_web_rec hz_contact_point_v2pub.web_rec_type ;
1285: l_msg_data VARCHAR2(2000);

Line 1282: l_email_rec hz_contact_point_v2pub.email_rec_type;

1278: l_dup_url IN VARCHAR2,
1279: G_return_status OUT NOCOPY varchar2)
1280: IS
1281: l_cp_rec hz_contact_point_v2pub.contact_point_rec_type;
1282: l_email_rec hz_contact_point_v2pub.email_rec_type;
1283: l_ph_rec hz_contact_point_v2pub.phone_rec_type;
1284: l_web_rec hz_contact_point_v2pub.web_rec_type ;
1285: l_msg_data VARCHAR2(2000);
1286: l_cpid number;

Line 1283: l_ph_rec hz_contact_point_v2pub.phone_rec_type;

1279: G_return_status OUT NOCOPY varchar2)
1280: IS
1281: l_cp_rec hz_contact_point_v2pub.contact_point_rec_type;
1282: l_email_rec hz_contact_point_v2pub.email_rec_type;
1283: l_ph_rec hz_contact_point_v2pub.phone_rec_type;
1284: l_web_rec hz_contact_point_v2pub.web_rec_type ;
1285: l_msg_data VARCHAR2(2000);
1286: l_cpid number;
1287:

Line 1284: l_web_rec hz_contact_point_v2pub.web_rec_type ;

1280: IS
1281: l_cp_rec hz_contact_point_v2pub.contact_point_rec_type;
1282: l_email_rec hz_contact_point_v2pub.email_rec_type;
1283: l_ph_rec hz_contact_point_v2pub.phone_rec_type;
1284: l_web_rec hz_contact_point_v2pub.web_rec_type ;
1285: l_msg_data VARCHAR2(2000);
1286: l_cpid number;
1287:
1288: -- Dummy

Line 1291: l_dummy_rec3 hz_contact_point_v2pub.contact_point_rec_type;

1287:
1288: -- Dummy
1289: l_dummy_rec1 hz_party_v2pub.party_rec_type;
1290: l_dummy_rec2 hz_location_v2pub.location_rec_type;
1291: l_dummy_rec3 hz_contact_point_v2pub.contact_point_rec_type;
1292: l_dummy_rec4 hz_party_site_v2pub.party_site_rec_type;
1293: l_dummy_rec5 hz_party_contact_v2pub.org_contact_rec_type;
1294: --l_dummy_rec6 hz_party_pub.org_contact_role_rec_type;
1295: l_dummy_rec7 as_sales_leads_pub.sales_lead_rec_type;

Line 1362: HZ_CONTACT_POINT_V2PUB.create_contact_point (

1358: l_ph_rec.raw_phone_number := pI.raw_phone_number;
1359:
1360: write_log(3, 'Inserting the phone rec');
1361:
1362: HZ_CONTACT_POINT_V2PUB.create_contact_point (
1363: p_init_msg_list => FND_API.G_FALSE,
1364: p_contact_point_rec => l_cp_rec,
1365: p_phone_rec => l_ph_rec,
1366: x_return_status => G_return_status,

Line 1401: HZ_CONTACT_POINT_V2PUB.create_contact_point (

1397: -- l_ph_rec.time_zone := pI.time_zone;
1398: l_ph_rec.raw_phone_number := NULL;
1399:
1400: write_log(3, 'Inserting the fax rec');
1401: HZ_CONTACT_POINT_V2PUB.create_contact_point (
1402: p_init_msg_list => FND_API.G_FALSE,
1403: p_contact_point_rec => l_cp_rec,
1404: p_phone_rec => l_ph_rec,
1405: x_return_status => G_return_status,

Line 1430: HZ_CONTACT_POINT_V2PUB.create_contact_point (

1426: l_email_rec.email_format := pI.email_format;
1427: l_email_rec.email_address := pI.email_address;
1428: write_log(3, 'Inserting an email rec');
1429:
1430: HZ_CONTACT_POINT_V2PUB.create_contact_point (
1431: p_init_msg_list => FND_API.G_FALSE,
1432: p_contact_point_rec => l_cp_rec,
1433: p_email_rec => l_email_rec,
1434: x_return_status => G_return_status,

Line 1459: HZ_CONTACT_POINT_V2PUB.create_contact_point (

1455: l_web_rec.web_type := 'http';
1456: l_web_rec.url := pI.url;
1457: write_log(3, 'Inserting an url rec');
1458:
1459: HZ_CONTACT_POINT_V2PUB.create_contact_point (
1460: p_init_msg_list => FND_API.G_FALSE,
1461: p_contact_point_rec => l_cp_rec,
1462: p_web_rec => l_web_rec,
1463: x_return_status => G_return_status,

Line 1485: -- calls HZ_CONTACT_POINT_V2PUB.do_create_contact_points

1481:
1482: --------------------------------------------------------
1483: -- name: do_create_contact_points
1484: -- scope: private
1485: -- calls HZ_CONTACT_POINT_V2PUB.do_create_contact_points
1486: -- inserts contact point (in as_imp_cnt_pnt_interface) for pary and party site
1487: ----------------------------------------------------------
1488: procedure do_create_contact_points(
1489: pI IN OUT NOCOPY leadImpType,

Line 1494: l_cp_rec hz_contact_point_v2pub.contact_point_rec_type;

1490: pCP IN OUT NOCOPY cntPntType,
1491: owner_type IN varchar2,
1492: G_return_status OUT NOCOPY varchar2)
1493: IS
1494: l_cp_rec hz_contact_point_v2pub.contact_point_rec_type;
1495: l_email_rec hz_contact_point_v2pub.email_rec_type;
1496: l_ph_rec hz_contact_point_v2pub.phone_rec_type;
1497: l_web_rec hz_contact_point_v2pub.web_rec_type ;
1498: l_msg_data VARCHAR2(2000);

Line 1495: l_email_rec hz_contact_point_v2pub.email_rec_type;

1491: owner_type IN varchar2,
1492: G_return_status OUT NOCOPY varchar2)
1493: IS
1494: l_cp_rec hz_contact_point_v2pub.contact_point_rec_type;
1495: l_email_rec hz_contact_point_v2pub.email_rec_type;
1496: l_ph_rec hz_contact_point_v2pub.phone_rec_type;
1497: l_web_rec hz_contact_point_v2pub.web_rec_type ;
1498: l_msg_data VARCHAR2(2000);
1499: l_cpid number;

Line 1496: l_ph_rec hz_contact_point_v2pub.phone_rec_type;

1492: G_return_status OUT NOCOPY varchar2)
1493: IS
1494: l_cp_rec hz_contact_point_v2pub.contact_point_rec_type;
1495: l_email_rec hz_contact_point_v2pub.email_rec_type;
1496: l_ph_rec hz_contact_point_v2pub.phone_rec_type;
1497: l_web_rec hz_contact_point_v2pub.web_rec_type ;
1498: l_msg_data VARCHAR2(2000);
1499: l_cpid number;
1500:

Line 1497: l_web_rec hz_contact_point_v2pub.web_rec_type ;

1493: IS
1494: l_cp_rec hz_contact_point_v2pub.contact_point_rec_type;
1495: l_email_rec hz_contact_point_v2pub.email_rec_type;
1496: l_ph_rec hz_contact_point_v2pub.phone_rec_type;
1497: l_web_rec hz_contact_point_v2pub.web_rec_type ;
1498: l_msg_data VARCHAR2(2000);
1499: l_cpid number;
1500:
1501: l_dup_phone varchar2(1):= 'N';

Line 1606: HZ_CONTACT_POINT_V2PUB.create_contact_point (

1602: -- l_ph_rec.time_zone := pCP.time_zone;
1603: l_ph_rec.raw_phone_number := pCP.raw_phone_number;
1604:
1605: write_log(3, 'Inserting the phone rec');
1606: HZ_CONTACT_POINT_V2PUB.create_contact_point (
1607: p_init_msg_list => FND_API.G_FALSE,
1608: p_contact_point_rec => l_cp_rec,
1609: p_phone_rec => l_ph_rec,
1610: x_return_status => G_return_status,

Line 1643: HZ_CONTACT_POINT_V2PUB.create_contact_point (

1639: -- l_ph_rec.time_zone := pCP.time_zone;
1640: l_ph_rec.raw_phone_number := pCP.raw_phone_number;
1641:
1642: write_log(3, 'Inserting the fax rec');
1643: HZ_CONTACT_POINT_V2PUB.create_contact_point (
1644: p_init_msg_list => FND_API.G_FALSE,
1645: p_contact_point_rec => l_cp_rec,
1646: p_phone_rec => l_ph_rec,
1647: x_return_status => G_return_status,

Line 1665: HZ_CONTACT_POINT_V2PUB.create_contact_point (

1661: l_email_rec.email_format := pCP.email_format;
1662: l_email_rec.email_address := pCP.email_address; --pI.email_address;
1663:
1664: write_log(3, 'Inserting an email rec');
1665: HZ_CONTACT_POINT_V2PUB.create_contact_point (
1666: p_init_msg_list => FND_API.G_FALSE,
1667: p_contact_point_rec => l_cp_rec,
1668: p_email_rec => l_email_rec,
1669: x_return_status => G_return_status,

Line 1687: HZ_CONTACT_POINT_V2PUB.create_contact_point (

1683: l_web_rec.web_type := pCP.web_type; -- 'http';
1684: l_web_rec.url := pCP.url; -- pI.url;
1685:
1686: write_log(3, 'Inserting an url rec');
1687: HZ_CONTACT_POINT_V2PUB.create_contact_point (
1688: p_init_msg_list => FND_API.G_FALSE,
1689: p_contact_point_rec => l_cp_rec,
1690: p_web_rec => l_web_rec,
1691: x_return_status => G_return_status,

Line 1722: l_dummy_rec3 hz_contact_point_v2pub.contact_point_rec_type;

1718:
1719: -- Dummy
1720: l_dummy_rec1 hz_party_v2pub.party_rec_type;
1721: --l_dummy_rec2 hz_location_pub.location_rec_type;
1722: l_dummy_rec3 hz_contact_point_v2pub.contact_point_rec_type;
1723: l_dummy_rec4 hz_party_site_v2pub.party_site_rec_type;
1724: l_dummy_rec5 hz_party_contact_v2pub.org_contact_rec_type;
1725: l_dummy_rec6 hz_party_contact_v2pub.org_contact_role_rec_type;
1726: l_dummy_rec7 as_sales_leads_pub.sales_lead_rec_type;

Line 1834: l_dummy_rec3 hz_contact_point_v2pub.contact_point_rec_type;

1830:
1831: -- aanjaria enh tcav2
1832: -- Dummy
1833: l_dummy_rec2 hz_location_v2pub.location_rec_type;
1834: l_dummy_rec3 hz_contact_point_v2pub.contact_point_rec_type;
1835: l_dummy_rec4 hz_party_site_v2pub.party_site_rec_type;
1836: l_dummy_rec5 hz_party_contact_v2pub.org_contact_rec_type;
1837: l_dummy_rec6 hz_party_contact_v2pub.org_contact_role_rec_type;
1838: l_dummy_rec7 as_sales_leads_pub.sales_lead_rec_type;

Line 1947: l_dummy_rec3 hz_contact_point_v2pub.contact_point_rec_type;

1943:
1944: -- Dummy
1945: l_dummy_rec1 hz_party_v2pub.party_rec_type;
1946: l_dummy_rec2 hz_location_v2pub.location_rec_type;
1947: l_dummy_rec3 hz_contact_point_v2pub.contact_point_rec_type;
1948: --l_dummy_rec4 hz_party_pub.party_site_rec_type;
1949: l_dummy_rec5 hz_party_contact_v2pub.org_contact_rec_type;
1950: l_dummy_rec6 hz_party_contact_v2pub.org_contact_role_rec_type;
1951: l_dummy_rec7 as_sales_leads_pub.sales_lead_rec_type;

Line 2077: l_dummy_rec3 hz_contact_point_v2pub.contact_point_rec_type;

2073:
2074: -- Dummy
2075: l_dummy_rec1 hz_party_v2pub.party_rec_type;
2076: l_dummy_rec2 hz_location_v2pub.location_rec_type;
2077: l_dummy_rec3 hz_contact_point_v2pub.contact_point_rec_type;
2078: l_dummy_rec4 hz_party_site_v2pub.party_site_rec_type;
2079: l_dummy_rec5 hz_party_contact_v2pub.org_contact_rec_type;
2080: l_dummy_rec6 hz_party_contact_v2pub.org_contact_role_rec_type;
2081: l_dummy_rec7 as_sales_leads_pub.sales_lead_rec_type;

Line 2360: l_dummy_rec3 hz_contact_point_v2pub.contact_point_rec_type;

2356:
2357: -- Dummy
2358: l_dummy_rec1 hz_party_v2pub.party_rec_type;
2359: l_dummy_rec2 hz_location_v2pub.location_rec_type;
2360: l_dummy_rec3 hz_contact_point_v2pub.contact_point_rec_type;
2361: l_dummy_rec4 hz_party_site_v2pub.party_site_rec_type;
2362: l_dummy_rec5 hz_party_contact_v2pub.org_contact_rec_type;
2363: l_dummy_rec6 hz_party_contact_v2pub.org_contact_role_rec_type;
2364: l_dummy_rec7 as_sales_leads_pub.sales_lead_rec_type;