APPS.IGS_EN_ADD_UNITS_API dependencies on IGS_EN_SU_ATTEMPT_PKG

Line 3539: IGS_EN_SU_ATTEMPT_PKG.INSERT_ROW (

3535: END IF;
3536: END LOOP;
3537:
3538: l_message_tokens := NULL;
3539: IGS_EN_SU_ATTEMPT_PKG.INSERT_ROW (
3540: X_ROWID => l_rowid ,
3541: X_PERSON_ID => p_person_id ,
3542: X_COURSE_CD => p_course_cd ,
3543: X_UNIT_CD => l_unit_rec.unit_cd ,

Line 3834: IGS_EN_SU_ATTEMPT_PKG.UPDATE_ROW(

3830: IF c_get_sua_dtls%FOUND THEN
3831: CLOSE c_get_sua_dtls;
3832:
3833: -- enroll the unit attempts
3834: IGS_EN_SU_ATTEMPT_PKG.UPDATE_ROW(
3835: X_ROWID => l_sua_rec.row_id ,
3836: X_PERSON_ID => l_sua_rec.person_id ,
3837: X_COURSE_CD => l_sua_rec.course_cd ,
3838: X_UNIT_CD => l_sua_rec.unit_cd ,

Line 3951: IGS_EN_SU_ATTEMPT_PKG.pkg_source_of_drop := NULL;

3947: END IF; -- IF c_get_sua_dtls%FOUND
3948: EXCEPTION
3949:
3950: WHEN NO_AUSL_RECORD_FOUND THEN
3951: IGS_EN_SU_ATTEMPT_PKG.pkg_source_of_drop := NULL;
3952: p_message := 'IGS_SS_CANTDET_ADM_UNT_STATUS';
3953: p_return_status := 'FALSE';
3954: RETURN;
3955:

Line 4032: IGS_EN_SU_ATTEMPT_PKG.pkg_source_of_drop := NULL;

4028:
4029: EXCEPTION
4030:
4031: WHEN NO_AUSL_RECORD_FOUND THEN
4032: IGS_EN_SU_ATTEMPT_PKG.pkg_source_of_drop := NULL;
4033: p_message := 'IGS_SS_CANTDET_ADM_UNT_STATUS';
4034: p_return_status := 'FALSE';
4035: RETURN;
4036:

Line 4091: IGS_EN_SU_ATTEMPT_PKG.pkg_source_of_drop := NULL;

4087: END IF;
4088:
4089: EXCEPTION
4090: WHEN OTHERS THEN
4091: IGS_EN_SU_ATTEMPT_PKG.pkg_source_of_drop := NULL;
4092: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level ) THEN
4093: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_add_units_api.create_planned_sua :',SQLERRM);
4094: END IF;
4095: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');

Line 5368: IGS_EN_SU_ATTEMPT_PKG.pkg_source_of_drop := 'PLAN';

5364: IF p_calling_obj = 'PLAN' THEN
5365:
5366: SAVEPOINT sp_plan_sua;
5367: l_return_status := NULL;
5368: IGS_EN_SU_ATTEMPT_PKG.pkg_source_of_drop := 'PLAN';
5369: create_planned_sua( p_person_id,
5370: p_course_cd,
5371: p_course_version,
5372: p_load_cal_type,

Line 5381: IGS_EN_SU_ATTEMPT_PKG.pkg_source_of_drop := NULL;

5377: l_enr_comm,
5378: p_message,
5379: l_return_status,
5380: p_calling_obj);
5381: IGS_EN_SU_ATTEMPT_PKG.pkg_source_of_drop := NULL;
5382: ROLLBACK TO sp_plan_sua; -- needs to be rollbacked as this is just for making validations
5383:
5384: IF l_return_status = 'FALSE' THEN
5385: p_return_status := 'FALSE';

Line 5611: IGS_EN_SU_ATTEMPT_PKG.pkg_source_of_drop := NULL;

5607: EXCEPTION
5608:
5609: WHEN OTHERS THEN
5610: igs_en_add_units_api.g_ss_session_id := NULL;
5611: IGS_EN_SU_ATTEMPT_PKG.pkg_source_of_drop := NULL;
5612: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level ) THEN
5613: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_add_units_api.add_selected_units :',SQLERRM);
5614: END IF;
5615: ROLLBACK TO sp_add_units_api;