APPS.IGS_AD_ACT_ASSESSMENTS_PKG dependencies on IGS_AD_CODE_CLASSES

Line 20: G_Score_Source_id IGS_AD_CODE_CLASSES.CODE_ID%TYPE;

16: -- GLOBAL VARIABLES AND CONSTANTS
17:
18: G_SSN_Person_Id_Type IGS_PE_PERSON_ID_TYP.PERSON_ID_TYPE%TYPE;
19: G_ACT_Person_Id_Type IGS_PE_PERSON_ID_TYP.PERSON_ID_TYPE%TYPE;
20: G_Score_Source_id IGS_AD_CODE_CLASSES.CODE_ID%TYPE;
21: G_Transcript_Source IGS_AD_CODE_CLASSES.CODE_ID%TYPE;
22: G_Grading_Scale IGS_AD_CODE_CLASSES.CODE_ID%TYPE;
23: G_Unit_Difficulty IGS_AD_CODE_CLASSES.CODE_ID%TYPE;
24:

Line 21: G_Transcript_Source IGS_AD_CODE_CLASSES.CODE_ID%TYPE;

17:
18: G_SSN_Person_Id_Type IGS_PE_PERSON_ID_TYP.PERSON_ID_TYPE%TYPE;
19: G_ACT_Person_Id_Type IGS_PE_PERSON_ID_TYP.PERSON_ID_TYPE%TYPE;
20: G_Score_Source_id IGS_AD_CODE_CLASSES.CODE_ID%TYPE;
21: G_Transcript_Source IGS_AD_CODE_CLASSES.CODE_ID%TYPE;
22: G_Grading_Scale IGS_AD_CODE_CLASSES.CODE_ID%TYPE;
23: G_Unit_Difficulty IGS_AD_CODE_CLASSES.CODE_ID%TYPE;
24:
25: ***************************************************************************** */

Line 22: G_Grading_Scale IGS_AD_CODE_CLASSES.CODE_ID%TYPE;

18: G_SSN_Person_Id_Type IGS_PE_PERSON_ID_TYP.PERSON_ID_TYPE%TYPE;
19: G_ACT_Person_Id_Type IGS_PE_PERSON_ID_TYP.PERSON_ID_TYPE%TYPE;
20: G_Score_Source_id IGS_AD_CODE_CLASSES.CODE_ID%TYPE;
21: G_Transcript_Source IGS_AD_CODE_CLASSES.CODE_ID%TYPE;
22: G_Grading_Scale IGS_AD_CODE_CLASSES.CODE_ID%TYPE;
23: G_Unit_Difficulty IGS_AD_CODE_CLASSES.CODE_ID%TYPE;
24:
25: ***************************************************************************** */
26:

Line 23: G_Unit_Difficulty IGS_AD_CODE_CLASSES.CODE_ID%TYPE;

19: G_ACT_Person_Id_Type IGS_PE_PERSON_ID_TYP.PERSON_ID_TYPE%TYPE;
20: G_Score_Source_id IGS_AD_CODE_CLASSES.CODE_ID%TYPE;
21: G_Transcript_Source IGS_AD_CODE_CLASSES.CODE_ID%TYPE;
22: G_Grading_Scale IGS_AD_CODE_CLASSES.CODE_ID%TYPE;
23: G_Unit_Difficulty IGS_AD_CODE_CLASSES.CODE_ID%TYPE;
24:
25: ***************************************************************************** */
26:
27:

Line 97: FROM IGS_AD_CODE_CLASSES

93: -- Cursor to check and select the corresponding cod_id for Test_Score_Source = ELEC
94: CURSOR c_Test_Score_Source IS
95: SELECT
96: CODE_ID
97: FROM IGS_AD_CODE_CLASSES
98: WHERE CLASS = 'SYS_SCORE_SOURCE'
99: AND NAME = 'ELEC'
100: AND CLOSED_IND = 'N'
101: AND CLASS_TYPE_CODE='ADM_CODE_CLASSES';

Line 107: FROM IGS_AD_CODE_CLASSES

103: -- Cursor to check and select the corresponding cod_id for Transcript_Source = ACT
104: CURSOR c_Transcript_Source IS
105: SELECT
106: CODE_ID
107: FROM IGS_AD_CODE_CLASSES
108: WHERE CLASS = 'TRANSCRIPT_SOURCE'
109: AND CLOSED_IND = 'N'
110: AND NAME = 'ACT'
111: AND CLASS_TYPE_CODE='ADM_CODE_CLASSES';

Line 117: FROM IGS_AD_CODE_CLASSES

113: -- Cursor to check and select the corresponding cod_id for Grading_Scale = 4 POINT
114: CURSOR c_Grading_Scale IS
115: SELECT
116: CODE_ID
117: FROM IGS_AD_CODE_CLASSES
118: WHERE CLASS = 'GRADING_SCALE_TYPES'
119: AND CLOSED_IND = 'N'
120: AND NAME = '4 POINT'
121: AND CLASS_TYPE_CODE='ADM_CODE_CLASSES';

Line 127: FROM IGS_AD_CODE_CLASSES

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
128: WHERE CLASS = 'UNIT_DIFFICULTY'
129: AND CLOSED_IND = 'N'
130: AND NAME = 'STANDARD'
131: AND CLASS_TYPE_CODE='ADM_CODE_CLASSES';

Line 152: FROM IGS_AD_CODE_CLASSES

148: AND actas.Grade_Level IS NOT NULL
149: MINUS
150: SELECT
151: NAME LEVEL_OF_QUAL
152: FROM IGS_AD_CODE_CLASSES
153: WHERE CLASS ='LEVEL_OF_QUAL'
154: AND CLOSED_IND = 'N'
155: AND CLASS_TYPE_CODE='ADM_CODE_CLASSES';
156:

Line 381: IGS_AD_CODE_CLASSES cc

377: cp_ACT_Id IGS_AD_ACT_ASSESSMENTS.act_identifier%type) IS
378: SELECT
379: actas.ROWID, actas.*,cc.code_id
380: FROM IGS_AD_ACT_ASSESSMENTS actas,
381: IGS_AD_CODE_CLASSES cc
382: WHERE actas.ACT_Batch_ID = cp_ACT_Batch_Id
383: AND actas.Reporting_Year like nvl(cp_Reporting_Year,'%')
384: AND actas.Test_Type like nvl(cp_Test_Type,'%')
385: AND actas.TEST_DATE_TXT like nvl(cp_Test_Date,'%')

Line 620: Act_Assessment_rec.code_id, -- Grade level need to be defined in IGS_AD_CODE_CLASSES

616: Act_Assessment_rec.middle_initial,
617: Act_Assessment_rec.first_name,
618: Decode(upper(Act_Assessment_rec.gender),'M','MALE','F','FEMALE','UNKNOWN'),
619: to_date(Act_Assessment_rec.date_of_birth_txt,'YYYYMMDD'),
620: Act_Assessment_rec.code_id, -- Grade level need to be defined in IGS_AD_CODE_CLASSES
621: --WHERE CLASS ='LEVEL_OF_QUAL' code_id is retrieved from the code_classes table
622: '2',
623: '2',
624: FND_GLOBAL.USER_ID,