DBA Data[Home] [Help]

APPS.AMS_CONTACT_POINT_PVT dependencies on HZ_CONTACT_POINT_V2PUB

Line 62: l_hz_contact_point_rec HZ_CONTACT_POINT_V2PUB.CONTACT_POINT_REC_TYPE;

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;

Line 63: l_hz_edi_rec HZ_CONTACT_POINT_V2PUB.edi_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;

Line 64: l_hz_email_rec HZ_CONTACT_POINT_V2PUB.email_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:

Line 65: l_hz_phone_rec HZ_CONTACT_POINT_V2PUB.phone_rec_type;

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

Line 66: l_hz_telex_rec HZ_CONTACT_POINT_V2PUB.telex_rec_type;

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

Line 67: l_hz_web_rec HZ_CONTACT_POINT_V2PUB.web_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
71: SAVEPOINT Create_Contact_POINT_PVT;

Line 167: HZ_CONTACT_POINT_V2PUB.create_contact_POINT

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,

Line 283: l_hz_contact_point_rec HZ_CONTACT_POINT_V2PUB.CONTACT_POINT_REC_TYPE;

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;

Line 284: l_hz_edi_rec HZ_CONTACT_POINT_V2PUB.edi_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;

Line 285: l_hz_email_rec HZ_CONTACT_POINT_V2PUB.email_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:

Line 286: l_hz_phone_rec HZ_CONTACT_POINT_V2PUB.phone_rec_type;

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:

Line 287: l_hz_telex_rec HZ_CONTACT_POINT_V2PUB.telex_rec_type;

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:

Line 288: l_hz_web_rec HZ_CONTACT_POINT_V2PUB.web_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:
292: BEGIN

Line 379: HZ_CONTACT_POINT_V2PUB.update_contact_POINT

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,