APPS.IGS_AS_ADI_UPLD_UG_PKG dependencies on IGS_AS_UG_INTERFACE

Line 44: FROM igs_as_ug_interface ugi

40: uoo_id,
41: manual_override_flag,
42: mark_capped_flag,
43: release_date
44: FROM igs_as_ug_interface ugi
45: WHERE ugi.user_id = p_user_id
46: AND trunc(ugi.batch_date) = trunc(p_batch_date)
47: AND NVL(grading_period_cd , '-') <> '-';
48:

Line 77: FROM igs_as_ug_interface ugi

73: uoo_id,
74: manual_override_flag,
75: mark_capped_flag,
76: release_date
77: FROM igs_as_ug_interface ugi
78: WHERE ugi.user_id=p_user_id
79: AND trunc(ugi.batch_date) = trunc(p_batch_date)
80: AND (error_code IS NULL
81: OR error_code IN ('IGS_AS_ASW_GP_GRADE_EXIST', 'IGS_AS_ASW_MARK_GRADE_INVALID'))

Line 189: UPDATE igs_as_ug_interface

185: v_ugi_rec.uoo_id
186: );
187:
188: if(l_validuser<>'Y') then
189: UPDATE igs_as_ug_interface
190: SET error_code = 'IGS_EN_PERSON_NO_RESP'
191: WHERE ROWID = v_ugi_rec.ROWID;
192: else
193: --

Line 236: UPDATE igs_as_ug_interface

232: );
233: IF v_load_file_flag = 'N' THEN
234: v_load_file_master := 'N';
235: END IF;
236: UPDATE igs_as_ug_interface
237: SET error_code = v_error_code,
238: grade = v_grade
239: WHERE ROWID = v_ugi_rec.ROWID;
240: end if ;

Line 416: UPDATE igs_as_ug_interface

412: );
413: retcode := 2;
414: errbuf := message_name;
415: IF (errbuf IS NOT NULL) THEN
416: UPDATE igs_as_ug_interface
417: SET error_code = errbuf
418: WHERE rowid = v_ugi_rec.rowid;
419: END IF;
420: END;

Line 499: UPDATE igs_as_ug_interface

495: );
496: retcode := 2;
497: errbuf := message_name;
498: IF (errbuf IS NOT NULL) THEN
499: UPDATE igs_as_ug_interface
500: SET error_code = errbuf
501: WHERE rowid = v_ugi_rec.rowid;
502: END IF;
503: END;