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_EN_TRANSFER_APIS dependencies on IGS_EN_SPA_TERMS

Line 192: l_key_program_flag igs_en_spa_terms.key_program_flag%TYPE := FND_API.G_MISS_CHAR;

188: l_src_commence_dt IGS_EN_STDNT_PS_ATT.COMMENCEMENT_DT%TYPE;
189: l_course_attempt_status IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE;
190: l_discont_reason_code IGS_EN_DCNT_REASONCD.discontinuation_reason_cd%TYPE;
191: l_stdnt_ps_attempt_dtls_rec c_get_stdnt_ps_att_dtls%ROWTYPE;
192: l_key_program_flag igs_en_spa_terms.key_program_flag%TYPE := FND_API.G_MISS_CHAR;
193: l_message_name VARCHAR2(2000);
194: BEGIN
195: OPEN c_get_stdnt_ps_att_dtls;
196: FETCH c_get_stdnt_ps_att_dtls INTO l_stdnt_ps_attempt_dtls_rec;

Line 231: igs_en_spa_terms_api.set_spa_term_cal_type(P_TERM_CAL_TYPE);

227: p_discontinued_dt => NULL,
228: p_lapsed_dt => l_stdnt_ps_attempt_dtls_rec.LAPSED_DT,
229: p_course_rqrmnt_complete_ind => l_stdnt_ps_attempt_dtls_rec.COURSE_RQRMNT_COMPLETE_IND,
230: p_logical_delete_dt => l_stdnt_ps_attempt_dtls_rec.logical_delete_dt );
231: igs_en_spa_terms_api.set_spa_term_cal_type(P_TERM_CAL_TYPE);
232: igs_en_spa_terms_api.set_spa_term_sequence_number (p_term_seq_num);
233: IGS_EN_STDNT_PS_ATT_PKG.UPDATE_ROW(
234: X_ROWID => l_stdnt_ps_attempt_dtls_rec.row_id,
235: X_PERSON_ID => l_stdnt_ps_attempt_dtls_rec.PERSON_ID,

Line 232: igs_en_spa_terms_api.set_spa_term_sequence_number (p_term_seq_num);

228: p_lapsed_dt => l_stdnt_ps_attempt_dtls_rec.LAPSED_DT,
229: p_course_rqrmnt_complete_ind => l_stdnt_ps_attempt_dtls_rec.COURSE_RQRMNT_COMPLETE_IND,
230: p_logical_delete_dt => l_stdnt_ps_attempt_dtls_rec.logical_delete_dt );
231: igs_en_spa_terms_api.set_spa_term_cal_type(P_TERM_CAL_TYPE);
232: igs_en_spa_terms_api.set_spa_term_sequence_number (p_term_seq_num);
233: IGS_EN_STDNT_PS_ATT_PKG.UPDATE_ROW(
234: X_ROWID => l_stdnt_ps_attempt_dtls_rec.row_id,
235: X_PERSON_ID => l_stdnt_ps_attempt_dtls_rec.PERSON_ID,
236: X_COURSE_CD => l_stdnt_ps_attempt_dtls_rec.COURSE_CD,

Line 308: igs_en_spa_terms_api.set_spa_term_cal_type(NULL);

304: X_ATTRIBUTE18 => l_stdnt_ps_attempt_dtls_rec.attribute18,
305: X_ATTRIBUTE19 => l_stdnt_ps_attempt_dtls_rec.attribute19,
306: X_ATTRIBUTE20 => l_stdnt_ps_attempt_dtls_rec.attribute20,
307: X_FUTURE_DATED_TRANS_FLAG => p_dest_fut_dt_trans_flag);
308: igs_en_spa_terms_api.set_spa_term_cal_type(NULL);
309: igs_en_spa_terms_api.set_spa_term_sequence_number (NULL);
310: IF p_dest_fut_dt_trans_flag = 'S' THEN
311: igs_en_spa_terms_api.create_update_term_rec(p_person_id => l_stdnt_ps_attempt_dtls_rec.PERSON_ID,
312: p_program_cd => l_stdnt_ps_attempt_dtls_rec.COURSE_CD,

Line 309: igs_en_spa_terms_api.set_spa_term_sequence_number (NULL);

305: X_ATTRIBUTE19 => l_stdnt_ps_attempt_dtls_rec.attribute19,
306: X_ATTRIBUTE20 => l_stdnt_ps_attempt_dtls_rec.attribute20,
307: X_FUTURE_DATED_TRANS_FLAG => p_dest_fut_dt_trans_flag);
308: igs_en_spa_terms_api.set_spa_term_cal_type(NULL);
309: igs_en_spa_terms_api.set_spa_term_sequence_number (NULL);
310: IF p_dest_fut_dt_trans_flag = 'S' THEN
311: igs_en_spa_terms_api.create_update_term_rec(p_person_id => l_stdnt_ps_attempt_dtls_rec.PERSON_ID,
312: p_program_cd => l_stdnt_ps_attempt_dtls_rec.COURSE_CD,
313: p_term_cal_type => P_TERM_CAL_TYPE,

Line 311: igs_en_spa_terms_api.create_update_term_rec(p_person_id => l_stdnt_ps_attempt_dtls_rec.PERSON_ID,

307: X_FUTURE_DATED_TRANS_FLAG => p_dest_fut_dt_trans_flag);
308: igs_en_spa_terms_api.set_spa_term_cal_type(NULL);
309: igs_en_spa_terms_api.set_spa_term_sequence_number (NULL);
310: IF p_dest_fut_dt_trans_flag = 'S' THEN
311: igs_en_spa_terms_api.create_update_term_rec(p_person_id => l_stdnt_ps_attempt_dtls_rec.PERSON_ID,
312: p_program_cd => l_stdnt_ps_attempt_dtls_rec.COURSE_CD,
313: p_term_cal_type => P_TERM_CAL_TYPE,
314: p_term_sequence_number => p_term_seq_num,
315: p_key_program_flag => l_key_program_flag,

Line 332: igs_en_spa_terms_api.set_spa_term_cal_type(NULL);

328:
329: WHEN APP_EXCEPTION.APPLICATION_EXCEPTION THEN
330: --allow calls before dml and after dml to this package from igs_en_stdnt_ps_att_pkg to fire
331: IGS_EN_STDNT_PS_ATT_PKG.skip_before_after_dml := FALSE ;
332: igs_en_spa_terms_api.set_spa_term_cal_type(NULL);
333: igs_en_spa_terms_api.set_spa_term_sequence_number (NULL);
334: RAISE;
335: WHEN FND_API.G_EXC_ERROR THEN
336: IGS_EN_STDNT_PS_ATT_PKG.skip_before_after_dml := FALSE ;

Line 333: igs_en_spa_terms_api.set_spa_term_sequence_number (NULL);

329: WHEN APP_EXCEPTION.APPLICATION_EXCEPTION THEN
330: --allow calls before dml and after dml to this package from igs_en_stdnt_ps_att_pkg to fire
331: IGS_EN_STDNT_PS_ATT_PKG.skip_before_after_dml := FALSE ;
332: igs_en_spa_terms_api.set_spa_term_cal_type(NULL);
333: igs_en_spa_terms_api.set_spa_term_sequence_number (NULL);
334: RAISE;
335: WHEN FND_API.G_EXC_ERROR THEN
336: IGS_EN_STDNT_PS_ATT_PKG.skip_before_after_dml := FALSE ;
337: igs_en_spa_terms_api.set_spa_term_cal_type(NULL);

Line 337: igs_en_spa_terms_api.set_spa_term_cal_type(NULL);

333: igs_en_spa_terms_api.set_spa_term_sequence_number (NULL);
334: RAISE;
335: WHEN FND_API.G_EXC_ERROR THEN
336: IGS_EN_STDNT_PS_ATT_PKG.skip_before_after_dml := FALSE ;
337: igs_en_spa_terms_api.set_spa_term_cal_type(NULL);
338: igs_en_spa_terms_api.set_spa_term_sequence_number (NULL);
339:
340: RAISE;
341: WHEN OTHERS THEN

Line 338: igs_en_spa_terms_api.set_spa_term_sequence_number (NULL);

334: RAISE;
335: WHEN FND_API.G_EXC_ERROR THEN
336: IGS_EN_STDNT_PS_ATT_PKG.skip_before_after_dml := FALSE ;
337: igs_en_spa_terms_api.set_spa_term_cal_type(NULL);
338: igs_en_spa_terms_api.set_spa_term_sequence_number (NULL);
339:
340: RAISE;
341: WHEN OTHERS THEN
342: --allow calls before dml and after dml to this package from igs_en_stdnt_ps_att_pkg to fire

Line 344: igs_en_spa_terms_api.set_spa_term_cal_type(NULL);

340: RAISE;
341: WHEN OTHERS THEN
342: --allow calls before dml and after dml to this package from igs_en_stdnt_ps_att_pkg to fire
343: IGS_EN_STDNT_PS_ATT_PKG.skip_before_after_dml := FALSE ;
344: igs_en_spa_terms_api.set_spa_term_cal_type(NULL);
345: igs_en_spa_terms_api.set_spa_term_sequence_number (NULL);
346: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
347: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_TRANSFER_APIS.update_destination_prgm');
348: IGS_GE_MSG_STACK.ADD;

Line 345: igs_en_spa_terms_api.set_spa_term_sequence_number (NULL);

341: WHEN OTHERS THEN
342: --allow calls before dml and after dml to this package from igs_en_stdnt_ps_att_pkg to fire
343: IGS_EN_STDNT_PS_ATT_PKG.skip_before_after_dml := FALSE ;
344: igs_en_spa_terms_api.set_spa_term_cal_type(NULL);
345: igs_en_spa_terms_api.set_spa_term_sequence_number (NULL);
346: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
347: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_TRANSFER_APIS.update_destination_prgm');
348: IGS_GE_MSG_STACK.ADD;
349: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level ) THEN

Line 928: l_key_program_flag igs_en_spa_terms.key_program_flag%TYPE;

924: --Who When What
925: -- stutta 26-Sep-2005 Added call to create_update_term_rec for bug 4588264
926: -------------------------------------------------------------------------------------------
927:
928: l_key_program_flag igs_en_spa_terms.key_program_flag%TYPE;
929: BEGIN
930:
931: IF p_dest_fut_dt_trans_flag = 'Y' THEN
932: -- delete the global table before populating it

Line 938: igs_en_spa_terms_api.create_update_term_rec(p_person_id => p_person_id,

934: l_key_program_flag := FND_API.G_MISS_CHAR;
935: IF p_key_program_flag = 'Y' THEN
936: l_key_program_flag := p_key_program_flag;
937: END IF;
938: igs_en_spa_terms_api.create_update_term_rec(p_person_id => p_person_id,
939: p_program_cd => p_dest_program_cd,
940: p_term_cal_type => p_term_cal_type,
941: p_term_sequence_NUMBER => p_term_seq_num,
942: p_key_program_flag => l_key_program_flag,

Line 3142: l_key_program IGS_EN_SPA_TERMS.key_program_flag%TYPE;

3138: l_trans_exists_rec c_trans_exists%ROWTYPE;
3139:
3140: l_adm_course_cd IGS_AD_PS_APPL.transfer_course_cd%TYPE;
3141: l_adm_transfer BOOLEAN;
3142: l_key_program IGS_EN_SPA_TERMS.key_program_flag%TYPE;
3143: BEGIN
3144: SAVEPOINT TRANSFER_PRGM;
3145: FND_MSG_PUB.INITIALIZE;
3146: IF is_career_model_enabled THEN