[Home] [Help]
PACKAGE BODY: APPS.PQH_PQIPED6_XMLP_PKG
Source
1 PACKAGE BODY PQH_PQIPED6_XMLP_PKG AS
2 /* $Header: PQIPED6B.pls 120.6 2011/05/02 07:44:46 nvelaga ship $ */
3
4 function line1Formula return Number is
5 temp_num number := 19;
6
7 begin
8
9 if line_num < 50 then
10 temp_num := line_num;
11 line_num:= line_num + 1;
12 elsif tmp_var between 49 and 54 then
13 temp_num := tmp_var;
14 tmp_var := tmp_var + 1;
15 elsif tmp_var1 between 54 and 61 then
16 temp_num := tmp_var1;
17 tmp_var1 := tmp_var1 + 1;
18 else
19 temp_num := tmp_var2;
20 tmp_var2 := tmp_var2 + 1;
21 end if;
22
23 if line_num = 26 then
24 line_num := 27;
25 elsif line_num = 34 then
26 line_num := 35;
27 elsif line_num = 42 then
28 line_num := 43;
29
30 end if;
31
32
33
34 return temp_num;
35 end;
36
37 function CF_GroupTotTitleFormula(JobCode in number) return Char is
38 l_total_title VARCHAR2(200) := '';
39 l_job_code Number := JobCode;
40 begin
41 IF l_job_code = '5' THEN
42 l_total_title := 'Total Exec/Administrative, and Managerial (sum of lines 19-25)';
43 ELSIF l_job_code = '6' THEN
44 l_total_title := 'Total Other Administrative (sum of lines 27-33)';
45 ELSIF l_job_code = '7' THEN
46 l_total_title := 'Total Other Professionals (sum of lines 35-41)';
47 ELSIF l_job_code = '8' THEN
48 l_total_title := 'Total Technical and Paraprofessionals (sum of lines 43-47)';
49 ELSIF l_job_code = '9' THEN
50 l_total_title := 'Total Clerical and Secretarial (sum of lines 49-53)';
51 ELSIF l_job_code = '10' THEN
52 l_total_title := 'Total Skilled Crafts (sum of lines 55-59)';
53 ELSIF l_job_code = '11' THEN
54 l_total_title := 'Total Service/Maintenance (sum of lines 61-65)';
55 END IF;
56
57 return l_total_title;
58 end;
59
60 function cf_group_linenoformula(JobCode in number) return number is
61 temp_num number;
62 begin
63 if (JobCode = 5) then
64 temp_num := 26;
65 elsif (JobCode = 6) then
66 temp_num := 34;
67 elsif (JobCode = 7) then
68 temp_num := 42;
69 elsif (JobCode = 8) then
70 temp_num := 48;
71 elsif (JobCode = 9) then
72 temp_num := 54;
73 elsif (JobCode = 10) then
74 temp_num := 60;
75 elsif (JobCode = 11) then
76 temp_num := 66;
77 end if;
78
79 return temp_num;
80
81 end;
82
83 function BeforeReport return boolean is
84 l_fr varchar2(2000);
85 l_ft varchar2(2000);
86 l_pr varchar2(2000);
87 l_pt varchar2(2000);
88 l_query_text VARCHAR2(2000);
89 line VARCHAR2(32767);
90 sc VARCHAR2(32767);
91 salary_range VARCHAR2(32767);
92 l_nr_men NUMBER(10) := 0;
93 l_nr_wmen NUMBER(10) := 0;
94 l_bnh_men NUMBER(10) := 0;
95 l_bnh_wmen NUMBER(10) := 0;
96 l_amai_men NUMBER(10) := 0;
97 l_amai_wmen NUMBER(10) := 0;
98 l_ap_men NUMBER(10) := 0;
99 l_ap_wmen NUMBER(10) := 0;
100 l_h_men NUMBER(10) := 0;
101 l_h_wmen NUMBER(10) := 0;
102 l_wnh_men NUMBER(10) := 0;
103 l_wnh_wmen NUMBER(10) := 0;
104 l_ur_men NUMBER(10) := 0;
105 l_ur_wmen NUMBER(10) := 0;
106 l_tot_men NUMBER(10) := 0;
107 l_tot_wmen NUMBER(10) := 0;
108 l_nh_op_men NUMBER(10) := 0;
109 l_nh_op_wmen NUMBER(10) := 0;
110 l_tmr_men NUMBER(10) := 0;
111 l_tmr_wmen NUMBER(10) := 0;
112
113 CURSOR get_line_counts IS
114 SELECT 1 line,
115 hl.lookup_code job_category_name,
116 pqh_salary_class_intervals_pkg.get_job_sal_interval(pqh_employment_category.identify_empl_category(ass.employment_category,
117 cp_fr, cp_ft, cp_pr, cp_pt), hl.lookup_code, nvl(ppp.proposed_salary_n, 0) * ppb.pay_annualization_factor) salary_range,
118 -- Added for bug#11736960
119 COUNT(decode(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id, p_report_date, 'Y'), 0, decode(peo.sex, 'M', 1, NULL), NULL)) nrmen,
120 COUNT(decode(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id, p_report_date, 'Y'), 0, decode(peo.sex, 'F', 1, NULL), NULL)) nrwmen,
121 COUNT(decode(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id, p_report_date, 'Y'), 2, decode(peo.sex, 'M', 1, NULL), NULL)) bnhmen,
122 COUNT(decode(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id, p_report_date, 'Y'), 2, decode(peo.sex, 'F', 1, NULL), NULL)) bnhwmen,
123 COUNT(decode(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id, p_report_date, 'Y'), 6, decode(peo.sex, 'M', 1, NULL), NULL)) am_almen,
124 COUNT(decode(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id, p_report_date, 'Y'), 6, decode(peo.sex, 'F', 1, NULL), NULL)) am_alwmen,
125 COUNT(decode(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id, p_report_date, 'Y'), 4, decode(peo.sex, 'M', 1, NULL), NULL)) a_pmen,
126 COUNT(decode(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id, p_report_date, 'Y'), 4, decode(peo.sex, 'F', 1, NULL), NULL)) a_pwmen,
127 COUNT(decode(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id, p_report_date, 'Y'), 3, decode(peo.sex, 'M', 1, NULL), NULL)) hmen,
128 COUNT(decode(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id, p_report_date, 'Y'), 3, decode(peo.sex, 'F', 1, NULL), NULL)) hwmen,
129 COUNT(decode(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id, p_report_date, 'Y'), 1, decode(peo.sex, 'M', 1, NULL), NULL)) wnhmen,
130 COUNT(decode(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id, p_report_date, 'Y'), 1, decode(peo.sex, 'F', 1, NULL), NULL)) wnhwmen,
131 COUNT(decode(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id, p_report_date, 'Y'), 99, decode(peo.sex, 'M', 1, NULL), NULL)) urmen,
132 COUNT(decode(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id, p_report_date, 'Y'), 99, decode(peo.sex, 'F', 1, NULL), NULL)) urwmen,
133 COUNT(decode(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id, p_report_date, 'Y'), 5, decode(peo.sex, 'M', 1, NULL), NULL)) nh_opmen,
134 COUNT(decode(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id, p_report_date, 'Y'), 5, decode(peo.sex, 'F', 1, NULL), NULL)) nh_opwmen,
135 COUNT(decode(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id, p_report_date, 'Y'), 13, decode(peo.sex, 'M', 1, NULL), NULL)) tmrmen,
136 COUNT(decode(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id, p_report_date, 'Y'), 13, decode(peo.sex, 'F', 1, NULL), NULL)) tmrwmen
137 --
138 /* Commented for bug#11736960 starts
139 COUNT(decode(pqh_nr_alien_pkg.get_count_nr_alien(peo.person_id, p_report_date), '1', decode(peo.sex, 'M', 1, NULL), NULL)) nrmen,
140 COUNT(decode(pqh_nr_alien_pkg.get_count_nr_alien(peo.person_id, p_report_date), '1', decode(peo.sex, 'F', 1, NULL), NULL)) nrwmen,
141 COUNT(decode(pqh_nr_alien_pkg.get_count_nr_alien(peo.person_id, p_report_date), NULL, (decode(peo.per_information1, '2', decode(peo.sex, 'M', 1, NULL), NULL)))) bnhmen,
142 COUNT(decode(pqh_nr_alien_pkg.get_count_nr_alien(peo.person_id, p_report_date), NULL, (decode(peo.per_information1, '2', decode(peo.sex, 'F', 1, NULL), NULL)))) bnhwmen,
143 COUNT(decode(pqh_nr_alien_pkg.get_count_nr_alien(peo.person_id, p_report_date), NULL, (decode(peo.per_information1, '6', decode(peo.sex, 'M', 1, NULL), NULL)))) am_almen,
144 COUNT(decode(pqh_nr_alien_pkg.get_count_nr_alien(peo.person_id, p_report_date), NULL, (decode(peo.per_information1, '6', decode(peo.sex, 'F', 1, NULL), NULL)))) am_alwmen,
145 COUNT(decode(pqh_nr_alien_pkg.get_count_nr_alien(peo.person_id, p_report_date), NULL, (decode(peo.per_information1, '4', decode(peo.sex, 'M', 1, NULL), NULL)))) a_pmen,
146 COUNT(decode(pqh_nr_alien_pkg.get_count_nr_alien(peo.person_id, p_report_date), NULL, (decode(peo.per_information1, '4', decode(peo.sex, 'F', 1, NULL), NULL)))) a_pwmen,
147 COUNT(decode(pqh_nr_alien_pkg.get_count_nr_alien(peo.person_id, p_report_date), NULL, (decode(peo.per_information1, '3', decode(peo.sex, 'M', 1, NULL), NULL)))) hmen,
148 COUNT(decode(pqh_nr_alien_pkg.get_count_nr_alien(peo.person_id, p_report_date), NULL, (decode(peo.per_information1, '3', decode(peo.sex, 'F', 1, NULL), NULL)))) hwmen,
149 COUNT(decode(pqh_nr_alien_pkg.get_count_nr_alien(peo.person_id, p_report_date), NULL, (decode(peo.per_information1, '1', decode(peo.sex, 'M', 1, NULL), NULL)))) wnhmen,
150 COUNT(decode(pqh_nr_alien_pkg.get_count_nr_alien(peo.person_id, p_report_date), NULL, (decode(peo.per_information1, '1', decode(peo.sex, 'F', 1, NULL), NULL)))) wnhwmen,
151 COUNT(decode(pqh_nr_alien_pkg.get_count_nr_alien(peo.person_id, p_report_date), NULL, (decode(peo.per_information1, NULL, decode(peo.sex, 'M', 1, NULL), NULL)), NULL)) urmen,
152 COUNT(decode(pqh_nr_alien_pkg.get_count_nr_alien(peo.person_id, p_report_date), NULL, (decode(peo.per_information1, NULL, decode(peo.sex, 'F', 1, NULL), NULL)), NULL)) urwmen,
153 COUNT(decode(pqh_nr_alien_pkg.get_count_nr_alien(peo.person_id, p_report_date), NULL, (decode(peo.per_information1, '5', decode(peo.sex, 'M', 1, NULL), NULL)))) nh_opmen,
154 COUNT(decode(pqh_nr_alien_pkg.get_count_nr_alien(peo.person_id, p_report_date), NULL, (decode(peo.per_information1, '5', decode(peo.sex, 'F', 1, NULL), NULL)))) nh_opwmen,
155 COUNT(decode(pqh_nr_alien_pkg.get_count_nr_alien(peo.person_id, p_report_date), NULL, (decode(peo.per_information1, '13', decode(peo.sex, 'M', 1, NULL), NULL)))) tmrmen,
156 COUNT(decode(pqh_nr_alien_pkg.get_count_nr_alien(peo.person_id, p_report_date), NULL, (decode(peo.per_information1, '13', decode(peo.sex, 'F', 1, NULL), NULL)))) tmrwmen
157 Commented for bug #11736960 ends */
158 --
159 FROM per_all_people_f peo,
160 per_all_assignments_f ass,
161 per_assignment_status_types ast,
162 per_jobs job,
163 per_pay_proposals ppp,
164 per_pay_bases ppb,
165 hr_lookups hl
166 WHERE peo.person_id = ass.person_id
167 AND peo.current_employee_flag = 'Y'
168 AND hl.lookup_code = job.job_information8
169 AND job.job_information8 NOT IN('1', '2', '3', '4')
170 AND pqh_employment_category.identify_empl_category(ass.employment_category, cp_fr, cp_ft, cp_pr, cp_pt) IN('FR')
171 AND ppp.change_date =
172 (SELECT MAX(change_date)
173 FROM per_pay_proposals PRO
174 WHERE ppp.assignment_id = PRO.ASSIGNMENT_ID
175 AND PRO.CHANGE_DATE <= P_REPORT_DATE
176 AND PRO.APPROVED = 'Y' )
177 AND ass.pay_basis_id = ppb.pay_basis_id
178 AND ass.assignment_id = ppp.assignment_id
179 AND nvl(ppp.proposed_salary_n, 0) * ppb.pay_annualization_factor > 0
180 AND hl.lookup_type = 'US_IPEDS_JOB_CATEGORIES'
181 AND job.job_information_category = 'US'
182 AND p_report_date BETWEEN peo.effective_start_date
183 AND peo.effective_end_date
184 AND p_report_date BETWEEN ass.effective_start_date
185 AND ass.effective_end_date
186 AND ass.primary_flag = 'Y'
187 AND ass.assignment_status_type_id = ast.assignment_status_type_id
188 AND ast.per_system_status <> 'TERM_ASSIGN'
189 AND ass.job_id = job.job_id
190 AND ass.assignment_type = 'E'
191 AND ass.organization_id IN
192 (SELECT org.organization_id
193 FROM hr_all_organization_units org
194 WHERE business_group_id = p_business_group_id
195 AND pqh_inst_type_pkg.get_inst_type(org.organization_id) = 'NON-MED')
196 GROUP BY
197 pqh_salary_class_intervals_pkg.get_job_sal_interval(pqh_employment_category.identify_empl_category(ass.employment_category,
198 cp_fr, cp_ft, cp_pr, cp_pt), hl.lookup_code, nvl(ppp.proposed_salary_n, 0) * ppb.pay_annualization_factor),
199 hl.lookup_code;
200 /* Commenting for the bug#7033011
201
202 CURSOR get_line_tmraces_counts(c_salary_range IN VARCHAR2, c_lookup_code IN NUMBER) IS
203 SELECT COUNT(decode(pei.pei_information5, '2', decode(peo.sex, 'M', 1, NULL), NULL)) bnhmen,
204 COUNT(decode(pei.pei_information5, '2', decode(peo.sex, 'F', 1, NULL), NULL)) bnhwmen,
205 COUNT(decode(pei.pei_information5, '6', decode(peo.sex, 'M', 1, NULL), NULL)) am_almen,
206 COUNT(decode(pei.pei_information5, '6', decode(peo.sex, 'F', 1, NULL), NULL)) am_alwmen,
207 COUNT(decode(pei.pei_information5, '4', decode(peo.sex, 'M', 1, NULL), '5', decode(peo.sex, 'M', 1, NULL), NULL)) a_pmen,
208 COUNT(decode(pei.pei_information5, '4', decode(peo.sex, 'F', 1, NULL), '5', decode(peo.sex, 'F', 1, NULL), NULL)) a_pwmen,
209 COUNT(decode(pei.pei_information5, '3', decode(peo.sex, 'M', 1, NULL), '9', decode(peo.sex, 'M', 1, NULL), NULL)) hmen,
210 COUNT(decode(pei.pei_information5, '3', decode(peo.sex, 'F', 1, NULL), '9', decode(peo.sex, 'F', 1, NULL), NULL)) hwmen,
211 COUNT(decode(pei.pei_information5, '1', decode(peo.sex, 'M', 1, NULL), NULL)) wnhmen,
212 COUNT(decode(pei.pei_information5, '1', decode(peo.sex, 'F', 1, NULL), NULL)) wnhwmen,
213 COUNT(decode(pei.pei_information5, NULL, decode(peo.sex, 'M', 1, NULL), NULL)) urmen,
214 COUNT(decode(pei.pei_information5, NULL, decode(peo.sex, 'F', 1, NULL), NULL)) urwmen
215 FROM per_all_people_f peo,
216 per_all_assignments_f ass,
217 per_assignment_status_types ast,
218 per_jobs job,
219 per_pay_proposals ppp,
220 per_pay_bases ppb,
221 hr_lookups hl,
222 per_people_extra_info pei
223 WHERE peo.person_id = ass.person_id
224 AND peo.current_employee_flag = 'Y'
225 AND peo.per_information1 = '13'
226 AND peo.person_id = pei.person_id(+)
227 AND(pei.information_type = 'PER_US_ADDL_ETHNIC_CAT' OR(pei.information_type <> 'PER_US_ADDL_ETHNIC_CAT'
228 AND NOT EXISTS
229 (SELECT 1
230 FROM per_people_extra_info pei2
231 WHERE pei2.information_type = 'PER_US_ADDL_ETHNIC_CAT'
232 AND pei2.person_id = pei.person_id)
233 AND pei.person_extra_info_id =
234 (SELECT MAX(pei1.person_extra_info_id)
235 FROM per_people_extra_info pei1
236 WHERE pei1.person_id = pei.person_id))
237 OR(NOT EXISTS
238 (SELECT person_extra_info_id
239 FROM per_people_extra_info pei3
240 WHERE pei3.person_id = pei.person_id))
241 )
242 AND hl.lookup_code = job.job_information8
243 AND job.job_information8 NOT IN('1', '2', '3', '4')
244 AND pqh_employment_category.identify_empl_category(ass.employment_category, cp_fr, cp_ft, cp_pr, cp_pt) IN('FR')
245 AND ppp.change_date =
246 (SELECT MAX(change_date)
247 FROM per_pay_proposals PRO
248 WHERE ppp.assignment_id = PRO.ASSIGNMENT_ID
249 AND PRO.CHANGE_DATE <= P_REPORT_DATE
250 AND PRO.APPROVED = 'Y' )
251 AND ass.pay_basis_id = ppb.pay_basis_id
252 AND ass.assignment_id = ppp.assignment_id
253 AND nvl(ppp.proposed_salary_n, 0) * ppb.pay_annualization_factor > 0
254 AND hl.lookup_type = 'US_IPEDS_JOB_CATEGORIES'
255 AND job.job_information_category = 'US'
256 AND p_report_date BETWEEN peo.effective_start_date
257 AND peo.effective_end_date
258 AND p_report_date BETWEEN ass.effective_start_date
259 AND ass.effective_end_date
260 AND ass.primary_flag = 'Y'
261 AND ass.assignment_status_type_id = ast.assignment_status_type_id
262 AND ast.per_system_status <> 'TERM_ASSIGN'
263 AND ass.job_id = job.job_id
264 AND ass.assignment_type = 'E'
265 AND ass.organization_id IN
266 (SELECT org.organization_id
267 FROM hr_all_organization_units org
268 WHERE business_group_id = p_business_group_id
269 AND pqh_inst_type_pkg.get_inst_type(org.organization_id) = 'NON-MED')
270 AND pqh_salary_class_intervals_pkg.get_job_sal_interval(pqh_employment_category.identify_empl_category(ass.employment_category, cp_fr, cp_ft, cp_pr, cp_pt), hl.lookup_code,
271 nvl(ppp.proposed_salary_n, 0) * ppb.pay_annualization_factor) = c_salary_range
272 AND hl.lookup_code = c_lookup_code;
273
274 */
275
276 begin
277 --hr_standard.event('BEFORE REPORT');
278 LP_REPORT_DATE := to_Char(P_REPORT_DATE,'DD-MON-YYYY');
279
280 pqh_employment_category.fetch_empl_categories(p_business_group_id,l_fr,l_ft,l_pr,l_pt);
281
282 cp_fr := l_fr;
283 cp_ft := l_ft;
284 cp_pr := l_pr;
285 cp_pt := l_pt;
286 FOR i IN get_line_counts
287 LOOP
288 line := i.line;
289 sc := i.job_category_name;
290 salary_range := i.salary_range;
291 l_nr_men := i.nrmen;
292 l_nr_wmen := i.nrwmen;
293 l_bnh_men := i.bnhmen;
294 l_bnh_wmen := i.bnhwmen;
295 l_amai_men := i.am_almen;
296 l_amai_wmen := i.am_alwmen;
297 l_ap_men := i.a_pmen;
298 l_ap_wmen := i.a_pwmen;
299 l_h_men := i.hmen;
300 l_h_wmen := i.hwmen;
301 l_wnh_men := i.wnhmen;
302 l_wnh_wmen := i.wnhwmen;
303 l_ur_men := i.urmen;
304 l_ur_wmen := i.urwmen;
305 l_nh_op_men := i.nh_opmen;
306 l_nh_op_wmen := i.nh_opwmen;
307 l_tmr_men := i.tmrmen;
308 l_tmr_wmen := i.tmrwmen;
309
310 l_tot_men := l_nr_men + l_bnh_men + l_amai_men + l_ap_men + l_h_men + l_wnh_men + l_ur_men + l_nh_op_men + l_tmr_men;
311 l_tot_wmen := l_nr_wmen + l_bnh_wmen + l_amai_wmen + l_ap_wmen + l_h_wmen + l_wnh_wmen + l_ur_wmen + l_nh_op_wmen + l_tmr_wmen;
312
313 /* Commenting for the bug#7033011
314 FOR j IN get_line_tmraces_counts(salary_range,sc)
315 LOOP
316 l_bnh_men := l_bnh_men + j.bnhmen;
317 l_bnh_wmen := l_bnh_wmen + j.bnhwmen;
318 l_amai_men := l_amai_men + j.am_almen;
319 l_amai_wmen := l_amai_wmen + j.am_alwmen;
320 l_ap_men := l_ap_men + j.a_pmen;
321 l_ap_wmen := l_ap_wmen + j.a_pwmen;
322 l_h_men := l_h_men + j.hmen;
323 l_h_wmen := l_h_wmen + j.hwmen;
324 l_wnh_men := l_wnh_men + j.wnhmen;
325 l_wnh_wmen := l_wnh_wmen + j.wnhwmen;
326 l_ur_men := l_ur_men + j.urmen;
327 l_ur_wmen := l_ur_wmen + j.urwmen;
328 l_tot_men := l_tot_men + j.bnhmen + j.am_almen + j.a_pmen + j.hmen + j.wnhmen + j.urmen;
329 l_tot_wmen := l_tot_wmen + j.bnhwmen + j.am_alwmen + j.a_pwmen + j.hwmen + j.wnhwmen + j.urwmen;
330 END LOOP;
331 */
332
333 INSERT
334 INTO pay_us_rpt_totals(session_id, attribute1, attribute2, value1, value2, value3, value4,
335 value5, value6, value7, value8, value9, value10, value11, value12, value13, value14, value15, value16, value17, value18, value19, value20, value21, value22)
336 VALUES(userenv('sessionid'), 'IPED6', salary_range, line, sc,
337 l_nr_men, l_nr_wmen, l_bnh_men, l_bnh_wmen, l_amai_men, l_amai_wmen, l_ap_men, l_ap_wmen, l_h_men, l_h_wmen, l_wnh_men,
338 l_wnh_wmen, l_ur_men, l_ur_wmen, l_tot_men, l_tot_wmen, l_nh_op_men, l_nh_op_wmen, l_tmr_men, l_tmr_wmen);
339 COMMIT;
340 END LOOP;
341
342 return true;
343 end;
344
345 function AfterReport return boolean is
346 begin
347 --hr_standard.event('AFTER REPORT');
348 EXECUTE IMMEDIATE 'DELETE FROM pay_us_rpt_totals
349 WHERE attribute1 = ''IPED6''';
350 return (TRUE);
351 end;
352
353 --Functions to refer Oracle report placeholders--
354
355 Function line_num_p return number is
356 Begin
357 return line_num;
358 END;
359 Function CP_FR_p return varchar2 is
360 Begin
361 return CP_FR;
362 END;
363 Function CP_FT_p return varchar2 is
364 Begin
365 return CP_FT;
366 END;
367 Function CP_PR_p return varchar2 is
368 Begin
369 return CP_PR;
370 END;
371 Function CP_PT_p return varchar2 is
372 Begin
373 return CP_PT;
374 END;
375 Function CP_lastLineNo_p return number is
376 Begin
377 return CP_lastLineNo;
378 END;
379 Function CP_ReportTotTitle_p return varchar2 is
380 Begin
381 return CP_ReportTotTitle;
382 END;
383 Function tmp_var_p return number is
384 Begin
385 return tmp_var;
386 END;
387 Function tmp_var1_p return number is
388 Begin
389 return tmp_var1;
390 END;
391 Function tmp_var2_p return number is
392 Begin
393 return tmp_var2;
394 END;
395 END PQH_PQIPED6_XMLP_PKG ;