DBA Data[Home] [Help]

APPS.PER_SLT_BUS dependencies on STANDARD

Line 172: -- HR_STANDARD_LOOKUPS for the lookup type 'PER_SOLUTION_CATEGORIES' with

168: --
169: -- Description:
170: -- Checks that a solution category value is valid
171: -- - Validates that the solution category exists as a lookup code on
172: -- HR_STANDARD_LOOKUPS for the lookup type 'PER_SOLUTION_CATEGORIES' with
173: -- an enabled flag set to 'Y' and the effective date between the
174: -- start date active and end date active on HR_STANDARD_LOOKUPS.
175: --
176: -- Pre-conditions:

Line 174: -- start date active and end date active on HR_STANDARD_LOOKUPS.

170: -- Checks that a solution category value is valid
171: -- - Validates that the solution category exists as a lookup code on
172: -- HR_STANDARD_LOOKUPS for the lookup type 'PER_SOLUTION_CATEGORIES' with
173: -- an enabled flag set to 'Y' and the effective date between the
174: -- start date active and end date active on HR_STANDARD_LOOKUPS.
175: --
176: -- Pre-conditions:
177: -- None
178: --

Line 187: -- - solution category exists as a lookup code in HR_STANDARD_LOOKUPS

183: -- p_object_version_number
184: --
185: -- Post Success:
186: -- Processing continues if:
187: -- - solution category exists as a lookup code in HR_STANDARD_LOOKUPS
188: -- for the lookup type 'PER_SOLUTION_CATEGORIES' where the enabled
189: -- flag is 'Y' and the effective date is between start date active
190: -- and end date active on HR_STANDARD_LOOKUPS.
191: --

Line 190: -- and end date active on HR_STANDARD_LOOKUPS.

186: -- Processing continues if:
187: -- - solution category exists as a lookup code in HR_STANDARD_LOOKUPS
188: -- for the lookup type 'PER_SOLUTION_CATEGORIES' where the enabled
189: -- flag is 'Y' and the effective date is between start date active
190: -- and end date active on HR_STANDARD_LOOKUPS.
191: --
192: -- Post Failure:
193: -- An application error is raised and processing is terminated if:
194: -- - solution category doesn't exist as a lookup code in HR_STANDARD_LOOKUPS

Line 194: -- - solution category doesn't exist as a lookup code in HR_STANDARD_LOOKUPS

190: -- and end date active on HR_STANDARD_LOOKUPS.
191: --
192: -- Post Failure:
193: -- An application error is raised and processing is terminated if:
194: -- - solution category doesn't exist as a lookup code in HR_STANDARD_LOOKUPS
195: -- for the lookup type 'PER_SOLUTION_CATEGORIES' where the enabled
196: -- flag is 'Y' and the effective date is between start date active
197: -- and end date active on HR_STANDARD_LOOKUPS.
198: --

Line 197: -- and end date active on HR_STANDARD_LOOKUPS.

193: -- An application error is raised and processing is terminated if:
194: -- - solution category doesn't exist as a lookup code in HR_STANDARD_LOOKUPS
195: -- for the lookup type 'PER_SOLUTION_CATEGORIES' where the enabled
196: -- flag is 'Y' and the effective date is between start date active
197: -- and end date active on HR_STANDARD_LOOKUPS.
198: --
199: -- Access Status:
200: -- Internal Table Handler Use Only.
201: --

Line 247: -- Check that the solution category exists in HR_STANDARD_LOOKUPS for the

243: -- Check if solution category is set
244: --
245: if p_solution_category is not null then
246: --
247: -- Check that the solution category exists in HR_STANDARD_LOOKUPS for the
248: -- lookup type 'PER_SOLUTION_CATEGORIES' with an enabled flag set to 'Y'
249: -- and that the effective date is between start date
250: -- active and end date active in HR_STANDARD_LOOKUPS.
251: --

Line 250: -- active and end date active in HR_STANDARD_LOOKUPS.

246: --
247: -- Check that the solution category exists in HR_STANDARD_LOOKUPS for the
248: -- lookup type 'PER_SOLUTION_CATEGORIES' with an enabled flag set to 'Y'
249: -- and that the effective date is between start date
250: -- active and end date active in HR_STANDARD_LOOKUPS.
251: --
252: if hr_api.not_exists_in_hrstanlookups
253: (p_effective_date => p_effective_date
254: ,p_lookup_type => 'PER_SOLUTION_CATEGORIES'

Line 288: -- - updateable exists as a lookup code in HR_STANDARD_LOOKUPS

284: -- p_object_version_number
285: --
286: -- Post Success:
287: -- Processing continues if:
288: -- - updateable exists as a lookup code in HR_STANDARD_LOOKUPS
289: -- for the lookup type 'YES_NO' where the enabled
290: -- flag is 'Y' and the effective date is between start date active
291: -- and end date active on HR_STANDARD_LOOKUPS.
292: --

Line 291: -- and end date active on HR_STANDARD_LOOKUPS.

287: -- Processing continues if:
288: -- - updateable exists as a lookup code in HR_STANDARD_LOOKUPS
289: -- for the lookup type 'YES_NO' where the enabled
290: -- flag is 'Y' and the effective date is between start date active
291: -- and end date active on HR_STANDARD_LOOKUPS.
292: --
293: -- Post Failure:
294: -- An application error is raised and processing is terminated if:
295: -- - updateable doesn't exist as a lookup code in HR_STANDARD_LOOKUPS

Line 295: -- - updateable doesn't exist as a lookup code in HR_STANDARD_LOOKUPS

291: -- and end date active on HR_STANDARD_LOOKUPS.
292: --
293: -- Post Failure:
294: -- An application error is raised and processing is terminated if:
295: -- - updateable doesn't exist as a lookup code in HR_STANDARD_LOOKUPS
296: -- for the lookup type 'YES_NO' where the enabled
297: -- flag is 'Y' and the effective date is between start date active
298: -- and end date active on HR_STANDARD_LOOKUPS.
299: --

Line 298: -- and end date active on HR_STANDARD_LOOKUPS.

294: -- An application error is raised and processing is terminated if:
295: -- - updateable doesn't exist as a lookup code in HR_STANDARD_LOOKUPS
296: -- for the lookup type 'YES_NO' where the enabled
297: -- flag is 'Y' and the effective date is between start date active
298: -- and end date active on HR_STANDARD_LOOKUPS.
299: --
300: -- Access Status:
301: -- Internal Table Handler Use Only.
302: --

Line 352: -- Check that the updateable flag exists in HR_STANDARD_LOOKUPS for the

348: -- Check if updateable is set
349: --
350: if p_updateable is not null then
351: --
352: -- Check that the updateable flag exists in HR_STANDARD_LOOKUPS for the
353: -- lookup type 'YES_NO' with an enabled flag set to 'Y'
354: -- and that the effective date is between start date
355: -- active and end date active in HR_STANDARD_LOOKUPS.
356: --

Line 355: -- active and end date active in HR_STANDARD_LOOKUPS.

351: --
352: -- Check that the updateable flag exists in HR_STANDARD_LOOKUPS for the
353: -- lookup type 'YES_NO' with an enabled flag set to 'Y'
354: -- and that the effective date is between start date
355: -- active and end date active in HR_STANDARD_LOOKUPS.
356: --
357: if hr_api.not_exists_in_hrstanlookups
358: (p_effective_date => p_effective_date
359: ,p_lookup_type => 'YES_NO'

Line 444: -- No business group context. HR_STANDARD_LOOKUPS used for validation."

440: hr_utility.set_location('Entering:'||l_proc, 5);
441: --
442: -- Call all supporting business operations
443: --
444: -- No business group context. HR_STANDARD_LOOKUPS used for validation."
445: --
446: -- Validate Dependent Attributes
447: --
448: --

Line 481: -- No business group context. HR_STANDARD_LOOKUPS used for validation."

477: hr_utility.set_location('Entering:'||l_proc, 5);
478: --
479: -- Call all supporting business operations
480: --
481: -- No business group context. HR_STANDARD_LOOKUPS used for validation."
482: --
483: -- Validate Dependent Attributes
484: --
485: chk_non_updateable_args