DBA Data[Home] [Help]

APPS.AS_IMPORT_SL_PVT dependencies on HZ_PARTY_CONTACT_V2PUB

Line 528: pHzocRec in OUT NOCOPY hz_party_contact_v2pub.org_contact_rec_type,

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,

Line 895: l_dummy_rec5 hz_party_contact_v2pub.org_contact_rec_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:

Line 1293: l_dummy_rec5 hz_party_contact_v2pub.org_contact_rec_type;

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;

Line 1724: l_dummy_rec5 hz_party_contact_v2pub.org_contact_rec_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;

Line 1725: l_dummy_rec6 hz_party_contact_v2pub.org_contact_role_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;
1729:

Line 1836: l_dummy_rec5 hz_party_contact_v2pub.org_contact_rec_type;

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;

Line 1837: l_dummy_rec6 hz_party_contact_v2pub.org_contact_role_rec_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:

Line 1949: l_dummy_rec5 hz_party_contact_v2pub.org_contact_rec_type;

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;

Line 1950: l_dummy_rec6 hz_party_contact_v2pub.org_contact_role_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;
1954:

Line 2057: -- calls HZ_PARTY_CONTACT_V2PUB.create_org_contact

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,

Line 2064: l_org_con_rec hz_party_contact_v2pub.org_contact_rec_type;

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;

Line 2065: l_role_rec hz_party_contact_v2pub.org_contact_role_rec_type;

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;

Line 2079: l_dummy_rec5 hz_party_contact_v2pub.org_contact_rec_type;

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;

Line 2080: l_dummy_rec6 hz_party_contact_v2pub.org_contact_role_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;
2084:

Line 2162: HZ_PARTY_CONTACT_V2PUB.create_org_contact (

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,

Line 2214: HZ_PARTY_CONTACT_V2PUB.create_org_contact_role (

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,

Line 2288: HZ_PARTY_CONTACT_V2PUB.create_org_contact_role (

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,

Line 2362: l_dummy_rec5 hz_party_contact_v2pub.org_contact_rec_type;

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;

Line 2363: l_dummy_rec6 hz_party_contact_v2pub.org_contact_role_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;
2367: