925: LOOP
926:
927: -- ## Delete the records from the LOC table.
928:
929: igf_sl_awd_disb_loc_pkg.delete_row (lcur_disb_loc.row_id);
930:
931: END LOOP;
932:
933: -- ## Insert the new record from igf_aw_awd record to igf_aw_awd_disb_loc table
933: -- ## Insert the new record from igf_aw_awd record to igf_aw_awd_disb_loc table
934:
935: FOR lcur_award IN cur_award(lc_lor.award_id)
936: LOOP
937: igf_sl_awd_disb_loc_pkg.insert_row (
938: x_mode => 'R',
939: x_rowid => l_rowid,
940: X_award_id => lcur_award.award_id,
941: X_disb_num => lcur_award.disb_num,