APPS.IGS_AS_ADI_UPLD_AIO_PKG dependencies on IGS_AS_AIO_INTERFACE

Line 122: FROM igs_as_aio_interface

118: penalty_applied_flag,
119: waived_flag,
120: submitted_date,
121: uoo_id
122: FROM igs_as_aio_interface
123: WHERE user_id = p_user_id
124: AND trunc(batch_date) = trunc(p_batch_date)
125: AND ass_id IS NOT NULL;
126: --

Line 205: UPDATE igs_as_aio_interface

201: v_aio_upld.user_id ,
202: v_aio_upld.uoo_id
203: );
204: IF (l_validuser <> 'Y') THEN
205: UPDATE igs_as_aio_interface
206: SET error_code = 'IGS_EN_PERSON_NO_RESP'
207: WHERE ROWID = v_aio_upld.ROWID;
208: ELSE
209:

Line 260: UPDATE igs_as_aio_interface

256: IF v_insert_flag = 'N' THEN
257: v_insert_batch := 'N';
258: END IF;
259: --
260: UPDATE igs_as_aio_interface
261: SET error_code = v_error_code,
262: grade = v_grade
263: WHERE ROWID = v_aio_upld.ROWID;
264: END IF;

Line 440: UPDATE igs_as_aio_interface

436: fnd_message.parse_encoded (fnd_message.get_encoded, app_short_name, message_name);
437: retcode := 2;
438: errbuf := message_name;
439: IF (errbuf IS NOT NULL) THEN
440: UPDATE igs_as_aio_interface
441: SET ERROR_CODE = errbuf
442: WHERE ROWID = v_aio_upld.ROWID;
443: END IF;
444: END;

Line 499: CURSOR CUR_AIO_NO_ERR IS SELECT aio.* from IGS_AS_AIO_INTERFACE AIO

495: WHERE ( (PERSON_number = cp_person_number OR ANONYMOUS_ID = CP_ANONYMOUS_ID)
496: AND user_id = cp_user_id and trunc(batch_date) = trunc(cp_batch_date)
497: AND uoo_id = cp_uoo_id and ERROR_CODE IS NOT NULL
498: );
499: CURSOR CUR_AIO_NO_ERR IS SELECT aio.* from IGS_AS_AIO_INTERFACE AIO
500: WHERE user_id = p_user_id and trunc(batch_date) = trunc(p_batch_date)
501: AND ASS_ID IS NULL
502: AND ERROR_CODE IS NULL
503: FOR UPDATE OF ERROR_CODE;

Line 531: UPDATE IGS_AS_AIO_INTERFACE SET ERROR_CODE = v_error_code_toaio WHERE CURRENT OF CUR_AIO_NO_ERR;

527: v_error_code_toaio := NULL;
528: OPEN cur_ug_err (AIO_NO_ERR.USER_ID, AIO_NO_ERR.batch_date, AIO_NO_ERR.person_number,AIO_NO_ERR.anonymous_id, AIO_NO_ERR.uoo_id);
529: FETCH cur_ug_err into v_error_code_toaio;
530: CLOSE cur_ug_err;
531: UPDATE IGS_AS_AIO_INTERFACE SET ERROR_CODE = v_error_code_toaio WHERE CURRENT OF CUR_AIO_NO_ERR;
532: END LOOP;
533: END assmnt_item_grade_unit_process;
534: --
535: -- Validate single Grading Period record from the interface table before