APPS.IGS_PE_CONTACT_POINT_PKG dependencies on HZ_CONTACT_POINT_V2PUB

Line 56: l_contact_point_rec HZ_CONTACT_POINT_V2PUB.contact_point_rec_type;

52: p_api_version NUMBER(15) := 1.0;
53: p_init_msg_list VARCHAR2(30) := FND_API.G_FALSE;
54: p_commit VARCHAR2(30) := FND_API.G_FALSE;
55: l_msg_count NUMBER(15);
56: l_contact_point_rec HZ_CONTACT_POINT_V2PUB.contact_point_rec_type;
57: l_email_rec HZ_CONTACT_POINT_V2PUB.email_rec_type;
58: l_last_update_date hz_contact_points.last_update_date%TYPE;
59: l_obj_ver hz_contact_points.object_version_number%TYPE;
60:

Line 57: l_email_rec HZ_CONTACT_POINT_V2PUB.email_rec_type;

53: p_init_msg_list VARCHAR2(30) := FND_API.G_FALSE;
54: p_commit VARCHAR2(30) := FND_API.G_FALSE;
55: l_msg_count NUMBER(15);
56: l_contact_point_rec HZ_CONTACT_POINT_V2PUB.contact_point_rec_type;
57: l_email_rec HZ_CONTACT_POINT_V2PUB.email_rec_type;
58: l_last_update_date hz_contact_points.last_update_date%TYPE;
59: l_obj_ver hz_contact_points.object_version_number%TYPE;
60:
61: tmp_var1 VARCHAR2(2000);

Line 106: HZ_CONTACT_POINT_V2PUB.create_contact_point(

102: l_EMAIL_REC.EMAIL_FORMAT := p_email_format;
103: l_EMAIL_REC.EMAIL_ADDRESS := p_email_address;
104:
105:
106: HZ_CONTACT_POINT_V2PUB.create_contact_point(
107: p_init_msg_list => p_init_msg_list ,
108: p_contact_point_rec => l_contact_point_rec ,
109: p_email_rec => l_EMAIL_REC,
110: x_contact_point_id => p_contact_point_id,

Line 165: HZ_CONTACT_POINT_V2PUB.update_contact_point(

161:
162: l_EMAIL_REC.EMAIL_FORMAT := NVL(p_email_format,FND_API.G_MISS_CHAR);
163: l_EMAIL_REC.EMAIL_ADDRESS := NVL(p_email_address,FND_API.G_MISS_CHAR);
164:
165: HZ_CONTACT_POINT_V2PUB.update_contact_point(
166: p_init_msg_list => p_init_msg_list ,
167: p_contact_point_rec => l_contact_point_rec ,
168: p_email_rec => l_EMAIL_REC ,
169: p_object_version_number => p_contact_point_ovn,

Line 250: l_contact_point_rec HZ_CONTACT_POINT_V2PUB.contact_point_rec_type;

246: p_commit VARCHAR2(30) := FND_API.G_FALSE;
247: l_msg_count NUMBER(15);
248: l_last_update_date hz_contact_points.last_update_date%TYPE;
249:
250: l_contact_point_rec HZ_CONTACT_POINT_V2PUB.contact_point_rec_type;
251: l_phone_rec HZ_CONTACT_POINT_V2PUB.phone_rec_type;
252:
253:
254: CURSOR get_lupd_date(p_contact_point_id NUMBER ) IS

Line 251: l_phone_rec HZ_CONTACT_POINT_V2PUB.phone_rec_type;

247: l_msg_count NUMBER(15);
248: l_last_update_date hz_contact_points.last_update_date%TYPE;
249:
250: l_contact_point_rec HZ_CONTACT_POINT_V2PUB.contact_point_rec_type;
251: l_phone_rec HZ_CONTACT_POINT_V2PUB.phone_rec_type;
252:
253:
254: CURSOR get_lupd_date(p_contact_point_id NUMBER ) IS
255: SELECT last_update_date

Line 303: HZ_CONTACT_POINT_V2PUB.create_contact_point(

299: l_PHONE_REC.PHONE_NUMBER := p_phone_number;
300: l_PHONE_REC.PHONE_EXTENSION := p_phone_extension;
301: l_PHONE_REC.PHONE_LINE_TYPE := p_phone_line_type;
302:
303: HZ_CONTACT_POINT_V2PUB.create_contact_point(
304: p_init_msg_list => p_init_msg_list ,
305: p_contact_point_rec => l_contact_point_rec ,
306: p_phone_rec => l_phone_rec ,
307: x_contact_point_id => p_contact_point_id,

Line 368: HZ_CONTACT_POINT_V2PUB.update_contact_point(

364: l_PHONE_REC.PHONE_NUMBER := NVL( p_phone_number,FND_API.G_MISS_CHAR);
365: l_PHONE_REC.PHONE_EXTENSION := NVL( p_phone_extension,FND_API.G_MISS_CHAR);
366: l_PHONE_REC.PHONE_LINE_TYPE := NVL( p_phone_line_type,FND_API.G_MISS_CHAR);
367:
368: HZ_CONTACT_POINT_V2PUB.update_contact_point(
369: p_init_msg_list => p_init_msg_list ,
370: p_contact_point_rec => l_contact_point_rec ,
371: p_phone_rec => l_PHONE_REC,
372: p_object_version_number => p_contact_point_ovn,