APPS.IGS_CA_INS_ROLL_CI dependencies on IGS_CA_TYPE

Line 2149: v_cal_type_rec IGS_CA_TYPE%ROWTYPE;

2145: v_new_cal_status IGS_CA_STAT.CAL_STATUS%TYPE;
2146: v_message_name VARCHAR2(30);
2147: v_cal_instance_rec IGS_CA_INST%ROWTYPE;
2148: v_new_cal_instance_rec IGS_CA_INST%ROWTYPE;
2149: v_cal_type_rec IGS_CA_TYPE%ROWTYPE;
2150: v_unique_sequence IGS_CA_INST.sequence_number%TYPE; -- added for bug 2563531
2151: v_cal_instance_exists BOOLEAN;
2152: v_new_term_instruction_time IGS_CA_INST.term_instruction_time%TYPE;
2153:

Line 2176: FROM IGS_CA_TYPE

2172: WHERE s_cal_status = cp_cal_status;
2173: CURSOR c_cal_type(
2174: cp_cal_type IGS_CA_INST.CAL_TYPE%TYPE) IS
2175: SELECT *
2176: FROM IGS_CA_TYPE
2177: WHERE CAL_TYPE = cp_cal_type;
2178: CURSOR c_ci_sequence_number IS
2179: SELECT IGS_CA_INST_SEQ_NUM_S.nextval
2180: FROM DUAL;

Line 2188: FROM IGS_CA_INST CI , IGS_CA_TYPE CAT

2184: SELECT igs_ca_inst_seq_num_s1.nextval from DUAL;
2185: -- cursor to check whether the alternate code for academic calendar instance is already present.
2186: CURSOR alt_code_unique(p_alternate_code IGS_CA_INST.ALTERNATE_CODE%TYPE) IS
2187: SELECT count(*)
2188: FROM IGS_CA_INST CI , IGS_CA_TYPE CAT
2189: WHERE CAT.CAL_TYPE = CI.CAL_TYPE
2190: AND CAT.S_CAL_CAT IN ('ACADEMIC' ,'LOAD','TEACHING')
2191: AND CI.ALTERNATE_CODE = p_alternate_code;
2192: l_count NUMBER(3);