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_IE_P45_ARCHIVE dependencies on PAY_IE_P45_ARCHIVE

Line 1: PACKAGE BODY pay_ie_p45_archive AS

1: PACKAGE BODY pay_ie_p45_archive AS
2: /* $Header: pyiep45.pkb 120.34.12010000.1 2008/07/27 22:50:34 appldev ship $ */
3: /*
4: **
5: ** Copyright (C) 1999 Oracle Corporation

Line 20: ** 2450336 to pay_ie_p45_archive.process_balance to archive

16: ** 10 JUN 2002 viviswan 2268282 XML Report generator
17: ** procedure added.
18: ** 14 JUN 2002 Kavenkat Modified the address information fields
19: ** 09-JUL-2002 Kavenkat 2448728 Passed on the prepayment assignment action id
20: ** 2450336 to pay_ie_p45_archive.process_balance to archive
21: ** the balance 'Total Pay'.
22: ** 10-JUL-2002 viviswan 2452564 Fixed EMEA BALANCE DEFINITION context getting
23: ** 2450279 archived for each chunk created by the PYUGEN
24: ** process.

Line 221: g_package CONSTANT VARCHAR2(30) := 'pay_ie_p45_archive.';

217: g_period_week_std_cutoff NUMBER; /* 5528450 */
218:
219:
220:
221: g_package CONSTANT VARCHAR2(30) := 'pay_ie_p45_archive.';
222:
223: g_archive_pact NUMBER;
224: g_archive_effective_date DATE;
225: g_archive_start_date DATE;

Line 538: pay_ie_p45_archive.get_parameters (

534: FETCH csr_archive_effective_date
535: INTO g_archive_effective_date;
536: CLOSE csr_archive_effective_date;
537:
538: pay_ie_p45_archive.get_parameters (
539: p_payroll_action_id => p_payroll_action_id
540: , p_token_name => 'EMPLOYER'
541: , p_token_value => g_paye_ref);
542:

Line 543: pay_ie_p45_archive.get_parameters (

539: p_payroll_action_id => p_payroll_action_id
540: , p_token_name => 'EMPLOYER'
541: , p_token_value => g_paye_ref);
542:
543: pay_ie_p45_archive.get_parameters (
544: p_payroll_action_id => p_payroll_action_id
545: , p_token_name => 'END_DATE'
546: , p_token_value => l_end_date);
547:

Line 548: pay_ie_p45_archive.get_parameters (

544: p_payroll_action_id => p_payroll_action_id
545: , p_token_name => 'END_DATE'
546: , p_token_value => l_end_date);
547:
548: pay_ie_p45_archive.get_parameters (
549: p_payroll_action_id => p_payroll_action_id
550: , p_token_name => 'START_DATE'
551: , p_token_value => l_start_date);
552:

Line 553: pay_ie_p45_archive.get_parameters (

549: p_payroll_action_id => p_payroll_action_id
550: , p_token_name => 'START_DATE'
551: , p_token_value => l_start_date);
552:
553: pay_ie_p45_archive.get_parameters (
554: p_payroll_action_id => p_payroll_action_id
555: , p_token_name => 'BG_ID'
556: , p_token_value => l_bg_id);
557:

Line 632: pay_ie_p45_archive.setup_standard_balance_table;

628: g_period_week_std_cutoff;
629: CLOSE csr_input_value_id;
630:
631: hr_utility.set_location('stage 2',23);
632: pay_ie_p45_archive.setup_standard_balance_table;
633:
634: hr_utility.set_location('stage 3',24);
635:
636: -- hr_utility.set_location('l_payroll_id = ' || l_payroll_id,20);

Line 918: pay_ie_p45_archive.get_parameters (

914:
915: hr_utility.set_location('Returned from pay_emp_action_arch',30);
916:
917: -- get the business group id
918: pay_ie_p45_archive.get_parameters (
919: p_payroll_action_id => g_archive_pact
920: , p_token_name => 'BG_ID'
921: , p_token_value => l_bg_id);
922:

Line 2676: pay_ie_p45_archive.get_parameters (

2672: OPEN csr_check_archived(p_payroll_action_id);
2673: FETCH csr_check_archived INTO l_archived;
2674: CLOSE csr_check_archived;
2675: IF l_archived = 0 THEN
2676: pay_ie_p45_archive.get_parameters (
2677: p_payroll_action_id => p_payroll_action_id
2678: , p_token_name => 'EMPLOYER'
2679: , p_token_value => g_paye_ref);
2680: /*

Line 2681: pay_ie_p45_archive.get_parameters (

2677: p_payroll_action_id => p_payroll_action_id
2678: , p_token_name => 'EMPLOYER'
2679: , p_token_value => g_paye_ref);
2680: /*
2681: pay_ie_p45_archive.get_parameters (
2682: p_payroll_action_id => p_payroll_action_id
2683: , p_token_name => 'CONSOLIDATION'
2684: , p_token_value => l_consolidation_set);
2685: pay_ie_p45_archive.get_parameters (

Line 2685: pay_ie_p45_archive.get_parameters (

2681: pay_ie_p45_archive.get_parameters (
2682: p_payroll_action_id => p_payroll_action_id
2683: , p_token_name => 'CONSOLIDATION'
2684: , p_token_value => l_consolidation_set);
2685: pay_ie_p45_archive.get_parameters (
2686: p_payroll_action_id => p_payroll_action_id
2687: , p_token_name => 'ASSIGNMENT_SET'
2688: , p_token_value => l_assignment_set_id);
2689: pay_ie_p45_archive.get_parameters (

Line 2689: pay_ie_p45_archive.get_parameters (

2685: pay_ie_p45_archive.get_parameters (
2686: p_payroll_action_id => p_payroll_action_id
2687: , p_token_name => 'ASSIGNMENT_SET'
2688: , p_token_value => l_assignment_set_id);
2689: pay_ie_p45_archive.get_parameters (
2690: p_payroll_action_id => p_payroll_action_id
2691: , p_token_name => 'START_DATE'
2692: , p_token_value => l_start_date);
2693: */

Line 2694: pay_ie_p45_archive.get_parameters (

2690: p_payroll_action_id => p_payroll_action_id
2691: , p_token_name => 'START_DATE'
2692: , p_token_value => l_start_date);
2693: */
2694: pay_ie_p45_archive.get_parameters (
2695: p_payroll_action_id => p_payroll_action_id
2696: , p_token_name => 'END_DATE'
2697: , p_token_value => l_end_date);
2698:

Line 2699: pay_ie_p45_archive.get_parameters (

2695: p_payroll_action_id => p_payroll_action_id
2696: , p_token_name => 'END_DATE'
2697: , p_token_value => l_end_date);
2698:
2699: pay_ie_p45_archive.get_parameters (
2700: p_payroll_action_id => p_payroll_action_id
2701: , p_token_name => 'START_DATE'
2702: , p_token_value => l_start_date);
2703:

Line 2704: pay_ie_p45_archive.get_parameters (

2700: p_payroll_action_id => p_payroll_action_id
2701: , p_token_name => 'START_DATE'
2702: , p_token_value => l_start_date);
2703:
2704: pay_ie_p45_archive.get_parameters (
2705: p_payroll_action_id => p_payroll_action_id
2706: , p_token_name => 'BG_ID'
2707: , p_token_value => l_bg_id);
2708: hr_utility.set_location('Step ' || l_proc,20);

Line 2782: pay_ie_p45_archive.setup_standard_balance_table;

2778: as the same cursor csr_payroll_info can be used to get the required details */
2779: /*
2780: END LOOP;
2781: -- setup statutory balances pl/sql table
2782: pay_ie_p45_archive.setup_standard_balance_table;
2783: FOR rec_payroll_info in csr_all_payroll_info(p_payroll_action_id)
2784: LOOP
2785: */
2786: hr_utility.trace('Entered payroll info');

Line 2789: pay_ie_p45_archive.setup_balance_definitions(p_payroll_action_id,

2785: */
2786: hr_utility.trace('Entered payroll info');
2787: pay_balance_pkg.set_context('PAYROLL_ACTION_ID'
2788: , rec_payroll_info.payroll_action_id);
2789: pay_ie_p45_archive.setup_balance_definitions(p_payroll_action_id,
2790: rec_payroll_info.payroll_action_id,
2791: rec_payroll_info.effective_date);
2792: END LOOP;
2793: --end if;

Line 2841: pay_ie_p45_archive.get_parameters (

2837:
2838: BEGIN
2839: hr_utility.set_location('Entering ' || l_proc,10);
2840: /*
2841: pay_ie_p45_archive.get_parameters (
2842: p_payroll_action_id => pactid
2843: , p_token_name => 'PAYROLL'
2844: , p_token_value => l_payroll_id);
2845: pay_ie_p45_archive.get_parameters (

Line 2845: pay_ie_p45_archive.get_parameters (

2841: pay_ie_p45_archive.get_parameters (
2842: p_payroll_action_id => pactid
2843: , p_token_name => 'PAYROLL'
2844: , p_token_value => l_payroll_id);
2845: pay_ie_p45_archive.get_parameters (
2846: p_payroll_action_id => pactid
2847: , p_token_name => 'CONSOLIDATION'
2848: , p_token_value => l_consolidation_set);
2849: pay_ie_p45_archive.get_parameters (

Line 2849: pay_ie_p45_archive.get_parameters (

2845: pay_ie_p45_archive.get_parameters (
2846: p_payroll_action_id => pactid
2847: , p_token_name => 'CONSOLIDATION'
2848: , p_token_value => l_consolidation_set);
2849: pay_ie_p45_archive.get_parameters (
2850: p_payroll_action_id => pactid
2851: , p_token_name => 'ASSIGNMENT_SET'
2852: , p_token_value => l_assignment_set_id);
2853: pay_ie_p45_archive.get_parameters (

Line 2853: pay_ie_p45_archive.get_parameters (

2849: pay_ie_p45_archive.get_parameters (
2850: p_payroll_action_id => pactid
2851: , p_token_name => 'ASSIGNMENT_SET'
2852: , p_token_value => l_assignment_set_id);
2853: pay_ie_p45_archive.get_parameters (
2854: p_payroll_action_id => pactid
2855: , p_token_name => 'START_DATE'
2856: , p_token_value => l_start_date);
2857: */

Line 2858: pay_ie_p45_archive.get_parameters (

2854: p_payroll_action_id => pactid
2855: , p_token_name => 'START_DATE'
2856: , p_token_value => l_start_date);
2857: */
2858: pay_ie_p45_archive.get_parameters (
2859: p_payroll_action_id => pactid
2860: , p_token_name => 'END_DATE'
2861: , p_token_value => l_end_date);
2862:

Line 2863: pay_ie_p45_archive.get_parameters (

2859: p_payroll_action_id => pactid
2860: , p_token_name => 'END_DATE'
2861: , p_token_value => l_end_date);
2862:
2863: pay_ie_p45_archive.get_parameters (
2864: p_payroll_action_id => pactid
2865: , p_token_name => 'BG_ID'
2866: , p_token_value => l_bg_id);
2867:

Line 2868: pay_ie_p45_archive.get_parameters (

2864: p_payroll_action_id => pactid
2865: , p_token_name => 'BG_ID'
2866: , p_token_value => l_bg_id);
2867:
2868: pay_ie_p45_archive.get_parameters (
2869: p_payroll_action_id => pactid
2870: , p_token_name => 'EMPLOYER'
2871: , p_token_value => l_employer);
2872:

Line 2873: pay_ie_p45_archive.get_parameters (

2869: p_payroll_action_id => pactid
2870: , p_token_name => 'EMPLOYER'
2871: , p_token_value => l_employer);
2872:
2873: pay_ie_p45_archive.get_parameters (
2874: p_payroll_action_id => pactid
2875: , p_token_name => 'START_DATE'
2876: , p_token_value => l_start_date);
2877:

Line 3066: pay_ie_p45_archive.get_parameters (

3062: l_proc VARCHAR2(50) := g_package||'action_creation';
3063: BEGIN
3064: --hr_utility.trace_on(null,'P45');
3065: hr_utility.set_location('Entering ' || l_proc,10);
3066: pay_ie_p45_archive.get_parameters (
3067: p_payroll_action_id => pactid
3068: , p_token_name => 'EMPLOYER'
3069: , p_token_value => g_paye_ref);
3070:

Line 3071: pay_ie_p45_archive.get_parameters (

3067: p_payroll_action_id => pactid
3068: , p_token_name => 'EMPLOYER'
3069: , p_token_value => g_paye_ref);
3070:
3071: pay_ie_p45_archive.get_parameters (
3072: p_payroll_action_id => pactid
3073: , p_token_name => 'END_DATE'
3074: , p_token_value => l_end_date);
3075:

Line 3076: pay_ie_p45_archive.get_parameters (

3072: p_payroll_action_id => pactid
3073: , p_token_name => 'END_DATE'
3074: , p_token_value => l_end_date);
3075:
3076: pay_ie_p45_archive.get_parameters (
3077: p_payroll_action_id => pactid
3078: , p_token_name => 'BG_ID'
3079: , p_token_value => l_bg_id);
3080:

Line 3081: pay_ie_p45_archive.get_parameters (

3077: p_payroll_action_id => pactid
3078: , p_token_name => 'BG_ID'
3079: , p_token_value => l_bg_id);
3080:
3081: pay_ie_p45_archive.get_parameters (
3082: p_payroll_action_id => pactid
3083: , p_token_name => 'START_DATE'
3084: , p_token_value => l_start_date);
3085:

Line 3086: pay_ie_p45_archive.get_parameters ( -- 5059862

3082: p_payroll_action_id => pactid
3083: , p_token_name => 'START_DATE'
3084: , p_token_value => l_start_date);
3085:
3086: pay_ie_p45_archive.get_parameters ( -- 5059862
3087: p_payroll_action_id => pactid
3088: , p_token_name => 'PAYROLL'
3089: , p_token_value => l_payroll_id);
3090:

Line 3424: pay_ie_p45_archive.archive_p45_info(

3420: lockingactid => l_actid
3421: , lockedactid => l_child_pay_action);
3422: END IF;
3423:
3424: pay_ie_p45_archive.archive_p45_info(
3425: p_action_context_id => p_assactid,
3426: p_assignment_id => csr_rec.assignment_id, -- assignment_id
3427: p_payroll_id => l_payroll_id,
3428: p_date_earned => csr_rec.date_earned,

Line 3459: pay_ie_p45_archive.archive_employee_details(

3455: lockingactid => l_actid
3456: , lockedactid => l_last_p45_action);
3457: END IF;
3458:
3459: pay_ie_p45_archive.archive_employee_details(
3460: p_assactid => l_action_context_id -- P45 master action
3461: , p_assignment_id => l_assignment_id
3462: , p_curr_pymt_ass_act_id => csr_rec.pre_assignment_action_id -- prepayment assignment_action_id
3463: , p_date_earned => csr_rec.date_earned -- payroll date_earned

Line 3491: pay_ie_p45_archive.process_balance (

3487: /*
3488: --Bug:2448728.Passing the prepayment assignment action id to p_source_id as the _PAYMENTS
3489: --balances are fed only during pre Payments.
3490: If g_statutory_balance_table(l_index).balance_name = 'Total Pay' Then
3491: pay_ie_p45_archive.process_balance (
3492: p_action_context_id => l_action_context_id
3493: , p_assignment_id => csr_rec.assignment_id
3494: , p_source_id => csr_rec.pre_assignment_action_id
3495: , p_effective_date => csr_rec.effective_date

Line 3505: pay_ie_p45_archive.process_balance (

3501: */
3502: -- IF ( l_supp_flag = 'Y' OR l_index < 19 OR l_index > 31 ) THEN
3503:
3504: IF (l_index < 20) THEN -- Bug 5015438
3505: pay_ie_p45_archive.process_balance (
3506: p_action_context_id => l_action_context_id
3507: , p_assignment_id => csr_rec.assignment_id
3508: , p_person_id => l_person_id
3509: , p_source_id => l_child_pay_action

Line 3522: pay_ie_p45_archive.process_supp_balance (

3518: , p_last_p45_pact => l_last_p45_pact -- Bug 5005788
3519: , p_prev_src_id => l_prev_src_id);
3520: ELSE
3521: IF (l_supp_flag = 'Y') THEN
3522: pay_ie_p45_archive.process_supp_balance (
3523: p_action_context_id => l_action_context_id
3524: , p_assignment_id => csr_rec.assignment_id
3525: , p_person_id => l_person_id
3526: , p_source_id => l_child_pay_action

Line 4195: END pay_ie_p45_archive;

4191: END IF;
4192:
4193: END generate_xml;
4194:
4195: END pay_ie_p45_archive;