PACKAGE: APPS.BIM_SGMT_INTL_UI_PVT

Source

1 PACKAGE BIM_SGMT_INTL_UI_PVT AS
2 /* $Header: bimsiuis.pls 120.2 2005/09/23 04:44:14 sbassi noship $ */
3 
4 PROCEDURE GET_SGMT_VALUE_SQL(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
5                           x_custom_sql  OUT NOCOPY VARCHAR2,
6                           x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
7 
8 
9 PROCEDURE GET_SGMT_REVENUE_SQL(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
10                           x_custom_sql  OUT NOCOPY VARCHAR2,
11                           x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
12 
13 PROCEDURE GET_SGMT_SIZE_SQL(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
14                                x_custom_sql  OUT NOCOPY VARCHAR2,
15                                x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
16 PROCEDURE GET_SGMT_AVG_TXN_SQL(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
17                                x_custom_sql  OUT NOCOPY VARCHAR2,
18                                x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
19 
20 PROCEDURE GET_CAMP_EFF_SQL	(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
21                                x_custom_sql  OUT NOCOPY VARCHAR2,
22                                x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
23 
24 PROCEDURE GET_CAMP_ACT_SQL	(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
25                                x_custom_sql  OUT NOCOPY VARCHAR2,
26                                x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
27 
28 PROCEDURE GET_CAMP_TREND_SQL (p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
29                                x_custom_sql  OUT NOCOPY VARCHAR2,
30                                x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
31 
32 PROCEDURE GET_ACTIVE_CUST_SQL (p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
33                                x_custom_sql  OUT NOCOPY VARCHAR2,
34                                x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
35 
36 FUNCTION GLb ( p_page_parameter_tbl    IN BIS_PMV_PAGE_PARAMETER_TBL,
37 				num  in number
38 			 )  RETURN VARCHAR2;
39 
40 
41 END BIM_SGMT_INTL_UI_PVT;