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_WGI_PKG dependencies on GHR_PA_REQUESTS

Line 9: ghr_pa_requests.personnel_office_id%TYPE default null,

5: (
6: errbuf out nocopy varchar2,
7: retcode out nocopy number,
8: p_personnel_office_id in
9: ghr_pa_requests.personnel_office_id%TYPE default null,
10: p_pay_plan in
11: ghr_pay_plans.pay_plan%TYPE default null
12: );
13: --

Line 22: ghr_pa_requests.personnel_office_id%TYPE default null,

18: p_log_flag in char default 'N',
19: p_errbuf OUT nocopy varchar2,
20: p_retcode OUT nocopy number,
21: p_personnel_office_id in
22: ghr_pa_requests.personnel_office_id%TYPE default null,
23: p_pay_plan in ghr_pay_plans.pay_plan%TYPE
24: default null
25: );
26: --

Line 50: (p_pay_rate_determinant in ghr_pa_requests.pay_rate_determinant%TYPE

46: --
47: -- Check assignment id
48: --
49: function check_assignment_prd
50: (p_pay_rate_determinant in ghr_pa_requests.pay_rate_determinant%TYPE
51: ) return boolean;
52: ----
53: -- Verify person in PA requests
54: --

Line 55: function person_in_pa_requests(p_person_id in ghr_pa_requests.person_id%TYPE,

51: ) return boolean;
52: ----
53: -- Verify person in PA requests
54: --
55: function person_in_pa_requests(p_person_id in ghr_pa_requests.person_id%TYPE,
56: p_effective_date in ghr_pa_requests.effective_date%TYPE,
57: p_first_noa_code in ghr_pa_requests.first_noa_code%TYPE,
58: p_days in number )
59: return boolean;

Line 56: p_effective_date in ghr_pa_requests.effective_date%TYPE,

52: ----
53: -- Verify person in PA requests
54: --
55: function person_in_pa_requests(p_person_id in ghr_pa_requests.person_id%TYPE,
56: p_effective_date in ghr_pa_requests.effective_date%TYPE,
57: p_first_noa_code in ghr_pa_requests.first_noa_code%TYPE,
58: p_days in number )
59: return boolean;
60: --

Line 57: p_first_noa_code in ghr_pa_requests.first_noa_code%TYPE,

53: -- Verify person in PA requests
54: --
55: function person_in_pa_requests(p_person_id in ghr_pa_requests.person_id%TYPE,
56: p_effective_date in ghr_pa_requests.effective_date%TYPE,
57: p_first_noa_code in ghr_pa_requests.first_noa_code%TYPE,
58: p_days in number )
59: return boolean;
60: --
61: function check_pay_plan( p_pay_plan in VARCHAR2)

Line 70: ,effective_date ghr_pa_requests.effective_date%type

66: TYPE wgi_in_rec_type IS RECORD
67: ( person_id per_people_f.person_id%type
68: ,assignment_id per_assignments.assignment_id%type
69: ,position_id per_assignments.position_id%type
70: ,effective_date ghr_pa_requests.effective_date%type
71: );
72: --
73: -- This record structure will keep all the out parameters that are passed from the
74: -- WGI Custom Hook

Line 83: p_first_noa_code in ghr_pa_requests.first_noa_code%TYPE,

79: --
80: --
81: procedure derive_legal_auth_cd_remarks
82: (
83: p_first_noa_code in ghr_pa_requests.first_noa_code%TYPE,
84: p_pay_rate_determinant in ghr_pa_requests.pay_rate_determinant%TYPE,
85: p_from_pay_plan in ghr_pa_requests.from_pay_plan%TYPE,
86: p_grade_or_level in ghr_pa_requests.from_grade_or_level%TYPE,
87: p_step_or_rate in ghr_pa_requests.from_step_or_rate%TYPE,

Line 84: p_pay_rate_determinant in ghr_pa_requests.pay_rate_determinant%TYPE,

80: --
81: procedure derive_legal_auth_cd_remarks
82: (
83: p_first_noa_code in ghr_pa_requests.first_noa_code%TYPE,
84: p_pay_rate_determinant in ghr_pa_requests.pay_rate_determinant%TYPE,
85: p_from_pay_plan in ghr_pa_requests.from_pay_plan%TYPE,
86: p_grade_or_level in ghr_pa_requests.from_grade_or_level%TYPE,
87: p_step_or_rate in ghr_pa_requests.from_step_or_rate%TYPE,
88: p_retained_pay_plan in ghr_pa_requests.from_pay_plan%TYPE default null,

Line 85: p_from_pay_plan in ghr_pa_requests.from_pay_plan%TYPE,

81: procedure derive_legal_auth_cd_remarks
82: (
83: p_first_noa_code in ghr_pa_requests.first_noa_code%TYPE,
84: p_pay_rate_determinant in ghr_pa_requests.pay_rate_determinant%TYPE,
85: p_from_pay_plan in ghr_pa_requests.from_pay_plan%TYPE,
86: p_grade_or_level in ghr_pa_requests.from_grade_or_level%TYPE,
87: p_step_or_rate in ghr_pa_requests.from_step_or_rate%TYPE,
88: p_retained_pay_plan in ghr_pa_requests.from_pay_plan%TYPE default null,
89: p_retained_grade_or_level in ghr_pa_requests.from_grade_or_level%TYPE default null,

Line 86: p_grade_or_level in ghr_pa_requests.from_grade_or_level%TYPE,

82: (
83: p_first_noa_code in ghr_pa_requests.first_noa_code%TYPE,
84: p_pay_rate_determinant in ghr_pa_requests.pay_rate_determinant%TYPE,
85: p_from_pay_plan in ghr_pa_requests.from_pay_plan%TYPE,
86: p_grade_or_level in ghr_pa_requests.from_grade_or_level%TYPE,
87: p_step_or_rate in ghr_pa_requests.from_step_or_rate%TYPE,
88: p_retained_pay_plan in ghr_pa_requests.from_pay_plan%TYPE default null,
89: p_retained_grade_or_level in ghr_pa_requests.from_grade_or_level%TYPE default null,
90: p_retained_step_or_rate in ghr_pa_requests.from_step_or_rate%TYPE default null,

Line 87: p_step_or_rate in ghr_pa_requests.from_step_or_rate%TYPE,

83: p_first_noa_code in ghr_pa_requests.first_noa_code%TYPE,
84: p_pay_rate_determinant in ghr_pa_requests.pay_rate_determinant%TYPE,
85: p_from_pay_plan in ghr_pa_requests.from_pay_plan%TYPE,
86: p_grade_or_level in ghr_pa_requests.from_grade_or_level%TYPE,
87: p_step_or_rate in ghr_pa_requests.from_step_or_rate%TYPE,
88: p_retained_pay_plan in ghr_pa_requests.from_pay_plan%TYPE default null,
89: p_retained_grade_or_level in ghr_pa_requests.from_grade_or_level%TYPE default null,
90: p_retained_step_or_rate in ghr_pa_requests.from_step_or_rate%TYPE default null,
91: -- Bug#5204589

Line 88: p_retained_pay_plan in ghr_pa_requests.from_pay_plan%TYPE default null,

84: p_pay_rate_determinant in ghr_pa_requests.pay_rate_determinant%TYPE,
85: p_from_pay_plan in ghr_pa_requests.from_pay_plan%TYPE,
86: p_grade_or_level in ghr_pa_requests.from_grade_or_level%TYPE,
87: p_step_or_rate in ghr_pa_requests.from_step_or_rate%TYPE,
88: p_retained_pay_plan in ghr_pa_requests.from_pay_plan%TYPE default null,
89: p_retained_grade_or_level in ghr_pa_requests.from_grade_or_level%TYPE default null,
90: p_retained_step_or_rate in ghr_pa_requests.from_step_or_rate%TYPE default null,
91: -- Bug#5204589
92: p_temp_step in ghr_pa_requests.from_step_or_rate%TYPE default null,

Line 89: p_retained_grade_or_level in ghr_pa_requests.from_grade_or_level%TYPE default null,

85: p_from_pay_plan in ghr_pa_requests.from_pay_plan%TYPE,
86: p_grade_or_level in ghr_pa_requests.from_grade_or_level%TYPE,
87: p_step_or_rate in ghr_pa_requests.from_step_or_rate%TYPE,
88: p_retained_pay_plan in ghr_pa_requests.from_pay_plan%TYPE default null,
89: p_retained_grade_or_level in ghr_pa_requests.from_grade_or_level%TYPE default null,
90: p_retained_step_or_rate in ghr_pa_requests.from_step_or_rate%TYPE default null,
91: -- Bug#5204589
92: p_temp_step in ghr_pa_requests.from_step_or_rate%TYPE default null,
93: p_effective_date in ghr_pa_requests.effective_date%TYPE,

Line 90: p_retained_step_or_rate in ghr_pa_requests.from_step_or_rate%TYPE default null,

86: p_grade_or_level in ghr_pa_requests.from_grade_or_level%TYPE,
87: p_step_or_rate in ghr_pa_requests.from_step_or_rate%TYPE,
88: p_retained_pay_plan in ghr_pa_requests.from_pay_plan%TYPE default null,
89: p_retained_grade_or_level in ghr_pa_requests.from_grade_or_level%TYPE default null,
90: p_retained_step_or_rate in ghr_pa_requests.from_step_or_rate%TYPE default null,
91: -- Bug#5204589
92: p_temp_step in ghr_pa_requests.from_step_or_rate%TYPE default null,
93: p_effective_date in ghr_pa_requests.effective_date%TYPE,
94: p_first_action_la_code1 in out nocopy ghr_pa_requests.first_action_la_code1%TYPE,

Line 92: p_temp_step in ghr_pa_requests.from_step_or_rate%TYPE default null,

88: p_retained_pay_plan in ghr_pa_requests.from_pay_plan%TYPE default null,
89: p_retained_grade_or_level in ghr_pa_requests.from_grade_or_level%TYPE default null,
90: p_retained_step_or_rate in ghr_pa_requests.from_step_or_rate%TYPE default null,
91: -- Bug#5204589
92: p_temp_step in ghr_pa_requests.from_step_or_rate%TYPE default null,
93: p_effective_date in ghr_pa_requests.effective_date%TYPE,
94: p_first_action_la_code1 in out nocopy ghr_pa_requests.first_action_la_code1%TYPE,
95: p_first_action_la_desc1 in out nocopy ghr_pa_requests.first_action_la_desc1%TYPE,
96: p_first_action_la_code2 in out nocopy ghr_pa_requests.first_action_la_code2%TYPE,

Line 93: p_effective_date in ghr_pa_requests.effective_date%TYPE,

89: p_retained_grade_or_level in ghr_pa_requests.from_grade_or_level%TYPE default null,
90: p_retained_step_or_rate in ghr_pa_requests.from_step_or_rate%TYPE default null,
91: -- Bug#5204589
92: p_temp_step in ghr_pa_requests.from_step_or_rate%TYPE default null,
93: p_effective_date in ghr_pa_requests.effective_date%TYPE,
94: p_first_action_la_code1 in out nocopy ghr_pa_requests.first_action_la_code1%TYPE,
95: p_first_action_la_desc1 in out nocopy ghr_pa_requests.first_action_la_desc1%TYPE,
96: p_first_action_la_code2 in out nocopy ghr_pa_requests.first_action_la_code2%TYPE,
97: p_first_action_la_desc2 in out nocopy ghr_pa_requests.first_action_la_desc2%TYPE,

Line 94: p_first_action_la_code1 in out nocopy ghr_pa_requests.first_action_la_code1%TYPE,

90: p_retained_step_or_rate in ghr_pa_requests.from_step_or_rate%TYPE default null,
91: -- Bug#5204589
92: p_temp_step in ghr_pa_requests.from_step_or_rate%TYPE default null,
93: p_effective_date in ghr_pa_requests.effective_date%TYPE,
94: p_first_action_la_code1 in out nocopy ghr_pa_requests.first_action_la_code1%TYPE,
95: p_first_action_la_desc1 in out nocopy ghr_pa_requests.first_action_la_desc1%TYPE,
96: p_first_action_la_code2 in out nocopy ghr_pa_requests.first_action_la_code2%TYPE,
97: p_first_action_la_desc2 in out nocopy ghr_pa_requests.first_action_la_desc2%TYPE,
98: p_remark_id1 out nocopy ghr_pa_remarks.remark_id%TYPE,

Line 95: p_first_action_la_desc1 in out nocopy ghr_pa_requests.first_action_la_desc1%TYPE,

91: -- Bug#5204589
92: p_temp_step in ghr_pa_requests.from_step_or_rate%TYPE default null,
93: p_effective_date in ghr_pa_requests.effective_date%TYPE,
94: p_first_action_la_code1 in out nocopy ghr_pa_requests.first_action_la_code1%TYPE,
95: p_first_action_la_desc1 in out nocopy ghr_pa_requests.first_action_la_desc1%TYPE,
96: p_first_action_la_code2 in out nocopy ghr_pa_requests.first_action_la_code2%TYPE,
97: p_first_action_la_desc2 in out nocopy ghr_pa_requests.first_action_la_desc2%TYPE,
98: p_remark_id1 out nocopy ghr_pa_remarks.remark_id%TYPE,
99: p_remark_desc1 out nocopy ghr_pa_remarks.description%type,

Line 96: p_first_action_la_code2 in out nocopy ghr_pa_requests.first_action_la_code2%TYPE,

92: p_temp_step in ghr_pa_requests.from_step_or_rate%TYPE default null,
93: p_effective_date in ghr_pa_requests.effective_date%TYPE,
94: p_first_action_la_code1 in out nocopy ghr_pa_requests.first_action_la_code1%TYPE,
95: p_first_action_la_desc1 in out nocopy ghr_pa_requests.first_action_la_desc1%TYPE,
96: p_first_action_la_code2 in out nocopy ghr_pa_requests.first_action_la_code2%TYPE,
97: p_first_action_la_desc2 in out nocopy ghr_pa_requests.first_action_la_desc2%TYPE,
98: p_remark_id1 out nocopy ghr_pa_remarks.remark_id%TYPE,
99: p_remark_desc1 out nocopy ghr_pa_remarks.description%type,
100: p_remark1_info1 out nocopy ghr_pa_remarks.remark_code_information1%TYPE,

Line 97: p_first_action_la_desc2 in out nocopy ghr_pa_requests.first_action_la_desc2%TYPE,

93: p_effective_date in ghr_pa_requests.effective_date%TYPE,
94: p_first_action_la_code1 in out nocopy ghr_pa_requests.first_action_la_code1%TYPE,
95: p_first_action_la_desc1 in out nocopy ghr_pa_requests.first_action_la_desc1%TYPE,
96: p_first_action_la_code2 in out nocopy ghr_pa_requests.first_action_la_code2%TYPE,
97: p_first_action_la_desc2 in out nocopy ghr_pa_requests.first_action_la_desc2%TYPE,
98: p_remark_id1 out nocopy ghr_pa_remarks.remark_id%TYPE,
99: p_remark_desc1 out nocopy ghr_pa_remarks.description%type,
100: p_remark1_info1 out nocopy ghr_pa_remarks.remark_code_information1%TYPE,
101: p_remark1_info2 out nocopy ghr_pa_remarks.remark_code_information2%TYPE,

Line 111: function CheckIfFWPayPlan( p_from_pay_plan in ghr_pa_requests.from_pay_plan%TYPE

107: p_remark2_info3 out nocopy ghr_pa_remarks.remark_code_information3%TYPE
108: );
109:
110: --
111: function CheckIfFWPayPlan( p_from_pay_plan in ghr_pa_requests.from_pay_plan%TYPE
112: )
113: return boolean;
114: --
115: --

Line 117: p_in_pay_plan in ghr_pa_requests.from_pay_plan%TYPE

113: return boolean;
114: --
115: --
116: function CheckPayPlanParm (
117: p_in_pay_plan in ghr_pa_requests.from_pay_plan%TYPE
118: ,p_from_pay_plan in ghr_pa_requests.from_pay_plan%TYPE
119: )
120: return boolean;
121: --

Line 118: ,p_from_pay_plan in ghr_pa_requests.from_pay_plan%TYPE

114: --
115: --
116: function CheckPayPlanParm (
117: p_in_pay_plan in ghr_pa_requests.from_pay_plan%TYPE
118: ,p_from_pay_plan in ghr_pa_requests.from_pay_plan%TYPE
119: )
120: return boolean;
121: --
122: --

Line 124: p_in_personnel_office_id in out NOCOPY ghr_pa_requests.personnel_office_id%TYPE

120: return boolean;
121: --
122: --
123: function CheckPOIParm (
124: p_in_personnel_office_id in out NOCOPY ghr_pa_requests.personnel_office_id%TYPE
125: ,p_position_id in per_assignments.position_id%TYPE
126: ,p_effective_date in ghr_pa_requests.effective_date%TYPE
127: )
128: return boolean ;

Line 126: ,p_effective_date in ghr_pa_requests.effective_date%TYPE

122: --
123: function CheckPOIParm (
124: p_in_personnel_office_id in out NOCOPY ghr_pa_requests.personnel_office_id%TYPE
125: ,p_position_id in per_assignments.position_id%TYPE
126: ,p_effective_date in ghr_pa_requests.effective_date%TYPE
127: )
128: return boolean ;
129: --
130: --

Line 131: function CheckIfMaxPayPlan( p_from_pay_plan in ghr_pa_requests.from_pay_plan%TYPE

127: )
128: return boolean ;
129: --
130: --
131: function CheckIfMaxPayPlan( p_from_pay_plan in ghr_pa_requests.from_pay_plan%TYPE
132: ,p_from_step_or_rate in ghr_pa_requests.from_step_or_rate%TYPE
133: )
134: return boolean ;
135: --

Line 132: ,p_from_step_or_rate in ghr_pa_requests.from_step_or_rate%TYPE

128: return boolean ;
129: --
130: --
131: function CheckIfMaxPayPlan( p_from_pay_plan in ghr_pa_requests.from_pay_plan%TYPE
132: ,p_from_step_or_rate in ghr_pa_requests.from_step_or_rate%TYPE
133: )
134: return boolean ;
135: --
136: --