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,
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);
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:
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);
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);
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);
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);
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;