APPS.GHR_PROCESS_SF52 dependencies on GHR_PA_ROUTING_HISTORY

Line 2532: from ghr_pa_requests a, ghr_pa_routing_history b

2528: ----If p_poi is passed then use the following modified SQL.
2529:
2530: cursor c_par_pend_per_poi is
2531: select person_id,effective_date
2532: from ghr_pa_requests a, ghr_pa_routing_history b
2533: where effective_date <= sysdate
2534: and pa_notification_id is null
2535: and approval_date is not null
2536: and a.pa_request_id = b.pa_request_id

Line 2549: from ghr_pa_routing_history

2545: where per.person_id = a.person_id
2546: and a.effective_date between
2547: per.effective_start_date and per.effective_end_date )
2548: and b.pa_routing_history_id = (select max(pa_routing_history_id)
2549: from ghr_pa_routing_history
2550: where pa_request_id = a.pa_request_id)
2551: group by person_id,effective_date
2552: order by 2,1;
2553:

Line 2560: from ghr_pa_requests a, ghr_pa_routing_history b

2556:
2557: cursor c_par_pend_per is
2558: ---------Added as part of fix for the bug 2180343
2559: select person_id,effective_date
2560: from ghr_pa_requests a, ghr_pa_routing_history b
2561: where effective_date <= sysdate
2562: and pa_notification_id is null
2563: and approval_date is not null
2564: and a.pa_request_id = b.pa_request_id

Line 2573: from ghr_pa_routing_history

2569: where per.person_id = a.person_id
2570: and a.effective_date between
2571: per.effective_start_date and per.effective_end_date )
2572: and b.pa_routing_history_id = (select max(pa_routing_history_id)
2573: from ghr_pa_routing_history
2574: where pa_request_id = a.pa_request_id)
2575: group by person_id,effective_date
2576: order by 2,1;
2577:

Line 2585: from ghr_pa_routing_history

2581: where effective_date <= sysdate and
2582: pa_notification_id is null and
2583: approval_date is not null and
2584: exists (select 'exists'
2585: from ghr_pa_routing_history
2586: where pa_routing_history_id = (select max(pa_routing_history_id)
2587: from ghr_pa_routing_history
2588: where pa_request_id = a.pa_request_id)
2589: and action_taken in ('FUTURE_ACTION'))

Line 2587: from ghr_pa_routing_history

2583: approval_date is not null and
2584: exists (select 'exists'
2585: from ghr_pa_routing_history
2586: where pa_routing_history_id = (select max(pa_routing_history_id)
2587: from ghr_pa_routing_history
2588: where pa_request_id = a.pa_request_id)
2589: and action_taken in ('FUTURE_ACTION'))
2590: order by 2,1;
2591:

Line 2601: from ghr_pa_routing_history

2597: and pa_notification_id is null
2598: and approval_date is not null
2599: and noa.code = a.first_noa_code
2600: and exists (select 'exists'
2601: from ghr_pa_routing_history
2602: where pa_routing_history_id = (select max(pa_routing_history_id)
2603: from ghr_pa_routing_history
2604: where pa_request_id = a.pa_request_id)
2605: and action_taken in ('FUTURE_ACTION'))

Line 2603: from ghr_pa_routing_history

2599: and noa.code = a.first_noa_code
2600: and exists (select 'exists'
2601: from ghr_pa_routing_history
2602: where pa_routing_history_id = (select max(pa_routing_history_id)
2603: from ghr_pa_routing_history
2604: where pa_request_id = a.pa_request_id)
2605: and action_taken in ('FUTURE_ACTION'))
2606: order by 2 asc;
2607:

Line 2634: from ghr_pa_routing_history

2630: and pa_notification_id is null
2631: and approval_date is not null
2632: and noa.code = a.first_noa_code
2633: and exists (select 'exists'
2634: from ghr_pa_routing_history
2635: where pa_routing_history_id = (select max(pa_routing_history_id)
2636: from ghr_pa_routing_history
2637: where pa_request_id = a.pa_request_id)
2638: and action_taken in ('FUTURE_ACTION'))

Line 2636: from ghr_pa_routing_history

2632: and noa.code = a.first_noa_code
2633: and exists (select 'exists'
2634: from ghr_pa_routing_history
2635: where pa_routing_history_id = (select max(pa_routing_history_id)
2636: from ghr_pa_routing_history
2637: where pa_request_id = a.pa_request_id)
2638: and action_taken in ('FUTURE_ACTION'))
2639: order by 2 asc;
2640:

Line 3024: l_pa_routing_history_id ghr_pa_routing_history.pa_routing_history_id%type;

3020:
3021: l_groupbox_id ghr_groupboxes.groupbox_id%type;
3022: l_routing_group_id ghr_pa_requests.routing_group_id%type;
3023: l_proc varchar2(72) := ' ghr_process_sf52.' || 'update_routing_details';
3024: l_pa_routing_history_id ghr_pa_routing_history.pa_routing_history_id%type;
3025: l_pa_object_version_number ghr_pa_routing_history.object_version_number%type;
3026: l_user_name varchar2(30);
3027: l_log_text varchar2(2000);
3028:

Line 3025: l_pa_object_version_number ghr_pa_routing_history.object_version_number%type;

3021: l_groupbox_id ghr_groupboxes.groupbox_id%type;
3022: l_routing_group_id ghr_pa_requests.routing_group_id%type;
3023: l_proc varchar2(72) := ' ghr_process_sf52.' || 'update_routing_details';
3024: l_pa_routing_history_id ghr_pa_routing_history.pa_routing_history_id%type;
3025: l_pa_object_version_number ghr_pa_routing_history.object_version_number%type;
3026: l_user_name varchar2(30);
3027: l_log_text varchar2(2000);
3028:
3029:

Line 3037: from ghr_pa_routing_history

3033: select pa_routing_history_id,
3034: object_version_number,
3035: user_name,
3036: groupbox_id
3037: from ghr_pa_routing_history
3038: where pa_request_id = p_pa_request_id
3039: order by 1 desc;
3040:
3041:

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

3081: savepoint get_personnel_off_groupbox;
3082: hr_utility.set_location('Entering ' || l_proc,5);
3083: p_retcode := null;
3084:
3085: -- Find the groupbox of the personnelist, update ghr_pa_routing_history and then call work_flow
3086:
3087: If p_position_id is not null then
3088:
3089: l_log_text := 'Error while getting the groupbox of the personnel';

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

3183: );
3184: hr_utility.set_location(l_proc ,10);
3185:
3186:
3187: l_log_text := 'Error while updating groupbox to ghr_pa_routing_history table';
3188: for rout_hist in c_rout_history loop
3189: hr_utility.set_location(l_proc ,15);
3190: l_pa_routing_history_id := rout_hist.pa_routing_history_id;
3191: l_pa_object_version_number := rout_hist.object_version_number;

Line 3240: from ghr_pa_routing_history

3236: effective_date > cp_date_effective and
3237: pa_notification_id is null and
3238: approval_date is not null and
3239: exists (select 'exists'
3240: from ghr_pa_routing_history
3241: where pa_routing_history_id = (select max(pa_routing_history_id)
3242: from ghr_pa_routing_history
3243: where pa_request_id = a.pa_request_id)
3244: and action_taken in ('FUTURE_ACTION')) ;

Line 3242: from ghr_pa_routing_history

3238: approval_date is not null and
3239: exists (select 'exists'
3240: from ghr_pa_routing_history
3241: where pa_routing_history_id = (select max(pa_routing_history_id)
3242: from ghr_pa_routing_history
3243: where pa_request_id = a.pa_request_id)
3244: and action_taken in ('FUTURE_ACTION')) ;
3245: l_error varchar2(512):='Routed because of intervening RPA approval';
3246: l_rec get_req%rowtype;

Line 3290: from ghr_pa_routing_history

3286: effective_date = cp_date_effective and
3287: pa_notification_id is null and
3288: approval_date is not null and
3289: exists (select 'exists'
3290: from ghr_pa_routing_history
3291: where pa_routing_history_id = (select max(pa_routing_history_id)
3292: from ghr_pa_routing_history
3293: where pa_request_id = a.pa_request_id)
3294: and action_taken in ('FUTURE_ACTION')) ;

Line 3292: from ghr_pa_routing_history

3288: approval_date is not null and
3289: exists (select 'exists'
3290: from ghr_pa_routing_history
3291: where pa_routing_history_id = (select max(pa_routing_history_id)
3292: from ghr_pa_routing_history
3293: where pa_request_id = a.pa_request_id)
3294: and action_taken in ('FUTURE_ACTION')) ;
3295: l_error varchar2(512):='Routed because of intervening RPA approval';
3296: l_rec get_req%rowtype;