DBA Data[Home] [Help]

APPS.IGS_AD_GEN_002 dependencies on IGS_AS_GRD_SCH_GRADE

Line 1306: cst_withdrawn CONSTANT IGS_AS_GRD_SCH_GRADE.s_result_type%TYPE :=

1302: cst_academic CONSTANT IGS_CA_TYPE.s_cal_cat%TYPE := 'ACADEMIC';
1303: cst_load CONSTANT IGS_CA_TYPE.s_cal_cat%TYPE := 'LOAD';
1304: cst_student_rec_type CONSTANT VARCHAR2(1) := 'M';
1305: cst_subject_rec_type CONSTANT VARCHAR2(1) := 'S';
1306: cst_withdrawn CONSTANT IGS_AS_GRD_SCH_GRADE.s_result_type%TYPE :=
1307: 'WITHDRAWN';
1308: cst_fail CONSTANT IGS_AS_GRD_SCH_GRADE.s_result_type%TYPE := 'FAIL';
1309: cst_pass CONSTANT IGS_AS_GRD_SCH_GRADE.s_result_type%TYPE := 'PASS';
1310: v_person_id IGS_PE_PERSON.person_id%TYPE;

Line 1308: cst_fail CONSTANT IGS_AS_GRD_SCH_GRADE.s_result_type%TYPE := 'FAIL';

1304: cst_student_rec_type CONSTANT VARCHAR2(1) := 'M';
1305: cst_subject_rec_type CONSTANT VARCHAR2(1) := 'S';
1306: cst_withdrawn CONSTANT IGS_AS_GRD_SCH_GRADE.s_result_type%TYPE :=
1307: 'WITHDRAWN';
1308: cst_fail CONSTANT IGS_AS_GRD_SCH_GRADE.s_result_type%TYPE := 'FAIL';
1309: cst_pass CONSTANT IGS_AS_GRD_SCH_GRADE.s_result_type%TYPE := 'PASS';
1310: v_person_id IGS_PE_PERSON.person_id%TYPE;
1311: v_surname IGS_PE_PERSON.surname%TYPE;
1312: v_given_names IGS_PE_PERSON.given_names%TYPE;

Line 1309: cst_pass CONSTANT IGS_AS_GRD_SCH_GRADE.s_result_type%TYPE := 'PASS';

1305: cst_subject_rec_type CONSTANT VARCHAR2(1) := 'S';
1306: cst_withdrawn CONSTANT IGS_AS_GRD_SCH_GRADE.s_result_type%TYPE :=
1307: 'WITHDRAWN';
1308: cst_fail CONSTANT IGS_AS_GRD_SCH_GRADE.s_result_type%TYPE := 'FAIL';
1309: cst_pass CONSTANT IGS_AS_GRD_SCH_GRADE.s_result_type%TYPE := 'PASS';
1310: v_person_id IGS_PE_PERSON.person_id%TYPE;
1311: v_surname IGS_PE_PERSON.surname%TYPE;
1312: v_given_names IGS_PE_PERSON.given_names%TYPE;
1313: v_birth_dt IGS_PE_PERSON.birth_dt%TYPE;

Line 1339: v_grade IGS_AS_GRD_SCH_GRADE.grade%TYPE;

1335: v_subject_title IGS_PS_UNIT_VER.title%TYPE;
1336: v_year_enrolled IGS_EN_SUA_V.acad_alternate_code%TYPE;
1337: v_arts_teaching_cal_type_cd IGS_CA_TYPE.arts_teaching_cal_type_cd%TYPE;
1338: v_semester_enrolled NUMBER(1);
1339: v_grade IGS_AS_GRD_SCH_GRADE.grade%TYPE;
1340: v_s_result_type IGS_AS_GRD_SCH_GRADE.s_result_type%TYPE;
1341: v_subject_completion_code NUMBER(1);
1342: v_govt_discipline_group_cd IGS_PS_DSCP.govt_discipline_group_cd%TYPE;
1343: v_subject_discipline_group NUMBER(4);

Line 1340: v_s_result_type IGS_AS_GRD_SCH_GRADE.s_result_type%TYPE;

1336: v_year_enrolled IGS_EN_SUA_V.acad_alternate_code%TYPE;
1337: v_arts_teaching_cal_type_cd IGS_CA_TYPE.arts_teaching_cal_type_cd%TYPE;
1338: v_semester_enrolled NUMBER(1);
1339: v_grade IGS_AS_GRD_SCH_GRADE.grade%TYPE;
1340: v_s_result_type IGS_AS_GRD_SCH_GRADE.s_result_type%TYPE;
1341: v_subject_completion_code NUMBER(1);
1342: v_govt_discipline_group_cd IGS_PS_DSCP.govt_discipline_group_cd%TYPE;
1343: v_subject_discipline_group NUMBER(4);
1344: v_number_ind BOOLEAN;

Line 1347: v_grading_schema_cd IGS_AS_GRD_SCH_GRADE.grading_schema_cd%TYPE;

1343: v_subject_discipline_group NUMBER(4);
1344: v_number_ind BOOLEAN;
1345: v_credit_points NUMBER(6);
1346: v_sua_eftsu NUMBER;
1347: v_grading_schema_cd IGS_AS_GRD_SCH_GRADE.grading_schema_cd%TYPE;
1348: v_gs_version_number IGS_AS_GRD_SCH_GRADE.version_number%TYPE;
1349: v_subject_cnt NUMBER(3);
1350: TYPE t_subject_type IS TABLE OF v_output_subject%TYPE
1351: INDEX BY BINARY_INTEGER;

Line 1348: v_gs_version_number IGS_AS_GRD_SCH_GRADE.version_number%TYPE;

1344: v_number_ind BOOLEAN;
1345: v_credit_points NUMBER(6);
1346: v_sua_eftsu NUMBER;
1347: v_grading_schema_cd IGS_AS_GRD_SCH_GRADE.grading_schema_cd%TYPE;
1348: v_gs_version_number IGS_AS_GRD_SCH_GRADE.version_number%TYPE;
1349: v_subject_cnt NUMBER(3);
1350: TYPE t_subject_type IS TABLE OF v_output_subject%TYPE
1351: INDEX BY BINARY_INTEGER;
1352: t_subject t_subject_type;