1 package hr_auth_bridge AUTHID CURRENT_USER as
2 /* $Header: hrathbrd.pkh 115.1 2002/05/29 05:43:27 pkm ship $ */
3
4 FUNCTION get_coverage
5 (
6 p_prtt_enrt_rslt_id in number,
7 p_per_in_ler_id in number,
8 p_acty_typ_cd in varchar2,
9 p_type in varchar2
10 )
11 RETURN varchar2;
12
13 FUNCTION get_beneficiaries
14 (
15 p_prtt_enrt_rslt_id in number,
16 p_per_in_ler_id in number,
17 p_prmry_cntngnt_cd in varchar2
18 )
19 RETURN varchar2;
20
21 FUNCTION get_beneficiaries
22 (
23 p_prtt_enrt_rslt_id in number,
24 p_per_in_ler_id in number,
25 p_prmry_cntngnt_cd in varchar2,
26 p_effective_date in date
27 )
28 RETURN varchar2;
29
30 FUNCTION get_primary_care_providers
31 (
32 p_prtt_enrt_rslt_id in number,
33 p_business_group_id in number
34 )
35 RETURN varchar2;
36
37 FUNCTION get_primary_care_providers
38 (
39 p_prtt_enrt_rslt_id in number,
40 p_business_group_id in number,
41 p_effective_date in date
42 )
43 RETURN varchar2;
44
45 FUNCTION get_interim_flag
46 (
47 p_prtt_enrt_rslt_id in number,
48 p_business_group_id in number
49 )
50 RETURN varchar2;
51
52 FUNCTION get_interim_flag
53 (
54 p_prtt_enrt_rslt_id in number,
55 p_business_group_id in number,
56 p_effective_date in date
57 )
58 RETURN varchar2;
59
60 FUNCTION get_contact_relationships
61 (
62 p_person_id in number,
63 p_contact_person_id in number
64 )
65 RETURN varchar2;
66
67 FUNCTION get_contact_relationships
68 (
69 p_person_id in number,
70 p_contact_person_id in number,
71 p_effective_date in date
72 )
73 RETURN varchar2;
74
75 FUNCTION get_proposed_salary
76 (
77 p_assignment_id in number
78 )
79 RETURN varchar2;
80
81 FUNCTION get_proposed_salary
82 (
83 p_assignment_id in number,
84 p_effective_date in date
85 )
86 RETURN varchar2;
87
88 FUNCTION get_salary_change_date
89 (
90 p_assignment_id in number
91 )
92 RETURN varchar2;
93
94 FUNCTION get_salary_change_date
95 (
96 p_assignment_id in number,
97 p_effective_date in date
98 )
99 RETURN varchar2;
100
101 FUNCTION get_performance_rating
102 (
103 p_person_id in number
104 )
105 RETURN varchar2;
106
107 FUNCTION get_performance_rating
108 (
109 p_person_id in number,
110 p_effective_date in date
111 )
112 RETURN varchar2;
113
114 FUNCTION get_person_start_date
115 (
116 p_person_id in number,
117 p_period_of_service_id in number,
118 p_paf_effective_start_date in date,
119 p_assignment_type in varchar2
120 )
121 RETURN date;
122
123 FUNCTION get_person_start_date
124 (
125 p_person_id in number,
126 p_period_of_service_id in number,
127 p_paf_effective_start_date in date,
128 p_assignment_type in varchar2,
129 p_effective_date in date
130 )
131 RETURN date;
132
133 FUNCTION get_person_end_date
134 (
135 p_person_id in number,
136 p_period_of_service_id in number,
137 p_paf_effective_end_date in date,
138 p_assignment_type in varchar2
139 )
140 RETURN date;
141
142 FUNCTION get_person_end_date
143 (
144 p_person_id in number,
145 p_period_of_service_id in number,
146 p_paf_effective_end_date in date,
147 p_assignment_type in varchar2,
148 p_effective_date in date
149 )
150 RETURN date;
151
152 FUNCTION get_per_system_status
153 (
154 p_assignment_status_type_id in number
155 )
156 RETURN varchar2;
157
158 FUNCTION get_assignment_id
159 (
160 p_person_id in number
161 )
162 RETURN number;
163
164 END hr_auth_bridge;