DBA Data[Home] [Help]

APPS.INV_ITEM_CATEGORY_PUB dependencies on MTL_CATEGORIES_S

Line 1604: SELECT mtl_categories_s.nextval

1600: l_row_id VARCHAR2(20);
1601: l_sys_date DATE := Sysdate;
1602:
1603: CURSOR new_category_id IS
1604: SELECT mtl_categories_s.nextval
1605: FROM dual;
1606: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1607: BEGIN
1608: -- Standard Start of API savepoint

Line 1641: mdebug('Dubious error with the MTL_CATEGORIES_S sequence');

1637: OPEN new_category_id;
1638: FETCH new_category_id INTO l_category_id;
1639: IF (new_category_id%NOTFOUND) THEN
1640: IF (l_debug = 1) THEN
1641: mdebug('Dubious error with the MTL_CATEGORIES_S sequence');
1642: END IF;
1643: END IF;
1644: CLOSE new_category_id;
1645: