DBA Data[Home] [Help]

APPS.PER_HRTCA_MERGE dependencies on HZ_CONTACT_POINT_V2PUB

Line 629: -- The call has been made to TCA v2 file (hz_contact_point_v2pub)

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;

Line 632: l_contact_point_rec hz_contact_point_v2pub.contact_point_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);

Line 633: l_email_rec hz_contact_point_v2pub.email_rec_type;

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;

Line 639: l_web_rec hz_contact_point_v2pub.web_rec_type;

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);

Line 640: l_edi_rec hz_contact_point_v2pub.edi_rec_type;

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

Line 641: l_phone_rec hz_contact_point_v2pub.phone_rec_type;

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;

Line 642: l_telex_rec hz_contact_point_v2pub.telex_rec_type;

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

Line 701: hz_contact_point_v2pub.update_contact_point

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,

Line 755: hz_contact_point_v2pub.create_contact_point

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,

Line 815: hz_contact_point_v2pub.update_contact_point

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,

Line 866: hz_contact_point_v2pub.update_contact_point

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,

Line 927: hz_contact_point_v2pub.create_contact_point

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,