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_AR_UTIL_PKG dependencies on BIS_PMV_PARAMETERS_PUB

Line 380: l_bind_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

376:
377: BEGIN
378:
379: p_bind_output_table := BIS_QUERY_ATTRIBUTES_TBL();
380: l_bind_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
381: p_sql_output := p_sqlstmt;
382:
383: p_bind_output_table.EXTEND;
384: l_bind_rec.attribute_name := ':ASOF_DATE';

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

382:
383: p_bind_output_table.EXTEND;
384: l_bind_rec.attribute_name := ':ASOF_DATE';
385: l_bind_rec.attribute_value := to_char(g_as_of_date, 'DD/MM/YYYY');
386: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
387: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
388: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
389:
390: p_bind_output_table.EXTEND;

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

383: p_bind_output_table.EXTEND;
384: l_bind_rec.attribute_name := ':ASOF_DATE';
385: l_bind_rec.attribute_value := to_char(g_as_of_date, 'DD/MM/YYYY');
386: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
387: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
388: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
389:
390: p_bind_output_table.EXTEND;
391: l_bind_rec.attribute_name := ':PREVIOUS_ASOF_DATE';

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

389:
390: p_bind_output_table.EXTEND;
391: l_bind_rec.attribute_name := ':PREVIOUS_ASOF_DATE';
392: l_bind_rec.attribute_value := to_char(g_previous_asof_date, 'DD/MM/YYYY');
393: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
394: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
395: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
396:
397: p_bind_output_table.EXTEND;

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

390: p_bind_output_table.EXTEND;
391: l_bind_rec.attribute_name := ':PREVIOUS_ASOF_DATE';
392: l_bind_rec.attribute_value := to_char(g_previous_asof_date, 'DD/MM/YYYY');
393: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
394: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
395: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
396:
397: p_bind_output_table.EXTEND;
398: l_bind_rec.attribute_name := ':CURRENCY';

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

396:
397: p_bind_output_table.EXTEND;
398: l_bind_rec.attribute_name := ':CURRENCY';
399: l_bind_rec.attribute_value := to_char(g_currency);
400: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
401: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
402: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
403:
404: /*

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

397: p_bind_output_table.EXTEND;
398: l_bind_rec.attribute_name := ':CURRENCY';
399: l_bind_rec.attribute_value := to_char(g_currency);
400: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
401: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
402: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
403:
404: /*
405: p_bind_output_table.EXTEND;

Line 406: l_bind_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;

402: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
403:
404: /*
405: p_bind_output_table.EXTEND;
406: l_bind_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;
407: l_bind_rec.attribute_value := g_view_by;
408: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.VIEW_BY_TYPE;
409: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
410: */

Line 408: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.VIEW_BY_TYPE;

404: /*
405: p_bind_output_table.EXTEND;
406: l_bind_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;
407: l_bind_rec.attribute_value := g_view_by;
408: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.VIEW_BY_TYPE;
409: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
410: */
411:
412: p_bind_output_table.EXTEND;

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

411:
412: p_bind_output_table.EXTEND;
413: l_bind_rec.attribute_name := ':PARTY_ID';
414: l_bind_rec.attribute_value := to_char(g_party_id);
415: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
416: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
417: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
418:
419: p_bind_output_table.EXTEND;

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

412: p_bind_output_table.EXTEND;
413: l_bind_rec.attribute_name := ':PARTY_ID';
414: l_bind_rec.attribute_value := to_char(g_party_id);
415: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
416: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
417: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
418:
419: p_bind_output_table.EXTEND;
420: l_bind_rec.attribute_name := ':CUST_ACCOUNT_ID';

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

418:
419: p_bind_output_table.EXTEND;
420: l_bind_rec.attribute_name := ':CUST_ACCOUNT_ID';
421: l_bind_rec.attribute_value := to_char(g_cust_account_id);
422: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
423: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
424: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
425:
426: p_bind_output_table.EXTEND;

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

419: p_bind_output_table.EXTEND;
420: l_bind_rec.attribute_name := ':CUST_ACCOUNT_ID';
421: l_bind_rec.attribute_value := to_char(g_cust_account_id);
422: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
423: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
424: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
425:
426: p_bind_output_table.EXTEND;
427: l_bind_rec.attribute_name := ':ORG_ID';

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

425:
426: p_bind_output_table.EXTEND;
427: l_bind_rec.attribute_name := ':ORG_ID';
428: l_bind_rec.attribute_value := to_char(g_org_id);
429: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
430: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
431: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
432:
433: p_bind_output_table.EXTEND;

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

426: p_bind_output_table.EXTEND;
427: l_bind_rec.attribute_name := ':ORG_ID';
428: l_bind_rec.attribute_value := to_char(g_org_id);
429: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
430: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
431: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
432:
433: p_bind_output_table.EXTEND;
434: l_bind_rec.attribute_name := ':COLLECTOR_ID';

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

432:
433: p_bind_output_table.EXTEND;
434: l_bind_rec.attribute_name := ':COLLECTOR_ID';
435: l_bind_rec.attribute_value := to_char(g_collector_id);
436: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
437: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
438: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
439:
440: p_bind_output_table.EXTEND;

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

433: p_bind_output_table.EXTEND;
434: l_bind_rec.attribute_name := ':COLLECTOR_ID';
435: l_bind_rec.attribute_value := to_char(g_collector_id);
436: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
437: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
438: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
439:
440: p_bind_output_table.EXTEND;
441: l_bind_rec.attribute_name := ':INDUSTRY_ID';

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

439:
440: p_bind_output_table.EXTEND;
441: l_bind_rec.attribute_name := ':INDUSTRY_ID';
442: l_bind_rec.attribute_value := to_char(g_industry_id);
443: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
444: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
445: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
446:
447: p_bind_output_table.EXTEND;

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

440: p_bind_output_table.EXTEND;
441: l_bind_rec.attribute_name := ':INDUSTRY_ID';
442: l_bind_rec.attribute_value := to_char(g_industry_id);
443: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
444: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
445: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
446:
447: p_bind_output_table.EXTEND;
448: l_bind_rec.attribute_name := ':CURR_PERIOD_START';

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

446:
447: p_bind_output_table.EXTEND;
448: l_bind_rec.attribute_name := ':CURR_PERIOD_START';
449: l_bind_rec.attribute_value := to_char(g_curr_per_start, 'DD/MM/YYYY');
450: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
451: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
452: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
453:
454: p_bind_output_table.EXTEND;

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

447: p_bind_output_table.EXTEND;
448: l_bind_rec.attribute_name := ':CURR_PERIOD_START';
449: l_bind_rec.attribute_value := to_char(g_curr_per_start, 'DD/MM/YYYY');
450: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
451: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
452: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
453:
454: p_bind_output_table.EXTEND;
455: l_bind_rec.attribute_name := ':CURR_PERIOD_END';

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

453:
454: p_bind_output_table.EXTEND;
455: l_bind_rec.attribute_name := ':CURR_PERIOD_END';
456: l_bind_rec.attribute_value := to_char(g_curr_per_end, 'DD/MM/YYYY');
457: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
458: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
459: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
460:
461: p_bind_output_table.EXTEND;

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

454: p_bind_output_table.EXTEND;
455: l_bind_rec.attribute_name := ':CURR_PERIOD_END';
456: l_bind_rec.attribute_value := to_char(g_curr_per_end, 'DD/MM/YYYY');
457: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
458: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
459: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
460:
461: p_bind_output_table.EXTEND;
462: l_bind_rec.attribute_name := ':PRIOR_PERIOD_START';

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

460:
461: p_bind_output_table.EXTEND;
462: l_bind_rec.attribute_name := ':PRIOR_PERIOD_START';
463: l_bind_rec.attribute_value := to_char(g_prior_per_start, 'DD/MM/YYYY');
464: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
465: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
466: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
467:
468: p_bind_output_table.EXTEND;

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

