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

Line 126: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

122: END IF;
123:
124: -- prepare output for bind variables
125: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
126: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
127:
128: -- set the basic bind variables for the status SQL
129: poa_dbi_util_pkg.get_custom_status_binds (x_custom_output);
130:

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

129: poa_dbi_util_pkg.get_custom_status_binds (x_custom_output);
130:
131: -- Passing AGGREGATION_LEVEL_FLAG to PMV
132: l_custom_rec.attribute_name := ':AGGREGATION_FLAG';
133: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
134: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
135: l_custom_rec.attribute_value := l_aggregation_flag;
136: x_custom_output.extend;
137: x_custom_output(x_custom_output.count) := l_custom_rec;

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

130:
131: -- Passing AGGREGATION_LEVEL_FLAG to PMV
132: l_custom_rec.attribute_name := ':AGGREGATION_FLAG';
133: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
134: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
135: l_custom_rec.attribute_value := l_aggregation_flag;
136: x_custom_output.extend;
137: x_custom_output(x_custom_output.count) := l_custom_rec;
138:

Line 438: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

434: END IF;
435:
436: -- prepare output for bind variables
437: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
438: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
439:
440: -- set the basic bind variables for the trend SQL
441: poa_dbi_util_pkg.get_custom_trend_binds (p_xtd => l_xtd,
442: p_comparison_type => l_comparison_type,

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

443: x_custom_output => x_custom_output);
444:
445: -- Passing AGGREGATION_LEVEL_FLAG to PMV
446: l_custom_rec.attribute_name := ':AGGREGATION_FLAG';
447: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
448: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
449: l_custom_rec.attribute_value := l_aggregation_flag;
450: x_custom_output.extend;
451: x_custom_output(x_custom_output.count) := l_custom_rec;

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

444:
445: -- Passing AGGREGATION_LEVEL_FLAG to PMV
446: l_custom_rec.attribute_name := ':AGGREGATION_FLAG';
447: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
448: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
449: l_custom_rec.attribute_value := l_aggregation_flag;
450: x_custom_output.extend;
451: x_custom_output(x_custom_output.count) := l_custom_rec;
452:

Line 754: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

750: END IF;
751:
752: -- prepare output for bind variables
753: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
754: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
755:
756: -- set the basic bind variables for the status SQL
757: poa_dbi_util_pkg.get_custom_status_binds (x_custom_output);
758:

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

757: poa_dbi_util_pkg.get_custom_status_binds (x_custom_output);
758:
759: -- Passing AGGREGATION_LEVEL_FLAG to PMV
760: l_custom_rec.attribute_name := ':AGGREGATION_FLAG';
761: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
762: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
763: l_custom_rec.attribute_value := l_aggregation_flag;
764: x_custom_output.extend;
765: x_custom_output(x_custom_output.count) := l_custom_rec;

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

758:
759: -- Passing AGGREGATION_LEVEL_FLAG to PMV
760: l_custom_rec.attribute_name := ':AGGREGATION_FLAG';
761: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
762: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
763: l_custom_rec.attribute_value := l_aggregation_flag;
764: x_custom_output.extend;
765: x_custom_output(x_custom_output.count) := l_custom_rec;
766:

Line 1005: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

1001: END IF;
1002:
1003: -- prepare output for bind variables
1004: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
1005: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
1006:
1007: -- set the basic bind variables for the trend SQL
1008: poa_dbi_util_pkg.get_custom_trend_binds (p_xtd => l_xtd,
1009: p_comparison_type => l_comparison_type,

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

1009: p_comparison_type => l_comparison_type,
1010: x_custom_output => x_custom_output);
1011: -- Passing AGGREGATION_LEVEL_FLAG to PMV
1012: l_custom_rec.attribute_name :=':AGGREGATION_FLAG';
1013: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1014: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
1015: l_custom_rec.attribute_value := l_aggregation_flag;
1016: x_custom_output.extend;
1017: x_custom_output(x_custom_output.count) := l_custom_rec;

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

1010: x_custom_output => x_custom_output);
1011: -- Passing AGGREGATION_LEVEL_FLAG to PMV
1012: l_custom_rec.attribute_name :=':AGGREGATION_FLAG';
1013: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1014: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
1015: l_custom_rec.attribute_value := l_aggregation_flag;
1016: x_custom_output.extend;
1017: x_custom_output(x_custom_output.count) := l_custom_rec;
1018:

Line 1156: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

1152: END IF;
1153:
1154: -- prepare output for bind variables
1155: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
1156: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
1157:
1158: -- set the basic bind variables for the status SQL
1159: poa_dbi_util_pkg.get_custom_status_binds (x_custom_output);
1160:

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

1159: poa_dbi_util_pkg.get_custom_status_binds (x_custom_output);
1160:
1161: -- Passing AGGREGATION_LEVEL_FLAG to PMV
1162: l_custom_rec.attribute_name := ':AGGREGATION_FLAG';
1163: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1164: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
1165: l_custom_rec.attribute_value := l_aggregation_flag;
1166: x_custom_output.extend;
1167: x_custom_output(x_custom_output.count) := l_custom_rec;

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

1160:
1161: -- Passing AGGREGATION_LEVEL_FLAG to PMV
1162: l_custom_rec.attribute_name := ':AGGREGATION_FLAG';
1163: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1164: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
1165: l_custom_rec.attribute_value := l_aggregation_flag;
1166: x_custom_output.extend;
1167: x_custom_output(x_custom_output.count) := l_custom_rec;
1168: x_custom_sql := l_query;