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;