[Home] [Help]
83: BEGIN
84: DECLARE
85: CURSOR c_note_seq IS
86: SELECT IGS_GE_NOTE_RF_NUM_S.nextval
87: FROM dual;
88: CURSOR c_note IS
89: SELECT IGS_GE_NOTE.s_note_format_type,
90: IGS_GE_NOTE.note_text
91: FROM IGS_GE_NOTE IGS_GE_NOTE
744: BEGIN
745: --- Get new reference number
746: SELECT IGS_GE_NOTE_RF_NUM_S.nextval
747: INTO p_new_ref_number
748: FROM dual;
749: --- Get related IGS_GE_NOTE and insert under new reference number
750:
751: For SGN_Rec In SGN_CUR
752: Loop
1426: CLOSE c_latest_gs_version;
1427: BEGIN
1428: SELECT IGS_PS_UNIT_OFR_OPT_UOO_ID_S.nextval
1429: INTO v_new_uoo_id
1430: FROM dual;
1431: x_rowid := NULL;
1432:
1433: l_org_id := igs_ge_gen_003.get_org_id;
1434: -- Added auditable_ind, audit_permission_ind parameters to the following call to insert_row
1630: -- End of the latest version check of Grading Schema.
1631: --
1632: SELECT IGS_AS_UNITASS_ITEM_SEQ_NUM_S.nextval
1633: INTO v_new_sequence_number
1634: FROM dual;
1635: x_rowid := NULL;
1636: l_unit_ass_item_id := NULL;
1637:
1638: IGS_AS_UNITASS_ITEM_PKG.INSERT_ROW(
2588: v_uoo_rec_exists c_uoo_rec_exists%ROWTYPE;
2589:
2590: CURSOR c_uoo_seq_num IS
2591: SELECT IGS_PS_UNIT_OFR_OPT_UOO_ID_S.NEXTVAL
2592: FROM DUAL;
2593:
2594: CURSOR c_uai_seq_num IS
2595: SELECT IGS_AS_UNITASS_ITEM_SEQ_NUM_S.NEXTVAL
2596: FROM DUAL;
2592: FROM DUAL;
2593:
2594: CURSOR c_uai_seq_num IS
2595: SELECT IGS_AS_UNITASS_ITEM_SEQ_NUM_S.NEXTVAL
2596: FROM DUAL;
2597:
2598: CURSOR c_teach_date(cp_cal_type igs_ca_inst_all.cal_type%TYPE ,cp_seq_num igs_ca_inst_all.sequence_number%TYPE) IS
2599: SELECT start_dt,end_dt
2600: FROM igs_ca_inst_all