DBA Data[Home] [Help]

APPS.GHR_PROCESS_SF52 dependencies on GHR_PA_REQUESTS

Line 5: g_prd ghr_pa_requests.pay_rate_determinant%type := NULL;

1: package GHR_PROCESS_SF52 AUTHID CURRENT_USER as
2: /* $Header: ghproc52.pkh 120.4.12020000.1 2012/06/29 04:35:46 appldev ship $ */
3:
4: g_total_pay_check varchar2(1) := 'Y';
5: g_prd ghr_pa_requests.pay_rate_determinant%type := NULL;
6: g_step_or_rate ghr_pa_requests.to_step_or_rate%type := NULL;
7: e_refresh EXCEPTION; -- Bug# 5634990
8:
9: g_dual_prior_ws ghr_pa_requests.work_schedule%type := NULL; --8267598

Line 6: g_step_or_rate ghr_pa_requests.to_step_or_rate%type := NULL;

2: /* $Header: ghproc52.pkh 120.4.12020000.1 2012/06/29 04:35:46 appldev ship $ */
3:
4: g_total_pay_check varchar2(1) := 'Y';
5: g_prd ghr_pa_requests.pay_rate_determinant%type := NULL;
6: g_step_or_rate ghr_pa_requests.to_step_or_rate%type := NULL;
7: e_refresh EXCEPTION; -- Bug# 5634990
8:
9: g_dual_prior_ws ghr_pa_requests.work_schedule%type := NULL; --8267598
10: g_dual_first_noac ghr_pa_requests.first_noa_code%type := NULL; --8264475

Line 9: g_dual_prior_ws ghr_pa_requests.work_schedule%type := NULL; --8267598

5: g_prd ghr_pa_requests.pay_rate_determinant%type := NULL;
6: g_step_or_rate ghr_pa_requests.to_step_or_rate%type := NULL;
7: e_refresh EXCEPTION; -- Bug# 5634990
8:
9: g_dual_prior_ws ghr_pa_requests.work_schedule%type := NULL; --8267598
10: g_dual_first_noac ghr_pa_requests.first_noa_code%type := NULL; --8264475
11: g_dual_second_noac ghr_pa_requests.first_noa_code%type := NULL; --8264475
12: g_dual_prior_prd ghr_pa_requests.pay_rate_determinant%type := NULL; --8268353
13: g_dual_action_yn varchar2(1) := 'Y'; --8264475

Line 10: g_dual_first_noac ghr_pa_requests.first_noa_code%type := NULL; --8264475

6: g_step_or_rate ghr_pa_requests.to_step_or_rate%type := NULL;
7: e_refresh EXCEPTION; -- Bug# 5634990
8:
9: g_dual_prior_ws ghr_pa_requests.work_schedule%type := NULL; --8267598
10: g_dual_first_noac ghr_pa_requests.first_noa_code%type := NULL; --8264475
11: g_dual_second_noac ghr_pa_requests.first_noa_code%type := NULL; --8264475
12: g_dual_prior_prd ghr_pa_requests.pay_rate_determinant%type := NULL; --8268353
13: g_dual_action_yn varchar2(1) := 'Y'; --8264475
14:

Line 11: g_dual_second_noac ghr_pa_requests.first_noa_code%type := NULL; --8264475

