APPS.ISC_DBI_PDUE_PRM_AGING_PKG dependencies on BIS_PMV_PARAMETERS_PUB

Line 187: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;

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'))

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

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:

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

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';

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

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:

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

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';

Line 409: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;

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:

Line 410: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;

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';

Line 416: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;

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:

Line 417: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;

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';

Line 423: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;

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:

Line 424: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;

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';

Line 430: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;

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:

Line 431: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;

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';

Line 437: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;

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:

Line 438: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;

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';

Line 444: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;

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:

Line 445: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;

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';

Line 451: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;

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:

Line 452: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;

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';

Line 458: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;

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:

Line 459: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;

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';

Line 465: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;

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:

Line 466: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;

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';

Line 472: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;

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:

Line 473: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;

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;