DBA Data[Home] [Help]

APPS.POS_PROFILE_PKG dependencies on HZ_CONTACT_POINT_V2PUB

Line 492: l_contact_points_rec hz_contact_point_v2pub.contact_point_rec_type;

488: , x_exception_msg OUT NOCOPY VARCHAR2
489: )
490: IS
491: l_contact_point_id NUMBER;
492: l_contact_points_rec hz_contact_point_v2pub.contact_point_rec_type;
493: l_email_rec hz_contact_point_v2pub.email_rec_type;
494: l_exception_msg varchar2(100);
495: return_status VARCHAR2(100);
496: msg_count NUMBER;

Line 493: l_email_rec hz_contact_point_v2pub.email_rec_type;

489: )
490: IS
491: l_contact_point_id NUMBER;
492: l_contact_points_rec hz_contact_point_v2pub.contact_point_rec_type;
493: l_email_rec hz_contact_point_v2pub.email_rec_type;
494: l_exception_msg varchar2(100);
495: return_status VARCHAR2(100);
496: msg_count NUMBER;
497: msg_data VARCHAR2(100);

Line 538: HZ_CONTACT_POINT_V2PUB.update_contact_point(

534: l_email_rec.email_format := 'MAILTEXT';
535: l_email_rec.email_address := l_email;
536: l_update_date := get_update_date_from_contact(l_contact_point_id);
537:
538: HZ_CONTACT_POINT_V2PUB.update_contact_point(
539: --p_api_version => 1.0,
540: --p_commit => fnd_api.g_false,
541: p_contact_point_rec => l_contact_points_rec,
542: p_email_rec => l_email_rec,

Line 560: hz_contact_point_v2pub.create_contact_point

556: l_contact_points_rec.status := 'A';
557: l_contact_points_rec.owner_table_name := p_party_type;
558: l_contact_points_rec.owner_table_id := p_party_id;
559: l_contact_points_rec.created_by_module := 'POS:PLS:ADM';
560: hz_contact_point_v2pub.create_contact_point
561: (
562: --1.0,fnd_api.g_true,
563: fnd_api.g_false,l_contact_points_rec,null,
564: l_email_rec,null,null,null,profile_id,return_status,

Line 594: l_contact_points_rec hz_contact_point_v2pub.contact_point_rec_type;

590: , x_exception_msg OUT NOCOPY VARCHAR2
591: )
592: IS
593: l_contact_point_id NUMBER;
594: l_contact_points_rec hz_contact_point_v2pub.contact_point_rec_type;
595: l_phone_rec hz_contact_point_v2pub.phone_rec_type;
596: l_exception_msg varchar2(100);
597: return_status VARCHAR2(100);
598: msg_count NUMBER;

Line 595: l_phone_rec hz_contact_point_v2pub.phone_rec_type;

591: )
592: IS
593: l_contact_point_id NUMBER;
594: l_contact_points_rec hz_contact_point_v2pub.contact_point_rec_type;
595: l_phone_rec hz_contact_point_v2pub.phone_rec_type;
596: l_exception_msg varchar2(100);
597: return_status VARCHAR2(100);
598: msg_count NUMBER;
599: msg_data VARCHAR2(100);

Line 639: x_exception_msg := 'CALL: HZ_CONTACT_POINT_V2PUB.update_contact_point';

635: l_phone_rec.phone_extension := p_extension;
636: l_phone_rec.phone_line_type := 'GEN';
637: l_update_date := get_update_date_from_contact(l_contact_point_id);
638:
639: x_exception_msg := 'CALL: HZ_CONTACT_POINT_V2PUB.update_contact_point';
640:
641: HZ_CONTACT_POINT_V2PUB.update_contact_point(
642: --p_api_version => 1.0,
643: --p_commit => fnd_api.g_false,

Line 641: HZ_CONTACT_POINT_V2PUB.update_contact_point(

637: l_update_date := get_update_date_from_contact(l_contact_point_id);
638:
639: x_exception_msg := 'CALL: HZ_CONTACT_POINT_V2PUB.update_contact_point';
640:
641: HZ_CONTACT_POINT_V2PUB.update_contact_point(
642: --p_api_version => 1.0,
643: --p_commit => fnd_api.g_false,
644: p_contact_point_rec => l_contact_points_rec,
645: p_phone_rec => l_phone_rec,

Line 670: hz_contact_point_v2pub.create_contact_point(

666: l_contact_points_rec.owner_table_name := p_party_type;
667: l_contact_points_rec.owner_table_id := p_party_id;
668: l_contact_points_rec.created_by_module := 'POS:PLS:ADM';
669: l_contact_points_rec.primary_flag := 'Y';
670: hz_contact_point_v2pub.create_contact_point(
671: --1.0,fnd_api.g_true,
672: fnd_api.g_false,l_contact_points_rec,null,null,l_phone_rec,null,
673: null,profile_id,return_status,msg_count,msg_data);
674: if (return_status <> 'S') THEN

Line 705: l_contact_points_rec hz_contact_point_v2pub.contact_point_rec_type;

701: , x_exception_msg OUT NOCOPY VARCHAR2
702: )
703: IS
704: l_contact_point_id NUMBER;
705: l_contact_points_rec hz_contact_point_v2pub.contact_point_rec_type;
706: l_phone_rec hz_contact_point_v2pub.phone_rec_type;
707: l_exception_msg varchar2(100);
708: return_status VARCHAR2(100);
709: msg_count NUMBER;

Line 706: l_phone_rec hz_contact_point_v2pub.phone_rec_type;

702: )
703: IS
704: l_contact_point_id NUMBER;
705: l_contact_points_rec hz_contact_point_v2pub.contact_point_rec_type;
706: l_phone_rec hz_contact_point_v2pub.phone_rec_type;
707: l_exception_msg varchar2(100);
708: return_status VARCHAR2(100);
709: msg_count NUMBER;
710: msg_data VARCHAR2(100);

Line 749: HZ_CONTACT_POINT_V2PUB.update_contact_point(

745: l_phone_rec.phone_extension := p_extension;
746: l_phone_rec.phone_line_type := 'FAX';
747: l_update_date := get_update_date_from_contact(l_contact_point_id);
748:
749: HZ_CONTACT_POINT_V2PUB.update_contact_point(
750: --p_api_version => 1.0,
751: --p_commit => fnd_api.g_false,
752: p_contact_point_rec => l_contact_points_rec,
753: p_phone_rec => l_phone_rec,

Line 774: hz_contact_point_v2pub.create_contact_point(

770: l_contact_points_rec.owner_table_id := p_party_id;
771: l_contact_points_rec.created_by_module := 'POS:PLS:ADM';
772: l_contact_points_rec.primary_flag := 'N';
773:
774: hz_contact_point_v2pub.create_contact_point(
775: --1.0,fnd_api.g_true,
776: fnd_api.g_false,l_contact_points_rec,null,null,l_phone_rec,null,
777: null,profile_id,return_status,msg_count,msg_data);
778: if (return_status <> 'S') THEN