DBA Data[Home] [Help]

APPS.HZ_CUST_ACCOUNT_MERGE_V2PVT dependencies on HZ_PARTY_V2PUB

Line 78: x_party_rec OUT NOCOPY hz_party_v2pub.party_rec_type,

74:
75: PROCEDURE get_party_rec (
76: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
77: p_party_id IN NUMBER,
78: x_party_rec OUT NOCOPY hz_party_v2pub.party_rec_type,
79: x_return_status OUT NOCOPY VARCHAR2,
80: x_msg_count OUT NOCOPY NUMBER,
81: x_msg_data OUT NOCOPY VARCHAR2
82: ) IS

Line 878: l_party_rec HZ_PARTY_V2PUB.PARTY_REC_TYPE := p_relationship_rec.party_rec;

874: l_party_number VARCHAR2(30);
875: l_generate_party_number VARCHAR2(1);
876: l_rowid ROWID := NULL;
877: l_count NUMBER;
878: l_party_rec HZ_PARTY_V2PUB.PARTY_REC_TYPE := p_relationship_rec.party_rec;
879: l_party_name hz_parties.PARTY_NAME%TYPE;
880: l_subject_name hz_parties.PARTY_NAME%TYPE;
881: l_object_name hz_parties.PARTY_NAME%TYPE;
882: l_customer_key hz_parties.CUSTOMER_KEY%TYPE;

Line 3610: -- AND content_source_type = hz_party_v2pub.g_miss_content_source_type

3606: WHERE owner_table_name = p_owner_table_name
3607: AND owner_table_id = p_owner_table_id
3608: AND contact_point_type = p_contact_point_type
3609: AND contact_point_id <> l_contact_point_id
3610: -- AND content_source_type = hz_party_v2pub.g_miss_content_source_type
3611: AND primary_flag = 'Y';
3612:
3613:
3614: END do_unset_prim_contact_point;

Line 3662: -- AND content_source_type = hz_party_v2pub.g_miss_content_source_type

3658: AND owner_table_id = p_owner_table_id
3659: AND contact_point_type = p_contact_point_type
3660: AND contact_point_purpose = p_contact_point_purpose
3661: AND contact_point_id <> l_contact_point_id
3662: -- AND content_source_type = hz_party_v2pub.g_miss_content_source_type
3663: AND primary_by_purpose = 'Y';
3664:
3665: END do_unset_primary_by_purpose;
3666: