eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BIM_DBI_MKTG_MGMT_PVT dependencies on BIS_QUERY_ATTRIBUTES_TBL

Line 7: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);

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 ;

Line 10: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_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);

Line 14: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);

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

Line 18: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);

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,

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

Line 26: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_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,

Line 29: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_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,

Line 32: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_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,

Line 35: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_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,

Line 38: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_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,

Line 41: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_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:

Line 44: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_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);

Line 48: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);

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

Line 52: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);

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

Line 56: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);

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,

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

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

Line 69: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_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 (

Line 72: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_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

Line 76: x_custom_output OUT NOCOPY bis_query_attributes_tbl

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,

Line 82: x_custom_output OUT NOCOPY bis_query_attributes_tbl

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,

Line 88: x_custom_output OUT NOCOPY bis_query_attributes_tbl

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,

Line 94: x_custom_output OUT NOCOPY bis_query_attributes_tbl

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,

Line 99: 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);

Line 103: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);

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 ;