1: PACKAGE BIM_DBI_MKTG_MGMT_PVT AS
2: /* $Header: bimvsqls.pls 120.1 2005/09/19 00:45:21 arvikuma noship $ */
3:
4: --FUNCTION GET_KPI_SQL(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL) return VARCHAR2 ;
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: PROCEDURE GET_CPL_KPI(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
1: PACKAGE BIM_DBI_MKTG_MGMT_PVT AS
2: /* $Header: bimvsqls.pls 120.1 2005/09/19 00:45:21 arvikuma noship $ */
3:
4: --FUNCTION GET_KPI_SQL(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL) return VARCHAR2 ;
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: PROCEDURE GET_CPL_KPI(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
9: x_custom_sql OUT NOCOPY VARCHAR2,
4: --FUNCTION GET_KPI_SQL(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL) return VARCHAR2 ;
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: PROCEDURE GET_CPL_KPI(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
9: x_custom_sql OUT NOCOPY VARCHAR2,
10: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
11: --FUNCTION GET_PO_RACK_SQL(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL) return VARCHAR2 ;
12: PROCEDURE GET_PO_RACK_SQL(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
7: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
8: PROCEDURE GET_CPL_KPI(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
9: x_custom_sql OUT NOCOPY VARCHAR2,
10: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
11: --FUNCTION GET_PO_RACK_SQL(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL) return VARCHAR2 ;
12: PROCEDURE GET_PO_RACK_SQL(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
13: x_custom_sql OUT NOCOPY VARCHAR2,
14: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
15:
8: PROCEDURE GET_CPL_KPI(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
9: x_custom_sql OUT NOCOPY VARCHAR2,
10: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
11: --FUNCTION GET_PO_RACK_SQL(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL) return VARCHAR2 ;
12: PROCEDURE GET_PO_RACK_SQL(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
13: x_custom_sql OUT NOCOPY VARCHAR2,
14: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
15:
16: PROCEDURE GET_CS_RACK_SQL(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
12: PROCEDURE GET_PO_RACK_SQL(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
13: x_custom_sql OUT NOCOPY VARCHAR2,
14: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
15:
16: PROCEDURE GET_CS_RACK_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: --FUNCTION GET_CPL_GRAPH_SQL(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL) return VARCHAR2 ;
20:
15:
16: PROCEDURE GET_CS_RACK_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: --FUNCTION GET_CPL_GRAPH_SQL(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL) return VARCHAR2 ;
20:
21: PROCEDURE GET_CPL_GRAPH_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);
17: x_custom_sql OUT NOCOPY VARCHAR2,
18: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
19: --FUNCTION GET_CPL_GRAPH_SQL(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL) return VARCHAR2 ;
20:
21: PROCEDURE GET_CPL_GRAPH_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: PROCEDURE GET_TOP_LEADS_SQL(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
25: x_custom_sql OUT NOCOPY VARCHAR2,
20:
21: PROCEDURE GET_CPL_GRAPH_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: PROCEDURE GET_TOP_LEADS_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: PROCEDURE GET_TOP_OPPS_SQL(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
28: x_custom_sql OUT NOCOPY VARCHAR2,
23: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
24: PROCEDURE GET_TOP_LEADS_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: PROCEDURE GET_TOP_OPPS_SQL(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
28: x_custom_sql OUT NOCOPY VARCHAR2,
29: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
30: PROCEDURE GET_TOP_EVEH_OPPS_SQL(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
31: x_custom_sql OUT NOCOPY VARCHAR2,
26: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
27: PROCEDURE GET_TOP_OPPS_SQL(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
28: x_custom_sql OUT NOCOPY VARCHAR2,
29: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
30: PROCEDURE GET_TOP_EVEH_OPPS_SQL(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
31: x_custom_sql OUT NOCOPY VARCHAR2,
32: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
33: PROCEDURE GET_TOP_CAMP_OPPS_SQL(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
34: x_custom_sql OUT NOCOPY VARCHAR2,
29: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
30: PROCEDURE GET_TOP_EVEH_OPPS_SQL(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
31: x_custom_sql OUT NOCOPY VARCHAR2,
32: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
33: PROCEDURE GET_TOP_CAMP_OPPS_SQL(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
34: x_custom_sql OUT NOCOPY VARCHAR2,
35: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
36: PROCEDURE GET_TOP_EVEH_LEAD_SQL(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
37: x_custom_sql OUT NOCOPY VARCHAR2,
32: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
33: PROCEDURE GET_TOP_CAMP_OPPS_SQL(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
34: x_custom_sql OUT NOCOPY VARCHAR2,
35: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
36: PROCEDURE GET_TOP_EVEH_LEAD_SQL(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
37: x_custom_sql OUT NOCOPY VARCHAR2,
38: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
39: PROCEDURE GET_TOP_CAMP_LEAD_SQL(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
40: x_custom_sql OUT NOCOPY VARCHAR2,
35: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
36: PROCEDURE GET_TOP_EVEH_LEAD_SQL(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
37: x_custom_sql OUT NOCOPY VARCHAR2,
38: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
39: PROCEDURE GET_TOP_CAMP_LEAD_SQL(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
40: x_custom_sql OUT NOCOPY VARCHAR2,
41: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
42: PROCEDURE GET_CPL_RPL_SQL(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
43: x_custom_sql OUT NOCOPY VARCHAR2,
38: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
39: PROCEDURE GET_TOP_CAMP_LEAD_SQL(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
40: x_custom_sql OUT NOCOPY VARCHAR2,
41: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
42: PROCEDURE GET_CPL_RPL_SQL(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
43: x_custom_sql OUT NOCOPY VARCHAR2,
44: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
45:
46: PROCEDURE GET_rpl_cpl_SQL(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
42: PROCEDURE GET_CPL_RPL_SQL(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
43: x_custom_sql OUT NOCOPY VARCHAR2,
44: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
45:
46: PROCEDURE GET_rpl_cpl_SQL(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
47: x_custom_sql OUT NOCOPY VARCHAR2,
48: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
49:
50: PROCEDURE GET_LEAD_OPTY_CONV_SQL(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
46: PROCEDURE GET_rpl_cpl_SQL(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
47: x_custom_sql OUT NOCOPY VARCHAR2,
48: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
49:
50: PROCEDURE GET_LEAD_OPTY_CONV_SQL(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
51: x_custom_sql OUT NOCOPY VARCHAR2,
52: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
53: PROCEDURE GET_MKTG_A_LEADS_SQL (
54: p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
50: PROCEDURE GET_LEAD_OPTY_CONV_SQL(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
51: x_custom_sql OUT NOCOPY VARCHAR2,
52: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
53: PROCEDURE GET_MKTG_A_LEADS_SQL (
54: p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
55: x_custom_sql OUT NOCOPY VARCHAR2,
56: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
57:
58: PROCEDURE GET_MKTG_NEW_LEADS_SQL (
55: x_custom_sql OUT NOCOPY VARCHAR2,
56: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
57:
58: PROCEDURE GET_MKTG_NEW_LEADS_SQL (
59: p_page_parameter_tbl IN bis_pmv_page_parameter_tbl,
60: x_custom_sql OUT NOCOPY VARCHAR2,
61: x_custom_output OUT NOCOPY bis_query_attributes_tbl
62: );
63:
60: x_custom_sql OUT NOCOPY VARCHAR2,
61: x_custom_output OUT NOCOPY bis_query_attributes_tbl
62: );
63:
64: PROCEDURE GET_CAMP_START_SQL(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
65: x_custom_sql OUT NOCOPY VARCHAR2,
66: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
67: PROCEDURE GET_EVEH_START_SQL(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
68: x_custom_sql OUT NOCOPY VARCHAR2,
63:
64: PROCEDURE GET_CAMP_START_SQL(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
65: x_custom_sql OUT NOCOPY VARCHAR2,
66: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
67: PROCEDURE GET_EVEH_START_SQL(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
68: x_custom_sql OUT NOCOPY VARCHAR2,
69: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
70: PROCEDURE GET_CSCH_START_SQL(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
71: x_custom_sql OUT NOCOPY VARCHAR2,
66: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
67: PROCEDURE GET_EVEH_START_SQL(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
68: x_custom_sql OUT NOCOPY VARCHAR2,
69: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
70: PROCEDURE GET_CSCH_START_SQL(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
71: x_custom_sql OUT NOCOPY VARCHAR2,
72: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
73: PROCEDURE GET_RESP_SUM_SQL (
74: p_page_parameter_tbl IN bis_pmv_page_parameter_tbl,
70: PROCEDURE GET_CSCH_START_SQL(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
71: x_custom_sql OUT NOCOPY VARCHAR2,
72: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
73: PROCEDURE GET_RESP_SUM_SQL (
74: p_page_parameter_tbl IN bis_pmv_page_parameter_tbl,
75: x_custom_sql OUT NOCOPY VARCHAR2,
76: x_custom_output OUT NOCOPY bis_query_attributes_tbl
77: );
78:
76: x_custom_output OUT NOCOPY bis_query_attributes_tbl
77: );
78:
79: PROCEDURE GET_RESP_RATE_SQL (
80: p_page_parameter_tbl IN bis_pmv_page_parameter_tbl,
81: x_custom_sql OUT NOCOPY VARCHAR2,
82: x_custom_output OUT NOCOPY bis_query_attributes_tbl
83: );
84:
82: x_custom_output OUT NOCOPY bis_query_attributes_tbl
83: );
84:
85: PROCEDURE GET_WON_OPTY_SQL (
86: p_page_parameter_tbl IN bis_pmv_page_parameter_tbl,
87: x_custom_sql OUT NOCOPY VARCHAR2,
88: x_custom_output OUT NOCOPY bis_query_attributes_tbl
89: );
90:
88: x_custom_output OUT NOCOPY bis_query_attributes_tbl
89: );
90:
91: PROCEDURE BIM_MKTG_LEAD_ACT_SQL (
92: p_page_parameter_tbl IN bis_pmv_page_parameter_tbl,
93: x_custom_sql OUT NOCOPY VARCHAR2,
94: x_custom_output OUT NOCOPY bis_query_attributes_tbl
95: );
96:
93: x_custom_sql OUT NOCOPY VARCHAR2,
94: x_custom_output OUT NOCOPY bis_query_attributes_tbl
95: );
96:
97: PROCEDURE GET_CAMP_DETL_SQL(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
98: x_custom_sql OUT NOCOPY VARCHAR2,
99: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
100:
101: PROCEDURE GET_CSCH_DETL_SQL(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
97: PROCEDURE GET_CAMP_DETL_SQL(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
98: x_custom_sql OUT NOCOPY VARCHAR2,
99: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
100:
101: PROCEDURE GET_CSCH_DETL_SQL(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
102: x_custom_sql OUT NOCOPY VARCHAR2,
103: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
104:
105: FUNCTION GET_BIM_TEST return VARCHAR2 ;