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_REGISTRY_VALIDATE_V2PUB dependencies on HZ_EMPLOYMENT_HISTORY

Line 9407: FROM hz_employment_history hc

9403: temp_employed_as_title VARCHAR2(60);
9404:
9405: CURSOR employment_history_cur (p_employment_history_id IN NUMBER) IS
9406: SELECT 'Y'
9407: FROM hz_employment_history hc
9408: WHERE hc.employment_history_id = p_employment_history_id;
9409:
9410: BEGIN
9411:

Line 9451: FROM HZ_EMPLOYMENT_HISTORY

9447: l_employed_as_title,
9448: l_status,
9449: l_created_by_module,
9450: l_application_id
9451: FROM HZ_EMPLOYMENT_HISTORY
9452: WHERE ROWID = p_rowid;
9453: END IF;
9454:
9455:

Line 9604: fnd_message.set_token('TABLE_NAME', 'HZ_EMPLOYMENT_HISTORY');

9600:
9601: EXCEPTION
9602: WHEN NO_DATA_FOUND THEN
9603: fnd_message.set_name('AR', 'HZ_API_PARTY_NOT_PERSON');
9604: fnd_message.set_token('TABLE_NAME', 'HZ_EMPLOYMENT_HISTORY');
9605: fnd_message.set_token('PARTY_ID_COL', 'party_id');
9606: fnd_msg_pub.add;
9607: x_return_status := fnd_api.g_ret_sts_error;
9608: END;

Line 10282: * to be a foreign key from hz_employment_history.

10278: * MODIFICATION HISTORY
10279: *
10280: * 02-Feb-2003 Porkodi C o Created.
10281: * 10-Mar-2003 Porkodi C Bug 2829041, Corrected the validation for employment_history_id
10282: * to be a foreign key from hz_employment_history.
10283: *
10284: */
10285:
10286: PROCEDURE validate_work_class(

Line 10468: -- employment_history_id has foreign key HZ_EMPLOYMENT_HISTORY.EMPLOYMENT_HISTORY_ID

10464:
10465:
10466: END IF;
10467:
10468: -- employment_history_id has foreign key HZ_EMPLOYMENT_HISTORY.EMPLOYMENT_HISTORY_ID
10469: IF p_create_update_flag = 'C'
10470: AND
10471: p_work_class_rec.employment_history_id IS NOT NULL
10472: AND

Line 10478: FROM hz_employment_history p

10474: THEN
10475: BEGIN
10476: SELECT 'Y'
10477: INTO l_dummy
10478: FROM hz_employment_history p
10479: WHERE p.employment_history_id = p_work_class_rec.employment_history_id;
10480:
10481: EXCEPTION
10482: WHEN NO_DATA_FOUND THEN

Line 10486: fnd_message.set_token('TABLE', 'hz_employment_history');

10482: WHEN NO_DATA_FOUND THEN
10483: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
10484: fnd_message.set_token('FK', 'employment_history_id');
10485: fnd_message.set_token('COLUMN', 'employment_history_id');
10486: fnd_message.set_token('TABLE', 'hz_employment_history');
10487: fnd_msg_pub.add;
10488: x_return_status := fnd_api.g_ret_sts_error;
10489: END;
10490:

Line 10493: 'employment_history_id has foreign key hz_employment_history.employment_history_id. ' ||

10489: END;
10490:
10491: /*IF g_debug THEN
10492: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,
10493: 'employment_history_id has foreign key hz_employment_history.employment_history_id. ' ||
10494: 'x_return_status = ' || x_return_status, l_debug_prefix);
10495: END IF;
10496: */
10497: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 10499: p_message=>'employment_history_id has foreign key hz_employment_history.employment_history_id. ' ||

10495: END IF;
10496: */
10497: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
10498: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,
10499: p_message=>'employment_history_id has foreign key hz_employment_history.employment_history_id. ' ||
10500: 'x_return_status = ' || x_return_status,
10501: p_msg_level=>fnd_log.level_statement);
10502: END IF;
10503: