DBA Data[Home] [Help]

APPS.EGO_PARTY_PUB dependencies on HZ_CONTACT_POINT_V2PUB

Line 605: l_contact_point_rec HZ_CONTACT_POINT_V2PUB.CONTACT_POINT_REC_TYPE;

601:
602: l_group_rec HZ_PARTY_V2PUB.GROUP_REC_TYPE;
603: l_party_rec HZ_PARTY_V2PUB.PARTY_REC_TYPE;
604:
605: l_contact_point_rec HZ_CONTACT_POINT_V2PUB.CONTACT_POINT_REC_TYPE;
606: l_edi_rec HZ_CONTACT_POINT_V2PUB.EDI_REC_TYPE;
607: l_email_rec HZ_CONTACT_POINT_V2PUB.EMAIL_REC_TYPE;
608: l_phone_rec HZ_CONTACT_POINT_V2PUB.PHONE_REC_TYPE;
609: l_telex_rec HZ_CONTACT_POINT_V2PUB.TELEX_REC_TYPE;

Line 606: l_edi_rec HZ_CONTACT_POINT_V2PUB.EDI_REC_TYPE;

602: l_group_rec HZ_PARTY_V2PUB.GROUP_REC_TYPE;
603: l_party_rec HZ_PARTY_V2PUB.PARTY_REC_TYPE;
604:
605: l_contact_point_rec HZ_CONTACT_POINT_V2PUB.CONTACT_POINT_REC_TYPE;
606: l_edi_rec HZ_CONTACT_POINT_V2PUB.EDI_REC_TYPE;
607: l_email_rec HZ_CONTACT_POINT_V2PUB.EMAIL_REC_TYPE;
608: l_phone_rec HZ_CONTACT_POINT_V2PUB.PHONE_REC_TYPE;
609: l_telex_rec HZ_CONTACT_POINT_V2PUB.TELEX_REC_TYPE;
610: l_web_rec HZ_CONTACT_POINT_V2PUB.WEB_REC_TYPE;

Line 607: l_email_rec HZ_CONTACT_POINT_V2PUB.EMAIL_REC_TYPE;

603: l_party_rec HZ_PARTY_V2PUB.PARTY_REC_TYPE;
604:
605: l_contact_point_rec HZ_CONTACT_POINT_V2PUB.CONTACT_POINT_REC_TYPE;
606: l_edi_rec HZ_CONTACT_POINT_V2PUB.EDI_REC_TYPE;
607: l_email_rec HZ_CONTACT_POINT_V2PUB.EMAIL_REC_TYPE;
608: l_phone_rec HZ_CONTACT_POINT_V2PUB.PHONE_REC_TYPE;
609: l_telex_rec HZ_CONTACT_POINT_V2PUB.TELEX_REC_TYPE;
610: l_web_rec HZ_CONTACT_POINT_V2PUB.WEB_REC_TYPE;
611: l_contact_point_id NUMBER;

Line 608: l_phone_rec HZ_CONTACT_POINT_V2PUB.PHONE_REC_TYPE;

604:
605: l_contact_point_rec HZ_CONTACT_POINT_V2PUB.CONTACT_POINT_REC_TYPE;
606: l_edi_rec HZ_CONTACT_POINT_V2PUB.EDI_REC_TYPE;
607: l_email_rec HZ_CONTACT_POINT_V2PUB.EMAIL_REC_TYPE;
608: l_phone_rec HZ_CONTACT_POINT_V2PUB.PHONE_REC_TYPE;
609: l_telex_rec HZ_CONTACT_POINT_V2PUB.TELEX_REC_TYPE;
610: l_web_rec HZ_CONTACT_POINT_V2PUB.WEB_REC_TYPE;
611: l_contact_point_id NUMBER;
612:

Line 609: l_telex_rec HZ_CONTACT_POINT_V2PUB.TELEX_REC_TYPE;

605: l_contact_point_rec HZ_CONTACT_POINT_V2PUB.CONTACT_POINT_REC_TYPE;
606: l_edi_rec HZ_CONTACT_POINT_V2PUB.EDI_REC_TYPE;
607: l_email_rec HZ_CONTACT_POINT_V2PUB.EMAIL_REC_TYPE;
608: l_phone_rec HZ_CONTACT_POINT_V2PUB.PHONE_REC_TYPE;
609: l_telex_rec HZ_CONTACT_POINT_V2PUB.TELEX_REC_TYPE;
610: l_web_rec HZ_CONTACT_POINT_V2PUB.WEB_REC_TYPE;
611: l_contact_point_id NUMBER;
612:
613: l_group_owner_rel_id NUMBER;

Line 610: l_web_rec HZ_CONTACT_POINT_V2PUB.WEB_REC_TYPE;

606: l_edi_rec HZ_CONTACT_POINT_V2PUB.EDI_REC_TYPE;
607: l_email_rec HZ_CONTACT_POINT_V2PUB.EMAIL_REC_TYPE;
608: l_phone_rec HZ_CONTACT_POINT_V2PUB.PHONE_REC_TYPE;
609: l_telex_rec HZ_CONTACT_POINT_V2PUB.TELEX_REC_TYPE;
610: l_web_rec HZ_CONTACT_POINT_V2PUB.WEB_REC_TYPE;
611: l_contact_point_id NUMBER;
612:
613: l_group_owner_rel_id NUMBER;
614: l_group_member_rel_id NUMBER;

Line 715: mdebug(' Before calling HZ_CONTACT_POINT_V2PUB.create_contact_point');

711: l_contact_point_rec.created_by_module := CREATED_BY_MODULE;
712: l_contact_point_rec.application_id := EGO_PARTY_PUB.get_application_id;
713: l_email_rec.email_address := p_email_address;
714:
715: mdebug(' Before calling HZ_CONTACT_POINT_V2PUB.create_contact_point');
716: HZ_CONTACT_POINT_V2PUB.create_contact_point
717: (p_init_msg_list => NVL(p_init_msg_list, 'F')
718: ,p_contact_point_rec => l_contact_point_rec
719: ,p_edi_rec => l_edi_rec

Line 716: HZ_CONTACT_POINT_V2PUB.create_contact_point

712: l_contact_point_rec.application_id := EGO_PARTY_PUB.get_application_id;
713: l_email_rec.email_address := p_email_address;
714:
715: mdebug(' Before calling HZ_CONTACT_POINT_V2PUB.create_contact_point');
716: HZ_CONTACT_POINT_V2PUB.create_contact_point
717: (p_init_msg_list => NVL(p_init_msg_list, 'F')
718: ,p_contact_point_rec => l_contact_point_rec
719: ,p_edi_rec => l_edi_rec
720: ,p_email_rec => l_email_rec

Line 737: mdebug('CREATE_GROUP: No need to call HZ_CONTACT_POINT_V2PUB.create_contact_point');

733: END IF;
734: RETURN;
735: END IF;
736: ELSE
737: mdebug('CREATE_GROUP: No need to call HZ_CONTACT_POINT_V2PUB.create_contact_point');
738: END IF;
739: -- The concept of creating an owner no more exists
740: -- we are having the concept of Administrator
741: -- which are done using specific grants

Line 917: l_contact_point_rec HZ_CONTACT_POINT_V2PUB.CONTACT_POINT_REC_TYPE;

913: l_group_rec HZ_PARTY_V2PUB.GROUP_REC_TYPE;
914: l_party_rec HZ_PARTY_V2PUB.PARTY_REC_TYPE;
915: l_party_rel_rec HZ_RELATIONSHIP_V2PUB.RELATIONSHIP_REC_TYPE;
916:
917: l_contact_point_rec HZ_CONTACT_POINT_V2PUB.CONTACT_POINT_REC_TYPE;
918: l_edi_rec HZ_CONTACT_POINT_V2PUB.EDI_REC_TYPE;
919: l_email_rec HZ_CONTACT_POINT_V2PUB.EMAIL_REC_TYPE;
920: l_phone_rec HZ_CONTACT_POINT_V2PUB.PHONE_REC_TYPE;
921: l_telex_rec HZ_CONTACT_POINT_V2PUB.TELEX_REC_TYPE;

Line 918: l_edi_rec HZ_CONTACT_POINT_V2PUB.EDI_REC_TYPE;

914: l_party_rec HZ_PARTY_V2PUB.PARTY_REC_TYPE;
915: l_party_rel_rec HZ_RELATIONSHIP_V2PUB.RELATIONSHIP_REC_TYPE;
916:
917: l_contact_point_rec HZ_CONTACT_POINT_V2PUB.CONTACT_POINT_REC_TYPE;
918: l_edi_rec HZ_CONTACT_POINT_V2PUB.EDI_REC_TYPE;
919: l_email_rec HZ_CONTACT_POINT_V2PUB.EMAIL_REC_TYPE;
920: l_phone_rec HZ_CONTACT_POINT_V2PUB.PHONE_REC_TYPE;
921: l_telex_rec HZ_CONTACT_POINT_V2PUB.TELEX_REC_TYPE;
922: l_web_rec HZ_CONTACT_POINT_V2PUB.WEB_REC_TYPE;

Line 919: l_email_rec HZ_CONTACT_POINT_V2PUB.EMAIL_REC_TYPE;

915: l_party_rel_rec HZ_RELATIONSHIP_V2PUB.RELATIONSHIP_REC_TYPE;
916:
917: l_contact_point_rec HZ_CONTACT_POINT_V2PUB.CONTACT_POINT_REC_TYPE;
918: l_edi_rec HZ_CONTACT_POINT_V2PUB.EDI_REC_TYPE;
919: l_email_rec HZ_CONTACT_POINT_V2PUB.EMAIL_REC_TYPE;
920: l_phone_rec HZ_CONTACT_POINT_V2PUB.PHONE_REC_TYPE;
921: l_telex_rec HZ_CONTACT_POINT_V2PUB.TELEX_REC_TYPE;
922: l_web_rec HZ_CONTACT_POINT_V2PUB.WEB_REC_TYPE;
923:

Line 920: l_phone_rec HZ_CONTACT_POINT_V2PUB.PHONE_REC_TYPE;

916:
917: l_contact_point_rec HZ_CONTACT_POINT_V2PUB.CONTACT_POINT_REC_TYPE;
918: l_edi_rec HZ_CONTACT_POINT_V2PUB.EDI_REC_TYPE;
919: l_email_rec HZ_CONTACT_POINT_V2PUB.EMAIL_REC_TYPE;
920: l_phone_rec HZ_CONTACT_POINT_V2PUB.PHONE_REC_TYPE;
921: l_telex_rec HZ_CONTACT_POINT_V2PUB.TELEX_REC_TYPE;
922: l_web_rec HZ_CONTACT_POINT_V2PUB.WEB_REC_TYPE;
923:
924: l_curr_owner_id NUMBER;

Line 921: l_telex_rec HZ_CONTACT_POINT_V2PUB.TELEX_REC_TYPE;

917: l_contact_point_rec HZ_CONTACT_POINT_V2PUB.CONTACT_POINT_REC_TYPE;
918: l_edi_rec HZ_CONTACT_POINT_V2PUB.EDI_REC_TYPE;
919: l_email_rec HZ_CONTACT_POINT_V2PUB.EMAIL_REC_TYPE;
920: l_phone_rec HZ_CONTACT_POINT_V2PUB.PHONE_REC_TYPE;
921: l_telex_rec HZ_CONTACT_POINT_V2PUB.TELEX_REC_TYPE;
922: l_web_rec HZ_CONTACT_POINT_V2PUB.WEB_REC_TYPE;
923:
924: l_curr_owner_id NUMBER;
925: l_curr_member_id NUMBER;

Line 922: l_web_rec HZ_CONTACT_POINT_V2PUB.WEB_REC_TYPE;

918: l_edi_rec HZ_CONTACT_POINT_V2PUB.EDI_REC_TYPE;
919: l_email_rec HZ_CONTACT_POINT_V2PUB.EMAIL_REC_TYPE;
920: l_phone_rec HZ_CONTACT_POINT_V2PUB.PHONE_REC_TYPE;
921: l_telex_rec HZ_CONTACT_POINT_V2PUB.TELEX_REC_TYPE;
922: l_web_rec HZ_CONTACT_POINT_V2PUB.WEB_REC_TYPE;
923:
924: l_curr_owner_id NUMBER;
925: l_curr_member_id NUMBER;
926: l_update_owner BOOLEAN;

Line 1066: HZ_CONTACT_POINT_V2PUB.create_contact_point

1062: l_contact_point_rec.created_by_module := CREATED_BY_MODULE;
1063: l_contact_point_rec.application_id := EGO_PARTY_PUB.get_application_id;
1064: l_email_rec.email_address := p_email_address;
1065: mdebug(' UPDATE_GROUP: Creating Contact point now !!! ');
1066: HZ_CONTACT_POINT_V2PUB.create_contact_point
1067: (p_init_msg_list => NVL(p_init_msg_list, 'F')
1068: ,p_contact_point_rec => l_contact_point_rec
1069: ,p_edi_rec => l_edi_rec
1070: ,p_email_rec => l_email_rec

Line 1095: mdebug('UPDATE_GROUP: before calling HZ_CONTACT_POINT_V2PUB.update_contact_point');

1091: l_email_rec.email_address := l_email_address;
1092: l_contact_point_rec.status := 'I';
1093: ELSE
1094: -- update email address in contact_points
1095: mdebug('UPDATE_GROUP: before calling HZ_CONTACT_POINT_V2PUB.update_contact_point');
1096: l_email_rec.email_address := p_email_address;
1097: l_contact_point_rec.status := l_status;
1098: END IF;
1099: l_email_rec.email_format := l_email_format;

Line 1102: HZ_CONTACT_POINT_V2PUB.update_contact_point

1098: END IF;
1099: l_email_rec.email_format := l_email_format;
1100: l_contact_point_rec.contact_point_id := l_contact_point_id;
1101: l_contact_point_rec.contact_point_type := 'EMAIL';
1102: HZ_CONTACT_POINT_V2PUB.update_contact_point
1103: (p_init_msg_list => NVL(p_init_msg_list, 'F')
1104: ,p_contact_point_rec => l_contact_point_rec
1105: ,p_edi_rec => l_edi_rec
1106: ,p_email_rec => l_email_rec

Line 1115: mdebug('UPDATE_GROUP: Exited from HZ_CONTACT_POINT_V2PUB.update_contact_point with status '''||l_return_status||'''');

1111: ,x_return_status => l_return_status
1112: ,x_msg_count => l_msg_count
1113: ,x_msg_data => l_msg_data
1114: );
1115: mdebug('UPDATE_GROUP: Exited from HZ_CONTACT_POINT_V2PUB.update_contact_point with status '''||l_return_status||'''');
1116: IF l_return_status <> 'S' THEN
1117: IF FND_API.TO_BOOLEAN(p_commit) THEN
1118: ROLLBACK TO EGO_UPDATE_GROUP;
1119: END IF;

Line 1350: l_contact_point_rec HZ_CONTACT_POINT_V2PUB.CONTACT_POINT_REC_TYPE;

1346: l_group_rec HZ_PARTY_V2PUB.GROUP_REC_TYPE;
1347: l_party_rec HZ_PARTY_V2PUB.PARTY_REC_TYPE;
1348: l_party_rel_rec HZ_RELATIONSHIP_V2PUB.RELATIONSHIP_REC_TYPE;
1349:
1350: l_contact_point_rec HZ_CONTACT_POINT_V2PUB.CONTACT_POINT_REC_TYPE;
1351: l_edi_rec HZ_CONTACT_POINT_V2PUB.EDI_REC_TYPE;
1352: l_email_rec HZ_CONTACT_POINT_V2PUB.EMAIL_REC_TYPE;
1353: l_phone_rec HZ_CONTACT_POINT_V2PUB.PHONE_REC_TYPE;
1354: l_telex_rec HZ_CONTACT_POINT_V2PUB.TELEX_REC_TYPE;

Line 1351: l_edi_rec HZ_CONTACT_POINT_V2PUB.EDI_REC_TYPE;

1347: l_party_rec HZ_PARTY_V2PUB.PARTY_REC_TYPE;
1348: l_party_rel_rec HZ_RELATIONSHIP_V2PUB.RELATIONSHIP_REC_TYPE;
1349:
1350: l_contact_point_rec HZ_CONTACT_POINT_V2PUB.CONTACT_POINT_REC_TYPE;
1351: l_edi_rec HZ_CONTACT_POINT_V2PUB.EDI_REC_TYPE;
1352: l_email_rec HZ_CONTACT_POINT_V2PUB.EMAIL_REC_TYPE;
1353: l_phone_rec HZ_CONTACT_POINT_V2PUB.PHONE_REC_TYPE;
1354: l_telex_rec HZ_CONTACT_POINT_V2PUB.TELEX_REC_TYPE;
1355: l_web_rec HZ_CONTACT_POINT_V2PUB.WEB_REC_TYPE;

Line 1352: l_email_rec HZ_CONTACT_POINT_V2PUB.EMAIL_REC_TYPE;

1348: l_party_rel_rec HZ_RELATIONSHIP_V2PUB.RELATIONSHIP_REC_TYPE;
1349:
1350: l_contact_point_rec HZ_CONTACT_POINT_V2PUB.CONTACT_POINT_REC_TYPE;
1351: l_edi_rec HZ_CONTACT_POINT_V2PUB.EDI_REC_TYPE;
1352: l_email_rec HZ_CONTACT_POINT_V2PUB.EMAIL_REC_TYPE;
1353: l_phone_rec HZ_CONTACT_POINT_V2PUB.PHONE_REC_TYPE;
1354: l_telex_rec HZ_CONTACT_POINT_V2PUB.TELEX_REC_TYPE;
1355: l_web_rec HZ_CONTACT_POINT_V2PUB.WEB_REC_TYPE;
1356:

Line 1353: l_phone_rec HZ_CONTACT_POINT_V2PUB.PHONE_REC_TYPE;

1349:
1350: l_contact_point_rec HZ_CONTACT_POINT_V2PUB.CONTACT_POINT_REC_TYPE;
1351: l_edi_rec HZ_CONTACT_POINT_V2PUB.EDI_REC_TYPE;
1352: l_email_rec HZ_CONTACT_POINT_V2PUB.EMAIL_REC_TYPE;
1353: l_phone_rec HZ_CONTACT_POINT_V2PUB.PHONE_REC_TYPE;
1354: l_telex_rec HZ_CONTACT_POINT_V2PUB.TELEX_REC_TYPE;
1355: l_web_rec HZ_CONTACT_POINT_V2PUB.WEB_REC_TYPE;
1356:
1357: l_curr_owner_id NUMBER;

Line 1354: l_telex_rec HZ_CONTACT_POINT_V2PUB.TELEX_REC_TYPE;

1350: l_contact_point_rec HZ_CONTACT_POINT_V2PUB.CONTACT_POINT_REC_TYPE;
1351: l_edi_rec HZ_CONTACT_POINT_V2PUB.EDI_REC_TYPE;
1352: l_email_rec HZ_CONTACT_POINT_V2PUB.EMAIL_REC_TYPE;
1353: l_phone_rec HZ_CONTACT_POINT_V2PUB.PHONE_REC_TYPE;
1354: l_telex_rec HZ_CONTACT_POINT_V2PUB.TELEX_REC_TYPE;
1355: l_web_rec HZ_CONTACT_POINT_V2PUB.WEB_REC_TYPE;
1356:
1357: l_curr_owner_id NUMBER;
1358: l_curr_member_id NUMBER;

Line 1355: l_web_rec HZ_CONTACT_POINT_V2PUB.WEB_REC_TYPE;

1351: l_edi_rec HZ_CONTACT_POINT_V2PUB.EDI_REC_TYPE;
1352: l_email_rec HZ_CONTACT_POINT_V2PUB.EMAIL_REC_TYPE;
1353: l_phone_rec HZ_CONTACT_POINT_V2PUB.PHONE_REC_TYPE;
1354: l_telex_rec HZ_CONTACT_POINT_V2PUB.TELEX_REC_TYPE;
1355: l_web_rec HZ_CONTACT_POINT_V2PUB.WEB_REC_TYPE;
1356:
1357: l_curr_owner_id NUMBER;
1358: l_curr_member_id NUMBER;
1359: l_group_member_rel_id NUMBER;

Line 1495: HZ_CONTACT_POINT_V2PUB.update_contact_point

1491: INTO l_contact_point_id, l_object_version_number;
1492: EXIT WHEN c_get_contact_point%NOTFOUND;
1493: l_contact_point_rec.status := 'I';
1494: l_contact_point_rec.contact_point_id := l_contact_point_id;
1495: HZ_CONTACT_POINT_V2PUB.update_contact_point
1496: (p_init_msg_list => NVL(p_init_msg_list, 'F')
1497: ,p_contact_point_rec => l_contact_point_rec
1498: ,p_edi_rec => l_edi_rec
1499: ,p_email_rec => l_email_rec