DBA Data[Home] [Help]

APPS.IBW_BI_VST_CMP_KPI_PVT dependencies on BIS_PMV_PARAMETERS_PUB

Line 135: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

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

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

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:

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

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' ;

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

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:

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

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' ;

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

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:

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

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

Line 467: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

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

Line 767: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

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 */

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

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:

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

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' ;

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

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:

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

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' ;

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

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;

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

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:

Line 1104: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

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

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

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:

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

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' ;

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

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:

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

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' ;

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

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:

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

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