APPS.IGS_AD_ACT_ASSESSMENTS_PKG dependencies on STANDARD

Line 123: -- Cursor to check and select the corresponding cod_id for Unit_Difficulty = STANDARD

119: AND CLOSED_IND = 'N'
120: AND NAME = '4 POINT'
121: AND CLASS_TYPE_CODE='ADM_CODE_CLASSES';
122:
123: -- Cursor to check and select the corresponding cod_id for Unit_Difficulty = STANDARD
124: CURSOR c_Unit_Difficulty IS
125: SELECT
126: CODE_ID
127: FROM IGS_AD_CODE_CLASSES

Line 130: AND NAME = 'STANDARD'

126: CODE_ID
127: FROM IGS_AD_CODE_CLASSES
128: WHERE CLASS = 'UNIT_DIFFICULTY'
129: AND CLOSED_IND = 'N'
130: AND NAME = 'STANDARD'
131: AND CLASS_TYPE_CODE='ADM_CODE_CLASSES';
132:
133: -- Cursor to Check the Assessments Grade Level Setup.
134: CURSOR c_Assessment_grade_level ( cp_ACT_Batch_Id IGS_AD_ACT_ASSESSMENTS.ACT_BATCH_ID%type,

Line 302: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Unit Difficulty of STANDARD is not defined in Transcript Information Setup.');

298: OPEN c_Unit_Difficulty;
299: FETCH c_Unit_Difficulty INTO G_Unit_Difficulty;
300: IF c_Unit_Difficulty%NOTFOUND THEN
301: CLOSE c_Unit_Difficulty;
302: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Unit Difficulty of STANDARD is not defined in Transcript Information Setup.');
303: l_return := 1;
304: ELSE
305: CLOSE c_Unit_Difficulty;
306: END IF;