eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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.11 2006/08/28 22:18:03 meshah noship $ */
3:
4: /*
5: Copyright (c) Oracle Corporation 1991,1992,1993. All rights reserved

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

398: If p_data = 'EMPLOYEE_DATA' then
399:
400: hr_utility.trace('deleting plsql table'|| p_data);
401:
402: if pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data.count > 0 then
403: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data.delete;
404: end if;
405:
406: if pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data.count > 0 then

Line 403: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data.delete;

399:
400: hr_utility.trace('deleting plsql table'|| p_data);
401:
402: if pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data.count > 0 then
403: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data.delete;
404: end if;
405:
406: if pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data.count > 0 then
407: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data.delete;

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

402: if pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data.count > 0 then
403: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data.delete;
404: end if;
405:
406: if pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data.count > 0 then
407: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data.delete;
408: end if;
409:
410: if pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data2.count > 0 then

Line 407: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data.delete;

403: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data.delete;
404: end if;
405:
406: if pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data.count > 0 then
407: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data.delete;
408: end if;
409:
410: if pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data2.count > 0 then
411: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data2.delete;

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

406: if pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data.count > 0 then
407: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data.delete;
408: end if;
409:
410: if pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data2.count > 0 then
411: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data2.delete;
412: end if;
413:
414: End if;

Line 411: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data2.delete;

407: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data.delete;
408: end if;
409:
410: if pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data2.count > 0 then
411: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data2.delete;
412: end if;
413:
414: End if;
415:

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

416: If p_data = 'PRE_DATA' then
417:
418: hr_utility.trace('deleting plsql table'|| p_data);
419:
420: if pay_ca_eoy_rl2_archive.ltr_ppa_arch_data.count > 0 then
421: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data.delete;
422: end if;
423:
424: if pay_ca_eoy_rl2_archive.ltr_ppa_arch_er_data.count > 0 then

Line 421: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data.delete;

417:
418: hr_utility.trace('deleting plsql table'|| p_data);
419:
420: if pay_ca_eoy_rl2_archive.ltr_ppa_arch_data.count > 0 then
421: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data.delete;
422: end if;
423:
424: if pay_ca_eoy_rl2_archive.ltr_ppa_arch_er_data.count > 0 then
425: pay_ca_eoy_rl2_archive.ltr_ppa_arch_er_data.delete;

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

420: if pay_ca_eoy_rl2_archive.ltr_ppa_arch_data.count > 0 then
421: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data.delete;
422: end if;
423:
424: if pay_ca_eoy_rl2_archive.ltr_ppa_arch_er_data.count > 0 then
425: pay_ca_eoy_rl2_archive.ltr_ppa_arch_er_data.delete;
426: end if;
427:
428: End if;

Line 425: pay_ca_eoy_rl2_archive.ltr_ppa_arch_er_data.delete;

421: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data.delete;
422: end if;
423:
424: if pay_ca_eoy_rl2_archive.ltr_ppa_arch_er_data.count > 0 then
425: pay_ca_eoy_rl2_archive.ltr_ppa_arch_er_data.delete;
426: end if;
427:
428: End if;
429:

Line 447: ,p_tab_rec_data in pay_ca_eoy_rl2_archive.action_info_table

443: ,p_action_context_type in varchar2
444: ,p_assignment_id in number
445: ,p_tax_unit_id in number
446: ,p_effective_date in date
447: ,p_tab_rec_data in pay_ca_eoy_rl2_archive.action_info_table
448: )
449:
450: IS
451: l_action_information_id_1 NUMBER ;

Line 834: l_user_entity_name_tab pay_ca_eoy_rl2_archive.char240_data_type_table;

830: l_effective_end_date date;
831: l_object_version_number number;
832: l_some_warning boolean;
833: l_counter number;
834: l_user_entity_name_tab pay_ca_eoy_rl2_archive.char240_data_type_table;
835: l_user_entity_value_tab pay_ca_eoy_rl2_archive.char240_data_type_table;
836: l_user_entity_name varchar2(240);
837:
838: /* Variables used to hold the values used as bind variables within the

Line 835: l_user_entity_value_tab pay_ca_eoy_rl2_archive.char240_data_type_table;

831: l_object_version_number number;
832: l_some_warning boolean;
833: l_counter number;
834: l_user_entity_name_tab pay_ca_eoy_rl2_archive.char240_data_type_table;
835: l_user_entity_value_tab pay_ca_eoy_rl2_archive.char240_data_type_table;
836: l_user_entity_name varchar2(240);
837:
838: /* Variables used to hold the values used as bind variables within the
839: SQL statement. */

Line 1257: l_seq_tab pay_ca_eoy_rl2_archive.number_data_type_table;

1253: l_value varchar2(240);
1254: l_sit_uid number;
1255: l_sui_uid number;
1256: l_fips_uid number;
1257: l_seq_tab pay_ca_eoy_rl2_archive.number_data_type_table;
1258: l_context_id_tab pay_ca_eoy_rl2_archive.number_data_type_table;
1259: l_context_val_tab pay_ca_eoy_rl2_archive.char240_data_type_table;
1260: l_user_entity_name_tab pay_ca_eoy_rl2_archive.char240_data_type_table;
1261: l_user_entity_value_tab pay_ca_eoy_rl2_archive.char240_data_type_table;

Line 1258: l_context_id_tab pay_ca_eoy_rl2_archive.number_data_type_table;

1254: l_sit_uid number;
1255: l_sui_uid number;
1256: l_fips_uid number;
1257: l_seq_tab pay_ca_eoy_rl2_archive.number_data_type_table;
1258: l_context_id_tab pay_ca_eoy_rl2_archive.number_data_type_table;
1259: l_context_val_tab pay_ca_eoy_rl2_archive.char240_data_type_table;
1260: l_user_entity_name_tab pay_ca_eoy_rl2_archive.char240_data_type_table;
1261: l_user_entity_value_tab pay_ca_eoy_rl2_archive.char240_data_type_table;
1262: l_arch_gre_step number := 0;

Line 1259: l_context_val_tab pay_ca_eoy_rl2_archive.char240_data_type_table;

1255: l_sui_uid number;
1256: l_fips_uid number;
1257: l_seq_tab pay_ca_eoy_rl2_archive.number_data_type_table;
1258: l_context_id_tab pay_ca_eoy_rl2_archive.number_data_type_table;
1259: l_context_val_tab pay_ca_eoy_rl2_archive.char240_data_type_table;
1260: l_user_entity_name_tab pay_ca_eoy_rl2_archive.char240_data_type_table;
1261: l_user_entity_value_tab pay_ca_eoy_rl2_archive.char240_data_type_table;
1262: l_arch_gre_step number := 0;
1263: l_archive_item_id number;

Line 1260: l_user_entity_name_tab pay_ca_eoy_rl2_archive.char240_data_type_table;

1256: l_fips_uid number;
1257: l_seq_tab pay_ca_eoy_rl2_archive.number_data_type_table;
1258: l_context_id_tab pay_ca_eoy_rl2_archive.number_data_type_table;
1259: l_context_val_tab pay_ca_eoy_rl2_archive.char240_data_type_table;
1260: l_user_entity_name_tab pay_ca_eoy_rl2_archive.char240_data_type_table;
1261: l_user_entity_value_tab pay_ca_eoy_rl2_archive.char240_data_type_table;
1262: l_arch_gre_step number := 0;
1263: l_archive_item_id number;
1264: l_town_or_city varchar2(240);

Line 1261: l_user_entity_value_tab pay_ca_eoy_rl2_archive.char240_data_type_table;

1257: l_seq_tab pay_ca_eoy_rl2_archive.number_data_type_table;
1258: l_context_id_tab pay_ca_eoy_rl2_archive.number_data_type_table;
1259: l_context_val_tab pay_ca_eoy_rl2_archive.char240_data_type_table;
1260: l_user_entity_name_tab pay_ca_eoy_rl2_archive.char240_data_type_table;
1261: l_user_entity_value_tab pay_ca_eoy_rl2_archive.char240_data_type_table;
1262: l_arch_gre_step number := 0;
1263: l_archive_item_id number;
1264: l_town_or_city varchar2(240);
1265: l_province_code varchar2(240);

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

1482:
1483:
1484: /* archive Releve 2 data */
1485:
1486: ln_index := pay_ca_eoy_rl2_archive.ltr_ppa_arch_data.count;
1487: ln_index2 := pay_ca_eoy_rl2_archive.ltr_ppa_arch_er_data.count;
1488:
1489: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).action_info_category
1490: := 'CAEOY TRANSMITTER INFO';

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

1483:
1484: /* archive Releve 2 data */
1485:
1486: ln_index := pay_ca_eoy_rl2_archive.ltr_ppa_arch_data.count;
1487: ln_index2 := pay_ca_eoy_rl2_archive.ltr_ppa_arch_er_data.count;
1488:
1489: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).action_info_category
1490: := 'CAEOY TRANSMITTER INFO';
1491:

Line 1489: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).action_info_category

1485:
1486: ln_index := pay_ca_eoy_rl2_archive.ltr_ppa_arch_data.count;
1487: ln_index2 := pay_ca_eoy_rl2_archive.ltr_ppa_arch_er_data.count;
1488:
1489: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).action_info_category
1490: := 'CAEOY TRANSMITTER INFO';
1491:
1492: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).jurisdiction_code
1493: := null;

Line 1492: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).jurisdiction_code

1488:
1489: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).action_info_category
1490: := 'CAEOY TRANSMITTER INFO';
1491:
1492: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).jurisdiction_code
1493: := null;
1494:
1495: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info1
1496: := 'RL2';

Line 1495: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info1

1491:
1492: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).jurisdiction_code
1493: := null;
1494:
1495: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info1
1496: := 'RL2';
1497:
1498: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info2
1499: := l_employer_ein;

Line 1498: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info2

1494:
1495: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info1
1496: := 'RL2';
1497:
1498: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info2
1499: := l_employer_ein;
1500:
1501: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info3
1502: := l_transmitter_number;

Line 1501: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info3

1497:
1498: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info2
1499: := l_employer_ein;
1500:
1501: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info3
1502: := l_transmitter_number;
1503:
1504: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info4
1505: := l_rl_data_type;

Line 1504: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info4

1500:
1501: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info3
1502: := l_transmitter_number;
1503:
1504: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info4
1505: := l_rl_data_type;
1506:
1507: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info5
1508: := l_rl_package_type;

Line 1507: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info5

1503:
1504: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info4
1505: := l_rl_data_type;
1506:
1507: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info5
1508: := l_rl_package_type;
1509:
1510: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info6
1511: := l_Transmitter_Type_Indicator;

Line 1510: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info6

1506:
1507: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info5
1508: := l_rl_package_type;
1509:
1510: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info6
1511: := l_Transmitter_Type_Indicator;
1512:
1513: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info7
1514: := l_rl_source_of_slips;

Line 1513: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info7

1509:
1510: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info6
1511: := l_Transmitter_Type_Indicator;
1512:
1513: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info7
1514: := l_rl_source_of_slips;
1515:
1516: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info8
1517: := l_taxation_year;

Line 1516: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info8

1512:
1513: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info7
1514: := l_rl_source_of_slips;
1515:
1516: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info8
1517: := l_taxation_year;
1518:
1519: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info9
1520: := l_transmitter_country;

Line 1519: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info9

1515:
1516: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info8
1517: := l_taxation_year;
1518:
1519: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info9
1520: := l_transmitter_country;
1521:
1522: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info10
1523: := l_transmitter_name;

Line 1522: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info10

1518:
1519: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info9
1520: := l_transmitter_country;
1521:
1522: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info10
1523: := l_transmitter_name;
1524:
1525: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info11
1526: := l_transmitter_addr_line_1;

Line 1525: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info11

1521:
1522: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info10
1523: := l_transmitter_name;
1524:
1525: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info11
1526: := l_transmitter_addr_line_1;
1527:
1528: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info12
1529: := l_transmitter_addr_line_2;

Line 1528: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info12

1524:
1525: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info11
1526: := l_transmitter_addr_line_1;
1527:
1528: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info12
1529: := l_transmitter_addr_line_2;
1530:
1531: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info13
1532: := l_transmitter_addr_line_3;

Line 1531: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info13

1527:
1528: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info12
1529: := l_transmitter_addr_line_2;
1530:
1531: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info13
1532: := l_transmitter_addr_line_3;
1533:
1534: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info14
1535: := l_transmitter_city;

Line 1534: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info14

1530:
1531: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info13
1532: := l_transmitter_addr_line_3;
1533:
1534: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info14
1535: := l_transmitter_city;
1536:
1537: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info15
1538: := l_transmitter_province;

Line 1537: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info15

1533:
1534: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info14
1535: := l_transmitter_city;
1536:
1537: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info15
1538: := l_transmitter_province;
1539:
1540: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info16
1541: := l_transmitter_postal_code;

Line 1540: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info16

1536:
1537: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info15
1538: := l_transmitter_province;
1539:
1540: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info16
1541: := l_transmitter_postal_code;
1542:
1543: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info17
1544: := l_technical_contact_name;

Line 1543: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info17

1539:
1540: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info16
1541: := l_transmitter_postal_code;
1542:
1543: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info17
1544: := l_technical_contact_name;
1545:
1546: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info18
1547: := l_technical_contact_area_code;

Line 1546: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info18

1542:
1543: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info17
1544: := l_technical_contact_name;
1545:
1546: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info18
1547: := l_technical_contact_area_code;
1548:
1549: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info19
1550: := l_technical_contact_phone;

Line 1549: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info19

1545:
1546: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info18
1547: := l_technical_contact_area_code;
1548:
1549: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info19
1550: := l_technical_contact_phone;
1551:
1552: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info20
1553: := l_technical_contact_extension;

Line 1552: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info20

1548:
1549: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info19
1550: := l_technical_contact_phone;
1551:
1552: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info20
1553: := l_technical_contact_extension;
1554:
1555: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info21
1556: := l_technical_contact_language;

Line 1555: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info21

1551:
1552: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info20
1553: := l_technical_contact_extension;
1554:
1555: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info21
1556: := l_technical_contact_language;
1557:
1558: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info22
1559: := l_accounting_contact_name;

Line 1558: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info22

1554:
1555: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info21
1556: := l_technical_contact_language;
1557:
1558: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info22
1559: := l_accounting_contact_name;
1560:
1561: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info23
1562: := l_accounting_contact_area_code;

Line 1561: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info23

1557:
1558: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info22
1559: := l_accounting_contact_name;
1560:
1561: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info23
1562: := l_accounting_contact_area_code;
1563:
1564: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info24
1565: := l_accounting_contact_phone ;

Line 1564: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info24

1560:
1561: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info23
1562: := l_accounting_contact_area_code;
1563:
1564: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info24
1565: := l_accounting_contact_phone ;
1566:
1567: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info25
1568: := l_accounting_contact_extension;

Line 1567: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info25

1563:
1564: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info24
1565: := l_accounting_contact_phone ;
1566:
1567: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info25
1568: := l_accounting_contact_extension;
1569:
1570: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info26
1571: := l_accounting_contact_language;

Line 1570: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info26

1566:
1567: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info25
1568: := l_accounting_contact_extension;
1569:
1570: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info26
1571: := l_accounting_contact_language;
1572:
1573: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info27
1574: := p_pre_org_id;

Line 1573: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info27

1569:
1570: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info26
1571: := l_accounting_contact_language;
1572:
1573: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info27
1574: := p_pre_org_id;
1575:
1576: /* Archive Employer Data */
1577: pay_ca_eoy_rl2_archive.ltr_ppa_arch_er_data(ln_index2).action_info_category

Line 1577: pay_ca_eoy_rl2_archive.ltr_ppa_arch_er_data(ln_index2).action_info_category

1573: pay_ca_eoy_rl2_archive.ltr_ppa_arch_data(ln_index).act_info27
1574: := p_pre_org_id;
1575:
1576: /* Archive Employer Data */
1577: pay_ca_eoy_rl2_archive.ltr_ppa_arch_er_data(ln_index2).action_info_category
1578: := 'CAEOY EMPLOYER INFO';
1579:
1580: pay_ca_eoy_rl2_archive.ltr_ppa_arch_er_data(ln_index2).jurisdiction_code
1581: := null;

Line 1580: pay_ca_eoy_rl2_archive.ltr_ppa_arch_er_data(ln_index2).jurisdiction_code

1576: /* Archive Employer Data */
1577: pay_ca_eoy_rl2_archive.ltr_ppa_arch_er_data(ln_index2).action_info_category
1578: := 'CAEOY EMPLOYER INFO';
1579:
1580: pay_ca_eoy_rl2_archive.ltr_ppa_arch_er_data(ln_index2).jurisdiction_code
1581: := null;
1582:
1583: pay_ca_eoy_rl2_archive.ltr_ppa_arch_er_data(ln_index2).act_info1
1584: := 'RL2';

Line 1583: pay_ca_eoy_rl2_archive.ltr_ppa_arch_er_data(ln_index2).act_info1

1579:
1580: pay_ca_eoy_rl2_archive.ltr_ppa_arch_er_data(ln_index2).jurisdiction_code
1581: := null;
1582:
1583: pay_ca_eoy_rl2_archive.ltr_ppa_arch_er_data(ln_index2).act_info1
1584: := 'RL2';
1585:
1586: pay_ca_eoy_rl2_archive.ltr_ppa_arch_er_data(ln_index2).act_info2
1587: := l_name;

Line 1586: pay_ca_eoy_rl2_archive.ltr_ppa_arch_er_data(ln_index2).act_info2

1582:
1583: pay_ca_eoy_rl2_archive.ltr_ppa_arch_er_data(ln_index2).act_info1
1584: := 'RL2';
1585:
1586: pay_ca_eoy_rl2_archive.ltr_ppa_arch_er_data(ln_index2).act_info2
1587: := l_name;
1588:
1589: pay_ca_eoy_rl2_archive.ltr_ppa_arch_er_data(ln_index2).act_info3
1590: := l_address_line_1;

Line 1589: pay_ca_eoy_rl2_archive.ltr_ppa_arch_er_data(ln_index2).act_info3

1585:
1586: pay_ca_eoy_rl2_archive.ltr_ppa_arch_er_data(ln_index2).act_info2
1587: := l_name;
1588:
1589: pay_ca_eoy_rl2_archive.ltr_ppa_arch_er_data(ln_index2).act_info3
1590: := l_address_line_1;
1591:
1592: pay_ca_eoy_rl2_archive.ltr_ppa_arch_er_data(ln_index2).act_info4
1593: := l_address_line_2;

Line 1592: pay_ca_eoy_rl2_archive.ltr_ppa_arch_er_data(ln_index2).act_info4

1588:
1589: pay_ca_eoy_rl2_archive.ltr_ppa_arch_er_data(ln_index2).act_info3
1590: := l_address_line_1;
1591:
1592: pay_ca_eoy_rl2_archive.ltr_ppa_arch_er_data(ln_index2).act_info4
1593: := l_address_line_2;
1594:
1595: pay_ca_eoy_rl2_archive.ltr_ppa_arch_er_data(ln_index2).act_info5
1596: := l_address_line_3;

Line 1595: pay_ca_eoy_rl2_archive.ltr_ppa_arch_er_data(ln_index2).act_info5

1591:
1592: pay_ca_eoy_rl2_archive.ltr_ppa_arch_er_data(ln_index2).act_info4
1593: := l_address_line_2;
1594:
1595: pay_ca_eoy_rl2_archive.ltr_ppa_arch_er_data(ln_index2).act_info5
1596: := l_address_line_3;
1597:
1598: pay_ca_eoy_rl2_archive.ltr_ppa_arch_er_data(ln_index2).act_info6
1599: := l_town_or_city;

Line 1598: pay_ca_eoy_rl2_archive.ltr_ppa_arch_er_data(ln_index2).act_info6

1594:
1595: pay_ca_eoy_rl2_archive.ltr_ppa_arch_er_data(ln_index2).act_info5
1596: := l_address_line_3;
1597:
1598: pay_ca_eoy_rl2_archive.ltr_ppa_arch_er_data(ln_index2).act_info6
1599: := l_town_or_city;
1600:
1601: pay_ca_eoy_rl2_archive.ltr_ppa_arch_er_data(ln_index2).act_info7
1602: := l_province_code;

Line 1601: pay_ca_eoy_rl2_archive.ltr_ppa_arch_er_data(ln_index2).act_info7

1597:
1598: pay_ca_eoy_rl2_archive.ltr_ppa_arch_er_data(ln_index2).act_info6
1599: := l_town_or_city;
1600:
1601: pay_ca_eoy_rl2_archive.ltr_ppa_arch_er_data(ln_index2).act_info7
1602: := l_province_code;
1603:
1604: pay_ca_eoy_rl2_archive.ltr_ppa_arch_er_data(ln_index2).act_info8
1605: := l_country_code;

Line 1604: pay_ca_eoy_rl2_archive.ltr_ppa_arch_er_data(ln_index2).act_info8

1600:
1601: pay_ca_eoy_rl2_archive.ltr_ppa_arch_er_data(ln_index2).act_info7
1602: := l_province_code;
1603:
1604: pay_ca_eoy_rl2_archive.ltr_ppa_arch_er_data(ln_index2).act_info8
1605: := l_country_code;
1606:
1607: pay_ca_eoy_rl2_archive.ltr_ppa_arch_er_data(ln_index2).act_info9
1608: := l_postal_code;

Line 1607: pay_ca_eoy_rl2_archive.ltr_ppa_arch_er_data(ln_index2).act_info9

1603:
1604: pay_ca_eoy_rl2_archive.ltr_ppa_arch_er_data(ln_index2).act_info8
1605: := l_country_code;
1606:
1607: pay_ca_eoy_rl2_archive.ltr_ppa_arch_er_data(ln_index2).act_info9
1608: := l_postal_code;
1609:
1610: l_arch_gre_step := 50;
1611: l_arch_gre_step := 51;

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

1625: ,p_action_context_type=> 'PA'
1626: ,p_assignment_id => null
1627: ,p_tax_unit_id => null
1628: ,p_effective_date => l_effective_date
1629: ,p_tab_rec_data => pay_ca_eoy_rl2_archive.ltr_ppa_arch_data);
1630: end if;
1631:
1632: /* Inserting rows into pay_action_information table
1633: Employer Information (Could be just a PRE or Transmitter PRE) */

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

1631:
1632: /* Inserting rows into pay_action_information table
1633: Employer Information (Could be just a PRE or Transmitter PRE) */
1634:
1635: if pay_ca_eoy_rl2_archive.ltr_ppa_arch_er_data.count >0 then
1636: hr_utility.trace('Archiving Employer Data');
1637: archive_data_records(
1638: p_action_context_id => p_payroll_action_id
1639: ,p_action_context_type=> 'PA'

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

1639: ,p_action_context_type=> 'PA'
1640: ,p_assignment_id => null
1641: ,p_tax_unit_id => null
1642: ,p_effective_date => l_effective_date
1643: ,p_tab_rec_data => pay_ca_eoy_rl2_archive.ltr_ppa_arch_er_data);
1644: end if;
1645:
1646: EXCEPTION
1647: when others then

Line 1791: l_seq_tab pay_ca_eoy_rl2_archive.number_data_type_table;

1787: l_county_code varchar2(3);
1788: l_city_code varchar2(4);
1789: l_jursd_context_id ff_contexts.context_id%type;
1790: l_taxunit_context_id ff_contexts.context_id%type;
1791: l_seq_tab pay_ca_eoy_rl2_archive.number_data_type_table;
1792: l_context_id_tab pay_ca_eoy_rl2_archive.number_data_type_table;
1793: l_context_val_tab pay_ca_eoy_rl2_archive.char240_data_type_table;
1794: l_chunk number;
1795: l_payroll_action_id number;

Line 1792: l_context_id_tab pay_ca_eoy_rl2_archive.number_data_type_table;

1788: l_city_code varchar2(4);
1789: l_jursd_context_id ff_contexts.context_id%type;
1790: l_taxunit_context_id ff_contexts.context_id%type;
1791: l_seq_tab pay_ca_eoy_rl2_archive.number_data_type_table;
1792: l_context_id_tab pay_ca_eoy_rl2_archive.number_data_type_table;
1793: l_context_val_tab pay_ca_eoy_rl2_archive.char240_data_type_table;
1794: l_chunk number;
1795: l_payroll_action_id number;
1796: l_person_id number;

Line 1793: l_context_val_tab pay_ca_eoy_rl2_archive.char240_data_type_table;

1789: l_jursd_context_id ff_contexts.context_id%type;
1790: l_taxunit_context_id ff_contexts.context_id%type;
1791: l_seq_tab pay_ca_eoy_rl2_archive.number_data_type_table;
1792: l_context_id_tab pay_ca_eoy_rl2_archive.number_data_type_table;
1793: l_context_val_tab pay_ca_eoy_rl2_archive.char240_data_type_table;
1794: l_chunk number;
1795: l_payroll_action_id number;
1796: l_person_id number;
1797: l_defined_balance_id number;

Line 1835: l_user_entity_name_tab pay_ca_eoy_rl2_archive.char240_data_type_table;

1831: l_some_warning boolean;
1832: result number;
1833: l_no_of_payroll_run number := 0;
1834: l_has_been_paid varchar2(3);
1835: l_user_entity_name_tab pay_ca_eoy_rl2_archive.char240_data_type_table;
1836: l_user_entity_value_tab pay_ca_eoy_rl2_archive.char240_data_type_table;
1837: l_balance_type_tab pay_ca_eoy_rl2_archive.char240_data_type_table;
1838: l_footnote_balance_type_tab varchar2(80);
1839: l_footnote_code varchar2(30);

Line 1836: l_user_entity_value_tab pay_ca_eoy_rl2_archive.char240_data_type_table;

1832: result number;
1833: l_no_of_payroll_run number := 0;
1834: l_has_been_paid varchar2(3);
1835: l_user_entity_name_tab pay_ca_eoy_rl2_archive.char240_data_type_table;
1836: l_user_entity_value_tab pay_ca_eoy_rl2_archive.char240_data_type_table;
1837: l_balance_type_tab pay_ca_eoy_rl2_archive.char240_data_type_table;
1838: l_footnote_balance_type_tab varchar2(80);
1839: l_footnote_code varchar2(30);
1840: l_footnote_balance varchar2(80);

Line 1837: l_balance_type_tab pay_ca_eoy_rl2_archive.char240_data_type_table;

1833: l_no_of_payroll_run number := 0;
1834: l_has_been_paid varchar2(3);
1835: l_user_entity_name_tab pay_ca_eoy_rl2_archive.char240_data_type_table;
1836: l_user_entity_value_tab pay_ca_eoy_rl2_archive.char240_data_type_table;
1837: l_balance_type_tab pay_ca_eoy_rl2_archive.char240_data_type_table;
1838: l_footnote_balance_type_tab varchar2(80);
1839: l_footnote_code varchar2(30);
1840: l_footnote_balance varchar2(80);
1841: l_footnote_amount number;

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

2469: close c_all_gres;
2470:
2471: hr_utility.trace('l_no_of_payroll_run is ' || l_no_of_payroll_run);
2472:
2473: ln_index := pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data.count;
2474: ln_footnote_index := pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data.count;
2475:
2476: hr_utility.trace('ln_index :'||to_char(ln_index));
2477: hr_utility.trace('ln_footnote_index :'||to_char(ln_footnote_index));

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

2470:
2471: hr_utility.trace('l_no_of_payroll_run is ' || l_no_of_payroll_run);
2472:
2473: ln_index := pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data.count;
2474: ln_footnote_index := pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data.count;
2475:
2476: hr_utility.trace('ln_index :'||to_char(ln_index));
2477: hr_utility.trace('ln_footnote_index :'||to_char(ln_footnote_index));
2478:

Line 2482: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info1

2478:
2479: if ((l_no_of_payroll_run > 0) and
2480: ((l_has_been_paid = 'Y') or (ln_no_gross_earnings <> 0)) ) then
2481:
2482: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info1
2483: := l_rl2_slip_number;
2484: for i in 1 .. l_count
2485: loop
2486:

Line 2497: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info3

2493: */
2494:
2495: if l_balance_type_tab(i) =
2496: 'Life Annuity Payments registered plan' then
2497: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info3
2498: := l_user_entity_value_tab(i);
2499: hr_utility.trace('ln_index :'||to_char(ln_index));
2500:
2501: elsif l_balance_type_tab(i) =

Line 2504: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info3

2500:
2501: elsif l_balance_type_tab(i) =
2502: 'Life Annuity Payments Unregistered plan' then
2503:
2504: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info3
2505: := to_number
2506: (pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info3)
2507: + to_number(nvl(l_user_entity_value_tab(i),0));
2508:

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

2502: 'Life Annuity Payments Unregistered plan' then
2503:
2504: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info3
2505: := to_number
2506: (pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info3)
2507: + to_number(nvl(l_user_entity_value_tab(i),0));
2508:
2509: elsif l_balance_type_tab(i) =
2510: 'Benefits from RRSP RRIF DPSP and Annuities' then

Line 2511: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info4

2507: + to_number(nvl(l_user_entity_value_tab(i),0));
2508:
2509: elsif l_balance_type_tab(i) =
2510: 'Benefits from RRSP RRIF DPSP and Annuities' then
2511: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info4
2512: := l_user_entity_value_tab(i);
2513:
2514: elsif l_balance_type_tab(i) = 'Other Payments' then
2515: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info5

Line 2515: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info5

2511: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info4
2512: := l_user_entity_value_tab(i);
2513:
2514: elsif l_balance_type_tab(i) = 'Other Payments' then
2515: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info5
2516: := l_user_entity_value_tab(i);
2517: hr_utility.trace('Box C :'||pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info5);
2518:
2519: elsif l_balance_type_tab(i) =

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

2513:
2514: elsif l_balance_type_tab(i) = 'Other Payments' then
2515: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info5
2516: := l_user_entity_value_tab(i);
2517: hr_utility.trace('Box C :'||pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info5);
2518:
2519: elsif l_balance_type_tab(i) =
2520: 'Refund of RRSP Premiums paid to surviving spouse' then
2521: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info6

Line 2521: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info6

2517: hr_utility.trace('Box C :'||pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info5);
2518:
2519: elsif l_balance_type_tab(i) =
2520: 'Refund of RRSP Premiums paid to surviving spouse' then
2521: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info6
2522: := l_user_entity_value_tab(i);
2523:
2524: elsif l_balance_type_tab(i) = 'Benefits at the time of death' then
2525: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info7

Line 2525: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info7

2521: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info6
2522: := l_user_entity_value_tab(i);
2523:
2524: elsif l_balance_type_tab(i) = 'Benefits at the time of death' then
2525: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info7
2526: := l_user_entity_value_tab(i);
2527:
2528: elsif l_balance_type_tab(i) =
2529: 'Refund of Undeducted RRSP contributions' then

Line 2530: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info8

2526: := l_user_entity_value_tab(i);
2527:
2528: elsif l_balance_type_tab(i) =
2529: 'Refund of Undeducted RRSP contributions' then
2530: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info8
2531: := l_user_entity_value_tab(i);
2532:
2533: elsif l_balance_type_tab(i) =
2534: 'Taxable Amount revoked registration RRSP or RRIF' then

Line 2535: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info9

2531: := l_user_entity_value_tab(i);
2532:
2533: elsif l_balance_type_tab(i) =
2534: 'Taxable Amount revoked registration RRSP or RRIF' then
2535: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info9
2536: := l_user_entity_value_tab(i);
2537:
2538: elsif l_balance_type_tab(i) = 'Other Income RRSP or RRIF' then
2539: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info10

Line 2539: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info10

2535: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info9
2536: := l_user_entity_value_tab(i);
2537:
2538: elsif l_balance_type_tab(i) = 'Other Income RRSP or RRIF' then
2539: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info10
2540: := l_user_entity_value_tab(i);
2541:
2542: elsif l_balance_type_tab(i) =
2543: 'Amount entitlement deduction for RRSP or RRIF' then

Line 2544: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info11

2540: := l_user_entity_value_tab(i);
2541:
2542: elsif l_balance_type_tab(i) =
2543: 'Amount entitlement deduction for RRSP or RRIF' then
2544: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info11
2545: := l_user_entity_value_tab(i);
2546:
2547: elsif l_balance_type_tab(i) = 'PROV Withheld' then
2548: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info12

Line 2548: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info12

2544: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info11
2545: := l_user_entity_value_tab(i);
2546:
2547: elsif l_balance_type_tab(i) = 'PROV Withheld' then
2548: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info12
2549: := l_user_entity_value_tab(i);
2550:
2551: elsif l_balance_type_tab(i) =
2552: 'Income earned after death RRSP or RRIF' then

Line 2553: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info13

2549: := l_user_entity_value_tab(i);
2550:
2551: elsif l_balance_type_tab(i) =
2552: 'Income earned after death RRSP or RRIF' then
2553: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info13
2554: := l_user_entity_value_tab(i);
2555:
2556: elsif l_balance_type_tab(i) =
2557: 'Withdrawal under the Lifelong Learning Plan' then

Line 2569: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info14

2565: if to_number(l_user_entity_value_tab(i)) > to_number(lv_boxL_Maxlimit) then
2566:
2567: lv_BoxL_excess_amt := to_char(to_number(l_user_entity_value_tab(i))
2568: - to_number(lv_boxL_Maxlimit)) ;
2569: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info14
2570: := lv_boxL_Maxlimit;
2571: else
2572: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info14
2573: := l_user_entity_value_tab(i);

Line 2572: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info14

2568: - to_number(lv_boxL_Maxlimit)) ;
2569: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info14
2570: := lv_boxL_Maxlimit;
2571: else
2572: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info14
2573: := l_user_entity_value_tab(i);
2574: end if;
2575:
2576: elsif l_balance_type_tab(i) = 'Tax Paid Amounts' then

Line 2577: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info15

2573: := l_user_entity_value_tab(i);
2574: end if;
2575:
2576: elsif l_balance_type_tab(i) = 'Tax Paid Amounts' then
2577: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info15
2578: := l_user_entity_value_tab(i);
2579:
2580: elsif l_balance_type_tab(i)
2581: = 'Withdrawal under the Home Buyers Plan' then

Line 2593: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info17

2589: if to_number(l_user_entity_value_tab(i)) > to_number(lv_boxO_Maxlimit) then
2590:
2591: lv_BoxO_excess_amt := to_char(to_number(l_user_entity_value_tab(i))
2592: - to_number(lv_boxO_Maxlimit));
2593: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info17
2594: := lv_boxO_Maxlimit;
2595: else
2596: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info17
2597: := l_user_entity_value_tab(i);

Line 2596: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info17

2592: - to_number(lv_boxO_Maxlimit));
2593: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info17
2594: := lv_boxO_Maxlimit;
2595: else
2596: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info17
2597: := l_user_entity_value_tab(i);
2598: end if;
2599:
2600: end if;

Line 2627: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data

2623: ln_footnote_index := ln_footnote_index;
2624: hr_utility.trace(' Box A ln_footnote_index :'
2625: ||to_char(ln_footnote_index));
2626:
2627: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data
2628: (ln_footnote_index).action_info_category := 'CA FOOTNOTES';
2629: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data
2630: (ln_footnote_index).jurisdiction_code := 'QC';
2631: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data

Line 2629: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data

2625: ||to_char(ln_footnote_index));
2626:
2627: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data
2628: (ln_footnote_index).action_info_category := 'CA FOOTNOTES';
2629: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data
2630: (ln_footnote_index).jurisdiction_code := 'QC';
2631: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data
2632: (ln_footnote_index).act_info4 := l_footnote_code;
2633: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data

Line 2631: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data

2627: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data
2628: (ln_footnote_index).action_info_category := 'CA FOOTNOTES';
2629: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data
2630: (ln_footnote_index).jurisdiction_code := 'QC';
2631: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data
2632: (ln_footnote_index).act_info4 := l_footnote_code;
2633: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data
2634: (ln_footnote_index).act_info5 :=
2635: to_char(l_footnote_amount);

Line 2633: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data

2629: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data
2630: (ln_footnote_index).jurisdiction_code := 'QC';
2631: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data
2632: (ln_footnote_index).act_info4 := l_footnote_code;
2633: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data
2634: (ln_footnote_index).act_info5 :=
2635: to_char(l_footnote_amount);
2636: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data
2637: (ln_footnote_index).act_info6 := 'RL2';

Line 2636: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data

2632: (ln_footnote_index).act_info4 := l_footnote_code;
2633: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data
2634: (ln_footnote_index).act_info5 :=
2635: to_char(l_footnote_amount);
2636: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data
2637: (ln_footnote_index).act_info6 := 'RL2';
2638:
2639: if l_footnote_amount < 0 then
2640:

Line 2693: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data

2689: ln_footnote_index := ln_footnote_index + 1;
2690: hr_utility.trace('old_l_ftcode ln_footnote_index :'
2691: ||to_char(ln_footnote_index));
2692:
2693: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data
2694: (ln_footnote_index).action_info_category
2695: := 'CA FOOTNOTES';
2696:
2697: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data

Line 2697: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data

2693: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data
2694: (ln_footnote_index).action_info_category
2695: := 'CA FOOTNOTES';
2696:
2697: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data
2698: (ln_footnote_index).jurisdiction_code := 'QC';
2699:
2700: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data
2701: (ln_footnote_index).act_info4

Line 2700: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data

2696:
2697: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data
2698: (ln_footnote_index).jurisdiction_code := 'QC';
2699:
2700: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data
2701: (ln_footnote_index).act_info4
2702: := old_l_footnote_code;
2703:
2704: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data

Line 2704: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data

2700: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data
2701: (ln_footnote_index).act_info4
2702: := old_l_footnote_code;
2703:
2704: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data
2705: (ln_footnote_index).act_info5
2706: := to_char(l_footnote_amount);
2707:
2708: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data

Line 2708: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data

2704: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data
2705: (ln_footnote_index).act_info5
2706: := to_char(l_footnote_amount);
2707:
2708: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data
2709: (ln_footnote_index).act_info6 := 'RL2';
2710:
2711: if l_footnote_amount < 0 then
2712:

Line 2818: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data

2814: ln_footnote_index := ln_footnote_index + 1;
2815: hr_utility.trace('after close c_footnote_info ln_footnote_index :'
2816: ||to_char(ln_footnote_index));
2817:
2818: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data
2819: (ln_footnote_index).action_info_category := 'CA FOOTNOTES';
2820: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data
2821: (ln_footnote_index).jurisdiction_code := 'QC';
2822: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data

Line 2820: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data

2816: ||to_char(ln_footnote_index));
2817:
2818: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data
2819: (ln_footnote_index).action_info_category := 'CA FOOTNOTES';
2820: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data
2821: (ln_footnote_index).jurisdiction_code := 'QC';
2822: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data
2823: (ln_footnote_index).act_info4 := l_footnote_code;
2824: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data

Line 2822: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data

2818: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data
2819: (ln_footnote_index).action_info_category := 'CA FOOTNOTES';
2820: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data
2821: (ln_footnote_index).jurisdiction_code := 'QC';
2822: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data
2823: (ln_footnote_index).act_info4 := l_footnote_code;
2824: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data
2825: (ln_footnote_index).act_info5 := to_char(l_footnote_amount);
2826: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data

Line 2824: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data

2820: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data
2821: (ln_footnote_index).jurisdiction_code := 'QC';
2822: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data
2823: (ln_footnote_index).act_info4 := l_footnote_code;
2824: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data
2825: (ln_footnote_index).act_info5 := to_char(l_footnote_amount);
2826: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data
2827: (ln_footnote_index).act_info6 := 'RL2';
2828:

Line 2826: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data

2822: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data
2823: (ln_footnote_index).act_info4 := l_footnote_code;
2824: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data
2825: (ln_footnote_index).act_info5 := to_char(l_footnote_amount);
2826: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data
2827: (ln_footnote_index).act_info6 := 'RL2';
2828:
2829: if l_footnote_amount < 0 then
2830:

Line 2851: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info5

2847: hr_utility.trace('lv_BoxL_excess_amt : '||lv_BoxL_excess_amt);
2848: hr_utility.trace('lv_BoxO_excess_amt : '||lv_BoxO_excess_amt);
2849:
2850: if ((lv_BoxL_Excess_amt > 0) or (lv_BoxO_Excess_amt > 0)) then
2851: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info5
2852: := to_char(NVL(to_number(pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info5),0)
2853: + to_number(lv_BoxL_excess_amt) + to_number(lv_BoxO_excess_amt));
2854: hr_utility.trace('Box C : '||pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info5);
2855: end if;

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

2848: hr_utility.trace('lv_BoxO_excess_amt : '||lv_BoxO_excess_amt);
2849:
2850: if ((lv_BoxL_Excess_amt > 0) or (lv_BoxO_Excess_amt > 0)) then
2851: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info5
2852: := to_char(NVL(to_number(pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info5),0)
2853: + to_number(lv_BoxL_excess_amt) + to_number(lv_BoxO_excess_amt));
2854: hr_utility.trace('Box C : '||pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info5);
2855: end if;
2856:

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

2850: if ((lv_BoxL_Excess_amt > 0) or (lv_BoxO_Excess_amt > 0)) then
2851: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info5
2852: := to_char(NVL(to_number(pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info5),0)
2853: + to_number(lv_BoxL_excess_amt) + to_number(lv_BoxO_excess_amt));
2854: hr_utility.trace('Box C : '||pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info5);
2855: end if;
2856:
2857: /* Set the Negative Balance Flag for Archiving */
2858: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info30

Line 2858: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info30

2854: hr_utility.trace('Box C : '||pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info5);
2855: end if;
2856:
2857: /* Set the Negative Balance Flag for Archiving */
2858: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info30
2859: := l_negative_balance_exists;
2860:
2861: hr_utility.trace('after loop act_info4 is: '
2862: || pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info4);

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

2858: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info30
2859: := l_negative_balance_exists;
2860:
2861: hr_utility.trace('after loop act_info4 is: '
2862: || pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info4);
2863:
2864: end if; /* end if for ((l_no_of_payroll_run >0) and (l_has_been_paid='Y'))*/
2865:
2866: -- Need to Archive Non-Box Footnotes, will be done next year

Line 2962: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data

2958: ln_footnote_index := ln_footnote_index + 1;
2959: hr_utility.trace('Archiving Source of Income Other as Footnote ln_footnote_index :'
2960: ||to_char(ln_footnote_index));
2961:
2962: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data
2963: (ln_footnote_index).action_info_category := 'CA FOOTNOTES';
2964: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data
2965: (ln_footnote_index).jurisdiction_code := 'QC';
2966: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data

Line 2964: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data

2960: ||to_char(ln_footnote_index));
2961:
2962: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data
2963: (ln_footnote_index).action_info_category := 'CA FOOTNOTES';
2964: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data
2965: (ln_footnote_index).jurisdiction_code := 'QC';
2966: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data
2967: (ln_footnote_index).act_info4 := l_rl2_source_of_income;
2968: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data

Line 2966: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data

2962: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data
2963: (ln_footnote_index).action_info_category := 'CA FOOTNOTES';
2964: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data
2965: (ln_footnote_index).jurisdiction_code := 'QC';
2966: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data
2967: (ln_footnote_index).act_info4 := l_rl2_source_of_income;
2968: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data
2969: (ln_footnote_index).act_info5 := '0';
2970: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data

Line 2968: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data

2964: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data
2965: (ln_footnote_index).jurisdiction_code := 'QC';
2966: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data
2967: (ln_footnote_index).act_info4 := l_rl2_source_of_income;
2968: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data
2969: (ln_footnote_index).act_info5 := '0';
2970: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data
2971: (ln_footnote_index).act_info6 := 'RL2';
2972: else

Line 2970: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data

2966: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data
2967: (ln_footnote_index).act_info4 := l_rl2_source_of_income;
2968: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data
2969: (ln_footnote_index).act_info5 := '0';
2970: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data
2971: (ln_footnote_index).act_info6 := 'RL2';
2972: else
2973: l_rl2_source_of_income := l_per_eit_source_of_income;
2974: end if;

Line 2985: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data

2981: ln_footnote_index := ln_footnote_index + 1;
2982: hr_utility.trace('Archiving Source of Income Other as Footnote ln_footnote_index :'
2983: ||to_char(ln_footnote_index));
2984:
2985: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data
2986: (ln_footnote_index).action_info_category := 'CA FOOTNOTES';
2987: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data
2988: (ln_footnote_index).jurisdiction_code := 'QC';
2989: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data

Line 2987: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data

2983: ||to_char(ln_footnote_index));
2984:
2985: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data
2986: (ln_footnote_index).action_info_category := 'CA FOOTNOTES';
2987: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data
2988: (ln_footnote_index).jurisdiction_code := 'QC';
2989: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data
2990: (ln_footnote_index).act_info4 := l_rl2_source_of_income;
2991: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data

Line 2989: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data

2985: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data
2986: (ln_footnote_index).action_info_category := 'CA FOOTNOTES';
2987: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data
2988: (ln_footnote_index).jurisdiction_code := 'QC';
2989: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data
2990: (ln_footnote_index).act_info4 := l_rl2_source_of_income;
2991: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data
2992: (ln_footnote_index).act_info5 := '0';
2993: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data

Line 2991: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data

2987: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data
2988: (ln_footnote_index).jurisdiction_code := 'QC';
2989: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data
2990: (ln_footnote_index).act_info4 := l_rl2_source_of_income;
2991: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data
2992: (ln_footnote_index).act_info5 := '0';
2993: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data
2994: (ln_footnote_index).act_info6 := 'RL2';
2995: else

Line 2993: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data

2989: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data
2990: (ln_footnote_index).act_info4 := l_rl2_source_of_income;
2991: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data
2992: (ln_footnote_index).act_info5 := '0';
2993: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data
2994: (ln_footnote_index).act_info6 := 'RL2';
2995: else
2996: l_rl2_source_of_income := l_pre_source_of_income;
2997: end if;

Line 3003: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).action_info_category

2999:
3000:
3001: hr_utility.trace('Before counter of asgid '|| l_asgid);
3002:
3003: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).action_info_category
3004: := 'CAEOY RL2 EMPLOYEE INFO';
3005:
3006: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).jurisdiction_code
3007: := l_jurisdiction;

Line 3006: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).jurisdiction_code

3002:
3003: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).action_info_category
3004: := 'CAEOY RL2 EMPLOYEE INFO';
3005:
3006: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).jurisdiction_code
3007: := l_jurisdiction;
3008:
3009: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info2
3010: := l_rl2_source_of_income;

Line 3009: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info2

3005:
3006: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).jurisdiction_code
3007: := l_jurisdiction;
3008:
3009: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info2
3010: := l_rl2_source_of_income;
3011:
3012: -- RL2 Box N SIN of Spouse
3013: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info16

Line 3013: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info16

3009: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info2
3010: := l_rl2_source_of_income;
3011:
3012: -- RL2 Box N SIN of Spouse
3013: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info16
3014: := l_beneficiary_sin;
3015:
3016: hr_utility.trace('Employee Info ln_index: '||to_char(ln_index));
3017: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info18

Line 3017: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info18

3013: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info16
3014: := l_beneficiary_sin;
3015:
3016: hr_utility.trace('Employee Info ln_index: '||to_char(ln_index));
3017: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info18
3018: := l_first_name;
3019:
3020: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info20
3021: := l_last_name ;

Line 3020: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info20

3016: hr_utility.trace('Employee Info ln_index: '||to_char(ln_index));
3017: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info18
3018: := l_first_name;
3019:
3020: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info20
3021: := l_last_name ;
3022:
3023: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info19
3024: := l_middle_name ;

Line 3023: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info19

3019:
3020: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info20
3021: := l_last_name ;
3022:
3023: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info19
3024: := l_middle_name ;
3025:
3026: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info28
3027: := l_national_identifier;

Line 3026: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info28

3022:
3023: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info19
3024: := l_middle_name ;
3025:
3026: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info28
3027: := l_national_identifier;
3028:
3029: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info29
3030: := l_employee_number;

Line 3029: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info29

3025:
3026: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info28
3027: := l_national_identifier;
3028:
3029: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info29
3030: := l_employee_number;
3031:
3032: end if;
3033:

Line 3072: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info21

3068: end if; /* c_get_pri_addr%NOTFOUND */
3069: close c_get_pri_addr;
3070: end;
3071:
3072: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info21
3073: := l_address_line1;
3074:
3075: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info22
3076: := l_address_line2;

Line 3075: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info22

3071:
3072: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info21
3073: := l_address_line1;
3074:
3075: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info22
3076: := l_address_line2;
3077:
3078: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info23
3079: := l_address_line3;

Line 3078: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info23

3074:
3075: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info22
3076: := l_address_line2;
3077:
3078: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info23
3079: := l_address_line3;
3080:
3081: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info24
3082: := l_town_or_city;

Line 3081: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info24

3077:
3078: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info23
3079: := l_address_line3;
3080:
3081: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info24
3082: := l_town_or_city;
3083:
3084: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info25
3085: := l_province_code;

Line 3084: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info25

3080:
3081: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info24
3082: := l_town_or_city;
3083:
3084: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info25
3085: := l_province_code;
3086:
3087: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info27
3088: := l_country_code;

Line 3087: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info27

3083:
3084: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info25
3085: := l_province_code;
3086:
3087: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info27
3088: := l_country_code;
3089:
3090: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info26
3091: := l_postal_code;

Line 3090: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info26

3086:
3087: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info27
3088: := l_country_code;
3089:
3090: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data(ln_index).act_info26
3091: := l_postal_code;
3092:
3093: end if;
3094:

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

3094:
3095: /* Inserting rows into pay_action_information table
3096: RL2 Employee Data Archived */
3097:
3098: if pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data.count >0 then
3099: archive_data_records(
3100: p_action_context_id => p_assactid
3101: ,p_action_context_type=> 'AAP'
3102: ,p_assignment_id => l_asgid

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

3101: ,p_action_context_type=> 'AAP'
3102: ,p_assignment_id => l_asgid
3103: ,p_tax_unit_id => l_rl2_tax_unit_id
3104: ,p_effective_date => p_effective_date
3105: ,p_tab_rec_data => pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data);
3106: ln_index := null;
3107: end if;
3108:
3109: if pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data.count >0 then

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

3105: ,p_tab_rec_data => pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data);
3106: ln_index := null;
3107: end if;
3108:
3109: if pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data.count >0 then
3110: archive_data_records(
3111: p_action_context_id => p_assactid
3112: ,p_action_context_type=> 'AAP'
3113: ,p_assignment_id => l_asgid

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

3112: ,p_action_context_type=> 'AAP'
3113: ,p_assignment_id => l_asgid
3114: ,p_tax_unit_id => l_rl2_tax_unit_id
3115: ,p_effective_date => p_effective_date
3116: ,p_tab_rec_data => pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_ft_data);
3117: ln_footnote_index := null;
3118: end if;
3119:
3120: --hr_utility.trace_on('Y','SAM');

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

3135:
3136: /* Archive the Pre-Printed form number for the RL2
3137: Amendment Pre-Process if one exists*/
3138:
3139: ln_index := pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data2.count;
3140:
3141: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data2(ln_index).action_info_category
3142: := 'CAEOY RL2 EMPLOYEE INFO2';
3143:

Line 3141: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data2(ln_index).action_info_category

3137: Amendment Pre-Process if one exists*/
3138:
3139: ln_index := pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data2.count;
3140:
3141: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data2(ln_index).action_info_category
3142: := 'CAEOY RL2 EMPLOYEE INFO2';
3143:
3144: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data2(ln_index).jurisdiction_code
3145: := l_jurisdiction;

Line 3144: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data2(ln_index).jurisdiction_code

3140:
3141: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data2(ln_index).action_info_category
3142: := 'CAEOY RL2 EMPLOYEE INFO2';
3143:
3144: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data2(ln_index).jurisdiction_code
3145: := l_jurisdiction;
3146:
3147: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data2(ln_index).act_info1
3148: := null;

Line 3147: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data2(ln_index).act_info1

3143:
3144: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data2(ln_index).jurisdiction_code
3145: := l_jurisdiction;
3146:
3147: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data2(ln_index).act_info1
3148: := null;
3149:
3150: open c_get_preprinted_form_no (l_person_id, ln_fapp_pre_org_id);
3151: loop

Line 3163: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data2(ln_index).act_info1

3159: if ((lv_fapp_effective_date =
3160: to_char(fnd_date.canonical_to_date(lv_eit_year), 'YYYY')) and
3161: (ln_fapp_pre_org_id = to_number(lv_eit_pre_org_id))) then
3162:
3163: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data2(ln_index).act_info1
3164: := lv_eit_form_no;
3165: end if;
3166:
3167: end loop;

Line 3186: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data2(ln_index).act_info2

3182:
3183: end if; -- report type validation for FAPP
3184:
3185: hr_utility.trace('Archiving RL2 Amendment Flag : ' || lv_fapp_flag);
3186: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data2(ln_index).act_info2
3187: := lv_fapp_flag;
3188:
3189: if pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data2.count >0 then
3190: archive_data_records(

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

3185: hr_utility.trace('Archiving RL2 Amendment Flag : ' || lv_fapp_flag);
3186: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data2(ln_index).act_info2
3187: := lv_fapp_flag;
3188:
3189: if pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data2.count >0 then
3190: archive_data_records(
3191: p_action_context_id => p_assactid
3192: ,p_action_context_type=> 'AAP'
3193: ,p_assignment_id => l_asgid

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

3192: ,p_action_context_type=> 'AAP'
3193: ,p_assignment_id => l_asgid
3194: ,p_tax_unit_id => l_rl2_tax_unit_id
3195: ,p_effective_date => p_effective_date
3196: ,p_tab_rec_data => pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data2);
3197: ln_index := null;
3198: end if;
3199:
3200: hr_utility.trace('End of Provincial YE Amendment PP Validation');

Line 3288: end pay_ca_eoy_rl2_archive;

3284: end if;
3285:
3286: end eoy_range_cursor;
3287:
3288: end pay_ca_eoy_rl2_archive;