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_PMV_PAGE_PARAMETER_TBL

Line 103: PROCEDURE GET_KPI_SQL(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,

99: END GET_ADMIN_STATUS;
100:
101:
102:
103: PROCEDURE GET_KPI_SQL(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
104: x_custom_sql OUT NOCOPY VARCHAR2,
105: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
106: IS
107: l_sqltext varchar2(32766);

Line 613: PROCEDURE GET_PO_RACK_SQL(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,

609: l_sql_errm := SQLERRM;
610: write_debug('MKTG KPI SQL','ERROR',l_sql_errm,l_sqltext,NULL,null);
611: END GET_KPI_SQL;
612:
613: PROCEDURE GET_PO_RACK_SQL(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
614: x_custom_sql OUT NOCOPY VARCHAR2,
615: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
616: IS
617: l_sqltext varchar2(32000);

Line 3518: PROCEDURE GET_CS_RACK_SQL(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,

3514: l_sql_errm := SQLERRM;
3515: write_debug('GET_PO_RACK_SQL','ERROR',l_sql_errm,l_sqltext);
3516: END GET_PO_RACK_SQL;
3517:
3518: PROCEDURE GET_CS_RACK_SQL(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
3519: x_custom_sql OUT NOCOPY VARCHAR2,
3520: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
3521:
3522: IS

Line 6634: PROCEDURE GET_TOP_LEADS_SQL(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,

6630: END GET_BIM_TEST;
6631:
6632:
6633:
6634: PROCEDURE GET_TOP_LEADS_SQL(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
6635: x_custom_sql OUT NOCOPY VARCHAR2,
6636: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
6637: IS
6638: l_sqltext varchar2(4000);

Line 6862: PROCEDURE GET_TOP_OPPS_SQL(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,

6858: l_sql_errm := SQLERRM;
6859: write_debug('GET_TOP_LEADS_SQL','ERROR',l_sql_errm,l_sqltext);
6860: END GET_TOP_LEADS_SQL;
6861:
6862: PROCEDURE GET_TOP_OPPS_SQL(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
6863: x_custom_sql OUT NOCOPY VARCHAR2,
6864: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
6865: IS
6866: l_sqltext varchar2(4000);

Line 7086: PROCEDURE GET_TOP_EVEH_OPPS_SQL(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,

7082: write_debug('GET_TOP_OPPS_SQL','ERROR',l_sql_errm,l_sqltext);
7083:
7084: END GET_TOP_OPPS_SQL;
7085:
7086: PROCEDURE GET_TOP_EVEH_OPPS_SQL(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
7087: x_custom_sql OUT NOCOPY VARCHAR2,
7088: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
7089: IS
7090: l_sqltext varchar2(4000);

Line 7269: PROCEDURE GET_TOP_CAMP_OPPS_SQL(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,

7265: write_debug('GET_TOP_EVEH_OPPS_SQL','ERROR',l_sql_errm,l_sqltext);
7266:
7267: END GET_TOP_EVEH_OPPS_SQL;
7268:
7269: PROCEDURE GET_TOP_CAMP_OPPS_SQL(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
7270: x_custom_sql OUT NOCOPY VARCHAR2,
7271: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
7272: IS
7273: l_sqltext varchar2(4000);

Line 7453: PROCEDURE GET_TOP_EVEH_LEAD_SQL(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,

7449: write_debug('GET_TOP_OPPS_SQL','ERROR',l_sql_errm,l_sqltext);
7450:
7451: END GET_TOP_CAMP_OPPS_SQL;
7452:
7453: PROCEDURE GET_TOP_EVEH_LEAD_SQL(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
7454: x_custom_sql OUT NOCOPY VARCHAR2,
7455: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
7456: IS
7457: l_sqltext varchar2(4000);

Line 7634: PROCEDURE GET_TOP_CAMP_LEAD_SQL(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,

7630: write_debug('GET_TOP_EVEH_LEAD_SQL','ERROR',l_sql_errm,l_sqltext);
7631:
7632: END GET_TOP_EVEH_LEAD_SQL;
7633:
7634: PROCEDURE GET_TOP_CAMP_LEAD_SQL(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
7635: x_custom_sql OUT NOCOPY VARCHAR2,
7636: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
7637: IS
7638: l_sqltext varchar2(4000);

Line 7817: PROCEDURE GET_CPL_KPI(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,

7813:
7814: END GET_TOP_CAMP_LEAD_SQL;
7815:
7816:
7817: PROCEDURE GET_CPL_KPI(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
7818: x_custom_sql OUT NOCOPY VARCHAR2,
7819: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
7820: IS
7821: l_sqltext varchar2(5000);

Line 8331: PROCEDURE GET_CPL_GRAPH_SQL(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,

8327: write_debug('MKTG KPI SQL2','ERROR',l_sql_errm,l_sqltext,NULL,null);
8328: END GET_CPL_KPI;
8329:
8330:
8331: PROCEDURE GET_CPL_GRAPH_SQL(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
8332: x_custom_sql OUT NOCOPY VARCHAR2,
8333: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
8334: IS
8335: iFlag number;

Line 8847: p_page_parameter_tbl IN bis_pmv_page_parameter_tbl,

8843:
8844: END GET_CPL_GRAPH_SQL;
8845:
8846: PROCEDURE GET_CPL_RPL_SQL (
8847: p_page_parameter_tbl IN bis_pmv_page_parameter_tbl,
8848: x_custom_sql OUT NOCOPY VARCHAR2,
8849: x_custom_output OUT NOCOPY bis_query_attributes_tbl
8850: )
8851: IS

Line 9868: p_page_parameter_tbl IN bis_pmv_page_parameter_tbl,

9864: END GET_CPL_RPL_SQL;
9865:
9866:
9867: PROCEDURE GET_RPL_CPL_SQL (
9868: p_page_parameter_tbl IN bis_pmv_page_parameter_tbl,
9869: x_custom_sql OUT NOCOPY VARCHAR2,
9870: x_custom_output OUT NOCOPY bis_query_attributes_tbl
9871: )
9872: IS

Line 10853: p_page_parameter_tbl IN bis_pmv_page_parameter_tbl,

10849: END GET_RPL_CPL_SQL;
10850:
10851:
10852: PROCEDURE GET_LEAD_OPTY_CONV_SQL (
10853: p_page_parameter_tbl IN bis_pmv_page_parameter_tbl,
10854: x_custom_sql OUT NOCOPY VARCHAR2,
10855: x_custom_output OUT NOCOPY bis_query_attributes_tbl
10856: )
10857: IS

Line 11733: p_page_parameter_tbl IN bis_pmv_page_parameter_tbl,

11729: write_debug ('GET_LEAD_OPTY_CONV_SQL', 'ERROR', l_sql_errm, l_sqltext);
11730: END get_lead_opty_conv_sql;
11731:
11732: PROCEDURE GET_MKTG_A_LEADS_SQL (
11733: p_page_parameter_tbl IN bis_pmv_page_parameter_tbl,
11734: x_custom_sql OUT NOCOPY VARCHAR2,
11735: x_custom_output OUT NOCOPY bis_query_attributes_tbl
11736: )
11737: IS

Line 12601: p_page_parameter_tbl IN bis_pmv_page_parameter_tbl,

12597: write_debug ('GET_MKTG_A_LEADS_SQL', 'ERROR', l_sql_errm, l_sqltext);
12598: END GET_MKTG_A_LEADS_SQL;
12599:
12600: PROCEDURE GET_MKTG_NEW_LEADS_SQL (
12601: p_page_parameter_tbl IN bis_pmv_page_parameter_tbl,
12602: x_custom_sql OUT NOCOPY VARCHAR2,
12603: x_custom_output OUT NOCOPY bis_query_attributes_tbl
12604: )
12605: IS

Line 13448: PROCEDURE GET_CAMP_START_SQL(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,

13444: END GET_MKTG_NEW_LEADS_SQL;
13445:
13446:
13447:
13448: PROCEDURE GET_CAMP_START_SQL(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
13449: x_custom_sql OUT NOCOPY VARCHAR2,
13450: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
13451: IS
13452: l_sqltext varchar2(15000);

Line 15349: PROCEDURE GET_EVEH_START_SQL(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,

15345:
15346: END GET_CAMP_START_SQL;
15347:
15348:
15349: PROCEDURE GET_EVEH_START_SQL(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
15350: x_custom_sql OUT NOCOPY VARCHAR2,
15351: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
15352: IS
15353: l_sqltext varchar2(15000);

Line 17242: PROCEDURE GET_CAMP_DETL_SQL(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,

17238: END GET_EVEH_START_SQL;
17239:
17240: --campaign detail
17241:
17242: PROCEDURE GET_CAMP_DETL_SQL(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
17243: x_custom_sql OUT NOCOPY VARCHAR2,
17244: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
17245: IS
17246: l_sqltext varchar2(15000);

Line 17609: PROCEDURE GET_CSCH_START_SQL(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,

17605: END GET_CAMP_DETL_SQL;
17606:
17607:
17608:
17609: PROCEDURE GET_CSCH_START_SQL(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
17610: x_custom_sql OUT NOCOPY VARCHAR2,
17611: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
17612: IS
17613: l_sqltext varchar2(15000);

Line 19886: PROCEDURE GET_CSCH_DETL_SQL(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,

19882: l_sql_errm := SQLERRM;
19883: write_debug('GET_CSCH_START_SQL','ERROR',l_sql_errm,l_sqltext);
19884: END GET_CSCH_START_SQL;
19885:
19886: PROCEDURE GET_CSCH_DETL_SQL(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
19887: x_custom_sql OUT NOCOPY VARCHAR2,
19888: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
19889: IS
19890: l_sqltext varchar2(15000);

Line 20129: PROCEDURE GET_RESP_SUM_SQL(p_page_parameter_tbl IN bis_pmv_page_parameter_tbl,

20125:
20126: END GET_CSCH_DETL_SQL;
20127:
20128:
20129: PROCEDURE GET_RESP_SUM_SQL(p_page_parameter_tbl IN bis_pmv_page_parameter_tbl,
20130: x_custom_sql OUT NOCOPY VARCHAR2,
20131: x_custom_output OUT NOCOPY bis_query_attributes_tbl) IS
20132: l_sqltext VARCHAR2(32000);
20133: iflag NUMBER;

Line 20885: p_page_parameter_tbl IN bis_pmv_page_parameter_tbl,

20881: write_debug('GET_RESP_SUM_SQL', 'ERROR', l_sql_errm, l_sqltext);
20882: END GET_RESP_SUM_SQL;
20883:
20884: PROCEDURE GET_RESP_RATE_SQL (
20885: p_page_parameter_tbl IN bis_pmv_page_parameter_tbl,
20886: x_custom_sql OUT NOCOPY VARCHAR2,
20887: x_custom_output OUT NOCOPY bis_query_attributes_tbl
20888: )
20889: IS

Line 21780: p_page_parameter_tbl IN bis_pmv_page_parameter_tbl,

21776: END GET_RESP_RATE_SQL;
21777:
21778:
21779: PROCEDURE GET_WON_OPTY_SQL (
21780: p_page_parameter_tbl IN bis_pmv_page_parameter_tbl,
21781: x_custom_sql OUT NOCOPY VARCHAR2,
21782: x_custom_output OUT NOCOPY bis_query_attributes_tbl
21783: )
21784: IS

Line 22495: p_page_parameter_tbl IN bis_pmv_page_parameter_tbl,

22491:
22492:
22493:
22494: PROCEDURE BIM_MKTG_LEAD_ACT_SQL (
22495: p_page_parameter_tbl IN bis_pmv_page_parameter_tbl,
22496: x_custom_sql OUT NOCOPY VARCHAR2,
22497: x_custom_output OUT NOCOPY bis_query_attributes_tbl
22498: )
22499: IS