DBA Data[Home] [Help]

APPS.OE_INLINE_CUSTOMER_PUB dependencies on HZ_CONTACT_POINT_V2PUB

Line 564: l_contact_points_rec HZ_CONTACT_POINT_V2PUB.contact_point_rec_type;

560: x_msg_data OUT NOCOPY /* file.sql.39 change */ Varchar2
561: )
562: IS
563: l_contact_point_id Number;
564: l_contact_points_rec HZ_CONTACT_POINT_V2PUB.contact_point_rec_type;
565: l_email_rec HZ_CONTACT_POINT_V2PUB.email_rec_type;
566: l_phone_rec HZ_CONTACT_POINT_V2PUB.phone_rec_type;
567: l_return_status Varchar2(1);
568: --

Line 565: l_email_rec HZ_CONTACT_POINT_V2PUB.email_rec_type;

561: )
562: IS
563: l_contact_point_id Number;
564: l_contact_points_rec HZ_CONTACT_POINT_V2PUB.contact_point_rec_type;
565: l_email_rec HZ_CONTACT_POINT_V2PUB.email_rec_type;
566: l_phone_rec HZ_CONTACT_POINT_V2PUB.phone_rec_type;
567: l_return_status Varchar2(1);
568: --
569: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 566: l_phone_rec HZ_CONTACT_POINT_V2PUB.phone_rec_type;

562: IS
563: l_contact_point_id Number;
564: l_contact_points_rec HZ_CONTACT_POINT_V2PUB.contact_point_rec_type;
565: l_email_rec HZ_CONTACT_POINT_V2PUB.email_rec_type;
566: l_phone_rec HZ_CONTACT_POINT_V2PUB.phone_rec_type;
567: l_return_status Varchar2(1);
568: --
569: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
570: --

Line 596: HZ_CONTACT_POINT_V2PUB.Create_Contact_Point(

592:
593: l_email_rec.email_address := p_email;
594:
595: -- { Start Call hz api to create contact point
596: HZ_CONTACT_POINT_V2PUB.Create_Contact_Point(
597: p_contact_point_rec => l_contact_points_rec,
598: p_email_rec => l_email_rec,
599: x_return_status => l_return_status,
600: x_msg_count => x_msg_count,

Line 638: HZ_CONTACT_POINT_V2PUB.Create_Contact_Point(

634: l_phone_rec.phone_line_type := 'GEN';
635: l_phone_rec.phone_country_code := p_phone_country_code;
636:
637: -- { Start Call hz api to create contact point
638: HZ_CONTACT_POINT_V2PUB.Create_Contact_Point(
639: p_contact_point_rec => l_contact_points_rec,
640: p_phone_rec => l_phone_rec,
641: x_return_status => l_return_status,
642: x_msg_count => x_msg_count,