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_GB_PAYSLIP_ARCHIVE dependencies on PAY_GB_PAYSLIP_ARCHIVE

Line 1: PACKAGE BODY pay_gb_payslip_archive AS

1: PACKAGE BODY pay_gb_payslip_archive AS
2: /* $Header: pygbparc.pkb 120.5 2006/09/27 05:53:26 npershad noship $ */
3:
4: TYPE balance_rec IS RECORD (
5: balance_type_id NUMBER,

Line 56: g_package CONSTANT VARCHAR2(30) := 'pay_gb_payslip_archive.';

52: g_paye_tax_code_id NUMBER;
53: g_tax_basis_id NUMBER;
54: g_tax_code_id NUMBER;
55:
56: g_package CONSTANT VARCHAR2(30) := 'pay_gb_payslip_archive.';
57:
58: g_balance_context CONSTANT VARCHAR2(30) := 'GB_PAYSLIP_BALANCES';
59: g_element_context CONSTANT VARCHAR2(30) := 'GB_PAYSLIP_ELEMENTS';
60:

Line 637: pay_gb_payslip_archive.get_parameters (

633: INTO g_archive_effective_date;
634:
635: CLOSE csr_archive_effective_date;
636:
637: pay_gb_payslip_archive.get_parameters (
638: p_payroll_action_id => p_payroll_action_id
639: , p_token_name => 'PAYROLL'
640: , p_token_value => l_payroll_id);
641:

Line 642: pay_gb_payslip_archive.get_parameters (

638: p_payroll_action_id => p_payroll_action_id
639: , p_token_name => 'PAYROLL'
640: , p_token_value => l_payroll_id);
641:
642: pay_gb_payslip_archive.get_parameters (
643: p_payroll_action_id => p_payroll_action_id
644: , p_token_name => 'CONSOLIDATION'
645: , p_token_value => l_consolidation_set);
646:

Line 647: pay_gb_payslip_archive.get_parameters (

643: p_payroll_action_id => p_payroll_action_id
644: , p_token_name => 'CONSOLIDATION'
645: , p_token_value => l_consolidation_set);
646:
647: pay_gb_payslip_archive.get_parameters (
648: p_payroll_action_id => p_payroll_action_id
649: , p_token_name => 'ASSIGNMENT_SET'
650: , p_token_value => l_assignment_set_id);
651:

Line 652: pay_gb_payslip_archive.get_parameters (

648: p_payroll_action_id => p_payroll_action_id
649: , p_token_name => 'ASSIGNMENT_SET'
650: , p_token_value => l_assignment_set_id);
651:
652: pay_gb_payslip_archive.get_parameters (
653: p_payroll_action_id => p_payroll_action_id
654: , p_token_name => 'START_DATE'
655: , p_token_value => l_start_date);
656:

Line 657: pay_gb_payslip_archive.get_parameters (

653: p_payroll_action_id => p_payroll_action_id
654: , p_token_name => 'START_DATE'
655: , p_token_value => l_start_date);
656:
657: pay_gb_payslip_archive.get_parameters (
658: p_payroll_action_id => p_payroll_action_id
659: , p_token_name => 'END_DATE'
660: , p_token_value => l_end_date);
661:

Line 662: pay_gb_payslip_archive.get_parameters (

658: p_payroll_action_id => p_payroll_action_id
659: , p_token_name => 'END_DATE'
660: , p_token_value => l_end_date);
661:
662: pay_gb_payslip_archive.get_parameters (
663: p_payroll_action_id => p_payroll_action_id
664: , p_token_name => 'BG_ID'
665: , p_token_value => l_bg_id);
666:

Line 725: pay_gb_payslip_archive.get_eit_definitions (

721: g_max_user_balance_index := 0;
722:
723: hr_utility.set_location('get_eit_definitions - balances',20);
724:
725: pay_gb_payslip_archive.get_eit_definitions (
726: p_pactid => p_payroll_action_id
727: , p_business_group_id => l_bg_id
728: , p_payroll_pact => NULL
729: , p_effective_date => l_canonical_start_date

Line 735: pay_gb_payslip_archive.get_eit_definitions (

731: , p_archive => 'N');
732:
733: hr_utility.set_location('get_eit_definitions - elements',20);
734:
735: pay_gb_payslip_archive.get_eit_definitions (
736: p_pactid => p_payroll_action_id
737: , p_business_group_id => l_bg_id
738: , p_payroll_pact => NULL
739: , p_effective_date => l_canonical_start_date

Line 748: pay_gb_payslip_archive.setup_standard_balance_table;

744: , p_payroll_action_id);
745:
746: -- setup statutory balances pl/sql table
747:
748: pay_gb_payslip_archive.setup_standard_balance_table;
749:
750: hr_utility.set_location('Leaving ' || l_proc,20);
751:
752: END archinit;

Line 1181: l_balance_value := pay_gb_payslip_archive.process_employer_balance (

1177: , p_dimension => p_dimension);
1178:
1179: ELSE
1180:
1181: l_balance_value := pay_gb_payslip_archive.process_employer_balance (
1182: p_assignment_action_id => p_source_id
1183: ,p_balance_dimension => p_dimension);
1184:
1185: END IF;

Line 1512: pay_gb_payslip_archive.get_parameters (

1508: -- hr_utility.trace_on(NULL,'UKPS1');
1509:
1510: hr_utility.set_location('Entering ' || l_proc,10);
1511:
1512: pay_gb_payslip_archive.get_parameters (
1513: p_payroll_action_id => pactid
1514: , p_token_name => 'PAYROLL'
1515: , p_token_value => l_payroll_id);
1516:

Line 1517: pay_gb_payslip_archive.get_parameters (

1513: p_payroll_action_id => pactid
1514: , p_token_name => 'PAYROLL'
1515: , p_token_value => l_payroll_id);
1516:
1517: pay_gb_payslip_archive.get_parameters (
1518: p_payroll_action_id => pactid
1519: , p_token_name => 'CONSOLIDATION'
1520: , p_token_value => l_consolidation_set);
1521:

Line 1522: pay_gb_payslip_archive.get_parameters (

1518: p_payroll_action_id => pactid
1519: , p_token_name => 'CONSOLIDATION'
1520: , p_token_value => l_consolidation_set);
1521:
1522: pay_gb_payslip_archive.get_parameters (
1523: p_payroll_action_id => pactid
1524: , p_token_name => 'ASSIGNMENT_SET'
1525: , p_token_value => l_assignment_set_id);
1526:

Line 1527: pay_gb_payslip_archive.get_parameters (

1523: p_payroll_action_id => pactid
1524: , p_token_name => 'ASSIGNMENT_SET'
1525: , p_token_value => l_assignment_set_id);
1526:
1527: pay_gb_payslip_archive.get_parameters (
1528: p_payroll_action_id => pactid
1529: , p_token_name => 'START_DATE'
1530: , p_token_value => l_start_date);
1531:

Line 1532: pay_gb_payslip_archive.get_parameters (

1528: p_payroll_action_id => pactid
1529: , p_token_name => 'START_DATE'
1530: , p_token_value => l_start_date);
1531:
1532: pay_gb_payslip_archive.get_parameters (
1533: p_payroll_action_id => pactid
1534: , p_token_name => 'END_DATE'
1535: , p_token_value => l_end_date);
1536:

Line 1537: pay_gb_payslip_archive.get_parameters (

1533: p_payroll_action_id => pactid
1534: , p_token_name => 'END_DATE'
1535: , p_token_value => l_end_date);
1536:
1537: pay_gb_payslip_archive.get_parameters (
1538: p_payroll_action_id => pactid
1539: , p_token_name => 'BG_ID'
1540: , p_token_value => l_bg_id);
1541:

Line 1559: pay_gb_payslip_archive.get_eit_definitions (

1555: hr_utility.set_location('l_canonical_end_date = ' || l_canonical_end_date,20);
1556:
1557: g_max_user_balance_index := 0;
1558:
1559: pay_gb_payslip_archive.get_eit_definitions (
1560: p_pactid => pactid
1561: , p_business_group_id => l_bg_id
1562: , p_payroll_pact => NULL
1563: , p_effective_date => l_canonical_start_date

Line 1567: pay_gb_payslip_archive.get_eit_definitions (

1563: , p_effective_date => l_canonical_start_date
1564: , p_eit_context => g_balance_context
1565: , p_archive => 'Y');
1566:
1567: pay_gb_payslip_archive.get_eit_definitions (
1568: p_pactid => pactid
1569: , p_business_group_id => l_bg_id
1570: , p_payroll_pact => NULL
1571: , p_effective_date => l_canonical_start_date

Line 1575: pay_gb_payslip_archive.setup_element_definitions (

1571: , p_effective_date => l_canonical_start_date
1572: , p_eit_context => g_element_context
1573: , p_archive => 'Y');
1574:
1575: pay_gb_payslip_archive.setup_element_definitions (
1576: p_pactid => pactid
1577: , p_payroll_pact => NULL
1578: , p_business_group_id => l_bg_id
1579: , p_effective_date => l_canonical_start_date);

Line 1884: pay_gb_payslip_archive.get_parameters (

1880: BEGIN
1881: -- hr_utility.trace_on(null,'UKPS3');
1882: hr_utility.set_location('Entering ' || l_proc,10);
1883:
1884: pay_gb_payslip_archive.get_parameters (
1885: p_payroll_action_id => pactid
1886: , p_token_name => 'PAYROLL'
1887: , p_token_value => l_payroll_id);
1888:

Line 1889: pay_gb_payslip_archive.get_parameters (

1885: p_payroll_action_id => pactid
1886: , p_token_name => 'PAYROLL'
1887: , p_token_value => l_payroll_id);
1888:
1889: pay_gb_payslip_archive.get_parameters (
1890: p_payroll_action_id => pactid
1891: , p_token_name => 'CONSOLIDATION'
1892: , p_token_value => l_consolidation_set);
1893:

Line 1894: pay_gb_payslip_archive.get_parameters (

1890: p_payroll_action_id => pactid
1891: , p_token_name => 'CONSOLIDATION'
1892: , p_token_value => l_consolidation_set);
1893:
1894: pay_gb_payslip_archive.get_parameters (
1895: p_payroll_action_id => pactid
1896: , p_token_name => 'START_DATE'
1897: , p_token_value => l_start_date);
1898:

Line 1899: pay_gb_payslip_archive.get_parameters (

1895: p_payroll_action_id => pactid
1896: , p_token_name => 'START_DATE'
1897: , p_token_value => l_start_date);
1898:
1899: pay_gb_payslip_archive.get_parameters (
1900: p_payroll_action_id => pactid
1901: , p_token_name => 'END_DATE'
1902: , p_token_value => l_end_date);
1903:

Line 2127: /* pay_gb_payslip_archive.archive_employee_details

2123: ** Call the global package only if the cursor fetches a record.
2124: *****************************************************************/
2125: if csr_assignment_actions%notfound then
2126: if csr_assignment_actions%rowcount > 0 then
2127: /* pay_gb_payslip_archive.archive_employee_details
2128: p_assactid => p_assactid
2129: ,p_assignment_id => assignment_id
2130: ,p_curr_pymt_ass_act_id => prepayment assignment_action_id
2131: ,p_effective_date => payroll effective_date

Line 2137: pay_gb_payslip_archive.archive_employee_details (

2133: ,p_curr_pymt_eff_date => prepayment effective_date
2134: ,p_time_period_id => payroll time_period_id
2135: ,p_record_count => l_record_count);
2136: */
2137: pay_gb_payslip_archive.archive_employee_details (
2138: p_assactid => p_assactid
2139: ,p_assignment_id => csr_rec.assignment_id
2140: ,p_curr_pymt_ass_act_id => csr_rec.pre_assignment_action_id
2141: ,p_effective_date => csr_rec.effective_date

Line 2195: /* pay_gb_payslip_archive.archive_employee_details

2191:
2192: l_action_context_id := l_actid;
2193:
2194: IF l_record_count = 0 THEN
2195: /* pay_gb_payslip_archive.archive_employee_details
2196: p_assactid => p_assactid
2197: ,p_assignment_id => assignment_id
2198: ,p_curr_pymt_ass_act_id => prepayment assignment_action_id
2199: ,p_effective_date => payroll effective_date

Line 2205: pay_gb_payslip_archive.archive_employee_details (

2201: ,p_curr_pymt_eff_date => prepayment effective_date
2202: ,p_time_period_id => payroll time_period_id
2203: ,p_record_count => l_record_count);
2204: */
2205: pay_gb_payslip_archive.archive_employee_details (
2206: p_assactid => l_action_context_id
2207: ,p_assignment_id => csr_rec.assignment_id
2208: ,p_curr_pymt_ass_act_id => csr_rec.pre_assignment_action_id
2209: ,p_effective_date => csr_rec.effective_date

Line 2215: pay_gb_payslip_archive.archive_gb_employee_details (

2211: ,p_curr_pymt_eff_date => csr_rec.pre_effective_date
2212: ,p_time_period_id => csr_rec.time_period_id
2213: ,p_record_count => l_record_count);
2214:
2215: pay_gb_payslip_archive.archive_gb_employee_details (
2216: p_assactid => l_action_context_id
2217: ,p_assignment_id => csr_rec.assignment_id
2218: ,p_curr_pymt_ass_act_id => csr_child_rec.child_assignment_action_id
2219: ,p_effective_date => csr_rec.effective_date);

Line 2223: pay_gb_payslip_archive.get_element_info (

2219: ,p_effective_date => csr_rec.effective_date);
2220:
2221: END IF;
2222:
2223: pay_gb_payslip_archive.get_element_info (
2224: p_action_context_id => l_action_context_id
2225: , p_assignment_id => csr_rec.assignment_id
2226: , p_child_assignment_action => csr_child_rec.child_assignment_action_id
2227: , p_effective_date => csr_rec.effective_date

Line 2249: pay_gb_payslip_archive.archive_gb_employee_details (

2245: lockingactid => l_actid
2246: ,lockedactid => csr_np_rec.np_assignment_action_id);
2247:
2248: IF l_child_count = 0 AND l_record_count = 0 THEN
2249: pay_gb_payslip_archive.archive_gb_employee_details (
2250: p_assactid => l_action_context_id
2251: ,p_assignment_id => csr_rec.assignment_id
2252: ,p_curr_pymt_ass_act_id => csr_np_rec.np_assignment_action_id
2253: ,p_effective_date => csr_rec.effective_date);

Line 2256: pay_gb_payslip_archive.get_element_info (

2252: ,p_curr_pymt_ass_act_id => csr_np_rec.np_assignment_action_id
2253: ,p_effective_date => csr_rec.effective_date);
2254: END IF;
2255:
2256: pay_gb_payslip_archive.get_element_info (
2257: p_action_context_id => l_action_context_id
2258: ,p_assignment_id => csr_rec.assignment_id
2259: ,p_child_assignment_action => csr_np_rec.np_assignment_action_id
2260: ,p_effective_date => csr_rec.effective_date

Line 2279: pay_gb_payslip_archive.process_balance (

2275: g_max_user_balance_index,60);
2276:
2277: FOR l_index IN 1 .. g_max_user_balance_index
2278: LOOP
2279: pay_gb_payslip_archive.process_balance (
2280: p_action_context_id => l_action_context_id
2281: , p_assignment_id => csr_rec.assignment_id
2282: , p_source_id => csr_child_rec.child_assignment_action_id
2283: , p_effective_date => csr_rec.effective_date

Line 2302: pay_gb_payslip_archive.process_balance (

2298:
2299: FOR l_index IN 1 .. g_max_statutory_balance_index
2300: LOOP
2301: hr_utility.set_location('l_index = ' || l_index,70);
2302: pay_gb_payslip_archive.process_balance (
2303: p_action_context_id => l_action_context_id
2304: , p_assignment_id => csr_rec.assignment_id
2305: , p_source_id => csr_child_rec.child_assignment_action_id
2306: , p_effective_date => csr_rec.effective_date

Line 2436: pay_gb_payslip_archive.get_parameters (

2432: and pai.action_context_type = 'PA'
2433: and pai.action_information_category in ('EMEA PAYROLL INFO');
2434:
2435:
2436: pay_gb_payslip_archive.get_parameters (
2437: p_payroll_action_id => p_payroll_action_id
2438: , p_token_name => 'PAYROLL'
2439: , p_token_value => l_payroll_id);
2440:

Line 2441: pay_gb_payslip_archive.get_parameters (

2437: p_payroll_action_id => p_payroll_action_id
2438: , p_token_name => 'PAYROLL'
2439: , p_token_value => l_payroll_id);
2440:
2441: pay_gb_payslip_archive.get_parameters (
2442: p_payroll_action_id => p_payroll_action_id
2443: , p_token_name => 'CONSOLIDATION'
2444: , p_token_value => l_consolidation_set);
2445:

Line 2446: pay_gb_payslip_archive.get_parameters (

2442: p_payroll_action_id => p_payroll_action_id
2443: , p_token_name => 'CONSOLIDATION'
2444: , p_token_value => l_consolidation_set);
2445:
2446: pay_gb_payslip_archive.get_parameters (
2447: p_payroll_action_id => p_payroll_action_id
2448: , p_token_name => 'ASSIGNMENT_SET'
2449: , p_token_value => l_assignment_set_id);
2450:

Line 2451: pay_gb_payslip_archive.get_parameters (

2447: p_payroll_action_id => p_payroll_action_id
2448: , p_token_name => 'ASSIGNMENT_SET'
2449: , p_token_value => l_assignment_set_id);
2450:
2451: pay_gb_payslip_archive.get_parameters (
2452: p_payroll_action_id => p_payroll_action_id
2453: , p_token_name => 'START_DATE'
2454: , p_token_value => l_start_date);
2455:

Line 2456: pay_gb_payslip_archive.get_parameters (

2452: p_payroll_action_id => p_payroll_action_id
2453: , p_token_name => 'START_DATE'
2454: , p_token_value => l_start_date);
2455:
2456: pay_gb_payslip_archive.get_parameters (
2457: p_payroll_action_id => p_payroll_action_id
2458: , p_token_name => 'END_DATE'
2459: , p_token_value => l_end_date);
2460:

Line 2461: pay_gb_payslip_archive.get_parameters (

2457: p_payroll_action_id => p_payroll_action_id
2458: , p_token_name => 'END_DATE'
2459: , p_token_value => l_end_date);
2460:
2461: pay_gb_payslip_archive.get_parameters (
2462: p_payroll_action_id => p_payroll_action_id
2463: , p_token_name => 'BG_ID'
2464: , p_token_value => l_bg_id);
2465: