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.

[Home] [Help]

APPS.GHR_UTILITY dependencies on PER_POSITION_EXTRA_INFO

Line 419: l_pos_cre_extra_info_id per_position_extra_info.position_extra_info_id%type;

415: SELECT 1 FROM hr_positions_f
416: WHERE information6 = to_char(c_position_id); -- Bug 4576746
417:
418: l_child_exists BOOLEAN;
419: l_pos_cre_extra_info_id per_position_extra_info.position_extra_info_id%type;
420: l_extra_info_id per_position_extra_info.position_extra_info_id%type;
421: l_pos_cre_ovn per_position_extra_info.object_version_number%type;
422: l_ovn per_position_extra_info.object_version_number%type;
423: l_information_type per_position_extra_info.information_type%type;

Line 420: l_extra_info_id per_position_extra_info.position_extra_info_id%type;

416: WHERE information6 = to_char(c_position_id); -- Bug 4576746
417:
418: l_child_exists BOOLEAN;
419: l_pos_cre_extra_info_id per_position_extra_info.position_extra_info_id%type;
420: l_extra_info_id per_position_extra_info.position_extra_info_id%type;
421: l_pos_cre_ovn per_position_extra_info.object_version_number%type;
422: l_ovn per_position_extra_info.object_version_number%type;
423: l_information_type per_position_extra_info.information_type%type;
424: l_session_date fnd_sessions.effective_date%type;

Line 421: l_pos_cre_ovn per_position_extra_info.object_version_number%type;

417:
418: l_child_exists BOOLEAN;
419: l_pos_cre_extra_info_id per_position_extra_info.position_extra_info_id%type;
420: l_extra_info_id per_position_extra_info.position_extra_info_id%type;
421: l_pos_cre_ovn per_position_extra_info.object_version_number%type;
422: l_ovn per_position_extra_info.object_version_number%type;
423: l_information_type per_position_extra_info.information_type%type;
424: l_session_date fnd_sessions.effective_date%type;
425: cursor c_get_session_date is

Line 422: l_ovn per_position_extra_info.object_version_number%type;

418: l_child_exists BOOLEAN;
419: l_pos_cre_extra_info_id per_position_extra_info.position_extra_info_id%type;
420: l_extra_info_id per_position_extra_info.position_extra_info_id%type;
421: l_pos_cre_ovn per_position_extra_info.object_version_number%type;
422: l_ovn per_position_extra_info.object_version_number%type;
423: l_information_type per_position_extra_info.information_type%type;
424: l_session_date fnd_sessions.effective_date%type;
425: cursor c_get_session_date is
426: select trunc(effective_date) session_date

Line 423: l_information_type per_position_extra_info.information_type%type;

419: l_pos_cre_extra_info_id per_position_extra_info.position_extra_info_id%type;
420: l_extra_info_id per_position_extra_info.position_extra_info_id%type;
421: l_pos_cre_ovn per_position_extra_info.object_version_number%type;
422: l_ovn per_position_extra_info.object_version_number%type;
423: l_information_type per_position_extra_info.information_type%type;
424: l_session_date fnd_sessions.effective_date%type;
425: cursor c_get_session_date is
426: select trunc(effective_date) session_date
427: from fnd_sessions

Line 564: l_pos_cre_extra_info_id per_position_extra_info.position_extra_info_id%type;

560: and pos.position_id = c_position_id
561: and c_effective_date between pos.effective_start_date and
562: pos.effective_end_date;
563:
564: l_pos_cre_extra_info_id per_position_extra_info.position_extra_info_id%type;
565: l_extra_info_id per_position_extra_info.position_extra_info_id%type;
566: l_pos_cre_ovn per_position_extra_info.object_version_number%type;
567: l_ovn per_position_extra_info.object_version_number%type;
568: l_information_type per_position_extra_info.information_type%type;

Line 565: l_extra_info_id per_position_extra_info.position_extra_info_id%type;

561: and c_effective_date between pos.effective_start_date and
562: pos.effective_end_date;
563:
564: l_pos_cre_extra_info_id per_position_extra_info.position_extra_info_id%type;
565: l_extra_info_id per_position_extra_info.position_extra_info_id%type;
566: l_pos_cre_ovn per_position_extra_info.object_version_number%type;
567: l_ovn per_position_extra_info.object_version_number%type;
568: l_information_type per_position_extra_info.information_type%type;
569: l_session_date fnd_sessions.effective_date%type;

Line 566: l_pos_cre_ovn per_position_extra_info.object_version_number%type;

562: pos.effective_end_date;
563:
564: l_pos_cre_extra_info_id per_position_extra_info.position_extra_info_id%type;
565: l_extra_info_id per_position_extra_info.position_extra_info_id%type;
566: l_pos_cre_ovn per_position_extra_info.object_version_number%type;
567: l_ovn per_position_extra_info.object_version_number%type;
568: l_information_type per_position_extra_info.information_type%type;
569: l_session_date fnd_sessions.effective_date%type;
570: cursor c_get_session_date is

Line 567: l_ovn per_position_extra_info.object_version_number%type;

563:
564: l_pos_cre_extra_info_id per_position_extra_info.position_extra_info_id%type;
565: l_extra_info_id per_position_extra_info.position_extra_info_id%type;
566: l_pos_cre_ovn per_position_extra_info.object_version_number%type;
567: l_ovn per_position_extra_info.object_version_number%type;
568: l_information_type per_position_extra_info.information_type%type;
569: l_session_date fnd_sessions.effective_date%type;
570: cursor c_get_session_date is
571: select trunc(effective_date) session_date

Line 568: l_information_type per_position_extra_info.information_type%type;

564: l_pos_cre_extra_info_id per_position_extra_info.position_extra_info_id%type;
565: l_extra_info_id per_position_extra_info.position_extra_info_id%type;
566: l_pos_cre_ovn per_position_extra_info.object_version_number%type;
567: l_ovn per_position_extra_info.object_version_number%type;
568: l_information_type per_position_extra_info.information_type%type;
569: l_session_date fnd_sessions.effective_date%type;
570: cursor c_get_session_date is
571: select trunc(effective_date) session_date
572: from fnd_sessions

Line 641: from per_position_extra_info

637: Cursor c_pos_ei(p_position_id in NUMBER,
638: p_information_type in VARCHAR2) is
639: select position_extra_info_id,
640: object_version_number
641: from per_position_extra_info
642: where position_id = p_position_id
643: and information_type = p_information_type;
644: l_pos_cre_extra_info_id per_position_extra_info.position_extra_info_id%type;
645: l_extra_info_id per_position_extra_info.position_extra_info_id%type;

Line 644: l_pos_cre_extra_info_id per_position_extra_info.position_extra_info_id%type;

640: object_version_number
641: from per_position_extra_info
642: where position_id = p_position_id
643: and information_type = p_information_type;
644: l_pos_cre_extra_info_id per_position_extra_info.position_extra_info_id%type;
645: l_extra_info_id per_position_extra_info.position_extra_info_id%type;
646: l_pos_cre_ovn per_position_extra_info.object_version_number%type;
647: l_ovn per_position_extra_info.object_version_number%type;
648: l_information_type per_position_extra_info.information_type%type;

Line 645: l_extra_info_id per_position_extra_info.position_extra_info_id%type;

641: from per_position_extra_info
642: where position_id = p_position_id
643: and information_type = p_information_type;
644: l_pos_cre_extra_info_id per_position_extra_info.position_extra_info_id%type;
645: l_extra_info_id per_position_extra_info.position_extra_info_id%type;
646: l_pos_cre_ovn per_position_extra_info.object_version_number%type;
647: l_ovn per_position_extra_info.object_version_number%type;
648: l_information_type per_position_extra_info.information_type%type;
649: BEGIN

Line 646: l_pos_cre_ovn per_position_extra_info.object_version_number%type;

642: where position_id = p_position_id
643: and information_type = p_information_type;
644: l_pos_cre_extra_info_id per_position_extra_info.position_extra_info_id%type;
645: l_extra_info_id per_position_extra_info.position_extra_info_id%type;
646: l_pos_cre_ovn per_position_extra_info.object_version_number%type;
647: l_ovn per_position_extra_info.object_version_number%type;
648: l_information_type per_position_extra_info.information_type%type;
649: BEGIN
650: -- Update/Create Position group1 Extra Info

Line 647: l_ovn per_position_extra_info.object_version_number%type;

643: and information_type = p_information_type;
644: l_pos_cre_extra_info_id per_position_extra_info.position_extra_info_id%type;
645: l_extra_info_id per_position_extra_info.position_extra_info_id%type;
646: l_pos_cre_ovn per_position_extra_info.object_version_number%type;
647: l_ovn per_position_extra_info.object_version_number%type;
648: l_information_type per_position_extra_info.information_type%type;
649: BEGIN
650: -- Update/Create Position group1 Extra Info
651: --

Line 648: l_information_type per_position_extra_info.information_type%type;

644: l_pos_cre_extra_info_id per_position_extra_info.position_extra_info_id%type;
645: l_extra_info_id per_position_extra_info.position_extra_info_id%type;
646: l_pos_cre_ovn per_position_extra_info.object_version_number%type;
647: l_ovn per_position_extra_info.object_version_number%type;
648: l_information_type per_position_extra_info.information_type%type;
649: BEGIN
650: -- Update/Create Position group1 Extra Info
651: --
652: -- EIT GHR_US_POS_GRP1