382: v_prod_id NUMBER;
383: v_sob_name VARCHAR2(80);
384: v_le_name VARCHAR2(80);
385: v_ou_name VARCHAR2(80);
386: v_org_name HR_ALL_ORGANIZATION_UNITS.NAME%TYPE;
387: v_area_name VARCHAR2(80);
388: v_country_name VARCHAR2(80);
389: v_prod_name VARCHAR2(80);
390: v_item_name VARCHAR2(80);