1 PACKAGE PQH_LENGTH_OF_SERVICE_PKG AS
2 /* $Header: pqlosclc.pkh 120.0 2005/05/29 02:11:19 appldev noship $ */
3
4
5 -- ---------------------------------------------------------------------*
6 -- get_length_of_service
7 -- ---------------------------------------------------------------------*
8
9 FUNCTION get_length_of_service ( p_bg_id IN NUMBER,
10 p_person_id IN NUMBER default NULL,
11 p_assignment_id IN NUMBER default NULL,
12 p_los_type IN VARCHAR2,
13 p_return_units IN VARCHAR2 default 'D',
14 p_determination_date IN DATE default NULL)
15 RETURN NUMBER;
16 --
17 -- Length of service calculation for German PS
18 --
19 FUNCTION get_length_of_service( p_bg_id IN per_all_organization_units.organization_id%TYPE,
20 p_person_id IN per_all_people_f.person_id%TYPE,
21 p_assignment_id IN per_all_assignments_f.assignment_id%TYPE DEFAULT NULL,
22 p_prev_job_id IN per_previous_jobs.previous_job_id%TYPE DEFAULT NULL,
23 p_los_type IN VARCHAR2,
24 p_assg_start_date IN DATE ,
25 p_assg_end_date IN DATE
26 )
27 RETURN VARCHAR2;
28
29 FUNCTION get_de_military_service_period(p_bg_id IN hr_all_organization_units.organization_id%TYPE,
30 p_person_id IN per_all_people_f.person_id%TYPE,
31 p_los_type IN hr_lookups.lookup_code%TYPE,
32 p_start_date IN DATE,
33 p_end_date IN DATE)
34 RETURN VARCHAR2;
35
36 FUNCTION get_de_correction_factor(p_person_id IN per_all_people_f.person_id%TYPE,
37 p_los_type IN hr_lookups.lookup_code%TYPE,
38 p_effective_date IN DATE)
39 RETURN VARCHAR2;
40
41 FUNCTION get_length_previous_employment(p_person_id IN per_all_people_f.person_id%TYPE,
42 p_bg_id IN per_all_organization_units.organization_id%TYPE,
43 p_los_type IN hr_lookups.lookup_code%TYPE,
44 p_previous_job_id IN per_previous_jobs.previous_job_id%TYPE)
45 RETURN NUMBER;
46 FUNCTION get_correction_factor ( p_person_id IN per_all_people_f.person_id%TYPE,
47 p_los_type IN hr_lookups.lookup_code%TYPE,
48 p_effective_date IN DATE)
49 RETURN NUMBER;
50
51
52 FUNCTION get_corps_name (p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,
53 p_bg_id IN per_all_organization_units.organization_id%TYPE)
54 RETURN VARCHAR2;
55
56 FUNCTION get_corps_name (p_corps_id IN pqh_corps_definitions.corps_definition_id%TYPE)
57 RETURN VARCHAR2;
58
59 FUNCTION get_grade_name (p_grade_id IN per_grades.grade_id%TYPE)
60 RETURN VARCHAR2;
61
62 FUNCTION get_los_for_display ( p_bg_id IN NUMBER,
63 p_person_id IN NUMBER default NULL,
64 p_assignment_id IN NUMBER default NULL,
65 p_los_type IN VARCHAR2,
66 p_determination_date IN DATE default SYSDATE) RETURN VARCHAR2;
67 FUNCTION get_working_time_ratio( p_bg_normal_day IN NUMBER,
68 p_bg_hours IN NUMBER,
69 p_bg_frequency IN VARCHAR2,
70 p_asg_hours IN NUMBER,
71 p_asg_frequency IN VARCHAR2)
72 RETURN NUMBER;
73 FUNCTION get_employee_type (p_person_id IN per_all_people_f.person_id%TYPE,
74 p_determination_date IN DATE)
75 RETURN VARCHAR2;
76 FUNCTION get_absent_period (p_bg_id IN per_all_organization_units.organization_id%TYPE,
77 p_person_id IN per_all_people_f.person_id%TYPE,
78 p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,
79 p_los_type IN hr_lookups.lookup_code%TYPE,
80 p_start_date IN DATE,
81 p_end_date IN DATE
82 )
83 RETURN NUMBER;
84 FUNCTION get_parttime_entitlement(p_person_id IN per_all_assignments_f.person_id%TYPE,
85 p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,
86 p_bg_id IN per_all_organization_units.organization_id%TYPE,
87 p_los_type IN hr_lookups.lookup_code%TYPE,
88 p_start_date IN DATE,
89 p_end_date IN DATE)
90
91 RETURN NUMBER ;
92
93 FUNCTION get_date_diff_for_display (
94 p_start_date IN DATE,
95 p_end_date IN DATE DEFAULT SYSDATE
96 )
97 RETURN VARCHAR2;
98
99 END PQH_LENGTH_OF_SERVICE_PKG;
100