5885: x_msg_data OUT NOCOPY VARCHAR2,
5886: x_contact_point_id OUT NOCOPY NUMBER)
5887: IS
5888:
5889: l_contact_point_rec HZ_CONTACT_POINT_V2PUB.CONTACT_POINT_REC_TYPE;
5890: l_email_rec_type HZ_CONTACT_POINT_V2PUB.EMAIL_REC_TYPE;
5891: l_phone_rec_type HZ_CONTACT_POINT_V2PUB.PHONE_REC_TYPE;
5892: l_web_rec_type HZ_CONTACT_POINT_V2PUB.WEB_REC_TYPE ;
5893: l_telex_rec_type HZ_CONTACT_POINT_V2PUB.TELEX_REC_TYPE;
5886: x_contact_point_id OUT NOCOPY NUMBER)
5887: IS
5888:
5889: l_contact_point_rec HZ_CONTACT_POINT_V2PUB.CONTACT_POINT_REC_TYPE;
5890: l_email_rec_type HZ_CONTACT_POINT_V2PUB.EMAIL_REC_TYPE;
5891: l_phone_rec_type HZ_CONTACT_POINT_V2PUB.PHONE_REC_TYPE;
5892: l_web_rec_type HZ_CONTACT_POINT_V2PUB.WEB_REC_TYPE ;
5893: l_telex_rec_type HZ_CONTACT_POINT_V2PUB.TELEX_REC_TYPE;
5894: l_edi_rec_type HZ_CONTACT_POINT_V2PUB.EDI_REC_TYPE;
5887: IS
5888:
5889: l_contact_point_rec HZ_CONTACT_POINT_V2PUB.CONTACT_POINT_REC_TYPE;
5890: l_email_rec_type HZ_CONTACT_POINT_V2PUB.EMAIL_REC_TYPE;
5891: l_phone_rec_type HZ_CONTACT_POINT_V2PUB.PHONE_REC_TYPE;
5892: l_web_rec_type HZ_CONTACT_POINT_V2PUB.WEB_REC_TYPE ;
5893: l_telex_rec_type HZ_CONTACT_POINT_V2PUB.TELEX_REC_TYPE;
5894: l_edi_rec_type HZ_CONTACT_POINT_V2PUB.EDI_REC_TYPE;
5895:
5888:
5889: l_contact_point_rec HZ_CONTACT_POINT_V2PUB.CONTACT_POINT_REC_TYPE;
5890: l_email_rec_type HZ_CONTACT_POINT_V2PUB.EMAIL_REC_TYPE;
5891: l_phone_rec_type HZ_CONTACT_POINT_V2PUB.PHONE_REC_TYPE;
5892: l_web_rec_type HZ_CONTACT_POINT_V2PUB.WEB_REC_TYPE ;
5893: l_telex_rec_type HZ_CONTACT_POINT_V2PUB.TELEX_REC_TYPE;
5894: l_edi_rec_type HZ_CONTACT_POINT_V2PUB.EDI_REC_TYPE;
5895:
5896: G_ERROR EXCEPTION;
5889: l_contact_point_rec HZ_CONTACT_POINT_V2PUB.CONTACT_POINT_REC_TYPE;
5890: l_email_rec_type HZ_CONTACT_POINT_V2PUB.EMAIL_REC_TYPE;
5891: l_phone_rec_type HZ_CONTACT_POINT_V2PUB.PHONE_REC_TYPE;
5892: l_web_rec_type HZ_CONTACT_POINT_V2PUB.WEB_REC_TYPE ;
5893: l_telex_rec_type HZ_CONTACT_POINT_V2PUB.TELEX_REC_TYPE;
5894: l_edi_rec_type HZ_CONTACT_POINT_V2PUB.EDI_REC_TYPE;
5895:
5896: G_ERROR EXCEPTION;
5897:
5890: l_email_rec_type HZ_CONTACT_POINT_V2PUB.EMAIL_REC_TYPE;
5891: l_phone_rec_type HZ_CONTACT_POINT_V2PUB.PHONE_REC_TYPE;
5892: l_web_rec_type HZ_CONTACT_POINT_V2PUB.WEB_REC_TYPE ;
5893: l_telex_rec_type HZ_CONTACT_POINT_V2PUB.TELEX_REC_TYPE;
5894: l_edi_rec_type HZ_CONTACT_POINT_V2PUB.EDI_REC_TYPE;
5895:
5896: G_ERROR EXCEPTION;
5897:
5898: BEGIN
5939: --contact creation end
5940:
5941: END IF;
5942:
5943: HZ_CONTACT_POINT_V2PUB.create_contact_point (
5944: p_init_msg_list => p_init_msg_list,
5945: p_contact_point_rec => l_contact_point_rec,
5946: p_email_rec => l_email_rec_type,
5947: p_phone_rec => l_phone_rec_type,
5979: x_msg_count OUT NOCOPY NUMBER,
5980: x_msg_data OUT NOCOPY VARCHAR2)
5981: IS
5982: l_object_Version_number NUMBER := 1 ;
5983: l_contact_point_rec HZ_CONTACT_POINT_V2PUB.CONTACT_POINT_REC_TYPE;
5984: l_email_rec_type HZ_CONTACT_POINT_V2PUB.EMAIL_REC_TYPE;
5985: l_phone_rec_type HZ_CONTACT_POINT_V2PUB.PHONE_REC_TYPE;
5986: G_ERROR EXCEPTION;
5987:
5980: x_msg_data OUT NOCOPY VARCHAR2)
5981: IS
5982: l_object_Version_number NUMBER := 1 ;
5983: l_contact_point_rec HZ_CONTACT_POINT_V2PUB.CONTACT_POINT_REC_TYPE;
5984: l_email_rec_type HZ_CONTACT_POINT_V2PUB.EMAIL_REC_TYPE;
5985: l_phone_rec_type HZ_CONTACT_POINT_V2PUB.PHONE_REC_TYPE;
5986: G_ERROR EXCEPTION;
5987:
5988: CURSOR l_cpoint_csr IS
5981: IS
5982: l_object_Version_number NUMBER := 1 ;
5983: l_contact_point_rec HZ_CONTACT_POINT_V2PUB.CONTACT_POINT_REC_TYPE;
5984: l_email_rec_type HZ_CONTACT_POINT_V2PUB.EMAIL_REC_TYPE;
5985: l_phone_rec_type HZ_CONTACT_POINT_V2PUB.PHONE_REC_TYPE;
5986: G_ERROR EXCEPTION;
5987:
5988: CURSOR l_cpoint_csr IS
5989: SELECT last_update_date, object_version_number, contact_point_type
6023:
6024: END IF;
6025: l_object_version_number := l_cpoint_rec.object_Version_number;
6026:
6027: HZ_CONTACT_POINT_V2PUB.update_contact_point (
6028: p_init_msg_list => p_init_msg_list,
6029: p_contact_point_rec => l_contact_point_rec,
6030: p_email_rec => l_email_rec_type,
6031: p_phone_rec => l_phone_rec_type,