131:
132: --Initializing section starts
133:
134: l_outer_where_clause := '';
135: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
136:
137: --Initializing section completed
138:
139: --Get the Table List
299: x_custom_output.Extend(3);
300:
301: l_custom_rec.attribute_name := ':l_currency' ;
302: l_custom_rec.attribute_value:= l_currency;
303: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
304: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
305: x_custom_output.EXTEND;
306: x_custom_output(1) := l_custom_rec;
307:
300:
301: l_custom_rec.attribute_name := ':l_currency' ;
302: l_custom_rec.attribute_value:= l_currency;
303: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
304: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
305: x_custom_output.EXTEND;
306: x_custom_output(1) := l_custom_rec;
307:
308: l_custom_rec.attribute_name := ':l_gp_currency' ;
306: x_custom_output(1) := l_custom_rec;
307:
308: l_custom_rec.attribute_name := ':l_gp_currency' ;
309: l_custom_rec.attribute_value:= l_gp_currency;
310: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
311: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
312: x_custom_output.EXTEND;
313: x_custom_output(2) := l_custom_rec;
314:
307:
308: l_custom_rec.attribute_name := ':l_gp_currency' ;
309: l_custom_rec.attribute_value:= l_gp_currency;
310: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
311: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
312: x_custom_output.EXTEND;
313: x_custom_output(2) := l_custom_rec;
314:
315: l_custom_rec.attribute_name := ':l_gs_currency' ;
313: x_custom_output(2) := l_custom_rec;
314:
315: l_custom_rec.attribute_name := ':l_gs_currency' ;
316: l_custom_rec.attribute_value:= l_gs_currency;
317: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
318: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
319: x_custom_output.EXTEND;
320: x_custom_output(3) := l_custom_rec;
321:
314:
315: l_custom_rec.attribute_name := ':l_gs_currency' ;
316: l_custom_rec.attribute_value:= l_gs_currency;
317: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
318: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
319: x_custom_output.EXTEND;
320: x_custom_output(3) := l_custom_rec;
321:
322: --IF gaflog_value ='Y' AND (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
463:
464: --Initializing section starts
465:
466: l_outer_where_clause := '';
467: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
468:
469: --Initializing section completed
470:
471: --Get the Table List
763:
764:
765: l_where := '';
766: l_url_str := null; --Initialising the String to Null
767: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
768:
769: --Initializing section starts
770: /********************Metrics in Campaign Analysis Report*********************/
771: /* IBW_VAL1 : Visits */
941:
942:
943: l_custom_rec.attribute_name := ':l_currency' ;
944: l_custom_rec.attribute_value:= l_currency;
945: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
946: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
947: x_custom_output.EXTEND;
948: x_custom_output(1) := l_custom_rec;
949:
942:
943: l_custom_rec.attribute_name := ':l_currency' ;
944: l_custom_rec.attribute_value:= l_currency;
945: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
946: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
947: x_custom_output.EXTEND;
948: x_custom_output(1) := l_custom_rec;
949:
950: l_custom_rec.attribute_name := ':l_gp_currency' ;
948: x_custom_output(1) := l_custom_rec;
949:
950: l_custom_rec.attribute_name := ':l_gp_currency' ;
951: l_custom_rec.attribute_value:= l_gp_currency;
952: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
953: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
954: x_custom_output.EXTEND;
955: x_custom_output(2) := l_custom_rec;
956:
949:
950: l_custom_rec.attribute_name := ':l_gp_currency' ;
951: l_custom_rec.attribute_value:= l_gp_currency;
952: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
953: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
954: x_custom_output.EXTEND;
955: x_custom_output(2) := l_custom_rec;
956:
957: l_custom_rec.attribute_name := ':l_gs_currency' ;
955: x_custom_output(2) := l_custom_rec;
956:
957: l_custom_rec.attribute_name := ':l_gs_currency' ;
958: l_custom_rec.attribute_value:= l_gs_currency;
959: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
960: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
961: x_custom_output.EXTEND;
962:
963: x_custom_output(3) := l_custom_rec;
956:
957: l_custom_rec.attribute_name := ':l_gs_currency' ;
958: l_custom_rec.attribute_value:= l_gs_currency;
959: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
960: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
961: x_custom_output.EXTEND;
962:
963: x_custom_output(3) := l_custom_rec;
964:
1100: END IF;
1101: --Initializing section starts
1102:
1103: l_outer_where_clause := '';
1104: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
1105:
1106: --Initializing section completed
1107:
1108: --Get the Table List
1267: x_custom_output.Extend(3);
1268:
1269: l_custom_rec.attribute_name := ':l_currency' ;
1270: l_custom_rec.attribute_value:= l_currency;
1271: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1272: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1273:
1274: x_custom_output(1) := l_custom_rec;
1275:
1268:
1269: l_custom_rec.attribute_name := ':l_currency' ;
1270: l_custom_rec.attribute_value:= l_currency;
1271: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1272: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1273:
1274: x_custom_output(1) := l_custom_rec;
1275:
1276: l_custom_rec.attribute_name := ':l_gp_currency' ;
1274: x_custom_output(1) := l_custom_rec;
1275:
1276: l_custom_rec.attribute_name := ':l_gp_currency' ;
1277: l_custom_rec.attribute_value:= l_gp_currency;
1278: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1279: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1280:
1281: x_custom_output(2) := l_custom_rec;
1282:
1275:
1276: l_custom_rec.attribute_name := ':l_gp_currency' ;
1277: l_custom_rec.attribute_value:= l_gp_currency;
1278: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1279: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1280:
1281: x_custom_output(2) := l_custom_rec;
1282:
1283: l_custom_rec.attribute_name := ':l_gs_currency' ;
1281: x_custom_output(2) := l_custom_rec;
1282:
1283: l_custom_rec.attribute_name := ':l_gs_currency' ;
1284: l_custom_rec.attribute_value:= l_gs_currency;
1285: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1286: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1287:
1288: x_custom_output(3) := l_custom_rec;
1289:
1282:
1283: l_custom_rec.attribute_name := ':l_gs_currency' ;
1284: l_custom_rec.attribute_value:= l_gs_currency;
1285: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1286: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1287:
1288: x_custom_output(3) := l_custom_rec;
1289:
1290: IF gaflog_value ='Y' AND (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN