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_ZA_PAYSLIP_ARCHIVE dependencies on PAY_ZA_PAYSLIP_ARCHIVE

Line 1: package body pay_za_payslip_archive as

1: package body pay_za_payslip_archive as
2: /* $Header: pyzaparc.pkb 120.10.12010000.2 2008/08/06 08:45:06 ubhat ship $ */
3:
4: type balance_rec is record
5: (

Line 47: g_package constant varchar2(30) := 'pay_za_payslip_archive.';

43:
44: g_archive_pact number;
45: g_archive_effective_date date;
46:
47: g_package constant varchar2(30) := 'pay_za_payslip_archive.';
48:
49: -- This procedure retrieves legislative parameters from the payroll action
50: procedure get_parameters
51: (

Line 1098: pay_za_payslip_archive.get_parameters

1094: fetch csr_archive_effective_date into g_archive_effective_date;
1095: close csr_archive_effective_date;
1096:
1097: -- Retrieve the legislative parameters from the payroll action
1098: pay_za_payslip_archive.get_parameters
1099: (
1100: p_payroll_action_id => p_payroll_action_id, -- Payroll Action of the Archiver
1101: p_token_name => 'PAYROLL',
1102: p_token_value => l_payroll_id

Line 1105: pay_za_payslip_archive.get_parameters

1101: p_token_name => 'PAYROLL',
1102: p_token_value => l_payroll_id
1103: );
1104:
1105: pay_za_payslip_archive.get_parameters
1106: (
1107: p_payroll_action_id => p_payroll_action_id,
1108: p_token_name => 'CONSOLIDATION',
1109: p_token_value => l_consolidation_set

Line 1112: pay_za_payslip_archive.get_parameters

1108: p_token_name => 'CONSOLIDATION',
1109: p_token_value => l_consolidation_set
1110: );
1111:
1112: pay_za_payslip_archive.get_parameters
1113: (
1114: p_payroll_action_id => p_payroll_action_id,
1115: p_token_name => 'ASSIGNMENT_SET',
1116: p_token_value => l_assignment_set_id

Line 1119: pay_za_payslip_archive.get_parameters

1115: p_token_name => 'ASSIGNMENT_SET',
1116: p_token_value => l_assignment_set_id
1117: );
1118:
1119: pay_za_payslip_archive.get_parameters
1120: (
1121: p_payroll_action_id => p_payroll_action_id,
1122: p_token_name => 'START_DATE',
1123: p_token_value => l_start_date

Line 1126: pay_za_payslip_archive.get_parameters

1122: p_token_name => 'START_DATE',
1123: p_token_value => l_start_date
1124: );
1125:
1126: pay_za_payslip_archive.get_parameters
1127: (
1128: p_payroll_action_id => p_payroll_action_id,
1129: p_token_name => 'END_DATE',
1130: p_token_value => l_end_date

Line 1133: pay_za_payslip_archive.get_parameters

1129: p_token_name => 'END_DATE',
1130: p_token_value => l_end_date
1131: );
1132:
1133: pay_za_payslip_archive.get_parameters
1134: (
1135: p_payroll_action_id => p_payroll_action_id,
1136: p_token_name => 'BG_ID',
1137: p_token_value => l_bg_id

Line 1174: pay_za_payslip_archive.get_eit_definitions

1170: g_max_user_balance_index := 0;
1171:
1172: hr_utility.set_location('get_eit_definitions - balances', 20);
1173:
1174: pay_za_payslip_archive.get_eit_definitions
1175: (
1176: p_pactid => p_payroll_action_id, -- Payroll Action of the Archiver
1177: p_business_group_id => l_bg_id,
1178: p_payroll_pact => rec_payroll_info.payroll_action_id, -- Payroll Action of the Prepayment

Line 1186: pay_za_payslip_archive.get_eit_definitions

1182: );
1183:
1184: hr_utility.set_location('get_eit_definitions - elements', 20);
1185:
1186: pay_za_payslip_archive.get_eit_definitions
1187: (
1188: p_pactid => p_payroll_action_id, -- Payroll Action of the Archiver
1189: p_business_group_id => l_bg_id,
1190: p_payroll_pact => rec_payroll_info.payroll_action_id, -- Payroll Action of the Prepayment

Line 1208: pay_za_payslip_archive.setup_standard_balance_table;

1204:
1205: end loop;
1206:
1207: -- Setup statutory balances pl/sql table
1208: pay_za_payslip_archive.setup_standard_balance_table;
1209:
1210: hr_utility.set_location('Leaving ' || l_proc, 20);
1211:
1212: end archinit;

Line 1748: pay_za_payslip_archive.get_parameters

1744: --hr_utility.trace_on(null, 'ZA_SOE');
1745: hr_utility.set_location('Entering ' || l_proc, 10);
1746:
1747: -- Retrieve the legislative parameters from the payroll action
1748: pay_za_payslip_archive.get_parameters
1749: (
1750: p_payroll_action_id => pactid, -- Payroll Action of the Archiver
1751: p_token_name => 'PAYROLL',
1752: p_token_value => l_payroll_id

Line 1755: pay_za_payslip_archive.get_parameters

1751: p_token_name => 'PAYROLL',
1752: p_token_value => l_payroll_id
1753: );
1754:
1755: pay_za_payslip_archive.get_parameters
1756: (
1757: p_payroll_action_id => pactid, -- Payroll Action of the Archiver
1758: p_token_name => 'CONSOLIDATION',
1759: p_token_value => l_consolidation_set

Line 1762: pay_za_payslip_archive.get_parameters

1758: p_token_name => 'CONSOLIDATION',
1759: p_token_value => l_consolidation_set
1760: );
1761:
1762: pay_za_payslip_archive.get_parameters
1763: (
1764: p_payroll_action_id => pactid, -- Payroll Action of the Archiver
1765: p_token_name => 'ASSIGNMENT_SET',
1766: p_token_value => l_assignment_set_id

Line 1769: pay_za_payslip_archive.get_parameters

1765: p_token_name => 'ASSIGNMENT_SET',
1766: p_token_value => l_assignment_set_id
1767: );
1768:
1769: pay_za_payslip_archive.get_parameters
1770: (
1771: p_payroll_action_id => pactid, -- Payroll Action of the Archiver
1772: p_token_name => 'START_DATE',
1773: p_token_value => l_start_date

Line 1776: pay_za_payslip_archive.get_parameters

1772: p_token_name => 'START_DATE',
1773: p_token_value => l_start_date
1774: );
1775:
1776: pay_za_payslip_archive.get_parameters
1777: (
1778: p_payroll_action_id => pactid, -- Payroll Action of the Archiver
1779: p_token_name => 'END_DATE',
1780: p_token_value => l_end_date

Line 1783: pay_za_payslip_archive.get_parameters

1779: p_token_name => 'END_DATE',
1780: p_token_value => l_end_date
1781: );
1782:
1783: pay_za_payslip_archive.get_parameters
1784: (
1785: p_payroll_action_id => pactid, -- Payroll Action of the Archiver
1786: p_token_name => 'BG_ID',
1787: p_token_value => l_bg_id

Line 1816: pay_za_payslip_archive.get_eit_definitions

1812: g_max_user_balance_index := 0;
1813: --
1814: -- Retrieve and archive user balance definitions from EITs
1815: -- The definitions are archived again for each prepayment
1816: pay_za_payslip_archive.get_eit_definitions
1817: (
1818: p_pactid => pactid, -- Payroll Action of Archiver
1819: p_business_group_id => l_bg_id,
1820: p_payroll_pact => rec_payroll_info.payroll_action_id, -- Payroll Action of Prepayments

Line 1827: pay_za_payslip_archive.get_eit_definitions

1823: p_archive => 'Y'
1824: );
1825: --
1826: -- This archives the element definitions on the Org Developer Flexfield
1827: pay_za_payslip_archive.get_eit_definitions
1828: (
1829: p_pactid => pactid, -- Payroll Action of Archiver
1830: p_business_group_id => l_bg_id,
1831: p_payroll_pact => rec_payroll_info.payroll_action_id, -- Payroll Action of Prepayments

Line 1838: pay_za_payslip_archive.setup_element_definitions

1834: p_archive => 'Y'
1835: );
1836: --
1837: -- This archives the element definitions for each Pay Advice Classification
1838: pay_za_payslip_archive.setup_element_definitions
1839: (
1840: p_pactid => pactid, -- Payroll Action of Archiver
1841: p_payroll_pact => rec_payroll_info.payroll_action_id, -- Payroll Action of Prepayments
1842: p_effective_date => rec_payroll_info.effective_date -- Effective Date of Prepayments

Line 2074: pay_za_payslip_archive.get_parameters

2070: --hr_utility.trace_on(null, 'ZA_SOE');
2071: hr_utility.set_location('Entering ' || l_proc, 10);
2072:
2073: -- Retrieve the legislative parameters from the payroll action
2074: pay_za_payslip_archive.get_parameters
2075: (
2076: p_payroll_action_id => pactid, -- Payroll Action of the Archiver
2077: p_token_name => 'PAYROLL',
2078: p_token_value => l_payroll_id

Line 2081: pay_za_payslip_archive.get_parameters

2077: p_token_name => 'PAYROLL',
2078: p_token_value => l_payroll_id
2079: );
2080:
2081: pay_za_payslip_archive.get_parameters
2082: (
2083: p_payroll_action_id => pactid, -- Payroll Action of the Archiver
2084: p_token_name => 'CONSOLIDATION',
2085: p_token_value => l_consolidation_set

Line 2088: pay_za_payslip_archive.get_parameters

2084: p_token_name => 'CONSOLIDATION',
2085: p_token_value => l_consolidation_set
2086: );
2087:
2088: pay_za_payslip_archive.get_parameters
2089: (
2090: p_payroll_action_id => pactid, -- Payroll Action of the Archiver
2091: p_token_name => 'START_DATE',
2092: p_token_value => l_start_date

Line 2095: pay_za_payslip_archive.get_parameters

2091: p_token_name => 'START_DATE',
2092: p_token_value => l_start_date
2093: );
2094:
2095: pay_za_payslip_archive.get_parameters
2096: (
2097: p_payroll_action_id => pactid, -- Payroll Action of the Archiver
2098: p_token_name => 'END_DATE',
2099: p_token_value => l_end_date

Line 2320: pay_za_payslip_archive.archive_employee_details

2316: hr_utility.set_location(' record_count = 0 , starting archive_employee_details' , 23);
2317:
2318: -- Archive the Employee Details in 'EMPLOYEE DETAILS', 'ADDRESS DETAILS',
2319: -- 'EMPLOYEE NET PAY DISTRIBUTION' and 'ZA EMPLOYEE DETAILS'
2320: pay_za_payslip_archive.archive_employee_details
2321: (
2322: p_assactid => p_assactid,
2323: p_assignment_id => csr_rec.assignment_id,
2324: p_curr_pymt_ass_act_id => csr_rec.pre_assignment_action_id, -- prepayment assignment_action_id

Line 2334: pay_za_payslip_archive.get_element_info

2330: hr_utility.set_location(' out of archive_employee_details ' , 25);
2331:
2332: end if;
2333:
2334: pay_za_payslip_archive.get_element_info
2335: (
2336: p_action_context_id => l_action_context_id,
2337: p_assignment_id => csr_rec.assignment_id,
2338: p_child_assignment_action => csr_rec.master_assignment_action_id,

Line 2361: pay_za_payslip_archive.process_balance

2357: hr_utility.set_location('l_pre_assignment_action_id = '|| l_pre_assignment_action_id, 60);
2358:
2359: for l_index in 1..g_max_user_balance_index loop
2360: -- Bug 5507715
2361: pay_za_payslip_archive.process_balance
2362: (
2363: p_action_context_id => l_action_context_id,
2364: p_assignment_id => csr_rec.assignment_id,
2365: p_source_id => csr_rec.master_assignment_action_id, --csr_rec.pre_assignment_action_id, --

Line 2374: pay_za_payslip_archive.process_balance

2370: p_record_count => l_record_count
2371: );/*
2372: IF g_user_balance_table(l_index).database_item_suffix = '_ASG_RUN' or
2373: g_user_balance_table(l_index).database_item_suffix = '_ASG_TAX_PTD' then
2374: pay_za_payslip_archive.process_balance
2375: (
2376: p_action_context_id => l_action_context_id,
2377: p_assignment_id => csr_rec.assignment_id,
2378: p_source_id => csr_rec.master_assignment_action_id,

Line 2386: pay_za_payslip_archive.process_balance

2382: p_defined_bal_id => g_user_balance_table(l_index).defined_balance_id,
2383: p_record_count => l_record_count
2384: );
2385: else
2386: pay_za_payslip_archive.process_balance
2387: (
2388: p_action_context_id => l_action_context_id,
2389: p_assignment_id => csr_rec.assignment_id,
2390: p_source_id => csr_rec.pre_assignment_action_id, --csr_rec.master_assignment_action_id,

Line 2411: pay_za_payslip_archive.process_balance

2407: for l_index in 1..g_max_statutory_balance_index loop
2408:
2409: hr_utility.set_location('l_index = ' || l_index, 70);
2410: --5507715
2411: pay_za_payslip_archive.process_balance
2412: (
2413: p_action_context_id => l_action_context_id,
2414: p_assignment_id => csr_rec.assignment_id,
2415: p_source_id => csr_rec.master_assignment_action_id,--csr_rec.pre_assignment_action_id, --

Line 2425: pay_za_payslip_archive.process_balance

2421: ); /*
2422: IF g_statutory_balance_table(l_index).database_item_suffix = '_ASG_RUN' or
2423: g_statutory_balance_table(l_index).database_item_suffix = '_ASG_TAX_PTD' then
2424:
2425: pay_za_payslip_archive.process_balance
2426: (
2427: p_action_context_id => l_action_context_id,
2428: p_assignment_id => csr_rec.assignment_id,
2429: p_source_id => csr_rec.master_assignment_action_id,

Line 2437: pay_za_payslip_archive.process_balance

2433: p_defined_bal_id => g_statutory_balance_table(l_index).defined_balance_id,
2434: p_record_count => l_record_count
2435: );
2436: else
2437: pay_za_payslip_archive.process_balance
2438: (
2439: p_action_context_id => l_action_context_id,
2440: p_assignment_id => csr_rec.assignment_id,
2441: p_source_id => csr_rec.pre_assignment_action_id, --csr_rec.master_assignment_action_id,