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 4912: cpoint_rec hz_contact_point_v2pub.contact_point_rec_type;

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

Line 4913: email_rec hz_contact_point_v2pub.email_rec_type;

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

Line 4914: phone_rec hz_contact_point_v2pub.phone_rec_type;

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

Line 4916: edi_rec hz_contact_point_v2pub.edi_rec_type;

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

Line 4917: telex_rec hz_contact_point_v2pub.telex_rec_type;

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

Line 4918: web_rec hz_contact_point_v2pub.web_rec_type;

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

Line 4919: fax_rec hz_contact_point_v2pub.phone_rec_type;

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

Line 13419: p_cpoint_rec IN hz_contact_point_v2pub.contact_point_rec_type,

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

Line 13420: p_edi_rec IN hz_contact_point_v2pub.edi_rec_type,

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

Line 13421: p_email_rec IN hz_contact_point_v2pub.email_rec_type,

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

Line 13422: p_phone_rec IN hz_contact_point_v2pub.phone_rec_type,

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

Line 13423: p_telex_rec IN hz_contact_point_v2pub.telex_rec_type,

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

Line 13424: p_web_rec IN hz_contact_point_v2pub.web_rec_type,

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

Line 13431: cpoint_rec hz_contact_point_v2pub.contact_point_rec_type := p_cpoint_rec;

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

Line 13432: email_rec hz_contact_point_v2pub.email_rec_type := p_email_rec;

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

Line 13433: phone_rec hz_contact_point_v2pub.phone_rec_type := p_phone_rec;

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

Line 13434: edi_rec hz_contact_point_v2pub.edi_rec_type := p_edi_rec;

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

Line 13435: telex_rec hz_contact_point_v2pub.telex_rec_type := p_telex_rec;

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

Line 13436: web_rec hz_contact_point_v2pub.web_rec_type := p_web_rec ;

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

Line 13445: hz_contact_point_v2pub.create_contact_point(

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

Line 16164: cpoint_rec hz_contact_point_v2pub.contact_point_rec_type;

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

Line 16165: email_rec hz_contact_point_v2pub.email_rec_type;

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

Line 16166: phone_rec hz_contact_point_v2pub.phone_rec_type;

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

Line 16168: edi_rec hz_contact_point_v2pub.edi_rec_type;

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

Line 16169: telex_rec hz_contact_point_v2pub.telex_rec_type;

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

Line 16170: web_rec hz_contact_point_v2pub.web_rec_type;

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

Line 17114: cpoint_rec hz_contact_point_v2pub.contact_point_rec_type;

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

Line 17115: email_rec hz_contact_point_v2pub.email_rec_type;

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

Line 17116: phone_rec hz_contact_point_v2pub.phone_rec_type;

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

Line 17118: edi_rec hz_contact_point_v2pub.edi_rec_type;

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

Line 17119: telex_rec hz_contact_point_v2pub.telex_rec_type;

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

Line 17120: web_rec hz_contact_point_v2pub.web_rec_type;

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