APPS.IGS_PS_GEN_001 dependencies on IGS_AS_GRD_SCHEMA

Line 399: v_gs_version_number IGS_AS_GRD_SCHEMA.version_number%TYPE;

395: p_new_course_cd IGS_PS_VER.course_cd%TYPE,
396: p_new_version_number IGS_PS_VER.version_number%TYPE) AS
397: BEGIN
398: DECLARE
399: v_gs_version_number IGS_AS_GRD_SCHEMA.version_number%TYPE;
400: v_message_name VARCHAR2(30);
401: CURSOR c_latest_gs_version (
402: cp_gs_cd IGS_AS_GRD_SCHEMA.grading_schema_cd%TYPE) IS
403: SELECT MAX(gs.version_number)

Line 402: cp_gs_cd IGS_AS_GRD_SCHEMA.grading_schema_cd%TYPE) IS

398: DECLARE
399: v_gs_version_number IGS_AS_GRD_SCHEMA.version_number%TYPE;
400: v_message_name VARCHAR2(30);
401: CURSOR c_latest_gs_version (
402: cp_gs_cd IGS_AS_GRD_SCHEMA.grading_schema_cd%TYPE) IS
403: SELECT MAX(gs.version_number)
404: FROM IGS_AS_GRD_SCHEMA gs
405: WHERE gs.grading_schema_cd = cp_gs_cd;
406: BEGIN

Line 404: FROM IGS_AS_GRD_SCHEMA gs

400: v_message_name VARCHAR2(30);
401: CURSOR c_latest_gs_version (
402: cp_gs_cd IGS_AS_GRD_SCHEMA.grading_schema_cd%TYPE) IS
403: SELECT MAX(gs.version_number)
404: FROM IGS_AS_GRD_SCHEMA gs
405: WHERE gs.grading_schema_cd = cp_gs_cd;
406: BEGIN
407: -- select the next sequence_number from the system
408: SELECT IGS_PS_OFR_PAT_COP_ID_S.NEXTVAL