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

Line 108: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

104: l_having := '';
105: l_from := '';
106: l_where := '';
107: l_inner_group_by := '';
108: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
109:
110: /*********************Bind Parameters used are****************************/
111:
112: /* &BIS_CURRENT_ASOF_DATE : AS OF DATE selected in the report */

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

279:
280:
281: l_custom_rec.attribute_name := ':l_currency' ;
282: l_custom_rec.attribute_value:= l_currency;
283: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
284: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
285: x_custom_output.EXTEND;
286: x_custom_output(1) := l_custom_rec;
287:

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

280:
281: l_custom_rec.attribute_name := ':l_currency' ;
282: l_custom_rec.attribute_value:= l_currency;
283: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
284: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
285: x_custom_output.EXTEND;
286: x_custom_output(1) := l_custom_rec;
287:
288: l_custom_rec.attribute_name := ':l_gp_currency' ;

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

286: x_custom_output(1) := l_custom_rec;
287:
288: l_custom_rec.attribute_name := ':l_gp_currency' ;
289: l_custom_rec.attribute_value:= l_gp_currency;
290: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
291: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
292: x_custom_output.EXTEND;
293: x_custom_output(2) := l_custom_rec;
294:

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

287:
288: l_custom_rec.attribute_name := ':l_gp_currency' ;
289: l_custom_rec.attribute_value:= l_gp_currency;
290: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
291: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
292: x_custom_output.EXTEND;
293: x_custom_output(2) := l_custom_rec;
294:
295: l_custom_rec.attribute_name := ':l_gs_currency' ;

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

293: x_custom_output(2) := l_custom_rec;
294:
295: l_custom_rec.attribute_name := ':l_gs_currency' ;
296: l_custom_rec.attribute_value:= l_gs_currency;
297: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
298: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
299: x_custom_output.EXTEND;
300: x_custom_output(3) := l_custom_rec;
301:

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

294:
295: l_custom_rec.attribute_name := ':l_gs_currency' ;
296: l_custom_rec.attribute_value:= l_gs_currency;
297: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
298: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
299: x_custom_output.EXTEND;
300: x_custom_output(3) := l_custom_rec;
301:
302: IF gaflog_value ='Y' AND (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

Line 423: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

419: l_from2 := '';
420: l_where2 := '';
421: l_inner_group_by := '';
422: l_inner_group_by1 := '';
423: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
424: l_url_str_prod := 'pFunctionName=IBW_BI_PRDCTINTRST_RPT&pParamIds=Y&VIEW_BY=IBW_WEB_ANALYTICS_GROUP1+ENI_ITEM&VIEW_BY_NAME=VIEW_BY_ID';
425: l_url_str_prodcatg :='pFunctionName=IBW_BI_PRDCTINTRST_RPT&pParamIds=Y&VIEW_BY=ITEM+ENI_ITEM_VBH_CAT&VIEW_BY_NAME=VIEW_BY_ID';
426:
427:

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

807: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
808:
809: l_custom_rec.attribute_name := ':l_currency' ;
810: l_custom_rec.attribute_value:= l_currency;
811: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
812: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
813: x_custom_output.EXTEND;
814: x_custom_output(1) := l_custom_rec;
815:

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

808:
809: l_custom_rec.attribute_name := ':l_currency' ;
810: l_custom_rec.attribute_value:= l_currency;
811: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
812: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
813: x_custom_output.EXTEND;
814: x_custom_output(1) := l_custom_rec;
815:
816: l_custom_rec.attribute_name := ':l_gp_currency' ;

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

814: x_custom_output(1) := l_custom_rec;
815:
816: l_custom_rec.attribute_name := ':l_gp_currency' ;
817: l_custom_rec.attribute_value:= l_gp_currency;
818: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
819: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
820: x_custom_output.EXTEND;
821: x_custom_output(2) := l_custom_rec;
822:

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

815:
816: l_custom_rec.attribute_name := ':l_gp_currency' ;
817: l_custom_rec.attribute_value:= l_gp_currency;
818: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
819: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
820: x_custom_output.EXTEND;
821: x_custom_output(2) := l_custom_rec;
822:
823: l_custom_rec.attribute_name := ':l_gs_currency' ;

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

821: x_custom_output(2) := l_custom_rec;
822:
823: l_custom_rec.attribute_name := ':l_gs_currency' ;
824: l_custom_rec.attribute_value:= l_gs_currency;
825: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
826: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
827: x_custom_output.EXTEND;
828: x_custom_output(3) := l_custom_rec;
829:

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

822:
823: l_custom_rec.attribute_name := ':l_gs_currency' ;
824: l_custom_rec.attribute_value:= l_gs_currency;
825: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
826: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
827: x_custom_output.EXTEND;
828: x_custom_output(3) := l_custom_rec;
829:
830: