DBA Data[Home] [Help]

APPS.PER_HRTCA_MERGE dependencies on HZ_CONTACT_POINT_V2PUB

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

627:
628:
629: --Define local variables
630: -- Modified for bug # 2648797
631: -- The call has been made to TCA v2 file (hz_contact_point_v2pub)
632: -- object version number has been added
633: l_c1 c1%rowtype;
634: l_contact_point_rec hz_contact_point_v2pub.contact_point_rec_type;
635: l_email_rec hz_contact_point_v2pub.email_rec_type;

Line 634: l_contact_point_rec hz_contact_point_v2pub.contact_point_rec_type;

630: -- Modified for bug # 2648797
631: -- The call has been made to TCA v2 file (hz_contact_point_v2pub)
632: -- object version number has been added
633: l_c1 c1%rowtype;
634: l_contact_point_rec hz_contact_point_v2pub.contact_point_rec_type;
635: l_email_rec hz_contact_point_v2pub.email_rec_type;
636: l_return_status varchar2(30);
637: l_msg_count number;
638: l_msg_data varchar2(2000);

Line 635: l_email_rec hz_contact_point_v2pub.email_rec_type;

631: -- The call has been made to TCA v2 file (hz_contact_point_v2pub)
632: -- object version number has been added
633: l_c1 c1%rowtype;
634: l_contact_point_rec hz_contact_point_v2pub.contact_point_rec_type;
635: l_email_rec hz_contact_point_v2pub.email_rec_type;
636: l_return_status varchar2(30);
637: l_msg_count number;
638: l_msg_data varchar2(2000);
639: l_contact_point_id number;

Line 641: l_web_rec hz_contact_point_v2pub.web_rec_type;

637: l_msg_count number;
638: l_msg_data varchar2(2000);
639: l_contact_point_id number;
640: l_object_version_number number;
641: l_web_rec hz_contact_point_v2pub.web_rec_type;
642: l_edi_rec hz_contact_point_v2pub.edi_rec_type;
643: l_phone_rec hz_contact_point_v2pub.phone_rec_type;
644: l_telex_rec hz_contact_point_v2pub.telex_rec_type;
645: l_init_msg_list varchar2(30);

Line 642: l_edi_rec hz_contact_point_v2pub.edi_rec_type;

638: l_msg_data varchar2(2000);
639: l_contact_point_id number;
640: l_object_version_number number;
641: l_web_rec hz_contact_point_v2pub.web_rec_type;
642: l_edi_rec hz_contact_point_v2pub.edi_rec_type;
643: l_phone_rec hz_contact_point_v2pub.phone_rec_type;
644: l_telex_rec hz_contact_point_v2pub.telex_rec_type;
645: l_init_msg_list varchar2(30);
646: --bug no 5546586 starts here

Line 643: l_phone_rec hz_contact_point_v2pub.phone_rec_type;

639: l_contact_point_id number;
640: l_object_version_number number;
641: l_web_rec hz_contact_point_v2pub.web_rec_type;
642: l_edi_rec hz_contact_point_v2pub.edi_rec_type;
643: l_phone_rec hz_contact_point_v2pub.phone_rec_type;
644: l_telex_rec hz_contact_point_v2pub.telex_rec_type;
645: l_init_msg_list varchar2(30);
646: --bug no 5546586 starts here
647: l_email_changed boolean:=false;

Line 644: l_telex_rec hz_contact_point_v2pub.telex_rec_type;

640: l_object_version_number number;
641: l_web_rec hz_contact_point_v2pub.web_rec_type;
642: l_edi_rec hz_contact_point_v2pub.edi_rec_type;
643: l_phone_rec hz_contact_point_v2pub.phone_rec_type;
644: l_telex_rec hz_contact_point_v2pub.telex_rec_type;
645: l_init_msg_list varchar2(30);
646: --bug no 5546586 starts here
647: l_email_changed boolean:=false;
648: --bug no 5546586 ends here

Line 703: hz_contact_point_v2pub.update_contact_point

699: --Added for 4697454
700: -- Set Created by Module only when creatinbg
701: -- set to null when updating.
702: l_contact_point_rec.created_by_module := null;
703: hz_contact_point_v2pub.update_contact_point
704: (
705: --p_api_version => 1.0,
706: p_contact_point_rec => l_contact_point_rec,
707: p_email_rec => l_email_rec,

Line 757: hz_contact_point_v2pub.create_contact_point

753: --Added for 4697454
754: -- Set Created by Module only when creatinbg
755: -- set to null when updating.
756: l_contact_point_rec.created_by_module := 'HR API';
757: hz_contact_point_v2pub.create_contact_point
758: (
759: --p_api_version => 1.0,
760: p_contact_point_rec => l_contact_point_rec,
761: x_return_status => l_return_status,

Line 817: hz_contact_point_v2pub.update_contact_point

813: --Added for 4697454
814: -- Set Created by Module only when creatinbg
815: -- set to null when updating.
816: l_contact_point_rec.created_by_module := null;
817: hz_contact_point_v2pub.update_contact_point
818: (
819: --p_api_version => 1.0,
820: p_contact_point_rec => l_contact_point_rec,
821: p_email_rec => l_email_rec,

Line 868: hz_contact_point_v2pub.update_contact_point

864: --Added for 4697454
865: -- Set Created by Module only when creatinbg
866: -- set to null when updating.
867: l_contact_point_rec.created_by_module := null;
868: hz_contact_point_v2pub.update_contact_point
869: (
870: --p_api_version => 1.0,
871: p_contact_point_rec => l_contact_point_rec,
872: p_email_rec => l_email_rec,

Line 929: hz_contact_point_v2pub.create_contact_point

925: -- Set Created by Module only when creatinbg
926: -- set to null when updating.
927: l_contact_point_rec.created_by_module := 'HR API';
928: --
929: hz_contact_point_v2pub.create_contact_point
930: (
931: --p_api_version => 1.0,
932: p_contact_point_rec => l_contact_point_rec,
933: x_return_status => l_return_status,