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 287: /* HZ_PARTIES */

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

Line 291: FROM hz_parties

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

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

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

Line 303: UPDATE hz_parties

299: fnd_msg_pub.add;
300: RAISE FND_API.G_EXC_ERROR;
301: END;
302: IF l_person_pre_name IS NULL THEN
303: UPDATE hz_parties
304: SET person_pre_name_adjunct = p_org_contact_rec.title
305: WHERE party_id = p_org_contact_rec.party_rel_rec.subject_id
306: AND party_type = 'PERSON';
307:

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

500: l_debug_prefix VARCHAR2(30);
501: l_object_id NUMBER;
502: l_org_status VARCHAR2(1);
503: l_person_pre_name HZ_PERSON_PROFILES.PERSON_PRE_NAME_ADJUNCT%TYPE := NULL;
504: l_party_id HZ_PARTIES.PARTY_ID%TYPE := NULL;
505: BEGIN
506: -- Debug info.
507: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
508: hz_utility_v2pub.debug(p_message=>'do_update_org_contact (-)',

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

613: THEN
614: BEGIN
615: SELECT P.PERSON_PRE_NAME_ADJUNCT,P.PARTY_ID INTO
616: l_person_pre_name,l_party_id
617: FROM HZ_PARTIES P, HZ_RELATIONSHIPS R, HZ_ORG_CONTACTS C
618: WHERE
619: C.ORG_CONTACT_ID = p_org_contact_rec.org_contact_id
620: AND R.RELATIONSHIP_ID = C.PARTY_RELATIONSHIP_ID
621: AND R.DIRECTIONAL_FLAG = 'F'

Line 626: UPDATE HZ_PARTIES

622: AND R.SUBJECT_ID = P.PARTY_ID
623: AND P.PARTY_TYPE = 'PERSON';
624:
625: IF l_person_pre_name IS NULL THEN
626: UPDATE HZ_PARTIES
627: SET PERSON_PRE_NAME_ADJUNCT = p_org_contact_rec.title
628: WHERE PARTY_ID = l_party_id;
629:
630: UPDATE HZ_PERSON_PROFILES