Script to Update the Item Revision with API (INV_ITEM_REVISION_PUB.UPDATE_ITEM_REVISION)
Hello Team,
Can anyone please share the script to update Item Revision Implementation date through API, I have tried with below script but unable to update the value can you lease help me.
DECLARE
l_return_status VARCHAR2 (10000);
l_errorcode NUMBER;
l_msg_count NUMBER;
l_msg_data VARCHAR2 (10000);
l_api_version NUMBER := 1.0;
-- l_organization_id NUMBER := 204;
-- l_inventory_item_id NUMBER := 592008;
L_ITEM_REVISION_REC INV_ITEM_REVISION_PUB.ITEM_REVISION_REC_TYPE;
BEGIN
DBMS_OUTPUT.put_line ('Starting ...');
FND_GLOBAL.APPS_INITIALIZE(54883,20634,401);
DBMS_OUTPUT.put_line ('INV Debug Profile: ' || fnd_profile.VALUE ('INV_DEBUG_TRACE'