[Home] [Help]
2133: p_admission_appl_number IN NUMBER,
2134: p_nominated_course_cd IN VARCHAR,
2135: p_sequence_number IN NUMBER,
2136: p_qualfying_type IN VARCHAR2 ) IS
2137: SELECT ac.rowid,ac.* FROM IGS_AD_APPQUAL_CODE ac WHERE
2138: PERSON_ID = p_person_id
2139: AND ADMISSION_APPL_NUMBER = p_admission_appl_number
2140: AND NOMINATED_COURSE_CD = p_nominated_course_cd
2141: AND SEQUENCE_NUMBER = p_sequence_number
2174: check_length('NOMINATED_COURSE_CD', 'IGS_AD_PS_APPL_INST_ALL', length(p_nominated_course_cd));
2175: -- P_SEQUENCE_NUMBER
2176: check_length('SEQUENCE_NUMBER', 'IGS_AD_PS_APPL_INST_ALL', length(TRUNC(p_sequence_number)));
2177: -- P_qualifying_type_code
2178: check_length('QUALIFYING_TYPE_CODE', 'IGS_AD_APPQUAL_CODE', length(p_qualifying_type_code));
2179: -- P_QUALIFYING_CODE
2180: check_length('NAME', 'IGS_AD_CODE_CLASSES', length(p_qualifying_code));
2181: -- P_QUALIFYING_VALUE
2182: check_length('QUALIFYING_VALUE', 'IGS_AD_APPQUAL_CODE', length(p_qualifying_value));
2178: check_length('QUALIFYING_TYPE_CODE', 'IGS_AD_APPQUAL_CODE', length(p_qualifying_type_code));
2179: -- P_QUALIFYING_CODE
2180: check_length('NAME', 'IGS_AD_CODE_CLASSES', length(p_qualifying_code));
2181: -- P_QUALIFYING_VALUE
2182: check_length('QUALIFYING_VALUE', 'IGS_AD_APPQUAL_CODE', length(p_qualifying_value));
2183: -- END OF PARAMETER VALIDATIONS.
2184:
2185: IF p_person_id = FND_API.G_MISS_NUM OR p_person_id IS NULL THEN
2186: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
2326: IGS_GE_MSG_STACK.ADD;
2327: RAISE FND_API.G_EXC_ERROR;
2328: END IF;
2329: --Call TBH
2330: igs_ad_appqual_code_pkg.UPDATE_ROW(
2331: x_rowid => l_qualtype.rowid,
2332: x_person_id => p_person_id,
2333: x_admission_appl_number => p_admission_appl_number,
2334: x_nominated_course_cd => p_nominated_course_cd,