[Home] [Help]
229: close c_parm_val_usg;
230:
231: select --pet.element_name current_interface
232: decode(p_lookup_code,
233: 'STANDARD', decode(pet.element_name,
234: 'VERTEX','In Use','Not in Use'),
235: 'ENHANCED', decode(pet.element_name,
236: 'US_TAX_VERTEX',decode(l_WAGEACCUM_parm
237: ,'N','In Use','Not In Use')
265: and pet1.legislation_code = 'US'
266: and prt.legislation_code = 'US'
267: and exists
268: ( select 'x' from pay_run_types_f prt1
269: where prt1.run_type_name IN ('Regular Standard Run',
270: 'Separate Payment Run',
271: 'Tax Separate Run',
272: 'Supplemental Standard Run',
273: 'Regular',
268: ( select 'x' from pay_run_types_f prt1
269: where prt1.run_type_name IN ('Regular Standard Run',
270: 'Separate Payment Run',
271: 'Tax Separate Run',
272: 'Supplemental Standard Run',
273: 'Regular',
274: 'Supplemental')
275: and prt1.business_group_id IS NULL
276: and prt1.legislation_code = 'US'
284: WHEN NO_DATA_FOUND
285: THEN
286: --{
287: select decode(p_lookup_code,
288: 'STANDARD', 'In Use','Not in Use')
289: into l_ret_value
290: from DUAL;
291: hr_utility.trace('1215 -> Current Tax Interface element is VERTEX');
292: hr_utility.trace('1220 -> Return Value '||l_ret_value);
298: hr_utility.trace('1225 -> Other Exception'||substr(sqlerrm,1,30));
299: hr_utility.trace('1226 -> '||substr(sqlerrm,31,40));
300: hr_utility.trace('1230 -> Current Tax Interface element is VERTEX');
301: select decode(p_lookup_code,
302: 'STANDARD', 'In Use','Not in Use')
303: into l_ret_value
304: from DUAL;
305: hr_utility.trace('1240 -> Return Value '||l_ret_value);
306: return l_ret_value;
337: and petu.legislation_code IS NULL --= 'US'
338: and petu.element_Type_id = pet.element_type_id
339: and exists
340: ( select 'x' from pay_run_types_f prt1
341: where prt1.run_type_name IN ('Regular Standard Run',
342: 'Separate Payment Run',
343: 'Tax Separate Run',
344: 'Supplemental Standard Run',
345: 'Regular',
340: ( select 'x' from pay_run_types_f prt1
341: where prt1.run_type_name IN ('Regular Standard Run',
342: 'Separate Payment Run',
343: 'Tax Separate Run',
344: 'Supplemental Standard Run',
345: 'Regular',
346: 'Supplemental')
347: and prt1.business_group_id IS NULL
348: and prt1.legislation_code = 'US'
375:
376:
377: -- This procedure Excudes the TAX Element from processing depending on
378: -- customer selection
379: -- IF Customer selection is STANDARD interface
380: -- New Tax Element US_TAX_VERTEX will be excluded
381: -- ELSIF Customer selection is ENHANCED interface
382: -- Old Tax Element VERTEX will be excluded
383: PROCEDURE select_tax_interface(errbuf OUT nocopy VARCHAR2,
390:
391: --
392: CURSOR c_run_type is
393: select prt.* from pay_run_types_f prt
394: where prt.run_type_name IN ('Regular Standard Run',
395: 'Separate Payment Run',
396: 'Tax Separate Run',
397: 'Supplemental Standard Run',
398: 'Regular',
393: select prt.* from pay_run_types_f prt
394: where prt.run_type_name IN ('Regular Standard Run',
395: 'Separate Payment Run',
396: 'Tax Separate Run',
397: 'Supplemental Standard Run',
398: 'Regular',
399: 'Supplemental')
400: and prt.business_group_id IS NULL
401: and prt.legislation_code = 'US';
461: 'Y');
462: END;
463: hr_utility.trace('2020 -> Setup completed for Running API ');
464:
465: IF p_vertex_interface = 'STANDARD'
466: THEN
467: hr_utility.trace('2050 -> Payroll Run exist in this Instance');
468: /*Bug#5937604: Disable WAGE_ACCUMULATION_ENABLED parameter */
469: update pay_action_parameters