[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
l_stmt_org := ' SELECT datetime_valid,
datetime_invalid
FROM OKL_INDICES_V idx, OKL_INDEX_VALUES_V idxv
WHERE idx.id = idxv.idx_id
AND idx.name = ' || '''' || ':1' || '''' ||
' AND idx.idx_type = ' || '''' || ':2' || '''' ;
l_stmt_org := ' SELECT datetime_valid,
datetime_invalid
FROM OKL_INDICES_V idx, OKL_INDEX_VALUES_V idxv
WHERE idx.id = idxv.idx_id
AND idx.id = ' || ':1' ;
SELECT idx_frequency
FROM OKL_INDICES idx,
OKL_INDEX_VALUES ive
WHERE ive.idx_id = idx.id
AND idx.ID = v_idx_id;
OKL_INDICES_PUB.UPDATE_INDICES(p_api_version => 1.0,
p_init_msg_list => l_init_msg_list,
x_return_status => l_return_status,
x_msg_count => l_msg_count,
x_msg_data => l_msg_data,
p_idxv_rec => l_idxv_rec_in,
x_idxv_rec => l_idxv_rec_out);
OKL_INDICES_PUB.update_index_values(p_api_version => 1.0,
p_init_msg_list => l_init_msg_list,
x_return_status => l_return_status,
x_msg_count => l_msg_count,
x_msg_data => l_msg_data,
p_ivev_rec => l_ivev_rec_in,
x_ivev_rec => l_ivev_rec_out);
SELECT datetime_valid,
datetime_invalid
FROM OKL_INDEX_VALUES
WHERE idx_id = v_idx_id;