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_BACKLOG_PKG dependencies on BIS_PMV_PARAMETERS_PUB

Line 111: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

107: END IF;
108:
109: -- prepare output for bind variables
110: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
111: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
112:
113: -- set the basic bind variables for the status SQL
114: poa_dbi_util_pkg.get_custom_status_binds (x_custom_output);
115:

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

114: poa_dbi_util_pkg.get_custom_status_binds (x_custom_output);
115:
116: -- Passing AGGREGATION_LEVEL_FLAG to PMV
117: l_custom_rec.attribute_name := ':AGGREGATION_FLAG';
118: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
119: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
120: l_custom_rec.attribute_value := l_aggregation_flag;
121: x_custom_output.extend;
122: x_custom_output(x_custom_output.count) := l_custom_rec;

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

115:
116: -- Passing AGGREGATION_LEVEL_FLAG to PMV
117: l_custom_rec.attribute_name := ':AGGREGATION_FLAG';
118: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
119: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
120: l_custom_rec.attribute_value := l_aggregation_flag;
121: x_custom_output.extend;
122: x_custom_output(x_custom_output.count) := l_custom_rec;
123:

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

123:
124: -- Passing AGGREGATION_LEVEL_FLAG to PMV
125: l_custom_rec.attribute_name := '&YTD_NESTED_PATTERN';
126: l_custom_rec.attribute_value := 1143;
127: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
128: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
129: x_custom_output.extend;
130: x_custom_output(x_custom_output.count) := l_custom_rec;
131:

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

124: -- Passing AGGREGATION_LEVEL_FLAG to PMV
125: l_custom_rec.attribute_name := '&YTD_NESTED_PATTERN';
126: l_custom_rec.attribute_value := 1143;
127: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
128: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
129: x_custom_output.extend;
130: x_custom_output(x_custom_output.count) := l_custom_rec;
131:
132: -- Passing last refresh date to PMV

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

131:
132: -- Passing last refresh date to PMV
133: l_custom_rec.attribute_name := ':LAST_REFRESH_DATE';
134: l_custom_rec.attribute_value := to_char(l_last_refresh_date,'DD/MM/YYYY');
135: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
136: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
137: x_custom_output.extend;
138: x_custom_output(x_custom_output.count) := l_custom_rec;
139:

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

132: -- Passing last refresh date to PMV
133: l_custom_rec.attribute_name := ':LAST_REFRESH_DATE';
134: l_custom_rec.attribute_value := to_char(l_last_refresh_date,'DD/MM/YYYY');
135: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
136: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
137: x_custom_output.extend;
138: x_custom_output(x_custom_output.count) := l_custom_rec;
139:
140: x_custom_sql := l_query;

Line 393: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

389: END IF;
390:
391: -- prepare output for bind variables
392: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
393: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
394:
395: -- set the basic bind variables for the status SQL
396: poa_dbi_util_pkg.get_custom_trend_binds (p_xtd => l_xtd,
397: p_comparison_type => l_comparison_type,

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

398: x_custom_output => x_custom_output);
399:
400: -- Passing AGGREGATION_LEVEL_FLAG to PMV
401: l_custom_rec.attribute_name := ':AGGREGATION_FLAG';
402: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
403: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
404: l_custom_rec.attribute_value := l_aggregation_flag;
405: x_custom_output.extend;
406: x_custom_output(x_custom_output.count) := l_custom_rec;

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

399:
400: -- Passing AGGREGATION_LEVEL_FLAG to PMV
401: l_custom_rec.attribute_name := ':AGGREGATION_FLAG';
402: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
403: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
404: l_custom_rec.attribute_value := l_aggregation_flag;
405: x_custom_output.extend;
406: x_custom_output(x_custom_output.count) := l_custom_rec;
407:

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

407:
408: -- Passing AGGREGATION_LEVEL_FLAG to PMV
409: l_custom_rec.attribute_name := '&YTD_NESTED_PATTERN';
410: l_custom_rec.attribute_value := 1143;
411: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
412: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
413: x_custom_output.extend;
414: x_custom_output(x_custom_output.count) := l_custom_rec;
415:

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

408: -- Passing AGGREGATION_LEVEL_FLAG to PMV
409: l_custom_rec.attribute_name := '&YTD_NESTED_PATTERN';
410: l_custom_rec.attribute_value := 1143;
411: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
412: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
413: x_custom_output.extend;
414: x_custom_output(x_custom_output.count) := l_custom_rec;
415:
416: x_custom_sql := l_query;

Line 737: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

733: ISC_DEPOT_RPT_UTIL_PKG.write('BIS_ISC_DEPOT_BACKLOG_DTL : ',l_err_stage,ISC_DEPOT_RPT_UTIL_PKG.C_DEBUG_LEVEL);
734: END IF;
735: -- prepare output for bind variables
736: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
737: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
738:
739: -- set the basic bind variables for the status SQL
740: poa_dbi_util_pkg.get_custom_status_binds (x_custom_output);
741:

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

740: poa_dbi_util_pkg.get_custom_status_binds (x_custom_output);
741:
742: -- Passing AGGREGATION_LEVEL_FLAG to PMV
743: l_custom_rec.attribute_name := ':AGGREGATION_FLAG';
744: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
745: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
746: l_custom_rec.attribute_value := l_aggregation_flag;
747: x_custom_output.extend;
748: x_custom_output(x_custom_output.count) := l_custom_rec;

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

741:
742: -- Passing AGGREGATION_LEVEL_FLAG to PMV
743: l_custom_rec.attribute_name := ':AGGREGATION_FLAG';
744: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
745: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
746: l_custom_rec.attribute_value := l_aggregation_flag;
747: x_custom_output.extend;
748: x_custom_output(x_custom_output.count) := l_custom_rec;
749:

Line 1121: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

1117: END IF;
1118:
1119: -- prepare output for bind variables
1120: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
1121: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
1122:
1123: -- set the basic bind variables for the status SQL
1124: poa_dbi_util_pkg.get_custom_status_binds (x_custom_output);
1125:

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

1124: poa_dbi_util_pkg.get_custom_status_binds (x_custom_output);
1125:
1126: -- Passing AGGREGATION_LEVEL_FLAG to PMV
1127: l_custom_rec.attribute_name := ':aggregation_flag_1';
1128: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1129: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
1130: l_custom_rec.attribute_value := l_agg_flag_1;
1131: x_custom_output.extend;
1132: x_custom_output(x_custom_output.count) := l_custom_rec;

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

1125:
1126: -- Passing AGGREGATION_LEVEL_FLAG to PMV
1127: l_custom_rec.attribute_name := ':aggregation_flag_1';
1128: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1129: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
1130: l_custom_rec.attribute_value := l_agg_flag_1;
1131: x_custom_output.extend;
1132: x_custom_output(x_custom_output.count) := l_custom_rec;
1133:

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

1132: x_custom_output(x_custom_output.count) := l_custom_rec;
1133:
1134: -- Passing AGGREGATION_LEVEL_FLAG to PMV
1135: l_custom_rec.attribute_name := ':aggregation_flag_2';
1136: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1137: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
1138: l_custom_rec.attribute_value := l_agg_flag_2;
1139: x_custom_output.extend;
1140: x_custom_output(x_custom_output.count) := l_custom_rec;

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

1133:
1134: -- Passing AGGREGATION_LEVEL_FLAG to PMV
1135: l_custom_rec.attribute_name := ':aggregation_flag_2';
1136: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1137: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
1138: l_custom_rec.attribute_value := l_agg_flag_2;
1139: x_custom_output.extend;
1140: x_custom_output(x_custom_output.count) := l_custom_rec;
1141: