DBA Data[Home] [Help]

APPS.IGF_AP_PROFILE_MATCHING_PKG dependencies on HZ_CONTACT_POINT_V2PUB

Line 92: p_contact_points_rec HZ_CONTACT_POINT_V2PUB.contact_point_rec_type;

88: */
89: l_msg_data VARCHAR2(2000);
90: l_msg_count NUMBER;
91:
92: p_contact_points_rec HZ_CONTACT_POINT_V2PUB.contact_point_rec_type;
93: p_email_rec HZ_CONTACT_POINT_V2PUB.email_rec_type := NULL;
94: p_phone_rec HZ_CONTACT_POINT_V2PUB.phone_rec_type;
95: l_return_status VARCHAR2(25);
96: l_contact_point_id hz_contact_points.contact_point_id%TYPE := NULL;

Line 93: p_email_rec HZ_CONTACT_POINT_V2PUB.email_rec_type := NULL;

89: l_msg_data VARCHAR2(2000);
90: l_msg_count NUMBER;
91:
92: p_contact_points_rec HZ_CONTACT_POINT_V2PUB.contact_point_rec_type;
93: p_email_rec HZ_CONTACT_POINT_V2PUB.email_rec_type := NULL;
94: p_phone_rec HZ_CONTACT_POINT_V2PUB.phone_rec_type;
95: l_return_status VARCHAR2(25);
96: l_contact_point_id hz_contact_points.contact_point_id%TYPE := NULL;
97: l_chk_email hz_parties.email_address%TYPE;

Line 94: p_phone_rec HZ_CONTACT_POINT_V2PUB.phone_rec_type;

90: l_msg_count NUMBER;
91:
92: p_contact_points_rec HZ_CONTACT_POINT_V2PUB.contact_point_rec_type;
93: p_email_rec HZ_CONTACT_POINT_V2PUB.email_rec_type := NULL;
94: p_phone_rec HZ_CONTACT_POINT_V2PUB.phone_rec_type;
95: l_return_status VARCHAR2(25);
96: l_contact_point_id hz_contact_points.contact_point_id%TYPE := NULL;
97: l_chk_email hz_parties.email_address%TYPE;
98:

Line 135: HZ_CONTACT_POINT_V2PUB.create_contact_point(

131: IF l_chk_email IS NULL THEN
132: -- new e-mail needs to be created
133: p_contact_points_rec.primary_flag := NULL;
134:
135: HZ_CONTACT_POINT_V2PUB.create_contact_point(
136: p_init_msg_list => FND_API.G_FALSE,
137: p_contact_point_rec => p_contact_points_rec,
138: p_email_rec => p_email_rec,
139: p_phone_rec => p_phone_rec,

Line 181: p_contact_points_rec HZ_CONTACT_POINT_V2PUB.contact_point_rec_type;

177: */
178: l_msg_data VARCHAR2(2000);
179: l_msg_count NUMBER;
180:
181: p_contact_points_rec HZ_CONTACT_POINT_V2PUB.contact_point_rec_type;
182: p_email_rec HZ_CONTACT_POINT_V2PUB.email_rec_type := NULL;
183: p_phone_rec HZ_CONTACT_POINT_V2PUB.phone_rec_type;
184: l_return_status VARCHAR2(25);
185: l_contact_point_id hz_contact_points.contact_point_id%TYPE := NULL;

Line 182: p_email_rec HZ_CONTACT_POINT_V2PUB.email_rec_type := NULL;

178: l_msg_data VARCHAR2(2000);
179: l_msg_count NUMBER;
180:
181: p_contact_points_rec HZ_CONTACT_POINT_V2PUB.contact_point_rec_type;
182: p_email_rec HZ_CONTACT_POINT_V2PUB.email_rec_type := NULL;
183: p_phone_rec HZ_CONTACT_POINT_V2PUB.phone_rec_type;
184: l_return_status VARCHAR2(25);
185: l_contact_point_id hz_contact_points.contact_point_id%TYPE := NULL;
186: BEGIN

Line 183: p_phone_rec HZ_CONTACT_POINT_V2PUB.phone_rec_type;

179: l_msg_count NUMBER;
180:
181: p_contact_points_rec HZ_CONTACT_POINT_V2PUB.contact_point_rec_type;
182: p_email_rec HZ_CONTACT_POINT_V2PUB.email_rec_type := NULL;
183: p_phone_rec HZ_CONTACT_POINT_V2PUB.phone_rec_type;
184: l_return_status VARCHAR2(25);
185: l_contact_point_id hz_contact_points.contact_point_id%TYPE := NULL;
186: BEGIN
187:

Line 201: HZ_CONTACT_POINT_V2PUB.create_contact_point(

197: p_contact_points_rec.primary_flag := NULL;
198: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
199: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_profile_matching_pkg.create_email_address.debug','Before creating Email Address' );
200: END IF;
201: HZ_CONTACT_POINT_V2PUB.create_contact_point(
202: p_init_msg_list => FND_API.G_FALSE,
203: p_contact_point_rec => p_contact_points_rec,
204: p_email_rec => p_email_rec,
205: p_phone_rec => p_phone_rec,