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 as
2: /* $Header: ghproc52.pkh 120.0.12010000.2 2008/08/05 15:10:40 ubhat 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: PROCEDURE refresh_pa_request(
9: p_person_id in per_people_f.person_id%type,

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

2: /* $Header: ghproc52.pkh 120.0.12010000.2 2008/08/05 15:10:40 ubhat 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: PROCEDURE refresh_pa_request(
9: p_person_id in per_people_f.person_id%type,
10: p_effective_date in date,

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

11: p_from_only in boolean default FALSE,
12: p_derive_to_cols in boolean default FALSE,
13: -- p_altered_pa_request_id in number default NULL,
14: -- p_noa_id_corrected in number default NULL,
15: p_sf52_data in out nocopy ghr_pa_requests%rowtype);
16: -- p_from_location_id out nocopy hr_locations.location_id%type
17:
18:
19: Procedure Process_SF52 (

Line 20: p_sf52_data in out nocopy ghr_pa_requests%rowtype,

16: -- p_from_location_id out nocopy hr_locations.location_id%type
17:
18:
19: Procedure Process_SF52 (
20: p_sf52_data in out nocopy ghr_pa_requests%rowtype,
21: p_process_type in varchar2 default 'CURRENT',
22: p_validate in Boolean default FALSE,
23: p_capped_other_pay in Number default NULL);
24: Procedure assign_new_rg (

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

24: Procedure assign_new_rg (
25: p_action_num in number,
26: -- p_altered_pa_request_id in number default NULL,
27: -- p_noa_id_corrected in number default NULL,
28: p_pa_req in out nocopy ghr_pa_requests%rowtype);
29: Procedure copy_2ndNoa_to_1stNoa (p_pa_req in out nocopy ghr_pa_requests%rowtype);
30: Procedure null_2ndNoa_cols (p_pa_req in out nocopy ghr_pa_requests%rowtype);
31:
32: Procedure Fetch_Extra_Info(

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

25: p_action_num in number,
26: -- p_altered_pa_request_id in number default NULL,
27: -- p_noa_id_corrected in number default NULL,
28: p_pa_req in out nocopy ghr_pa_requests%rowtype);
29: Procedure copy_2ndNoa_to_1stNoa (p_pa_req in out nocopy ghr_pa_requests%rowtype);
30: Procedure null_2ndNoa_cols (p_pa_req in out nocopy ghr_pa_requests%rowtype);
31:
32: Procedure Fetch_Extra_Info(
33: p_pa_request_id in number,

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

26: -- p_altered_pa_request_id in number default NULL,
27: -- p_noa_id_corrected in number default NULL,
28: p_pa_req in out nocopy ghr_pa_requests%rowtype);
29: Procedure copy_2ndNoa_to_1stNoa (p_pa_req in out nocopy ghr_pa_requests%rowtype);
30: Procedure null_2ndNoa_cols (p_pa_req in out nocopy ghr_pa_requests%rowtype);
31:
32: Procedure Fetch_Extra_Info(
33: p_pa_request_id in number,
34: p_noa_id in number,

Line 59: p_pa_req_in in ghr_pa_requests%rowtype,

55: p_effective_date in date
56: );
57:
58: Procedure get_par_ap_apue_fields(
59: p_pa_req_in in ghr_pa_requests%rowtype,
60: p_first_noa_id in ghr_pa_requests.first_noa_id%type,
61: p_second_noa_id in ghr_pa_requests.second_noa_id%type,
62: p_pa_req_out out nocopy ghr_pa_requests%rowtype);
63:

Line 60: p_first_noa_id in ghr_pa_requests.first_noa_id%type,

56: );
57:
58: Procedure get_par_ap_apue_fields(
59: p_pa_req_in in ghr_pa_requests%rowtype,
60: p_first_noa_id in ghr_pa_requests.first_noa_id%type,
61: p_second_noa_id in ghr_pa_requests.second_noa_id%type,
62: p_pa_req_out out nocopy ghr_pa_requests%rowtype);
63:
64: Procedure derive_to_columns(p_sf52_data in out nocopy ghr_pa_requests%rowtype);

Line 61: p_second_noa_id in ghr_pa_requests.second_noa_id%type,

57:
58: Procedure get_par_ap_apue_fields(
59: p_pa_req_in in ghr_pa_requests%rowtype,
60: p_first_noa_id in ghr_pa_requests.first_noa_id%type,
61: p_second_noa_id in ghr_pa_requests.second_noa_id%type,
62: p_pa_req_out out nocopy ghr_pa_requests%rowtype);
63:
64: Procedure derive_to_columns(p_sf52_data in out nocopy ghr_pa_requests%rowtype);
65: Procedure Redo_Pay_calc ( p_sf52_rec in out nocopy ghr_pa_requests%rowtype,

Line 62: p_pa_req_out out nocopy ghr_pa_requests%rowtype);

58: Procedure get_par_ap_apue_fields(
59: p_pa_req_in in ghr_pa_requests%rowtype,
60: p_first_noa_id in ghr_pa_requests.first_noa_id%type,
61: p_second_noa_id in ghr_pa_requests.second_noa_id%type,
62: p_pa_req_out out nocopy ghr_pa_requests%rowtype);
63:
64: Procedure derive_to_columns(p_sf52_data in out nocopy ghr_pa_requests%rowtype);
65: Procedure Redo_Pay_calc ( p_sf52_rec in out nocopy ghr_pa_requests%rowtype,
66: p_capped_other_pay in out nocopy number );

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

60: p_first_noa_id in ghr_pa_requests.first_noa_id%type,
61: p_second_noa_id in ghr_pa_requests.second_noa_id%type,
62: p_pa_req_out out nocopy ghr_pa_requests%rowtype);
63:
64: Procedure derive_to_columns(p_sf52_data in out nocopy ghr_pa_requests%rowtype);
65: Procedure Redo_Pay_calc ( p_sf52_rec in out nocopy ghr_pa_requests%rowtype,
66: p_capped_other_pay in out nocopy number );
67:
68: Procedure refresh_req_shadow (

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

61: p_second_noa_id in ghr_pa_requests.second_noa_id%type,
62: p_pa_req_out out nocopy ghr_pa_requests%rowtype);
63:
64: Procedure derive_to_columns(p_sf52_data in out nocopy ghr_pa_requests%rowtype);
65: Procedure Redo_Pay_calc ( p_sf52_rec in out nocopy ghr_pa_requests%rowtype,
66: p_capped_other_pay in out nocopy number );
67:
68: Procedure refresh_req_shadow (
69: p_sf52_data in out nocopy ghr_pa_requests%rowtype,

Line 69: p_sf52_data in out nocopy ghr_pa_requests%rowtype,

65: Procedure Redo_Pay_calc ( p_sf52_rec in out nocopy ghr_pa_requests%rowtype,
66: p_capped_other_pay in out nocopy number );
67:
68: Procedure refresh_req_shadow (
69: p_sf52_data in out nocopy ghr_pa_requests%rowtype,
70: p_shadow_data out nocopy ghr_pa_request_shadow%rowtype,
71: p_process_type in varchar2 default 'CURRENT');
72:
73: Procedure create_shadow_row ( p_sf52_data in ghr_pa_requests%rowtype);

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

69: p_sf52_data in out nocopy ghr_pa_requests%rowtype,
70: p_shadow_data out nocopy ghr_pa_request_shadow%rowtype,
71: p_process_type in varchar2 default 'CURRENT');
72:
73: Procedure create_shadow_row ( p_sf52_data in ghr_pa_requests%rowtype);
74: Procedure create_shadow_row ( p_shadow_data in ghr_pa_request_shadow%rowtype);
75: Procedure Update_rfrs_values( p_sf52_data in out nocopy ghr_pa_requests%rowtype,
76: p_shadow_data in ghr_pa_request_shadow%rowtype);
77: procedure print_sf52(p_proc VARCHAR2, p_pa_request_rec GHR_PA_REQUESTS%ROWTYPE);

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

71: p_process_type in varchar2 default 'CURRENT');
72:
73: Procedure create_shadow_row ( p_sf52_data in ghr_pa_requests%rowtype);
74: Procedure create_shadow_row ( p_shadow_data in ghr_pa_request_shadow%rowtype);
75: Procedure Update_rfrs_values( p_sf52_data in out nocopy ghr_pa_requests%rowtype,
76: p_shadow_data in ghr_pa_request_shadow%rowtype);
77: procedure print_sf52(p_proc VARCHAR2, p_pa_request_rec GHR_PA_REQUESTS%ROWTYPE);
78:
79:

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

73: Procedure create_shadow_row ( p_sf52_data in ghr_pa_requests%rowtype);
74: Procedure create_shadow_row ( p_shadow_data in ghr_pa_request_shadow%rowtype);
75: Procedure Update_rfrs_values( p_sf52_data in out nocopy ghr_pa_requests%rowtype,
76: p_shadow_data in ghr_pa_request_shadow%rowtype);
77: procedure print_sf52(p_proc VARCHAR2, p_pa_request_rec GHR_PA_REQUESTS%ROWTYPE);
78:
79:
80: End;