APPS.IBE_M_PRICING_PVT dependencies on IBE_TEMP_TABLE
Line 38: delete from IBE_TEMP_TABLE where key =p_keyString;
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:
Line 43: INSERT into IBE_TEMP_TABLE (KEY, NUM_VAL) VALUES (p_keyString,to_number(l_id_str));
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:
Line 48: x_QueryString := 'SELECT NUM_VAL FROM IBE_TEMP_TABLE WHERE KEY = :'||p_number||'';
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