DBA Data[Home] [Help]

APPS.ISC_DBI_PDUE_PRM_DETAIL_PKG dependencies on BIS_PMV_PARAMETERS_PUB

Line 215: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;

211: l_snapshot_taken := TRUE;
212:
213: END;
214:
215: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
216: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
217:
218: l_measures := 'ISC_ATTRIBUTE_2, ISC_ATTRIBUTE_3, ISC_ATTRIBUTE_5, ISC_ATTRIBUTE_7,
219: ISC_MEASURE_1, ISC_MEASURE_2, ISC_MEASURE_3';

Line 285: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;

281: x_custom_sql := l_stmt;
282:
283: l_custom_rec.attribute_name := ':ISC_LOW';
284: l_custom_rec.attribute_value := to_char(l_low);
285: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
286: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.integer_bind;
287: x_custom_output.extend;
288: x_custom_output(1) := l_custom_rec;
289:

Line 286: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.integer_bind;

282:
283: l_custom_rec.attribute_name := ':ISC_LOW';
284: l_custom_rec.attribute_value := to_char(l_low);
285: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
286: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.integer_bind;
287: x_custom_output.extend;
288: x_custom_output(1) := l_custom_rec;
289:
290: l_custom_rec.attribute_name := ':ISC_HIGH';

Line 292: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;

288: x_custom_output(1) := l_custom_rec;
289:
290: l_custom_rec.attribute_name := ':ISC_HIGH';
291: l_custom_rec.attribute_value := to_char(l_high);
292: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
293: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.integer_bind;
294: x_custom_output.extend;
295: x_custom_output(2) := l_custom_rec;
296:

Line 293: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.integer_bind;

289:
290: l_custom_rec.attribute_name := ':ISC_HIGH';
291: l_custom_rec.attribute_value := to_char(l_high);
292: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
293: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.integer_bind;
294: x_custom_output.extend;
295: x_custom_output(2) := l_custom_rec;
296:
297: l_custom_rec.attribute_name := ':ISC_LANG';

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

295: x_custom_output(2) := l_custom_rec;
296:
297: l_custom_rec.attribute_name := ':ISC_LANG';
298: l_custom_rec.attribute_value := l_lang;
299: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
300: l_custom_Rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
301: x_custom_output.EXTEND;
302: x_custom_output(3) := l_custom_rec;
303:

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

296:
297: l_custom_rec.attribute_name := ':ISC_LANG';
298: l_custom_rec.attribute_value := l_lang;
299: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
300: l_custom_Rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
301: x_custom_output.EXTEND;
302: x_custom_output(3) := l_custom_rec;
303:
304: END Get_Sql;