[Home] [Help]
125: -- added p_replace_mode
126: -- p_replace_mode = '1' => previous time value already known (passed as p_default_start_date,p_default_end_date)
127: -- = '2' => API to get previous time values needs to get called
128: PROCEDURE replace_prev_time_parameters(
129: p_user_session_rec IN BIS_PMV_SESSION_PVT.SESSION_REC_TYPE,
130: p_time_parameter IN VARCHAR2,
131: p_asof_date IN VARCHAR2,
132: p_time_comparison_type IN VARCHAR2,
133: p_default_start_date IN VARCHAR2,
237:
238: END replace_prev_time_parameters;
239:
240: PROCEDURE retrieve_params_from_page (
241: p_user_session_rec IN BIS_PMV_SESSION_PVT.SESSION_REC_TYPE,
242: p_paramlvlparam_Tbl IN BIS_PMV_PARAMETERS_PVT.parameter_tbl_Type,
243: x_asof_date OUT NOCOPY VARCHAR2,
244: x_prev_asof_date OUT NOCOPY VARCHAR2,
245: x_time_comparison_type OUT NOCOPY VARCHAR2,
276: END retrieve_params_from_page;
277:
278: --replaces the ASOF_DATE substitution variables
279: PROCEDURE replace_paramLvl_parameters(
280: p_user_session_rec IN BIS_PMV_SESSION_PVT.SESSION_REC_TYPE,
281: p_asof_date IN VARCHAR2,
282: p_prev_asof_date IN VARCHAR2,
283: p_time_comparison_type IN VARCHAR2,
284: p_time_parameter IN VARCHAR2,
344:
345:
346: -- replaces the time parameters
347: PROCEDURE replace_report_parameters(
348: p_user_session_rec IN BIS_PMV_SESSION_PVT.SESSION_REC_TYPE ,
349: pParameterTbl IN BIS_PMV_PARAMETERS_PVT.PARAMETER_TBL_TYPE,
350: pStartChar IN CHAR DEFAULT '&',
351: pEndChar IN CHAR DEFAULT '',
352: pUseBindVariable In BOOLEAN DEFAULT true,
516:
517: /** substitute each of the dim+dimLevels of the params (parameterName) present in the where clause*/
518:
519: PROCEDURE replace_custom_sql(
520: p_user_session_rec IN BIS_PMV_SESSION_PVT.SESSION_REC_TYPE ,
521: pParameterTbl IN BIS_PMV_PARAMETERS_PVT.PARAMETER_TBL_TYPE ,
522: p_original_sql in varchar2,
523: p_where IN OUT NOCOPY VARCHAR2,
524: x_bind_variables IN OUT NOCOPY VARCHAR2,
696: l_user_orderby VARCHAR2(2000);
697:
698:
699: -- parameter info from bis_user_attributes
700: l_user_session_rec BIS_PMV_SESSION_PVT.SESSION_REC_TYPE;
701: l_parameter_rec BIS_PMV_PARAMETERS_PVT.PARAMETER_REC_TYPE;
702: l_parameter_tbl BIS_PMV_PARAMETERS_PVT.PARAMETER_TBL_TYPE;
703:
704: -- report info from ak_regions_vl
2731:
2732: END order_Dimensions;
2733:
2734:
2735: procedure GET_TARGET_SELECT(p_user_session_rec in BIS_PMV_SESSION_PVT.SESSION_REC_TYPE,
2736: p_ak_region_item_rec in BIS_PMV_METADATA_PVT.AK_REGION_ITEM_REC,
2737: p_parameter_tbl in BIS_PMV_PARAMETERS_PVT.PARAMETER_TBL_TYPE,
2738: p_report_type in VARCHAR2,
2739: p_plan_id in VARCHAR2,
3406: /** Procedure to retun thre order by clause for given metadata and parmeters */
3407: procedure get_order_by_clause(
3408: p_source in varchar2 DEFAULT 'REPORT',
3409: pAKRegionRec in BIS_PMV_METADATA_PVT.AK_REGION_REC,
3410: pUserSession in BIS_PMV_SESSION_PVT.SESSION_REC_TYPE,
3411: p_sort_attribute in VARCHAR2 DEFAULT NULL,
3412: p_sort_direction in VARCHAR2 DEFAULT NULL,
3413: p_viewby_attribute2 IN VARCHAR2,
3414: p_viewby_dimension IN VARCHAR2,
3728: END getParameterAcronym ;
3729:
3730: /** Procedure to replace the view by parameter for a given user session rec*/
3731: PROCEDURE process_custom_view_by(
3732: pUserSession in BIS_PMV_SESSION_PVT.SESSION_REC_TYPE,
3733: pViewByParam IN VARCHAR2
3734: ) IS
3735: l_return_status VARCHAR2(80);
3736: l_msg_count NUMBER;
3735: l_return_status VARCHAR2(80);
3736: l_msg_count NUMBER;
3737: l_msg_data VARCHAR2(2000);
3738: l_parameter_rec BIS_PMV_PARAMETERS_PVT.parameter_rec_type ;
3739: l_user_session_rec BIS_PMV_SESSION_PVT.SESSION_REC_TYPE := pUserSession;
3740: BEGIN
3741:
3742: l_user_session_rec.page_id := null;
3743: --delete the existing view by
3798: END process_custom_view_by;
3799:
3800: /** Procedure to process the custom output from a pl/sql procedure call*/
3801: PROCEDURE process_custom_output(
3802: pUserSession in BIS_PMV_SESSION_PVT.SESSION_REC_TYPE,
3803: pCustomOutput IN bis_map_tbl,
3804: xCustom_sql OUT NOCOPY VARCHAR2,
3805: x_view_by_value OUT NOCOPY VARCHAR2
3806: ) IS
3823:
3824: procedure get_custom_sql (p_source in varchar2 DEFAULT 'REPORT',
3825: pAKRegionRec in BIS_PMV_METADATA_PVT.AK_REGION_REC,
3826: pParameterTbl in BIS_PMV_PARAMETERS_PVT.PARAMETER_TBL_TYPE,
3827: pUserSession in BIS_PMV_SESSION_PVT.SESSION_REC_TYPE,
3828: p_sort_attribute in VARCHAR2 DEFAULT NULL,
3829: p_sort_direction in VARCHAR2 DEFAULT NULL,
3830: p_viewby_attribute2 VARCHAR2,
3831: p_viewby_dimension VARCHAR2,
4462: null;
4463: END;
4464:
4465: PROCEDURE replaceAttrCodeWithDimension(
4466: pUserSession_rec IN BIS_PMV_SESSION_PVT.SESSION_REC_TYPE,
4467: x_custom_sql In OUT NOCOPY VARCHAR2
4468: ) IS
4469: vAttributeCode VARCHAR2(150);
4470: vAttribute2 VARCHAR2(150);
4488:
4489: END replaceAttrCodeWithDimension;
4490:
4491: PROCEDURE substitute_lov_where(
4492: pUserSession_rec IN BIS_PMV_SESSION_PVT.SESSION_REC_TYPE,
4493: pSchedule_id IN VARCHAR2,
4494: pSource In VARCHAR2 DEFAULT 'REPORT',
4495: x_lov_where IN OUT NOCOPY VARCHAR2,
4496: x_return_status out NOCOPY VARCHAR2,
4639:
4640: end replace_with_bind_variables;
4641:
4642: procedure replace_product_binds
4643: (pUSerSession IN BIS_PMV_SESSION_PVT.SESSION_REC_TYPE,
4644: p_original_sql IN VARCHAR2,
4645: p_custom_output IN BIS_QUERY_ATTRIBUTES_TBL,
4646: x_custom_sql IN OUT NOCOPY VARCHAR2,
4647: x_bind_variables IN OUT NOCOPY VARCHAR2,