55: l_api_name CONSTANT VARCHAR2(30) := 'Insert_sch';
56: l_api_version CONSTANT NUMBER := 1.0;
57:
58: -- Cursor added as part of Enh bug#2833850
59: CURSOR cur_usec(cp_n_usec_id igs_ps_usec_occurs_all.unit_section_occurrence_id%TYPE) IS
60: SELECT *
61: FROM igs_ps_usec_occurs_all
62: WHERE unit_section_occurrence_id = cp_n_usec_id;
63:
57:
58: -- Cursor added as part of Enh bug#2833850
59: CURSOR cur_usec(cp_n_usec_id igs_ps_usec_occurs_all.unit_section_occurrence_id%TYPE) IS
60: SELECT *
61: FROM igs_ps_usec_occurs_all
62: WHERE unit_section_occurrence_id = cp_n_usec_id;
63:
64: -- Cursor added as part of Enh bug#2833850
65: CURSOR c_cal(cp_c_cal_type igs_ca_inst.cal_type%TYPE,