STORES_TRANSACTION_DTLS
STORES_SR_DTLS  	====
STORES_CHALAN_DTLS
STORES_PRODUCT_ALIAS
STORES_ISSUE_DTLS
STORES_INDENT_DTLS
STORES_OP_BAL
STORES_REJECTION_MAST
STORES_PO_DTLS          ====
STORES_ITEM_AMST
STORES_REQ_DTLS


CREATE OR REPLACE PROCEDURE UPDATE_ITEM_CODE(P_COMP IN NUMBER,P_OLDITEM_CODE IN CHAR,P_NEWITEM_CODE IN CHAR)
IS

BEGIN
UPDATE STORES.STORES_TRANSACTION_DTLS
SET
ITEM_CODE=P_NEWITEM_CODE
WHERE
ITEM_CODE=P_OLDITEM_CODE
AND
COMP_CODE=P_COMP;

UPDATE STORES.STORES_SR_DTLS
SET
ITEM_CODE=P_NEWITEM_CODE
WHERE
ITEM_CODE=P_OLDITEM_CODE
AND
COMP_CODE=P_COMP;


UPDATE STORES.STORES_SR_PAYCHARGE_DTLS
SET
ITEM_CODE=P_NEWITEM_CODE
WHERE
ITEM_CODE=P_OLDITEM_CODE
AND
COMP_CODE=P_COMP;


UPDATE STORES.STORES_CHALAN_DTLS
SET
ITEM_CODE=P_NEWITEM_CODE
WHERE
ITEM_CODE=P_OLDITEM_CODE
AND
COMP_CODE=P_COMP;

UPDATE STORES.STORES_PRODUCT_ALIAS
SET
ITEM_CODE=P_NEWITEM_CODE
WHERE
ITEM_CODE=P_OLDITEM_CODE
AND
COMP_CODE=P_COMP;

UPDATE STORES.STORES_ISSUE_DTLS
SET
ITEM_CODE=P_NEWITEM_CODE
WHERE
ITEM_CODE=P_OLDITEM_CODE
AND
COMP_CODE=P_COMP;

UPDATE STORES.STORES_INDENT_DTLS
SET
ITEM_CODE=P_NEWITEM_CODE
WHERE
ITEM_CODE=P_OLDITEM_CODE
AND
COMP_CODE=P_COMP;

UPDATE STORES.STORES_REJECTION_MAST
SET
ITEM_CODE=P_NEWITEM_CODE
WHERE
ITEM_CODE=P_OLDITEM_CODE
AND
COMP_CODE=P_COMP;

UPDATE STORES.STORES_PO_DTLS
SET
ITEM_CODE=P_NEWITEM_CODE
WHERE
ITEM_CODE=P_OLDITEM_CODE
AND
COMP_CODE=P_COMP;


UPDATE STORES.STORES_PO_PAYCHARGE_DTLS
SET
ITEM_CODE=P_NEWITEM_CODE
WHERE
ITEM_CODE=P_OLDITEM_CODE
AND
COMP_CODE=P_COMP;

UPDATE STORES.STORES_REQ_DTLS
SET
ITEM_CODE=P_NEWITEM_CODE
WHERE
ITEM_CODE=P_OLDITEM_CODE
AND
COMP_CODE=P_COMP;
END;