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.22.12020000.9 2013/04/11 15:51:09 nchinnam ship $ */
3:
4: type balance_rec is record
5: (

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

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

Line 1228: pay_za_payslip_archive.get_parameters

1224: fetch csr_archive_effective_date into g_archive_effective_date;
1225: close csr_archive_effective_date;
1226:
1227: -- Retrieve the legislative parameters from the payroll action
1228: pay_za_payslip_archive.get_parameters
1229: (
1230: p_payroll_action_id => p_payroll_action_id, -- Payroll Action of the Archiver
1231: p_token_name => 'PAYROLL',
1232: p_token_value => l_payroll_id

Line 1235: pay_za_payslip_archive.get_parameters

1231: p_token_name => 'PAYROLL',
1232: p_token_value => l_payroll_id
1233: );
1234:
1235: pay_za_payslip_archive.get_parameters
1236: (
1237: p_payroll_action_id => p_payroll_action_id,
1238: p_token_name => 'CONSOLIDATION',
1239: p_token_value => l_consolidation_set

Line 1242: pay_za_payslip_archive.get_parameters

1238: p_token_name => 'CONSOLIDATION',
1239: p_token_value => l_consolidation_set
1240: );
1241:
1242: pay_za_payslip_archive.get_parameters
1243: (
1244: p_payroll_action_id => p_payroll_action_id,
1245: p_token_name => 'ASSIGNMENT_SET',
1246: p_token_value => l_assignment_set_id

Line 1249: pay_za_payslip_archive.get_parameters

1245: p_token_name => 'ASSIGNMENT_SET',
1246: p_token_value => l_assignment_set_id
1247: );
1248:
1249: pay_za_payslip_archive.get_parameters
1250: (
1251: p_payroll_action_id => p_payroll_action_id,
1252: p_token_name => 'START_DATE',
1253: p_token_value => l_start_date

Line 1256: pay_za_payslip_archive.get_parameters

1252: p_token_name => 'START_DATE',
1253: p_token_value => l_start_date
1254: );
1255:
1256: pay_za_payslip_archive.get_parameters
1257: (
1258: p_payroll_action_id => p_payroll_action_id,
1259: p_token_name => 'END_DATE',
1260: p_token_value => l_end_date

Line 1263: pay_za_payslip_archive.get_parameters

1259: p_token_name => 'END_DATE',
1260: p_token_value => l_end_date
1261: );
1262:
1263: pay_za_payslip_archive.get_parameters
1264: (
1265: p_payroll_action_id => p_payroll_action_id,
1266: p_token_name => 'BG_ID',
1267: p_token_value => l_bg_id

Line 1309: pay_za_payslip_archive.get_eit_definitions

1305: g_max_user_balance_index := 0;
1306:
1307: hr_utility.set_location('get_eit_definitions - balances', 20);
1308:
1309: pay_za_payslip_archive.get_eit_definitions
1310: (
1311: p_pactid => p_payroll_action_id, -- Payroll Action of the Archiver
1312: p_business_group_id => l_bg_id,
1313: p_payroll_pact => rec_payroll_info.payroll_action_id, -- Payroll Action of the Prepayment

Line 1321: pay_za_payslip_archive.get_eit_definitions

1317: );
1318:
1319: hr_utility.set_location('get_eit_definitions - elements', 20);
1320:
1321: pay_za_payslip_archive.get_eit_definitions
1322: (
1323: p_pactid => p_payroll_action_id, -- Payroll Action of the Archiver
1324: p_business_group_id => l_bg_id,
1325: p_payroll_pact => rec_payroll_info.payroll_action_id, -- Payroll Action of the Prepayment

Line 1343: pay_za_payslip_archive.setup_standard_balance_table;

1339:
1340: end loop;
1341:
1342: -- Setup statutory balances pl/sql table
1343: pay_za_payslip_archive.setup_standard_balance_table;
1344:
1345: hr_utility.set_location('Leaving ' || l_proc, 20);
1346:
1347: end archinit;

Line 2002: pay_za_payslip_archive.get_parameters

1998: --hr_utility.trace_on(null, 'ZA_SOE');
1999: hr_utility.set_location('Entering ' || l_proc, 10);
2000:
2001: -- Retrieve the legislative parameters from the payroll action
2002: pay_za_payslip_archive.get_parameters
2003: (
2004: p_payroll_action_id => pactid, -- Payroll Action of the Archiver
2005: p_token_name => 'PAYROLL',
2006: p_token_value => l_payroll_id

Line 2009: pay_za_payslip_archive.get_parameters

2005: p_token_name => 'PAYROLL',
2006: p_token_value => l_payroll_id
2007: );
2008:
2009: pay_za_payslip_archive.get_parameters
2010: (
2011: p_payroll_action_id => pactid, -- Payroll Action of the Archiver
2012: p_token_name => 'CONSOLIDATION',
2013: p_token_value => l_consolidation_set

Line 2016: pay_za_payslip_archive.get_parameters

2012: p_token_name => 'CONSOLIDATION',
2013: p_token_value => l_consolidation_set
2014: );
2015:
2016: pay_za_payslip_archive.get_parameters
2017: (
2018: p_payroll_action_id => pactid, -- Payroll Action of the Archiver
2019: p_token_name => 'ASSIGNMENT_SET',
2020: p_token_value => l_assignment_set_id

Line 2023: pay_za_payslip_archive.get_parameters

2019: p_token_name => 'ASSIGNMENT_SET',
2020: p_token_value => l_assignment_set_id
2021: );
2022:
2023: pay_za_payslip_archive.get_parameters
2024: (
2025: p_payroll_action_id => pactid, -- Payroll Action of the Archiver
2026: p_token_name => 'START_DATE',
2027: p_token_value => l_start_date

Line 2030: pay_za_payslip_archive.get_parameters

2026: p_token_name => 'START_DATE',
2027: p_token_value => l_start_date
2028: );
2029:
2030: pay_za_payslip_archive.get_parameters
2031: (
2032: p_payroll_action_id => pactid, -- Payroll Action of the Archiver
2033: p_token_name => 'END_DATE',
2034: p_token_value => l_end_date

Line 2037: pay_za_payslip_archive.get_parameters

2033: p_token_name => 'END_DATE',
2034: p_token_value => l_end_date
2035: );
2036:
2037: pay_za_payslip_archive.get_parameters
2038: (
2039: p_payroll_action_id => pactid, -- Payroll Action of the Archiver
2040: p_token_name => 'BG_ID',
2041: p_token_value => l_bg_id

Line 2070: pay_za_payslip_archive.get_eit_definitions

2066: g_max_user_balance_index := 0;
2067: --
2068: -- Retrieve and archive user balance definitions from EITs
2069: -- The definitions are archived again for each prepayment
2070: pay_za_payslip_archive.get_eit_definitions
2071: (
2072: p_pactid => pactid, -- Payroll Action of Archiver
2073: p_business_group_id => l_bg_id,
2074: p_payroll_pact => rec_payroll_info.payroll_action_id, -- Payroll Action of Prepayments

Line 2081: pay_za_payslip_archive.get_eit_definitions

2077: p_archive => 'Y'
2078: );
2079: --
2080: -- This archives the element definitions on the Org Developer Flexfield
2081: pay_za_payslip_archive.get_eit_definitions
2082: (
2083: p_pactid => pactid, -- Payroll Action of Archiver
2084: p_business_group_id => l_bg_id,
2085: p_payroll_pact => rec_payroll_info.payroll_action_id, -- Payroll Action of Prepayments

Line 2092: pay_za_payslip_archive.setup_element_definitions

2088: p_archive => 'Y'
2089: );
2090: --
2091: -- This archives the element definitions for each Pay Advice Classification
2092: pay_za_payslip_archive.setup_element_definitions
2093: (
2094: p_pactid => pactid, -- Payroll Action of Archiver
2095: p_payroll_pact => rec_payroll_info.payroll_action_id, -- Payroll Action of Prepayments
2096: p_effective_date => rec_payroll_info.effective_date -- Effective Date of Prepayments

Line 2334: pay_za_payslip_archive.get_parameters

2330: --hr_utility.trace_on(null, 'ZA_SOE');
2331: hr_utility.set_location('Entering ' || l_proc, 10);
2332:
2333: -- Retrieve the legislative parameters from the payroll action
2334: pay_za_payslip_archive.get_parameters
2335: (
2336: p_payroll_action_id => pactid, -- Payroll Action of the Archiver
2337: p_token_name => 'PAYROLL',
2338: p_token_value => l_payroll_id

Line 2341: pay_za_payslip_archive.get_parameters

2337: p_token_name => 'PAYROLL',
2338: p_token_value => l_payroll_id
2339: );
2340:
2341: pay_za_payslip_archive.get_parameters
2342: (
2343: p_payroll_action_id => pactid, -- Payroll Action of the Archiver
2344: p_token_name => 'CONSOLIDATION',
2345: p_token_value => l_consolidation_set

Line 2348: pay_za_payslip_archive.get_parameters

2344: p_token_name => 'CONSOLIDATION',
2345: p_token_value => l_consolidation_set
2346: );
2347:
2348: pay_za_payslip_archive.get_parameters
2349: (
2350: p_payroll_action_id => pactid, -- Payroll Action of the Archiver
2351: p_token_name => 'START_DATE',
2352: p_token_value => l_start_date

Line 2355: pay_za_payslip_archive.get_parameters

2351: p_token_name => 'START_DATE',
2352: p_token_value => l_start_date
2353: );
2354:
2355: pay_za_payslip_archive.get_parameters
2356: (
2357: p_payroll_action_id => pactid, -- Payroll Action of the Archiver
2358: p_token_name => 'END_DATE',
2359: p_token_value => l_end_date

Line 2581: pay_za_payslip_archive.archive_employee_details

2577: hr_utility.set_location(' record_count = 0 , starting archive_employee_details' , 23);
2578:
2579: -- Archive the Employee Details in 'EMPLOYEE DETAILS', 'ADDRESS DETAILS',
2580: -- 'EMPLOYEE NET PAY DISTRIBUTION' and 'ZA EMPLOYEE DETAILS'
2581: pay_za_payslip_archive.archive_employee_details
2582: (
2583: p_assactid => p_assactid,
2584: p_assignment_id => csr_rec.assignment_id,
2585: p_curr_pymt_ass_act_id => csr_rec.pre_assignment_action_id, -- prepayment assignment_action_id

Line 2615: pay_za_payslip_archive.get_element_info

2611: fetch csr_child_actions into csr_child_rec;
2612: /* If child run types doesnt exist i.e. Payroll was run before enabling of run types then archive
2613: element info for the master assignment action id (i.e. the only assignment action for the run) */
2614: if csr_child_actions%rowcount=0 then
2615: pay_za_payslip_archive.get_element_info
2616: (
2617: p_action_context_id => l_action_context_id,
2618: p_assignment_id => csr_rec.assignment_id,
2619: p_child_assignment_action => csr_rec.master_assignment_action_id,

Line 2659: pay_za_payslip_archive.get_element_info (

2655: ,lockedactid => csr_child_rec.child_assignment_action_id);
2656:
2657: l_action_context_id := l_actid;
2658:
2659: pay_za_payslip_archive.get_element_info (
2660: p_action_context_id => l_action_context_id
2661: , p_assignment_id => csr_rec.assignment_id
2662: , p_child_assignment_action => csr_child_rec.child_assignment_action_id
2663: , p_effective_date => csr_rec.effective_date

Line 2684: pay_za_payslip_archive.get_element_info (

2680: hr_nonrun_asact.insint(
2681: lockingactid => l_actid
2682: ,lockedactid => csr_np_rec.np_assignment_action_id);
2683:
2684: pay_za_payslip_archive.get_element_info (
2685: p_action_context_id => l_action_context_id
2686: ,p_assignment_id => csr_rec.assignment_id
2687: ,p_child_assignment_action => csr_np_rec.np_assignment_action_id
2688: ,p_effective_date => csr_rec.effective_date

Line 2703: pay_za_payslip_archive.get_element_info

2699: --End changes for Multiple Run TYpes
2700: --Net to Gross NTG
2701:
2702: /* Commented for Net to Gross
2703: pay_za_payslip_archive.get_element_info
2704: (
2705: p_action_context_id => l_action_context_id,
2706: p_assignment_id => csr_rec.assignment_id,
2707: p_child_assignment_action => csr_rec.master_assignment_action_id,

Line 2731: pay_za_payslip_archive.process_balance

2727: hr_utility.set_location('l_pre_assignment_action_id = '|| l_pre_assignment_action_id, 60);
2728:
2729: for l_index in 1..g_max_user_balance_index loop
2730: -- Bug 5507715
2731: pay_za_payslip_archive.process_balance
2732: (
2733: p_action_context_id => l_action_context_id,
2734: p_assignment_id => csr_rec.assignment_id,
2735: p_source_id => csr_rec.master_assignment_action_id, --csr_rec.pre_assignment_action_id, --

Line 2744: pay_za_payslip_archive.process_balance

2740: p_record_count => l_record_count
2741: );/*
2742: IF g_user_balance_table(l_index).database_item_suffix = '_ASG_RUN' or
2743: g_user_balance_table(l_index).database_item_suffix = '_ASG_TAX_PTD' then
2744: pay_za_payslip_archive.process_balance
2745: (
2746: p_action_context_id => l_action_context_id,
2747: p_assignment_id => csr_rec.assignment_id,
2748: p_source_id => csr_rec.master_assignment_action_id,

Line 2756: pay_za_payslip_archive.process_balance

2752: p_defined_bal_id => g_user_balance_table(l_index).defined_balance_id,
2753: p_record_count => l_record_count
2754: );
2755: else
2756: pay_za_payslip_archive.process_balance
2757: (
2758: p_action_context_id => l_action_context_id,
2759: p_assignment_id => csr_rec.assignment_id,
2760: p_source_id => csr_rec.pre_assignment_action_id, --csr_rec.master_assignment_action_id,

Line 2781: pay_za_payslip_archive.process_balance

2777: for l_index in 1..g_max_statutory_balance_index loop
2778:
2779: hr_utility.set_location('l_index = ' || l_index, 70);
2780: --5507715
2781: pay_za_payslip_archive.process_balance
2782: (
2783: p_action_context_id => l_action_context_id,
2784: p_assignment_id => csr_rec.assignment_id,
2785: p_source_id => csr_rec.master_assignment_action_id,--csr_rec.pre_assignment_action_id, --

Line 2795: pay_za_payslip_archive.process_balance

2791: ); /*
2792: IF g_statutory_balance_table(l_index).database_item_suffix = '_ASG_RUN' or
2793: g_statutory_balance_table(l_index).database_item_suffix = '_ASG_TAX_PTD' then
2794:
2795: pay_za_payslip_archive.process_balance
2796: (
2797: p_action_context_id => l_action_context_id,
2798: p_assignment_id => csr_rec.assignment_id,
2799: p_source_id => csr_rec.master_assignment_action_id,

Line 2807: pay_za_payslip_archive.process_balance

2803: p_defined_bal_id => g_statutory_balance_table(l_index).defined_balance_id,
2804: p_record_count => l_record_count
2805: );
2806: else
2807: pay_za_payslip_archive.process_balance
2808: (
2809: p_action_context_id => l_action_context_id,
2810: p_assignment_id => csr_rec.assignment_id,
2811: p_source_id => csr_rec.pre_assignment_action_id, --csr_rec.master_assignment_action_id,