1 PACKAGE pqp_fedhr_uspay_int_utils AUTHID CURRENT_USER AS
2 /* $Header: pqpfhexr.pkh 120.0 2005/05/29 01:57:23 appldev noship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |---------------------< return_new_element_name >--------------------------|
6 -- ----------------------------------------------------------------------------
7 -- {Start Of Comments}
8 --
9 -- Description:
10 -- This function returns a new element name if an entry is present in
11 -- pqp_configuration_values table. Otherwise this function returns the
12 -- same element name as passed to it as input parameter.
13 -- Prerequisites:
14 -- None.
15 --
16 -- In Parameters:
17 --
18 -- Post Success:
19 -- This function will return an element name.
20 --
21 -- Post Failure:
22 --
23 -- Developer Implementation Notes:
24 -- None.
25 --
26 -- Access Status:
27 -- Internal Development Use Only.
28 --
29 -- {End Of Comments}
30 -- ----------------------------------------------------------------------------
31 FUNCTION return_new_element_name
32 (
33 p_fedhr_element_name IN VARCHAR2,
34 p_business_group_id IN NUMBER,
35 p_effective_date IN DATE,
36 p_pay_basis IN VARCHAR2 DEFAULT NULL
37 ) RETURN VARCHAR2;
38
39 --
40 -- ----------------------------------------------------------------------------
41 -- |---------------------< return_new_element_name >--------------------------|
42 -- ----------------------------------------------------------------------------
43 -- {Start Of Comments}
44 --
45 -- Description:
46 -- This function returns a new element name if an entry is present in
47 -- pqp_configuration_values table. Otherwise this function returns the
48 -- same element name as passed to it as input parameter.
49 -- Prerequisites:
50 -- None.
51 --
52 -- In Parameters:
53 --
54 -- Post Success:
55 -- This function will return an element name.
56 --
57 -- Post Failure:
58 --
59 -- Developer Implementation Notes:
60 -- None.
61 --
62 -- Access Status:
63 -- Internal Development Use Only.
64 --
65 -- {End Of Comments}
66 -- ----------------------------------------------------------------------------
67 FUNCTION return_new_element_name
68 (
69 p_assignment_id IN VARCHAR2 ,
70 p_business_group_id IN NUMBER ,
71 p_effective_date IN DATE
72 ) RETURN VARCHAR2;
73 -- ----------------------------------------------------------------------------
74 -- |---------------------< return_new_element_name >--------------------------|
75 -- ----------------------------------------------------------------------------
76 -- {Start Of Comments}
77 --
78 -- Description:
79 -- This function returns a new element name if an entry is present in
80 -- pqp_configuration_values table. Otherwise this function returns the
81 -- same element name as passed to it as input parameter.
82 -- Prerequisites:
83 -- None.
84 --
85 -- In Parameters:
86 --
87 -- Post Success:
88 -- This function will return an element name.
89 --
90 -- Post Failure:
91 --
92 -- Developer Implementation Notes:
93 -- None.
94 --
95 -- Access Status:
96 -- Internal Development Use Only.
97 --
98 -- {End Of Comments}
99 -- ----------------------------------------------------------------------------
100 FUNCTION return_new_element_name
101 (
102 p_salary_basis IN VARCHAR2 ,
103 p_business_group_id IN NUMBER ,
104 p_effective_date IN DATE
105 ) RETURN VARCHAR2;
106 --
107 -- ----------------------------------------------------------------------------
108 -- |---------------------------< is_script_run >------------------------------|
109 -- ----------------------------------------------------------------------------
110 -- {Start Of Comments}
111 --
112 -- Description:
113 -- This function return a TRUE if rows are present in pqp_configuration_values
114 -- table. Otherwise this function returns false.
115 -- Prerequisites:
116 -- None.
117 --
118 -- In Parameters:
119 --
120 -- Post Success:
121 -- This function will return a TRUE or FALSE.
122 --
123 -- Post Failure:
124 --
125 -- Developer Implementation Notes:
126 -- None.
127 --
128 -- Access Status:
129 -- Internal Development Use Only.
130 --
131 -- {End Of Comments}
132 -- ----------------------------------------------------------------------------
133 FUNCTION is_script_run
134 (
135 p_fedhr_element_name IN VARCHAR2,
136 p_business_group_id IN NUMBER
137 ) RETURN BOOLEAN;
138
139 --
140 -- ----------------------------------------------------------------------------
141 -- |---------------------------is_ele_link_exists >----------------------------|
142 -- ----------------------------------------------------------------------------
143 -- {Start Of Comments}
144 --
145 -- Description:
146 -- This function return a TRUE if the element link exists.
147 -- Otherwise this function returns false.
148 -- Prerequisites:
149 -- None.
150 --
151 -- In Parameters:
152 --
153 -- Post Success:
154 -- This function will return a TRUE or FALSE.
155 --
156 -- Post Failure:
157 --
158 -- Developer Implementation Notes:
159 -- None.
160 --
161 -- Access Status:
162 -- Internal Development Use Only.
163 --
164 -- {End Of Comments}
165 -- ----------------------------------------------------------------------------
166
167 FUNCTION is_ele_link_exists
168 (
169 p_ele_name IN VARCHAR2,
170 p_legislation_code IN VARCHAR2 DEFAULT NULL,
171 p_bg_id IN NUMBER DEFAULT NULL
172 ) RETURN BOOLEAN;
173
174 --
175 -- ----------------------------------------------------------------------------
176 -- |---------------------< pay_basis_to_sal_basis >--------------------------|
177 -- ----------------------------------------------------------------------------
178 -- {Start Of Comments}
179 --
180 -- Description:
181 -- This function return the mapping of Pay Basis to Salary Basis.
182 --
183 -- Prerequisites:
184 -- None.
185 --
186 -- In Parameters:
187 --
188 -- Post Success:
189 -- This function returns Pay basis Mapping to Sal Basis.
190 --
191 -- Post Failure:
192 --
193 -- Developer Implementation Notes:
194 -- None.
195 --
196 -- Access Status:
197 -- Internal Development Use Only.
198 --
199 -- {End Of Comments}
200 -- ----------------------------------------------------------------------------
201
202 FUNCTION pay_basis_to_sal_basis
203 (
204 p_pay_basis IN VARCHAR2,
205 p_sal_basis OUT NOCOPY VARCHAR2
206 ) RETURN VARCHAR2;
207
208 -- ----------------------------------------------------------------------------
209 -- |---------------------< return_old_element_name >--------------------------|
210 -- ----------------------------------------------------------------------------
211 -- {Start Of Comments}
212 --
213 -- Description:
214 -- This function returns federal element name if an entry is present in
215 -- pqp_configuration_values table. Otherwise this function returns the
216 -- same element name as passed to it as input parameter.
217 -- Prerequisites:
218 -- None.
219 --
220 -- In Parameters:
221 --
222 -- Post Success:
223 -- This function will return federal element name.
224 --
225 -- Post Failure:
226 --
227 -- Developer Implementation Notes:
228 -- None.
229 --
230 -- Access Status:
231 -- Internal Development Use Only.
232 --
233 -- {End Of Comments}
234 -- ----------------------------------------------------------------------------
235 FUNCTION return_old_element_name
236 (
237 p_agency_element_name IN VARCHAR2 ,
238 p_business_group_id IN NUMBER ,
239 p_effective_date IN DATE
240 ) RETURN VARCHAR2;
241
242 END pqp_fedhr_uspay_int_utils;