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

Line 34: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

30:
31: BEGIN
32:
33: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
34: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
35:
36: OKI_DBI_UTIL_PVT.get_parameter_values(p_page_parameter_tbl, l_view_by, l_period_type, l_org, l_comparison_type, l_xtd,l_as_of_date, l_cur_suffix,l_pattern,l_period_type_id,l_period_code);
37:
38: l_nw_amt := 's_nw_amt_'|| l_cur_suffix;

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

206: x_custom_sql := '/* OKI_DBI_BAL_KPI */' || l_SQLText;
207:
208: l_custom_rec.attribute_name := '&SEC_ID';
209: l_custom_rec.attribute_value := oki_dbi_util_pvt.get_sec_profile;
210: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
211: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
212: x_custom_output.EXTEND;
213: x_custom_output(x_custom_output.COUNT) := l_custom_rec;
214:

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

207:
208: l_custom_rec.attribute_name := '&SEC_ID';
209: l_custom_rec.attribute_value := oki_dbi_util_pvt.get_sec_profile;
210: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
211: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
212: x_custom_output.EXTEND;
213: x_custom_output(x_custom_output.COUNT) := l_custom_rec;
214:
215:

Line 249: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

245:
246: BEGIN
247:
248: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
249: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
250:
251: OKI_DBI_UTIL_PVT.get_parameter_values(p_page_parameter_tbl, l_view_by, l_period_type, l_org, l_comparison_type, l_xtd,l_as_of_date, l_cur_suffix,l_pattern,l_period_type_id,l_period_code);
252:
253: l_nw_amt := 's_nw_amt_'|| l_cur_suffix;

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

408: x_custom_sql := '/* OKI_DBI_OTHERS_KPI */' || l_sqltext;
409:
410: l_custom_rec.attribute_name := '&SEC_ID';
411: l_custom_rec.attribute_value := oki_dbi_util_pvt.get_sec_profile;
412: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
413: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
414: x_custom_output.EXTEND;
415: x_custom_output(x_custom_output.COUNT) := l_custom_rec;
416:

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

409:
410: l_custom_rec.attribute_name := '&SEC_ID';
411: l_custom_rec.attribute_value := oki_dbi_util_pvt.get_sec_profile;
412: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
413: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
414: x_custom_output.EXTEND;
415: x_custom_output(x_custom_output.COUNT) := l_custom_rec;
416:
417:

Line 452: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

448: BEGIN
449:
450:
451: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
452: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
453:
454: OKI_DBI_UTIL_PVT.get_parameter_values(p_page_parameter_tbl, l_view_by, l_period_type, l_org, l_comparison_type, l_xtd,l_as_of_date, l_cur_suffix,l_pattern,l_period_type_id,l_period_code);
455:
456: l_x_amt := 'x_amt_'|| l_cur_suffix;

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

583: x_custom_sql := '/* OKI_DBI_RATES_KPI */' || l_sqltext;
584:
585: l_custom_rec.attribute_name := '&SEC_ID';
586: l_custom_rec.attribute_value := oki_dbi_util_pvt.get_sec_profile;
587: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
588: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
589: x_custom_output.EXTEND;
590: x_custom_output(x_custom_output.COUNT) := l_custom_rec;
591:

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

584:
585: l_custom_rec.attribute_name := '&SEC_ID';
586: l_custom_rec.attribute_value := oki_dbi_util_pvt.get_sec_profile;
587: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
588: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
589: x_custom_output.EXTEND;
590: x_custom_output(x_custom_output.COUNT) := l_custom_rec;
591:
592: /* DEBUG

Line 633: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

629:
630: BEGIN
631:
632: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
633: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
634:
635: OKI_DBI_UTIL_PVT.get_parameter_values(p_page_parameter_tbl, l_view_by, l_period, l_org, l_comparison_type, l_xtd,l_as_of_date, l_cur_suffix,l_pattern,l_period_type_id,l_period_code);
636:
637: /* DEBUG

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

786: ) curr_bal ';
787:
788: x_custom_sql := '/* OKI_DBI_K_BALANCE_G */' || l_SQLText;
789:
790: l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;
791: l_custom_rec.attribute_value := 'TIME+'||l_period;
792: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.VIEW_BY_TYPE;
793: x_custom_output.EXTEND;
794: x_custom_output(x_custom_output.COUNT) := l_custom_rec;

Line 792: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.VIEW_BY_TYPE;

788: x_custom_sql := '/* OKI_DBI_K_BALANCE_G */' || l_SQLText;
789:
790: l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;
791: l_custom_rec.attribute_value := 'TIME+'||l_period;
792: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.VIEW_BY_TYPE;
793: x_custom_output.EXTEND;
794: x_custom_output(x_custom_output.COUNT) := l_custom_rec;
795:
796:

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

795:
796:
797: l_custom_rec.attribute_name := '&SEC_ID';
798: l_custom_rec.attribute_value := oki_dbi_util_pvt.get_sec_profile;
799: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
800: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
801: x_custom_output.EXTEND;
802: x_custom_output(x_custom_output.COUNT) := l_custom_rec;
803:

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

796:
797: l_custom_rec.attribute_name := '&SEC_ID';
798: l_custom_rec.attribute_value := oki_dbi_util_pvt.get_sec_profile;
799: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
800: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
801: x_custom_output.EXTEND;
802: x_custom_output(x_custom_output.COUNT) := l_custom_rec;
803:
804: --return l_SQLText ;