DBA Data[Home] [Help]

APPS.BIM_SGMT_INTL_UI_PVT dependencies on BIS_PMV_PARAMETERS_PUB

Line 158: l_custom_rec := bis_pmv_parameters_pub.initialize_query_type;

154: l_col VARCHAR2(200);
155:
156: BEGIN
157: x_custom_output := bis_query_attributes_tbl ();
158: l_custom_rec := bis_pmv_parameters_pub.initialize_query_type;
159: bim_pmv_dbi_utl_pkg.get_bim_page_sgmt_params(p_page_parameter_tbl,
160: l_as_of_date ,
161: l_period_type,
162: l_record_type_id,

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

390: x_custom_sql := l_sqltext;
391:
392: l_custom_rec.attribute_name := ':l_record_type';
393: l_custom_rec.attribute_value := l_record_type_id;
394: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
395: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
396: x_custom_output.EXTEND;
397: x_custom_output (1) := l_custom_rec;
398: l_custom_rec.attribute_name := ':l_sgmt_id';

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

391:
392: l_custom_rec.attribute_name := ':l_record_type';
393: l_custom_rec.attribute_value := l_record_type_id;
394: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
395: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
396: x_custom_output.EXTEND;
397: x_custom_output (1) := l_custom_rec;
398: l_custom_rec.attribute_name := ':l_sgmt_id';
399: l_custom_rec.attribute_value := l_sgmt_id;

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

396: x_custom_output.EXTEND;
397: x_custom_output (1) := l_custom_rec;
398: l_custom_rec.attribute_name := ':l_sgmt_id';
399: l_custom_rec.attribute_value := l_sgmt_id;
400: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
401: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
402: x_custom_output.EXTEND;
403: x_custom_output (2) := l_custom_rec;
404: END;

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

397: x_custom_output (1) := l_custom_rec;
398: l_custom_rec.attribute_name := ':l_sgmt_id';
399: l_custom_rec.attribute_value := l_sgmt_id;
400: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
401: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
402: x_custom_output.EXTEND;
403: x_custom_output (2) := l_custom_rec;
404: END;
405:

Line 440: l_custom_rec := bis_pmv_parameters_pub.initialize_query_type;

436: l_from VARCHAR2(100);
437:
438: BEGIN
439: x_custom_output := bis_query_attributes_tbl ();
440: l_custom_rec := bis_pmv_parameters_pub.initialize_query_type;
441: bim_pmv_dbi_utl_pkg.get_bim_page_sgmt_params(p_page_parameter_tbl,
442: l_as_of_date ,
443: l_period_type,
444: l_record_type_id,

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

524:
525: x_custom_sql := l_sqltext;
526: l_custom_rec.attribute_name := ':l_record_type';
527: l_custom_rec.attribute_value := l_record_type_id;
528: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
529: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
530: x_custom_output.EXTEND;
531: x_custom_output (1) := l_custom_rec;
532: l_custom_rec.attribute_name := ':l_sgmt_id';

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

525: x_custom_sql := l_sqltext;
526: l_custom_rec.attribute_name := ':l_record_type';
527: l_custom_rec.attribute_value := l_record_type_id;
528: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
529: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
530: x_custom_output.EXTEND;
531: x_custom_output (1) := l_custom_rec;
532: l_custom_rec.attribute_name := ':l_sgmt_id';
533: l_custom_rec.attribute_value := l_sgmt_id;

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

530: x_custom_output.EXTEND;
531: x_custom_output (1) := l_custom_rec;
532: l_custom_rec.attribute_name := ':l_sgmt_id';
533: l_custom_rec.attribute_value := l_sgmt_id;
534: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
535: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
536: x_custom_output.EXTEND;
537: x_custom_output (2) := l_custom_rec;
538: END GET_SGMT_REVENUE_SQL;

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

531: x_custom_output (1) := l_custom_rec;
532: l_custom_rec.attribute_name := ':l_sgmt_id';
533: l_custom_rec.attribute_value := l_sgmt_id;
534: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
535: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
536: x_custom_output.EXTEND;
537: x_custom_output (2) := l_custom_rec;
538: END GET_SGMT_REVENUE_SQL;
539:

Line 574: l_custom_rec := bis_pmv_parameters_pub.initialize_query_type;

570: l_from VARCHAR2(100);
571:
572: BEGIN
573: x_custom_output := bis_query_attributes_tbl ();
574: l_custom_rec := bis_pmv_parameters_pub.initialize_query_type;
575: bim_pmv_dbi_utl_pkg.get_bim_page_sgmt_params(p_page_parameter_tbl,
576: l_as_of_date ,
577: l_period_type,
578: l_record_type_id,

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

667: order by fii.start_date ';
668: x_custom_sql := l_sqltext;
669: l_custom_rec.attribute_name := ':l_record_type';
670: l_custom_rec.attribute_value := l_record_type_id;
671: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
672: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
673: x_custom_output.EXTEND;
674: x_custom_output (1) := l_custom_rec;
675: l_custom_rec.attribute_name := ':l_sgmt_id';

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

668: x_custom_sql := l_sqltext;
669: l_custom_rec.attribute_name := ':l_record_type';
670: l_custom_rec.attribute_value := l_record_type_id;
671: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
672: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
673: x_custom_output.EXTEND;
674: x_custom_output (1) := l_custom_rec;
675: l_custom_rec.attribute_name := ':l_sgmt_id';
676: l_custom_rec.attribute_value := l_sgmt_id;

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

673: x_custom_output.EXTEND;
674: x_custom_output (1) := l_custom_rec;
675: l_custom_rec.attribute_name := ':l_sgmt_id';
676: l_custom_rec.attribute_value := l_sgmt_id;
677: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
678: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
679: x_custom_output.EXTEND;
680: x_custom_output (2) := l_custom_rec;
681: END GET_ACTIVE_CUST_SQL;

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

674: x_custom_output (1) := l_custom_rec;
675: l_custom_rec.attribute_name := ':l_sgmt_id';
676: l_custom_rec.attribute_value := l_sgmt_id;
677: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
678: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
679: x_custom_output.EXTEND;
680: x_custom_output (2) := l_custom_rec;
681: END GET_ACTIVE_CUST_SQL;
682:

Line 718: l_custom_rec := bis_pmv_parameters_pub.initialize_query_type;

714: l_from VARCHAR2(100);
715:
716: BEGIN
717: x_custom_output := bis_query_attributes_tbl ();
718: l_custom_rec := bis_pmv_parameters_pub.initialize_query_type;
719: bim_pmv_dbi_utl_pkg.get_bim_page_sgmt_params(p_page_parameter_tbl,
720: l_as_of_date ,
721: l_period_type,
722: l_record_type_id,

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

792: order by fii.start_date ';
793: x_custom_sql := l_sqltext;
794: l_custom_rec.attribute_name := ':l_record_type';
795: l_custom_rec.attribute_value := l_record_type_id;
796: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
797: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
798: x_custom_output.EXTEND;
799: x_custom_output (1) := l_custom_rec;
800: l_custom_rec.attribute_name := ':l_sgmt_id';

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

793: x_custom_sql := l_sqltext;
794: l_custom_rec.attribute_name := ':l_record_type';
795: l_custom_rec.attribute_value := l_record_type_id;
796: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
797: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
798: x_custom_output.EXTEND;
799: x_custom_output (1) := l_custom_rec;
800: l_custom_rec.attribute_name := ':l_sgmt_id';
801: l_custom_rec.attribute_value := l_sgmt_id;

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

798: x_custom_output.EXTEND;
799: x_custom_output (1) := l_custom_rec;
800: l_custom_rec.attribute_name := ':l_sgmt_id';
801: l_custom_rec.attribute_value := l_sgmt_id;
802: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
803: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
804: x_custom_output.EXTEND;
805: x_custom_output (2) := l_custom_rec;
806: END GET_SGMT_SIZE_SQL;

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

799: x_custom_output (1) := l_custom_rec;
800: l_custom_rec.attribute_name := ':l_sgmt_id';
801: l_custom_rec.attribute_value := l_sgmt_id;
802: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
803: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
804: x_custom_output.EXTEND;
805: x_custom_output (2) := l_custom_rec;
806: END GET_SGMT_SIZE_SQL;
807:

Line 841: l_custom_rec := bis_pmv_parameters_pub.initialize_query_type;

837: l_from VARCHAR2(100);
838:
839: BEGIN
840: x_custom_output := bis_query_attributes_tbl ();
841: l_custom_rec := bis_pmv_parameters_pub.initialize_query_type;
842: bim_pmv_dbi_utl_pkg.get_bim_page_sgmt_params(p_page_parameter_tbl,
843: l_as_of_date ,
844: l_period_type,
845: l_record_type_id,

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

929:
930: x_custom_sql := l_sqltext;
931: l_custom_rec.attribute_name := ':l_record_type';
932: l_custom_rec.attribute_value := l_record_type_id;
933: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
934: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
935: x_custom_output.EXTEND;
936: x_custom_output (1) := l_custom_rec;
937: l_custom_rec.attribute_name := ':l_sgmt_id';

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

930: x_custom_sql := l_sqltext;
931: l_custom_rec.attribute_name := ':l_record_type';
932: l_custom_rec.attribute_value := l_record_type_id;
933: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
934: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
935: x_custom_output.EXTEND;
936: x_custom_output (1) := l_custom_rec;
937: l_custom_rec.attribute_name := ':l_sgmt_id';
938: l_custom_rec.attribute_value := l_sgmt_id;

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

935: x_custom_output.EXTEND;
936: x_custom_output (1) := l_custom_rec;
937: l_custom_rec.attribute_name := ':l_sgmt_id';
938: l_custom_rec.attribute_value := l_sgmt_id;
939: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
940: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
941: x_custom_output.EXTEND;
942: x_custom_output (2) := l_custom_rec;
943: END GET_SGMT_AVG_TXN_SQL;

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

936: x_custom_output (1) := l_custom_rec;
937: l_custom_rec.attribute_name := ':l_sgmt_id';
938: l_custom_rec.attribute_value := l_sgmt_id;
939: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
940: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
941: x_custom_output.EXTEND;
942: x_custom_output (2) := l_custom_rec;
943: END GET_SGMT_AVG_TXN_SQL;
944:

Line 989: l_custom_rec := bis_pmv_parameters_pub.initialize_query_type;

985:
986:
987: BEGIN
988: x_custom_output := bis_query_attributes_tbl ();
989: l_custom_rec := bis_pmv_parameters_pub.initialize_query_type;
990: bim_pmv_dbi_utl_pkg.get_bim_page_sgmt_params(p_page_parameter_tbl,
991: l_as_of_date ,
992: l_period_type,
993: l_record_type_id,

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

1604:
1605: x_custom_sql := l_sqltext;
1606: l_custom_rec.attribute_name := ':l_record_type';
1607: l_custom_rec.attribute_value := l_record_type_id;
1608: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
1609: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
1610: x_custom_output.EXTEND;
1611: x_custom_output (1) := l_custom_rec;
1612: l_custom_rec.attribute_name := ':l_sgmt_id';

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

1605: x_custom_sql := l_sqltext;
1606: l_custom_rec.attribute_name := ':l_record_type';
1607: l_custom_rec.attribute_value := l_record_type_id;
1608: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
1609: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
1610: x_custom_output.EXTEND;
1611: x_custom_output (1) := l_custom_rec;
1612: l_custom_rec.attribute_name := ':l_sgmt_id';
1613: l_custom_rec.attribute_value := l_sgmt_id;

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

1610: x_custom_output.EXTEND;
1611: x_custom_output (1) := l_custom_rec;
1612: l_custom_rec.attribute_name := ':l_sgmt_id';
1613: l_custom_rec.attribute_value := l_sgmt_id;
1614: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
1615: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
1616: x_custom_output.EXTEND;
1617: x_custom_output (2) := l_custom_rec;
1618: l_custom_rec.attribute_name := ':l_cat_id';

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

1611: x_custom_output (1) := l_custom_rec;
1612: l_custom_rec.attribute_name := ':l_sgmt_id';
1613: l_custom_rec.attribute_value := l_sgmt_id;
1614: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
1615: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
1616: x_custom_output.EXTEND;
1617: x_custom_output (2) := l_custom_rec;
1618: l_custom_rec.attribute_name := ':l_cat_id';
1619: l_custom_rec.attribute_value := l_cat_id;

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

1616: x_custom_output.EXTEND;
1617: x_custom_output (2) := l_custom_rec;
1618: l_custom_rec.attribute_name := ':l_cat_id';
1619: l_custom_rec.attribute_value := l_cat_id;
1620: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
1621: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
1622: x_custom_output.EXTEND;
1623: x_custom_output (3) := l_custom_rec;
1624:

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

1617: x_custom_output (2) := l_custom_rec;
1618: l_custom_rec.attribute_name := ':l_cat_id';
1619: l_custom_rec.attribute_value := l_cat_id;
1620: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
1621: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
1622: x_custom_output.EXTEND;
1623: x_custom_output (3) := l_custom_rec;
1624:
1625:

Line 1674: l_custom_rec := bis_pmv_parameters_pub.initialize_query_type;

1670:
1671:
1672: BEGIN
1673: x_custom_output := bis_query_attributes_tbl ();
1674: l_custom_rec := bis_pmv_parameters_pub.initialize_query_type;
1675: bim_pmv_dbi_utl_pkg.get_bim_page_sgmt_params(p_page_parameter_tbl,
1676: l_as_of_date ,
1677: l_period_type,
1678: l_record_type_id,

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

1808:
1809: x_custom_sql := l_sqltext;
1810: l_custom_rec.attribute_name := ':l_record_type';
1811: l_custom_rec.attribute_value := l_record_type_id;
1812: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
1813: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
1814: x_custom_output.EXTEND;
1815: x_custom_output (1) := l_custom_rec;
1816: l_custom_rec.attribute_name := ':l_sgmt_id';

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

1809: x_custom_sql := l_sqltext;
1810: l_custom_rec.attribute_name := ':l_record_type';
1811: l_custom_rec.attribute_value := l_record_type_id;
1812: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
1813: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
1814: x_custom_output.EXTEND;
1815: x_custom_output (1) := l_custom_rec;
1816: l_custom_rec.attribute_name := ':l_sgmt_id';
1817: l_custom_rec.attribute_value := l_sgmt_id;

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

1814: x_custom_output.EXTEND;
1815: x_custom_output (1) := l_custom_rec;
1816: l_custom_rec.attribute_name := ':l_sgmt_id';
1817: l_custom_rec.attribute_value := l_sgmt_id;
1818: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
1819: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
1820: x_custom_output.EXTEND;
1821: x_custom_output (2) := l_custom_rec;
1822: l_custom_rec.attribute_name := ':l_cat_id';

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

1815: x_custom_output (1) := l_custom_rec;
1816: l_custom_rec.attribute_name := ':l_sgmt_id';
1817: l_custom_rec.attribute_value := l_sgmt_id;
1818: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
1819: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
1820: x_custom_output.EXTEND;
1821: x_custom_output (2) := l_custom_rec;
1822: l_custom_rec.attribute_name := ':l_cat_id';
1823: l_custom_rec.attribute_value := l_cat_id;

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

1820: x_custom_output.EXTEND;
1821: x_custom_output (2) := l_custom_rec;
1822: l_custom_rec.attribute_name := ':l_cat_id';
1823: l_custom_rec.attribute_value := l_cat_id;
1824: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
1825: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
1826: x_custom_output.EXTEND;
1827: x_custom_output (3) := l_custom_rec;
1828: l_custom_rec.attribute_name := ':l_resource_id';

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

1821: x_custom_output (2) := l_custom_rec;
1822: l_custom_rec.attribute_name := ':l_cat_id';
1823: l_custom_rec.attribute_value := l_cat_id;
1824: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
1825: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
1826: x_custom_output.EXTEND;
1827: x_custom_output (3) := l_custom_rec;
1828: l_custom_rec.attribute_name := ':l_resource_id';
1829: l_custom_rec.attribute_value := l_resource_id;

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

1826: x_custom_output.EXTEND;
1827: x_custom_output (3) := l_custom_rec;
1828: l_custom_rec.attribute_name := ':l_resource_id';
1829: l_custom_rec.attribute_value := l_resource_id;
1830: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
1831: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
1832: x_custom_output.EXTEND;
1833: x_custom_output (4) := l_custom_rec;
1834:

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

1827: x_custom_output (3) := l_custom_rec;
1828: l_custom_rec.attribute_name := ':l_resource_id';
1829: l_custom_rec.attribute_value := l_resource_id;
1830: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
1831: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
1832: x_custom_output.EXTEND;
1833: x_custom_output (4) := l_custom_rec;
1834:
1835:

Line 1870: l_custom_rec := bis_pmv_parameters_pub.initialize_query_type;

1866:
1867:
1868: BEGIN
1869: x_custom_output := bis_query_attributes_tbl ();
1870: l_custom_rec := bis_pmv_parameters_pub.initialize_query_type;
1871: bim_pmv_dbi_utl_pkg.get_bim_page_sgmt_params(p_page_parameter_tbl,
1872: l_as_of_date ,
1873: l_period_type,
1874: l_record_type_id,

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

2017:
2018: x_custom_sql := l_sqltext;
2019: l_custom_rec.attribute_name := ':l_record_type';
2020: l_custom_rec.attribute_value := l_record_type_id;
2021: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
2022: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
2023: x_custom_output.EXTEND;
2024: x_custom_output (1) := l_custom_rec;
2025: l_custom_rec.attribute_name := ':l_sgmt_id';

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

2018: x_custom_sql := l_sqltext;
2019: l_custom_rec.attribute_name := ':l_record_type';
2020: l_custom_rec.attribute_value := l_record_type_id;
2021: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
2022: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
2023: x_custom_output.EXTEND;
2024: x_custom_output (1) := l_custom_rec;
2025: l_custom_rec.attribute_name := ':l_sgmt_id';
2026: l_custom_rec.attribute_value := l_sgmt_id;

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

2023: x_custom_output.EXTEND;
2024: x_custom_output (1) := l_custom_rec;
2025: l_custom_rec.attribute_name := ':l_sgmt_id';
2026: l_custom_rec.attribute_value := l_sgmt_id;
2027: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
2028: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
2029: x_custom_output.EXTEND;
2030: x_custom_output (2) := l_custom_rec;
2031: l_custom_rec.attribute_name := ':l_cat_id';

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

2024: x_custom_output (1) := l_custom_rec;
2025: l_custom_rec.attribute_name := ':l_sgmt_id';
2026: l_custom_rec.attribute_value := l_sgmt_id;
2027: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
2028: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
2029: x_custom_output.EXTEND;
2030: x_custom_output (2) := l_custom_rec;
2031: l_custom_rec.attribute_name := ':l_cat_id';
2032: l_custom_rec.attribute_value := l_cat_id;

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

2029: x_custom_output.EXTEND;
2030: x_custom_output (2) := l_custom_rec;
2031: l_custom_rec.attribute_name := ':l_cat_id';
2032: l_custom_rec.attribute_value := l_cat_id;
2033: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
2034: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
2035: x_custom_output.EXTEND;
2036: x_custom_output (3) := l_custom_rec;
2037:

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

2030: x_custom_output (2) := l_custom_rec;
2031: l_custom_rec.attribute_name := ':l_cat_id';
2032: l_custom_rec.attribute_value := l_cat_id;
2033: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
2034: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
2035: x_custom_output.EXTEND;
2036: x_custom_output (3) := l_custom_rec;
2037:
2038: