APPS.BIS_PMV_QUERY_PVT dependencies on BIS_PMV_SESSION_PVT

Line 83: procedure GET_TARGET_SELECT(p_user_session_rec in BIS_PMV_SESSION_PVT.SESSION_REC_TYPE,

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,
87: p_plan_id in VARCHAR2,

Line 177: pUserSession in BIS_PMV_SESSION_PVT.SESSION_REC_TYPE,

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,
181: p_viewby_dimension IN VARCHAR2,

Line 201: pUserSession_rec IN BIS_PMV_SESSION_PVT.SESSION_REC_TYPE,

197: p_Parameter_name IN VARCHAR2
198: ) RETURN VARCHAR2 ;
199:
200: PROCEDURE substitute_lov_where(
201: pUserSession_rec IN BIS_PMV_SESSION_PVT.SESSION_REC_TYPE,
202: pSchedule_id IN VARCHAR2,
203: pSource In VARCHAR2 DEFAULT'REPORT',
204: x_lov_where IN OUT NOCOPY VARCHAR2,
205: x_return_status out NOCOPY VARCHAR2,

Line 225: (pUserSession in BIS_PMV_SESSION_PVT.SESSION_REC_TYPE,

221: x_bind_indexes in out NOCOPY varchar2,
222: x_bind_datatypes IN OUT NOCOPY VARCHAR2,
223: x_bind_count in out NOCOPY number);
224: procedure replace_product_binds
225: (pUserSession in BIS_PMV_SESSION_PVT.SESSION_REC_TYPE,
226: p_original_sql IN VARCHAR2,
227: p_custom_output IN BIS_QUERY_ATTRIBUTES_TBL,
228: x_custom_sql IN OUT NOCOPY VARCHAR2,
229: x_bind_variables IN OUT NOCOPY VARCHAR2,