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 AK_QUERY_PKG

Line 51: l_query_binds ak_query_pkg.bind_tab;

47: l_LOV_foreign_key_name varchar2(30);
48: l_LOV_region_id number;
49: l_LOV_region varchar2(30);
50:
51: l_query_binds ak_query_pkg.bind_tab;
52: l_where_clause varchar2(2000);
53: l_order_clause varchar2(2000);
54: c_where_clause varchar2(2000);
55:

Line 204: ak_query_pkg.exec_query (

200: end if;
201:
202:
203:
204: ak_query_pkg.exec_query (
205: P_PARENT_REGION_APPL_ID => l_LOV_region_id ,
206: P_PARENT_REGION_CODE => l_LOV_region ,
207: P_WHERE_CLAUSE => l_where_clause ,
208: P_WHERE_BINDS => l_query_binds ,

Line 219: p_total_row := ak_query_pkg.g_regions_table(0).total_result_count;

215: P_RANGE_HIGH => l_end_row ,
216: P_MAX_ROWS => 1000);
217:
218:
219: p_total_row := ak_query_pkg.g_regions_table(0).total_result_count;
220:
221: l_insert_values := '';
222: l_column_names := '';
223: l_display_column := 0;

Line 225: for j in 0..ak_query_pkg.g_items_table.COUNT-1 loop

221: l_insert_values := '';
222: l_column_names := '';
223: l_display_column := 0;
224: j := 0;
225: for j in 0..ak_query_pkg.g_items_table.COUNT-1 loop
226:
227: if (l_display_column=0) then
228: l_insert_values := l_insert_values ||
229: ':VALUE' || to_char(j+1);

Line 250: for j in 0..ak_query_pkg.g_items_table.COUNT-1 loop

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:
254: tmp_num := dbms_sql.execute(l_cursor);

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 261: for i in 0..ak_query_pkg.g_results_table.COUNT-1 loop

257:
258:
259: i := 0;
260: j := 0;
261: for i in 0..ak_query_pkg.g_results_table.COUNT-1 loop
262: icx_util.transfer_Row_To_Column(ak_query_pkg.g_results_table(i), l_result_row_table);
263: l_insert_values := '';
264: l_column_names := '';
265: l_display_column := 0;

Line 262: icx_util.transfer_Row_To_Column(ak_query_pkg.g_results_table(i), l_result_row_table);

258:
259: i := 0;
260: j := 0;
261: for i in 0..ak_query_pkg.g_results_table.COUNT-1 loop
262: icx_util.transfer_Row_To_Column(ak_query_pkg.g_results_table(i), l_result_row_table);
263: l_insert_values := '';
264: l_column_names := '';
265: l_display_column := 0;
266: for j in 0..ak_query_pkg.g_items_table.COUNT-1 loop

Line 266: for j in 0..ak_query_pkg.g_items_table.COUNT-1 loop

262: icx_util.transfer_Row_To_Column(ak_query_pkg.g_results_table(i), l_result_row_table);
263: l_insert_values := '';
264: l_column_names := '';
265: l_display_column := 0;
266: for j in 0..ak_query_pkg.g_items_table.COUNT-1 loop
267:
268: if (l_display_column=0) then
269: l_insert_values := l_insert_values || ':VALUE' || to_char(j+1);
270: l_column_names := l_column_names || 'VALUE' || to_char(j+1);

Line 292: for j in 0..ak_query_pkg.g_items_table.COUNT-1 loop

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:
296: tmp_num := dbms_sql.execute(l_cursor);

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 307: for j in 0..ak_query_pkg.g_items_table.COUNT-1 loop

303: l_insert_values := '';
304: l_column_names := '';
305: l_display_column := 0;
306: j := 0;
307: for j in 0..ak_query_pkg.g_items_table.COUNT-1 loop
308: if ak_query_pkg.g_items_table(j).secured_column = 'F' and
309: ak_query_pkg.g_items_table(j).node_display_flag = 'Y' then
310:
311: if (l_display_column=0) then

Line 308: if ak_query_pkg.g_items_table(j).secured_column = 'F' and

304: l_column_names := '';
305: l_display_column := 0;
306: j := 0;
307: for j in 0..ak_query_pkg.g_items_table.COUNT-1 loop
308: if ak_query_pkg.g_items_table(j).secured_column = 'F' and
309: ak_query_pkg.g_items_table(j).node_display_flag = 'Y' then
310:
311: if (l_display_column=0) then
312: l_insert_values := l_insert_values || ':VALUE' || to_char(j+1);

Line 309: ak_query_pkg.g_items_table(j).node_display_flag = 'Y' then

305: l_display_column := 0;
306: j := 0;
307: for j in 0..ak_query_pkg.g_items_table.COUNT-1 loop
308: if ak_query_pkg.g_items_table(j).secured_column = 'F' and
309: ak_query_pkg.g_items_table(j).node_display_flag = 'Y' then
310:
311: if (l_display_column=0) then
312: l_insert_values := l_insert_values || ':VALUE' || to_char(j+1);
313: l_column_names := l_column_names || 'VALUE' || to_char(j+1);

Line 334: for j in 0..ak_query_pkg.g_items_table.COUNT-1 loop

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
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;

Line 335: if ak_query_pkg.g_items_table(j).secured_column = 'F' and

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
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;

Line 336: ak_query_pkg.g_items_table(j).node_display_flag = 'Y' then

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
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:

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 346: for i in 0..ak_query_pkg.g_results_table.COUNT-1 loop

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
347: icx_util.transfer_Row_To_Column(ak_query_pkg.g_results_table(i), l_result_row_table);
348: l_insert_values := '';
349: l_column_names := '';
350: l_display_column := 0;

Line 347: icx_util.transfer_Row_To_Column(ak_query_pkg.g_results_table(i), l_result_row_table);

343:
344: i := 0;
345: j := 0;
346: for i in 0..ak_query_pkg.g_results_table.COUNT-1 loop
347: icx_util.transfer_Row_To_Column(ak_query_pkg.g_results_table(i), l_result_row_table);
348: l_insert_values := '';
349: l_column_names := '';
350: l_display_column := 0;
351: for j in 0..ak_query_pkg.g_items_table.COUNT-1 loop

Line 351: for j in 0..ak_query_pkg.g_items_table.COUNT-1 loop

347: icx_util.transfer_Row_To_Column(ak_query_pkg.g_results_table(i), l_result_row_table);
348: l_insert_values := '';
349: l_column_names := '';
350: l_display_column := 0;
351: for j in 0..ak_query_pkg.g_items_table.COUNT-1 loop
352: if ak_query_pkg.g_items_table(j).secured_column = 'F' and
353: ak_query_pkg.g_items_table(j).node_display_flag = 'Y' then
354:
355: if (l_display_column=0) then

Line 352: if ak_query_pkg.g_items_table(j).secured_column = 'F' and

348: l_insert_values := '';
349: l_column_names := '';
350: l_display_column := 0;
351: for j in 0..ak_query_pkg.g_items_table.COUNT-1 loop
352: if ak_query_pkg.g_items_table(j).secured_column = 'F' and
353: ak_query_pkg.g_items_table(j).node_display_flag = 'Y' then
354:
355: if (l_display_column=0) then
356: l_insert_values := l_insert_values || ':VALUE' || to_char(j+1);

Line 353: ak_query_pkg.g_items_table(j).node_display_flag = 'Y' then

349: l_column_names := '';
350: l_display_column := 0;
351: for j in 0..ak_query_pkg.g_items_table.COUNT-1 loop
352: if ak_query_pkg.g_items_table(j).secured_column = 'F' and
353: ak_query_pkg.g_items_table(j).node_display_flag = 'Y' then
354:
355: if (l_display_column=0) then
356: l_insert_values := l_insert_values || ':VALUE' || to_char(j+1);
357: l_column_names := l_column_names || 'VALUE' || to_char(j+1);

Line 381: for j in 0..ak_query_pkg.g_items_table.COUNT-1 loop

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
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;

Line 382: if ak_query_pkg.g_items_table(j).secured_column = 'F' and

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
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;

Line 383: ak_query_pkg.g_items_table(j).node_display_flag = 'Y' then

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
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:

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);