DBA Data[Home] [Help]

APPS.HZ_DQM_SYNC dependencies on HZ_PARTY_SEARCH

Line 1438: l_party_site_search_rec HZ_PARTY_SEARCH.party_site_search_rec_type;

1434: ) IS
1435:
1436: l_party_id NUMBER;
1437: l_party_site_id NUMBER;
1438: l_party_site_search_rec HZ_PARTY_SEARCH.party_site_search_rec_type;
1439: l_party_site_stage_rec HZ_PARTY_STAGE.PARTY_SITE_STAGE_REC_TYPE;
1440:
1441: BEGIN
1442: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1497: l_cpt_search_rec HZ_PARTY_SEARCH.contact_point_search_rec_type;

1493: x_return_status OUT NOCOPY VARCHAR2
1494: ) IS
1495:
1496: l_contact_point_id NUMBER;
1497: l_cpt_search_rec HZ_PARTY_SEARCH.contact_point_search_rec_type;
1498: l_contact_pt_stage_rec HZ_PARTY_STAGE.CONTACT_PT_STAGE_REC_TYPE;
1499: l_party_id NUMBER := 0;
1500: l_pr_id NUMBER;
1501: l_num_ocs NUMBER;

Line 1640: l_contact_search_rec HZ_PARTY_SEARCH.contact_search_rec_type;

1636: ) IS
1637:
1638: l_org_contact_id NUMBER;
1639: l_party_id NUMBER;
1640: l_contact_search_rec HZ_PARTY_SEARCH.contact_search_rec_type;
1641: l_contact_stage_rec HZ_PARTY_STAGE.CONTACT_STAGE_REC_TYPE;
1642: l_rel_party_id NUMBER;
1643: BEGIN
1644: