APPS.IGS_UC_PROC_APPLICATION_DATA dependencies on IGS_UC_ISTARN_INTS

Line 149: FROM igs_uc_istarn_ints stn

145: stn.ad_interface_id,
146: stn.ad_api_id ,
147: stn.record_status ,
148: stn.error_code
149: FROM igs_uc_istarn_ints stn
150: WHERE stn.record_status = 'I';
151:
152: l_starn_rec cur_ivstarn%ROWTYPE;
153:

Line 154: CURSOR ad_interface_cur (p_interface_id igs_uc_istarn_ints.ad_interface_id%TYPE) IS

150: WHERE stn.record_status = 'I';
151:
152: l_starn_rec cur_ivstarn%ROWTYPE;
153:
154: CURSOR ad_interface_cur (p_interface_id igs_uc_istarn_ints.ad_interface_id%TYPE) IS
155: SELECT 'X'
156: FROM igs_ad_interface_all
157: WHERE interface_id = p_interface_id;
158:

Line 178: UPDATE igs_uc_istarn_ints

174: CLOSE ad_interface_cur;
175:
176: IF l_exists_flag IS NULL THEN
177: -- update the record with status = 'D'.
178: UPDATE igs_uc_istarn_ints
179: SET record_status = 'D'
180: WHERE rowid = ivstarn_rec.rowid;
181:
182: -- update count for success records

Line 188: UPDATE igs_uc_istarn_ints

184:
185: ELSE
186:
187: -- update the error code with status = 'D'.
188: UPDATE igs_uc_istarn_ints
189: SET error_code = '3001'
190: WHERE rowid = ivstarn_rec.rowid;
191:
192: -- update count for failure records

Line 557: FROM igs_uc_istarn_ints ivstn

553: -- get the records from interface tables where status is NEW.
554: CURSOR new_ivstarn_cur IS
555: SELECT ivstn.rowid,
556: ivstn.*
557: FROM igs_uc_istarn_ints ivstn
558: WHERE ivstn.record_status = 'N';
559:
560:
561: -- check for corresponding record in UCAS Names table.

Line 1322: UPDATE igs_uc_istarn_ints

1318:
1319: -- rollback the insert/updates made for this record
1320: ROLLBACK TO ivstarn_rec_savepoint;
1321:
1322: UPDATE igs_uc_istarn_ints
1323: SET error_code = g_error_code
1324: WHERE rowid = new_ivstarn_rec.rowid;
1325:
1326: -- log error message/meaning.

Line 1335: UPDATE igs_uc_istarn_ints

1331:
1332: ELSE
1333:
1334: -- record processed successfully
1335: UPDATE igs_uc_istarn_ints
1336: SET record_status = 'I' , -- 'I' signifies intermediate stage of processing.
1337: error_code = NULL ,
1338: ad_batch_id = l_adm_batch_id,
1339: ad_interface_id = l_interface_id,