[Home] [Help]
26: -- 70.9 Rod Fine 06-Oct-1994 - Added column FS_LOOKUP_TYPE to
27: -- PAY_STATE_RULES table installation
28: -- procedure.
29: -- 70.10 Rod Fine 23-Mar-1995 - Added column CLASSIFICATION_ID to
30: -- PAY_TAXABILITY_RULES table
31: -- installation procedure.
32: -- 70.11 Rod Fine 07-Apr-1995 - Added extra check on classification_id
33: -- to PAY_TAXABILITY_RULES transfer_row
34: -- procedure.
29: -- 70.10 Rod Fine 23-Mar-1995 - Added column CLASSIFICATION_ID to
30: -- PAY_TAXABILITY_RULES table
31: -- installation procedure.
32: -- 70.11 Rod Fine 07-Apr-1995 - Added extra check on classification_id
33: -- to PAY_TAXABILITY_RULES transfer_row
34: -- procedure.
35: -- 70.12 rfine 27-Mar-96 353225 When delivering PAY_STATE_RULES, update
36: -- the row if it already exists, rather
37: -- than simply not delivering it.
291:
292: END install_state_rules;
293:
294: --****************************************************************************
295: -- INSTALLATION PROCEDURE FOR : PAY_TAXABILITY_RULES
296: --****************************************************************************
297:
298: PROCEDURE install_tax_rules(p_phase IN number)
299: ----------------------------------------------
299: ----------------------------------------------
300: IS
301: -- Install procedure to transfer startup taxability rules into the live
302: -- tables. This routine is written purely for the US localization team.
303: -- The object PAY_TAXABILITY_RULES is used only in the US payroll system
304: --
305: -- Canadian Payroll also uses pay_taxability_rules, so I have updated
306: -- RM's changes so they can be used for CA.
307:
301: -- Install procedure to transfer startup taxability rules into the live
302: -- tables. This routine is written purely for the US localization team.
303: -- The object PAY_TAXABILITY_RULES is used only in the US payroll system
304: --
305: -- Canadian Payroll also uses pay_taxability_rules, so I have updated
306: -- RM's changes so they can be used for CA.
307:
308: l_null_return varchar2(1); -- For 'select null' statements
309: l_new_surrogate_key number(15); -- New surrogate key for the delivery row
366:
367: BEGIN
368: select taxability_rules_date_id
369: into l_trd_id
370: from pay_taxability_rules_dates
371: where legislation_code = stu_rec.legislation_code
372: and trunc(valid_date_from) = trunc(to_date('0001/01/01', 'YYYY/MM/DD'))
373: and trunc(valid_date_to) = trunc(to_date('4712/12/31', 'YYYY/MM/DD'));
374:
374:
375: EXCEPTION
376: when NO_DATA_FOUND then
377:
378: select pay_taxability_rules_dates_s.nextval
379: into l_trd_id
380: from dual;
381:
382: insert into pay_taxability_rules_dates
378: select pay_taxability_rules_dates_s.nextval
379: into l_trd_id
380: from dual;
381:
382: insert into pay_taxability_rules_dates
383: ( taxability_rules_date_id,
384: valid_date_from,
385: valid_date_to,
386: legislation_code)
397: BEGIN
398:
399: select null
400: into l_null_return
401: from pay_taxability_rules
402: where jurisdiction_code = stu_rec.jurisdiction_code
403: and tax_type = stu_rec.tax_type
404: and classification_id = stu_rec.classification_id
405: and tax_category = stu_rec.tax_category;
419: END IF;
420:
421:
422: --
423: insert into pay_taxability_rules
424: (jurisdiction_code
425: ,tax_type
426: ,tax_category
427: ,classification_id
455:
456: BEGIN
457:
458: --
459: -- If any rows in pay_taxability_rules do not deliver any rows
460: -- from hr_s_taxability_rules
461: --
462: -- Bug fix for bug no: 1618263
463: -- Added this code because it was not populating the records into pay_
462: -- Bug fix for bug no: 1618263
463: -- Added this code because it was not populating the records into pay_
464: -- taxability_rules table for legislation_code 'CA',
465: -- if there is another legislation_code data already
466: -- installed . Earlier the count(*) from pay_taxability_rules
467: -- will show the count irrespecitve of legislation_code and deletes the
468: -- hr_s_taxability_rules data and the 'stu' cursor will not
469: -- get executed.
470: /* Started code here for bug fix: 1618263 */
474: l_leg_code := legs.legislation_code;
475:
476: select count(*)
477: into l_num_rules
478: from pay_taxability_rules
479: where legislation_code = l_leg_code;
480:
481: /* End code here for bug fix: 1618263 */
482:
2387: hr_legislation.hrrunprc_trace_on;
2388: hr_utility.trace('start install_tax_rules: ' || to_char(p_phase));
2389: hr_legislation.hrrunprc_trace_off;
2390:
2391: install_tax_rules(p_phase); --install pay_taxability_rules
2392:
2393: hr_legislation.hrrunprc_trace_on;
2394: hr_utility.trace('start install_surcharges: ' || to_char(p_phase));
2395: hr_legislation.hrrunprc_trace_off;
2410: hr_legislation.hrrunprc_trace_on;
2411: hr_utility.trace('start install_tax_rules: ' || to_char(p_phase));
2412: hr_legislation.hrrunprc_trace_off;
2413:
2414: install_tax_rules(p_phase); -- install pay_taxability_rules
2415: --
2416: END IF;
2417: --
2418: IF driving_legislation = 'GB' THEN