[Home] [Help]
27: ******************************************************************************/
28:
29: PROCEDURE BIL_BI_FST_WON_QTA_TREND(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL
30: ,x_custom_sql OUT NOCOPY VARCHAR2
31: ,x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL )
32: IS
33: l_custom_sql VARCHAR2(32000);
34: l_period_type VARCHAR2(200);
35: l_sg_id VARCHAR2(200);
878:
879:
880: l_bind_ctr := 1;
881:
882: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
883:
884: l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;
885: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.VIEW_BY_TYPE;
886: l_custom_rec.attribute_value := l_viewby;
1094: ******************************************************************************/
1095:
1096: PROCEDURE BIL_BI_FRCST_PIPE_TREND(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL
1097: ,x_custom_sql OUT NOCOPY VARCHAR2
1098: ,x_custom_attr OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL )
1099: IS
1100: l_custom_sql VARCHAR2(10000);
1101: l_period_type VARCHAR2(200);
1102: l_sg_id VARCHAR2(200);
1915:
1916:
1917: l_bind_ctr := 1;
1918:
1919: x_custom_attr := BIS_QUERY_ATTRIBUTES_TBL();
1920:
1921: l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;
1922: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.VIEW_BY_TYPE;
1923: l_custom_rec.attribute_value := l_viewby;
2123: * 02 Jun 2004 ctoba Pipeline related changes (do rollup on product in front end)
2124: ******************************************************************************/
2125: PROCEDURE BIL_BI_FRCST_PIPE_WON_TREND(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL
2126: ,x_custom_sql OUT NOCOPY VARCHAR2
2127: ,x_custom_attr OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
2128: IS
2129: l_period_type VARCHAR2(200);
2130: l_conv_rate_selected VARCHAR2(200);
2131: l_sg_id VARCHAR2(200);
2198:
2199: END IF;
2200:
2201:
2202: x_custom_attr := BIS_QUERY_ATTRIBUTES_TBL();
2203: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
2204:
2205: BIL_BI_UTIL_PKG.GET_PAGE_PARAMS(p_page_parameter_tbl =>p_page_parameter_tbl,
2206: p_region_id =>l_region_id,
2731: * 01/02/04 ESAPOZHN Intial Version
2732: ******************************************************************************/
2733: PROCEDURE BIL_BI_PIPELINE_MOMENTUM_TREND( p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL
2734: ,x_custom_sql OUT NOCOPY VARCHAR2
2735: ,x_custom_attr OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL )
2736:
2737: IS
2738:
2739: --page params
2813:
2814: END IF;
2815:
2816:
2817: x_custom_attr := BIS_QUERY_ATTRIBUTES_TBL();
2818: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
2819:
2820:
2821: BIL_BI_UTIL_PKG.GET_OTHER_PROFILES(x_DebugMode => l_DebugMode);
3273: ******************************************************************************/
3274:
3275: PROCEDURE BIL_BI_WIN_LOSS_CONV_TREND( p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL
3276: ,x_custom_sql OUT NOCOPY VARCHAR2
3277: ,x_custom_attr OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL )
3278: IS
3279:
3280: --page params
3281: l_region_id VARCHAR2(100);
3351: MESSAGE => ' Start of Procedure '|| l_proc);
3352:
3353: END IF;
3354:
3355: x_custom_attr := BIS_QUERY_ATTRIBUTES_TBL();
3356: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
3357:
3358: BIL_BI_UTIL_PKG.GET_PAGE_PARAMS(p_page_parameter_tbl =>p_page_parameter_tbl,
3359: p_region_id =>l_region_id,
3809: ******************************************************************************/
3810:
3811: PROCEDURE BIL_BI_FRCST_WON_TREND(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL
3812: ,x_custom_sql OUT NOCOPY VARCHAR2
3813: ,x_custom_attr OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL )
3814: IS
3815: l_region_id VARCHAR2(100);
3816: l_period_type VARCHAR2(200);
3817: l_conv_rate_selected VARCHAR2(200);
3890:
3891: END IF;
3892:
3893:
3894: x_custom_attr := BIS_QUERY_ATTRIBUTES_TBL();
3895: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
3896:
3897:
3898: BIL_BI_UTIL_PKG.GET_OTHER_PROFILES(x_DebugMode => l_DebugMode);