[Home] [Help]
PACKAGE: APPS.BIM_DBI_MKTG_MGMT_PVT
Source
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,
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,
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,
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,
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,
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,
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 (
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
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,
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
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
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
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
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 ;
106 FUNCTION GET_DIM return VARCHAR2 ;
107 FUNCTION GET_DIM_PARAM return VARCHAR2 ;
108 FUNCTION GET_RESOURCE_ID return NUMBER ;
109
110
111 END BIM_DBI_MKTG_MGMT_PVT;