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_NL_PAYSLIP_ARCHIVE dependencies on PAY_NL_PAYSLIP_ARCHIVE

Line 1: PACKAGE BODY PAY_NL_PAYSLIP_ARCHIVE as

1: PACKAGE BODY PAY_NL_PAYSLIP_ARCHIVE as
2: /* $Header: pynlparc.pkb 120.30 2010/11/01 14:10:57 vijranga noship $ */
3:
4: g_package varchar2(33) := ' PAY_NL_PAYSLIP_ARCHIVE.';
5:

Line 4: g_package varchar2(33) := ' PAY_NL_PAYSLIP_ARCHIVE.';

1: PACKAGE BODY PAY_NL_PAYSLIP_ARCHIVE as
2: /* $Header: pynlparc.pkb 120.30 2010/11/01 14:10:57 vijranga noship $ */
3:
4: g_package varchar2(33) := ' PAY_NL_PAYSLIP_ARCHIVE.';
5:
6:
7: -----------------------------------------------------------------------------
8: -- Globals

Line 291: SELECT PAY_NL_PAYSLIP_ARCHIVE.get_parameter(legislative_parameters,'PAYROLL_ID')

287: ,p_consolidation_set OUT NOCOPY VARCHAR2) IS
288: --
289: CURSOR csr_parameter_info(p_payroll_action_id NUMBER) IS
290:
291: SELECT PAY_NL_PAYSLIP_ARCHIVE.get_parameter(legislative_parameters,'PAYROLL_ID')
292: ,PAY_NL_PAYSLIP_ARCHIVE.get_parameter(legislative_parameters,'CONSOLIDATION_SET_ID')
293: ,PAY_NL_PAYSLIP_ARCHIVE.get_parameter(legislative_parameters,'START_DATE')
294: ,PAY_NL_PAYSLIP_ARCHIVE.get_parameter(legislative_parameters,'END_DATE')
295: ,effective_date

Line 292: ,PAY_NL_PAYSLIP_ARCHIVE.get_parameter(legislative_parameters,'CONSOLIDATION_SET_ID')

288: --
289: CURSOR csr_parameter_info(p_payroll_action_id NUMBER) IS
290:
291: SELECT PAY_NL_PAYSLIP_ARCHIVE.get_parameter(legislative_parameters,'PAYROLL_ID')
292: ,PAY_NL_PAYSLIP_ARCHIVE.get_parameter(legislative_parameters,'CONSOLIDATION_SET_ID')
293: ,PAY_NL_PAYSLIP_ARCHIVE.get_parameter(legislative_parameters,'START_DATE')
294: ,PAY_NL_PAYSLIP_ARCHIVE.get_parameter(legislative_parameters,'END_DATE')
295: ,effective_date
296: ,business_group_id

Line 293: ,PAY_NL_PAYSLIP_ARCHIVE.get_parameter(legislative_parameters,'START_DATE')

289: CURSOR csr_parameter_info(p_payroll_action_id NUMBER) IS
290:
291: SELECT PAY_NL_PAYSLIP_ARCHIVE.get_parameter(legislative_parameters,'PAYROLL_ID')
292: ,PAY_NL_PAYSLIP_ARCHIVE.get_parameter(legislative_parameters,'CONSOLIDATION_SET_ID')
293: ,PAY_NL_PAYSLIP_ARCHIVE.get_parameter(legislative_parameters,'START_DATE')
294: ,PAY_NL_PAYSLIP_ARCHIVE.get_parameter(legislative_parameters,'END_DATE')
295: ,effective_date
296: ,business_group_id
297: FROM pay_payroll_actions

Line 294: ,PAY_NL_PAYSLIP_ARCHIVE.get_parameter(legislative_parameters,'END_DATE')

290:
291: SELECT PAY_NL_PAYSLIP_ARCHIVE.get_parameter(legislative_parameters,'PAYROLL_ID')
292: ,PAY_NL_PAYSLIP_ARCHIVE.get_parameter(legislative_parameters,'CONSOLIDATION_SET_ID')
293: ,PAY_NL_PAYSLIP_ARCHIVE.get_parameter(legislative_parameters,'START_DATE')
294: ,PAY_NL_PAYSLIP_ARCHIVE.get_parameter(legislative_parameters,'END_DATE')
295: ,effective_date
296: ,business_group_id
297: FROM pay_payroll_actions
298: WHERE payroll_action_id = p_payroll_action_id;

Line 660: pay_nl_payslip_archive.get_all_parameters(pactid

656: --
657: --hr_utility.trace_on(NULL,'PSA');
658: --hr_utility.set_location('Entering Range Code',50);
659: --
660: pay_nl_payslip_archive.get_all_parameters(pactid
661: ,l_business_group_id
662: ,l_start_date
663: ,l_end_date
664: ,l_effective_date

Line 691: pay_nl_payslip_archive.get_eit_definitions (

687:
688: -- Populates the global PL/SQL Table with Balance information and archives
689: -- EMEA BALANCE DEFINITION Context
690: --
691: pay_nl_payslip_archive.get_eit_definitions (
692: p_pactid => pactid
693: , p_business_group_id => l_business_group_id
694: , p_payroll_pact => NULL
695: , p_effective_date => l_canonical_start_date

Line 705: pay_nl_payslip_archive.get_eit_definitions (

701:
702: -- Populates the global PL/SQL Table with Element information and archives
703: -- EMEA ELEMENT DEFINITION Context
704: --
705: pay_nl_payslip_archive.get_eit_definitions (
706: p_pactid => pactid
707: , p_business_group_id => l_business_group_id
708: , p_payroll_pact => NULL
709: , p_effective_date => l_canonical_start_date

Line 932: pay_nl_payslip_archive.get_all_parameters(p_payroll_action_id

928: --hr_utility.set_location('Entering Assignment Action Code',400);
929: --
930:
931:
932: pay_nl_payslip_archive.get_all_parameters(p_payroll_action_id
933: ,l_business_group_id,l_start_date,l_end_date
934: ,l_effective_date,l_payroll_id,l_consolidation_set);
935:
936: --

Line 1343: pay_nl_payslip_archive.get_all_parameters(p_payroll_action_id

1339: BEGIN
1340: --
1341: --hr_utility.set_location('Entering Archive Init',600);
1342: --
1343: pay_nl_payslip_archive.get_all_parameters(p_payroll_action_id
1344: ,l_business_group_id
1345: ,l_start_date,l_end_date,l_effective_date
1346: ,l_payroll_id,l_consolidation_set);
1347: --

Line 1369: pay_nl_payslip_archive.get_eit_definitions (

1365: -- Populates the global PL/SQL Table with Balance information and archives
1366: -- EMEA BALANCE DEFINITION Context
1367: --
1368: IF g_user_balance_table.count = 0 THEN
1369: pay_nl_payslip_archive.get_eit_definitions (
1370: p_pactid => p_payroll_action_id
1371: , p_business_group_id => l_business_group_id
1372: , p_payroll_pact => NULL
1373: , p_effective_date => l_canonical_start_date

Line 1384: pay_nl_payslip_archive.get_eit_definitions (

1380: -- Populates the global PL/SQL Table with Element information and archives
1381: -- EMEA ELEMENT DEFINITION Context
1382: --
1383: IF g_element_table.count = 0 THEN
1384: pay_nl_payslip_archive.get_eit_definitions (
1385: p_pactid => p_payroll_action_id
1386: , p_business_group_id => l_business_group_id
1387: , p_payroll_pact => NULL
1388: , p_effective_date => l_canonical_start_date

Line 6292: pay_nl_payslip_archive.archive_employee_details (

6288: l_prepay_asg_action_id := csr_rec.master_pre_asg_action_id;
6289: ELSE
6290: l_prepay_asg_action_id := csr_rec.pre_assignment_action_id;
6291: END IF;
6292: pay_nl_payslip_archive.archive_employee_details (
6293: p_payroll_action_id => g_payroll_action_id
6294: ,p_assactid => p_assignment_action_id
6295: ,p_assignment_id => csr_rec.assignment_id
6296: ,p_curr_pymt_ass_act_id => l_prepay_asg_action_id

Line 6303: pay_nl_payslip_archive.archive_nl_employee_details (

6299: ,p_curr_pymt_eff_date => l_payment_date
6300: ,p_time_period_id => l_time_period_id
6301: ,p_record_count => l_record_count);
6302:
6303: pay_nl_payslip_archive.archive_nl_employee_details (
6304: p_assg_action_id => p_assignment_action_id
6305: ,p_assignment_id => csr_rec.assignment_id
6306: ,p_master_asg_act_id => l_latest_child_asg_action_id
6307: ,p_payroll_id =>csr_rec.payroll_id

Line 6321: pay_nl_payslip_archive.process_balance (

6317: LOOP
6318:
6319: hr_utility.set_location('Inside Archive Code for NP run Type'||g_user_balance_table(l_index).balance_name,1260);
6320:
6321: pay_nl_payslip_archive.process_balance (
6322: p_action_context_id => p_assignment_action_id
6323: , p_assignment_id => csr_rec.assignment_id
6324: , p_source_id => l_latest_child_asg_action_id
6325: , p_effective_date => csr_rec.effective_date

Line 6342: pay_nl_payslip_archive.process_balance (

6338: /*FOR l_index IN 1 .. g_statutory_balance_table.count
6339: LOOP
6340:
6341: hr_utility.set_location('Inside Archive Code for NP run Type '||g_statutory_balance_table(l_index).balance_name,1270);
6342: pay_nl_payslip_archive.process_balance (
6343: p_action_context_id => p_assignment_action_id
6344: ,p_assignment_id => csr_rec.assignment_id
6345: ,p_source_id => l_latest_child_asg_action_id
6346: ,p_effective_date => csr_rec.effective_date

Line 6357: /*pay_nl_payslip_archive.archive_payslip_balance_info(

6353: END LOOP;*/
6354: --
6355: -- Archive Payslip Balances in NL CALCULATIONS Context
6356: --
6357: /*pay_nl_payslip_archive.archive_payslip_balance_info(
6358: p_arch_assign_action_id => p_assignment_action_id
6359: , p_run_assign_action_id =>csr_rec.master_assignment_action_id
6360: , p_date_earned => csr_rec.date_earned
6361: , p_record_count =>l_record_count

Line 6397: pay_nl_payslip_archive.archive_payslip_element_info (

6393: LOOP
6394: --
6395: -- Archive Statutory Element Information in NL CALCULATIONS Context
6396:
6397: pay_nl_payslip_archive.archive_payslip_element_info (
6398: p_arch_assign_action_id => p_assignment_action_id
6399: , p_run_assign_action_id =>
6400: csr_np_rec.np_assignment_action_id
6401: , p_date_earned => csr_rec.date_earned

Line 6418: pay_nl_payslip_archive.archive_nl_employee_details (

6414: l_latest_child_asg_action_id := csr_np_rec.np_assignment_action_id;
6415:
6416: --Bug 5982957 Starts
6417: IF l_dp_de = 'DE' THEN
6418: pay_nl_payslip_archive.archive_nl_employee_details (
6419: p_assg_action_id => p_assignment_action_id
6420: ,p_assignment_id => csr_rec.assignment_id
6421: ,p_master_asg_act_id => l_latest_child_asg_action_id
6422: ,p_payroll_id =>csr_rec.payroll_id

Line 6445: pay_nl_payslip_archive.archive_employee_details (

6441: l_prepay_asg_action_id := csr_rec.master_pre_asg_action_id;
6442: ELSE
6443: l_prepay_asg_action_id := csr_rec.pre_assignment_action_id;
6444: END IF;
6445: pay_nl_payslip_archive.archive_employee_details (
6446: p_payroll_action_id => g_payroll_action_id
6447: ,p_assactid => p_assignment_action_id
6448: ,p_assignment_id => csr_rec.assignment_id
6449: ,p_curr_pymt_ass_act_id => l_prepay_asg_action_id

Line 6459: pay_nl_payslip_archive.archive_nl_employee_details (

6455:
6456: IF l_nl_emp_archived = 0 THEN
6457: --Bug 5982957 extra if condition added
6458: IF l_dp_de = 'DP' THEN
6459: pay_nl_payslip_archive.archive_nl_employee_details (
6460: p_assg_action_id => p_assignment_action_id
6461: ,p_assignment_id => csr_rec.assignment_id
6462: ,p_master_asg_act_id => l_latest_child_asg_action_id
6463: ,p_payroll_id =>csr_rec.payroll_id

Line 6466: pay_nl_payslip_archive.archive_payslip_balance_info(

6462: ,p_master_asg_act_id => l_latest_child_asg_action_id
6463: ,p_payroll_id =>csr_rec.payroll_id
6464: ,p_date_earned => csr_rec.effective_date);
6465: END IF;
6466: pay_nl_payslip_archive.archive_payslip_balance_info(
6467: p_arch_assign_action_id => p_assignment_action_id
6468: , p_run_assign_action_id =>csr_rec.master_assignment_action_id
6469: , p_date_earned => csr_rec.date_earned
6470: , p_record_count =>l_record_count

Line 6483: pay_nl_payslip_archive.archive_user_element_info (

6479:
6480: END IF;
6481:
6482: -- Archive User Element Information in EMEA ELEMENT INFO Context
6483: pay_nl_payslip_archive.archive_user_element_info (
6484: p_action_context_id => p_assignment_action_id
6485: , p_assignment_id => csr_rec.assignment_id
6486: , p_child_assignment_action =>
6487: csr_np_rec.np_assignment_action_id

Line 6505: pay_nl_payslip_archive.process_balance (

6501: IF ((v_csr_max_assact.max_assact <> p_assignment_action_id AND (l_stat_not_ytd = 1))
6502: OR (v_csr_max_assact.max_assact = p_assignment_action_id AND csr_np_rec.np_assignment_action_id <> csr_child_rec.child_assignment_action_id AND (l_stat_not_ytd = 1))
6503: OR v_csr_max_assact.max_assact = p_assignment_action_id AND csr_np_rec.np_assignment_action_id = csr_child_rec.child_assignment_action_id AND (l_archive_stat = 0 OR (l_archive_stat = 1 AND l_stat_not_ytd = 1))) THEN
6504: hr_utility.set_location('Inside Archive Code for NP run Type '||g_statutory_balance_table(l_index).balance_name,1270);
6505: pay_nl_payslip_archive.process_balance (
6506: p_action_context_id => p_assignment_action_id
6507: ,p_assignment_id => csr_rec.assignment_id
6508: ,p_source_id => csr_np_rec.np_assignment_action_id
6509: ,p_effective_date => csr_rec.effective_date

Line 6532: pay_nl_payslip_archive.process_balance (

6528: IF ((v_csr_max_assact.max_assact <> p_assignment_action_id AND (l_user_not_ytd = 1))
6529: OR (v_csr_max_assact.max_assact = p_assignment_action_id AND csr_np_rec.np_assignment_action_id <> csr_child_rec.child_assignment_action_id AND (l_user_not_ytd = 1))
6530: OR v_csr_max_assact.max_assact = p_assignment_action_id AND csr_np_rec.np_assignment_action_id = csr_child_rec.child_assignment_action_id AND (l_archive_user = 0 OR (l_archive_user = 1 AND l_user_not_ytd = 1))) THEN
6531: hr_utility.set_location('Inside Archive Code for NP run Type'||g_user_balance_table(l_index).balance_name,1260);
6532: pay_nl_payslip_archive.process_balance (
6533: p_action_context_id => p_assignment_action_id
6534: , p_assignment_id => csr_rec.assignment_id
6535: , p_source_id => csr_np_rec.np_assignment_action_id
6536: , p_effective_date => csr_rec.effective_date

Line 6574: pay_nl_payslip_archive.archive_nl_employee_details (

6570: -- and NL SI EMPLOYEE DETAILS
6571: --
6572: --Bug 5982957 (Extra condition added "and l_dp_de= DP/DE")
6573: IF l_nl_emp_archived = 0 and l_dp_de = 'DP' THEN
6574: pay_nl_payslip_archive.archive_nl_employee_details (
6575: p_assg_action_id => p_assignment_action_id
6576: ,p_master_asg_act_id =>csr_rec.master_assignment_action_id
6577: ,p_assignment_id => csr_rec.assignment_id
6578: ,p_payroll_id => csr_rec.payroll_id

Line 6581: pay_nl_payslip_archive.archive_nl_employee_details (

6577: ,p_assignment_id => csr_rec.assignment_id
6578: ,p_payroll_id => csr_rec.payroll_id
6579: ,p_date_earned => csr_rec.effective_date);
6580: ELSIF l_nl_emp_archived = 0 and l_dp_de = 'DE' THEN
6581: pay_nl_payslip_archive.archive_nl_employee_details (
6582: p_assg_action_id => p_assignment_action_id
6583: ,p_master_asg_act_id => csr_rec.master_assignment_action_id
6584: ,p_assignment_id => csr_rec.assignment_id
6585: ,p_payroll_id => csr_rec.payroll_id

Line 6593: pay_nl_payslip_archive.archive_user_element_info (

6589:
6590: --hr_utility.set_location('Inside Archive Code p_assignment_action_id'||p_assignment_action_id,1500);
6591:
6592: -- Archive User Element Information in EMEA ELEMENT INFO Context
6593: pay_nl_payslip_archive.archive_user_element_info (
6594: p_action_context_id => p_assignment_action_id
6595: , p_assignment_id => csr_rec.assignment_id
6596: , p_child_assignment_action =>
6597: csr_rec.master_assignment_action_id

Line 6606: pay_nl_payslip_archive.archive_payslip_element_info (

6602: --hr_utility.set_location('Inside Archive Code csr_rec.master_assignment_action_id'||csr_rec.master_assignment_action_id,1600);
6603:
6604: -- Archive Statutory Element Information in NL CALCULATIONS Context
6605:
6606: pay_nl_payslip_archive.archive_payslip_element_info (
6607: p_arch_assign_action_id => p_assignment_action_id
6608: , p_run_assign_action_id =>
6609: csr_rec.master_assignment_action_id
6610: , p_date_earned => csr_rec.date_earned

Line 6638: pay_nl_payslip_archive.process_balance (

6634: --hr_utility.set_location('Inside Archive Code l_record_count '||l_record_count,1800);
6635: --hr_utility.set_location('Inside Archive Code csr_rec.assignment_id '||csr_rec.assignment_id,1800);
6636:
6637: BEGIN
6638: pay_nl_payslip_archive.process_balance (
6639: p_action_context_id => p_assignment_action_id
6640: , p_assignment_id => csr_rec.assignment_id
6641: , p_source_id => csr_rec.master_assignment_action_id
6642: , p_effective_date => csr_rec.effective_date

Line 6676: pay_nl_payslip_archive.process_balance (

6672: --hr_utility.set_location('Inside Archive Code l_iterative_flag'||g_statutory_balance_table(l_index).defined_balance_id,2001);
6673: --hr_utility.set_location('Inside Archive Code l_iterative_flag'||g_statutory_balance_table(l_index).si_type,2001);
6674: --hr_utility.set_location('Inside Archive Code l_iterative_flag'||l_record_count,2001);
6675:
6676: pay_nl_payslip_archive.process_balance (
6677: p_action_context_id => p_assignment_action_id
6678: ,p_assignment_id => csr_rec.assignment_id
6679: ,p_source_id => csr_rec.master_assignment_action_id
6680: ,p_effective_date => csr_rec.effective_date

Line 6702: pay_nl_payslip_archive.archive_payslip_balance_info(

6698: --hr_utility.set_location('Inside Archive Code csr_rec.master_assignment_action_id'||csr_rec.master_assignment_action_id,2100);
6699: --hr_utility.set_location('Inside Archive Code csr_rec.date_earned'||csr_rec.date_earned,2100);
6700: --hr_utility.set_location('Inside Archive Code l_record_count'||l_record_count,2100);
6701: IF l_nl_emp_archived = 0 THEN
6702: pay_nl_payslip_archive.archive_payslip_balance_info(
6703: p_arch_assign_action_id => p_assignment_action_id
6704: , p_run_assign_action_id =>
6705: csr_rec.master_assignment_action_id
6706: , p_date_earned => csr_rec.date_earned

Line 6729: END PAY_NL_PAYSLIP_ARCHIVE;

6725: --hr_utility.set_location('Leaving Archive code',2300);
6726: --
6727: END ARCHIVE_CODE;
6728:
6729: END PAY_NL_PAYSLIP_ARCHIVE;