DBA Data[Home] [Help]

APPS.POS_HZ_CONTACT_POINT_PKG dependencies on HZ_CONTACT_POINT_V2PUB

Line 35: l_contact_points_rec hz_contact_point_v2pub.contact_point_rec_type;

31: l_rec l_cur%ROWTYPE;
32: l_found BOOLEAN;
33:
34: l_contact_point_id NUMBER;
35: l_contact_points_rec hz_contact_point_v2pub.contact_point_rec_type;
36: l_phone_rec hz_contact_point_v2pub.phone_rec_type;
37:
38: BEGIN
39:

Line 36: l_phone_rec hz_contact_point_v2pub.phone_rec_type;

32: l_found BOOLEAN;
33:
34: l_contact_point_id NUMBER;
35: l_contact_points_rec hz_contact_point_v2pub.contact_point_rec_type;
36: l_phone_rec hz_contact_point_v2pub.phone_rec_type;
37:
38: BEGIN
39:
40: OPEN l_cur;

Line 101: hz_contact_point_v2pub.update_contact_point

97: l_rec.object_version_number := p_phone_object_version_number;
98: END IF;
99: --End for Bug 6620664
100:
101: hz_contact_point_v2pub.update_contact_point
102: (p_init_msg_list => fnd_api.g_false,
103: p_contact_point_rec => l_contact_points_rec,
104: p_phone_rec => l_phone_rec,
105: p_object_version_number => l_rec.object_version_number,

Line 113: p_prefix => 'call hz_contact_point_v2pub.update_contact_point',

109: );
110:
111: pos_log.log_call_result
112: (p_module => 'POSADMB',
113: p_prefix => 'call hz_contact_point_v2pub.update_contact_point',
114: p_return_status => x_return_status,
115: p_msg_count => x_msg_count,
116: p_msg_data => x_msg_data
117: );

Line 134: hz_contact_point_v2pub.create_contact_point

130: l_contact_points_rec.created_by_module := 'POS_SUPPLIER_MGMT';
131: l_contact_points_rec.application_id := 177;
132: l_contact_points_rec.primary_flag := 'Y';
133:
134: hz_contact_point_v2pub.create_contact_point
135: ( p_init_msg_list => fnd_api.g_false,
136: p_contact_point_rec => l_contact_points_rec,
137: p_phone_rec => l_phone_rec,
138: x_contact_point_id => l_contact_point_id,

Line 146: p_prefix => 'call hz_contact_point_v2pub.create_contact_point',

142: );
143:
144: pos_log.log_call_result
145: (p_module => 'POSADMB',
146: p_prefix => 'call hz_contact_point_v2pub.create_contact_point',
147: p_return_status => x_return_status,
148: p_msg_count => x_msg_count,
149: p_msg_data => x_msg_data
150: );

Line 187: l_contact_points_rec hz_contact_point_v2pub.contact_point_rec_type;

183: l_rec l_cur%ROWTYPE;
184: l_found BOOLEAN;
185:
186: l_contact_point_id NUMBER;
187: l_contact_points_rec hz_contact_point_v2pub.contact_point_rec_type;
188: l_phone_rec hz_contact_point_v2pub.phone_rec_type;
189:
190: BEGIN
191:

Line 188: l_phone_rec hz_contact_point_v2pub.phone_rec_type;

184: l_found BOOLEAN;
185:
186: l_contact_point_id NUMBER;
187: l_contact_points_rec hz_contact_point_v2pub.contact_point_rec_type;
188: l_phone_rec hz_contact_point_v2pub.phone_rec_type;
189:
190: BEGIN
191:
192: OPEN l_cur;

Line 250: hz_contact_point_v2pub.update_contact_point

246: l_rec.object_version_number := p_fax_object_version_number;
247: END IF;
248: --End for Bug 6620664
249:
250: hz_contact_point_v2pub.update_contact_point
251: (p_init_msg_list => fnd_api.g_false,
252: p_contact_point_rec => l_contact_points_rec,
253: p_phone_rec => l_phone_rec,
254: p_object_version_number => l_rec.object_version_number,

Line 274: hz_contact_point_v2pub.create_contact_point

270: l_contact_points_rec.owner_table_id := p_owner_table_id;
271: l_contact_points_rec.created_by_module := 'POS_SUPPLIER_MGMT';
272: l_contact_points_rec.application_id := 177;
273:
274: hz_contact_point_v2pub.create_contact_point
275: ( p_init_msg_list => fnd_api.g_false,
276: p_contact_point_rec => l_contact_points_rec,
277: p_phone_rec => l_phone_rec,
278: x_contact_point_id => l_contact_point_id,

Line 315: l_contact_points_rec hz_contact_point_v2pub.contact_point_rec_type;

311: l_rec l_cur%ROWTYPE;
312: l_found BOOLEAN;
313:
314: l_contact_point_id NUMBER;
315: l_contact_points_rec hz_contact_point_v2pub.contact_point_rec_type;
316: l_email_rec hz_contact_point_v2pub.email_rec_type;
317:
318: BEGIN
319: OPEN l_cur;

Line 316: l_email_rec hz_contact_point_v2pub.email_rec_type;

312: l_found BOOLEAN;
313:
314: l_contact_point_id NUMBER;
315: l_contact_points_rec hz_contact_point_v2pub.contact_point_rec_type;
316: l_email_rec hz_contact_point_v2pub.email_rec_type;
317:
318: BEGIN
319: OPEN l_cur;
320: FETCH l_cur INTO l_rec;

Line 356: hz_contact_point_v2pub.update_contact_point

352: l_rec.object_version_number := p_email_object_version_number;
353: END IF;
354: --End for Bug 6620664
355:
356: hz_contact_point_v2pub.update_contact_point
357: (p_init_msg_list => fnd_api.g_false,
358: p_contact_point_rec => l_contact_points_rec,
359: p_email_rec => l_email_rec,
360: p_object_version_number => l_rec.object_version_number,

Line 377: hz_contact_point_v2pub.create_contact_point

373: l_contact_points_rec.owner_table_id := p_owner_table_id;
374: l_contact_points_rec.created_by_module := 'POS_SUPPLIER_MGMT';
375: l_contact_points_rec.application_id := 177;
376:
377: hz_contact_point_v2pub.create_contact_point
378: ( p_init_msg_list => fnd_api.g_false,
379: p_contact_point_rec => l_contact_points_rec,
380: p_email_rec => l_email_rec,
381: x_contact_point_id => l_contact_point_id,

Line 421: l_contact_points_rec hz_contact_point_v2pub.contact_point_rec_type;

417: l_rec l_cur%ROWTYPE;
418: l_found BOOLEAN;
419:
420: l_contact_point_id NUMBER;
421: l_contact_points_rec hz_contact_point_v2pub.contact_point_rec_type;
422: l_phone_rec hz_contact_point_v2pub.phone_rec_type;
423:
424: BEGIN
425:

Line 422: l_phone_rec hz_contact_point_v2pub.phone_rec_type;

418: l_found BOOLEAN;
419:
420: l_contact_point_id NUMBER;
421: l_contact_points_rec hz_contact_point_v2pub.contact_point_rec_type;
422: l_phone_rec hz_contact_point_v2pub.phone_rec_type;
423:
424: BEGIN
425:
426: OPEN l_cur;

Line 484: hz_contact_point_v2pub.update_contact_point

480: IF p_phone_object_version_number <> fnd_api.G_NULL_NUM THEN
481: l_rec.object_version_number := p_phone_object_version_number;
482: END IF;
483:
484: hz_contact_point_v2pub.update_contact_point
485: (p_init_msg_list => fnd_api.g_false,
486: p_contact_point_rec => l_contact_points_rec,
487: p_phone_rec => l_phone_rec,
488: p_object_version_number => l_rec.object_version_number,

Line 496: p_prefix => 'call hz_contact_point_v2pub.update_contact_point',

492: );
493:
494: pos_log.log_call_result
495: (p_module => 'POSADMB',
496: p_prefix => 'call hz_contact_point_v2pub.update_contact_point',
497: p_return_status => x_return_status,
498: p_msg_count => x_msg_count,
499: p_msg_data => x_msg_data
500: );

Line 517: hz_contact_point_v2pub.create_contact_point

513: l_contact_points_rec.created_by_module := 'POS_SUPPLIER_MGMT';
514: l_contact_points_rec.application_id := 177;
515: l_contact_points_rec.primary_flag := 'N';
516:
517: hz_contact_point_v2pub.create_contact_point
518: ( p_init_msg_list => fnd_api.g_false,
519: p_contact_point_rec => l_contact_points_rec,
520: p_phone_rec => l_phone_rec,
521: x_contact_point_id => l_contact_point_id,

Line 529: p_prefix => 'call hz_contact_point_v2pub.create_contact_point',

525: );
526:
527: pos_log.log_call_result
528: (p_module => 'POSADMB',
529: p_prefix => 'call hz_contact_point_v2pub.create_contact_point',
530: p_return_status => x_return_status,
531: p_msg_count => x_msg_count,
532: p_msg_data => x_msg_data
533: );

Line 563: l_contact_points_rec hz_contact_point_v2pub.contact_point_rec_type;

559: l_rec l_cur%ROWTYPE;
560: l_found BOOLEAN;
561:
562: l_contact_point_id NUMBER;
563: l_contact_points_rec hz_contact_point_v2pub.contact_point_rec_type;
564: l_url_rec hz_contact_point_v2pub.web_rec_type;
565:
566: BEGIN
567: OPEN l_cur;

Line 564: l_url_rec hz_contact_point_v2pub.web_rec_type;

560: l_found BOOLEAN;
561:
562: l_contact_point_id NUMBER;
563: l_contact_points_rec hz_contact_point_v2pub.contact_point_rec_type;
564: l_url_rec hz_contact_point_v2pub.web_rec_type;
565:
566: BEGIN
567: OPEN l_cur;
568: FETCH l_cur INTO l_rec;

Line 601: hz_contact_point_v2pub.update_contact_point

597: IF p_url_object_version_number <> fnd_api.G_NULL_NUM THEN
598: l_rec.object_version_number := p_url_object_version_number;
599: END IF;
600:
601: hz_contact_point_v2pub.update_contact_point
602: (p_init_msg_list => fnd_api.g_false,
603: p_contact_point_rec => l_contact_points_rec,
604: p_web_rec => l_url_rec,
605: p_object_version_number => l_rec.object_version_number,

Line 621: hz_contact_point_v2pub.create_contact_point

617: l_contact_points_rec.owner_table_id := p_owner_table_id;
618: l_contact_points_rec.created_by_module := 'POS_SUPPLIER_MGMT';
619: l_contact_points_rec.application_id := 177;
620:
621: hz_contact_point_v2pub.create_contact_point
622: ( p_init_msg_list => fnd_api.g_false,
623: p_contact_point_rec => l_contact_points_rec,
624: p_web_rec => l_url_rec,
625: x_contact_point_id => l_contact_point_id,