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