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_METADATA_PVT

Line 73: function GET_NORMAL_SELECT(p_ak_region_item_rec in BIS_PMV_METADATA_PVT.AK_REGION_ITEM_REC) return varchar2;

69: x_bind_datatypes OUT NOCOPY VARCHAR2,
70: x_view_by_value OUT NOCOPY VARCHAR2
71: );
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

Line 74: function APPLY_DATA_FORMAT(p_ak_region_item_rec in BIS_PMV_METADATA_PVT.AK_REGION_ITEM_REC) return varchar2;

70: x_view_by_value OUT NOCOPY VARCHAR2
71: );
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;

Line 75: function GET_CALCULATE_SELECT(p_ak_region_item_rec in BIS_PMV_METADATA_PVT.AK_REGION_ITEM_REC

71: );
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

Line 79: function REPLACE_FORMULA(p_ak_region_item_rec in BIS_PMV_METADATA_PVT.AK_REGION_ITEM_REC

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;
83: procedure GET_TARGET_SELECT(p_user_session_rec in BIS_PMV_SESSION_PVT.SESSION_REC_TYPE,

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

Line 100: p_save_region_item_rec in BIS_PMV_METADATA_PVT.SAVE_REGION_ITEM_REC,

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,
104: p_viewby_dimension in VARCHAR2,

Line 101: p_ak_region_rec in BIS_PMV_METADATA_PVT.AK_REGION_REC,

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,
104: p_viewby_dimension in VARCHAR2,
105: p_time_id_name in VARCHAR2,

Line 113: p_save_region_item_rec in BIS_PMV_METADATA_PVT.SAVE_REGION_ITEM_REC,

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,
117: p_viewby_dimension in VARCHAR2,

Line 114: p_ak_region_rec in BIS_PMV_METADATA_PVT.AK_REGION_REC,

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,
117: p_viewby_dimension in VARCHAR2,
118: p_time_id_name in VARCHAR2,

Line 132: p_save_region_item_rec in BIS_PMV_METADATA_PVT.SAVE_REGION_ITEM_REC,

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,
136: x_bind_count in out NOCOPY number) return varchar2;

Line 138: p_save_region_item_rec in BIS_PMV_METADATA_PVT.SAVE_REGION_ITEM_REC,

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;
142: function GET_LOV_WHERE(p_parameter_tbl in BIS_PMV_PARAMETERS_PVT.PARAMETER_TBL_TYPE,

Line 175: pAKRegionRec in BIS_PMV_METADATA_PVT.AK_REGION_REC,

171: p_main_order_by in out NOCOPY varchar2,
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,