539: x_revision_description VARCHAR2 := NULL)
540: IS
541: l_language_code VARCHAR2(3);
542: l_revision_id NUMBER;
543: l_user_id NUMBER := FND_GLOBAL.User_Id;
544: l_login_id NUMBER := FND_GLOBAL.Login_Id;
545:
546: BEGIN
547:
540: IS
541: l_language_code VARCHAR2(3);
542: l_revision_id NUMBER;
543: l_user_id NUMBER := FND_GLOBAL.User_Id;
544: l_login_id NUMBER := FND_GLOBAL.Login_Id;
545:
546: BEGIN
547:
548: update MTL_ITEM_REVISIONS_B
677: , p_change_notice IN VARCHAR2
678: ) IS
679: l_language_code VARCHAR2(3);
680: l_revision_id NUMBER;
681: l_user_id NUMBER := FND_GLOBAL.User_Id;
682: l_login_id NUMBER := FND_GLOBAL.Login_Id;
683: BEGIN
684:
685: UPDATE MTL_ITEM_REVISIONS_B
678: ) IS
679: l_language_code VARCHAR2(3);
680: l_revision_id NUMBER;
681: l_user_id NUMBER := FND_GLOBAL.User_Id;
682: l_login_id NUMBER := FND_GLOBAL.Login_Id;
683: BEGIN
684:
685: UPDATE MTL_ITEM_REVISIONS_B
686: SET change_notice = p_change_notice,