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

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

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

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

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

Line 90: sevis_user_id igs_sv_batches.sevis_user_id%TYPE,

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

Line 91: batch_type igs_sv_batches.batch_type%TYPE,

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

Line 156: p_batch_id IN IGS_SV_BATCHES.BATCH_ID%TYPE

152: PROCEDURE xml_log_file (p_batch_id IN igs_sv_btch_summary.batch_id%TYPE);
153: /*****************************************************************/
154: PROCEDURE Submit_Event (
155: p_batch_type IN VARCHAR2,
156: p_batch_id IN IGS_SV_BATCHES.BATCH_ID%TYPE
157: )
158: IS
159:
160: l_parameter_list wf_parameter_list_t := wf_parameter_list_t();

Line 193: FROM igs_sv_batches

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

Line 8260: igs_sv_batches btch,

8256: WHERE pr.person_id = p_person_rec.person_id
8257: AND pr.batch_id IN
8258: ( SELECT max(btch.batch_id)
8259: FROM igs_sv_persons prs,
8260: igs_sv_batches btch,
8261: igs_sv_persons pr
8262: WHERE prs.person_id = pr.person_id
8263: AND prs.batch_id = pr.batch_id
8264: AND pr.record_status <> 'E'

Line 11424: p_batch_id igs_sv_batches.batch_id%TYPE,

11420: END Get_pre_noshow_status;
11421:
11422:
11423: FUNCTION new_batch(
11424: p_batch_id igs_sv_batches.batch_id%TYPE,
11425: p_dso_id VARCHAR2,
11426: p_org_id VARCHAR2,
11427: p_batch_type VARCHAR2,
11428: p_org_party_id NUMBER,

Line 11433: l_batch_id igs_sv_batches.batch_id%TYPE;

11429: p_user_party_id NUMBER
11430: )
11431: RETURN NUMBER
11432: IS
11433: l_batch_id igs_sv_batches.batch_id%TYPE;
11434: BEGIN
11435: -- DELETE FROM igs_sv_batches WHERE batch_id = p_batch_id;
11436:
11437: INSERT INTO igs_sv_batches

Line 11435: -- DELETE FROM igs_sv_batches WHERE batch_id = p_batch_id;

11431: RETURN NUMBER
11432: IS
11433: l_batch_id igs_sv_batches.batch_id%TYPE;
11434: BEGIN
11435: -- DELETE FROM igs_sv_batches WHERE batch_id = p_batch_id;
11436:
11437: INSERT INTO igs_sv_batches
11438: ( batch_id,
11439: schema_version,

Line 11437: INSERT INTO igs_sv_batches

11433: l_batch_id igs_sv_batches.batch_id%TYPE;
11434: BEGIN
11435: -- DELETE FROM igs_sv_batches WHERE batch_id = p_batch_id;
11436:
11437: INSERT INTO igs_sv_batches
11438: ( batch_id,
11439: schema_version,
11440: sevis_user_id,
11441: sevis_school_id,

Line 11453: ( igs_sv_batches_id_s.nextval,

11449: SEVIS_SCHOOL_ORG_ID ,
11450: SEVIS_USER_PERSON_ID
11451: )
11452: VALUES
11453: ( igs_sv_batches_id_s.nextval,
11454: 1,
11455: p_dso_id,
11456: p_org_id,
11457: 'S',

Line 11512: l_batch_id igs_sv_batches.batch_id%TYPE;

11508: -- select all persons from I-20 where form status is not Terminated or Completed and reported to SEVIS already
11509:
11510:
11511:
11512: l_batch_id igs_sv_batches.batch_id%TYPE;
11513: l_person_sevis_id IGS_SV_PERSONS.SEVIS_USER_ID%TYPE;
11514: l_issue_rec IGS_SV_PERSONS%ROWTYPE;
11515: l_bio_rec IGS_SV_BIO_INFO%ROWTYPE;
11516: l_oth_rec IGS_SV_OTH_INFO%ROWTYPE;

Line 11528: l_btch_id igs_sv_batches.batch_id%TYPE;

11524: l_submiter_id NUMBER(25);
11525: l_submiter_number hz_parties.party_number%TYPE;
11526: no_show_status VARCHAR2(1);
11527: l_cur_authdrp_rec IGS_SV_PRGMS_INFO%ROWTYPE;
11528: l_btch_id igs_sv_batches.batch_id%TYPE;
11529:
11530: CURSOR C_EV_CUR IS
11531: SELECT fr.person_id, min(ev_form_id) form_id, pr.party_number person_number, fr.no_show_flag, fr.reprint_reason reprint_reason
11532: FROM igs_pe_ev_form fr, hz_parties pr

Line 11606: igs_sv_batches b

11602:
11603: CURSOR c_prev_info( p_id NUMBER, f_id NUMBER) IS
11604: SELECT 1
11605: FROM igs_sv_persons a,
11606: igs_sv_batches b
11607: WHERE person_id = p_id
11608: AND a.batch_id = b.batch_id
11609: AND b.batch_type = p_batch_type
11610: AND a.record_status <> 'E'

Line 11615: FROM igs_sv_batches

11611: AND form_id = f_id;
11612:
11613: CURSOR c_active_batch IS
11614: SELECT batch_id
11615: FROM igs_sv_batches
11616: WHERE batch_status IN ('N') -- prbhardw
11617: AND batch_type = p_batch_type;
11618:
11619: CURSOR c_print_form (p_form_id NUMBER) IS

Line 11763: INSERT INTO igs_sv_batches

11759: END IF;
11760: -- Create batch record
11761: Put_Log_Msg('Inserting batch record',0);
11762:
11763: INSERT INTO igs_sv_batches
11764: ( batch_id,
11765: schema_version,
11766: sevis_user_id,
11767: sevis_school_id,

Line 11779: ( igs_sv_batches_id_s.nextval,

11775: SEVIS_SCHOOL_ORG_ID,
11776: SEVIS_USER_PERSON_ID
11777: )
11778: VALUES
11779: ( igs_sv_batches_id_s.nextval,
11780: 1,
11781: l_person_sevis_id,
11782: p_org_id,
11783: 'S',

Line 12456: DELETE FROM igs_sv_batches WHERE batch_id = l_batch_id;

12452:
12453: FND_MESSAGE.SET_NAME('IGS', 'IGS_SV_NO_STUDENTS'); -- No students found to submit
12454: Put_Log_Msg(FND_MESSAGE.Get,1);
12455:
12456: DELETE FROM igs_sv_batches WHERE batch_id = l_batch_id;
12457:
12458: END IF;
12459:
12460: /*

Line 12484: DELETE FROM igs_sv_batches WHERE batch_id = g_parallel_batches(i);

12480: ELSE
12481:
12482: FOR i IN 1..g_parallel_batches.COUNT LOOP
12483: Remove_Person_Data (p_person_id => NULL, p_batch_id => g_parallel_batches(i) );
12484: DELETE FROM igs_sv_batches WHERE batch_id = g_parallel_batches(i);
12485: Put_Log_Msg(' Removing parallel batch: ' || g_parallel_batches(i),0);
12486: END LOOP;
12487:
12488: FOR i IN 1..g_running_batches.COUNT LOOP

Line 12490: DELETE FROM igs_sv_batches WHERE batch_id = g_running_batches(i);

12486: END LOOP;
12487:
12488: FOR i IN 1..g_running_batches.COUNT LOOP
12489: Remove_Person_Data (p_person_id => NULL, p_batch_id => g_running_batches(i) );
12490: DELETE FROM igs_sv_batches WHERE batch_id = g_running_batches(i);
12491: Put_Log_Msg(' Removing running batch: ' || g_running_batches(i),0);
12492: END LOOP;
12493:
12494: END IF;

Line 12664: l_batch_id igs_sv_batches.batch_id%TYPE;

12660: p_batch_type IN VARCHAR2 -- Batch type E(ev), I(international)
12661: ) IS
12662:
12663: l_api_name CONSTANT VARCHAR2(25) := 'Purge_Batch';
12664: l_batch_id igs_sv_batches.batch_id%TYPE;
12665:
12666: CURSOR c_active_batch IS
12667: SELECT batch_id
12668: FROM igs_sv_batches

Line 12668: FROM igs_sv_batches

12664: l_batch_id igs_sv_batches.batch_id%TYPE;
12665:
12666: CURSOR c_active_batch IS
12667: SELECT batch_id
12668: FROM igs_sv_batches
12669: WHERE batch_status IN ('S','N')
12670: AND batch_type = p_batch_type;
12671:
12672: BEGIN

Line 12700: DELETE FROM igs_sv_batches WHERE batch_id = l_batch_id;

12696:
12697: --Remove batch
12698: /*Remove_Person_Data (p_person_id => NULL, p_batch_id => l_batch_id );
12699:
12700: DELETE FROM igs_sv_batches WHERE batch_id = l_batch_id;
12701: DELETE FROM igs_sv_batches WHERE batch_id > l_batch_id;*/
12702:
12703: FOR i IN 1..g_parallel_batches.COUNT LOOP
12704: Remove_Person_Data (p_person_id => NULL, p_batch_id => g_parallel_batches(i) );

Line 12701: DELETE FROM igs_sv_batches WHERE batch_id > l_batch_id;*/

12697: --Remove batch
12698: /*Remove_Person_Data (p_person_id => NULL, p_batch_id => l_batch_id );
12699:
12700: DELETE FROM igs_sv_batches WHERE batch_id = l_batch_id;
12701: DELETE FROM igs_sv_batches WHERE batch_id > l_batch_id;*/
12702:
12703: FOR i IN 1..g_parallel_batches.COUNT LOOP
12704: Remove_Person_Data (p_person_id => NULL, p_batch_id => g_parallel_batches(i) );
12705: DELETE FROM igs_sv_batches WHERE batch_id = g_parallel_batches(i);

Line 12705: DELETE FROM igs_sv_batches WHERE batch_id = g_parallel_batches(i);

12701: DELETE FROM igs_sv_batches WHERE batch_id > l_batch_id;*/
12702:
12703: FOR i IN 1..g_parallel_batches.COUNT LOOP
12704: Remove_Person_Data (p_person_id => NULL, p_batch_id => g_parallel_batches(i) );
12705: DELETE FROM igs_sv_batches WHERE batch_id = g_parallel_batches(i);
12706: Put_Log_Msg(' In purge batch-Removing parallel batch: ' || g_parallel_batches(i),0);
12707: END LOOP;
12708:
12709: FOR i IN 1..g_running_batches.COUNT LOOP

Line 12711: DELETE FROM igs_sv_batches WHERE batch_id = g_running_batches(i);

12707: END LOOP;
12708:
12709: FOR i IN 1..g_running_batches.COUNT LOOP
12710: Remove_Person_Data (p_person_id => NULL, p_batch_id => g_running_batches(i) );
12711: DELETE FROM igs_sv_batches WHERE batch_id = g_running_batches(i);
12712: Put_Log_Msg(' In purge batch-Removing running batch: ' || g_running_batches(i),0);
12713: END LOOP;
12714:
12715: END IF;

Line 13102: FROM igs_sv_batches

13098: l_api_name CONSTANT VARCHAR2(30) := 'process_trans_header';
13099:
13100: CURSOR c_batch IS
13101: SELECT batch_status
13102: FROM igs_sv_batches
13103: WHERE batch_id = p_BatchID;
13104:
13105: l_status igs_sv_batches.batch_status%TYPE;
13106:

Line 13105: l_status igs_sv_batches.batch_status%TYPE;

13101: SELECT batch_status
13102: FROM igs_sv_batches
13103: WHERE batch_id = p_BatchID;
13104:
13105: l_status igs_sv_batches.batch_status%TYPE;
13106:
13107:
13108: BEGIN
13109:

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

13146:
13147: END IF;
13148:
13149: -- Update batch and set success status
13150: UPDATE igs_sv_batches SET batch_status = 'P' WHERE batch_id = p_BatchID;
13151:
13152: ELSE
13153: -- purge the batch completely.
13154:

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

13153: -- purge the batch completely.
13154:
13155: Remove_Person_Data (p_person_id => NULL, p_batch_id => p_BatchID );
13156:
13157: UPDATE igs_sv_batches SET batch_status = 'E', SEVIS_ERROR_CODE = NVL(p_FileErrorCode,NVL(p_FileValidation,'X')) WHERE batch_id = p_BatchID;
13158:
13159: END IF;
13160: EXCEPTION
13161: WHEN FND_API.G_EXC_ERROR THEN

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

13459: retcode OUT NOCOPY NUMBER , -- Request standard return status
13460: batch_id IN NUMBER
13461: )
13462: IS
13463: CURSOR c_get_batch_type(cp_batch_id igs_sv_batches.batch_id%TYPE)
13464: IS
13465: SELECT batch_type
13466: FROM igs_sv_batches
13467: WHERE batch_id = cp_batch_id;

Line 13466: FROM igs_sv_batches

13462: IS
13463: CURSOR c_get_batch_type(cp_batch_id igs_sv_batches.batch_id%TYPE)
13464: IS
13465: SELECT batch_type
13466: FROM igs_sv_batches
13467: WHERE batch_id = cp_batch_id;
13468: l_batch_type VARCHAR2(1);
13469: l_batch_id igs_sv_batches.batch_id%TYPE;
13470: BEGIN

Line 13469: l_batch_id igs_sv_batches.batch_id%TYPE;

13465: SELECT batch_type
13466: FROM igs_sv_batches
13467: WHERE batch_id = cp_batch_id;
13468: l_batch_type VARCHAR2(1);
13469: l_batch_id igs_sv_batches.batch_id%TYPE;
13470: BEGIN
13471: retcode := 0;
13472: /* Debug */
13473: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN

Line 13486: UPDATE igs_sv_batches

13482: CLOSE c_get_batch_type;
13483: Submit_Event ( l_batch_type, batch_id);
13484: /* fix for bug 5330564 */
13485: l_batch_id := batch_id;
13486: UPDATE igs_sv_batches
13487: SET batch_status = 'X' , xml_gen_date = trunc(sysdate)
13488: WHERE batch_id = l_batch_id;
13489:
13490: xml_log_file(batch_id);