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

Line 122: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

118: p_in_join_tables => NULL);
119:
120: -- prepare output for bind variables
121: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
122: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
123:
124: -- set the basic bind variables for the status SQL
125: poa_dbi_util_pkg.get_custom_status_binds (x_custom_output);
126: poa_dbi_util_pkg.get_custom_rolling_binds(x_custom_output,l_xtd);

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

127:
128: -- Passing aggregation level flag to PMV
129: l_custom_rec.attribute_name := ':OPI_PEX_AGG_LEVEL_FLAG';
130: l_custom_rec.attribute_value := l_aggregation_level_flag;
131: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
132: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
133: x_custom_output.extend;
134:
135: x_custom_output(x_custom_output.count) := l_custom_rec;

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

128: -- Passing aggregation level flag to PMV
129: l_custom_rec.attribute_name := ':OPI_PEX_AGG_LEVEL_FLAG';
130: l_custom_rec.attribute_value := l_aggregation_level_flag;
131: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
132: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
133: x_custom_output.extend;
134:
135: x_custom_output(x_custom_output.count) := l_custom_rec;
136:

Line 425: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

421: p_in_join_tables => NULL);
422:
423: -- prepare output for bind variables
424: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
425: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
426:
427: -- set the basic bind variables for the status SQL
428: poa_dbi_util_pkg.get_custom_status_binds (x_custom_output);
429: poa_dbi_util_pkg.get_custom_rolling_binds(x_custom_output,l_xtd);

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

430:
431: -- Passing aggregation level flag to PMV
432: l_custom_rec.attribute_name := ':OPI_PER_AGG_LEVEL_FLAG';
433: l_custom_rec.attribute_value := l_aggregation_level_flag;
434: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
435: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
436: x_custom_output.extend;
437:
438: x_custom_output(x_custom_output.count) := l_custom_rec;

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

431: -- Passing aggregation level flag to PMV
432: l_custom_rec.attribute_name := ':OPI_PER_AGG_LEVEL_FLAG';
433: l_custom_rec.attribute_value := l_aggregation_level_flag;
434: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
435: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
436: x_custom_output.extend;
437:
438: x_custom_output(x_custom_output.count) := l_custom_rec;
439:

Line 609: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

605: );
606:
607: -- prepare output for bind variables
608: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
609: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
610:
611: -- set the basic bind variables for the trend SQL
612: poa_dbi_util_pkg.get_custom_trend_binds (p_xtd => l_xtd,
613: p_comparison_type => l_comparison_type,

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

615: poa_dbi_util_pkg.get_custom_rolling_binds(x_custom_output,l_xtd);
616:
617: -- Passing AGGREGATION_LEVEL_FLAG to PMV
618: l_custom_rec.attribute_name := ':OPI_PEX_AGG_LEVEL_FLAG';
619: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
620: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
621: l_custom_rec.attribute_value := l_aggregation_level_flag;
622: x_custom_output.extend;
623: x_custom_output(x_custom_output.count) := l_custom_rec;

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

616:
617: -- Passing AGGREGATION_LEVEL_FLAG to PMV
618: l_custom_rec.attribute_name := ':OPI_PEX_AGG_LEVEL_FLAG';
619: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
620: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
621: l_custom_rec.attribute_value := l_aggregation_level_flag;
622: x_custom_output.extend;
623: x_custom_output(x_custom_output.count) := l_custom_rec;
624:

Line 797: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

793: p_in_join_tables => NULL);
794:
795: -- prepare output for bind variables
796: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
797: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
798:
799: -- set the basic bind variables for the status SQL
800: poa_dbi_util_pkg.get_custom_status_binds (x_custom_output);
801: poa_dbi_util_pkg.get_custom_rolling_binds(x_custom_output,l_xtd);

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

802:
803: -- Passing aggregation level flag to PMV
804: l_custom_rec.attribute_name := ':OPI_OPP_AGG_LEVEL_FLAG';
805: l_custom_rec.attribute_value := l_aggregation_level_flag;
806: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
807: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
808: x_custom_output.extend;
809: x_custom_output(x_custom_output.count) := l_custom_rec;
810:

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

803: -- Passing aggregation level flag to PMV
804: l_custom_rec.attribute_name := ':OPI_OPP_AGG_LEVEL_FLAG';
805: l_custom_rec.attribute_value := l_aggregation_level_flag;
806: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
807: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
808: x_custom_output.extend;
809: x_custom_output(x_custom_output.count) := l_custom_rec;
810:
811: commit;

Line 1051: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

1047: p_generate_viewby => 'Y',
1048: p_in_join_tables => NULL);
1049: -- prepare output for bind variables
1050: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
1051: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
1052:
1053: -- set the basic bind variables for the status SQL
1054: poa_dbi_util_pkg.get_custom_status_binds (x_custom_output);
1055: poa_dbi_util_pkg.get_custom_rolling_binds(x_custom_output,l_xtd);

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

1056:
1057: -- Passing OPI_AGGREGATION_LEVEL_FLAGS to PMV
1058: l_custom_rec.attribute_name := ':OPI_OPER_AGG_LEVEL_FLAG';
1059: l_custom_rec.attribute_value := l_aggregation_level_flag;
1060: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1061: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
1062: x_custom_output.extend;
1063: x_custom_output(x_custom_output.count) := l_custom_rec;
1064:

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

1057: -- Passing OPI_AGGREGATION_LEVEL_FLAGS to PMV
1058: l_custom_rec.attribute_name := ':OPI_OPER_AGG_LEVEL_FLAG';
1059: l_custom_rec.attribute_value := l_aggregation_level_flag;
1060: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1061: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
1062: x_custom_output.extend;
1063: x_custom_output(x_custom_output.count) := l_custom_rec;
1064:
1065: commit;