DBA Data[Home] [Help]

APPS.IGS_EN_TRANSFER_APIS dependencies on IGS_EN_SPA_TERMS_API

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 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,