DBA Data[Home] [Help]

APPS.PER_PSS_BUS dependencies on STANDARD

Line 203: -- a) Exists in hr_standard_lookups for lookup_type 'SURVEY_COMPANY'.

199: -- ---------------------------------------------------------------
200: --
201: -- Description
202: -- This procedure is used to check that survey_company_code:
203: -- a) Exists in hr_standard_lookups for lookup_type 'SURVEY_COMPANY'.
204: --
205: -- Pre Requisites
206: -- None.
207: --

Line 212: -- hr_standard_lookups)

208: -- In Parameters
209: -- salary_survey_id
210: -- survey_company_code.
211: -- p_effective_date (used as parameter for not_exists in
212: -- hr_standard_lookups)
213: --
214: -- Post Success
215: -- Processing continues if the survey_company_code
216: -- exists in hr_standard_lookups.

Line 216: -- exists in hr_standard_lookups.

212: -- hr_standard_lookups)
213: --
214: -- Post Success
215: -- Processing continues if the survey_company_code
216: -- exists in hr_standard_lookups.
217: --
218: -- Post Failure
219: -- An application error is raised and processing is terminated
220: -- if the survey_company_code does not exist in hr_standard_lookups.

Line 220: -- if the survey_company_code does not exist in hr_standard_lookups.

216: -- exists in hr_standard_lookups.
217: --
218: -- Post Failure
219: -- An application error is raised and processing is terminated
220: -- if the survey_company_code does not exist in hr_standard_lookups.
221: --
222: -- Developer/Implementation Notes
223: -- None.
224: --

Line 266: -- in hr_standard_lookups where the lookup_type is 'SURVEY_COMPANY'

262: hr_utility.set_location(l_proc, 20);
263: --
264: -- If survey_company_code is not null then
265: -- Check if the survey_company_code value exists
266: -- in hr_standard_lookups where the lookup_type is 'SURVEY_COMPANY'
267: --
268: if p_survey_company_code is not null then
269: -- code commented for bug5439193 by amigarg
270: --if hr_api.not_exists_in_hrstanlookups

Line 360: -- exists in hr_standard_lookups and is not null.

356: -- p_effective_date
357: --
358: -- Post Success
359: -- Processing continues if the currency_code
360: -- exists in hr_standard_lookups and is not null.
361: --
362: -- Post Failure
363: -- An application error is raised and processing is terminated
364: -- if the currency_code does not exist in hr_standard_lookups or is null.

Line 364: -- if the currency_code does not exist in hr_standard_lookups or is null.

360: -- exists in hr_standard_lookups and is not null.
361: --
362: -- Post Failure
363: -- An application error is raised and processing is terminated
364: -- if the currency_code does not exist in hr_standard_lookups or is null.
365: --
366: -- Developer/Implementation Notes
367: -- None.
368: --

Line 449: -- b) Exists in hr_standard_lookups for lookup_type 'PAY_BASIS'.

445: --
446: -- Description
447: -- This procedure is used to check that survey_type_code:
448: -- a) Is not null.
449: -- b) Exists in hr_standard_lookups for lookup_type 'PAY_BASIS'.
450: --
451: -- Pre Requisites
452: -- None.
453: --

Line 458: -- hr_standard_lookups)

454: -- In Parameters
455: -- salary_survey_id
456: -- survey_type_code.
457: -- p_effective_date (used as parameter for not_exists in
458: -- hr_standard_lookups)
459: --
460: -- Post Success
461: -- Processing continues if the survey_type_code
462: -- exists in hr_standard_lookups.

Line 462: -- exists in hr_standard_lookups.

458: -- hr_standard_lookups)
459: --
460: -- Post Success
461: -- Processing continues if the survey_type_code
462: -- exists in hr_standard_lookups.
463: --
464: -- Post Failure
465: -- An application error is raised and processing is terminated
466: -- if the survey_type_code does not exist in hr_standard_lookups.

Line 466: -- if the survey_type_code does not exist in hr_standard_lookups.

462: -- exists in hr_standard_lookups.
463: --
464: -- Post Failure
465: -- An application error is raised and processing is terminated
466: -- if the survey_type_code does not exist in hr_standard_lookups.
467: --
468: -- Developer/Implementation Notes
469: -- None.
470: --

Line 521: -- in hr_standard_lookups where the lookup_type is 'PAY_BASIS'

517: hr_utility.set_location(l_proc, 20);
518: --
519: -- If survey_type_code is not null then
520: -- Check if the survey_type_code value exists
521: -- in hr_standard_lookups where the lookup_type is 'PAY_BASIS'
522: --
523: if hr_api.not_exists_in_hrstanlookups
524: (p_effective_date => p_effective_date
525: ,p_lookup_type => 'PAY_BASIS'