DBA Data[Home] [Help]

APPS.POS_SEARCH_DUP_PARTY_PKG dependencies on HZ_PARTIES

Line 244: l_contact_point_rec.owner_table_name := 'HZ_PARTIES';

240:
241: IF l_url IS NOT NULL THEN
242:
243: --populate contact point record
244: l_contact_point_rec.owner_table_name := 'HZ_PARTIES';
245: l_contact_point_rec.owner_table_id := x_org_party_id;
246: l_contact_point_rec.created_by_module := 'POS_SUPPLIER_MGMT';
247: l_contact_point_rec.application_id := 200;
248:

Line 372: from hz_parties

368:
369:
370: select object_version_number
371: into l_party_obj_version
372: from hz_parties
373: where party_id = p_party_id;
374:
375: l_org_rec.organization_name := p_supp_name;
376: l_org_rec.organization_name_phonetic := p_supp_name_alt;

Line 547: /* Get other data from hz_parties */

543: g_module || '.' || l_method,
544: l_step);
545: END IF;
546:
547: /* Get other data from hz_parties */
548: SELECT party_name, jgzz_fiscal_code, tax_reference
549: INTO l_vendor_name, l_taxpayer_id, l_taxreg_num
550: FROM hz_parties
551: WHERE party_id = l_party_id;

Line 550: FROM hz_parties

546:
547: /* Get other data from hz_parties */
548: SELECT party_name, jgzz_fiscal_code, tax_reference
549: INTO l_vendor_name, l_taxpayer_id, l_taxreg_num
550: FROM hz_parties
551: WHERE party_id = l_party_id;
552:
553: l_vendor_rec.party_id := l_party_id;
554: l_vendor_rec.segment1 := l_vendor_num;