DBA Data[Home] [Help]

APPS.JTF_UM_INDIVIDUAL_USER_PVT dependencies on HZ_CONTACT_POINT_V2PUB

Line 32: l_contact_point_rec HZ_CONTACT_POINT_V2PUB.CONTACT_POINT_REC_TYPE;

28: l_party_number varchar2(100);
29: l_profile_id number;
30: l_contact_point_id number;
31: l_contact_preference_id number;
32: l_contact_point_rec HZ_CONTACT_POINT_V2PUB.CONTACT_POINT_REC_TYPE;
33: l_email_rec HZ_CONTACT_POINT_V2PUB.EMAIL_REC_TYPE;
34: l_phone_rec HZ_CONTACT_POINT_V2PUB.PHONE_REC_TYPE;
35: l_contact_preference_rec HZ_CONTACT_PREFERENCE_V2PUB.CONTACT_PREFERENCE_REC_TYPE;
36: l_api_name varchar2(50) := 'createPersonAndContact';

Line 33: l_email_rec HZ_CONTACT_POINT_V2PUB.EMAIL_REC_TYPE;

29: l_profile_id number;
30: l_contact_point_id number;
31: l_contact_preference_id number;
32: l_contact_point_rec HZ_CONTACT_POINT_V2PUB.CONTACT_POINT_REC_TYPE;
33: l_email_rec HZ_CONTACT_POINT_V2PUB.EMAIL_REC_TYPE;
34: l_phone_rec HZ_CONTACT_POINT_V2PUB.PHONE_REC_TYPE;
35: l_contact_preference_rec HZ_CONTACT_PREFERENCE_V2PUB.CONTACT_PREFERENCE_REC_TYPE;
36: l_api_name varchar2(50) := 'createPersonAndContact';
37: l_privacy_preference varchar2(5);

Line 34: l_phone_rec HZ_CONTACT_POINT_V2PUB.PHONE_REC_TYPE;

30: l_contact_point_id number;
31: l_contact_preference_id number;
32: l_contact_point_rec HZ_CONTACT_POINT_V2PUB.CONTACT_POINT_REC_TYPE;
33: l_email_rec HZ_CONTACT_POINT_V2PUB.EMAIL_REC_TYPE;
34: l_phone_rec HZ_CONTACT_POINT_V2PUB.PHONE_REC_TYPE;
35: l_contact_preference_rec HZ_CONTACT_PREFERENCE_V2PUB.CONTACT_PREFERENCE_REC_TYPE;
36: l_api_name varchar2(50) := 'createPersonAndContact';
37: l_privacy_preference varchar2(5);
38: begin

Line 69: p_message => 'invoking HZ_CONTACT_POINT_V2PUB.create_contact_point for creating email');

65:
66: -- creating contact points for the user
67:
68: JTF_DEBUG_PUB. LOG_EVENT( p_module => G_MODULE,
69: p_message => 'invoking HZ_CONTACT_POINT_V2PUB.create_contact_point for creating email');
70:
71: l_contact_point_rec.status := 'A';
72: l_contact_point_rec.owner_table_name := 'HZ_PARTIES';
73: l_contact_point_rec.owner_table_id := p_um_person_rec.party_id;

Line 84: HZ_CONTACT_POINT_V2PUB.create_contact_point (

80:
81: l_email_rec.email_address := p_um_person_rec.email_address;
82: l_email_rec.email_format := 'MAILTEXT';
83:
84: HZ_CONTACT_POINT_V2PUB.create_contact_point (
85: p_contact_point_rec => l_contact_point_rec,
86: p_email_rec => l_email_rec,
87: x_contact_point_id => l_contact_point_id,
88: x_return_status => X_Return_Status,

Line 140: p_message => 'invoking HZ_CONTACT_POINT_V2PUB.create_contact_point for creating phone');

136: if p_um_person_rec.phone_number is not NULL then
137: l_contact_point_rec.contact_point_type := 'PHONE';
138:
139: JTF_DEBUG_PUB. LOG_EVENT( p_module => G_MODULE,
140: p_message => 'invoking HZ_CONTACT_POINT_V2PUB.create_contact_point for creating phone');
141: l_phone_rec.phone_area_code := p_um_person_rec.phone_area_code;
142: l_phone_rec.phone_number := p_um_person_rec.phone_number;
143: l_phone_rec.phone_line_type := 'GEN';
144:

Line 145: HZ_CONTACT_POINT_V2PUB.create_contact_point (

141: l_phone_rec.phone_area_code := p_um_person_rec.phone_area_code;
142: l_phone_rec.phone_number := p_um_person_rec.phone_number;
143: l_phone_rec.phone_line_type := 'GEN';
144:
145: HZ_CONTACT_POINT_V2PUB.create_contact_point (
146: p_contact_point_rec => l_contact_point_rec,
147: p_phone_rec => l_phone_rec,
148: x_contact_point_id => l_contact_point_id,
149: x_return_status => X_Return_Status,