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.IBE_BI_ORD_GRAPH_PVT dependencies on IBE_BI_ORD_GRAPH_PVT

Line 1: PACKAGE BODY IBE_BI_ORD_GRAPH_PVT AS

1: PACKAGE BODY IBE_BI_ORD_GRAPH_PVT AS
2: /* $Header: IBEVBIORDGRAB.pls 120.4 2005/10/17 20:52:36 narao ship $ */
3: PROCEDURE GET_ORDER_GRAPH_SQL(
4: p_pmv_parameters IN BIS_PMV_PAGE_PARAMETER_tbl,
5: x_custom_sql OUT NOCOPY VARCHAR2,

Line 45: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'ibe.plsql.dbi.ibe_bi_ord_graph_pvt.get_order_graph_sql.begin','BEGIN');

41: /**************************************************************************/
42: BEGIN
43:
44: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
45: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'ibe.plsql.dbi.ibe_bi_ord_graph_pvt.get_order_graph_sql.begin','BEGIN');
46: END IF;
47: -- initilization of variables
48:
49: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;

Line 169: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'ibe.plsql.dbi.ibe_bi_ord_graph_pvt.get_order_graph_sql.parameters',dbg_msg);

165: l_prev_start||','||'MID_START_DATE:'||l_mid_start||','||'CURR_YEAR:'||
166: l_cur_year||','||'PREV_YEAR:'||l_prev_year||','||'TIME_SPAN:'||l_timespan;
167:
168: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
169: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'ibe.plsql.dbi.ibe_bi_ord_graph_pvt.get_order_graph_sql.parameters',dbg_msg);
170: END IF;
171:
172: IF(l_comparison_type = 'SEQUENTIAL') THEN
173:

Line 403: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'ibe.plsql.dbi.ibe_bi_ord_graph_pvt.get_order_graph_sql.query',l_custom_sql);

399:
400: x_custom_sql := l_custom_sql;
401:
402: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
403: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'ibe.plsql.dbi.ibe_bi_ord_graph_pvt.get_order_graph_sql.query',l_custom_sql);
404: END IF;
405:
406: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
407: x_custom_output.EXTEND(13);

Line 503: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'ibe.plsql.dbi.ibe_bi_ord_graph_pvt.get_order_graph_sql.end','END');

499:
500: x_custom_output(13) := l_custom_rec;
501:
502: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
503: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'ibe.plsql.dbi.ibe_bi_ord_graph_pvt.get_order_graph_sql.end','END');
504: END IF;
505:
506: END GET_ORDER_GRAPH_SQL;
507:

Line 551: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'ibe.plsql.dbi.ibe_bi_ord_graph_pvt.get_avg_ord_graph_sql.begin','BEGIN');

547: /**************************************************************************/
548: BEGIN
549:
550: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
551: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'ibe.plsql.dbi.ibe_bi_ord_graph_pvt.get_avg_ord_graph_sql.begin','BEGIN');
552: END IF;
553:
554: -- initilization of variables
555:

Line 679: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'ibe.plsql.dbi.ibe_bi_ord_graph_pvt.get_avg_ord_graph_sql.parameters',dbg_msg);

675: l_prev_start||','||'MID_START_DATE:'||l_mid_start||','||'CURR_YEAR:'||
676: l_cur_year||','||'PREV_YEAR:'||l_prev_year||','||'TIME_SPAN:'||l_timespan;
677:
678: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
679: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'ibe.plsql.dbi.ibe_bi_ord_graph_pvt.get_avg_ord_graph_sql.parameters',dbg_msg);
680: END IF;
681:
682: IF(l_comparison_type = 'SEQUENTIAL') THEN
683:

Line 962: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'ibe.plsql.dbi.ibe_bi_ord_graph_pvt.get_avg_ord_graph_sql.query',l_custom_sql);

958:
959: x_custom_sql := l_custom_sql;
960:
961: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
962: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'ibe.plsql.dbi.ibe_bi_ord_graph_pvt.get_avg_ord_graph_sql.query',l_custom_sql);
963: END IF;
964:
965: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
966: x_custom_output.EXTEND(13);

Line 1061: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'ibe.plsql.dbi.ibe_bi_ord_graph_pvt.get_avg_ord_graph_sql.end','END');

1057:
1058: x_custom_output(13) := l_custom_rec;
1059:
1060: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1061: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'ibe.plsql.dbi.ibe_bi_ord_graph_pvt.get_avg_ord_graph_sql.end','END');
1062: END IF;
1063:
1064: END GET_AVG_ORD_GRAPH_SQL;
1065:

Line 1112: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'ibe.plsql.dbi.ibe_bi_ord_graph_pvt.get_avg_disc_graph_sql.begin','BEGIN');

1108:
1109: BEGIN
1110:
1111: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1112: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'ibe.plsql.dbi.ibe_bi_ord_graph_pvt.get_avg_disc_graph_sql.begin','BEGIN');
1113: END IF;
1114:
1115: -- initilization of variables
1116:

Line 1238: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'ibe.plsql.dbi.ibe_bi_ord_graph_pvt.get_avg_disc_graph_sql.parameters',dbg_msg);

1234: ','||'CURR_YEAR:'||l_cur_year||','||'PREV_YEAR:'||l_prev_year||','||
1235: 'TIME_SPAN:'||l_timespan;
1236:
1237: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1238: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'ibe.plsql.dbi.ibe_bi_ord_graph_pvt.get_avg_disc_graph_sql.parameters',dbg_msg);
1239: END IF;
1240:
1241: IF(l_comparison_type = 'SEQUENTIAL') THEN
1242:

Line 1519: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'ibe.plsql.dbi.ibe_bi_ord_graph_pvt.get_avg_disc_graph_sql',l_custom_sql);

1515:
1516:
1517:
1518: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1519: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'ibe.plsql.dbi.ibe_bi_ord_graph_pvt.get_avg_disc_graph_sql',l_custom_sql);
1520: END IF;
1521:
1522: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
1523: x_custom_output.EXTEND(13);

Line 1620: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'ibe.plsql.dbi.ibe_bi_ord_graph_pvt.get_avg_disc_graph_sql.end','END');

1616: x_custom_output(13) := l_custom_rec;
1617:
1618:
1619: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1620: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'ibe.plsql.dbi.ibe_bi_ord_graph_pvt.get_avg_disc_graph_sql.end','END');
1621: END IF;
1622:
1623:
1624: END GET_AVG_DISC_GRAPH_SQL;

Line 1626: END IBE_BI_ORD_GRAPH_PVT;

1622:
1623:
1624: END GET_AVG_DISC_GRAPH_SQL;
1625:
1626: END IBE_BI_ORD_GRAPH_PVT;