[Home] [Help]
183: END GET_ADMIN_STATUS;
184:
185: PROCEDURE GET_BGT_SUM_SQL(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
186: x_custom_sql OUT NOCOPY VARCHAR2,
187: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
188: IS
189: l_sqltext varchar2(12000);
190: iFlag number;
191: l_period_type_hc number;
220: l_curr VARCHAR2(50);
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,
607: END GET_BGT_SUM_SQL;
608:
609: PROCEDURE GET_BGT_CAT_SQL(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
610: x_custom_sql OUT NOCOPY VARCHAR2,
611: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
612: IS
613: l_sqltext varchar2(12000);
614: iFlag number;
615: l_period_type_hc number;
644: l_curr VARCHAR2(50);
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,
1000: END GET_BGT_CAT_SQL;
1001:
1002: PROCEDURE GET_BGT_UTL_SQL(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
1003: x_custom_sql OUT NOCOPY VARCHAR2,
1004: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
1005: IS
1006: --l_sqltext varchar2(12000);
1007: l_sqltext varchar2(30000);
1008: iFlag number;
1085: l_where_bud VARCHAR2(300);
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,