DBA Data[Home] [Help]

APPS.BIM_I_LEAD_MGMT_PVT dependencies on BIS_PMV_PAGE_PARAMETER_TBL

Line 5: PROCEDURE GET_KPI_SQL(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,

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,

Line 9: PROCEDURE GET_LEAD_AGE_KPI_SQL(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,

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,

Line 13: PROCEDURE GET_LEAD_ACT_SQL(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,

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,

Line 17: PROCEDURE GET_LEAD_AGING_QU_SQL(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,

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,

Line 21: PROCEDURE GET_LEAD_AGING_SG_SQL(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,

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,

Line 25: PROCEDURE GET_LEAD_OPP_CHART_SQL(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,

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,

Line 28: PROCEDURE GET_LEAD_QUALITY_SQL(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_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,

Line 31: PROCEDURE GET_LEAD_CONV_SQL(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,

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,

Line 34: PROCEDURE GET_LEAD_CONV_P_SQL(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,

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,

Line 37: PROCEDURE GET_LEAD_DETAIL_SQL (p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,

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,

Line 40: PROCEDURE GET_LEAD_CAMP_SQL(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,

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:

Line 52: FUNCTION GLbl( p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,colno in number ) 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;