7: e_refresh EXCEPTION; -- Bug# 5634990
8:
9: g_dual_prior_ws ghr_pa_requests.work_schedule%type := NULL; --8267598
10: g_dual_first_noac ghr_pa_requests.first_noa_code%type := NULL; --8264475
11: g_dual_second_noac ghr_pa_requests.first_noa_code%type := NULL; --8264475
12: g_dual_prior_prd ghr_pa_requests.pay_rate_determinant%type := NULL; --8268353
13: g_dual_action_yn varchar2(1) := 'Y'; --8264475
14:
15: PROCEDURE refresh_pa_request(

Line 12: g_dual_prior_prd ghr_pa_requests.pay_rate_determinant%type := NULL; --8268353

8:
9: g_dual_prior_ws ghr_pa_requests.work_schedule%type := NULL; --8267598
10: g_dual_first_noac ghr_pa_requests.first_noa_code%type := NULL; --8264475
11: g_dual_second_noac ghr_pa_requests.first_noa_code%type := NULL; --8264475
12: g_dual_prior_prd ghr_pa_requests.pay_rate_determinant%type := NULL; --8268353
13: g_dual_action_yn varchar2(1) := 'Y'; --8264475
14:
15: PROCEDURE refresh_pa_request(
16: p_person_id in per_people_f.person_id%type,

Line 22: p_sf52_data in out nocopy ghr_pa_requests%rowtype);

18: p_from_only in boolean default FALSE,
19: p_derive_to_cols in boolean default FALSE,
20: -- p_altered_pa_request_id in number default NULL,
21: -- p_noa_id_corrected in number default NULL,
22: p_sf52_data in out nocopy ghr_pa_requests%rowtype);
23: -- p_from_location_id out nocopy hr_locations.location_id%type
24:
25:
26: Procedure Process_SF52 (

Line 27: p_sf52_data in out nocopy ghr_pa_requests%rowtype,

23: -- p_from_location_id out nocopy hr_locations.location_id%type
24:
25:
26: Procedure Process_SF52 (
27: p_sf52_data in out nocopy ghr_pa_requests%rowtype,
28: p_process_type in varchar2 default 'CURRENT',
29: p_validate in Boolean default FALSE,
30: p_capped_other_pay in Number default NULL);
31: Procedure assign_new_rg (

Line 35: p_pa_req in out nocopy ghr_pa_requests%rowtype);

31: Procedure assign_new_rg (
32: p_action_num in number,
33: -- p_altered_pa_request_id in number default NULL,
34: -- p_noa_id_corrected in number default NULL,
35: p_pa_req in out nocopy ghr_pa_requests%rowtype);
36: Procedure copy_2ndNoa_to_1stNoa (p_pa_req in out nocopy ghr_pa_requests%rowtype);
37: Procedure null_2ndNoa_cols (p_pa_req in out nocopy ghr_pa_requests%rowtype);
38:
39: Procedure Fetch_Extra_Info(

Line 36: Procedure copy_2ndNoa_to_1stNoa (p_pa_req in out nocopy ghr_pa_requests%rowtype);

32: p_action_num in number,
33: -- p_altered_pa_request_id in number default NULL,
34: -- p_noa_id_corrected in number default NULL,
35: p_pa_req in out nocopy ghr_pa_requests%rowtype);
36: Procedure copy_2ndNoa_to_1stNoa (p_pa_req in out nocopy ghr_pa_requests%rowtype);
37: Procedure null_2ndNoa_cols (p_pa_req in out nocopy ghr_pa_requests%rowtype);
38:
39: Procedure Fetch_Extra_Info(
40: p_pa_request_id in number,

Line 37: Procedure null_2ndNoa_cols (p_pa_req in out nocopy ghr_pa_requests%rowtype);

33: -- p_altered_pa_request_id in number default NULL,
34: -- p_noa_id_corrected in number default NULL,
35: p_pa_req in out nocopy ghr_pa_requests%rowtype);
36: Procedure copy_2ndNoa_to_1stNoa (p_pa_req in out nocopy ghr_pa_requests%rowtype);
37: Procedure null_2ndNoa_cols (p_pa_req in out nocopy ghr_pa_requests%rowtype);
38:
39: Procedure Fetch_Extra_Info(
40: p_pa_request_id in number,
41: p_noa_id in number,

Line 66: p_pa_req_in in ghr_pa_requests%rowtype,

62: p_effective_date in date
63: );
64:
65: Procedure get_par_ap_apue_fields(
66: p_pa_req_in in ghr_pa_requests%rowtype,
67: p_first_noa_id in ghr_pa_requests.first_noa_id%type,
68: p_second_noa_id in ghr_pa_requests.second_noa_id%type,
69: p_pa_req_out out nocopy ghr_pa_requests%rowtype);
70:

Line 67: p_first_noa_id in ghr_pa_requests.first_noa_id%type,

63: );
64:
65: Procedure get_par_ap_apue_fields(
66: p_pa_req_in in ghr_pa_requests%rowtype,
67: p_first_noa_id in ghr_pa_requests.first_noa_id%type,
68: p_second_noa_id in ghr_pa_requests.second_noa_id%type,
69: p_pa_req_out out nocopy ghr_pa_requests%rowtype);
70:
71: Procedure derive_to_columns(p_sf52_data in out nocopy ghr_pa_requests%rowtype);

Line 68: p_second_noa_id in ghr_pa_requests.second_noa_id%type,

64:
65: Procedure get_par_ap_apue_fields(
66: p_pa_req_in in ghr_pa_requests%rowtype,
67: p_first_noa_id in ghr_pa_requests.first_noa_id%type,
68: p_second_noa_id in ghr_pa_requests.second_noa_id%type,
69: p_pa_req_out out nocopy ghr_pa_requests%rowtype);
70:
71: Procedure derive_to_columns(p_sf52_data in out nocopy ghr_pa_requests%rowtype);
72: Procedure Redo_Pay_calc ( p_sf52_rec in out nocopy ghr_pa_requests%rowtype,

Line 69: p_pa_req_out out nocopy ghr_pa_requests%rowtype);

65: Procedure get_par_ap_apue_fields(
66: p_pa_req_in in ghr_pa_requests%rowtype,
67: p_first_noa_id in ghr_pa_requests.first_noa_id%type,
68: p_second_noa_id in ghr_pa_requests.second_noa_id%type,
69: p_pa_req_out out nocopy ghr_pa_requests%rowtype);
70:
71: Procedure derive_to_columns(p_sf52_data in out nocopy ghr_pa_requests%rowtype);
72: Procedure Redo_Pay_calc ( p_sf52_rec in out nocopy ghr_pa_requests%rowtype,
73: p_capped_other_pay in out nocopy number );

Line 71: Procedure derive_to_columns(p_sf52_data in out nocopy ghr_pa_requests%rowtype);

67: p_first_noa_id in ghr_pa_requests.first_noa_id%type,
68: p_second_noa_id in ghr_pa_requests.second_noa_id%type,
69: p_pa_req_out out nocopy ghr_pa_requests%rowtype);
70:
71: Procedure derive_to_columns(p_sf52_data in out nocopy ghr_pa_requests%rowtype);
72: Procedure Redo_Pay_calc ( p_sf52_rec in out nocopy ghr_pa_requests%rowtype,
73: p_capped_other_pay in out nocopy number );
74:
75: Procedure refresh_req_shadow (

Line 72: Procedure Redo_Pay_calc ( p_sf52_rec in out nocopy ghr_pa_requests%rowtype,

68: p_second_noa_id in ghr_pa_requests.second_noa_id%type,
69: p_pa_req_out out nocopy ghr_pa_requests%rowtype);
70:
71: Procedure derive_to_columns(p_sf52_data in out nocopy ghr_pa_requests%rowtype);
72: Procedure Redo_Pay_calc ( p_sf52_rec in out nocopy ghr_pa_requests%rowtype,
73: p_capped_other_pay in out nocopy number );
74:
75: Procedure refresh_req_shadow (
76: p_sf52_data in out nocopy ghr_pa_requests%rowtype,

Line 76: p_sf52_data in out nocopy ghr_pa_requests%rowtype,

72: Procedure Redo_Pay_calc ( p_sf52_rec in out nocopy ghr_pa_requests%rowtype,
73: p_capped_other_pay in out nocopy number );
74:
75: Procedure refresh_req_shadow (
76: p_sf52_data in out nocopy ghr_pa_requests%rowtype,
77: p_shadow_data out nocopy ghr_pa_request_shadow%rowtype,
78: p_process_type in varchar2 default 'CURRENT');
79:
80: Procedure create_shadow_row ( p_sf52_data in ghr_pa_requests%rowtype);

Line 80: Procedure create_shadow_row ( p_sf52_data in ghr_pa_requests%rowtype);

76: p_sf52_data in out nocopy ghr_pa_requests%rowtype,
77: p_shadow_data out nocopy ghr_pa_request_shadow%rowtype,
78: p_process_type in varchar2 default 'CURRENT');
79:
80: Procedure create_shadow_row ( p_sf52_data in ghr_pa_requests%rowtype);
81: Procedure create_shadow_row ( p_shadow_data in ghr_pa_request_shadow%rowtype);
82: Procedure Update_rfrs_values( p_sf52_data in out nocopy ghr_pa_requests%rowtype,
83: p_shadow_data in ghr_pa_request_shadow%rowtype);
84: procedure print_sf52(p_proc VARCHAR2, p_pa_request_rec GHR_PA_REQUESTS%ROWTYPE);

Line 82: Procedure Update_rfrs_values( p_sf52_data in out nocopy ghr_pa_requests%rowtype,

78: p_process_type in varchar2 default 'CURRENT');
79:
80: Procedure create_shadow_row ( p_sf52_data in ghr_pa_requests%rowtype);
81: Procedure create_shadow_row ( p_shadow_data in ghr_pa_request_shadow%rowtype);
82: Procedure Update_rfrs_values( p_sf52_data in out nocopy ghr_pa_requests%rowtype,
83: p_shadow_data in ghr_pa_request_shadow%rowtype);
84: procedure print_sf52(p_proc VARCHAR2, p_pa_request_rec GHR_PA_REQUESTS%ROWTYPE);
85:
86: --8267598

Line 84: procedure print_sf52(p_proc VARCHAR2, p_pa_request_rec GHR_PA_REQUESTS%ROWTYPE);

80: Procedure create_shadow_row ( p_sf52_data in ghr_pa_requests%rowtype);
81: Procedure create_shadow_row ( p_shadow_data in ghr_pa_request_shadow%rowtype);
82: Procedure Update_rfrs_values( p_sf52_data in out nocopy ghr_pa_requests%rowtype,
83: p_shadow_data in ghr_pa_request_shadow%rowtype);
84: procedure print_sf52(p_proc VARCHAR2, p_pa_request_rec GHR_PA_REQUESTS%ROWTYPE);
85:
86: --8267598
87: procedure reinit_dual_var;
88: