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

Line 106: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

102: l_site_from := '';
103: l_outer_select := '';
104: l_outer_where := '';
105: l_custom_sql := '';
106: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
107:
108: --Initializing section completed
109:
110: --Get the Table List

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

335: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
336:
337: l_custom_rec.attribute_name := ':l_currency' ;
338: l_custom_rec.attribute_value:= l_currency;
339: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
340: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
341: x_custom_output.EXTEND;
342: x_custom_output(1) := l_custom_rec;
343:

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

336:
337: l_custom_rec.attribute_name := ':l_currency' ;
338: l_custom_rec.attribute_value:= l_currency;
339: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
340: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
341: x_custom_output.EXTEND;
342: x_custom_output(1) := l_custom_rec;
343:
344: l_custom_rec.attribute_name := ':l_gp_currency' ;

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

342: x_custom_output(1) := l_custom_rec;
343:
344: l_custom_rec.attribute_name := ':l_gp_currency' ;
345: l_custom_rec.attribute_value:= l_gp_currency;
346: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
347: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
348: x_custom_output.EXTEND;
349: x_custom_output(2) := l_custom_rec;
350:

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

343:
344: l_custom_rec.attribute_name := ':l_gp_currency' ;
345: l_custom_rec.attribute_value:= l_gp_currency;
346: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
347: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
348: x_custom_output.EXTEND;
349: x_custom_output(2) := l_custom_rec;
350:
351: l_custom_rec.attribute_name := ':l_gs_currency' ;

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

349: x_custom_output(2) := l_custom_rec;
350:
351: l_custom_rec.attribute_name := ':l_gs_currency' ;
352: l_custom_rec.attribute_value:= l_gs_currency;
353: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
354: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
355: x_custom_output.EXTEND;
356: x_custom_output(3) := l_custom_rec;
357:

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

350:
351: l_custom_rec.attribute_name := ':l_gs_currency' ;
352: l_custom_rec.attribute_value:= l_gs_currency;
353: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
354: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
355: x_custom_output.EXTEND;
356: x_custom_output(3) := l_custom_rec;
357:
358: IF gaflog_value ='Y' AND (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

Line 474: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

470: l_site_from := '';
471: l_custom_sql := '';
472: l_outer_select := '';
473: l_outer_where := '';
474: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
475:
476: --Get the Table List
477:
478: l_from := ' IBW_VISIT_CUST_TIME_MV CUSTACQUIS_MV' ||

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

769: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
770:
771: l_custom_rec.attribute_name := ':l_currency' ;
772: l_custom_rec.attribute_value:= l_currency;
773: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
774: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
775: x_custom_output.EXTEND;
776: x_custom_output(1) := l_custom_rec;
777:

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

770:
771: l_custom_rec.attribute_name := ':l_currency' ;
772: l_custom_rec.attribute_value:= l_currency;
773: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
774: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
775: x_custom_output.EXTEND;
776: x_custom_output(1) := l_custom_rec;
777:
778: l_custom_rec.attribute_name := ':l_gp_currency' ;

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

776: x_custom_output(1) := l_custom_rec;
777:
778: l_custom_rec.attribute_name := ':l_gp_currency' ;
779: l_custom_rec.attribute_value:= l_gp_currency;
780: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
781: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
782: x_custom_output.EXTEND;
783: x_custom_output(2) := l_custom_rec;
784:

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

777:
778: l_custom_rec.attribute_name := ':l_gp_currency' ;
779: l_custom_rec.attribute_value:= l_gp_currency;
780: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
781: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
782: x_custom_output.EXTEND;
783: x_custom_output(2) := l_custom_rec;
784:
785: l_custom_rec.attribute_name := ':l_gs_currency' ;

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

783: x_custom_output(2) := l_custom_rec;
784:
785: l_custom_rec.attribute_name := ':l_gs_currency' ;
786: l_custom_rec.attribute_value:= l_gs_currency;
787: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
788: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
789: x_custom_output.EXTEND;
790: x_custom_output(3) := l_custom_rec;
791:

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

784:
785: l_custom_rec.attribute_name := ':l_gs_currency' ;
786: l_custom_rec.attribute_value:= l_gs_currency;
787: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
788: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
789: x_custom_output.EXTEND;
790: x_custom_output(3) := l_custom_rec;
791:
792: IF gaflog_value ='Y' AND (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

Line 921: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

917: l_where_all := '';
918: l_middle_select := '';
919: l_middle_group_by := '';
920: l_having := '';
921: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
922:
923:
924: --Get the Table List
925:

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

1241: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
1242:
1243: l_custom_rec.attribute_name := ':l_currency' ;
1244: l_custom_rec.attribute_value:= l_currency;
1245: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1246: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1247: x_custom_output.EXTEND;
1248: x_custom_output(1) := l_custom_rec;
1249:

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

1242:
1243: l_custom_rec.attribute_name := ':l_currency' ;
1244: l_custom_rec.attribute_value:= l_currency;
1245: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1246: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1247: x_custom_output.EXTEND;
1248: x_custom_output(1) := l_custom_rec;
1249:
1250: l_custom_rec.attribute_name := ':l_gp_currency' ;

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

1248: x_custom_output(1) := l_custom_rec;
1249:
1250: l_custom_rec.attribute_name := ':l_gp_currency' ;
1251: l_custom_rec.attribute_value:= l_gp_currency;
1252: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1253: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1254: x_custom_output.EXTEND;
1255: x_custom_output(2) := l_custom_rec;
1256:

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

1249:
1250: l_custom_rec.attribute_name := ':l_gp_currency' ;
1251: l_custom_rec.attribute_value:= l_gp_currency;
1252: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1253: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1254: x_custom_output.EXTEND;
1255: x_custom_output(2) := l_custom_rec;
1256:
1257: l_custom_rec.attribute_name := ':l_gs_currency' ;

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

1255: x_custom_output(2) := l_custom_rec;
1256:
1257: l_custom_rec.attribute_name := ':l_gs_currency' ;
1258: l_custom_rec.attribute_value:= l_gs_currency;
1259: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1260: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1261: x_custom_output.EXTEND;
1262: x_custom_output(3) := l_custom_rec;
1263:

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

1256:
1257: l_custom_rec.attribute_name := ':l_gs_currency' ;
1258: l_custom_rec.attribute_value:= l_gs_currency;
1259: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1260: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1261: x_custom_output.EXTEND;
1262: x_custom_output(3) := l_custom_rec;
1263:
1264: IF gaflog_value ='Y' AND (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN