[Home] [Help]
1306:
1307: CURSOR c_get_item_properties
1308: IS
1309: SELECT COUNT(*)
1310: FROM gr_item_properties ip
1311: WHERE ip.label_code = p_label_code;
1312:
1313: /* Item Toxic */
1314:
1410: OPEN c_get_item_properties;
1411: FETCH c_get_item_properties INTO l_record_count;
1412: IF l_record_count <> 0 THEN
1413: l_return_status := 'E';
1414: l_msg_data := l_msg_data || 'gr_item_properties, ';
1415: END IF;
1416: CLOSE c_get_item_properties;
1417:
1418: /* Item Toxic */