3:
4:
5: PROCEDURE GET_KPI_SQL(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
6: x_custom_sql OUT NOCOPY VARCHAR2,
7: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
8:
9: PROCEDURE GET_LEAD_AGE_KPI_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);
7: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
8:
9: PROCEDURE GET_LEAD_AGE_KPI_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_LEAD_ACT_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_LEAD_ACT_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:
17: PROCEDURE GET_LEAD_AGING_QU_SQL(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
18: x_custom_sql OUT NOCOPY VARCHAR2,
19: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
15: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
16:
17: PROCEDURE GET_LEAD_AGING_QU_SQL(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
18: x_custom_sql OUT NOCOPY VARCHAR2,
19: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
20:
21: PROCEDURE GET_LEAD_AGING_SG_SQL(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
22: x_custom_sql OUT NOCOPY VARCHAR2,
23: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
19: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
20:
21: PROCEDURE GET_LEAD_AGING_SG_SQL(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
22: x_custom_sql OUT NOCOPY VARCHAR2,
23: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
24:
25: PROCEDURE GET_LEAD_OPP_CHART_SQL(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
26: x_custom_sql OUT NOCOPY VARCHAR2,
27: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
23: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
24:
25: PROCEDURE GET_LEAD_OPP_CHART_SQL(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
26: x_custom_sql OUT NOCOPY VARCHAR2,
27: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
28: PROCEDURE GET_LEAD_QUALITY_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: PROCEDURE GET_LEAD_CONV_SQL(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
26: x_custom_sql OUT NOCOPY VARCHAR2,
27: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
28: PROCEDURE GET_LEAD_QUALITY_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: PROCEDURE GET_LEAD_CONV_SQL(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
32: x_custom_sql OUT NOCOPY VARCHAR2,
33: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
34: PROCEDURE GET_LEAD_CONV_P_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: PROCEDURE GET_LEAD_CONV_SQL(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
32: x_custom_sql OUT NOCOPY VARCHAR2,
33: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
34: PROCEDURE GET_LEAD_CONV_P_SQL(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
35: x_custom_sql OUT NOCOPY VARCHAR2,
36: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
37: PROCEDURE GET_LEAD_DETAIL_SQL (p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
32: x_custom_sql OUT NOCOPY VARCHAR2,
33: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
34: PROCEDURE GET_LEAD_CONV_P_SQL(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
35: x_custom_sql OUT NOCOPY VARCHAR2,
36: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
37: PROCEDURE GET_LEAD_DETAIL_SQL (p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
38: x_custom_sql OUT NOCOPY VARCHAR2,
39: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
40: PROCEDURE GET_LEAD_CAMP_SQL(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
35: x_custom_sql OUT NOCOPY VARCHAR2,
36: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
37: PROCEDURE GET_LEAD_DETAIL_SQL (p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
38: x_custom_sql OUT NOCOPY VARCHAR2,
39: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
40: PROCEDURE GET_LEAD_CAMP_SQL(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
41: x_custom_sql OUT NOCOPY VARCHAR2,
42: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
43:
38: x_custom_sql OUT NOCOPY VARCHAR2,
39: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
40: PROCEDURE GET_LEAD_CAMP_SQL(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
41: x_custom_sql OUT NOCOPY VARCHAR2,
42: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
43:
44:
45: FUNCTION GET_SALES_GROUP_ID RETURN VARCHAR2;
46: FUNCTION get_params RETURN varchar2;