DBA Data[Home] [Help]

APPS.BIL_BI_TREND_MGMT_RPTS_PKG dependencies on BIS_PMV_PAGE_PARAMETER_TBL

Line 29: PROCEDURE BIL_BI_FST_WON_QTA_TREND(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL

25: * 25 Feb 2004 krsundar fii_time_structures uptake
26: * 08 Mar 2004 krsundar Forecast related changes.
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);

Line 1096: PROCEDURE BIL_BI_FRCST_PIPE_TREND(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL

1092: * 09 Jun 04 ctoba Fix for bug 3681057
1093: * 14 Jun 04 ppatil Fix for Bug 3690434
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);

Line 2125: PROCEDURE BIL_BI_FRCST_PIPE_WON_TREND(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL

2121: * 08 Mar 2004 krsundar Forecast related changes, pipeline : grp_total_flag = 1
2122: * 28 May 2004 ctoba Performance fixes
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);

Line 2733: PROCEDURE BIL_BI_PIPELINE_MOMENTUM_TREND( p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL

2729: * Date Author Description
2730: * ---- ------ -----------
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

Line 3275: PROCEDURE BIL_BI_WIN_LOSS_CONV_TREND( p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL

3271: * ---- ------ -----------
3272: * 01/02/04 ESAPOZHN Intial Version
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:

Line 3811: PROCEDURE BIL_BI_FRCST_WON_TREND(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL

3807: * ---- ------ -----------
3808: * 01/02/04 ESAPOZHN Intial Version
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);