APPS.IGS_PS_GEN_003 dependencies on IGS_AS_GRD_SCHEMA

Line 319: v_gs_version_number IGS_AS_GRD_SCHEMA.version_number%TYPE;

315:
316: v_inserted_cnt NUMBER(4);
317: v_check CHAR;
318: v_message_name varchar2(30);
319: v_gs_version_number IGS_AS_GRD_SCHEMA.version_number%TYPE;
320: CURSOR c_course_offering_pattern IS
321: SELECT location_cd,
322: attendance_mode,
323: attendance_type,

Line 361: cp_gs_cd IGS_AS_GRD_SCHEMA.grading_schema_cd%TYPE) IS

357: CURSOR c_cop_sequence_number IS
358: SELECT IGS_PS_OFR_PAT_COP_ID_S.NEXTVAL
359: FROM DUAL;
360: CURSOR c_latest_gs_version (
361: cp_gs_cd IGS_AS_GRD_SCHEMA.grading_schema_cd%TYPE) IS
362: SELECT MAX(gs.version_number)
363: FROM IGS_AS_GRD_SCHEMA gs
364: WHERE gs.grading_schema_cd = cp_gs_cd;
365:

Line 363: FROM IGS_AS_GRD_SCHEMA gs

359: FROM DUAL;
360: CURSOR c_latest_gs_version (
361: cp_gs_cd IGS_AS_GRD_SCHEMA.grading_schema_cd%TYPE) IS
362: SELECT MAX(gs.version_number)
363: FROM IGS_AS_GRD_SCHEMA gs
364: WHERE gs.grading_schema_cd = cp_gs_cd;
365:
366: x_rowid VARCHAR2(25);
367: BEGIN