440: -- adding this if codition to avoid Lock row problem from self service pages
441: IF x_order_number IS NULL THEN
442: SELECT igs_as_order_hdr_s.NEXTVAL
443: INTO x_order_number
444: FROM dual;
445: END IF;
446: before_dml(
447: p_action => 'INSERT',
448: x_rowid => x_rowid,