[Home] [Help]
11: -- GLOBAL VARIABLES AND CONSTANTS
12: --
13: G_SSN_Person_Id_Type IGS_PE_PERSON_ID_TYP.PERSON_ID_TYPE%TYPE;
14: G_ACT_Person_Id_Type IGS_PE_PERSON_ID_TYP.PERSON_ID_TYPE%TYPE;
15: G_Score_Source_id IGS_AD_CODE_CLASSES.CODE_ID%TYPE;
16: G_Transcript_Source IGS_AD_CODE_CLASSES.CODE_ID%TYPE;
17: G_Grading_Scale IGS_AD_CODE_CLASSES.CODE_ID%TYPE;
18: G_Unit_Difficulty IGS_AD_CODE_CLASSES.CODE_ID%TYPE;
19: --*****************************************************************************
12: --
13: G_SSN_Person_Id_Type IGS_PE_PERSON_ID_TYP.PERSON_ID_TYPE%TYPE;
14: G_ACT_Person_Id_Type IGS_PE_PERSON_ID_TYP.PERSON_ID_TYPE%TYPE;
15: G_Score_Source_id IGS_AD_CODE_CLASSES.CODE_ID%TYPE;
16: G_Transcript_Source IGS_AD_CODE_CLASSES.CODE_ID%TYPE;
17: G_Grading_Scale IGS_AD_CODE_CLASSES.CODE_ID%TYPE;
18: G_Unit_Difficulty IGS_AD_CODE_CLASSES.CODE_ID%TYPE;
19: --*****************************************************************************
20:
13: G_SSN_Person_Id_Type IGS_PE_PERSON_ID_TYP.PERSON_ID_TYPE%TYPE;
14: G_ACT_Person_Id_Type IGS_PE_PERSON_ID_TYP.PERSON_ID_TYPE%TYPE;
15: G_Score_Source_id IGS_AD_CODE_CLASSES.CODE_ID%TYPE;
16: G_Transcript_Source IGS_AD_CODE_CLASSES.CODE_ID%TYPE;
17: G_Grading_Scale IGS_AD_CODE_CLASSES.CODE_ID%TYPE;
18: G_Unit_Difficulty IGS_AD_CODE_CLASSES.CODE_ID%TYPE;
19: --*****************************************************************************
20:
21: /* This function is used to generate the batch_id into the ASSESSMENT Table through SQL Loader Process */
14: G_ACT_Person_Id_Type IGS_PE_PERSON_ID_TYP.PERSON_ID_TYPE%TYPE;
15: G_Score_Source_id IGS_AD_CODE_CLASSES.CODE_ID%TYPE;
16: G_Transcript_Source IGS_AD_CODE_CLASSES.CODE_ID%TYPE;
17: G_Grading_Scale IGS_AD_CODE_CLASSES.CODE_ID%TYPE;
18: G_Unit_Difficulty IGS_AD_CODE_CLASSES.CODE_ID%TYPE;
19: --*****************************************************************************
20:
21: /* This function is used to generate the batch_id into the ASSESSMENT Table through SQL Loader Process */
22: FUNCTION get_batch_id RETURN NUMBER;