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_FI_ARCHIVE_TEL dependencies on FND_DATE

Line 113: ,FND_DATE.CANONICAL_TO_DATE(PAY_FI_ARCHIVE_TEL.GET_PARAMETER(legislative_parameters,'REF_DATE'))

109: PAY_FI_ARCHIVE_TEL.GET_PARAMETER(legislative_parameters,'PENSION_INS_NUM') PPID
110: ,TO_NUMBER ( PAY_FI_ARCHIVE_TEL.GET_PARAMETER(legislative_parameters,'LEGAL_EMPLOYER_ID') ) Legal
111: ,TO_NUMBER (PAY_FI_ARCHIVE_TEL.GET_PARAMETER(legislative_parameters,'LOCAL_UNIT_ID') ) Local_unit
112: ,PAY_FI_ARCHIVE_TEL.GET_PARAMETER(legislative_parameters,'REPORT') Annual_Report
113: ,FND_DATE.CANONICAL_TO_DATE(PAY_FI_ARCHIVE_TEL.GET_PARAMETER(legislative_parameters,'REF_DATE'))
114: ,PAY_FI_ARCHIVE_TEL.GET_PARAMETER(legislative_parameters,'ARCHIVE') ARCHIVE_OR_NOT
115: -- ,PAY_FI_ARCHIVE_TEL.GET_PARAMETER(legislative_parameters,'TEST') TEST_OR_NOT
116: ,effective_date Effective_date
117: ,business_group_id BG_ID FROM pay_payroll_actions

Line 359: pay_balance_pkg.set_context('DATE_EARNED',fnd_date.date_to_canonical(g_ref_date));

355: );
356:
357: pay_balance_pkg.set_context('TAX_UNIT_ID',g_legal_employer_id);
358: pay_balance_pkg.set_context('LOCAL_UNIT_ID',g_local_unit_id);
359: pay_balance_pkg.set_context('DATE_EARNED',fnd_date.date_to_canonical(g_ref_date));
360: pay_balance_pkg.set_context('JURISDICTION_CODE',NULL);
361: pay_balance_pkg.set_context('SOURCE_ID',NULL);
362: pay_balance_pkg.set_context('TAX_GROUP',NULL);
363: pay_balance_pkg.set_context('ORGANIZATION_ID',g_pension_provider_id);

Line 533: p_action_information9=> fnd_date.date_to_canonical ( g_ref_date ),

529: p_action_information5=> g_legal_employer_id,
530: p_action_information6=> lr_local_unit_details.NAME,
531: p_action_information7=> g_local_unit_id,
532: p_action_information8=> g_annual_report,
533: p_action_information9=> fnd_date.date_to_canonical ( g_ref_date ),
534: p_action_information10=> g_pension_ins_num,
535: p_action_information11=> NULL,
536: p_action_information12=> NULL,
537: p_action_information13=> NULL,

Line 1115: AND csr_v_effective_date BETWEEN fnd_date.canonical_to_date(hoi2.org_information1) AND

1111: AND hoi1.org_information_context = 'CLASS'
1112: AND o1.organization_id =hoi2.organization_id
1113: AND hoi2.ORG_INFORMATION_CONTEXT='FI_PENSION_PROVIDERS'
1114: AND hoi2.org_information6=csr_v_pension_ins_num
1115: AND csr_v_effective_date BETWEEN fnd_date.canonical_to_date(hoi2.org_information1) AND
1116: nvl(fnd_date.canonical_to_date(hoi2.org_information2),to_date('31/12/4712','DD/MM/YYYY')) ;
1117:
1118: lr_pension_provider csr_pension_provider%ROWTYPE;
1119:

Line 1116: nvl(fnd_date.canonical_to_date(hoi2.org_information2),to_date('31/12/4712','DD/MM/YYYY')) ;

1112: AND o1.organization_id =hoi2.organization_id
1113: AND hoi2.ORG_INFORMATION_CONTEXT='FI_PENSION_PROVIDERS'
1114: AND hoi2.org_information6=csr_v_pension_ins_num
1115: AND csr_v_effective_date BETWEEN fnd_date.canonical_to_date(hoi2.org_information1) AND
1116: nvl(fnd_date.canonical_to_date(hoi2.org_information2),to_date('31/12/4712','DD/MM/YYYY')) ;
1117:
1118: lr_pension_provider csr_pension_provider%ROWTYPE;
1119:
1120: /* Cursor to retrieve Person Details */

Line 1376: l_Pension_Start_date := fnd_date.canonical_to_date(lr_get_person_details.PER_INFORMATION14);

1372:
1373: -- *****************************************************************************
1374: -- TO pick up the Start Date [ Pension Hire date stored at person level. ]
1375:
1376: l_Pension_Start_date := fnd_date.canonical_to_date(lr_get_person_details.PER_INFORMATION14);
1377:
1378: fnd_file.put_line(fnd_file.log,'Pension_Start_date ==> '||l_Pension_Start_date );
1379:
1380: -- *****************************************************************************

Line 1389: pay_balance_pkg.set_context('DATE_EARNED',fnd_date.date_to_canonical(g_ref_date));

1385: pay_balance_pkg.set_context('ASSIGNMENT_ID',l_assignment_id);
1386:
1387: pay_balance_pkg.set_context('TAX_UNIT_ID',g_legal_employer_id);
1388: pay_balance_pkg.set_context('LOCAL_UNIT_ID',g_local_unit_id);
1389: pay_balance_pkg.set_context('DATE_EARNED',fnd_date.date_to_canonical(g_ref_date));
1390: pay_balance_pkg.set_context('JURISDICTION_CODE',NULL);
1391: pay_balance_pkg.set_context('SOURCE_ID',NULL);
1392: pay_balance_pkg.set_context('TAX_GROUP',NULL);
1393: pay_balance_pkg.set_context('ORGANIZATION_ID',g_pension_provider_id);

Line 1516: P_VIRTUAL_DATE => fnd_date.canonical_to_date(lr_get_person_details.PER_INFORMATION20) ),'999999999D99') ;

1512: THEN
1513: l_sal_sub_pension_YTD_before :=to_char(pay_balance_pkg.get_value
1514: (P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id.creator_id,
1515: P_ASSIGNMENT_ID =>l_assignment_id ,
1516: P_VIRTUAL_DATE => fnd_date.canonical_to_date(lr_get_person_details.PER_INFORMATION20) ),'999999999D99') ;
1517: ELSE
1518: l_sal_sub_pension_YTD_before := 0;
1519: END IF;
1520: fnd_file.put_line(fnd_file.log,'l_Sal_subject_pension_PER_PENSION_LU_YEAR_BEFORE ==> '||l_sal_sub_pension_YTD_before );

Line 1543: P_VIRTUAL_DATE => fnd_date.canonical_to_date(lr_get_person_details.PER_INFORMATION20) ),'999999999D99') ;

1539: THEN
1540: l_bik_sub_pension_YTD_before :=to_char(pay_balance_pkg.get_value
1541: (P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id.creator_id,
1542: P_ASSIGNMENT_ID =>l_assignment_id ,
1543: P_VIRTUAL_DATE => fnd_date.canonical_to_date(lr_get_person_details.PER_INFORMATION20) ),'999999999D99') ;
1544: ELSE
1545: l_bik_sub_pension_YTD_before := 0;
1546: END IF;
1547: fnd_file.put_line(fnd_file.log,'l_bik_subject_pension_PER_PENSION_LU_YEAR_before ==> '||l_bik_sub_pension_YTD_before );

Line 1575: P_VIRTUAL_DATE => fnd_date.canonical_to_date(lr_get_person_details.PER_INFORMATION20) ),'999999999D99') ;

1571: THEN
1572: l_tax_exp_pension_YTD_before :=to_char(pay_balance_pkg.get_value
1573: (P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id.creator_id,
1574: P_ASSIGNMENT_ID =>l_assignment_id ,
1575: P_VIRTUAL_DATE => fnd_date.canonical_to_date(lr_get_person_details.PER_INFORMATION20) ),'999999999D99') ;
1576: ELSE
1577: l_tax_exp_pension_YTD_before := 0;
1578: END IF;
1579: fnd_file.put_line(fnd_file.log,'l_tax_exp_subject_pension_PER_PENSION_LU_YEAR_BEFORE ==> '||l_tax_exp_pension_YTD_before );

Line 1696: P_VIRTUAL_DATE => fnd_date.canonical_to_date(lr_get_person_details.PER_INFORMATION20) ),'999999999D99') ;

1692: THEN
1693: l_sal_sub_pension_YTD_before :=to_char(pay_balance_pkg.get_value
1694: (P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id.creator_id,
1695: P_ASSIGNMENT_ID =>l_assignment_id ,
1696: P_VIRTUAL_DATE => fnd_date.canonical_to_date(lr_get_person_details.PER_INFORMATION20) ),'999999999D99') ;
1697: ELSE
1698: l_sal_sub_pension_YTD_before := 0;
1699: END IF;
1700: fnd_file.put_line(fnd_file.log,'l_Sal_subject_pension_PER_PENSION_LE_YEAR_BEFORE ==> '||l_sal_sub_pension_YTD_before );

Line 1721: P_VIRTUAL_DATE => fnd_date.canonical_to_date(lr_get_person_details.PER_INFORMATION20) ),'999999999D99') ;

1717: THEN
1718: l_bik_sub_pension_YTD_before :=to_char(pay_balance_pkg.get_value
1719: (P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id.creator_id,
1720: P_ASSIGNMENT_ID =>l_assignment_id ,
1721: P_VIRTUAL_DATE => fnd_date.canonical_to_date(lr_get_person_details.PER_INFORMATION20) ),'999999999D99') ;
1722: ELSE
1723: l_bik_sub_pension_YTD_before := 0;
1724: END IF;
1725: fnd_file.put_line(fnd_file.log,'l_bik_subject_pension_PER_PENSION_LE_YEAR_before ==> '||l_bik_sub_pension_YTD_before );

Line 1749: P_VIRTUAL_DATE => fnd_date.canonical_to_date(lr_get_person_details.PER_INFORMATION20) ),'999999999D99') ;

1745: THEN
1746: l_tax_exp_pension_YTD_before :=to_char(pay_balance_pkg.get_value
1747: (P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id.creator_id,
1748: P_ASSIGNMENT_ID =>l_assignment_id ,
1749: P_VIRTUAL_DATE => fnd_date.canonical_to_date(lr_get_person_details.PER_INFORMATION20) ),'999999999D99') ;
1750: ELSE
1751: l_tax_exp_pension_YTD_before := 0;
1752: END IF;
1753: fnd_file.put_line(fnd_file.log,'l_tax_exp_subject_pension_PER_PENSION_LE_YEAR_BEFORE ==> '||l_tax_exp_pension_YTD_before );

Line 1759: l_Termination_date := fnd_date.canonical_to_date(lr_get_person_details.PER_INFORMATION20);

1755: END IF; -- END OF G_LOCAL_UNIT_ID NULL CHECK
1756:
1757: -- *****************************************************************************
1758: -- Pick up Termiantion date form person table
1759: l_Termination_date := fnd_date.canonical_to_date(lr_get_person_details.PER_INFORMATION20);
1760: fnd_file.put_line(fnd_file.log,'l_Termination_date ==> '||l_Termination_date );
1761: -- *****************************************************************************
1762: -- Pick up the Cause of termination
1763: -- from person record

Line 1868: ,p_action_information9 => fnd_date.date_to_canonical(l_Pension_Start_date)

1864: ,p_action_information5 => l_Employee_Pin
1865: ,p_action_information6 => l_old_pension_group_code
1866: ,p_action_information7 => l_old_Department
1867: ,p_action_information8 => l_Employee_name
1868: ,p_action_information9 => fnd_date.date_to_canonical(l_Pension_Start_date)
1869: ,p_action_information10 => FND_NUMBER.NUMBER_TO_CANONICAL(l_Sal_subject_pension_MTD)
1870: ,p_action_information11 => FND_NUMBER.NUMBER_TO_CANONICAL(l_bik_subject_pension_MTD)
1871: ,p_action_information12 => FND_NUMBER.NUMBER_TO_CANONICAL(l_tax_exp_subject_pension_MTD)
1872: ,p_action_information13 => FND_NUMBER.NUMBER_TO_CANONICAL(l_Sal_subject_pension_YTD)

Line 1875: ,p_action_information16 => fnd_date.date_to_canonical(l_Termination_date)

1871: ,p_action_information12 => FND_NUMBER.NUMBER_TO_CANONICAL(l_tax_exp_subject_pension_MTD)
1872: ,p_action_information13 => FND_NUMBER.NUMBER_TO_CANONICAL(l_Sal_subject_pension_YTD)
1873: ,p_action_information14 => FND_NUMBER.NUMBER_TO_CANONICAL(l_bik_subject_pension_YTD)
1874: ,p_action_information15 => FND_NUMBER.NUMBER_TO_CANONICAL(l_tax_exp_subject_pension_YTD)
1875: ,p_action_information16 => fnd_date.date_to_canonical(l_Termination_date)
1876: ,p_action_information17 => l_Cause_of_termination
1877: ,p_action_information18 => FND_NUMBER.NUMBER_TO_CANONICAL(l_sal_sub_pension_YTD_before)
1878: ,p_action_information19 => FND_NUMBER.NUMBER_TO_CANONICAL(l_tax_exp_pension_YTD_before)
1879: ,p_action_information20 => FND_NUMBER.NUMBER_TO_CANONICAL(l_bik_sub_pension_YTD_before)

Line 2053: ,p_action_information5 => fnd_date.date_to_canonical(l_first_start_date)

2049: ,p_action_information1 => 'PYFITELA'
2050: ,p_action_information2 => 'PER1'
2051: ,p_action_information3 => g_payroll_action_id
2052: ,p_action_information4 => l_first_category
2053: ,p_action_information5 => fnd_date.date_to_canonical(l_first_start_date)
2054: ,p_action_information6 => fnd_date.date_to_canonical(l_first_end_date)
2055: ,p_action_information7 => l_second_category
2056: ,p_action_information8 => fnd_date.date_to_canonical(l_second_start_date)
2057: ,p_action_information9 => fnd_date.date_to_canonical(l_second_end_date)

Line 2054: ,p_action_information6 => fnd_date.date_to_canonical(l_first_end_date)

2050: ,p_action_information2 => 'PER1'
2051: ,p_action_information3 => g_payroll_action_id
2052: ,p_action_information4 => l_first_category
2053: ,p_action_information5 => fnd_date.date_to_canonical(l_first_start_date)
2054: ,p_action_information6 => fnd_date.date_to_canonical(l_first_end_date)
2055: ,p_action_information7 => l_second_category
2056: ,p_action_information8 => fnd_date.date_to_canonical(l_second_start_date)
2057: ,p_action_information9 => fnd_date.date_to_canonical(l_second_end_date)
2058: ,p_action_information10 => l_third_category

Line 2056: ,p_action_information8 => fnd_date.date_to_canonical(l_second_start_date)

2052: ,p_action_information4 => l_first_category
2053: ,p_action_information5 => fnd_date.date_to_canonical(l_first_start_date)
2054: ,p_action_information6 => fnd_date.date_to_canonical(l_first_end_date)
2055: ,p_action_information7 => l_second_category
2056: ,p_action_information8 => fnd_date.date_to_canonical(l_second_start_date)
2057: ,p_action_information9 => fnd_date.date_to_canonical(l_second_end_date)
2058: ,p_action_information10 => l_third_category
2059: ,p_action_information11 => fnd_date.date_to_canonical(l_third_start_date)
2060: ,p_action_information12 => fnd_date.date_to_canonical(l_third_end_date)

Line 2057: ,p_action_information9 => fnd_date.date_to_canonical(l_second_end_date)

2053: ,p_action_information5 => fnd_date.date_to_canonical(l_first_start_date)
2054: ,p_action_information6 => fnd_date.date_to_canonical(l_first_end_date)
2055: ,p_action_information7 => l_second_category
2056: ,p_action_information8 => fnd_date.date_to_canonical(l_second_start_date)
2057: ,p_action_information9 => fnd_date.date_to_canonical(l_second_end_date)
2058: ,p_action_information10 => l_third_category
2059: ,p_action_information11 => fnd_date.date_to_canonical(l_third_start_date)
2060: ,p_action_information12 => fnd_date.date_to_canonical(l_third_end_date)
2061: ,p_action_information13 => FND_NUMBER.NUMBER_TO_CANONICAL(l_Sal_subject_pension_QTD)

Line 2059: ,p_action_information11 => fnd_date.date_to_canonical(l_third_start_date)

2055: ,p_action_information7 => l_second_category
2056: ,p_action_information8 => fnd_date.date_to_canonical(l_second_start_date)
2057: ,p_action_information9 => fnd_date.date_to_canonical(l_second_end_date)
2058: ,p_action_information10 => l_third_category
2059: ,p_action_information11 => fnd_date.date_to_canonical(l_third_start_date)
2060: ,p_action_information12 => fnd_date.date_to_canonical(l_third_end_date)
2061: ,p_action_information13 => FND_NUMBER.NUMBER_TO_CANONICAL(l_Sal_subject_pension_QTD)
2062: ,p_action_information14 => FND_NUMBER.NUMBER_TO_CANONICAL(l_bik_subject_pension_QTD)
2063: ,p_action_information15 => FND_NUMBER.NUMBER_TO_CANONICAL(l_tax_exp_subject_pension_QTD)

Line 2060: ,p_action_information12 => fnd_date.date_to_canonical(l_third_end_date)

2056: ,p_action_information8 => fnd_date.date_to_canonical(l_second_start_date)
2057: ,p_action_information9 => fnd_date.date_to_canonical(l_second_end_date)
2058: ,p_action_information10 => l_third_category
2059: ,p_action_information11 => fnd_date.date_to_canonical(l_third_start_date)
2060: ,p_action_information12 => fnd_date.date_to_canonical(l_third_end_date)
2061: ,p_action_information13 => FND_NUMBER.NUMBER_TO_CANONICAL(l_Sal_subject_pension_QTD)
2062: ,p_action_information14 => FND_NUMBER.NUMBER_TO_CANONICAL(l_bik_subject_pension_QTD)
2063: ,p_action_information15 => FND_NUMBER.NUMBER_TO_CANONICAL(l_tax_exp_subject_pension_QTD)
2064: ,p_action_information16 => null