DBA Data[Home] [Help]

APPS.HZ_MAP_PARTY_PUB dependencies on HZ_CONTACT_POINT_V2PUB

Line 2313: l_contact_points_rec hz_contact_point_v2pub.contact_point_rec_type;

2309: --l_fin_rep_rec hz_org_info_pub.financial_reports_rec_type;
2310: l_fin_rep_rec HZ_ORGANIZATION_INFO_V2PUB.financial_report_rec_type;
2311: --l_fin_num_rec hz_org_info_pub.financial_numbers_rec_type;
2312: l_fin_num_rec HZ_ORGANIZATION_INFO_V2PUB.financial_number_rec_type;
2313: l_contact_points_rec hz_contact_point_v2pub.contact_point_rec_type;
2314: l_phone_rec hz_contact_point_v2pub.phone_rec_type := HZ_CONTACT_POINT_V2PUB.G_MISS_PHONE_REC;
2315: l_code_assignment_rec hz_classification_v2pub.code_assignment_rec_type;
2316: l_organization_profile_id NUMBER;
2317: l_is_new_party BOOLEAN := FALSE;

Line 2314: l_phone_rec hz_contact_point_v2pub.phone_rec_type := HZ_CONTACT_POINT_V2PUB.G_MISS_PHONE_REC;

2310: l_fin_rep_rec HZ_ORGANIZATION_INFO_V2PUB.financial_report_rec_type;
2311: --l_fin_num_rec hz_org_info_pub.financial_numbers_rec_type;
2312: l_fin_num_rec HZ_ORGANIZATION_INFO_V2PUB.financial_number_rec_type;
2313: l_contact_points_rec hz_contact_point_v2pub.contact_point_rec_type;
2314: l_phone_rec hz_contact_point_v2pub.phone_rec_type := HZ_CONTACT_POINT_V2PUB.G_MISS_PHONE_REC;
2315: l_code_assignment_rec hz_classification_v2pub.code_assignment_rec_type;
2316: l_organization_profile_id NUMBER;
2317: l_is_new_party BOOLEAN := FALSE;
2318: x_new_fin_report VARCHAR2(1);

Line 4421: p_contact_points_rec IN OUT NOCOPY hz_contact_point_v2pub.contact_point_rec_type,

4417: |
4418: +===========================================================================*/
4419:
4420: procedure store_contact_point(
4421: p_contact_points_rec IN OUT NOCOPY hz_contact_point_v2pub.contact_point_rec_type,
4422: p_phone_rec IN OUT NOCOPY hz_contact_point_v2pub.phone_rec_type,
4423: x_return_status IN OUT NOCOPY VARCHAR2
4424: ) IS
4425: l_edi_rec hz_contact_point_v2pub.edi_rec_type := HZ_CONTACT_POINT_v2PUB.G_MISS_EDI_REC;

Line 4422: p_phone_rec IN OUT NOCOPY hz_contact_point_v2pub.phone_rec_type,

4418: +===========================================================================*/
4419:
4420: procedure store_contact_point(
4421: p_contact_points_rec IN OUT NOCOPY hz_contact_point_v2pub.contact_point_rec_type,
4422: p_phone_rec IN OUT NOCOPY hz_contact_point_v2pub.phone_rec_type,
4423: x_return_status IN OUT NOCOPY VARCHAR2
4424: ) IS
4425: l_edi_rec hz_contact_point_v2pub.edi_rec_type := HZ_CONTACT_POINT_v2PUB.G_MISS_EDI_REC;
4426: l_email_rec hz_contact_point_v2pub.email_rec_type := HZ_CONTACT_POINT_v2PUB.G_MISS_EMAIL_REC;

Line 4425: l_edi_rec hz_contact_point_v2pub.edi_rec_type := HZ_CONTACT_POINT_v2PUB.G_MISS_EDI_REC;

4421: p_contact_points_rec IN OUT NOCOPY hz_contact_point_v2pub.contact_point_rec_type,
4422: p_phone_rec IN OUT NOCOPY hz_contact_point_v2pub.phone_rec_type,
4423: x_return_status IN OUT NOCOPY VARCHAR2
4424: ) IS
4425: l_edi_rec hz_contact_point_v2pub.edi_rec_type := HZ_CONTACT_POINT_v2PUB.G_MISS_EDI_REC;
4426: l_email_rec hz_contact_point_v2pub.email_rec_type := HZ_CONTACT_POINT_v2PUB.G_MISS_EMAIL_REC;
4427: l_telex_rec hz_contact_point_v2pub.telex_rec_type := HZ_CONTACT_POINT_v2PUB.G_MISS_TELEX_REC;
4428: l_web_rec hz_contact_point_v2pub.web_rec_type := HZ_CONTACT_POINT_v2PUB.G_MISS_WEB_REC;
4429:

Line 4426: l_email_rec hz_contact_point_v2pub.email_rec_type := HZ_CONTACT_POINT_v2PUB.G_MISS_EMAIL_REC;

4422: p_phone_rec IN OUT NOCOPY hz_contact_point_v2pub.phone_rec_type,
4423: x_return_status IN OUT NOCOPY VARCHAR2
4424: ) IS
4425: l_edi_rec hz_contact_point_v2pub.edi_rec_type := HZ_CONTACT_POINT_v2PUB.G_MISS_EDI_REC;
4426: l_email_rec hz_contact_point_v2pub.email_rec_type := HZ_CONTACT_POINT_v2PUB.G_MISS_EMAIL_REC;
4427: l_telex_rec hz_contact_point_v2pub.telex_rec_type := HZ_CONTACT_POINT_v2PUB.G_MISS_TELEX_REC;
4428: l_web_rec hz_contact_point_v2pub.web_rec_type := HZ_CONTACT_POINT_v2PUB.G_MISS_WEB_REC;
4429:
4430: l_mosr_mapping_exist VARCHAR2(1);

Line 4427: l_telex_rec hz_contact_point_v2pub.telex_rec_type := HZ_CONTACT_POINT_v2PUB.G_MISS_TELEX_REC;

4423: x_return_status IN OUT NOCOPY VARCHAR2
4424: ) IS
4425: l_edi_rec hz_contact_point_v2pub.edi_rec_type := HZ_CONTACT_POINT_v2PUB.G_MISS_EDI_REC;
4426: l_email_rec hz_contact_point_v2pub.email_rec_type := HZ_CONTACT_POINT_v2PUB.G_MISS_EMAIL_REC;
4427: l_telex_rec hz_contact_point_v2pub.telex_rec_type := HZ_CONTACT_POINT_v2PUB.G_MISS_TELEX_REC;
4428: l_web_rec hz_contact_point_v2pub.web_rec_type := HZ_CONTACT_POINT_v2PUB.G_MISS_WEB_REC;
4429:
4430: l_mosr_mapping_exist VARCHAR2(1);
4431: l_msg_count NUMBER;

Line 4428: l_web_rec hz_contact_point_v2pub.web_rec_type := HZ_CONTACT_POINT_v2PUB.G_MISS_WEB_REC;

4424: ) IS
4425: l_edi_rec hz_contact_point_v2pub.edi_rec_type := HZ_CONTACT_POINT_v2PUB.G_MISS_EDI_REC;
4426: l_email_rec hz_contact_point_v2pub.email_rec_type := HZ_CONTACT_POINT_v2PUB.G_MISS_EMAIL_REC;
4427: l_telex_rec hz_contact_point_v2pub.telex_rec_type := HZ_CONTACT_POINT_v2PUB.G_MISS_TELEX_REC;
4428: l_web_rec hz_contact_point_v2pub.web_rec_type := HZ_CONTACT_POINT_v2PUB.G_MISS_WEB_REC;
4429:
4430: l_mosr_mapping_exist VARCHAR2(1);
4431: l_msg_count NUMBER;
4432: l_msg_data VARCHAR2(2000);

Line 4508: hz_contact_point_v2pub.update_contact_point(

4504: p_contact_points_rec.orig_system := NULL;
4505: p_contact_points_rec.orig_system_reference := l_orig_system_reference;
4506: p_contact_points_rec.created_by_module := NULL;
4507: p_contact_points_rec.application_id := NULL;
4508: hz_contact_point_v2pub.update_contact_point(
4509: 'F',
4510: p_contact_points_rec,
4511: l_edi_rec,
4512: l_email_rec,

Line 4607: hz_contact_point_v2pub.create_contact_point(

4603: END IF;
4604:
4605: p_contact_points_rec.application_id := 222;
4606: p_contact_points_rec.created_by_module := 'TCA_DNB_MAPPING';
4607: hz_contact_point_v2pub.create_contact_point(
4608: 'F',
4609: p_contact_points_rec,
4610: l_edi_rec,
4611: l_email_rec,

Line 6113: l_contact_points_rec hz_contact_point_v2pub.contact_point_rec_type;

6109:
6110:
6111: l_organization_rec HZ_PARTY_V2PUB.organization_rec_type;
6112: l_location_rec hz_location_v2pub.location_rec_type;
6113: l_contact_points_rec hz_contact_point_v2pub.contact_point_rec_type;
6114: l_phone_rec hz_contact_point_v2pub.phone_rec_type := HZ_CONTACT_POINT_V2PUB.G_MISS_PHONE_REC;
6115: l_party_rel_rec HZ_RELATIONSHIP_V2PUB.relationship_rec_type;
6116:
6117: l_msg_count NUMBER;

Line 6114: l_phone_rec hz_contact_point_v2pub.phone_rec_type := HZ_CONTACT_POINT_V2PUB.G_MISS_PHONE_REC;

6110:
6111: l_organization_rec HZ_PARTY_V2PUB.organization_rec_type;
6112: l_location_rec hz_location_v2pub.location_rec_type;
6113: l_contact_points_rec hz_contact_point_v2pub.contact_point_rec_type;
6114: l_phone_rec hz_contact_point_v2pub.phone_rec_type := HZ_CONTACT_POINT_V2PUB.G_MISS_PHONE_REC;
6115: l_party_rel_rec HZ_RELATIONSHIP_V2PUB.relationship_rec_type;
6116:
6117: l_msg_count NUMBER;
6118: l_msg_data VARCHAR2(2000);