DBA Data[Home] [Help]

APPS.IGS_AD_INT_RECONSIDER dependencies on IGS_GE_NUMBER

Line 1636: l_prev_acad_cal_seq_no := IGS_GE_NUMBER.TO_NUM(substr(p_curr_acad_adm_cal, 13,7));

1632: l_fut_adm_ci_seq_no := NULL;
1633: l_nominated_course_cd := NULL;
1634:
1635: l_prev_acad_cal_type := rtrim (substr (p_curr_acad_adm_cal, 1,10));
1636: l_prev_acad_cal_seq_no := IGS_GE_NUMBER.TO_NUM(substr(p_curr_acad_adm_cal, 13,7));
1637: l_prev_adm_cal_type := rtrim (substr (p_curr_acad_adm_cal, 23,10));
1638: l_prev_adm_cal_seq_no := IGS_GE_NUMBER.TO_NUM (substr (p_curr_acad_adm_cal, 35,7));
1639:
1640: l_fut_acad_cal_type := rtrim (substr (p_future_acad_adm_cal, 1,10));

Line 1638: l_prev_adm_cal_seq_no := IGS_GE_NUMBER.TO_NUM (substr (p_curr_acad_adm_cal, 35,7));

1634:
1635: l_prev_acad_cal_type := rtrim (substr (p_curr_acad_adm_cal, 1,10));
1636: l_prev_acad_cal_seq_no := IGS_GE_NUMBER.TO_NUM(substr(p_curr_acad_adm_cal, 13,7));
1637: l_prev_adm_cal_type := rtrim (substr (p_curr_acad_adm_cal, 23,10));
1638: l_prev_adm_cal_seq_no := IGS_GE_NUMBER.TO_NUM (substr (p_curr_acad_adm_cal, 35,7));
1639:
1640: l_fut_acad_cal_type := rtrim (substr (p_future_acad_adm_cal, 1,10));
1641: l_fut_acad_cal_seq_no := IGS_GE_NUMBER.TO_NUM (substr (p_future_acad_adm_cal, 13,7));
1642: l_fut_adm_cal_type := rtrim (substr (p_future_acad_adm_cal, 23,10));

Line 1641: l_fut_acad_cal_seq_no := IGS_GE_NUMBER.TO_NUM (substr (p_future_acad_adm_cal, 13,7));

1637: l_prev_adm_cal_type := rtrim (substr (p_curr_acad_adm_cal, 23,10));
1638: l_prev_adm_cal_seq_no := IGS_GE_NUMBER.TO_NUM (substr (p_curr_acad_adm_cal, 35,7));
1639:
1640: l_fut_acad_cal_type := rtrim (substr (p_future_acad_adm_cal, 1,10));
1641: l_fut_acad_cal_seq_no := IGS_GE_NUMBER.TO_NUM (substr (p_future_acad_adm_cal, 13,7));
1642: l_fut_adm_cal_type := rtrim (substr (p_future_acad_adm_cal, 23,10));
1643: l_fut_adm_cal_seq_no := IGS_GE_NUMBER.TO_NUM(substr (p_future_acad_adm_cal, 35,7));
1644:
1645:

Line 1643: l_fut_adm_cal_seq_no := IGS_GE_NUMBER.TO_NUM(substr (p_future_acad_adm_cal, 35,7));

1639:
1640: l_fut_acad_cal_type := rtrim (substr (p_future_acad_adm_cal, 1,10));
1641: l_fut_acad_cal_seq_no := IGS_GE_NUMBER.TO_NUM (substr (p_future_acad_adm_cal, 13,7));
1642: l_fut_adm_cal_type := rtrim (substr (p_future_acad_adm_cal, 23,10));
1643: l_fut_adm_cal_seq_no := IGS_GE_NUMBER.TO_NUM(substr (p_future_acad_adm_cal, 35,7));
1644:
1645:
1646: OPEN c_admission_type(p_application_type);
1647: FETCH c_admission_type INTO l_admission_type;

Line 2354: IGS_GE_NUMBER.TO_CANN(l_appl_inst_rec.future_acad_ci_sequence_number)

2350: l_message_name := 'IGS_AD_CAL_PGM_NOT_OFFER';
2351: fnd_message.set_name('IGS', l_message_name);
2352: fnd_message.set_token('PGM', l_appl_inst_rec.nominated_course_cd);
2353: fnd_message.set_token('ALTCODE',l_appl_inst_rec.future_acad_cal_type||','||
2354: IGS_GE_NUMBER.TO_CANN(l_appl_inst_rec.future_acad_ci_sequence_number)
2355: ||'/'||l_appl_inst_rec.future_adm_cal_type||','||
2356: IGS_GE_NUMBER.TO_CANN(l_appl_inst_rec.future_adm_ci_sequence_number));
2357: fnd_file.put_line(fnd_file.log, fnd_message.get);
2358:

Line 2356: IGS_GE_NUMBER.TO_CANN(l_appl_inst_rec.future_adm_ci_sequence_number));

2352: fnd_message.set_token('PGM', l_appl_inst_rec.nominated_course_cd);
2353: fnd_message.set_token('ALTCODE',l_appl_inst_rec.future_acad_cal_type||','||
2354: IGS_GE_NUMBER.TO_CANN(l_appl_inst_rec.future_acad_ci_sequence_number)
2355: ||'/'||l_appl_inst_rec.future_adm_cal_type||','||
2356: IGS_GE_NUMBER.TO_CANN(l_appl_inst_rec.future_adm_ci_sequence_number));
2357: fnd_file.put_line(fnd_file.log, fnd_message.get);
2358:
2359: ELSE
2360:

Line 3069: IGS_GE_NUMBER.TO_CANN(l_appl_inst_rec.future_acad_ci_sequence_number)

3065: l_message_name := 'IGS_AD_CAL_PGM_NOT_OFFER';
3066: fnd_message.set_name('IGS', l_message_name);
3067: fnd_message.set_token('PGM', l_appl_inst_rec.nominated_course_cd);
3068: fnd_message.set_token('ALTCODE',l_appl_inst_rec.future_acad_cal_type||','||
3069: IGS_GE_NUMBER.TO_CANN(l_appl_inst_rec.future_acad_ci_sequence_number)
3070: ||'/'||l_appl_inst_rec.future_adm_cal_type||','||
3071: IGS_GE_NUMBER.TO_CANN(l_appl_inst_rec.future_adm_ci_sequence_number));
3072: fnd_file.put_line(fnd_file.log, fnd_message.get);
3073: ELSE

Line 3071: IGS_GE_NUMBER.TO_CANN(l_appl_inst_rec.future_adm_ci_sequence_number));

3067: fnd_message.set_token('PGM', l_appl_inst_rec.nominated_course_cd);
3068: fnd_message.set_token('ALTCODE',l_appl_inst_rec.future_acad_cal_type||','||
3069: IGS_GE_NUMBER.TO_CANN(l_appl_inst_rec.future_acad_ci_sequence_number)
3070: ||'/'||l_appl_inst_rec.future_adm_cal_type||','||
3071: IGS_GE_NUMBER.TO_CANN(l_appl_inst_rec.future_adm_ci_sequence_number));
3072: fnd_file.put_line(fnd_file.log, fnd_message.get);
3073: ELSE
3074: fnd_message.set_name('IGS', l_message_name);
3075: fnd_file.put_line(fnd_file.log, fnd_message.get);