eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.POR_LOV_PKG dependencies on DBMS_SQL

Line 243: l_cursor := dbms_sql.open_cursor;

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:
246: dbms_sql.bind_variable(l_cursor, ':SESSION_ID', p_session_id);
247: dbms_sql.bind_variable(l_cursor, ':LAST_UPDATED_BY', l_user_id);

Line 244: dbms_sql.parse(l_cursor, tmp_string, dbms_sql.v7);

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:
246: dbms_sql.bind_variable(l_cursor, ':SESSION_ID', p_session_id);
247: dbms_sql.bind_variable(l_cursor, ':LAST_UPDATED_BY', l_user_id);
248: dbms_sql.bind_variable(l_cursor, ':LAST_UPDATE_DATE', sysdate);

Line 246: dbms_sql.bind_variable(l_cursor, ':SESSION_ID', p_session_id);

242:
243: l_cursor := dbms_sql.open_cursor;
244: dbms_sql.parse(l_cursor, tmp_string, dbms_sql.v7);
245:
246: dbms_sql.bind_variable(l_cursor, ':SESSION_ID', p_session_id);
247: dbms_sql.bind_variable(l_cursor, ':LAST_UPDATED_BY', l_user_id);
248: dbms_sql.bind_variable(l_cursor, ':LAST_UPDATE_DATE', sysdate);
249: dbms_sql.bind_variable(l_cursor, ':TYPE', 'CODE');
250: for j in 0..ak_query_pkg.g_items_table.COUNT-1 loop

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

243: l_cursor := dbms_sql.open_cursor;
244: dbms_sql.parse(l_cursor, tmp_string, dbms_sql.v7);
245:
246: dbms_sql.bind_variable(l_cursor, ':SESSION_ID', p_session_id);
247: dbms_sql.bind_variable(l_cursor, ':LAST_UPDATED_BY', l_user_id);
248: dbms_sql.bind_variable(l_cursor, ':LAST_UPDATE_DATE', sysdate);
249: dbms_sql.bind_variable(l_cursor, ':TYPE', 'CODE');
250: for j in 0..ak_query_pkg.g_items_table.COUNT-1 loop
251: dbms_sql.bind_variable(l_cursor, ':VALUE'|| to_char(j+1) , ak_query_pkg.g_items_table(j).attribute_code );

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

244: dbms_sql.parse(l_cursor, tmp_string, dbms_sql.v7);
245:
246: dbms_sql.bind_variable(l_cursor, ':SESSION_ID', p_session_id);
247: dbms_sql.bind_variable(l_cursor, ':LAST_UPDATED_BY', l_user_id);
248: dbms_sql.bind_variable(l_cursor, ':LAST_UPDATE_DATE', sysdate);
249: dbms_sql.bind_variable(l_cursor, ':TYPE', 'CODE');
250: for j in 0..ak_query_pkg.g_items_table.COUNT-1 loop
251: dbms_sql.bind_variable(l_cursor, ':VALUE'|| to_char(j+1) , ak_query_pkg.g_items_table(j).attribute_code );
252: end loop;

Line 249: dbms_sql.bind_variable(l_cursor, ':TYPE', 'CODE');

245:
246: dbms_sql.bind_variable(l_cursor, ':SESSION_ID', p_session_id);
247: dbms_sql.bind_variable(l_cursor, ':LAST_UPDATED_BY', l_user_id);
248: dbms_sql.bind_variable(l_cursor, ':LAST_UPDATE_DATE', sysdate);
249: dbms_sql.bind_variable(l_cursor, ':TYPE', 'CODE');
250: for j in 0..ak_query_pkg.g_items_table.COUNT-1 loop
251: dbms_sql.bind_variable(l_cursor, ':VALUE'|| to_char(j+1) , ak_query_pkg.g_items_table(j).attribute_code );
252: end loop;
253:

Line 251: dbms_sql.bind_variable(l_cursor, ':VALUE'|| to_char(j+1) , ak_query_pkg.g_items_table(j).attribute_code );

247: dbms_sql.bind_variable(l_cursor, ':LAST_UPDATED_BY', l_user_id);
248: dbms_sql.bind_variable(l_cursor, ':LAST_UPDATE_DATE', sysdate);
249: dbms_sql.bind_variable(l_cursor, ':TYPE', 'CODE');
250: for j in 0..ak_query_pkg.g_items_table.COUNT-1 loop
251: dbms_sql.bind_variable(l_cursor, ':VALUE'|| to_char(j+1) , ak_query_pkg.g_items_table(j).attribute_code );
252: end loop;
253:
254: tmp_num := dbms_sql.execute(l_cursor);
255: dbms_sql.close_cursor(l_cursor);

Line 254: tmp_num := dbms_sql.execute(l_cursor);

250: for j in 0..ak_query_pkg.g_items_table.COUNT-1 loop
251: dbms_sql.bind_variable(l_cursor, ':VALUE'|| to_char(j+1) , ak_query_pkg.g_items_table(j).attribute_code );
252: end loop;
253:
254: tmp_num := dbms_sql.execute(l_cursor);
255: dbms_sql.close_cursor(l_cursor);
256:
257:
258:

Line 255: dbms_sql.close_cursor(l_cursor);

251: dbms_sql.bind_variable(l_cursor, ':VALUE'|| to_char(j+1) , ak_query_pkg.g_items_table(j).attribute_code );
252: end loop;
253:
254: tmp_num := dbms_sql.execute(l_cursor);
255: dbms_sql.close_cursor(l_cursor);
256:
257:
258:
259: i := 0;

Line 284: l_cursor := dbms_sql.open_cursor;

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:
287: dbms_sql.bind_variable(l_cursor, ':SESSION_ID', p_session_id);
288: dbms_sql.bind_variable(l_cursor, ':SEQUENCE', i);

Line 285: dbms_sql.parse(l_cursor, tmp_string, dbms_sql.v7);

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:
287: dbms_sql.bind_variable(l_cursor, ':SESSION_ID', p_session_id);
288: dbms_sql.bind_variable(l_cursor, ':SEQUENCE', i);
289: dbms_sql.bind_variable(l_cursor, ':LAST_UPDATED_BY', l_user_id);

Line 287: dbms_sql.bind_variable(l_cursor, ':SESSION_ID', p_session_id);

283:
284: l_cursor := dbms_sql.open_cursor;
285: dbms_sql.parse(l_cursor, tmp_string, dbms_sql.v7);
286:
287: dbms_sql.bind_variable(l_cursor, ':SESSION_ID', p_session_id);
288: dbms_sql.bind_variable(l_cursor, ':SEQUENCE', i);
289: dbms_sql.bind_variable(l_cursor, ':LAST_UPDATED_BY', l_user_id);
290: dbms_sql.bind_variable(l_cursor, ':LAST_UPDATE_DATE', sysdate);
291: dbms_sql.bind_variable(l_cursor, ':TYPE', 'VALUE');

Line 288: dbms_sql.bind_variable(l_cursor, ':SEQUENCE', i);

284: l_cursor := dbms_sql.open_cursor;
285: dbms_sql.parse(l_cursor, tmp_string, dbms_sql.v7);
286:
287: dbms_sql.bind_variable(l_cursor, ':SESSION_ID', p_session_id);
288: dbms_sql.bind_variable(l_cursor, ':SEQUENCE', i);
289: dbms_sql.bind_variable(l_cursor, ':LAST_UPDATED_BY', l_user_id);
290: dbms_sql.bind_variable(l_cursor, ':LAST_UPDATE_DATE', sysdate);
291: dbms_sql.bind_variable(l_cursor, ':TYPE', 'VALUE');
292: for j in 0..ak_query_pkg.g_items_table.COUNT-1 loop

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

285: dbms_sql.parse(l_cursor, tmp_string, dbms_sql.v7);
286:
287: dbms_sql.bind_variable(l_cursor, ':SESSION_ID', p_session_id);
288: dbms_sql.bind_variable(l_cursor, ':SEQUENCE', i);
289: dbms_sql.bind_variable(l_cursor, ':LAST_UPDATED_BY', l_user_id);
290: dbms_sql.bind_variable(l_cursor, ':LAST_UPDATE_DATE', sysdate);
291: dbms_sql.bind_variable(l_cursor, ':TYPE', 'VALUE');
292: for j in 0..ak_query_pkg.g_items_table.COUNT-1 loop
293: dbms_sql.bind_variable(l_cursor, ':VALUE' || to_char(j+1), l_result_row_table(ak_query_pkg.g_items_table(j).value_id));

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

286:
287: dbms_sql.bind_variable(l_cursor, ':SESSION_ID', p_session_id);
288: dbms_sql.bind_variable(l_cursor, ':SEQUENCE', i);
289: dbms_sql.bind_variable(l_cursor, ':LAST_UPDATED_BY', l_user_id);
290: dbms_sql.bind_variable(l_cursor, ':LAST_UPDATE_DATE', sysdate);
291: dbms_sql.bind_variable(l_cursor, ':TYPE', 'VALUE');
292: for j in 0..ak_query_pkg.g_items_table.COUNT-1 loop
293: dbms_sql.bind_variable(l_cursor, ':VALUE' || to_char(j+1), l_result_row_table(ak_query_pkg.g_items_table(j).value_id));
294: end loop;

Line 291: dbms_sql.bind_variable(l_cursor, ':TYPE', 'VALUE');

287: dbms_sql.bind_variable(l_cursor, ':SESSION_ID', p_session_id);
288: dbms_sql.bind_variable(l_cursor, ':SEQUENCE', i);
289: dbms_sql.bind_variable(l_cursor, ':LAST_UPDATED_BY', l_user_id);
290: dbms_sql.bind_variable(l_cursor, ':LAST_UPDATE_DATE', sysdate);
291: dbms_sql.bind_variable(l_cursor, ':TYPE', 'VALUE');
292: for j in 0..ak_query_pkg.g_items_table.COUNT-1 loop
293: dbms_sql.bind_variable(l_cursor, ':VALUE' || to_char(j+1), l_result_row_table(ak_query_pkg.g_items_table(j).value_id));
294: end loop;
295:

Line 293: dbms_sql.bind_variable(l_cursor, ':VALUE' || to_char(j+1), l_result_row_table(ak_query_pkg.g_items_table(j).value_id));

289: dbms_sql.bind_variable(l_cursor, ':LAST_UPDATED_BY', l_user_id);
290: dbms_sql.bind_variable(l_cursor, ':LAST_UPDATE_DATE', sysdate);
291: dbms_sql.bind_variable(l_cursor, ':TYPE', 'VALUE');
292: for j in 0..ak_query_pkg.g_items_table.COUNT-1 loop
293: dbms_sql.bind_variable(l_cursor, ':VALUE' || to_char(j+1), l_result_row_table(ak_query_pkg.g_items_table(j).value_id));
294: end loop;
295:
296: tmp_num := dbms_sql.execute(l_cursor);
297: dbms_sql.close_cursor(l_cursor);

Line 296: tmp_num := dbms_sql.execute(l_cursor);

292: for j in 0..ak_query_pkg.g_items_table.COUNT-1 loop
293: dbms_sql.bind_variable(l_cursor, ':VALUE' || to_char(j+1), l_result_row_table(ak_query_pkg.g_items_table(j).value_id));
294: end loop;
295:
296: tmp_num := dbms_sql.execute(l_cursor);
297: dbms_sql.close_cursor(l_cursor);
298:
299: end loop;
300:

Line 297: dbms_sql.close_cursor(l_cursor);

293: dbms_sql.bind_variable(l_cursor, ':VALUE' || to_char(j+1), l_result_row_table(ak_query_pkg.g_items_table(j).value_id));
294: end loop;
295:
296: tmp_num := dbms_sql.execute(l_cursor);
297: dbms_sql.close_cursor(l_cursor);
298:
299: end loop;
300:
301: p_value_column := l_display_column;

Line 326: l_cursor := dbms_sql.open_cursor;

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:
329: dbms_sql.bind_variable(l_cursor, ':SESSION_ID', p_session_id);
330: dbms_sql.bind_variable(l_cursor, ':LAST_UPDATED_BY', l_user_id);

Line 327: dbms_sql.parse(l_cursor, tmp_string, dbms_sql.v7);

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:
329: dbms_sql.bind_variable(l_cursor, ':SESSION_ID', p_session_id);
330: dbms_sql.bind_variable(l_cursor, ':LAST_UPDATED_BY', l_user_id);
331: dbms_sql.bind_variable(l_cursor, ':LAST_UPDATE_DATE', sysdate);

Line 329: dbms_sql.bind_variable(l_cursor, ':SESSION_ID', p_session_id);

325:
326: l_cursor := dbms_sql.open_cursor;
327: dbms_sql.parse(l_cursor, tmp_string, dbms_sql.v7);
328:
329: dbms_sql.bind_variable(l_cursor, ':SESSION_ID', p_session_id);
330: dbms_sql.bind_variable(l_cursor, ':LAST_UPDATED_BY', l_user_id);
331: dbms_sql.bind_variable(l_cursor, ':LAST_UPDATE_DATE', sysdate);
332: dbms_sql.bind_variable(l_cursor, ':TYPE', 'TITLE');
333:

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

326: l_cursor := dbms_sql.open_cursor;
327: dbms_sql.parse(l_cursor, tmp_string, dbms_sql.v7);
328:
329: dbms_sql.bind_variable(l_cursor, ':SESSION_ID', p_session_id);
330: dbms_sql.bind_variable(l_cursor, ':LAST_UPDATED_BY', l_user_id);
331: dbms_sql.bind_variable(l_cursor, ':LAST_UPDATE_DATE', sysdate);
332: dbms_sql.bind_variable(l_cursor, ':TYPE', 'TITLE');
333:
334: for j in 0..ak_query_pkg.g_items_table.COUNT-1 loop

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

327: dbms_sql.parse(l_cursor, tmp_string, dbms_sql.v7);
328:
329: dbms_sql.bind_variable(l_cursor, ':SESSION_ID', p_session_id);
330: dbms_sql.bind_variable(l_cursor, ':LAST_UPDATED_BY', l_user_id);
331: dbms_sql.bind_variable(l_cursor, ':LAST_UPDATE_DATE', sysdate);
332: dbms_sql.bind_variable(l_cursor, ':TYPE', 'TITLE');
333:
334: for j in 0..ak_query_pkg.g_items_table.COUNT-1 loop
335: if ak_query_pkg.g_items_table(j).secured_column = 'F' and

Line 332: dbms_sql.bind_variable(l_cursor, ':TYPE', 'TITLE');

328:
329: dbms_sql.bind_variable(l_cursor, ':SESSION_ID', p_session_id);
330: dbms_sql.bind_variable(l_cursor, ':LAST_UPDATED_BY', l_user_id);
331: dbms_sql.bind_variable(l_cursor, ':LAST_UPDATE_DATE', sysdate);
332: dbms_sql.bind_variable(l_cursor, ':TYPE', 'TITLE');
333:
334: for j in 0..ak_query_pkg.g_items_table.COUNT-1 loop
335: if ak_query_pkg.g_items_table(j).secured_column = 'F' and
336: ak_query_pkg.g_items_table(j).node_display_flag = 'Y' then

Line 337: dbms_sql.bind_variable(l_cursor, ':VALUE' || to_char(j+1), ak_query_pkg.g_items_table(j).attribute_label_long);

333:
334: for j in 0..ak_query_pkg.g_items_table.COUNT-1 loop
335: if ak_query_pkg.g_items_table(j).secured_column = 'F' and
336: ak_query_pkg.g_items_table(j).node_display_flag = 'Y' then
337: dbms_sql.bind_variable(l_cursor, ':VALUE' || to_char(j+1), ak_query_pkg.g_items_table(j).attribute_label_long);
338: end if;
339: end loop;
340:
341: tmp_num := dbms_sql.execute(l_cursor);

Line 341: tmp_num := dbms_sql.execute(l_cursor);

337: dbms_sql.bind_variable(l_cursor, ':VALUE' || to_char(j+1), ak_query_pkg.g_items_table(j).attribute_label_long);
338: end if;
339: end loop;
340:
341: tmp_num := dbms_sql.execute(l_cursor);
342: dbms_sql.close_cursor(l_cursor);
343:
344: i := 0;
345: j := 0;

Line 342: dbms_sql.close_cursor(l_cursor);

338: end if;
339: end loop;
340:
341: tmp_num := dbms_sql.execute(l_cursor);
342: dbms_sql.close_cursor(l_cursor);
343:
344: i := 0;
345: j := 0;
346: for i in 0..ak_query_pkg.g_results_table.COUNT-1 loop

Line 372: l_cursor := dbms_sql.open_cursor;

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:
375: dbms_sql.bind_variable(l_cursor, ':SESSION_ID', p_session_id);
376: dbms_sql.bind_variable(l_cursor, ':SEQUENCE', i);

Line 373: dbms_sql.parse(l_cursor, tmp_string, dbms_sql.v7);

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:
375: dbms_sql.bind_variable(l_cursor, ':SESSION_ID', p_session_id);
376: dbms_sql.bind_variable(l_cursor, ':SEQUENCE', i);
377: dbms_sql.bind_variable(l_cursor, ':LAST_UPDATED_BY', l_user_id);

Line 375: dbms_sql.bind_variable(l_cursor, ':SESSION_ID', p_session_id);

371:
372: l_cursor := dbms_sql.open_cursor;
373: dbms_sql.parse(l_cursor, tmp_string, dbms_sql.v7);
374:
375: dbms_sql.bind_variable(l_cursor, ':SESSION_ID', p_session_id);
376: dbms_sql.bind_variable(l_cursor, ':SEQUENCE', i);
377: dbms_sql.bind_variable(l_cursor, ':LAST_UPDATED_BY', l_user_id);
378: dbms_sql.bind_variable(l_cursor, ':LAST_UPDATE_DATE', sysdate);
379: dbms_sql.bind_variable(l_cursor, ':TYPE', 'VALUE');

Line 376: dbms_sql.bind_variable(l_cursor, ':SEQUENCE', i);

372: l_cursor := dbms_sql.open_cursor;
373: dbms_sql.parse(l_cursor, tmp_string, dbms_sql.v7);
374:
375: dbms_sql.bind_variable(l_cursor, ':SESSION_ID', p_session_id);
376: dbms_sql.bind_variable(l_cursor, ':SEQUENCE', i);
377: dbms_sql.bind_variable(l_cursor, ':LAST_UPDATED_BY', l_user_id);
378: dbms_sql.bind_variable(l_cursor, ':LAST_UPDATE_DATE', sysdate);
379: dbms_sql.bind_variable(l_cursor, ':TYPE', 'VALUE');
380:

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

373: dbms_sql.parse(l_cursor, tmp_string, dbms_sql.v7);
374:
375: dbms_sql.bind_variable(l_cursor, ':SESSION_ID', p_session_id);
376: dbms_sql.bind_variable(l_cursor, ':SEQUENCE', i);
377: dbms_sql.bind_variable(l_cursor, ':LAST_UPDATED_BY', l_user_id);
378: dbms_sql.bind_variable(l_cursor, ':LAST_UPDATE_DATE', sysdate);
379: dbms_sql.bind_variable(l_cursor, ':TYPE', 'VALUE');
380:
381: for j in 0..ak_query_pkg.g_items_table.COUNT-1 loop

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

374:
375: dbms_sql.bind_variable(l_cursor, ':SESSION_ID', p_session_id);
376: dbms_sql.bind_variable(l_cursor, ':SEQUENCE', i);
377: dbms_sql.bind_variable(l_cursor, ':LAST_UPDATED_BY', l_user_id);
378: dbms_sql.bind_variable(l_cursor, ':LAST_UPDATE_DATE', sysdate);
379: dbms_sql.bind_variable(l_cursor, ':TYPE', 'VALUE');
380:
381: for j in 0..ak_query_pkg.g_items_table.COUNT-1 loop
382: if ak_query_pkg.g_items_table(j).secured_column = 'F' and

Line 379: dbms_sql.bind_variable(l_cursor, ':TYPE', 'VALUE');

375: dbms_sql.bind_variable(l_cursor, ':SESSION_ID', p_session_id);
376: dbms_sql.bind_variable(l_cursor, ':SEQUENCE', i);
377: dbms_sql.bind_variable(l_cursor, ':LAST_UPDATED_BY', l_user_id);
378: dbms_sql.bind_variable(l_cursor, ':LAST_UPDATE_DATE', sysdate);
379: dbms_sql.bind_variable(l_cursor, ':TYPE', 'VALUE');
380:
381: for j in 0..ak_query_pkg.g_items_table.COUNT-1 loop
382: if ak_query_pkg.g_items_table(j).secured_column = 'F' and
383: ak_query_pkg.g_items_table(j).node_display_flag = 'Y' then

Line 384: dbms_sql.bind_variable(l_cursor, ':VALUE' || to_char(j+1),l_result_row_table(ak_query_pkg.g_items_table(j).value_id));

380:
381: for j in 0..ak_query_pkg.g_items_table.COUNT-1 loop
382: if ak_query_pkg.g_items_table(j).secured_column = 'F' and
383: ak_query_pkg.g_items_table(j).node_display_flag = 'Y' then
384: dbms_sql.bind_variable(l_cursor, ':VALUE' || to_char(j+1),l_result_row_table(ak_query_pkg.g_items_table(j).value_id));
385: end if;
386: end loop;
387:
388: tmp_num := dbms_sql.execute(l_cursor);

Line 388: tmp_num := dbms_sql.execute(l_cursor);

384: dbms_sql.bind_variable(l_cursor, ':VALUE' || to_char(j+1),l_result_row_table(ak_query_pkg.g_items_table(j).value_id));
385: end if;
386: end loop;
387:
388: tmp_num := dbms_sql.execute(l_cursor);
389: dbms_sql.close_cursor(l_cursor);
390:
391: end loop;
392:

Line 389: dbms_sql.close_cursor(l_cursor);

385: end if;
386: end loop;
387:
388: tmp_num := dbms_sql.execute(l_cursor);
389: dbms_sql.close_cursor(l_cursor);
390:
391: end loop;
392:
393: p_display_column := l_display_column;