[Home] [Help]
76:
77: --ALIAS_TYPE
78: --SQL for validation:
79: IF NOT
80: (igs_pe_pers_imp_001.validate_lookup_type_code('PE_ALIAS_TYPE',person_alias_rec.alias_type,8405))
81: THEN
82: l_error_code := 'E221'; -- Validation Unsuccessful
83: UPDATE igs_ad_alias_int_all
84: SET STATUS = '3',
361:
362: --TYPE_OF_EMPLOYMENT
363: -- Modified to validate type_of_employment from lookup values
364: IF PERSON_EMP_REC.TYPE_OF_EMPLOYMENT IS NOT NULL THEN
365: IF NOT (igs_pe_pers_imp_001.validate_lookup_type_code('HZ_EMPLOYMENT_TYPE',PERSON_EMP_REC.TYPE_OF_EMPLOYMENT,222)) THEN
366: p_error_code := 'E224';
367:
368: UPDATE IGS_AD_EMP_INT_ALL
369: SET Error_Code = p_error_code,
394:
395: --TENURE_OF_EMPLOYMENT
396: --Modified to validate tenure_of_employment from lookup values
397: IF PERSON_EMP_REC.TENURE_OF_EMPLOYMENT IS NOT NULL THEN
398: IF NOT (igs_pe_pers_imp_001.validate_lookup_type_code('HZ_TENURE_CODE',PERSON_EMP_REC.TENURE_OF_EMPLOYMENT,222))THEN
399: --Validation Unsuccessful
400: p_error_code := 'E226';
401: UPDATE IGS_AD_EMP_INT_ALL
402: SET Error_Code = p_error_code,
988:
989: --LEVEL_OF_PARTICIPATION
990: IF EXTRACURR_REC.LEVEL_OF_PARTICIPATION IS NOT NULL THEN
991: IF NOT
992: (igs_pe_pers_imp_001.validate_lookup_type_code('PARTICIPATION_LEVEL',extracurr_rec.level_of_participation,222))
993: THEN
994: p_error_code := 'E233';
995: RAISE no_data_found;
996: END IF;
1084: p_error_code := 'E216';
1085: RAISE NO_DATA_FOUND;
1086: ELSE
1087: IF NOT
1088: (igs_pe_pers_imp_001.validate_lookup_type_code(extracurr_rec.sub_interest_type_code,extracurr_rec.interest_type_code,222))
1089: THEN
1090: p_error_code := 'E254';
1091: RAISE NO_DATA_FOUND;
1092: END IF;
1094:
1095: ELSE
1096: IF EXTRACURR_REC.INTEREST_TYPE_CODE IS NOT NULL THEN
1097: IF NOT
1098: (igs_pe_pers_imp_001.validate_lookup_type_code('INTEREST_TYPE',extracurr_rec.interest_type_code,222))
1099: OR
1100: (igs_pe_pers_imp_001.validate_lookup_type_code('ENTERTAINMENT',extracurr_rec.interest_type_code,222))
1101: THEN
1102: p_error_code := 'E232';
1096: IF EXTRACURR_REC.INTEREST_TYPE_CODE IS NOT NULL THEN
1097: IF NOT
1098: (igs_pe_pers_imp_001.validate_lookup_type_code('INTEREST_TYPE',extracurr_rec.interest_type_code,222))
1099: OR
1100: (igs_pe_pers_imp_001.validate_lookup_type_code('ENTERTAINMENT',extracurr_rec.interest_type_code,222))
1101: THEN
1102: p_error_code := 'E232';
1103: RAISE no_data_found;
1104: END IF;
1108: -- added Activity Source CD as part of ID prospective applicant part 2 of 1
1109: --ACTIVITY SOURCE CD
1110: IF EXTRACURR_REC.ACTIVITY_SOURCE_CD IS NOT NULL THEN
1111: IF NOT
1112: (igs_pe_pers_imp_001.validate_lookup_type_code('ACTIVITY_SOURCE',EXTRACURR_REC.ACTIVITY_SOURCE_CD,8405))
1113: THEN
1114: p_error_code := 'E230';
1115: RAISE NO_DATA_FOUND;
1116: END IF;
1176:
1177: IF l_error_code IS NULL THEN
1178: IF EXTRACURR_REC.INTEREST_TYPE_CODE IS NOT NULL AND EXTRACURR_REC.SUB_INTEREST_TYPE_CODE IS NULL THEN
1179: IF NOT
1180: (igs_pe_pers_imp_001.validate_lookup_type_code('INTEREST_TYPE',extracurr_rec.interest_type_code,222))
1181: OR
1182: (igs_pe_pers_imp_001.validate_lookup_type_code('ENTERTAINMENT',extracurr_rec.interest_type_code,222))
1183: THEN
1184: RAISE NO_DATA_FOUND;
1178: IF EXTRACURR_REC.INTEREST_TYPE_CODE IS NOT NULL AND EXTRACURR_REC.SUB_INTEREST_TYPE_CODE IS NULL THEN
1179: IF NOT
1180: (igs_pe_pers_imp_001.validate_lookup_type_code('INTEREST_TYPE',extracurr_rec.interest_type_code,222))
1181: OR
1182: (igs_pe_pers_imp_001.validate_lookup_type_code('ENTERTAINMENT',extracurr_rec.interest_type_code,222))
1183: THEN
1184: RAISE NO_DATA_FOUND;
1185: END IF;
1186: ELSE