27: where_clause AK_REGIONS_VL.attribute11%TYPE);
28:
29: TYPE AK_REGION_TBL IS TABLE OF AK_REGION_REC INDEX BY BINARY_INTEGER;
30:
31: -- report info from ak_region_items_vl
32: TYPE AK_REGION_ITEM_REC IS RECORD(
33: attribute_type AK_REGION_ITEMS_VL.attribute1%TYPE,
34: attribute_code AK_REGION_ITEMS_VL.attribute_code%TYPE,
35: attribute2 AK_REGION_ITEMS_VL.attribute2%TYPE,
29: TYPE AK_REGION_TBL IS TABLE OF AK_REGION_REC INDEX BY BINARY_INTEGER;
30:
31: -- report info from ak_region_items_vl
32: TYPE AK_REGION_ITEM_REC IS RECORD(
33: attribute_type AK_REGION_ITEMS_VL.attribute1%TYPE,
34: attribute_code AK_REGION_ITEMS_VL.attribute_code%TYPE,
35: attribute2 AK_REGION_ITEMS_VL.attribute2%TYPE,
36: base_column AK_REGION_ITEMS_VL.attribute3%TYPE,
37: where_clause AK_REGION_ITEMS_VL.attribute4%TYPE,
30:
31: -- report info from ak_region_items_vl
32: TYPE AK_REGION_ITEM_REC IS RECORD(
33: attribute_type AK_REGION_ITEMS_VL.attribute1%TYPE,
34: attribute_code AK_REGION_ITEMS_VL.attribute_code%TYPE,
35: attribute2 AK_REGION_ITEMS_VL.attribute2%TYPE,
36: base_column AK_REGION_ITEMS_VL.attribute3%TYPE,
37: where_clause AK_REGION_ITEMS_VL.attribute4%TYPE,
38: lov_table AK_REGION_ITEMS_VL.attribute15%TYPE,
31: -- report info from ak_region_items_vl
32: TYPE AK_REGION_ITEM_REC IS RECORD(
33: attribute_type AK_REGION_ITEMS_VL.attribute1%TYPE,
34: attribute_code AK_REGION_ITEMS_VL.attribute_code%TYPE,
35: attribute2 AK_REGION_ITEMS_VL.attribute2%TYPE,
36: base_column AK_REGION_ITEMS_VL.attribute3%TYPE,
37: where_clause AK_REGION_ITEMS_VL.attribute4%TYPE,
38: lov_table AK_REGION_ITEMS_VL.attribute15%TYPE,
39: aggregate_function AK_REGION_ITEMS_VL.attribute9%TYPE,
32: TYPE AK_REGION_ITEM_REC IS RECORD(
33: attribute_type AK_REGION_ITEMS_VL.attribute1%TYPE,
34: attribute_code AK_REGION_ITEMS_VL.attribute_code%TYPE,
35: attribute2 AK_REGION_ITEMS_VL.attribute2%TYPE,
36: base_column AK_REGION_ITEMS_VL.attribute3%TYPE,
37: where_clause AK_REGION_ITEMS_VL.attribute4%TYPE,
38: lov_table AK_REGION_ITEMS_VL.attribute15%TYPE,
39: aggregate_function AK_REGION_ITEMS_VL.attribute9%TYPE,
40: data_type AK_REGION_ITEMS_VL.attribute14%TYPE,
33: attribute_type AK_REGION_ITEMS_VL.attribute1%TYPE,
34: attribute_code AK_REGION_ITEMS_VL.attribute_code%TYPE,
35: attribute2 AK_REGION_ITEMS_VL.attribute2%TYPE,
36: base_column AK_REGION_ITEMS_VL.attribute3%TYPE,
37: where_clause AK_REGION_ITEMS_VL.attribute4%TYPE,
38: lov_table AK_REGION_ITEMS_VL.attribute15%TYPE,
39: aggregate_function AK_REGION_ITEMS_VL.attribute9%TYPE,
40: data_type AK_REGION_ITEMS_VL.attribute14%TYPE,
41: data_format AK_REGION_ITEMS_VL.attribute7%TYPE,
34: attribute_code AK_REGION_ITEMS_VL.attribute_code%TYPE,
35: attribute2 AK_REGION_ITEMS_VL.attribute2%TYPE,
36: base_column AK_REGION_ITEMS_VL.attribute3%TYPE,
37: where_clause AK_REGION_ITEMS_VL.attribute4%TYPE,
38: lov_table AK_REGION_ITEMS_VL.attribute15%TYPE,
39: aggregate_function AK_REGION_ITEMS_VL.attribute9%TYPE,
40: data_type AK_REGION_ITEMS_VL.attribute14%TYPE,
41: data_format AK_REGION_ITEMS_VL.attribute7%TYPE,
42: order_sequence AK_REGION_ITEMS_VL.order_sequence%TYPE,
35: attribute2 AK_REGION_ITEMS_VL.attribute2%TYPE,
36: base_column AK_REGION_ITEMS_VL.attribute3%TYPE,
37: where_clause AK_REGION_ITEMS_VL.attribute4%TYPE,
38: lov_table AK_REGION_ITEMS_VL.attribute15%TYPE,
39: aggregate_function AK_REGION_ITEMS_VL.attribute9%TYPE,
40: data_type AK_REGION_ITEMS_VL.attribute14%TYPE,
41: data_format AK_REGION_ITEMS_VL.attribute7%TYPE,
42: order_sequence AK_REGION_ITEMS_VL.order_sequence%TYPE,
43: order_direction AK_REGION_ITEMS_VL.order_direction%TYPE,
36: base_column AK_REGION_ITEMS_VL.attribute3%TYPE,
37: where_clause AK_REGION_ITEMS_VL.attribute4%TYPE,
38: lov_table AK_REGION_ITEMS_VL.attribute15%TYPE,
39: aggregate_function AK_REGION_ITEMS_VL.attribute9%TYPE,
40: data_type AK_REGION_ITEMS_VL.attribute14%TYPE,
41: data_format AK_REGION_ITEMS_VL.attribute7%TYPE,
42: order_sequence AK_REGION_ITEMS_VL.order_sequence%TYPE,
43: order_direction AK_REGION_ITEMS_VL.order_direction%TYPE,
44: node_query_flag AK_REGION_ITEMS_VL.node_query_flag%TYPE,
37: where_clause AK_REGION_ITEMS_VL.attribute4%TYPE,
38: lov_table AK_REGION_ITEMS_VL.attribute15%TYPE,
39: aggregate_function AK_REGION_ITEMS_VL.attribute9%TYPE,
40: data_type AK_REGION_ITEMS_VL.attribute14%TYPE,
41: data_format AK_REGION_ITEMS_VL.attribute7%TYPE,
42: order_sequence AK_REGION_ITEMS_VL.order_sequence%TYPE,
43: order_direction AK_REGION_ITEMS_VL.order_direction%TYPE,
44: node_query_flag AK_REGION_ITEMS_VL.node_query_flag%TYPE,
45: node_display_flag AK_REGION_ITEMS_VL.node_display_flag%TYPE
38: lov_table AK_REGION_ITEMS_VL.attribute15%TYPE,
39: aggregate_function AK_REGION_ITEMS_VL.attribute9%TYPE,
40: data_type AK_REGION_ITEMS_VL.attribute14%TYPE,
41: data_format AK_REGION_ITEMS_VL.attribute7%TYPE,
42: order_sequence AK_REGION_ITEMS_VL.order_sequence%TYPE,
43: order_direction AK_REGION_ITEMS_VL.order_direction%TYPE,
44: node_query_flag AK_REGION_ITEMS_VL.node_query_flag%TYPE,
45: node_display_flag AK_REGION_ITEMS_VL.node_display_flag%TYPE
46: );
39: aggregate_function AK_REGION_ITEMS_VL.attribute9%TYPE,
40: data_type AK_REGION_ITEMS_VL.attribute14%TYPE,
41: data_format AK_REGION_ITEMS_VL.attribute7%TYPE,
42: order_sequence AK_REGION_ITEMS_VL.order_sequence%TYPE,
43: order_direction AK_REGION_ITEMS_VL.order_direction%TYPE,
44: node_query_flag AK_REGION_ITEMS_VL.node_query_flag%TYPE,
45: node_display_flag AK_REGION_ITEMS_VL.node_display_flag%TYPE
46: );
47:
40: data_type AK_REGION_ITEMS_VL.attribute14%TYPE,
41: data_format AK_REGION_ITEMS_VL.attribute7%TYPE,
42: order_sequence AK_REGION_ITEMS_VL.order_sequence%TYPE,
43: order_direction AK_REGION_ITEMS_VL.order_direction%TYPE,
44: node_query_flag AK_REGION_ITEMS_VL.node_query_flag%TYPE,
45: node_display_flag AK_REGION_ITEMS_VL.node_display_flag%TYPE
46: );
47:
48: TYPE AK_REGION_ITEM_TBL IS TABLE OF AK_REGION_ITEM_REC INDEX BY BINARY_INTEGER;
41: data_format AK_REGION_ITEMS_VL.attribute7%TYPE,
42: order_sequence AK_REGION_ITEMS_VL.order_sequence%TYPE,
43: order_direction AK_REGION_ITEMS_VL.order_direction%TYPE,
44: node_query_flag AK_REGION_ITEMS_VL.node_query_flag%TYPE,
45: node_display_flag AK_REGION_ITEMS_VL.node_display_flag%TYPE
46: );
47:
48: TYPE AK_REGION_ITEM_TBL IS TABLE OF AK_REGION_ITEM_REC INDEX BY BINARY_INTEGER;
49:
47:
48: TYPE AK_REGION_ITEM_TBL IS TABLE OF AK_REGION_ITEM_REC INDEX BY BINARY_INTEGER;
49:
50: TYPE SAVE_REGION_ITEM_REC IS RECORD(
51: attribute2 AK_REGION_ITEMS_VL.attribute2%TYPE,
52: base_column AK_REGION_ITEMS_VL.attribute3%TYPE,
53: where_clause AK_REGION_ITEMS_VL.attribute4%TYPE,
54: data_type AK_REGION_ITEMS_VL.attribute14%TYPE);
55:
48: TYPE AK_REGION_ITEM_TBL IS TABLE OF AK_REGION_ITEM_REC INDEX BY BINARY_INTEGER;
49:
50: TYPE SAVE_REGION_ITEM_REC IS RECORD(
51: attribute2 AK_REGION_ITEMS_VL.attribute2%TYPE,
52: base_column AK_REGION_ITEMS_VL.attribute3%TYPE,
53: where_clause AK_REGION_ITEMS_VL.attribute4%TYPE,
54: data_type AK_REGION_ITEMS_VL.attribute14%TYPE);
55:
56: TYPE SAVE_REGION_ITEM_TBL IS TABLE OF SAVE_REGION_ITEM_REC INDEX BY BINARY_INTEGER;
49:
50: TYPE SAVE_REGION_ITEM_REC IS RECORD(
51: attribute2 AK_REGION_ITEMS_VL.attribute2%TYPE,
52: base_column AK_REGION_ITEMS_VL.attribute3%TYPE,
53: where_clause AK_REGION_ITEMS_VL.attribute4%TYPE,
54: data_type AK_REGION_ITEMS_VL.attribute14%TYPE);
55:
56: TYPE SAVE_REGION_ITEM_TBL IS TABLE OF SAVE_REGION_ITEM_REC INDEX BY BINARY_INTEGER;
57:
50: TYPE SAVE_REGION_ITEM_REC IS RECORD(
51: attribute2 AK_REGION_ITEMS_VL.attribute2%TYPE,
52: base_column AK_REGION_ITEMS_VL.attribute3%TYPE,
53: where_clause AK_REGION_ITEMS_VL.attribute4%TYPE,
54: data_type AK_REGION_ITEMS_VL.attribute14%TYPE);
55:
56: TYPE SAVE_REGION_ITEM_TBL IS TABLE OF SAVE_REGION_ITEM_REC INDEX BY BINARY_INTEGER;
57:
58: -- report info from bis_ak_region_item_extension