DBA Data[Home] [Help]

APPS.BIM_DBI_MKTG_MGMT_PVT dependencies on BIS_PMV_PAGE_PARAMETER_TBL

Line 4: --FUNCTION GET_KPI_SQL(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL) return VARCHAR2 ;

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,

Line 5: PROCEDURE GET_KPI_SQL(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,

Line 8: PROCEDURE GET_CPL_KPI(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,

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,

Line 11: --FUNCTION GET_PO_RACK_SQL(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL) return 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:

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

Line 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:

Line 19: --FUNCTION GET_CPL_GRAPH_SQL(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL) return VARCHAR2 ;

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);

Line 21: PROCEDURE GET_CPL_GRAPH_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,

Line 24: PROCEDURE GET_TOP_LEADS_SQL(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,

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,

Line 27: PROCEDURE GET_TOP_OPPS_SQL(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,

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,

Line 30: PROCEDURE GET_TOP_EVEH_OPPS_SQL(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,

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,

Line 33: PROCEDURE GET_TOP_CAMP_OPPS_SQL(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,

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,

Line 36: PROCEDURE GET_TOP_EVEH_LEAD_SQL(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,

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,

Line 39: PROCEDURE GET_TOP_CAMP_LEAD_SQL(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,

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,

Line 42: PROCEDURE GET_CPL_RPL_SQL(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,

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,

Line 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,

Line 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,

Line 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 (

Line 59: 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:

Line 64: PROCEDURE GET_CAMP_START_SQL(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,

Line 67: PROCEDURE GET_EVEH_START_SQL(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,

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,

Line 70: PROCEDURE GET_CSCH_START_SQL(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,

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,

Line 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:

Line 80: p_page_parameter_tbl IN bis_pmv_page_parameter_tbl,

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:

Line 86: p_page_parameter_tbl IN bis_pmv_page_parameter_tbl,

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:

Line 92: p_page_parameter_tbl IN bis_pmv_page_parameter_tbl,

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:

Line 97: PROCEDURE GET_CAMP_DETL_SQL(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,

Line 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 ;