APPS.IBE_UTIL dependencies on IBE_TEMP_TABLE

Line 398: delete from ibe_temp_table where key=p_keyString;

394: FUNCTION delete_from_temp_table (p_keyString IN VARCHAR2) RETURN VARCHAR2
395:
396: IS
397: BEGIN
398: delete from ibe_temp_table where key=p_keyString;
399: IF SQL%FOUND THEN
400: return FND_API.G_TRUE;
401: ELSE
402: return FND_API.G_FALSE;

Line 453: INSERT into IBE_TEMP_TABLE (KEY, CHAR_VAL) VALUES (p_keyString,p_inString);

449: IBE_UTIL.debug('START: insert_into_temp_table');
450: END IF;
451:
452: IF p_Type = 'CHAR' THEN
453: INSERT into IBE_TEMP_TABLE (KEY, CHAR_VAL) VALUES (p_keyString,p_inString);
454: ELSIF p_Type = 'NUM' THEN
455: INSERT into IBE_TEMP_TABLE (KEY, NUM_VAL) VALUES (p_keyString,to_number(p_inString));
456: END IF;
457:

Line 455: INSERT into IBE_TEMP_TABLE (KEY, NUM_VAL) VALUES (p_keyString,to_number(p_inString));

451:
452: IF p_Type = 'CHAR' THEN
453: INSERT into IBE_TEMP_TABLE (KEY, CHAR_VAL) VALUES (p_keyString,p_inString);
454: ELSIF p_Type = 'NUM' THEN
455: INSERT into IBE_TEMP_TABLE (KEY, NUM_VAL) VALUES (p_keyString,to_number(p_inString));
456: END IF;
457:
458: IF p_Type = 'CHAR' THEN
459: x_QueryString := 'SELECT CHAR_VAL FROM IBE_TEMP_TABLE WHERE KEY = :1';

Line 459: x_QueryString := 'SELECT CHAR_VAL FROM IBE_TEMP_TABLE WHERE KEY = :1';

455: INSERT into IBE_TEMP_TABLE (KEY, NUM_VAL) VALUES (p_keyString,to_number(p_inString));
456: END IF;
457:
458: IF p_Type = 'CHAR' THEN
459: x_QueryString := 'SELECT CHAR_VAL FROM IBE_TEMP_TABLE WHERE KEY = :1';
460: ELSIF p_Type = 'NUM' THEN
461: x_QueryString := 'SELECT NUM_VAL FROM IBE_TEMP_TABLE WHERE KEY = :1';
462: END IF;
463:

Line 461: x_QueryString := 'SELECT NUM_VAL FROM IBE_TEMP_TABLE WHERE KEY = :1';

457:
458: IF p_Type = 'CHAR' THEN
459: x_QueryString := 'SELECT CHAR_VAL FROM IBE_TEMP_TABLE WHERE KEY = :1';
460: ELSIF p_Type = 'NUM' THEN
461: x_QueryString := 'SELECT NUM_VAL FROM IBE_TEMP_TABLE WHERE KEY = :1';
462: END IF;
463:
464: EXCEPTION
465: WHEN OTHERS then