[Home] [Help]
38: || * The contact point type check and phone line type check in
39: || create and update contact point proc is removed.
40: || * Cursor C1 fetches records based on contact point ID =
41: || igs_ad_contacts_int.interface_contacts_id it is changed to
42: || contact point ID = l_contact_point_id from hz_contact_points.
43: || ssawhney 15 nov Bug no.2103692:Person Interface DLD
44: || prc_pe_citizenship code is removed from here and added to
45: || IGS_AD_IMP_007.
46: || gmaheswa 11 Nov 2003 Bug 3223043 HZ.K Impact Changes
471: match_ind = cst_mi_val_19
472: WHERE ai.interface_run_id = l_interface_run_id
473: AND ai.status = cst_stat_val_2
474: AND EXISTS( SELECT '1'
475: FROM hz_contact_points pe, igs_ad_interface_all i
476: WHERE i.interface_run_id = l_interface_run_id
477: AND i.interface_id = ai.interface_id
478: AND pe.owner_table_id = i.person_id
479: AND UPPER(ai.contact_point_type) = pe.contact_point_type
517: WHERE ai.interface_run_id = l_interface_run_id
518: AND ai.match_ind IS NULL
519: AND ai.status = cst_stat_val_2
520: AND EXISTS ( SELECT '1'
521: FROM hz_contact_points pe, igs_ad_interface_all i
522: WHERE i.interface_run_id = l_interface_run_id
523: AND i.interface_id = ai.interface_id
524: AND pe.owner_table_id = i.person_id
525: AND UPPER(ai.contact_point_type) = pe.contact_point_type
544: UPDATE igs_ad_contacts_int_all ai
545: SET status = cst_stat_val_3,
546: match_ind = cst_mi_val_20,
547: dup_contact_point_id = (SELECT contact_point_id
548: FROM hz_contact_points pe, igs_ad_interface_all i
549: WHERE i.interface_run_id = l_interface_run_id
550: AND i.interface_id = ai.interface_id
551: AND rownum = 1
552: AND pe.owner_table_id = i.person_id
563: WHERE ai.interface_run_id = l_interface_run_id
564: AND ai.match_ind IS NULL
565: AND ai.status = cst_stat_val_2
566: AND EXISTS (SELECT '1'
567: FROM hz_contact_points pe, igs_ad_interface_all i
568: WHERE i.interface_run_id = l_interface_run_id
569: AND i.interface_id = ai.interface_id
570: AND pe.owner_table_id = i.person_id
571: AND UPPER(ai.contact_point_type) = pe.contact_point_type
597: p_phone_area_code VARCHAR2,
598: p_phone_number VARCHAR2
599: ) IS
600: SELECT ROWID, hi.*
601: FROM hz_contact_points hi
602: WHERE hi.owner_table_id=p_owner_table_id
603: AND UPPER(hi.contact_point_type)=UPPER(p_contact_point_type)
604: AND UPPER(hi.owner_table_name)='HZ_PARTIES'
605: AND ((UPPER(hi.email_format)=UPPER(p_email_format)
636: l_msg_count NUMBER;
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:
644:
645: BEGIN
646: SELECT object_version_number
647: INTO l_obj_ver
648: FROM hz_contact_points
649: WHERE contact_point_id = check_dup_contact_rec.contact_point_id;
650:
651: p_contact_points_rec.contact_point_id := check_dup_contact_rec.contact_point_id;
652: p_contact_points_rec.contact_point_type := rec_pc1.contact_point_type;
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
781: INTO l_obj_ver
778:
779: BEGIN
780: SELECT object_version_number
781: INTO l_obj_ver
782: FROM hz_contact_points
783: WHERE contact_point_id = l_contact_point_id;
784: p_contact_points_rec.contact_point_id := l_contact_point_id;
785: p_contact_points_rec.contact_point_type := rec_pc1.contact_point_type;
786: p_contact_points_rec.owner_table_name := 'HZ_PARTIES';