[Home] [Help]
306: p_end_date date)
307: is
308: begin
309:
310: insert into fwk_tbx_suppliers
311: (supplier_id,
312: name,
313: on_hold_flag,
314: start_date,
327: sysdate,
328: 0
329: from dual
330: where not exists (select null
331: from fwk_tbx_suppliers
332: where supplier_id = p_supplier_id);
333:
334: end insert_supplier;
335: