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.GHR_UTILITY dependencies on PER_POSITION_EXTRA_INFO

Line 409: l_pos_cre_extra_info_id per_position_extra_info.position_extra_info_id%type;

405: SELECT 1 FROM hr_positions_f
406: WHERE information6 = to_char(c_position_id); -- Bug 4576746
407:
408: l_child_exists BOOLEAN;
409: l_pos_cre_extra_info_id per_position_extra_info.position_extra_info_id%type;
410: l_extra_info_id per_position_extra_info.position_extra_info_id%type;
411: l_pos_cre_ovn per_position_extra_info.object_version_number%type;
412: l_ovn per_position_extra_info.object_version_number%type;
413: l_information_type per_position_extra_info.information_type%type;

Line 410: l_extra_info_id per_position_extra_info.position_extra_info_id%type;

406: WHERE information6 = to_char(c_position_id); -- Bug 4576746
407:
408: l_child_exists BOOLEAN;
409: l_pos_cre_extra_info_id per_position_extra_info.position_extra_info_id%type;
410: l_extra_info_id per_position_extra_info.position_extra_info_id%type;
411: l_pos_cre_ovn per_position_extra_info.object_version_number%type;
412: l_ovn per_position_extra_info.object_version_number%type;
413: l_information_type per_position_extra_info.information_type%type;
414: l_session_date fnd_sessions.effective_date%type;

Line 411: l_pos_cre_ovn per_position_extra_info.object_version_number%type;

407:
408: l_child_exists BOOLEAN;
409: l_pos_cre_extra_info_id per_position_extra_info.position_extra_info_id%type;
410: l_extra_info_id per_position_extra_info.position_extra_info_id%type;
411: l_pos_cre_ovn per_position_extra_info.object_version_number%type;
412: l_ovn per_position_extra_info.object_version_number%type;
413: l_information_type per_position_extra_info.information_type%type;
414: l_session_date fnd_sessions.effective_date%type;
415: cursor c_get_session_date is

Line 412: l_ovn per_position_extra_info.object_version_number%type;

408: l_child_exists BOOLEAN;
409: l_pos_cre_extra_info_id per_position_extra_info.position_extra_info_id%type;
410: l_extra_info_id per_position_extra_info.position_extra_info_id%type;
411: l_pos_cre_ovn per_position_extra_info.object_version_number%type;
412: l_ovn per_position_extra_info.object_version_number%type;
413: l_information_type per_position_extra_info.information_type%type;
414: l_session_date fnd_sessions.effective_date%type;
415: cursor c_get_session_date is
416: select trunc(effective_date) session_date

Line 413: l_information_type per_position_extra_info.information_type%type;

409: l_pos_cre_extra_info_id per_position_extra_info.position_extra_info_id%type;
410: l_extra_info_id per_position_extra_info.position_extra_info_id%type;
411: l_pos_cre_ovn per_position_extra_info.object_version_number%type;
412: l_ovn per_position_extra_info.object_version_number%type;
413: l_information_type per_position_extra_info.information_type%type;
414: l_session_date fnd_sessions.effective_date%type;
415: cursor c_get_session_date is
416: select trunc(effective_date) session_date
417: from fnd_sessions

Line 554: l_pos_cre_extra_info_id per_position_extra_info.position_extra_info_id%type;

550: and pos.position_id = c_position_id
551: and c_effective_date between pos.effective_start_date and
552: pos.effective_end_date;
553:
554: l_pos_cre_extra_info_id per_position_extra_info.position_extra_info_id%type;
555: l_extra_info_id per_position_extra_info.position_extra_info_id%type;
556: l_pos_cre_ovn per_position_extra_info.object_version_number%type;
557: l_ovn per_position_extra_info.object_version_number%type;
558: l_information_type per_position_extra_info.information_type%type;

Line 555: l_extra_info_id per_position_extra_info.position_extra_info_id%type;

551: and c_effective_date between pos.effective_start_date and
552: pos.effective_end_date;
553:
554: l_pos_cre_extra_info_id per_position_extra_info.position_extra_info_id%type;
555: l_extra_info_id per_position_extra_info.position_extra_info_id%type;
556: l_pos_cre_ovn per_position_extra_info.object_version_number%type;
557: l_ovn per_position_extra_info.object_version_number%type;
558: l_information_type per_position_extra_info.information_type%type;
559: l_session_date fnd_sessions.effective_date%type;

Line 556: l_pos_cre_ovn per_position_extra_info.object_version_number%type;

552: pos.effective_end_date;
553:
554: l_pos_cre_extra_info_id per_position_extra_info.position_extra_info_id%type;
555: l_extra_info_id per_position_extra_info.position_extra_info_id%type;
556: l_pos_cre_ovn per_position_extra_info.object_version_number%type;
557: l_ovn per_position_extra_info.object_version_number%type;
558: l_information_type per_position_extra_info.information_type%type;
559: l_session_date fnd_sessions.effective_date%type;
560: cursor c_get_session_date is

Line 557: l_ovn per_position_extra_info.object_version_number%type;

553:
554: l_pos_cre_extra_info_id per_position_extra_info.position_extra_info_id%type;
555: l_extra_info_id per_position_extra_info.position_extra_info_id%type;
556: l_pos_cre_ovn per_position_extra_info.object_version_number%type;
557: l_ovn per_position_extra_info.object_version_number%type;
558: l_information_type per_position_extra_info.information_type%type;
559: l_session_date fnd_sessions.effective_date%type;
560: cursor c_get_session_date is
561: select trunc(effective_date) session_date

Line 558: l_information_type per_position_extra_info.information_type%type;

554: l_pos_cre_extra_info_id per_position_extra_info.position_extra_info_id%type;
555: l_extra_info_id per_position_extra_info.position_extra_info_id%type;
556: l_pos_cre_ovn per_position_extra_info.object_version_number%type;
557: l_ovn per_position_extra_info.object_version_number%type;
558: l_information_type per_position_extra_info.information_type%type;
559: l_session_date fnd_sessions.effective_date%type;
560: cursor c_get_session_date is
561: select trunc(effective_date) session_date
562: from fnd_sessions

Line 631: from per_position_extra_info

627: Cursor c_pos_ei(p_position_id in NUMBER,
628: p_information_type in VARCHAR2) is
629: select position_extra_info_id,
630: object_version_number
631: from per_position_extra_info
632: where position_id = p_position_id
633: and information_type = p_information_type;
634: l_pos_cre_extra_info_id per_position_extra_info.position_extra_info_id%type;
635: l_extra_info_id per_position_extra_info.position_extra_info_id%type;

Line 634: l_pos_cre_extra_info_id per_position_extra_info.position_extra_info_id%type;

630: object_version_number
631: from per_position_extra_info
632: where position_id = p_position_id
633: and information_type = p_information_type;
634: l_pos_cre_extra_info_id per_position_extra_info.position_extra_info_id%type;
635: l_extra_info_id per_position_extra_info.position_extra_info_id%type;
636: l_pos_cre_ovn per_position_extra_info.object_version_number%type;
637: l_ovn per_position_extra_info.object_version_number%type;
638: l_information_type per_position_extra_info.information_type%type;

Line 635: l_extra_info_id per_position_extra_info.position_extra_info_id%type;

631: from per_position_extra_info
632: where position_id = p_position_id
633: and information_type = p_information_type;
634: l_pos_cre_extra_info_id per_position_extra_info.position_extra_info_id%type;
635: l_extra_info_id per_position_extra_info.position_extra_info_id%type;
636: l_pos_cre_ovn per_position_extra_info.object_version_number%type;
637: l_ovn per_position_extra_info.object_version_number%type;
638: l_information_type per_position_extra_info.information_type%type;
639: BEGIN

Line 636: l_pos_cre_ovn per_position_extra_info.object_version_number%type;

632: where position_id = p_position_id
633: and information_type = p_information_type;
634: l_pos_cre_extra_info_id per_position_extra_info.position_extra_info_id%type;
635: l_extra_info_id per_position_extra_info.position_extra_info_id%type;
636: l_pos_cre_ovn per_position_extra_info.object_version_number%type;
637: l_ovn per_position_extra_info.object_version_number%type;
638: l_information_type per_position_extra_info.information_type%type;
639: BEGIN
640: -- Update/Create Position group1 Extra Info

Line 637: l_ovn per_position_extra_info.object_version_number%type;

633: and information_type = p_information_type;
634: l_pos_cre_extra_info_id per_position_extra_info.position_extra_info_id%type;
635: l_extra_info_id per_position_extra_info.position_extra_info_id%type;
636: l_pos_cre_ovn per_position_extra_info.object_version_number%type;
637: l_ovn per_position_extra_info.object_version_number%type;
638: l_information_type per_position_extra_info.information_type%type;
639: BEGIN
640: -- Update/Create Position group1 Extra Info
641: --

Line 638: l_information_type per_position_extra_info.information_type%type;

634: l_pos_cre_extra_info_id per_position_extra_info.position_extra_info_id%type;
635: l_extra_info_id per_position_extra_info.position_extra_info_id%type;
636: l_pos_cre_ovn per_position_extra_info.object_version_number%type;
637: l_ovn per_position_extra_info.object_version_number%type;
638: l_information_type per_position_extra_info.information_type%type;
639: BEGIN
640: -- Update/Create Position group1 Extra Info
641: --
642: -- EIT GHR_US_POS_GRP1