DBA Data[Home] [Help]

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