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_PERSON_LANGUAGE

Line 201: FROM HZ_PERSON_LANGUAGE

197: p_person_language_rec.language_use_reference_id <> FND_API.G_MISS_NUM
198: THEN
199: BEGIN
200: SELECT 'Y' INTO l_dummy
201: FROM HZ_PERSON_LANGUAGE
202: WHERE LANGUAGE_USE_REFERENCE_ID = p_person_language_rec.language_use_reference_id;
203:
204: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');
205: FND_MESSAGE.SET_TOKEN('COLUMN', 'language_use_reference_id');

Line 221: FROM HZ_PERSON_LANGUAGE

217: IF p_person_language_rec.primary_language_indicator = 'Y' THEN
218: BEGIN
219: SELECT LANGUAGE_USE_REFERENCE_ID
220: INTO l_language_use_reference_id
221: FROM HZ_PERSON_LANGUAGE
222: WHERE PARTY_ID = p_person_language_rec.party_id
223: AND PRIMARY_LANGUAGE_INDICATOR = 'Y'
224: AND LANGUAGE_USE_REFERENCE_ID <> NVL(p_person_language_rec.language_use_reference_id, fnd_api.g_miss_num);
225:

Line 226: UPDATE HZ_PERSON_LANGUAGE

222: WHERE PARTY_ID = p_person_language_rec.party_id
223: AND PRIMARY_LANGUAGE_INDICATOR = 'Y'
224: AND LANGUAGE_USE_REFERENCE_ID <> NVL(p_person_language_rec.language_use_reference_id, fnd_api.g_miss_num);
225:
226: UPDATE HZ_PERSON_LANGUAGE
227: SET primary_language_indicator='N'
228: WHERE PARTY_ID = p_person_language_rec.party_id AND
229: PRIMARY_LANGUAGE_INDICATOR ='Y' AND
230: LANGUAGE_USE_REFERENCE_ID = l_language_use_reference_id;

Line 253: FROM HZ_PERSON_LANGUAGE

249: IF p_person_language_rec.native_language = 'Y' THEN
250: BEGIN
251: SELECT LANGUAGE_USE_REFERENCE_ID
252: INTO l_language_use_reference_id
253: FROM HZ_PERSON_LANGUAGE
254: WHERE PARTY_ID = p_person_language_rec.party_id
255: AND NATIVE_LANGUAGE = 'Y'
256: AND LANGUAGE_USE_REFERENCE_ID <> NVL(p_person_language_rec.language_use_reference_id, fnd_api.g_miss_num);
257:

Line 258: UPDATE HZ_PERSON_LANGUAGE

254: WHERE PARTY_ID = p_person_language_rec.party_id
255: AND NATIVE_LANGUAGE = 'Y'
256: AND LANGUAGE_USE_REFERENCE_ID <> NVL(p_person_language_rec.language_use_reference_id, fnd_api.g_miss_num);
257:
258: UPDATE HZ_PERSON_LANGUAGE
259: SET native_language='N'
260: WHERE PARTY_ID = p_person_language_rec.party_id AND
261: NATIVE_LANGUAGE ='Y' AND
262: LANGUAGE_USE_REFERENCE_ID = l_language_use_reference_id;

Line 291: HZ_PERSON_LANGUAGE_PKG.Insert_Row (

287: RAISE FND_API.G_EXC_ERROR;
288: END IF;
289:
290: -- call table handler to insert a row
291: HZ_PERSON_LANGUAGE_PKG.Insert_Row (
292: X_LANGUAGE_USE_REFERENCE_ID => p_person_language_rec.language_use_reference_id,
293: X_LANGUAGE_NAME => p_person_language_rec.language_name,
294: X_PARTY_ID => p_person_language_rec.party_id,
295: X_NATIVE_LANGUAGE => p_person_language_rec.native_language,

Line 375: FROM HZ_PERSON_LANGUAGE

371: SELECT rowid, object_version_number, party_id,
372: native_language, language_name,status
373: INTO l_rowid, l_object_version_number, l_party_id,
374: l_native_language, l_language_name,l_status
375: FROM HZ_PERSON_LANGUAGE
376: WHERE language_use_reference_id = p_person_language_rec.language_use_reference_id
377: FOR UPDATE NOWAIT;
378:
379: IF NOT

Line 390: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_PERSON_LANGUAGE');

386: )
387: )
388: THEN
389: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
390: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_PERSON_LANGUAGE');
391: FND_MSG_PUB.ADD;
392: RAISE FND_API.G_EXC_ERROR;
393: END IF;
394:

Line 400: FND_MESSAGE.SET_TOKEN('RECORD', 'HZ_PERSON_LANGUAGE');

396:
397: EXCEPTION
398: WHEN NO_DATA_FOUND THEN
399: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
400: FND_MESSAGE.SET_TOKEN('RECORD', 'HZ_PERSON_LANGUAGE');
401: FND_MESSAGE.SET_TOKEN('VALUE', NVL( TO_CHAR( p_person_language_rec.language_use_reference_id ), 'null' ) );
402: FND_MSG_PUB.ADD;
403: RAISE FND_API.G_EXC_ERROR;
404: END;

Line 412: FROM HZ_PERSON_LANGUAGE

408: IF p_person_language_rec.primary_language_indicator = 'Y' THEN
409: BEGIN
410: SELECT LANGUAGE_USE_REFERENCE_ID
411: INTO l_language_use_reference_id
412: FROM HZ_PERSON_LANGUAGE
413: WHERE PARTY_ID = l_party_id
414: AND PRIMARY_LANGUAGE_INDICATOR = 'Y'
415: AND LANGUAGE_USE_REFERENCE_ID <> NVL(p_person_language_rec.language_use_reference_id, fnd_api.g_miss_num);
416:

Line 417: UPDATE HZ_PERSON_LANGUAGE

413: WHERE PARTY_ID = l_party_id
414: AND PRIMARY_LANGUAGE_INDICATOR = 'Y'
415: AND LANGUAGE_USE_REFERENCE_ID <> NVL(p_person_language_rec.language_use_reference_id, fnd_api.g_miss_num);
416:
417: UPDATE HZ_PERSON_LANGUAGE
418: SET primary_language_indicator='N'
419: WHERE PARTY_ID = l_party_id AND
420: PRIMARY_LANGUAGE_INDICATOR ='Y' AND
421: LANGUAGE_USE_REFERENCE_ID = l_language_use_reference_id;

Line 443: FROM HZ_PERSON_LANGUAGE

439: IF p_person_language_rec.native_language = 'Y' THEN
440: BEGIN
441: SELECT LANGUAGE_USE_REFERENCE_ID
442: INTO l_language_use_reference_id
443: FROM HZ_PERSON_LANGUAGE
444: WHERE PARTY_ID = l_party_id
445: AND NATIVE_LANGUAGE = 'Y'
446: AND LANGUAGE_USE_REFERENCE_ID <> NVL(p_person_language_rec.language_use_reference_id, fnd_api.g_miss_num);
447:

Line 448: UPDATE HZ_PERSON_LANGUAGE

444: WHERE PARTY_ID = l_party_id
445: AND NATIVE_LANGUAGE = 'Y'
446: AND LANGUAGE_USE_REFERENCE_ID <> NVL(p_person_language_rec.language_use_reference_id, fnd_api.g_miss_num);
447:
448: UPDATE HZ_PERSON_LANGUAGE
449: SET native_language='N'
450: WHERE PARTY_ID = l_party_id AND
451: NATIVE_LANGUAGE ='Y' AND
452: LANGUAGE_USE_REFERENCE_ID = l_language_use_reference_id;

Line 480: HZ_PERSON_LANGUAGE_PKG.Update_Row (

476: RAISE FND_API.G_EXC_ERROR;
477: END IF;
478:
479: -- call table handler to update a row
480: HZ_PERSON_LANGUAGE_PKG.Update_Row (
481: X_Rowid => l_rowid,
482: X_LANGUAGE_USE_REFERENCE_ID => p_person_language_rec.language_use_reference_id,
483: X_LANGUAGE_NAME => p_person_language_rec.language_name,
484: X_PARTY_ID => p_person_language_rec.party_id,

Line 1630: HZ_POPULATE_BOT_PKG.pop_hz_person_language(

1626: l_person_language_rec );
1627: END IF;
1628:
1629: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
1630: HZ_POPULATE_BOT_PKG.pop_hz_person_language(
1631: p_operation => 'I',
1632: p_language_use_reference_id => x_language_use_reference_id);
1633: END IF;
1634: END IF;

Line 1758: HZ_POPULATE_BOT_PKG.pop_hz_person_language(

1754: l_old_person_language_rec );
1755: END IF;
1756:
1757: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
1758: HZ_POPULATE_BOT_PKG.pop_hz_person_language(
1759: p_operation => 'U',
1760: p_language_use_reference_id => l_person_language_rec.language_use_reference_id);
1761: END IF;
1762: END IF;

Line 1807: * HZ_PERSON_LANGUAGE_PKG.Select_Row

1803: * DESCRIPTION
1804: * Gets class category record.
1805: *
1806: * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
1807: * HZ_PERSON_LANGUAGE_PKG.Select_Row
1808: *
1809: * ARGUMENTS
1810: * IN:
1811: * p_init_msg_list Initialize message stack if it is set to

Line 1867: HZ_PERSON_LANGUAGE_PKG.Select_Row (

1863:
1864: -- The x_person_language_rec.language_use_reference_id must be initiated to p_language_use_reference_id
1865: p_person_language_rec.language_use_reference_id := p_language_use_reference_id;
1866:
1867: HZ_PERSON_LANGUAGE_PKG.Select_Row (
1868: X_LANGUAGE_USE_REFERENCE_ID => p_person_language_rec.language_use_reference_id,
1869: X_LANGUAGE_NAME => p_person_language_rec.language_name,
1870: X_PARTY_ID => p_person_language_rec.party_id,
1871: X_NATIVE_LANGUAGE => p_person_language_rec.native_language,