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 183: if p_per_information_category = 'KW' and (p_per_information8 is not null and p_per_information8 <> hr_api.g_varchar2 ) then

179: IF hr_utility.chk_product_install('Oracle Human Resources', 'KW') THEN
180:
181: if g_type IS NOT NULL THEN
182:
183: if p_per_information_category = 'KW' and (p_per_information8 is not null and p_per_information8 <> hr_api.g_varchar2 ) then
184: --
185: -- Check that the religion exists in hr_lookups for the
186: -- lookup type 'GCC_RELIGION' with an enabled flag set to 'Y' and that
187: -- the effective start date of the person is between start date

Line 190: if hr_api.not_exists_in_hr_lookups

186: -- lookup type 'GCC_RELIGION' with an enabled flag set to 'Y' and that
187: -- the effective start date of the person is between start date
188: -- active and end date active in hr_lookups.
189: --
190: if hr_api.not_exists_in_hr_lookups
191: (p_effective_date => p_effective_date
192: ,p_lookup_type => 'GCC_RELIGION'
193: ,p_lookup_code => p_per_information8
194: )

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

201: end if;
202:
203: /* Added for previous nationality check */
204:
205: if p_per_information_category = 'KW' and (p_per_information7 is not null and p_per_information7 <> hr_api.g_varchar2 )then
206:
207: if hr_api.not_exists_in_hr_lookups
208: (p_effective_date => p_effective_date
209: ,p_lookup_type => 'NATIONALITY'

Line 207: if hr_api.not_exists_in_hr_lookups

203: /* Added for previous nationality check */
204:
205: if p_per_information_category = 'KW' and (p_per_information7 is not null and p_per_information7 <> hr_api.g_varchar2 )then
206:
207: if hr_api.not_exists_in_hr_lookups
208: (p_effective_date => p_effective_date
209: ,p_lookup_type => 'NATIONALITY'
210: ,p_lookup_code => p_per_information7
211: )

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

272: IF hr_utility.chk_product_install('Oracle Human Resources', 'KW') THEN
273:
274: if g_type IS NOT NULL THEN
275:
276: if p_per_information_category = 'KW' and (p_per_information8 is not null and p_per_information8 <> hr_api.g_varchar2 ) then
277: --
278: -- Check that the religion exists in hr_lookups for the
279: -- lookup type 'GCC_RELIGION' with an enabled flag set to 'Y' and that
280: -- the effective start date of the person is between start date

Line 283: if hr_api.not_exists_in_hr_lookups

279: -- lookup type 'GCC_RELIGION' with an enabled flag set to 'Y' and that
280: -- the effective start date of the person is between start date
281: -- active and end date active in hr_lookups.
282: --
283: if hr_api.not_exists_in_hr_lookups
284: (p_effective_date => p_date_received
285: ,p_lookup_type => 'GCC_RELIGION'
286: ,p_lookup_code => p_per_information8
287: )

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

293: end if;
294: end if;
295:
296: /* Added for previous nationality check */
297: if p_per_information_category = 'KW' and (p_per_information7 is not null and p_per_information7 <> hr_api.g_varchar2 ) then
298:
299: if hr_api.not_exists_in_hr_lookups
300: (p_effective_date => p_date_received
301: ,p_lookup_type => 'NATIONALITY'

Line 299: if hr_api.not_exists_in_hr_lookups

295:
296: /* Added for previous nationality check */
297: if p_per_information_category = 'KW' and (p_per_information7 is not null and p_per_information7 <> hr_api.g_varchar2 ) then
298:
299: if hr_api.not_exists_in_hr_lookups
300: (p_effective_date => p_date_received
301: ,p_lookup_type => 'NATIONALITY'
302: ,p_lookup_code => p_per_information7
303: )

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

364: /* Added for GSI Bug 5472781 */
365: IF hr_utility.chk_product_install('Oracle Human Resources', 'KW') THEN
366:
367: if g_type IS NOT NULL THEN
368: if p_per_information_category = 'KW' and (p_per_information8 is not null and p_per_information8 <> hr_api.g_varchar2 ) then
369: --
370: -- Check that the religion exists in hr_lookups for the
371: -- lookup type 'GCC_RELIGION' with an enabled flag set to 'Y' and that
372: -- the effective start date of the person is between start date

Line 375: if hr_api.not_exists_in_hr_lookups

371: -- lookup type 'GCC_RELIGION' with an enabled flag set to 'Y' and that
372: -- the effective start date of the person is between start date
373: -- active and end date active in hr_lookups.
374: --
375: if hr_api.not_exists_in_hr_lookups
376: (p_effective_date => p_hire_date
377: ,p_lookup_type => 'GCC_RELIGION'
378: ,p_lookup_code => p_per_information8
379: )

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

385: end if;
386: end if;
387:
388: /* Added for previous nationality check */
389: if p_per_information_category = 'KW' and (p_per_information7 is not null and p_per_information7 <> hr_api.g_varchar2 ) then
390:
391: if hr_api.not_exists_in_hr_lookups
392: (p_effective_date => p_hire_date
393: ,p_lookup_type => 'NATIONALITY'

Line 391: if hr_api.not_exists_in_hr_lookups

387:
388: /* Added for previous nationality check */
389: if p_per_information_category = 'KW' and (p_per_information7 is not null and p_per_information7 <> hr_api.g_varchar2 ) then
390:
391: if hr_api.not_exists_in_hr_lookups
392: (p_effective_date => p_hire_date
393: ,p_lookup_type => 'NATIONALITY'
394: ,p_lookup_code => p_per_information7
395: )

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

457: /* Added for GSI Bug 5472781 */
458: IF hr_utility.chk_product_install('Oracle Human Resources', 'KW') THEN
459:
460: if g_type IS NOT NULL THEN
461: if p_per_information_category = 'KW' and (p_per_information8 is not null and p_per_information8 <> hr_api.g_varchar2 ) then
462: --
463: -- Check that the religion exists in hr_lookups for the
464: -- lookup type 'GCC_RELIGION' with an enabled flag set to 'Y' and that
465: -- the effective start date of the person is between start date

Line 468: if hr_api.not_exists_in_hr_lookups

464: -- lookup type 'GCC_RELIGION' with an enabled flag set to 'Y' and that
465: -- the effective start date of the person is between start date
466: -- active and end date active in hr_lookups.
467: --
468: if hr_api.not_exists_in_hr_lookups
469: (p_effective_date => p_start_date
470: ,p_lookup_type => 'GCC_RELIGION'
471: ,p_lookup_code => p_per_information8
472: )

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

478: end if;
479: end if;
480:
481: /* Added for previous nationality check */
482: if p_per_information_category = 'KW' and (p_per_information7 is not null and p_per_information7 <> hr_api.g_varchar2 ) then
483:
484: if hr_api.not_exists_in_hr_lookups
485: (p_effective_date => p_start_date
486: ,p_lookup_type => 'NATIONALITY'

Line 484: if hr_api.not_exists_in_hr_lookups

480:
481: /* Added for previous nationality check */
482: if p_per_information_category = 'KW' and (p_per_information7 is not null and p_per_information7 <> hr_api.g_varchar2 ) then
483:
484: if hr_api.not_exists_in_hr_lookups
485: (p_effective_date => p_start_date
486: ,p_lookup_type => 'NATIONALITY'
487: ,p_lookup_code => p_per_information7
488: )

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

548: /* Added for GSI Bug 5472781 */
549: IF hr_utility.chk_product_install('Oracle Human Resources', 'KW') THEN
550:
551: if g_type IS NOT NULL THEN
552: if p_per_information_category = 'KW' and (p_per_information8 is not null and p_per_information8 <> hr_api.g_varchar2 ) then
553: --
554: -- Check that the religion exists in hr_lookups for the
555: -- lookup type 'GCC_RELIGION' with an enabled flag set to 'Y' and that
556: -- the effective start date of the person is between start date

Line 559: if hr_api.not_exists_in_hr_lookups

555: -- lookup type 'GCC_RELIGION' with an enabled flag set to 'Y' and that
556: -- the effective start date of the person is between start date
557: -- active and end date active in hr_lookups.
558: --
559: if hr_api.not_exists_in_hr_lookups
560: (p_effective_date => p_start_date
561: ,p_lookup_type => 'GCC_RELIGION'
562: ,p_lookup_code => p_per_information8
563: )

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

569: end if;
570: end if;
571:
572: /* Added for previous nationality check */
573: if p_per_information_category = 'KW' and (p_per_information7 is not null and p_per_information7 <> hr_api.g_varchar2 ) then
574:
575: if hr_api.not_exists_in_hr_lookups
576: (p_effective_date => p_start_date
577: ,p_lookup_type => 'NATIONALITY'

Line 575: if hr_api.not_exists_in_hr_lookups

571:
572: /* Added for previous nationality check */
573: if p_per_information_category = 'KW' and (p_per_information7 is not null and p_per_information7 <> hr_api.g_varchar2 ) then
574:
575: if hr_api.not_exists_in_hr_lookups
576: (p_effective_date => p_start_date
577: ,p_lookup_type => 'NATIONALITY'
578: ,p_lookup_code => p_per_information7
579: )

Line 620: IF hr_api.not_exists_in_hr_lookups

616: -- Check that the employment status exists in hr_lookups for the
617: -- lookup type 'KW_EMPLOYMENT_STATUS' with an enabled flag set to 'Y'
618: --
619: IF p_ctr_information1 IS NOT NULL THEN
620: IF hr_api.not_exists_in_hr_lookups
621: (p_effective_date => p_effective_date
622: ,p_lookup_type => 'KW_EMPLOYMENT_STATUS'
623: ,p_lookup_code => p_ctr_information1
624: )

Line 650: (p_employer_name IN varchar2 default hr_api.g_varchar2

646: END CONTRACT_VALIDATE;
647:
648: --Procedure for validating previous_employer
649: PROCEDURE PREVIOUS_EMPLOYER_VALIDATE
650: (p_employer_name IN varchar2 default hr_api.g_varchar2
651: ,p_effective_date IN date default hr_api.g_date
652: ,p_pem_information_category IN varchar2 default hr_api.g_varchar2
653: ,p_pem_information1 IN varchar2 default hr_api.g_varchar2
654: ) IS

Line 651: ,p_effective_date IN date default hr_api.g_date

647:
648: --Procedure for validating previous_employer
649: PROCEDURE PREVIOUS_EMPLOYER_VALIDATE
650: (p_employer_name IN varchar2 default hr_api.g_varchar2
651: ,p_effective_date IN date default hr_api.g_date
652: ,p_pem_information_category IN varchar2 default hr_api.g_varchar2
653: ,p_pem_information1 IN varchar2 default hr_api.g_varchar2
654: ) IS
655:

Line 652: ,p_pem_information_category IN varchar2 default hr_api.g_varchar2

648: --Procedure for validating previous_employer
649: PROCEDURE PREVIOUS_EMPLOYER_VALIDATE
650: (p_employer_name IN varchar2 default hr_api.g_varchar2
651: ,p_effective_date IN date default hr_api.g_date
652: ,p_pem_information_category IN varchar2 default hr_api.g_varchar2
653: ,p_pem_information1 IN varchar2 default hr_api.g_varchar2
654: ) IS
655:
656: v_field VARCHAR2(300);

Line 653: ,p_pem_information1 IN varchar2 default hr_api.g_varchar2

649: PROCEDURE PREVIOUS_EMPLOYER_VALIDATE
650: (p_employer_name IN varchar2 default hr_api.g_varchar2
651: ,p_effective_date IN date default hr_api.g_date
652: ,p_pem_information_category IN varchar2 default hr_api.g_varchar2
653: ,p_pem_information1 IN varchar2 default hr_api.g_varchar2
654: ) IS
655:
656: v_field VARCHAR2(300);
657:

Line 678: IF hr_api.not_exists_in_hr_lookups

674: hr_utility.raise_error;
675: END IF;
676:
677: IF p_pem_information1 IS NOT NULL THEN
678: IF hr_api.not_exists_in_hr_lookups
679: (p_effective_date => p_effective_date
680: ,p_lookup_type => 'LEAV_REAS'
681: ,p_lookup_code => p_pem_information1
682: )