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_NI_BATCH_PROCESS_PKG dependencies on IGS_SV_BATCHES

Line 68: TYPE g_parallel_batches_tbl IS TABLE OF IGS_SV_BATCHES.BATCH_ID%TYPE INDEX BY BINARY_INTEGER;

64: TYPE g_edu_rec_type IS TABLE OF IGS_SV_PRGMS_INFO%ROWTYPE INDEX BY BINARY_INTEGER;
65: TYPE g_dependent_rec_type IS TABLE OF IGS_SV_DEPDNT_INFO%ROWTYPE INDEX BY BINARY_INTEGER;
66: TYPE g_convictions_rec_type IS TABLE OF IGS_SV_CONVICTIONS%ROWTYPE INDEX BY BINARY_INTEGER;
67: TYPE g_empl_rec_type IS TABLE OF IGS_SV_EMPL_INFO%ROWTYPE INDEX BY BINARY_INTEGER;
68: TYPE g_parallel_batches_tbl IS TABLE OF IGS_SV_BATCHES.BATCH_ID%TYPE INDEX BY BINARY_INTEGER;
69: TYPE g_running_batches_tbl IS TABLE OF IGS_SV_BATCHES.BATCH_ID%TYPE INDEX BY BINARY_INTEGER;
70:
71: g_parallel_batches g_parallel_batches_tbl;
72: g_running_batches g_running_batches_tbl;

Line 69: TYPE g_running_batches_tbl IS TABLE OF IGS_SV_BATCHES.BATCH_ID%TYPE INDEX BY BINARY_INTEGER;

65: TYPE g_dependent_rec_type IS TABLE OF IGS_SV_DEPDNT_INFO%ROWTYPE INDEX BY BINARY_INTEGER;
66: TYPE g_convictions_rec_type IS TABLE OF IGS_SV_CONVICTIONS%ROWTYPE INDEX BY BINARY_INTEGER;
67: TYPE g_empl_rec_type IS TABLE OF IGS_SV_EMPL_INFO%ROWTYPE INDEX BY BINARY_INTEGER;
68: TYPE g_parallel_batches_tbl IS TABLE OF IGS_SV_BATCHES.BATCH_ID%TYPE INDEX BY BINARY_INTEGER;
69: TYPE g_running_batches_tbl IS TABLE OF IGS_SV_BATCHES.BATCH_ID%TYPE INDEX BY BINARY_INTEGER;
70:
71: g_parallel_batches g_parallel_batches_tbl;
72: g_running_batches g_running_batches_tbl;
73:

Line 89: sevis_user_id igs_sv_batches.sevis_user_id%TYPE,

85: batch_id igs_sv_persons.batch_id%TYPE,
86: record_number igs_sv_persons.record_number%TYPE,
87: record_status igs_sv_persons.record_status%TYPE, --(N)ew (C)hanged
88: person_number igs_sv_persons.person_number%TYPE,
89: sevis_user_id igs_sv_batches.sevis_user_id%TYPE,
90: batch_type igs_sv_batches.batch_type%TYPE,
91: form_id igs_sv_persons.form_id%TYPE,
92: print_form igs_sv_persons.print_form%TYPE,
93: dep_flag VARCHAR2(1),

Line 90: batch_type igs_sv_batches.batch_type%TYPE,

86: record_number igs_sv_persons.record_number%TYPE,
87: record_status igs_sv_persons.record_status%TYPE, --(N)ew (C)hanged
88: person_number igs_sv_persons.person_number%TYPE,
89: sevis_user_id igs_sv_batches.sevis_user_id%TYPE,
90: batch_type igs_sv_batches.batch_type%TYPE,
91: form_id igs_sv_persons.form_id%TYPE,
92: print_form igs_sv_persons.print_form%TYPE,
93: dep_flag VARCHAR2(1),
94: person_status VARCHAR2(1),

Line 154: p_batch_id IN IGS_SV_BATCHES.BATCH_ID%TYPE

150: PROCEDURE compose_log_file;
151: /*****************************************************************/
152: PROCEDURE Submit_Event (
153: p_batch_type IN VARCHAR2,
154: p_batch_id IN IGS_SV_BATCHES.BATCH_ID%TYPE
155: )
156: IS
157:
158: l_parameter_list wf_parameter_list_t := wf_parameter_list_t();

Line 191: FROM igs_sv_batches

187: );
188:
189: CURSOR c_get_user_id IS
190: SELECT sevis_user_id
191: FROM igs_sv_batches
192: WHERE batch_id = p_batch_id;
193:
194: l_con_req_id NUMBER;
195: BEGIN

Line 7184: igs_sv_batches btch,

7180: WHERE pr.person_id = p_person_rec.person_id
7181: AND pr.batch_id IN
7182: ( SELECT max(btch.batch_id)
7183: FROM igs_sv_persons prs,
7184: igs_sv_batches btch,
7185: igs_sv_persons pr
7186: WHERE prs.person_id = pr.person_id
7187: AND prs.batch_id = pr.batch_id
7188: AND pr.record_status <> 'E'

Line 10286: p_batch_id igs_sv_batches.batch_id%TYPE,

10282: END Get_pre_noshow_status;
10283:
10284:
10285: FUNCTION new_batch(
10286: p_batch_id igs_sv_batches.batch_id%TYPE,
10287: p_dso_id VARCHAR2,
10288: p_org_id VARCHAR2,
10289: p_batch_type VARCHAR2,
10290: p_org_party_id NUMBER,

Line 10295: l_batch_id igs_sv_batches.batch_id%TYPE;

10291: p_user_party_id NUMBER
10292: )
10293: RETURN NUMBER
10294: IS
10295: l_batch_id igs_sv_batches.batch_id%TYPE;
10296: BEGIN
10297: DELETE FROM igs_sv_batches WHERE batch_id = p_batch_id;
10298: INSERT INTO igs_sv_batches
10299: ( batch_id,

Line 10297: DELETE FROM igs_sv_batches WHERE batch_id = p_batch_id;

10293: RETURN NUMBER
10294: IS
10295: l_batch_id igs_sv_batches.batch_id%TYPE;
10296: BEGIN
10297: DELETE FROM igs_sv_batches WHERE batch_id = p_batch_id;
10298: INSERT INTO igs_sv_batches
10299: ( batch_id,
10300: schema_version,
10301: sevis_user_id,

Line 10298: INSERT INTO igs_sv_batches

10294: IS
10295: l_batch_id igs_sv_batches.batch_id%TYPE;
10296: BEGIN
10297: DELETE FROM igs_sv_batches WHERE batch_id = p_batch_id;
10298: INSERT INTO igs_sv_batches
10299: ( batch_id,
10300: schema_version,
10301: sevis_user_id,
10302: sevis_school_id,

Line 10314: ( igs_sv_batches_id_s.nextval,

10310: SEVIS_SCHOOL_ORG_ID ,
10311: SEVIS_USER_PERSON_ID
10312: )
10313: VALUES
10314: ( igs_sv_batches_id_s.nextval,
10315: 1,
10316: p_dso_id,
10317: p_org_id,
10318: 'S',

Line 10373: l_batch_id igs_sv_batches.batch_id%TYPE;

10369: -- select all persons from I-20 where form status is not Terminated or Completed and reported to SEVIS already
10370:
10371:
10372:
10373: l_batch_id igs_sv_batches.batch_id%TYPE;
10374: l_person_sevis_id IGS_SV_PERSONS.SEVIS_USER_ID%TYPE;
10375: l_issue_rec IGS_SV_PERSONS%ROWTYPE;
10376: l_bio_rec IGS_SV_BIO_INFO%ROWTYPE;
10377: l_oth_rec IGS_SV_OTH_INFO%ROWTYPE;

Line 10389: l_btch_id igs_sv_batches.batch_id%TYPE;

10385: l_submiter_id NUMBER(25);
10386: l_submiter_number hz_parties.party_number%TYPE;
10387: no_show_status VARCHAR2(1);
10388: l_cur_authdrp_rec IGS_SV_PRGMS_INFO%ROWTYPE;
10389: l_btch_id igs_sv_batches.batch_id%TYPE;
10390:
10391: CURSOR C_EV_CUR IS
10392: SELECT fr.person_id, min(ev_form_id) form_id, pr.party_number person_number, fr.no_show_flag, fr.reprint_reason reprint_reason
10393: FROM igs_pe_ev_form fr, hz_parties pr, igs_pe_alt_pers_id alt

Line 10458: igs_sv_batches b

10454:
10455: CURSOR c_prev_info( p_id NUMBER, f_id NUMBER) IS
10456: SELECT 1
10457: FROM igs_sv_persons a,
10458: igs_sv_batches b
10459: WHERE person_id = p_id
10460: AND a.batch_id = b.batch_id
10461: AND b.batch_type = p_batch_type
10462: AND a.record_status <> 'E'

Line 10467: FROM igs_sv_batches

10463: AND form_id = f_id;
10464:
10465: CURSOR c_active_batch IS
10466: SELECT batch_id
10467: FROM igs_sv_batches
10468: WHERE batch_status IN ('N') -- prbhardw
10469: AND batch_type = p_batch_type;
10470:
10471: CURSOR c_print_form (p_form_id NUMBER) IS

Line 10611: INSERT INTO igs_sv_batches

10607: END IF;
10608: -- Create batch record
10609: Put_Log_Msg('Inserting batch record',0);
10610:
10611: INSERT INTO igs_sv_batches
10612: ( batch_id,
10613: schema_version,
10614: sevis_user_id,
10615: sevis_school_id,

Line 10627: ( igs_sv_batches_id_s.nextval,

10623: SEVIS_SCHOOL_ORG_ID,
10624: SEVIS_USER_PERSON_ID
10625: )
10626: VALUES
10627: ( igs_sv_batches_id_s.nextval,
10628: 1,
10629: l_person_sevis_id,
10630: p_org_id,
10631: 'S',

Line 11301: DELETE FROM igs_sv_batches WHERE batch_id = l_batch_id;

11297:
11298: FND_MESSAGE.SET_NAME('IGS', 'IGS_SV_NO_STUDENTS'); -- No students found to submit
11299: Put_Log_Msg(FND_MESSAGE.Get,1);
11300:
11301: DELETE FROM igs_sv_batches WHERE batch_id = l_batch_id;
11302:
11303: END IF;
11304:
11305: /*

Line 11327: DELETE FROM igs_sv_batches WHERE batch_id = l_batch_id;

11323: -- Submit_Event ( p_batch_type, l_batch_id);
11324: null;
11325: ELSE
11326: Remove_Person_Data (p_person_id => NULL, p_batch_id => l_batch_id );
11327: DELETE FROM igs_sv_batches WHERE batch_id = l_batch_id;
11328: DELETE FROM igs_sv_batches WHERE batch_id > l_batch_id;
11329: END IF;
11330: /* Debug */
11331: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN

Line 11328: DELETE FROM igs_sv_batches WHERE batch_id > l_batch_id;

11324: null;
11325: ELSE
11326: Remove_Person_Data (p_person_id => NULL, p_batch_id => l_batch_id );
11327: DELETE FROM igs_sv_batches WHERE batch_id = l_batch_id;
11328: DELETE FROM igs_sv_batches WHERE batch_id > l_batch_id;
11329: END IF;
11330: /* Debug */
11331: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
11332: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Create_Batch';

Line 11499: l_batch_id igs_sv_batches.batch_id%TYPE;

11495: p_batch_type IN VARCHAR2 -- Batch type E(ev), I(international)
11496: ) IS
11497:
11498: l_api_name CONSTANT VARCHAR2(25) := 'Purge_Batch';
11499: l_batch_id igs_sv_batches.batch_id%TYPE;
11500:
11501: CURSOR c_active_batch IS
11502: SELECT batch_id
11503: FROM igs_sv_batches

Line 11503: FROM igs_sv_batches

11499: l_batch_id igs_sv_batches.batch_id%TYPE;
11500:
11501: CURSOR c_active_batch IS
11502: SELECT batch_id
11503: FROM igs_sv_batches
11504: WHERE batch_status IN ('S','N')
11505: AND batch_type = p_batch_type;
11506:
11507: BEGIN

Line 11535: DELETE FROM igs_sv_batches WHERE batch_id = l_batch_id;

11531:
11532: --Remove batch
11533: Remove_Person_Data (p_person_id => NULL, p_batch_id => l_batch_id );
11534:
11535: DELETE FROM igs_sv_batches WHERE batch_id = l_batch_id;
11536: DELETE FROM igs_sv_batches WHERE batch_id > l_batch_id;
11537:
11538: END IF;
11539:

Line 11536: DELETE FROM igs_sv_batches WHERE batch_id > l_batch_id;

11532: --Remove batch
11533: Remove_Person_Data (p_person_id => NULL, p_batch_id => l_batch_id );
11534:
11535: DELETE FROM igs_sv_batches WHERE batch_id = l_batch_id;
11536: DELETE FROM igs_sv_batches WHERE batch_id > l_batch_id;
11537:
11538: END IF;
11539:
11540: retcode := 0;

Line 11925: FROM igs_sv_batches

11921: l_api_name CONSTANT VARCHAR2(30) := 'process_trans_header';
11922:
11923: CURSOR c_batch IS
11924: SELECT batch_status
11925: FROM igs_sv_batches
11926: WHERE batch_id = p_BatchID;
11927:
11928: l_status igs_sv_batches.batch_status%TYPE;
11929:

Line 11928: l_status igs_sv_batches.batch_status%TYPE;

11924: SELECT batch_status
11925: FROM igs_sv_batches
11926: WHERE batch_id = p_BatchID;
11927:
11928: l_status igs_sv_batches.batch_status%TYPE;
11929:
11930:
11931: BEGIN
11932:

Line 11973: UPDATE igs_sv_batches SET batch_status = 'P' WHERE batch_id = p_BatchID;

11969:
11970: END IF;
11971:
11972: -- Update batch and set success status
11973: UPDATE igs_sv_batches SET batch_status = 'P' WHERE batch_id = p_BatchID;
11974:
11975: ELSE
11976: -- purge the batch completely.
11977:

Line 11980: UPDATE igs_sv_batches SET batch_status = 'E', SEVIS_ERROR_CODE = NVL(p_FileErrorCode,NVL(p_FileValidation,'X')) WHERE batch_id = p_BatchID;

11976: -- purge the batch completely.
11977:
11978: Remove_Person_Data (p_person_id => NULL, p_batch_id => p_BatchID );
11979:
11980: UPDATE igs_sv_batches SET batch_status = 'E', SEVIS_ERROR_CODE = NVL(p_FileErrorCode,NVL(p_FileValidation,'X')) WHERE batch_id = p_BatchID;
11981:
11982: END IF;
11983: EXCEPTION
11984: WHEN FND_API.G_EXC_ERROR THEN

Line 12286: CURSOR c_get_batch_type(cp_batch_id igs_sv_batches.batch_id%TYPE)

12282: retcode OUT NOCOPY NUMBER , -- Request standard return status
12283: batch_id IN NUMBER
12284: )
12285: IS
12286: CURSOR c_get_batch_type(cp_batch_id igs_sv_batches.batch_id%TYPE)
12287: IS
12288: SELECT batch_type
12289: FROM igs_sv_batches
12290: WHERE batch_id = cp_batch_id;

Line 12289: FROM igs_sv_batches

12285: IS
12286: CURSOR c_get_batch_type(cp_batch_id igs_sv_batches.batch_id%TYPE)
12287: IS
12288: SELECT batch_type
12289: FROM igs_sv_batches
12290: WHERE batch_id = cp_batch_id;
12291: l_batch_type VARCHAR2(1);
12292: BEGIN
12293: /* Debug */