1 PACKAGE PSP_GENERAL AUTHID CURRENT_USER AS
2 /* $Header: PSPGENES.pls 120.5.12010000.3 2008/10/20 09:33:12 amakrish ship $ */
3 procedure get_annual_salary(p_assignment_id in number,
4 p_session_date in date,
5 p_annual_salary out NOCOPY number);
6 procedure get_gl_ccid(p_payroll_id in number,
7 p_set_of_books_id in number,
8 p_cost_keyflex_id in number,
9 x_gl_ccid out NOCOPY number);
10
11 PROCEDURE TRANSACTION_CHANGE_PURGEBLE;
12
13 function business_days (low_date date,
14 high_date date,
15 p_assignment_id NUMBER DEFAULT NULL)
16 RETURN number;
17
18 function last_working_date (last_date date)
19 RETURN date;
20
21 ---
22 FUNCTION find_chart_of_accts(p_set_of_books_id IN NUMBER,
23 p_chart_of_accts OUT NOCOPY VARCHAR2)
24 RETURN NUMBER;
25 ---
26 FUNCTION get_gl_description(p_set_of_books_id IN NUMBER,
27 a_code_combination_id IN NUMBER)
28 RETURN VARCHAR2;
29 ---PRAGMA RESTRICT_REFERENCES(get_gl_description,WNDS);
30 ---
31 FUNCTION find_global_suspense(p_start_date_active IN DATE DEFAULT NULL,
32 p_business_group_id IN NUMBER,
33 p_set_of_books_id IN NUMBER,
34 p_organization_account_id OUT NOCOPY NUMBER)
35 RETURN VARCHAR2;
36 ---
37
38 PROCEDURE poeta_effective_date
39 (p_payroll_end_date IN DATE,
40 p_project_id IN NUMBER,
41 p_award_id IN NUMBER,
42 p_task_id IN NUMBER,
43 p_effective_date OUT NOCOPY DATE,
44 p_return_status OUT NOCOPY VARCHAR2);
45
46 PROCEDURE poeta_effective_date
47 (p_payroll_end_date IN DATE,
48 p_project_id IN NUMBER,
49 p_task_id IN NUMBER,
50 p_effective_date OUT NOCOPY DATE,
51 p_return_status OUT NOCOPY VARCHAR2);
52
53 PROCEDURE MULTIORG_CLIENT_INFO(
54 p_gl_set_of_bks_id OUT NOCOPY NUMBER,
55 p_business_group_id OUT NOCOPY NUMBER,
56 p_operating_unit OUT NOCOPY NUMBER,
57 p_pa_gms_install_options OUT NOCOPY VARCHAR2);
58
59 FUNCTION get_specific_profile(
60 p_profile_name IN VARCHAR2)
61 return VARCHAR2;
62
63 FUNCTION IS_LD_ENABLED (P_BUSINESS_GROUP_ID IN NUMBER) RETURN VARCHAR2;
64
65 /* Added the procedure below as part of "Zero work days" enhancement */
66
67 PROCEDURE GET_GMS_EFFECTIVE_DATE(
68 p_person_id in number,
69 p_effective_date in out NOCOPY date);
70
71
72 FUNCTION AWARD_DATE_VALIDATION
73 (P_AWARD_ID IN NUMBER,
74 P_START_DATE IN DATE,
75 P_END_DATE IN DATE)
76 RETURN BOOLEAN;
77
78 FUNCTION get_gl_values(p_set_of_books_id IN NUMBER,
79 a_code_combination_id IN NUMBER)
80 RETURN VARCHAR2;
81
82 -- Added by Ritesh on 14-NOV-2001 for Bug:2103460
83
84 FUNCTION get_person_name(p_person_id IN NUMBER,
85 p_effective_date IN DATE)
86 RETURN VARCHAR2;
87
88 FUNCTION get_assignment_num(p_assignment_id IN NUMBER,
89 p_effective_date IN DATE)
90 RETURN VARCHAR2;
91
92 FUNCTION get_payroll_name(p_payroll_id IN NUMBER,
93 p_effective_date IN DATE)
94 RETURN VARCHAR2;
95
96 /* Commented the following procedure for bug fix 2397883
97 -- Introduced the following procedure for bug 2209483
98 PROCEDURE igw_percent_effort (p_person_id IN NUMBER,
99 p_award_id IN NUMBER,
100 p_effective_date IN DATE,
101 p_percent_effort OUT NOCOPY NUMBER,
102 p_msg_data OUT NOCOPY VARCHAR2,
103 p_return_status OUT NOCOPY VARCHAR2);
104 End of bug fix 2397883 */
105
106 -- Pragmas needs to be defined for these functions as they are called from SQL.
107
108 PRAGMA RESTRICT_REFERENCES(get_person_name, WNDS);
109 PRAGMA RESTRICT_REFERENCES(get_assignment_num, WNDS);
110 PRAGMA RESTRICT_REFERENCES(get_payroll_name, WNDS);
111
112 -- End additions for Bug:2103460.
113
114 -- Introduced the following for bug fix 2635110
115 FUNCTION get_project_number (p_project_id IN NUMBER) RETURN VARCHAR2;
116 FUNCTION get_task_number (p_task_id IN NUMBER) RETURN VARCHAR2;
117 FUNCTION get_award_number (p_award_id IN NUMBER) RETURN VARCHAR2;
118 FUNCTION get_org_name (p_org_id IN NUMBER) RETURN VARCHAR2;
119 FUNCTION get_period_name (p_period_id IN NUMBER) RETURN VARCHAR2;
120 FUNCTION get_element_name (p_element_type_id IN NUMBER) RETURN VARCHAR2;
121 FUNCTION get_element_name (p_element_type_id IN NUMBER,
122 p_effective_date IN DATE) RETURN VARCHAR2;
123 FUNCTION get_source_type (p_source_type IN VARCHAR2,
124 p_source_code IN VARCHAR2) RETURN VARCHAR2;
125 FUNCTION get_status_description (p_status_code IN VARCHAR2) RETURN VARCHAR2;
126 FUNCTION get_error_description (p_error_code IN VARCHAR2) RETURN VARCHAR2;
127
128 -- Pragmas for the above functions
129 PRAGMA RESTRICT_REFERENCES(get_project_number, WNDS);
130 PRAGMA RESTRICT_REFERENCES(get_task_number, WNDS);
131 PRAGMA RESTRICT_REFERENCES(get_award_number, WNDS);
132 PRAGMA RESTRICT_REFERENCES(get_org_name, WNDS);
133 PRAGMA RESTRICT_REFERENCES(get_period_name, WNDS);
134 PRAGMA RESTRICT_REFERENCES(get_element_name, WNDS);
135 PRAGMA RESTRICT_REFERENCES(get_source_type, WNDS);
136 PRAGMA RESTRICT_REFERENCES(get_status_description, WNDS);
137 PRAGMA RESTRICT_REFERENCES(get_error_description, WNDS);
138 -- End of bug fix 2635110
139
140
141
142 -- For bug no 2478000 by tbalacha
143
144 /**********************************************************************************************
145 Description : Function Introduced fro Qubec
146 Purpose : To remove hard coded US dollars from LD
147 Date:25-Apr-2003
148 **********************************************************************************************/
149
150 FUNCTION get_currency_code(p_business_group_id IN NUMBER ) RETURN VARCHAR2;
151
152 -- End of code for bug no 2478000 by tbalacha
153
154 -- Introduced the following procedure for bug 2916848
155 PROCEDURE get_currency_precision
156 (p_currency_code IN VARCHAR2,
157 p_precision OUT NOCOPY NUMBER,
158 p_ext_precision OUT NOCOPY NUMBER);
159
160 /***** Commented the following gor bug fix 3146167
161 FUNCTION get_payroll_currency(p_payroll_control_id IN NUMBER) RETURN VARCHAR2;
162 PRAGMA RESTRICT_REFERENCES(get_payroll_currency, WNDS);
163 End of comment for bug fix 3146167 *****/
164 -- End of bug fix 2916848
165
166 -- For BUg 2916848 Ilo Mrc Ehnc.
167 /*******************************************************************************************
168 Description: This function call would replace call to profile option
169 PSP: Enable Update Encumbrance, as the profile,
170 PSP: Enable Update Encumbrance will be obsoleted by end dating it to '01-jan-2003'.
171 The call to the profile PSP: Enable Update Encumbrance , in all the files except
172 GMS.pll will be removed and this new function START_CAPTURING_UPDATES will
173 instead called in its place
174 Date of Creation: 23-Jul-2003
175 Bug :3075435 Dynamic trigger implementaion
176 **********************************************************************************************/
177 Function START_CAPTURING_UPDATES(p_business_group_id IN NUMBER) RETURN VARCHAR2;
178
179 /**************************************************************************
180 Description : this function was Introduced to check for the existence of
181 Person_Business_group_id column at customers site , if it
182 exist, then this function returns true else it returns false
183 Date of creation: 24-Oct-2003
184 FUNCTION PERSON_BUSINESS_GROUP_ID_EXIST RETURN BOOLEAN;
185 ***************************************************************************/
186
187
188
189 /*****************************************************************************
190 Function name : VALIDATE_PROC_FOR_HR_UPG
191 Creation date : 21-Apr-2004
192 Purpose : This procedure returns true when Labor Distribtion Product
193 is Installed.
194 *****************************************************************************/
195 PROCEDURE VALIDATE_PROC_FOR_HR_UPG(DO_UPG OUT NOCOPY VARCHAR2);
196
197 -- Introduced the following for bug fix 2908859/2907203
198 FUNCTION get_act_dff_grouping_option (p_business_group_id IN NUMBER) RETURN VARCHAR2;
199 FUNCTION get_enc_dff_grouping_option (p_business_group_id IN NUMBER) RETURN VARCHAR2;
200
201 FUNCTION get_sponsored_flag (p_project_id IN NUMBER) RETURN VARCHAR2;
202 -- End of changes for bug fix 2908859/2907203
203
204 -- Function introduced to be used in Effort Reporting self service module
205 FUNCTION get_person_name_er(p_person_id IN VARCHAR2, p_effective_date IN DATE) RETURN VARCHAR2 ;
206 FUNCTION chk_person_validity(p_person_id IN VARCHAR2,p_effective_date IN DATE) RETURN VARCHAR2;
207 FUNCTION get_payroll_name_er(p_payroll_id IN NUMBER, p_effective_date IN DATE) RETURN VARCHAR2;
208 FUNCTION chk_payroll_validity(p_payroll_id IN NUMBER, p_effective_date IN DATE) RETURN VARCHAR2;
209 FUNCTION chk_position_validity(p_position_id IN NUMBER, p_effective_date IN DATE) RETURN VARCHAR2;
210 FUNCTION get_position_name_er(p_position_id IN NUMBER, p_effective_date IN DATE) RETURN VARCHAR2 ;
211 FUNCTION get_fastformula_name_er(p_formula_id IN NUMBER, p_effective_date IN DATE) RETURN VARCHAR2;
212 FUNCTION chk_fastformula_validity(p_formula_id IN NUMBER, p_effective_date IN DATE) RETURN VARCHAR2;
213 FUNCTION get_job_name_er(p_job_id IN NUMBER, p_effective_date IN DATE) RETURN VARCHAR2;
214 FUNCTION chk_job_validity(p_job_id IN NUMBER, p_effective_date IN DATE) RETURN VARCHAR2;
215 FUNCTION chk_org_validity(p_org_id IN NUMBER, p_effective_date IN DATE) RETURN VARCHAR2;
216 FUNCTION get_org_name_er(p_org_id IN NUMBER, p_effective_date IN DATE) RETURN VARCHAR2 ;
217 FUNCTION get_fastformula_desc_er(p_formula_id IN NUMBER, p_effective_date IN DATE) RETURN VARCHAR2;
218
219 -- End of funtion changes for Er Self service module.
220
221 --- Functions used in AME
222 function get_approval_type(txn_id varchar2) return varchar2;
223 pragma restrict_references (get_approval_type, wnds, wnps);
224
225 function get_person_id(txn_id varchar2) return number;
226 pragma restrict_references (get_person_id, wnds, wnps);
227
228 function get_eff_report_detail_id(txn_id varchar2) return number;
229 pragma restrict_references (get_eff_report_detail_id, wnds, wnps);
230
231 function get_task_id(txn_id varchar2) return number;
232 pragma restrict_references (get_task_id, wnds, wnps);
233
234 function get_project_id(txn_id varchar2) return number;
235 pragma restrict_references (get_project_id, wnds, wnps);
236
237 function get_emp_term_flag(txn_id varchar2) return varchar2;
238 pragma restrict_references (get_emp_term_flag, wnds, wnps);
239
240 function get_user_id_flag(txn_id varchar2) return varchar2; --Added for bug 6786413
241 pragma restrict_references (get_user_id_flag, wnds, wnps);
242
243 -- Introduced the following for bug fix 3867234
244 PROCEDURE add_report_error(p_request_id IN NUMBER,
245 p_message_level IN VARCHAR2,
246 p_source_id IN NUMBER,
247 p_error_message IN VARCHAR2,
248 p_payroll_action_id IN NUMBER DEFAULT NULL,
249 p_return_status OUT NOCOPY VARCHAR2,
250 p_source_name IN VARCHAR2 DEFAULT NULL,
251 p_parent_source_id IN NUMBER DEFAULT NULL,
252 p_parent_source_name IN VARCHAR2 DEFAULT NULL,
253 p_value1 IN NUMBER DEFAULT NULL,
254 p_value2 IN NUMBER DEFAULT NULL,
255 p_value3 IN NUMBER DEFAULT NULL,
256 p_value4 IN NUMBER DEFAULT NULL,
257 p_value5 IN NUMBER DEFAULT NULL,
258 p_value6 IN NUMBER DEFAULT NULL,
259 p_value7 IN NUMBER DEFAULT NULL,
260 p_value8 IN NUMBER DEFAULT NULL,
261 p_value9 IN NUMBER DEFAULT NULL,
262 p_value10 IN NUMBER DEFAULT NULL,
263 p_information1 IN VARCHAR2 DEFAULT NULL,
264 p_information2 IN VARCHAR2 DEFAULT NULL,
265 p_information3 IN VARCHAR2 DEFAULT NULL,
266 p_information4 IN VARCHAR2 DEFAULT NULL,
267 p_information5 IN VARCHAR2 DEFAULT NULL,
268 p_information6 IN VARCHAR2 DEFAULT NULL,
269 p_information7 IN VARCHAR2 DEFAULT NULL,
270 p_information8 IN VARCHAR2 DEFAULT NULL,
271 p_information9 IN VARCHAR2 DEFAULT NULL,
272 p_information10 IN VARCHAR2 DEFAULT NULL);
273
274 PROCEDURE add_report_error(p_request_id IN NUMBER,
275 p_message_level IN VARCHAR2,
276 p_source_id IN NUMBER,
277 p_retry_request_id IN NUMBER,
278 p_pdf_request_id IN NUMBER,
279 p_error_message IN VARCHAR2,
280 p_return_status OUT NOCOPY VARCHAR2);
281 -- End of changes for bug fix 3867234
282
283 -- Introduced the following for bug fix 4022334
284 FUNCTION IS_EFFORT_REPORT_MIGRATED RETURN BOOLEAN ;
285 -- END of changes for bug fix 4022334
286
287 -- Start BUG 4244924YALE ENHANCEMENTS
288 function GET_CONFIGURATION_OPTION_VALUE(p_business_group_id IN NUMBER,
289 p_pcv_information_category in varchar2,
290 p_pcv_information1 in varchar2 default null) return varchar2;
291
292 Procedure get_gl_ptaoe_Mapping(p_business_group_id IN NUMBER,
293 p_proj_segment OUT NOCOPY varchar2, p_tsk_segment OUT NOCOPY varchar2,
294 p_awd_sgement OUT NOCOPY varchar2, p_exp_org_segment OUT NOCOPY varchar2,
295 p_exp_type_segment OUT NOCOPY varchar2) ;
296
297 -- END BUG 4244924YALE ENHANCEMENTS
298
299 --Bug 4334816:Function added for Effort Report Status Monitor
300 FUNCTION Is_eff_Report_status_changed (p_status_code IN Varchar2, p_wf_itrm_key IN Number)
301 return varchar2 ;
302
303
304 function get_assignment_status( p_ASSIGNMENT_id in number , p_effective_date in date)
305 return VARCHAR2;
306
307 --R12 MOAC Uptake
308 G_PREV_PROJ_ID Number(15);
309 G_PREV_ORG_ID Number(15);
310
311 PROCEDURE INIT_MOAC;
312
313 FUNCTION Get_transaction_org_id (p_project_id Number,p_expenditure_organization_id Number)
314 RETURN NUMBER;
315
316 -- Bug 7137755
317 FUNCTION get_pre_app_emp_list(P_REQUEST_ID IN Number)
318 return varchar2;
319
320 -- Bug 7137755
321 FUNCTION get_app_rej_emp_list(P_WF_ITEM_KEY IN Varchar2)
322 return varchar2;
323
324 END;
325