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.IBE_BI_ORD_GRAPH_PVT dependencies on BIS_PMV_PARAMETERS_PUB

Line 49: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;

45: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'ibe.plsql.dbi.ibe_bi_ord_graph_pvt.get_order_graph_sql.begin','BEGIN');
46: END IF;
47: -- initilization of variables
48:
49: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
50: l_g_p := '''FII_GLOBAL1''';
51: l_g_s := '''FII_GLOBAL2''';
52:
53: FOR i IN p_pmv_parameters.FIRST..p_pmv_parameters.LAST

Line 411: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

407: x_custom_output.EXTEND(13);
408:
409: l_custom_rec.attribute_name := ':l_sequence';
410: l_custom_rec.attribute_value := l_sequence;
411: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
412: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
413:
414: x_custom_output(1) := l_custom_rec;
415:

Line 412: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;

408:
409: l_custom_rec.attribute_name := ':l_sequence';
410: l_custom_rec.attribute_value := l_sequence;
411: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
412: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
413:
414: x_custom_output(1) := l_custom_rec;
415:
416: l_custom_rec.attribute_name := ':l_record_type_id' ;

Line 418: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

414: x_custom_output(1) := l_custom_rec;
415:
416: l_custom_rec.attribute_name := ':l_record_type_id' ;
417: l_custom_rec.attribute_value:= l_record_type_id;
418: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
419: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
420:
421: x_custom_output(2) := l_custom_rec;
422:

Line 419: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;

415:
416: l_custom_rec.attribute_name := ':l_record_type_id' ;
417: l_custom_rec.attribute_value:= l_record_type_id;
418: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
419: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
420:
421: x_custom_output(2) := l_custom_rec;
422:
423: l_custom_rec.attribute_name := ':l_prev_start' ;

Line 425: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

421: x_custom_output(2) := l_custom_rec;
422:
423: l_custom_rec.attribute_name := ':l_prev_start' ;
424: l_custom_rec.attribute_value:= to_char(l_prev_start,'dd/mm/yyyy');
425: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
426: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
427:
428: x_custom_output(3) := l_custom_rec;
429:

Line 426: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;

422:
423: l_custom_rec.attribute_name := ':l_prev_start' ;
424: l_custom_rec.attribute_value:= to_char(l_prev_start,'dd/mm/yyyy');
425: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
426: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
427:
428: x_custom_output(3) := l_custom_rec;
429:
430: l_custom_rec.attribute_name := ':l_cur_start' ;

Line 432: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

428: x_custom_output(3) := l_custom_rec;
429:
430: l_custom_rec.attribute_name := ':l_cur_start' ;
431: l_custom_rec.attribute_value:= to_char(l_cur_start,'dd/mm/yyyy');
432: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
433: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
434:
435: x_custom_output(4) := l_custom_rec;
436:

Line 433: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;

429:
430: l_custom_rec.attribute_name := ':l_cur_start' ;
431: l_custom_rec.attribute_value:= to_char(l_cur_start,'dd/mm/yyyy');
432: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
433: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
434:
435: x_custom_output(4) := l_custom_rec;
436:
437: l_custom_rec.attribute_name := ':l_prev_year' ;

Line 439: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

435: x_custom_output(4) := l_custom_rec;
436:
437: l_custom_rec.attribute_name := ':l_prev_year' ;
438: l_custom_rec.attribute_value:= l_prev_year;
439: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
440: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
441:
442: x_custom_output(5) := l_custom_rec;
443:

Line 440: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;

436:
437: l_custom_rec.attribute_name := ':l_prev_year' ;
438: l_custom_rec.attribute_value:= l_prev_year;
439: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
440: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
441:
442: x_custom_output(5) := l_custom_rec;
443:
444: l_custom_rec.attribute_name := ':l_cur_year' ;

Line 446: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

442: x_custom_output(5) := l_custom_rec;
443:
444: l_custom_rec.attribute_name := ':l_cur_year' ;
445: l_custom_rec.attribute_value:= l_cur_year;
446: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
447: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
448:
449: x_custom_output(6) := l_custom_rec;
450:

Line 447: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;

443:
444: l_custom_rec.attribute_name := ':l_cur_year' ;
445: l_custom_rec.attribute_value:= l_cur_year;
446: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
447: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
448:
449: x_custom_output(6) := l_custom_rec;
450:
451: l_custom_rec.attribute_name := ':l_timespan' ;

Line 453: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

449: x_custom_output(6) := l_custom_rec;
450:
451: l_custom_rec.attribute_name := ':l_timespan' ;
452: l_custom_rec.attribute_value:= l_timespan;
453: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
454: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
455:
456: x_custom_output(7) := l_custom_rec;
457:

Line 454: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;

450:
451: l_custom_rec.attribute_name := ':l_timespan' ;
452: l_custom_rec.attribute_value:= l_timespan;
453: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
454: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
455:
456: x_custom_output(7) := l_custom_rec;
457:
458:

Line 461: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

457:
458:
459: l_custom_rec.attribute_name := ':l_mid_start' ;
460: l_custom_rec.attribute_value:= to_char(l_mid_start,'dd/mm/yyyy');
461: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
462: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
463:
464: x_custom_output(8) := l_custom_rec;
465:

Line 462: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;

458:
459: l_custom_rec.attribute_name := ':l_mid_start' ;
460: l_custom_rec.attribute_value:= to_char(l_mid_start,'dd/mm/yyyy');
461: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
462: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
463:
464: x_custom_output(8) := l_custom_rec;
465:
466: l_custom_rec.attribute_name := ':l_pprev_start' ;

Line 468: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

464: x_custom_output(8) := l_custom_rec;
465:
466: l_custom_rec.attribute_name := ':l_pprev_start' ;
467: l_custom_rec.attribute_value:= to_char(l_pprev_start,'dd/mm/yyyy');
468: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
469: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
470:
471: x_custom_output(9) := l_custom_rec;
472:

Line 469: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;

465:
466: l_custom_rec.attribute_name := ':l_pprev_start' ;
467: l_custom_rec.attribute_value:= to_char(l_pprev_start,'dd/mm/yyyy');
468: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
469: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
470:
471: x_custom_output(9) := l_custom_rec;
472:
473:

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

472:
473:
474: l_custom_rec.attribute_name := ':l_pcur_start' ;
475: l_custom_rec.attribute_value:= to_char(l_pcur_start,'dd/mm/yyyy');
476: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
477: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
478:
479: x_custom_output(10) := l_custom_rec;
480:

Line 477: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;

473:
474: l_custom_rec.attribute_name := ':l_pcur_start' ;
475: l_custom_rec.attribute_value:= to_char(l_pcur_start,'dd/mm/yyyy');
476: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
477: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
478:
479: x_custom_output(10) := l_custom_rec;
480:
481: l_custom_rec.attribute_name := ':l_currency_code' ;

Line 483: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

479: x_custom_output(10) := l_custom_rec;
480:
481: l_custom_rec.attribute_name := ':l_currency_code' ;
482: l_custom_rec.attribute_value:= l_currency_code;
483: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
484: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
485:
486: x_custom_output(11) := l_custom_rec;
487:

Line 484: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

480:
481: l_custom_rec.attribute_name := ':l_currency_code' ;
482: l_custom_rec.attribute_value:= l_currency_code;
483: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
484: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
485:
486: x_custom_output(11) := l_custom_rec;
487:
488: l_custom_rec.attribute_name := ':l_g_p' ;

Line 490: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

486: x_custom_output(11) := l_custom_rec;
487:
488: l_custom_rec.attribute_name := ':l_g_p' ;
489: l_custom_rec.attribute_value:= l_g_p;
490: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
491: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
492:
493: x_custom_output(12) := l_custom_rec;
494:

Line 491: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

487:
488: l_custom_rec.attribute_name := ':l_g_p' ;
489: l_custom_rec.attribute_value:= l_g_p;
490: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
491: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
492:
493: x_custom_output(12) := l_custom_rec;
494:
495: l_custom_rec.attribute_name := ':l_g_s' ;

Line 497: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

493: x_custom_output(12) := l_custom_rec;
494:
495: l_custom_rec.attribute_name := ':l_g_s' ;
496: l_custom_rec.attribute_value:= l_g_s;
497: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
498: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
499:
500: x_custom_output(13) := l_custom_rec;
501:

Line 498: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

494:
495: l_custom_rec.attribute_name := ':l_g_s' ;
496: l_custom_rec.attribute_value:= l_g_s;
497: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
498: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
499:
500: x_custom_output(13) := l_custom_rec;
501:
502: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 556: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;

552: END IF;
553:
554: -- initilization of variables
555:
556: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
557: l_g_p := '''FII_GLOBAL1''';
558: l_g_s := '''FII_GLOBAL2''';
559:
560: FOR i IN p_pmv_parameters.FIRST..p_pmv_parameters.LAST

Line 970: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

966: x_custom_output.EXTEND(13);
967:
968: l_custom_rec.attribute_name := ':l_sequence';
969: l_custom_rec.attribute_value := l_sequence;
970: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
971: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
972:
973: x_custom_output(1) := l_custom_rec;
974:

Line 971: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;

967:
968: l_custom_rec.attribute_name := ':l_sequence';
969: l_custom_rec.attribute_value := l_sequence;
970: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
971: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
972:
973: x_custom_output(1) := l_custom_rec;
974:
975: l_custom_rec.attribute_name := ':l_record_type_id' ;

Line 977: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

973: x_custom_output(1) := l_custom_rec;
974:
975: l_custom_rec.attribute_name := ':l_record_type_id' ;
976: l_custom_rec.attribute_value:= l_record_type_id;
977: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
978: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
979:
980: x_custom_output(2) := l_custom_rec;
981:

Line 978: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;

974:
975: l_custom_rec.attribute_name := ':l_record_type_id' ;
976: l_custom_rec.attribute_value:= l_record_type_id;
977: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
978: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
979:
980: x_custom_output(2) := l_custom_rec;
981:
982: l_custom_rec.attribute_name := ':l_prev_start' ;

Line 984: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

980: x_custom_output(2) := l_custom_rec;
981:
982: l_custom_rec.attribute_name := ':l_prev_start' ;
983: l_custom_rec.attribute_value:= to_char(l_prev_start,'dd/mm/yyyy');
984: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
985: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
986:
987: x_custom_output(3) := l_custom_rec;
988:

Line 985: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;

981:
982: l_custom_rec.attribute_name := ':l_prev_start' ;
983: l_custom_rec.attribute_value:= to_char(l_prev_start,'dd/mm/yyyy');
984: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
985: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
986:
987: x_custom_output(3) := l_custom_rec;
988:
989: l_custom_rec.attribute_name := ':l_cur_start' ;

Line 991: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

987: x_custom_output(3) := l_custom_rec;
988:
989: l_custom_rec.attribute_name := ':l_cur_start' ;
990: l_custom_rec.attribute_value:= to_char(l_cur_start,'dd/mm/yyyy');
991: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
992: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
993:
994: x_custom_output(4) := l_custom_rec;
995:

Line 992: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;

988:
989: l_custom_rec.attribute_name := ':l_cur_start' ;
990: l_custom_rec.attribute_value:= to_char(l_cur_start,'dd/mm/yyyy');
991: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
992: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
993:
994: x_custom_output(4) := l_custom_rec;
995:
996: l_custom_rec.attribute_name := ':l_prev_year' ;

Line 998: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

994: x_custom_output(4) := l_custom_rec;
995:
996: l_custom_rec.attribute_name := ':l_prev_year' ;
997: l_custom_rec.attribute_value:= l_prev_year;
998: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
999: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
1000:
1001: x_custom_output(5) := l_custom_rec;
1002:

Line 999: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;

995:
996: l_custom_rec.attribute_name := ':l_prev_year' ;
997: l_custom_rec.attribute_value:= l_prev_year;
998: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
999: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
1000:
1001: x_custom_output(5) := l_custom_rec;
1002:
1003: l_custom_rec.attribute_name := ':l_cur_year' ;

Line 1005: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

1001: x_custom_output(5) := l_custom_rec;
1002:
1003: l_custom_rec.attribute_name := ':l_cur_year' ;
1004: l_custom_rec.attribute_value:= l_cur_year;
1005: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1006: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
1007:
1008: x_custom_output(6) := l_custom_rec;
1009:

Line 1006: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;

1002:
1003: l_custom_rec.attribute_name := ':l_cur_year' ;
1004: l_custom_rec.attribute_value:= l_cur_year;
1005: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1006: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
1007:
1008: x_custom_output(6) := l_custom_rec;
1009:
1010: l_custom_rec.attribute_name := ':l_timespan' ;

Line 1012: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

1008: x_custom_output(6) := l_custom_rec;
1009:
1010: l_custom_rec.attribute_name := ':l_timespan' ;
1011: l_custom_rec.attribute_value:= l_timespan;
1012: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1013: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
1014:
1015: x_custom_output(7) := l_custom_rec;
1016:

Line 1013: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;

1009:
1010: l_custom_rec.attribute_name := ':l_timespan' ;
1011: l_custom_rec.attribute_value:= l_timespan;
1012: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1013: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
1014:
1015: x_custom_output(7) := l_custom_rec;
1016:
1017: l_custom_rec.attribute_name := ':l_mid_start' ;

Line 1019: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

1015: x_custom_output(7) := l_custom_rec;
1016:
1017: l_custom_rec.attribute_name := ':l_mid_start' ;
1018: l_custom_rec.attribute_value:= to_char(l_mid_start,'dd/mm/yyyy');
1019: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1020: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
1021:
1022: x_custom_output(8) := l_custom_rec;
1023:

Line 1020: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;

1016:
1017: l_custom_rec.attribute_name := ':l_mid_start' ;
1018: l_custom_rec.attribute_value:= to_char(l_mid_start,'dd/mm/yyyy');
1019: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1020: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
1021:
1022: x_custom_output(8) := l_custom_rec;
1023:
1024: l_custom_rec.attribute_name := ':l_pprev_start' ;

Line 1026: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

1022: x_custom_output(8) := l_custom_rec;
1023:
1024: l_custom_rec.attribute_name := ':l_pprev_start' ;
1025: l_custom_rec.attribute_value:= to_char(l_pprev_start,'dd/mm/yyyy');
1026: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1027: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
1028:
1029: x_custom_output(9) := l_custom_rec;
1030:

Line 1027: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;

1023:
1024: l_custom_rec.attribute_name := ':l_pprev_start' ;
1025: l_custom_rec.attribute_value:= to_char(l_pprev_start,'dd/mm/yyyy');
1026: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1027: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
1028:
1029: x_custom_output(9) := l_custom_rec;
1030:
1031:

Line 1034: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

1030:
1031:
1032: l_custom_rec.attribute_name := ':l_pcur_start' ;
1033: l_custom_rec.attribute_value:= to_char(l_pcur_start,'dd/mm/yyyy');
1034: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1035: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
1036:
1037: x_custom_output(10) := l_custom_rec;
1038:

Line 1035: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;

1031:
1032: l_custom_rec.attribute_name := ':l_pcur_start' ;
1033: l_custom_rec.attribute_value:= to_char(l_pcur_start,'dd/mm/yyyy');
1034: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1035: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
1036:
1037: x_custom_output(10) := l_custom_rec;
1038:
1039: l_custom_rec.attribute_name := ':l_currency_code' ;

Line 1041: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

1037: x_custom_output(10) := l_custom_rec;
1038:
1039: l_custom_rec.attribute_name := ':l_currency_code' ;
1040: l_custom_rec.attribute_value:= l_currency_code;
1041: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1042: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1043:
1044: x_custom_output(11) := l_custom_rec;
1045:

Line 1042: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

1038:
1039: l_custom_rec.attribute_name := ':l_currency_code' ;
1040: l_custom_rec.attribute_value:= l_currency_code;
1041: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1042: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1043:
1044: x_custom_output(11) := l_custom_rec;
1045:
1046: l_custom_rec.attribute_name := ':l_g_p' ;

Line 1048: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

1044: x_custom_output(11) := l_custom_rec;
1045:
1046: l_custom_rec.attribute_name := ':l_g_p' ;
1047: l_custom_rec.attribute_value:= l_g_p;
1048: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1049: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1050:
1051: x_custom_output(12) := l_custom_rec;
1052:

Line 1049: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

1045:
1046: l_custom_rec.attribute_name := ':l_g_p' ;
1047: l_custom_rec.attribute_value:= l_g_p;
1048: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1049: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1050:
1051: x_custom_output(12) := l_custom_rec;
1052:
1053: l_custom_rec.attribute_name := ':l_g_s' ;

Line 1055: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

1051: x_custom_output(12) := l_custom_rec;
1052:
1053: l_custom_rec.attribute_name := ':l_g_s' ;
1054: l_custom_rec.attribute_value:= l_g_s;
1055: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1056: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1057:
1058: x_custom_output(13) := l_custom_rec;
1059:

Line 1056: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

1052:
1053: l_custom_rec.attribute_name := ':l_g_s' ;
1054: l_custom_rec.attribute_value:= l_g_s;
1055: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1056: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1057:
1058: x_custom_output(13) := l_custom_rec;
1059:
1060: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1117: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;

1113: END IF;
1114:
1115: -- initilization of variables
1116:
1117: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
1118: l_g_p := '''FII_GLOBAL1''';
1119: l_g_s := '''FII_GLOBAL2''';
1120:
1121: FOR i IN p_pmv_parameters.FIRST..p_pmv_parameters.LAST

Line 1527: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

1523: x_custom_output.EXTEND(13);
1524:
1525: l_custom_rec.attribute_name := ':l_sequence';
1526: l_custom_rec.attribute_value := l_sequence;
1527: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1528: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
1529:
1530: x_custom_output(1) := l_custom_rec;
1531:

Line 1528: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;

1524:
1525: l_custom_rec.attribute_name := ':l_sequence';
1526: l_custom_rec.attribute_value := l_sequence;
1527: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1528: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
1529:
1530: x_custom_output(1) := l_custom_rec;
1531:
1532: l_custom_rec.attribute_name := ':l_record_type_id' ;

Line 1534: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

1530: x_custom_output(1) := l_custom_rec;
1531:
1532: l_custom_rec.attribute_name := ':l_record_type_id' ;
1533: l_custom_rec.attribute_value:= l_record_type_id;
1534: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1535: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
1536:
1537: x_custom_output(2) := l_custom_rec;
1538:

Line 1535: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;

1531:
1532: l_custom_rec.attribute_name := ':l_record_type_id' ;
1533: l_custom_rec.attribute_value:= l_record_type_id;
1534: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1535: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
1536:
1537: x_custom_output(2) := l_custom_rec;
1538:
1539: l_custom_rec.attribute_name := ':l_prev_start' ;

Line 1541: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

1537: x_custom_output(2) := l_custom_rec;
1538:
1539: l_custom_rec.attribute_name := ':l_prev_start' ;
1540: l_custom_rec.attribute_value:= to_char(l_prev_start,'dd/mm/yyyy');
1541: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1542: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
1543:
1544: x_custom_output(3) := l_custom_rec;
1545:

Line 1542: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;

1538:
1539: l_custom_rec.attribute_name := ':l_prev_start' ;
1540: l_custom_rec.attribute_value:= to_char(l_prev_start,'dd/mm/yyyy');
1541: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1542: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
1543:
1544: x_custom_output(3) := l_custom_rec;
1545:
1546: l_custom_rec.attribute_name := ':l_cur_start' ;

Line 1548: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

1544: x_custom_output(3) := l_custom_rec;
1545:
1546: l_custom_rec.attribute_name := ':l_cur_start' ;
1547: l_custom_rec.attribute_value:= to_char(l_cur_start,'dd/mm/yyyy');
1548: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1549: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
1550:
1551: x_custom_output(4) := l_custom_rec;
1552:

Line 1549: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;

1545:
1546: l_custom_rec.attribute_name := ':l_cur_start' ;
1547: l_custom_rec.attribute_value:= to_char(l_cur_start,'dd/mm/yyyy');
1548: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1549: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
1550:
1551: x_custom_output(4) := l_custom_rec;
1552:
1553: l_custom_rec.attribute_name := ':l_prev_year' ;

Line 1555: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

1551: x_custom_output(4) := l_custom_rec;
1552:
1553: l_custom_rec.attribute_name := ':l_prev_year' ;
1554: l_custom_rec.attribute_value:= l_prev_year;
1555: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1556: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
1557:
1558: x_custom_output(5) := l_custom_rec;
1559:

Line 1556: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;

1552:
1553: l_custom_rec.attribute_name := ':l_prev_year' ;
1554: l_custom_rec.attribute_value:= l_prev_year;
1555: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1556: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
1557:
1558: x_custom_output(5) := l_custom_rec;
1559:
1560: l_custom_rec.attribute_name := ':l_cur_year' ;

Line 1562: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

1558: x_custom_output(5) := l_custom_rec;
1559:
1560: l_custom_rec.attribute_name := ':l_cur_year' ;
1561: l_custom_rec.attribute_value:= l_cur_year;
1562: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1563: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
1564:
1565: x_custom_output(6) := l_custom_rec;
1566:

Line 1563: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;

1559:
1560: l_custom_rec.attribute_name := ':l_cur_year' ;
1561: l_custom_rec.attribute_value:= l_cur_year;
1562: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1563: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
1564:
1565: x_custom_output(6) := l_custom_rec;
1566:
1567: l_custom_rec.attribute_name := ':l_timespan' ;

Line 1569: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

1565: x_custom_output(6) := l_custom_rec;
1566:
1567: l_custom_rec.attribute_name := ':l_timespan' ;
1568: l_custom_rec.attribute_value:= l_timespan;
1569: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1570: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
1571:
1572: x_custom_output(7) := l_custom_rec;
1573:

Line 1570: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;

1566:
1567: l_custom_rec.attribute_name := ':l_timespan' ;
1568: l_custom_rec.attribute_value:= l_timespan;
1569: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1570: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
1571:
1572: x_custom_output(7) := l_custom_rec;
1573:
1574:

Line 1577: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

1573:
1574:
1575: l_custom_rec.attribute_name := ':l_mid_start' ;
1576: l_custom_rec.attribute_value:= to_char(l_mid_start,'dd/mm/yyyy');
1577: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1578: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
1579:
1580: x_custom_output(8) := l_custom_rec;
1581:

Line 1578: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;

1574:
1575: l_custom_rec.attribute_name := ':l_mid_start' ;
1576: l_custom_rec.attribute_value:= to_char(l_mid_start,'dd/mm/yyyy');
1577: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1578: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
1579:
1580: x_custom_output(8) := l_custom_rec;
1581:
1582: l_custom_rec.attribute_name := ':l_pprev_start' ;

Line 1584: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

1580: x_custom_output(8) := l_custom_rec;
1581:
1582: l_custom_rec.attribute_name := ':l_pprev_start' ;
1583: l_custom_rec.attribute_value:= to_char(l_pprev_start,'dd/mm/yyyy');
1584: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1585: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
1586:
1587: x_custom_output(9) := l_custom_rec;
1588:

Line 1585: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;

1581:
1582: l_custom_rec.attribute_name := ':l_pprev_start' ;
1583: l_custom_rec.attribute_value:= to_char(l_pprev_start,'dd/mm/yyyy');
1584: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1585: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
1586:
1587: x_custom_output(9) := l_custom_rec;
1588:
1589:

Line 1592: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

1588:
1589:
1590: l_custom_rec.attribute_name := ':l_pcur_start' ;
1591: l_custom_rec.attribute_value:= to_char(l_pcur_start,'dd/mm/yyyy');
1592: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1593: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
1594:
1595: x_custom_output(10) := l_custom_rec;
1596:

Line 1593: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;

1589:
1590: l_custom_rec.attribute_name := ':l_pcur_start' ;
1591: l_custom_rec.attribute_value:= to_char(l_pcur_start,'dd/mm/yyyy');
1592: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1593: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
1594:
1595: x_custom_output(10) := l_custom_rec;
1596:
1597: l_custom_rec.attribute_name := ':l_c_d' ;

Line 1599: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

1595: x_custom_output(10) := l_custom_rec;
1596:
1597: l_custom_rec.attribute_name := ':l_c_d' ;
1598: l_custom_rec.attribute_value:= l_c_d;
1599: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1600: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1601:
1602: x_custom_output(11) := l_custom_rec;
1603:

Line 1600: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

1596:
1597: l_custom_rec.attribute_name := ':l_c_d' ;
1598: l_custom_rec.attribute_value:= l_c_d;
1599: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1600: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1601:
1602: x_custom_output(11) := l_custom_rec;
1603:
1604: l_custom_rec.attribute_name := ':l_g_p' ;

Line 1606: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

1602: x_custom_output(11) := l_custom_rec;
1603:
1604: l_custom_rec.attribute_name := ':l_g_p' ;
1605: l_custom_rec.attribute_value:= l_g_p;
1606: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1607: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1608:
1609: x_custom_output(12) := l_custom_rec;
1610:

Line 1607: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

1603:
1604: l_custom_rec.attribute_name := ':l_g_p' ;
1605: l_custom_rec.attribute_value:= l_g_p;
1606: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1607: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1608:
1609: x_custom_output(12) := l_custom_rec;
1610:
1611: l_custom_rec.attribute_name := ':l_g_s' ;

Line 1613: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

1609: x_custom_output(12) := l_custom_rec;
1610:
1611: l_custom_rec.attribute_name := ':l_g_s' ;
1612: l_custom_rec.attribute_value:= l_g_s;
1613: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1614: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1615:
1616: x_custom_output(13) := l_custom_rec;
1617:

Line 1614: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

1610:
1611: l_custom_rec.attribute_name := ':l_g_s' ;
1612: l_custom_rec.attribute_value:= l_g_s;
1613: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1614: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1615:
1616: x_custom_output(13) := l_custom_rec;
1617:
1618: