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 9404: FROM hz_employment_history hc

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

Line 9448: FROM HZ_EMPLOYMENT_HISTORY

9444: l_employed_as_title,
9445: l_status,
9446: l_created_by_module,
9447: l_application_id
9448: FROM HZ_EMPLOYMENT_HISTORY
9449: WHERE ROWID = p_rowid;
9450: END IF;
9451:
9452:

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

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

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

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

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

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

Line 10475: FROM hz_employment_history p

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

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

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

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

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

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

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