DBA Data[Home] [Help]

APPS.UMX_REGISTER_USER_PVT dependencies on HZ_CONTACT_POINT_V2PUB

Line 111: l_contact_point_rec HZ_CONTACT_POINT_V2PUB.CONTACT_POINT_REC_TYPE;

107: l_phone_extension HZ_CONTACT_POINTS.phone_extension%type;
108: l_profile_id number;
109:
110:
111: l_contact_point_rec HZ_CONTACT_POINT_V2PUB.CONTACT_POINT_REC_TYPE;
112: l_email_rec HZ_CONTACT_POINT_V2PUB.EMAIL_REC_TYPE;
113: l_phone_rec HZ_CONTACT_POINT_V2PUB.PHONE_REC_TYPE;
114:
115: X_Return_Status VARCHAR2 (20);

Line 112: l_email_rec HZ_CONTACT_POINT_V2PUB.EMAIL_REC_TYPE;

108: l_profile_id number;
109:
110:
111: l_contact_point_rec HZ_CONTACT_POINT_V2PUB.CONTACT_POINT_REC_TYPE;
112: l_email_rec HZ_CONTACT_POINT_V2PUB.EMAIL_REC_TYPE;
113: l_phone_rec HZ_CONTACT_POINT_V2PUB.PHONE_REC_TYPE;
114:
115: X_Return_Status VARCHAR2 (20);
116: X_Msg_Count NUMBER;

Line 113: l_phone_rec HZ_CONTACT_POINT_V2PUB.PHONE_REC_TYPE;

109:
110:
111: l_contact_point_rec HZ_CONTACT_POINT_V2PUB.CONTACT_POINT_REC_TYPE;
112: l_email_rec HZ_CONTACT_POINT_V2PUB.EMAIL_REC_TYPE;
113: l_phone_rec HZ_CONTACT_POINT_V2PUB.PHONE_REC_TYPE;
114:
115: X_Return_Status VARCHAR2 (20);
116: X_Msg_Count NUMBER;
117: X_Msg_data VARCHAR2 (300);

Line 153: HZ_CONTACT_POINT_V2PUB.create_contact_point (

149: l_email_rec.email_format := l_email_format;
150:
151:
152:
153: HZ_CONTACT_POINT_V2PUB.create_contact_point (
154: p_contact_point_rec => l_contact_point_rec,
155: p_email_rec => l_email_rec,
156: x_contact_point_id => l_contact_point_id,
157: x_return_status => X_Return_Status,

Line 186: HZ_CONTACT_POINT_V2PUB.create_contact_point (

182: l_phone_rec.phone_country_code := l_country_code;
183: l_phone_rec.phone_extension := l_phone_extension;
184: l_phone_rec.phone_line_type := 'GEN';
185:
186: HZ_CONTACT_POINT_V2PUB.create_contact_point (
187: p_contact_point_rec => l_contact_point_rec,
188: p_phone_rec => l_phone_rec,
189: x_contact_point_id => l_contact_point_id,
190: x_return_status => X_Return_Status,