121: OPEN c_hesa_seq_num;
122: FETCH c_hesa_seq_num INTO v_hesa_seq_num;
123: CLOSE c_hesa_seq_num;
124:
125: l_org_id := igs_ge_gen_003.get_org_id;
126: x_rowid := NULL;
127:
128: igs_he_st_prog_all_pkg.insert_row(
129: X_ROWID => x_rowid,
283: FETCH c_poous_seq_num INTO v_poous_seq_num;
284: CLOSE c_poous_seq_num;
285:
286: x_rowid := NULL;
287: l_org_id := igs_ge_gen_003.get_org_id;
288:
289: igs_he_poous_all_pkg.insert_row(
290: X_ROWID => x_rowid,
291: X_ORG_ID => l_org_id,
492: OPEN c_pooou_seq_num;
493: FETCH c_pooou_seq_num INTO v_pooou_seq_num;
494: CLOSE c_pooou_seq_num;
495:
496: l_org_id := igs_ge_gen_003.get_org_id;
497: x_rowid := NULL;
498:
499:
500: igs_he_poous_ou_all_pkg.insert_row(