113: -- If statement type is detail then pull sequence number and bind it
114: IF p_sum_detail_flag = 1 THEN
115: SELECT mtl_short_chk_temp_s.NEXTVAL
116: INTO x_seq_num 117: FROM dual; 118: --
119: dbms_sql.bind_variable(L_ExecStatement_crs,':seq_num',
120: x_seq_num);
121: ELSE