461: p_bind_output_table.EXTEND;
462: l_bind_rec.attribute_name := ':PRIOR_PERIOD_START';
463: l_bind_rec.attribute_value := to_char(g_prior_per_start, 'DD/MM/YYYY');
464: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
465: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
466: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
467:
468: p_bind_output_table.EXTEND;
469: l_bind_rec.attribute_name := ':PRIOR_PERIOD_END';

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

467:
468: p_bind_output_table.EXTEND;
469: l_bind_rec.attribute_name := ':PRIOR_PERIOD_END';
470: l_bind_rec.attribute_value := to_char(g_prior_per_end, 'DD/MM/YYYY');
471: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
472: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
473: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
474:
475: p_bind_output_table.EXTEND;

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

468: p_bind_output_table.EXTEND;
469: l_bind_rec.attribute_name := ':PRIOR_PERIOD_END';
470: l_bind_rec.attribute_value := to_char(g_prior_per_end, 'DD/MM/YYYY');
471: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
472: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
473: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
474:
475: p_bind_output_table.EXTEND;
476: l_bind_rec.attribute_name := ':CURR_MONTH_START';

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

474:
475: p_bind_output_table.EXTEND;
476: l_bind_rec.attribute_name := ':CURR_MONTH_START';
477: l_bind_rec.attribute_value := to_char(g_curr_month_start, 'DD/MM/YYYY');
478: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
479: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
480: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
481:
482: p_bind_output_table.EXTEND;

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

475: p_bind_output_table.EXTEND;
476: l_bind_rec.attribute_name := ':CURR_MONTH_START';
477: l_bind_rec.attribute_value := to_char(g_curr_month_start, 'DD/MM/YYYY');
478: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
479: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
480: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
481:
482: p_bind_output_table.EXTEND;
483: l_bind_rec.attribute_name := ':BITAND';

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

481:
482: p_bind_output_table.EXTEND;
483: l_bind_rec.attribute_name := ':BITAND';
484: l_bind_rec.attribute_value := to_char(g_bitand);
485: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
486: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
487: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
488:
489: p_bind_output_table.EXTEND;

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

482: p_bind_output_table.EXTEND;
483: l_bind_rec.attribute_name := ':BITAND';
484: l_bind_rec.attribute_value := to_char(g_bitand);
485: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
486: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
487: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
488:
489: p_bind_output_table.EXTEND;
490: l_bind_rec.attribute_name := ':DSO_BITAND';

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

488:
489: p_bind_output_table.EXTEND;
490: l_bind_rec.attribute_name := ':DSO_BITAND';
491: l_bind_rec.attribute_value := to_char(g_dso_bitand);
492: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
493: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
494: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
495:
496: p_bind_output_table.EXTEND;

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

489: p_bind_output_table.EXTEND;
490: l_bind_rec.attribute_name := ':DSO_BITAND';
491: l_bind_rec.attribute_value := to_char(g_dso_bitand);
492: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
493: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
494: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
495:
496: p_bind_output_table.EXTEND;
497: l_bind_rec.attribute_name := ':BITAND_INC_TODATE';

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

495:
496: p_bind_output_table.EXTEND;
497: l_bind_rec.attribute_name := ':BITAND_INC_TODATE';
498: l_bind_rec.attribute_value := to_char(g_bitand_inc_todate);
499: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
500: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
501: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
502:
503: p_bind_output_table.EXTEND;

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

496: p_bind_output_table.EXTEND;
497: l_bind_rec.attribute_name := ':BITAND_INC_TODATE';
498: l_bind_rec.attribute_value := to_char(g_bitand_inc_todate);
499: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
500: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
501: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
502:
503: p_bind_output_table.EXTEND;
504: l_bind_rec.attribute_name := ':BITAND_ROLLING_30_DAYS';

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

502:
503: p_bind_output_table.EXTEND;
504: l_bind_rec.attribute_name := ':BITAND_ROLLING_30_DAYS';
505: l_bind_rec.attribute_value := to_char(g_bitand_rolling_30_days);
506: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
507: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
508: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
509:
510: p_bind_output_table.EXTEND;

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

503: p_bind_output_table.EXTEND;
504: l_bind_rec.attribute_name := ':BITAND_ROLLING_30_DAYS';
505: l_bind_rec.attribute_value := to_char(g_bitand_rolling_30_days);
506: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
507: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
508: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
509:
510: p_bind_output_table.EXTEND;
511: l_bind_rec.attribute_name := ':SELF_MSG';

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

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

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

510: p_bind_output_table.EXTEND;
511: l_bind_rec.attribute_name := ':SELF_MSG';
512: l_bind_rec.attribute_value := to_char(g_self_msg);
513: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
514: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
515: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
516:
517:
518: p_bind_output_table.EXTEND;

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

517:
518: p_bind_output_table.EXTEND;
519: l_bind_rec.attribute_name := ':CURR_SUFIX';
520: l_bind_rec.attribute_value := to_char(g_curr_suffix);
521: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
522: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
523: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
524:
525: p_bind_output_table.EXTEND;

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

518: p_bind_output_table.EXTEND;
519: l_bind_rec.attribute_name := ':CURR_SUFIX';
520: l_bind_rec.attribute_value := to_char(g_curr_suffix);
521: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
522: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
523: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
524:
525: p_bind_output_table.EXTEND;
526: l_bind_rec.attribute_name := ':DSO_PERIOD';

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

524:
525: p_bind_output_table.EXTEND;
526: l_bind_rec.attribute_name := ':DSO_PERIOD';
527: l_bind_rec.attribute_value := to_char(g_dso_period);
528: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
529: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
530: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
531:
532: p_bind_output_table.EXTEND;

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

525: p_bind_output_table.EXTEND;
526: l_bind_rec.attribute_name := ':DSO_PERIOD';
527: l_bind_rec.attribute_value := to_char(g_dso_period);
528: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
529: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
530: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
531:
532: p_bind_output_table.EXTEND;
533: l_bind_rec.attribute_name := ':SD_PRIOR';

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

531:
532: p_bind_output_table.EXTEND;
533: l_bind_rec.attribute_name := ':SD_PRIOR';
534: l_bind_rec.attribute_value := to_char(g_sd_prior, 'DD/MM/YYYY');
535: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
536: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
537: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
538:
539: p_bind_output_table.EXTEND;

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

532: p_bind_output_table.EXTEND;
533: l_bind_rec.attribute_name := ':SD_PRIOR';
534: l_bind_rec.attribute_value := to_char(g_sd_prior, 'DD/MM/YYYY');
535: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
536: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
537: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
538:
539: p_bind_output_table.EXTEND;
540: l_bind_rec.attribute_name := ':SD_PRIOR_PRIOR';

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

538:
539: p_bind_output_table.EXTEND;
540: l_bind_rec.attribute_name := ':SD_PRIOR_PRIOR';
541: l_bind_rec.attribute_value := to_char(g_sd_prior_prior, 'DD/MM/YYYY');
542: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
543: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
544: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
545:
546: p_bind_output_table.EXTEND;

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

539: p_bind_output_table.EXTEND;
540: l_bind_rec.attribute_name := ':SD_PRIOR_PRIOR';
541: l_bind_rec.attribute_value := to_char(g_sd_prior_prior, 'DD/MM/YYYY');
542: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
543: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
544: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
545:
546: p_bind_output_table.EXTEND;
547: l_bind_rec.attribute_name := ':SD_SDATE';

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

545:
546: p_bind_output_table.EXTEND;
547: l_bind_rec.attribute_name := ':SD_SDATE';
548: l_bind_rec.attribute_value := to_char(g_sd_curr_sdate, 'DD/MM/YYYY');
549: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
550: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
551: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
552:
553: p_bind_output_table.EXTEND;

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

546: p_bind_output_table.EXTEND;
547: l_bind_rec.attribute_name := ':SD_SDATE';
548: l_bind_rec.attribute_value := to_char(g_sd_curr_sdate, 'DD/MM/YYYY');
549: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
550: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
551: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
552:
553: p_bind_output_table.EXTEND;
554: l_bind_rec.attribute_name := ':CASH_RECEIPT_ID';

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

552:
553: p_bind_output_table.EXTEND;
554: l_bind_rec.attribute_name := ':CASH_RECEIPT_ID';
555: l_bind_rec.attribute_value := to_char(g_cash_receipt_id);
556: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
557: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
558: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
559:
560: p_bind_output_table.EXTEND;

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

553: p_bind_output_table.EXTEND;
554: l_bind_rec.attribute_name := ':CASH_RECEIPT_ID';
555: l_bind_rec.attribute_value := to_char(g_cash_receipt_id);
556: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
557: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
558: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
559:
560: p_bind_output_table.EXTEND;
561: l_bind_rec.attribute_name := ':CUST_TRX_ID';

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

559:
560: p_bind_output_table.EXTEND;
561: l_bind_rec.attribute_name := ':CUST_TRX_ID';
562: l_bind_rec.attribute_value := to_char(g_cust_trx_id);
563: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
564: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
565: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
566:
567: p_bind_output_table.EXTEND;

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

560: p_bind_output_table.EXTEND;
561: l_bind_rec.attribute_name := ':CUST_TRX_ID';
562: l_bind_rec.attribute_value := to_char(g_cust_trx_id);
563: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
564: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
565: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
566:
567: p_bind_output_table.EXTEND;
568: l_bind_rec.attribute_name := ':TRAN_NUM';

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

566:
567: p_bind_output_table.EXTEND;
568: l_bind_rec.attribute_name := ':TRAN_NUM';
569: l_bind_rec.attribute_value := to_char(g_tran_num);
570: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
571: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
572: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
573:
574: p_bind_output_table.EXTEND;

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

567: p_bind_output_table.EXTEND;
568: l_bind_rec.attribute_name := ':TRAN_NUM';
569: l_bind_rec.attribute_value := to_char(g_tran_num);
570: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
571: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
572: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
573:
574: p_bind_output_table.EXTEND;
575: l_bind_rec.attribute_name := ':TRAN_CLASS';

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

573:
574: p_bind_output_table.EXTEND;
575: l_bind_rec.attribute_name := ':TRAN_CLASS';
576: l_bind_rec.attribute_value := to_char(g_tran_class);
577: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
578: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
579: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
580:
581: p_bind_output_table.EXTEND;

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

574: p_bind_output_table.EXTEND;
575: l_bind_rec.attribute_name := ':TRAN_CLASS';
576: l_bind_rec.attribute_value := to_char(g_tran_class);
577: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
578: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
579: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
580:
581: p_bind_output_table.EXTEND;
582: l_bind_rec.attribute_name := ':CUST_ACCOUNT';

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

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

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

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

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

587:
588: p_bind_output_table.EXTEND;
589: l_bind_rec.attribute_name := ':APP_CUST_TRX_ID';
590: l_bind_rec.attribute_value := to_char(g_app_cust_trx_id);
591: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
592: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
593: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
594:
595: p_bind_output_table.EXTEND;

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

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

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

594:
595: p_bind_output_table.EXTEND;
596: l_bind_rec.attribute_name := ':PAGE_REFRESH_DATE';
597: l_bind_rec.attribute_value := to_char(g_page_refresh_date, 'DD/MM/YYYY');
598: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
599: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
600: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
601:
602: END bind_variable;

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

595: p_bind_output_table.EXTEND;
596: l_bind_rec.attribute_name := ':PAGE_REFRESH_DATE';
597: l_bind_rec.attribute_value := to_char(g_page_refresh_date, 'DD/MM/YYYY');
598: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
599: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
600: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
601:
602: END bind_variable;
603: