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

Line 156: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

152: l_media VARCHAR2(300);
153: BEGIN
154:
155: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
156: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
157: bim_pmv_dbi_utl_pkg.get_bim_page_params(p_page_parameter_tbl,
158: l_as_of_date,
159: l_period_type,
160: l_record_type_id,

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

569:
570: x_custom_sql := l_sqltext;
571: l_custom_rec.attribute_name := ':l_record_type';
572: l_custom_rec.attribute_value := l_record_type_id;
573: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
574: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
575: x_custom_output.EXTEND;
576: x_custom_output(1) := l_custom_rec;
577:

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

570: x_custom_sql := l_sqltext;
571: l_custom_rec.attribute_name := ':l_record_type';
572: l_custom_rec.attribute_value := l_record_type_id;
573: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
574: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
575: x_custom_output.EXTEND;
576: x_custom_output(1) := l_custom_rec;
577:
578: l_custom_rec.attribute_name := ':l_resource_id';

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

576: x_custom_output(1) := l_custom_rec;
577:
578: l_custom_rec.attribute_name := ':l_resource_id';
579: l_custom_rec.attribute_value := GET_RESOURCE_ID;
580: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
581: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
582: x_custom_output.EXTEND;
583: x_custom_output(2) := l_custom_rec;
584:

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

577:
578: l_custom_rec.attribute_name := ':l_resource_id';
579: l_custom_rec.attribute_value := GET_RESOURCE_ID;
580: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
581: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
582: x_custom_output.EXTEND;
583: x_custom_output(2) := l_custom_rec;
584:
585: l_custom_rec.attribute_name := ':l_admin_flag';

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

583: x_custom_output(2) := l_custom_rec;
584:
585: l_custom_rec.attribute_name := ':l_admin_flag';
586: l_custom_rec.attribute_value := GET_ADMIN_STATUS;
587: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
588: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
589: x_custom_output.EXTEND;
590: x_custom_output(3) := l_custom_rec;
591:

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

584:
585: l_custom_rec.attribute_name := ':l_admin_flag';
586: l_custom_rec.attribute_value := GET_ADMIN_STATUS;
587: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
588: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
589: x_custom_output.EXTEND;
590: x_custom_output(3) := l_custom_rec;
591:
592: l_custom_rec.attribute_name := ':l_country';

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

590: x_custom_output(3) := l_custom_rec;
591:
592: l_custom_rec.attribute_name := ':l_country';
593: l_custom_rec.attribute_value := l_country;
594: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
595: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
596: x_custom_output.EXTEND;
597: x_custom_output(4) := l_custom_rec;
598:

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

591:
592: l_custom_rec.attribute_name := ':l_country';
593: l_custom_rec.attribute_value := l_country;
594: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
595: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
596: x_custom_output.EXTEND;
597: x_custom_output(4) := l_custom_rec;
598:
599: l_custom_rec.attribute_name := ':l_cat_id';

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

597: x_custom_output(4) := l_custom_rec;
598:
599: l_custom_rec.attribute_name := ':l_cat_id';
600: l_custom_rec.attribute_value := l_cat_id;
601: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
602: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
603: x_custom_output.EXTEND;
604: x_custom_output(5) := l_custom_rec;
605:

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

598:
599: l_custom_rec.attribute_name := ':l_cat_id';
600: l_custom_rec.attribute_value := l_cat_id;
601: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
602: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
603: x_custom_output.EXTEND;
604: x_custom_output(5) := l_custom_rec;
605:
606: write_debug('MKTG KPI SQL','QUERY','test',l_sqltext,NULL,null);

Line 677: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

673: where source_code_id=replace(l_campaign_id,'''');
674:
675: BEGIN
676: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
677: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
678: bim_pmv_dbi_utl_pkg.get_bim_page_params(p_page_parameter_tbl,
679: l_as_of_date,
680: l_period_type,
681: l_record_type_id,

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

3463: END IF;
3464: x_custom_sql := l_sqltext;
3465: l_custom_rec.attribute_name := ':l_record_type';
3466: l_custom_rec.attribute_value := l_record_type_id;
3467: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
3468: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
3469: x_custom_output.EXTEND;
3470: x_custom_output(1) := l_custom_rec;
3471:

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

3464: x_custom_sql := l_sqltext;
3465: l_custom_rec.attribute_name := ':l_record_type';
3466: l_custom_rec.attribute_value := l_record_type_id;
3467: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
3468: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
3469: x_custom_output.EXTEND;
3470: x_custom_output(1) := l_custom_rec;
3471:
3472: l_custom_rec.attribute_name := ':l_resource_id';

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

3470: x_custom_output(1) := l_custom_rec;
3471:
3472: l_custom_rec.attribute_name := ':l_resource_id';
3473: l_custom_rec.attribute_value := GET_RESOURCE_ID;
3474: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
3475: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
3476: x_custom_output.EXTEND;
3477: x_custom_output(2) := l_custom_rec;
3478:

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

3471:
3472: l_custom_rec.attribute_name := ':l_resource_id';
3473: l_custom_rec.attribute_value := GET_RESOURCE_ID;
3474: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
3475: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
3476: x_custom_output.EXTEND;
3477: x_custom_output(2) := l_custom_rec;
3478:
3479: l_custom_rec.attribute_name := ':l_admin_flag';

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

3477: x_custom_output(2) := l_custom_rec;
3478:
3479: l_custom_rec.attribute_name := ':l_admin_flag';
3480: l_custom_rec.attribute_value := GET_ADMIN_STATUS;
3481: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
3482: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
3483: x_custom_output.EXTEND;
3484: x_custom_output(3) := l_custom_rec;
3485:

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

3478:
3479: l_custom_rec.attribute_name := ':l_admin_flag';
3480: l_custom_rec.attribute_value := GET_ADMIN_STATUS;
3481: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
3482: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
3483: x_custom_output.EXTEND;
3484: x_custom_output(3) := l_custom_rec;
3485:
3486: l_custom_rec.attribute_name := ':l_country';

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

3484: x_custom_output(3) := l_custom_rec;
3485:
3486: l_custom_rec.attribute_name := ':l_country';
3487: l_custom_rec.attribute_value := l_country;
3488: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
3489: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
3490: x_custom_output.EXTEND;
3491: x_custom_output(4) := l_custom_rec;
3492:

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

3485:
3486: l_custom_rec.attribute_name := ':l_country';
3487: l_custom_rec.attribute_value := l_country;
3488: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
3489: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
3490: x_custom_output.EXTEND;
3491: x_custom_output(4) := l_custom_rec;
3492:
3493: l_custom_rec.attribute_name := ':l_cat_id';

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

3491: x_custom_output(4) := l_custom_rec;
3492:
3493: l_custom_rec.attribute_name := ':l_cat_id';
3494: l_custom_rec.attribute_value := l_cat_id;
3495: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
3496: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
3497: x_custom_output.EXTEND;
3498: x_custom_output(5) := l_custom_rec;
3499:

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

3492:
3493: l_custom_rec.attribute_name := ':l_cat_id';
3494: l_custom_rec.attribute_value := l_cat_id;
3495: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
3496: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
3497: x_custom_output.EXTEND;
3498: x_custom_output(5) := l_custom_rec;
3499:
3500: l_custom_rec.attribute_name := ':l_campaign_id';

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

3498: x_custom_output(5) := l_custom_rec;
3499:
3500: l_custom_rec.attribute_name := ':l_campaign_id';
3501: l_custom_rec.attribute_value := l_campaign_id;
3502: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
3503: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
3504: x_custom_output.EXTEND;
3505: x_custom_output(6) := l_custom_rec;
3506:

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

3499:
3500: l_custom_rec.attribute_name := ':l_campaign_id';
3501: l_custom_rec.attribute_value := l_campaign_id;
3502: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
3503: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
3504: x_custom_output.EXTEND;
3505: x_custom_output(6) := l_custom_rec;
3506:
3507:

Line 3598: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

3594:
3595:
3596:
3597: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
3598: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
3599: bim_pmv_dbi_utl_pkg.get_bim_page_params(p_page_parameter_tbl,
3600: l_as_of_date,
3601: l_period_type,
3602: l_record_type_id,

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

6568: END IF;
6569: x_custom_sql := l_sqltext;
6570: l_custom_rec.attribute_name := ':l_record_type';
6571: l_custom_rec.attribute_value := l_record_type_id;
6572: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
6573: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
6574: x_custom_output.EXTEND;
6575: x_custom_output(1) := l_custom_rec;
6576:

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

6569: x_custom_sql := l_sqltext;
6570: l_custom_rec.attribute_name := ':l_record_type';
6571: l_custom_rec.attribute_value := l_record_type_id;
6572: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
6573: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
6574: x_custom_output.EXTEND;
6575: x_custom_output(1) := l_custom_rec;
6576:
6577: l_custom_rec.attribute_name := ':l_resource_id';

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

6575: x_custom_output(1) := l_custom_rec;
6576:
6577: l_custom_rec.attribute_name := ':l_resource_id';
6578: l_custom_rec.attribute_value := GET_RESOURCE_ID;
6579: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
6580: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
6581: x_custom_output.EXTEND;
6582: x_custom_output(2) := l_custom_rec;
6583:

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

6576:
6577: l_custom_rec.attribute_name := ':l_resource_id';
6578: l_custom_rec.attribute_value := GET_RESOURCE_ID;
6579: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
6580: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
6581: x_custom_output.EXTEND;
6582: x_custom_output(2) := l_custom_rec;
6583:
6584: l_custom_rec.attribute_name := ':l_admin_flag';

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

6582: x_custom_output(2) := l_custom_rec;
6583:
6584: l_custom_rec.attribute_name := ':l_admin_flag';
6585: l_custom_rec.attribute_value := GET_ADMIN_STATUS;
6586: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
6587: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
6588: x_custom_output.EXTEND;
6589: x_custom_output(3) := l_custom_rec;
6590:

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

6583:
6584: l_custom_rec.attribute_name := ':l_admin_flag';
6585: l_custom_rec.attribute_value := GET_ADMIN_STATUS;
6586: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
6587: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
6588: x_custom_output.EXTEND;
6589: x_custom_output(3) := l_custom_rec;
6590:
6591: l_custom_rec.attribute_name := ':l_country';

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

6589: x_custom_output(3) := l_custom_rec;
6590:
6591: l_custom_rec.attribute_name := ':l_country';
6592: l_custom_rec.attribute_value := l_country;
6593: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
6594: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
6595: x_custom_output.EXTEND;
6596: x_custom_output(4) := l_custom_rec;
6597:

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

6590:
6591: l_custom_rec.attribute_name := ':l_country';
6592: l_custom_rec.attribute_value := l_country;
6593: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
6594: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
6595: x_custom_output.EXTEND;
6596: x_custom_output(4) := l_custom_rec;
6597:
6598: l_custom_rec.attribute_name := ':l_cat_id';

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

6596: x_custom_output(4) := l_custom_rec;
6597:
6598: l_custom_rec.attribute_name := ':l_cat_id';
6599: l_custom_rec.attribute_value := l_cat_id;
6600: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
6601: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
6602: x_custom_output.EXTEND;
6603: x_custom_output(5) := l_custom_rec;
6604:

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

6597:
6598: l_custom_rec.attribute_name := ':l_cat_id';
6599: l_custom_rec.attribute_value := l_cat_id;
6600: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
6601: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
6602: x_custom_output.EXTEND;
6603: x_custom_output(5) := l_custom_rec;
6604:
6605: l_custom_rec.attribute_name := ':l_campaign_id';

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

6603: x_custom_output(5) := l_custom_rec;
6604:
6605: l_custom_rec.attribute_name := ':l_campaign_id';
6606: l_custom_rec.attribute_value := l_campaign_id;
6607: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
6608: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
6609: x_custom_output.EXTEND;
6610: x_custom_output(6) := l_custom_rec;
6611:

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

6604:
6605: l_custom_rec.attribute_name := ':l_campaign_id';
6606: l_custom_rec.attribute_value := l_campaign_id;
6607: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
6608: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
6609: x_custom_output.EXTEND;
6610: x_custom_output(6) := l_custom_rec;
6611:
6612:

Line 6676: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

6672: l_media VARCHAR2(300);
6673:
6674: BEGIN
6675: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
6676: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
6677: bim_pmv_dbi_utl_pkg.get_bim_page_params(p_page_parameter_tbl,
6678: l_as_of_date,
6679: l_period_type,
6680: l_record_type_id,

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

6816:
6817: x_custom_sql := l_sqltext;
6818: l_custom_rec.attribute_name := ':l_record_type';
6819: l_custom_rec.attribute_value := l_record_type_id;
6820: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
6821: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
6822: x_custom_output.EXTEND;
6823: x_custom_output(1) := l_custom_rec;
6824:

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

6817: x_custom_sql := l_sqltext;
6818: l_custom_rec.attribute_name := ':l_record_type';
6819: l_custom_rec.attribute_value := l_record_type_id;
6820: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
6821: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
6822: x_custom_output.EXTEND;
6823: x_custom_output(1) := l_custom_rec;
6824:
6825: l_custom_rec.attribute_name := ':l_resource_id';

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

6823: x_custom_output(1) := l_custom_rec;
6824:
6825: l_custom_rec.attribute_name := ':l_resource_id';
6826: l_custom_rec.attribute_value := GET_RESOURCE_ID;
6827: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
6828: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
6829: x_custom_output.EXTEND;
6830: x_custom_output(2) := l_custom_rec;
6831:

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

6824:
6825: l_custom_rec.attribute_name := ':l_resource_id';
6826: l_custom_rec.attribute_value := GET_RESOURCE_ID;
6827: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
6828: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
6829: x_custom_output.EXTEND;
6830: x_custom_output(2) := l_custom_rec;
6831:
6832: l_custom_rec.attribute_name := ':l_admin_flag';

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

6830: x_custom_output(2) := l_custom_rec;
6831:
6832: l_custom_rec.attribute_name := ':l_admin_flag';
6833: l_custom_rec.attribute_value := GET_ADMIN_STATUS;
6834: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
6835: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
6836: x_custom_output.EXTEND;
6837: x_custom_output(3) := l_custom_rec;
6838:

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

6831:
6832: l_custom_rec.attribute_name := ':l_admin_flag';
6833: l_custom_rec.attribute_value := GET_ADMIN_STATUS;
6834: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
6835: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
6836: x_custom_output.EXTEND;
6837: x_custom_output(3) := l_custom_rec;
6838:
6839: l_custom_rec.attribute_name := ':l_country';

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

6837: x_custom_output(3) := l_custom_rec;
6838:
6839: l_custom_rec.attribute_name := ':l_country';
6840: l_custom_rec.attribute_value := l_country;
6841: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
6842: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
6843: x_custom_output.EXTEND;
6844: x_custom_output(4) := l_custom_rec;
6845:

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

6838:
6839: l_custom_rec.attribute_name := ':l_country';
6840: l_custom_rec.attribute_value := l_country;
6841: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
6842: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
6843: x_custom_output.EXTEND;
6844: x_custom_output(4) := l_custom_rec;
6845:
6846: l_custom_rec.attribute_name := ':l_cat_id';

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

6844: x_custom_output(4) := l_custom_rec;
6845:
6846: l_custom_rec.attribute_name := ':l_cat_id';
6847: l_custom_rec.attribute_value := l_cat_id;
6848: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
6849: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
6850: x_custom_output.EXTEND;
6851: x_custom_output(5) := l_custom_rec;
6852:

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

6845:
6846: l_custom_rec.attribute_name := ':l_cat_id';
6847: l_custom_rec.attribute_value := l_cat_id;
6848: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
6849: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
6850: x_custom_output.EXTEND;
6851: x_custom_output(5) := l_custom_rec;
6852:
6853: write_debug('GET_TOP_LEADS_SQL','QUERY','_',l_sqltext);

Line 6903: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

6899: l_report_name VARCHAR2(300);
6900: l_media VARCHAR2(300);
6901: BEGIN
6902: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
6903: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
6904: bim_pmv_dbi_utl_pkg.get_bim_page_params(p_page_parameter_tbl,
6905: l_as_of_date,
6906: l_period_type,
6907: l_record_type_id,

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

7038:
7039: x_custom_sql := l_sqltext;
7040: l_custom_rec.attribute_name := ':l_record_type';
7041: l_custom_rec.attribute_value := l_record_type_id;
7042: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
7043: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
7044: x_custom_output.EXTEND;
7045: x_custom_output(1) := l_custom_rec;
7046:

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

7039: x_custom_sql := l_sqltext;
7040: l_custom_rec.attribute_name := ':l_record_type';
7041: l_custom_rec.attribute_value := l_record_type_id;
7042: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
7043: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
7044: x_custom_output.EXTEND;
7045: x_custom_output(1) := l_custom_rec;
7046:
7047: l_custom_rec.attribute_name := ':l_resource_id';

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

7045: x_custom_output(1) := l_custom_rec;
7046:
7047: l_custom_rec.attribute_name := ':l_resource_id';
7048: l_custom_rec.attribute_value := GET_RESOURCE_ID;
7049: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
7050: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
7051: x_custom_output.EXTEND;
7052: x_custom_output(2) := l_custom_rec;
7053:

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

7046:
7047: l_custom_rec.attribute_name := ':l_resource_id';
7048: l_custom_rec.attribute_value := GET_RESOURCE_ID;
7049: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
7050: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
7051: x_custom_output.EXTEND;
7052: x_custom_output(2) := l_custom_rec;
7053:
7054: l_custom_rec.attribute_name := ':l_admin_flag';

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

7052: x_custom_output(2) := l_custom_rec;
7053:
7054: l_custom_rec.attribute_name := ':l_admin_flag';
7055: l_custom_rec.attribute_value := GET_ADMIN_STATUS;
7056: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
7057: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
7058: x_custom_output.EXTEND;
7059: x_custom_output(3) := l_custom_rec;
7060:

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

7053:
7054: l_custom_rec.attribute_name := ':l_admin_flag';
7055: l_custom_rec.attribute_value := GET_ADMIN_STATUS;
7056: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
7057: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
7058: x_custom_output.EXTEND;
7059: x_custom_output(3) := l_custom_rec;
7060:
7061: l_custom_rec.attribute_name := ':l_country';

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

7059: x_custom_output(3) := l_custom_rec;
7060:
7061: l_custom_rec.attribute_name := ':l_country';
7062: l_custom_rec.attribute_value := l_country;
7063: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
7064: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
7065: x_custom_output.EXTEND;
7066: x_custom_output(4) := l_custom_rec;
7067:

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

7060:
7061: l_custom_rec.attribute_name := ':l_country';
7062: l_custom_rec.attribute_value := l_country;
7063: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
7064: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
7065: x_custom_output.EXTEND;
7066: x_custom_output(4) := l_custom_rec;
7067:
7068: l_custom_rec.attribute_name := ':l_cat_id';

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

7066: x_custom_output(4) := l_custom_rec;
7067:
7068: l_custom_rec.attribute_name := ':l_cat_id';
7069: l_custom_rec.attribute_value := l_cat_id;
7070: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
7071: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
7072: x_custom_output.EXTEND;
7073: x_custom_output(5) := l_custom_rec;
7074:

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

7067:
7068: l_custom_rec.attribute_name := ':l_cat_id';
7069: l_custom_rec.attribute_value := l_cat_id;
7070: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
7071: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
7072: x_custom_output.EXTEND;
7073: x_custom_output(5) := l_custom_rec;
7074:
7075:

Line 7127: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

7123: l_report_name VARCHAR2(300);
7124: l_media VARCHAR2(300);
7125: BEGIN
7126: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
7127: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
7128: bim_pmv_dbi_utl_pkg.get_bim_page_params(p_page_parameter_tbl,
7129: l_as_of_date,
7130: l_period_type,
7131: l_record_type_id,

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

7221:
7222: x_custom_sql := l_sqltext;
7223: l_custom_rec.attribute_name := ':l_record_type';
7224: l_custom_rec.attribute_value := l_record_type_id;
7225: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
7226: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
7227: x_custom_output.EXTEND;
7228: x_custom_output(1) := l_custom_rec;
7229:

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

7222: x_custom_sql := l_sqltext;
7223: l_custom_rec.attribute_name := ':l_record_type';
7224: l_custom_rec.attribute_value := l_record_type_id;
7225: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
7226: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
7227: x_custom_output.EXTEND;
7228: x_custom_output(1) := l_custom_rec;
7229:
7230: l_custom_rec.attribute_name := ':l_resource_id';

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

7228: x_custom_output(1) := l_custom_rec;
7229:
7230: l_custom_rec.attribute_name := ':l_resource_id';
7231: l_custom_rec.attribute_value := GET_RESOURCE_ID;
7232: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
7233: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
7234: x_custom_output.EXTEND;
7235: x_custom_output(2) := l_custom_rec;
7236:

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

7229:
7230: l_custom_rec.attribute_name := ':l_resource_id';
7231: l_custom_rec.attribute_value := GET_RESOURCE_ID;
7232: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
7233: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
7234: x_custom_output.EXTEND;
7235: x_custom_output(2) := l_custom_rec;
7236:
7237: l_custom_rec.attribute_name := ':l_admin_flag';

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

7235: x_custom_output(2) := l_custom_rec;
7236:
7237: l_custom_rec.attribute_name := ':l_admin_flag';
7238: l_custom_rec.attribute_value := GET_ADMIN_STATUS;
7239: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
7240: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
7241: x_custom_output.EXTEND;
7242: x_custom_output(3) := l_custom_rec;
7243:

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

7236:
7237: l_custom_rec.attribute_name := ':l_admin_flag';
7238: l_custom_rec.attribute_value := GET_ADMIN_STATUS;
7239: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
7240: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
7241: x_custom_output.EXTEND;
7242: x_custom_output(3) := l_custom_rec;
7243:
7244: l_custom_rec.attribute_name := ':l_country';

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

7242: x_custom_output(3) := l_custom_rec;
7243:
7244: l_custom_rec.attribute_name := ':l_country';
7245: l_custom_rec.attribute_value := l_country;
7246: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
7247: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
7248: x_custom_output.EXTEND;
7249: x_custom_output(4) := l_custom_rec;
7250:

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

7243:
7244: l_custom_rec.attribute_name := ':l_country';
7245: l_custom_rec.attribute_value := l_country;
7246: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
7247: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
7248: x_custom_output.EXTEND;
7249: x_custom_output(4) := l_custom_rec;
7250:
7251: l_custom_rec.attribute_name := ':l_cat_id';

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

7249: x_custom_output(4) := l_custom_rec;
7250:
7251: l_custom_rec.attribute_name := ':l_cat_id';
7252: l_custom_rec.attribute_value := l_cat_id;
7253: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
7254: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
7255: x_custom_output.EXTEND;
7256: x_custom_output(5) := l_custom_rec;
7257:

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

7250:
7251: l_custom_rec.attribute_name := ':l_cat_id';
7252: l_custom_rec.attribute_value := l_cat_id;
7253: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
7254: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
7255: x_custom_output.EXTEND;
7256: x_custom_output(5) := l_custom_rec;
7257:
7258:

Line 7310: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

7306: l_report_name VARCHAR2(300);
7307: l_media VARCHAR2(300);
7308: BEGIN
7309: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
7310: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
7311: bim_pmv_dbi_utl_pkg.get_bim_page_params(p_page_parameter_tbl,
7312: l_as_of_date,
7313: l_period_type,
7314: l_record_type_id,

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

7405:
7406: x_custom_sql := l_sqltext;
7407: l_custom_rec.attribute_name := ':l_record_type';
7408: l_custom_rec.attribute_value := l_record_type_id;
7409: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
7410: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
7411: x_custom_output.EXTEND;
7412: x_custom_output(1) := l_custom_rec;
7413:

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

7406: x_custom_sql := l_sqltext;
7407: l_custom_rec.attribute_name := ':l_record_type';
7408: l_custom_rec.attribute_value := l_record_type_id;
7409: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
7410: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
7411: x_custom_output.EXTEND;
7412: x_custom_output(1) := l_custom_rec;
7413:
7414: l_custom_rec.attribute_name := ':l_resource_id';

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

7412: x_custom_output(1) := l_custom_rec;
7413:
7414: l_custom_rec.attribute_name := ':l_resource_id';
7415: l_custom_rec.attribute_value := GET_RESOURCE_ID;
7416: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
7417: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
7418: x_custom_output.EXTEND;
7419: x_custom_output(2) := l_custom_rec;
7420:

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

7413:
7414: l_custom_rec.attribute_name := ':l_resource_id';
7415: l_custom_rec.attribute_value := GET_RESOURCE_ID;
7416: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
7417: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
7418: x_custom_output.EXTEND;
7419: x_custom_output(2) := l_custom_rec;
7420:
7421: l_custom_rec.attribute_name := ':l_admin_flag';

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

7419: x_custom_output(2) := l_custom_rec;
7420:
7421: l_custom_rec.attribute_name := ':l_admin_flag';
7422: l_custom_rec.attribute_value := GET_ADMIN_STATUS;
7423: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
7424: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
7425: x_custom_output.EXTEND;
7426: x_custom_output(3) := l_custom_rec;
7427:

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

7420:
7421: l_custom_rec.attribute_name := ':l_admin_flag';
7422: l_custom_rec.attribute_value := GET_ADMIN_STATUS;
7423: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
7424: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
7425: x_custom_output.EXTEND;
7426: x_custom_output(3) := l_custom_rec;
7427:
7428: l_custom_rec.attribute_name := ':l_country';

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

7426: x_custom_output(3) := l_custom_rec;
7427:
7428: l_custom_rec.attribute_name := ':l_country';
7429: l_custom_rec.attribute_value := l_country;
7430: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
7431: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
7432: x_custom_output.EXTEND;
7433: x_custom_output(4) := l_custom_rec;
7434:

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

7427:
7428: l_custom_rec.attribute_name := ':l_country';
7429: l_custom_rec.attribute_value := l_country;
7430: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
7431: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
7432: x_custom_output.EXTEND;
7433: x_custom_output(4) := l_custom_rec;
7434:
7435: l_custom_rec.attribute_name := ':l_cat_id';

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

7433: x_custom_output(4) := l_custom_rec;
7434:
7435: l_custom_rec.attribute_name := ':l_cat_id';
7436: l_custom_rec.attribute_value := l_cat_id;
7437: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
7438: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
7439: x_custom_output.EXTEND;
7440: x_custom_output(5) := l_custom_rec;
7441:

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

7434:
7435: l_custom_rec.attribute_name := ':l_cat_id';
7436: l_custom_rec.attribute_value := l_cat_id;
7437: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
7438: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
7439: x_custom_output.EXTEND;
7440: x_custom_output(5) := l_custom_rec;
7441:
7442:

Line 7494: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

7490: l_report_name VARCHAR2(300);
7491: l_media VARCHAR2(300);
7492: BEGIN
7493: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
7494: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
7495: bim_pmv_dbi_utl_pkg.get_bim_page_params(p_page_parameter_tbl,
7496: l_as_of_date,
7497: l_period_type,
7498: l_record_type_id,

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

7586:
7587: x_custom_sql := l_sqltext;
7588: l_custom_rec.attribute_name := ':l_record_type';
7589: l_custom_rec.attribute_value := l_record_type_id;
7590: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
7591: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
7592: x_custom_output.EXTEND;
7593: x_custom_output(1) := l_custom_rec;
7594:

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

7587: x_custom_sql := l_sqltext;
7588: l_custom_rec.attribute_name := ':l_record_type';
7589: l_custom_rec.attribute_value := l_record_type_id;
7590: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
7591: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
7592: x_custom_output.EXTEND;
7593: x_custom_output(1) := l_custom_rec;
7594:
7595: l_custom_rec.attribute_name := ':l_resource_id';

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

7593: x_custom_output(1) := l_custom_rec;
7594:
7595: l_custom_rec.attribute_name := ':l_resource_id';
7596: l_custom_rec.attribute_value := GET_RESOURCE_ID;
7597: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
7598: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
7599: x_custom_output.EXTEND;
7600: x_custom_output(2) := l_custom_rec;
7601:

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

7594:
7595: l_custom_rec.attribute_name := ':l_resource_id';
7596: l_custom_rec.attribute_value := GET_RESOURCE_ID;
7597: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
7598: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
7599: x_custom_output.EXTEND;
7600: x_custom_output(2) := l_custom_rec;
7601:
7602: l_custom_rec.attribute_name := ':l_admin_flag';

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

7600: x_custom_output(2) := l_custom_rec;
7601:
7602: l_custom_rec.attribute_name := ':l_admin_flag';
7603: l_custom_rec.attribute_value := GET_ADMIN_STATUS;
7604: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
7605: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
7606: x_custom_output.EXTEND;
7607: x_custom_output(3) := l_custom_rec;
7608:

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

7601:
7602: l_custom_rec.attribute_name := ':l_admin_flag';
7603: l_custom_rec.attribute_value := GET_ADMIN_STATUS;
7604: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
7605: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
7606: x_custom_output.EXTEND;
7607: x_custom_output(3) := l_custom_rec;
7608:
7609: l_custom_rec.attribute_name := ':l_country';

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

7607: x_custom_output(3) := l_custom_rec;
7608:
7609: l_custom_rec.attribute_name := ':l_country';
7610: l_custom_rec.attribute_value := l_country;
7611: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
7612: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
7613: x_custom_output.EXTEND;
7614: x_custom_output(4) := l_custom_rec;
7615:

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

7608:
7609: l_custom_rec.attribute_name := ':l_country';
7610: l_custom_rec.attribute_value := l_country;
7611: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
7612: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
7613: x_custom_output.EXTEND;
7614: x_custom_output(4) := l_custom_rec;
7615:
7616: l_custom_rec.attribute_name := ':l_cat_id';

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

7614: x_custom_output(4) := l_custom_rec;
7615:
7616: l_custom_rec.attribute_name := ':l_cat_id';
7617: l_custom_rec.attribute_value := l_cat_id;
7618: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
7619: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
7620: x_custom_output.EXTEND;
7621: x_custom_output(5) := l_custom_rec;
7622:

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

7615:
7616: l_custom_rec.attribute_name := ':l_cat_id';
7617: l_custom_rec.attribute_value := l_cat_id;
7618: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
7619: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
7620: x_custom_output.EXTEND;
7621: x_custom_output(5) := l_custom_rec;
7622:
7623:

Line 7675: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

7671: l_report_name VARCHAR2(300);
7672: l_media VARCHAR2(300);
7673: BEGIN
7674: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
7675: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
7676: bim_pmv_dbi_utl_pkg.get_bim_page_params(p_page_parameter_tbl,
7677: l_as_of_date,
7678: l_period_type,
7679: l_record_type_id,

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

7768:
7769: x_custom_sql := l_sqltext;
7770: l_custom_rec.attribute_name := ':l_record_type';
7771: l_custom_rec.attribute_value := l_record_type_id;
7772: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
7773: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
7774: x_custom_output.EXTEND;
7775: x_custom_output(1) := l_custom_rec;
7776:

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

7769: x_custom_sql := l_sqltext;
7770: l_custom_rec.attribute_name := ':l_record_type';
7771: l_custom_rec.attribute_value := l_record_type_id;
7772: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
7773: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
7774: x_custom_output.EXTEND;
7775: x_custom_output(1) := l_custom_rec;
7776:
7777: l_custom_rec.attribute_name := ':l_resource_id';

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

7775: x_custom_output(1) := l_custom_rec;
7776:
7777: l_custom_rec.attribute_name := ':l_resource_id';
7778: l_custom_rec.attribute_value := GET_RESOURCE_ID;
7779: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
7780: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
7781: x_custom_output.EXTEND;
7782: x_custom_output(2) := l_custom_rec;
7783:

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

7776:
7777: l_custom_rec.attribute_name := ':l_resource_id';
7778: l_custom_rec.attribute_value := GET_RESOURCE_ID;
7779: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
7780: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
7781: x_custom_output.EXTEND;
7782: x_custom_output(2) := l_custom_rec;
7783:
7784: l_custom_rec.attribute_name := ':l_admin_flag';

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

7782: x_custom_output(2) := l_custom_rec;
7783:
7784: l_custom_rec.attribute_name := ':l_admin_flag';
7785: l_custom_rec.attribute_value := GET_ADMIN_STATUS;
7786: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
7787: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
7788: x_custom_output.EXTEND;
7789: x_custom_output(3) := l_custom_rec;
7790:

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

7783:
7784: l_custom_rec.attribute_name := ':l_admin_flag';
7785: l_custom_rec.attribute_value := GET_ADMIN_STATUS;
7786: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
7787: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
7788: x_custom_output.EXTEND;
7789: x_custom_output(3) := l_custom_rec;
7790:
7791: l_custom_rec.attribute_name := ':l_country';

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

7789: x_custom_output(3) := l_custom_rec;
7790:
7791: l_custom_rec.attribute_name := ':l_country';
7792: l_custom_rec.attribute_value := l_country;
7793: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
7794: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
7795: x_custom_output.EXTEND;
7796: x_custom_output(4) := l_custom_rec;
7797:

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

7790:
7791: l_custom_rec.attribute_name := ':l_country';
7792: l_custom_rec.attribute_value := l_country;
7793: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
7794: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
7795: x_custom_output.EXTEND;
7796: x_custom_output(4) := l_custom_rec;
7797:
7798: l_custom_rec.attribute_name := ':l_cat_id';

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

7796: x_custom_output(4) := l_custom_rec;
7797:
7798: l_custom_rec.attribute_name := ':l_cat_id';
7799: l_custom_rec.attribute_value := l_cat_id;
7800: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
7801: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
7802: x_custom_output.EXTEND;
7803: x_custom_output(5) := l_custom_rec;
7804:

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

7797:
7798: l_custom_rec.attribute_name := ':l_cat_id';
7799: l_custom_rec.attribute_value := l_cat_id;
7800: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
7801: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
7802: x_custom_output.EXTEND;
7803: x_custom_output(5) := l_custom_rec;
7804:
7805:

Line 7872: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

7868:
7869:
7870: BEGIN
7871: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
7872: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
7873: bim_pmv_dbi_utl_pkg.get_bim_page_params(p_page_parameter_tbl,
7874: l_as_of_date,
7875: l_period_type,
7876: l_record_type_id,

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

8286:
8287: x_custom_sql := l_sqltext_final;
8288: l_custom_rec.attribute_name := ':l_record_type';
8289: l_custom_rec.attribute_value := l_record_type_id;
8290: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
8291: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
8292: x_custom_output.EXTEND;
8293: x_custom_output(1) := l_custom_rec;
8294:

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

8287: x_custom_sql := l_sqltext_final;
8288: l_custom_rec.attribute_name := ':l_record_type';
8289: l_custom_rec.attribute_value := l_record_type_id;
8290: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
8291: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
8292: x_custom_output.EXTEND;
8293: x_custom_output(1) := l_custom_rec;
8294:
8295: l_custom_rec.attribute_name := ':l_resource_id';

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

8293: x_custom_output(1) := l_custom_rec;
8294:
8295: l_custom_rec.attribute_name := ':l_resource_id';
8296: l_custom_rec.attribute_value := GET_RESOURCE_ID;
8297: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
8298: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
8299: x_custom_output.EXTEND;
8300: x_custom_output(2) := l_custom_rec;
8301:

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

8294:
8295: l_custom_rec.attribute_name := ':l_resource_id';
8296: l_custom_rec.attribute_value := GET_RESOURCE_ID;
8297: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
8298: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
8299: x_custom_output.EXTEND;
8300: x_custom_output(2) := l_custom_rec;
8301:
8302: l_custom_rec.attribute_name := ':l_admin_flag';

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

8300: x_custom_output(2) := l_custom_rec;
8301:
8302: l_custom_rec.attribute_name := ':l_admin_flag';
8303: l_custom_rec.attribute_value := GET_ADMIN_STATUS;
8304: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
8305: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
8306: x_custom_output.EXTEND;
8307: x_custom_output(3) := l_custom_rec;
8308:

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

8301:
8302: l_custom_rec.attribute_name := ':l_admin_flag';
8303: l_custom_rec.attribute_value := GET_ADMIN_STATUS;
8304: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
8305: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
8306: x_custom_output.EXTEND;
8307: x_custom_output(3) := l_custom_rec;
8308:
8309: l_custom_rec.attribute_name := ':l_country';

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

8307: x_custom_output(3) := l_custom_rec;
8308:
8309: l_custom_rec.attribute_name := ':l_country';
8310: l_custom_rec.attribute_value := l_country;
8311: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
8312: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
8313: x_custom_output.EXTEND;
8314: x_custom_output(4) := l_custom_rec;
8315:

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

8308:
8309: l_custom_rec.attribute_name := ':l_country';
8310: l_custom_rec.attribute_value := l_country;
8311: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
8312: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
8313: x_custom_output.EXTEND;
8314: x_custom_output(4) := l_custom_rec;
8315:
8316: l_custom_rec.attribute_name := ':l_cat_id';

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

8314: x_custom_output(4) := l_custom_rec;
8315:
8316: l_custom_rec.attribute_name := ':l_cat_id';
8317: l_custom_rec.attribute_value := l_cat_id;
8318: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
8319: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
8320: x_custom_output.EXTEND;
8321: x_custom_output(5) := l_custom_rec;
8322:

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

8315:
8316: l_custom_rec.attribute_name := ':l_cat_id';
8317: l_custom_rec.attribute_value := l_cat_id;
8318: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
8319: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
8320: x_custom_output.EXTEND;
8321: x_custom_output(5) := l_custom_rec;
8322:
8323: write_debug('MKTG KPI SQL','QUERY','test',l_sqltext,NULL,null);

Line 8377: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

8373: l_report_name VARCHAR2(300);
8374: l_media VARCHAR2(300);
8375: BEGIN
8376: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
8377: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
8378:
8379: bim_pmv_dbi_utl_pkg.get_bim_page_params(p_page_parameter_tbl,
8380: l_as_of_date,
8381: l_period_type,

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

8793:
8794: x_custom_sql := l_sqltext;
8795: l_custom_rec.attribute_name := ':l_record_type';
8796: l_custom_rec.attribute_value := l_record_type_id;
8797: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
8798: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
8799: x_custom_output.EXTEND;
8800: x_custom_output(1) := l_custom_rec;
8801:

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

8794: x_custom_sql := l_sqltext;
8795: l_custom_rec.attribute_name := ':l_record_type';
8796: l_custom_rec.attribute_value := l_record_type_id;
8797: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
8798: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
8799: x_custom_output.EXTEND;
8800: x_custom_output(1) := l_custom_rec;
8801:
8802: l_custom_rec.attribute_name := ':l_resource_id';

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

8800: x_custom_output(1) := l_custom_rec;
8801:
8802: l_custom_rec.attribute_name := ':l_resource_id';
8803: l_custom_rec.attribute_value := GET_RESOURCE_ID;
8804: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
8805: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
8806: x_custom_output.EXTEND;
8807: x_custom_output(2) := l_custom_rec;
8808:

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

8801:
8802: l_custom_rec.attribute_name := ':l_resource_id';
8803: l_custom_rec.attribute_value := GET_RESOURCE_ID;
8804: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
8805: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
8806: x_custom_output.EXTEND;
8807: x_custom_output(2) := l_custom_rec;
8808:
8809: l_custom_rec.attribute_name := ':l_admin_flag';

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

8807: x_custom_output(2) := l_custom_rec;
8808:
8809: l_custom_rec.attribute_name := ':l_admin_flag';
8810: l_custom_rec.attribute_value := GET_ADMIN_STATUS;
8811: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
8812: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
8813: x_custom_output.EXTEND;
8814: x_custom_output(3) := l_custom_rec;
8815:

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

8808:
8809: l_custom_rec.attribute_name := ':l_admin_flag';
8810: l_custom_rec.attribute_value := GET_ADMIN_STATUS;
8811: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
8812: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
8813: x_custom_output.EXTEND;
8814: x_custom_output(3) := l_custom_rec;
8815:
8816: l_custom_rec.attribute_name := ':l_country';

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

8814: x_custom_output(3) := l_custom_rec;
8815:
8816: l_custom_rec.attribute_name := ':l_country';
8817: l_custom_rec.attribute_value := l_country;
8818: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
8819: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
8820: x_custom_output.EXTEND;
8821: x_custom_output(4) := l_custom_rec;
8822:

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

8815:
8816: l_custom_rec.attribute_name := ':l_country';
8817: l_custom_rec.attribute_value := l_country;
8818: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
8819: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
8820: x_custom_output.EXTEND;
8821: x_custom_output(4) := l_custom_rec;
8822:
8823: l_custom_rec.attribute_name := ':l_period_type_id';

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

8821: x_custom_output(4) := l_custom_rec;
8822:
8823: l_custom_rec.attribute_name := ':l_period_type_id';
8824: l_custom_rec.attribute_value := l_period_type_id;
8825: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
8826: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
8827: x_custom_output.EXTEND;
8828: x_custom_output(5) := l_custom_rec;
8829:

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

8822:
8823: l_custom_rec.attribute_name := ':l_period_type_id';
8824: l_custom_rec.attribute_value := l_period_type_id;
8825: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
8826: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
8827: x_custom_output.EXTEND;
8828: x_custom_output(5) := l_custom_rec;
8829:
8830: l_custom_rec.attribute_name := ':l_cat_id';

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

8828: x_custom_output(5) := l_custom_rec;
8829:
8830: l_custom_rec.attribute_name := ':l_cat_id';
8831: l_custom_rec.attribute_value := l_cat_id;
8832: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
8833: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
8834: x_custom_output.EXTEND;
8835: x_custom_output(6) := l_custom_rec;
8836:

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

8829:
8830: l_custom_rec.attribute_name := ':l_cat_id';
8831: l_custom_rec.attribute_value := l_cat_id;
8832: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
8833: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
8834: x_custom_output.EXTEND;
8835: x_custom_output(6) := l_custom_rec;
8836:
8837:

Line 8945: l_custom_rec := bis_pmv_parameters_pub.initialize_query_type;

8941: l_where_bud VARCHAR2(300);
8942: l_prog_cost1 VARCHAR2(30);
8943: BEGIN
8944: x_custom_output := bis_query_attributes_tbl ();
8945: l_custom_rec := bis_pmv_parameters_pub.initialize_query_type;
8946: bim_pmv_dbi_utl_pkg.get_bim_page_params(p_page_parameter_tbl,
8947: l_as_of_date,
8948: l_period_type,
8949: l_record_type_id,

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

9820:
9821: x_custom_sql := l_sqltext;
9822: l_custom_rec.attribute_name := ':l_record_type';
9823: l_custom_rec.attribute_value := l_record_type_id;
9824: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
9825: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
9826: x_custom_output.EXTEND;
9827: x_custom_output (1) := l_custom_rec;
9828: l_custom_rec.attribute_name := ':l_resource_id';

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

9821: x_custom_sql := l_sqltext;
9822: l_custom_rec.attribute_name := ':l_record_type';
9823: l_custom_rec.attribute_value := l_record_type_id;
9824: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
9825: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
9826: x_custom_output.EXTEND;
9827: x_custom_output (1) := l_custom_rec;
9828: l_custom_rec.attribute_name := ':l_resource_id';
9829: l_custom_rec.attribute_value := get_resource_id;

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

9826: x_custom_output.EXTEND;
9827: x_custom_output (1) := l_custom_rec;
9828: l_custom_rec.attribute_name := ':l_resource_id';
9829: l_custom_rec.attribute_value := get_resource_id;
9830: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
9831: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
9832: x_custom_output.EXTEND;
9833: x_custom_output (2) := l_custom_rec;
9834: l_custom_rec.attribute_name := ':l_admin_flag';

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

9827: x_custom_output (1) := l_custom_rec;
9828: l_custom_rec.attribute_name := ':l_resource_id';
9829: l_custom_rec.attribute_value := get_resource_id;
9830: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
9831: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
9832: x_custom_output.EXTEND;
9833: x_custom_output (2) := l_custom_rec;
9834: l_custom_rec.attribute_name := ':l_admin_flag';
9835: l_custom_rec.attribute_value := get_admin_status;

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

9832: x_custom_output.EXTEND;
9833: x_custom_output (2) := l_custom_rec;
9834: l_custom_rec.attribute_name := ':l_admin_flag';
9835: l_custom_rec.attribute_value := get_admin_status;
9836: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
9837: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
9838: x_custom_output.EXTEND;
9839: x_custom_output (3) := l_custom_rec;
9840: l_custom_rec.attribute_name := ':l_country';

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

9833: x_custom_output (2) := l_custom_rec;
9834: l_custom_rec.attribute_name := ':l_admin_flag';
9835: l_custom_rec.attribute_value := get_admin_status;
9836: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
9837: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
9838: x_custom_output.EXTEND;
9839: x_custom_output (3) := l_custom_rec;
9840: l_custom_rec.attribute_name := ':l_country';
9841: l_custom_rec.attribute_value := l_country;

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

9838: x_custom_output.EXTEND;
9839: x_custom_output (3) := l_custom_rec;
9840: l_custom_rec.attribute_name := ':l_country';
9841: l_custom_rec.attribute_value := l_country;
9842: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
9843: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
9844: x_custom_output.EXTEND;
9845: x_custom_output (4) := l_custom_rec;
9846: l_custom_rec.attribute_name := ':l_cat_id';

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

9839: x_custom_output (3) := l_custom_rec;
9840: l_custom_rec.attribute_name := ':l_country';
9841: l_custom_rec.attribute_value := l_country;
9842: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
9843: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
9844: x_custom_output.EXTEND;
9845: x_custom_output (4) := l_custom_rec;
9846: l_custom_rec.attribute_name := ':l_cat_id';
9847: l_custom_rec.attribute_value := l_cat_id;

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

9844: x_custom_output.EXTEND;
9845: x_custom_output (4) := l_custom_rec;
9846: l_custom_rec.attribute_name := ':l_cat_id';
9847: l_custom_rec.attribute_value := l_cat_id;
9848: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
9849: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
9850: x_custom_output.EXTEND;
9851: x_custom_output (5) := l_custom_rec;
9852: l_custom_rec.attribute_name := ':l_campaign_id';

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

9845: x_custom_output (4) := l_custom_rec;
9846: l_custom_rec.attribute_name := ':l_cat_id';
9847: l_custom_rec.attribute_value := l_cat_id;
9848: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
9849: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
9850: x_custom_output.EXTEND;
9851: x_custom_output (5) := l_custom_rec;
9852: l_custom_rec.attribute_name := ':l_campaign_id';
9853: l_custom_rec.attribute_value := l_campaign_id;

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

9850: x_custom_output.EXTEND;
9851: x_custom_output (5) := l_custom_rec;
9852: l_custom_rec.attribute_name := ':l_campaign_id';
9853: l_custom_rec.attribute_value := l_campaign_id;
9854: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
9855: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
9856: x_custom_output.EXTEND;
9857: x_custom_output (6) := l_custom_rec;
9858: write_debug ('GET_CPL_RPL_SQL', 'QUERY', '_', l_sqltext);

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

9851: x_custom_output (5) := l_custom_rec;
9852: l_custom_rec.attribute_name := ':l_campaign_id';
9853: l_custom_rec.attribute_value := l_campaign_id;
9854: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
9855: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
9856: x_custom_output.EXTEND;
9857: x_custom_output (6) := l_custom_rec;
9858: write_debug ('GET_CPL_RPL_SQL', 'QUERY', '_', l_sqltext);
9859: EXCEPTION

Line 9967: l_custom_rec := bis_pmv_parameters_pub.initialize_query_type;

9963: l_where_bud VARCHAR2(300);
9964: l_prog_cost1 VARCHAR2(30);
9965: BEGIN
9966: x_custom_output := bis_query_attributes_tbl ();
9967: l_custom_rec := bis_pmv_parameters_pub.initialize_query_type;
9968: bim_pmv_dbi_utl_pkg.get_bim_page_params(p_page_parameter_tbl,
9969: l_as_of_date,
9970: l_period_type,
9971: l_record_type_id,

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

10805:
10806: x_custom_sql := l_sqltext;
10807: l_custom_rec.attribute_name := ':l_record_type';
10808: l_custom_rec.attribute_value := l_record_type_id;
10809: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
10810: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
10811: x_custom_output.EXTEND;
10812: x_custom_output (1) := l_custom_rec;
10813: l_custom_rec.attribute_name := ':l_resource_id';

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

10806: x_custom_sql := l_sqltext;
10807: l_custom_rec.attribute_name := ':l_record_type';
10808: l_custom_rec.attribute_value := l_record_type_id;
10809: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
10810: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
10811: x_custom_output.EXTEND;
10812: x_custom_output (1) := l_custom_rec;
10813: l_custom_rec.attribute_name := ':l_resource_id';
10814: l_custom_rec.attribute_value := get_resource_id;

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

10811: x_custom_output.EXTEND;
10812: x_custom_output (1) := l_custom_rec;
10813: l_custom_rec.attribute_name := ':l_resource_id';
10814: l_custom_rec.attribute_value := get_resource_id;
10815: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
10816: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
10817: x_custom_output.EXTEND;
10818: x_custom_output (2) := l_custom_rec;
10819: l_custom_rec.attribute_name := ':l_admin_flag';

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

10812: x_custom_output (1) := l_custom_rec;
10813: l_custom_rec.attribute_name := ':l_resource_id';
10814: l_custom_rec.attribute_value := get_resource_id;
10815: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
10816: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
10817: x_custom_output.EXTEND;
10818: x_custom_output (2) := l_custom_rec;
10819: l_custom_rec.attribute_name := ':l_admin_flag';
10820: l_custom_rec.attribute_value := get_admin_status;

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

10817: x_custom_output.EXTEND;
10818: x_custom_output (2) := l_custom_rec;
10819: l_custom_rec.attribute_name := ':l_admin_flag';
10820: l_custom_rec.attribute_value := get_admin_status;
10821: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
10822: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
10823: x_custom_output.EXTEND;
10824: x_custom_output (3) := l_custom_rec;
10825: l_custom_rec.attribute_name := ':l_country';

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

10818: x_custom_output (2) := l_custom_rec;
10819: l_custom_rec.attribute_name := ':l_admin_flag';
10820: l_custom_rec.attribute_value := get_admin_status;
10821: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
10822: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
10823: x_custom_output.EXTEND;
10824: x_custom_output (3) := l_custom_rec;
10825: l_custom_rec.attribute_name := ':l_country';
10826: l_custom_rec.attribute_value := l_country;

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

10823: x_custom_output.EXTEND;
10824: x_custom_output (3) := l_custom_rec;
10825: l_custom_rec.attribute_name := ':l_country';
10826: l_custom_rec.attribute_value := l_country;
10827: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
10828: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
10829: x_custom_output.EXTEND;
10830: x_custom_output (4) := l_custom_rec;
10831: l_custom_rec.attribute_name := ':l_cat_id';

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

10824: x_custom_output (3) := l_custom_rec;
10825: l_custom_rec.attribute_name := ':l_country';
10826: l_custom_rec.attribute_value := l_country;
10827: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
10828: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
10829: x_custom_output.EXTEND;
10830: x_custom_output (4) := l_custom_rec;
10831: l_custom_rec.attribute_name := ':l_cat_id';
10832: l_custom_rec.attribute_value := l_cat_id;

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

10829: x_custom_output.EXTEND;
10830: x_custom_output (4) := l_custom_rec;
10831: l_custom_rec.attribute_name := ':l_cat_id';
10832: l_custom_rec.attribute_value := l_cat_id;
10833: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
10834: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
10835: x_custom_output.EXTEND;
10836: x_custom_output (5) := l_custom_rec;
10837: l_custom_rec.attribute_name := ':l_campaign_id';

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

10830: x_custom_output (4) := l_custom_rec;
10831: l_custom_rec.attribute_name := ':l_cat_id';
10832: l_custom_rec.attribute_value := l_cat_id;
10833: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
10834: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
10835: x_custom_output.EXTEND;
10836: x_custom_output (5) := l_custom_rec;
10837: l_custom_rec.attribute_name := ':l_campaign_id';
10838: l_custom_rec.attribute_value := l_campaign_id;

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

10835: x_custom_output.EXTEND;
10836: x_custom_output (5) := l_custom_rec;
10837: l_custom_rec.attribute_name := ':l_campaign_id';
10838: l_custom_rec.attribute_value := l_campaign_id;
10839: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
10840: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
10841: x_custom_output.EXTEND;
10842: x_custom_output (6) := l_custom_rec;
10843: write_debug ('GET_RPL_CPL_SQL', 'QUERY', '_', l_sqltext);

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

10836: x_custom_output (5) := l_custom_rec;
10837: l_custom_rec.attribute_name := ':l_campaign_id';
10838: l_custom_rec.attribute_value := l_campaign_id;
10839: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
10840: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
10841: x_custom_output.EXTEND;
10842: x_custom_output (6) := l_custom_rec;
10843: write_debug ('GET_RPL_CPL_SQL', 'QUERY', '_', l_sqltext);
10844: EXCEPTION

Line 10935: l_custom_rec := bis_pmv_parameters_pub.initialize_query_type;

10931: l_report_name VARCHAR2(300);
10932: l_media VARCHAR2(300);
10933: BEGIN
10934: x_custom_output := bis_query_attributes_tbl ();
10935: l_custom_rec := bis_pmv_parameters_pub.initialize_query_type;
10936: bim_pmv_dbi_utl_pkg.get_bim_page_params(p_page_parameter_tbl,
10937: l_as_of_date,
10938: l_period_type,
10939: l_record_type_id,

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

11686:
11687: x_custom_sql := l_sqltext;
11688: l_custom_rec.attribute_name := ':l_record_type';
11689: l_custom_rec.attribute_value := l_record_type_id;
11690: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
11691: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
11692: x_custom_output.EXTEND;
11693: x_custom_output (1) := l_custom_rec;
11694: l_custom_rec.attribute_name := ':l_resource_id';

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

11687: x_custom_sql := l_sqltext;
11688: l_custom_rec.attribute_name := ':l_record_type';
11689: l_custom_rec.attribute_value := l_record_type_id;
11690: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
11691: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
11692: x_custom_output.EXTEND;
11693: x_custom_output (1) := l_custom_rec;
11694: l_custom_rec.attribute_name := ':l_resource_id';
11695: l_custom_rec.attribute_value := get_resource_id;

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

11692: x_custom_output.EXTEND;
11693: x_custom_output (1) := l_custom_rec;
11694: l_custom_rec.attribute_name := ':l_resource_id';
11695: l_custom_rec.attribute_value := get_resource_id;
11696: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
11697: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
11698: x_custom_output.EXTEND;
11699: x_custom_output (2) := l_custom_rec;
11700: l_custom_rec.attribute_name := ':l_admin_flag';

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

11693: x_custom_output (1) := l_custom_rec;
11694: l_custom_rec.attribute_name := ':l_resource_id';
11695: l_custom_rec.attribute_value := get_resource_id;
11696: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
11697: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
11698: x_custom_output.EXTEND;
11699: x_custom_output (2) := l_custom_rec;
11700: l_custom_rec.attribute_name := ':l_admin_flag';
11701: l_custom_rec.attribute_value := get_admin_status;

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

11698: x_custom_output.EXTEND;
11699: x_custom_output (2) := l_custom_rec;
11700: l_custom_rec.attribute_name := ':l_admin_flag';
11701: l_custom_rec.attribute_value := get_admin_status;
11702: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
11703: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
11704: x_custom_output.EXTEND;
11705: x_custom_output (3) := l_custom_rec;
11706: l_custom_rec.attribute_name := ':l_country';

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

11699: x_custom_output (2) := l_custom_rec;
11700: l_custom_rec.attribute_name := ':l_admin_flag';
11701: l_custom_rec.attribute_value := get_admin_status;
11702: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
11703: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
11704: x_custom_output.EXTEND;
11705: x_custom_output (3) := l_custom_rec;
11706: l_custom_rec.attribute_name := ':l_country';
11707: l_custom_rec.attribute_value := l_country;

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

11704: x_custom_output.EXTEND;
11705: x_custom_output (3) := l_custom_rec;
11706: l_custom_rec.attribute_name := ':l_country';
11707: l_custom_rec.attribute_value := l_country;
11708: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
11709: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
11710: x_custom_output.EXTEND;
11711: x_custom_output (4) := l_custom_rec;
11712: l_custom_rec.attribute_name := ':l_cat_id';

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

11705: x_custom_output (3) := l_custom_rec;
11706: l_custom_rec.attribute_name := ':l_country';
11707: l_custom_rec.attribute_value := l_country;
11708: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
11709: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
11710: x_custom_output.EXTEND;
11711: x_custom_output (4) := l_custom_rec;
11712: l_custom_rec.attribute_name := ':l_cat_id';
11713: l_custom_rec.attribute_value := l_cat_id;

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

11710: x_custom_output.EXTEND;
11711: x_custom_output (4) := l_custom_rec;
11712: l_custom_rec.attribute_name := ':l_cat_id';
11713: l_custom_rec.attribute_value := l_cat_id;
11714: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
11715: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
11716: x_custom_output.EXTEND;
11717: x_custom_output (5) := l_custom_rec;
11718: l_custom_rec.attribute_name := ':l_campaign_id';

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

11711: x_custom_output (4) := l_custom_rec;
11712: l_custom_rec.attribute_name := ':l_cat_id';
11713: l_custom_rec.attribute_value := l_cat_id;
11714: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
11715: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
11716: x_custom_output.EXTEND;
11717: x_custom_output (5) := l_custom_rec;
11718: l_custom_rec.attribute_name := ':l_campaign_id';
11719: l_custom_rec.attribute_value := l_campaign_id;

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

11716: x_custom_output.EXTEND;
11717: x_custom_output (5) := l_custom_rec;
11718: l_custom_rec.attribute_name := ':l_campaign_id';
11719: l_custom_rec.attribute_value := l_campaign_id;
11720: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
11721: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
11722: x_custom_output.EXTEND;
11723: x_custom_output (6) := l_custom_rec;
11724: write_debug ('GET_LEAD_OPTY_CONV_SQL', 'QUERY', '_', l_sqltext);

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

11717: x_custom_output (5) := l_custom_rec;
11718: l_custom_rec.attribute_name := ':l_campaign_id';
11719: l_custom_rec.attribute_value := l_campaign_id;
11720: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
11721: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
11722: x_custom_output.EXTEND;
11723: x_custom_output (6) := l_custom_rec;
11724: write_debug ('GET_LEAD_OPTY_CONV_SQL', 'QUERY', '_', l_sqltext);
11725: EXCEPTION

Line 11816: l_custom_rec := bis_pmv_parameters_pub.initialize_query_type;

11812: l_jtf varchar2(300);
11813:
11814: BEGIN
11815: x_custom_output := bis_query_attributes_tbl ();
11816: l_custom_rec := bis_pmv_parameters_pub.initialize_query_type;
11817: bim_pmv_dbi_utl_pkg.get_bim_page_params(p_page_parameter_tbl,
11818: l_as_of_date,
11819: l_period_type,
11820: l_record_type_id,

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

12554:
12555: x_custom_sql := l_sqltext;
12556: l_custom_rec.attribute_name := ':l_record_type';
12557: l_custom_rec.attribute_value := l_record_type_id;
12558: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
12559: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
12560: x_custom_output.EXTEND;
12561: x_custom_output (1) := l_custom_rec;
12562: l_custom_rec.attribute_name := ':l_resource_id';

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

12555: x_custom_sql := l_sqltext;
12556: l_custom_rec.attribute_name := ':l_record_type';
12557: l_custom_rec.attribute_value := l_record_type_id;
12558: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
12559: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
12560: x_custom_output.EXTEND;
12561: x_custom_output (1) := l_custom_rec;
12562: l_custom_rec.attribute_name := ':l_resource_id';
12563: l_custom_rec.attribute_value := get_resource_id;

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

12560: x_custom_output.EXTEND;
12561: x_custom_output (1) := l_custom_rec;
12562: l_custom_rec.attribute_name := ':l_resource_id';
12563: l_custom_rec.attribute_value := get_resource_id;
12564: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
12565: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
12566: x_custom_output.EXTEND;
12567: x_custom_output (2) := l_custom_rec;
12568: l_custom_rec.attribute_name := ':l_admin_flag';

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

12561: x_custom_output (1) := l_custom_rec;
12562: l_custom_rec.attribute_name := ':l_resource_id';
12563: l_custom_rec.attribute_value := get_resource_id;
12564: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
12565: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
12566: x_custom_output.EXTEND;
12567: x_custom_output (2) := l_custom_rec;
12568: l_custom_rec.attribute_name := ':l_admin_flag';
12569: l_custom_rec.attribute_value := get_admin_status;

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

12566: x_custom_output.EXTEND;
12567: x_custom_output (2) := l_custom_rec;
12568: l_custom_rec.attribute_name := ':l_admin_flag';
12569: l_custom_rec.attribute_value := get_admin_status;
12570: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
12571: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
12572: x_custom_output.EXTEND;
12573: x_custom_output (3) := l_custom_rec;
12574: l_custom_rec.attribute_name := ':l_country';

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

12567: x_custom_output (2) := l_custom_rec;
12568: l_custom_rec.attribute_name := ':l_admin_flag';
12569: l_custom_rec.attribute_value := get_admin_status;
12570: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
12571: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
12572: x_custom_output.EXTEND;
12573: x_custom_output (3) := l_custom_rec;
12574: l_custom_rec.attribute_name := ':l_country';
12575: l_custom_rec.attribute_value := l_country;

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

12572: x_custom_output.EXTEND;
12573: x_custom_output (3) := l_custom_rec;
12574: l_custom_rec.attribute_name := ':l_country';
12575: l_custom_rec.attribute_value := l_country;
12576: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
12577: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
12578: x_custom_output.EXTEND;
12579: x_custom_output (4) := l_custom_rec;
12580: l_custom_rec.attribute_name := ':l_cat_id';

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

12573: x_custom_output (3) := l_custom_rec;
12574: l_custom_rec.attribute_name := ':l_country';
12575: l_custom_rec.attribute_value := l_country;
12576: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
12577: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
12578: x_custom_output.EXTEND;
12579: x_custom_output (4) := l_custom_rec;
12580: l_custom_rec.attribute_name := ':l_cat_id';
12581: l_custom_rec.attribute_value := l_cat_id;

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

12578: x_custom_output.EXTEND;
12579: x_custom_output (4) := l_custom_rec;
12580: l_custom_rec.attribute_name := ':l_cat_id';
12581: l_custom_rec.attribute_value := l_cat_id;
12582: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
12583: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
12584: x_custom_output.EXTEND;
12585: x_custom_output (5) := l_custom_rec;
12586: l_custom_rec.attribute_name := ':l_campaign_id';

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

12579: x_custom_output (4) := l_custom_rec;
12580: l_custom_rec.attribute_name := ':l_cat_id';
12581: l_custom_rec.attribute_value := l_cat_id;
12582: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
12583: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
12584: x_custom_output.EXTEND;
12585: x_custom_output (5) := l_custom_rec;
12586: l_custom_rec.attribute_name := ':l_campaign_id';
12587: l_custom_rec.attribute_value := l_campaign_id;

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

12584: x_custom_output.EXTEND;
12585: x_custom_output (5) := l_custom_rec;
12586: l_custom_rec.attribute_name := ':l_campaign_id';
12587: l_custom_rec.attribute_value := l_campaign_id;
12588: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
12589: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
12590: x_custom_output.EXTEND;
12591: x_custom_output (6) := l_custom_rec;
12592: write_debug ('GET_', 'QUERY', '_', l_sqltext);

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

12585: x_custom_output (5) := l_custom_rec;
12586: l_custom_rec.attribute_name := ':l_campaign_id';
12587: l_custom_rec.attribute_value := l_campaign_id;
12588: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
12589: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
12590: x_custom_output.EXTEND;
12591: x_custom_output (6) := l_custom_rec;
12592: write_debug ('GET_', 'QUERY', '_', l_sqltext);
12593: EXCEPTION

Line 12682: l_custom_rec := bis_pmv_parameters_pub.initialize_query_type;

12678: l_media VARCHAR2(300);
12679: l_jtf varchar2(300);
12680: BEGIN
12681: x_custom_output := bis_query_attributes_tbl ();
12682: l_custom_rec := bis_pmv_parameters_pub.initialize_query_type;
12683:
12684: bim_pmv_dbi_utl_pkg.get_bim_page_params(p_page_parameter_tbl,
12685: l_as_of_date,
12686: l_period_type,

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

13400:
13401: x_custom_sql := l_sqltext;
13402: l_custom_rec.attribute_name := ':l_record_type';
13403: l_custom_rec.attribute_value := l_record_type_id;
13404: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
13405: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
13406: x_custom_output.EXTEND;
13407: x_custom_output (1) := l_custom_rec;
13408: l_custom_rec.attribute_name := ':l_resource_id';

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

13401: x_custom_sql := l_sqltext;
13402: l_custom_rec.attribute_name := ':l_record_type';
13403: l_custom_rec.attribute_value := l_record_type_id;
13404: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
13405: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
13406: x_custom_output.EXTEND;
13407: x_custom_output (1) := l_custom_rec;
13408: l_custom_rec.attribute_name := ':l_resource_id';
13409: l_custom_rec.attribute_value := get_resource_id;

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

13406: x_custom_output.EXTEND;
13407: x_custom_output (1) := l_custom_rec;
13408: l_custom_rec.attribute_name := ':l_resource_id';
13409: l_custom_rec.attribute_value := get_resource_id;
13410: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
13411: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
13412: x_custom_output.EXTEND;
13413: x_custom_output (2) := l_custom_rec;
13414: l_custom_rec.attribute_name := ':l_admin_flag';

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

13407: x_custom_output (1) := l_custom_rec;
13408: l_custom_rec.attribute_name := ':l_resource_id';
13409: l_custom_rec.attribute_value := get_resource_id;
13410: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
13411: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
13412: x_custom_output.EXTEND;
13413: x_custom_output (2) := l_custom_rec;
13414: l_custom_rec.attribute_name := ':l_admin_flag';
13415: l_custom_rec.attribute_value := get_admin_status;

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

13412: x_custom_output.EXTEND;
13413: x_custom_output (2) := l_custom_rec;
13414: l_custom_rec.attribute_name := ':l_admin_flag';
13415: l_custom_rec.attribute_value := get_admin_status;
13416: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
13417: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
13418: x_custom_output.EXTEND;
13419: x_custom_output (3) := l_custom_rec;
13420: l_custom_rec.attribute_name := ':l_country';

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

13413: x_custom_output (2) := l_custom_rec;
13414: l_custom_rec.attribute_name := ':l_admin_flag';
13415: l_custom_rec.attribute_value := get_admin_status;
13416: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
13417: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
13418: x_custom_output.EXTEND;
13419: x_custom_output (3) := l_custom_rec;
13420: l_custom_rec.attribute_name := ':l_country';
13421: l_custom_rec.attribute_value := l_country;

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

13418: x_custom_output.EXTEND;
13419: x_custom_output (3) := l_custom_rec;
13420: l_custom_rec.attribute_name := ':l_country';
13421: l_custom_rec.attribute_value := l_country;
13422: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
13423: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
13424: x_custom_output.EXTEND;
13425: x_custom_output (4) := l_custom_rec;
13426: l_custom_rec.attribute_name := ':l_cat_id';

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

13419: x_custom_output (3) := l_custom_rec;
13420: l_custom_rec.attribute_name := ':l_country';
13421: l_custom_rec.attribute_value := l_country;
13422: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
13423: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
13424: x_custom_output.EXTEND;
13425: x_custom_output (4) := l_custom_rec;
13426: l_custom_rec.attribute_name := ':l_cat_id';
13427: l_custom_rec.attribute_value := l_cat_id;

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

13424: x_custom_output.EXTEND;
13425: x_custom_output (4) := l_custom_rec;
13426: l_custom_rec.attribute_name := ':l_cat_id';
13427: l_custom_rec.attribute_value := l_cat_id;
13428: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
13429: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
13430: x_custom_output.EXTEND;
13431: x_custom_output (5) := l_custom_rec;
13432: l_custom_rec.attribute_name := ':l_campaign_id';

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

13425: x_custom_output (4) := l_custom_rec;
13426: l_custom_rec.attribute_name := ':l_cat_id';
13427: l_custom_rec.attribute_value := l_cat_id;
13428: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
13429: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
13430: x_custom_output.EXTEND;
13431: x_custom_output (5) := l_custom_rec;
13432: l_custom_rec.attribute_name := ':l_campaign_id';
13433: l_custom_rec.attribute_value := l_campaign_id;

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

13430: x_custom_output.EXTEND;
13431: x_custom_output (5) := l_custom_rec;
13432: l_custom_rec.attribute_name := ':l_campaign_id';
13433: l_custom_rec.attribute_value := l_campaign_id;
13434: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
13435: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
13436: x_custom_output.EXTEND;
13437: x_custom_output (6) := l_custom_rec;
13438: write_debug ('GET_MKTG_NEW_LEADS_SQL', 'QUERY', '_', l_sqltext);

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

13431: x_custom_output (5) := l_custom_rec;
13432: l_custom_rec.attribute_name := ':l_campaign_id';
13433: l_custom_rec.attribute_value := l_campaign_id;
13434: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
13435: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
13436: x_custom_output.EXTEND;
13437: x_custom_output (6) := l_custom_rec;
13438: write_debug ('GET_MKTG_NEW_LEADS_SQL', 'QUERY', '_', l_sqltext);
13439: EXCEPTION

Line 13491: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

13487: l_curr_suffix VARCHAR2(50);
13488: l_media VARCHAR2(300);
13489: BEGIN
13490: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
13491: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
13492: bim_pmv_dbi_utl_pkg.get_bim_page_params(p_page_parameter_tbl,
13493: l_as_of_date,
13494: l_period_type,
13495: l_record_type_id,

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

15301:
15302: x_custom_sql := l_sqltext;
15303: l_custom_rec.attribute_name := ':l_record_type';
15304: l_custom_rec.attribute_value := l_record_type_id;
15305: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
15306: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
15307: x_custom_output.EXTEND;
15308: x_custom_output(1) := l_custom_rec;
15309:

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

15302: x_custom_sql := l_sqltext;
15303: l_custom_rec.attribute_name := ':l_record_type';
15304: l_custom_rec.attribute_value := l_record_type_id;
15305: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
15306: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
15307: x_custom_output.EXTEND;
15308: x_custom_output(1) := l_custom_rec;
15309:
15310: l_custom_rec.attribute_name := ':l_resource_id';

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

15308: x_custom_output(1) := l_custom_rec;
15309:
15310: l_custom_rec.attribute_name := ':l_resource_id';
15311: l_custom_rec.attribute_value := GET_RESOURCE_ID;
15312: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
15313: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
15314: x_custom_output.EXTEND;
15315: x_custom_output(2) := l_custom_rec;
15316:

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

15309:
15310: l_custom_rec.attribute_name := ':l_resource_id';
15311: l_custom_rec.attribute_value := GET_RESOURCE_ID;
15312: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
15313: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
15314: x_custom_output.EXTEND;
15315: x_custom_output(2) := l_custom_rec;
15316:
15317: l_custom_rec.attribute_name := ':l_admin_flag';

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

15315: x_custom_output(2) := l_custom_rec;
15316:
15317: l_custom_rec.attribute_name := ':l_admin_flag';
15318: l_custom_rec.attribute_value := GET_ADMIN_STATUS;
15319: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
15320: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
15321: x_custom_output.EXTEND;
15322: x_custom_output(3) := l_custom_rec;
15323:

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

15316:
15317: l_custom_rec.attribute_name := ':l_admin_flag';
15318: l_custom_rec.attribute_value := GET_ADMIN_STATUS;
15319: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
15320: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
15321: x_custom_output.EXTEND;
15322: x_custom_output(3) := l_custom_rec;
15323:
15324: l_custom_rec.attribute_name := ':l_country';

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

15322: x_custom_output(3) := l_custom_rec;
15323:
15324: l_custom_rec.attribute_name := ':l_country';
15325: l_custom_rec.attribute_value := l_country;
15326: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
15327: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
15328: x_custom_output.EXTEND;
15329: x_custom_output(4) := l_custom_rec;
15330:

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

15323:
15324: l_custom_rec.attribute_name := ':l_country';
15325: l_custom_rec.attribute_value := l_country;
15326: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
15327: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
15328: x_custom_output.EXTEND;
15329: x_custom_output(4) := l_custom_rec;
15330:
15331: l_custom_rec.attribute_name := ':l_cat_id';

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

15329: x_custom_output(4) := l_custom_rec;
15330:
15331: l_custom_rec.attribute_name := ':l_cat_id';
15332: l_custom_rec.attribute_value := l_cat_id;
15333: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
15334: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
15335: x_custom_output.EXTEND;
15336: x_custom_output(5) := l_custom_rec;
15337:

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

15330:
15331: l_custom_rec.attribute_name := ':l_cat_id';
15332: l_custom_rec.attribute_value := l_cat_id;
15333: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
15334: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
15335: x_custom_output.EXTEND;
15336: x_custom_output(5) := l_custom_rec;
15337:
15338:

Line 15392: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

15388: l_curr_suffix VARCHAR2(50);
15389: l_media VARCHAR2(300);
15390: BEGIN
15391: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
15392: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
15393: bim_pmv_dbi_utl_pkg.get_bim_page_params(p_page_parameter_tbl,
15394: l_as_of_date,
15395: l_period_type,
15396: l_record_type_id,

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

17192:
17193: x_custom_sql := l_sqltext;
17194: l_custom_rec.attribute_name := ':l_record_type';
17195: l_custom_rec.attribute_value := l_record_type_id;
17196: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
17197: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
17198: x_custom_output.EXTEND;
17199: x_custom_output(1) := l_custom_rec;
17200:

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

17193: x_custom_sql := l_sqltext;
17194: l_custom_rec.attribute_name := ':l_record_type';
17195: l_custom_rec.attribute_value := l_record_type_id;
17196: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
17197: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
17198: x_custom_output.EXTEND;
17199: x_custom_output(1) := l_custom_rec;
17200:
17201: l_custom_rec.attribute_name := ':l_resource_id';

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

17199: x_custom_output(1) := l_custom_rec;
17200:
17201: l_custom_rec.attribute_name := ':l_resource_id';
17202: l_custom_rec.attribute_value := GET_RESOURCE_ID;
17203: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
17204: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
17205: x_custom_output.EXTEND;
17206: x_custom_output(2) := l_custom_rec;
17207:

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

17200:
17201: l_custom_rec.attribute_name := ':l_resource_id';
17202: l_custom_rec.attribute_value := GET_RESOURCE_ID;
17203: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
17204: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
17205: x_custom_output.EXTEND;
17206: x_custom_output(2) := l_custom_rec;
17207:
17208: l_custom_rec.attribute_name := ':l_admin_flag';

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

17206: x_custom_output(2) := l_custom_rec;
17207:
17208: l_custom_rec.attribute_name := ':l_admin_flag';
17209: l_custom_rec.attribute_value := GET_ADMIN_STATUS;
17210: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
17211: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
17212: x_custom_output.EXTEND;
17213: x_custom_output(3) := l_custom_rec;
17214:

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

17207:
17208: l_custom_rec.attribute_name := ':l_admin_flag';
17209: l_custom_rec.attribute_value := GET_ADMIN_STATUS;
17210: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
17211: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
17212: x_custom_output.EXTEND;
17213: x_custom_output(3) := l_custom_rec;
17214:
17215: l_custom_rec.attribute_name := ':l_country';

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

17213: x_custom_output(3) := l_custom_rec;
17214:
17215: l_custom_rec.attribute_name := ':l_country';
17216: l_custom_rec.attribute_value := l_country;
17217: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
17218: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
17219: x_custom_output.EXTEND;
17220: x_custom_output(4) := l_custom_rec;
17221:

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

17214:
17215: l_custom_rec.attribute_name := ':l_country';
17216: l_custom_rec.attribute_value := l_country;
17217: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
17218: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
17219: x_custom_output.EXTEND;
17220: x_custom_output(4) := l_custom_rec;
17221:
17222: l_custom_rec.attribute_name := ':l_cat_id';

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

17220: x_custom_output(4) := l_custom_rec;
17221:
17222: l_custom_rec.attribute_name := ':l_cat_id';
17223: l_custom_rec.attribute_value := l_cat_id;
17224: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
17225: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
17226: x_custom_output.EXTEND;
17227: x_custom_output(5) := l_custom_rec;
17228:

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

17221:
17222: l_custom_rec.attribute_name := ':l_cat_id';
17223: l_custom_rec.attribute_value := l_cat_id;
17224: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
17225: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
17226: x_custom_output.EXTEND;
17227: x_custom_output(5) := l_custom_rec;
17228:
17229:

Line 17289: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

17285: l_group_by varchar2(5000);
17286:
17287: BEGIN
17288: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
17289: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
17290:
17291: bim_pmv_dbi_utl_pkg.get_bim_page_params(p_page_parameter_tbl,
17292: l_as_of_date,
17293: l_period_type,

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

17556:
17557: x_custom_sql := l_sqltext;
17558: l_custom_rec.attribute_name := ':l_record_type';
17559: l_custom_rec.attribute_value := l_record_type_id;
17560: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
17561: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
17562: x_custom_output.EXTEND;
17563: x_custom_output(1) := l_custom_rec;
17564:

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

17557: x_custom_sql := l_sqltext;
17558: l_custom_rec.attribute_name := ':l_record_type';
17559: l_custom_rec.attribute_value := l_record_type_id;
17560: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
17561: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
17562: x_custom_output.EXTEND;
17563: x_custom_output(1) := l_custom_rec;
17564:
17565: l_custom_rec.attribute_name := ':l_resource_id';

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

17563: x_custom_output(1) := l_custom_rec;
17564:
17565: l_custom_rec.attribute_name := ':l_resource_id';
17566: l_custom_rec.attribute_value := GET_RESOURCE_ID;
17567: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
17568: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
17569: x_custom_output.EXTEND;
17570: x_custom_output(2) := l_custom_rec;
17571:

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

17564:
17565: l_custom_rec.attribute_name := ':l_resource_id';
17566: l_custom_rec.attribute_value := GET_RESOURCE_ID;
17567: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
17568: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
17569: x_custom_output.EXTEND;
17570: x_custom_output(2) := l_custom_rec;
17571:
17572: l_custom_rec.attribute_name := ':l_admin_flag';

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

17570: x_custom_output(2) := l_custom_rec;
17571:
17572: l_custom_rec.attribute_name := ':l_admin_flag';
17573: l_custom_rec.attribute_value := GET_ADMIN_STATUS;
17574: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
17575: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
17576: x_custom_output.EXTEND;
17577: x_custom_output(3) := l_custom_rec;
17578:

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

17571:
17572: l_custom_rec.attribute_name := ':l_admin_flag';
17573: l_custom_rec.attribute_value := GET_ADMIN_STATUS;
17574: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
17575: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
17576: x_custom_output.EXTEND;
17577: x_custom_output(3) := l_custom_rec;
17578:
17579: l_custom_rec.attribute_name := ':l_country';

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

17577: x_custom_output(3) := l_custom_rec;
17578:
17579: l_custom_rec.attribute_name := ':l_country';
17580: l_custom_rec.attribute_value := l_country;
17581: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
17582: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
17583: x_custom_output.EXTEND;
17584: x_custom_output(4) := l_custom_rec;
17585:

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

17578:
17579: l_custom_rec.attribute_name := ':l_country';
17580: l_custom_rec.attribute_value := l_country;
17581: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
17582: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
17583: x_custom_output.EXTEND;
17584: x_custom_output(4) := l_custom_rec;
17585:
17586: l_custom_rec.attribute_name := ':l_cat_id';

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

17584: x_custom_output(4) := l_custom_rec;
17585:
17586: l_custom_rec.attribute_name := ':l_cat_id';
17587: l_custom_rec.attribute_value := l_cat_id;
17588: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
17589: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
17590: x_custom_output.EXTEND;
17591: x_custom_output(5) := l_custom_rec;
17592:

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

17585:
17586: l_custom_rec.attribute_name := ':l_cat_id';
17587: l_custom_rec.attribute_value := l_cat_id;
17588: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
17589: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
17590: x_custom_output.EXTEND;
17591: x_custom_output(5) := l_custom_rec;
17592:
17593: l_custom_rec.attribute_name := ':l_area';

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

17591: x_custom_output(5) := l_custom_rec;
17592:
17593: l_custom_rec.attribute_name := ':l_area';
17594: l_custom_rec.attribute_value := l_area;
17595: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
17596: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
17597: x_custom_output.EXTEND;
17598: x_custom_output(6) := l_custom_rec;
17599:

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

17592:
17593: l_custom_rec.attribute_name := ':l_area';
17594: l_custom_rec.attribute_value := l_area;
17595: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
17596: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
17597: x_custom_output.EXTEND;
17598: x_custom_output(6) := l_custom_rec;
17599:
17600: EXCEPTION

Line 17664: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

17660: l_url_str3_r VARCHAR2(1000);
17661:
17662: BEGIN
17663: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
17664: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
17665: bim_pmv_dbi_utl_pkg.get_bim_page_params(p_page_parameter_tbl,
17666: l_as_of_date,
17667: l_period_type,
17668: l_record_type_id,

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

19819:
19820: x_custom_sql := l_sqltext;
19821: l_custom_rec.attribute_name := ':l_record_type';
19822: l_custom_rec.attribute_value := l_record_type_id;
19823: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
19824: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
19825: x_custom_output.EXTEND;
19826: x_custom_output(1) := l_custom_rec;
19827:

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

19820: x_custom_sql := l_sqltext;
19821: l_custom_rec.attribute_name := ':l_record_type';
19822: l_custom_rec.attribute_value := l_record_type_id;
19823: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
19824: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
19825: x_custom_output.EXTEND;
19826: x_custom_output(1) := l_custom_rec;
19827:
19828: l_custom_rec.attribute_name := ':l_resource_id';

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

19826: x_custom_output(1) := l_custom_rec;
19827:
19828: l_custom_rec.attribute_name := ':l_resource_id';
19829: l_custom_rec.attribute_value := GET_RESOURCE_ID;
19830: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
19831: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
19832: x_custom_output.EXTEND;
19833: x_custom_output(2) := l_custom_rec;
19834:

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

19827:
19828: l_custom_rec.attribute_name := ':l_resource_id';
19829: l_custom_rec.attribute_value := GET_RESOURCE_ID;
19830: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
19831: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
19832: x_custom_output.EXTEND;
19833: x_custom_output(2) := l_custom_rec;
19834:
19835: l_custom_rec.attribute_name := ':l_admin_flag';

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

19833: x_custom_output(2) := l_custom_rec;
19834:
19835: l_custom_rec.attribute_name := ':l_admin_flag';
19836: l_custom_rec.attribute_value := GET_ADMIN_STATUS;
19837: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
19838: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
19839: x_custom_output.EXTEND;
19840: x_custom_output(3) := l_custom_rec;
19841:

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

19834:
19835: l_custom_rec.attribute_name := ':l_admin_flag';
19836: l_custom_rec.attribute_value := GET_ADMIN_STATUS;
19837: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
19838: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
19839: x_custom_output.EXTEND;
19840: x_custom_output(3) := l_custom_rec;
19841:
19842: l_custom_rec.attribute_name := ':l_country';

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

19840: x_custom_output(3) := l_custom_rec;
19841:
19842: l_custom_rec.attribute_name := ':l_country';
19843: l_custom_rec.attribute_value := l_country;
19844: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
19845: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
19846: x_custom_output.EXTEND;
19847: x_custom_output(4) := l_custom_rec;
19848:

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

19841:
19842: l_custom_rec.attribute_name := ':l_country';
19843: l_custom_rec.attribute_value := l_country;
19844: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
19845: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
19846: x_custom_output.EXTEND;
19847: x_custom_output(4) := l_custom_rec;
19848:
19849: l_custom_rec.attribute_name := ':l_cat_id';

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

19847: x_custom_output(4) := l_custom_rec;
19848:
19849: l_custom_rec.attribute_name := ':l_cat_id';
19850: l_custom_rec.attribute_value := l_cat_id;
19851: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
19852: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
19853: x_custom_output.EXTEND;
19854: x_custom_output(5) := l_custom_rec;
19855:

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

19848:
19849: l_custom_rec.attribute_name := ':l_cat_id';
19850: l_custom_rec.attribute_value := l_cat_id;
19851: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
19852: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
19853: x_custom_output.EXTEND;
19854: x_custom_output(5) := l_custom_rec;
19855:
19856: l_custom_rec.attribute_name := ':l_view_by';

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

19854: x_custom_output(5) := l_custom_rec;
19855:
19856: l_custom_rec.attribute_name := ':l_view_by';
19857: l_custom_rec.attribute_value := l_view_by;
19858: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
19859: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
19860: x_custom_output.EXTEND;
19861: x_custom_output(6) := l_custom_rec;
19862:

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

19855:
19856: l_custom_rec.attribute_name := ':l_view_by';
19857: l_custom_rec.attribute_value := l_view_by;
19858: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
19859: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
19860: x_custom_output.EXTEND;
19861: x_custom_output(6) := l_custom_rec;
19862:
19863: l_custom_rec.attribute_name := ':l_area';

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

19861: x_custom_output(6) := l_custom_rec;
19862:
19863: l_custom_rec.attribute_name := ':l_area';
19864: l_custom_rec.attribute_value := l_area;
19865: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
19866: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
19867: x_custom_output.EXTEND;
19868: x_custom_output(7) := l_custom_rec;
19869:

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

19862:
19863: l_custom_rec.attribute_name := ':l_area';
19864: l_custom_rec.attribute_value := l_area;
19865: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
19866: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
19867: x_custom_output.EXTEND;
19868: x_custom_output(7) := l_custom_rec;
19869:
19870: l_custom_rec.attribute_name := ':l_media';

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

19868: x_custom_output(7) := l_custom_rec;
19869:
19870: l_custom_rec.attribute_name := ':l_media';
19871: l_custom_rec.attribute_value := l_media;
19872: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
19873: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
19874: x_custom_output.EXTEND;
19875: x_custom_output(8) := l_custom_rec;
19876:

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

19869:
19870: l_custom_rec.attribute_name := ':l_media';
19871: l_custom_rec.attribute_value := l_media;
19872: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
19873: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
19874: x_custom_output.EXTEND;
19875: x_custom_output(8) := l_custom_rec;
19876:
19877: --write_debug('GET_CSCH_START_SQL','QUERY','_',l_sqltext);

Line 19941: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

19937: l_curr_suffix1 VARCHAR2(50);
19938:
19939: BEGIN
19940: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
19941: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
19942: bim_pmv_dbi_utl_pkg.get_bim_page_params(p_page_parameter_tbl,
19943: l_as_of_date,
19944: l_period_type,
19945: l_record_type_id,

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

20068:
20069: x_custom_sql := l_sqltext;
20070: l_custom_rec.attribute_name := ':l_record_type';
20071: l_custom_rec.attribute_value := l_record_type_id;
20072: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
20073: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
20074: x_custom_output.EXTEND;
20075: x_custom_output(1) := l_custom_rec;
20076:

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

20069: x_custom_sql := l_sqltext;
20070: l_custom_rec.attribute_name := ':l_record_type';
20071: l_custom_rec.attribute_value := l_record_type_id;
20072: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
20073: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
20074: x_custom_output.EXTEND;
20075: x_custom_output(1) := l_custom_rec;
20076:
20077: l_custom_rec.attribute_name := ':l_resource_id';

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

20075: x_custom_output(1) := l_custom_rec;
20076:
20077: l_custom_rec.attribute_name := ':l_resource_id';
20078: l_custom_rec.attribute_value := GET_RESOURCE_ID;
20079: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
20080: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
20081: x_custom_output.EXTEND;
20082: x_custom_output(2) := l_custom_rec;
20083:

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

20076:
20077: l_custom_rec.attribute_name := ':l_resource_id';
20078: l_custom_rec.attribute_value := GET_RESOURCE_ID;
20079: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
20080: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
20081: x_custom_output.EXTEND;
20082: x_custom_output(2) := l_custom_rec;
20083:
20084: l_custom_rec.attribute_name := ':l_admin_flag';

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

20082: x_custom_output(2) := l_custom_rec;
20083:
20084: l_custom_rec.attribute_name := ':l_admin_flag';
20085: l_custom_rec.attribute_value := GET_ADMIN_STATUS;
20086: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
20087: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
20088: x_custom_output.EXTEND;
20089: x_custom_output(3) := l_custom_rec;
20090:

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

20083:
20084: l_custom_rec.attribute_name := ':l_admin_flag';
20085: l_custom_rec.attribute_value := GET_ADMIN_STATUS;
20086: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
20087: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
20088: x_custom_output.EXTEND;
20089: x_custom_output(3) := l_custom_rec;
20090:
20091: l_custom_rec.attribute_name := ':l_country';

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

20089: x_custom_output(3) := l_custom_rec;
20090:
20091: l_custom_rec.attribute_name := ':l_country';
20092: l_custom_rec.attribute_value := l_country;
20093: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
20094: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
20095: x_custom_output.EXTEND;
20096: x_custom_output(4) := l_custom_rec;
20097:

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

20090:
20091: l_custom_rec.attribute_name := ':l_country';
20092: l_custom_rec.attribute_value := l_country;
20093: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
20094: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
20095: x_custom_output.EXTEND;
20096: x_custom_output(4) := l_custom_rec;
20097:
20098: l_custom_rec.attribute_name := ':l_cat_id';

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

20096: x_custom_output(4) := l_custom_rec;
20097:
20098: l_custom_rec.attribute_name := ':l_cat_id';
20099: l_custom_rec.attribute_value := l_cat_id;
20100: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
20101: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
20102: x_custom_output.EXTEND;
20103: x_custom_output(5) := l_custom_rec;
20104:

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

20097:
20098: l_custom_rec.attribute_name := ':l_cat_id';
20099: l_custom_rec.attribute_value := l_cat_id;
20100: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
20101: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
20102: x_custom_output.EXTEND;
20103: x_custom_output(5) := l_custom_rec;
20104:
20105: l_custom_rec.attribute_name := ':l_media';

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

20103: x_custom_output(5) := l_custom_rec;
20104:
20105: l_custom_rec.attribute_name := ':l_media';
20106: l_custom_rec.attribute_value := l_media;
20107: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
20108: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
20109: x_custom_output.EXTEND;
20110: x_custom_output(4) := l_custom_rec;
20111:

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

20104:
20105: l_custom_rec.attribute_name := ':l_media';
20106: l_custom_rec.attribute_value := l_media;
20107: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
20108: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
20109: x_custom_output.EXTEND;
20110: x_custom_output(4) := l_custom_rec;
20111:
20112: l_custom_rec.attribute_name := ':l_area';

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

20110: x_custom_output(4) := l_custom_rec;
20111:
20112: l_custom_rec.attribute_name := ':l_area';
20113: l_custom_rec.attribute_value := l_area;
20114: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
20115: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
20116: x_custom_output.EXTEND;
20117: x_custom_output(5) := l_custom_rec;
20118:

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

20111:
20112: l_custom_rec.attribute_name := ':l_area';
20113: l_custom_rec.attribute_value := l_area;
20114: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
20115: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
20116: x_custom_output.EXTEND;
20117: x_custom_output(5) := l_custom_rec;
20118:
20119: --write_debug('GET_CSCH_DETL_SQL','QUERY','_',l_sqltext);

Line 20223: l_custom_rec := bis_pmv_parameters_pub.initialize_query_type;

20219: l_prog_cost1 VARCHAR2(30);
20220:
20221: BEGIN
20222: x_custom_output := bis_query_attributes_tbl();
20223: l_custom_rec := bis_pmv_parameters_pub.initialize_query_type;
20224: bim_pmv_dbi_utl_pkg.get_bim_page_params(p_page_parameter_tbl,
20225: l_as_of_date,
20226: l_period_type,
20227: l_record_type_id,

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

20839: END IF;
20840: x_custom_sql := l_sqltext;
20841: l_custom_rec.attribute_name := ':l_record_type';
20842: l_custom_rec.attribute_value := l_record_type_id;
20843: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
20844: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
20845: x_custom_output.EXTEND;
20846: x_custom_output(1) := l_custom_rec;
20847: l_custom_rec.attribute_name := ':l_resource_id';

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

20840: x_custom_sql := l_sqltext;
20841: l_custom_rec.attribute_name := ':l_record_type';
20842: l_custom_rec.attribute_value := l_record_type_id;
20843: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
20844: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
20845: x_custom_output.EXTEND;
20846: x_custom_output(1) := l_custom_rec;
20847: l_custom_rec.attribute_name := ':l_resource_id';
20848: l_custom_rec.attribute_value := get_resource_id;

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

20845: x_custom_output.EXTEND;
20846: x_custom_output(1) := l_custom_rec;
20847: l_custom_rec.attribute_name := ':l_resource_id';
20848: l_custom_rec.attribute_value := get_resource_id;
20849: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
20850: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
20851: x_custom_output.EXTEND;
20852: x_custom_output(2) := l_custom_rec;
20853: l_custom_rec.attribute_name := ':l_admin_flag';

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

20846: x_custom_output(1) := l_custom_rec;
20847: l_custom_rec.attribute_name := ':l_resource_id';
20848: l_custom_rec.attribute_value := get_resource_id;
20849: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
20850: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
20851: x_custom_output.EXTEND;
20852: x_custom_output(2) := l_custom_rec;
20853: l_custom_rec.attribute_name := ':l_admin_flag';
20854: l_custom_rec.attribute_value := get_admin_status;

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

20851: x_custom_output.EXTEND;
20852: x_custom_output(2) := l_custom_rec;
20853: l_custom_rec.attribute_name := ':l_admin_flag';
20854: l_custom_rec.attribute_value := get_admin_status;
20855: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
20856: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
20857: x_custom_output.EXTEND;
20858: x_custom_output(3) := l_custom_rec;
20859: l_custom_rec.attribute_name := ':l_country';

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

20852: x_custom_output(2) := l_custom_rec;
20853: l_custom_rec.attribute_name := ':l_admin_flag';
20854: l_custom_rec.attribute_value := get_admin_status;
20855: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
20856: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
20857: x_custom_output.EXTEND;
20858: x_custom_output(3) := l_custom_rec;
20859: l_custom_rec.attribute_name := ':l_country';
20860: l_custom_rec.attribute_value := l_country;

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

20857: x_custom_output.EXTEND;
20858: x_custom_output(3) := l_custom_rec;
20859: l_custom_rec.attribute_name := ':l_country';
20860: l_custom_rec.attribute_value := l_country;
20861: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
20862: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
20863: x_custom_output.EXTEND;
20864: x_custom_output(4) := l_custom_rec;
20865: l_custom_rec.attribute_name := ':l_cat_id';

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

20858: x_custom_output(3) := l_custom_rec;
20859: l_custom_rec.attribute_name := ':l_country';
20860: l_custom_rec.attribute_value := l_country;
20861: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
20862: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
20863: x_custom_output.EXTEND;
20864: x_custom_output(4) := l_custom_rec;
20865: l_custom_rec.attribute_name := ':l_cat_id';
20866: l_custom_rec.attribute_value := l_cat_id;

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

20863: x_custom_output.EXTEND;
20864: x_custom_output(4) := l_custom_rec;
20865: l_custom_rec.attribute_name := ':l_cat_id';
20866: l_custom_rec.attribute_value := l_cat_id;
20867: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
20868: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
20869: x_custom_output.EXTEND;
20870: x_custom_output(5) := l_custom_rec;
20871: l_custom_rec.attribute_name := ':l_campaign_id';

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

20864: x_custom_output(4) := l_custom_rec;
20865: l_custom_rec.attribute_name := ':l_cat_id';
20866: l_custom_rec.attribute_value := l_cat_id;
20867: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
20868: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
20869: x_custom_output.EXTEND;
20870: x_custom_output(5) := l_custom_rec;
20871: l_custom_rec.attribute_name := ':l_campaign_id';
20872: l_custom_rec.attribute_value := l_campaign_id;

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

20869: x_custom_output.EXTEND;
20870: x_custom_output(5) := l_custom_rec;
20871: l_custom_rec.attribute_name := ':l_campaign_id';
20872: l_custom_rec.attribute_value := l_campaign_id;
20873: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
20874: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
20875: x_custom_output.EXTEND;
20876: x_custom_output(6) := l_custom_rec;
20877: write_debug('GET_RESP_SUM_SQL', 'QUERY', '_', l_sqltext);

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

20870: x_custom_output(5) := l_custom_rec;
20871: l_custom_rec.attribute_name := ':l_campaign_id';
20872: l_custom_rec.attribute_value := l_campaign_id;
20873: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
20874: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
20875: x_custom_output.EXTEND;
20876: x_custom_output(6) := l_custom_rec;
20877: write_debug('GET_RESP_SUM_SQL', 'QUERY', '_', l_sqltext);
20878: EXCEPTION

Line 20977: l_custom_rec := bis_pmv_parameters_pub.initialize_query_type;

20973: l_report_name VARCHAR2(300);
20974: l_media VARCHAR2(300);
20975: BEGIN
20976: x_custom_output := bis_query_attributes_tbl ();
20977: l_custom_rec := bis_pmv_parameters_pub.initialize_query_type;
20978: bim_pmv_dbi_utl_pkg.get_bim_page_params(p_page_parameter_tbl,
20979: l_as_of_date,
20980: l_period_type,
20981: l_record_type_id,

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

21732: END IF;
21733: x_custom_sql := l_sqltext;
21734: l_custom_rec.attribute_name := ':l_record_type';
21735: l_custom_rec.attribute_value := l_record_type_id;
21736: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
21737: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
21738: x_custom_output.EXTEND;
21739: x_custom_output (1) := l_custom_rec;
21740: l_custom_rec.attribute_name := ':l_resource_id';

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

21733: x_custom_sql := l_sqltext;
21734: l_custom_rec.attribute_name := ':l_record_type';
21735: l_custom_rec.attribute_value := l_record_type_id;
21736: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
21737: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
21738: x_custom_output.EXTEND;
21739: x_custom_output (1) := l_custom_rec;
21740: l_custom_rec.attribute_name := ':l_resource_id';
21741: l_custom_rec.attribute_value := get_resource_id;

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

21738: x_custom_output.EXTEND;
21739: x_custom_output (1) := l_custom_rec;
21740: l_custom_rec.attribute_name := ':l_resource_id';
21741: l_custom_rec.attribute_value := get_resource_id;
21742: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
21743: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
21744: x_custom_output.EXTEND;
21745: x_custom_output (2) := l_custom_rec;
21746: l_custom_rec.attribute_name := ':l_admin_flag';

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

21739: x_custom_output (1) := l_custom_rec;
21740: l_custom_rec.attribute_name := ':l_resource_id';
21741: l_custom_rec.attribute_value := get_resource_id;
21742: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
21743: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
21744: x_custom_output.EXTEND;
21745: x_custom_output (2) := l_custom_rec;
21746: l_custom_rec.attribute_name := ':l_admin_flag';
21747: l_custom_rec.attribute_value := get_admin_status;

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

21744: x_custom_output.EXTEND;
21745: x_custom_output (2) := l_custom_rec;
21746: l_custom_rec.attribute_name := ':l_admin_flag';
21747: l_custom_rec.attribute_value := get_admin_status;
21748: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
21749: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
21750: x_custom_output.EXTEND;
21751: x_custom_output (3) := l_custom_rec;
21752: l_custom_rec.attribute_name := ':l_country';

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

21745: x_custom_output (2) := l_custom_rec;
21746: l_custom_rec.attribute_name := ':l_admin_flag';
21747: l_custom_rec.attribute_value := get_admin_status;
21748: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
21749: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
21750: x_custom_output.EXTEND;
21751: x_custom_output (3) := l_custom_rec;
21752: l_custom_rec.attribute_name := ':l_country';
21753: l_custom_rec.attribute_value := l_country;

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

21750: x_custom_output.EXTEND;
21751: x_custom_output (3) := l_custom_rec;
21752: l_custom_rec.attribute_name := ':l_country';
21753: l_custom_rec.attribute_value := l_country;
21754: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
21755: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
21756: x_custom_output.EXTEND;
21757: x_custom_output (4) := l_custom_rec;
21758: l_custom_rec.attribute_name := ':l_cat_id';

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

21751: x_custom_output (3) := l_custom_rec;
21752: l_custom_rec.attribute_name := ':l_country';
21753: l_custom_rec.attribute_value := l_country;
21754: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
21755: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
21756: x_custom_output.EXTEND;
21757: x_custom_output (4) := l_custom_rec;
21758: l_custom_rec.attribute_name := ':l_cat_id';
21759: l_custom_rec.attribute_value := l_cat_id;

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

21756: x_custom_output.EXTEND;
21757: x_custom_output (4) := l_custom_rec;
21758: l_custom_rec.attribute_name := ':l_cat_id';
21759: l_custom_rec.attribute_value := l_cat_id;
21760: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
21761: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
21762: x_custom_output.EXTEND;
21763: x_custom_output (5) := l_custom_rec;
21764: l_custom_rec.attribute_name := ':l_campaign_id';

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

21757: x_custom_output (4) := l_custom_rec;
21758: l_custom_rec.attribute_name := ':l_cat_id';
21759: l_custom_rec.attribute_value := l_cat_id;
21760: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
21761: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
21762: x_custom_output.EXTEND;
21763: x_custom_output (5) := l_custom_rec;
21764: l_custom_rec.attribute_name := ':l_campaign_id';
21765: l_custom_rec.attribute_value := l_campaign_id;

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

21762: x_custom_output.EXTEND;
21763: x_custom_output (5) := l_custom_rec;
21764: l_custom_rec.attribute_name := ':l_campaign_id';
21765: l_custom_rec.attribute_value := l_campaign_id;
21766: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
21767: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
21768: x_custom_output.EXTEND;
21769: x_custom_output (6) := l_custom_rec;
21770: write_debug ('GET_RESP_RATE_SQL', 'QUERY', '_', l_sqltext);

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

21763: x_custom_output (5) := l_custom_rec;
21764: l_custom_rec.attribute_name := ':l_campaign_id';
21765: l_custom_rec.attribute_value := l_campaign_id;
21766: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
21767: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
21768: x_custom_output.EXTEND;
21769: x_custom_output (6) := l_custom_rec;
21770: write_debug ('GET_RESP_RATE_SQL', 'QUERY', '_', l_sqltext);
21771: EXCEPTION

Line 21860: l_custom_rec := bis_pmv_parameters_pub.initialize_query_type;

21856: l_report_name VARCHAR2(300);
21857: l_media VARCHAR2(300);
21858: BEGIN
21859: x_custom_output := bis_query_attributes_tbl ();
21860: l_custom_rec := bis_pmv_parameters_pub.initialize_query_type;
21861: bim_pmv_dbi_utl_pkg.get_bim_page_params(p_page_parameter_tbl,
21862: l_as_of_date,
21863: l_period_type,
21864: l_record_type_id,

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

22446: END IF;
22447: x_custom_sql := l_sqltext;
22448: l_custom_rec.attribute_name := ':l_record_type';
22449: l_custom_rec.attribute_value := l_record_type_id;
22450: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
22451: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
22452: x_custom_output.EXTEND;
22453: x_custom_output (1) := l_custom_rec;
22454: l_custom_rec.attribute_name := ':l_resource_id';

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

22447: x_custom_sql := l_sqltext;
22448: l_custom_rec.attribute_name := ':l_record_type';
22449: l_custom_rec.attribute_value := l_record_type_id;
22450: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
22451: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
22452: x_custom_output.EXTEND;
22453: x_custom_output (1) := l_custom_rec;
22454: l_custom_rec.attribute_name := ':l_resource_id';
22455: l_custom_rec.attribute_value := get_resource_id;

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

22452: x_custom_output.EXTEND;
22453: x_custom_output (1) := l_custom_rec;
22454: l_custom_rec.attribute_name := ':l_resource_id';
22455: l_custom_rec.attribute_value := get_resource_id;
22456: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
22457: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
22458: x_custom_output.EXTEND;
22459: x_custom_output (2) := l_custom_rec;
22460: l_custom_rec.attribute_name := ':l_admin_flag';

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

22453: x_custom_output (1) := l_custom_rec;
22454: l_custom_rec.attribute_name := ':l_resource_id';
22455: l_custom_rec.attribute_value := get_resource_id;
22456: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
22457: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
22458: x_custom_output.EXTEND;
22459: x_custom_output (2) := l_custom_rec;
22460: l_custom_rec.attribute_name := ':l_admin_flag';
22461: l_custom_rec.attribute_value := get_admin_status;

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

22458: x_custom_output.EXTEND;
22459: x_custom_output (2) := l_custom_rec;
22460: l_custom_rec.attribute_name := ':l_admin_flag';
22461: l_custom_rec.attribute_value := get_admin_status;
22462: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
22463: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
22464: x_custom_output.EXTEND;
22465: x_custom_output (3) := l_custom_rec;
22466: l_custom_rec.attribute_name := ':l_country';

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

22459: x_custom_output (2) := l_custom_rec;
22460: l_custom_rec.attribute_name := ':l_admin_flag';
22461: l_custom_rec.attribute_value := get_admin_status;
22462: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
22463: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
22464: x_custom_output.EXTEND;
22465: x_custom_output (3) := l_custom_rec;
22466: l_custom_rec.attribute_name := ':l_country';
22467: l_custom_rec.attribute_value := l_country;

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

22464: x_custom_output.EXTEND;
22465: x_custom_output (3) := l_custom_rec;
22466: l_custom_rec.attribute_name := ':l_country';
22467: l_custom_rec.attribute_value := l_country;
22468: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
22469: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
22470: x_custom_output.EXTEND;
22471: x_custom_output (4) := l_custom_rec;
22472: l_custom_rec.attribute_name := ':l_cat_id';

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

22465: x_custom_output (3) := l_custom_rec;
22466: l_custom_rec.attribute_name := ':l_country';
22467: l_custom_rec.attribute_value := l_country;
22468: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
22469: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
22470: x_custom_output.EXTEND;
22471: x_custom_output (4) := l_custom_rec;
22472: l_custom_rec.attribute_name := ':l_cat_id';
22473: l_custom_rec.attribute_value := l_cat_id;

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

22470: x_custom_output.EXTEND;
22471: x_custom_output (4) := l_custom_rec;
22472: l_custom_rec.attribute_name := ':l_cat_id';
22473: l_custom_rec.attribute_value := l_cat_id;
22474: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
22475: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
22476: x_custom_output.EXTEND;
22477: x_custom_output (5) := l_custom_rec;
22478: l_custom_rec.attribute_name := ':l_campaign_id';

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

22471: x_custom_output (4) := l_custom_rec;
22472: l_custom_rec.attribute_name := ':l_cat_id';
22473: l_custom_rec.attribute_value := l_cat_id;
22474: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
22475: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
22476: x_custom_output.EXTEND;
22477: x_custom_output (5) := l_custom_rec;
22478: l_custom_rec.attribute_name := ':l_campaign_id';
22479: l_custom_rec.attribute_value := l_campaign_id;

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

22476: x_custom_output.EXTEND;
22477: x_custom_output (5) := l_custom_rec;
22478: l_custom_rec.attribute_name := ':l_campaign_id';
22479: l_custom_rec.attribute_value := l_campaign_id;
22480: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
22481: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
22482: x_custom_output.EXTEND;
22483: x_custom_output (6) := l_custom_rec;
22484: write_debug ('GET_WON_OPTY_SQL', 'QUERY', '_', l_sqltext);

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

22477: x_custom_output (5) := l_custom_rec;
22478: l_custom_rec.attribute_name := ':l_campaign_id';
22479: l_custom_rec.attribute_value := l_campaign_id;
22480: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
22481: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
22482: x_custom_output.EXTEND;
22483: x_custom_output (6) := l_custom_rec;
22484: write_debug ('GET_WON_OPTY_SQL', 'QUERY', '_', l_sqltext);
22485: EXCEPTION