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_FR_ARC_PKG dependencies on PAY_FR_PTO_PKG

Line 2029: -- DESCRIPTION : Calls pay_fr_pto_pkg function to load a pl/sql table

2025: --
2026: end load_balances;
2027: -------------------------------------------------------------------------------
2028: -- LOAD_HOLIDAYS
2029: -- DESCRIPTION : Calls pay_fr_pto_pkg function to load a pl/sql table
2030: -- with results for archiving,
2031: -- Then fetches from the table
2032: -------------------------------------------------------------------------------
2033: procedure load_holidays(

Line 2052: pay_fr_pto_pkg.load_fr_payslip_accrual_data

2048: hr_utility.set_location('Entering ' || l_proc, 10);
2049: --
2050: -- Get the holiday values
2051: --
2052: pay_fr_pto_pkg.load_fr_payslip_accrual_data
2053: (p_business_group_id => p_business_Group_id
2054: ,p_date_earned => p_effective_date
2055: ,p_assignment_id => p_assignment_id );
2056: --

Line 2062: FOR i in 1 .. pay_fr_pto_pkg.g_fr_payslip_info.LAST LOOP

2058: --
2059: -- Loop through each record to fetch and archive
2060: --
2061: BEGIN
2062: FOR i in 1 .. pay_fr_pto_pkg.g_fr_payslip_info.LAST LOOP
2063: hr_utility.set_location('I loop is ' || l_proc, i);
2064: pay_action_information_api.create_action_information (
2065: p_action_information_id => l_action_info_id
2066: , p_action_context_id => p_assignment_action_id

Line 2071: , p_action_information4 => to_char(pay_fr_pto_pkg.g_fr_payslip_info(i).entitlement)

2067: , p_action_context_type => l_archive_type
2068: , p_object_version_number => l_ovn
2069: , p_tax_unit_id => p_establishment_id
2070: , p_action_information_category => 'FR_SOE_EE_HOLIDAYS'
2071: , p_action_information4 => to_char(pay_fr_pto_pkg.g_fr_payslip_info(i).entitlement)
2072: , p_action_information5 => to_char(pay_fr_pto_pkg.g_fr_payslip_info(i).accrual)
2073: , p_action_information6 => to_char(pay_fr_pto_pkg.g_fr_payslip_info(i).taken)
2074: , p_action_information7 => to_char(pay_fr_pto_pkg.g_fr_payslip_info(i).balance)
2075: , p_action_information8 => pay_fr_pto_pkg.g_fr_payslip_info(i).plan_name

Line 2072: , p_action_information5 => to_char(pay_fr_pto_pkg.g_fr_payslip_info(i).accrual)

2068: , p_object_version_number => l_ovn
2069: , p_tax_unit_id => p_establishment_id
2070: , p_action_information_category => 'FR_SOE_EE_HOLIDAYS'
2071: , p_action_information4 => to_char(pay_fr_pto_pkg.g_fr_payslip_info(i).entitlement)
2072: , p_action_information5 => to_char(pay_fr_pto_pkg.g_fr_payslip_info(i).accrual)
2073: , p_action_information6 => to_char(pay_fr_pto_pkg.g_fr_payslip_info(i).taken)
2074: , p_action_information7 => to_char(pay_fr_pto_pkg.g_fr_payslip_info(i).balance)
2075: , p_action_information8 => pay_fr_pto_pkg.g_fr_payslip_info(i).plan_name
2076: );

Line 2073: , p_action_information6 => to_char(pay_fr_pto_pkg.g_fr_payslip_info(i).taken)

2069: , p_tax_unit_id => p_establishment_id
2070: , p_action_information_category => 'FR_SOE_EE_HOLIDAYS'
2071: , p_action_information4 => to_char(pay_fr_pto_pkg.g_fr_payslip_info(i).entitlement)
2072: , p_action_information5 => to_char(pay_fr_pto_pkg.g_fr_payslip_info(i).accrual)
2073: , p_action_information6 => to_char(pay_fr_pto_pkg.g_fr_payslip_info(i).taken)
2074: , p_action_information7 => to_char(pay_fr_pto_pkg.g_fr_payslip_info(i).balance)
2075: , p_action_information8 => pay_fr_pto_pkg.g_fr_payslip_info(i).plan_name
2076: );
2077: END LOOP;

Line 2074: , p_action_information7 => to_char(pay_fr_pto_pkg.g_fr_payslip_info(i).balance)

2070: , p_action_information_category => 'FR_SOE_EE_HOLIDAYS'
2071: , p_action_information4 => to_char(pay_fr_pto_pkg.g_fr_payslip_info(i).entitlement)
2072: , p_action_information5 => to_char(pay_fr_pto_pkg.g_fr_payslip_info(i).accrual)
2073: , p_action_information6 => to_char(pay_fr_pto_pkg.g_fr_payslip_info(i).taken)
2074: , p_action_information7 => to_char(pay_fr_pto_pkg.g_fr_payslip_info(i).balance)
2075: , p_action_information8 => pay_fr_pto_pkg.g_fr_payslip_info(i).plan_name
2076: );
2077: END LOOP;
2078: EXCEPTION

Line 2075: , p_action_information8 => pay_fr_pto_pkg.g_fr_payslip_info(i).plan_name

2071: , p_action_information4 => to_char(pay_fr_pto_pkg.g_fr_payslip_info(i).entitlement)
2072: , p_action_information5 => to_char(pay_fr_pto_pkg.g_fr_payslip_info(i).accrual)
2073: , p_action_information6 => to_char(pay_fr_pto_pkg.g_fr_payslip_info(i).taken)
2074: , p_action_information7 => to_char(pay_fr_pto_pkg.g_fr_payslip_info(i).balance)
2075: , p_action_information8 => pay_fr_pto_pkg.g_fr_payslip_info(i).plan_name
2076: );
2077: END LOOP;
2078: EXCEPTION
2079: when others then null;