198:
199:
200: CURSOR cur_org_unit_st_dt(p_org_unit_cd VARCHAR2) IS
201: SELECT start_dt
202: FROM igs_or_unit
203: WHERE org_unit_cd = p_org_unit_cd;
204:
205: CURSOR cur_person_id_grp(p_person_id_group NUMBER) IS
206: SELECT PG.GROUP_CD||'-'||PG.GROUP_ID
242: l_message_name VARCHAR2(30) := NULL;
243: l_elgb_override_id igs_en_elgb_ovr.elgb_override_id%TYPE;
244: l_rowid VARCHAR2(30);
245: l_record_found BOOLEAN :=FALSE;
246: l_org_unit_start_dt igs_or_unit.start_dt%TYPE;
247: l_person_id_grp VARCHAR2(20);
248: l_person_id VARCHAR2(20);
249: l_step IGS_Lookups_view.meaning%TYPE;
250: l_load_cal_type igs_ca_teach_to_load_v.load_cal_type%TYPE;