DBA Data[Home] [Help]

APPS.INV_ITEM_REVISION_PUB dependencies on MTL_ITEM_REVISIONS_B_S

Line 931: SELECT mtl_item_revisions_b_s.CURRVAL

927: END IF;
928:
929: IF p_Item_Revision_rec.revision_id IS NOT NULL THEN
930: BEGIN
931: SELECT mtl_item_revisions_b_s.CURRVAL
932: INTO l_revision_id FROM DUAL;
933: IF p_Item_Revision_rec.revision_id > l_revision_id THEN
934: Add_Message ('INV', 'INV_INVALID_REVISION_ID');
935: RAISE FND_API.g_EXC_ERROR;

Line 946: SELECT mtl_item_revisions_b_s.NEXTVAL

942: END IF;
943:
944: IF p_Item_Revision_rec.revision_id IS NULL THEN
945:
946: SELECT mtl_item_revisions_b_s.NEXTVAL
947: INTO p_Item_Revision_rec.revision_id
948: FROM DUAL;
949:
950: END IF;