330:
331:
332:
333:
334: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
335: x_custom_output := bis_query_attributes_tbl();
336:
337: x_custom_output.extend;
338: l_custom_rec.attribute_name := ':ITEM';
336:
337: x_custom_output.extend;
338: l_custom_rec.attribute_name := ':ITEM';
339: l_custom_rec.attribute_value := l_item;
340: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
341: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
342: x_custom_output(1) := l_custom_rec;
343:
344: x_custom_output.extend;
337: x_custom_output.extend;
338: l_custom_rec.attribute_name := ':ITEM';
339: l_custom_rec.attribute_value := l_item;
340: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
341: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
342: x_custom_output(1) := l_custom_rec;
343:
344: x_custom_output.extend;
345: l_custom_rec.attribute_name := ':ORG';
343:
344: x_custom_output.extend;
345: l_custom_rec.attribute_name := ':ORG';
346: l_custom_rec.attribute_value := replace(l_org,'''');
347: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
348: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
349: x_custom_output(2) := l_custom_rec;
350:
351: x_custom_output.extend;
344: x_custom_output.extend;
345: l_custom_rec.attribute_name := ':ORG';
346: l_custom_rec.attribute_value := replace(l_org,'''');
347: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
348: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
349: x_custom_output(2) := l_custom_rec;
350:
351: x_custom_output.extend;
352: l_custom_rec.attribute_name := ':REASON';
350:
351: x_custom_output.extend;
352: l_custom_rec.attribute_name := ':REASON';
353: l_custom_rec.attribute_value := l_reason;
354: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
355: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
356: x_custom_output(3) := l_custom_rec;
357:
358: x_custom_output.extend;
351: x_custom_output.extend;
352: l_custom_rec.attribute_name := ':REASON';
353: l_custom_rec.attribute_value := l_reason;
354: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
355: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
356: x_custom_output(3) := l_custom_rec;
357:
358: x_custom_output.extend;
359: l_custom_rec.attribute_name := ':PRIORITY';
357:
358: x_custom_output.extend;
359: l_custom_rec.attribute_name := ':PRIORITY';
360: l_custom_rec.attribute_value := l_priority;
361: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
362: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
363: x_custom_output(4) := l_custom_rec;
364:
365: x_custom_output.extend;
358: x_custom_output.extend;
359: l_custom_rec.attribute_name := ':PRIORITY';
360: l_custom_rec.attribute_value := l_priority;
361: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
362: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
363: x_custom_output(4) := l_custom_rec;
364:
365: x_custom_output.extend;
366: l_custom_rec.attribute_name := ':TYPE';
364:
365: x_custom_output.extend;
366: l_custom_rec.attribute_name := ':TYPE';
367: l_custom_rec.attribute_value := replace(l_type,'''');
368: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
369: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
370: x_custom_output(5) := l_custom_rec;
371:
372: x_custom_output.extend;
365: x_custom_output.extend;
366: l_custom_rec.attribute_name := ':TYPE';
367: l_custom_rec.attribute_value := replace(l_type,'''');
368: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
369: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
370: x_custom_output(5) := l_custom_rec;
371:
372: x_custom_output.extend;
373: l_custom_rec.attribute_name := ':STATUS';
371:
372: x_custom_output.extend;
373: l_custom_rec.attribute_name := ':STATUS';
374: l_custom_rec.attribute_value := replace(l_status,'''');
375: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
376: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
377: x_custom_output(6) := l_custom_rec;
378:
379: --Bug 5083652 -- Start Code
372: x_custom_output.extend;
373: l_custom_rec.attribute_name := ':STATUS';
374: l_custom_rec.attribute_value := replace(l_status,'''');
375: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
376: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
377: x_custom_output(6) := l_custom_rec;
378:
379: --Bug 5083652 -- Start Code
380:
380:
381: x_custom_output.extend;
382: l_custom_rec.attribute_name := ':PERIODTYPE';
383: l_custom_rec.attribute_value := REPLACE(l_period_type,'''');
384: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
385: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
386: x_custom_output(7) := l_custom_rec;
387:
388: x_custom_output.extend;
381: x_custom_output.extend;
382: l_custom_rec.attribute_name := ':PERIODTYPE';
383: l_custom_rec.attribute_value := REPLACE(l_period_type,'''');
384: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
385: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
386: x_custom_output(7) := l_custom_rec;
387:
388: x_custom_output.extend;
389: l_custom_rec.attribute_name := ':COMPARETYPE';
387:
388: x_custom_output.extend;
389: l_custom_rec.attribute_name := ':COMPARETYPE';
390: l_custom_rec.attribute_value := REPLACE(l_comp_type,'''');
391: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
392: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
393: x_custom_output(8) := l_custom_rec;
394:
395:
388: x_custom_output.extend;
389: l_custom_rec.attribute_name := ':COMPARETYPE';
390: l_custom_rec.attribute_value := REPLACE(l_comp_type,'''');
391: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
392: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
393: x_custom_output(8) := l_custom_rec;
394:
395:
396: x_custom_output.extend;
395:
396: x_custom_output.extend;
397: l_custom_rec.attribute_name := ':PERIODAND';
398: l_custom_rec.attribute_value := REPLACE(l_period_bitand,'''');
399: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
400: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
401: x_custom_output(9) := l_custom_rec;
402:
403: x_custom_output.extend;
396: x_custom_output.extend;
397: l_custom_rec.attribute_name := ':PERIODAND';
398: l_custom_rec.attribute_value := REPLACE(l_period_bitand,'''');
399: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
400: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
401: x_custom_output(9) := l_custom_rec;
402:
403: x_custom_output.extend;
404: l_custom_rec.attribute_name := ':CUR_PERIOD_ID';
402:
403: x_custom_output.extend;
404: l_custom_rec.attribute_name := ':CUR_PERIOD_ID';
405: l_custom_rec.attribute_value := REPLACE(l_cur_period,'''');
406: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
407: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
408: x_custom_output(10) := l_custom_rec;
409:
410: --Bug 5083652 -- End Code
403: x_custom_output.extend;
404: l_custom_rec.attribute_name := ':CUR_PERIOD_ID';
405: l_custom_rec.attribute_value := REPLACE(l_cur_period,'''');
406: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
407: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
408: x_custom_output(10) := l_custom_rec;
409:
410: --Bug 5083652 -- End Code
411: