APPS.IGS_AS_GEN_004 dependencies on IGS_AS_MARK_SHEET_ALL

Line 1155: UPDATE igs_as_mark_sheet_all

1151: -- open cursor in which the update of IGS_AS_MARK_SHEET.duplicate_ind is based on
1152: -- if table is busy, update will be abandoned without waiting (NO_WAIT)
1153: OPEN c_mss (v_ms_sequence_number);
1154: FETCH c_mss INTO v_mss_mark_sheet;
1155: UPDATE igs_as_mark_sheet_all
1156: SET duplicate_ind = 'Y'
1157: WHERE CURRENT OF c_mss;
1158: CLOSE c_mss;
1159: EXIT;

Line 1165: DELETE igs_as_mark_sheet_all

1161: END LOOP;
1162: END LOOP;
1163: IF v_ins_ms = TRUE THEN
1164: -- Delete sheets which were created but have no students.
1165: DELETE igs_as_mark_sheet_all
1166: WHERE group_sequence_number = v_group_sequence_number
1167: AND NOT EXISTS ( SELECT sheet_number
1168: FROM igs_as_msht_su_atmpt
1169: WHERE sheet_number = igs_as_mark_sheet_all.sheet_number);

Line 1169: WHERE sheet_number = igs_as_mark_sheet_all.sheet_number);

1165: DELETE igs_as_mark_sheet_all
1166: WHERE group_sequence_number = v_group_sequence_number
1167: AND NOT EXISTS ( SELECT sheet_number
1168: FROM igs_as_msht_su_atmpt
1169: WHERE sheet_number = igs_as_mark_sheet_all.sheet_number);
1170: p_group_sequence_number := v_group_sequence_number;
1171: RETURN TRUE;
1172: ELSE
1173: p_group_sequence_number := NULL;