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_MX_SOC_SEC_ARCHIVE dependencies on PAY_MX_SOC_SEC_ARCHIVE

Line 1: PACKAGE BODY PAY_MX_SOC_SEC_ARCHIVE AS

1: PACKAGE BODY PAY_MX_SOC_SEC_ARCHIVE AS
2: /* $Header: paymxsocsecarch.pkb 120.88.12020000.4 2012/11/17 07:57:06 jeisaac ship $ */
3: /*
4: +=======================================================================+
5: | Copyright (c) 2003 Oracle Corporation |

Line 9: Package Header Name : pay_mx_soc_sec_archive

5: | Copyright (c) 2003 Oracle Corporation |
6: | Redwood Shores, California, USA |
7: | All rights reserved. |
8: +=======================================================================+
9: Package Header Name : pay_mx_soc_sec_archive
10: Package File Name : paymxsocsecarch.pkb
11:
12: Description : Used for Social Security Archiver.
13:

Line 1066: ln_index := pay_mx_soc_sec_archive.lrr_act_tab.COUNT;

1062:
1063: hr_utility.set_location(gv_package || lv_procedure_name, 60);
1064: ln_step := 6;
1065:
1066: ln_index := pay_mx_soc_sec_archive.lrr_act_tab.COUNT;
1067:
1068: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).action_info_category
1069: := 'MX SS GRE INFORMATION';
1070: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).jurisdiction_code := NULL;

Line 1068: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).action_info_category

1064: ln_step := 6;
1065:
1066: ln_index := pay_mx_soc_sec_archive.lrr_act_tab.COUNT;
1067:
1068: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).action_info_category
1069: := 'MX SS GRE INFORMATION';
1070: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).jurisdiction_code := NULL;
1071: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info1 := lv_soc_sec_id;
1072: /*bug:9820914 : Handling Spcial Chars in GRE Name */

Line 1070: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).jurisdiction_code := NULL;

1066: ln_index := pay_mx_soc_sec_archive.lrr_act_tab.COUNT;
1067:
1068: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).action_info_category
1069: := 'MX SS GRE INFORMATION';
1070: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).jurisdiction_code := NULL;
1071: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info1 := lv_soc_sec_id;
1072: /*bug:9820914 : Handling Spcial Chars in GRE Name */
1073: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info2
1074: := replace(pay_mx_rules.strip_spl_chars (lv_gre_name),'/','N');

Line 1071: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info1 := lv_soc_sec_id;

1067:
1068: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).action_info_category
1069: := 'MX SS GRE INFORMATION';
1070: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).jurisdiction_code := NULL;
1071: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info1 := lv_soc_sec_id;
1072: /*bug:9820914 : Handling Spcial Chars in GRE Name */
1073: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info2
1074: := replace(pay_mx_rules.strip_spl_chars (lv_gre_name),'/','N');
1075: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info3

Line 1073: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info2

1069: := 'MX SS GRE INFORMATION';
1070: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).jurisdiction_code := NULL;
1071: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info1 := lv_soc_sec_id;
1072: /*bug:9820914 : Handling Spcial Chars in GRE Name */
1073: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info2
1074: := replace(pay_mx_rules.strip_spl_chars (lv_gre_name),'/','N');
1075: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info3
1076: := lv_transmitter_gre_id;
1077: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info4

Line 1075: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info3

1071: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info1 := lv_soc_sec_id;
1072: /*bug:9820914 : Handling Spcial Chars in GRE Name */
1073: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info2
1074: := replace(pay_mx_rules.strip_spl_chars (lv_gre_name),'/','N');
1075: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info3
1076: := lv_transmitter_gre_id;
1077: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info4
1078: := replace(pay_mx_rules.strip_spl_chars (lv_transmitter_gre_name),'/','N');
1079: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info5 := lv_waybill_no;

Line 1077: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info4

1073: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info2
1074: := replace(pay_mx_rules.strip_spl_chars (lv_gre_name),'/','N');
1075: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info3
1076: := lv_transmitter_gre_id;
1077: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info4
1078: := replace(pay_mx_rules.strip_spl_chars (lv_transmitter_gre_name),'/','N');
1079: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info5 := lv_waybill_no;
1080:
1081: pay_emp_action_arch.insert_rows_thro_api_process(

Line 1079: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info5 := lv_waybill_no;

1075: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info3
1076: := lv_transmitter_gre_id;
1077: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info4
1078: := replace(pay_mx_rules.strip_spl_chars (lv_transmitter_gre_name),'/','N');
1079: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info5 := lv_waybill_no;
1080:
1081: pay_emp_action_arch.insert_rows_thro_api_process(
1082: p_action_context_id => p_payroll_action_id
1083: ,p_action_context_type => 'PA'

Line 1087: ,p_tab_rec_data => pay_mx_soc_sec_archive.lrr_act_tab

1083: ,p_action_context_type => 'PA'
1084: ,p_assignment_id => null
1085: ,p_tax_unit_id => p_tax_unit_id
1086: ,p_curr_pymt_eff_date => p_effective_date
1087: ,p_tab_rec_data => pay_mx_soc_sec_archive.lrr_act_tab
1088: );
1089:
1090: pay_mx_soc_sec_archive.lrr_act_tab.DELETE;
1091:

Line 1090: pay_mx_soc_sec_archive.lrr_act_tab.DELETE;

1086: ,p_curr_pymt_eff_date => p_effective_date
1087: ,p_tab_rec_data => pay_mx_soc_sec_archive.lrr_act_tab
1088: );
1089:
1090: pay_mx_soc_sec_archive.lrr_act_tab.DELETE;
1091:
1092: EXCEPTION
1093: WHEN others THEN
1094: lv_error_message := 'Error at step ' || ln_step || ' in ' ||

Line 1549: hr_utility_trace('Archived SS transaxtions ' ||pay_mx_soc_sec_archive.lrr_act_tab.COUNT());

1545: -- Archive a 07 only if current person is not a new hire
1546: -- (Bug 6021768)
1547: lb_new_hire := FALSE;
1548: hr_utility_trace('Checking for hire ');
1549: hr_utility_trace('Archived SS transaxtions ' ||pay_mx_soc_sec_archive.lrr_act_tab.COUNT());
1550: hr_utility_trace('p_effective_date ' || p_effective_date);
1551:
1552: OPEN c_first_sal_date;
1553: FETCH c_first_sal_date into ld_effective_date;

Line 1556: IF pay_mx_soc_sec_archive.lrr_act_tab.COUNT() > 0 THEN --Bug 6060052

1552: OPEN c_first_sal_date;
1553: FETCH c_first_sal_date into ld_effective_date;
1554: CLOSE c_first_sal_date;
1555:
1556: IF pay_mx_soc_sec_archive.lrr_act_tab.COUNT() > 0 THEN --Bug 6060052
1557: FOR cntr IN pay_mx_soc_sec_archive.lrr_act_tab.FIRST()..
1558: pay_mx_soc_sec_archive.lrr_act_tab.LAST() LOOP
1559: hr_utility_trace('pay_mx_soc_sec_archive.lrr_act_tab(cntr).action_info_category ' ||
1560: pay_mx_soc_sec_archive.lrr_act_tab(cntr).action_info_category);

Line 1557: FOR cntr IN pay_mx_soc_sec_archive.lrr_act_tab.FIRST()..

1553: FETCH c_first_sal_date into ld_effective_date;
1554: CLOSE c_first_sal_date;
1555:
1556: IF pay_mx_soc_sec_archive.lrr_act_tab.COUNT() > 0 THEN --Bug 6060052
1557: FOR cntr IN pay_mx_soc_sec_archive.lrr_act_tab.FIRST()..
1558: pay_mx_soc_sec_archive.lrr_act_tab.LAST() LOOP
1559: hr_utility_trace('pay_mx_soc_sec_archive.lrr_act_tab(cntr).action_info_category ' ||
1560: pay_mx_soc_sec_archive.lrr_act_tab(cntr).action_info_category);
1561: hr_utility_trace('pay_mx_soc_sec_archive.lrr_act_tab(cntr).act_info2) ' ||

Line 1558: pay_mx_soc_sec_archive.lrr_act_tab.LAST() LOOP

1554: CLOSE c_first_sal_date;
1555:
1556: IF pay_mx_soc_sec_archive.lrr_act_tab.COUNT() > 0 THEN --Bug 6060052
1557: FOR cntr IN pay_mx_soc_sec_archive.lrr_act_tab.FIRST()..
1558: pay_mx_soc_sec_archive.lrr_act_tab.LAST() LOOP
1559: hr_utility_trace('pay_mx_soc_sec_archive.lrr_act_tab(cntr).action_info_category ' ||
1560: pay_mx_soc_sec_archive.lrr_act_tab(cntr).action_info_category);
1561: hr_utility_trace('pay_mx_soc_sec_archive.lrr_act_tab(cntr).act_info2) ' ||
1562: pay_mx_soc_sec_archive.lrr_act_tab(cntr).act_info2);

Line 1559: hr_utility_trace('pay_mx_soc_sec_archive.lrr_act_tab(cntr).action_info_category ' ||

1555:
1556: IF pay_mx_soc_sec_archive.lrr_act_tab.COUNT() > 0 THEN --Bug 6060052
1557: FOR cntr IN pay_mx_soc_sec_archive.lrr_act_tab.FIRST()..
1558: pay_mx_soc_sec_archive.lrr_act_tab.LAST() LOOP
1559: hr_utility_trace('pay_mx_soc_sec_archive.lrr_act_tab(cntr).action_info_category ' ||
1560: pay_mx_soc_sec_archive.lrr_act_tab(cntr).action_info_category);
1561: hr_utility_trace('pay_mx_soc_sec_archive.lrr_act_tab(cntr).act_info2) ' ||
1562: pay_mx_soc_sec_archive.lrr_act_tab(cntr).act_info2);
1563: hr_utility_trace('pay_mx_soc_sec_archive.lrr_act_tab(cntr).act_info4 ' ||

Line 1560: pay_mx_soc_sec_archive.lrr_act_tab(cntr).action_info_category);

1556: IF pay_mx_soc_sec_archive.lrr_act_tab.COUNT() > 0 THEN --Bug 6060052
1557: FOR cntr IN pay_mx_soc_sec_archive.lrr_act_tab.FIRST()..
1558: pay_mx_soc_sec_archive.lrr_act_tab.LAST() LOOP
1559: hr_utility_trace('pay_mx_soc_sec_archive.lrr_act_tab(cntr).action_info_category ' ||
1560: pay_mx_soc_sec_archive.lrr_act_tab(cntr).action_info_category);
1561: hr_utility_trace('pay_mx_soc_sec_archive.lrr_act_tab(cntr).act_info2) ' ||
1562: pay_mx_soc_sec_archive.lrr_act_tab(cntr).act_info2);
1563: hr_utility_trace('pay_mx_soc_sec_archive.lrr_act_tab(cntr).act_info4 ' ||
1564: pay_mx_soc_sec_archive.lrr_act_tab(cntr).act_info4);

Line 1561: hr_utility_trace('pay_mx_soc_sec_archive.lrr_act_tab(cntr).act_info2) ' ||

1557: FOR cntr IN pay_mx_soc_sec_archive.lrr_act_tab.FIRST()..
1558: pay_mx_soc_sec_archive.lrr_act_tab.LAST() LOOP
1559: hr_utility_trace('pay_mx_soc_sec_archive.lrr_act_tab(cntr).action_info_category ' ||
1560: pay_mx_soc_sec_archive.lrr_act_tab(cntr).action_info_category);
1561: hr_utility_trace('pay_mx_soc_sec_archive.lrr_act_tab(cntr).act_info2) ' ||
1562: pay_mx_soc_sec_archive.lrr_act_tab(cntr).act_info2);
1563: hr_utility_trace('pay_mx_soc_sec_archive.lrr_act_tab(cntr).act_info4 ' ||
1564: pay_mx_soc_sec_archive.lrr_act_tab(cntr).act_info4);
1565:

Line 1562: pay_mx_soc_sec_archive.lrr_act_tab(cntr).act_info2);

1558: pay_mx_soc_sec_archive.lrr_act_tab.LAST() LOOP
1559: hr_utility_trace('pay_mx_soc_sec_archive.lrr_act_tab(cntr).action_info_category ' ||
1560: pay_mx_soc_sec_archive.lrr_act_tab(cntr).action_info_category);
1561: hr_utility_trace('pay_mx_soc_sec_archive.lrr_act_tab(cntr).act_info2) ' ||
1562: pay_mx_soc_sec_archive.lrr_act_tab(cntr).act_info2);
1563: hr_utility_trace('pay_mx_soc_sec_archive.lrr_act_tab(cntr).act_info4 ' ||
1564: pay_mx_soc_sec_archive.lrr_act_tab(cntr).act_info4);
1565:
1566: IF pay_mx_soc_sec_archive.lrr_act_tab(cntr).action_info_category

Line 1563: hr_utility_trace('pay_mx_soc_sec_archive.lrr_act_tab(cntr).act_info4 ' ||

1559: hr_utility_trace('pay_mx_soc_sec_archive.lrr_act_tab(cntr).action_info_category ' ||
1560: pay_mx_soc_sec_archive.lrr_act_tab(cntr).action_info_category);
1561: hr_utility_trace('pay_mx_soc_sec_archive.lrr_act_tab(cntr).act_info2) ' ||
1562: pay_mx_soc_sec_archive.lrr_act_tab(cntr).act_info2);
1563: hr_utility_trace('pay_mx_soc_sec_archive.lrr_act_tab(cntr).act_info4 ' ||
1564: pay_mx_soc_sec_archive.lrr_act_tab(cntr).act_info4);
1565:
1566: IF pay_mx_soc_sec_archive.lrr_act_tab(cntr).action_info_category
1567: = 'MX SS TRANSACTIONS' AND

Line 1564: pay_mx_soc_sec_archive.lrr_act_tab(cntr).act_info4);

1560: pay_mx_soc_sec_archive.lrr_act_tab(cntr).action_info_category);
1561: hr_utility_trace('pay_mx_soc_sec_archive.lrr_act_tab(cntr).act_info2) ' ||
1562: pay_mx_soc_sec_archive.lrr_act_tab(cntr).act_info2);
1563: hr_utility_trace('pay_mx_soc_sec_archive.lrr_act_tab(cntr).act_info4 ' ||
1564: pay_mx_soc_sec_archive.lrr_act_tab(cntr).act_info4);
1565:
1566: IF pay_mx_soc_sec_archive.lrr_act_tab(cntr).action_info_category
1567: = 'MX SS TRANSACTIONS' AND
1568: fnd_date.canonical_to_date(

Line 1566: IF pay_mx_soc_sec_archive.lrr_act_tab(cntr).action_info_category

1562: pay_mx_soc_sec_archive.lrr_act_tab(cntr).act_info2);
1563: hr_utility_trace('pay_mx_soc_sec_archive.lrr_act_tab(cntr).act_info4 ' ||
1564: pay_mx_soc_sec_archive.lrr_act_tab(cntr).act_info4);
1565:
1566: IF pay_mx_soc_sec_archive.lrr_act_tab(cntr).action_info_category
1567: = 'MX SS TRANSACTIONS' AND
1568: fnd_date.canonical_to_date(
1569: pay_mx_soc_sec_archive.lrr_act_tab(cntr).act_info2) =
1570: p_effective_date AND

Line 1569: pay_mx_soc_sec_archive.lrr_act_tab(cntr).act_info2) =

1565:
1566: IF pay_mx_soc_sec_archive.lrr_act_tab(cntr).action_info_category
1567: = 'MX SS TRANSACTIONS' AND
1568: fnd_date.canonical_to_date(
1569: pay_mx_soc_sec_archive.lrr_act_tab(cntr).act_info2) =
1570: p_effective_date AND
1571: pay_mx_soc_sec_archive.lrr_act_tab(cntr).act_info4 = '08'
1572: THEN
1573: lb_new_hire := TRUE;

Line 1571: pay_mx_soc_sec_archive.lrr_act_tab(cntr).act_info4 = '08'

1567: = 'MX SS TRANSACTIONS' AND
1568: fnd_date.canonical_to_date(
1569: pay_mx_soc_sec_archive.lrr_act_tab(cntr).act_info2) =
1570: p_effective_date AND
1571: pay_mx_soc_sec_archive.lrr_act_tab(cntr).act_info4 = '08'
1572: THEN
1573: lb_new_hire := TRUE;
1574: EXIT;
1575: ELSIF

Line 1577: pay_mx_soc_sec_archive.lrr_act_tab(cntr).action_info_category

1573: lb_new_hire := TRUE;
1574: EXIT;
1575: ELSIF
1576: p_effective_date = ld_effective_date AND --BUG 7342321
1577: pay_mx_soc_sec_archive.lrr_act_tab(cntr).action_info_category
1578: = 'MX SS TRANSACTIONS' AND
1579: pay_mx_soc_sec_archive.lrr_act_tab(cntr).act_info4 = '08'
1580: THEN
1581: lb_new_hire := TRUE;

Line 1579: pay_mx_soc_sec_archive.lrr_act_tab(cntr).act_info4 = '08'

1575: ELSIF
1576: p_effective_date = ld_effective_date AND --BUG 7342321
1577: pay_mx_soc_sec_archive.lrr_act_tab(cntr).action_info_category
1578: = 'MX SS TRANSACTIONS' AND
1579: pay_mx_soc_sec_archive.lrr_act_tab(cntr).act_info4 = '08'
1580: THEN
1581: lb_new_hire := TRUE;
1582: hr_utility_trace('Going to run the get_idw to get the correct IDW for the first salary.');
1583: ln_idw := get_idw( p_assignment_id => p_assignment_id

Line 1588: pay_mx_soc_sec_archive.lrr_act_tab(cntr).act_info8:= ln_idw;

1584: ,p_tax_unit_id => p_gre_id
1585: ,p_effective_date => ld_effective_date
1586: ,p_fixed_idw => ln_fix_idw
1587: ,p_variable_idw => ln_var_idw );
1588: pay_mx_soc_sec_archive.lrr_act_tab(cntr).act_info8:= ln_idw;
1589: hr_utility_trace('Exiting the ELSIF part to prevent 07 transaction');
1590: EXIT;
1591: END IF;
1592: END LOOP;

Line 1851: IF pay_mx_soc_sec_archive.seniority_changed (p_person_id,

1847: END LOOP;
1848: CLOSE c_IDW_events;
1849:
1850: /*-- Support for change in seniority --*/
1851: IF pay_mx_soc_sec_archive.seniority_changed (p_person_id,
1852: p_end_date,
1853: p_start_date) = 'Y' THEN
1854: hr_utility_trace ('Seniority of person '||p_person_id||
1855: ' has changed since last archiver run. IDW will'||

Line 2373: ln_index := pay_mx_soc_sec_archive.lrr_act_tab.COUNT;

2369:
2370: END IF;
2371: /*8438074 End*/
2372:
2373: ln_index := pay_mx_soc_sec_archive.lrr_act_tab.COUNT;
2374:
2375: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).action_info_category
2376: := 'MX SS TRANSACTIONS';
2377: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).jurisdiction_code

Line 2375: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).action_info_category

2371: /*8438074 End*/
2372:
2373: ln_index := pay_mx_soc_sec_archive.lrr_act_tab.COUNT;
2374:
2375: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).action_info_category
2376: := 'MX SS TRANSACTIONS';
2377: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).jurisdiction_code
2378: := NULL;
2379: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info1

Line 2377: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).jurisdiction_code

2373: ln_index := pay_mx_soc_sec_archive.lrr_act_tab.COUNT;
2374:
2375: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).action_info_category
2376: := 'MX SS TRANSACTIONS';
2377: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).jurisdiction_code
2378: := NULL;
2379: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info1
2380: := p_person_id;
2381: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info2

Line 2379: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info1

2375: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).action_info_category
2376: := 'MX SS TRANSACTIONS';
2377: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).jurisdiction_code
2378: := NULL;
2379: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info1
2380: := p_person_id;
2381: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info2
2382: := trn(i).date;
2383: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info3

Line 2381: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info2

2377: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).jurisdiction_code
2378: := NULL;
2379: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info1
2380: := p_person_id;
2381: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info2
2382: := trn(i).date;
2383: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info3
2384: := lv_employee_ssn;
2385: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info4

Line 2383: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info3

2379: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info1
2380: := p_person_id;
2381: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info2
2382: := trn(i).date;
2383: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info3
2384: := lv_employee_ssn;
2385: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info4
2386: := trn(i).type;
2387: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info5

Line 2385: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info4

2381: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info2
2382: := trn(i).date;
2383: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info3
2384: := lv_employee_ssn;
2385: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info4
2386: := trn(i).type;
2387: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info5
2388: := lv_employer_ss_id;
2389: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info6

Line 2387: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info5

2383: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info3
2384: := lv_employee_ssn;
2385: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info4
2386: := trn(i).type;
2387: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info5
2388: := lv_employer_ss_id;
2389: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info6
2390: := trn(i).dis_num;
2391: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info7

Line 2389: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info6

2385: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info4
2386: := trn(i).type;
2387: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info5
2388: := lv_employer_ss_id;
2389: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info6
2390: := trn(i).dis_num;
2391: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info7
2392: := trn(i).abs_days;
2393: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info8

Line 2391: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info7

2387: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info5
2388: := lv_employer_ss_id;
2389: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info6
2390: := trn(i).dis_num;
2391: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info7
2392: := trn(i).abs_days;
2393: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info8
2394: := to_char(trn(i).idw_vol_contr,'99999.99');
2395: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info9

Line 2393: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info8

2389: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info6
2390: := trn(i).dis_num;
2391: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info7
2392: := trn(i).abs_days;
2393: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info8
2394: := to_char(trn(i).idw_vol_contr,'99999.99');
2395: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info9
2396: := NULL;
2397: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info10

Line 2395: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info9

2391: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info7
2392: := trn(i).abs_days;
2393: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info8
2394: := to_char(trn(i).idw_vol_contr,'99999.99');
2395: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info9
2396: := NULL;
2397: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info10
2398: := lv_do_not_report;
2399: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info11

Line 2397: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info10

2393: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info8
2394: := to_char(trn(i).idw_vol_contr,'99999.99');
2395: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info9
2396: := NULL;
2397: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info10
2398: := lv_do_not_report;
2399: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info11
2400: := trn(i).salary_type;
2401: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info12

Line 2399: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info11

2395: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info9
2396: := NULL;
2397: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info10
2398: := lv_do_not_report;
2399: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info11
2400: := trn(i).salary_type;
2401: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info12
2402: := trn(i).credit_number;
2403: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info13

Line 2401: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info12

2397: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info10
2398: := lv_do_not_report;
2399: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info11
2400: := trn(i).salary_type;
2401: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info12
2402: := trn(i).credit_number;
2403: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info13
2404: := trn(i).discount_type;
2405: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info14

Line 2403: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info13

2399: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info11
2400: := trn(i).salary_type;
2401: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info12
2402: := trn(i).credit_number;
2403: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info13
2404: := trn(i).discount_type;
2405: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info14
2406: := trn(i).discount_value;
2407: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info15

Line 2405: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info14

2401: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info12
2402: := trn(i).credit_number;
2403: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info13
2404: := trn(i).discount_type;
2405: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info14
2406: := trn(i).discount_value;
2407: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info15
2408: := trn(i).redxn_table_applies;
2409: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info16

Line 2407: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info15

2403: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info13
2404: := trn(i).discount_type;
2405: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info14
2406: := trn(i).discount_value;
2407: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info15
2408: := trn(i).redxn_table_applies;
2409: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info16
2410: := trn(i).abs_start_date;
2411: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info17

Line 2409: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info16

2405: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info14
2406: := trn(i).discount_value;
2407: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info15
2408: := trn(i).redxn_table_applies;
2409: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info16
2410: := trn(i).abs_start_date;
2411: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info17
2412: := trn(i).subsidized_days;
2413: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info18

Line 2411: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info17

2407: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info15
2408: := trn(i).redxn_table_applies;
2409: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info16
2410: := trn(i).abs_start_date;
2411: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info17
2412: := trn(i).subsidized_days;
2413: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info18
2414: := trn(i).disability_percent;
2415: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info19

Line 2413: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info18

2409: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info16
2410: := trn(i).abs_start_date;
2411: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info17
2412: := trn(i).subsidized_days;
2413: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info18
2414: := trn(i).disability_percent;
2415: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info19
2416: := trn(i).dis_insurance_type;
2417: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info20

Line 2415: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info19

2411: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info17
2412: := trn(i).subsidized_days;
2413: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info18
2414: := trn(i).disability_percent;
2415: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info19
2416: := trn(i).dis_insurance_type;
2417: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info20
2418: := trn(i).risk_type;
2419: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info21

Line 2417: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info20

2413: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info18
2414: := trn(i).disability_percent;
2415: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info19
2416: := trn(i).dis_insurance_type;
2417: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info20
2418: := trn(i).risk_type;
2419: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info21
2420: := trn(i).consequence;
2421: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info22

Line 2419: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info21

2415: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info19
2416: := trn(i).dis_insurance_type;
2417: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info20
2418: := trn(i).risk_type;
2419: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info21
2420: := trn(i).consequence;
2421: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info22
2422: := trn(i).disability_control;
2423: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info23

Line 2421: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info22

2417: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info20
2418: := trn(i).risk_type;
2419: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info21
2420: := trn(i).consequence;
2421: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info22
2422: := trn(i).disability_control;
2423: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info23
2424: := trn(i).abs_end_date;
2425: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info25

Line 2423: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info23

2419: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info21
2420: := trn(i).consequence;
2421: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info22
2422: := trn(i).disability_control;
2423: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info23
2424: := trn(i).abs_end_date;
2425: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info25
2426: := lv_exclude_start_date; /*8438074*/
2427: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info26

Line 2425: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info25

2421: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info22
2422: := trn(i).disability_control;
2423: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info23
2424: := trn(i).abs_end_date;
2425: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info25
2426: := lv_exclude_start_date; /*8438074*/
2427: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info26
2428: := lv_exclude_end_date; /*8438074*/
2429:

Line 2427: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info26

2423: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info23
2424: := trn(i).abs_end_date;
2425: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info25
2426: := lv_exclude_start_date; /*8438074*/
2427: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info26
2428: := lv_exclude_end_date; /*8438074*/
2429:
2430: END LOOP;
2431:

Line 3369: ln_index := pay_mx_soc_sec_archive.lrr_act_tab.COUNT;

3365:
3366: END IF;
3367: /*8438074 End*/
3368:
3369: ln_index := pay_mx_soc_sec_archive.lrr_act_tab.COUNT;
3370:
3371: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).action_info_category
3372: := 'MX SS TRANSACTIONS';
3373: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).jurisdiction_code

Line 3371: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).action_info_category

3367: /*8438074 End*/
3368:
3369: ln_index := pay_mx_soc_sec_archive.lrr_act_tab.COUNT;
3370:
3371: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).action_info_category
3372: := 'MX SS TRANSACTIONS';
3373: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).jurisdiction_code
3374: := NULL;
3375: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info1

Line 3373: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).jurisdiction_code

3369: ln_index := pay_mx_soc_sec_archive.lrr_act_tab.COUNT;
3370:
3371: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).action_info_category
3372: := 'MX SS TRANSACTIONS';
3373: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).jurisdiction_code
3374: := NULL;
3375: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info1
3376: := p_person_id;
3377: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info2

Line 3375: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info1

3371: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).action_info_category
3372: := 'MX SS TRANSACTIONS';
3373: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).jurisdiction_code
3374: := NULL;
3375: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info1
3376: := p_person_id;
3377: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info2
3378: := lv_transaction_date;
3379: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info3

Line 3377: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info2

3373: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).jurisdiction_code
3374: := NULL;
3375: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info1
3376: := p_person_id;
3377: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info2
3378: := lv_transaction_date;
3379: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info3
3380: := lv_employee_ssn;
3381: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info4

Line 3379: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info3

3375: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info1
3376: := p_person_id;
3377: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info2
3378: := lv_transaction_date;
3379: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info3
3380: := lv_employee_ssn;
3381: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info4
3382: := lv_transaction_type;
3383: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info5

Line 3381: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info4

3377: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info2
3378: := lv_transaction_date;
3379: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info3
3380: := lv_employee_ssn;
3381: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info4
3382: := lv_transaction_type;
3383: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info5
3384: := lv_employer_ss_id;
3385: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info6

Line 3383: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info5

3379: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info3
3380: := lv_employee_ssn;
3381: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info4
3382: := lv_transaction_type;
3383: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info5
3384: := lv_employer_ss_id;
3385: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info6
3386: := NULL;
3387: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info7

Line 3385: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info6

3381: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info4
3382: := lv_transaction_type;
3383: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info5
3384: := lv_employer_ss_id;
3385: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info6
3386: := NULL;
3387: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info7
3388: := NULL;
3389: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info8

Line 3387: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info7

3383: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info5
3384: := lv_employer_ss_id;
3385: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info6
3386: := NULL;
3387: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info7
3388: := NULL;
3389: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info8
3390: := lv_idw;
3391: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info9

Line 3389: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info8

3385: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info6
3386: := NULL;
3387: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info7
3388: := NULL;
3389: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info8
3390: := lv_idw;
3391: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info9
3392: := lv_leaving_reason;
3393: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info10

Line 3391: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info9

3387: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info7
3388: := NULL;
3389: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info8
3390: := lv_idw;
3391: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info9
3392: := lv_leaving_reason;
3393: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info10
3394: := lv_do_not_report;
3395: IF pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info11 IS NULL THEN

Line 3393: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info10

3389: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info8
3390: := lv_idw;
3391: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info9
3392: := lv_leaving_reason;
3393: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info10
3394: := lv_do_not_report;
3395: IF pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info11 IS NULL THEN
3396: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info11
3397: := ln_salary_type;

Line 3395: IF pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info11 IS NULL THEN

3391: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info9
3392: := lv_leaving_reason;
3393: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info10
3394: := lv_do_not_report;
3395: IF pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info11 IS NULL THEN
3396: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info11
3397: := ln_salary_type;
3398: END IF; /*6933682*/
3399: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info24

Line 3396: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info11

3392: := lv_leaving_reason;
3393: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info10
3394: := lv_do_not_report;
3395: IF pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info11 IS NULL THEN
3396: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info11
3397: := ln_salary_type;
3398: END IF; /*6933682*/
3399: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info24
3400: := lv_report_yes_no;

Line 3399: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info24

3395: IF pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info11 IS NULL THEN
3396: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info11
3397: := ln_salary_type;
3398: END IF; /*6933682*/
3399: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info24
3400: := lv_report_yes_no;
3401: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info25
3402: := lv_exclude_start_date; /*8438074*/
3403: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info26

Line 3401: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info25

3397: := ln_salary_type;
3398: END IF; /*6933682*/
3399: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info24
3400: := lv_report_yes_no;
3401: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info25
3402: := lv_exclude_start_date; /*8438074*/
3403: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info26
3404: := lv_exclude_end_date; /*8438074*/
3405: hr_utility_trace('Archived MX SS Transaction for hire');

Line 3403: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info26

3399: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info24
3400: := lv_report_yes_no;
3401: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info25
3402: := lv_exclude_start_date; /*8438074*/
3403: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info26
3404: := lv_exclude_end_date; /*8438074*/
3405: hr_utility_trace('Archived MX SS Transaction for hire');
3406: hr_utility_trace('-----------------------------------');
3407: hr_utility_trace('index ' || ln_index);

Line 3408: hr_utility_trace('pay_mx_soc_sec_archive.lrr_act_tab(ln_index).action_info_category ' ||

3404: := lv_exclude_end_date; /*8438074*/
3405: hr_utility_trace('Archived MX SS Transaction for hire');
3406: hr_utility_trace('-----------------------------------');
3407: hr_utility_trace('index ' || ln_index);
3408: hr_utility_trace('pay_mx_soc_sec_archive.lrr_act_tab(ln_index).action_info_category ' ||
3409: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).action_info_category);
3410: hr_utility_trace(' pay_mx_soc_sec_archive.lrr_act_tab(ln_index).jurisdiction_code ' ||
3411: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).jurisdiction_code);
3412: hr_utility_trace('Person ID ' ||

Line 3409: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).action_info_category);

3405: hr_utility_trace('Archived MX SS Transaction for hire');
3406: hr_utility_trace('-----------------------------------');
3407: hr_utility_trace('index ' || ln_index);
3408: hr_utility_trace('pay_mx_soc_sec_archive.lrr_act_tab(ln_index).action_info_category ' ||
3409: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).action_info_category);
3410: hr_utility_trace(' pay_mx_soc_sec_archive.lrr_act_tab(ln_index).jurisdiction_code ' ||
3411: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).jurisdiction_code);
3412: hr_utility_trace('Person ID ' ||
3413: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info1);

Line 3410: hr_utility_trace(' pay_mx_soc_sec_archive.lrr_act_tab(ln_index).jurisdiction_code ' ||

3406: hr_utility_trace('-----------------------------------');
3407: hr_utility_trace('index ' || ln_index);
3408: hr_utility_trace('pay_mx_soc_sec_archive.lrr_act_tab(ln_index).action_info_category ' ||
3409: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).action_info_category);
3410: hr_utility_trace(' pay_mx_soc_sec_archive.lrr_act_tab(ln_index).jurisdiction_code ' ||
3411: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).jurisdiction_code);
3412: hr_utility_trace('Person ID ' ||
3413: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info1);
3414: hr_utility_trace('Transaction date ' ||

Line 3411: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).jurisdiction_code);

3407: hr_utility_trace('index ' || ln_index);
3408: hr_utility_trace('pay_mx_soc_sec_archive.lrr_act_tab(ln_index).action_info_category ' ||
3409: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).action_info_category);
3410: hr_utility_trace(' pay_mx_soc_sec_archive.lrr_act_tab(ln_index).jurisdiction_code ' ||
3411: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).jurisdiction_code);
3412: hr_utility_trace('Person ID ' ||
3413: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info1);
3414: hr_utility_trace('Transaction date ' ||
3415: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info2);

Line 3413: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info1);

3409: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).action_info_category);
3410: hr_utility_trace(' pay_mx_soc_sec_archive.lrr_act_tab(ln_index).jurisdiction_code ' ||
3411: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).jurisdiction_code);
3412: hr_utility_trace('Person ID ' ||
3413: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info1);
3414: hr_utility_trace('Transaction date ' ||
3415: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info2);
3416: hr_utility_trace('transaction type ' ||
3417: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info4);

Line 3415: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info2);

3411: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).jurisdiction_code);
3412: hr_utility_trace('Person ID ' ||
3413: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info1);
3414: hr_utility_trace('Transaction date ' ||
3415: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info2);
3416: hr_utility_trace('transaction type ' ||
3417: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info4);
3418: hr_utility_trace('-----------------------------------');
3419:

Line 3417: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info4);

3413: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info1);
3414: hr_utility_trace('Transaction date ' ||
3415: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info2);
3416: hr_utility_trace('transaction type ' ||
3417: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info4);
3418: hr_utility_trace('-----------------------------------');
3419:
3420:
3421: ELSE

Line 4102: ln_index := pay_mx_soc_sec_archive.lrr_act_tab.COUNT;

4098:
4099: hr_utility.set_location(gv_package || lv_procedure_name, 80);
4100: ln_step := 8;
4101:
4102: ln_index := pay_mx_soc_sec_archive.lrr_act_tab.COUNT;
4103:
4104: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).action_info_category
4105: := 'MX SS PERSON INFORMATION';
4106: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).jurisdiction_code := NULL;

Line 4104: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).action_info_category

4100: ln_step := 8;
4101:
4102: ln_index := pay_mx_soc_sec_archive.lrr_act_tab.COUNT;
4103:
4104: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).action_info_category
4105: := 'MX SS PERSON INFORMATION';
4106: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).jurisdiction_code := NULL;
4107: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info1 := ln_person_id;
4108: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info2 := lv_emp_ssn;

Line 4106: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).jurisdiction_code := NULL;

4102: ln_index := pay_mx_soc_sec_archive.lrr_act_tab.COUNT;
4103:
4104: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).action_info_category
4105: := 'MX SS PERSON INFORMATION';
4106: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).jurisdiction_code := NULL;
4107: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info1 := ln_person_id;
4108: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info2 := lv_emp_ssn;
4109: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info3 := lv_tax_rfc_id;
4110: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info4 := lv_curp;

Line 4107: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info1 := ln_person_id;

4103:
4104: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).action_info_category
4105: := 'MX SS PERSON INFORMATION';
4106: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).jurisdiction_code := NULL;
4107: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info1 := ln_person_id;
4108: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info2 := lv_emp_ssn;
4109: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info3 := lv_tax_rfc_id;
4110: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info4 := lv_curp;
4111: /*Bug:9820914: Handling Spcial Chars in Employee Name */

Line 4108: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info2 := lv_emp_ssn;

4104: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).action_info_category
4105: := 'MX SS PERSON INFORMATION';
4106: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).jurisdiction_code := NULL;
4107: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info1 := ln_person_id;
4108: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info2 := lv_emp_ssn;
4109: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info3 := lv_tax_rfc_id;
4110: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info4 := lv_curp;
4111: /*Bug:9820914: Handling Spcial Chars in Employee Name */
4112: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info5

Line 4109: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info3 := lv_tax_rfc_id;

4105: := 'MX SS PERSON INFORMATION';
4106: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).jurisdiction_code := NULL;
4107: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info1 := ln_person_id;
4108: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info2 := lv_emp_ssn;
4109: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info3 := lv_tax_rfc_id;
4110: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info4 := lv_curp;
4111: /*Bug:9820914: Handling Spcial Chars in Employee Name */
4112: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info5
4113: := replace(pay_mx_rules.strip_spl_chars(lv_paternal_last_name),'/','N');

Line 4110: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info4 := lv_curp;

4106: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).jurisdiction_code := NULL;
4107: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info1 := ln_person_id;
4108: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info2 := lv_emp_ssn;
4109: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info3 := lv_tax_rfc_id;
4110: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info4 := lv_curp;
4111: /*Bug:9820914: Handling Spcial Chars in Employee Name */
4112: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info5
4113: := replace(pay_mx_rules.strip_spl_chars(lv_paternal_last_name),'/','N');
4114: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info6

Line 4112: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info5

4108: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info2 := lv_emp_ssn;
4109: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info3 := lv_tax_rfc_id;
4110: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info4 := lv_curp;
4111: /*Bug:9820914: Handling Spcial Chars in Employee Name */
4112: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info5
4113: := replace(pay_mx_rules.strip_spl_chars(lv_paternal_last_name),'/','N');
4114: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info6
4115: := replace(pay_mx_rules.strip_spl_chars(lv_maternal_last_name),'/','N');
4116: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info7

Line 4114: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info6

4110: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info4 := lv_curp;
4111: /*Bug:9820914: Handling Spcial Chars in Employee Name */
4112: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info5
4113: := replace(pay_mx_rules.strip_spl_chars(lv_paternal_last_name),'/','N');
4114: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info6
4115: := replace(pay_mx_rules.strip_spl_chars(lv_maternal_last_name),'/','N');
4116: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info7
4117: := replace(pay_mx_rules.strip_spl_chars(lv_emp_name),'/','N');
4118: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info8 := lv_worker_type;

Line 4116: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info7

4112: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info5
4113: := replace(pay_mx_rules.strip_spl_chars(lv_paternal_last_name),'/','N');
4114: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info6
4115: := replace(pay_mx_rules.strip_spl_chars(lv_maternal_last_name),'/','N');
4116: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info7
4117: := replace(pay_mx_rules.strip_spl_chars(lv_emp_name),'/','N');
4118: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info8 := lv_worker_type;
4119: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info9
4120: := lv_red_work_week_ind;

Line 4118: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info8 := lv_worker_type;

4114: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info6
4115: := replace(pay_mx_rules.strip_spl_chars(lv_maternal_last_name),'/','N');
4116: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info7
4117: := replace(pay_mx_rules.strip_spl_chars(lv_emp_name),'/','N');
4118: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info8 := lv_worker_type;
4119: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info9
4120: := lv_red_work_week_ind;
4121: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info10 := lv_hire_date;
4122: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info11

Line 4119: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info9

4115: := replace(pay_mx_rules.strip_spl_chars(lv_maternal_last_name),'/','N');
4116: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info7
4117: := replace(pay_mx_rules.strip_spl_chars(lv_emp_name),'/','N');
4118: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info8 := lv_worker_type;
4119: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info9
4120: := lv_red_work_week_ind;
4121: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info10 := lv_hire_date;
4122: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info11
4123: := to_char(ln_idw,'99999.99');

Line 4121: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info10 := lv_hire_date;

4117: := replace(pay_mx_rules.strip_spl_chars(lv_emp_name),'/','N');
4118: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info8 := lv_worker_type;
4119: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info9
4120: := lv_red_work_week_ind;
4121: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info10 := lv_hire_date;
4122: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info11
4123: := to_char(ln_idw,'99999.99');
4124: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info12 := lv_location_code;
4125: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info13 := gv_credit_no;

Line 4122: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info11

4118: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info8 := lv_worker_type;
4119: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info9
4120: := lv_red_work_week_ind;
4121: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info10 := lv_hire_date;
4122: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info11
4123: := to_char(ln_idw,'99999.99');
4124: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info12 := lv_location_code;
4125: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info13 := gv_credit_no;
4126: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info14

Line 4124: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info12 := lv_location_code;

4120: := lv_red_work_week_ind;
4121: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info10 := lv_hire_date;
4122: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info11
4123: := to_char(ln_idw,'99999.99');
4124: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info12 := lv_location_code;
4125: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info13 := gv_credit_no;
4126: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info14
4127: := gv_credit_start_date;
4128: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info15 := gv_discount_type;

Line 4125: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info13 := gv_credit_no;

4121: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info10 := lv_hire_date;
4122: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info11
4123: := to_char(ln_idw,'99999.99');
4124: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info12 := lv_location_code;
4125: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info13 := gv_credit_no;
4126: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info14
4127: := gv_credit_start_date;
4128: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info15 := gv_discount_type;
4129: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info16

Line 4126: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info14

4122: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info11
4123: := to_char(ln_idw,'99999.99');
4124: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info12 := lv_location_code;
4125: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info13 := gv_credit_no;
4126: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info14
4127: := gv_credit_start_date;
4128: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info15 := gv_discount_type;
4129: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info16
4130: := gv_discount_value;

Line 4128: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info15 := gv_discount_type;

4124: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info12 := lv_location_code;
4125: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info13 := gv_credit_no;
4126: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info14
4127: := gv_credit_start_date;
4128: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info15 := gv_discount_type;
4129: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info16
4130: := gv_discount_value;
4131: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info17 := NULL;
4132: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info18 := lv_salary_type;

Line 4129: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info16

4125: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info13 := gv_credit_no;
4126: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info14
4127: := gv_credit_start_date;
4128: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info15 := gv_discount_type;
4129: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info16
4130: := gv_discount_value;
4131: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info17 := NULL;
4132: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info18 := lv_salary_type;
4133: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info19

Line 4131: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info17 := NULL;

4127: := gv_credit_start_date;
4128: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info15 := gv_discount_type;
4129: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info16
4130: := gv_discount_value;
4131: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info17 := NULL;
4132: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info18 := lv_salary_type;
4133: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info19
4134: := lv_medical_center;
4135: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info20 := lv_worker_id;

Line 4132: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info18 := lv_salary_type;

4128: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info15 := gv_discount_type;
4129: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info16
4130: := gv_discount_value;
4131: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info17 := NULL;
4132: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info18 := lv_salary_type;
4133: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info19
4134: := lv_medical_center;
4135: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info20 := lv_worker_id;
4136: -- Segment 21 is the 'Do Not Report on Magtape' flag

Line 4133: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info19

4129: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info16
4130: := gv_discount_value;
4131: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info17 := NULL;
4132: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info18 := lv_salary_type;
4133: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info19
4134: := lv_medical_center;
4135: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info20 := lv_worker_id;
4136: -- Segment 21 is the 'Do Not Report on Magtape' flag
4137: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info22 := gv_crdt_grant_dt;

Line 4135: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info20 := lv_worker_id;

4131: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info17 := NULL;
4132: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info18 := lv_salary_type;
4133: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info19
4134: := lv_medical_center;
4135: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info20 := lv_worker_id;
4136: -- Segment 21 is the 'Do Not Report on Magtape' flag
4137: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info22 := gv_crdt_grant_dt;
4138:
4139: hr_utility.set_location(gv_package || lv_procedure_name, 90);

Line 4137: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info22 := gv_crdt_grant_dt;

4133: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info19
4134: := lv_medical_center;
4135: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info20 := lv_worker_id;
4136: -- Segment 21 is the 'Do Not Report on Magtape' flag
4137: pay_mx_soc_sec_archive.lrr_act_tab(ln_index).act_info22 := gv_crdt_grant_dt;
4138:
4139: hr_utility.set_location(gv_package || lv_procedure_name, 90);
4140:
4141: EXCEPTION

Line 4298: lv_exists := pay_mx_soc_sec_archive.seniority_changed (p_person_id,

4294: CLOSE c_chk_pay_process_events;
4295: hr_utility.set_location(gv_package || lv_procedure_name, 20);
4296:
4297: IF gv_IDW_calc_method = 'B' THEN
4298: lv_exists := pay_mx_soc_sec_archive.seniority_changed (p_person_id,
4299: p_end_date,
4300: p_start_date);
4301: IF lv_exists = 'Y' THEN
4302: RETURN lv_exists;

Line 4391: IF pay_mx_soc_sec_archive.arch_exists_without_upgrade(ln_business_group_id)

4387: hr_utility_trace('lv_start_date :' || lv_start_date);
4388: hr_utility_trace('lv_end_date :' || lv_end_date);
4389: hr_utility_trace('ln_business_group_id :' || ln_business_group_id);
4390:
4391: IF pay_mx_soc_sec_archive.arch_exists_without_upgrade(ln_business_group_id)
4392: = 'B' THEN
4393: pay_generic_upgrade.new_business_group (
4394: p_bus_grp_id => ln_business_group_id,
4395: p_leg_code => NULL);

Line 4992: IF ( pay_mx_soc_sec_archive.per_asg.EXISTS(ln_person_id) = FALSE )

4988: ln_step := 7;
4989:
4990: hr_utility_trace('--> In STep 7');
4991:
4992: IF ( pay_mx_soc_sec_archive.per_asg.EXISTS(ln_person_id) = FALSE )
4993: THEN
4994: hr_utility_trace('--> Adding in pay_mx_soc_sec_archive.per_asg ');
4995: pay_mx_soc_sec_archive.per_asg(ln_person_id).person_id :=
4996: ln_person_id;

Line 4994: hr_utility_trace('--> Adding in pay_mx_soc_sec_archive.per_asg ');

4990: hr_utility_trace('--> In STep 7');
4991:
4992: IF ( pay_mx_soc_sec_archive.per_asg.EXISTS(ln_person_id) = FALSE )
4993: THEN
4994: hr_utility_trace('--> Adding in pay_mx_soc_sec_archive.per_asg ');
4995: pay_mx_soc_sec_archive.per_asg(ln_person_id).person_id :=
4996: ln_person_id;
4997: pay_mx_soc_sec_archive.per_asg(ln_person_id).assignment_id :=
4998: ln_assignment_id;

Line 4995: pay_mx_soc_sec_archive.per_asg(ln_person_id).person_id :=

4991:
4992: IF ( pay_mx_soc_sec_archive.per_asg.EXISTS(ln_person_id) = FALSE )
4993: THEN
4994: hr_utility_trace('--> Adding in pay_mx_soc_sec_archive.per_asg ');
4995: pay_mx_soc_sec_archive.per_asg(ln_person_id).person_id :=
4996: ln_person_id;
4997: pay_mx_soc_sec_archive.per_asg(ln_person_id).assignment_id :=
4998: ln_assignment_id;
4999: END IF;

Line 4997: pay_mx_soc_sec_archive.per_asg(ln_person_id).assignment_id :=

4993: THEN
4994: hr_utility_trace('--> Adding in pay_mx_soc_sec_archive.per_asg ');
4995: pay_mx_soc_sec_archive.per_asg(ln_person_id).person_id :=
4996: ln_person_id;
4997: pay_mx_soc_sec_archive.per_asg(ln_person_id).assignment_id :=
4998: ln_assignment_id;
4999: END IF;
5000:
5001: hr_utility_trace('--> lv_report_mode '||lv_report_mode);

Line 5055: pay_mx_soc_sec_archive.per_asg.delete;

5051: 'MX_IDWV=' || lv_report_mode || '|'
5052: WHERE assignment_action_id = ln_asg_act_id;
5053:
5054:
5055: pay_mx_soc_sec_archive.per_asg.delete;
5056:
5057: END IF; -- ln_events_found
5058:
5059: END IF; -- gn_implementation

Line 5164: pay_mx_soc_sec_archive.lrr_act_tab.DELETE;

5160: hr_utility_trace('--> Archive_data' );
5161: hr_utility_trace('--> p_asg_action_id ' || p_asg_action_id );
5162: hr_utility_trace('--> p_effective_date' || p_effective_date );
5163:
5164: pay_mx_soc_sec_archive.lrr_act_tab.DELETE;
5165:
5166: lv_procedure_name := 'archive_data';
5167: gn_person_rec_chng := 0;
5168: gn_gre_found := 0;

Line 5312: IF pay_mx_soc_sec_archive.lrr_act_tab.COUNT > 0 THEN

5308: l_act_tab.DELETE;
5309: j := 0;
5310:
5311:
5312: IF pay_mx_soc_sec_archive.lrr_act_tab.COUNT > 0 THEN
5313: FOR i IN pay_mx_soc_sec_archive.lrr_act_tab.FIRST..
5314: pay_mx_soc_sec_archive.lrr_act_tab.LAST
5315: LOOP
5316:

Line 5313: FOR i IN pay_mx_soc_sec_archive.lrr_act_tab.FIRST..

5309: j := 0;
5310:
5311:
5312: IF pay_mx_soc_sec_archive.lrr_act_tab.COUNT > 0 THEN
5313: FOR i IN pay_mx_soc_sec_archive.lrr_act_tab.FIRST..
5314: pay_mx_soc_sec_archive.lrr_act_tab.LAST
5315: LOOP
5316:
5317: IF pay_mx_soc_sec_archive.lrr_act_tab(i).action_info_category

Line 5314: pay_mx_soc_sec_archive.lrr_act_tab.LAST

5310:
5311:
5312: IF pay_mx_soc_sec_archive.lrr_act_tab.COUNT > 0 THEN
5313: FOR i IN pay_mx_soc_sec_archive.lrr_act_tab.FIRST..
5314: pay_mx_soc_sec_archive.lrr_act_tab.LAST
5315: LOOP
5316:
5317: IF pay_mx_soc_sec_archive.lrr_act_tab(i).action_info_category
5318: = 'MX SS TRANSACTIONS' THEN

Line 5317: IF pay_mx_soc_sec_archive.lrr_act_tab(i).action_info_category

5313: FOR i IN pay_mx_soc_sec_archive.lrr_act_tab.FIRST..
5314: pay_mx_soc_sec_archive.lrr_act_tab.LAST
5315: LOOP
5316:
5317: IF pay_mx_soc_sec_archive.lrr_act_tab(i).action_info_category
5318: = 'MX SS TRANSACTIONS' THEN
5319: /*Added code for bug 6862116*/
5320: hr_utility_trace('Checking for active employe ..for MX SS TRANSACTIONS' );
5321: OPEN c_check_active_employee(pay_mx_soc_sec_archive.lrr_act_tab(i).ACT_INFO1,

Line 5321: OPEN c_check_active_employee(pay_mx_soc_sec_archive.lrr_act_tab(i).ACT_INFO1,

5317: IF pay_mx_soc_sec_archive.lrr_act_tab(i).action_info_category
5318: = 'MX SS TRANSACTIONS' THEN
5319: /*Added code for bug 6862116*/
5320: hr_utility_trace('Checking for active employe ..for MX SS TRANSACTIONS' );
5321: OPEN c_check_active_employee(pay_mx_soc_sec_archive.lrr_act_tab(i).ACT_INFO1,
5322: pay_mx_soc_sec_archive.lrr_act_tab(i).ACT_INFO2);
5323: FETCH c_check_active_employee INTO lv_is_employee;
5324: CLOSE c_check_active_employee;
5325:

Line 5322: pay_mx_soc_sec_archive.lrr_act_tab(i).ACT_INFO2);

5318: = 'MX SS TRANSACTIONS' THEN
5319: /*Added code for bug 6862116*/
5320: hr_utility_trace('Checking for active employe ..for MX SS TRANSACTIONS' );
5321: OPEN c_check_active_employee(pay_mx_soc_sec_archive.lrr_act_tab(i).ACT_INFO1,
5322: pay_mx_soc_sec_archive.lrr_act_tab(i).ACT_INFO2);
5323: FETCH c_check_active_employee INTO lv_is_employee;
5324: CLOSE c_check_active_employee;
5325:
5326: hr_utility_trace('Person ID for MX SS Transcations .. ' || pay_mx_soc_sec_archive.lrr_act_tab(i).ACT_INFO1);

Line 5326: hr_utility_trace('Person ID for MX SS Transcations .. ' || pay_mx_soc_sec_archive.lrr_act_tab(i).ACT_INFO1);

5322: pay_mx_soc_sec_archive.lrr_act_tab(i).ACT_INFO2);
5323: FETCH c_check_active_employee INTO lv_is_employee;
5324: CLOSE c_check_active_employee;
5325:
5326: hr_utility_trace('Person ID for MX SS Transcations .. ' || pay_mx_soc_sec_archive.lrr_act_tab(i).ACT_INFO1);
5327: hr_utility_trace('Transaction Date for MX SS Transcations .. ' || pay_mx_soc_sec_archive.lrr_act_tab(i).ACT_INFO2);
5328: hr_utility_trace('IS Employee active .. ' || lv_is_employee);
5329:
5330: IF (TRUNC(fnd_date.canonical_to_date(

Line 5327: hr_utility_trace('Transaction Date for MX SS Transcations .. ' || pay_mx_soc_sec_archive.lrr_act_tab(i).ACT_INFO2);

5323: FETCH c_check_active_employee INTO lv_is_employee;
5324: CLOSE c_check_active_employee;
5325:
5326: hr_utility_trace('Person ID for MX SS Transcations .. ' || pay_mx_soc_sec_archive.lrr_act_tab(i).ACT_INFO1);
5327: hr_utility_trace('Transaction Date for MX SS Transcations .. ' || pay_mx_soc_sec_archive.lrr_act_tab(i).ACT_INFO2);
5328: hr_utility_trace('IS Employee active .. ' || lv_is_employee);
5329:
5330: IF (TRUNC(fnd_date.canonical_to_date(
5331: pay_mx_soc_sec_archive.lrr_act_tab(i).act_info2)) =

Line 5331: pay_mx_soc_sec_archive.lrr_act_tab(i).act_info2)) =

5327: hr_utility_trace('Transaction Date for MX SS Transcations .. ' || pay_mx_soc_sec_archive.lrr_act_tab(i).ACT_INFO2);
5328: hr_utility_trace('IS Employee active .. ' || lv_is_employee);
5329:
5330: IF (TRUNC(fnd_date.canonical_to_date(
5331: pay_mx_soc_sec_archive.lrr_act_tab(i).act_info2)) =
5332: TRUNC(fnd_date.canonical_to_date('4712/12/31'))) OR lv_is_employee = 'N' THEN
5333:
5334: NULL;
5335: hr_utility_trace('--> NULL' );

Line 5337: l_act_tab(j) := pay_mx_soc_sec_archive.lrr_act_tab(i);

5333:
5334: NULL;
5335: hr_utility_trace('--> NULL' );
5336: ELSE
5337: l_act_tab(j) := pay_mx_soc_sec_archive.lrr_act_tab(i);
5338:
5339: j := j + 1;
5340:
5341: END if;

Line 5343: ELSIF pay_mx_soc_sec_archive.lrr_act_tab(i).action_info_category

5339: j := j + 1;
5340:
5341: END if;
5342:
5343: ELSIF pay_mx_soc_sec_archive.lrr_act_tab(i).action_info_category
5344: = 'MX SS PERSON INFORMATION' THEN
5345: hr_utility_trace('Checking for active employe ..for MX SS PERSON Information' );
5346: OPEN c_check_active_employee (pay_mx_soc_sec_archive.lrr_act_tab(i).ACT_INFO1,
5347: pay_mx_soc_sec_archive.lrr_act_tab(i).ACT_INFO10);

Line 5346: OPEN c_check_active_employee (pay_mx_soc_sec_archive.lrr_act_tab(i).ACT_INFO1,

5342:
5343: ELSIF pay_mx_soc_sec_archive.lrr_act_tab(i).action_info_category
5344: = 'MX SS PERSON INFORMATION' THEN
5345: hr_utility_trace('Checking for active employe ..for MX SS PERSON Information' );
5346: OPEN c_check_active_employee (pay_mx_soc_sec_archive.lrr_act_tab(i).ACT_INFO1,
5347: pay_mx_soc_sec_archive.lrr_act_tab(i).ACT_INFO10);
5348: FETCH c_check_active_employee INTO lv_is_employee;
5349: CLOSE c_check_active_employee;
5350:

Line 5347: pay_mx_soc_sec_archive.lrr_act_tab(i).ACT_INFO10);

5343: ELSIF pay_mx_soc_sec_archive.lrr_act_tab(i).action_info_category
5344: = 'MX SS PERSON INFORMATION' THEN
5345: hr_utility_trace('Checking for active employe ..for MX SS PERSON Information' );
5346: OPEN c_check_active_employee (pay_mx_soc_sec_archive.lrr_act_tab(i).ACT_INFO1,
5347: pay_mx_soc_sec_archive.lrr_act_tab(i).ACT_INFO10);
5348: FETCH c_check_active_employee INTO lv_is_employee;
5349: CLOSE c_check_active_employee;
5350:
5351: hr_utility_trace('Person ID for MX SS Transcations .. ' || pay_mx_soc_sec_archive.lrr_act_tab(i).ACT_INFO1);

Line 5351: hr_utility_trace('Person ID for MX SS Transcations .. ' || pay_mx_soc_sec_archive.lrr_act_tab(i).ACT_INFO1);

5347: pay_mx_soc_sec_archive.lrr_act_tab(i).ACT_INFO10);
5348: FETCH c_check_active_employee INTO lv_is_employee;
5349: CLOSE c_check_active_employee;
5350:
5351: hr_utility_trace('Person ID for MX SS Transcations .. ' || pay_mx_soc_sec_archive.lrr_act_tab(i).ACT_INFO1);
5352: hr_utility_trace('Transaction Date for MX SS Transcations .. ' || pay_mx_soc_sec_archive.lrr_act_tab(i).ACT_INFO10);
5353:
5354: hr_utility_trace('IS Employee active .. ' || lv_is_employee);
5355:

Line 5352: hr_utility_trace('Transaction Date for MX SS Transcations .. ' || pay_mx_soc_sec_archive.lrr_act_tab(i).ACT_INFO10);

5348: FETCH c_check_active_employee INTO lv_is_employee;
5349: CLOSE c_check_active_employee;
5350:
5351: hr_utility_trace('Person ID for MX SS Transcations .. ' || pay_mx_soc_sec_archive.lrr_act_tab(i).ACT_INFO1);
5352: hr_utility_trace('Transaction Date for MX SS Transcations .. ' || pay_mx_soc_sec_archive.lrr_act_tab(i).ACT_INFO10);
5353:
5354: hr_utility_trace('IS Employee active .. ' || lv_is_employee);
5355:
5356:

Line 5362: l_act_tab(j) := pay_mx_soc_sec_archive.lrr_act_tab(i);

5358:
5359: NULL ;
5360:
5361: ELSE
5362: l_act_tab(j) := pay_mx_soc_sec_archive.lrr_act_tab(i);
5363:
5364: j := j + 1;
5365:
5366: END IF ;

Line 5369: l_act_tab(j) := pay_mx_soc_sec_archive.lrr_act_tab(i);

5365:
5366: END IF ;
5367:
5368: ELSE
5369: l_act_tab(j) := pay_mx_soc_sec_archive.lrr_act_tab(i);
5370:
5371: j := j + 1;
5372:
5373: END IF;

Line 5377: pay_mx_soc_sec_archive.lrr_act_tab.DELETE;

5373: END IF;
5374:
5375: END LOOP;
5376:
5377: pay_mx_soc_sec_archive.lrr_act_tab.DELETE;
5378:
5379: IF l_act_tab.COUNT > 0 THEN
5380: pay_mx_soc_sec_archive.lrr_act_tab := l_act_tab;
5381: END IF;

Line 5380: pay_mx_soc_sec_archive.lrr_act_tab := l_act_tab;

5376:
5377: pay_mx_soc_sec_archive.lrr_act_tab.DELETE;
5378:
5379: IF l_act_tab.COUNT > 0 THEN
5380: pay_mx_soc_sec_archive.lrr_act_tab := l_act_tab;
5381: END IF;
5382:
5383: l_act_tab.DELETE;
5384:

Line 5387: IF pay_mx_soc_sec_archive.lrr_act_tab.COUNT > 0 THEN

5383: l_act_tab.DELETE;
5384:
5385: END IF;
5386:
5387: IF pay_mx_soc_sec_archive.lrr_act_tab.COUNT > 0 THEN
5388:
5389: hr_utility_trace('--> pay_mx_soc_sec_archive.lrr_act_tab.COUNT ' || pay_mx_soc_sec_archive.lrr_act_tab.COUNT);
5390: pay_emp_action_arch.insert_rows_thro_api_process(
5391: p_action_context_id => p_asg_action_id

Line 5389: hr_utility_trace('--> pay_mx_soc_sec_archive.lrr_act_tab.COUNT ' || pay_mx_soc_sec_archive.lrr_act_tab.COUNT);

5385: END IF;
5386:
5387: IF pay_mx_soc_sec_archive.lrr_act_tab.COUNT > 0 THEN
5388:
5389: hr_utility_trace('--> pay_mx_soc_sec_archive.lrr_act_tab.COUNT ' || pay_mx_soc_sec_archive.lrr_act_tab.COUNT);
5390: pay_emp_action_arch.insert_rows_thro_api_process(
5391: p_action_context_id => p_asg_action_id
5392: ,p_action_context_type => 'AAP'
5393: ,p_assignment_id => ln_assignment_id

Line 5396: ,p_tab_rec_data => pay_mx_soc_sec_archive.lrr_act_tab

5392: ,p_action_context_type => 'AAP'
5393: ,p_assignment_id => ln_assignment_id
5394: ,p_tax_unit_id => ln_gre_id
5395: ,p_curr_pymt_eff_date => ld_end_date
5396: ,p_tab_rec_data => pay_mx_soc_sec_archive.lrr_act_tab
5397: );
5398:
5399: END IF;
5400:

Line 5401: pay_mx_soc_sec_archive.lrr_act_tab.DELETE;

5397: );
5398:
5399: END IF;
5400:
5401: pay_mx_soc_sec_archive.lrr_act_tab.DELETE;
5402:
5403: hr_utility.set_location(gv_package || lv_procedure_name, 100);
5404: ln_step := 10;
5405:

Line 5605: gv_package := 'pay_mx_soc_sec_archive.';

5601:
5602: BEGIN
5603:
5604: --hr_utility.trace_on(null,'SUA');
5605: gv_package := 'pay_mx_soc_sec_archive.';
5606: gv_debug := hr_utility.debug_enabled;
5607:
5608: END PAY_MX_SOC_SEC_ARCHIVE;

Line 5608: END PAY_MX_SOC_SEC_ARCHIVE;

5604: --hr_utility.trace_on(null,'SUA');
5605: gv_package := 'pay_mx_soc_sec_archive.';
5606: gv_debug := hr_utility.debug_enabled;
5607:
5608: END PAY_MX_SOC_SEC_ARCHIVE;