APPS.IGS_AD_IMP_016 dependencies on IGS_AD_TEST_TYPE

Line 164: CURSOR c_test_type_cur ( x_admission_test_type igs_ad_test_type.admission_test_type%TYPE ) IS

160: AND test_segment_id = cp_test_segment_id;
161:
162: c_null_hdlg_tst_dtls_rec c_null_hdlg_tst_dtls_cur%ROWTYPE;
163:
164: CURSOR c_test_type_cur ( x_admission_test_type igs_ad_test_type.admission_test_type%TYPE ) IS
165: SELECT score_type
166: FROM igs_ad_test_type
167: WHERE admission_test_type = x_admission_test_type ;
168:

Line 166: FROM igs_ad_test_type

162: c_null_hdlg_tst_dtls_rec c_null_hdlg_tst_dtls_cur%ROWTYPE;
163:
164: CURSOR c_test_type_cur ( x_admission_test_type igs_ad_test_type.admission_test_type%TYPE ) IS
165: SELECT score_type
166: FROM igs_ad_test_type
167: WHERE admission_test_type = x_admission_test_type ;
168:
169:
170: l_count_seg NUMBER(15);

Line 173: l_score_type igs_ad_test_type.score_type%TYPE;

169:
170: l_count_seg NUMBER(15);
171: l_success BOOLEAN := TRUE;
172:
173: l_score_type igs_ad_test_type.score_type%TYPE;
174: l_status VARCHAR2(1);
175: l_error_code VARCHAR2(30);
176: l_error_text VARCHAR2(2000);
177: l_msg_at_index NUMBER := 0;