[Home] [Help]
305: p_load_ci_seq_num IN NUMBER)
306: RETURN BOOLEAN AS
307: /* HISTORY
308: WHO WHEN WHAT
309: bdeviset 29-JUL-2004 Before calling IGS_AS_SU_SETATMPT_PKG.UPDATE_ROW/INSERT_ROW in a check is
310: made to see that their is no overlapping of selection,completion and
311: end dates for any two unit sets by calling check_usa_overlap.If it returns
312: false log entry is made and the insert or update is not carried out for bug 3149133.
313: knag 29-OCT-2002 Bug 2647482 addded parameters attendance_mode, location_cd for calculation
2236:
2237: -- Bug#2347141
2238: -- Its updating the record in the Unit Set Attempt table with student conformed indicator as 'Y'
2239: -- and the Selection date as the value in the local variable.
2240: IGS_AS_SU_SETATMPT_PKG.UPDATE_ROW(
2241: X_ROWID => v_susa_rec.rowid,
2242: X_PERSON_ID => v_susa_rec.person_id ,
2243: X_COURSE_CD => v_susa_rec.course_cd ,
2244: X_UNIT_SET_CD => v_susa_rec.unit_set_cd ,
3544: RETURN FALSE;
3545: END IF ;
3546:
3547: -- set the current year of program to completed
3548: IGS_AS_SU_SETATMPT_PKG.UPDATE_ROW (
3549: X_ROWID => c_susa_upd_rec.rowid,
3550: X_PERSON_ID => c_susa_upd_rec.person_id ,
3551: X_COURSE_CD => c_susa_upd_rec.course_cd ,
3552: X_UNIT_SET_CD => c_susa_upd_rec.unit_set_cd ,
3726: END IF;
3727: RETURN FALSE;
3728: END IF;
3729:
3730: IGS_AS_SU_SETATMPT_PKG.UPDATE_ROW (
3731: X_ROWID => c_susa_upd_rec.rowid,
3732: X_PERSON_ID => c_susa_upd_rec.person_id,
3733: X_COURSE_CD => c_susa_upd_rec.course_cd ,
3734: X_UNIT_SET_CD => c_susa_upd_rec.unit_set_cd ,
4057: )
4058: RETURN boolean AS
4059: /* HISTORY
4060: WHO WHEN WHAT
4061: bdeviset 29-JUL-2004 Before calling IGS_AS_SU_SETATMPT_PKG.UPDATE_ROW/INSERT_ROW in a check is
4062: made to see that their is no overlapping of selection,completion and
4063: end dates for any two unit sets by calling check_usa_overlap.If it returns
4064: false log entry is made and the insert or update is not carried out for bug 3149133.
4065: ayedubat 4-JUN-2002 Changed the Code of YOP for Unit Set pre-enrollment before
5180: RETURN FALSE;
5181: END IF ;
5182:
5183: -- set the current year of program to completed
5184: IGS_AS_SU_SETATMPT_PKG.UPDATE_ROW (
5185: X_ROWID => c_susa_upd_rec.rowid,
5186: X_PERSON_ID => c_susa_upd_rec.person_id ,
5187: X_COURSE_CD => c_susa_upd_rec.course_cd ,
5188: X_UNIT_SET_CD => c_susa_upd_rec.unit_set_cd ,
6928: -- Transfer the IGS_EN_SU_ATTEMPT.
6929: DECLARE
6930: l_rowid VARCHAR2(25) := NULL;
6931: BEGIN
6932: IGS_AS_SU_SETATMPT_PKG.INSERT_ROW (
6933: x_rowid => l_rowid,
6934: x_person_id => p_person_id,
6935: x_course_cd => p_transfer_course_cd,
6936: x_unit_set_cd => p_unit_set_cd,
7935:
7936: ------------------------------------------------------------------------------------------------
7937: --Change History:
7938: --Who When What
7939: --bdeviset 29-JUL-2004 Added p_log_creation_dt as parameter.Before calling IGS_AS_SU_SETATMPT_PKG.UPDATE_ROW/INSERT_ROW
7940: -- a check is made to see that their is no overlapping of selection,completion and
7941: -- end dates for any two unit sets by calling check_usa_overlap.If it returns
7942: -- false log entry is made and the insert or update is not carried out for bug 3149133.
7943: ------------------------------------------------------------------------------------------------
8035: END IF;
8036: RETURN FALSE;
8037: END IF ;
8038:
8039: IGS_AS_SU_SETATMPT_PKG.INSERT_ROW (
8040: X_ROWID => vl_rowid,
8041: X_PERSON_ID => p_person_id ,
8042: X_COURSE_CD => p_course_cd ,
8043: X_UNIT_SET_CD => vc_acad_us_rec.stream_unit_set_cd ,
8125: END IF;
8126: RETURN FALSE;
8127: END IF ;
8128:
8129: IGS_AS_SU_SETATMPT_PKG.UPDATE_ROW (
8130: X_ROWID => vc_susa_upd_rec.rowid,
8131: X_PERSON_ID => vc_susa_upd_rec.person_id ,
8132: X_COURSE_CD => vc_susa_upd_rec.course_cd ,
8133: X_UNIT_SET_CD => vc_susa_upd_rec.unit_set_cd ,
8203:
8204: ------------------------------------------------------------------------------------------------
8205: --Change History:
8206: --Who When What
8207: --bdeviset 29-JUL-2004 Added p_log_creation_dt as parameter.Before calling IGS_AS_SU_SETATMPT_PKG.UPDATE_ROW/INSERT_ROW
8208: -- a check is made to see that their is no overlapping of selection,completion and
8209: -- end dates for any two unit sets by calling check_usa_overlap.If it returns
8210: -- false log entry is made and the insert or update is not carried out for bug 3149133.
8211: ------------------------------------------------------------------------------------------------
8286: END IF;
8287: RETURN FALSE;
8288: END IF ;
8289:
8290: IGS_AS_SU_SETATMPT_PKG.UPDATE_ROW (
8291: X_ROWID => v_susa_rec.rowid,
8292: X_PERSON_ID => v_susa_rec.person_id ,
8293: X_COURSE_CD => v_susa_rec.course_cd ,
8294: X_UNIT_SET_CD => v_susa_rec.unit_set_cd ,
8372: RETURN FALSE;
8373: END IF ;
8374:
8375:
8376: IGS_AS_SU_SETATMPT_PKG.INSERT_ROW (
8377: x_rowid => l_rowid,
8378: x_person_id => p_person_id,
8379: x_course_cd => p_course_cd,
8380: x_unit_set_cd => p_unit_set_cd,
8437:
8438: ------------------------------------------------------------------------------------------------
8439: --Change History:
8440: --Who When What
8441: --bdeviset 29-JUL-2004 Added p_log_creation_dt as parameter.Before calling IGS_AS_SU_SETATMPT_PKG.UPDATE_ROW/INSERT_ROW
8442: -- a check is made to see that their is no overlapping of selection,completion and
8443: -- end dates for any two unit sets by calling check_usa_overlap.If it returns
8444: -- false log entry is made and the insert or update is not carried out for bug 3149133.
8445: ------------------------------------------------------------------------------------------------
8541: RETURN FALSE;
8542: END IF ;
8543:
8544:
8545: IGS_AS_SU_SETATMPT_PKG.UPDATE_ROW (
8546: X_ROWID => vc_susa_upd_rec.rowid,
8547: X_PERSON_ID => vc_susa_upd_rec.person_id ,
8548: X_COURSE_CD => vc_susa_upd_rec.course_cd ,
8549: X_UNIT_SET_CD => vc_susa_upd_rec.unit_set_cd ,