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.IGS_AD_IMP_025 dependencies on IGS_PE_PERS_IMP_001

Line 277: IF NOT(igs_pe_pers_imp_001.validate_lookup_type_code('PE_TEA_PER_RES',p_housing_rec.teach_period_resid_stat_cd,8405))

273: l_error_code igs_pe_housing_int.error_code%TYPE;
274: l_rec VARCHAR2(1);
275: BEGIN
276: -- TEACH_PERIOD_RESID_STAT_CD
277: IF NOT(igs_pe_pers_imp_001.validate_lookup_type_code('PE_TEA_PER_RES',p_housing_rec.teach_period_resid_stat_cd,8405))
278: THEN
279: l_error_code := 'E110'; -- Person Housing Status Validation Failed - Teaching Period Housing Status
280: RAISE NO_DATA_FOUND;
281: END IF;

Line 1599: IF NOT(igs_pe_pers_imp_001.validate_lookup_type_code('PE_RACE',p_race_rec.race_cd,8405))

1595: l_error_code igs_pe_race_int.error_code%TYPE;
1596: BEGIN
1597: -- Call Log header
1598:
1599: IF NOT(igs_pe_pers_imp_001.validate_lookup_type_code('PE_RACE',p_race_rec.race_cd,8405))
1600: THEN
1601: l_error_code := 'E580';
1602: RAISE NO_DATA_FOUND;
1603: END IF;

Line 2047: IF (NOT igs_pe_pers_imp_001.validate_lookup_type_code('PERSON_PRIVACY_ACTION',p_priv_rec.action_code,8405)) THEN

2043:
2044: END IF;
2045:
2046: --2.) Check the action code be a valid lookup code.
2047: IF (NOT igs_pe_pers_imp_001.validate_lookup_type_code('PERSON_PRIVACY_ACTION',p_priv_rec.action_code,8405)) THEN
2048: l_error_code := 'E353'; -- not a valid ACTION_CODE
2049: RAISE NO_DATA_FOUND;
2050: END IF;
2051:

Line 2052: --3.) Validate TO_WHOM_CODE column in the interface table. Call igs_pe_pers_imp_001.validate_lookup_type_code. If not validated, check in HZ_RELATIONSHIPS.

2048: l_error_code := 'E353'; -- not a valid ACTION_CODE
2049: RAISE NO_DATA_FOUND;
2050: END IF;
2051:
2052: --3.) Validate TO_WHOM_CODE column in the interface table. Call igs_pe_pers_imp_001.validate_lookup_type_code. If not validated, check in HZ_RELATIONSHIPS.
2053:
2054: IF (NOT igs_pe_pers_imp_001.validate_lookup_type_code('PERSON_PRIVACY_RELEASE',p_priv_rec.to_whom_code,8405))
2055: THEN
2056: l_exists := null;

Line 2054: IF (NOT igs_pe_pers_imp_001.validate_lookup_type_code('PERSON_PRIVACY_RELEASE',p_priv_rec.to_whom_code,8405))

2050: END IF;
2051:
2052: --3.) Validate TO_WHOM_CODE column in the interface table. Call igs_pe_pers_imp_001.validate_lookup_type_code. If not validated, check in HZ_RELATIONSHIPS.
2053:
2054: IF (NOT igs_pe_pers_imp_001.validate_lookup_type_code('PERSON_PRIVACY_RELEASE',p_priv_rec.to_whom_code,8405))
2055: THEN
2056: l_exists := null;
2057: OPEN chk_to_whom_code(p_priv_rec.person_id,p_priv_rec.to_whom_code);
2058: FETCH chk_to_whom_code INTO l_exists;