eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_AD_IMP_012 dependencies on HZ_CONTACT_POINT_V2PUB

Line 16: HZ_CONTACT_POINT_PUB TO HZ_CONTACT_POINT_V2PUB for create and update of

12: || code added to commit after import of every
13: || 100 records .New variable l_processed_records added
14: || gmuralid 26-NOV-2002 BUG 2466674 - V2API UPTAKE
15: changed reference of HZ_PER_INFO_PUB to HZ_PERSON_INFO_V2PUB AND
16: HZ_CONTACT_POINT_PUB TO HZ_CONTACT_POINT_V2PUB for create and update of
17: person language and contact points
18:
19: ssawhney 27 may BUG - 2377751, error codes modified from E008 for contacts.
20: || npalanis 9-may-2002 BUG - 2352725

Line 134: p_contact_points_rec HZ_CONTACT_POINT_V2PUB.contact_point_rec_type;

130: l_smp VARCHAR2(25);
131: l_smp1 VARCHAR2(25);
132: p_error_code VARCHAR2(25);
133: p_status VARCHAR2(25);
134: p_contact_points_rec HZ_CONTACT_POINT_V2PUB.contact_point_rec_type;
135: p_email_rec HZ_CONTACT_POINT_V2PUB.email_rec_type;
136: p_phone_rec HZ_CONTACT_POINT_V2PUB.phone_rec_type;
137:
138: l_tmp_var1 VARCHAR2(500);

Line 135: p_email_rec HZ_CONTACT_POINT_V2PUB.email_rec_type;

131: l_smp1 VARCHAR2(25);
132: p_error_code VARCHAR2(25);
133: p_status VARCHAR2(25);
134: p_contact_points_rec HZ_CONTACT_POINT_V2PUB.contact_point_rec_type;
135: p_email_rec HZ_CONTACT_POINT_V2PUB.email_rec_type;
136: p_phone_rec HZ_CONTACT_POINT_V2PUB.phone_rec_type;
137:
138: l_tmp_var1 VARCHAR2(500);
139: l_tmp_var VARCHAR2(500);

Line 136: p_phone_rec HZ_CONTACT_POINT_V2PUB.phone_rec_type;

132: p_error_code VARCHAR2(25);
133: p_status VARCHAR2(25);
134: p_contact_points_rec HZ_CONTACT_POINT_V2PUB.contact_point_rec_type;
135: p_email_rec HZ_CONTACT_POINT_V2PUB.email_rec_type;
136: p_phone_rec HZ_CONTACT_POINT_V2PUB.phone_rec_type;
137:
138: l_tmp_var1 VARCHAR2(500);
139: l_tmp_var VARCHAR2(500);
140: BEGIN

Line 179: HZ_CONTACT_POINT_V2PUB.create_contact_point(

175: p_phone_rec.phone_extension := rec_pc.phone_extension;
176: p_phone_rec.phone_line_type := rec_pc.phone_line_type;
177: END IF;
178:
179: HZ_CONTACT_POINT_V2PUB.create_contact_point(
180: p_init_msg_list => FND_API.G_FALSE,
181: p_contact_point_rec => p_contact_points_rec,
182: p_email_rec => p_email_rec,
183: p_phone_rec => p_phone_rec,

Line 641: p_contact_points_rec HZ_CONTACT_POINT_V2PUB.contact_point_rec_type;

637: l_msg_data VARCHAR2(4000);
638: l_smp VARCHAR2(25);
639: l_smp1 VARCHAR2(25);
640: l_obj_ver hz_contact_points.object_version_number%TYPE;
641: p_contact_points_rec HZ_CONTACT_POINT_V2PUB.contact_point_rec_type;
642: p_email_rec HZ_CONTACT_POINT_V2PUB.email_rec_type;
643: p_phone_rec HZ_CONTACT_POINT_V2PUB.phone_rec_type;
644:
645: BEGIN

Line 642: p_email_rec HZ_CONTACT_POINT_V2PUB.email_rec_type;

638: l_smp VARCHAR2(25);
639: l_smp1 VARCHAR2(25);
640: l_obj_ver hz_contact_points.object_version_number%TYPE;
641: p_contact_points_rec HZ_CONTACT_POINT_V2PUB.contact_point_rec_type;
642: p_email_rec HZ_CONTACT_POINT_V2PUB.email_rec_type;
643: p_phone_rec HZ_CONTACT_POINT_V2PUB.phone_rec_type;
644:
645: BEGIN
646: SELECT object_version_number

Line 643: p_phone_rec HZ_CONTACT_POINT_V2PUB.phone_rec_type;

639: l_smp1 VARCHAR2(25);
640: l_obj_ver hz_contact_points.object_version_number%TYPE;
641: p_contact_points_rec HZ_CONTACT_POINT_V2PUB.contact_point_rec_type;
642: p_email_rec HZ_CONTACT_POINT_V2PUB.email_rec_type;
643: p_phone_rec HZ_CONTACT_POINT_V2PUB.phone_rec_type;
644:
645: BEGIN
646: SELECT object_version_number
647: INTO l_obj_ver

Line 670: HZ_CONTACT_POINT_V2PUB.update_contact_point(

666: p_phone_rec.phone_number := NVL(rec_pc1.phone_number,FND_API.G_MISS_CHAR);
667: p_phone_rec.phone_extension := NVL((NVL(rec_pc1.phone_extension,check_dup_contact_rec.phone_extension)),FND_API.G_MISS_CHAR); --
668: END IF;
669:
670: HZ_CONTACT_POINT_V2PUB.update_contact_point(
671: p_init_msg_list => FND_API.G_FALSE,
672: p_contact_point_rec => p_contact_points_rec,
673: p_email_rec => p_email_rec ,
674: p_phone_rec => p_phone_rec,

Line 774: p_contact_points_rec HZ_CONTACT_POINT_V2PUB.contact_point_rec_type;

770: l_smp1 VARCHAR2(25);
771: l_return_status VARCHAR2(25);
772: l_msg_count NUMBER;
773: l_msg_data VARCHAR2(4000);
774: p_contact_points_rec HZ_CONTACT_POINT_V2PUB.contact_point_rec_type;
775: p_email_rec HZ_CONTACT_POINT_V2PUB.email_rec_type;
776: p_phone_rec HZ_CONTACT_POINT_V2PUB.phone_rec_type;
777: l_obj_ver hz_contact_points.object_version_number%TYPE;
778:

Line 775: p_email_rec HZ_CONTACT_POINT_V2PUB.email_rec_type;

771: l_return_status VARCHAR2(25);
772: l_msg_count NUMBER;
773: l_msg_data VARCHAR2(4000);
774: p_contact_points_rec HZ_CONTACT_POINT_V2PUB.contact_point_rec_type;
775: p_email_rec HZ_CONTACT_POINT_V2PUB.email_rec_type;
776: p_phone_rec HZ_CONTACT_POINT_V2PUB.phone_rec_type;
777: l_obj_ver hz_contact_points.object_version_number%TYPE;
778:
779: BEGIN

Line 776: p_phone_rec HZ_CONTACT_POINT_V2PUB.phone_rec_type;

772: l_msg_count NUMBER;
773: l_msg_data VARCHAR2(4000);
774: p_contact_points_rec HZ_CONTACT_POINT_V2PUB.contact_point_rec_type;
775: p_email_rec HZ_CONTACT_POINT_V2PUB.email_rec_type;
776: p_phone_rec HZ_CONTACT_POINT_V2PUB.phone_rec_type;
777: l_obj_ver hz_contact_points.object_version_number%TYPE;
778:
779: BEGIN
780: SELECT object_version_number

Line 805: HZ_CONTACT_POINT_V2PUB.update_contact_point(

801: p_phone_rec.phone_area_code := NVL((NVL(rec_pc1.phone_area_code,check_dup_contact_rec.phone_area_code)),FND_API.G_MISS_CHAR);
802: p_phone_rec.phone_number := NVL(rec_pc1.phone_number,FND_API.G_MISS_CHAR);
803: p_phone_rec.phone_extension := NVL((NVL(rec_pc1.phone_extension,check_dup_contact_rec.phone_extension)),FND_API.G_MISS_CHAR) ;
804: END IF;
805: HZ_CONTACT_POINT_V2PUB.update_contact_point(
806: p_init_msg_list => FND_API.G_FALSE,
807: p_contact_point_rec => p_contact_points_rec,
808: p_email_rec => p_email_rec ,
809: p_phone_rec => p_phone_rec,