APPS.IBE_UTIL SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 69

 |   02/18/2004 - ssekar   - Added insert_into_temp_table and                 |
 |                           delete_from_temp_table created by Anita          |
 *----------------------------------------------------------------------------*/

-------------------------------------------------------------------------
-- Private Variables
-------------------------------------------------------------------------
l_file_name	    VARCHAR2(100) := NULL;

Line: 297

    select d.party_type
    from fnd_user c , hz_parties d
    where d.party_id=c.customer_id
    and c.user_name=c_user_name;

Line: 332

 SELECT 'Y' FROM JTF_AUTH_PERMISSIONS_B A,
		JTF_AUTH_PRINCIPAL_MAPS B,
		JTF_AUTH_ROLE_PERMS C,
		JTF_AUTH_PRINCIPALS_B D,
		JTF_AUTH_PRINCIPALS_B E,
 	    JTF_AUTH_DOMAINS_B F
	WHERE D.PRINCIPAL_NAME = l_user_name AND D.IS_USER_FLAG = 1 AND
		D.JTF_AUTH_PRINCIPAL_ID = B.JTF_AUTH_PRINCIPAL_ID AND
 		B.JTF_AUTH_PARENT_PRINCIPAL_ID=E.JTF_AUTH_PRINCIPAL_ID AND
        E.IS_USER_FLAG = 0 AND
		E.JTF_AUTH_PRINCIPAL_ID = C.JTF_AUTH_PRINCIPAL_ID AND
		C.JTF_AUTH_PERMISSION_ID = A.JTF_AUTH_PERMISSION_ID AND
		C.POSITIVE_FLAG=1 AND
		B.JTF_AUTH_DOMAIN_ID = F.JTF_AUTH_DOMAIN_ID AND
		F.DOMAIN_NAME ='CRM_DOMAIN' AND
		A.PERMISSION_NAME = l_permission;

Line: 394

FUNCTION delete_from_temp_table (p_keyString IN VARCHAR2)  RETURN VARCHAR2

IS
BEGIN
  delete from ibe_temp_table where key=p_keyString;

Line: 404

END delete_from_temp_table;

Line: 440

PROCEDURE insert_into_temp_table (p_inString IN VARCHAR2,
                                  p_Type     IN VARCHAR2,
                                  p_keyString IN VARCHAR2,
                                  x_QueryString OUT NOCOPY VARCHAR2)
IS

 BEGIN

   IF  IBE_UTIL.G_DEBUGON = FND_API.G_TRUE THEN
       IBE_UTIL.debug('START: insert_into_temp_table');

Line: 453

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

Line: 455

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

Line: 459

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

Line: 461

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

Line: 471

 END insert_into_temp_table;