APPS.JTF_REGION_PUB dependencies on AK_QUERY_PKG

Line 345: p_ak_result_table in ak_query_pkg.result_rec,

341: END get_region_item_name;
342:
343:
344: procedure transfer_row_to_column(
345: p_ak_result_table in ak_query_pkg.result_rec,
346: p_ak_result_rec OUT NOCOPY /* file.sql.39 change */ result_rec) IS
347: cnt number := 0;
348: BEGIN
349: p_ak_result_rec.value1 := p_ak_result_table.value1;

Line 466: p_bind_tab ak_query_pkg.bind_tab;

462: , p_ak_item_rec_table OUT NOCOPY /* file.sql.39 change */ ak_item_rec_table
463: , p_ak_result_table OUT NOCOPY /* file.sql.39 change */ ak_result_table
464: ) IS
465: cnt number := 0;
466: p_bind_tab ak_query_pkg.bind_tab;
467: l_result_rec result_rec := null;
468: l_ak_item_rec ak_item_rec := null;
469: range_high number := 0;
470: range_low number := 0;

Line 481: ak_query_pkg.exec_query(

477: p_bind_tab(i).value := p_where_binds(i).value;
478: END LOOP;
479: end if;
480:
481: ak_query_pkg.exec_query(
482: p_parent_region_appl_id=>p_application_id,
483: p_parent_region_code=>p_region_code,
484: p_where_clause=>p_where_clause,
485: p_order_by_clause=>p_order_by_clause,

Line 493: if(ak_query_pkg.g_regions_table(0).total_result_count > 0) then

489: p_range_high=>p_range_high,
490: p_max_rows=>p_max_rows,
491: p_where_binds=>p_bind_tab);
492:
493: if(ak_query_pkg.g_regions_table(0).total_result_count > 0) then
494: if(p_max_rows is null or p_max_rows > ak_query_pkg.g_regions_table(0).total_result_count ) then
495: p_max_rows := ak_query_pkg.g_regions_table(0).total_result_count;
496: end if;
497: else

Line 494: if(p_max_rows is null or p_max_rows > ak_query_pkg.g_regions_table(0).total_result_count ) then

490: p_max_rows=>p_max_rows,
491: p_where_binds=>p_bind_tab);
492:
493: if(ak_query_pkg.g_regions_table(0).total_result_count > 0) then
494: if(p_max_rows is null or p_max_rows > ak_query_pkg.g_regions_table(0).total_result_count ) then
495: p_max_rows := ak_query_pkg.g_regions_table(0).total_result_count;
496: end if;
497: else
498: p_max_rows := 0;

Line 495: p_max_rows := ak_query_pkg.g_regions_table(0).total_result_count;

491: p_where_binds=>p_bind_tab);
492:
493: if(ak_query_pkg.g_regions_table(0).total_result_count > 0) then
494: if(p_max_rows is null or p_max_rows > ak_query_pkg.g_regions_table(0).total_result_count ) then
495: p_max_rows := ak_query_pkg.g_regions_table(0).total_result_count;
496: end if;
497: else
498: p_max_rows := 0;
499: l_ak_item_rec.value_id := 0;

Line 512: for i in ak_query_pkg.g_items_table.FIRST..ak_query_pkg.g_items_table.LAST

508: /* read all the item records */
509:
510: /*dbms_output.put_line('reading the items table ' );*/
511:
512: for i in ak_query_pkg.g_items_table.FIRST..ak_query_pkg.g_items_table.LAST
513: loop
514:
515: /*dbms_output.put_line('reading the items table: ' || ak_query_pkg.g_items_table(i).attribute_code || 'll' || ak_query_pkg.g_items_table(i).object_attribute_flag);*/
516:

Line 515: /*dbms_output.put_line('reading the items table: ' || ak_query_pkg.g_items_table(i).attribute_code || 'll' || ak_query_pkg.g_items_table(i).object_attribute_flag);*/

511:
512: for i in ak_query_pkg.g_items_table.FIRST..ak_query_pkg.g_items_table.LAST
513: loop
514:
515: /*dbms_output.put_line('reading the items table: ' || ak_query_pkg.g_items_table(i).attribute_code || 'll' || ak_query_pkg.g_items_table(i).object_attribute_flag);*/
516:
517: if(ak_query_pkg.g_items_table(i).object_attribute_flag = 'Y') then
518: select column_name into p_column_name from ak_object_attributes
519: where attribute_code = ak_query_pkg.g_items_table(i).attribute_code;

Line 517: if(ak_query_pkg.g_items_table(i).object_attribute_flag = 'Y') then

513: loop
514:
515: /*dbms_output.put_line('reading the items table: ' || ak_query_pkg.g_items_table(i).attribute_code || 'll' || ak_query_pkg.g_items_table(i).object_attribute_flag);*/
516:
517: if(ak_query_pkg.g_items_table(i).object_attribute_flag = 'Y') then
518: select column_name into p_column_name from ak_object_attributes
519: where attribute_code = ak_query_pkg.g_items_table(i).attribute_code;
520: l_ak_item_rec.value_id := ak_query_pkg.g_items_table(i).value_id;
521: l_ak_item_rec.column_name := p_column_name;

Line 519: where attribute_code = ak_query_pkg.g_items_table(i).attribute_code;

515: /*dbms_output.put_line('reading the items table: ' || ak_query_pkg.g_items_table(i).attribute_code || 'll' || ak_query_pkg.g_items_table(i).object_attribute_flag);*/
516:
517: if(ak_query_pkg.g_items_table(i).object_attribute_flag = 'Y') then
518: select column_name into p_column_name from ak_object_attributes
519: where attribute_code = ak_query_pkg.g_items_table(i).attribute_code;
520: l_ak_item_rec.value_id := ak_query_pkg.g_items_table(i).value_id;
521: l_ak_item_rec.column_name := p_column_name;
522:
523: p_ak_item_rec_table(i + 1) := l_ak_item_rec;

Line 520: l_ak_item_rec.value_id := ak_query_pkg.g_items_table(i).value_id;

516:
517: if(ak_query_pkg.g_items_table(i).object_attribute_flag = 'Y') then
518: select column_name into p_column_name from ak_object_attributes
519: where attribute_code = ak_query_pkg.g_items_table(i).attribute_code;
520: l_ak_item_rec.value_id := ak_query_pkg.g_items_table(i).value_id;
521: l_ak_item_rec.column_name := p_column_name;
522:
523: p_ak_item_rec_table(i + 1) := l_ak_item_rec;
524: cnt := cnt +1;

Line 553: transfer_row_to_column(ak_query_pkg.g_results_table(i), l_result_rec);

549: range_high := p_max_rows;
550: end if;
551:
552: for i in range_low-1..range_high-1 loop
553: transfer_row_to_column(ak_query_pkg.g_results_table(i), l_result_rec);
554: p_ak_result_table(cnt) := l_result_rec;
555: cnt := cnt + 1;
556: end loop;
557: end if;