183:
184: -- Retrieve record to get bucket labels
185: bis_bucket_pub.RETRIEVE_BIS_BUCKET('ISC_DBI_PDUE_AGING', l_bucket_rec, l_status, l_error_tbl);
186:
187: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
188: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
189:
190: IF ((l_prod IS NULL OR l_prod = '' OR l_prod = 'All') AND
191: (l_cust IS NULL OR l_cust = '' OR l_cust = 'All'))
391: x_custom_sql := l_stmt;
392:
393: l_custom_rec.attribute_name := ':ISC_ITEM_CAT_FLAG';
394: l_custom_rec.attribute_value := to_char(l_item_cat_flag);
395: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
396: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.integer_bind;
397: x_custom_output.extend;
398: x_custom_output(1) := l_custom_rec;
399:
392:
393: l_custom_rec.attribute_name := ':ISC_ITEM_CAT_FLAG';
394: l_custom_rec.attribute_value := to_char(l_item_cat_flag);
395: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
396: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.integer_bind;
397: x_custom_output.extend;
398: x_custom_output(1) := l_custom_rec;
399:
400: l_custom_rec.attribute_name := ':ISC_CUST_FLAG';
398: x_custom_output(1) := l_custom_rec;
399:
400: l_custom_rec.attribute_name := ':ISC_CUST_FLAG';
401: l_custom_rec.attribute_value := to_char(l_cust_flag);
402: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
403: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.integer_bind;
404: x_custom_output.extend;
405: x_custom_output(2) := l_custom_rec;
406:
399:
400: l_custom_rec.attribute_name := ':ISC_CUST_FLAG';
401: l_custom_rec.attribute_value := to_char(l_cust_flag);
402: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
403: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.integer_bind;
404: x_custom_output.extend;
405: x_custom_output(2) := l_custom_rec;
406:
407: l_custom_rec.attribute_name := ':ISC_R1';
405: x_custom_output(2) := l_custom_rec;
406:
407: l_custom_rec.attribute_name := ':ISC_R1';
408: l_custom_rec.attribute_value := l_bucket_rec.range1_name;
409: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
410: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
411: x_custom_output.extend;
412: x_custom_output(3) := l_custom_rec;
413:
406:
407: l_custom_rec.attribute_name := ':ISC_R1';
408: l_custom_rec.attribute_value := l_bucket_rec.range1_name;
409: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
410: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
411: x_custom_output.extend;
412: x_custom_output(3) := l_custom_rec;
413:
414: l_custom_rec.attribute_name := ':ISC_R2';
412: x_custom_output(3) := l_custom_rec;
413:
414: l_custom_rec.attribute_name := ':ISC_R2';
415: l_custom_rec.attribute_value := l_bucket_rec.range2_name;
416: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
417: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
418: x_custom_output.extend;
419: x_custom_output(4) := l_custom_rec;
420:
413:
414: l_custom_rec.attribute_name := ':ISC_R2';
415: l_custom_rec.attribute_value := l_bucket_rec.range2_name;
416: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
417: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
418: x_custom_output.extend;
419: x_custom_output(4) := l_custom_rec;
420:
421: l_custom_rec.attribute_name := ':ISC_R3';
419: x_custom_output(4) := l_custom_rec;
420:
421: l_custom_rec.attribute_name := ':ISC_R3';
422: l_custom_rec.attribute_value := l_bucket_rec.range3_name;
423: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
424: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
425: x_custom_output.extend;
426: x_custom_output(5) := l_custom_rec;
427:
420:
421: l_custom_rec.attribute_name := ':ISC_R3';
422: l_custom_rec.attribute_value := l_bucket_rec.range3_name;
423: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
424: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
425: x_custom_output.extend;
426: x_custom_output(5) := l_custom_rec;
427:
428: l_custom_rec.attribute_name := ':ISC_R4';
426: x_custom_output(5) := l_custom_rec;
427:
428: l_custom_rec.attribute_name := ':ISC_R4';
429: l_custom_rec.attribute_value := l_bucket_rec.range4_name;
430: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
431: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
432: x_custom_output.extend;
433: x_custom_output(6) := l_custom_rec;
434:
427:
428: l_custom_rec.attribute_name := ':ISC_R4';
429: l_custom_rec.attribute_value := l_bucket_rec.range4_name;
430: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
431: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
432: x_custom_output.extend;
433: x_custom_output(6) := l_custom_rec;
434:
435: l_custom_rec.attribute_name := ':ISC_R5';
433: x_custom_output(6) := l_custom_rec;
434:
435: l_custom_rec.attribute_name := ':ISC_R5';
436: l_custom_rec.attribute_value := l_bucket_rec.range5_name;
437: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
438: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
439: x_custom_output.extend;
440: x_custom_output(7) := l_custom_rec;
441:
434:
435: l_custom_rec.attribute_name := ':ISC_R5';
436: l_custom_rec.attribute_value := l_bucket_rec.range5_name;
437: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
438: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
439: x_custom_output.extend;
440: x_custom_output(7) := l_custom_rec;
441:
442: l_custom_rec.attribute_name := ':ISC_R6';
440: x_custom_output(7) := l_custom_rec;
441:
442: l_custom_rec.attribute_name := ':ISC_R6';
443: l_custom_rec.attribute_value := l_bucket_rec.range6_name;
444: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
445: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
446: x_custom_output.extend;
447: x_custom_output(8) := l_custom_rec;
448:
441:
442: l_custom_rec.attribute_name := ':ISC_R6';
443: l_custom_rec.attribute_value := l_bucket_rec.range6_name;
444: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
445: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
446: x_custom_output.extend;
447: x_custom_output(8) := l_custom_rec;
448:
449: l_custom_rec.attribute_name := ':ISC_R7';
447: x_custom_output(8) := l_custom_rec;
448:
449: l_custom_rec.attribute_name := ':ISC_R7';
450: l_custom_rec.attribute_value := l_bucket_rec.range7_name;
451: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
452: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
453: x_custom_output.extend;
454: x_custom_output(9) := l_custom_rec;
455:
448:
449: l_custom_rec.attribute_name := ':ISC_R7';
450: l_custom_rec.attribute_value := l_bucket_rec.range7_name;
451: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
452: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
453: x_custom_output.extend;
454: x_custom_output(9) := l_custom_rec;
455:
456: l_custom_rec.attribute_name := ':ISC_R8';
454: x_custom_output(9) := l_custom_rec;
455:
456: l_custom_rec.attribute_name := ':ISC_R8';
457: l_custom_rec.attribute_value := l_bucket_rec.range8_name;
458: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
459: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
460: x_custom_output.extend;
461: x_custom_output(10) := l_custom_rec;
462:
455:
456: l_custom_rec.attribute_name := ':ISC_R8';
457: l_custom_rec.attribute_value := l_bucket_rec.range8_name;
458: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
459: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
460: x_custom_output.extend;
461: x_custom_output(10) := l_custom_rec;
462:
463: l_custom_rec.attribute_name := ':ISC_R9';
461: x_custom_output(10) := l_custom_rec;
462:
463: l_custom_rec.attribute_name := ':ISC_R9';
464: l_custom_rec.attribute_value := l_bucket_rec.range9_name;
465: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
466: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
467: x_custom_output.extend;
468: x_custom_output(11) := l_custom_rec;
469:
462:
463: l_custom_rec.attribute_name := ':ISC_R9';
464: l_custom_rec.attribute_value := l_bucket_rec.range9_name;
465: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
466: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
467: x_custom_output.extend;
468: x_custom_output(11) := l_custom_rec;
469:
470: l_custom_rec.attribute_name := ':ISC_R10';
468: x_custom_output(11) := l_custom_rec;
469:
470: l_custom_rec.attribute_name := ':ISC_R10';
471: l_custom_rec.attribute_value := l_bucket_rec.range10_name;
472: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
473: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
474: x_custom_output.extend;
475: x_custom_output(12) := l_custom_rec;
476:
469:
470: l_custom_rec.attribute_name := ':ISC_R10';
471: l_custom_rec.attribute_value := l_bucket_rec.range10_name;
472: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
473: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
474: x_custom_output.extend;
475: x_custom_output(12) := l_custom_rec;
476:
477: END Get_Sql;