APPS.POR_LOV_PKG dependencies on POR_LOV_RESULT_VALUES

Line 13: DELETE FROM POR_LOV_RESULT_VALUES WHERE SESSION_ID = p_session_id;

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;
15:
16:
17: EXCEPTION

Line 104: DELETE FROM POR_LOV_RESULT_VALUES WHERE SESSION_ID = p_session_id;

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;
106:
107:
108: select USER_ID, RESPONSIBILITY_ID, RESPONSIBILITY_APPLICATION_ID

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

237: end loop;
238:
239: l_column_names := '(SESSION_ID, LAST_UPDATED_BY, LAST_UPDATE_DATE, TYPE,' || l_column_names || ')';
240: l_insert_values := '(:SESSION_ID, :LAST_UPDATED_BY, :LAST_UPDATE_DATE, :TYPE, ' || l_insert_values || ')';
241: tmp_string := 'INSERT INTO POR_LOV_RESULT_VALUES ' || l_column_names ||' VALUES ' || l_insert_values;
242:
243: l_cursor := dbms_sql.open_cursor;
244: dbms_sql.parse(l_cursor, tmp_string, dbms_sql.v7);
245:

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

278: end loop;
279:
280: l_column_names := '(SESSION_ID, SEQUENCE, LAST_UPDATED_BY, LAST_UPDATE_DATE, TYPE, ' || l_column_names || ')';
281: l_insert_values := '(:SESSION_ID, :SEQUENCE, :LAST_UPDATED_BY, :LAST_UPDATE_DATE, :TYPE,' || l_insert_values ||')';
282: tmp_string := 'INSERT INTO POR_LOV_RESULT_VALUES ' || l_column_names ||' VALUES ' || l_insert_values;
283:
284: l_cursor := dbms_sql.open_cursor;
285: dbms_sql.parse(l_cursor, tmp_string, dbms_sql.v7);
286: