APPS.PAY_CA_EOY_RL2_ARCHIVE dependencies on PAY_CA_EOY_RL2_ARCHIVE

Line 1: package body pay_ca_eoy_rl2_archive as

1: package body pay_ca_eoy_rl2_archive as
2: /* $Header: pycarl2a.pkb 120.19.12020000.5 2013/01/02 10:21:57 sbachu ship $ */
3:
4: /*
5: Copyright (c) Oracle Corporation 1991,1992,1993. All rights reserved

Line 441: if pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data.count > 0 then

437: If p_data = 'EMPLOYEE_DATA' then
438:
439: hr_utility.trace('deleting plsql table'|| p_data);
440:
441: if pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data.count > 0 then
442: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data.delete;
443: end if;
444:
445: if pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data.count > 0 then

Line 442: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data.delete;

438:
439: hr_utility.trace('deleting plsql table'|| p_data);
440:
441: if pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data.count > 0 then
442: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data.delete;
443: end if;
444:
445: if pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data.count > 0 then
446: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data.delete;

Line 445: if pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data.count > 0 then

441: if pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data.count > 0 then
442: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data.delete;
443: end if;
444:
445: if pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data.count > 0 then
446: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data.delete;
447: end if;
448:
449: if pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data2.count > 0 then

Line 446: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data.delete;

442: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data.delete;
443: end if;
444:
445: if pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data.count > 0 then
446: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data.delete;
447: end if;
448:
449: if pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data2.count > 0 then
450: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data2.delete;

Line 449: if pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data2.count > 0 then

445: if pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data.count > 0 then
446: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data.delete;
447: end if;
448:
449: if pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data2.count > 0 then
450: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data2.delete;
451: end if;
452:
453: End if;

Line 450: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data2.delete;

446: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data.delete;
447: end if;
448:
449: if pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data2.count > 0 then
450: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data2.delete;
451: end if;
452:
453: End if;
454:

Line 459: if pay_ca_eoy_rl2_archive.ltr_ppa_arch_data.count > 0 then

455: If p_data = 'PRE_DATA' then
456:
457: hr_utility.trace('deleting plsql table'|| p_data);
458:
459: if pay_ca_eoy_rl2_archive.ltr_ppa_arch_data.count > 0 then
460: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data.delete;
461: end if;
462:
463: if pay_ca_eoy_rl2_archive.ltr_ppa_arch_er_data.count > 0 then

Line 460: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data.delete;

456:
457: hr_utility.trace('deleting plsql table'|| p_data);
458:
459: if pay_ca_eoy_rl2_archive.ltr_ppa_arch_data.count > 0 then
460: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data.delete;
461: end if;
462:
463: if pay_ca_eoy_rl2_archive.ltr_ppa_arch_er_data.count > 0 then
464: pay_ca_eoy_rl2_archive.ltr_ppa_arch_er_data.delete;

Line 463: if pay_ca_eoy_rl2_archive.ltr_ppa_arch_er_data.count > 0 then

459: if pay_ca_eoy_rl2_archive.ltr_ppa_arch_data.count > 0 then
460: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data.delete;
461: end if;
462:
463: if pay_ca_eoy_rl2_archive.ltr_ppa_arch_er_data.count > 0 then
464: pay_ca_eoy_rl2_archive.ltr_ppa_arch_er_data.delete;
465: end if;
466:
467: End if;

Line 464: pay_ca_eoy_rl2_archive.ltr_ppa_arch_er_data.delete;

460: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data.delete;
461: end if;
462:
463: if pay_ca_eoy_rl2_archive.ltr_ppa_arch_er_data.count > 0 then
464: pay_ca_eoy_rl2_archive.ltr_ppa_arch_er_data.delete;
465: end if;
466:
467: End if;
468:

Line 486: ,p_tab_rec_data in pay_ca_eoy_rl2_archive.action_info_table

482: ,p_action_context_type in varchar2
483: ,p_assignment_id in number
484: ,p_tax_unit_id in number
485: ,p_effective_date in date
486: ,p_tab_rec_data in pay_ca_eoy_rl2_archive.action_info_table
487: )
488:
489: IS
490: l_action_information_id_1 NUMBER ;

Line 893: l_user_entity_name_tab pay_ca_eoy_rl2_archive.char240_data_type_table;

889: l_effective_end_date date;
890: l_object_version_number number;
891: l_some_warning boolean;
892: l_counter number;
893: l_user_entity_name_tab pay_ca_eoy_rl2_archive.char240_data_type_table;
894: l_user_entity_value_tab pay_ca_eoy_rl2_archive.char240_data_type_table;
895: l_user_entity_name varchar2(240);
896:
897: /* Variables used to hold the values used as bind variables within the

Line 894: l_user_entity_value_tab pay_ca_eoy_rl2_archive.char240_data_type_table;

890: l_object_version_number number;
891: l_some_warning boolean;
892: l_counter number;
893: l_user_entity_name_tab pay_ca_eoy_rl2_archive.char240_data_type_table;
894: l_user_entity_value_tab pay_ca_eoy_rl2_archive.char240_data_type_table;
895: l_user_entity_name varchar2(240);
896:
897: /* Variables used to hold the values used as bind variables within the
898: SQL statement. */

Line 1427: l_seq_tab pay_ca_eoy_rl2_archive.number_data_type_table;

1423: l_value varchar2(240);
1424: l_sit_uid number;
1425: l_sui_uid number;
1426: l_fips_uid number;
1427: l_seq_tab pay_ca_eoy_rl2_archive.number_data_type_table;
1428: l_context_id_tab pay_ca_eoy_rl2_archive.number_data_type_table;
1429: l_context_val_tab pay_ca_eoy_rl2_archive.char240_data_type_table;
1430: l_user_entity_name_tab pay_ca_eoy_rl2_archive.char240_data_type_table;
1431: l_user_entity_value_tab pay_ca_eoy_rl2_archive.char240_data_type_table;

Line 1428: l_context_id_tab pay_ca_eoy_rl2_archive.number_data_type_table;

1424: l_sit_uid number;
1425: l_sui_uid number;
1426: l_fips_uid number;
1427: l_seq_tab pay_ca_eoy_rl2_archive.number_data_type_table;
1428: l_context_id_tab pay_ca_eoy_rl2_archive.number_data_type_table;
1429: l_context_val_tab pay_ca_eoy_rl2_archive.char240_data_type_table;
1430: l_user_entity_name_tab pay_ca_eoy_rl2_archive.char240_data_type_table;
1431: l_user_entity_value_tab pay_ca_eoy_rl2_archive.char240_data_type_table;
1432: l_arch_gre_step number := 0;

Line 1429: l_context_val_tab pay_ca_eoy_rl2_archive.char240_data_type_table;

1425: l_sui_uid number;
1426: l_fips_uid number;
1427: l_seq_tab pay_ca_eoy_rl2_archive.number_data_type_table;
1428: l_context_id_tab pay_ca_eoy_rl2_archive.number_data_type_table;
1429: l_context_val_tab pay_ca_eoy_rl2_archive.char240_data_type_table;
1430: l_user_entity_name_tab pay_ca_eoy_rl2_archive.char240_data_type_table;
1431: l_user_entity_value_tab pay_ca_eoy_rl2_archive.char240_data_type_table;
1432: l_arch_gre_step number := 0;
1433: l_archive_item_id number;

Line 1430: l_user_entity_name_tab pay_ca_eoy_rl2_archive.char240_data_type_table;

1426: l_fips_uid number;
1427: l_seq_tab pay_ca_eoy_rl2_archive.number_data_type_table;
1428: l_context_id_tab pay_ca_eoy_rl2_archive.number_data_type_table;
1429: l_context_val_tab pay_ca_eoy_rl2_archive.char240_data_type_table;
1430: l_user_entity_name_tab pay_ca_eoy_rl2_archive.char240_data_type_table;
1431: l_user_entity_value_tab pay_ca_eoy_rl2_archive.char240_data_type_table;
1432: l_arch_gre_step number := 0;
1433: l_archive_item_id number;
1434: l_town_or_city varchar2(240);

Line 1431: l_user_entity_value_tab pay_ca_eoy_rl2_archive.char240_data_type_table;

1427: l_seq_tab pay_ca_eoy_rl2_archive.number_data_type_table;
1428: l_context_id_tab pay_ca_eoy_rl2_archive.number_data_type_table;
1429: l_context_val_tab pay_ca_eoy_rl2_archive.char240_data_type_table;
1430: l_user_entity_name_tab pay_ca_eoy_rl2_archive.char240_data_type_table;
1431: l_user_entity_value_tab pay_ca_eoy_rl2_archive.char240_data_type_table;
1432: l_arch_gre_step number := 0;
1433: l_archive_item_id number;
1434: l_town_or_city varchar2(240);
1435: l_province_code varchar2(240);

Line 1656: ln_index := pay_ca_eoy_rl2_archive.ltr_ppa_arch_data.count;

1652:
1653:
1654: /* archive Releve 2 data */
1655:
1656: ln_index := pay_ca_eoy_rl2_archive.ltr_ppa_arch_data.count;
1657: ln_index2 := pay_ca_eoy_rl2_archive.ltr_ppa_arch_er_data.count;
1658:
1659: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).action_info_category
1660: := 'CAEOY TRANSMITTER INFO';

Line 1657: ln_index2 := pay_ca_eoy_rl2_archive.ltr_ppa_arch_er_data.count;

1653:
1654: /* archive Releve 2 data */
1655:
1656: ln_index := pay_ca_eoy_rl2_archive.ltr_ppa_arch_data.count;
1657: ln_index2 := pay_ca_eoy_rl2_archive.ltr_ppa_arch_er_data.count;
1658:
1659: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).action_info_category
1660: := 'CAEOY TRANSMITTER INFO';
1661:

Line 1659: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).action_info_category

1655:
1656: ln_index := pay_ca_eoy_rl2_archive.ltr_ppa_arch_data.count;
1657: ln_index2 := pay_ca_eoy_rl2_archive.ltr_ppa_arch_er_data.count;
1658:
1659: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).action_info_category
1660: := 'CAEOY TRANSMITTER INFO';
1661:
1662: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).jurisdiction_code
1663: := null;

Line 1662: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).jurisdiction_code

1658:
1659: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).action_info_category
1660: := 'CAEOY TRANSMITTER INFO';
1661:
1662: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).jurisdiction_code
1663: := null;
1664:
1665: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info1
1666: := 'RL2';

Line 1665: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info1

1661:
1662: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).jurisdiction_code
1663: := null;
1664:
1665: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info1
1666: := 'RL2';
1667:
1668: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info2
1669: := l_employer_ein;

Line 1668: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info2

1664:
1665: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info1
1666: := 'RL2';
1667:
1668: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info2
1669: := l_employer_ein;
1670:
1671: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info3
1672: := l_transmitter_number;

Line 1671: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info3

1667:
1668: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info2
1669: := l_employer_ein;
1670:
1671: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info3
1672: := l_transmitter_number;
1673:
1674: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info4
1675: := l_rl_data_type;

Line 1674: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info4

1670:
1671: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info3
1672: := l_transmitter_number;
1673:
1674: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info4
1675: := l_rl_data_type;
1676:
1677: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info5
1678: := l_rl_package_type;

Line 1677: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info5

1673:
1674: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info4
1675: := l_rl_data_type;
1676:
1677: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info5
1678: := l_rl_package_type;
1679:
1680: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info6
1681: := l_Transmitter_Type_Indicator;

Line 1680: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info6

1676:
1677: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info5
1678: := l_rl_package_type;
1679:
1680: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info6
1681: := l_Transmitter_Type_Indicator;
1682:
1683: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info7
1684: := l_rl_source_of_slips;

Line 1683: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info7

1679:
1680: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info6
1681: := l_Transmitter_Type_Indicator;
1682:
1683: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info7
1684: := l_rl_source_of_slips;
1685:
1686: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info8
1687: := l_taxation_year;

Line 1686: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info8

1682:
1683: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info7
1684: := l_rl_source_of_slips;
1685:
1686: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info8
1687: := l_taxation_year;
1688:
1689: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info9
1690: := l_transmitter_country;

Line 1689: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info9

1685:
1686: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info8
1687: := l_taxation_year;
1688:
1689: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info9
1690: := l_transmitter_country;
1691:
1692: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info10
1693: := l_transmitter_name;

Line 1692: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info10

1688:
1689: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info9
1690: := l_transmitter_country;
1691:
1692: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info10
1693: := l_transmitter_name;
1694:
1695: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info11
1696: := l_transmitter_addr_line_1;

Line 1695: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info11

1691:
1692: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info10
1693: := l_transmitter_name;
1694:
1695: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info11
1696: := l_transmitter_addr_line_1;
1697:
1698: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info12
1699: := l_transmitter_addr_line_2;

Line 1698: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info12

1694:
1695: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info11
1696: := l_transmitter_addr_line_1;
1697:
1698: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info12
1699: := l_transmitter_addr_line_2;
1700:
1701: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info13
1702: := l_transmitter_addr_line_3;

Line 1701: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info13

1697:
1698: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info12
1699: := l_transmitter_addr_line_2;
1700:
1701: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info13
1702: := l_transmitter_addr_line_3;
1703:
1704: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info14
1705: := l_transmitter_city;

Line 1704: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info14

1700:
1701: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info13
1702: := l_transmitter_addr_line_3;
1703:
1704: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info14
1705: := l_transmitter_city;
1706:
1707: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info15
1708: := l_transmitter_province;

Line 1707: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info15

1703:
1704: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info14
1705: := l_transmitter_city;
1706:
1707: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info15
1708: := l_transmitter_province;
1709:
1710: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info16
1711: := l_transmitter_postal_code;

Line 1710: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info16

1706:
1707: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info15
1708: := l_transmitter_province;
1709:
1710: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info16
1711: := l_transmitter_postal_code;
1712:
1713: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info17
1714: := l_technical_contact_name;

Line 1713: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info17

1709:
1710: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info16
1711: := l_transmitter_postal_code;
1712:
1713: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info17
1714: := l_technical_contact_name;
1715:
1716: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info18
1717: := l_technical_contact_area_code;

Line 1716: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info18

1712:
1713: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info17
1714: := l_technical_contact_name;
1715:
1716: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info18
1717: := l_technical_contact_area_code;
1718:
1719: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info19
1720: := l_technical_contact_phone;

Line 1719: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info19

1715:
1716: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info18
1717: := l_technical_contact_area_code;
1718:
1719: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info19
1720: := l_technical_contact_phone;
1721:
1722: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info20
1723: := l_technical_contact_extension;

Line 1722: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info20

1718:
1719: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info19
1720: := l_technical_contact_phone;
1721:
1722: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info20
1723: := l_technical_contact_extension;
1724:
1725: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info21
1726: := l_technical_contact_language;

Line 1725: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info21

1721:
1722: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info20
1723: := l_technical_contact_extension;
1724:
1725: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info21
1726: := l_technical_contact_language;
1727:
1728: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info22
1729: := l_accounting_contact_name;

Line 1728: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info22

1724:
1725: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info21
1726: := l_technical_contact_language;
1727:
1728: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info22
1729: := l_accounting_contact_name;
1730:
1731: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info23
1732: := l_accounting_contact_area_code;

Line 1731: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info23

1727:
1728: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info22
1729: := l_accounting_contact_name;
1730:
1731: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info23
1732: := l_accounting_contact_area_code;
1733:
1734: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info24
1735: := l_accounting_contact_phone ;

Line 1734: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info24

1730:
1731: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info23
1732: := l_accounting_contact_area_code;
1733:
1734: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info24
1735: := l_accounting_contact_phone ;
1736:
1737: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info25
1738: := l_accounting_contact_extension;

Line 1737: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info25

1733:
1734: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info24
1735: := l_accounting_contact_phone ;
1736:
1737: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info25
1738: := l_accounting_contact_extension;
1739:
1740: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info26
1741: := l_accounting_contact_language;

Line 1740: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info26

1736:
1737: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info25
1738: := l_accounting_contact_extension;
1739:
1740: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info26
1741: := l_accounting_contact_language;
1742:
1743: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info27
1744: := p_pre_org_id;

Line 1743: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info27

1739:
1740: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info26
1741: := l_accounting_contact_language;
1742:
1743: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info27
1744: := p_pre_org_id;
1745:
1746: /* Archive Employer Data */
1747: pay_ca_eoy_rl2_archive.ltr_ppa_arch_er_data(ln_index2).action_info_category

Line 1747: pay_ca_eoy_rl2_archive.ltr_ppa_arch_er_data(ln_index2).action_info_category

1743: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info27
1744: := p_pre_org_id;
1745:
1746: /* Archive Employer Data */
1747: pay_ca_eoy_rl2_archive.ltr_ppa_arch_er_data(ln_index2).action_info_category
1748: := 'CAEOY EMPLOYER INFO';
1749:
1750: pay_ca_eoy_rl2_archive.ltr_ppa_arch_er_data(ln_index2).jurisdiction_code
1751: := null;

Line 1750: pay_ca_eoy_rl2_archive.ltr_ppa_arch_er_data(ln_index2).jurisdiction_code

1746: /* Archive Employer Data */
1747: pay_ca_eoy_rl2_archive.ltr_ppa_arch_er_data(ln_index2).action_info_category
1748: := 'CAEOY EMPLOYER INFO';
1749:
1750: pay_ca_eoy_rl2_archive.ltr_ppa_arch_er_data(ln_index2).jurisdiction_code
1751: := null;
1752:
1753: pay_ca_eoy_rl2_archive.ltr_ppa_arch_er_data(ln_index2).act_info1
1754: := 'RL2';

Line 1753: pay_ca_eoy_rl2_archive.ltr_ppa_arch_er_data(ln_index2).act_info1

1749:
1750: pay_ca_eoy_rl2_archive.ltr_ppa_arch_er_data(ln_index2).jurisdiction_code
1751: := null;
1752:
1753: pay_ca_eoy_rl2_archive.ltr_ppa_arch_er_data(ln_index2).act_info1
1754: := 'RL2';
1755:
1756: pay_ca_eoy_rl2_archive.ltr_ppa_arch_er_data(ln_index2).act_info2
1757: := l_name;

Line 1756: pay_ca_eoy_rl2_archive.ltr_ppa_arch_er_data(ln_index2).act_info2

1752:
1753: pay_ca_eoy_rl2_archive.ltr_ppa_arch_er_data(ln_index2).act_info1
1754: := 'RL2';
1755:
1756: pay_ca_eoy_rl2_archive.ltr_ppa_arch_er_data(ln_index2).act_info2
1757: := l_name;
1758:
1759: pay_ca_eoy_rl2_archive.ltr_ppa_arch_er_data(ln_index2).act_info3
1760: := l_address_line_1;

Line 1759: pay_ca_eoy_rl2_archive.ltr_ppa_arch_er_data(ln_index2).act_info3

1755:
1756: pay_ca_eoy_rl2_archive.ltr_ppa_arch_er_data(ln_index2).act_info2
1757: := l_name;
1758:
1759: pay_ca_eoy_rl2_archive.ltr_ppa_arch_er_data(ln_index2).act_info3
1760: := l_address_line_1;
1761:
1762: pay_ca_eoy_rl2_archive.ltr_ppa_arch_er_data(ln_index2).act_info4
1763: := l_address_line_2;

Line 1762: pay_ca_eoy_rl2_archive.ltr_ppa_arch_er_data(ln_index2).act_info4

1758:
1759: pay_ca_eoy_rl2_archive.ltr_ppa_arch_er_data(ln_index2).act_info3
1760: := l_address_line_1;
1761:
1762: pay_ca_eoy_rl2_archive.ltr_ppa_arch_er_data(ln_index2).act_info4
1763: := l_address_line_2;
1764:
1765: pay_ca_eoy_rl2_archive.ltr_ppa_arch_er_data(ln_index2).act_info5
1766: := l_address_line_3;

Line 1765: pay_ca_eoy_rl2_archive.ltr_ppa_arch_er_data(ln_index2).act_info5

1761:
1762: pay_ca_eoy_rl2_archive.ltr_ppa_arch_er_data(ln_index2).act_info4
1763: := l_address_line_2;
1764:
1765: pay_ca_eoy_rl2_archive.ltr_ppa_arch_er_data(ln_index2).act_info5
1766: := l_address_line_3;
1767:
1768: pay_ca_eoy_rl2_archive.ltr_ppa_arch_er_data(ln_index2).act_info6
1769: := l_town_or_city;

Line 1768: pay_ca_eoy_rl2_archive.ltr_ppa_arch_er_data(ln_index2).act_info6

1764:
1765: pay_ca_eoy_rl2_archive.ltr_ppa_arch_er_data(ln_index2).act_info5
1766: := l_address_line_3;
1767:
1768: pay_ca_eoy_rl2_archive.ltr_ppa_arch_er_data(ln_index2).act_info6
1769: := l_town_or_city;
1770:
1771: pay_ca_eoy_rl2_archive.ltr_ppa_arch_er_data(ln_index2).act_info7
1772: := l_province_code;

Line 1771: pay_ca_eoy_rl2_archive.ltr_ppa_arch_er_data(ln_index2).act_info7

1767:
1768: pay_ca_eoy_rl2_archive.ltr_ppa_arch_er_data(ln_index2).act_info6
1769: := l_town_or_city;
1770:
1771: pay_ca_eoy_rl2_archive.ltr_ppa_arch_er_data(ln_index2).act_info7
1772: := l_province_code;
1773:
1774: pay_ca_eoy_rl2_archive.ltr_ppa_arch_er_data(ln_index2).act_info8
1775: := l_country_code;

Line 1774: pay_ca_eoy_rl2_archive.ltr_ppa_arch_er_data(ln_index2).act_info8

1770:
1771: pay_ca_eoy_rl2_archive.ltr_ppa_arch_er_data(ln_index2).act_info7
1772: := l_province_code;
1773:
1774: pay_ca_eoy_rl2_archive.ltr_ppa_arch_er_data(ln_index2).act_info8
1775: := l_country_code;
1776:
1777: pay_ca_eoy_rl2_archive.ltr_ppa_arch_er_data(ln_index2).act_info9
1778: := l_postal_code;

Line 1777: pay_ca_eoy_rl2_archive.ltr_ppa_arch_er_data(ln_index2).act_info9

1773:
1774: pay_ca_eoy_rl2_archive.ltr_ppa_arch_er_data(ln_index2).act_info8
1775: := l_country_code;
1776:
1777: pay_ca_eoy_rl2_archive.ltr_ppa_arch_er_data(ln_index2).act_info9
1778: := l_postal_code;
1779:
1780: l_arch_gre_step := 50;
1781: l_arch_gre_step := 51;

Line 1799: ,p_tab_rec_data => pay_ca_eoy_rl2_archive.ltr_ppa_arch_data);

1795: ,p_action_context_type=> 'PA'
1796: ,p_assignment_id => null
1797: ,p_tax_unit_id => null
1798: ,p_effective_date => l_effective_date
1799: ,p_tab_rec_data => pay_ca_eoy_rl2_archive.ltr_ppa_arch_data);
1800: end if;
1801:
1802: /* Inserting rows into pay_action_information table
1803: Employer Information (Could be just a PRE or Transmitter PRE) */

Line 1805: if pay_ca_eoy_rl2_archive.ltr_ppa_arch_er_data.count >0 then

1801:
1802: /* Inserting rows into pay_action_information table
1803: Employer Information (Could be just a PRE or Transmitter PRE) */
1804:
1805: if pay_ca_eoy_rl2_archive.ltr_ppa_arch_er_data.count >0 then
1806: hr_utility.trace('Archiving Employer Data');
1807: archive_data_records(
1808: p_action_context_id => p_payroll_action_id
1809: ,p_action_context_type=> 'PA'

Line 1813: ,p_tab_rec_data => pay_ca_eoy_rl2_archive.ltr_ppa_arch_er_data);

1809: ,p_action_context_type=> 'PA'
1810: ,p_assignment_id => null
1811: ,p_tax_unit_id => null
1812: ,p_effective_date => l_effective_date
1813: ,p_tab_rec_data => pay_ca_eoy_rl2_archive.ltr_ppa_arch_er_data);
1814: end if;
1815:
1816: EXCEPTION
1817: when others then

Line 1972: hr_utility.trace('In pay_ca_eoy_rl2_archive.gen_rl2_pdf_seq 10');

1968: l_act_info_id number;
1969:
1970: begin
1971:
1972: hr_utility.trace('In pay_ca_eoy_rl2_archive.gen_rl2_pdf_seq 10');
1973:
1974: if (called_from = 'XMLPROC') then
1975: hr_utility.trace('In pay_ca_eoy_rl2_archive.gen_rl2_pdf_seq 20');
1976: open c_get_arch_seq_num(p_aaid);

Line 1975: hr_utility.trace('In pay_ca_eoy_rl2_archive.gen_rl2_pdf_seq 20');

1971:
1972: hr_utility.trace('In pay_ca_eoy_rl2_archive.gen_rl2_pdf_seq 10');
1973:
1974: if (called_from = 'XMLPROC') then
1975: hr_utility.trace('In pay_ca_eoy_rl2_archive.gen_rl2_pdf_seq 20');
1976: open c_get_arch_seq_num(p_aaid);
1977: fetch c_get_arch_seq_num into l_final_seq_num,l_act_info_id,l_obj_ver;
1978: close c_get_arch_seq_num;
1979:

Line 1992: hr_utility.trace('In pay_ca_eoy_rl2_archive.gen_rl2_pdf_seq 30');

1988: fetch c_get_seq_num_range into l_start_seq_num,l_end_seq_num;
1989: close c_get_seq_num_range;
1990:
1991: if (l_start_seq_num is not null) then
1992: hr_utility.trace('In pay_ca_eoy_rl2_archive.gen_rl2_pdf_seq 30');
1993:
1994: select PAY_CA_RL2_PDF_SEQ_COUNT_S.nextval into l_seq_offset
1995: from dual;
1996: l_final_seq_num := getnext_seq_num(l_start_seq_num + l_seq_offset); --Bug 8500723

Line 2002: hr_utility.trace('In pay_ca_eoy_rl2_archive.gen_rl2_pdf_seq 40');

1998: l_final_seq_num := null;
1999: end if;
2000:
2001: if (called_from ='XMLPROC') then
2002: hr_utility.trace('In pay_ca_eoy_rl2_archive.gen_rl2_pdf_seq 40');
2003:
2004: pay_action_information_api.update_action_information(p_action_information_id=>l_act_info_id,
2005: p_object_version_number=>l_obj_ver,
2006: p_action_information3=>l_final_seq_num);

Line 2123: l_user_entity_name_tab pay_ca_eoy_rl2_archive.char240_data_type_table;

2119: l_negative_balance_exists varchar2(2);
2120: result number;
2121: l_rl2_tax_unit_id pay_assignment_actions.tax_unit_id%type;
2122: lv_serial_number varchar2(30);
2123: l_user_entity_name_tab pay_ca_eoy_rl2_archive.char240_data_type_table;
2124: l_balance_type_tab pay_ca_eoy_rl2_archive.char240_data_type_table;
2125: l_footnote_balance_type_tab varchar2(80);
2126: ln_further_index NUMBER;
2127:

Line 2124: l_balance_type_tab pay_ca_eoy_rl2_archive.char240_data_type_table;

2120: result number;
2121: l_rl2_tax_unit_id pay_assignment_actions.tax_unit_id%type;
2122: lv_serial_number varchar2(30);
2123: l_user_entity_name_tab pay_ca_eoy_rl2_archive.char240_data_type_table;
2124: l_balance_type_tab pay_ca_eoy_rl2_archive.char240_data_type_table;
2125: l_footnote_balance_type_tab varchar2(80);
2126: ln_further_index NUMBER;
2127:
2128:

Line 2319: if pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_further_data.count > 0 then

2315: l_balance_type_tab(l_count) := 'RL2_FURTHER_INFO_AMOUNT_C3';
2316:
2317: hr_utility.trace('Assignment action id is ' || to_char(p_assactid));
2318:
2319: if pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_further_data.count > 0 then
2320: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_further_data.delete;
2321: end if;
2322: ln_further_index := pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_further_data.count;
2323: for i in 1 .. l_count

Line 2320: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_further_data.delete;

2316:
2317: hr_utility.trace('Assignment action id is ' || to_char(p_assactid));
2318:
2319: if pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_further_data.count > 0 then
2320: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_further_data.delete;
2321: end if;
2322: ln_further_index := pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_further_data.count;
2323: for i in 1 .. l_count
2324: loop

Line 2322: ln_further_index := pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_further_data.count;

2318:
2319: if pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_further_data.count > 0 then
2320: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_further_data.delete;
2321: end if;
2322: ln_further_index := pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_further_data.count;
2323: for i in 1 .. l_count
2324: loop
2325: /* Get the context_id for 'Jurisdiction' from ff_contexts */
2326: if l_balance_type_tab(i) = 'RL2_FURTHER_INFO_AMOUNT_201' then

Line 2328: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_further_data

2324: loop
2325: /* Get the context_id for 'Jurisdiction' from ff_contexts */
2326: if l_balance_type_tab(i) = 'RL2_FURTHER_INFO_AMOUNT_201' then
2327: ln_further_index := ln_further_index+1;
2328: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_further_data
2329: (ln_further_index).action_info_category := 'CAEOY RL2 FURTHER INFO';
2330: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_further_data
2331: (ln_further_index).jurisdiction_code := 'QC';
2332: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_further_data

Line 2330: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_further_data

2326: if l_balance_type_tab(i) = 'RL2_FURTHER_INFO_AMOUNT_201' then
2327: ln_further_index := ln_further_index+1;
2328: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_further_data
2329: (ln_further_index).action_info_category := 'CAEOY RL2 FURTHER INFO';
2330: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_further_data
2331: (ln_further_index).jurisdiction_code := 'QC';
2332: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_further_data
2333: (ln_further_index).act_info4 := l_balance_type_tab(i);
2334: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_further_data

Line 2332: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_further_data

2328: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_further_data
2329: (ln_further_index).action_info_category := 'CAEOY RL2 FURTHER INFO';
2330: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_further_data
2331: (ln_further_index).jurisdiction_code := 'QC';
2332: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_further_data
2333: (ln_further_index).act_info4 := l_balance_type_tab(i);
2334: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_further_data
2335: (ln_further_index).act_info5 := substr(p_source_of_income_descr,1,15); -- 14701748
2336: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_further_data

Line 2334: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_further_data

2330: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_further_data
2331: (ln_further_index).jurisdiction_code := 'QC';
2332: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_further_data
2333: (ln_further_index).act_info4 := l_balance_type_tab(i);
2334: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_further_data
2335: (ln_further_index).act_info5 := substr(p_source_of_income_descr,1,15); -- 14701748
2336: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_further_data
2337: (ln_further_index).act_info6 := 'RL2';
2338: /*Bug 14701748 */

Line 2336: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_further_data

2332: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_further_data
2333: (ln_further_index).act_info4 := l_balance_type_tab(i);
2334: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_further_data
2335: (ln_further_index).act_info5 := substr(p_source_of_income_descr,1,15); -- 14701748
2336: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_further_data
2337: (ln_further_index).act_info6 := 'RL2';
2338: /*Bug 14701748 */
2339: if p_source_of_income_descr is not null then
2340: p_temp_fi := p_temp_fi +1;

Line 2392: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_further_data

2388: end;
2389: end loop;
2390: close c_all_gres;
2391: ln_further_index := ln_further_index+1;
2392: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_further_data
2393: (ln_further_index).action_info_category := 'CAEOY RL2 FURTHER INFO';
2394: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_further_data
2395: (ln_further_index).jurisdiction_code := 'QC';
2396: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_further_data

Line 2394: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_further_data

2390: close c_all_gres;
2391: ln_further_index := ln_further_index+1;
2392: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_further_data
2393: (ln_further_index).action_info_category := 'CAEOY RL2 FURTHER INFO';
2394: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_further_data
2395: (ln_further_index).jurisdiction_code := 'QC';
2396: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_further_data
2397: (ln_further_index).act_info4 := l_balance_type_tab(i);
2398: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_further_data

Line 2396: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_further_data

2392: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_further_data
2393: (ln_further_index).action_info_category := 'CAEOY RL2 FURTHER INFO';
2394: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_further_data
2395: (ln_further_index).jurisdiction_code := 'QC';
2396: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_further_data
2397: (ln_further_index).act_info4 := l_balance_type_tab(i);
2398: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_further_data
2399: (ln_further_index).act_info5 := to_char(result);
2400: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_further_data

Line 2398: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_further_data

2394: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_further_data
2395: (ln_further_index).jurisdiction_code := 'QC';
2396: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_further_data
2397: (ln_further_index).act_info4 := l_balance_type_tab(i);
2398: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_further_data
2399: (ln_further_index).act_info5 := to_char(result);
2400: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_further_data
2401: (ln_further_index).act_info6 := 'RL2';
2402: if result < 0 and l_negative_balance_exists <> 'Y' then

Line 2400: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_further_data

2396: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_further_data
2397: (ln_further_index).act_info4 := l_balance_type_tab(i);
2398: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_further_data
2399: (ln_further_index).act_info5 := to_char(result);
2400: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_further_data
2401: (ln_further_index).act_info6 := 'RL2';
2402: if result < 0 and l_negative_balance_exists <> 'Y' then
2403: l_negative_balance_exists := 'Y';
2404: end if;

Line 2414: if pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_further_data.count >0 then

2410: end if; --l_balance_type_tab(i) = 'RL2_FURTHER_INFO_AMOUNT_201'
2411: end loop;
2412:
2413:
2414: if pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_further_data.count >0 then
2415: archive_data_records(
2416: p_action_context_id => p_assactid
2417: ,p_action_context_type=> 'AAP'
2418: ,p_assignment_id => l_asgid

Line 2421: ,p_tab_rec_data => pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_further_data);

2417: ,p_action_context_type=> 'AAP'
2418: ,p_assignment_id => l_asgid
2419: ,p_tax_unit_id => l_rl2_tax_unit_id
2420: ,p_effective_date => p_effective_date
2421: ,p_tab_rec_data => pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_further_data);
2422: ln_further_index := null;
2423: end if;
2424: p_negative_balance_exists := l_negative_balance_exists;
2425: hr_utility.trace('End of Provincial YE Amendment PP Validation');

Line 2474: l_seq_tab pay_ca_eoy_rl2_archive.number_data_type_table;

2470: l_county_code varchar2(3);
2471: l_city_code varchar2(4);
2472: l_jursd_context_id ff_contexts.context_id%type;
2473: l_taxunit_context_id ff_contexts.context_id%type;
2474: l_seq_tab pay_ca_eoy_rl2_archive.number_data_type_table;
2475: l_context_id_tab pay_ca_eoy_rl2_archive.number_data_type_table;
2476: l_context_val_tab pay_ca_eoy_rl2_archive.char240_data_type_table;
2477: l_chunk number;
2478: l_payroll_action_id number;

Line 2475: l_context_id_tab pay_ca_eoy_rl2_archive.number_data_type_table;

2471: l_city_code varchar2(4);
2472: l_jursd_context_id ff_contexts.context_id%type;
2473: l_taxunit_context_id ff_contexts.context_id%type;
2474: l_seq_tab pay_ca_eoy_rl2_archive.number_data_type_table;
2475: l_context_id_tab pay_ca_eoy_rl2_archive.number_data_type_table;
2476: l_context_val_tab pay_ca_eoy_rl2_archive.char240_data_type_table;
2477: l_chunk number;
2478: l_payroll_action_id number;
2479: l_person_id number;

Line 2476: l_context_val_tab pay_ca_eoy_rl2_archive.char240_data_type_table;

2472: l_jursd_context_id ff_contexts.context_id%type;
2473: l_taxunit_context_id ff_contexts.context_id%type;
2474: l_seq_tab pay_ca_eoy_rl2_archive.number_data_type_table;
2475: l_context_id_tab pay_ca_eoy_rl2_archive.number_data_type_table;
2476: l_context_val_tab pay_ca_eoy_rl2_archive.char240_data_type_table;
2477: l_chunk number;
2478: l_payroll_action_id number;
2479: l_person_id number;
2480: l_defined_balance_id number;

Line 2528: l_user_entity_name_tab pay_ca_eoy_rl2_archive.char240_data_type_table;

2524: l_some_warning boolean;
2525: result number;
2526: l_no_of_payroll_run number := 0;
2527: l_has_been_paid varchar2(3);
2528: l_user_entity_name_tab pay_ca_eoy_rl2_archive.char240_data_type_table;
2529: l_user_entity_value_tab pay_ca_eoy_rl2_archive.char240_data_type_table;
2530: l_balance_type_tab pay_ca_eoy_rl2_archive.char240_data_type_table;
2531: l_footnote_balance_type_tab varchar2(80);
2532: l_footnote_code varchar2(30);

Line 2529: l_user_entity_value_tab pay_ca_eoy_rl2_archive.char240_data_type_table;

2525: result number;
2526: l_no_of_payroll_run number := 0;
2527: l_has_been_paid varchar2(3);
2528: l_user_entity_name_tab pay_ca_eoy_rl2_archive.char240_data_type_table;
2529: l_user_entity_value_tab pay_ca_eoy_rl2_archive.char240_data_type_table;
2530: l_balance_type_tab pay_ca_eoy_rl2_archive.char240_data_type_table;
2531: l_footnote_balance_type_tab varchar2(80);
2532: l_footnote_code varchar2(30);
2533: l_footnote_balance varchar2(80);

Line 2530: l_balance_type_tab pay_ca_eoy_rl2_archive.char240_data_type_table;

2526: l_no_of_payroll_run number := 0;
2527: l_has_been_paid varchar2(3);
2528: l_user_entity_name_tab pay_ca_eoy_rl2_archive.char240_data_type_table;
2529: l_user_entity_value_tab pay_ca_eoy_rl2_archive.char240_data_type_table;
2530: l_balance_type_tab pay_ca_eoy_rl2_archive.char240_data_type_table;
2531: l_footnote_balance_type_tab varchar2(80);
2532: l_footnote_code varchar2(30);
2533: l_footnote_balance varchar2(80);
2534: l_footnote_amount number;

Line 2599: l_fi_balance_type_tab pay_ca_eoy_rl2_archive.char240_data_type_table;

2595: lv_pre_pr_form_no varchar2(240);
2596:
2597: /*Bug 16045054 sbachu*/
2598: l_count_fi number := 0;
2599: l_fi_balance_type_tab pay_ca_eoy_rl2_archive.char240_data_type_table;
2600: l_fi_result number := 0;
2601:
2602: cursor c_get_fapp_locked_action_id(cp_locking_act_id number) is
2603: select locked_action_id

Line 3244: ln_index := pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data.count;

3240: end loop;
3241: /*Bug 16045054 ends here sbachu*/
3242: hr_utility.trace('l_no_of_payroll_run is ' || l_no_of_payroll_run);
3243:
3244: ln_index := pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data.count;
3245: ln_footnote_index := pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data.count;
3246:
3247: hr_utility.trace('ln_index :'||to_char(ln_index));
3248: hr_utility.trace('ln_footnote_index :'||to_char(ln_footnote_index));

Line 3245: ln_footnote_index := pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data.count;

3241: /*Bug 16045054 ends here sbachu*/
3242: hr_utility.trace('l_no_of_payroll_run is ' || l_no_of_payroll_run);
3243:
3244: ln_index := pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data.count;
3245: ln_footnote_index := pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data.count;
3246:
3247: hr_utility.trace('ln_index :'||to_char(ln_index));
3248: hr_utility.trace('ln_footnote_index :'||to_char(ln_footnote_index));
3249:

Line 3254: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info1

3250: if ((l_no_of_payroll_run > 0) and
3251: ((l_has_been_paid = 'Y') or (ln_no_gross_earnings <> 0)) ) then
3252:
3253: /* Removed from here 14701748
3254: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info1
3255: := gen_rl2_slip_no(l_transmitter_id,l_asgid);*/
3256: for i in 1 .. l_count
3257: loop
3258:

Line 3269: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info3

3265: */
3266:
3267: if l_balance_type_tab(i) =
3268: 'Life Annuity Payments registered plan' then
3269: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info3
3270: := l_user_entity_value_tab(i);
3271: hr_utility.trace('ln_index :'||to_char(ln_index));
3272:
3273: elsif l_balance_type_tab(i) =

Line 3276: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info3

3272:
3273: elsif l_balance_type_tab(i) =
3274: 'Life Annuity Payments Unregistered plan' then
3275:
3276: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info3
3277: := to_number
3278: (pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info3)
3279: + to_number(nvl(l_user_entity_value_tab(i),0));
3280:

Line 3278: (pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info3)

3274: 'Life Annuity Payments Unregistered plan' then
3275:
3276: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info3
3277: := to_number
3278: (pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info3)
3279: + to_number(nvl(l_user_entity_value_tab(i),0));
3280:
3281: elsif l_balance_type_tab(i) =
3282: 'Benefits from RRSP RRIF DPSP and Annuities' then

Line 3283: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info4

3279: + to_number(nvl(l_user_entity_value_tab(i),0));
3280:
3281: elsif l_balance_type_tab(i) =
3282: 'Benefits from RRSP RRIF DPSP and Annuities' then
3283: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info4
3284: := l_user_entity_value_tab(i);
3285:
3286: elsif l_balance_type_tab(i) = 'Other Payments' then
3287: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info5

Line 3287: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info5

3283: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info4
3284: := l_user_entity_value_tab(i);
3285:
3286: elsif l_balance_type_tab(i) = 'Other Payments' then
3287: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info5
3288: := l_user_entity_value_tab(i);
3289: hr_utility.trace('Box C :'||pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info5);
3290:
3291: elsif l_balance_type_tab(i) =

Line 3289: hr_utility.trace('Box C :'||pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info5);

3285:
3286: elsif l_balance_type_tab(i) = 'Other Payments' then
3287: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info5
3288: := l_user_entity_value_tab(i);
3289: hr_utility.trace('Box C :'||pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info5);
3290:
3291: elsif l_balance_type_tab(i) =
3292: 'Refund of RRSP Premiums paid to surviving spouse' then
3293: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info6

Line 3293: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info6

3289: hr_utility.trace('Box C :'||pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info5);
3290:
3291: elsif l_balance_type_tab(i) =
3292: 'Refund of RRSP Premiums paid to surviving spouse' then
3293: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info6
3294: := l_user_entity_value_tab(i);
3295:
3296: elsif l_balance_type_tab(i) = 'Benefits at the time of death' then
3297: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info7

Line 3297: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info7

3293: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info6
3294: := l_user_entity_value_tab(i);
3295:
3296: elsif l_balance_type_tab(i) = 'Benefits at the time of death' then
3297: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info7
3298: := l_user_entity_value_tab(i);
3299:
3300: elsif l_balance_type_tab(i) =
3301: 'Refund of Undeducted RRSP contributions' then

Line 3302: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info8

3298: := l_user_entity_value_tab(i);
3299:
3300: elsif l_balance_type_tab(i) =
3301: 'Refund of Undeducted RRSP contributions' then
3302: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info8
3303: := l_user_entity_value_tab(i);
3304:
3305: elsif l_balance_type_tab(i) =
3306: 'Taxable Amount revoked registration RRSP or RRIF' then

Line 3307: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info9

3303: := l_user_entity_value_tab(i);
3304:
3305: elsif l_balance_type_tab(i) =
3306: 'Taxable Amount revoked registration RRSP or RRIF' then
3307: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info9
3308: := l_user_entity_value_tab(i);
3309:
3310: elsif l_balance_type_tab(i) = 'Other Income RRSP or RRIF' then
3311: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info10

Line 3311: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info10

3307: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info9
3308: := l_user_entity_value_tab(i);
3309:
3310: elsif l_balance_type_tab(i) = 'Other Income RRSP or RRIF' then
3311: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info10
3312: := l_user_entity_value_tab(i);
3313:
3314: elsif l_balance_type_tab(i) =
3315: 'Amount entitlement deduction for RRSP or RRIF' then

Line 3316: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info11

3312: := l_user_entity_value_tab(i);
3313:
3314: elsif l_balance_type_tab(i) =
3315: 'Amount entitlement deduction for RRSP or RRIF' then
3316: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info11
3317: := l_user_entity_value_tab(i);
3318:
3319: elsif l_balance_type_tab(i) = 'PROV Withheld' then
3320: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info12

Line 3320: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info12

3316: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info11
3317: := l_user_entity_value_tab(i);
3318:
3319: elsif l_balance_type_tab(i) = 'PROV Withheld' then
3320: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info12
3321: := l_user_entity_value_tab(i);
3322:
3323: elsif l_balance_type_tab(i) =
3324: 'Income earned after death RRSP or RRIF' then

Line 3325: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info13

3321: := l_user_entity_value_tab(i);
3322:
3323: elsif l_balance_type_tab(i) =
3324: 'Income earned after death RRSP or RRIF' then
3325: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info13
3326: := l_user_entity_value_tab(i);
3327:
3328: elsif l_balance_type_tab(i) =
3329: 'Withdrawal under the Lifelong Learning Plan' then

Line 3341: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info14

3337: if to_number(l_user_entity_value_tab(i)) > to_number(lv_boxL_Maxlimit) then
3338:
3339: lv_BoxL_excess_amt := to_char(to_number(l_user_entity_value_tab(i))
3340: - to_number(lv_boxL_Maxlimit)) ;
3341: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info14
3342: := lv_boxL_Maxlimit;
3343: else
3344: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info14
3345: := l_user_entity_value_tab(i);

Line 3344: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info14

3340: - to_number(lv_boxL_Maxlimit)) ;
3341: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info14
3342: := lv_boxL_Maxlimit;
3343: else
3344: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info14
3345: := l_user_entity_value_tab(i);
3346: end if;
3347:
3348: elsif l_balance_type_tab(i) = 'Tax Paid Amounts' then

Line 3349: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info15

3345: := l_user_entity_value_tab(i);
3346: end if;
3347:
3348: elsif l_balance_type_tab(i) = 'Tax Paid Amounts' then
3349: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info15
3350: := l_user_entity_value_tab(i);
3351:
3352: elsif l_balance_type_tab(i)
3353: = 'Withdrawal under the Home Buyers Plan' then

Line 3365: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info17

3361: if to_number(l_user_entity_value_tab(i)) > to_number(lv_boxO_Maxlimit) then
3362:
3363: lv_BoxO_excess_amt := to_char(to_number(l_user_entity_value_tab(i))
3364: - to_number(lv_boxO_Maxlimit));
3365: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info17
3366: := lv_boxO_Maxlimit;
3367: else
3368: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info17
3369: := l_user_entity_value_tab(i);

Line 3368: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info17

3364: - to_number(lv_boxO_Maxlimit));
3365: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info17
3366: := lv_boxO_Maxlimit;
3367: else
3368: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info17
3369: := l_user_entity_value_tab(i);
3370: end if;
3371:
3372: end if;

Line 3399: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data

3395: ln_footnote_index := ln_footnote_index;
3396: hr_utility.trace(' Box A ln_footnote_index :'
3397: ||to_char(ln_footnote_index));
3398:
3399: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data
3400: (ln_footnote_index).action_info_category := 'CA FOOTNOTES';
3401: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data
3402: (ln_footnote_index).jurisdiction_code := 'QC';
3403: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data

Line 3401: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data

3397: ||to_char(ln_footnote_index));
3398:
3399: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data
3400: (ln_footnote_index).action_info_category := 'CA FOOTNOTES';
3401: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data
3402: (ln_footnote_index).jurisdiction_code := 'QC';
3403: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data
3404: (ln_footnote_index).act_info4 := l_footnote_code;
3405: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data

Line 3403: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data

3399: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data
3400: (ln_footnote_index).action_info_category := 'CA FOOTNOTES';
3401: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data
3402: (ln_footnote_index).jurisdiction_code := 'QC';
3403: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data
3404: (ln_footnote_index).act_info4 := l_footnote_code;
3405: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data
3406: (ln_footnote_index).act_info5 :=
3407: to_char(l_footnote_amount);

Line 3405: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data

3401: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data
3402: (ln_footnote_index).jurisdiction_code := 'QC';
3403: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data
3404: (ln_footnote_index).act_info4 := l_footnote_code;
3405: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data
3406: (ln_footnote_index).act_info5 :=
3407: to_char(l_footnote_amount);
3408: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data
3409: (ln_footnote_index).act_info6 := 'RL2';

Line 3408: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data

3404: (ln_footnote_index).act_info4 := l_footnote_code;
3405: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data
3406: (ln_footnote_index).act_info5 :=
3407: to_char(l_footnote_amount);
3408: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data
3409: (ln_footnote_index).act_info6 := 'RL2';
3410:
3411: if l_footnote_amount < 0 then
3412:

Line 3465: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data

3461: ln_footnote_index := ln_footnote_index + 1;
3462: hr_utility.trace('old_l_ftcode ln_footnote_index :'
3463: ||to_char(ln_footnote_index));
3464:
3465: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data
3466: (ln_footnote_index).action_info_category
3467: := 'CA FOOTNOTES';
3468:
3469: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data

Line 3469: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data

3465: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data
3466: (ln_footnote_index).action_info_category
3467: := 'CA FOOTNOTES';
3468:
3469: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data
3470: (ln_footnote_index).jurisdiction_code := 'QC';
3471:
3472: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data
3473: (ln_footnote_index).act_info4

Line 3472: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data

3468:
3469: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data
3470: (ln_footnote_index).jurisdiction_code := 'QC';
3471:
3472: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data
3473: (ln_footnote_index).act_info4
3474: := old_l_footnote_code;
3475:
3476: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data

Line 3476: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data

3472: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data
3473: (ln_footnote_index).act_info4
3474: := old_l_footnote_code;
3475:
3476: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data
3477: (ln_footnote_index).act_info5
3478: := to_char(l_footnote_amount);
3479:
3480: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data

Line 3480: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data

3476: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data
3477: (ln_footnote_index).act_info5
3478: := to_char(l_footnote_amount);
3479:
3480: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data
3481: (ln_footnote_index).act_info6 := 'RL2';
3482:
3483: if l_footnote_amount < 0 then
3484:

Line 3590: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data

3586: ln_footnote_index := ln_footnote_index + 1;
3587: hr_utility.trace('after close c_footnote_info ln_footnote_index :'
3588: ||to_char(ln_footnote_index));
3589:
3590: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data
3591: (ln_footnote_index).action_info_category := 'CA FOOTNOTES';
3592: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data
3593: (ln_footnote_index).jurisdiction_code := 'QC';
3594: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data

Line 3592: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data

3588: ||to_char(ln_footnote_index));
3589:
3590: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data
3591: (ln_footnote_index).action_info_category := 'CA FOOTNOTES';
3592: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data
3593: (ln_footnote_index).jurisdiction_code := 'QC';
3594: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data
3595: (ln_footnote_index).act_info4 := l_footnote_code;
3596: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data

