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 1916: when hr_api.cannot_find_prog_unit then

1912: ,p_information29 => p_information29
1913: ,p_information30 => p_information30
1914: );
1915: exception
1916: when hr_api.cannot_find_prog_unit then
1917: hr_api.cannot_find_prog_unit_error
1918: (p_module_name => 'create_accrual_plan'
1919: ,p_hook_type => 'AP'
1920: );

Line 1917: hr_api.cannot_find_prog_unit_error

1913: ,p_information30 => p_information30
1914: );
1915: exception
1916: when hr_api.cannot_find_prog_unit then
1917: hr_api.cannot_find_prog_unit_error
1918: (p_module_name => 'create_accrual_plan'
1919: ,p_hook_type => 'AP'
1920: );
1921: end;

Line 1929: raise hr_api.validate_enabled;

1925: --
1926: -- When in validation only mode raise the Validate_Enabled exception
1927: --
1928: if p_validate then
1929: raise hr_api.validate_enabled;
1930: end if;
1931: --
1932: -- Set all output arguments
1933: --

Line 2010: WHEN hr_api.validate_enabled THEN

2006: hr_utility.set_location(' Leaving:'||l_proc, 70);
2007:
2008: EXCEPTION
2009:
2010: WHEN hr_api.validate_enabled THEN
2011: --
2012: -- As the Validate_Enabled exception has been raised
2013: -- we must rollback to the savepoint
2014: --

Line 2074: ,p_pto_input_value_id in number default hr_api.g_number

2070: PROCEDURE update_accrual_plan
2071: (p_validate in boolean default false
2072: ,p_effective_date in date
2073: ,p_accrual_plan_id in number
2074: ,p_pto_input_value_id in number default hr_api.g_number
2075: ,p_accrual_category in varchar2 default hr_api.g_varchar2
2076: ,p_accrual_start in varchar2 default hr_api.g_varchar2
2077: ,p_ineligible_period_length in number default hr_api.g_number
2078: ,p_ineligible_period_type in varchar2 default hr_api.g_varchar2

Line 2075: ,p_accrual_category in varchar2 default hr_api.g_varchar2

2071: (p_validate in boolean default false
2072: ,p_effective_date in date
2073: ,p_accrual_plan_id in number
2074: ,p_pto_input_value_id in number default hr_api.g_number
2075: ,p_accrual_category in varchar2 default hr_api.g_varchar2
2076: ,p_accrual_start in varchar2 default hr_api.g_varchar2
2077: ,p_ineligible_period_length in number default hr_api.g_number
2078: ,p_ineligible_period_type in varchar2 default hr_api.g_varchar2
2079: ,p_accrual_formula_id in number default hr_api.g_number

Line 2076: ,p_accrual_start in varchar2 default hr_api.g_varchar2

2072: ,p_effective_date in date
2073: ,p_accrual_plan_id in number
2074: ,p_pto_input_value_id in number default hr_api.g_number
2075: ,p_accrual_category in varchar2 default hr_api.g_varchar2
2076: ,p_accrual_start in varchar2 default hr_api.g_varchar2
2077: ,p_ineligible_period_length in number default hr_api.g_number
2078: ,p_ineligible_period_type in varchar2 default hr_api.g_varchar2
2079: ,p_accrual_formula_id in number default hr_api.g_number
2080: ,p_co_formula_id in number default hr_api.g_number

Line 2077: ,p_ineligible_period_length in number default hr_api.g_number

2073: ,p_accrual_plan_id in number
2074: ,p_pto_input_value_id in number default hr_api.g_number
2075: ,p_accrual_category in varchar2 default hr_api.g_varchar2
2076: ,p_accrual_start in varchar2 default hr_api.g_varchar2
2077: ,p_ineligible_period_length in number default hr_api.g_number
2078: ,p_ineligible_period_type in varchar2 default hr_api.g_varchar2
2079: ,p_accrual_formula_id in number default hr_api.g_number
2080: ,p_co_formula_id in number default hr_api.g_number
2081: ,p_description in varchar2 default hr_api.g_varchar2

Line 2078: ,p_ineligible_period_type in varchar2 default hr_api.g_varchar2

2074: ,p_pto_input_value_id in number default hr_api.g_number
2075: ,p_accrual_category in varchar2 default hr_api.g_varchar2
2076: ,p_accrual_start in varchar2 default hr_api.g_varchar2
2077: ,p_ineligible_period_length in number default hr_api.g_number
2078: ,p_ineligible_period_type in varchar2 default hr_api.g_varchar2
2079: ,p_accrual_formula_id in number default hr_api.g_number
2080: ,p_co_formula_id in number default hr_api.g_number
2081: ,p_description in varchar2 default hr_api.g_varchar2
2082: ,p_ineligibility_formula_id in number default hr_api.g_number

Line 2079: ,p_accrual_formula_id in number default hr_api.g_number

2075: ,p_accrual_category in varchar2 default hr_api.g_varchar2
2076: ,p_accrual_start in varchar2 default hr_api.g_varchar2
2077: ,p_ineligible_period_length in number default hr_api.g_number
2078: ,p_ineligible_period_type in varchar2 default hr_api.g_varchar2
2079: ,p_accrual_formula_id in number default hr_api.g_number
2080: ,p_co_formula_id in number default hr_api.g_number
2081: ,p_description in varchar2 default hr_api.g_varchar2
2082: ,p_ineligibility_formula_id in number default hr_api.g_number
2083: ,p_balance_dimension_id in number default hr_api.g_number

Line 2080: ,p_co_formula_id in number default hr_api.g_number

2076: ,p_accrual_start in varchar2 default hr_api.g_varchar2
2077: ,p_ineligible_period_length in number default hr_api.g_number
2078: ,p_ineligible_period_type in varchar2 default hr_api.g_varchar2
2079: ,p_accrual_formula_id in number default hr_api.g_number
2080: ,p_co_formula_id in number default hr_api.g_number
2081: ,p_description in varchar2 default hr_api.g_varchar2
2082: ,p_ineligibility_formula_id in number default hr_api.g_number
2083: ,p_balance_dimension_id in number default hr_api.g_number
2084: ,p_information_category in varchar2 default hr_api.g_varchar2

Line 2081: ,p_description in varchar2 default hr_api.g_varchar2

2077: ,p_ineligible_period_length in number default hr_api.g_number
2078: ,p_ineligible_period_type in varchar2 default hr_api.g_varchar2
2079: ,p_accrual_formula_id in number default hr_api.g_number
2080: ,p_co_formula_id in number default hr_api.g_number
2081: ,p_description in varchar2 default hr_api.g_varchar2
2082: ,p_ineligibility_formula_id in number default hr_api.g_number
2083: ,p_balance_dimension_id in number default hr_api.g_number
2084: ,p_information_category in varchar2 default hr_api.g_varchar2
2085: ,p_information1 in varchar2 default hr_api.g_varchar2

Line 2082: ,p_ineligibility_formula_id in number default hr_api.g_number

2078: ,p_ineligible_period_type in varchar2 default hr_api.g_varchar2
2079: ,p_accrual_formula_id in number default hr_api.g_number
2080: ,p_co_formula_id in number default hr_api.g_number
2081: ,p_description in varchar2 default hr_api.g_varchar2
2082: ,p_ineligibility_formula_id in number default hr_api.g_number
2083: ,p_balance_dimension_id in number default hr_api.g_number
2084: ,p_information_category in varchar2 default hr_api.g_varchar2
2085: ,p_information1 in varchar2 default hr_api.g_varchar2
2086: ,p_information2 in varchar2 default hr_api.g_varchar2

Line 2083: ,p_balance_dimension_id in number default hr_api.g_number

2079: ,p_accrual_formula_id in number default hr_api.g_number
2080: ,p_co_formula_id in number default hr_api.g_number
2081: ,p_description in varchar2 default hr_api.g_varchar2
2082: ,p_ineligibility_formula_id in number default hr_api.g_number
2083: ,p_balance_dimension_id in number default hr_api.g_number
2084: ,p_information_category in varchar2 default hr_api.g_varchar2
2085: ,p_information1 in varchar2 default hr_api.g_varchar2
2086: ,p_information2 in varchar2 default hr_api.g_varchar2
2087: ,p_information3 in varchar2 default hr_api.g_varchar2

Line 2084: ,p_information_category in varchar2 default hr_api.g_varchar2

2080: ,p_co_formula_id in number default hr_api.g_number
2081: ,p_description in varchar2 default hr_api.g_varchar2
2082: ,p_ineligibility_formula_id in number default hr_api.g_number
2083: ,p_balance_dimension_id in number default hr_api.g_number
2084: ,p_information_category in varchar2 default hr_api.g_varchar2
2085: ,p_information1 in varchar2 default hr_api.g_varchar2
2086: ,p_information2 in varchar2 default hr_api.g_varchar2
2087: ,p_information3 in varchar2 default hr_api.g_varchar2
2088: ,p_information4 in varchar2 default hr_api.g_varchar2

Line 2085: ,p_information1 in varchar2 default hr_api.g_varchar2

2081: ,p_description in varchar2 default hr_api.g_varchar2
2082: ,p_ineligibility_formula_id in number default hr_api.g_number
2083: ,p_balance_dimension_id in number default hr_api.g_number
2084: ,p_information_category in varchar2 default hr_api.g_varchar2
2085: ,p_information1 in varchar2 default hr_api.g_varchar2
2086: ,p_information2 in varchar2 default hr_api.g_varchar2
2087: ,p_information3 in varchar2 default hr_api.g_varchar2
2088: ,p_information4 in varchar2 default hr_api.g_varchar2
2089: ,p_information5 in varchar2 default hr_api.g_varchar2

Line 2086: ,p_information2 in varchar2 default hr_api.g_varchar2

2082: ,p_ineligibility_formula_id in number default hr_api.g_number
2083: ,p_balance_dimension_id in number default hr_api.g_number
2084: ,p_information_category in varchar2 default hr_api.g_varchar2
2085: ,p_information1 in varchar2 default hr_api.g_varchar2
2086: ,p_information2 in varchar2 default hr_api.g_varchar2
2087: ,p_information3 in varchar2 default hr_api.g_varchar2
2088: ,p_information4 in varchar2 default hr_api.g_varchar2
2089: ,p_information5 in varchar2 default hr_api.g_varchar2
2090: ,p_information6 in varchar2 default hr_api.g_varchar2

Line 2087: ,p_information3 in varchar2 default hr_api.g_varchar2

2083: ,p_balance_dimension_id in number default hr_api.g_number
2084: ,p_information_category in varchar2 default hr_api.g_varchar2
2085: ,p_information1 in varchar2 default hr_api.g_varchar2
2086: ,p_information2 in varchar2 default hr_api.g_varchar2
2087: ,p_information3 in varchar2 default hr_api.g_varchar2
2088: ,p_information4 in varchar2 default hr_api.g_varchar2
2089: ,p_information5 in varchar2 default hr_api.g_varchar2
2090: ,p_information6 in varchar2 default hr_api.g_varchar2
2091: ,p_information7 in varchar2 default hr_api.g_varchar2

Line 2088: ,p_information4 in varchar2 default hr_api.g_varchar2

2084: ,p_information_category in varchar2 default hr_api.g_varchar2
2085: ,p_information1 in varchar2 default hr_api.g_varchar2
2086: ,p_information2 in varchar2 default hr_api.g_varchar2
2087: ,p_information3 in varchar2 default hr_api.g_varchar2
2088: ,p_information4 in varchar2 default hr_api.g_varchar2
2089: ,p_information5 in varchar2 default hr_api.g_varchar2
2090: ,p_information6 in varchar2 default hr_api.g_varchar2
2091: ,p_information7 in varchar2 default hr_api.g_varchar2
2092: ,p_information8 in varchar2 default hr_api.g_varchar2

Line 2089: ,p_information5 in varchar2 default hr_api.g_varchar2

2085: ,p_information1 in varchar2 default hr_api.g_varchar2
2086: ,p_information2 in varchar2 default hr_api.g_varchar2
2087: ,p_information3 in varchar2 default hr_api.g_varchar2
2088: ,p_information4 in varchar2 default hr_api.g_varchar2
2089: ,p_information5 in varchar2 default hr_api.g_varchar2
2090: ,p_information6 in varchar2 default hr_api.g_varchar2
2091: ,p_information7 in varchar2 default hr_api.g_varchar2
2092: ,p_information8 in varchar2 default hr_api.g_varchar2
2093: ,p_information9 in varchar2 default hr_api.g_varchar2

Line 2090: ,p_information6 in varchar2 default hr_api.g_varchar2

2086: ,p_information2 in varchar2 default hr_api.g_varchar2
2087: ,p_information3 in varchar2 default hr_api.g_varchar2
2088: ,p_information4 in varchar2 default hr_api.g_varchar2
2089: ,p_information5 in varchar2 default hr_api.g_varchar2
2090: ,p_information6 in varchar2 default hr_api.g_varchar2
2091: ,p_information7 in varchar2 default hr_api.g_varchar2
2092: ,p_information8 in varchar2 default hr_api.g_varchar2
2093: ,p_information9 in varchar2 default hr_api.g_varchar2
2094: ,p_information10 in varchar2 default hr_api.g_varchar2

Line 2091: ,p_information7 in varchar2 default hr_api.g_varchar2

2087: ,p_information3 in varchar2 default hr_api.g_varchar2
2088: ,p_information4 in varchar2 default hr_api.g_varchar2
2089: ,p_information5 in varchar2 default hr_api.g_varchar2
2090: ,p_information6 in varchar2 default hr_api.g_varchar2
2091: ,p_information7 in varchar2 default hr_api.g_varchar2
2092: ,p_information8 in varchar2 default hr_api.g_varchar2
2093: ,p_information9 in varchar2 default hr_api.g_varchar2
2094: ,p_information10 in varchar2 default hr_api.g_varchar2
2095: ,p_information11 in varchar2 default hr_api.g_varchar2

Line 2092: ,p_information8 in varchar2 default hr_api.g_varchar2

2088: ,p_information4 in varchar2 default hr_api.g_varchar2
2089: ,p_information5 in varchar2 default hr_api.g_varchar2
2090: ,p_information6 in varchar2 default hr_api.g_varchar2
2091: ,p_information7 in varchar2 default hr_api.g_varchar2
2092: ,p_information8 in varchar2 default hr_api.g_varchar2
2093: ,p_information9 in varchar2 default hr_api.g_varchar2
2094: ,p_information10 in varchar2 default hr_api.g_varchar2
2095: ,p_information11 in varchar2 default hr_api.g_varchar2
2096: ,p_information12 in varchar2 default hr_api.g_varchar2

Line 2093: ,p_information9 in varchar2 default hr_api.g_varchar2

2089: ,p_information5 in varchar2 default hr_api.g_varchar2
2090: ,p_information6 in varchar2 default hr_api.g_varchar2
2091: ,p_information7 in varchar2 default hr_api.g_varchar2
2092: ,p_information8 in varchar2 default hr_api.g_varchar2
2093: ,p_information9 in varchar2 default hr_api.g_varchar2
2094: ,p_information10 in varchar2 default hr_api.g_varchar2
2095: ,p_information11 in varchar2 default hr_api.g_varchar2
2096: ,p_information12 in varchar2 default hr_api.g_varchar2
2097: ,p_information13 in varchar2 default hr_api.g_varchar2

Line 2094: ,p_information10 in varchar2 default hr_api.g_varchar2

2090: ,p_information6 in varchar2 default hr_api.g_varchar2
2091: ,p_information7 in varchar2 default hr_api.g_varchar2
2092: ,p_information8 in varchar2 default hr_api.g_varchar2
2093: ,p_information9 in varchar2 default hr_api.g_varchar2
2094: ,p_information10 in varchar2 default hr_api.g_varchar2
2095: ,p_information11 in varchar2 default hr_api.g_varchar2
2096: ,p_information12 in varchar2 default hr_api.g_varchar2
2097: ,p_information13 in varchar2 default hr_api.g_varchar2
2098: ,p_information14 in varchar2 default hr_api.g_varchar2

Line 2095: ,p_information11 in varchar2 default hr_api.g_varchar2

2091: ,p_information7 in varchar2 default hr_api.g_varchar2
2092: ,p_information8 in varchar2 default hr_api.g_varchar2
2093: ,p_information9 in varchar2 default hr_api.g_varchar2
2094: ,p_information10 in varchar2 default hr_api.g_varchar2
2095: ,p_information11 in varchar2 default hr_api.g_varchar2
2096: ,p_information12 in varchar2 default hr_api.g_varchar2
2097: ,p_information13 in varchar2 default hr_api.g_varchar2
2098: ,p_information14 in varchar2 default hr_api.g_varchar2
2099: ,p_information15 in varchar2 default hr_api.g_varchar2

Line 2096: ,p_information12 in varchar2 default hr_api.g_varchar2

2092: ,p_information8 in varchar2 default hr_api.g_varchar2
2093: ,p_information9 in varchar2 default hr_api.g_varchar2
2094: ,p_information10 in varchar2 default hr_api.g_varchar2
2095: ,p_information11 in varchar2 default hr_api.g_varchar2
2096: ,p_information12 in varchar2 default hr_api.g_varchar2
2097: ,p_information13 in varchar2 default hr_api.g_varchar2
2098: ,p_information14 in varchar2 default hr_api.g_varchar2
2099: ,p_information15 in varchar2 default hr_api.g_varchar2
2100: ,p_information16 in varchar2 default hr_api.g_varchar2

Line 2097: ,p_information13 in varchar2 default hr_api.g_varchar2

2093: ,p_information9 in varchar2 default hr_api.g_varchar2
2094: ,p_information10 in varchar2 default hr_api.g_varchar2
2095: ,p_information11 in varchar2 default hr_api.g_varchar2
2096: ,p_information12 in varchar2 default hr_api.g_varchar2
2097: ,p_information13 in varchar2 default hr_api.g_varchar2
2098: ,p_information14 in varchar2 default hr_api.g_varchar2
2099: ,p_information15 in varchar2 default hr_api.g_varchar2
2100: ,p_information16 in varchar2 default hr_api.g_varchar2
2101: ,p_information17 in varchar2 default hr_api.g_varchar2

Line 2098: ,p_information14 in varchar2 default hr_api.g_varchar2

2094: ,p_information10 in varchar2 default hr_api.g_varchar2
2095: ,p_information11 in varchar2 default hr_api.g_varchar2
2096: ,p_information12 in varchar2 default hr_api.g_varchar2
2097: ,p_information13 in varchar2 default hr_api.g_varchar2
2098: ,p_information14 in varchar2 default hr_api.g_varchar2
2099: ,p_information15 in varchar2 default hr_api.g_varchar2
2100: ,p_information16 in varchar2 default hr_api.g_varchar2
2101: ,p_information17 in varchar2 default hr_api.g_varchar2
2102: ,p_information18 in varchar2 default hr_api.g_varchar2

Line 2099: ,p_information15 in varchar2 default hr_api.g_varchar2

2095: ,p_information11 in varchar2 default hr_api.g_varchar2
2096: ,p_information12 in varchar2 default hr_api.g_varchar2
2097: ,p_information13 in varchar2 default hr_api.g_varchar2
2098: ,p_information14 in varchar2 default hr_api.g_varchar2
2099: ,p_information15 in varchar2 default hr_api.g_varchar2
2100: ,p_information16 in varchar2 default hr_api.g_varchar2
2101: ,p_information17 in varchar2 default hr_api.g_varchar2
2102: ,p_information18 in varchar2 default hr_api.g_varchar2
2103: ,p_information19 in varchar2 default hr_api.g_varchar2

Line 2100: ,p_information16 in varchar2 default hr_api.g_varchar2

2096: ,p_information12 in varchar2 default hr_api.g_varchar2
2097: ,p_information13 in varchar2 default hr_api.g_varchar2
2098: ,p_information14 in varchar2 default hr_api.g_varchar2
2099: ,p_information15 in varchar2 default hr_api.g_varchar2
2100: ,p_information16 in varchar2 default hr_api.g_varchar2
2101: ,p_information17 in varchar2 default hr_api.g_varchar2
2102: ,p_information18 in varchar2 default hr_api.g_varchar2
2103: ,p_information19 in varchar2 default hr_api.g_varchar2
2104: ,p_information20 in varchar2 default hr_api.g_varchar2

Line 2101: ,p_information17 in varchar2 default hr_api.g_varchar2

2097: ,p_information13 in varchar2 default hr_api.g_varchar2
2098: ,p_information14 in varchar2 default hr_api.g_varchar2
2099: ,p_information15 in varchar2 default hr_api.g_varchar2
2100: ,p_information16 in varchar2 default hr_api.g_varchar2
2101: ,p_information17 in varchar2 default hr_api.g_varchar2
2102: ,p_information18 in varchar2 default hr_api.g_varchar2
2103: ,p_information19 in varchar2 default hr_api.g_varchar2
2104: ,p_information20 in varchar2 default hr_api.g_varchar2
2105: ,p_information21 in varchar2 default hr_api.g_varchar2

Line 2102: ,p_information18 in varchar2 default hr_api.g_varchar2

2098: ,p_information14 in varchar2 default hr_api.g_varchar2
2099: ,p_information15 in varchar2 default hr_api.g_varchar2
2100: ,p_information16 in varchar2 default hr_api.g_varchar2
2101: ,p_information17 in varchar2 default hr_api.g_varchar2
2102: ,p_information18 in varchar2 default hr_api.g_varchar2
2103: ,p_information19 in varchar2 default hr_api.g_varchar2
2104: ,p_information20 in varchar2 default hr_api.g_varchar2
2105: ,p_information21 in varchar2 default hr_api.g_varchar2
2106: ,p_information22 in varchar2 default hr_api.g_varchar2

Line 2103: ,p_information19 in varchar2 default hr_api.g_varchar2

2099: ,p_information15 in varchar2 default hr_api.g_varchar2
2100: ,p_information16 in varchar2 default hr_api.g_varchar2
2101: ,p_information17 in varchar2 default hr_api.g_varchar2
2102: ,p_information18 in varchar2 default hr_api.g_varchar2
2103: ,p_information19 in varchar2 default hr_api.g_varchar2
2104: ,p_information20 in varchar2 default hr_api.g_varchar2
2105: ,p_information21 in varchar2 default hr_api.g_varchar2
2106: ,p_information22 in varchar2 default hr_api.g_varchar2
2107: ,p_information23 in varchar2 default hr_api.g_varchar2

Line 2104: ,p_information20 in varchar2 default hr_api.g_varchar2

2100: ,p_information16 in varchar2 default hr_api.g_varchar2
2101: ,p_information17 in varchar2 default hr_api.g_varchar2
2102: ,p_information18 in varchar2 default hr_api.g_varchar2
2103: ,p_information19 in varchar2 default hr_api.g_varchar2
2104: ,p_information20 in varchar2 default hr_api.g_varchar2
2105: ,p_information21 in varchar2 default hr_api.g_varchar2
2106: ,p_information22 in varchar2 default hr_api.g_varchar2
2107: ,p_information23 in varchar2 default hr_api.g_varchar2
2108: ,p_information24 in varchar2 default hr_api.g_varchar2

Line 2105: ,p_information21 in varchar2 default hr_api.g_varchar2

2101: ,p_information17 in varchar2 default hr_api.g_varchar2
2102: ,p_information18 in varchar2 default hr_api.g_varchar2
2103: ,p_information19 in varchar2 default hr_api.g_varchar2
2104: ,p_information20 in varchar2 default hr_api.g_varchar2
2105: ,p_information21 in varchar2 default hr_api.g_varchar2
2106: ,p_information22 in varchar2 default hr_api.g_varchar2
2107: ,p_information23 in varchar2 default hr_api.g_varchar2
2108: ,p_information24 in varchar2 default hr_api.g_varchar2
2109: ,p_information25 in varchar2 default hr_api.g_varchar2

Line 2106: ,p_information22 in varchar2 default hr_api.g_varchar2

2102: ,p_information18 in varchar2 default hr_api.g_varchar2
2103: ,p_information19 in varchar2 default hr_api.g_varchar2
2104: ,p_information20 in varchar2 default hr_api.g_varchar2
2105: ,p_information21 in varchar2 default hr_api.g_varchar2
2106: ,p_information22 in varchar2 default hr_api.g_varchar2
2107: ,p_information23 in varchar2 default hr_api.g_varchar2
2108: ,p_information24 in varchar2 default hr_api.g_varchar2
2109: ,p_information25 in varchar2 default hr_api.g_varchar2
2110: ,p_information26 in varchar2 default hr_api.g_varchar2

Line 2107: ,p_information23 in varchar2 default hr_api.g_varchar2

2103: ,p_information19 in varchar2 default hr_api.g_varchar2
2104: ,p_information20 in varchar2 default hr_api.g_varchar2
2105: ,p_information21 in varchar2 default hr_api.g_varchar2
2106: ,p_information22 in varchar2 default hr_api.g_varchar2
2107: ,p_information23 in varchar2 default hr_api.g_varchar2
2108: ,p_information24 in varchar2 default hr_api.g_varchar2
2109: ,p_information25 in varchar2 default hr_api.g_varchar2
2110: ,p_information26 in varchar2 default hr_api.g_varchar2
2111: ,p_information27 in varchar2 default hr_api.g_varchar2

Line 2108: ,p_information24 in varchar2 default hr_api.g_varchar2

2104: ,p_information20 in varchar2 default hr_api.g_varchar2
2105: ,p_information21 in varchar2 default hr_api.g_varchar2
2106: ,p_information22 in varchar2 default hr_api.g_varchar2
2107: ,p_information23 in varchar2 default hr_api.g_varchar2
2108: ,p_information24 in varchar2 default hr_api.g_varchar2
2109: ,p_information25 in varchar2 default hr_api.g_varchar2
2110: ,p_information26 in varchar2 default hr_api.g_varchar2
2111: ,p_information27 in varchar2 default hr_api.g_varchar2
2112: ,p_information28 in varchar2 default hr_api.g_varchar2

Line 2109: ,p_information25 in varchar2 default hr_api.g_varchar2

2105: ,p_information21 in varchar2 default hr_api.g_varchar2
2106: ,p_information22 in varchar2 default hr_api.g_varchar2
2107: ,p_information23 in varchar2 default hr_api.g_varchar2
2108: ,p_information24 in varchar2 default hr_api.g_varchar2
2109: ,p_information25 in varchar2 default hr_api.g_varchar2
2110: ,p_information26 in varchar2 default hr_api.g_varchar2
2111: ,p_information27 in varchar2 default hr_api.g_varchar2
2112: ,p_information28 in varchar2 default hr_api.g_varchar2
2113: ,p_information29 in varchar2 default hr_api.g_varchar2

Line 2110: ,p_information26 in varchar2 default hr_api.g_varchar2

2106: ,p_information22 in varchar2 default hr_api.g_varchar2
2107: ,p_information23 in varchar2 default hr_api.g_varchar2
2108: ,p_information24 in varchar2 default hr_api.g_varchar2
2109: ,p_information25 in varchar2 default hr_api.g_varchar2
2110: ,p_information26 in varchar2 default hr_api.g_varchar2
2111: ,p_information27 in varchar2 default hr_api.g_varchar2
2112: ,p_information28 in varchar2 default hr_api.g_varchar2
2113: ,p_information29 in varchar2 default hr_api.g_varchar2
2114: ,p_information30 in varchar2 default hr_api.g_varchar2

Line 2111: ,p_information27 in varchar2 default hr_api.g_varchar2

2107: ,p_information23 in varchar2 default hr_api.g_varchar2
2108: ,p_information24 in varchar2 default hr_api.g_varchar2
2109: ,p_information25 in varchar2 default hr_api.g_varchar2
2110: ,p_information26 in varchar2 default hr_api.g_varchar2
2111: ,p_information27 in varchar2 default hr_api.g_varchar2
2112: ,p_information28 in varchar2 default hr_api.g_varchar2
2113: ,p_information29 in varchar2 default hr_api.g_varchar2
2114: ,p_information30 in varchar2 default hr_api.g_varchar2
2115: ,p_object_version_number in out nocopy number

Line 2112: ,p_information28 in varchar2 default hr_api.g_varchar2

2108: ,p_information24 in varchar2 default hr_api.g_varchar2
2109: ,p_information25 in varchar2 default hr_api.g_varchar2
2110: ,p_information26 in varchar2 default hr_api.g_varchar2
2111: ,p_information27 in varchar2 default hr_api.g_varchar2
2112: ,p_information28 in varchar2 default hr_api.g_varchar2
2113: ,p_information29 in varchar2 default hr_api.g_varchar2
2114: ,p_information30 in varchar2 default hr_api.g_varchar2
2115: ,p_object_version_number in out nocopy number
2116: ,p_payroll_formula_id out nocopy number

Line 2113: ,p_information29 in varchar2 default hr_api.g_varchar2

2109: ,p_information25 in varchar2 default hr_api.g_varchar2
2110: ,p_information26 in varchar2 default hr_api.g_varchar2
2111: ,p_information27 in varchar2 default hr_api.g_varchar2
2112: ,p_information28 in varchar2 default hr_api.g_varchar2
2113: ,p_information29 in varchar2 default hr_api.g_varchar2
2114: ,p_information30 in varchar2 default hr_api.g_varchar2
2115: ,p_object_version_number in out nocopy number
2116: ,p_payroll_formula_id out nocopy number
2117: ,p_defined_balance_id out nocopy number

Line 2114: ,p_information30 in varchar2 default hr_api.g_varchar2

2110: ,p_information26 in varchar2 default hr_api.g_varchar2
2111: ,p_information27 in varchar2 default hr_api.g_varchar2
2112: ,p_information28 in varchar2 default hr_api.g_varchar2
2113: ,p_information29 in varchar2 default hr_api.g_varchar2
2114: ,p_information30 in varchar2 default hr_api.g_varchar2
2115: ,p_object_version_number in out nocopy number
2116: ,p_payroll_formula_id out nocopy number
2117: ,p_defined_balance_id out nocopy number
2118: ,p_balance_element_type_id out nocopy number

Line 2331: when hr_api.cannot_find_prog_unit then

2327: ,p_information30 => p_information30
2328:
2329: );
2330: exception
2331: when hr_api.cannot_find_prog_unit then
2332: hr_api.cannot_find_prog_unit_error
2333: (p_module_name => 'update_accrual_plan'
2334: ,p_hook_type => 'BP'
2335: );

Line 2332: hr_api.cannot_find_prog_unit_error

2328:
2329: );
2330: exception
2331: when hr_api.cannot_find_prog_unit then
2332: hr_api.cannot_find_prog_unit_error
2333: (p_module_name => 'update_accrual_plan'
2334: ,p_hook_type => 'BP'
2335: );
2336: end;

Line 2365: p_balance_dimension_id <> hr_api.g_number THEN

2361: hr_utility.set_location(l_proc, 40);
2362:
2363: IF l_plan_rec.defined_balance_id IS NULL AND
2364: p_balance_dimension_id IS NOT NULL AND
2365: p_balance_dimension_id <> hr_api.g_number THEN
2366:
2367: --
2368: -- Setup the accrual plan for payroll balances.
2369: --

Line 2881: if p_pto_input_value_id <> hr_api.g_number

2877: );
2878:
2879: hr_utility.set_location(l_proc, 180);
2880:
2881: if p_pto_input_value_id <> hr_api.g_number
2882: and p_pto_input_value_id <> pay_pap_shd.g_old_rec.pto_input_value_id then
2883: --
2884: for l_ncr_rec in c_get_ncr(pay_pap_shd.g_old_rec.pto_input_value_id) loop
2885: --

Line 2979: when hr_api.cannot_find_prog_unit then

2975: ,p_information29 => p_information29
2976: ,p_information30 => p_information30
2977: );
2978: exception
2979: when hr_api.cannot_find_prog_unit then
2980: hr_api.cannot_find_prog_unit_error
2981: (p_module_name => 'update_accrual_plan'
2982: ,p_hook_type => 'AP'
2983: );

Line 2980: hr_api.cannot_find_prog_unit_error

2976: ,p_information30 => p_information30
2977: );
2978: exception
2979: when hr_api.cannot_find_prog_unit then
2980: hr_api.cannot_find_prog_unit_error
2981: (p_module_name => 'update_accrual_plan'
2982: ,p_hook_type => 'AP'
2983: );
2984: end;

Line 2992: raise hr_api.validate_enabled;

2988: --
2989: -- When in validation only mode raise the Validate_Enabled exception
2990: --
2991: if p_validate then
2992: raise hr_api.validate_enabled;
2993: end if;
2994: --
2995: -- Set all output arguments
2996: --

Line 3036: WHEN hr_api.validate_enabled THEN

3032: hr_utility.set_location(' Leaving:'||l_proc, 230);
3033:
3034: EXCEPTION
3035:
3036: WHEN hr_api.validate_enabled THEN
3037:
3038: --
3039: -- As the Validate_Enabled exception has been raised
3040: -- we must rollback to the savepoint

Line 3128: when hr_api.cannot_find_prog_unit then

3124: ,p_tagging_element_type_id => p_tagging_element_type_id
3125: ,p_object_version_number => p_object_version_number
3126: );
3127: exception
3128: when hr_api.cannot_find_prog_unit then
3129: hr_api.cannot_find_prog_unit_error
3130: (p_module_name => 'delete_accrual_plan'
3131: ,p_hook_type => 'BP'
3132: );

Line 3129: hr_api.cannot_find_prog_unit_error

3125: ,p_object_version_number => p_object_version_number
3126: );
3127: exception
3128: when hr_api.cannot_find_prog_unit then
3129: hr_api.cannot_find_prog_unit_error
3130: (p_module_name => 'delete_accrual_plan'
3131: ,p_hook_type => 'BP'
3132: );
3133: end;

Line 3331: when hr_api.cannot_find_prog_unit then

3327: ,p_tagging_element_type_id => p_tagging_element_type_id
3328: ,p_object_version_number => p_object_version_number
3329: );
3330: exception
3331: when hr_api.cannot_find_prog_unit then
3332: hr_api.cannot_find_prog_unit_error
3333: (p_module_name => 'delete_accrual_plan'
3334: ,p_hook_type => 'AP'
3335: );

Line 3332: hr_api.cannot_find_prog_unit_error

3328: ,p_object_version_number => p_object_version_number
3329: );
3330: exception
3331: when hr_api.cannot_find_prog_unit then
3332: hr_api.cannot_find_prog_unit_error
3333: (p_module_name => 'delete_accrual_plan'
3334: ,p_hook_type => 'AP'
3335: );
3336: end;

Line 3343: raise hr_api.validate_enabled;

3339: --
3340: -- When in validation only mode raise the Validate_Enabled exception
3341: --
3342: if p_validate then
3343: raise hr_api.validate_enabled;
3344: end if;
3345:
3346: --
3347: hr_utility.set_location(' Leaving:'||l_proc, 70);

Line 3349: when hr_api.validate_enabled then

3345:
3346: --
3347: hr_utility.set_location(' Leaving:'||l_proc, 70);
3348: exception
3349: when hr_api.validate_enabled then
3350: --
3351: -- As the Validate_Enabled exception has been raised
3352: -- we must rollback to the savepoint
3353: --