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_PROCESS_SF52 dependencies on GHR_PA_ROUTING_HISTORY

Line 2642: from ghr_pa_requests a, ghr_pa_routing_history b

2638: ----If p_poi is passed then use the following modified SQL.
2639:
2640: cursor c_par_pend_per_poi is
2641: select person_id,effective_date
2642: from ghr_pa_requests a, ghr_pa_routing_history b
2643: where effective_date <= sysdate
2644: and pa_notification_id is null
2645: and approval_date is not null
2646: and a.pa_request_id = b.pa_request_id

Line 2659: from ghr_pa_routing_history

2655: where per.person_id = a.person_id
2656: and a.effective_date between
2657: per.effective_start_date and per.effective_end_date )
2658: and b.pa_routing_history_id = (select max(pa_routing_history_id)
2659: from ghr_pa_routing_history
2660: where pa_request_id = a.pa_request_id)
2661: group by person_id,effective_date
2662: order by 2,1;
2663:

Line 2670: from ghr_pa_requests a, ghr_pa_routing_history b

2666:
2667: cursor c_par_pend_per is
2668: ---------Added as part of fix for the bug 2180343
2669: select person_id,effective_date
2670: from ghr_pa_requests a, ghr_pa_routing_history b
2671: where effective_date <= sysdate
2672: and pa_notification_id is null
2673: and approval_date is not null
2674: and a.pa_request_id = b.pa_request_id

Line 2683: from ghr_pa_routing_history

2679: where per.person_id = a.person_id
2680: and a.effective_date between
2681: per.effective_start_date and per.effective_end_date )
2682: and b.pa_routing_history_id = (select max(pa_routing_history_id)
2683: from ghr_pa_routing_history
2684: where pa_request_id = a.pa_request_id)
2685: group by person_id,effective_date
2686: order by 2,1;
2687:

Line 2695: from ghr_pa_routing_history

2691: where effective_date <= sysdate and
2692: pa_notification_id is null and
2693: approval_date is not null and
2694: exists (select 'exists'
2695: from ghr_pa_routing_history
2696: where pa_routing_history_id = (select max(pa_routing_history_id)
2697: from ghr_pa_routing_history
2698: where pa_request_id = a.pa_request_id)
2699: and action_taken in ('FUTURE_ACTION'))

Line 2697: from ghr_pa_routing_history

2693: approval_date is not null and
2694: exists (select 'exists'
2695: from ghr_pa_routing_history
2696: where pa_routing_history_id = (select max(pa_routing_history_id)
2697: from ghr_pa_routing_history
2698: where pa_request_id = a.pa_request_id)
2699: and action_taken in ('FUTURE_ACTION'))
2700: order by 2,1;
2701:

Line 2711: from ghr_pa_routing_history

2707: and pa_notification_id is null
2708: and approval_date is not null
2709: and noa.code = a.first_noa_code
2710: and exists (select 'exists'
2711: from ghr_pa_routing_history
2712: where pa_routing_history_id = (select max(pa_routing_history_id)
2713: from ghr_pa_routing_history
2714: where pa_request_id = a.pa_request_id)
2715: and action_taken in ('FUTURE_ACTION'))

Line 2713: from ghr_pa_routing_history

2709: and noa.code = a.first_noa_code
2710: and exists (select 'exists'
2711: from ghr_pa_routing_history
2712: where pa_routing_history_id = (select max(pa_routing_history_id)
2713: from ghr_pa_routing_history
2714: where pa_request_id = a.pa_request_id)
2715: and action_taken in ('FUTURE_ACTION'))
2716: order by 2 asc;
2717:

Line 2744: from ghr_pa_routing_history

2740: and pa_notification_id is null
2741: and approval_date is not null
2742: and noa.code = a.first_noa_code
2743: and exists (select 'exists'
2744: from ghr_pa_routing_history
2745: where pa_routing_history_id = (select max(pa_routing_history_id)
2746: from ghr_pa_routing_history
2747: where pa_request_id = a.pa_request_id)
2748: and action_taken in ('FUTURE_ACTION'))

Line 2746: from ghr_pa_routing_history

2742: and noa.code = a.first_noa_code
2743: and exists (select 'exists'
2744: from ghr_pa_routing_history
2745: where pa_routing_history_id = (select max(pa_routing_history_id)
2746: from ghr_pa_routing_history
2747: where pa_request_id = a.pa_request_id)
2748: and action_taken in ('FUTURE_ACTION'))
2749: order by 2 asc;
2750:

Line 3150: l_pa_routing_history_id ghr_pa_routing_history.pa_routing_history_id%type;

3146:
3147: l_groupbox_id ghr_groupboxes.groupbox_id%type;
3148: l_routing_group_id ghr_pa_requests.routing_group_id%type;
3149: l_proc varchar2(72) := ' ghr_process_sf52.' || 'update_routing_details';
3150: l_pa_routing_history_id ghr_pa_routing_history.pa_routing_history_id%type;
3151: l_pa_object_version_number ghr_pa_routing_history.object_version_number%type;
3152: l_user_name varchar2(30);
3153: l_log_text varchar2(2000);
3154:

Line 3151: l_pa_object_version_number ghr_pa_routing_history.object_version_number%type;

3147: l_groupbox_id ghr_groupboxes.groupbox_id%type;
3148: l_routing_group_id ghr_pa_requests.routing_group_id%type;
3149: l_proc varchar2(72) := ' ghr_process_sf52.' || 'update_routing_details';
3150: l_pa_routing_history_id ghr_pa_routing_history.pa_routing_history_id%type;
3151: l_pa_object_version_number ghr_pa_routing_history.object_version_number%type;
3152: l_user_name varchar2(30);
3153: l_log_text varchar2(2000);
3154:
3155:

Line 3163: from ghr_pa_routing_history

3159: select pa_routing_history_id,
3160: object_version_number,
3161: user_name,
3162: groupbox_id
3163: from ghr_pa_routing_history
3164: where pa_request_id = p_pa_request_id
3165: order by 1 desc;
3166:
3167:

Line 3211: -- Find the groupbox of the personnelist, update ghr_pa_routing_history and then call work_flow

3207: savepoint get_personnel_off_groupbox;
3208: hr_utility.set_location('Entering ' || l_proc,5);
3209: p_retcode := null;
3210:
3211: -- Find the groupbox of the personnelist, update ghr_pa_routing_history and then call work_flow
3212:
3213: If p_position_id is not null then
3214:
3215: l_log_text := 'Error while getting the groupbox of the personnel';

Line 3313: l_log_text := 'Error while updating groupbox to ghr_pa_routing_history table';

3309: );
3310: hr_utility.set_location(l_proc ,10);
3311:
3312:
3313: l_log_text := 'Error while updating groupbox to ghr_pa_routing_history table';
3314: for rout_hist in c_rout_history loop
3315: hr_utility.set_location(l_proc ,15);
3316: l_pa_routing_history_id := rout_hist.pa_routing_history_id;
3317: l_pa_object_version_number := rout_hist.object_version_number;

Line 3366: from ghr_pa_routing_history

3362: effective_date > cp_date_effective and
3363: pa_notification_id is null and
3364: approval_date is not null and
3365: exists (select 'exists'
3366: from ghr_pa_routing_history
3367: where pa_routing_history_id = (select max(pa_routing_history_id)
3368: from ghr_pa_routing_history
3369: where pa_request_id = a.pa_request_id)
3370: and action_taken in ('FUTURE_ACTION')) ;

Line 3368: from ghr_pa_routing_history

3364: approval_date is not null and
3365: exists (select 'exists'
3366: from ghr_pa_routing_history
3367: where pa_routing_history_id = (select max(pa_routing_history_id)
3368: from ghr_pa_routing_history
3369: where pa_request_id = a.pa_request_id)
3370: and action_taken in ('FUTURE_ACTION')) ;
3371: l_error varchar2(512):='Routed because of intervening RPA approval';
3372: l_rec get_req%rowtype;

Line 3416: from ghr_pa_routing_history

3412: effective_date = cp_date_effective and
3413: pa_notification_id is null and
3414: approval_date is not null and
3415: exists (select 'exists'
3416: from ghr_pa_routing_history
3417: where pa_routing_history_id = (select max(pa_routing_history_id)
3418: from ghr_pa_routing_history
3419: where pa_request_id = a.pa_request_id)
3420: and action_taken in ('FUTURE_ACTION')) ;

Line 3418: from ghr_pa_routing_history

3414: approval_date is not null and
3415: exists (select 'exists'
3416: from ghr_pa_routing_history
3417: where pa_routing_history_id = (select max(pa_routing_history_id)
3418: from ghr_pa_routing_history
3419: where pa_request_id = a.pa_request_id)
3420: and action_taken in ('FUTURE_ACTION')) ;
3421: l_error varchar2(512):='Routed because of intervening RPA approval';
3422: l_rec get_req%rowtype;

Line 6918: l_u_pa_routing_history_id ghr_pa_routing_history.pa_routing_history_id%TYPE;

6914: l_ovn ghr_pa_requests.object_version_number%type;
6915: l_pa_remark_id ghr_pa_remarks.pa_remark_id%type;
6916: l_object_version_number ghr_pa_remarks.object_version_number%type;
6917: --8737212
6918: l_u_pa_routing_history_id ghr_pa_routing_history.pa_routing_history_id%TYPE;
6919: l_u_prh_object_version_number ghr_pa_routing_history.object_version_number%TYPE;
6920:
6921: cursor c_dual_cancel
6922: is

Line 6919: l_u_prh_object_version_number ghr_pa_routing_history.object_version_number%TYPE;

6915: l_pa_remark_id ghr_pa_remarks.pa_remark_id%type;
6916: l_object_version_number ghr_pa_remarks.object_version_number%type;
6917: --8737212
6918: l_u_pa_routing_history_id ghr_pa_routing_history.pa_routing_history_id%TYPE;
6919: l_u_prh_object_version_number ghr_pa_routing_history.object_version_number%TYPE;
6920:
6921: cursor c_dual_cancel
6922: is
6923: select *

Line 6960: FROM ghr_pa_routing_history prh

6956: cursor C_routing_history_id
6957: is
6958: SELECT prh.pa_routing_history_id,
6959: prh.object_version_number
6960: FROM ghr_pa_routing_history prh
6961: WHERE prh.pa_request_id = l_sf52_dual_sec_rec.pa_request_id
6962: ORDER by prh.pa_routing_history_id desc;
6963:
6964: cursor c_first_routing_det

Line 6967: from ghr_pa_routing_history prh

6963:
6964: cursor c_first_routing_det
6965: is
6966: select *
6967: from ghr_pa_routing_history prh
6968: where prh.pa_request_id = p_sf52_data.pa_request_id
6969: and ACTION_TAKEN = 'UPDATE_HR'
6970: and APPROVAL_STATUS = 'APPROVE';
6971: --8737212