const_def_org VARCHAR2(100) := 'Default Organization';

BEGIN

DELETE eim_prodinvloc
WHERE if_row_batch_num
BETWEEN p_if_row_batch_num_min
AND p_if_row_batch_num_max;

COMMIT;

INSERT INTO eim_prodinvloc
(
row_id,
if_row_stat,
if_row_batch_num,
pil_invloc_bu,
pil_invloc_name,
pil_prod_bu,
pil_prod_name,
pil_cg_active_flg,
pil_cgrtlaudit_flg,
cg_op_acc_bu,
cg_op_acc_loc,
cg_op_acc_name,
cg_op_prod_bu,
cg_op_prod_name
)
 (SELECT rownum,
         p_eim_string
         p_if_row_batch_num_min + FLOOR(rownum/p_def_batch_num),
         const_def_org,
         merch_loc_name,
         const_def_org,
         product_name,
         'Y',
         ret_audit_flag,
         const_def_org,
         olet_loc,
         outlet_name,
         const_def_org,
         product_name
FROM (SELECT merch_loc_name
            ,product_name
            ,outlet_name
            ,olet_loc
            ,ret_audit_flag
      FROM   V3_BC_MERCH_ASSORTMENT
     MINUS
      SELECT merch_loc_name
            ,product_name
            ,outlet_name
            ,olet_loc
            ,ret_audit_flag
      FROM   siebeletl.bc_populate_merch_assort@sibdb));

COMMIT;

EXCEPTION
WHEN OTHERS THEN
ROLLBACK;
p_status := 1;
p_message := 'PROC_BC_POPULATE_MERCH_ASSORT : ' || SQLERRM;

END;