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;
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;
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;
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;
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;
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;
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;
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;
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:
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;
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;
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;
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:
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:
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
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:
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,
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,
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,
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,
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,
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
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;
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 ;
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:
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
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;
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:
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,
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;
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;
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;
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:
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;
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;
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;
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;
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;
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;
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;
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;