[Home] [Help]
34: begin
35:
36:
37:
38: delete from IBE_TEMP_TABLE where key =p_keyString;
39:
40: FOR i IN 1..p_inTable.COUNT LOOP
41: l_id_str := p_inTable(i).price_list_id;
42:
39:
40: FOR i IN 1..p_inTable.COUNT LOOP
41: l_id_str := p_inTable(i).price_list_id;
42:
43: INSERT into IBE_TEMP_TABLE (KEY, NUM_VAL) VALUES (p_keyString,to_number(l_id_str));
44:
45: end loop;
46:
47:
44:
45: end loop;
46:
47:
48: x_QueryString := 'SELECT NUM_VAL FROM IBE_TEMP_TABLE WHERE KEY = :'||p_number||'';
49:
50:
51: exception
52: WHEN OTHERS then