PACKAGE: APPS.BIS_PMV_METADATA_PVT

Source

1 Package BIS_PMV_METADATA_PVT AUTHID CURRENT_USER AS
2 /* $Header: BISVMDTS.pls 115.7 2002/08/16 01:34:52 gsanap noship $ */
3 -- dbdrv: sql ~PROD ~PATH ~FILE none none none package &phase=pls \
4 -- dbdrv: checkfile:~PROD:~PATH:~FILE
5 --
6 -- To modify this template, edit file PKGSPEC.TXT in TEMPLATE
7 -- directory of SQL Navigator
8 --
9 -- Purpose: Briefly explain the functionality of the package
10 --
11 -- MODIFICATION HISTORY
12 -- Person      Date    Comments
13 --
14 -- Nihar       29-MAY-2002   Bug Fix 2371922: Added node_display_flag to AK_REGION_ITEM_REC
15 -- ---------   ------  ---------------------------------------------------------------------
16 -- Enter package declarations as shown below
17 
18 -- report info from ak_regions_vl
19 TYPE AK_REGION_REC IS RECORD(
20 disable_viewby AK_REGIONS_VL.attribute1%TYPE,
21 user_groupby   AK_REGIONS_VL.attribute6%TYPE,
22 user_orderby   AK_REGIONS_VL.attribute7%TYPE,
23 source_view    AK_REGIONS_VL.database_object_name%TYPE,
24 report_type    AK_REGIONS_VL.region_object_type%TYPE,
25 plsql_function AK_REGIONS_VL.attribute8%TYPE,
26 data_source    AK_REGIONS_VL.attribute10%TYPE,
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,
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,
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 
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
59 TYPE AK_REGION_ITEM_EXT_REC IS RECORD(
60 extra_groupby  BIS_AK_REGION_ITEM_EXTENSION.attribute16%TYPE);
61 
62 TYPE AK_REGION_ITEM_EXT_TBL IS TABLE OF AK_REGION_ITEM_EXT_REC INDEX BY BINARY_INTEGER;
63 
64 END; -- Package Specification BIS_PMV_METADATA_PVT