DBA Data[Home] [Help]

APPS.BIS_PMV_QUERY_PVT dependencies on BISVIEWER

Line 77: ,p_base_column_tbl in out NOCOPY BISVIEWER.t_char

73: function GET_NORMAL_SELECT(p_ak_region_item_rec in BIS_PMV_METADATA_PVT.AK_REGION_ITEM_REC) return varchar2;
74: function APPLY_DATA_FORMAT(p_ak_region_item_rec in BIS_PMV_METADATA_PVT.AK_REGION_ITEM_REC) return varchar2;
75: function GET_CALCULATE_SELECT(p_ak_region_item_rec in BIS_PMV_METADATA_PVT.AK_REGION_ITEM_REC
76: ,p_parameter_tbl in BIS_PMV_PARAMETERS_PVT.PARAMETER_TBL_TYPE
77: ,p_base_column_tbl in out NOCOPY BISVIEWER.t_char
78: ,p_aggregation_tbl in out NOCOPY BISVIEWER.t_char) return varchar2;
79: function REPLACE_FORMULA(p_ak_region_item_rec in BIS_PMV_METADATA_PVT.AK_REGION_ITEM_REC
80: ,p_parameter_tbl in BIS_PMV_PARAMETERS_PVT.PARAMETER_TBL_TYPE
81: ,p_base_column_tbl in out NOCOPY BISVIEWER.t_char

Line 78: ,p_aggregation_tbl in out NOCOPY BISVIEWER.t_char) return varchar2;

74: function APPLY_DATA_FORMAT(p_ak_region_item_rec in BIS_PMV_METADATA_PVT.AK_REGION_ITEM_REC) return varchar2;
75: function GET_CALCULATE_SELECT(p_ak_region_item_rec in BIS_PMV_METADATA_PVT.AK_REGION_ITEM_REC
76: ,p_parameter_tbl in BIS_PMV_PARAMETERS_PVT.PARAMETER_TBL_TYPE
77: ,p_base_column_tbl in out NOCOPY BISVIEWER.t_char
78: ,p_aggregation_tbl in out NOCOPY BISVIEWER.t_char) return varchar2;
79: function REPLACE_FORMULA(p_ak_region_item_rec in BIS_PMV_METADATA_PVT.AK_REGION_ITEM_REC
80: ,p_parameter_tbl in BIS_PMV_PARAMETERS_PVT.PARAMETER_TBL_TYPE
81: ,p_base_column_tbl in out NOCOPY BISVIEWER.t_char
82: ,p_aggregation_tbl in out NOCOPY BISVIEWER.t_Char) return varchar2;

Line 81: ,p_base_column_tbl in out NOCOPY BISVIEWER.t_char

77: ,p_base_column_tbl in out NOCOPY BISVIEWER.t_char
78: ,p_aggregation_tbl in out NOCOPY BISVIEWER.t_char) return varchar2;
79: function REPLACE_FORMULA(p_ak_region_item_rec in BIS_PMV_METADATA_PVT.AK_REGION_ITEM_REC
80: ,p_parameter_tbl in BIS_PMV_PARAMETERS_PVT.PARAMETER_TBL_TYPE
81: ,p_base_column_tbl in out NOCOPY BISVIEWER.t_char
82: ,p_aggregation_tbl in out NOCOPY BISVIEWER.t_Char) return varchar2;
83: procedure GET_TARGET_SELECT(p_user_session_rec in BIS_PMV_SESSION_PVT.SESSION_REC_TYPE,
84: p_ak_region_item_rec in BIS_PMV_METADATA_PVT.AK_REGION_ITEM_REC,
85: p_parameter_tbl in BIS_PMV_PARAMETERS_PVT.PARAMETER_TBL_TYPE,

Line 82: ,p_aggregation_tbl in out NOCOPY BISVIEWER.t_Char) return varchar2;

78: ,p_aggregation_tbl in out NOCOPY BISVIEWER.t_char) return varchar2;
79: function REPLACE_FORMULA(p_ak_region_item_rec in BIS_PMV_METADATA_PVT.AK_REGION_ITEM_REC
80: ,p_parameter_tbl in BIS_PMV_PARAMETERS_PVT.PARAMETER_TBL_TYPE
81: ,p_base_column_tbl in out NOCOPY BISVIEWER.t_char
82: ,p_aggregation_tbl in out NOCOPY BISVIEWER.t_Char) return varchar2;
83: procedure GET_TARGET_SELECT(p_user_session_rec in BIS_PMV_SESSION_PVT.SESSION_REC_TYPE,
84: p_ak_region_item_rec in BIS_PMV_METADATA_PVT.AK_REGION_ITEM_REC,
85: p_parameter_tbl in BIS_PMV_PARAMETERS_PVT.PARAMETER_TBL_TYPE,
86: p_report_type in VARCHAR2,

Line 163: (pSortNameTbl in out NOCOPY BISVIEWER.t_char

159: p_default_sort_attribute in VARCHAR2,
160: p_user_orderby in VARCHAR2) return varchar2;
161: function GET_USER_STRING(p_user_string in VARCHAR2) return varchar2;
162: procedure sort
163: (pSortNameTbl in out NOCOPY BISVIEWER.t_char
164: ,pSortValueTbl in out NOCOPY BISVIEWER.t_Char
165: );
166: procedure get_customized_order_by(p_viewby in varchar2,
167: p_attribute_code in varchar2,

Line 164: ,pSortValueTbl in out NOCOPY BISVIEWER.t_Char

160: p_user_orderby in VARCHAR2) return varchar2;
161: function GET_USER_STRING(p_user_string in VARCHAR2) return varchar2;
162: procedure sort
163: (pSortNameTbl in out NOCOPY BISVIEWER.t_char
164: ,pSortValueTbl in out NOCOPY BISVIEWER.t_Char
165: );
166: procedure get_customized_order_by(p_viewby in varchar2,
167: p_attribute_code in varchar2,
168: p_region_code in varchar2,