DBA Data[Home] [Help]

APPS.BIS_PMV_QUERY_PVT dependencies on BISVIEWER

Line 767: l_base_column_tbl BISVIEWER.t_char;

763: l_item_count number;
764: l_ak_region_item_rec BIS_PMV_METADATA_PVT.AK_REGION_ITEM_REC;
765: l_ak_region_item_tbl BIS_PMV_METADATA_PVT.AK_REGION_ITEM_TBL;
766: l_Ak_count number :=1;
767: l_base_column_tbl BISVIEWER.t_char;
768: l_aggregation_tbl BISVIEWER.t_char;
769:
770: /*
771: l_attribute_type VARCHAR2(2000);

Line 768: l_aggregation_tbl BISVIEWER.t_char;

764: l_ak_region_item_rec BIS_PMV_METADATA_PVT.AK_REGION_ITEM_REC;
765: l_ak_region_item_tbl BIS_PMV_METADATA_PVT.AK_REGION_ITEM_TBL;
766: l_Ak_count number :=1;
767: l_base_column_tbl BISVIEWER.t_char;
768: l_aggregation_tbl BISVIEWER.t_char;
769:
770: /*
771: l_attribute_type VARCHAR2(2000);
772: l_attribute_code VARCHAR2(2000);

Line 822: l_def_sort_attr_tbl BISVIEWER.t_char;

818: l_viewby_value_name VARCHAR2(2000);
819: l_extra_groupby_label VARCHAR2(2000);
820: l_extra_groupby_name VARCHAR2(2000);
821: l_default_sort_attribute VARCHAR2(2000) := '';
822: l_def_sort_attr_tbl BISVIEWER.t_char;
823: l_Def_sort_seq_tbl BISVIEWER.t_Char;
824: l_def_sort_count NUMBER := 1;
825: l_sort_attr_code VARCHAR2(150);
826: --changed l_sort_attr_code size from 30 to 150 for bugfix 2598917

Line 823: l_Def_sort_seq_tbl BISVIEWER.t_Char;

819: l_extra_groupby_label VARCHAR2(2000);
820: l_extra_groupby_name VARCHAR2(2000);
821: l_default_sort_attribute VARCHAR2(2000) := '';
822: l_def_sort_attr_tbl BISVIEWER.t_char;
823: l_Def_sort_seq_tbl BISVIEWER.t_Char;
824: l_def_sort_count NUMBER := 1;
825: l_sort_attr_code VARCHAR2(150);
826: --changed l_sort_attr_code size from 30 to 150 for bugfix 2598917
827: l_first_attr_code VARCHAR2(2000);

Line 1635: ,p_base_column_tbl in out NOCOPY BISVIEWER.t_char

1631: end APPLY_DATA_FORMAT;
1632:
1633: function GET_CALCULATE_SELECT(p_ak_region_item_rec in BIS_PMV_METADATA_PVT.AK_REGION_ITEM_REC
1634: ,p_parameter_tbl in BIS_PMV_PARAMETERS_PVT.PARAMETER_TBL_TYPE
1635: ,p_base_column_tbl in out NOCOPY BISVIEWER.t_char
1636: ,p_aggregation_tbl in out NOCOPY BISVIEWER.t_char)
1637: return varchar2 is
1638: l_calculate_select varchar2(2000);
1639: begin

Line 1636: ,p_aggregation_tbl in out NOCOPY BISVIEWER.t_char)

1632:
1633: function GET_CALCULATE_SELECT(p_ak_region_item_rec in BIS_PMV_METADATA_PVT.AK_REGION_ITEM_REC
1634: ,p_parameter_tbl in BIS_PMV_PARAMETERS_PVT.PARAMETER_TBL_TYPE
1635: ,p_base_column_tbl in out NOCOPY BISVIEWER.t_char
1636: ,p_aggregation_tbl in out NOCOPY BISVIEWER.t_char)
1637: return varchar2 is
1638: l_calculate_select varchar2(2000);
1639: begin
1640: if substr(p_ak_region_item_rec.base_column, 1, 1) = '''' then

Line 1658: ,p_base_column_tbl in out NOCOPY BISVIEWER.t_char

1654:
1655: --not implemented yet!!
1656: function REPLACE_FORMULA(p_ak_region_item_rec in BIS_PMV_METADATA_PVT.AK_REGION_ITEM_REC
1657: ,p_parameter_tbl in BIS_PMV_PARAMETERS_PVT.PARAMETER_TBL_TYPE
1658: ,p_base_column_tbl in out NOCOPY BISVIEWER.t_char
1659: ,p_aggregation_tbl in out NOCOPY BISVIEWER.t_char)
1660: return varchar2 is
1661: l_formula varchar2(2000);
1662: l_param_name_tbl BISVIEWER.t_char;

Line 1659: ,p_aggregation_tbl in out NOCOPY BISVIEWER.t_char)

1655: --not implemented yet!!
1656: function REPLACE_FORMULA(p_ak_region_item_rec in BIS_PMV_METADATA_PVT.AK_REGION_ITEM_REC
1657: ,p_parameter_tbl in BIS_PMV_PARAMETERS_PVT.PARAMETER_TBL_TYPE
1658: ,p_base_column_tbl in out NOCOPY BISVIEWER.t_char
1659: ,p_aggregation_tbl in out NOCOPY BISVIEWER.t_char)
1660: return varchar2 is
1661: l_formula varchar2(2000);
1662: l_param_name_tbl BISVIEWER.t_char;
1663: l_param_value_tbl BISVIEWER.t_char;

Line 1662: l_param_name_tbl BISVIEWER.t_char;

1658: ,p_base_column_tbl in out NOCOPY BISVIEWER.t_char
1659: ,p_aggregation_tbl in out NOCOPY BISVIEWER.t_char)
1660: return varchar2 is
1661: l_formula varchar2(2000);
1662: l_param_name_tbl BISVIEWER.t_char;
1663: l_param_value_tbl BISVIEWER.t_char;
1664: l_return_Status VARCHAR2(1);
1665: l_msg_count NUMBER;
1666: l_msg_data VARCHAR2(2000);

Line 1663: l_param_value_tbl BISVIEWER.t_char;

1659: ,p_aggregation_tbl in out NOCOPY BISVIEWER.t_char)
1660: return varchar2 is
1661: l_formula varchar2(2000);
1662: l_param_name_tbl BISVIEWER.t_char;
1663: l_param_value_tbl BISVIEWER.t_char;
1664: l_return_Status VARCHAR2(1);
1665: l_msg_count NUMBER;
1666: l_msg_data VARCHAR2(2000);
1667: l_base_column VARCHAR2(150);

Line 3311: (pSortNameTbl in out NOCOPY BISVIEWER.t_char

3307: l_user_string := replace(l_user_string, '', 'SV.');
3308: return l_user_string;
3309: end GET_USER_STRING;
3310: procedure sort
3311: (pSortNameTbl in out NOCOPY BISVIEWER.t_char
3312: ,pSortValueTbl in out NOCOPY BISVIEWER.t_char
3313: )
3314: IS
3315: l_temp_value varchar2(2000);

Line 3312: ,pSortValueTbl in out NOCOPY BISVIEWER.t_char

3308: return l_user_string;
3309: end GET_USER_STRING;
3310: procedure sort
3311: (pSortNameTbl in out NOCOPY BISVIEWER.t_char
3312: ,pSortValueTbl in out NOCOPY BISVIEWER.t_char
3313: )
3314: IS
3315: l_temp_value varchar2(2000);
3316: l_temp_name varchar2(2000);

Line 3425: l_def_sort_attr_tbl BISVIEWER.t_char;

3421: l_view_by_attr_code VARCHAR2(80);
3422: l_main_order_by VARCHAR2(100) :=NULL;
3423: l_first_order_by VARCHAR2(100) := NULL;
3424: l_second_order_by VARCHAR2(100) := NULL;
3425: l_def_sort_attr_tbl BISVIEWER.t_char;
3426: l_Def_sort_seq_tbl BISVIEWER.t_Char;
3427: l_sort_attr_code VARCHAR2(150);
3428: --changed l_sort_attr_code size from 30 to 150 for bugfix 2598917
3429: l_def_sort_count NUMBER := 1;

Line 3426: l_Def_sort_seq_tbl BISVIEWER.t_Char;

3422: l_main_order_by VARCHAR2(100) :=NULL;
3423: l_first_order_by VARCHAR2(100) := NULL;
3424: l_second_order_by VARCHAR2(100) := NULL;
3425: l_def_sort_attr_tbl BISVIEWER.t_char;
3426: l_Def_sort_seq_tbl BISVIEWER.t_Char;
3427: l_sort_attr_code VARCHAR2(150);
3428: --changed l_sort_attr_code size from 30 to 150 for bugfix 2598917
3429: l_def_sort_count NUMBER := 1;
3430: l_default_sort_attribute VARCHAR2(2000) := '';