APPS.IGS_PE_CONTACT_POINT_PKG dependencies on HZ_CONTACT_POINTS

Line 4: PROCEDURE HZ_CONTACT_POINTS_AKE(

1: PACKAGE BODY IGS_PE_CONTACT_POINT_PKG AS
2: /* $Header: IGSNI78B.pls 115.12 2003/05/05 14:56:42 kpadiyar ship $ */
3:
4: PROCEDURE HZ_CONTACT_POINTS_AKE(
5: p_action IN VARCHAR2,
6: p_rowid IN OUT NOCOPY VARCHAR2,
7: p_status IN VARCHAR2,
8: p_owner_table_name IN VARCHAR2,

Line 58: l_last_update_date hz_contact_points.last_update_date%TYPE;

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);
62: tmp_var VARCHAR2(2000);

Line 59: l_obj_ver hz_contact_points.object_version_number%TYPE;

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);
62: tmp_var VARCHAR2(2000);
63:

Line 66: FROM hz_contact_points

62: tmp_var VARCHAR2(2000);
63:
64: CURSOR get_lupd_date(p_contact_point_id NUMBER ) IS
65: SELECT last_update_date
66: FROM hz_contact_points
67: WHERE contact_point_id = p_contact_point_id;
68:
69:
70: BEGIN

Line 192: END HZ_CONTACT_POINTS_AKE;

188: END IF;
189:
190: END IF;
191:
192: END HZ_CONTACT_POINTS_AKE;
193:
194: PROCEDURE HZ_CONTACT_POINTS_AKP(
195: p_action IN VARCHAR2,
196: p_rowid IN OUT NOCOPY VARCHAR2,

Line 194: PROCEDURE HZ_CONTACT_POINTS_AKP(

190: END IF;
191:
192: END HZ_CONTACT_POINTS_AKE;
193:
194: PROCEDURE HZ_CONTACT_POINTS_AKP(
195: p_action IN VARCHAR2,
196: p_rowid IN OUT NOCOPY VARCHAR2,
197: p_status IN VARCHAR2,
198: p_owner_table_name IN VARCHAR2,

Line 248: l_last_update_date hz_contact_points.last_update_date%TYPE;

244: p_api_version NUMBER(15) := 1.0;
245: p_init_msg_list VARCHAR2(30) := FND_API.G_FALSE;
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:

Line 256: FROM hz_contact_points

252:
253:
254: CURSOR get_lupd_date(p_contact_point_id NUMBER ) IS
255: SELECT last_update_date
256: FROM hz_contact_points
257: WHERE contact_point_id = p_contact_point_id;
258:
259:
260: tmp_var1 VARCHAR2(2000);

Line 395: END HZ_CONTACT_POINTS_AKP;

391: END IF;
392:
393: END IF;
394:
395: END HZ_CONTACT_POINTS_AKP;
396:
397: END IGS_PE_CONTACT_POINT_PKG;