APPS.AK_QUERY_PKG dependencies on AK_QUERY_PKG

Line 1: PACKAGE BODY AK_QUERY_PKG AS

1: PACKAGE BODY AK_QUERY_PKG AS
2: /* $Header: akqueryb.pls 115.40 2004/03/10 20:53:58 tshort ship $ */
3:
4: TYPE relation_rec IS RECORD
5: ( foreign_key_name varchar2(30),

Line 335: ak_query_pkg.do_execute_query(

331: l_range_low := nvl(l_range_low,0);
332: l_range_high := nvl(l_range_high,MAXROWNUM);
333: l_use_subquery := nvl(l_use_subquery, FALSE);
334:
335: ak_query_pkg.do_execute_query(
336: root,
337: l_new_key_columns,
338: l_new_key_values,
339: p_child_page_appl_id,

Line 408: ak_query_pkg.construct_query(

404:
405: IF p_return_parents = FALSE and p_return_children = FALSE THEN
406: -- return the region and item information for the parent only
407:
408: ak_query_pkg.construct_query(
409: p_node,
410: p_node_key_columns,
411: p_node_key_values,
412: p_where_clause,

Line 431: ak_query_pkg.create_region_record(p_node,

427: l_where,
428: l_order_by);
429:
430: IF p_display_region THEN
431: ak_query_pkg.create_region_record(p_node,
432: p_node_key_values,
433: p_node_key_columns.COUNT,
434: l_rls_binds,
435: p_where_binds,

Line 448: ak_query_pkg.construct_query(

444:
445:
446: IF p_return_parents THEN
447:
448: ak_query_pkg.construct_query(
449: p_node,
450: p_node_key_columns,
451: p_node_key_values,
452: p_where_clause,

Line 471: ak_query_pkg.create_region_record(p_node,

467: l_where,
468: l_order_by);
469:
470: IF p_display_region THEN
471: ak_query_pkg.create_region_record(p_node,
472: p_node_key_values,
473: p_node_key_columns.COUNT,
474: l_rls_binds,
475: p_where_binds,

Line 489: ak_query_pkg.bind_sql(cursor_id, p_node_key_values);

485: cursor_id := dbms_sql.open_cursor;
486: dbms_sql.parse(cursor_id, l_query_stmt, dbms_sql.v7);
487:
488: IF (p_node_key_columns.count > 0) THEN
489: ak_query_pkg.bind_sql(cursor_id, p_node_key_values);
490: END IF;
491:
492: IF (p_where_binds.count > 0) THEN
493: ak_query_pkg.bind_where_clause(cursor_id, p_where_binds);

Line 493: ak_query_pkg.bind_where_clause(cursor_id, p_where_binds);

489: ak_query_pkg.bind_sql(cursor_id, p_node_key_values);
490: END IF;
491:
492: IF (p_where_binds.count > 0) THEN
493: ak_query_pkg.bind_where_clause(cursor_id, p_where_binds);
494: END IF;
495:
496: IF (l_rls_binds.count > 0) THEN
497: ak_query_pkg.bind_where_clause(cursor_id, l_rls_binds);

Line 497: ak_query_pkg.bind_where_clause(cursor_id, l_rls_binds);

493: ak_query_pkg.bind_where_clause(cursor_id, p_where_binds);
494: END IF;
495:
496: IF (l_rls_binds.count > 0) THEN
497: ak_query_pkg.bind_where_clause(cursor_id, l_rls_binds);
498: END IF;
499:
500: ak_query_pkg.define_sql(cursor_id, l_num_select + l_num_key);
501:

Line 500: ak_query_pkg.define_sql(cursor_id, l_num_select + l_num_key);

496: IF (l_rls_binds.count > 0) THEN
497: ak_query_pkg.bind_where_clause(cursor_id, l_rls_binds);
498: END IF;
499:
500: ak_query_pkg.define_sql(cursor_id, l_num_select + l_num_key);
501:
502: l_retval := dbms_sql.execute(cursor_id);
503:
504: -- Fetch rows

Line 528: ak_query_pkg.get_sql(cursor_id,

524: -- the range of rows to get (i.e. this is an LOV and we are only
525: -- to return rows 25 - 50
526: IF l_row_num >= p_range_low AND l_row_num <= p_range_high THEN
527:
528: ak_query_pkg.get_sql(cursor_id,
529: l_num_select,
530: l_num_key,
531: p_node,
532: p_display_region,

Line 1356: ak_query_pkg.sql_stmt := l_query_stmt;

1352: -- END IF;
1353:
1354:
1355: p_query_stmt := l_query_stmt;
1356: ak_query_pkg.sql_stmt := l_query_stmt;
1357: print_debug('sql_stmt = ' ||substr(l_query_stmt,1,240));
1358: print_debug('where clause = '|| where_stmt);
1359: print_debug('order by clause = '||
1360: nvl(p_order_by_clause,order_by_stmt));

Line 2135: ak_query_pkg.sql_stmt := l_sql_statement;

2131: END IF;
2132:
2133: END LOOP;
2134:
2135: ak_query_pkg.sql_stmt := l_sql_statement;
2136:
2137: -- Now execute the select statement built above
2138: c := dbms_sql.open_cursor;
2139: dbms_sql.parse(c, l_sql_statement, dbms_sql.v7);

Line 2321: ak_query_pkg.load_relations(p_parent,

2317: END IF;
2318:
2319: -- For each row recurse down to get it children
2320:
2321: ak_query_pkg.load_relations(p_parent,
2322: p_child_page_appl_id,
2323: p_child_page_code,
2324: l_relations_table);
2325:

Line 2775: if (AK_QUERY_PKG.PRINT_DEBUG_ON) then

2771: end getSecuredWhere;
2772:
2773: procedure print_debug(dMessage in varchar2) is
2774: begin
2775: if (AK_QUERY_PKG.PRINT_DEBUG_ON) then
2776: null;
2777: -- comment out dbms_output so that adchkdrv would not complain
2778: -- uncomment the following line when debug
2779: --dbms_output.put_line(dMessage);

Line 2783: END AK_QUERY_PKG;

2779: --dbms_output.put_line(dMessage);
2780: end if;
2781: end print_debug;
2782:
2783: END AK_QUERY_PKG;