[Home] [Help]
345: p_end_date date)
346: is
347: begin
348:
349: insert into fwk_tbx_supplier_sites
350: (supplier_id,
351: supplier_site_id,
352: site_name,
353: payment_terms_code,
374: sysdate,
375: 0
376: from dual
377: where not exists (select null
378: from fwk_tbx_supplier_sites
379: where supplier_site_id = p_supplier_site_id);
380:
381: end insert_supplier_site;
382: