DBA Data[Home] [Help]

APPS.AMS_LISTIMPORT_PVT dependencies on HZ_CONTACT_POINT_V2PUB

Line 941: cpoint_rec hz_contact_point_v2pub.contact_point_rec_type;

937: person_rec hz_party_v2pub.person_rec_type;
938: location_rec hz_location_v2pub.location_rec_type;
939: psite_rec hz_party_site_v2pub.party_site_rec_type;
940: psiteuse_rec hz_party_site_v2pub.party_site_use_rec_type;
941: cpoint_rec hz_contact_point_v2pub.contact_point_rec_type;
942: email_rec hz_contact_point_v2pub.email_rec_type;
943: phone_rec hz_contact_point_v2pub.phone_rec_type;
944: fax_rec hz_contact_point_v2pub.phone_rec_type;
945: ocon_rec hz_party_contact_v2pub.org_contact_rec_type;

Line 942: email_rec hz_contact_point_v2pub.email_rec_type;

938: location_rec hz_location_v2pub.location_rec_type;
939: psite_rec hz_party_site_v2pub.party_site_rec_type;
940: psiteuse_rec hz_party_site_v2pub.party_site_use_rec_type;
941: cpoint_rec hz_contact_point_v2pub.contact_point_rec_type;
942: email_rec hz_contact_point_v2pub.email_rec_type;
943: phone_rec hz_contact_point_v2pub.phone_rec_type;
944: fax_rec hz_contact_point_v2pub.phone_rec_type;
945: ocon_rec hz_party_contact_v2pub.org_contact_rec_type;
946: edi_rec hz_contact_point_v2pub.edi_rec_type;

Line 943: phone_rec hz_contact_point_v2pub.phone_rec_type;

939: psite_rec hz_party_site_v2pub.party_site_rec_type;
940: psiteuse_rec hz_party_site_v2pub.party_site_use_rec_type;
941: cpoint_rec hz_contact_point_v2pub.contact_point_rec_type;
942: email_rec hz_contact_point_v2pub.email_rec_type;
943: phone_rec hz_contact_point_v2pub.phone_rec_type;
944: fax_rec hz_contact_point_v2pub.phone_rec_type;
945: ocon_rec hz_party_contact_v2pub.org_contact_rec_type;
946: edi_rec hz_contact_point_v2pub.edi_rec_type;
947: telex_rec hz_contact_point_v2pub.telex_rec_type;

Line 944: fax_rec hz_contact_point_v2pub.phone_rec_type;

940: psiteuse_rec hz_party_site_v2pub.party_site_use_rec_type;
941: cpoint_rec hz_contact_point_v2pub.contact_point_rec_type;
942: email_rec hz_contact_point_v2pub.email_rec_type;
943: phone_rec hz_contact_point_v2pub.phone_rec_type;
944: fax_rec hz_contact_point_v2pub.phone_rec_type;
945: ocon_rec hz_party_contact_v2pub.org_contact_rec_type;
946: edi_rec hz_contact_point_v2pub.edi_rec_type;
947: telex_rec hz_contact_point_v2pub.telex_rec_type;
948: web_rec hz_contact_point_v2pub.web_rec_type;

Line 946: edi_rec hz_contact_point_v2pub.edi_rec_type;

942: email_rec hz_contact_point_v2pub.email_rec_type;
943: phone_rec hz_contact_point_v2pub.phone_rec_type;
944: fax_rec hz_contact_point_v2pub.phone_rec_type;
945: ocon_rec hz_party_contact_v2pub.org_contact_rec_type;
946: edi_rec hz_contact_point_v2pub.edi_rec_type;
947: telex_rec hz_contact_point_v2pub.telex_rec_type;
948: web_rec hz_contact_point_v2pub.web_rec_type;
949:
950: org_email_rec hz_contact_point_v2pub.email_rec_type;

Line 947: telex_rec hz_contact_point_v2pub.telex_rec_type;

943: phone_rec hz_contact_point_v2pub.phone_rec_type;
944: fax_rec hz_contact_point_v2pub.phone_rec_type;
945: ocon_rec hz_party_contact_v2pub.org_contact_rec_type;
946: edi_rec hz_contact_point_v2pub.edi_rec_type;
947: telex_rec hz_contact_point_v2pub.telex_rec_type;
948: web_rec hz_contact_point_v2pub.web_rec_type;
949:
950: org_email_rec hz_contact_point_v2pub.email_rec_type;
951: org_phone_rec hz_contact_point_v2pub.phone_rec_type;

Line 948: web_rec hz_contact_point_v2pub.web_rec_type;

944: fax_rec hz_contact_point_v2pub.phone_rec_type;
945: ocon_rec hz_party_contact_v2pub.org_contact_rec_type;
946: edi_rec hz_contact_point_v2pub.edi_rec_type;
947: telex_rec hz_contact_point_v2pub.telex_rec_type;
948: web_rec hz_contact_point_v2pub.web_rec_type;
949:
950: org_email_rec hz_contact_point_v2pub.email_rec_type;
951: org_phone_rec hz_contact_point_v2pub.phone_rec_type;
952: org_location_rec hz_location_v2pub.location_rec_type;

Line 950: org_email_rec hz_contact_point_v2pub.email_rec_type;

946: edi_rec hz_contact_point_v2pub.edi_rec_type;
947: telex_rec hz_contact_point_v2pub.telex_rec_type;
948: web_rec hz_contact_point_v2pub.web_rec_type;
949:
950: org_email_rec hz_contact_point_v2pub.email_rec_type;
951: org_phone_rec hz_contact_point_v2pub.phone_rec_type;
952: org_location_rec hz_location_v2pub.location_rec_type;
953: org_psite_rec hz_party_site_v2pub.party_site_rec_type;
954: language_rec HZ_PERSON_INFO_V2PUB.person_language_rec_type;

Line 951: org_phone_rec hz_contact_point_v2pub.phone_rec_type;

947: telex_rec hz_contact_point_v2pub.telex_rec_type;
948: web_rec hz_contact_point_v2pub.web_rec_type;
949:
950: org_email_rec hz_contact_point_v2pub.email_rec_type;
951: org_phone_rec hz_contact_point_v2pub.phone_rec_type;
952: org_location_rec hz_location_v2pub.location_rec_type;
953: org_psite_rec hz_party_site_v2pub.party_site_rec_type;
954: language_rec HZ_PERSON_INFO_V2PUB.person_language_rec_type;
955:

Line 4913: cpoint_rec hz_contact_point_v2pub.contact_point_rec_type;

4909: person_rec hz_party_v2pub.person_rec_type;
4910: location_rec hz_location_v2pub.location_rec_type;
4911: psite_rec hz_party_site_v2pub.party_site_rec_type;
4912: psiteuse_rec hz_party_site_v2pub.party_site_use_rec_type;
4913: cpoint_rec hz_contact_point_v2pub.contact_point_rec_type;
4914: email_rec hz_contact_point_v2pub.email_rec_type;
4915: phone_rec hz_contact_point_v2pub.phone_rec_type;
4916: ocon_rec hz_party_contact_v2pub.org_contact_rec_type;
4917: edi_rec hz_contact_point_v2pub.edi_rec_type;

Line 4914: email_rec hz_contact_point_v2pub.email_rec_type;

4910: location_rec hz_location_v2pub.location_rec_type;
4911: psite_rec hz_party_site_v2pub.party_site_rec_type;
4912: psiteuse_rec hz_party_site_v2pub.party_site_use_rec_type;
4913: cpoint_rec hz_contact_point_v2pub.contact_point_rec_type;
4914: email_rec hz_contact_point_v2pub.email_rec_type;
4915: phone_rec hz_contact_point_v2pub.phone_rec_type;
4916: ocon_rec hz_party_contact_v2pub.org_contact_rec_type;
4917: edi_rec hz_contact_point_v2pub.edi_rec_type;
4918: telex_rec hz_contact_point_v2pub.telex_rec_type;

Line 4915: phone_rec hz_contact_point_v2pub.phone_rec_type;

4911: psite_rec hz_party_site_v2pub.party_site_rec_type;
4912: psiteuse_rec hz_party_site_v2pub.party_site_use_rec_type;
4913: cpoint_rec hz_contact_point_v2pub.contact_point_rec_type;
4914: email_rec hz_contact_point_v2pub.email_rec_type;
4915: phone_rec hz_contact_point_v2pub.phone_rec_type;
4916: ocon_rec hz_party_contact_v2pub.org_contact_rec_type;
4917: edi_rec hz_contact_point_v2pub.edi_rec_type;
4918: telex_rec hz_contact_point_v2pub.telex_rec_type;
4919: web_rec hz_contact_point_v2pub.web_rec_type;

Line 4917: edi_rec hz_contact_point_v2pub.edi_rec_type;

4913: cpoint_rec hz_contact_point_v2pub.contact_point_rec_type;
4914: email_rec hz_contact_point_v2pub.email_rec_type;
4915: phone_rec hz_contact_point_v2pub.phone_rec_type;
4916: ocon_rec hz_party_contact_v2pub.org_contact_rec_type;
4917: edi_rec hz_contact_point_v2pub.edi_rec_type;
4918: telex_rec hz_contact_point_v2pub.telex_rec_type;
4919: web_rec hz_contact_point_v2pub.web_rec_type;
4920: fax_rec hz_contact_point_v2pub.phone_rec_type;
4921:

Line 4918: telex_rec hz_contact_point_v2pub.telex_rec_type;

4914: email_rec hz_contact_point_v2pub.email_rec_type;
4915: phone_rec hz_contact_point_v2pub.phone_rec_type;
4916: ocon_rec hz_party_contact_v2pub.org_contact_rec_type;
4917: edi_rec hz_contact_point_v2pub.edi_rec_type;
4918: telex_rec hz_contact_point_v2pub.telex_rec_type;
4919: web_rec hz_contact_point_v2pub.web_rec_type;
4920: fax_rec hz_contact_point_v2pub.phone_rec_type;
4921:
4922:

Line 4919: web_rec hz_contact_point_v2pub.web_rec_type;

4915: phone_rec hz_contact_point_v2pub.phone_rec_type;
4916: ocon_rec hz_party_contact_v2pub.org_contact_rec_type;
4917: edi_rec hz_contact_point_v2pub.edi_rec_type;
4918: telex_rec hz_contact_point_v2pub.telex_rec_type;
4919: web_rec hz_contact_point_v2pub.web_rec_type;
4920: fax_rec hz_contact_point_v2pub.phone_rec_type;
4921:
4922:
4923: begin

Line 4920: fax_rec hz_contact_point_v2pub.phone_rec_type;

4916: ocon_rec hz_party_contact_v2pub.org_contact_rec_type;
4917: edi_rec hz_contact_point_v2pub.edi_rec_type;
4918: telex_rec hz_contact_point_v2pub.telex_rec_type;
4919: web_rec hz_contact_point_v2pub.web_rec_type;
4920: fax_rec hz_contact_point_v2pub.phone_rec_type;
4921:
4922:
4923: begin
4924:

Line 13420: p_cpoint_rec IN hz_contact_point_v2pub.contact_point_rec_type,

13416: end exe_custxml_data_validation;
13417: -- ----------------------------------------------
13418:
13419: procedure create_contact_point(
13420: p_cpoint_rec IN hz_contact_point_v2pub.contact_point_rec_type,
13421: p_edi_rec IN hz_contact_point_v2pub.edi_rec_type,
13422: p_email_rec IN hz_contact_point_v2pub.email_rec_type,
13423: p_phone_rec IN hz_contact_point_v2pub.phone_rec_type,
13424: p_telex_rec IN hz_contact_point_v2pub.telex_rec_type,

Line 13421: p_edi_rec IN hz_contact_point_v2pub.edi_rec_type,

13417: -- ----------------------------------------------
13418:
13419: procedure create_contact_point(
13420: p_cpoint_rec IN hz_contact_point_v2pub.contact_point_rec_type,
13421: p_edi_rec IN hz_contact_point_v2pub.edi_rec_type,
13422: p_email_rec IN hz_contact_point_v2pub.email_rec_type,
13423: p_phone_rec IN hz_contact_point_v2pub.phone_rec_type,
13424: p_telex_rec IN hz_contact_point_v2pub.telex_rec_type,
13425: p_web_rec IN hz_contact_point_v2pub.web_rec_type,

Line 13422: p_email_rec IN hz_contact_point_v2pub.email_rec_type,

13418:
13419: procedure create_contact_point(
13420: p_cpoint_rec IN hz_contact_point_v2pub.contact_point_rec_type,
13421: p_edi_rec IN hz_contact_point_v2pub.edi_rec_type,
13422: p_email_rec IN hz_contact_point_v2pub.email_rec_type,
13423: p_phone_rec IN hz_contact_point_v2pub.phone_rec_type,
13424: p_telex_rec IN hz_contact_point_v2pub.telex_rec_type,
13425: p_web_rec IN hz_contact_point_v2pub.web_rec_type,
13426: x_return_status OUT NOCOPY VARCHAR2,

Line 13423: p_phone_rec IN hz_contact_point_v2pub.phone_rec_type,

13419: procedure create_contact_point(
13420: p_cpoint_rec IN hz_contact_point_v2pub.contact_point_rec_type,
13421: p_edi_rec IN hz_contact_point_v2pub.edi_rec_type,
13422: p_email_rec IN hz_contact_point_v2pub.email_rec_type,
13423: p_phone_rec IN hz_contact_point_v2pub.phone_rec_type,
13424: p_telex_rec IN hz_contact_point_v2pub.telex_rec_type,
13425: p_web_rec IN hz_contact_point_v2pub.web_rec_type,
13426: x_return_status OUT NOCOPY VARCHAR2,
13427: x_msg_count OUT NOCOPY NUMBER,

Line 13424: p_telex_rec IN hz_contact_point_v2pub.telex_rec_type,

13420: p_cpoint_rec IN hz_contact_point_v2pub.contact_point_rec_type,
13421: p_edi_rec IN hz_contact_point_v2pub.edi_rec_type,
13422: p_email_rec IN hz_contact_point_v2pub.email_rec_type,
13423: p_phone_rec IN hz_contact_point_v2pub.phone_rec_type,
13424: p_telex_rec IN hz_contact_point_v2pub.telex_rec_type,
13425: p_web_rec IN hz_contact_point_v2pub.web_rec_type,
13426: x_return_status OUT NOCOPY VARCHAR2,
13427: x_msg_count OUT NOCOPY NUMBER,
13428: x_msg_data OUT NOCOPY VARCHAR2,

Line 13425: p_web_rec IN hz_contact_point_v2pub.web_rec_type,

13421: p_edi_rec IN hz_contact_point_v2pub.edi_rec_type,
13422: p_email_rec IN hz_contact_point_v2pub.email_rec_type,
13423: p_phone_rec IN hz_contact_point_v2pub.phone_rec_type,
13424: p_telex_rec IN hz_contact_point_v2pub.telex_rec_type,
13425: p_web_rec IN hz_contact_point_v2pub.web_rec_type,
13426: x_return_status OUT NOCOPY VARCHAR2,
13427: x_msg_count OUT NOCOPY NUMBER,
13428: x_msg_data OUT NOCOPY VARCHAR2,
13429: x_contact_point_id OUT NOCOPY NUMBER

Line 13432: cpoint_rec hz_contact_point_v2pub.contact_point_rec_type := p_cpoint_rec;

13428: x_msg_data OUT NOCOPY VARCHAR2,
13429: x_contact_point_id OUT NOCOPY NUMBER
13430: ) is
13431:
13432: cpoint_rec hz_contact_point_v2pub.contact_point_rec_type := p_cpoint_rec;
13433: email_rec hz_contact_point_v2pub.email_rec_type := p_email_rec;
13434: phone_rec hz_contact_point_v2pub.phone_rec_type := p_phone_rec;
13435: edi_rec hz_contact_point_v2pub.edi_rec_type := p_edi_rec;
13436: telex_rec hz_contact_point_v2pub.telex_rec_type := p_telex_rec;

Line 13433: email_rec hz_contact_point_v2pub.email_rec_type := p_email_rec;

13429: x_contact_point_id OUT NOCOPY NUMBER
13430: ) is
13431:
13432: cpoint_rec hz_contact_point_v2pub.contact_point_rec_type := p_cpoint_rec;
13433: email_rec hz_contact_point_v2pub.email_rec_type := p_email_rec;
13434: phone_rec hz_contact_point_v2pub.phone_rec_type := p_phone_rec;
13435: edi_rec hz_contact_point_v2pub.edi_rec_type := p_edi_rec;
13436: telex_rec hz_contact_point_v2pub.telex_rec_type := p_telex_rec;
13437: web_rec hz_contact_point_v2pub.web_rec_type := p_web_rec ;

Line 13434: phone_rec hz_contact_point_v2pub.phone_rec_type := p_phone_rec;

13430: ) is
13431:
13432: cpoint_rec hz_contact_point_v2pub.contact_point_rec_type := p_cpoint_rec;
13433: email_rec hz_contact_point_v2pub.email_rec_type := p_email_rec;
13434: phone_rec hz_contact_point_v2pub.phone_rec_type := p_phone_rec;
13435: edi_rec hz_contact_point_v2pub.edi_rec_type := p_edi_rec;
13436: telex_rec hz_contact_point_v2pub.telex_rec_type := p_telex_rec;
13437: web_rec hz_contact_point_v2pub.web_rec_type := p_web_rec ;
13438:

Line 13435: edi_rec hz_contact_point_v2pub.edi_rec_type := p_edi_rec;

13431:
13432: cpoint_rec hz_contact_point_v2pub.contact_point_rec_type := p_cpoint_rec;
13433: email_rec hz_contact_point_v2pub.email_rec_type := p_email_rec;
13434: phone_rec hz_contact_point_v2pub.phone_rec_type := p_phone_rec;
13435: edi_rec hz_contact_point_v2pub.edi_rec_type := p_edi_rec;
13436: telex_rec hz_contact_point_v2pub.telex_rec_type := p_telex_rec;
13437: web_rec hz_contact_point_v2pub.web_rec_type := p_web_rec ;
13438:
13439: begin

Line 13436: telex_rec hz_contact_point_v2pub.telex_rec_type := p_telex_rec;

13432: cpoint_rec hz_contact_point_v2pub.contact_point_rec_type := p_cpoint_rec;
13433: email_rec hz_contact_point_v2pub.email_rec_type := p_email_rec;
13434: phone_rec hz_contact_point_v2pub.phone_rec_type := p_phone_rec;
13435: edi_rec hz_contact_point_v2pub.edi_rec_type := p_edi_rec;
13436: telex_rec hz_contact_point_v2pub.telex_rec_type := p_telex_rec;
13437: web_rec hz_contact_point_v2pub.web_rec_type := p_web_rec ;
13438:
13439: begin
13440: SELECT hz_contact_points_s.nextval into x_contact_point_id from dual;

Line 13437: web_rec hz_contact_point_v2pub.web_rec_type := p_web_rec ;

13433: email_rec hz_contact_point_v2pub.email_rec_type := p_email_rec;
13434: phone_rec hz_contact_point_v2pub.phone_rec_type := p_phone_rec;
13435: edi_rec hz_contact_point_v2pub.edi_rec_type := p_edi_rec;
13436: telex_rec hz_contact_point_v2pub.telex_rec_type := p_telex_rec;
13437: web_rec hz_contact_point_v2pub.web_rec_type := p_web_rec ;
13438:
13439: begin
13440: SELECT hz_contact_points_s.nextval into x_contact_point_id from dual;
13441:

Line 13446: hz_contact_point_v2pub.create_contact_point(

13442: cpoint_rec.contact_point_id := x_contact_point_id;
13443: cpoint_rec.orig_system_reference := x_contact_point_id;
13444: cpoint_rec.CREATED_BY_MODULE := 'AMS_LIST_IMPORT';
13445: cpoint_rec.application_id := 530;
13446: hz_contact_point_v2pub.create_contact_point(
13447: 'F',
13448: cpoint_rec,
13449: edi_rec,
13450: email_rec,

Line 16165: cpoint_rec hz_contact_point_v2pub.contact_point_rec_type;

16161: org_rec hz_party_v2pub.organization_rec_type;
16162: person_rec hz_party_v2pub.person_rec_type;
16163: location_rec hz_location_v2pub.location_rec_type;
16164: psite_rec hz_party_site_v2pub.party_site_rec_type;
16165: cpoint_rec hz_contact_point_v2pub.contact_point_rec_type;
16166: email_rec hz_contact_point_v2pub.email_rec_type;
16167: phone_rec hz_contact_point_v2pub.phone_rec_type;
16168: ocon_rec hz_party_contact_v2pub.org_contact_rec_type;
16169: edi_rec hz_contact_point_v2pub.edi_rec_type;

Line 16166: email_rec hz_contact_point_v2pub.email_rec_type;

16162: person_rec hz_party_v2pub.person_rec_type;
16163: location_rec hz_location_v2pub.location_rec_type;
16164: psite_rec hz_party_site_v2pub.party_site_rec_type;
16165: cpoint_rec hz_contact_point_v2pub.contact_point_rec_type;
16166: email_rec hz_contact_point_v2pub.email_rec_type;
16167: phone_rec hz_contact_point_v2pub.phone_rec_type;
16168: ocon_rec hz_party_contact_v2pub.org_contact_rec_type;
16169: edi_rec hz_contact_point_v2pub.edi_rec_type;
16170: telex_rec hz_contact_point_v2pub.telex_rec_type;

Line 16167: phone_rec hz_contact_point_v2pub.phone_rec_type;

16163: location_rec hz_location_v2pub.location_rec_type;
16164: psite_rec hz_party_site_v2pub.party_site_rec_type;
16165: cpoint_rec hz_contact_point_v2pub.contact_point_rec_type;
16166: email_rec hz_contact_point_v2pub.email_rec_type;
16167: phone_rec hz_contact_point_v2pub.phone_rec_type;
16168: ocon_rec hz_party_contact_v2pub.org_contact_rec_type;
16169: edi_rec hz_contact_point_v2pub.edi_rec_type;
16170: telex_rec hz_contact_point_v2pub.telex_rec_type;
16171: web_rec hz_contact_point_v2pub.web_rec_type;

Line 16169: edi_rec hz_contact_point_v2pub.edi_rec_type;

16165: cpoint_rec hz_contact_point_v2pub.contact_point_rec_type;
16166: email_rec hz_contact_point_v2pub.email_rec_type;
16167: phone_rec hz_contact_point_v2pub.phone_rec_type;
16168: ocon_rec hz_party_contact_v2pub.org_contact_rec_type;
16169: edi_rec hz_contact_point_v2pub.edi_rec_type;
16170: telex_rec hz_contact_point_v2pub.telex_rec_type;
16171: web_rec hz_contact_point_v2pub.web_rec_type;
16172:
16173:

Line 16170: telex_rec hz_contact_point_v2pub.telex_rec_type;

16166: email_rec hz_contact_point_v2pub.email_rec_type;
16167: phone_rec hz_contact_point_v2pub.phone_rec_type;
16168: ocon_rec hz_party_contact_v2pub.org_contact_rec_type;
16169: edi_rec hz_contact_point_v2pub.edi_rec_type;
16170: telex_rec hz_contact_point_v2pub.telex_rec_type;
16171: web_rec hz_contact_point_v2pub.web_rec_type;
16172:
16173:
16174: l_orgid_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;

Line 16171: web_rec hz_contact_point_v2pub.web_rec_type;

16167: phone_rec hz_contact_point_v2pub.phone_rec_type;
16168: ocon_rec hz_party_contact_v2pub.org_contact_rec_type;
16169: edi_rec hz_contact_point_v2pub.edi_rec_type;
16170: telex_rec hz_contact_point_v2pub.telex_rec_type;
16171: web_rec hz_contact_point_v2pub.web_rec_type;
16172:
16173:
16174: l_orgid_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
16175: l_locid_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;

Line 17115: cpoint_rec hz_contact_point_v2pub.contact_point_rec_type;

17111: org_rec hz_party_v2pub.organization_rec_type;
17112: person_rec hz_party_v2pub.person_rec_type;
17113: location_rec hz_location_v2pub.location_rec_type;
17114: psite_rec hz_party_site_v2pub.party_site_rec_type;
17115: cpoint_rec hz_contact_point_v2pub.contact_point_rec_type;
17116: email_rec hz_contact_point_v2pub.email_rec_type;
17117: phone_rec hz_contact_point_v2pub.phone_rec_type;
17118: ocon_rec hz_party_contact_v2pub.org_contact_rec_type;
17119: edi_rec hz_contact_point_v2pub.edi_rec_type;

Line 17116: email_rec hz_contact_point_v2pub.email_rec_type;

17112: person_rec hz_party_v2pub.person_rec_type;
17113: location_rec hz_location_v2pub.location_rec_type;
17114: psite_rec hz_party_site_v2pub.party_site_rec_type;
17115: cpoint_rec hz_contact_point_v2pub.contact_point_rec_type;
17116: email_rec hz_contact_point_v2pub.email_rec_type;
17117: phone_rec hz_contact_point_v2pub.phone_rec_type;
17118: ocon_rec hz_party_contact_v2pub.org_contact_rec_type;
17119: edi_rec hz_contact_point_v2pub.edi_rec_type;
17120: telex_rec hz_contact_point_v2pub.telex_rec_type;

Line 17117: phone_rec hz_contact_point_v2pub.phone_rec_type;

17113: location_rec hz_location_v2pub.location_rec_type;
17114: psite_rec hz_party_site_v2pub.party_site_rec_type;
17115: cpoint_rec hz_contact_point_v2pub.contact_point_rec_type;
17116: email_rec hz_contact_point_v2pub.email_rec_type;
17117: phone_rec hz_contact_point_v2pub.phone_rec_type;
17118: ocon_rec hz_party_contact_v2pub.org_contact_rec_type;
17119: edi_rec hz_contact_point_v2pub.edi_rec_type;
17120: telex_rec hz_contact_point_v2pub.telex_rec_type;
17121: web_rec hz_contact_point_v2pub.web_rec_type;

Line 17119: edi_rec hz_contact_point_v2pub.edi_rec_type;

17115: cpoint_rec hz_contact_point_v2pub.contact_point_rec_type;
17116: email_rec hz_contact_point_v2pub.email_rec_type;
17117: phone_rec hz_contact_point_v2pub.phone_rec_type;
17118: ocon_rec hz_party_contact_v2pub.org_contact_rec_type;
17119: edi_rec hz_contact_point_v2pub.edi_rec_type;
17120: telex_rec hz_contact_point_v2pub.telex_rec_type;
17121: web_rec hz_contact_point_v2pub.web_rec_type;
17122:
17123: l_perid_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;

Line 17120: telex_rec hz_contact_point_v2pub.telex_rec_type;

17116: email_rec hz_contact_point_v2pub.email_rec_type;
17117: phone_rec hz_contact_point_v2pub.phone_rec_type;
17118: ocon_rec hz_party_contact_v2pub.org_contact_rec_type;
17119: edi_rec hz_contact_point_v2pub.edi_rec_type;
17120: telex_rec hz_contact_point_v2pub.telex_rec_type;
17121: web_rec hz_contact_point_v2pub.web_rec_type;
17122:
17123: l_perid_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
17124: l_locid_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;

Line 17121: web_rec hz_contact_point_v2pub.web_rec_type;

17117: phone_rec hz_contact_point_v2pub.phone_rec_type;
17118: ocon_rec hz_party_contact_v2pub.org_contact_rec_type;
17119: edi_rec hz_contact_point_v2pub.edi_rec_type;
17120: telex_rec hz_contact_point_v2pub.telex_rec_type;
17121: web_rec hz_contact_point_v2pub.web_rec_type;
17122:
17123: l_perid_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
17124: l_locid_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
17125: l_addid_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;