APPS.EGO_ITEM_STATUSES_PUB dependencies on MTL_STATUS_ATTRIBUTE_VALUES

Line 480: MTL_STATUS_ATTRIBUTE_VALUES

476: -- Check if the pk already exists
477:
478: SELECT COUNT (*) INTO l_count
479: FROM
480: MTL_STATUS_ATTRIBUTE_VALUES
481: WHERE
482: INVENTORY_ITEM_STATUS_CODE = p_item_status_code
483: AND ATTRIBUTE_NAME = p_attribute_name;
484:

Line 490: INSERT INTO MTL_STATUS_ATTRIBUTE_VALUES

486: THEN
487: RAISE G_DUPLICATE_EXCEPTION;
488: END IF;
489:
490: INSERT INTO MTL_STATUS_ATTRIBUTE_VALUES
491: (
492: INVENTORY_ITEM_STATUS_CODE
493: , ATTRIBUTE_NAME
494: , ATTRIBUTE_VALUE

Line 634: UPDATE MTL_STATUS_ATTRIBUTE_VALUES

630: END IF;
631:
632: ------------------------------
633:
634: UPDATE MTL_STATUS_ATTRIBUTE_VALUES
635: SET
636: ATTRIBUTE_VALUE = p_attribute_value
637: , LAST_UPDATED_BY = g_current_user_id
638: , LAST_UPDATE_DATE = l_Sysdate