[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);
69: l_bis_sysdate DATE;
70: l_prev_date DATE;
71: l_curr_eff_end_date DATE;
72: l_prev_eff_end_date DATE;
73: l_custom_rec BIS_QUERY_ATTRIBUTES;
74: l_proc VARCHAR2(100);
75: l_parameter_valid BOOLEAN;
76: l_region_id VARCHAR2(100);
77: l_parent_sls_grp_id NUMBER;
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);
1137: l_prev_date DATE;
1138: l_snap_date DATE;
1139: l_curr_eff_end_date DATE;
1140: l_prev_eff_end_date DATE;
1141: l_custom_rec BIS_QUERY_ATTRIBUTES;
1142: l_parameter_valid BOOLEAN;
1143: -- l_pipeline_req BOOLEAN;
1144: l_region_id VARCHAR2(100);
1145: l_proc VARCHAR2(100);
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);
2144: l_bitand_id VARCHAR2(10);
2145: l_calendar_id VARCHAR2(10);
2146: l_bis_sysdate Date;
2147: l_fii_struct VARCHAR2(100);
2148: l_custom_rec BIS_QUERY_ATTRIBUTES;
2149: l_sg_id_num NUMBER;
2150: l_custom_sql VARCHAR2(10000);
2151: l_prior_str VARCHAR2(5000);
2152: l_bind_ctr NUMBER;
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
2773: l_curr_eff_end_date DATE;
2774: l_prev_eff_end_date DATE;
2775:
2776: --procedure specific vars
2777: l_custom_rec BIS_QUERY_ATTRIBUTES;
2778: l_sg_id_num NUMBER;
2779: l_custom_sql VARCHAR2(12000);
2780: l_prior_str VARCHAR2(5000);
2781: l_inner_select VARCHAR2(2000);
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);
3310: l_curr_eff_end_date DATE;
3311: l_prev_eff_end_date DATE;
3312:
3313: --procedure specific vars
3314: l_custom_rec BIS_QUERY_ATTRIBUTES;
3315: l_sg_id_num NUMBER;
3316: l_custom_sql VARCHAR2(10000);
3317: l_prior_str VARCHAR2(5000);
3318: l_inner_select VARCHAR2(2000);
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);
3835: l_calendar_id VARCHAR2(10);
3836: l_bis_sysdate DATE;
3837: l_fii_struct VARCHAR2(100);
3838: --procedure specific vars
3839: l_custom_rec BIS_QUERY_ATTRIBUTES;
3840: l_sg_id_num NUMBER;
3841: l_custom_sql VARCHAR2(32000);
3842: l_prior_str VARCHAR2(5000);
3843: g_SQL_Error_Msg VARCHAR2(500);
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);