The following lines contain the word 'select', 'insert', 'update' or 'delete':
l_rows_updated INTEGER;
l_update_stmt VARCHAR2(4000);
l_update_stmt := 'SELECT m.inventory_item_id
FROM mtl_system_items m
WHERE m.organization_id = :l_org ';
l_update_stmt := l_update_stmt || 'AND m.CUSTOMER_ORDER_FLAG = ''Y'' ';
l_update_stmt := l_update_stmt ||
'AND (m.segment1 IS NULL) ';
l_update_stmt := l_update_stmt ||
'AND (m.segment1 BETWEEN ';
l_update_stmt := l_update_stmt ||p_segment1_lohi;
l_update_stmt := l_update_stmt ||' )';
l_update_stmt := l_update_stmt ||
'AND (m.segment2 IS NULL) ';
l_update_stmt := l_update_stmt ||
'AND (m.segment2 BETWEEN ';
l_update_stmt := l_update_stmt ||p_segment2_lohi;
l_update_stmt := l_update_stmt ||' )';
l_update_stmt := l_update_stmt ||
'AND (m.segment3 IS NULL) ';
l_update_stmt := l_update_stmt ||
'AND (m.segment3 BETWEEN ';
l_update_stmt := l_update_stmt ||p_segment3_lohi;
l_update_stmt := l_update_stmt ||' )';
l_update_stmt := l_update_stmt ||
'AND (m.segment4 IS NULL) ';
l_update_stmt := l_update_stmt ||
'AND (m.segment4 BETWEEN ';
l_update_stmt := l_update_stmt ||p_segment4_lohi;
l_update_stmt := l_update_stmt ||' )';
l_update_stmt := l_update_stmt ||
'AND (m.segment5 IS NULL) ';
l_update_stmt := l_update_stmt ||
'AND (m.segment5 BETWEEN ';
l_update_stmt := l_update_stmt ||p_segment5_lohi;
l_update_stmt := l_update_stmt ||' )';
l_update_stmt := l_update_stmt ||
'AND (m.segment6 IS NULL) ';
l_update_stmt := l_update_stmt ||
'AND (m.segment6 BETWEEN ';
l_update_stmt := l_update_stmt ||p_segment6_lohi;
l_update_stmt := l_update_stmt ||' )';
l_update_stmt := l_update_stmt ||
'AND (m.segment7 IS NULL) ';
l_update_stmt := l_update_stmt ||
'AND (m.segment7 BETWEEN ';
l_update_stmt := l_update_stmt ||p_segment7_lohi;
l_update_stmt := l_update_stmt ||' )';
l_update_stmt := l_update_stmt ||
'AND (m.segment8 IS NULL) ';
l_update_stmt := l_update_stmt ||
'AND (m.segment8 BETWEEN ';
l_update_stmt := l_update_stmt ||p_segment8_lohi;
l_update_stmt := l_update_stmt ||' )';
l_update_stmt := l_update_stmt ||
'AND (m.segment9 IS NULL) ';
l_update_stmt := l_update_stmt ||
'AND (m.segment9 BETWEEN ';
l_update_stmt := l_update_stmt ||p_segment9_lohi;
l_update_stmt := l_update_stmt ||' )';
l_update_stmt := l_update_stmt ||
'AND (m.segment10 IS NULL) ';
l_update_stmt := l_update_stmt ||
'AND (m.segment10 BETWEEN ';
l_update_stmt := l_update_stmt ||p_segment10_lohi;
l_update_stmt := l_update_stmt ||' )';
l_update_stmt := l_update_stmt ||
'AND (m.segment11 IS NULL) ';
l_update_stmt := l_update_stmt ||
'AND (m.segment11 BETWEEN ';
l_update_stmt := l_update_stmt ||p_segment11_lohi;
l_update_stmt := l_update_stmt ||' )';
l_update_stmt := l_update_stmt ||
'AND (m.segment12 IS NULL) ';
l_update_stmt := l_update_stmt ||
'AND (m.segment12 BETWEEN ';
l_update_stmt := l_update_stmt ||p_segment12_lohi;
l_update_stmt := l_update_stmt ||' )';
l_update_stmt := l_update_stmt ||
'AND (m.segment13 IS NULL) ';
l_update_stmt := l_update_stmt ||
'AND (m.segment13 BETWEEN ';
l_update_stmt := l_update_stmt ||p_segment13_lohi;
l_update_stmt := l_update_stmt ||' )';
l_update_stmt := l_update_stmt ||
'AND (m.segment14 IS NULL) ';
l_update_stmt := l_update_stmt ||
'AND (m.segment14 BETWEEN ';
l_update_stmt := l_update_stmt ||p_segment14_lohi;
l_update_stmt := l_update_stmt ||' )';
l_update_stmt := l_update_stmt ||
'AND (m.segment15 IS NULL) ';
l_update_stmt := l_update_stmt ||
'AND (m.segment15 BETWEEN ';
l_update_stmt := l_update_stmt ||p_segment15_lohi;
l_update_stmt := l_update_stmt ||' )';
l_update_stmt := l_update_stmt ||
'AND (m.segment16 IS NULL) ';
l_update_stmt := l_update_stmt ||
'AND (m.segment16 BETWEEN ';
l_update_stmt := l_update_stmt ||p_segment16_lohi;
l_update_stmt := l_update_stmt ||' )';
l_update_stmt := l_update_stmt ||
'AND (m.segment17 IS NULL) ';
l_update_stmt := l_update_stmt ||
'AND (m.segment17 BETWEEN ';
l_update_stmt := l_update_stmt ||p_segment17_lohi;
l_update_stmt := l_update_stmt ||' )';
l_update_stmt := l_update_stmt ||
'AND (m.segment18 IS NULL) ';
l_update_stmt := l_update_stmt ||
'AND (m.segment18 BETWEEN ';
l_update_stmt := l_update_stmt ||p_segment18_lohi;
l_update_stmt := l_update_stmt ||' )';
l_update_stmt := l_update_stmt ||
'AND (m.segment19 IS NULL) ';
l_update_stmt := l_update_stmt ||
'AND (m.segment19 BETWEEN ';
l_update_stmt := l_update_stmt ||p_segment19_lohi;
l_update_stmt := l_update_stmt ||' )';
l_update_stmt := l_update_stmt ||
'AND (m.segment20 IS NULL) ';
l_update_stmt := l_update_stmt ||
'AND (m.segment20 BETWEEN ';
l_update_stmt := l_update_stmt ||p_segment20_lohi;
l_update_stmt := l_update_stmt ||' )';
l_update_stmt := l_update_stmt ||
'AND m.inventory_item_status_code = :l_stat ';
l_update_stmt := l_update_stmt ||
'AND m.inventory_item_id IN
( SELECT ic.inventory_item_id
FROM mtl_item_categories ic
WHERE ic.inventory_item_id = m.inventory_item_id
AND ic.organization_id = m.organization_id
AND ic.organization_id = :l_org )';
l_update_stmt := l_update_stmt ||
'AND m.inventory_item_id IN
( SELECT ic.inventory_item_id
FROM mtl_item_categories ic
WHERE ic.inventory_item_id = m.inventory_item_id
AND ic.organization_id = m.organization_id
AND ic.organization_id = :l_org
AND ic.category_set_id = :l_set )';
l_update_stmt := l_update_stmt ||
'AND m.inventory_item_id IN
( SELECT ic.inventory_item_id
FROM mtl_item_categories ic
WHERE ic.inventory_item_id = m.inventory_item_id
AND ic.organization_id = m.organization_id
AND ic.organization_id = :l_org
AND ic.category_set_id = :l_set
AND ic.category_id = :l_cat )';
l_update_stmt := l_update_stmt ||
'AND m.inventory_item_id IN
( SELECT ic.inventory_item_id
FROM mtl_item_categories ic
WHERE ic.inventory_item_id = m.inventory_item_id
AND ic.organization_id = m.organization_id
AND ic.category_set_id = :l_set
AND ic.category_id = :l_cat )';
DBMS_SQL.PARSE(l_cursor_id, l_update_stmt, DBMS_SQL.V7);
l_rows_updated := DBMS_SQL.EXECUTE(l_cursor_id);