APPS.HZ_PARTY_CONTACT_V2PUB dependencies on HZ_PARTIES

Line 176: l_person_pre_name HZ_PARTIES.PERSON_PRE_NAME_ADJUNCT%TYPE := NULL;

172: l_dummy VARCHAR2(1);
173: l_debug_prefix VARCHAR2(30);
174: l_org_status VARCHAR2(1);
175: l_object_id NUMBER;
176: l_person_pre_name HZ_PARTIES.PERSON_PRE_NAME_ADJUNCT%TYPE := NULL;
177: l_orig_sys_reference_rec HZ_ORIG_SYSTEM_REF_PUB.ORIG_SYS_REFERENCE_REC_TYPE;
178:
179: CURSOR c_rel IS
180: SELECT BACKWARD_REL_CODE

Line 284: /* HZ_PARTIES */

280: IF p_org_contact_rec.party_rel_rec.subject_type = 'PERSON' AND
281: p_org_contact_rec.title IS NOT NULL AND
282: p_org_contact_rec.title <> FND_API.G_MISS_CHAR
283: THEN
284: /* HZ_PARTIES */
285: BEGIN
286: SELECT person_pre_name_adjunct
287: INTO l_person_pre_name
288: FROM hz_parties

Line 288: FROM hz_parties

284: /* HZ_PARTIES */
285: BEGIN
286: SELECT person_pre_name_adjunct
287: INTO l_person_pre_name
288: FROM hz_parties
289: WHERE party_id = p_org_contact_rec.party_rel_rec.subject_id
290: AND party_type = 'PERSON'
291: FOR UPDATE NOWAIT;
292: EXCEPTION

Line 295: fnd_message.set_token('TABLE', 'HZ_PARTIES');

291: FOR UPDATE NOWAIT;
292: EXCEPTION
293: WHEN OTHERS THEN
294: fnd_message.set_name('AR', 'HZ_API_RECORD_CHANGED');
295: fnd_message.set_token('TABLE', 'HZ_PARTIES');
296: fnd_msg_pub.add;
297: RAISE FND_API.G_EXC_ERROR;
298: END;
299: IF l_person_pre_name IS NULL THEN

Line 300: UPDATE hz_parties

296: fnd_msg_pub.add;
297: RAISE FND_API.G_EXC_ERROR;
298: END;
299: IF l_person_pre_name IS NULL THEN
300: UPDATE hz_parties
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:

Line 499: l_party_id HZ_PARTIES.PARTY_ID%TYPE := NULL;

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
503: hz_utility_v2pub.debug(p_message=>'do_update_org_contact (-)',

Line 612: FROM HZ_PARTIES P, HZ_RELATIONSHIPS R, HZ_ORG_CONTACTS C

608: THEN
609: BEGIN
610: SELECT P.PERSON_PRE_NAME_ADJUNCT,P.PARTY_ID INTO
611: l_person_pre_name,l_party_id
612: FROM HZ_PARTIES P, HZ_RELATIONSHIPS R, HZ_ORG_CONTACTS C
613: WHERE
614: C.ORG_CONTACT_ID = p_org_contact_rec.org_contact_id
615: AND R.RELATIONSHIP_ID = C.PARTY_RELATIONSHIP_ID
616: AND R.DIRECTIONAL_FLAG = 'F'

Line 621: UPDATE HZ_PARTIES

617: AND R.SUBJECT_ID = P.PARTY_ID
618: AND P.PARTY_TYPE = 'PERSON';
619:
620: IF l_person_pre_name IS NULL THEN
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