508: ** - Bala BALAKUMAR.
509: */
510:
511: -- commented out by abedajna for perf. tuning
512: /* select wsm_split_merge_transactions_s.nextval
513: ** into txn.transaction_id
514: ** from dual;
515: **
516: **
522: -- begin modification by abedajna for perf. tuning
523:
524: lProcLocation := 130;
525: update wsm_lot_split_merges_interface
526: set transaction_id = wsm_split_merge_transactions_s.nextval
527: Where header_id = txn.header_id
528: returning transaction_id into txn.transaction_id;
529:
530: -- end modification by abedajna for perf. tuning