DBA Data[Home] [Help]

APPS.JTF_UM_BUSINESS_USER_PVT dependencies on HZ_CONTACT_POINT_V2PUB

Line 58: l_contact_point_rec HZ_CONTACT_POINT_V2PUB.CONTACT_POINT_REC_TYPE;

54: l_contact_preference_id NUMBER;
55: l_search_value varchar2(360);
56: l_profile_id number;
57: l_contact_point_id number;
58: l_contact_point_rec HZ_CONTACT_POINT_V2PUB.CONTACT_POINT_REC_TYPE;
59: l_email_rec HZ_CONTACT_POINT_V2PUB.EMAIL_REC_TYPE;
60: l_phone_rec HZ_CONTACT_POINT_V2PUB.PHONE_REC_TYPE;
61: l_api_name varchar2(50) := 'RegisterBusinessUser';
62: l_check_existing_org_option varchar2(10) := 'N';

Line 59: l_email_rec HZ_CONTACT_POINT_V2PUB.EMAIL_REC_TYPE;

55: l_search_value varchar2(360);
56: l_profile_id number;
57: l_contact_point_id number;
58: l_contact_point_rec HZ_CONTACT_POINT_V2PUB.CONTACT_POINT_REC_TYPE;
59: l_email_rec HZ_CONTACT_POINT_V2PUB.EMAIL_REC_TYPE;
60: l_phone_rec HZ_CONTACT_POINT_V2PUB.PHONE_REC_TYPE;
61: l_api_name varchar2(50) := 'RegisterBusinessUser';
62: l_check_existing_org_option varchar2(10) := 'N';
63: l_org_contact_rec HZ_PARTY_CONTACT_V2PUB.org_contact_rec_type;

Line 60: l_phone_rec HZ_CONTACT_POINT_V2PUB.PHONE_REC_TYPE;

56: l_profile_id number;
57: l_contact_point_id number;
58: l_contact_point_rec HZ_CONTACT_POINT_V2PUB.CONTACT_POINT_REC_TYPE;
59: l_email_rec HZ_CONTACT_POINT_V2PUB.EMAIL_REC_TYPE;
60: l_phone_rec HZ_CONTACT_POINT_V2PUB.PHONE_REC_TYPE;
61: l_api_name varchar2(50) := 'RegisterBusinessUser';
62: l_check_existing_org_option varchar2(10) := 'N';
63: l_org_contact_rec HZ_PARTY_CONTACT_V2PUB.org_contact_rec_type;
64: l_party_rel_rec HZ_RELATIONSHIP_V2PUB.relationship_rec_type;

Line 235: HZ_CONTACT_POINT_V2PUB.create_contact_point (

231: if ( p_um_person_rec.email_address is not NULL ) then
232: l_contact_point_rec.contact_point_type := 'EMAIL';
233: l_email_rec.email_address := p_um_person_rec.email_address;
234: l_email_rec.email_format := 'MAILTEXT';
235: HZ_CONTACT_POINT_V2PUB.create_contact_point (
236: p_contact_point_rec => l_contact_point_rec,
237: p_email_rec => l_email_rec,
238: x_contact_point_id => l_contact_point_id,
239: x_return_status => X_Return_Status,

Line 248: HZ_CONTACT_POINT_V2PUB.create_contact_point (

244: l_contact_point_rec.contact_point_type := 'PHONE';
245: l_phone_rec.phone_area_code := nvl( p_um_person_rec.phone_area_code, '' );
246: l_phone_rec.phone_number := p_um_person_rec.phone_number;
247: l_phone_rec.phone_line_type := 'GEN';
248: HZ_CONTACT_POINT_V2PUB.create_contact_point (
249: p_contact_point_rec => l_contact_point_rec,
250: p_phone_rec => l_phone_rec,
251: x_contact_point_id => l_contact_point_id,
252: x_return_status => X_Return_Status,

Line 373: l_contact_point_rec HZ_CONTACT_POINT_V2PUB.CONTACT_POINT_REC_TYPE;

369: l_person_rec HZ_PARTY_V2PUB.PERSON_REC_TYPE;
370: l_HzOrganizationRec HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE;
371: l_profile_id number;
372: l_contact_point_id number;
373: l_contact_point_rec HZ_CONTACT_POINT_V2PUB.CONTACT_POINT_REC_TYPE;
374: l_location_rec HZ_LOCATION_V2PUB.LOCATION_REC_TYPE;
375: l_location_id l_location_rec.location_id%TYPE;
376: l_party_site_rec HZ_PARTY_SITE_V2PUB.PARTY_SITE_REC_TYPE;
377: l_party_site_id l_party_site_rec.party_site_id%type;

Line 379: l_email_rec HZ_CONTACT_POINT_V2PUB.EMAIL_REC_TYPE;

375: l_location_id l_location_rec.location_id%TYPE;
376: l_party_site_rec HZ_PARTY_SITE_V2PUB.PARTY_SITE_REC_TYPE;
377: l_party_site_id l_party_site_rec.party_site_id%type;
378: l_party_site_number l_party_site_rec.party_site_number%type;
379: l_email_rec HZ_CONTACT_POINT_V2PUB.EMAIL_REC_TYPE;
380: l_phone_rec HZ_CONTACT_POINT_V2PUB.PHONE_REC_TYPE;
381: l_api_name varchar2(50) := 'Create_Organization';
382: BEGIN
383: JTF_DEBUG_PUB.LOG_ENTERING_METHOD( p_module => G_MODULE, p_message => l_api_name);

Line 380: l_phone_rec HZ_CONTACT_POINT_V2PUB.PHONE_REC_TYPE;

376: l_party_site_rec HZ_PARTY_SITE_V2PUB.PARTY_SITE_REC_TYPE;
377: l_party_site_id l_party_site_rec.party_site_id%type;
378: l_party_site_number l_party_site_rec.party_site_number%type;
379: l_email_rec HZ_CONTACT_POINT_V2PUB.EMAIL_REC_TYPE;
380: l_phone_rec HZ_CONTACT_POINT_V2PUB.PHONE_REC_TYPE;
381: l_api_name varchar2(50) := 'Create_Organization';
382: BEGIN
383: JTF_DEBUG_PUB.LOG_ENTERING_METHOD( p_module => G_MODULE, p_message => l_api_name);
384: -- Standard Start of API savepoint

Line 465: JTF_DEBUG_PUB. LOG_EVENT( p_module => G_MODULE, p_message => 'invoking HZ_CONTACT_POINT_V2PUB.create_contact_point for creating phone');

461: l_contact_point_rec.contact_point_type := 'PHONE';
462: l_phone_rec.phone_area_code := nvl( P_um_organization_Rec.phone_area_code, '' );
463: l_phone_rec.phone_number := P_um_organization_Rec.phone_number;
464: l_phone_rec.phone_line_type := 'GEN';
465: JTF_DEBUG_PUB. LOG_EVENT( p_module => G_MODULE, p_message => 'invoking HZ_CONTACT_POINT_V2PUB.create_contact_point for creating phone');
466: HZ_CONTACT_POINT_V2PUB.create_contact_point (
467: p_contact_point_rec => l_contact_point_rec,
468: p_phone_rec => l_phone_rec,
469: x_contact_point_id => l_contact_point_id,

Line 466: HZ_CONTACT_POINT_V2PUB.create_contact_point (

462: l_phone_rec.phone_area_code := nvl( P_um_organization_Rec.phone_area_code, '' );
463: l_phone_rec.phone_number := P_um_organization_Rec.phone_number;
464: l_phone_rec.phone_line_type := 'GEN';
465: JTF_DEBUG_PUB. LOG_EVENT( p_module => G_MODULE, p_message => 'invoking HZ_CONTACT_POINT_V2PUB.create_contact_point for creating phone');
466: HZ_CONTACT_POINT_V2PUB.create_contact_point (
467: p_contact_point_rec => l_contact_point_rec,
468: p_phone_rec => l_phone_rec,
469: x_contact_point_id => l_contact_point_id,
470: x_return_status => X_Return_Status,

Line 483: JTF_DEBUG_PUB. LOG_EVENT( p_module => G_MODULE, p_message => 'invoking HZ_CONTACT_POINT_V2PUB.create_contact_point for creating phone');

479: l_contact_point_rec.contact_point_type := 'PHONE';
480: l_phone_rec.phone_area_code := nvl( P_um_organization_Rec.fax_area_code, '' );
481: l_phone_rec.phone_number := P_um_organization_Rec.fax_number;
482: l_phone_rec.phone_line_type := 'FAX';
483: JTF_DEBUG_PUB. LOG_EVENT( p_module => G_MODULE, p_message => 'invoking HZ_CONTACT_POINT_V2PUB.create_contact_point for creating phone');
484: HZ_CONTACT_POINT_V2PUB.create_contact_point (
485: p_contact_point_rec => l_contact_point_rec,
486: p_phone_rec => l_phone_rec,
487: x_contact_point_id => l_contact_point_id,

Line 484: HZ_CONTACT_POINT_V2PUB.create_contact_point (

480: l_phone_rec.phone_area_code := nvl( P_um_organization_Rec.fax_area_code, '' );
481: l_phone_rec.phone_number := P_um_organization_Rec.fax_number;
482: l_phone_rec.phone_line_type := 'FAX';
483: JTF_DEBUG_PUB. LOG_EVENT( p_module => G_MODULE, p_message => 'invoking HZ_CONTACT_POINT_V2PUB.create_contact_point for creating phone');
484: HZ_CONTACT_POINT_V2PUB.create_contact_point (
485: p_contact_point_rec => l_contact_point_rec,
486: p_phone_rec => l_phone_rec,
487: x_contact_point_id => l_contact_point_id,
488: x_return_status => X_Return_Status,