537: x_revision_description VARCHAR2 := NULL)
538: IS
539: l_language_code VARCHAR2(3);
540: l_revision_id NUMBER;
541: l_user_id NUMBER := FND_GLOBAL.User_Id;
542: l_login_id NUMBER := FND_GLOBAL.Login_Id;
543:
544: BEGIN
545:
538: IS
539: l_language_code VARCHAR2(3);
540: l_revision_id NUMBER;
541: l_user_id NUMBER := FND_GLOBAL.User_Id;
542: l_login_id NUMBER := FND_GLOBAL.Login_Id;
543:
544: BEGIN
545:
546: update MTL_ITEM_REVISIONS_B
654: , p_change_notice IN VARCHAR2
655: ) IS
656: l_language_code VARCHAR2(3);
657: l_revision_id NUMBER;
658: l_user_id NUMBER := FND_GLOBAL.User_Id;
659: l_login_id NUMBER := FND_GLOBAL.Login_Id;
660: BEGIN
661:
662: UPDATE MTL_ITEM_REVISIONS_B
655: ) IS
656: l_language_code VARCHAR2(3);
657: l_revision_id NUMBER;
658: l_user_id NUMBER := FND_GLOBAL.User_Id;
659: l_login_id NUMBER := FND_GLOBAL.Login_Id;
660: BEGIN
661:
662: UPDATE MTL_ITEM_REVISIONS_B
663: SET change_notice = p_change_notice,