DBA Data[Home] [Help]

APPS.ISC_DBI_SHIP_LATE_PKG dependencies on BIS_PMV_PARAMETERS_PUB

Line 133: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

129: END CASE;
130:
131: l_lang := USERENV('LANG');
132:
133: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
134: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
135:
136: l_formula_sql :='
137: a.late_line_cnt ISC_MEASURE_1,

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

269: x_custom_sql := l_stmt;
270:
271: l_custom_rec.attribute_name := ':ISC_AGG_LEVEL';
272: l_custom_rec.attribute_value := to_char(l_agg_level);
273: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
274: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
275: x_custom_output.EXTEND;
276: x_custom_output(1) := l_custom_rec;
277:

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

270:
271: l_custom_rec.attribute_name := ':ISC_AGG_LEVEL';
272: l_custom_rec.attribute_value := to_char(l_agg_level);
273: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
274: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
275: x_custom_output.EXTEND;
276: x_custom_output(1) := l_custom_rec;
277:
278: l_custom_rec.attribute_name := ':ISC_LANG';

Line 280: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

276: x_custom_output(1) := l_custom_rec;
277:
278: l_custom_rec.attribute_name := ':ISC_LANG';
279: l_custom_rec.attribute_value := l_lang;
280: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
281: l_custom_Rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
282: x_custom_output.EXTEND;
283: x_custom_output(2) := l_custom_rec;
284:

Line 281: l_custom_Rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

277:
278: l_custom_rec.attribute_name := ':ISC_LANG';
279: l_custom_rec.attribute_value := l_lang;
280: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
281: l_custom_Rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
282: x_custom_output.EXTEND;
283: x_custom_output(2) := l_custom_rec;
284:
285: l_custom_rec.attribute_name := ':ISC_CONST';

Line 287: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

283: x_custom_output(2) := l_custom_rec;
284:
285: l_custom_rec.attribute_name := ':ISC_CONST';
286: l_custom_rec.attribute_value := l_const;
287: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
288: l_custom_Rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
289: x_custom_output.EXTEND;
290: x_custom_output(3) := l_custom_rec;
291:

Line 288: l_custom_Rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;

284:
285: l_custom_rec.attribute_name := ':ISC_CONST';
286: l_custom_rec.attribute_value := l_const;
287: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
288: l_custom_Rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
289: x_custom_output.EXTEND;
290: x_custom_output(3) := l_custom_rec;
291:
292: