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_DA_TRNS_IMP dependencies on IGS_DA_REQ_STDNTS

Line 70: UPDATE igs_da_req_stdnts

66: UPDATE igs_da_rqst
67: SET request_status = 'COMPLETE_ERROR'
68: WHERE batch_id = p_batch_id;
69:
70: UPDATE igs_da_req_stdnts
71: SET report_text = v_report_text,
72: ERROR_CODE = l_error_code
73: WHERE batch_id = p_batch_id
74: AND person_id = p_person_id

Line 1008: p_batch_id IN igs_da_req_stdnts.batch_id%TYPE,

1004: );
1005: END create_term_unit_details;
1006:
1007: FUNCTION process_term_unit_details (
1008: p_batch_id IN igs_da_req_stdnts.batch_id%TYPE,
1009: p_person_id IN hz_parties.party_id%TYPE,
1010: p_program_cd IN igs_av_lgcy_unt_int.program_cd%TYPE,
1011: p_trans_cur_rec IN OUT NOCOPY trans_cur_rec
1012: )

Line 1281: p_batch_id IN igs_da_req_stdnts.batch_id%TYPE,

1277: );
1278: END update_term_details;
1279:
1280: PROCEDURE process_term_details (
1281: p_batch_id IN igs_da_req_stdnts.batch_id%TYPE,
1282: p_person_id IN hz_parties.party_id%TYPE,
1283: p_program_cd IN igs_av_lgcy_unt_int.program_cd%TYPE,
1284: p_trans_cur_rec IN OUT NOCOPY trans_cur_rec
1285: )

Line 1339: p_batch_id IN igs_da_req_stdnts.batch_id%TYPE,

1335: write_message('ERROR ' || sqlerrm);
1336: END process_term_details;
1337:
1338: PROCEDURE create_acad_hist_rec (
1339: p_batch_id IN igs_da_req_stdnts.batch_id%TYPE,
1340: p_program_cd IN igs_av_lgcy_unt_int.program_cd%TYPE,
1341: p_person_id_code IN igs_pe_alt_pers_id.api_person_id%TYPE,
1342: p_person_id_code_type IN igs_pe_alt_pers_id.api_person_id%TYPE,
1343: p_term_type IN VARCHAR2,

Line 3334: FROM igs_da_req_stdnts

3330:
3331: CURSOR c_stdnts_batch (p_person_id hz_parties.party_id%TYPE)
3332: IS
3333: SELECT 'x'
3334: FROM igs_da_req_stdnts
3335: WHERE batch_id = p_batch_id
3336: AND person_id = p_person_id
3337: AND ERROR_CODE = 'INP';
3338:

Line 3356: l_igs_da_req_stdnts_id igs_da_req_stdnts.igs_da_req_stdnts_id%TYPE;

3352: v_dummy_rowid ROWID;
3353: l_return_status VARCHAR2 (500);
3354: l_msg_data VARCHAR2 (2000);
3355: l_msg_count NUMBER;
3356: l_igs_da_req_stdnts_id igs_da_req_stdnts.igs_da_req_stdnts_id%TYPE;
3357: BEGIN
3358: ecx_debug.push ('IGS_DA_TRNS_IMP.CREATE_OR_GET_BATCH_ID');
3359: write_message (' p_batch_id ' || p_batch_id);
3360: write_message (' p_person_id_code ' || p_person_id_code);

Line 3509: write_message ('* INSERT INTO IGS_DA_REQ_STDNTS *');

3505: AND l_batch_id IS NOT NULL
3506: THEN
3507: write_message ('create_or_get_batch_id : Adding students to request'
3508: );
3509: write_message ('***** INSERT INTO IGS_DA_REQ_STDNTS *****');
3510: v_dummy_rowid := NULL;
3511: igs_da_req_stdnts_pkg.insert_row (x_rowid => v_dummy_rowid,
3512: x_batch_id => l_batch_id,
3513: x_igs_da_req_stdnts_id => l_igs_da_req_stdnts_id,

Line 3511: igs_da_req_stdnts_pkg.insert_row (x_rowid => v_dummy_rowid,

3507: write_message ('create_or_get_batch_id : Adding students to request'
3508: );
3509: write_message ('***** INSERT INTO IGS_DA_REQ_STDNTS *****');
3510: v_dummy_rowid := NULL;
3511: igs_da_req_stdnts_pkg.insert_row (x_rowid => v_dummy_rowid,
3512: x_batch_id => l_batch_id,
3513: x_igs_da_req_stdnts_id => l_igs_da_req_stdnts_id,
3514: x_person_id => l_person_id,
3515: x_program_code => p_program_code,

Line 3513: x_igs_da_req_stdnts_id => l_igs_da_req_stdnts_id,

3509: write_message ('***** INSERT INTO IGS_DA_REQ_STDNTS *****');
3510: v_dummy_rowid := NULL;
3511: igs_da_req_stdnts_pkg.insert_row (x_rowid => v_dummy_rowid,
3512: x_batch_id => l_batch_id,
3513: x_igs_da_req_stdnts_id => l_igs_da_req_stdnts_id,
3514: x_person_id => l_person_id,
3515: x_program_code => p_program_code,
3516: x_wif_program_code => NULL,
3517: x_special_program_code => NULL,

Line 3526: UPDATE igs_da_req_stdnts

3522: x_mode => 'R',
3523: x_error_code => 'INP'
3524: );
3525: ELSE
3526: UPDATE igs_da_req_stdnts
3527: SET ERROR_CODE = 'INP'
3528: WHERE batch_id = p_batch_id AND person_id = l_person_id;
3529: END IF;
3530: ELSE

Line 3562: UPDATE igs_da_req_stdnts

3558: write_message ( 'Entered complete_import_process p_batch_id='
3559: || p_batch_id
3560: );
3561:
3562: UPDATE igs_da_req_stdnts
3563: SET ERROR_CODE = NULL
3564: WHERE batch_id = p_batch_id AND ERROR_CODE = 'INP';
3565:
3566: UPDATE igs_da_req_stdnts

Line 3566: UPDATE igs_da_req_stdnts

3562: UPDATE igs_da_req_stdnts
3563: SET ERROR_CODE = NULL
3564: WHERE batch_id = p_batch_id AND ERROR_CODE = 'INP';
3565:
3566: UPDATE igs_da_req_stdnts
3567: SET report_text =
3568: ' Transfer Evaluation

'
3569: || 'Completed Successfully'
3570: || ' '