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.POA_DBI_PQC_PKG dependencies on BIS_PMV_PARAMETERS_PUB

Line 442: l_custom_rec := bis_pmv_parameters_pub.initialize_query_type;

438: l_mv_tbl poa_dbi_util_pkg.poa_dbi_mv_tbl;
439: begin
440: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl();
441: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl();
442: l_custom_rec := bis_pmv_parameters_pub.initialize_query_type;
443:
444: l_sec_context := poa_dbi_sutil_pkg.get_sec_context(p_param);
445: if (l_sec_context = 'OU' or l_sec_context = 'OU/COM')then
446: poa_dbi_sutil_pkg.process_parameters(

Line 619: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

615: x_custom_sql := l_query;
616:
617: l_custom_rec.attribute_name := '&PREV_PREV_DATE';
618: l_custom_rec.attribute_value := TO_CHAR(l_prev_prev_as_of_date, 'DD/MM/YYYY');
619: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
620: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
621: x_custom_output.EXTEND;
622: x_custom_output(x_custom_output.COUNT) := l_custom_rec;
623: end kpi_sql;

Line 620: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;

616:
617: l_custom_rec.attribute_name := '&PREV_PREV_DATE';
618: l_custom_rec.attribute_value := TO_CHAR(l_prev_prev_as_of_date, 'DD/MM/YYYY');
619: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
620: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
621: x_custom_output.EXTEND;
622: x_custom_output(x_custom_output.COUNT) := l_custom_rec;
623: end kpi_sql;
624:

Line 1453: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

1449: order by days';
1450: end if; /* l_xtd='YTD' */
1451: x_custom_sql := l_query;
1452:
1453: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
1454:
1455: l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;
1456: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.View_By_Type;
1457: if(l_xtd = 'YTD') then

Line 1455: l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;

1451: x_custom_sql := l_query;
1452:
1453: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
1454:
1455: l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;
1456: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.View_By_Type;
1457: if(l_xtd = 'YTD') then
1458: l_custom_rec.attribute_value := 'TIME+FII_TIME_ENT_PERIOD';
1459: elsif(l_xtd = 'QTD') then

Line 1456: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.View_By_Type;

1452:
1453: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
1454:
1455: l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;
1456: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.View_By_Type;
1457: if(l_xtd = 'YTD') then
1458: l_custom_rec.attribute_value := 'TIME+FII_TIME_ENT_PERIOD';
1459: elsif(l_xtd = 'QTD') then
1460: l_custom_rec.attribute_value := 'TIME+FII_TIME_DAY';

Line 1471: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

1467: x_custom_output(x_custom_output.COUNT) := l_custom_rec;
1468:
1469: l_custom_rec.attribute_name := '&FND_USER_ID';
1470: l_custom_rec.attribute_value := poa_dbi_util_pkg.get_fnd_user_profile;
1471: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1472: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
1473: x_custom_output.EXTEND;
1474: x_custom_output(x_custom_output.COUNT) := l_custom_rec;
1475:

Line 1472: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;

1468:
1469: l_custom_rec.attribute_name := '&FND_USER_ID';
1470: l_custom_rec.attribute_value := poa_dbi_util_pkg.get_fnd_user_profile;
1471: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1472: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
1473: x_custom_output.EXTEND;
1474: x_custom_output(x_custom_output.COUNT) := l_custom_rec;
1475:
1476: l_custom_rec.attribute_name := ':POA_CURR_START';

Line 1478: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;

1474: x_custom_output(x_custom_output.COUNT) := l_custom_rec;
1475:
1476: l_custom_rec.attribute_name := ':POA_CURR_START';
1477: l_custom_rec.attribute_value := to_char(l_curr_start,'DD-MM-YYYY');
1478: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
1479: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.date_bind;
1480: x_custom_output.extend;
1481: x_custom_output(x_custom_output.COUNT) := l_custom_rec;
1482:

Line 1479: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.date_bind;

1475:
1476: l_custom_rec.attribute_name := ':POA_CURR_START';
1477: l_custom_rec.attribute_value := to_char(l_curr_start,'DD-MM-YYYY');
1478: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
1479: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.date_bind;
1480: x_custom_output.extend;
1481: x_custom_output(x_custom_output.COUNT) := l_custom_rec;
1482:
1483: l_custom_rec.attribute_name := ':POA_CURR_END';

Line 1485: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;

1481: x_custom_output(x_custom_output.COUNT) := l_custom_rec;
1482:
1483: l_custom_rec.attribute_name := ':POA_CURR_END';
1484: l_custom_rec.attribute_value := to_char(l_curr_end,'DD-MM-YYYY');
1485: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
1486: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.date_bind;
1487: x_custom_output.extend;
1488: x_custom_output(x_custom_output.COUNT) := l_custom_rec;
1489:

Line 1486: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.date_bind;

1482:
1483: l_custom_rec.attribute_name := ':POA_CURR_END';
1484: l_custom_rec.attribute_value := to_char(l_curr_end,'DD-MM-YYYY');
1485: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
1486: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.date_bind;
1487: x_custom_output.extend;
1488: x_custom_output(x_custom_output.COUNT) := l_custom_rec;
1489:
1490: l_custom_rec.attribute_name := ':POA_PRIOR_START';

Line 1492: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;

1488: x_custom_output(x_custom_output.COUNT) := l_custom_rec;
1489:
1490: l_custom_rec.attribute_name := ':POA_PRIOR_START';
1491: l_custom_rec.attribute_value := to_char(l_prior_start,'DD-MM-YYYY');
1492: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
1493: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.date_bind;
1494: x_custom_output.extend;
1495: x_custom_output(x_custom_output.COUNT) := l_custom_rec;
1496:

Line 1493: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.date_bind;

1489:
1490: l_custom_rec.attribute_name := ':POA_PRIOR_START';
1491: l_custom_rec.attribute_value := to_char(l_prior_start,'DD-MM-YYYY');
1492: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
1493: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.date_bind;
1494: x_custom_output.extend;
1495: x_custom_output(x_custom_output.COUNT) := l_custom_rec;
1496:
1497: l_custom_rec.attribute_name := ':POA_PRIOR_END';

Line 1499: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;

1495: x_custom_output(x_custom_output.COUNT) := l_custom_rec;
1496:
1497: l_custom_rec.attribute_name := ':POA_PRIOR_END';
1498: l_custom_rec.attribute_value := to_char(l_prior_end,'DD-MM-YYYY');
1499: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
1500: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.date_bind;
1501: x_custom_output.extend;
1502: x_custom_output(x_custom_output.COUNT) := l_custom_rec;
1503:

Line 1500: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.date_bind;

1496:
1497: l_custom_rec.attribute_name := ':POA_PRIOR_END';
1498: l_custom_rec.attribute_value := to_char(l_prior_end,'DD-MM-YYYY');
1499: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
1500: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.date_bind;
1501: x_custom_output.extend;
1502: x_custom_output(x_custom_output.COUNT) := l_custom_rec;
1503:
1504: END trend_sql;