APPS.POR_LOV_PKG dependencies on POR_LOV_DISPLAY_RESULTS

Line 10: DELETE FROM POR_LOV_DISPLAY_RESULTS WHERE SESSION_ID = p_session_id;

6: ) is
7:
8: BEGIN
9:
10: DELETE FROM POR_LOV_DISPLAY_RESULTS WHERE SESSION_ID = p_session_id;
11: COMMIT;
12:
13: DELETE FROM POR_LOV_RESULT_VALUES WHERE SESSION_ID = p_session_id;
14: COMMIT;

Line 101: DELETE FROM POR_LOV_DISPLAY_RESULTS WHERE SESSION_ID = p_session_id;

97:
98:
99: BEGIN
100:
101: DELETE FROM POR_LOV_DISPLAY_RESULTS WHERE SESSION_ID = p_session_id;
102: COMMIT;
103:
104: DELETE FROM POR_LOV_RESULT_VALUES WHERE SESSION_ID = p_session_id;
105: COMMIT;

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

320: end loop;
321:
322: l_column_names := '(SESSION_ID, LAST_UPDATED_BY, LAST_UPDATE_DATE, TYPE, ' || l_column_names || ')';
323: l_insert_values := '(:SESSION_ID, :LAST_UPDATED_BY, :LAST_UPDATE_DATE, :TYPE, ' || l_insert_values || ')';
324: tmp_string := 'INSERT INTO POR_LOV_DISPLAY_RESULTS ' || l_column_names ||' VALUES ' || l_insert_values;
325:
326: l_cursor := dbms_sql.open_cursor;
327: dbms_sql.parse(l_cursor, tmp_string, dbms_sql.v7);
328:

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

366: end loop;
367:
368: l_column_names := '(SESSION_ID, SEQUENCE, LAST_UPDATED_BY, LAST_UPDATE_DATE, TYPE, ' || l_column_names || ')';
369: l_insert_values := '(:SESSION_ID, :SEQUENCE, :LAST_UPDATED_BY, :LAST_UPDATE_DATE, :TYPE, ' || l_insert_values || ')';
370: tmp_string := 'INSERT INTO POR_LOV_DISPLAY_RESULTS ' || l_column_names ||' VALUES ' || l_insert_values;
371:
372: l_cursor := dbms_sql.open_cursor;
373: dbms_sql.parse(l_cursor, tmp_string, dbms_sql.v7);
374: