DBA Data[Home] [Help]

APPS.BIX_PMV_EMC_KPI_PRTLT_PKG dependencies on BIS_PMV_PARAMETERS_PUB

Line 36: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;

32: l_row_type varchar2(10) := 'ACP';
33:
34: BEGIN
35: p_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
36: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
37:
38: /*
39: l_sqltext := '
40: SELECT

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

288:
289:
290: l_custom_rec.attribute_name := ':l_period_type_id' ;
291: l_custom_rec.attribute_value:= l_period_type_id;
292: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
293: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
294:
295: p_custom_output.Extend();
296: p_custom_output(p_custom_output.count) := l_custom_rec;

Line 293: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;

289:
290: l_custom_rec.attribute_name := ':l_period_type_id' ;
291: l_custom_rec.attribute_value:= l_period_type_id;
292: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
293: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
294:
295: p_custom_output.Extend();
296: p_custom_output(p_custom_output.count) := l_custom_rec;
297:

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

296: p_custom_output(p_custom_output.count) := l_custom_rec;
297:
298: l_custom_rec.attribute_name := ':l_max_collect_date' ;
299: l_custom_rec.attribute_value:= l_max_collect_date;
300: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
301: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
302:
303: p_custom_output.Extend();
304: p_custom_output(p_custom_output.count) := l_custom_rec;

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

297:
298: l_custom_rec.attribute_name := ':l_max_collect_date' ;
299: l_custom_rec.attribute_value:= l_max_collect_date;
300: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
301: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
302:
303: p_custom_output.Extend();
304: p_custom_output(p_custom_output.count) := l_custom_rec;
305:

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

305:
306:
307: l_custom_rec.attribute_name := ':l_application_id';
308: l_custom_rec.attribute_value:= l_application_id;
309: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
310: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
311:
312: p_custom_output.EXTEND;
313: p_custom_output(p_custom_output.COUNT) := l_custom_rec;

Line 310: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;

306:
307: l_custom_rec.attribute_name := ':l_application_id';
308: l_custom_rec.attribute_value:= l_application_id;
309: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
310: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
311:
312: p_custom_output.EXTEND;
313: p_custom_output(p_custom_output.COUNT) := l_custom_rec;
314:

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

314:
315: IF ( l_account IS NOT NULL) THEN
316: l_custom_rec.attribute_name := ':l_account' ;
317: l_custom_rec.attribute_value:= l_account;
318: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
319: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
320:
321: p_custom_output.Extend();
322: p_custom_output(p_custom_output.count) := l_custom_rec;

Line 319: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

315: IF ( l_account IS NOT NULL) THEN
316: l_custom_rec.attribute_name := ':l_account' ;
317: l_custom_rec.attribute_value:= l_account;
318: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
319: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
320:
321: p_custom_output.Extend();
322: p_custom_output(p_custom_output.count) := l_custom_rec;
323: END IF;

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

324:
325: IF ( l_classification IS NOT NULL) THEN
326: l_custom_rec.attribute_name := ':l_classification' ;
327: l_custom_rec.attribute_value:= l_classification;
328: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
329: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
330:
331: p_custom_output.Extend();
332: p_custom_output(p_custom_output.count) := l_custom_rec;

Line 329: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

325: IF ( l_classification IS NOT NULL) THEN
326: l_custom_rec.attribute_name := ':l_classification' ;
327: l_custom_rec.attribute_value:= l_classification;
328: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
329: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
330:
331: p_custom_output.Extend();
332: p_custom_output(p_custom_output.count) := l_custom_rec;
333: END IF;

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

333: END IF;
334:
335: l_custom_rec.attribute_name := ':l_row_type' ;
336: l_custom_rec.attribute_value:= l_row_type;
337: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
338: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
339:
340: p_custom_output.Extend();
341: p_custom_output(p_custom_output.count) := l_custom_rec;

Line 338: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

334:
335: l_custom_rec.attribute_name := ':l_row_type' ;
336: l_custom_rec.attribute_value:= l_row_type;
337: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
338: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
339:
340: p_custom_output.Extend();
341: p_custom_output(p_custom_output.count) := l_custom_rec;
342: