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_KW_VALIDATE_PKG dependencies on HR_API

Line 195: if p_per_information_category = 'KW' and (p_per_information8 is not null and p_per_information8 <> hr_api.g_varchar2 ) then

191: IF hr_utility.chk_product_install('Oracle Human Resources', 'KW') THEN
192:
193: if g_type IS NOT NULL THEN
194:
195: if p_per_information_category = 'KW' and (p_per_information8 is not null and p_per_information8 <> hr_api.g_varchar2 ) then
196: --
197: -- Check that the religion exists in hr_lookups for the
198: -- lookup type 'GCC_RELIGION' with an enabled flag set to 'Y' and that
199: -- the effective start date of the person is between start date

Line 202: if hr_api.not_exists_in_hr_lookups

198: -- lookup type 'GCC_RELIGION' with an enabled flag set to 'Y' and that
199: -- the effective start date of the person is between start date
200: -- active and end date active in hr_lookups.
201: --
202: if hr_api.not_exists_in_hr_lookups
203: (p_effective_date => p_effective_date
204: ,p_lookup_type => 'GCC_RELIGION'
205: ,p_lookup_code => p_per_information8
206: )

Line 217: if p_per_information_category = 'KW' and (p_per_information7 is not null and p_per_information7 <> hr_api.g_varchar2 )then

213: end if;
214:
215: /* Added for previous nationality check */
216:
217: if p_per_information_category = 'KW' and (p_per_information7 is not null and p_per_information7 <> hr_api.g_varchar2 )then
218:
219: if hr_api.not_exists_in_hr_lookups
220: (p_effective_date => p_effective_date
221: ,p_lookup_type => 'NATIONALITY'

Line 219: if hr_api.not_exists_in_hr_lookups

215: /* Added for previous nationality check */
216:
217: if p_per_information_category = 'KW' and (p_per_information7 is not null and p_per_information7 <> hr_api.g_varchar2 )then
218:
219: if hr_api.not_exists_in_hr_lookups
220: (p_effective_date => p_effective_date
221: ,p_lookup_type => 'NATIONALITY'
222: ,p_lookup_code => p_per_information7
223: )

Line 288: if p_per_information_category = 'KW' and (p_per_information8 is not null and p_per_information8 <> hr_api.g_varchar2 ) then

284: IF hr_utility.chk_product_install('Oracle Human Resources', 'KW') THEN
285:
286: if g_type IS NOT NULL THEN
287:
288: if p_per_information_category = 'KW' and (p_per_information8 is not null and p_per_information8 <> hr_api.g_varchar2 ) then
289: --
290: -- Check that the religion exists in hr_lookups for the
291: -- lookup type 'GCC_RELIGION' with an enabled flag set to 'Y' and that
292: -- the effective start date of the person is between start date

Line 295: if hr_api.not_exists_in_hr_lookups

291: -- lookup type 'GCC_RELIGION' with an enabled flag set to 'Y' and that
292: -- the effective start date of the person is between start date
293: -- active and end date active in hr_lookups.
294: --
295: if hr_api.not_exists_in_hr_lookups
296: (p_effective_date => p_date_received
297: ,p_lookup_type => 'GCC_RELIGION'
298: ,p_lookup_code => p_per_information8
299: )

Line 309: if p_per_information_category = 'KW' and (p_per_information7 is not null and p_per_information7 <> hr_api.g_varchar2 ) then

305: end if;
306: end if;
307:
308: /* Added for previous nationality check */
309: if p_per_information_category = 'KW' and (p_per_information7 is not null and p_per_information7 <> hr_api.g_varchar2 ) then
310:
311: if hr_api.not_exists_in_hr_lookups
312: (p_effective_date => p_date_received
313: ,p_lookup_type => 'NATIONALITY'

Line 311: if hr_api.not_exists_in_hr_lookups

307:
308: /* Added for previous nationality check */
309: if p_per_information_category = 'KW' and (p_per_information7 is not null and p_per_information7 <> hr_api.g_varchar2 ) then
310:
311: if hr_api.not_exists_in_hr_lookups
312: (p_effective_date => p_date_received
313: ,p_lookup_type => 'NATIONALITY'
314: ,p_lookup_code => p_per_information7
315: )

Line 380: if p_per_information_category = 'KW' and (p_per_information8 is not null and p_per_information8 <> hr_api.g_varchar2 ) then

376: /* Added for GSI Bug 5472781 */
377: IF hr_utility.chk_product_install('Oracle Human Resources', 'KW') THEN
378:
379: if g_type IS NOT NULL THEN
380: if p_per_information_category = 'KW' and (p_per_information8 is not null and p_per_information8 <> hr_api.g_varchar2 ) then
381: --
382: -- Check that the religion exists in hr_lookups for the
383: -- lookup type 'GCC_RELIGION' with an enabled flag set to 'Y' and that
384: -- the effective start date of the person is between start date

Line 387: if hr_api.not_exists_in_hr_lookups

383: -- lookup type 'GCC_RELIGION' with an enabled flag set to 'Y' and that
384: -- the effective start date of the person is between start date
385: -- active and end date active in hr_lookups.
386: --
387: if hr_api.not_exists_in_hr_lookups
388: (p_effective_date => p_hire_date
389: ,p_lookup_type => 'GCC_RELIGION'
390: ,p_lookup_code => p_per_information8
391: )

Line 401: if p_per_information_category = 'KW' and (p_per_information7 is not null and p_per_information7 <> hr_api.g_varchar2 ) then

397: end if;
398: end if;
399:
400: /* Added for previous nationality check */
401: if p_per_information_category = 'KW' and (p_per_information7 is not null and p_per_information7 <> hr_api.g_varchar2 ) then
402:
403: if hr_api.not_exists_in_hr_lookups
404: (p_effective_date => p_hire_date
405: ,p_lookup_type => 'NATIONALITY'

Line 403: if hr_api.not_exists_in_hr_lookups

399:
400: /* Added for previous nationality check */
401: if p_per_information_category = 'KW' and (p_per_information7 is not null and p_per_information7 <> hr_api.g_varchar2 ) then
402:
403: if hr_api.not_exists_in_hr_lookups
404: (p_effective_date => p_hire_date
405: ,p_lookup_type => 'NATIONALITY'
406: ,p_lookup_code => p_per_information7
407: )

Line 473: if p_per_information_category = 'KW' and (p_per_information8 is not null and p_per_information8 <> hr_api.g_varchar2 ) then

469: /* Added for GSI Bug 5472781 */
470: IF hr_utility.chk_product_install('Oracle Human Resources', 'KW') THEN
471:
472: if g_type IS NOT NULL THEN
473: if p_per_information_category = 'KW' and (p_per_information8 is not null and p_per_information8 <> hr_api.g_varchar2 ) then
474: --
475: -- Check that the religion exists in hr_lookups for the
476: -- lookup type 'GCC_RELIGION' with an enabled flag set to 'Y' and that
477: -- the effective start date of the person is between start date

Line 480: if hr_api.not_exists_in_hr_lookups

476: -- lookup type 'GCC_RELIGION' with an enabled flag set to 'Y' and that
477: -- the effective start date of the person is between start date
478: -- active and end date active in hr_lookups.
479: --
480: if hr_api.not_exists_in_hr_lookups
481: (p_effective_date => p_start_date
482: ,p_lookup_type => 'GCC_RELIGION'
483: ,p_lookup_code => p_per_information8
484: )

Line 494: if p_per_information_category = 'KW' and (p_per_information7 is not null and p_per_information7 <> hr_api.g_varchar2 ) then

490: end if;
491: end if;
492:
493: /* Added for previous nationality check */
494: if p_per_information_category = 'KW' and (p_per_information7 is not null and p_per_information7 <> hr_api.g_varchar2 ) then
495:
496: if hr_api.not_exists_in_hr_lookups
497: (p_effective_date => p_start_date
498: ,p_lookup_type => 'NATIONALITY'

Line 496: if hr_api.not_exists_in_hr_lookups

492:
493: /* Added for previous nationality check */
494: if p_per_information_category = 'KW' and (p_per_information7 is not null and p_per_information7 <> hr_api.g_varchar2 ) then
495:
496: if hr_api.not_exists_in_hr_lookups
497: (p_effective_date => p_start_date
498: ,p_lookup_type => 'NATIONALITY'
499: ,p_lookup_code => p_per_information7
500: )

Line 564: if p_per_information_category = 'KW' and (p_per_information8 is not null and p_per_information8 <> hr_api.g_varchar2 ) then

560: /* Added for GSI Bug 5472781 */
561: IF hr_utility.chk_product_install('Oracle Human Resources', 'KW') THEN
562:
563: if g_type IS NOT NULL THEN
564: if p_per_information_category = 'KW' and (p_per_information8 is not null and p_per_information8 <> hr_api.g_varchar2 ) then
565: --
566: -- Check that the religion exists in hr_lookups for the
567: -- lookup type 'GCC_RELIGION' with an enabled flag set to 'Y' and that
568: -- the effective start date of the person is between start date

Line 571: if hr_api.not_exists_in_hr_lookups

567: -- lookup type 'GCC_RELIGION' with an enabled flag set to 'Y' and that
568: -- the effective start date of the person is between start date
569: -- active and end date active in hr_lookups.
570: --
571: if hr_api.not_exists_in_hr_lookups
572: (p_effective_date => p_start_date
573: ,p_lookup_type => 'GCC_RELIGION'
574: ,p_lookup_code => p_per_information8
575: )

Line 585: if p_per_information_category = 'KW' and (p_per_information7 is not null and p_per_information7 <> hr_api.g_varchar2 ) then

581: end if;
582: end if;
583:
584: /* Added for previous nationality check */
585: if p_per_information_category = 'KW' and (p_per_information7 is not null and p_per_information7 <> hr_api.g_varchar2 ) then
586:
587: if hr_api.not_exists_in_hr_lookups
588: (p_effective_date => p_start_date
589: ,p_lookup_type => 'NATIONALITY'

Line 587: if hr_api.not_exists_in_hr_lookups

583:
584: /* Added for previous nationality check */
585: if p_per_information_category = 'KW' and (p_per_information7 is not null and p_per_information7 <> hr_api.g_varchar2 ) then
586:
587: if hr_api.not_exists_in_hr_lookups
588: (p_effective_date => p_start_date
589: ,p_lookup_type => 'NATIONALITY'
590: ,p_lookup_code => p_per_information7
591: )

Line 632: IF hr_api.not_exists_in_hr_lookups

628: -- Check that the employment status exists in hr_lookups for the
629: -- lookup type 'KW_EMPLOYMENT_STATUS' with an enabled flag set to 'Y'
630: --
631: IF p_ctr_information1 IS NOT NULL THEN
632: IF hr_api.not_exists_in_hr_lookups
633: (p_effective_date => p_effective_date
634: ,p_lookup_type => 'KW_EMPLOYMENT_STATUS'
635: ,p_lookup_code => p_ctr_information1
636: )

Line 662: (p_employer_name IN varchar2 default hr_api.g_varchar2

658: END CONTRACT_VALIDATE;
659:
660: --Procedure for validating previous_employer
661: PROCEDURE PREVIOUS_EMPLOYER_VALIDATE
662: (p_employer_name IN varchar2 default hr_api.g_varchar2
663: ,p_effective_date IN date default hr_api.g_date
664: ,p_pem_information_category IN varchar2 default hr_api.g_varchar2
665: ,p_pem_information1 IN varchar2 default hr_api.g_varchar2
666: ) IS

Line 663: ,p_effective_date IN date default hr_api.g_date

659:
660: --Procedure for validating previous_employer
661: PROCEDURE PREVIOUS_EMPLOYER_VALIDATE
662: (p_employer_name IN varchar2 default hr_api.g_varchar2
663: ,p_effective_date IN date default hr_api.g_date
664: ,p_pem_information_category IN varchar2 default hr_api.g_varchar2
665: ,p_pem_information1 IN varchar2 default hr_api.g_varchar2
666: ) IS
667:

Line 664: ,p_pem_information_category IN varchar2 default hr_api.g_varchar2

660: --Procedure for validating previous_employer
661: PROCEDURE PREVIOUS_EMPLOYER_VALIDATE
662: (p_employer_name IN varchar2 default hr_api.g_varchar2
663: ,p_effective_date IN date default hr_api.g_date
664: ,p_pem_information_category IN varchar2 default hr_api.g_varchar2
665: ,p_pem_information1 IN varchar2 default hr_api.g_varchar2
666: ) IS
667:
668: v_field VARCHAR2(300);

Line 665: ,p_pem_information1 IN varchar2 default hr_api.g_varchar2

661: PROCEDURE PREVIOUS_EMPLOYER_VALIDATE
662: (p_employer_name IN varchar2 default hr_api.g_varchar2
663: ,p_effective_date IN date default hr_api.g_date
664: ,p_pem_information_category IN varchar2 default hr_api.g_varchar2
665: ,p_pem_information1 IN varchar2 default hr_api.g_varchar2
666: ) IS
667:
668: v_field VARCHAR2(300);
669:

Line 690: IF hr_api.not_exists_in_hr_lookups

686: hr_utility.raise_error;
687: END IF;
688:
689: IF p_pem_information1 IS NOT NULL THEN
690: IF hr_api.not_exists_in_hr_lookups
691: (p_effective_date => p_effective_date
692: ,p_lookup_type => 'LEAV_REAS'
693: ,p_lookup_code => p_pem_information1
694: )