[Home] [Help]
720: OPEN gc_coo_seq_num;
721: FETCH gc_coo_seq_num INTO gv_coo_seq_num;
722: CLOSE gc_coo_seq_num;
723: x_rowid := NULL;
724: l_org_id := IGS_GE_GEN_003.GET_ORG_ID;
725: IGS_PS_OFR_OPT_PKG.INSERT_ROW(
726: X_ROWID => x_rowid,
727: X_COURSE_CD => p_new_course_cd,
728: X_VERSION_NUMBER => p_new_version_number,
1204:
1205: l_org_id NUMBER(15);
1206: BEGIN
1207: X_ROWID := NULL;
1208: l_org_id := IGS_GE_GEN_003.GET_ORG_ID;
1209: IGS_PS_OFR_PKG.INSERT_ROW(
1210: X_ROWID => x_rowid,
1211: X_COURSE_CD => p_new_course_cd,
1212: X_VERSION_NUMBER => p_new_version_number,
1497:
1498: l_org_id NUMBER(15);
1499: BEGIN
1500: x_rowid := NULL;
1501: l_org_id := IGS_GE_GEN_003.GET_ORG_ID;
1502: IGS_PS_CATEGORISE_PKG.INSERT_ROW(
1503: X_ROWID => x_rowid,
1504: X_COURSE_CD => p_new_course_cd,
1505: X_VERSION_NUMBER => p_new_version_number,
1790: OPEN c_dms_seq;
1791: FETCH c_dms_seq INTO v_seq_num;
1792: CLOSE c_dms_seq;
1793: x_rowid := NULL;
1794: l_org_id := IGS_GE_GEN_003.get_org_id;
1795: IGS_RE_DFLT_MS_SET_PKG.INSERT_ROW(
1796: X_ROWID => x_rowid,
1797: X_COURSE_CD => p_new_course_cd,
1798: X_VERSION_NUMBER => p_new_version_number,
2516: l_c_attribute19 igs_ps_usec_occurs_all.attribute19%TYPE;
2517: l_c_attribute20 igs_ps_usec_occurs_all.attribute20%TYPE;
2518: l_occur_roll_allowed BOOLEAN;
2519: BEGIN
2520: l_org_id := igs_ge_gen_003.get_org_id;
2521:
2522: IF usec_occurs_rec.start_date IS NOT NULL THEN
2523: l_n_num_st_days := usec_occurs_rec.start_date - NVL(gv_old_usec_rec.unit_section_start_date,l_d_src_teach_cal_start_dt);
2524: l_d_uso_dest_start_dt := NVL(gv_new_usec_rec.unit_section_start_date,l_d_dst_teach_cal_start_dt) + l_n_num_st_days;
3920: OPEN c_ou( usec_tro_rec.org_unit_cd,
3921: usec_tro_rec.ou_start_dt);
3922: FETCH c_ou INTO l_ou_exists;
3923: IF c_ou%FOUND THEN
3924: l_org_id := igs_ge_gen_003.get_org_id;
3925:
3926: igs_ps_tch_resp_ovrd_pkg.insert_row(
3927: x_rowid => l_rowid,
3928: x_unit_cd => gv_new_usec_rec.unit_cd,