58: l_msg_data VARCHAR2(2000);
59:
60:
61:
62: l_hz_contact_point_rec HZ_CONTACT_POINT_V2PUB.CONTACT_POINT_REC_TYPE;
63: l_hz_edi_rec HZ_CONTACT_POINT_V2PUB.edi_rec_type;
64: l_hz_email_rec HZ_CONTACT_POINT_V2PUB.email_rec_type;
65: l_hz_phone_rec HZ_CONTACT_POINT_V2PUB.phone_rec_type;
66: l_hz_telex_rec HZ_CONTACT_POINT_V2PUB.telex_rec_type;
59:
60:
61:
62: l_hz_contact_point_rec HZ_CONTACT_POINT_V2PUB.CONTACT_POINT_REC_TYPE;
63: l_hz_edi_rec HZ_CONTACT_POINT_V2PUB.edi_rec_type;
64: l_hz_email_rec HZ_CONTACT_POINT_V2PUB.email_rec_type;
65: l_hz_phone_rec HZ_CONTACT_POINT_V2PUB.phone_rec_type;
66: l_hz_telex_rec HZ_CONTACT_POINT_V2PUB.telex_rec_type;
67: l_hz_web_rec HZ_CONTACT_POINT_V2PUB.web_rec_type;
60:
61:
62: l_hz_contact_point_rec HZ_CONTACT_POINT_V2PUB.CONTACT_POINT_REC_TYPE;
63: l_hz_edi_rec HZ_CONTACT_POINT_V2PUB.edi_rec_type;
64: l_hz_email_rec HZ_CONTACT_POINT_V2PUB.email_rec_type;
65: l_hz_phone_rec HZ_CONTACT_POINT_V2PUB.phone_rec_type;
66: l_hz_telex_rec HZ_CONTACT_POINT_V2PUB.telex_rec_type;
67: l_hz_web_rec HZ_CONTACT_POINT_V2PUB.web_rec_type;
68:
61:
62: l_hz_contact_point_rec HZ_CONTACT_POINT_V2PUB.CONTACT_POINT_REC_TYPE;
63: l_hz_edi_rec HZ_CONTACT_POINT_V2PUB.edi_rec_type;
64: l_hz_email_rec HZ_CONTACT_POINT_V2PUB.email_rec_type;
65: l_hz_phone_rec HZ_CONTACT_POINT_V2PUB.phone_rec_type;
66: l_hz_telex_rec HZ_CONTACT_POINT_V2PUB.telex_rec_type;
67: l_hz_web_rec HZ_CONTACT_POINT_V2PUB.web_rec_type;
68:
69: BEGIN
62: l_hz_contact_point_rec HZ_CONTACT_POINT_V2PUB.CONTACT_POINT_REC_TYPE;
63: l_hz_edi_rec HZ_CONTACT_POINT_V2PUB.edi_rec_type;
64: l_hz_email_rec HZ_CONTACT_POINT_V2PUB.email_rec_type;
65: l_hz_phone_rec HZ_CONTACT_POINT_V2PUB.phone_rec_type;
66: l_hz_telex_rec HZ_CONTACT_POINT_V2PUB.telex_rec_type;
67: l_hz_web_rec HZ_CONTACT_POINT_V2PUB.web_rec_type;
68:
69: BEGIN
70: -- Standard Start of API savepoint
63: l_hz_edi_rec HZ_CONTACT_POINT_V2PUB.edi_rec_type;
64: l_hz_email_rec HZ_CONTACT_POINT_V2PUB.email_rec_type;
65: l_hz_phone_rec HZ_CONTACT_POINT_V2PUB.phone_rec_type;
66: l_hz_telex_rec HZ_CONTACT_POINT_V2PUB.telex_rec_type;
67: l_hz_web_rec HZ_CONTACT_POINT_V2PUB.web_rec_type;
68:
69: BEGIN
70: -- Standard Start of API savepoint
71: SAVEPOINT Create_Contact_POINT_PVT;
163: l_hz_web_rec.web_type := p_ams_web_rec.web_type;
164: l_hz_web_rec.url := p_ams_web_rec.url;
165:
166:
167: HZ_CONTACT_POINT_V2PUB.create_contact_POINT
168: (
169: p_init_msg_list => p_init_msg_list,
170: p_contact_POINT_rec => l_hz_contact_point_rec ,
171: p_edi_rec => l_hz_edi_rec,
279: l_return_status VARCHAR2(1);
280: l_msg_count NUMBER;
281: l_msg_data VARCHAR2(2000);
282:
283: l_hz_contact_point_rec HZ_CONTACT_POINT_V2PUB.CONTACT_POINT_REC_TYPE;
284: l_hz_edi_rec HZ_CONTACT_POINT_V2PUB.edi_rec_type;
285: l_hz_email_rec HZ_CONTACT_POINT_V2PUB.email_rec_type;
286: l_hz_phone_rec HZ_CONTACT_POINT_V2PUB.phone_rec_type;
287: l_hz_telex_rec HZ_CONTACT_POINT_V2PUB.telex_rec_type;
280: l_msg_count NUMBER;
281: l_msg_data VARCHAR2(2000);
282:
283: l_hz_contact_point_rec HZ_CONTACT_POINT_V2PUB.CONTACT_POINT_REC_TYPE;
284: l_hz_edi_rec HZ_CONTACT_POINT_V2PUB.edi_rec_type;
285: l_hz_email_rec HZ_CONTACT_POINT_V2PUB.email_rec_type;
286: l_hz_phone_rec HZ_CONTACT_POINT_V2PUB.phone_rec_type;
287: l_hz_telex_rec HZ_CONTACT_POINT_V2PUB.telex_rec_type;
288: l_hz_web_rec HZ_CONTACT_POINT_V2PUB.web_rec_type;
281: l_msg_data VARCHAR2(2000);
282:
283: l_hz_contact_point_rec HZ_CONTACT_POINT_V2PUB.CONTACT_POINT_REC_TYPE;
284: l_hz_edi_rec HZ_CONTACT_POINT_V2PUB.edi_rec_type;
285: l_hz_email_rec HZ_CONTACT_POINT_V2PUB.email_rec_type;
286: l_hz_phone_rec HZ_CONTACT_POINT_V2PUB.phone_rec_type;
287: l_hz_telex_rec HZ_CONTACT_POINT_V2PUB.telex_rec_type;
288: l_hz_web_rec HZ_CONTACT_POINT_V2PUB.web_rec_type;
289:
282:
283: l_hz_contact_point_rec HZ_CONTACT_POINT_V2PUB.CONTACT_POINT_REC_TYPE;
284: l_hz_edi_rec HZ_CONTACT_POINT_V2PUB.edi_rec_type;
285: l_hz_email_rec HZ_CONTACT_POINT_V2PUB.email_rec_type;
286: l_hz_phone_rec HZ_CONTACT_POINT_V2PUB.phone_rec_type;
287: l_hz_telex_rec HZ_CONTACT_POINT_V2PUB.telex_rec_type;
288: l_hz_web_rec HZ_CONTACT_POINT_V2PUB.web_rec_type;
289:
290:
283: l_hz_contact_point_rec HZ_CONTACT_POINT_V2PUB.CONTACT_POINT_REC_TYPE;
284: l_hz_edi_rec HZ_CONTACT_POINT_V2PUB.edi_rec_type;
285: l_hz_email_rec HZ_CONTACT_POINT_V2PUB.email_rec_type;
286: l_hz_phone_rec HZ_CONTACT_POINT_V2PUB.phone_rec_type;
287: l_hz_telex_rec HZ_CONTACT_POINT_V2PUB.telex_rec_type;
288: l_hz_web_rec HZ_CONTACT_POINT_V2PUB.web_rec_type;
289:
290:
291:
284: l_hz_edi_rec HZ_CONTACT_POINT_V2PUB.edi_rec_type;
285: l_hz_email_rec HZ_CONTACT_POINT_V2PUB.email_rec_type;
286: l_hz_phone_rec HZ_CONTACT_POINT_V2PUB.phone_rec_type;
287: l_hz_telex_rec HZ_CONTACT_POINT_V2PUB.telex_rec_type;
288: l_hz_web_rec HZ_CONTACT_POINT_V2PUB.web_rec_type;
289:
290:
291:
292: BEGIN
375: l_hz_web_rec.web_type := p_ams_web_rec.web_type;
376: l_hz_web_rec.url := p_ams_web_rec.url;
377: */
378:
379: HZ_CONTACT_POINT_V2PUB.update_contact_POINT
380: (
381: p_init_msg_list => p_init_msg_list,
382: p_contact_POINT_rec => l_hz_contact_point_rec,
383: p_edi_rec => l_hz_edi_rec,