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.14 2011/12/01 07:22:12 ssarap ship $ */
3:
4: TYPE balance_rec IS RECORD (
5: balance_type_id NUMBER,

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

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

Line 674: pay_gb_payslip_archive.get_parameters (

670: INTO g_archive_effective_date;
671:
672: CLOSE csr_archive_effective_date;
673:
674: pay_gb_payslip_archive.get_parameters (
675: p_payroll_action_id => p_payroll_action_id
676: , p_token_name => 'PAYROLL'
677: , p_token_value => l_payroll_id);
678:

Line 679: pay_gb_payslip_archive.get_parameters (

675: p_payroll_action_id => p_payroll_action_id
676: , p_token_name => 'PAYROLL'
677: , p_token_value => l_payroll_id);
678:
679: pay_gb_payslip_archive.get_parameters (
680: p_payroll_action_id => p_payroll_action_id
681: , p_token_name => 'CONSOLIDATION'
682: , p_token_value => l_consolidation_set);
683:

Line 684: pay_gb_payslip_archive.get_parameters (

680: p_payroll_action_id => p_payroll_action_id
681: , p_token_name => 'CONSOLIDATION'
682: , p_token_value => l_consolidation_set);
683:
684: pay_gb_payslip_archive.get_parameters (
685: p_payroll_action_id => p_payroll_action_id
686: , p_token_name => 'ASSIGNMENT_SET'
687: , p_token_value => l_assignment_set_id);
688:

Line 689: pay_gb_payslip_archive.get_parameters (

685: p_payroll_action_id => p_payroll_action_id
686: , p_token_name => 'ASSIGNMENT_SET'
687: , p_token_value => l_assignment_set_id);
688:
689: pay_gb_payslip_archive.get_parameters (
690: p_payroll_action_id => p_payroll_action_id
691: , p_token_name => 'START_DATE'
692: , p_token_value => l_start_date);
693:

Line 694: pay_gb_payslip_archive.get_parameters (

690: p_payroll_action_id => p_payroll_action_id
691: , p_token_name => 'START_DATE'
692: , p_token_value => l_start_date);
693:
694: pay_gb_payslip_archive.get_parameters (
695: p_payroll_action_id => p_payroll_action_id
696: , p_token_name => 'END_DATE'
697: , p_token_value => l_end_date);
698:

Line 699: pay_gb_payslip_archive.get_parameters (

695: p_payroll_action_id => p_payroll_action_id
696: , p_token_name => 'END_DATE'
697: , p_token_value => l_end_date);
698:
699: pay_gb_payslip_archive.get_parameters (
700: p_payroll_action_id => p_payroll_action_id
701: , p_token_name => 'BG_ID'
702: , p_token_value => l_bg_id);
703:

Line 769: pay_gb_payslip_archive.get_eit_definitions (

765: g_max_user_balance_index := 0;
766:
767: hr_utility.set_location('get_eit_definitions - balances',20);
768:
769: pay_gb_payslip_archive.get_eit_definitions (
770: p_pactid => p_payroll_action_id
771: , p_business_group_id => l_bg_id
772: , p_payroll_pact => NULL
773: , p_effective_date => l_canonical_start_date

Line 779: pay_gb_payslip_archive.get_eit_definitions (

775: , p_archive => 'N');
776:
777: hr_utility.set_location('get_eit_definitions - elements',20);
778:
779: pay_gb_payslip_archive.get_eit_definitions (
780: p_pactid => p_payroll_action_id
781: , p_business_group_id => l_bg_id
782: , p_payroll_pact => NULL
783: , p_effective_date => l_canonical_start_date

Line 792: pay_gb_payslip_archive.setup_standard_balance_table;

788: , p_payroll_action_id);
789:
790: -- setup statutory balances pl/sql table
791:
792: pay_gb_payslip_archive.setup_standard_balance_table;
793:
794: hr_utility.set_location('Leaving ' || l_proc,20);
795:
796: END archinit;

Line 1247: l_balance_value := pay_gb_payslip_archive.process_employer_balance (

1243: , p_dimension => p_dimension);
1244:
1245: ELSE
1246:
1247: l_balance_value := pay_gb_payslip_archive.process_employer_balance (
1248: p_assignment_action_id => p_source_id
1249: ,p_balance_dimension => p_dimension);
1250:
1251: END IF;

Line 1578: pay_gb_payslip_archive.get_parameters (

1574: -- hr_utility.trace_on(NULL,'UKPS1');
1575:
1576: hr_utility.set_location('Entering ' || l_proc,10);
1577:
1578: pay_gb_payslip_archive.get_parameters (
1579: p_payroll_action_id => pactid
1580: , p_token_name => 'PAYROLL'
1581: , p_token_value => l_payroll_id);
1582:

Line 1583: pay_gb_payslip_archive.get_parameters (

1579: p_payroll_action_id => pactid
1580: , p_token_name => 'PAYROLL'
1581: , p_token_value => l_payroll_id);
1582:
1583: pay_gb_payslip_archive.get_parameters (
1584: p_payroll_action_id => pactid
1585: , p_token_name => 'CONSOLIDATION'
1586: , p_token_value => l_consolidation_set);
1587:

Line 1588: pay_gb_payslip_archive.get_parameters (

1584: p_payroll_action_id => pactid
1585: , p_token_name => 'CONSOLIDATION'
1586: , p_token_value => l_consolidation_set);
1587:
1588: pay_gb_payslip_archive.get_parameters (
1589: p_payroll_action_id => pactid
1590: , p_token_name => 'ASSIGNMENT_SET'
1591: , p_token_value => l_assignment_set_id);
1592:

Line 1593: pay_gb_payslip_archive.get_parameters (

1589: p_payroll_action_id => pactid
1590: , p_token_name => 'ASSIGNMENT_SET'
1591: , p_token_value => l_assignment_set_id);
1592:
1593: pay_gb_payslip_archive.get_parameters (
1594: p_payroll_action_id => pactid
1595: , p_token_name => 'START_DATE'
1596: , p_token_value => l_start_date);
1597:

Line 1598: pay_gb_payslip_archive.get_parameters (

1594: p_payroll_action_id => pactid
1595: , p_token_name => 'START_DATE'
1596: , p_token_value => l_start_date);
1597:
1598: pay_gb_payslip_archive.get_parameters (
1599: p_payroll_action_id => pactid
1600: , p_token_name => 'END_DATE'
1601: , p_token_value => l_end_date);
1602:

Line 1603: pay_gb_payslip_archive.get_parameters (

1599: p_payroll_action_id => pactid
1600: , p_token_name => 'END_DATE'
1601: , p_token_value => l_end_date);
1602:
1603: pay_gb_payslip_archive.get_parameters (
1604: p_payroll_action_id => pactid
1605: , p_token_name => 'BG_ID'
1606: , p_token_value => l_bg_id);
1607:

Line 1625: pay_gb_payslip_archive.get_eit_definitions (

1621: hr_utility.set_location('l_canonical_end_date = ' || l_canonical_end_date,20);
1622:
1623: g_max_user_balance_index := 0;
1624:
1625: pay_gb_payslip_archive.get_eit_definitions (
1626: p_pactid => pactid
1627: , p_business_group_id => l_bg_id
1628: , p_payroll_pact => NULL
1629: , p_effective_date => l_canonical_start_date

Line 1633: pay_gb_payslip_archive.get_eit_definitions (

1629: , p_effective_date => l_canonical_start_date
1630: , p_eit_context => g_balance_context
1631: , p_archive => 'Y');
1632:
1633: pay_gb_payslip_archive.get_eit_definitions (
1634: p_pactid => pactid
1635: , p_business_group_id => l_bg_id
1636: , p_payroll_pact => NULL
1637: , p_effective_date => l_canonical_start_date

Line 1641: pay_gb_payslip_archive.setup_element_definitions (

1637: , p_effective_date => l_canonical_start_date
1638: , p_eit_context => g_element_context
1639: , p_archive => 'Y');
1640:
1641: pay_gb_payslip_archive.setup_element_definitions (
1642: p_pactid => pactid
1643: , p_payroll_pact => NULL
1644: , p_business_group_id => l_bg_id
1645: , p_effective_date => l_canonical_start_date

Line 1955: pay_gb_payslip_archive.get_parameters (

1951: BEGIN
1952: -- hr_utility.trace_on(null,'UKPS3');
1953: hr_utility.set_location('Entering ' || l_proc,10);
1954:
1955: pay_gb_payslip_archive.get_parameters (
1956: p_payroll_action_id => pactid
1957: , p_token_name => 'PAYROLL'
1958: , p_token_value => l_payroll_id);
1959:

Line 1960: pay_gb_payslip_archive.get_parameters (

1956: p_payroll_action_id => pactid
1957: , p_token_name => 'PAYROLL'
1958: , p_token_value => l_payroll_id);
1959:
1960: pay_gb_payslip_archive.get_parameters (
1961: p_payroll_action_id => pactid
1962: , p_token_name => 'CONSOLIDATION'
1963: , p_token_value => l_consolidation_set);
1964:

Line 1965: pay_gb_payslip_archive.get_parameters (

1961: p_payroll_action_id => pactid
1962: , p_token_name => 'CONSOLIDATION'
1963: , p_token_value => l_consolidation_set);
1964:
1965: pay_gb_payslip_archive.get_parameters (
1966: p_payroll_action_id => pactid
1967: , p_token_name => 'START_DATE'
1968: , p_token_value => l_start_date);
1969:

Line 1970: pay_gb_payslip_archive.get_parameters (

1966: p_payroll_action_id => pactid
1967: , p_token_name => 'START_DATE'
1968: , p_token_value => l_start_date);
1969:
1970: pay_gb_payslip_archive.get_parameters (
1971: p_payroll_action_id => pactid
1972: , p_token_name => 'END_DATE'
1973: , p_token_value => l_end_date);
1974:

Line 2199: /* pay_gb_payslip_archive.archive_employee_details

2195: ** Call the global package only if the cursor fetches a record.
2196: *****************************************************************/
2197: if csr_assignment_actions%notfound then
2198: if csr_assignment_actions%rowcount > 0 then
2199: /* pay_gb_payslip_archive.archive_employee_details
2200: p_assactid => p_assactid
2201: ,p_assignment_id => assignment_id
2202: ,p_curr_pymt_ass_act_id => prepayment assignment_action_id
2203: ,p_effective_date => payroll effective_date

Line 2209: pay_gb_payslip_archive.archive_employee_details (

2205: ,p_curr_pymt_eff_date => prepayment effective_date
2206: ,p_time_period_id => payroll time_period_id
2207: ,p_record_count => l_record_count);
2208: */
2209: pay_gb_payslip_archive.archive_employee_details (
2210: p_assactid => p_assactid
2211: ,p_assignment_id => csr_rec.assignment_id
2212: ,p_curr_pymt_ass_act_id => csr_rec.pre_assignment_action_id
2213: ,p_effective_date => csr_rec.effective_date

Line 2268: /* pay_gb_payslip_archive.archive_employee_details

2264:
2265: l_action_context_id := l_actid;
2266:
2267: IF l_record_count = 0 THEN
2268: /* pay_gb_payslip_archive.archive_employee_details
2269: p_assactid => p_assactid
2270: ,p_assignment_id => assignment_id
2271: ,p_curr_pymt_ass_act_id => prepayment assignment_action_id
2272: ,p_effective_date => payroll effective_date

Line 2278: pay_gb_payslip_archive.archive_employee_details (

2274: ,p_curr_pymt_eff_date => prepayment effective_date
2275: ,p_time_period_id => payroll time_period_id
2276: ,p_record_count => l_record_count);
2277: */
2278: pay_gb_payslip_archive.archive_employee_details (
2279: p_assactid => l_action_context_id
2280: ,p_assignment_id => csr_rec.assignment_id
2281: ,p_curr_pymt_ass_act_id => csr_rec.pre_assignment_action_id
2282: ,p_effective_date => csr_rec.effective_date

Line 2288: pay_gb_payslip_archive.archive_gb_employee_details (

2284: ,p_curr_pymt_eff_date => csr_rec.pre_effective_date
2285: ,p_time_period_id => csr_rec.time_period_id
2286: ,p_record_count => l_record_count);
2287:
2288: pay_gb_payslip_archive.archive_gb_employee_details (
2289: p_assactid => l_action_context_id
2290: ,p_assignment_id => csr_rec.assignment_id
2291: ,p_curr_pymt_ass_act_id => csr_child_rec.child_assignment_action_id
2292: ,p_effective_date => csr_rec.effective_date);

Line 2296: pay_gb_payslip_archive.get_element_info (

2292: ,p_effective_date => csr_rec.effective_date);
2293:
2294: END IF;
2295:
2296: pay_gb_payslip_archive.get_element_info (
2297: p_action_context_id => l_action_context_id
2298: , p_assignment_id => csr_rec.assignment_id
2299: , p_child_assignment_action => csr_child_rec.child_assignment_action_id
2300: , p_effective_date => csr_rec.effective_date

Line 2322: pay_gb_payslip_archive.archive_gb_employee_details (

2318: lockingactid => l_actid
2319: ,lockedactid => csr_np_rec.np_assignment_action_id);
2320:
2321: IF l_child_count = 0 AND l_record_count = 0 THEN
2322: pay_gb_payslip_archive.archive_gb_employee_details (
2323: p_assactid => l_action_context_id
2324: ,p_assignment_id => csr_rec.assignment_id
2325: ,p_curr_pymt_ass_act_id => csr_np_rec.np_assignment_action_id
2326: ,p_effective_date => csr_rec.effective_date);

Line 2329: pay_gb_payslip_archive.get_element_info (

2325: ,p_curr_pymt_ass_act_id => csr_np_rec.np_assignment_action_id
2326: ,p_effective_date => csr_rec.effective_date);
2327: END IF;
2328:
2329: pay_gb_payslip_archive.get_element_info (
2330: p_action_context_id => l_action_context_id
2331: ,p_assignment_id => csr_rec.assignment_id
2332: ,p_child_assignment_action => csr_np_rec.np_assignment_action_id
2333: ,p_effective_date => csr_rec.effective_date

Line 2352: pay_gb_payslip_archive.process_balance (

2348: g_max_user_balance_index,60);
2349:
2350: FOR l_index IN 1 .. g_max_user_balance_index
2351: LOOP
2352: pay_gb_payslip_archive.process_balance (
2353: p_action_context_id => l_action_context_id
2354: , p_assignment_id => csr_rec.assignment_id
2355: , p_source_id => csr_child_rec.child_assignment_action_id
2356: , p_effective_date => csr_rec.effective_date

Line 2375: pay_gb_payslip_archive.process_balance (

2371:
2372: FOR l_index IN 1 .. g_max_statutory_balance_index
2373: LOOP
2374: hr_utility.set_location('l_index = ' || l_index,70);
2375: pay_gb_payslip_archive.process_balance (
2376: p_action_context_id => l_action_context_id
2377: , p_assignment_id => csr_rec.assignment_id
2378: , p_source_id => csr_child_rec.child_assignment_action_id
2379: , p_effective_date => csr_rec.effective_date

Line 2396: -- PAY_GB_PAYSLIP_ARCHIVE.get_pay_deduct_element_info (p_assactid);

2392: ** for the given assignment_action_id.
2393: *****************************************************************/
2394:
2395: -- Moved down the below call for the bug 10217859
2396: -- PAY_GB_PAYSLIP_ARCHIVE.get_pay_deduct_element_info (p_assactid);
2397:
2398: -- hr_utility.set_location('Archive Payments and Deductions data - Complete',75);
2399:
2400: END LOOP; -- child assignment actions

Line 2415: PAY_GB_PAYSLIP_ARCHIVE.get_pay_deduct_element_info (p_assactid);

2411: END LOOP;
2412: close csr_assignment_actions;
2413:
2414: -- Moved here the below call for the bug 10217859
2415: PAY_GB_PAYSLIP_ARCHIVE.get_pay_deduct_element_info (p_assactid);
2416:
2417: hr_utility.set_location('Archive Payments and Deductions data - Complete',75);
2418:
2419: hr_utility.set_location('Leaving '|| l_proc,80);

Line 2532: pay_gb_payslip_archive.get_parameters (

2528: and pai.action_context_type = 'PA'
2529: and pai.action_information_category in ('EMEA PAYROLL INFO');
2530:
2531:
2532: pay_gb_payslip_archive.get_parameters (
2533: p_payroll_action_id => p_payroll_action_id
2534: , p_token_name => 'PAYROLL'
2535: , p_token_value => l_payroll_id);
2536:

Line 2537: pay_gb_payslip_archive.get_parameters (

2533: p_payroll_action_id => p_payroll_action_id
2534: , p_token_name => 'PAYROLL'
2535: , p_token_value => l_payroll_id);
2536:
2537: pay_gb_payslip_archive.get_parameters (
2538: p_payroll_action_id => p_payroll_action_id
2539: , p_token_name => 'CONSOLIDATION'
2540: , p_token_value => l_consolidation_set);
2541:

Line 2542: pay_gb_payslip_archive.get_parameters (

2538: p_payroll_action_id => p_payroll_action_id
2539: , p_token_name => 'CONSOLIDATION'
2540: , p_token_value => l_consolidation_set);
2541:
2542: pay_gb_payslip_archive.get_parameters (
2543: p_payroll_action_id => p_payroll_action_id
2544: , p_token_name => 'ASSIGNMENT_SET'
2545: , p_token_value => l_assignment_set_id);
2546:

Line 2547: pay_gb_payslip_archive.get_parameters (

2543: p_payroll_action_id => p_payroll_action_id
2544: , p_token_name => 'ASSIGNMENT_SET'
2545: , p_token_value => l_assignment_set_id);
2546:
2547: pay_gb_payslip_archive.get_parameters (
2548: p_payroll_action_id => p_payroll_action_id
2549: , p_token_name => 'START_DATE'
2550: , p_token_value => l_start_date);
2551:

Line 2552: pay_gb_payslip_archive.get_parameters (

2548: p_payroll_action_id => p_payroll_action_id
2549: , p_token_name => 'START_DATE'
2550: , p_token_value => l_start_date);
2551:
2552: pay_gb_payslip_archive.get_parameters (
2553: p_payroll_action_id => p_payroll_action_id
2554: , p_token_name => 'END_DATE'
2555: , p_token_value => l_end_date);
2556:

Line 2557: pay_gb_payslip_archive.get_parameters (

2553: p_payroll_action_id => p_payroll_action_id
2554: , p_token_name => 'END_DATE'
2555: , p_token_value => l_end_date);
2556:
2557: pay_gb_payslip_archive.get_parameters (
2558: p_payroll_action_id => p_payroll_action_id
2559: , p_token_name => 'BG_ID'
2560: , p_token_value => l_bg_id);
2561: