625:
626:
627: --Define local variables
628: -- Modified for bug # 2648797
629: -- The call has been made to TCA v2 file (hz_contact_point_v2pub)
630: -- object version number has been added
631: l_c1 c1%rowtype;
632: l_contact_point_rec hz_contact_point_v2pub.contact_point_rec_type;
633: l_email_rec hz_contact_point_v2pub.email_rec_type;
628: -- Modified for bug # 2648797
629: -- The call has been made to TCA v2 file (hz_contact_point_v2pub)
630: -- object version number has been added
631: l_c1 c1%rowtype;
632: l_contact_point_rec hz_contact_point_v2pub.contact_point_rec_type;
633: l_email_rec hz_contact_point_v2pub.email_rec_type;
634: l_return_status varchar2(30);
635: l_msg_count number;
636: l_msg_data varchar2(2000);
629: -- The call has been made to TCA v2 file (hz_contact_point_v2pub)
630: -- object version number has been added
631: l_c1 c1%rowtype;
632: l_contact_point_rec hz_contact_point_v2pub.contact_point_rec_type;
633: l_email_rec hz_contact_point_v2pub.email_rec_type;
634: l_return_status varchar2(30);
635: l_msg_count number;
636: l_msg_data varchar2(2000);
637: l_contact_point_id number;
635: l_msg_count number;
636: l_msg_data varchar2(2000);
637: l_contact_point_id number;
638: l_object_version_number number;
639: l_web_rec hz_contact_point_v2pub.web_rec_type;
640: l_edi_rec hz_contact_point_v2pub.edi_rec_type;
641: l_phone_rec hz_contact_point_v2pub.phone_rec_type;
642: l_telex_rec hz_contact_point_v2pub.telex_rec_type;
643: l_init_msg_list varchar2(30);
636: l_msg_data varchar2(2000);
637: l_contact_point_id number;
638: l_object_version_number number;
639: l_web_rec hz_contact_point_v2pub.web_rec_type;
640: l_edi_rec hz_contact_point_v2pub.edi_rec_type;
641: l_phone_rec hz_contact_point_v2pub.phone_rec_type;
642: l_telex_rec hz_contact_point_v2pub.telex_rec_type;
643: l_init_msg_list varchar2(30);
644: --bug no 5546586 starts here
637: l_contact_point_id number;
638: l_object_version_number number;
639: l_web_rec hz_contact_point_v2pub.web_rec_type;
640: l_edi_rec hz_contact_point_v2pub.edi_rec_type;
641: l_phone_rec hz_contact_point_v2pub.phone_rec_type;
642: l_telex_rec hz_contact_point_v2pub.telex_rec_type;
643: l_init_msg_list varchar2(30);
644: --bug no 5546586 starts here
645: l_email_changed boolean:=false;
638: l_object_version_number number;
639: l_web_rec hz_contact_point_v2pub.web_rec_type;
640: l_edi_rec hz_contact_point_v2pub.edi_rec_type;
641: l_phone_rec hz_contact_point_v2pub.phone_rec_type;
642: l_telex_rec hz_contact_point_v2pub.telex_rec_type;
643: l_init_msg_list varchar2(30);
644: --bug no 5546586 starts here
645: l_email_changed boolean:=false;
646: --bug no 5546586 ends here
697: --Added for 4697454
698: -- Set Created by Module only when creatinbg
699: -- set to null when updating.
700: l_contact_point_rec.created_by_module := null;
701: hz_contact_point_v2pub.update_contact_point
702: (
703: --p_api_version => 1.0,
704: p_contact_point_rec => l_contact_point_rec,
705: p_email_rec => l_email_rec,
751: --Added for 4697454
752: -- Set Created by Module only when creatinbg
753: -- set to null when updating.
754: l_contact_point_rec.created_by_module := 'HR API';
755: hz_contact_point_v2pub.create_contact_point
756: (
757: --p_api_version => 1.0,
758: p_contact_point_rec => l_contact_point_rec,
759: x_return_status => l_return_status,
811: --Added for 4697454
812: -- Set Created by Module only when creatinbg
813: -- set to null when updating.
814: l_contact_point_rec.created_by_module := null;
815: hz_contact_point_v2pub.update_contact_point
816: (
817: --p_api_version => 1.0,
818: p_contact_point_rec => l_contact_point_rec,
819: p_email_rec => l_email_rec,
862: --Added for 4697454
863: -- Set Created by Module only when creatinbg
864: -- set to null when updating.
865: l_contact_point_rec.created_by_module := null;
866: hz_contact_point_v2pub.update_contact_point
867: (
868: --p_api_version => 1.0,
869: p_contact_point_rec => l_contact_point_rec,
870: p_email_rec => l_email_rec,
923: -- Set Created by Module only when creatinbg
924: -- set to null when updating.
925: l_contact_point_rec.created_by_module := 'HR API';
926: --
927: hz_contact_point_v2pub.create_contact_point
928: (
929: --p_api_version => 1.0,
930: p_contact_point_rec => l_contact_point_rec,
931: x_return_status => l_return_status,