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.46.12020000.6 2013/03/14 08:00:28 rsahai 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 240: g_package CONSTANT VARCHAR2(30) := 'pay_ie_p45_archive.';

236: g_period_week_std_cutoff NUMBER; /* 5528450 */
237:
238:
239:
240: g_package CONSTANT VARCHAR2(30) := 'pay_ie_p45_archive.';
241:
242: g_archive_pact NUMBER;
243: g_archive_effective_date DATE;
244: g_archive_start_date DATE;

Line 728: pay_ie_p45_archive.get_parameters (

724: FETCH csr_archive_effective_date
725: INTO g_archive_effective_date;
726: CLOSE csr_archive_effective_date;
727:
728: pay_ie_p45_archive.get_parameters (
729: p_payroll_action_id => p_payroll_action_id
730: , p_token_name => 'EMPLOYER'
731: , p_token_value => g_paye_ref);
732:

Line 733: pay_ie_p45_archive.get_parameters (

729: p_payroll_action_id => p_payroll_action_id
730: , p_token_name => 'EMPLOYER'
731: , p_token_value => g_paye_ref);
732:
733: pay_ie_p45_archive.get_parameters (
734: p_payroll_action_id => p_payroll_action_id
735: , p_token_name => 'END_DATE'
736: , p_token_value => l_end_date);
737:

Line 738: pay_ie_p45_archive.get_parameters (

734: p_payroll_action_id => p_payroll_action_id
735: , p_token_name => 'END_DATE'
736: , p_token_value => l_end_date);
737:
738: pay_ie_p45_archive.get_parameters (
739: p_payroll_action_id => p_payroll_action_id
740: , p_token_name => 'START_DATE'
741: , p_token_value => l_start_date);
742:

Line 743: pay_ie_p45_archive.get_parameters (

739: p_payroll_action_id => p_payroll_action_id
740: , p_token_name => 'START_DATE'
741: , p_token_value => l_start_date);
742:
743: pay_ie_p45_archive.get_parameters (
744: p_payroll_action_id => p_payroll_action_id
745: , p_token_name => 'BG_ID'
746: , p_token_value => l_bg_id);
747:

Line 822: pay_ie_p45_archive.setup_standard_balance_table;

818: g_period_week_std_cutoff;
819: CLOSE csr_input_value_id;
820:
821: hr_utility.set_location('stage 2',23);
822: pay_ie_p45_archive.setup_standard_balance_table;
823:
824: hr_utility.set_location('stage 3',24);
825:
826: -- hr_utility.set_location('l_payroll_id = ' || l_payroll_id,20);

Line 1135: pay_ie_p45_archive.get_parameters (

1131:
1132: hr_utility.set_location('p_payroll_child_actid'||p_payroll_child_actid,30);
1133: hr_utility.set_location('p_ppsn_override_flag'||p_ppsn_override_flag,30);
1134: -- get the business group id
1135: pay_ie_p45_archive.get_parameters (
1136: p_payroll_action_id => g_archive_pact
1137: , p_token_name => 'BG_ID'
1138: , p_token_value => l_bg_id);
1139:

Line 3383: pay_ie_p45_archive.get_parameters (

3379: OPEN csr_check_archived(p_payroll_action_id);
3380: FETCH csr_check_archived INTO l_archived;
3381: CLOSE csr_check_archived;
3382: IF l_archived = 0 THEN
3383: pay_ie_p45_archive.get_parameters (
3384: p_payroll_action_id => p_payroll_action_id
3385: , p_token_name => 'EMPLOYER'
3386: , p_token_value => g_paye_ref);
3387: /*

Line 3388: pay_ie_p45_archive.get_parameters (

3384: p_payroll_action_id => p_payroll_action_id
3385: , p_token_name => 'EMPLOYER'
3386: , p_token_value => g_paye_ref);
3387: /*
3388: pay_ie_p45_archive.get_parameters (
3389: p_payroll_action_id => p_payroll_action_id
3390: , p_token_name => 'CONSOLIDATION'
3391: , p_token_value => l_consolidation_set);
3392: pay_ie_p45_archive.get_parameters (

Line 3392: pay_ie_p45_archive.get_parameters (

3388: pay_ie_p45_archive.get_parameters (
3389: p_payroll_action_id => p_payroll_action_id
3390: , p_token_name => 'CONSOLIDATION'
3391: , p_token_value => l_consolidation_set);
3392: pay_ie_p45_archive.get_parameters (
3393: p_payroll_action_id => p_payroll_action_id
3394: , p_token_name => 'ASSIGNMENT_SET'
3395: , p_token_value => l_assignment_set_id);
3396: pay_ie_p45_archive.get_parameters (

Line 3396: pay_ie_p45_archive.get_parameters (

3392: pay_ie_p45_archive.get_parameters (
3393: p_payroll_action_id => p_payroll_action_id
3394: , p_token_name => 'ASSIGNMENT_SET'
3395: , p_token_value => l_assignment_set_id);
3396: pay_ie_p45_archive.get_parameters (
3397: p_payroll_action_id => p_payroll_action_id
3398: , p_token_name => 'START_DATE'
3399: , p_token_value => l_start_date);
3400: */

Line 3401: pay_ie_p45_archive.get_parameters (

3397: p_payroll_action_id => p_payroll_action_id
3398: , p_token_name => 'START_DATE'
3399: , p_token_value => l_start_date);
3400: */
3401: pay_ie_p45_archive.get_parameters (
3402: p_payroll_action_id => p_payroll_action_id
3403: , p_token_name => 'END_DATE'
3404: , p_token_value => l_end_date);
3405:

Line 3406: pay_ie_p45_archive.get_parameters (

3402: p_payroll_action_id => p_payroll_action_id
3403: , p_token_name => 'END_DATE'
3404: , p_token_value => l_end_date);
3405:
3406: pay_ie_p45_archive.get_parameters (
3407: p_payroll_action_id => p_payroll_action_id
3408: , p_token_name => 'START_DATE'
3409: , p_token_value => l_start_date);
3410:

Line 3411: pay_ie_p45_archive.get_parameters (

3407: p_payroll_action_id => p_payroll_action_id
3408: , p_token_name => 'START_DATE'
3409: , p_token_value => l_start_date);
3410:
3411: pay_ie_p45_archive.get_parameters (
3412: p_payroll_action_id => p_payroll_action_id
3413: , p_token_name => 'BG_ID'
3414: , p_token_value => l_bg_id);
3415: hr_utility.set_location('Step ' || l_proc,20);

Line 3489: pay_ie_p45_archive.setup_standard_balance_table;

3485: as the same cursor csr_payroll_info can be used to get the required details */
3486: /*
3487: END LOOP;
3488: -- setup statutory balances pl/sql table
3489: pay_ie_p45_archive.setup_standard_balance_table;
3490: FOR rec_payroll_info in csr_all_payroll_info(p_payroll_action_id)
3491: LOOP
3492: */
3493: hr_utility.trace('Entered payroll info');

Line 3496: pay_ie_p45_archive.setup_balance_definitions(p_payroll_action_id,

3492: */
3493: hr_utility.trace('Entered payroll info');
3494: pay_balance_pkg.set_context('PAYROLL_ACTION_ID'
3495: , rec_payroll_info.payroll_action_id);
3496: pay_ie_p45_archive.setup_balance_definitions(p_payroll_action_id,
3497: rec_payroll_info.payroll_action_id,
3498: rec_payroll_info.effective_date);
3499: END LOOP;
3500: --end if;

Line 3549: pay_ie_p45_archive.get_parameters (

3545: BEGIN
3546: -- hr_utility.trace_on(null,'P45');
3547: hr_utility.set_location('Entering ' || l_proc,10);
3548: /*
3549: pay_ie_p45_archive.get_parameters (
3550: p_payroll_action_id => pactid
3551: , p_token_name => 'PAYROLL'
3552: , p_token_value => l_payroll_id);
3553: pay_ie_p45_archive.get_parameters (

Line 3553: pay_ie_p45_archive.get_parameters (

3549: pay_ie_p45_archive.get_parameters (
3550: p_payroll_action_id => pactid
3551: , p_token_name => 'PAYROLL'
3552: , p_token_value => l_payroll_id);
3553: pay_ie_p45_archive.get_parameters (
3554: p_payroll_action_id => pactid
3555: , p_token_name => 'CONSOLIDATION'
3556: , p_token_value => l_consolidation_set);
3557: pay_ie_p45_archive.get_parameters (

Line 3557: pay_ie_p45_archive.get_parameters (

3553: pay_ie_p45_archive.get_parameters (
3554: p_payroll_action_id => pactid
3555: , p_token_name => 'CONSOLIDATION'
3556: , p_token_value => l_consolidation_set);
3557: pay_ie_p45_archive.get_parameters (
3558: p_payroll_action_id => pactid
3559: , p_token_name => 'ASSIGNMENT_SET'
3560: , p_token_value => l_assignment_set_id);
3561: pay_ie_p45_archive.get_parameters (

Line 3561: pay_ie_p45_archive.get_parameters (

3557: pay_ie_p45_archive.get_parameters (
3558: p_payroll_action_id => pactid
3559: , p_token_name => 'ASSIGNMENT_SET'
3560: , p_token_value => l_assignment_set_id);
3561: pay_ie_p45_archive.get_parameters (
3562: p_payroll_action_id => pactid
3563: , p_token_name => 'START_DATE'
3564: , p_token_value => l_start_date);
3565: */

Line 3566: pay_ie_p45_archive.get_parameters (

3562: p_payroll_action_id => pactid
3563: , p_token_name => 'START_DATE'
3564: , p_token_value => l_start_date);
3565: */
3566: pay_ie_p45_archive.get_parameters (
3567: p_payroll_action_id => pactid
3568: , p_token_name => 'END_DATE'
3569: , p_token_value => l_end_date);
3570:

Line 3571: pay_ie_p45_archive.get_parameters (

3567: p_payroll_action_id => pactid
3568: , p_token_name => 'END_DATE'
3569: , p_token_value => l_end_date);
3570:
3571: pay_ie_p45_archive.get_parameters (
3572: p_payroll_action_id => pactid
3573: , p_token_name => 'BG_ID'
3574: , p_token_value => l_bg_id);
3575:

Line 3576: pay_ie_p45_archive.get_parameters (

3572: p_payroll_action_id => pactid
3573: , p_token_name => 'BG_ID'
3574: , p_token_value => l_bg_id);
3575:
3576: pay_ie_p45_archive.get_parameters (
3577: p_payroll_action_id => pactid
3578: , p_token_name => 'EMPLOYER'
3579: , p_token_value => l_employer);
3580:

Line 3581: pay_ie_p45_archive.get_parameters (

3577: p_payroll_action_id => pactid
3578: , p_token_name => 'EMPLOYER'
3579: , p_token_value => l_employer);
3580:
3581: pay_ie_p45_archive.get_parameters (
3582: p_payroll_action_id => pactid
3583: , p_token_name => 'START_DATE'
3584: , p_token_value => l_start_date);
3585:

Line 3802: pay_ie_p45_archive.get_parameters (

3798: BEGIN
3799:
3800: --hr_utility.trace_on(null,'P45');
3801: hr_utility.set_location('Entering ' || l_proc,10);
3802: pay_ie_p45_archive.get_parameters (
3803: p_payroll_action_id => pactid
3804: , p_token_name => 'EMPLOYER'
3805: , p_token_value => g_paye_ref);
3806:

Line 3807: pay_ie_p45_archive.get_parameters (

3803: p_payroll_action_id => pactid
3804: , p_token_name => 'EMPLOYER'
3805: , p_token_value => g_paye_ref);
3806:
3807: pay_ie_p45_archive.get_parameters (
3808: p_payroll_action_id => pactid
3809: , p_token_name => 'END_DATE'
3810: , p_token_value => l_end_date);
3811:

Line 3812: pay_ie_p45_archive.get_parameters (

3808: p_payroll_action_id => pactid
3809: , p_token_name => 'END_DATE'
3810: , p_token_value => l_end_date);
3811:
3812: pay_ie_p45_archive.get_parameters (
3813: p_payroll_action_id => pactid
3814: , p_token_name => 'BG_ID'
3815: , p_token_value => l_bg_id);
3816:

Line 3817: pay_ie_p45_archive.get_parameters (

3813: p_payroll_action_id => pactid
3814: , p_token_name => 'BG_ID'
3815: , p_token_value => l_bg_id);
3816:
3817: pay_ie_p45_archive.get_parameters (
3818: p_payroll_action_id => pactid
3819: , p_token_name => 'START_DATE'
3820: , p_token_value => l_start_date);
3821:

Line 3822: pay_ie_p45_archive.get_parameters ( -- 5059862

3818: p_payroll_action_id => pactid
3819: , p_token_name => 'START_DATE'
3820: , p_token_value => l_start_date);
3821:
3822: pay_ie_p45_archive.get_parameters ( -- 5059862
3823: p_payroll_action_id => pactid
3824: , p_token_name => 'PAYROLL'
3825: , p_token_value => l_payroll_id);
3826:

Line 4256: pay_ie_p45_archive.archive_p45_info(

4252: lockingactid => l_actid
4253: , lockedactid => l_child_pay_action);
4254: END IF;
4255:
4256: pay_ie_p45_archive.archive_p45_info(
4257: p_action_context_id => p_assactid,
4258: p_assignment_id => csr_rec.assignment_id, -- assignment_id
4259: p_payroll_id => l_payroll_id,
4260: p_date_earned => csr_rec.date_earned,

Line 4293: pay_ie_p45_archive.archive_employee_details(

4289: lockingactid => l_actid
4290: , lockedactid => l_last_p45_action);
4291: END IF;
4292:
4293: pay_ie_p45_archive.archive_employee_details(
4294: p_assactid => l_action_context_id -- P45 master action
4295: , p_assignment_id => l_assignment_id
4296: , p_curr_pymt_ass_act_id => csr_rec.pre_assignment_action_id -- prepayment assignment_action_id
4297: , p_date_earned => csr_rec.date_earned -- payroll date_earned

Line 4334: pay_ie_p45_archive.process_balance (

4330: /*
4331: --Bug:2448728.Passing the prepayment assignment action id to p_source_id as the _PAYMENTS
4332: --balances are fed only during pre Payments.
4333: If g_statutory_balance_table(l_index).balance_name = 'Total Pay' Then
4334: pay_ie_p45_archive.process_balance (
4335: p_action_context_id => l_action_context_id
4336: , p_assignment_id => csr_rec.assignment_id
4337: , p_source_id => csr_rec.pre_assignment_action_id
4338: , p_effective_date => csr_rec.effective_date

Line 4349: pay_ie_p45_archive.process_balance (

4345: -- IF ( l_supp_flag = 'Y' OR l_index < 19 OR l_index > 31 ) THEN
4346:
4347: -- IF (l_index < 20) THEN -- Bug 5015438 13359530
4348: IF (l_index < 24) THEN
4349: pay_ie_p45_archive.process_balance (
4350: p_action_context_id => l_action_context_id
4351: , p_assignment_id => csr_rec.assignment_id
4352: , p_person_id => l_person_id
4353: , p_source_id => l_child_pay_action

Line 4366: pay_ie_p45_archive.process_supp_balance (

4362: , p_last_p45_pact => l_last_p45_pact -- Bug 5005788
4363: , p_prev_src_id => l_prev_src_id);
4364: ELSE
4365: IF (l_supp_flag = 'Y') THEN
4366: pay_ie_p45_archive.process_supp_balance (
4367: p_action_context_id => l_action_context_id
4368: , p_assignment_id => csr_rec.assignment_id
4369: , p_person_id => l_person_id
4370: , p_source_id => l_child_pay_action

Line 4394: pay_ie_p45_archive.process_balance (

4390: hr_utility.set_location('database_item_suffix ='||g_statutory_balance_table_ppsn(l_index).database_item_suffix,70);
4391:
4392: -- IF (l_index < 20) THEN -- Bug 5015438 13359530
4393: IF (l_index < 24) THEN
4394: pay_ie_p45_archive.process_balance (
4395: p_action_context_id => l_action_context_id
4396: , p_assignment_id => csr_rec.assignment_id
4397: , p_person_id => l_person_id
4398: , p_source_id => l_child_pay_action_ppsn

Line 4413: pay_ie_p45_archive.process_supp_balance (

4409:
4410: ELSE
4411: IF (l_supp_flag = 'Y') THEN
4412: hr_utility.set_location('entered the if block and supp flag is y ' ,70);
4413: pay_ie_p45_archive.process_supp_balance (
4414: p_action_context_id => l_action_context_id
4415: , p_assignment_id => csr_rec.assignment_id
4416: , p_person_id => l_person_id
4417: , p_source_id => l_child_pay_action_ppsn

Line 4969: /* pay_ie_p45_archive.get_parameters (

4965: IF once_per_run = 'N' THEN
4966: -- Start of xml doc
4967: /* 7291676 */
4968: --bug 14197192
4969: /* pay_ie_p45_archive.get_parameters (
4970: p_payroll_action_id => p_p45_archive_process
4971: , p_token_name => 'START_DATE'
4972: , p_token_value => l_start_date); */
4973: pay_ie_p45_archive.get_parameters (

Line 4973: pay_ie_p45_archive.get_parameters (

4969: /* pay_ie_p45_archive.get_parameters (
4970: p_payroll_action_id => p_p45_archive_process
4971: , p_token_name => 'START_DATE'
4972: , p_token_value => l_start_date); */
4973: pay_ie_p45_archive.get_parameters (
4974: p_payroll_action_id => p_p45_archive_process
4975: , p_token_name => 'END_DATE'
4976: , p_token_value => l_start_date);
4977:

Line 5837: END pay_ie_p45_archive;

5833: END IF;
5834:
5835: END generate_xml;
5836:
5837: END pay_ie_p45_archive;
5838: