PACKAGE: APPS.BIM_I_LEAD_MGMT_PVT

Source

1 PACKAGE BIM_I_LEAD_MGMT_PVT AS
2 /* $Header: bimvldis.pls 120.0 2005/05/31 13:15:27 appldev noship $ */
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);
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);
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);
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,
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 
44 
45    FUNCTION GET_SALES_GROUP_ID RETURN VARCHAR2;
46    FUNCTION get_params RETURN varchar2;
47    FUNCTION get_params_new RETURN varchar2;
48    PROCEDURE TEST_KPI_SQL;
49    PROCEDURE RESET_ATTRIBUTES;
50    FUNCTION get_dummy_sql
51    RETURN varchar2;
52    FUNCTION GLbl( p_page_parameter_tbl   IN BIS_PMV_PAGE_PARAMETER_TBL,colno in number ) RETURN VARCHAR2;
53 
54 
55 
56 END;