Line 3594: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data

3590: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data
3591: (ln_footnote_index).action_info_category := 'CA FOOTNOTES';
3592: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data
3593: (ln_footnote_index).jurisdiction_code := 'QC';
3594: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data
3595: (ln_footnote_index).act_info4 := l_footnote_code;
3596: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data
3597: (ln_footnote_index).act_info5 := to_char(l_footnote_amount);
3598: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data

Line 3596: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data

3592: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data
3593: (ln_footnote_index).jurisdiction_code := 'QC';
3594: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data
3595: (ln_footnote_index).act_info4 := l_footnote_code;
3596: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data
3597: (ln_footnote_index).act_info5 := to_char(l_footnote_amount);
3598: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data
3599: (ln_footnote_index).act_info6 := 'RL2';
3600:

Line 3598: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data

3594: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data
3595: (ln_footnote_index).act_info4 := l_footnote_code;
3596: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data
3597: (ln_footnote_index).act_info5 := to_char(l_footnote_amount);
3598: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data
3599: (ln_footnote_index).act_info6 := 'RL2';
3600:
3601: if l_footnote_amount < 0 then
3602:

Line 3623: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info5

3619: hr_utility.trace('lv_BoxL_excess_amt : '||lv_BoxL_excess_amt);
3620: hr_utility.trace('lv_BoxO_excess_amt : '||lv_BoxO_excess_amt);
3621:
3622: if ((lv_BoxL_Excess_amt > 0) or (lv_BoxO_Excess_amt > 0)) then
3623: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info5
3624: := to_char(NVL(to_number(pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info5),0)
3625: + to_number(lv_BoxL_excess_amt) + to_number(lv_BoxO_excess_amt));
3626: hr_utility.trace('Box C : '||pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info5);
3627: end if;

Line 3624: := to_char(NVL(to_number(pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info5),0)

3620: hr_utility.trace('lv_BoxO_excess_amt : '||lv_BoxO_excess_amt);
3621:
3622: if ((lv_BoxL_Excess_amt > 0) or (lv_BoxO_Excess_amt > 0)) then
3623: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info5
3624: := to_char(NVL(to_number(pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info5),0)
3625: + to_number(lv_BoxL_excess_amt) + to_number(lv_BoxO_excess_amt));
3626: hr_utility.trace('Box C : '||pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info5);
3627: end if;
3628:

Line 3626: hr_utility.trace('Box C : '||pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info5);

3622: if ((lv_BoxL_Excess_amt > 0) or (lv_BoxO_Excess_amt > 0)) then
3623: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info5
3624: := to_char(NVL(to_number(pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info5),0)
3625: + to_number(lv_BoxL_excess_amt) + to_number(lv_BoxO_excess_amt));
3626: hr_utility.trace('Box C : '||pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info5);
3627: end if;
3628:
3629: /* Commented out for Bug 15997380
3630: Set the Negative Balance Flag for Archiving

Line 3631: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info30

3627: end if;
3628:
3629: /* Commented out for Bug 15997380
3630: Set the Negative Balance Flag for Archiving
3631: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info30
3632: := l_negative_balance_exists; */
3633:
3634: hr_utility.trace('after loop act_info4 is: '
3635: || pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info4);

Line 3635: || pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info4);

3631: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info30
3632: := l_negative_balance_exists; */
3633:
3634: hr_utility.trace('after loop act_info4 is: '
3635: || pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info4);
3636:
3637: end if; /* end if for ((l_no_of_payroll_run >0) and (l_has_been_paid='Y'))*/
3638:
3639: -- Need to Archive Non-Box Footnotes, will be done next year

Line 3735: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data

3731: ln_footnote_index := ln_footnote_index + 1;
3732: hr_utility.trace('Archiving Source of Income Other as Footnote ln_footnote_index :'
3733: ||to_char(ln_footnote_index));
3734:
3735: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data
3736: (ln_footnote_index).action_info_category := 'CA FOOTNOTES';
3737: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data
3738: (ln_footnote_index).jurisdiction_code := 'QC';
3739: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data

Line 3737: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data

3733: ||to_char(ln_footnote_index));
3734:
3735: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data
3736: (ln_footnote_index).action_info_category := 'CA FOOTNOTES';
3737: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data
3738: (ln_footnote_index).jurisdiction_code := 'QC';
3739: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data
3740: (ln_footnote_index).act_info4 := l_rl2_source_of_income;
3741: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data

Line 3739: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data

3735: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data
3736: (ln_footnote_index).action_info_category := 'CA FOOTNOTES';
3737: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data
3738: (ln_footnote_index).jurisdiction_code := 'QC';
3739: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data
3740: (ln_footnote_index).act_info4 := l_rl2_source_of_income;
3741: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data
3742: (ln_footnote_index).act_info5 := '0';
3743: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data

Line 3741: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data

3737: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data
3738: (ln_footnote_index).jurisdiction_code := 'QC';
3739: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data
3740: (ln_footnote_index).act_info4 := l_rl2_source_of_income;
3741: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data
3742: (ln_footnote_index).act_info5 := '0';
3743: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data
3744: (ln_footnote_index).act_info6 := 'RL2';
3745: else

Line 3743: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data

3739: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data
3740: (ln_footnote_index).act_info4 := l_rl2_source_of_income;
3741: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data
3742: (ln_footnote_index).act_info5 := '0';
3743: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data
3744: (ln_footnote_index).act_info6 := 'RL2';
3745: else
3746: l_rl2_source_of_income := l_per_eit_source_of_income;
3747: end if;

Line 3758: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data

3754: ln_footnote_index := ln_footnote_index + 1;
3755: hr_utility.trace('Archiving Source of Income Other as Footnote ln_footnote_index :'
3756: ||to_char(ln_footnote_index));
3757:
3758: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data
3759: (ln_footnote_index).action_info_category := 'CA FOOTNOTES';
3760: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data
3761: (ln_footnote_index).jurisdiction_code := 'QC';
3762: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data

Line 3760: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data

3756: ||to_char(ln_footnote_index));
3757:
3758: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data
3759: (ln_footnote_index).action_info_category := 'CA FOOTNOTES';
3760: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data
3761: (ln_footnote_index).jurisdiction_code := 'QC';
3762: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data
3763: (ln_footnote_index).act_info4 := l_rl2_source_of_income;
3764: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data

Line 3762: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data

3758: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data
3759: (ln_footnote_index).action_info_category := 'CA FOOTNOTES';
3760: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data
3761: (ln_footnote_index).jurisdiction_code := 'QC';
3762: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data
3763: (ln_footnote_index).act_info4 := l_rl2_source_of_income;
3764: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data
3765: (ln_footnote_index).act_info5 := '0';
3766: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data

Line 3764: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data

3760: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data
3761: (ln_footnote_index).jurisdiction_code := 'QC';
3762: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data
3763: (ln_footnote_index).act_info4 := l_rl2_source_of_income;
3764: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data
3765: (ln_footnote_index).act_info5 := '0';
3766: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data
3767: (ln_footnote_index).act_info6 := 'RL2';
3768: else

Line 3766: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data

3762: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data
3763: (ln_footnote_index).act_info4 := l_rl2_source_of_income;
3764: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data
3765: (ln_footnote_index).act_info5 := '0';
3766: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data
3767: (ln_footnote_index).act_info6 := 'RL2';
3768: else
3769: l_rl2_source_of_income := l_pre_source_of_income;
3770: end if;

Line 3775: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).action_info_category

3771: end if;
3772:
3773: hr_utility.trace('Before counter of asgid '|| l_asgid);
3774:
3775: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).action_info_category
3776: := 'CAEOY RL2 EMPLOYEE INFO';
3777:
3778: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).jurisdiction_code
3779: := l_jurisdiction;

Line 3778: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).jurisdiction_code

3774:
3775: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).action_info_category
3776: := 'CAEOY RL2 EMPLOYEE INFO';
3777:
3778: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).jurisdiction_code
3779: := l_jurisdiction;
3780:
3781: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info2
3782: := l_rl2_source_of_income;

Line 3781: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info2

3777:
3778: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).jurisdiction_code
3779: := l_jurisdiction;
3780:
3781: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info2
3782: := l_rl2_source_of_income;
3783:
3784: -- RL2 Box N SIN of Spouse
3785: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info16

Line 3785: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info16

3781: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info2
3782: := l_rl2_source_of_income;
3783:
3784: -- RL2 Box N SIN of Spouse
3785: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info16
3786: := l_beneficiary_sin;
3787:
3788: hr_utility.trace('Employee Info ln_index: '||to_char(ln_index));
3789: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info18

Line 3789: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info18

3785: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info16
3786: := l_beneficiary_sin;
3787:
3788: hr_utility.trace('Employee Info ln_index: '||to_char(ln_index));
3789: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info18
3790: := l_first_name;
3791:
3792: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info20
3793: := l_last_name ;

Line 3792: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info20

3788: hr_utility.trace('Employee Info ln_index: '||to_char(ln_index));
3789: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info18
3790: := l_first_name;
3791:
3792: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info20
3793: := l_last_name ;
3794:
3795: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info19
3796: := l_middle_name ;

Line 3795: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info19

3791:
3792: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info20
3793: := l_last_name ;
3794:
3795: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info19
3796: := l_middle_name ;
3797:
3798: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info28
3799: := l_national_identifier;

Line 3798: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info28

3794:
3795: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info19
3796: := l_middle_name ;
3797:
3798: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info28
3799: := l_national_identifier;
3800:
3801: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info29
3802: := l_employee_number;

Line 3801: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info29

3797:
3798: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info28
3799: := l_national_identifier;
3800:
3801: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info29
3802: := l_employee_number;
3803:
3804: end if;
3805:

Line 3836: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info1

3832: end loop;
3833: end if;
3834: end if;
3835:
3836: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info1
3837: := l_rl2_slip_number;
3838:
3839:
3840:

Line 3881: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info21

3877: end if; /* c_get_pri_addr%NOTFOUND */
3878: close c_get_pri_addr;
3879: end;
3880:
3881: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info21
3882: := l_address_line1;
3883:
3884: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info22
3885: := l_address_line2;

Line 3884: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info22

3880:
3881: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info21
3882: := l_address_line1;
3883:
3884: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info22
3885: := l_address_line2;
3886:
3887: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info23
3888: := l_address_line3;

Line 3887: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info23

3883:
3884: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info22
3885: := l_address_line2;
3886:
3887: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info23
3888: := l_address_line3;
3889:
3890: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info24
3891: := l_town_or_city;

Line 3890: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info24

3886:
3887: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info23
3888: := l_address_line3;
3889:
3890: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info24
3891: := l_town_or_city;
3892:
3893: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info25
3894: := l_province_code;

Line 3893: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info25

3889:
3890: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info24
3891: := l_town_or_city;
3892:
3893: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info25
3894: := l_province_code;
3895:
3896: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info27
3897: := l_country_code;

Line 3896: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info27

3892:
3893: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info25
3894: := l_province_code;
3895:
3896: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info27
3897: := l_country_code;
3898:
3899: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info26
3900: := l_postal_code;

Line 3899: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info26

3895:
3896: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info27
3897: := l_country_code;
3898:
3899: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info26
3900: := l_postal_code;
3901:
3902: /* Set the Negative Balance Flag for Archiving */
3903: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info30

Line 3903: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info30

3899: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info26
3900: := l_postal_code;
3901:
3902: /* Set the Negative Balance Flag for Archiving */
3903: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info30
3904: := l_negative_balance_exists;
3905:
3906: end if;
3907:

Line 3911: if pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data.count >0 then

3907:
3908: /* Inserting rows into pay_action_information table
3909: RL2 Employee Data Archived */
3910:
3911: if pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data.count >0 then
3912: archive_data_records(
3913: p_action_context_id => p_assactid
3914: ,p_action_context_type=> 'AAP'
3915: ,p_assignment_id => l_asgid

Line 3918: ,p_tab_rec_data => pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data);

3914: ,p_action_context_type=> 'AAP'
3915: ,p_assignment_id => l_asgid
3916: ,p_tax_unit_id => l_rl2_tax_unit_id
3917: ,p_effective_date => p_effective_date
3918: ,p_tab_rec_data => pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data);
3919: ln_index := null;
3920: end if;
3921:
3922: if pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data.count >0 then

Line 3922: if pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data.count >0 then

3918: ,p_tab_rec_data => pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data);
3919: ln_index := null;
3920: end if;
3921:
3922: if pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data.count >0 then
3923: archive_data_records(
3924: p_action_context_id => p_assactid
3925: ,p_action_context_type=> 'AAP'
3926: ,p_assignment_id => l_asgid

Line 3929: ,p_tab_rec_data => pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data);

3925: ,p_action_context_type=> 'AAP'
3926: ,p_assignment_id => l_asgid
3927: ,p_tax_unit_id => l_rl2_tax_unit_id
3928: ,p_effective_date => p_effective_date
3929: ,p_tab_rec_data => pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data);
3930: ln_footnote_index := null;
3931: end if;
3932:
3933: --hr_utility.trace_on('Y','SAM');

Line 3952: ln_index := pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data2.count;

3948:
3949: /* Archive the Pre-Printed form number for the RL2
3950: Amendment Pre-Process if one exists*/
3951:
3952: ln_index := pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data2.count;
3953:
3954: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data2(ln_index).action_info_category
3955: := 'CAEOY RL2 EMPLOYEE INFO2';
3956:

Line 3954: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data2(ln_index).action_info_category

3950: Amendment Pre-Process if one exists*/
3951:
3952: ln_index := pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data2.count;
3953:
3954: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data2(ln_index).action_info_category
3955: := 'CAEOY RL2 EMPLOYEE INFO2';
3956:
3957: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data2(ln_index).jurisdiction_code
3958: := l_jurisdiction;

Line 3957: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data2(ln_index).jurisdiction_code

3953:
3954: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data2(ln_index).action_info_category
3955: := 'CAEOY RL2 EMPLOYEE INFO2';
3956:
3957: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data2(ln_index).jurisdiction_code
3958: := l_jurisdiction;
3959:
3960: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data2(ln_index).act_info1
3961: := null;

Line 3960: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data2(ln_index).act_info1

3956:
3957: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data2(ln_index).jurisdiction_code
3958: := l_jurisdiction;
3959:
3960: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data2(ln_index).act_info1
3961: := null;
3962: l_k := 0;
3963: open c_get_preprinted_form_no (l_person_id, ln_fapp_pre_org_id);
3964: loop

Line 3982: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data2(ln_index).act_info1

3978: lv_pre_pr_form_no := lv_eit_form_no;
3979: else
3980: lv_pre_pr_form_no := lv_pre_pr_form_no || '|' || lv_eit_form_no;
3981: end if;
3982: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data2(ln_index).act_info1
3983: := lv_pre_pr_form_no;
3984: end if;
3985:
3986: end loop;

Line 3990: l_pre_printed_slip_no := pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data2(ln_index).act_info1;

3986: end loop;
3987:
3988: close c_get_preprinted_form_no;
3989: -- For Bug 8921055
3990: l_pre_printed_slip_no := pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data2(ln_index).act_info1;
3991:
3992: if lv_fapp_report_type = 'CAEOY_RL2_AMEND_PP' then
3993:
3994: open c_get_fapp_locked_action_id(p_assactid);

Line 4008: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data2(ln_index).act_info2

4004:
4005: end if; -- report type validation for FAPP
4006:
4007: hr_utility.trace('Archiving RL2 Amendment Flag : ' || lv_fapp_flag);
4008: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data2(ln_index).act_info2
4009: := lv_fapp_flag;
4010:
4011: l_rl2_seq_number := gen_rl2_pdf_seq(p_assactid,
4012: to_char(p_effective_date,'YYYY'),

Line 4034: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data2(ln_index).act_info3 := l_rl2_seq_number;

4030: end loop;
4031: end if;
4032: end if;
4033:
4034: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data2(ln_index).act_info3 := l_rl2_seq_number;
4035:
4036: if pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data2.count >0 then
4037: archive_data_records(
4038: p_action_context_id => p_assactid

Line 4036: if pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data2.count >0 then

4032: end if;
4033:
4034: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data2(ln_index).act_info3 := l_rl2_seq_number;
4035:
4036: if pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data2.count >0 then
4037: archive_data_records(
4038: p_action_context_id => p_assactid
4039: ,p_action_context_type=> 'AAP'
4040: ,p_assignment_id => l_asgid

Line 4043: ,p_tab_rec_data => pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data2);

4039: ,p_action_context_type=> 'AAP'
4040: ,p_assignment_id => l_asgid
4041: ,p_tax_unit_id => l_rl2_tax_unit_id
4042: ,p_effective_date => p_effective_date
4043: ,p_tab_rec_data => pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data2);
4044: ln_index := null;
4045: end if;
4046:
4047: hr_utility.trace('End of Provincial YE Amendment PP Validation');

Line 4134: end pay_ca_eoy_rl2_archive;

4130: hr_utility.trace('eoy_range_cursor archived employer data');
4131: end if;
4132:
4133: end eoy_range_cursor;
4134: end pay_ca_eoy_rl2_archive;