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

Line 225: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

221: l_curr_suffix VARCHAR2(50);
222: l_url_str VARCHAR2(1000);
223: BEGIN
224: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
225: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
226: get_bim_page_params(p_page_parameter_tbl,
227: l_as_of_date,
228: l_period_type,
229: l_record_type_id,

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

556: */
557: x_custom_sql := l_sqltext;
558: l_custom_rec.attribute_name := ':l_record_type';
559: l_custom_rec.attribute_value := l_record_type_id;
560: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
561: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
562: x_custom_output.EXTEND;
563: x_custom_output(1) := l_custom_rec;
564:

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

557: x_custom_sql := l_sqltext;
558: l_custom_rec.attribute_name := ':l_record_type';
559: l_custom_rec.attribute_value := l_record_type_id;
560: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
561: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
562: x_custom_output.EXTEND;
563: x_custom_output(1) := l_custom_rec;
564:
565: l_custom_rec.attribute_name := ':l_resource_id';

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

563: x_custom_output(1) := l_custom_rec;
564:
565: l_custom_rec.attribute_name := ':l_resource_id';
566: l_custom_rec.attribute_value := GET_RESOURCE_ID;
567: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
568: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
569: x_custom_output.EXTEND;
570: x_custom_output(2) := l_custom_rec;
571:

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

564:
565: l_custom_rec.attribute_name := ':l_resource_id';
566: l_custom_rec.attribute_value := GET_RESOURCE_ID;
567: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
568: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
569: x_custom_output.EXTEND;
570: x_custom_output(2) := l_custom_rec;
571:
572: l_custom_rec.attribute_name := ':l_admin_flag';

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

570: x_custom_output(2) := l_custom_rec;
571:
572: l_custom_rec.attribute_name := ':l_admin_flag';
573: l_custom_rec.attribute_value := GET_ADMIN_STATUS;
574: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
575: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
576: x_custom_output.EXTEND;
577: x_custom_output(3) := l_custom_rec;
578:

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

571:
572: l_custom_rec.attribute_name := ':l_admin_flag';
573: l_custom_rec.attribute_value := GET_ADMIN_STATUS;
574: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
575: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
576: x_custom_output.EXTEND;
577: x_custom_output(3) := l_custom_rec;
578:
579: l_custom_rec.attribute_name := ':l_country';

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

577: x_custom_output(3) := l_custom_rec;
578:
579: l_custom_rec.attribute_name := ':l_country';
580: l_custom_rec.attribute_value := l_country;
581: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
582: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
583: x_custom_output.EXTEND;
584: x_custom_output(4) := l_custom_rec;
585:

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

578:
579: l_custom_rec.attribute_name := ':l_country';
580: l_custom_rec.attribute_value := l_country;
581: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
582: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
583: x_custom_output.EXTEND;
584: x_custom_output(4) := l_custom_rec;
585:
586: l_custom_rec.attribute_name := ':l_fund_id';

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

584: x_custom_output(4) := l_custom_rec;
585:
586: l_custom_rec.attribute_name := ':l_fund_id';
587: l_custom_rec.attribute_value := l_fund_id;
588: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
589: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
590: x_custom_output.EXTEND;
591: x_custom_output(5) := l_custom_rec;
592:

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

585:
586: l_custom_rec.attribute_name := ':l_fund_id';
587: l_custom_rec.attribute_value := l_fund_id;
588: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
589: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
590: x_custom_output.EXTEND;
591: x_custom_output(5) := l_custom_rec;
592:
593: /* l_custom_rec.attribute_name := ':l_campaign_id';

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

591: x_custom_output(5) := l_custom_rec;
592:
593: /* l_custom_rec.attribute_name := ':l_campaign_id';
594: l_custom_rec.attribute_value := l_campaign_id;
595: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
596: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
597: x_custom_output.EXTEND;
598: x_custom_output(6) := l_custom_rec;*/
599:

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

592:
593: /* l_custom_rec.attribute_name := ':l_campaign_id';
594: l_custom_rec.attribute_value := l_campaign_id;
595: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
596: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
597: x_custom_output.EXTEND;
598: x_custom_output(6) := l_custom_rec;*/
599:
600: write_debug('GET_BGT_SUM_SQL','QUERY','_',l_sqltext);

Line 649: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

645: l_curr_suffix VARCHAR2(50);
646: l_url_str VARCHAR2(1000);
647: BEGIN
648: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
649: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
650: get_bim_page_params(p_page_parameter_tbl,
651: l_as_of_date,
652: l_period_type,
653: l_record_type_id,

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

942: END IF;
943: x_custom_sql := l_sqltext;
944: l_custom_rec.attribute_name := ':l_record_type';
945: l_custom_rec.attribute_value := l_record_type_id;
946: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
947: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
948: x_custom_output.EXTEND;
949: x_custom_output(1) := l_custom_rec;
950:

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

943: x_custom_sql := l_sqltext;
944: l_custom_rec.attribute_name := ':l_record_type';
945: l_custom_rec.attribute_value := l_record_type_id;
946: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
947: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
948: x_custom_output.EXTEND;
949: x_custom_output(1) := l_custom_rec;
950:
951: l_custom_rec.attribute_name := ':l_resource_id';

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

949: x_custom_output(1) := l_custom_rec;
950:
951: l_custom_rec.attribute_name := ':l_resource_id';
952: l_custom_rec.attribute_value := GET_RESOURCE_ID;
953: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
954: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
955: x_custom_output.EXTEND;
956: x_custom_output(2) := l_custom_rec;
957:

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

950:
951: l_custom_rec.attribute_name := ':l_resource_id';
952: l_custom_rec.attribute_value := GET_RESOURCE_ID;
953: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
954: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
955: x_custom_output.EXTEND;
956: x_custom_output(2) := l_custom_rec;
957:
958: l_custom_rec.attribute_name := ':l_admin_flag';

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

956: x_custom_output(2) := l_custom_rec;
957:
958: l_custom_rec.attribute_name := ':l_admin_flag';
959: l_custom_rec.attribute_value := GET_ADMIN_STATUS;
960: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
961: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
962: x_custom_output.EXTEND;
963: x_custom_output(3) := l_custom_rec;
964:

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

957:
958: l_custom_rec.attribute_name := ':l_admin_flag';
959: l_custom_rec.attribute_value := GET_ADMIN_STATUS;
960: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
961: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
962: x_custom_output.EXTEND;
963: x_custom_output(3) := l_custom_rec;
964:
965: l_custom_rec.attribute_name := ':l_country';

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

963: x_custom_output(3) := l_custom_rec;
964:
965: l_custom_rec.attribute_name := ':l_country';
966: l_custom_rec.attribute_value := l_country;
967: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
968: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
969: x_custom_output.EXTEND;
970: x_custom_output(4) := l_custom_rec;
971:

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

964:
965: l_custom_rec.attribute_name := ':l_country';
966: l_custom_rec.attribute_value := l_country;
967: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
968: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
969: x_custom_output.EXTEND;
970: x_custom_output(4) := l_custom_rec;
971:
972: l_custom_rec.attribute_name := ':l_fund_id';

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

970: x_custom_output(4) := l_custom_rec;
971:
972: l_custom_rec.attribute_name := ':l_fund_id';
973: l_custom_rec.attribute_value := l_fund_id;
974: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
975: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
976: x_custom_output.EXTEND;
977: x_custom_output(5) := l_custom_rec;
978:

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

971:
972: l_custom_rec.attribute_name := ':l_fund_id';
973: l_custom_rec.attribute_value := l_fund_id;
974: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
975: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
976: x_custom_output.EXTEND;
977: x_custom_output(5) := l_custom_rec;
978:
979: l_custom_rec.attribute_name := ':l_bcat_id';

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

977: x_custom_output(5) := l_custom_rec;
978:
979: l_custom_rec.attribute_name := ':l_bcat_id';
980: l_custom_rec.attribute_value := l_bcat_id;
981: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
982: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
983: x_custom_output.EXTEND;
984: x_custom_output(5) := l_custom_rec;
985:

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

978:
979: l_custom_rec.attribute_name := ':l_bcat_id';
980: l_custom_rec.attribute_value := l_bcat_id;
981: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
982: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
983: x_custom_output.EXTEND;
984: x_custom_output(5) := l_custom_rec;
985:
986: /* l_custom_rec.attribute_name := ':l_campaign_id';

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

984: x_custom_output(5) := l_custom_rec;
985:
986: /* l_custom_rec.attribute_name := ':l_campaign_id';
987: l_custom_rec.attribute_value := l_campaign_id;
988: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
989: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
990: x_custom_output.EXTEND;
991: x_custom_output(6) := l_custom_rec;*/
992:

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

985:
986: /* l_custom_rec.attribute_name := ':l_campaign_id';
987: l_custom_rec.attribute_value := l_campaign_id;
988: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
989: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
990: x_custom_output.EXTEND;
991: x_custom_output(6) := l_custom_rec;*/
992:
993: write_debug('GET_BGT_CAT_SQL','QUERY','_',l_sqltext);

Line 1090: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

1086: l_prog_cost1 VARCHAR2(20);
1087:
1088: BEGIN
1089: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
1090: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
1091: bim_pmv_dbi_utl_pkg.get_bim_page_params(p_page_parameter_tbl,
1092: l_as_of_date,
1093: l_period_type,
1094: l_record_type_id,

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

1689:
1690: x_custom_sql := l_sqltext;
1691: l_custom_rec.attribute_name := ':l_record_type';
1692: l_custom_rec.attribute_value := l_record_type_id;
1693: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
1694: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
1695: x_custom_output.EXTEND;
1696: x_custom_output (1) := l_custom_rec;
1697: l_custom_rec.attribute_name := ':l_resource_id';

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

1690: x_custom_sql := l_sqltext;
1691: l_custom_rec.attribute_name := ':l_record_type';
1692: l_custom_rec.attribute_value := l_record_type_id;
1693: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
1694: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
1695: x_custom_output.EXTEND;
1696: x_custom_output (1) := l_custom_rec;
1697: l_custom_rec.attribute_name := ':l_resource_id';
1698: l_custom_rec.attribute_value := get_resource_id;

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

1695: x_custom_output.EXTEND;
1696: x_custom_output (1) := l_custom_rec;
1697: l_custom_rec.attribute_name := ':l_resource_id';
1698: l_custom_rec.attribute_value := get_resource_id;
1699: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
1700: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
1701: x_custom_output.EXTEND;
1702: x_custom_output (2) := l_custom_rec;
1703: l_custom_rec.attribute_name := ':l_admin_flag';

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

1696: x_custom_output (1) := l_custom_rec;
1697: l_custom_rec.attribute_name := ':l_resource_id';
1698: l_custom_rec.attribute_value := get_resource_id;
1699: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
1700: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
1701: x_custom_output.EXTEND;
1702: x_custom_output (2) := l_custom_rec;
1703: l_custom_rec.attribute_name := ':l_admin_flag';
1704: l_custom_rec.attribute_value := get_admin_status;

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

1701: x_custom_output.EXTEND;
1702: x_custom_output (2) := l_custom_rec;
1703: l_custom_rec.attribute_name := ':l_admin_flag';
1704: l_custom_rec.attribute_value := get_admin_status;
1705: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
1706: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
1707: x_custom_output.EXTEND;
1708: x_custom_output (3) := l_custom_rec;
1709: l_custom_rec.attribute_name := ':l_country';

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

1702: x_custom_output (2) := l_custom_rec;
1703: l_custom_rec.attribute_name := ':l_admin_flag';
1704: l_custom_rec.attribute_value := get_admin_status;
1705: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
1706: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
1707: x_custom_output.EXTEND;
1708: x_custom_output (3) := l_custom_rec;
1709: l_custom_rec.attribute_name := ':l_country';
1710: l_custom_rec.attribute_value := l_country;

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

1707: x_custom_output.EXTEND;
1708: x_custom_output (3) := l_custom_rec;
1709: l_custom_rec.attribute_name := ':l_country';
1710: l_custom_rec.attribute_value := l_country;
1711: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
1712: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
1713: x_custom_output.EXTEND;
1714: x_custom_output (4) := l_custom_rec;
1715: l_custom_rec.attribute_name := ':l_cat_id';

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

1708: x_custom_output (3) := l_custom_rec;
1709: l_custom_rec.attribute_name := ':l_country';
1710: l_custom_rec.attribute_value := l_country;
1711: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
1712: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
1713: x_custom_output.EXTEND;
1714: x_custom_output (4) := l_custom_rec;
1715: l_custom_rec.attribute_name := ':l_cat_id';
1716: l_custom_rec.attribute_value := l_cat_id;

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

1713: x_custom_output.EXTEND;
1714: x_custom_output (4) := l_custom_rec;
1715: l_custom_rec.attribute_name := ':l_cat_id';
1716: l_custom_rec.attribute_value := l_cat_id;
1717: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
1718: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
1719: x_custom_output.EXTEND;
1720: x_custom_output (5) := l_custom_rec;
1721: l_custom_rec.attribute_name := ':l_campaign_id';

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

1714: x_custom_output (4) := l_custom_rec;
1715: l_custom_rec.attribute_name := ':l_cat_id';
1716: l_custom_rec.attribute_value := l_cat_id;
1717: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
1718: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
1719: x_custom_output.EXTEND;
1720: x_custom_output (5) := l_custom_rec;
1721: l_custom_rec.attribute_name := ':l_campaign_id';
1722: l_custom_rec.attribute_value := l_campaign_id;

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

1719: x_custom_output.EXTEND;
1720: x_custom_output (5) := l_custom_rec;
1721: l_custom_rec.attribute_name := ':l_campaign_id';
1722: l_custom_rec.attribute_value := l_campaign_id;
1723: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
1724: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
1725: x_custom_output.EXTEND;
1726: x_custom_output (6) := l_custom_rec;
1727:

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

1720: x_custom_output (5) := l_custom_rec;
1721: l_custom_rec.attribute_name := ':l_campaign_id';
1722: l_custom_rec.attribute_value := l_campaign_id;
1723: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
1724: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
1725: x_custom_output.EXTEND;
1726: x_custom_output (6) := l_custom_rec;
1727:
1728: write_debug('GET_BGT_UTL_SQL','QUERY','_',l_sqltext);