eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_SV_UTIL dependencies on IGS_SV_BATCHES

Line 53: FROM igs_sv_batches

49:
50: CURSOR proc_dt_crsr (batch_no NUMBER)
51: IS
52: SELECT creation_date
53: FROM igs_sv_batches
54: WHERE batch_id = batch_no;
55: BEGIN
56: get_tbl_extra_params (
57: p_key_code,

Line 212: l_batch_id igs_sv_batches.batch_id%TYPE;

208:
209: ******************************************************************/
210: IS
211: l_gen_xml_flg BOOLEAN := TRUE ;
212: l_batch_id igs_sv_batches.batch_id%TYPE;
213: l_tmp_btch_id igs_sv_batches.batch_id%TYPE;
214: l_batch_rec igs_sv_batches%ROWTYPE;
215: l_person_rec igs_sv_persons%ROWTYPE;
216: l_tbl_name VARCHAR2 (30);

Line 213: l_tmp_btch_id igs_sv_batches.batch_id%TYPE;

209: ******************************************************************/
210: IS
211: l_gen_xml_flg BOOLEAN := TRUE ;
212: l_batch_id igs_sv_batches.batch_id%TYPE;
213: l_tmp_btch_id igs_sv_batches.batch_id%TYPE;
214: l_batch_rec igs_sv_batches%ROWTYPE;
215: l_person_rec igs_sv_persons%ROWTYPE;
216: l_tbl_name VARCHAR2 (30);
217: l_extra_criteria VARCHAR2 (100);

Line 214: l_batch_rec igs_sv_batches%ROWTYPE;

210: IS
211: l_gen_xml_flg BOOLEAN := TRUE ;
212: l_batch_id igs_sv_batches.batch_id%TYPE;
213: l_tmp_btch_id igs_sv_batches.batch_id%TYPE;
214: l_batch_rec igs_sv_batches%ROWTYPE;
215: l_person_rec igs_sv_persons%ROWTYPE;
216: l_tbl_name VARCHAR2 (30);
217: l_extra_criteria VARCHAR2 (100);
218: l_rec_count NUMBER;

Line 221: l_batch_status igs_sv_batches.BATCH_TYPE%TYPE;

217: l_extra_criteria VARCHAR2 (100);
218: l_rec_count NUMBER;
219: l_query VARCHAR2(2000);
220: l_pers_status igs_sv_persons.record_status%TYPE;
221: l_batch_status igs_sv_batches.BATCH_TYPE%TYPE;
222:
223: CURSOR batch_crsr (cp_batch_id NUMBER)
224: IS
225: SELECT *

Line 226: FROM igs_sv_batches

222:
223: CURSOR batch_crsr (cp_batch_id NUMBER)
224: IS
225: SELECT *
226: FROM igs_sv_batches
227: WHERE batch_id = cp_batch_id;
228:
229: CURSOR c_batch_type (cp_batch_id NUMBER)
230: IS

Line 232: FROM igs_sv_batches

228:
229: CURSOR c_batch_type (cp_batch_id NUMBER)
230: IS
231: SELECT BATCH_TYPE
232: FROM igs_sv_batches
233: WHERE batch_id = cp_batch_id;
234:
235: CURSOR pers_rec_status (cp_person_id NUMBER,cp_batch_id NUMBER)
236: IS

Line 267: --select igs_sv_batches_id_s.NEXTVAL into :i from dual;

263: /* ELSIF l_batch_rec.batch_status = 'X' THEN
264: l_batch_id := l_batch_rec.batch_id;
265: --*/
266: ELSE
267: --select igs_sv_batches_id_s.NEXTVAL into :i from dual;
268: l_batch_id := open_new_batch(p_person_id,p_batch_id,'HOLD');
269: END IF;
270:
271: -- my_dbg('Before First Cursor - l_batch_rec.batch_status : ', l_batch_rec.batch_status);

Line 390: l_batch_id igs_sv_batches.batch_id%TYPE;

386: Who When What
387: ------------------------------------------------------------------------
388:
389: ******************************************************************/
390: l_batch_id igs_sv_batches.batch_id%TYPE;
391: l_batch_rec igs_sv_batches%ROWTYPE;
392: l_person_rec igs_sv_persons%ROWTYPE;
393: l_rec_count NUMBER;
394:

Line 391: l_batch_rec igs_sv_batches%ROWTYPE;

387: ------------------------------------------------------------------------
388:
389: ******************************************************************/
390: l_batch_id igs_sv_batches.batch_id%TYPE;
391: l_batch_rec igs_sv_batches%ROWTYPE;
392: l_person_rec igs_sv_persons%ROWTYPE;
393: l_rec_count NUMBER;
394:
395: CURSOR batch_crsr (cp_batch_id NUMBER)

Line 398: FROM igs_sv_batches

394:
395: CURSOR batch_crsr (cp_batch_id NUMBER)
396: IS
397: SELECT *
398: FROM igs_sv_batches
399: WHERE batch_id = cp_batch_id;
400:
401: CURSOR person_crsr (cp_person_id NUMBER, cp_batch_id NUMBER)
402: IS

Line 418: SELECT igs_sv_batches_id_s.NEXTVAL INTO l_batch_id from dual;

414: OPEN batch_crsr (p_batch_id);
415: FETCH batch_crsr INTO l_batch_rec;
416: CLOSE batch_crsr;
417:
418: SELECT igs_sv_batches_id_s.NEXTVAL INTO l_batch_id from dual;
419:
420: INSERT INTO igs_sv_batches
421: (batch_id, schema_version,
422: sevis_user_id, sevis_school_id,

Line 420: INSERT INTO igs_sv_batches

416: CLOSE batch_crsr;
417:
418: SELECT igs_sv_batches_id_s.NEXTVAL INTO l_batch_id from dual;
419:
420: INSERT INTO igs_sv_batches
421: (batch_id, schema_version,
422: sevis_user_id, sevis_school_id,
423: batch_status, batch_type, creation_date,
424: created_by, last_updated_by,

Line 526: l_batch_id igs_sv_batches.batch_id%TYPE;

522: Who When What
523: ------------------------------------------------------------------------
524:
525: ******************************************************************/
526: l_batch_id igs_sv_batches.batch_id%TYPE;
527: l_batch_rec igs_sv_batches%ROWTYPE;
528: l_person_rec igs_sv_persons%ROWTYPE;
529: l_rec_count NUMBER;
530:

Line 527: l_batch_rec igs_sv_batches%ROWTYPE;

523: ------------------------------------------------------------------------
524:
525: ******************************************************************/
526: l_batch_id igs_sv_batches.batch_id%TYPE;
527: l_batch_rec igs_sv_batches%ROWTYPE;
528: l_person_rec igs_sv_persons%ROWTYPE;
529: l_rec_count NUMBER;
530:
531:

Line 615: FROM igs_sv_prgms_info prgm, IGS_SV_BATCHES btch

611:
612: ******************************************************************/
613: CURSOR c_btch_date IS
614: SELECT MAX(prgm.BATCH_ID) , btch.creation_date
615: FROM igs_sv_prgms_info prgm, IGS_SV_BATCHES btch
616: WHERE prgm.batch_id = btch.batch_id AND
617: prgm.person_id = p_person_id AND
618: prgm.sevis_auth_id = p_sevis_auth_id AND
619: prgm.prgm_action_type = 'DB' AND