APPS.HZ_PARTY_CONTACT_V2PUB dependencies on HZ_PERSON_PROFILES

Line 305: /* HZ_PERSON_PROFILES */

301: SET person_pre_name_adjunct = p_org_contact_rec.title
302: WHERE party_id = p_org_contact_rec.party_rel_rec.subject_id
303: AND party_type = 'PERSON';
304:
305: /* HZ_PERSON_PROFILES */
306: BEGIN
307: SELECT 'Y'
308: INTO l_dummy
309: FROM hz_person_profiles

Line 309: FROM hz_person_profiles

305: /* HZ_PERSON_PROFILES */
306: BEGIN
307: SELECT 'Y'
308: INTO l_dummy
309: FROM hz_person_profiles
310: WHERE party_id = p_org_contact_rec.party_rel_rec.subject_id
311: AND effective_end_date IS NULL
312: FOR UPDATE NOWAIT;
313: EXCEPTION

Line 316: fnd_message.set_token('TABLE', 'HZ_PERSON_PROFILES');

312: FOR UPDATE NOWAIT;
313: EXCEPTION
314: WHEN OTHERS THEN
315: fnd_message.set_name('AR', 'HZ_API_RECORD_CHANGED');
316: fnd_message.set_token('TABLE', 'HZ_PERSON_PROFILES');
317: fnd_msg_pub.add;
318: RAISE FND_API.G_EXC_ERROR;
319: END;
320: UPDATE hz_person_profiles

Line 320: UPDATE hz_person_profiles

316: fnd_message.set_token('TABLE', 'HZ_PERSON_PROFILES');
317: fnd_msg_pub.add;
318: RAISE FND_API.G_EXC_ERROR;
319: END;
320: UPDATE hz_person_profiles
321: SET person_pre_name_adjunct = p_org_contact_rec.title
322: WHERE party_id = p_org_contact_rec.party_rel_rec.subject_id
323: AND effective_end_date IS NULL;
324: END IF;

Line 498: l_person_pre_name HZ_PERSON_PROFILES.PERSON_PRE_NAME_ADJUNCT%TYPE := NULL;

494: l_object_version_number NUMBER;
495: l_debug_prefix VARCHAR2(30);
496: l_object_id NUMBER;
497: l_org_status VARCHAR2(1);
498: l_person_pre_name HZ_PERSON_PROFILES.PERSON_PRE_NAME_ADJUNCT%TYPE := NULL;
499: l_party_id HZ_PARTIES.PARTY_ID%TYPE := NULL;
500: BEGIN
501: -- Debug info.
502: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 625: UPDATE HZ_PERSON_PROFILES

621: UPDATE HZ_PARTIES
622: SET PERSON_PRE_NAME_ADJUNCT = p_org_contact_rec.title
623: WHERE PARTY_ID = l_party_id;
624:
625: UPDATE HZ_PERSON_PROFILES
626: SET PERSON_PRE_NAME_ADJUNCT = p_org_contact_rec.title
627: WHERE PARTY_ID = l_party_id
628: AND EFFECTIVE_END_DATE IS NULL;
629: END IF;