DBA Data[Home] [Help]

APPS.GHR_MSL_PKG dependencies on PER_PEOPLE_F

Line 89: ,p_full_name IN per_people_f.full_name%TYPE

85: PROCEDURE fetch_and_validate_emp(
86: p_action IN VARCHAR2
87: ,p_mass_salary_id IN NUMBER
88: ,p_mass_salary_name IN VARCHAR2
89: ,p_full_name IN per_people_f.full_name%TYPE
90: ,p_national_identifier IN per_people_f.national_identifier%TYPE
91: --Bug # 9329643
92: ,p_employee_number IN per_people_f.employee_number%TYPE
93: ,p_assignment_id IN per_assignments_f.assignment_id%TYPE

Line 90: ,p_national_identifier IN per_people_f.national_identifier%TYPE

86: p_action IN VARCHAR2
87: ,p_mass_salary_id IN NUMBER
88: ,p_mass_salary_name IN VARCHAR2
89: ,p_full_name IN per_people_f.full_name%TYPE
90: ,p_national_identifier IN per_people_f.national_identifier%TYPE
91: --Bug # 9329643
92: ,p_employee_number IN per_people_f.employee_number%TYPE
93: ,p_assignment_id IN per_assignments_f.assignment_id%TYPE
94: ,p_person_id IN per_assignments_f.person_id%TYPE

Line 92: ,p_employee_number IN per_people_f.employee_number%TYPE

88: ,p_mass_salary_name IN VARCHAR2
89: ,p_full_name IN per_people_f.full_name%TYPE
90: ,p_national_identifier IN per_people_f.national_identifier%TYPE
91: --Bug # 9329643
92: ,p_employee_number IN per_people_f.employee_number%TYPE
93: ,p_assignment_id IN per_assignments_f.assignment_id%TYPE
94: ,p_person_id IN per_assignments_f.person_id%TYPE
95: ,p_position_id IN per_assignments_f.position_id%TYPE
96: ,p_grade_id IN per_assignments_f.grade_id%TYPE

Line 135: ,p_full_name IN per_people_f.full_name%TYPE

131: PROCEDURE fetch_and_validate_emp_perc(
132: p_action IN VARCHAR2
133: ,p_mass_salary_id IN NUMBER
134: ,p_mass_salary_name IN VARCHAR2
135: ,p_full_name IN per_people_f.full_name%TYPE
136: ,p_national_identifier IN per_people_f.national_identifier%TYPE
137: --Bug # 9329643
138: ,p_employee_number IN per_people_f.employee_number%TYPE
139: ,p_assignment_id IN per_assignments_f.assignment_id%TYPE

Line 136: ,p_national_identifier IN per_people_f.national_identifier%TYPE

132: p_action IN VARCHAR2
133: ,p_mass_salary_id IN NUMBER
134: ,p_mass_salary_name IN VARCHAR2
135: ,p_full_name IN per_people_f.full_name%TYPE
136: ,p_national_identifier IN per_people_f.national_identifier%TYPE
137: --Bug # 9329643
138: ,p_employee_number IN per_people_f.employee_number%TYPE
139: ,p_assignment_id IN per_assignments_f.assignment_id%TYPE
140: ,p_person_id IN per_assignments_f.person_id%TYPE

Line 138: ,p_employee_number IN per_people_f.employee_number%TYPE

134: ,p_mass_salary_name IN VARCHAR2
135: ,p_full_name IN per_people_f.full_name%TYPE
136: ,p_national_identifier IN per_people_f.national_identifier%TYPE
137: --Bug # 9329643
138: ,p_employee_number IN per_people_f.employee_number%TYPE
139: ,p_assignment_id IN per_assignments_f.assignment_id%TYPE
140: ,p_person_id IN per_assignments_f.person_id%TYPE
141: ,p_position_id IN per_assignments_f.position_id%TYPE
142: ,p_grade_id IN per_assignments_f.grade_id%TYPE

Line 446: ,p_full_name IN per_people_f.full_name%TYPE

442: PROCEDURE fetch_and_validate_emp_ses(
443: p_action IN VARCHAR2
444: ,p_mass_salary_id IN NUMBER
445: ,p_mass_salary_name IN VARCHAR2
446: ,p_full_name IN per_people_f.full_name%TYPE
447: ,p_national_identifier IN per_people_f.national_identifier%TYPE
448: --Bug # 9329643
449: ,p_employee_number IN per_people_f.employee_number%TYPE
450: ,p_assignment_id IN per_assignments_f.assignment_id%TYPE

Line 447: ,p_national_identifier IN per_people_f.national_identifier%TYPE

443: p_action IN VARCHAR2
444: ,p_mass_salary_id IN NUMBER
445: ,p_mass_salary_name IN VARCHAR2
446: ,p_full_name IN per_people_f.full_name%TYPE
447: ,p_national_identifier IN per_people_f.national_identifier%TYPE
448: --Bug # 9329643
449: ,p_employee_number IN per_people_f.employee_number%TYPE
450: ,p_assignment_id IN per_assignments_f.assignment_id%TYPE
451: ,p_person_id IN per_assignments_f.person_id%TYPE

Line 449: ,p_employee_number IN per_people_f.employee_number%TYPE

445: ,p_mass_salary_name IN VARCHAR2
446: ,p_full_name IN per_people_f.full_name%TYPE
447: ,p_national_identifier IN per_people_f.national_identifier%TYPE
448: --Bug # 9329643
449: ,p_employee_number IN per_people_f.employee_number%TYPE
450: ,p_assignment_id IN per_assignments_f.assignment_id%TYPE
451: ,p_person_id IN per_assignments_f.person_id%TYPE
452: ,p_position_id IN per_assignments_f.position_id%TYPE
453: ,p_grade_id IN per_assignments_f.grade_id%TYPE