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.

[Home] [Help]

APPS.ISC_DEPOT_COMPLETION_PKG dependencies on BIS_PMV_PARAMETERS_PUB

Line 119: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

115: END IF;
116:
117: -- prepare output for bind variables
118: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
119: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
120:
121: -- set the basic bind variables for the status SQL
122: poa_dbi_util_pkg.get_custom_status_binds (x_custom_output);
123:

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

122: poa_dbi_util_pkg.get_custom_status_binds (x_custom_output);
123:
124: -- Passing AGGREGATION_LEVEL_FLAG to PMV
125: l_custom_rec.attribute_name := ':AGGREGATION_FLAG';
126: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
127: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
128: l_custom_rec.attribute_value := l_aggregation_flag;
129: x_custom_output.extend;
130: x_custom_output(x_custom_output.count) := l_custom_rec;

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

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

Line 421: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

417: END IF;
418:
419: -- prepare output for bind variables
420: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
421: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
422:
423: -- set the basic bind variables for the status SQL
424: poa_dbi_util_pkg.get_custom_trend_binds (p_xtd => l_xtd,
425: p_comparison_type => l_comparison_type,

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

426: x_custom_output => x_custom_output);
427:
428: -- Passing AGGREGATION_LEVEL_FLAG to PMV
429: l_custom_rec.attribute_name := ':AGGREGATION_FLAG';
430: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
431: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
432: l_custom_rec.attribute_value := l_aggregation_flag;
433: x_custom_output.extend;
434: x_custom_output(x_custom_output.count) := l_custom_rec;

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

427:
428: -- Passing AGGREGATION_LEVEL_FLAG to PMV
429: l_custom_rec.attribute_name := ':AGGREGATION_FLAG';
430: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
431: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
432: l_custom_rec.attribute_value := l_aggregation_flag;
433: x_custom_output.extend;
434: x_custom_output(x_custom_output.count) := l_custom_rec;
435:

Line 921: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

917: ' group by range_name, buckets.bucket_number order by buckets.bucket_number)';
918:
919: -- prepare output for bind variables
920: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
921: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
922:
923: -- set the basic bind variables for the status SQL
924: poa_dbi_util_pkg.get_custom_status_binds (x_custom_output);
925: -- Passing AGGREGATION_LEVEL_FLAG to PMV

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

923: -- set the basic bind variables for the status SQL
924: poa_dbi_util_pkg.get_custom_status_binds (x_custom_output);
925: -- Passing AGGREGATION_LEVEL_FLAG to PMV
926: l_custom_rec.attribute_name := ':AGGREGATION_FLAG';
927: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
928: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
929: l_custom_rec.attribute_value := l_aggregation_flag;
930: x_custom_output.extend;
931: x_custom_output(x_custom_output.count) := l_custom_rec;

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

924: poa_dbi_util_pkg.get_custom_status_binds (x_custom_output);
925: -- Passing AGGREGATION_LEVEL_FLAG to PMV
926: l_custom_rec.attribute_name := ':AGGREGATION_FLAG';
927: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
928: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
929: l_custom_rec.attribute_value := l_aggregation_flag;
930: x_custom_output.extend;
931: x_custom_output(x_custom_output.count) := l_custom_rec;
932: