84: ,p_mass_salary_id IN NUMBER
85: ,p_mass_salary_name IN VARCHAR2
86: ,p_full_name IN per_people_f.full_name%TYPE
87: ,p_national_identifier IN per_people_f.national_identifier%TYPE
88: ,p_assignment_id IN per_assignments_f.assignment_id%TYPE
89: ,p_person_id IN per_assignments_f.person_id%TYPE
90: ,p_position_id IN per_assignments_f.position_id%TYPE
91: ,p_grade_id IN per_assignments_f.grade_id%TYPE
92: ,p_business_group_id IN per_assignments_f.business_group_iD%TYPE
85: ,p_mass_salary_name IN VARCHAR2
86: ,p_full_name IN per_people_f.full_name%TYPE
87: ,p_national_identifier IN per_people_f.national_identifier%TYPE
88: ,p_assignment_id IN per_assignments_f.assignment_id%TYPE
89: ,p_person_id IN per_assignments_f.person_id%TYPE
90: ,p_position_id IN per_assignments_f.position_id%TYPE
91: ,p_grade_id IN per_assignments_f.grade_id%TYPE
92: ,p_business_group_id IN per_assignments_f.business_group_iD%TYPE
93: ,p_location_id IN per_assignments_f.location_id%TYPE
86: ,p_full_name IN per_people_f.full_name%TYPE
87: ,p_national_identifier IN per_people_f.national_identifier%TYPE
88: ,p_assignment_id IN per_assignments_f.assignment_id%TYPE
89: ,p_person_id IN per_assignments_f.person_id%TYPE
90: ,p_position_id IN per_assignments_f.position_id%TYPE
91: ,p_grade_id IN per_assignments_f.grade_id%TYPE
92: ,p_business_group_id IN per_assignments_f.business_group_iD%TYPE
93: ,p_location_id IN per_assignments_f.location_id%TYPE
94: ,p_organization_id IN per_assignments_f.organization_id%TYPE
87: ,p_national_identifier IN per_people_f.national_identifier%TYPE
88: ,p_assignment_id IN per_assignments_f.assignment_id%TYPE
89: ,p_person_id IN per_assignments_f.person_id%TYPE
90: ,p_position_id IN per_assignments_f.position_id%TYPE
91: ,p_grade_id IN per_assignments_f.grade_id%TYPE
92: ,p_business_group_id IN per_assignments_f.business_group_iD%TYPE
93: ,p_location_id IN per_assignments_f.location_id%TYPE
94: ,p_organization_id IN per_assignments_f.organization_id%TYPE
95: ,p_msl_organization_id IN per_assignments_f.organization_id%TYPE
88: ,p_assignment_id IN per_assignments_f.assignment_id%TYPE
89: ,p_person_id IN per_assignments_f.person_id%TYPE
90: ,p_position_id IN per_assignments_f.position_id%TYPE
91: ,p_grade_id IN per_assignments_f.grade_id%TYPE
92: ,p_business_group_id IN per_assignments_f.business_group_iD%TYPE
93: ,p_location_id IN per_assignments_f.location_id%TYPE
94: ,p_organization_id IN per_assignments_f.organization_id%TYPE
95: ,p_msl_organization_id IN per_assignments_f.organization_id%TYPE
96: ,p_msl_duty_station_id IN ghr_duty_stations_f.duty_station_id%TYPE
89: ,p_person_id IN per_assignments_f.person_id%TYPE
90: ,p_position_id IN per_assignments_f.position_id%TYPE
91: ,p_grade_id IN per_assignments_f.grade_id%TYPE
92: ,p_business_group_id IN per_assignments_f.business_group_iD%TYPE
93: ,p_location_id IN per_assignments_f.location_id%TYPE
94: ,p_organization_id IN per_assignments_f.organization_id%TYPE
95: ,p_msl_organization_id IN per_assignments_f.organization_id%TYPE
96: ,p_msl_duty_station_id IN ghr_duty_stations_f.duty_station_id%TYPE
97: ,p_msl_personnel_office_id IN VARCHAR2
90: ,p_position_id IN per_assignments_f.position_id%TYPE
91: ,p_grade_id IN per_assignments_f.grade_id%TYPE
92: ,p_business_group_id IN per_assignments_f.business_group_iD%TYPE
93: ,p_location_id IN per_assignments_f.location_id%TYPE
94: ,p_organization_id IN per_assignments_f.organization_id%TYPE
95: ,p_msl_organization_id IN per_assignments_f.organization_id%TYPE
96: ,p_msl_duty_station_id IN ghr_duty_stations_f.duty_station_id%TYPE
97: ,p_msl_personnel_office_id IN VARCHAR2
98: ,p_msl_agency_code_subelement IN VARCHAR2
91: ,p_grade_id IN per_assignments_f.grade_id%TYPE
92: ,p_business_group_id IN per_assignments_f.business_group_iD%TYPE
93: ,p_location_id IN per_assignments_f.location_id%TYPE
94: ,p_organization_id IN per_assignments_f.organization_id%TYPE
95: ,p_msl_organization_id IN per_assignments_f.organization_id%TYPE
96: ,p_msl_duty_station_id IN ghr_duty_stations_f.duty_station_id%TYPE
97: ,p_msl_personnel_office_id IN VARCHAR2
98: ,p_msl_agency_code_subelement IN VARCHAR2
99: ,p_msl_user_table_id IN NUMBER
109: ,p_annuitant_indicator OUT NOCOPY VARCHAR2
110: ,p_pay_rate_determinant OUT NOCOPY VARCHAR2
111: ,p_work_schedule OUT NOCOPY VARCHAR2
112: ,p_part_time_hour OUT NOCOPY VARCHAR2
113: ,p_to_grade_id OUT NOCOPY per_assignments_f.grade_id%type
114: ,p_pay_plan OUT NOCOPY VARCHAR2
115: ,p_to_pay_plan OUT NOCOPY VARCHAR2
116: ,p_pay_table_id OUT NOCOPY NUMBER
117: ,p_grade_or_level OUT NOCOPY VARCHAR2
128: ,p_mass_salary_id IN NUMBER
129: ,p_mass_salary_name IN VARCHAR2
130: ,p_full_name IN per_people_f.full_name%TYPE
131: ,p_national_identifier IN per_people_f.national_identifier%TYPE
132: ,p_assignment_id IN per_assignments_f.assignment_id%TYPE
133: ,p_person_id IN per_assignments_f.person_id%TYPE
134: ,p_position_id IN per_assignments_f.position_id%TYPE
135: ,p_grade_id IN per_assignments_f.grade_id%TYPE
136: ,p_business_group_id IN per_assignments_f.business_group_iD%TYPE
129: ,p_mass_salary_name IN VARCHAR2
130: ,p_full_name IN per_people_f.full_name%TYPE
131: ,p_national_identifier IN per_people_f.national_identifier%TYPE
132: ,p_assignment_id IN per_assignments_f.assignment_id%TYPE
133: ,p_person_id IN per_assignments_f.person_id%TYPE
134: ,p_position_id IN per_assignments_f.position_id%TYPE
135: ,p_grade_id IN per_assignments_f.grade_id%TYPE
136: ,p_business_group_id IN per_assignments_f.business_group_iD%TYPE
137: ,p_location_id IN per_assignments_f.location_id%TYPE
130: ,p_full_name IN per_people_f.full_name%TYPE
131: ,p_national_identifier IN per_people_f.national_identifier%TYPE
132: ,p_assignment_id IN per_assignments_f.assignment_id%TYPE
133: ,p_person_id IN per_assignments_f.person_id%TYPE
134: ,p_position_id IN per_assignments_f.position_id%TYPE
135: ,p_grade_id IN per_assignments_f.grade_id%TYPE
136: ,p_business_group_id IN per_assignments_f.business_group_iD%TYPE
137: ,p_location_id IN per_assignments_f.location_id%TYPE
138: ,p_organization_id IN per_assignments_f.organization_id%TYPE
131: ,p_national_identifier IN per_people_f.national_identifier%TYPE
132: ,p_assignment_id IN per_assignments_f.assignment_id%TYPE
133: ,p_person_id IN per_assignments_f.person_id%TYPE
134: ,p_position_id IN per_assignments_f.position_id%TYPE
135: ,p_grade_id IN per_assignments_f.grade_id%TYPE
136: ,p_business_group_id IN per_assignments_f.business_group_iD%TYPE
137: ,p_location_id IN per_assignments_f.location_id%TYPE
138: ,p_organization_id IN per_assignments_f.organization_id%TYPE
139: ,p_msl_organization_id IN per_assignments_f.organization_id%TYPE
132: ,p_assignment_id IN per_assignments_f.assignment_id%TYPE
133: ,p_person_id IN per_assignments_f.person_id%TYPE
134: ,p_position_id IN per_assignments_f.position_id%TYPE
135: ,p_grade_id IN per_assignments_f.grade_id%TYPE
136: ,p_business_group_id IN per_assignments_f.business_group_iD%TYPE
137: ,p_location_id IN per_assignments_f.location_id%TYPE
138: ,p_organization_id IN per_assignments_f.organization_id%TYPE
139: ,p_msl_organization_id IN per_assignments_f.organization_id%TYPE
140: ,p_msl_duty_station_id IN ghr_duty_stations_f.duty_station_id%TYPE
133: ,p_person_id IN per_assignments_f.person_id%TYPE
134: ,p_position_id IN per_assignments_f.position_id%TYPE
135: ,p_grade_id IN per_assignments_f.grade_id%TYPE
136: ,p_business_group_id IN per_assignments_f.business_group_iD%TYPE
137: ,p_location_id IN per_assignments_f.location_id%TYPE
138: ,p_organization_id IN per_assignments_f.organization_id%TYPE
139: ,p_msl_organization_id IN per_assignments_f.organization_id%TYPE
140: ,p_msl_duty_station_id IN ghr_duty_stations_f.duty_station_id%TYPE
141: ,p_msl_personnel_office_id IN VARCHAR2
134: ,p_position_id IN per_assignments_f.position_id%TYPE
135: ,p_grade_id IN per_assignments_f.grade_id%TYPE
136: ,p_business_group_id IN per_assignments_f.business_group_iD%TYPE
137: ,p_location_id IN per_assignments_f.location_id%TYPE
138: ,p_organization_id IN per_assignments_f.organization_id%TYPE
139: ,p_msl_organization_id IN per_assignments_f.organization_id%TYPE
140: ,p_msl_duty_station_id IN ghr_duty_stations_f.duty_station_id%TYPE
141: ,p_msl_personnel_office_id IN VARCHAR2
142: ,p_msl_agency_code_subelement IN VARCHAR2
135: ,p_grade_id IN per_assignments_f.grade_id%TYPE
136: ,p_business_group_id IN per_assignments_f.business_group_iD%TYPE
137: ,p_location_id IN per_assignments_f.location_id%TYPE
138: ,p_organization_id IN per_assignments_f.organization_id%TYPE
139: ,p_msl_organization_id IN per_assignments_f.organization_id%TYPE
140: ,p_msl_duty_station_id IN ghr_duty_stations_f.duty_station_id%TYPE
141: ,p_msl_personnel_office_id IN VARCHAR2
142: ,p_msl_agency_code_subelement IN VARCHAR2
143: ,p_msl_user_table_id IN NUMBER
219: p_supervisory_diff_perc out nocopy number,
220: p_staffing_differential out nocopy number);
221:
222: procedure get_sub_element_code_pos_title
223: (p_position_id in per_assignments_f.position_id%type,
224: p_person_id in number,
225: p_business_group_id in per_assignments_f.business_group_id%type,
226: p_assignment_id in per_assignments_f.assignment_id%type,
227: p_effective_date in date,
221:
222: procedure get_sub_element_code_pos_title
223: (p_position_id in per_assignments_f.position_id%type,
224: p_person_id in number,
225: p_business_group_id in per_assignments_f.business_group_id%type,
226: p_assignment_id in per_assignments_f.assignment_id%type,
227: p_effective_date in date,
228: p_sub_element_code out nocopy varchar2,
229: p_position_title out nocopy varchar2,
222: procedure get_sub_element_code_pos_title
223: (p_position_id in per_assignments_f.position_id%type,
224: p_person_id in number,
225: p_business_group_id in per_assignments_f.business_group_id%type,
226: p_assignment_id in per_assignments_f.assignment_id%type,
227: p_effective_date in date,
228: p_sub_element_code out nocopy varchar2,
229: p_position_title out nocopy varchar2,
230: p_position_number out nocopy varchar2,
258: procedure purge_old_data (p_mass_salary_id in number);
259:
260: PROCEDURE get_pay_plan_and_table_id (p_prd in varchar2,
261: p_person_id in number,
262: p_position_id in per_assignments_f.position_id%type,
263: p_effective_date in date,
264: p_grade_id in per_assignments_f.grade_id%type,
265: p_assignment_id in per_assignments_f.assignment_id%type,
266: p_action in varchar2,
260: PROCEDURE get_pay_plan_and_table_id (p_prd in varchar2,
261: p_person_id in number,
262: p_position_id in per_assignments_f.position_id%type,
263: p_effective_date in date,
264: p_grade_id in per_assignments_f.grade_id%type,
265: p_assignment_id in per_assignments_f.assignment_id%type,
266: p_action in varchar2,
267: p_pay_plan out nocopy varchar2,
268: p_pay_table_id out nocopy number,
261: p_person_id in number,
262: p_position_id in per_assignments_f.position_id%type,
263: p_effective_date in date,
264: p_grade_id in per_assignments_f.grade_id%type,
265: p_assignment_id in per_assignments_f.assignment_id%type,
266: p_action in varchar2,
267: p_pay_plan out nocopy varchar2,
268: p_pay_table_id out nocopy number,
269: p_grade_or_level out nocopy varchar2,
272:
273: --Bug#5089732 Created new overloaded procedure get_pay_plan_and_table_id
274: PROCEDURE get_pay_plan_and_table_id (p_prd in varchar2,
275: p_person_id in number,
276: p_position_id in per_assignments_f.position_id%type,
277: p_effective_date in date,
278: p_grade_id in per_assignments_f.grade_id%type,
279: p_to_grade_id out nocopy per_assignments_f.grade_id%type,
280: p_assignment_id in per_assignments_f.assignment_id%type,
274: PROCEDURE get_pay_plan_and_table_id (p_prd in varchar2,
275: p_person_id in number,
276: p_position_id in per_assignments_f.position_id%type,
277: p_effective_date in date,
278: p_grade_id in per_assignments_f.grade_id%type,
279: p_to_grade_id out nocopy per_assignments_f.grade_id%type,
280: p_assignment_id in per_assignments_f.assignment_id%type,
281: p_action in varchar2,
282: p_pay_plan out nocopy varchar2,
275: p_person_id in number,
276: p_position_id in per_assignments_f.position_id%type,
277: p_effective_date in date,
278: p_grade_id in per_assignments_f.grade_id%type,
279: p_to_grade_id out nocopy per_assignments_f.grade_id%type,
280: p_assignment_id in per_assignments_f.assignment_id%type,
281: p_action in varchar2,
282: p_pay_plan out nocopy varchar2,
283: p_to_pay_plan out nocopy varchar2,
276: p_position_id in per_assignments_f.position_id%type,
277: p_effective_date in date,
278: p_grade_id in per_assignments_f.grade_id%type,
279: p_to_grade_id out nocopy per_assignments_f.grade_id%type,
280: p_assignment_id in per_assignments_f.assignment_id%type,
281: p_action in varchar2,
282: p_pay_plan out nocopy varchar2,
283: p_to_pay_plan out nocopy varchar2,
284: p_pay_table_id out nocopy number,
292: FUNCTION check_grade_retention(p_prd in varchar2
293: ,p_person_id in number
294: ,p_effective_date in date) return varchar2;
295:
296: procedure get_pos_grp1_ddf (p_position_id in per_assignments_f.position_id%type,
297: p_effective_date in date,
298: p_pos_ei_data out nocopy per_position_extra_info%rowtype);
299:
300: procedure create_mass_act_prev (
318: p_tot_old_sal in number,
319: p_tot_new_sal in number,
320: p_old_auo_pay in number,
321: p_new_auo_pay in number,
322: p_position_id in per_assignments_f.position_id%type,
323: p_position_title in varchar2,
324: -- FWFA Changes Bug#4444609
325: p_position_number in varchar2,
326: p_position_seq_no in varchar2,
435: ,p_mass_salary_id IN NUMBER
436: ,p_mass_salary_name IN VARCHAR2
437: ,p_full_name IN per_people_f.full_name%TYPE
438: ,p_national_identifier IN per_people_f.national_identifier%TYPE
439: ,p_assignment_id IN per_assignments_f.assignment_id%TYPE
440: ,p_person_id IN per_assignments_f.person_id%TYPE
441: ,p_position_id IN per_assignments_f.position_id%TYPE
442: ,p_grade_id IN per_assignments_f.grade_id%TYPE
443: ,p_business_group_id IN per_assignments_f.business_group_iD%TYPE
436: ,p_mass_salary_name IN VARCHAR2
437: ,p_full_name IN per_people_f.full_name%TYPE
438: ,p_national_identifier IN per_people_f.national_identifier%TYPE
439: ,p_assignment_id IN per_assignments_f.assignment_id%TYPE
440: ,p_person_id IN per_assignments_f.person_id%TYPE
441: ,p_position_id IN per_assignments_f.position_id%TYPE
442: ,p_grade_id IN per_assignments_f.grade_id%TYPE
443: ,p_business_group_id IN per_assignments_f.business_group_iD%TYPE
444: ,p_location_id IN per_assignments_f.location_id%TYPE
437: ,p_full_name IN per_people_f.full_name%TYPE
438: ,p_national_identifier IN per_people_f.national_identifier%TYPE
439: ,p_assignment_id IN per_assignments_f.assignment_id%TYPE
440: ,p_person_id IN per_assignments_f.person_id%TYPE
441: ,p_position_id IN per_assignments_f.position_id%TYPE
442: ,p_grade_id IN per_assignments_f.grade_id%TYPE
443: ,p_business_group_id IN per_assignments_f.business_group_iD%TYPE
444: ,p_location_id IN per_assignments_f.location_id%TYPE
445: ,p_organization_id IN per_assignments_f.organization_id%TYPE
438: ,p_national_identifier IN per_people_f.national_identifier%TYPE
439: ,p_assignment_id IN per_assignments_f.assignment_id%TYPE
440: ,p_person_id IN per_assignments_f.person_id%TYPE
441: ,p_position_id IN per_assignments_f.position_id%TYPE
442: ,p_grade_id IN per_assignments_f.grade_id%TYPE
443: ,p_business_group_id IN per_assignments_f.business_group_iD%TYPE
444: ,p_location_id IN per_assignments_f.location_id%TYPE
445: ,p_organization_id IN per_assignments_f.organization_id%TYPE
446: ,p_msl_organization_id IN per_assignments_f.organization_id%TYPE
439: ,p_assignment_id IN per_assignments_f.assignment_id%TYPE
440: ,p_person_id IN per_assignments_f.person_id%TYPE
441: ,p_position_id IN per_assignments_f.position_id%TYPE
442: ,p_grade_id IN per_assignments_f.grade_id%TYPE
443: ,p_business_group_id IN per_assignments_f.business_group_iD%TYPE
444: ,p_location_id IN per_assignments_f.location_id%TYPE
445: ,p_organization_id IN per_assignments_f.organization_id%TYPE
446: ,p_msl_organization_id IN per_assignments_f.organization_id%TYPE
447: ,p_msl_duty_station_id IN ghr_duty_stations_f.duty_station_id%TYPE
440: ,p_person_id IN per_assignments_f.person_id%TYPE
441: ,p_position_id IN per_assignments_f.position_id%TYPE
442: ,p_grade_id IN per_assignments_f.grade_id%TYPE
443: ,p_business_group_id IN per_assignments_f.business_group_iD%TYPE
444: ,p_location_id IN per_assignments_f.location_id%TYPE
445: ,p_organization_id IN per_assignments_f.organization_id%TYPE
446: ,p_msl_organization_id IN per_assignments_f.organization_id%TYPE
447: ,p_msl_duty_station_id IN ghr_duty_stations_f.duty_station_id%TYPE
448: ,p_msl_personnel_office_id IN VARCHAR2
441: ,p_position_id IN per_assignments_f.position_id%TYPE
442: ,p_grade_id IN per_assignments_f.grade_id%TYPE
443: ,p_business_group_id IN per_assignments_f.business_group_iD%TYPE
444: ,p_location_id IN per_assignments_f.location_id%TYPE
445: ,p_organization_id IN per_assignments_f.organization_id%TYPE
446: ,p_msl_organization_id IN per_assignments_f.organization_id%TYPE
447: ,p_msl_duty_station_id IN ghr_duty_stations_f.duty_station_id%TYPE
448: ,p_msl_personnel_office_id IN VARCHAR2
449: ,p_msl_agency_code_subelement IN VARCHAR2
442: ,p_grade_id IN per_assignments_f.grade_id%TYPE
443: ,p_business_group_id IN per_assignments_f.business_group_iD%TYPE
444: ,p_location_id IN per_assignments_f.location_id%TYPE
445: ,p_organization_id IN per_assignments_f.organization_id%TYPE
446: ,p_msl_organization_id IN per_assignments_f.organization_id%TYPE
447: ,p_msl_duty_station_id IN ghr_duty_stations_f.duty_station_id%TYPE
448: ,p_msl_personnel_office_id IN VARCHAR2
449: ,p_msl_agency_code_subelement IN VARCHAR2
450: ,p_msl_user_table_id IN NUMBER
460: ,p_annuitant_indicator OUT NOCOPY VARCHAR2
461: ,p_pay_rate_determinant OUT NOCOPY VARCHAR2
462: ,p_work_schedule OUT NOCOPY VARCHAR2
463: ,p_part_time_hour OUT NOCOPY VARCHAR2
464: ,p_to_grade_id OUT NOCOPY per_assignments_f.grade_id%type
465: ,p_pay_plan OUT NOCOPY VARCHAR2
466: ,p_to_pay_plan OUT NOCOPY VARCHAR2
467: ,p_pay_table_id OUT NOCOPY NUMBER
468: ,p_grade_or_level OUT NOCOPY VARCHAR2