DBA Data[Home] [Help]

APPS.ISC_DBI_SHIP_LATE_TP_PKG dependencies on BIS_PMV_PARAMETERS_PUB

Line 134: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

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

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

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

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

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

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

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

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

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

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

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

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

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