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

Line 841: , p_action_information1 => fnd_date.date_to_canonical(ld_period_end_date) -- Payment Date

837: , p_assignment_id => p_assignment_id
838: , p_source_id => NULL
839: , p_source_text => NULL
840: , p_action_information_category => 'JP_UITE_SAL'
841: , p_action_information1 => fnd_date.date_to_canonical(ld_period_end_date) -- Payment Date
842: , p_action_information2 => fnd_date.date_to_canonical(ld_insured_start_date) -- Insured Period Start Date
843: , p_action_information3 => fnd_date.date_to_canonical(ld_insured_end_date) -- Insured Period End Date
844: , p_action_information4 => NULL -- Wage Payment Base Days
845: , p_action_information5 => fnd_date.date_to_canonical(ld_period_start_date) -- Pay Period Start Date

Line 842: , p_action_information2 => fnd_date.date_to_canonical(ld_insured_start_date) -- Insured Period Start Date

838: , p_source_id => NULL
839: , p_source_text => NULL
840: , p_action_information_category => 'JP_UITE_SAL'
841: , p_action_information1 => fnd_date.date_to_canonical(ld_period_end_date) -- Payment Date
842: , p_action_information2 => fnd_date.date_to_canonical(ld_insured_start_date) -- Insured Period Start Date
843: , p_action_information3 => fnd_date.date_to_canonical(ld_insured_end_date) -- Insured Period End Date
844: , p_action_information4 => NULL -- Wage Payment Base Days
845: , p_action_information5 => fnd_date.date_to_canonical(ld_period_start_date) -- Pay Period Start Date
846: , p_action_information6 => fnd_date.date_to_canonical(ld_period_end_date) -- Pay Period End Date

Line 843: , p_action_information3 => fnd_date.date_to_canonical(ld_insured_end_date) -- Insured Period End Date

839: , p_source_text => NULL
840: , p_action_information_category => 'JP_UITE_SAL'
841: , p_action_information1 => fnd_date.date_to_canonical(ld_period_end_date) -- Payment Date
842: , p_action_information2 => fnd_date.date_to_canonical(ld_insured_start_date) -- Insured Period Start Date
843: , p_action_information3 => fnd_date.date_to_canonical(ld_insured_end_date) -- Insured Period End Date
844: , p_action_information4 => NULL -- Wage Payment Base Days
845: , p_action_information5 => fnd_date.date_to_canonical(ld_period_start_date) -- Pay Period Start Date
846: , p_action_information6 => fnd_date.date_to_canonical(ld_period_end_date) -- Pay Period End Date
847: , p_action_information7 => NULL -- Base Days

Line 845: , p_action_information5 => fnd_date.date_to_canonical(ld_period_start_date) -- Pay Period Start Date

841: , p_action_information1 => fnd_date.date_to_canonical(ld_period_end_date) -- Payment Date
842: , p_action_information2 => fnd_date.date_to_canonical(ld_insured_start_date) -- Insured Period Start Date
843: , p_action_information3 => fnd_date.date_to_canonical(ld_insured_end_date) -- Insured Period End Date
844: , p_action_information4 => NULL -- Wage Payment Base Days
845: , p_action_information5 => fnd_date.date_to_canonical(ld_period_start_date) -- Pay Period Start Date
846: , p_action_information6 => fnd_date.date_to_canonical(ld_period_end_date) -- Pay Period End Date
847: , p_action_information7 => NULL -- Base Days
848: , p_action_information8 => NULL -- Wage Amount A
849: , p_action_information9 => NULL -- Wage Amount B

Line 846: , p_action_information6 => fnd_date.date_to_canonical(ld_period_end_date) -- Pay Period End Date

842: , p_action_information2 => fnd_date.date_to_canonical(ld_insured_start_date) -- Insured Period Start Date
843: , p_action_information3 => fnd_date.date_to_canonical(ld_insured_end_date) -- Insured Period End Date
844: , p_action_information4 => NULL -- Wage Payment Base Days
845: , p_action_information5 => fnd_date.date_to_canonical(ld_period_start_date) -- Pay Period Start Date
846: , p_action_information6 => fnd_date.date_to_canonical(ld_period_end_date) -- Pay Period End Date
847: , p_action_information7 => NULL -- Base Days
848: , p_action_information8 => NULL -- Wage Amount A
849: , p_action_information9 => NULL -- Wage Amount B
850: , p_action_information10 => NULL -- Total Amount of Salary

Line 1574: , p_action_information1 => fnd_date.date_to_canonical(lt_insert_action_info(j).payment_date) -- Payment Date

1570: , p_assignment_id => p_assignment_id
1571: , p_source_id => NULL
1572: , p_source_text => NULL
1573: , p_action_information_category => 'JP_UITE_SAL'
1574: , p_action_information1 => fnd_date.date_to_canonical(lt_insert_action_info(j).payment_date) -- Payment Date
1575: , p_action_information2 => fnd_date.date_to_canonical(lt_insert_action_info(j).insured_start_date) -- Insured Period Start Date
1576: , p_action_information3 => fnd_date.date_to_canonical(lt_insert_action_info(j).insured_end_date) -- Insured Period End Date
1577: , p_action_information4 => fnd_number.number_to_canonical(lt_insert_action_info(j).insured_days) -- Insured Period Base Days
1578: , p_action_information5 => fnd_date.date_to_canonical(lt_insert_action_info(j).period_start_date) -- Pay Period Start Date

Line 1575: , p_action_information2 => fnd_date.date_to_canonical(lt_insert_action_info(j).insured_start_date) -- Insured Period Start Date

1571: , p_source_id => NULL
1572: , p_source_text => NULL
1573: , p_action_information_category => 'JP_UITE_SAL'
1574: , p_action_information1 => fnd_date.date_to_canonical(lt_insert_action_info(j).payment_date) -- Payment Date
1575: , p_action_information2 => fnd_date.date_to_canonical(lt_insert_action_info(j).insured_start_date) -- Insured Period Start Date
1576: , p_action_information3 => fnd_date.date_to_canonical(lt_insert_action_info(j).insured_end_date) -- Insured Period End Date
1577: , p_action_information4 => fnd_number.number_to_canonical(lt_insert_action_info(j).insured_days) -- Insured Period Base Days
1578: , p_action_information5 => fnd_date.date_to_canonical(lt_insert_action_info(j).period_start_date) -- Pay Period Start Date
1579: , p_action_information6 => fnd_date.date_to_canonical(lt_insert_action_info(j).period_end_date) -- Pay Period End Date

Line 1576: , p_action_information3 => fnd_date.date_to_canonical(lt_insert_action_info(j).insured_end_date) -- Insured Period End Date

1572: , p_source_text => NULL
1573: , p_action_information_category => 'JP_UITE_SAL'
1574: , p_action_information1 => fnd_date.date_to_canonical(lt_insert_action_info(j).payment_date) -- Payment Date
1575: , p_action_information2 => fnd_date.date_to_canonical(lt_insert_action_info(j).insured_start_date) -- Insured Period Start Date
1576: , p_action_information3 => fnd_date.date_to_canonical(lt_insert_action_info(j).insured_end_date) -- Insured Period End Date
1577: , p_action_information4 => fnd_number.number_to_canonical(lt_insert_action_info(j).insured_days) -- Insured Period Base Days
1578: , p_action_information5 => fnd_date.date_to_canonical(lt_insert_action_info(j).period_start_date) -- Pay Period Start Date
1579: , p_action_information6 => fnd_date.date_to_canonical(lt_insert_action_info(j).period_end_date) -- Pay Period End Date
1580: , p_action_information7 => fnd_number.number_to_canonical(lt_insert_action_info(j).base_days) -- Pay Period Base Days

Line 1578: , p_action_information5 => fnd_date.date_to_canonical(lt_insert_action_info(j).period_start_date) -- Pay Period Start Date

1574: , p_action_information1 => fnd_date.date_to_canonical(lt_insert_action_info(j).payment_date) -- Payment Date
1575: , p_action_information2 => fnd_date.date_to_canonical(lt_insert_action_info(j).insured_start_date) -- Insured Period Start Date
1576: , p_action_information3 => fnd_date.date_to_canonical(lt_insert_action_info(j).insured_end_date) -- Insured Period End Date
1577: , p_action_information4 => fnd_number.number_to_canonical(lt_insert_action_info(j).insured_days) -- Insured Period Base Days
1578: , p_action_information5 => fnd_date.date_to_canonical(lt_insert_action_info(j).period_start_date) -- Pay Period Start Date
1579: , p_action_information6 => fnd_date.date_to_canonical(lt_insert_action_info(j).period_end_date) -- Pay Period End Date
1580: , p_action_information7 => fnd_number.number_to_canonical(lt_insert_action_info(j).base_days) -- Pay Period Base Days
1581: , p_action_information8 => fnd_number.number_to_canonical(lt_insert_action_info(j).wage_amount_a) -- Wage Amount A
1582: , p_action_information9 => fnd_number.number_to_canonical(lt_insert_action_info(j).wage_amount_b) -- Wage Amount B

Line 1579: , p_action_information6 => fnd_date.date_to_canonical(lt_insert_action_info(j).period_end_date) -- Pay Period End Date

1575: , p_action_information2 => fnd_date.date_to_canonical(lt_insert_action_info(j).insured_start_date) -- Insured Period Start Date
1576: , p_action_information3 => fnd_date.date_to_canonical(lt_insert_action_info(j).insured_end_date) -- Insured Period End Date
1577: , p_action_information4 => fnd_number.number_to_canonical(lt_insert_action_info(j).insured_days) -- Insured Period Base Days
1578: , p_action_information5 => fnd_date.date_to_canonical(lt_insert_action_info(j).period_start_date) -- Pay Period Start Date
1579: , p_action_information6 => fnd_date.date_to_canonical(lt_insert_action_info(j).period_end_date) -- Pay Period End Date
1580: , p_action_information7 => fnd_number.number_to_canonical(lt_insert_action_info(j).base_days) -- Pay Period Base Days
1581: , p_action_information8 => fnd_number.number_to_canonical(lt_insert_action_info(j).wage_amount_a) -- Wage Amount A
1582: , p_action_information9 => fnd_number.number_to_canonical(lt_insert_action_info(j).wage_amount_b) -- Wage Amount B
1583: , p_action_information10 => fnd_number.number_to_canonical(ln_total_wage) -- Wage Amount Total

Line 1695: , p_action_information1 => fnd_date.date_to_canonical(ld_period_end_date) -- Payment Date

1691: , p_assignment_id => p_assignment_id
1692: , p_source_id => NULL
1693: , p_source_text => NULL
1694: , p_action_information_category => 'JP_UITE_SAL'
1695: , p_action_information1 => fnd_date.date_to_canonical(ld_period_end_date) -- Payment Date
1696: , p_action_information2 => fnd_date.date_to_canonical(ld_insured_start_date) -- Insured Period Start Date
1697: , p_action_information3 => fnd_date.date_to_canonical(ld_insured_end_date) -- Insured Period End Date
1698: , p_action_information4 => NULL -- Wage Payment Base Days
1699: , p_action_information5 => fnd_date.date_to_canonical(ld_period_start_date) -- Pay Period Start Date

Line 1696: , p_action_information2 => fnd_date.date_to_canonical(ld_insured_start_date) -- Insured Period Start Date

1692: , p_source_id => NULL
1693: , p_source_text => NULL
1694: , p_action_information_category => 'JP_UITE_SAL'
1695: , p_action_information1 => fnd_date.date_to_canonical(ld_period_end_date) -- Payment Date
1696: , p_action_information2 => fnd_date.date_to_canonical(ld_insured_start_date) -- Insured Period Start Date
1697: , p_action_information3 => fnd_date.date_to_canonical(ld_insured_end_date) -- Insured Period End Date
1698: , p_action_information4 => NULL -- Wage Payment Base Days
1699: , p_action_information5 => fnd_date.date_to_canonical(ld_period_start_date) -- Pay Period Start Date
1700: , p_action_information6 => fnd_date.date_to_canonical(ld_period_end_date) -- Pay Period End Date

Line 1697: , p_action_information3 => fnd_date.date_to_canonical(ld_insured_end_date) -- Insured Period End Date

1693: , p_source_text => NULL
1694: , p_action_information_category => 'JP_UITE_SAL'
1695: , p_action_information1 => fnd_date.date_to_canonical(ld_period_end_date) -- Payment Date
1696: , p_action_information2 => fnd_date.date_to_canonical(ld_insured_start_date) -- Insured Period Start Date
1697: , p_action_information3 => fnd_date.date_to_canonical(ld_insured_end_date) -- Insured Period End Date
1698: , p_action_information4 => NULL -- Wage Payment Base Days
1699: , p_action_information5 => fnd_date.date_to_canonical(ld_period_start_date) -- Pay Period Start Date
1700: , p_action_information6 => fnd_date.date_to_canonical(ld_period_end_date) -- Pay Period End Date
1701: , p_action_information7 => NULL -- Base Days

Line 1699: , p_action_information5 => fnd_date.date_to_canonical(ld_period_start_date) -- Pay Period Start Date

1695: , p_action_information1 => fnd_date.date_to_canonical(ld_period_end_date) -- Payment Date
1696: , p_action_information2 => fnd_date.date_to_canonical(ld_insured_start_date) -- Insured Period Start Date
1697: , p_action_information3 => fnd_date.date_to_canonical(ld_insured_end_date) -- Insured Period End Date
1698: , p_action_information4 => NULL -- Wage Payment Base Days
1699: , p_action_information5 => fnd_date.date_to_canonical(ld_period_start_date) -- Pay Period Start Date
1700: , p_action_information6 => fnd_date.date_to_canonical(ld_period_end_date) -- Pay Period End Date
1701: , p_action_information7 => NULL -- Base Days
1702: , p_action_information8 => NULL -- Wage Amount A
1703: , p_action_information9 => NULL -- Wage Amount B

Line 1700: , p_action_information6 => fnd_date.date_to_canonical(ld_period_end_date) -- Pay Period End Date

1696: , p_action_information2 => fnd_date.date_to_canonical(ld_insured_start_date) -- Insured Period Start Date
1697: , p_action_information3 => fnd_date.date_to_canonical(ld_insured_end_date) -- Insured Period End Date
1698: , p_action_information4 => NULL -- Wage Payment Base Days
1699: , p_action_information5 => fnd_date.date_to_canonical(ld_period_start_date) -- Pay Period Start Date
1700: , p_action_information6 => fnd_date.date_to_canonical(ld_period_end_date) -- Pay Period End Date
1701: , p_action_information7 => NULL -- Base Days
1702: , p_action_information8 => NULL -- Wage Amount A
1703: , p_action_information9 => NULL -- Wage Amount B
1704: , p_action_information10 => NULL -- Total Amount of Salary

Line 1872: , p_action_information2 => fnd_date.date_to_canonical(lt_spb_assact_tbl(spb_assact_cnt).effective_date) -- Effective Date

1868: , p_source_id => NULL
1869: , p_source_text => NULL
1870: , p_action_information_category => 'JP_UITE_SPB'
1871: , p_action_information1 => fnd_number.number_to_canonical(lt_spb_assact_tbl(spb_assact_cnt).assignment_action_id) -- Assignment Action ID
1872: , p_action_information2 => fnd_date.date_to_canonical(lt_spb_assact_tbl(spb_assact_cnt).effective_date) -- Effective Date
1873: , p_action_information3 => fnd_number.number_to_canonical(ln_spb_earnings) -- Total Earnings Subject to EI
1874: );
1875: --
1876: END LOOP;

Line 2749: , p_action_information7 => fnd_date.date_to_canonical(lr_employee_details.TERMINATION_DATE)

2745: , p_action_information3 => lr_employee_details.LAST_NAME_KANA
2746: , p_action_information4 => lr_employee_details.FIRST_NAME_KANA
2747: , p_action_information5 => lr_employee_details.LAST_NAME
2748: , p_action_information6 => lr_employee_details.FIRST_NAME
2749: , p_action_information7 => fnd_date.date_to_canonical(lr_employee_details.TERMINATION_DATE)
2750: , p_action_information8 => lr_employee_details.EMP_ZIP_CODE
2751: , p_action_information9 => lr_employee_details.ADDRESS_LINE1
2752: , p_action_information10 => lr_employee_details.ADDRESS_LINE2
2753: , p_action_information11 => lr_employee_details.ADDRESS_LINE3