APPS.POR_LOV_PKG SQL Statements

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

Line: 10

DELETE FROM POR_LOV_DISPLAY_RESULTS WHERE SESSION_ID = p_session_id;

Line: 13

DELETE FROM POR_LOV_RESULT_VALUES WHERE SESSION_ID = p_session_id;

Line: 60

l_insert_values varchar2(4000);

Line: 78

        select  d.COLUMN_NAME,b.ATTRIBUTE_LABEL_LONG,
                substr(a.DATA_TYPE,1,1)
        from    AK_ATTRIBUTES a,
                AK_REGION_ITEMS_VL b,
                AK_REGIONS c,
                AK_OBJECT_ATTRIBUTES d
        where   b.REGION_APPLICATION_ID = l_LOV_region_id
        and     b.REGION_CODE = l_LOV_region
        and     b.NODE_QUERY_FLAG = 'Y'
        and     b.ATTRIBUTE_APPLICATION_ID = d.ATTRIBUTE_APPLICATION_ID
        and     b.ATTRIBUTE_CODE = d.ATTRIBUTE_CODE
        and     b.REGION_APPLICATION_ID = c.REGION_APPLICATION_ID
        and     b.REGION_CODE = c.REGION_CODE
        and     c.DATABASE_OBJECT_NAME = d.DATABASE_OBJECT_NAME
        and     d.ATTRIBUTE_APPLICATION_ID = b.ATTRIBUTE_APPLICATION_ID
        and     d.ATTRIBUTE_CODE = b.ATTRIBUTE_CODE
        and     d.ATTRIBUTE_APPLICATION_ID = a.ATTRIBUTE_APPLICATION_ID
        and     d.ATTRIBUTE_CODE = a.ATTRIBUTE_CODE
        order by b.DISPLAY_SEQUENCE;

Line: 101

DELETE FROM POR_LOV_DISPLAY_RESULTS WHERE SESSION_ID = p_session_id;

Line: 104

DELETE FROM POR_LOV_RESULT_VALUES WHERE SESSION_ID = p_session_id;

Line: 108

  select USER_ID, RESPONSIBILITY_ID, RESPONSIBILITY_APPLICATION_ID
  into l_user_id, l_responsibility_id, l_responsibility_app_id
  from ICX_SESSIONS
  where SESSION_ID = p_session_id;

Line: 116

  select LOV_FOREIGN_KEY_NAME, LOV_REGION_APPLICATION_ID, LOV_REGION_CODE
  into  l_LOV_foreign_key_name, l_LOV_region_id, l_LOV_region
  from  AK_REGION_ITEMS
  where REGION_APPLICATION_ID = p_region_app_id
  and   REGION_CODE = p_region_code
  and   ATTRIBUTE_APPLICATION_ID = p_attribute_app_id
  and   ATTRIBUTE_CODE = p_attribute_code;

Line: 126

    select QUERY_SET, MAX_ROWS
    into l_query_size, l_max_rows
    from ICX_PARAMETERS;

Line: 221

l_insert_values := '';

Line: 228

                        l_insert_values := l_insert_values ||
                                ':VALUE' || to_char(j+1);

Line: 232

                        l_insert_values := l_insert_values || ', ' ||
                                ':VALUE' || to_char(j+1);

Line: 239

        l_column_names := '(SESSION_ID, LAST_UPDATED_BY, LAST_UPDATE_DATE, TYPE,' || l_column_names || ')';

Line: 240

        l_insert_values := '(:SESSION_ID, :LAST_UPDATED_BY, :LAST_UPDATE_DATE, :TYPE, ' || l_insert_values || ')';

Line: 241

        tmp_string := 'INSERT INTO POR_LOV_RESULT_VALUES ' || l_column_names ||' VALUES ' || l_insert_values;

Line: 247

	dbms_sql.bind_variable(l_cursor, ':LAST_UPDATED_BY', l_user_id);

Line: 248

	dbms_sql.bind_variable(l_cursor, ':LAST_UPDATE_DATE', sysdate);

Line: 263

        l_insert_values := '';

Line: 269

                                l_insert_values := l_insert_values || ':VALUE' || to_char(j+1);

Line: 272

                                l_insert_values := l_insert_values || ', ' || ':VALUE' || to_char(j+1);

Line: 280

        l_column_names := '(SESSION_ID, SEQUENCE, LAST_UPDATED_BY, LAST_UPDATE_DATE, TYPE, ' || l_column_names || ')';

Line: 281

        l_insert_values := '(:SESSION_ID, :SEQUENCE, :LAST_UPDATED_BY, :LAST_UPDATE_DATE, :TYPE,' || l_insert_values ||')';

Line: 282

        tmp_string := 'INSERT INTO POR_LOV_RESULT_VALUES ' || l_column_names ||' VALUES ' || l_insert_values;

Line: 289

	dbms_sql.bind_variable(l_cursor, ':LAST_UPDATED_BY', l_user_id);

Line: 290

	dbms_sql.bind_variable(l_cursor, ':LAST_UPDATE_DATE', sysdate);

Line: 303

l_insert_values := '';

Line: 312

			l_insert_values := l_insert_values || ':VALUE' || to_char(j+1);

Line: 315

			l_insert_values := l_insert_values || ', ' || ':VALUE' || to_char(j+1);

Line: 322

        l_column_names := '(SESSION_ID, LAST_UPDATED_BY, LAST_UPDATE_DATE, TYPE, ' || l_column_names || ')';

Line: 323

        l_insert_values := '(:SESSION_ID, :LAST_UPDATED_BY, :LAST_UPDATE_DATE, :TYPE, ' || l_insert_values || ')';

Line: 324

        tmp_string := 'INSERT INTO POR_LOV_DISPLAY_RESULTS ' || l_column_names ||' VALUES ' || l_insert_values;

Line: 330

        dbms_sql.bind_variable(l_cursor, ':LAST_UPDATED_BY', l_user_id);

Line: 331

        dbms_sql.bind_variable(l_cursor, ':LAST_UPDATE_DATE', sysdate);

Line: 348

        l_insert_values := '';

Line: 356

                                l_insert_values := l_insert_values || ':VALUE' || to_char(j+1);

Line: 359

                                l_insert_values := l_insert_values || ', ' || ':VALUE' || to_char(j+1);

Line: 368

        l_column_names := '(SESSION_ID, SEQUENCE, LAST_UPDATED_BY, LAST_UPDATE_DATE, TYPE, ' || l_column_names || ')';

Line: 369

        l_insert_values := '(:SESSION_ID, :SEQUENCE, :LAST_UPDATED_BY, :LAST_UPDATE_DATE, :TYPE, ' || l_insert_values || ')';

Line: 370

        tmp_string := 'INSERT INTO POR_LOV_DISPLAY_RESULTS ' || l_column_names ||' VALUES ' || l_insert_values;

Line: 377

        dbms_sql.bind_variable(l_cursor, ':LAST_UPDATED_BY', l_user_id);

Line: 378

        dbms_sql.bind_variable(l_cursor, ':LAST_UPDATE_DATE', sysdate);