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.HR_ACCRUAL_PLAN_API dependencies on HR_API

Line 572: AND NVL(pbd.legislation_code, NVL(l_legislation_code, hr_api.g_varchar2))

568: SELECT NULL
569: FROM pay_balance_dimensions pbd
570: WHERE pbd.balance_dimension_id = p_balance_dimension_id
571: AND NVL(pbd.business_group_id, p_business_group_id) = p_business_group_id
572: AND NVL(pbd.legislation_code, NVL(l_legislation_code, hr_api.g_varchar2))
573: = NVL(l_legislation_code, hr_api.g_varchar2)
574: AND EXISTS (SELECT NULL
575: FROM ff_routes fr
576: ,ff_contexts fc

Line 573: = NVL(l_legislation_code, hr_api.g_varchar2)

569: FROM pay_balance_dimensions pbd
570: WHERE pbd.balance_dimension_id = p_balance_dimension_id
571: AND NVL(pbd.business_group_id, p_business_group_id) = p_business_group_id
572: AND NVL(pbd.legislation_code, NVL(l_legislation_code, hr_api.g_varchar2))
573: = NVL(l_legislation_code, hr_api.g_varchar2)
574: AND EXISTS (SELECT NULL
575: FROM ff_routes fr
576: ,ff_contexts fc
577: ,ff_route_context_usages frcu

Line 599: AND NVL(pbd.legislation_code, NVL(l_legislation_code, hr_api.g_varchar2))

595: SELECT NULL
596: FROM pay_balance_dimensions pbd
597: WHERE pbd.balance_dimension_id = p_balance_dimension_id
598: AND NVL(pbd.business_group_id, p_business_group_id) = p_business_group_id
599: AND NVL(pbd.legislation_code, NVL(l_legislation_code, hr_api.g_varchar2))
600: = NVL(l_legislation_code, hr_api.g_varchar2)
601: AND EXISTS (SELECT NULL
602: FROM ff_routes fr
603: ,ff_contexts fc

Line 600: = NVL(l_legislation_code, hr_api.g_varchar2)

596: FROM pay_balance_dimensions pbd
597: WHERE pbd.balance_dimension_id = p_balance_dimension_id
598: AND NVL(pbd.business_group_id, p_business_group_id) = p_business_group_id
599: AND NVL(pbd.legislation_code, NVL(l_legislation_code, hr_api.g_varchar2))
600: = NVL(l_legislation_code, hr_api.g_varchar2)
601: AND EXISTS (SELECT NULL
602: FROM ff_routes fr
603: ,ff_contexts fc
604: ,ff_route_context_usages frcu

Line 962: when hr_api.cannot_find_prog_unit then

958: ,p_information30 => p_information30
959:
960: );
961: exception
962: when hr_api.cannot_find_prog_unit then
963: hr_api.cannot_find_prog_unit_error
964: (p_module_name => 'create_accrual_plan'
965: ,p_hook_type => 'BP'
966: );

Line 963: hr_api.cannot_find_prog_unit_error

959:
960: );
961: exception
962: when hr_api.cannot_find_prog_unit then
963: hr_api.cannot_find_prog_unit_error
964: (p_module_name => 'create_accrual_plan'
965: ,p_hook_type => 'BP'
966: );
967: end;

Line 1924: when hr_api.cannot_find_prog_unit then

1920: ,p_information29 => p_information29
1921: ,p_information30 => p_information30
1922: );
1923: exception
1924: when hr_api.cannot_find_prog_unit then
1925: hr_api.cannot_find_prog_unit_error
1926: (p_module_name => 'create_accrual_plan'
1927: ,p_hook_type => 'AP'
1928: );

Line 1925: hr_api.cannot_find_prog_unit_error

1921: ,p_information30 => p_information30
1922: );
1923: exception
1924: when hr_api.cannot_find_prog_unit then
1925: hr_api.cannot_find_prog_unit_error
1926: (p_module_name => 'create_accrual_plan'
1927: ,p_hook_type => 'AP'
1928: );
1929: end;

Line 1937: raise hr_api.validate_enabled;

1933: --
1934: -- When in validation only mode raise the Validate_Enabled exception
1935: --
1936: if p_validate then
1937: raise hr_api.validate_enabled;
1938: end if;
1939: --
1940: -- Set all output arguments
1941: --

Line 2018: WHEN hr_api.validate_enabled THEN

2014: hr_utility.set_location(' Leaving:'||l_proc, 70);
2015:
2016: EXCEPTION
2017:
2018: WHEN hr_api.validate_enabled THEN
2019: --
2020: -- As the Validate_Enabled exception has been raised
2021: -- we must rollback to the savepoint
2022: --

Line 2082: ,p_pto_input_value_id in number default hr_api.g_number

2078: PROCEDURE update_accrual_plan
2079: (p_validate in boolean default false
2080: ,p_effective_date in date
2081: ,p_accrual_plan_id in number
2082: ,p_pto_input_value_id in number default hr_api.g_number
2083: ,p_accrual_category in varchar2 default hr_api.g_varchar2
2084: ,p_accrual_start in varchar2 default hr_api.g_varchar2
2085: ,p_ineligible_period_length in number default hr_api.g_number
2086: ,p_ineligible_period_type in varchar2 default hr_api.g_varchar2

Line 2083: ,p_accrual_category in varchar2 default hr_api.g_varchar2

2079: (p_validate in boolean default false
2080: ,p_effective_date in date
2081: ,p_accrual_plan_id in number
2082: ,p_pto_input_value_id in number default hr_api.g_number
2083: ,p_accrual_category in varchar2 default hr_api.g_varchar2
2084: ,p_accrual_start in varchar2 default hr_api.g_varchar2
2085: ,p_ineligible_period_length in number default hr_api.g_number
2086: ,p_ineligible_period_type in varchar2 default hr_api.g_varchar2
2087: ,p_accrual_formula_id in number default hr_api.g_number

Line 2084: ,p_accrual_start in varchar2 default hr_api.g_varchar2

2080: ,p_effective_date in date
2081: ,p_accrual_plan_id in number
2082: ,p_pto_input_value_id in number default hr_api.g_number
2083: ,p_accrual_category in varchar2 default hr_api.g_varchar2
2084: ,p_accrual_start in varchar2 default hr_api.g_varchar2
2085: ,p_ineligible_period_length in number default hr_api.g_number
2086: ,p_ineligible_period_type in varchar2 default hr_api.g_varchar2
2087: ,p_accrual_formula_id in number default hr_api.g_number
2088: ,p_co_formula_id in number default hr_api.g_number

Line 2085: ,p_ineligible_period_length in number default hr_api.g_number

2081: ,p_accrual_plan_id in number
2082: ,p_pto_input_value_id in number default hr_api.g_number
2083: ,p_accrual_category in varchar2 default hr_api.g_varchar2
2084: ,p_accrual_start in varchar2 default hr_api.g_varchar2
2085: ,p_ineligible_period_length in number default hr_api.g_number
2086: ,p_ineligible_period_type in varchar2 default hr_api.g_varchar2
2087: ,p_accrual_formula_id in number default hr_api.g_number
2088: ,p_co_formula_id in number default hr_api.g_number
2089: ,p_description in varchar2 default hr_api.g_varchar2

Line 2086: ,p_ineligible_period_type in varchar2 default hr_api.g_varchar2

2082: ,p_pto_input_value_id in number default hr_api.g_number
2083: ,p_accrual_category in varchar2 default hr_api.g_varchar2
2084: ,p_accrual_start in varchar2 default hr_api.g_varchar2
2085: ,p_ineligible_period_length in number default hr_api.g_number
2086: ,p_ineligible_period_type in varchar2 default hr_api.g_varchar2
2087: ,p_accrual_formula_id in number default hr_api.g_number
2088: ,p_co_formula_id in number default hr_api.g_number
2089: ,p_description in varchar2 default hr_api.g_varchar2
2090: ,p_ineligibility_formula_id in number default hr_api.g_number

Line 2087: ,p_accrual_formula_id in number default hr_api.g_number

2083: ,p_accrual_category in varchar2 default hr_api.g_varchar2
2084: ,p_accrual_start in varchar2 default hr_api.g_varchar2
2085: ,p_ineligible_period_length in number default hr_api.g_number
2086: ,p_ineligible_period_type in varchar2 default hr_api.g_varchar2
2087: ,p_accrual_formula_id in number default hr_api.g_number
2088: ,p_co_formula_id in number default hr_api.g_number
2089: ,p_description in varchar2 default hr_api.g_varchar2
2090: ,p_ineligibility_formula_id in number default hr_api.g_number
2091: ,p_balance_dimension_id in number default hr_api.g_number

Line 2088: ,p_co_formula_id in number default hr_api.g_number

2084: ,p_accrual_start in varchar2 default hr_api.g_varchar2
2085: ,p_ineligible_period_length in number default hr_api.g_number
2086: ,p_ineligible_period_type in varchar2 default hr_api.g_varchar2
2087: ,p_accrual_formula_id in number default hr_api.g_number
2088: ,p_co_formula_id in number default hr_api.g_number
2089: ,p_description in varchar2 default hr_api.g_varchar2
2090: ,p_ineligibility_formula_id in number default hr_api.g_number
2091: ,p_balance_dimension_id in number default hr_api.g_number
2092: ,p_information_category in varchar2 default hr_api.g_varchar2

Line 2089: ,p_description in varchar2 default hr_api.g_varchar2

2085: ,p_ineligible_period_length in number default hr_api.g_number
2086: ,p_ineligible_period_type in varchar2 default hr_api.g_varchar2
2087: ,p_accrual_formula_id in number default hr_api.g_number
2088: ,p_co_formula_id in number default hr_api.g_number
2089: ,p_description in varchar2 default hr_api.g_varchar2
2090: ,p_ineligibility_formula_id in number default hr_api.g_number
2091: ,p_balance_dimension_id in number default hr_api.g_number
2092: ,p_information_category in varchar2 default hr_api.g_varchar2
2093: ,p_information1 in varchar2 default hr_api.g_varchar2

Line 2090: ,p_ineligibility_formula_id in number default hr_api.g_number

2086: ,p_ineligible_period_type in varchar2 default hr_api.g_varchar2
2087: ,p_accrual_formula_id in number default hr_api.g_number
2088: ,p_co_formula_id in number default hr_api.g_number
2089: ,p_description in varchar2 default hr_api.g_varchar2
2090: ,p_ineligibility_formula_id in number default hr_api.g_number
2091: ,p_balance_dimension_id in number default hr_api.g_number
2092: ,p_information_category in varchar2 default hr_api.g_varchar2
2093: ,p_information1 in varchar2 default hr_api.g_varchar2
2094: ,p_information2 in varchar2 default hr_api.g_varchar2

Line 2091: ,p_balance_dimension_id in number default hr_api.g_number

2087: ,p_accrual_formula_id in number default hr_api.g_number
2088: ,p_co_formula_id in number default hr_api.g_number
2089: ,p_description in varchar2 default hr_api.g_varchar2
2090: ,p_ineligibility_formula_id in number default hr_api.g_number
2091: ,p_balance_dimension_id in number default hr_api.g_number
2092: ,p_information_category in varchar2 default hr_api.g_varchar2
2093: ,p_information1 in varchar2 default hr_api.g_varchar2
2094: ,p_information2 in varchar2 default hr_api.g_varchar2
2095: ,p_information3 in varchar2 default hr_api.g_varchar2

Line 2092: ,p_information_category in varchar2 default hr_api.g_varchar2

2088: ,p_co_formula_id in number default hr_api.g_number
2089: ,p_description in varchar2 default hr_api.g_varchar2
2090: ,p_ineligibility_formula_id in number default hr_api.g_number
2091: ,p_balance_dimension_id in number default hr_api.g_number
2092: ,p_information_category in varchar2 default hr_api.g_varchar2
2093: ,p_information1 in varchar2 default hr_api.g_varchar2
2094: ,p_information2 in varchar2 default hr_api.g_varchar2
2095: ,p_information3 in varchar2 default hr_api.g_varchar2
2096: ,p_information4 in varchar2 default hr_api.g_varchar2

Line 2093: ,p_information1 in varchar2 default hr_api.g_varchar2

2089: ,p_description in varchar2 default hr_api.g_varchar2
2090: ,p_ineligibility_formula_id in number default hr_api.g_number
2091: ,p_balance_dimension_id in number default hr_api.g_number
2092: ,p_information_category in varchar2 default hr_api.g_varchar2
2093: ,p_information1 in varchar2 default hr_api.g_varchar2
2094: ,p_information2 in varchar2 default hr_api.g_varchar2
2095: ,p_information3 in varchar2 default hr_api.g_varchar2
2096: ,p_information4 in varchar2 default hr_api.g_varchar2
2097: ,p_information5 in varchar2 default hr_api.g_varchar2

Line 2094: ,p_information2 in varchar2 default hr_api.g_varchar2

2090: ,p_ineligibility_formula_id in number default hr_api.g_number
2091: ,p_balance_dimension_id in number default hr_api.g_number
2092: ,p_information_category in varchar2 default hr_api.g_varchar2
2093: ,p_information1 in varchar2 default hr_api.g_varchar2
2094: ,p_information2 in varchar2 default hr_api.g_varchar2
2095: ,p_information3 in varchar2 default hr_api.g_varchar2
2096: ,p_information4 in varchar2 default hr_api.g_varchar2
2097: ,p_information5 in varchar2 default hr_api.g_varchar2
2098: ,p_information6 in varchar2 default hr_api.g_varchar2

Line 2095: ,p_information3 in varchar2 default hr_api.g_varchar2

2091: ,p_balance_dimension_id in number default hr_api.g_number
2092: ,p_information_category in varchar2 default hr_api.g_varchar2
2093: ,p_information1 in varchar2 default hr_api.g_varchar2
2094: ,p_information2 in varchar2 default hr_api.g_varchar2
2095: ,p_information3 in varchar2 default hr_api.g_varchar2
2096: ,p_information4 in varchar2 default hr_api.g_varchar2
2097: ,p_information5 in varchar2 default hr_api.g_varchar2
2098: ,p_information6 in varchar2 default hr_api.g_varchar2
2099: ,p_information7 in varchar2 default hr_api.g_varchar2

Line 2096: ,p_information4 in varchar2 default hr_api.g_varchar2

2092: ,p_information_category in varchar2 default hr_api.g_varchar2
2093: ,p_information1 in varchar2 default hr_api.g_varchar2
2094: ,p_information2 in varchar2 default hr_api.g_varchar2
2095: ,p_information3 in varchar2 default hr_api.g_varchar2
2096: ,p_information4 in varchar2 default hr_api.g_varchar2
2097: ,p_information5 in varchar2 default hr_api.g_varchar2
2098: ,p_information6 in varchar2 default hr_api.g_varchar2
2099: ,p_information7 in varchar2 default hr_api.g_varchar2
2100: ,p_information8 in varchar2 default hr_api.g_varchar2

Line 2097: ,p_information5 in varchar2 default hr_api.g_varchar2

2093: ,p_information1 in varchar2 default hr_api.g_varchar2
2094: ,p_information2 in varchar2 default hr_api.g_varchar2
2095: ,p_information3 in varchar2 default hr_api.g_varchar2
2096: ,p_information4 in varchar2 default hr_api.g_varchar2
2097: ,p_information5 in varchar2 default hr_api.g_varchar2
2098: ,p_information6 in varchar2 default hr_api.g_varchar2
2099: ,p_information7 in varchar2 default hr_api.g_varchar2
2100: ,p_information8 in varchar2 default hr_api.g_varchar2
2101: ,p_information9 in varchar2 default hr_api.g_varchar2

Line 2098: ,p_information6 in varchar2 default hr_api.g_varchar2

2094: ,p_information2 in varchar2 default hr_api.g_varchar2
2095: ,p_information3 in varchar2 default hr_api.g_varchar2
2096: ,p_information4 in varchar2 default hr_api.g_varchar2
2097: ,p_information5 in varchar2 default hr_api.g_varchar2
2098: ,p_information6 in varchar2 default hr_api.g_varchar2
2099: ,p_information7 in varchar2 default hr_api.g_varchar2
2100: ,p_information8 in varchar2 default hr_api.g_varchar2
2101: ,p_information9 in varchar2 default hr_api.g_varchar2
2102: ,p_information10 in varchar2 default hr_api.g_varchar2

Line 2099: ,p_information7 in varchar2 default hr_api.g_varchar2

2095: ,p_information3 in varchar2 default hr_api.g_varchar2
2096: ,p_information4 in varchar2 default hr_api.g_varchar2
2097: ,p_information5 in varchar2 default hr_api.g_varchar2
2098: ,p_information6 in varchar2 default hr_api.g_varchar2
2099: ,p_information7 in varchar2 default hr_api.g_varchar2
2100: ,p_information8 in varchar2 default hr_api.g_varchar2
2101: ,p_information9 in varchar2 default hr_api.g_varchar2
2102: ,p_information10 in varchar2 default hr_api.g_varchar2
2103: ,p_information11 in varchar2 default hr_api.g_varchar2

Line 2100: ,p_information8 in varchar2 default hr_api.g_varchar2

2096: ,p_information4 in varchar2 default hr_api.g_varchar2
2097: ,p_information5 in varchar2 default hr_api.g_varchar2
2098: ,p_information6 in varchar2 default hr_api.g_varchar2
2099: ,p_information7 in varchar2 default hr_api.g_varchar2
2100: ,p_information8 in varchar2 default hr_api.g_varchar2
2101: ,p_information9 in varchar2 default hr_api.g_varchar2
2102: ,p_information10 in varchar2 default hr_api.g_varchar2
2103: ,p_information11 in varchar2 default hr_api.g_varchar2
2104: ,p_information12 in varchar2 default hr_api.g_varchar2

Line 2101: ,p_information9 in varchar2 default hr_api.g_varchar2

2097: ,p_information5 in varchar2 default hr_api.g_varchar2
2098: ,p_information6 in varchar2 default hr_api.g_varchar2
2099: ,p_information7 in varchar2 default hr_api.g_varchar2
2100: ,p_information8 in varchar2 default hr_api.g_varchar2
2101: ,p_information9 in varchar2 default hr_api.g_varchar2
2102: ,p_information10 in varchar2 default hr_api.g_varchar2
2103: ,p_information11 in varchar2 default hr_api.g_varchar2
2104: ,p_information12 in varchar2 default hr_api.g_varchar2
2105: ,p_information13 in varchar2 default hr_api.g_varchar2

Line 2102: ,p_information10 in varchar2 default hr_api.g_varchar2

2098: ,p_information6 in varchar2 default hr_api.g_varchar2
2099: ,p_information7 in varchar2 default hr_api.g_varchar2
2100: ,p_information8 in varchar2 default hr_api.g_varchar2
2101: ,p_information9 in varchar2 default hr_api.g_varchar2
2102: ,p_information10 in varchar2 default hr_api.g_varchar2
2103: ,p_information11 in varchar2 default hr_api.g_varchar2
2104: ,p_information12 in varchar2 default hr_api.g_varchar2
2105: ,p_information13 in varchar2 default hr_api.g_varchar2
2106: ,p_information14 in varchar2 default hr_api.g_varchar2

Line 2103: ,p_information11 in varchar2 default hr_api.g_varchar2

2099: ,p_information7 in varchar2 default hr_api.g_varchar2
2100: ,p_information8 in varchar2 default hr_api.g_varchar2
2101: ,p_information9 in varchar2 default hr_api.g_varchar2
2102: ,p_information10 in varchar2 default hr_api.g_varchar2
2103: ,p_information11 in varchar2 default hr_api.g_varchar2
2104: ,p_information12 in varchar2 default hr_api.g_varchar2
2105: ,p_information13 in varchar2 default hr_api.g_varchar2
2106: ,p_information14 in varchar2 default hr_api.g_varchar2
2107: ,p_information15 in varchar2 default hr_api.g_varchar2

Line 2104: ,p_information12 in varchar2 default hr_api.g_varchar2

2100: ,p_information8 in varchar2 default hr_api.g_varchar2
2101: ,p_information9 in varchar2 default hr_api.g_varchar2
2102: ,p_information10 in varchar2 default hr_api.g_varchar2
2103: ,p_information11 in varchar2 default hr_api.g_varchar2
2104: ,p_information12 in varchar2 default hr_api.g_varchar2
2105: ,p_information13 in varchar2 default hr_api.g_varchar2
2106: ,p_information14 in varchar2 default hr_api.g_varchar2
2107: ,p_information15 in varchar2 default hr_api.g_varchar2
2108: ,p_information16 in varchar2 default hr_api.g_varchar2

Line 2105: ,p_information13 in varchar2 default hr_api.g_varchar2

2101: ,p_information9 in varchar2 default hr_api.g_varchar2
2102: ,p_information10 in varchar2 default hr_api.g_varchar2
2103: ,p_information11 in varchar2 default hr_api.g_varchar2
2104: ,p_information12 in varchar2 default hr_api.g_varchar2
2105: ,p_information13 in varchar2 default hr_api.g_varchar2
2106: ,p_information14 in varchar2 default hr_api.g_varchar2
2107: ,p_information15 in varchar2 default hr_api.g_varchar2
2108: ,p_information16 in varchar2 default hr_api.g_varchar2
2109: ,p_information17 in varchar2 default hr_api.g_varchar2

Line 2106: ,p_information14 in varchar2 default hr_api.g_varchar2

2102: ,p_information10 in varchar2 default hr_api.g_varchar2
2103: ,p_information11 in varchar2 default hr_api.g_varchar2
2104: ,p_information12 in varchar2 default hr_api.g_varchar2
2105: ,p_information13 in varchar2 default hr_api.g_varchar2
2106: ,p_information14 in varchar2 default hr_api.g_varchar2
2107: ,p_information15 in varchar2 default hr_api.g_varchar2
2108: ,p_information16 in varchar2 default hr_api.g_varchar2
2109: ,p_information17 in varchar2 default hr_api.g_varchar2
2110: ,p_information18 in varchar2 default hr_api.g_varchar2

Line 2107: ,p_information15 in varchar2 default hr_api.g_varchar2

2103: ,p_information11 in varchar2 default hr_api.g_varchar2
2104: ,p_information12 in varchar2 default hr_api.g_varchar2
2105: ,p_information13 in varchar2 default hr_api.g_varchar2
2106: ,p_information14 in varchar2 default hr_api.g_varchar2
2107: ,p_information15 in varchar2 default hr_api.g_varchar2
2108: ,p_information16 in varchar2 default hr_api.g_varchar2
2109: ,p_information17 in varchar2 default hr_api.g_varchar2
2110: ,p_information18 in varchar2 default hr_api.g_varchar2
2111: ,p_information19 in varchar2 default hr_api.g_varchar2

Line 2108: ,p_information16 in varchar2 default hr_api.g_varchar2

2104: ,p_information12 in varchar2 default hr_api.g_varchar2
2105: ,p_information13 in varchar2 default hr_api.g_varchar2
2106: ,p_information14 in varchar2 default hr_api.g_varchar2
2107: ,p_information15 in varchar2 default hr_api.g_varchar2
2108: ,p_information16 in varchar2 default hr_api.g_varchar2
2109: ,p_information17 in varchar2 default hr_api.g_varchar2
2110: ,p_information18 in varchar2 default hr_api.g_varchar2
2111: ,p_information19 in varchar2 default hr_api.g_varchar2
2112: ,p_information20 in varchar2 default hr_api.g_varchar2

Line 2109: ,p_information17 in varchar2 default hr_api.g_varchar2

2105: ,p_information13 in varchar2 default hr_api.g_varchar2
2106: ,p_information14 in varchar2 default hr_api.g_varchar2
2107: ,p_information15 in varchar2 default hr_api.g_varchar2
2108: ,p_information16 in varchar2 default hr_api.g_varchar2
2109: ,p_information17 in varchar2 default hr_api.g_varchar2
2110: ,p_information18 in varchar2 default hr_api.g_varchar2
2111: ,p_information19 in varchar2 default hr_api.g_varchar2
2112: ,p_information20 in varchar2 default hr_api.g_varchar2
2113: ,p_information21 in varchar2 default hr_api.g_varchar2

Line 2110: ,p_information18 in varchar2 default hr_api.g_varchar2

2106: ,p_information14 in varchar2 default hr_api.g_varchar2
2107: ,p_information15 in varchar2 default hr_api.g_varchar2
2108: ,p_information16 in varchar2 default hr_api.g_varchar2
2109: ,p_information17 in varchar2 default hr_api.g_varchar2
2110: ,p_information18 in varchar2 default hr_api.g_varchar2
2111: ,p_information19 in varchar2 default hr_api.g_varchar2
2112: ,p_information20 in varchar2 default hr_api.g_varchar2
2113: ,p_information21 in varchar2 default hr_api.g_varchar2
2114: ,p_information22 in varchar2 default hr_api.g_varchar2

Line 2111: ,p_information19 in varchar2 default hr_api.g_varchar2

2107: ,p_information15 in varchar2 default hr_api.g_varchar2
2108: ,p_information16 in varchar2 default hr_api.g_varchar2
2109: ,p_information17 in varchar2 default hr_api.g_varchar2
2110: ,p_information18 in varchar2 default hr_api.g_varchar2
2111: ,p_information19 in varchar2 default hr_api.g_varchar2
2112: ,p_information20 in varchar2 default hr_api.g_varchar2
2113: ,p_information21 in varchar2 default hr_api.g_varchar2
2114: ,p_information22 in varchar2 default hr_api.g_varchar2
2115: ,p_information23 in varchar2 default hr_api.g_varchar2

Line 2112: ,p_information20 in varchar2 default hr_api.g_varchar2

2108: ,p_information16 in varchar2 default hr_api.g_varchar2
2109: ,p_information17 in varchar2 default hr_api.g_varchar2
2110: ,p_information18 in varchar2 default hr_api.g_varchar2
2111: ,p_information19 in varchar2 default hr_api.g_varchar2
2112: ,p_information20 in varchar2 default hr_api.g_varchar2
2113: ,p_information21 in varchar2 default hr_api.g_varchar2
2114: ,p_information22 in varchar2 default hr_api.g_varchar2
2115: ,p_information23 in varchar2 default hr_api.g_varchar2
2116: ,p_information24 in varchar2 default hr_api.g_varchar2

Line 2113: ,p_information21 in varchar2 default hr_api.g_varchar2

2109: ,p_information17 in varchar2 default hr_api.g_varchar2
2110: ,p_information18 in varchar2 default hr_api.g_varchar2
2111: ,p_information19 in varchar2 default hr_api.g_varchar2
2112: ,p_information20 in varchar2 default hr_api.g_varchar2
2113: ,p_information21 in varchar2 default hr_api.g_varchar2
2114: ,p_information22 in varchar2 default hr_api.g_varchar2
2115: ,p_information23 in varchar2 default hr_api.g_varchar2
2116: ,p_information24 in varchar2 default hr_api.g_varchar2
2117: ,p_information25 in varchar2 default hr_api.g_varchar2

Line 2114: ,p_information22 in varchar2 default hr_api.g_varchar2

2110: ,p_information18 in varchar2 default hr_api.g_varchar2
2111: ,p_information19 in varchar2 default hr_api.g_varchar2
2112: ,p_information20 in varchar2 default hr_api.g_varchar2
2113: ,p_information21 in varchar2 default hr_api.g_varchar2
2114: ,p_information22 in varchar2 default hr_api.g_varchar2
2115: ,p_information23 in varchar2 default hr_api.g_varchar2
2116: ,p_information24 in varchar2 default hr_api.g_varchar2
2117: ,p_information25 in varchar2 default hr_api.g_varchar2
2118: ,p_information26 in varchar2 default hr_api.g_varchar2

Line 2115: ,p_information23 in varchar2 default hr_api.g_varchar2

2111: ,p_information19 in varchar2 default hr_api.g_varchar2
2112: ,p_information20 in varchar2 default hr_api.g_varchar2
2113: ,p_information21 in varchar2 default hr_api.g_varchar2
2114: ,p_information22 in varchar2 default hr_api.g_varchar2
2115: ,p_information23 in varchar2 default hr_api.g_varchar2
2116: ,p_information24 in varchar2 default hr_api.g_varchar2
2117: ,p_information25 in varchar2 default hr_api.g_varchar2
2118: ,p_information26 in varchar2 default hr_api.g_varchar2
2119: ,p_information27 in varchar2 default hr_api.g_varchar2

Line 2116: ,p_information24 in varchar2 default hr_api.g_varchar2

2112: ,p_information20 in varchar2 default hr_api.g_varchar2
2113: ,p_information21 in varchar2 default hr_api.g_varchar2
2114: ,p_information22 in varchar2 default hr_api.g_varchar2
2115: ,p_information23 in varchar2 default hr_api.g_varchar2
2116: ,p_information24 in varchar2 default hr_api.g_varchar2
2117: ,p_information25 in varchar2 default hr_api.g_varchar2
2118: ,p_information26 in varchar2 default hr_api.g_varchar2
2119: ,p_information27 in varchar2 default hr_api.g_varchar2
2120: ,p_information28 in varchar2 default hr_api.g_varchar2

Line 2117: ,p_information25 in varchar2 default hr_api.g_varchar2

2113: ,p_information21 in varchar2 default hr_api.g_varchar2
2114: ,p_information22 in varchar2 default hr_api.g_varchar2
2115: ,p_information23 in varchar2 default hr_api.g_varchar2
2116: ,p_information24 in varchar2 default hr_api.g_varchar2
2117: ,p_information25 in varchar2 default hr_api.g_varchar2
2118: ,p_information26 in varchar2 default hr_api.g_varchar2
2119: ,p_information27 in varchar2 default hr_api.g_varchar2
2120: ,p_information28 in varchar2 default hr_api.g_varchar2
2121: ,p_information29 in varchar2 default hr_api.g_varchar2

Line 2118: ,p_information26 in varchar2 default hr_api.g_varchar2

2114: ,p_information22 in varchar2 default hr_api.g_varchar2
2115: ,p_information23 in varchar2 default hr_api.g_varchar2
2116: ,p_information24 in varchar2 default hr_api.g_varchar2
2117: ,p_information25 in varchar2 default hr_api.g_varchar2
2118: ,p_information26 in varchar2 default hr_api.g_varchar2
2119: ,p_information27 in varchar2 default hr_api.g_varchar2
2120: ,p_information28 in varchar2 default hr_api.g_varchar2
2121: ,p_information29 in varchar2 default hr_api.g_varchar2
2122: ,p_information30 in varchar2 default hr_api.g_varchar2

Line 2119: ,p_information27 in varchar2 default hr_api.g_varchar2

2115: ,p_information23 in varchar2 default hr_api.g_varchar2
2116: ,p_information24 in varchar2 default hr_api.g_varchar2
2117: ,p_information25 in varchar2 default hr_api.g_varchar2
2118: ,p_information26 in varchar2 default hr_api.g_varchar2
2119: ,p_information27 in varchar2 default hr_api.g_varchar2
2120: ,p_information28 in varchar2 default hr_api.g_varchar2
2121: ,p_information29 in varchar2 default hr_api.g_varchar2
2122: ,p_information30 in varchar2 default hr_api.g_varchar2
2123: ,p_object_version_number in out nocopy number

Line 2120: ,p_information28 in varchar2 default hr_api.g_varchar2

2116: ,p_information24 in varchar2 default hr_api.g_varchar2
2117: ,p_information25 in varchar2 default hr_api.g_varchar2
2118: ,p_information26 in varchar2 default hr_api.g_varchar2
2119: ,p_information27 in varchar2 default hr_api.g_varchar2
2120: ,p_information28 in varchar2 default hr_api.g_varchar2
2121: ,p_information29 in varchar2 default hr_api.g_varchar2
2122: ,p_information30 in varchar2 default hr_api.g_varchar2
2123: ,p_object_version_number in out nocopy number
2124: ,p_payroll_formula_id out nocopy number

Line 2121: ,p_information29 in varchar2 default hr_api.g_varchar2

2117: ,p_information25 in varchar2 default hr_api.g_varchar2
2118: ,p_information26 in varchar2 default hr_api.g_varchar2
2119: ,p_information27 in varchar2 default hr_api.g_varchar2
2120: ,p_information28 in varchar2 default hr_api.g_varchar2
2121: ,p_information29 in varchar2 default hr_api.g_varchar2
2122: ,p_information30 in varchar2 default hr_api.g_varchar2
2123: ,p_object_version_number in out nocopy number
2124: ,p_payroll_formula_id out nocopy number
2125: ,p_defined_balance_id out nocopy number

Line 2122: ,p_information30 in varchar2 default hr_api.g_varchar2

2118: ,p_information26 in varchar2 default hr_api.g_varchar2
2119: ,p_information27 in varchar2 default hr_api.g_varchar2
2120: ,p_information28 in varchar2 default hr_api.g_varchar2
2121: ,p_information29 in varchar2 default hr_api.g_varchar2
2122: ,p_information30 in varchar2 default hr_api.g_varchar2
2123: ,p_object_version_number in out nocopy number
2124: ,p_payroll_formula_id out nocopy number
2125: ,p_defined_balance_id out nocopy number
2126: ,p_balance_element_type_id out nocopy number

Line 2339: when hr_api.cannot_find_prog_unit then

2335: ,p_information30 => p_information30
2336:
2337: );
2338: exception
2339: when hr_api.cannot_find_prog_unit then
2340: hr_api.cannot_find_prog_unit_error
2341: (p_module_name => 'update_accrual_plan'
2342: ,p_hook_type => 'BP'
2343: );

Line 2340: hr_api.cannot_find_prog_unit_error

2336:
2337: );
2338: exception
2339: when hr_api.cannot_find_prog_unit then
2340: hr_api.cannot_find_prog_unit_error
2341: (p_module_name => 'update_accrual_plan'
2342: ,p_hook_type => 'BP'
2343: );
2344: end;

Line 2373: p_balance_dimension_id <> hr_api.g_number THEN

2369: hr_utility.set_location(l_proc, 40);
2370:
2371: IF l_plan_rec.defined_balance_id IS NULL AND
2372: p_balance_dimension_id IS NOT NULL AND
2373: p_balance_dimension_id <> hr_api.g_number THEN
2374:
2375: --
2376: -- Setup the accrual plan for payroll balances.
2377: --

Line 2897: if p_pto_input_value_id <> hr_api.g_number

2893: -- MLS changes
2894: hr_utility.set_location(l_proc, 185);
2895: --
2896:
2897: if p_pto_input_value_id <> hr_api.g_number
2898: and p_pto_input_value_id <> pay_pap_shd.g_old_rec.pto_input_value_id then
2899: --
2900: for l_ncr_rec in c_get_ncr(pay_pap_shd.g_old_rec.pto_input_value_id) loop
2901: --

Line 2995: when hr_api.cannot_find_prog_unit then

2991: ,p_information29 => p_information29
2992: ,p_information30 => p_information30
2993: );
2994: exception
2995: when hr_api.cannot_find_prog_unit then
2996: hr_api.cannot_find_prog_unit_error
2997: (p_module_name => 'update_accrual_plan'
2998: ,p_hook_type => 'AP'
2999: );

Line 2996: hr_api.cannot_find_prog_unit_error

2992: ,p_information30 => p_information30
2993: );
2994: exception
2995: when hr_api.cannot_find_prog_unit then
2996: hr_api.cannot_find_prog_unit_error
2997: (p_module_name => 'update_accrual_plan'
2998: ,p_hook_type => 'AP'
2999: );
3000: end;

Line 3008: raise hr_api.validate_enabled;

3004: --
3005: -- When in validation only mode raise the Validate_Enabled exception
3006: --
3007: if p_validate then
3008: raise hr_api.validate_enabled;
3009: end if;
3010: --
3011: -- Set all output arguments
3012: --

Line 3052: WHEN hr_api.validate_enabled THEN

3048: hr_utility.set_location(' Leaving:'||l_proc, 230);
3049:
3050: EXCEPTION
3051:
3052: WHEN hr_api.validate_enabled THEN
3053:
3054: --
3055: -- As the Validate_Enabled exception has been raised
3056: -- we must rollback to the savepoint

Line 3144: when hr_api.cannot_find_prog_unit then

3140: ,p_tagging_element_type_id => p_tagging_element_type_id
3141: ,p_object_version_number => p_object_version_number
3142: );
3143: exception
3144: when hr_api.cannot_find_prog_unit then
3145: hr_api.cannot_find_prog_unit_error
3146: (p_module_name => 'delete_accrual_plan'
3147: ,p_hook_type => 'BP'
3148: );

Line 3145: hr_api.cannot_find_prog_unit_error

3141: ,p_object_version_number => p_object_version_number
3142: );
3143: exception
3144: when hr_api.cannot_find_prog_unit then
3145: hr_api.cannot_find_prog_unit_error
3146: (p_module_name => 'delete_accrual_plan'
3147: ,p_hook_type => 'BP'
3148: );
3149: end;

Line 3353: when hr_api.cannot_find_prog_unit then

3349: ,p_tagging_element_type_id => p_tagging_element_type_id
3350: ,p_object_version_number => p_object_version_number
3351: );
3352: exception
3353: when hr_api.cannot_find_prog_unit then
3354: hr_api.cannot_find_prog_unit_error
3355: (p_module_name => 'delete_accrual_plan'
3356: ,p_hook_type => 'AP'
3357: );

Line 3354: hr_api.cannot_find_prog_unit_error

3350: ,p_object_version_number => p_object_version_number
3351: );
3352: exception
3353: when hr_api.cannot_find_prog_unit then
3354: hr_api.cannot_find_prog_unit_error
3355: (p_module_name => 'delete_accrual_plan'
3356: ,p_hook_type => 'AP'
3357: );
3358: end;

Line 3365: raise hr_api.validate_enabled;

3361: --
3362: -- When in validation only mode raise the Validate_Enabled exception
3363: --
3364: if p_validate then
3365: raise hr_api.validate_enabled;
3366: end if;
3367:
3368: --
3369: hr_utility.set_location(' Leaving:'||l_proc, 70);

Line 3371: when hr_api.validate_enabled then

3367:
3368: --
3369: hr_utility.set_location(' Leaving:'||l_proc, 70);
3370: exception
3371: when hr_api.validate_enabled then
3372: --
3373: -- As the Validate_Enabled exception has been raised
3374: -- we must rollback to the savepoint
3375: --