eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FII_PMV_UTIL dependencies on BIS_PMV_PARAMETERS_PUB

Line 446: l_bind_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

442: l_bind_rec BIS_QUERY_ATTRIBUTES;
443:
444: BEGIN
445: p_bind_output_table := BIS_QUERY_ATTRIBUTES_TBL();
446: l_bind_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
447: p_sql_output := p_sqlstmt;
448:
449: p_bind_output_table.EXTEND;
450: l_bind_rec.attribute_name := ':FIIBIND1';

Line 452: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

448:
449: p_bind_output_table.EXTEND;
450: l_bind_rec.attribute_name := ':FIIBIND1';
451: l_bind_rec.attribute_value := to_char(p_fiibind1);
452: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
453: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
454: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
455: p_bind_output_table.EXTEND;
456: l_bind_rec.attribute_name := ':FIIBIND2';

Line 453: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

449: p_bind_output_table.EXTEND;
450: l_bind_rec.attribute_name := ':FIIBIND1';
451: l_bind_rec.attribute_value := to_char(p_fiibind1);
452: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
453: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
454: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
455: p_bind_output_table.EXTEND;
456: l_bind_rec.attribute_name := ':FIIBIND2';
457: l_bind_rec.attribute_value := to_char(p_fiibind2);

Line 458: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

454: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
455: p_bind_output_table.EXTEND;
456: l_bind_rec.attribute_name := ':FIIBIND2';
457: l_bind_rec.attribute_value := to_char(p_fiibind2);
458: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
459: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
460: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
461: p_bind_output_table.EXTEND;
462: l_bind_rec.attribute_name := ':FIIBIND3';

Line 459: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

455: p_bind_output_table.EXTEND;
456: l_bind_rec.attribute_name := ':FIIBIND2';
457: l_bind_rec.attribute_value := to_char(p_fiibind2);
458: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
459: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
460: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
461: p_bind_output_table.EXTEND;
462: l_bind_rec.attribute_name := ':FIIBIND3';
463: l_bind_rec.attribute_value := to_char(p_fiibind3);

Line 464: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

460: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
461: p_bind_output_table.EXTEND;
462: l_bind_rec.attribute_name := ':FIIBIND3';
463: l_bind_rec.attribute_value := to_char(p_fiibind3);
464: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
465: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
466: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
467: p_bind_output_table.EXTEND;
468: l_bind_rec.attribute_name := ':FIIBIND4';

Line 465: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

461: p_bind_output_table.EXTEND;
462: l_bind_rec.attribute_name := ':FIIBIND3';
463: l_bind_rec.attribute_value := to_char(p_fiibind3);
464: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
465: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
466: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
467: p_bind_output_table.EXTEND;
468: l_bind_rec.attribute_name := ':FIIBIND4';
469: l_bind_rec.attribute_value := to_char(p_fiibind4);

Line 470: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

466: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
467: p_bind_output_table.EXTEND;
468: l_bind_rec.attribute_name := ':FIIBIND4';
469: l_bind_rec.attribute_value := to_char(p_fiibind4);
470: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
471: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
472: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
473: p_bind_output_table.EXTEND;
474: l_bind_rec.attribute_name := ':FIIBIND5';

Line 471: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

467: p_bind_output_table.EXTEND;
468: l_bind_rec.attribute_name := ':FIIBIND4';
469: l_bind_rec.attribute_value := to_char(p_fiibind4);
470: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
471: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
472: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
473: p_bind_output_table.EXTEND;
474: l_bind_rec.attribute_name := ':FIIBIND5';
475: l_bind_rec.attribute_value := to_char(p_fiibind5);

Line 476: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

472: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
473: p_bind_output_table.EXTEND;
474: l_bind_rec.attribute_name := ':FIIBIND5';
475: l_bind_rec.attribute_value := to_char(p_fiibind5);
476: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
477: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
478: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
479: p_bind_output_table.EXTEND;
480: l_bind_rec.attribute_name := ':FIIBIND6';

Line 477: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

473: p_bind_output_table.EXTEND;
474: l_bind_rec.attribute_name := ':FIIBIND5';
475: l_bind_rec.attribute_value := to_char(p_fiibind5);
476: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
477: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
478: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
479: p_bind_output_table.EXTEND;
480: l_bind_rec.attribute_name := ':FIIBIND6';
481: l_bind_rec.attribute_value := to_char(p_fiibind6);

Line 482: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

478: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
479: p_bind_output_table.EXTEND;
480: l_bind_rec.attribute_name := ':FIIBIND6';
481: l_bind_rec.attribute_value := to_char(p_fiibind6);
482: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
483: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
484: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
485: p_bind_output_table.EXTEND;
486: l_bind_rec.attribute_name := ':ENTRY';

Line 483: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

479: p_bind_output_table.EXTEND;
480: l_bind_rec.attribute_name := ':FIIBIND6';
481: l_bind_rec.attribute_value := to_char(p_fiibind6);
482: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
483: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
484: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
485: p_bind_output_table.EXTEND;
486: l_bind_rec.attribute_name := ':ENTRY';
487: l_bind_rec.attribute_value := to_char(p_entry);

Line 488: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

484: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
485: p_bind_output_table.EXTEND;
486: l_bind_rec.attribute_name := ':ENTRY';
487: l_bind_rec.attribute_value := to_char(p_entry);
488: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
489: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
490: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
491: p_bind_output_table.EXTEND;
492: l_bind_rec.attribute_name := ':HOLD_PLACED';

Line 489: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

485: p_bind_output_table.EXTEND;
486: l_bind_rec.attribute_name := ':ENTRY';
487: l_bind_rec.attribute_value := to_char(p_entry);
488: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
489: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
490: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
491: p_bind_output_table.EXTEND;
492: l_bind_rec.attribute_name := ':HOLD_PLACED';
493: l_bind_rec.attribute_value := to_char(p_hold_placed);

Line 494: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

490: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
491: p_bind_output_table.EXTEND;
492: l_bind_rec.attribute_name := ':HOLD_PLACED';
493: l_bind_rec.attribute_value := to_char(p_hold_placed);
494: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
495: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
496: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
497: p_bind_output_table.EXTEND;
498: l_bind_rec.attribute_name := ':HOLD_RELEASED';

Line 495: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

491: p_bind_output_table.EXTEND;
492: l_bind_rec.attribute_name := ':HOLD_PLACED';
493: l_bind_rec.attribute_value := to_char(p_hold_placed);
494: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
495: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
496: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
497: p_bind_output_table.EXTEND;
498: l_bind_rec.attribute_name := ':HOLD_RELEASED';
499: l_bind_rec.attribute_value := to_char(p_hold_released);

Line 500: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

496: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
497: p_bind_output_table.EXTEND;
498: l_bind_rec.attribute_name := ':HOLD_RELEASED';
499: l_bind_rec.attribute_value := to_char(p_hold_released);
500: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
501: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
502: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
503: p_bind_output_table.EXTEND;
504: l_bind_rec.attribute_name := ':PREPAY_APPLIED';

Line 501: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

497: p_bind_output_table.EXTEND;
498: l_bind_rec.attribute_name := ':HOLD_RELEASED';
499: l_bind_rec.attribute_value := to_char(p_hold_released);
500: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
501: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
502: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
503: p_bind_output_table.EXTEND;
504: l_bind_rec.attribute_name := ':PREPAY_APPLIED';
505: l_bind_rec.attribute_value := to_char(p_prepay_applied);

Line 506: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

502: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
503: p_bind_output_table.EXTEND;
504: l_bind_rec.attribute_name := ':PREPAY_APPLIED';
505: l_bind_rec.attribute_value := to_char(p_prepay_applied);
506: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
507: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
508: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
509: p_bind_output_table.EXTEND;
510: l_bind_rec.attribute_name := ':PREPAY_UNAPPLIED';

Line 507: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

503: p_bind_output_table.EXTEND;
504: l_bind_rec.attribute_name := ':PREPAY_APPLIED';
505: l_bind_rec.attribute_value := to_char(p_prepay_applied);
506: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
507: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
508: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
509: p_bind_output_table.EXTEND;
510: l_bind_rec.attribute_name := ':PREPAY_UNAPPLIED';
511: l_bind_rec.attribute_value := to_char(p_prepay_unapplied);

Line 512: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

508: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
509: p_bind_output_table.EXTEND;
510: l_bind_rec.attribute_name := ':PREPAY_UNAPPLIED';
511: l_bind_rec.attribute_value := to_char(p_prepay_unapplied);
512: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
513: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
514: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
515: p_bind_output_table.EXTEND;
516: l_bind_rec.attribute_name := ':PAYMT';

Line 513: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

509: p_bind_output_table.EXTEND;
510: l_bind_rec.attribute_name := ':PREPAY_UNAPPLIED';
511: l_bind_rec.attribute_value := to_char(p_prepay_unapplied);
512: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
513: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
514: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
515: p_bind_output_table.EXTEND;
516: l_bind_rec.attribute_name := ':PAYMT';
517: l_bind_rec.attribute_value := to_char(p_payment);

Line 518: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

514: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
515: p_bind_output_table.EXTEND;
516: l_bind_rec.attribute_name := ':PAYMT';
517: l_bind_rec.attribute_value := to_char(p_payment);
518: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
519: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
520: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
521: p_bind_output_table.EXTEND;
522: l_bind_rec.attribute_name := ':PAYMT_VOID';

Line 519: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

515: p_bind_output_table.EXTEND;
516: l_bind_rec.attribute_name := ':PAYMT';
517: l_bind_rec.attribute_value := to_char(p_payment);
518: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
519: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
520: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
521: p_bind_output_table.EXTEND;
522: l_bind_rec.attribute_name := ':PAYMT_VOID';
523: l_bind_rec.attribute_value := to_char(p_paymt_void);

Line 524: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

520: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
521: p_bind_output_table.EXTEND;
522: l_bind_rec.attribute_name := ':PAYMT_VOID';
523: l_bind_rec.attribute_value := to_char(p_paymt_void);
524: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
525: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
526: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
527: p_bind_output_table.EXTEND;
528: l_bind_rec.attribute_name := ':PAYMT_STOP';

Line 525: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

521: p_bind_output_table.EXTEND;
522: l_bind_rec.attribute_name := ':PAYMT_VOID';
523: l_bind_rec.attribute_value := to_char(p_paymt_void);
524: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
525: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
526: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
527: p_bind_output_table.EXTEND;
528: l_bind_rec.attribute_name := ':PAYMT_STOP';
529: l_bind_rec.attribute_value := to_char(p_paymt_stop);

Line 530: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

526: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
527: p_bind_output_table.EXTEND;
528: l_bind_rec.attribute_name := ':PAYMT_STOP';
529: l_bind_rec.attribute_value := to_char(p_paymt_stop);
530: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
531: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
532: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
533: p_bind_output_table.EXTEND;
534: l_bind_rec.attribute_name := ':PAYMT_RELEASE';

Line 531: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

527: p_bind_output_table.EXTEND;
528: l_bind_rec.attribute_name := ':PAYMT_STOP';
529: l_bind_rec.attribute_value := to_char(p_paymt_stop);
530: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
531: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
532: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
533: p_bind_output_table.EXTEND;
534: l_bind_rec.attribute_name := ':PAYMT_RELEASE';
535: l_bind_rec.attribute_value := to_char(p_paymt_release);

Line 536: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

532: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
533: p_bind_output_table.EXTEND;
534: l_bind_rec.attribute_name := ':PAYMT_RELEASE';
535: l_bind_rec.attribute_value := to_char(p_paymt_release);
536: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
537: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
538: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
539:
540: p_bind_output_table.EXTEND;

Line 537: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

533: p_bind_output_table.EXTEND;
534: l_bind_rec.attribute_name := ':PAYMT_RELEASE';
535: l_bind_rec.attribute_value := to_char(p_paymt_release);
536: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
537: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
538: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
539:
540: p_bind_output_table.EXTEND;
541: l_bind_rec.attribute_name := ':CREATED';

Line 543: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

539:
540: p_bind_output_table.EXTEND;
541: l_bind_rec.attribute_name := ':CREATED';
542: l_bind_rec.attribute_value := to_char(p_created);
543: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
544: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
545: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
546: p_bind_output_table.EXTEND;
547: l_bind_rec.attribute_name := ':STOPPED';

Line 544: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

540: p_bind_output_table.EXTEND;
541: l_bind_rec.attribute_name := ':CREATED';
542: l_bind_rec.attribute_value := to_char(p_created);
543: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
544: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
545: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
546: p_bind_output_table.EXTEND;
547: l_bind_rec.attribute_name := ':STOPPED';
548: l_bind_rec.attribute_value := to_char(p_stopped);

Line 549: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

545: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
546: p_bind_output_table.EXTEND;
547: l_bind_rec.attribute_name := ':STOPPED';
548: l_bind_rec.attribute_value := to_char(p_stopped);
549: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
550: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
551: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
552: p_bind_output_table.EXTEND;
553: l_bind_rec.attribute_name := ':STOP_RELEASED';

Line 550: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

546: p_bind_output_table.EXTEND;
547: l_bind_rec.attribute_name := ':STOPPED';
548: l_bind_rec.attribute_value := to_char(p_stopped);
549: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
550: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
551: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
552: p_bind_output_table.EXTEND;
553: l_bind_rec.attribute_name := ':STOP_RELEASED';
554: l_bind_rec.attribute_value := to_char(p_stop_released);

Line 555: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

551: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
552: p_bind_output_table.EXTEND;
553: l_bind_rec.attribute_name := ':STOP_RELEASED';
554: l_bind_rec.attribute_value := to_char(p_stop_released);
555: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
556: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
557: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
558: p_bind_output_table.EXTEND;
559: l_bind_rec.attribute_name := ':CLEARED';

Line 556: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

552: p_bind_output_table.EXTEND;
553: l_bind_rec.attribute_name := ':STOP_RELEASED';
554: l_bind_rec.attribute_value := to_char(p_stop_released);
555: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
556: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
557: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
558: p_bind_output_table.EXTEND;
559: l_bind_rec.attribute_name := ':CLEARED';
560: l_bind_rec.attribute_value := to_char(p_cleared);

Line 561: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

557: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
558: p_bind_output_table.EXTEND;
559: l_bind_rec.attribute_name := ':CLEARED';
560: l_bind_rec.attribute_value := to_char(p_cleared);
561: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
562: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
563: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
564: p_bind_output_table.EXTEND;
565: l_bind_rec.attribute_name := ':RECONCILED';

Line 562: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

558: p_bind_output_table.EXTEND;
559: l_bind_rec.attribute_name := ':CLEARED';
560: l_bind_rec.attribute_value := to_char(p_cleared);
561: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
562: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
563: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
564: p_bind_output_table.EXTEND;
565: l_bind_rec.attribute_name := ':RECONCILED';
566: l_bind_rec.attribute_value := to_char(p_reconciled);

Line 567: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

563: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
564: p_bind_output_table.EXTEND;
565: l_bind_rec.attribute_name := ':RECONCILED';
566: l_bind_rec.attribute_value := to_char(p_reconciled);
567: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
568: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
569: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
570: p_bind_output_table.EXTEND;
571: l_bind_rec.attribute_name := ':UNRECONCILED';

Line 568: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

564: p_bind_output_table.EXTEND;
565: l_bind_rec.attribute_name := ':RECONCILED';
566: l_bind_rec.attribute_value := to_char(p_reconciled);
567: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
568: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
569: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
570: p_bind_output_table.EXTEND;
571: l_bind_rec.attribute_name := ':UNRECONCILED';
572: l_bind_rec.attribute_value := to_char(p_unreconciled);

Line 573: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

569: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
570: p_bind_output_table.EXTEND;
571: l_bind_rec.attribute_name := ':UNRECONCILED';
572: l_bind_rec.attribute_value := to_char(p_unreconciled);
573: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
574: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
575: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
576: p_bind_output_table.EXTEND;
577: l_bind_rec.attribute_name := ':UNCLEARED';

Line 574: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

570: p_bind_output_table.EXTEND;
571: l_bind_rec.attribute_name := ':UNRECONCILED';
572: l_bind_rec.attribute_value := to_char(p_unreconciled);
573: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
574: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
575: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
576: p_bind_output_table.EXTEND;
577: l_bind_rec.attribute_name := ':UNCLEARED';
578: l_bind_rec.attribute_value := to_char(p_uncleared);

Line 579: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

575: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
576: p_bind_output_table.EXTEND;
577: l_bind_rec.attribute_name := ':UNCLEARED';
578: l_bind_rec.attribute_value := to_char(p_uncleared);
579: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
580: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
581: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
582: p_bind_output_table.EXTEND;
583: l_bind_rec.attribute_name := ':VOIDED';

Line 580: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

576: p_bind_output_table.EXTEND;
577: l_bind_rec.attribute_name := ':UNCLEARED';
578: l_bind_rec.attribute_value := to_char(p_uncleared);
579: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
580: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
581: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
582: p_bind_output_table.EXTEND;
583: l_bind_rec.attribute_name := ':VOIDED';
584: l_bind_rec.attribute_value := to_char(p_voided);

Line 585: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

581: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
582: p_bind_output_table.EXTEND;
583: l_bind_rec.attribute_name := ':VOIDED';
584: l_bind_rec.attribute_value := to_char(p_voided);
585: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
586: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
587: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
588:
589: p_bind_output_table.EXTEND;

Line 586: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

582: p_bind_output_table.EXTEND;
583: l_bind_rec.attribute_name := ':VOIDED';
584: l_bind_rec.attribute_value := to_char(p_voided);
585: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
586: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
587: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
588:
589: p_bind_output_table.EXTEND;
590: l_bind_rec.attribute_name := ':INVOICE_ID';

Line 592: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

588:
589: p_bind_output_table.EXTEND;
590: l_bind_rec.attribute_name := ':INVOICE_ID';
591: l_bind_rec.attribute_value := to_char(p_invoice_number);
592: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
593: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
594: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
595: p_bind_output_table.EXTEND;
596: l_bind_rec.attribute_name := ':VIEW_BY';

Line 593: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;

589: p_bind_output_table.EXTEND;
590: l_bind_rec.attribute_name := ':INVOICE_ID';
591: l_bind_rec.attribute_value := to_char(p_invoice_number);
592: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
593: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
594: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
595: p_bind_output_table.EXTEND;
596: l_bind_rec.attribute_name := ':VIEW_BY';
597: l_bind_rec.attribute_value := to_char(p_view_by);

Line 598: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

594: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
595: p_bind_output_table.EXTEND;
596: l_bind_rec.attribute_name := ':VIEW_BY';
597: l_bind_rec.attribute_value := to_char(p_view_by);
598: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
599: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
600: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
601: p_bind_output_table.EXTEND;
602: l_bind_rec.attribute_name := ':RECORD_TYPE_ID';

Line 599: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

595: p_bind_output_table.EXTEND;
596: l_bind_rec.attribute_name := ':VIEW_BY';
597: l_bind_rec.attribute_value := to_char(p_view_by);
598: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
599: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
600: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
601: p_bind_output_table.EXTEND;
602: l_bind_rec.attribute_name := ':RECORD_TYPE_ID';
603: l_bind_rec.attribute_value := to_char(p_record_type_id);

Line 604: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

600: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
601: p_bind_output_table.EXTEND;
602: l_bind_rec.attribute_name := ':RECORD_TYPE_ID';
603: l_bind_rec.attribute_value := to_char(p_record_type_id);
604: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
605: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
606: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
607: p_bind_output_table.EXTEND;
608: l_bind_rec.attribute_name := ':GID';

Line 605: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;

601: p_bind_output_table.EXTEND;
602: l_bind_rec.attribute_name := ':RECORD_TYPE_ID';
603: l_bind_rec.attribute_value := to_char(p_record_type_id);
604: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
605: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
606: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
607: p_bind_output_table.EXTEND;
608: l_bind_rec.attribute_name := ':GID';
609: l_bind_rec.attribute_value := to_char(p_gid);

Line 610: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

606: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
607: p_bind_output_table.EXTEND;
608: l_bind_rec.attribute_name := ':GID';
609: l_bind_rec.attribute_value := to_char(p_gid);
610: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
611: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
612: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
613: p_bind_output_table.EXTEND;
614: l_bind_rec.attribute_name := ':SEC_ID';

Line 611: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;

607: p_bind_output_table.EXTEND;
608: l_bind_rec.attribute_name := ':GID';
609: l_bind_rec.attribute_value := to_char(p_gid);
610: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
611: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
612: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
613: p_bind_output_table.EXTEND;
614: l_bind_rec.attribute_name := ':SEC_ID';
615: l_bind_rec.attribute_value := fii_pmv_util.get_sec_profile;

Line 616: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

612: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
613: p_bind_output_table.EXTEND;
614: l_bind_rec.attribute_name := ':SEC_ID';
615: l_bind_rec.attribute_value := fii_pmv_util.get_sec_profile;
616: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
617: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
618: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
619: p_bind_output_table.EXTEND;
620: l_bind_rec.attribute_name := ':PERIOD_START';

Line 617: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;

613: p_bind_output_table.EXTEND;
614: l_bind_rec.attribute_name := ':SEC_ID';
615: l_bind_rec.attribute_value := fii_pmv_util.get_sec_profile;
616: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
617: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
618: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
619: p_bind_output_table.EXTEND;
620: l_bind_rec.attribute_name := ':PERIOD_START';
621: l_bind_rec.attribute_value := to_char(p_period_start, 'DD-MM-YYYY');

Line 622: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

618: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
619: p_bind_output_table.EXTEND;
620: l_bind_rec.attribute_name := ':PERIOD_START';
621: l_bind_rec.attribute_value := to_char(p_period_start, 'DD-MM-YYYY');
622: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
623: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
624: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
625: p_bind_output_table.EXTEND;
626: l_bind_rec.attribute_name := ':CHECK_ID';

Line 623: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;

619: p_bind_output_table.EXTEND;
620: l_bind_rec.attribute_name := ':PERIOD_START';
621: l_bind_rec.attribute_value := to_char(p_period_start, 'DD-MM-YYYY');
622: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
623: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
624: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
625: p_bind_output_table.EXTEND;
626: l_bind_rec.attribute_name := ':CHECK_ID';
627: l_bind_rec.attribute_value := to_char(p_check_id);

Line 628: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

624: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
625: p_bind_output_table.EXTEND;
626: l_bind_rec.attribute_name := ':CHECK_ID';
627: l_bind_rec.attribute_value := to_char(p_check_id);
628: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
629: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
630: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
631: p_bind_output_table.EXTEND;
632:

Line 629: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;

625: p_bind_output_table.EXTEND;
626: l_bind_rec.attribute_name := ':CHECK_ID';
627: l_bind_rec.attribute_value := to_char(p_check_id);
628: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
629: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
630: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
631: p_bind_output_table.EXTEND;
632:
633: l_bind_rec.attribute_name := ':LINE_NUMBER';

Line 635: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

631: p_bind_output_table.EXTEND;
632:
633: l_bind_rec.attribute_name := ':LINE_NUMBER';
634: l_bind_rec.attribute_value := to_char(p_line_number);
635: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
636: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
637: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
638: p_bind_output_table.EXTEND;
639:

Line 636: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;

632:
633: l_bind_rec.attribute_name := ':LINE_NUMBER';
634: l_bind_rec.attribute_value := to_char(p_line_number);
635: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
636: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
637: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
638: p_bind_output_table.EXTEND;
639:
640: l_bind_rec.attribute_name := ':BUSINESS_GROUP';

Line 642: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

638: p_bind_output_table.EXTEND;
639:
640: l_bind_rec.attribute_name := ':BUSINESS_GROUP';
641: l_bind_rec.attribute_value := to_char(g_business_group_id);
642: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
643: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
644: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
645: p_bind_output_table.EXTEND;
646:

Line 643: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;

639:
640: l_bind_rec.attribute_name := ':BUSINESS_GROUP';
641: l_bind_rec.attribute_value := to_char(g_business_group_id);
642: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
643: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
644: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
645: p_bind_output_table.EXTEND;
646:
647: l_bind_rec.attribute_name := ':SEC_ORG_ID';

Line 649: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

645: p_bind_output_table.EXTEND;
646:
647: l_bind_rec.attribute_name := ':SEC_ORG_ID';
648: l_bind_rec.attribute_value := g_security_org_id;
649: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
650: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
651: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
652: p_bind_output_table.EXTEND;
653:

Line 650: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;

646:
647: l_bind_rec.attribute_name := ':SEC_ORG_ID';
648: l_bind_rec.attribute_value := g_security_org_id;
649: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
650: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
651: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
652: p_bind_output_table.EXTEND;
653:
654: --added by vkazhipu

Line 657: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

653:
654: --added by vkazhipu
655: l_bind_rec.attribute_name := ':ASOF_DATE_JULIEN';
656: l_bind_rec.attribute_value := to_number(to_char(g_p_as_of_date,'J'));
657: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
658: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
659: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
660: p_bind_output_table.EXTEND;
661:

Line 658: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;

654: --added by vkazhipu
655: l_bind_rec.attribute_name := ':ASOF_DATE_JULIEN';
656: l_bind_rec.attribute_value := to_number(to_char(g_p_as_of_date,'J'));
657: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
658: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
659: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
660: p_bind_output_table.EXTEND;
661:
662: l_bind_rec.attribute_name := ':GID2';

Line 664: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

660: p_bind_output_table.EXTEND;
661:
662: l_bind_rec.attribute_name := ':GID2';
663: l_bind_rec.attribute_value := to_char(g_gid);
664: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
665: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
666: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
667: p_bind_output_table.EXTEND;
668:

Line 665: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;

661:
662: l_bind_rec.attribute_name := ':GID2';
663: l_bind_rec.attribute_value := to_char(g_gid);
664: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
665: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
666: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
667: p_bind_output_table.EXTEND;
668:
669: l_bind_rec.attribute_name := ':PREVIOUS_DATE';

Line 671: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

667: p_bind_output_table.EXTEND;
668:
669: l_bind_rec.attribute_name := ':PREVIOUS_DATE';
670: l_bind_rec.attribute_value := to_char(g_previous_date, 'DD-MM-YYYY');
671: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
672: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
673: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
674: p_bind_output_table.EXTEND;
675:

Line 672: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;

668:
669: l_bind_rec.attribute_name := ':PREVIOUS_DATE';
670: l_bind_rec.attribute_value := to_char(g_previous_date, 'DD-MM-YYYY');
671: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
672: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
673: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
674: p_bind_output_table.EXTEND;
675:
676: