296: rec_title c_title%ROWTYPE;
297:
298: CURSOR c_setup IS
299: SELECT wif_unit_set_title
300: FROM igs_da_setup
301: WHERE s_control_num = 1;
302: l_wif_unit_set_title igs_da_setup.wif_unit_set_title%TYPE;
303: BEGIN
304: -- get unit set title
298: CURSOR c_setup IS
299: SELECT wif_unit_set_title
300: FROM igs_da_setup
301: WHERE s_control_num = 1;
302: l_wif_unit_set_title igs_da_setup.wif_unit_set_title%TYPE;
303: BEGIN
304: -- get unit set title
305: OPEN c_title (p_unit_set_cd);
306: FETCH c_title INTO rec_title;