BEGIN
                  FORALL l_nm_loop IN l_nm_start_cnt..l_nm_end_cnt
                     INSERT INTO TVD_TL_PIP_AMOUNT (PIP_AMOUNT_ID, VALUATION_ITERATION_ID, REATTRBN_KEYDATE_ELIGIBLITY_ID,
                                                    SCALED_AMOUNT, SWITCHABLE_AMOUNT, HYB_SWITCHABLE_AMOUNT,
                                                    TOTAL_AMOUNT, MINIMUM_ADDITION_AMOUNT, FINAL_PIP_AMOUNT, MINIMUM_APPLIED_IND,
                                                    CREATE_DATE_TIME, CREATE_USER_ID,
                                                    LAST_UPDATE_DATE_TIME, UPDATE_USER_ID)
                                            VALUES (TVD_TL_PIP_AMOUNT_SEQ.NEXTVAL, l_nm_valuation_iteration_id, TO_NUMBER (g_a100_sm_reckey (l_nm_loop)),
                                                    g_a242_sm_scaled_pip (l_nm_loop), g_a242_sm_switchable_pip (l_nm_loop), g_a242_sm_hyb_npsw_pip (l_nm_loop),
                                                    g_a242_sm_total_pip (l_nm_loop), g_a242_sm_min_amt (l_nm_loop), g_a242_sm_final_pip (l_nm_loop), g_a100_sm_min_applied (l_nm_loop),
                                                    SYSDATE, g_vc_userid,
                                                    SYSDATE, g_vc_userid);
                  l_nm_recs_inserted := l_nm_recs_inserted + SQL%ROWCOUNT;
                  COMMIT;
 
                  l_nm_start_cnt := l_nm_end_cnt + 1;
                  l_nm_end_cnt := l_nm_end_cnt + l_nm_increment;
 
              EXCEPTION
                  WHEN OTHERS THEN
                      p_pip_exceptions_logging (l_vc_component_name, SQLERRM);
                      p_delete_pip_records (l_nm_valuation_iteration_id, l_nm_del_status);
                      l_nm_exit_status := 1;
              END;
          END LOOP;