APPS.BIM_DBI_BGT_MGMT_PVT dependencies on BIS_QUERY_ATTRIBUTES

Line 187: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

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;

Line 217: l_custom_rec BIS_QUERY_ATTRIBUTES;

213: l_access_table varchar2(4000);
214: --l_cat_id NUMBER;
215: l_campaign_id VARCHAR2(50);
216: l_cat_id VARCHAR2(50):=NULL;
217: l_custom_rec BIS_QUERY_ATTRIBUTES;
218: l_fund_id VARCHAR2(50);
219: l_bcat_id VARCHAR2(50);
220: l_curr VARCHAR2(50);
221: l_curr_suffix VARCHAR2(50);

Line 224: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

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,

Line 611: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

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;

Line 641: l_custom_rec BIS_QUERY_ATTRIBUTES;

637: l_access_table varchar2(4000);
638: --l_cat_id NUMBER;
639: l_campaign_id VARCHAR2(50);
640: l_cat_id VARCHAR2(50):=NULL;
641: l_custom_rec BIS_QUERY_ATTRIBUTES;
642: l_fund_id VARCHAR2(50);
643: l_bcat_id VARCHAR2(50);
644: l_curr VARCHAR2(50);
645: l_curr_suffix VARCHAR2(50);

Line 648: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

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,

Line 1004: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

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;

Line 1082: l_custom_rec BIS_QUERY_ATTRIBUTES;

1078: from bim_i_source_codes
1079: where source_code_id=replace(l_campaign_id,'''');
1080: /*********************************************************/
1081: l_object_type varchar2(30);
1082: l_custom_rec BIS_QUERY_ATTRIBUTES;
1083: l_curr_suffix1 VARCHAR2(50);
1084: l_table_bud VARCHAR2(300);
1085: l_where_bud VARCHAR2(300);
1086: l_prog_cost1 VARCHAR2(20);

Line 1089: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

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,