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

Line 98: p_sf52_rec in out nocopy ghr_pa_requests%rowtype

94:
95:
96: procedure emp_rec_to_sf52_rec
97: (p_emp_rec in ghr_mass_actions_pkg.emp_rec_type,
98: p_sf52_rec in out nocopy ghr_pa_requests%rowtype
99: )
100: is
101: l_proc varchar2(72) := g_package || 'emp_rec_to_sf52_rec';
102: l_sf52_rec ghr_pa_requests%rowtype;

Line 102: l_sf52_rec ghr_pa_requests%rowtype;

98: p_sf52_rec in out nocopy ghr_pa_requests%rowtype
99: )
100: is
101: l_proc varchar2(72) := g_package || 'emp_rec_to_sf52_rec';
102: l_sf52_rec ghr_pa_requests%rowtype;
103:
104: begin
105: -- Nocopy Changes
106: l_sf52_rec := p_sf52_rec;

Line 127: p_sf52_rec in out nocopy ghr_pa_requests%rowtype

123:
124:
125: procedure asg_sf52_rec_to_sf52_rec
126: (p_asg_sf52_rec in ghr_api.asg_sf52_type,
127: p_sf52_rec in out nocopy ghr_pa_requests%rowtype
128: )
129: is
130:
131: l_proc varchar2(72) := g_package || 'asg_sf52_rec_to_sf52_rec';

Line 132: l_sf52_rec ghr_pa_requests%rowtype;

128: )
129: is
130:
131: l_proc varchar2(72) := g_package || 'asg_sf52_rec_to_sf52_rec';
132: l_sf52_rec ghr_pa_requests%rowtype;
133: begin
134: -- Nocopy Changes
135: l_sf52_rec := p_sf52_rec;
136: --

Line 159: p_sf52_rec in out nocopy ghr_pa_requests%rowtype

155:
156:
157: procedure pos_grp1_rec_to_sf52_rec
158: (p_pos_grp1_rec in ghr_api.pos_grp1_type,
159: p_sf52_rec in out nocopy ghr_pa_requests%rowtype
160: )
161: is
162:
163: l_proc varchar2(72) := g_package || 'pos_grp1_rec_to_sf52_rec';

Line 164: l_sf52_rec ghr_pa_requests%rowtype;

160: )
161: is
162:
163: l_proc varchar2(72) := g_package || 'pos_grp1_rec_to_sf52_rec';
164: l_sf52_rec ghr_pa_requests%rowtype;
165:
166: begin
167: -- Nocopy Changes
168: l_sf52_rec := p_sf52_rec;

Line 187: p_sf52_rec in out nocopy ghr_pa_requests%rowtype

183: end pos_grp1_rec_to_sf52_rec;
184:
185: procedure pay_calc_rec_to_sf52_rec
186: (p_pay_calc_rec in ghr_pay_calc.pay_calc_out_rec_type,
187: p_sf52_rec in out nocopy ghr_pa_requests%rowtype
188: )
189: is
190:
191: l_proc varchar2(72) := g_package || 'pos_grp1_rec_to_sf52_rec';

Line 192: l_sf52_rec ghr_pa_requests%rowtype;

188: )
189: is
190:
191: l_proc varchar2(72) := g_package || 'pos_grp1_rec_to_sf52_rec';
192: l_sf52_rec ghr_pa_requests%rowtype;
193:
194: begin
195: -- Nocopy Changes
196: l_sf52_rec := p_sf52_rec;

Line 227: p_sf52_rec in out nocopy ghr_pa_requests%rowtype

223: end pay_calc_rec_to_sf52_rec;
224:
225: procedure duty_station_rec_to_sf52_rec
226: (p_duty_station_rec in ghr_mass_actions_pkg.duty_station_rec_type,
227: p_sf52_rec in out nocopy ghr_pa_requests%rowtype
228: )
229: is
230: l_proc varchar2(72) := g_package || 'duty_station_rec_to_sf52_rec';
231: l_sf52_rec ghr_pa_requests%rowtype;

Line 231: l_sf52_rec ghr_pa_requests%rowtype;

227: p_sf52_rec in out nocopy ghr_pa_requests%rowtype
228: )
229: is
230: l_proc varchar2(72) := g_package || 'duty_station_rec_to_sf52_rec';
231: l_sf52_rec ghr_pa_requests%rowtype;
232:
233: begin
234: -- Nocopy Changes
235: l_sf52_rec := p_sf52_rec;

Line 321: (p_position_id in ghr_pa_requests.from_position_id%type,

317: end replace_insertion_values;
318:
319:
320: Procedure get_personnel_off_groupbox
321: (p_position_id in ghr_pa_requests.from_position_id%type,
322: p_effective_date in date default trunc(sysdate),
323: p_groupbox_id out nocopy ghr_groupboxes.groupbox_id%type,
324: p_routing_group_id out nocopy ghr_routing_groups.routing_group_id%type
325: )

Line 332: l_personnel_office_id ghr_pa_requests.personnel_office_id%type;

328: l_proc varchar2(72) := g_package || 'get_personnel_off_groupbox';
329: l_pos_ei_data per_position_extra_info%rowtype;
330: l_groupbox_id ghr_groupboxes.groupbox_id%type;
331: l_routing_group_id ghr_routing_groups.routing_group_id%type;
332: l_personnel_office_id ghr_pa_requests.personnel_office_id%type;
333: l_log_text varchar2(2000);
334: l_count number;
335:
336: Cursor c_gbx is

Line 405: (p_personnel_office_id in ghr_pa_requests.personnel_office_id%TYPE,

401: RAISE;
402: end get_personnel_off_groupbox;
403:
404: Procedure get_personnel_officer_name
405: (p_personnel_office_id in ghr_pa_requests.personnel_office_id%TYPE,
406: p_person_full_name out nocopy varchar2,
407: p_approving_off_work_title out nocopy varchar2)
408: IS
409:

Line 427: ghr_pa_requests_pkg.get_position_work_title

423:
424: END LOOP;
425:
426: p_approving_off_work_title :=
427: ghr_pa_requests_pkg.get_position_work_title
428: (p_person_id => l_person_id);
429:
430: p_person_full_name := ghr_pa_requests_pkg.get_full_name_fml
431: (l_person_id);

Line 430: p_person_full_name := ghr_pa_requests_pkg.get_full_name_fml

426: p_approving_off_work_title :=
427: ghr_pa_requests_pkg.get_position_work_title
428: (p_person_id => l_person_id);
429:
430: p_person_full_name := ghr_pa_requests_pkg.get_full_name_fml
431: (l_person_id);
432: EXCEPTION
433: WHEN OTHERS THEN
434: p_person_full_name := NULL;