eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BIS_PMV_QUERY_PVT dependencies on BIS_PMV_PARAMETERS_PVT

Line 76: ,p_parameter_tbl in BIS_PMV_PARAMETERS_PVT.PARAMETER_TBL_TYPE

72:
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

Line 80: ,p_parameter_tbl in BIS_PMV_PARAMETERS_PVT.PARAMETER_TBL_TYPE

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;
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,

Line 85: 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,
87: p_plan_id in VARCHAR2,
88: p_viewby_dimension in VARCHAR2,
89: p_viewby_attribute2 in VARCHAR2,

Line 99: function GET_DIMENSION_WHERE(p_parameter_rec in BIS_PMV_PARAMETERS_PVT.PARAMETER_REC_TYPE,

95: x_bind_variables in OUT NOCOPY VARCHAR2,
96: --x_bind_indexes in OUT NOCOPY VARCHAR2,
97: x_bind_count in out NOCOPY number
98: );
99: function GET_DIMENSION_WHERE(p_parameter_rec in BIS_PMV_PARAMETERS_PVT.PARAMETER_REC_TYPE,
100: p_save_region_item_rec in BIS_PMV_METADATA_PVT.SAVE_REGION_ITEM_REC,
101: p_ak_region_rec in BIS_PMV_METADATA_PVT.AK_REGION_REC,
102: p_org_dimension_level in VARCHAR2,
103: p_org_dimension_level_value in VARCHAR2,

Line 112: function GET_TIME_WHERE(p_parameter_rec in BIS_PMV_PARAMETERS_PVT.PARAMETER_REC_TYPE,

108: p_TM_alias in VARCHAR2,
109: x_bind_variables in OUT NOCOPY VARCHAR2,
110: --x_bind_indexes in OUT NOCOPY VARCHAR2,
111: x_bind_count in out NOCOPY number) return varchar2;
112: function GET_TIME_WHERE(p_parameter_rec in BIS_PMV_PARAMETERS_PVT.PARAMETER_REC_TYPE,
113: p_save_region_item_rec in BIS_PMV_METADATA_PVT.SAVE_REGION_ITEM_REC,
114: p_ak_region_rec in BIS_PMV_METADATA_PVT.AK_REGION_REC,
115: p_org_dimension_level in VARCHAR2,
116: p_org_dimension_level_value in VARCHAR2,

Line 131: function GET_NON_TIME_WHERE(p_parameter_rec in BIS_PMV_PARAMETERS_PVT.PARAMETER_REC_TYPE,

127: p_TM_alias in VARCHAR2,
128: x_bind_variables in OUT NOCOPY VARCHAR2,
129: --x_bind_indexes in OUT NOCOPY VARCHAR2,
130: x_bind_count in out NOCOPY number) return varchar2;
131: function GET_NON_TIME_WHERE(p_parameter_rec in BIS_PMV_PARAMETERS_PVT.PARAMETER_REC_TYPE,
132: p_save_region_item_rec in BIS_PMV_METADATA_PVT.SAVE_REGION_ITEM_REC,
133: p_source in varchar2 default null,
134: x_bind_variables in OUT NOCOPY VARCHAR2,
135: --x_bind_indexes in OUT NOCOPY VARCHAR2,

Line 137: function GET_NON_DIMENSION_WHERE(p_parameter_rec in BIS_PMV_PARAMETERS_PVT.PARAMETER_REC_TYPE,

133: p_source in varchar2 default null,
134: x_bind_variables in OUT NOCOPY VARCHAR2,
135: --x_bind_indexes in OUT NOCOPY VARCHAR2,
136: x_bind_count in out NOCOPY number) return varchar2;
137: function GET_NON_DIMENSION_WHERE(p_parameter_rec in BIS_PMV_PARAMETERS_PVT.PARAMETER_REC_TYPE,
138: p_save_region_item_rec in BIS_PMV_METADATA_PVT.SAVE_REGION_ITEM_REC,
139: x_bind_variables in OUT NOCOPY VARCHAR2,
140: --x_bind_indexes in OUT NOCOPY VARCHAR2,
141: x_bind_count in out NOCOPY number) return varchar2;

Line 142: function GET_LOV_WHERE(p_parameter_tbl in BIS_PMV_PARAMETERS_PVT.PARAMETER_TBL_TYPE,

138: p_save_region_item_rec in BIS_PMV_METADATA_PVT.SAVE_REGION_ITEM_REC,
139: x_bind_variables in OUT NOCOPY VARCHAR2,
140: --x_bind_indexes in OUT NOCOPY VARCHAR2,
141: x_bind_count in out NOCOPY number) return varchar2;
142: function GET_LOV_WHERE(p_parameter_tbl in BIS_PMV_PARAMETERS_PVT.PARAMETER_TBL_TYPE,
143: p_where_clause in VARCHAR2,
144: p_region_code in VARCHAR2 ) return varchar2;
145: function GET_GROUP_BY(p_disable_viewby in VARCHAR2,
146: p_viewby_id_name in VARCHAR2,

Line 176: pParameterTbl in BIS_PMV_PARAMETERS_PVT.PARAMETER_TBL_TYPE,

172: p_first_order_by in out NOCOPY varchar2,
173: p_second_order_by in out NOCOPY varchar2);
174: procedure get_custom_sql ( p_source in varchar2 DEFAULT 'REPORT',
175: pAKRegionRec in BIS_PMV_METADATA_PVT.AK_REGION_REC,
176: pParameterTbl in BIS_PMV_PARAMETERS_PVT.PARAMETER_TBL_TYPE,
177: pUserSession in BIS_PMV_SESSION_PVT.SESSION_REC_TYPE,
178: p_sort_attribute in VARCHAR2 DEFAULT NULL,
179: p_sort_direction in VARCHAR2 DEFAULT NULL,
180: p_viewby_attribute2 IN VARCHAR2,