eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HZ_PERSON_INFO_V2PUB dependencies on HZ_PARTIES

Line 310: -- update the language_name in hz_parties based on native_language.

306:
307: -- assign the primary key back
308: x_language_use_reference_id := p_person_language_rec.language_use_reference_id;
309:
310: -- update the language_name in hz_parties based on native_language.
311: IF p_person_language_rec.NATIVE_LANGUAGE = 'Y'
312: AND nvl(p_person_language_rec.status,'A') = 'A'
313: THEN
314: UPDATE hz_parties

Line 314: UPDATE hz_parties

310: -- update the language_name in hz_parties based on native_language.
311: IF p_person_language_rec.NATIVE_LANGUAGE = 'Y'
312: AND nvl(p_person_language_rec.status,'A') = 'A'
313: THEN
314: UPDATE hz_parties
315: SET language_name = p_person_language_rec.language_name
316: WHERE party_id = p_person_language_rec.party_id;
317: END IF;
318:

Line 498: -- To update the language_name in hz_parties.

494: X_APPLICATION_ID => p_person_language_rec.application_id
495: );
496:
497:
498: -- To update the language_name in hz_parties.
499: ------------------Bug No. 4095604
500: IF nvl(p_person_language_rec.native_language,l_native_language)='Y' AND nvl(p_person_language_rec.status,l_status)='A' AND
501: (nvl(p_person_language_rec.native_language,l_native_language)<>l_native_language OR nvl(p_person_language_rec.status,l_status)<>l_status)
502: THEN UPDATE hz_parties

Line 502: THEN UPDATE hz_parties

498: -- To update the language_name in hz_parties.
499: ------------------Bug No. 4095604
500: IF nvl(p_person_language_rec.native_language,l_native_language)='Y' AND nvl(p_person_language_rec.status,l_status)='A' AND
501: (nvl(p_person_language_rec.native_language,l_native_language)<>l_native_language OR nvl(p_person_language_rec.status,l_status)<>l_status)
502: THEN UPDATE hz_parties
503: SET language_name= nvl(p_person_language_rec.language_name,l_language_name)
504: WHERE party_id=l_party_id;
505: ELSIF l_native_language='Y' AND l_status='A'
506: AND ((p_person_language_rec.native_language is not null AND p_person_language_rec.native_language <> l_native_language) OR

Line 508: UPDATE hz_parties

504: WHERE party_id=l_party_id;
505: ELSIF l_native_language='Y' AND l_status='A'
506: AND ((p_person_language_rec.native_language is not null AND p_person_language_rec.native_language <> l_native_language) OR
507: (p_person_language_rec.status is not null AND p_person_language_rec.status <> l_status)) THEN
508: UPDATE hz_parties
509: SET language_name=NULL
510: WHERE party_id=l_party_id;
511: END IF;
512: -------------------------Bug No. 4095604