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,
531: pAssllTbl in OUT NOCOPY as_sales_leads_pub.sales_lead_line_tbl_type,
532: pAsslcTbl in OUT NOCOPY as_sales_leads_pub.sales_lead_contact_tbl_type,
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;
898: l_dummy_tbl9 as_sales_leads_pub.sales_lead_contact_tbl_type;
899:
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;
1296: l_dummy_tbl8 as_sales_leads_pub.sales_lead_line_tbl_type;
1297: l_dummy_tbl9 as_sales_leads_pub.sales_lead_contact_tbl_type;
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;
1727: l_dummy_tbl8 as_sales_leads_pub.sales_lead_line_tbl_type;
1728: l_dummy_tbl9 as_sales_leads_pub.sales_lead_contact_tbl_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;
1727: l_dummy_tbl8 as_sales_leads_pub.sales_lead_line_tbl_type;
1728: l_dummy_tbl9 as_sales_leads_pub.sales_lead_contact_tbl_type;
1729:
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;
1839: l_dummy_tbl8 as_sales_leads_pub.sales_lead_line_tbl_type;
1840: l_dummy_tbl9 as_sales_leads_pub.sales_lead_contact_tbl_type;
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;
1839: l_dummy_tbl8 as_sales_leads_pub.sales_lead_line_tbl_type;
1840: l_dummy_tbl9 as_sales_leads_pub.sales_lead_contact_tbl_type;
1841:
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;
1952: l_dummy_tbl8 as_sales_leads_pub.sales_lead_line_tbl_type;
1953: l_dummy_tbl9 as_sales_leads_pub.sales_lead_contact_tbl_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;
1952: l_dummy_tbl8 as_sales_leads_pub.sales_lead_line_tbl_type;
1953: l_dummy_tbl9 as_sales_leads_pub.sales_lead_contact_tbl_type;
1954:
2053:
2054: ----------------------------------------------------------
2055: -- name: do_create_relationship
2056: -- scope: private
2057: -- calls HZ_PARTY_CONTACT_V2PUB.create_org_contact
2058: -- inserts party relationship and creates org_contact
2059: ----------------------------------------------------------
2060: procedure do_create_relationship(
2061: pI IN OUT NOCOPY leadImpType,
2060: procedure do_create_relationship(
2061: pI IN OUT NOCOPY leadImpType,
2062: G_return_status OUT NOCOPY varchar2)
2063: IS
2064: l_org_con_rec hz_party_contact_v2pub.org_contact_rec_type;
2065: l_role_rec hz_party_contact_v2pub.org_contact_role_rec_type;
2066: -- l_rel_rec hz_party_pub.party_rel_rec_type;
2067: --l_org_contact_id NUMBER;
2068: l_party_rel_id NUMBER;
2061: pI IN OUT NOCOPY leadImpType,
2062: G_return_status OUT NOCOPY varchar2)
2063: IS
2064: l_org_con_rec hz_party_contact_v2pub.org_contact_rec_type;
2065: l_role_rec hz_party_contact_v2pub.org_contact_role_rec_type;
2066: -- l_rel_rec hz_party_pub.party_rel_rec_type;
2067: --l_org_contact_id NUMBER;
2068: l_party_rel_id NUMBER;
2069: l_party_id NUMBER;
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;
2082: l_dummy_tbl8 as_sales_leads_pub.sales_lead_line_tbl_type;
2083: l_dummy_tbl9 as_sales_leads_pub.sales_lead_contact_tbl_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;
2082: l_dummy_tbl8 as_sales_leads_pub.sales_lead_line_tbl_type;
2083: l_dummy_tbl9 as_sales_leads_pub.sales_lead_contact_tbl_type;
2084:
2158: G_return_status
2159: );
2160: If G_return_status = FND_API.G_RET_STS_SUCCESS Then
2161: write_log(3, 'Creating OrgContact');
2162: HZ_PARTY_CONTACT_V2PUB.create_org_contact (
2163: p_init_msg_list => FND_API.G_FALSE,
2164: p_org_contact_rec => l_org_con_rec,
2165: x_return_status => G_return_status,
2166: x_msg_count => G_MESG_COUNT,
2210: Then
2211: If G_return_status = FND_API.G_RET_STS_SUCCESS
2212: Then
2213: write_log(3, 'Creating OrgContactRole(1)');
2214: HZ_PARTY_CONTACT_V2PUB.create_org_contact_role (
2215: p_init_msg_list => FND_API.G_FALSE,
2216: p_org_contact_role_rec => l_role_rec,
2217: x_return_status => G_return_status,
2218: x_msg_count => G_MESG_COUNT,
2284: *** */
2285: If G_return_status = FND_API.G_RET_STS_SUCCESS
2286: Then
2287: write_log(3, 'Creating OrgContactRole(2)');
2288: HZ_PARTY_CONTACT_V2PUB.create_org_contact_role (
2289: p_init_msg_list => FND_API.G_FALSE,
2290: p_org_contact_role_rec => l_role_rec,
2291: x_return_status => G_return_status,
2292: x_msg_count => G_MESG_COUNT,
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;
2365: l_dummy_tbl8 as_sales_leads_pub.sales_lead_line_tbl_type;
2366: l_dummy_tbl9 as_sales_leads_pub.sales_lead_contact_tbl_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;
2365: l_dummy_tbl8 as_sales_leads_pub.sales_lead_line_tbl_type;
2366: l_dummy_tbl9 as_sales_leads_pub.sales_lead_contact_tbl_type;
2367: