APPS.PAY_CA_T4_XML dependencies on PAY_CA_ARCHIVE_UTILS

Line 367: pay_ca_archive_utils.get_archive_value(p_pa_id,

363: and paa.tax_unit_id = hou.organization_id;
364:
365: begin
366: lv_year :=
367: pay_ca_archive_utils.get_archive_value(p_pa_id,
368: 'CAEOY_TAXATION_YEAR'); -- year
369:
370: lv_employer_name :=
371: pay_ca_archive_utils.get_archive_value(p_pa_id,

Line 371: pay_ca_archive_utils.get_archive_value(p_pa_id,

367: pay_ca_archive_utils.get_archive_value(p_pa_id,
368: 'CAEOY_TAXATION_YEAR'); -- year
369:
370: lv_employer_name :=
371: pay_ca_archive_utils.get_archive_value(p_pa_id,
372: 'CAEOY_EMPLOYER_NAME'); -- employer name
373:
374: if p_print = 'Y' then
375:

Line 377: pay_ca_archive_utils.get_archive_value(p_pa_id,

373:
374: if p_print = 'Y' then
375:
376: lv_employer_address1 :=
377: pay_ca_archive_utils.get_archive_value(p_pa_id,
378: 'CAEOY_EMPLOYER_ADDRESS_LINE1'); -- employer address1
379:
380: lv_employer_address2 :=
381: pay_ca_archive_utils.get_archive_value(p_pa_id,

Line 381: pay_ca_archive_utils.get_archive_value(p_pa_id,

377: pay_ca_archive_utils.get_archive_value(p_pa_id,
378: 'CAEOY_EMPLOYER_ADDRESS_LINE1'); -- employer address1
379:
380: lv_employer_address2 :=
381: pay_ca_archive_utils.get_archive_value(p_pa_id,
382: 'CAEOY_EMPLOYER_ADDRESS_LINE2'); -- employer address2
383:
384: lv_employer_address3 :=
385: pay_ca_archive_utils.get_archive_value(p_pa_id,

Line 385: pay_ca_archive_utils.get_archive_value(p_pa_id,

381: pay_ca_archive_utils.get_archive_value(p_pa_id,
382: 'CAEOY_EMPLOYER_ADDRESS_LINE2'); -- employer address2
383:
384: lv_employer_address3 :=
385: pay_ca_archive_utils.get_archive_value(p_pa_id,
386: 'CAEOY_EMPLOYER_ADDRESS_LINE3'); -- employer address3
387:
388: lv_employer_city :=
389: pay_ca_archive_utils.get_archive_value(p_pa_id,

Line 389: pay_ca_archive_utils.get_archive_value(p_pa_id,

385: pay_ca_archive_utils.get_archive_value(p_pa_id,
386: 'CAEOY_EMPLOYER_ADDRESS_LINE3'); -- employer address3
387:
388: lv_employer_city :=
389: pay_ca_archive_utils.get_archive_value(p_pa_id,
390: 'CAEOY_EMPLOYER_CITY'); -- employer_city
391:
392: lv_employer_province :=
393: pay_ca_archive_utils.get_archive_value(p_pa_id,

Line 393: pay_ca_archive_utils.get_archive_value(p_pa_id,

389: pay_ca_archive_utils.get_archive_value(p_pa_id,
390: 'CAEOY_EMPLOYER_CITY'); -- employer_city
391:
392: lv_employer_province :=
393: pay_ca_archive_utils.get_archive_value(p_pa_id,
394: 'CAEOY_EMPLOYER_PROVINCE'); -- employer_province
395:
396: lv_employer_country :=
397: pay_ca_archive_utils.get_archive_value(p_pa_id,

Line 397: pay_ca_archive_utils.get_archive_value(p_pa_id,

393: pay_ca_archive_utils.get_archive_value(p_pa_id,
394: 'CAEOY_EMPLOYER_PROVINCE'); -- employer_province
395:
396: lv_employer_country :=
397: pay_ca_archive_utils.get_archive_value(p_pa_id,
398: 'CAEOY_EMPLOYER_COUNTRY'); -- employer_country
399:
400: lv_employer_postal_code :=
401: pay_ca_archive_utils.get_archive_value(p_pa_id,

Line 401: pay_ca_archive_utils.get_archive_value(p_pa_id,

397: pay_ca_archive_utils.get_archive_value(p_pa_id,
398: 'CAEOY_EMPLOYER_COUNTRY'); -- employer_country
399:
400: lv_employer_postal_code :=
401: pay_ca_archive_utils.get_archive_value(p_pa_id,
402: 'CAEOY_EMPLOYER_POSTAL_CODE'); -- employer_postal_code
403:
404:
405: if ((lv_employer_address2 is null) and

Line 431: pay_ca_archive_utils.get_archive_value(p_pa_id,

427:
428: if p_type = 'T4ERPAPER' then
429:
430: lv_employer_business_no :=
431: pay_ca_archive_utils.get_archive_value(p_pa_id,
432: 'CAEOY_EMPLOYER_IDENTIFICATION_NUMBER'); -- business number
433: end if;
434:
435: lv_sin :=

Line 436: pay_ca_archive_utils.get_archive_value(p_aa_id,

432: 'CAEOY_EMPLOYER_IDENTIFICATION_NUMBER'); -- business number
433: end if;
434:
435: lv_sin :=
436: pay_ca_archive_utils.get_archive_value(p_aa_id,
437: 'CAEOY_EMPLOYEE_SIN'); -- sin
438:
439: -- changes started for bug 6434602
440: if lv_sin is null then

Line 448: substr(pay_ca_archive_utils.get_archive_value(p_aa_id,

444: lv_sin := ltrim(rtrim(replace(lv_sin, ' ')));
445: lv_sin := substr(lv_sin,1,3)||' '||substr(lv_sin,4,3)||' '||substr(lv_sin,7,3);
446:
447: lv_employee_name :=
448: substr(pay_ca_archive_utils.get_archive_value(p_aa_id,
449: 'CAEOY_EMPLOYEE_FIRST_NAME'),1,15); -- employee_name
450:
451: lv_employee_initial :=
452: pay_ca_archive_utils.get_archive_value(p_aa_id,

Line 452: pay_ca_archive_utils.get_archive_value(p_aa_id,

448: substr(pay_ca_archive_utils.get_archive_value(p_aa_id,
449: 'CAEOY_EMPLOYEE_FIRST_NAME'),1,15); -- employee_name
450:
451: lv_employee_initial :=
452: pay_ca_archive_utils.get_archive_value(p_aa_id,
453: 'CAEOY_EMPLOYEE_INITIAL'); -- employee_initial
454:
455: if lv_employee_initial is not null then
456: lv_employee_initial := upper(substr(lv_employee_initial,1,1));

Line 460: upper(pay_ca_archive_utils.get_archive_value(p_aa_id,

456: lv_employee_initial := upper(substr(lv_employee_initial,1,1));
457: end if;
458:
459: lv_employee_last_name :=
460: upper(pay_ca_archive_utils.get_archive_value(p_aa_id,
461: 'CAEOY_EMPLOYEE_LAST_NAME')); -- employee_last_name
462:
463:
464: lv_person_id := to_number(pay_ca_archive_utils.get_archive_value(p_aa_id,

Line 464: lv_person_id := to_number(pay_ca_archive_utils.get_archive_value(p_aa_id,

460: upper(pay_ca_archive_utils.get_archive_value(p_aa_id,
461: 'CAEOY_EMPLOYEE_LAST_NAME')); -- employee_last_name
462:
463:
464: lv_person_id := to_number(pay_ca_archive_utils.get_archive_value(p_aa_id,
465: 'CAEOY_PERSON_ID'));
466:
467: address := pay_ca_rl1_reg.get_primary_address(lv_person_id, sysdate());
468:

Line 493: pay_ca_archive_utils.get_archive_value(p_aa_id, p_prov,

489: end if;
490:
491:
492: lv_cpp_qpp_exempt :=
493: pay_ca_archive_utils.get_archive_value(p_aa_id, p_prov,
494: 'JURISDICTION_CODE',
495: 'CAEOY_CPP_QPP_EXEMPT'); -- cpp_qpp_exempt
496:
497: lv_ei_exempt :=

Line 498: pay_ca_archive_utils.get_archive_value(p_aa_id, p_prov,

494: 'JURISDICTION_CODE',
495: 'CAEOY_CPP_QPP_EXEMPT'); -- cpp_qpp_exempt
496:
497: lv_ei_exempt :=
498: pay_ca_archive_utils.get_archive_value(p_aa_id, p_prov,
499: 'JURISDICTION_CODE',
500: 'CAEOY_EI_EXEMPT'); -- ei_exempt
501:
502:

Line 504: pay_ca_archive_utils.get_archive_value(p_aa_id, p_prov,

500: 'CAEOY_EI_EXEMPT'); -- ei_exempt
501:
502:
503: lv_employment_code :=
504: pay_ca_archive_utils.get_archive_value(p_aa_id, p_prov,
505: 'JURISDICTION_CODE',
506: 'CAEOY_EMPLOYMENT_CODE'); -- employment_code
507:
508: lv_rpp_dpsp_reg_no :=

Line 509: pay_ca_archive_utils.get_archive_value(p_aa_id,

505: 'JURISDICTION_CODE',
506: 'CAEOY_EMPLOYMENT_CODE'); -- employment_code
507:
508: lv_rpp_dpsp_reg_no :=
509: pay_ca_archive_utils.get_archive_value(p_aa_id,
510: 'CAEOY_T4_EMPLOYEE_REGISTRATION_NO'); -- rpp_dpsp_reg_no
511:
512: lv_employment_income :=
513: pay_ca_archive_utils.get_archive_value(p_aa_id,p_prov,

Line 513: pay_ca_archive_utils.get_archive_value(p_aa_id,p_prov,

509: pay_ca_archive_utils.get_archive_value(p_aa_id,
510: 'CAEOY_T4_EMPLOYEE_REGISTRATION_NO'); -- rpp_dpsp_reg_no
511:
512: lv_employment_income :=
513: pay_ca_archive_utils.get_archive_value(p_aa_id,p_prov,
514: 'JURISDICTION_CODE',
515: 'CAEOY_GROSS_EARNINGS_PER_JD_GRE_YTD'); -- employment_income
516:
517: if to_number(lv_employment_income) = 0 then

Line 522: pay_ca_archive_utils.get_archive_value(p_aa_id, p_prov,

518: lv_employment_income := null;
519: end if;
520:
521: lv_income_tax_deducted :=
522: pay_ca_archive_utils.get_archive_value(p_aa_id, p_prov,
523: 'JURISDICTION_CODE',
524: 'CAEOY_FED_WITHHELD_PER_JD_GRE_YTD'); -- income_tax_deducted
525:
526: if to_number(lv_income_tax_deducted) = 0 then

Line 531: pay_ca_archive_utils.get_archive_value(p_aa_id, p_prov,

527: lv_income_tax_deducted := null;
528: end if;
529:
530: lv_employees_cpp :=
531: pay_ca_archive_utils.get_archive_value(p_aa_id, p_prov,
532: 'JURISDICTION_CODE',
533: 'CAEOY_CPP_EE_WITHHELD_PER_JD_GRE_YTD'); -- employees_cpp
534:
535: if to_number(lv_employees_cpp) = 0 then

Line 540: pay_ca_archive_utils.get_archive_value(p_aa_id, p_prov,

536: lv_employees_cpp := null;
537: end if;
538:
539: lv_employees_qpp :=
540: pay_ca_archive_utils.get_archive_value(p_aa_id, p_prov,
541: 'JURISDICTION_CODE',
542: 'CAEOY_QPP_EE_WITHHELD_PER_JD_GRE_YTD'); -- employees_qpp
543:
544: if to_number(lv_employees_qpp) = 0 then

Line 549: pay_ca_archive_utils.get_archive_value(p_aa_id, p_prov,

545: lv_employees_qpp := null;
546: end if;
547:
548: lv_employees_ei :=
549: pay_ca_archive_utils.get_archive_value(p_aa_id, p_prov,
550: 'JURISDICTION_CODE',
551: 'CAEOY_EI_EE_WITHHELD_PER_JD_GRE_YTD'); -- employees_ei
552:
553: if to_number(lv_employees_ei) = 0 then

Line 561: pay_ca_archive_utils.get_archive_value(p_aa_id, p_prov,

557: /* Added by ssmukher for including PPIP taxes */
558: if p_prov = 'QC' then
559:
560: lv_ppip_exempt :=
561: pay_ca_archive_utils.get_archive_value(p_aa_id, p_prov,
562: 'JURISDICTION_CODE',
563: 'CAEOY_PPIP_EXEMPT'); -- ppip_exempt
564:
565: lv_employees_ppip :=

Line 566: pay_ca_archive_utils.get_archive_value(p_aa_id, p_prov,

562: 'JURISDICTION_CODE',
563: 'CAEOY_PPIP_EXEMPT'); -- ppip_exempt
564:
565: lv_employees_ppip :=
566: pay_ca_archive_utils.get_archive_value(p_aa_id, p_prov,
567: 'JURISDICTION_CODE',
568: 'CAEOY_PPIP_EE_WITHHELD_PER_JD_GRE_YTD'); -- employees_ppip
569:
570: if to_number(lv_employees_ppip) = 0 then

Line 580: pay_ca_archive_utils.get_archive_value(p_aa_id, p_prov,

576: into lv_max_ppip_earning;
577: close cur_max_ppip_earning;
578:
579: lv_ppip_insurable_earnings :=
580: pay_ca_archive_utils.get_archive_value(p_aa_id, p_prov,
581: 'JURISDICTION_CODE',
582: 'CAEOY_PPIP_EE_TAXABLE_PER_JD_GRE_YTD'); -- ppip_insurable_earnings
583:
584: -- commented by sneelapa for bug 6434613

Line 628: pay_ca_archive_utils.get_archive_value(p_aa_id, p_prov,

624: lv_ppip_insurable_earnings := null;
625: end if;
626:
627: lv_rpp_contribution :=
628: pay_ca_archive_utils.get_archive_value(p_aa_id, p_prov,
629: 'JURISDICTION_CODE',
630: 'CAEOY_T4_BOX20_PER_JD_GRE_YTD'); -- rpp_contribution
631:
632: if to_number(lv_rpp_contribution) = 0 then

Line 637: pay_ca_archive_utils.get_archive_value(p_aa_id, p_prov,

633: lv_rpp_contribution := null;
634: end if;
635:
636: lv_pension_adjustment :=
637: pay_ca_archive_utils.get_archive_value(p_aa_id, p_prov,
638: 'JURISDICTION_CODE',
639: 'CAEOY_T4_BOX52_PER_JD_GRE_YTD'); -- pension_adjustment
640:
641: if to_number(lv_pension_adjustment) = 0 then

Line 646: pay_ca_archive_utils.get_archive_value(p_aa_id, p_prov,

642: lv_pension_adjustment := null;
643: end if;
644:
645: lv_ei_insurable_earnings :=
646: pay_ca_archive_utils.get_archive_value(p_aa_id, p_prov,
647: 'JURISDICTION_CODE',
648: 'CAEOY_EI_EE_TAXABLE_PER_JD_GRE_YTD'); -- ei_insurable_earnings
649:
650: open cur_max_ei_earning;

Line 670: pay_ca_archive_utils.get_archive_value(p_aa_id, p_prov,

666:
667: if p_prov = 'QC' then
668:
669: lv_cpp_qpp_earnings :=
670: pay_ca_archive_utils.get_archive_value(p_aa_id, p_prov,
671: 'JURISDICTION_CODE',
672: 'CAEOY_QPP_EE_TAXABLE_PER_JD_GRE_YTD');
673: else
674: lv_cpp_qpp_earnings :=

Line 675: pay_ca_archive_utils.get_archive_value(p_aa_id, p_prov,

671: 'JURISDICTION_CODE',
672: 'CAEOY_QPP_EE_TAXABLE_PER_JD_GRE_YTD');
673: else
674: lv_cpp_qpp_earnings :=
675: pay_ca_archive_utils.get_archive_value(p_aa_id, p_prov,
676: 'JURISDICTION_CODE',
677: 'CAEOY_CPP_EE_TAXABLE_PER_JD_GRE_YTD');
678: end if;
679:

Line 697: pay_ca_archive_utils.get_archive_value(p_aa_id, p_prov,

693:
694: end if;
695:
696: lv_union_dues :=
697: pay_ca_archive_utils.get_archive_value(p_aa_id, p_prov,
698: 'JURISDICTION_CODE',
699: 'CAEOY_T4_BOX44_PER_JD_GRE_YTD'); -- union_dues
700:
701: if to_number(lv_union_dues) = 0 then

Line 706: pay_ca_archive_utils.get_archive_value(p_aa_id, p_prov,

702: lv_union_dues := null;
703: end if;
704:
705: lv_charitable_donations :=
706: pay_ca_archive_utils.get_archive_value(p_aa_id, p_prov,
707: 'JURISDICTION_CODE',
708: 'CAEOY_T4_BOX46_PER_JD_GRE_YTD'); -- charitable_donations
709:
710: if to_number(lv_charitable_donations) = 0 then