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

Line 20: -- BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;

16: l_currency_code VARCHAR2(3200);
17: l_minisite VARCHAR2(3200);
18: l_minisite_id VARCHAR2(3200);
19: l_custom_rec BIS_QUERY_ATTRIBUTES;-- :=
20: -- BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
21: dbg_msg VARCHAR2(3200);
22: l_g_p VARCHAR2(30);
23: l_g_s VARCHAR2(30);
24:

Line 36: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;

32: END IF;
33:
34: -- initilization of variables
35:
36: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
37: l_g_p := '''FII_GLOBAL1''';
38: l_g_s := '''FII_GLOBAL2''';
39:
40: FOR i IN p_pmv_parameters.FIRST..p_pmv_parameters.LAST

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

146: x_custom_output.Extend(4);
147:
148: l_custom_rec.attribute_name := ':l_asof_date' ;
149: l_custom_rec.attribute_value:= to_char(l_asof_date,'dd/mm/yyyy');
150: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
151: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
152:
153: x_custom_output(1) := l_custom_rec;
154:

Line 151: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;

147:
148: l_custom_rec.attribute_name := ':l_asof_date' ;
149: l_custom_rec.attribute_value:= to_char(l_asof_date,'dd/mm/yyyy');
150: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
151: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
152:
153: x_custom_output(1) := l_custom_rec;
154:
155: l_custom_rec.attribute_name := ':l_prev_date' ;

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

153: x_custom_output(1) := l_custom_rec;
154:
155: l_custom_rec.attribute_name := ':l_prev_date' ;
156: l_custom_rec.attribute_value:= to_char(l_prev_date,'dd/mm/yyyy');
157: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
158: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
159:
160: x_custom_output(2) := l_custom_rec;
161:

Line 158: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;

154:
155: l_custom_rec.attribute_name := ':l_prev_date' ;
156: l_custom_rec.attribute_value:= to_char(l_prev_date,'dd/mm/yyyy');
157: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
158: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
159:
160: x_custom_output(2) := l_custom_rec;
161:
162: l_custom_rec.attribute_name := ':l_record_type_id' ;

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

160: x_custom_output(2) := l_custom_rec;
161:
162: l_custom_rec.attribute_name := ':l_record_type_id' ;
163: l_custom_rec.attribute_value:= l_record_type_id;
164: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
165: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
166:
167: x_custom_output(3) := l_custom_rec;
168:

Line 165: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;

161:
162: l_custom_rec.attribute_name := ':l_record_type_id' ;
163: l_custom_rec.attribute_value:= l_record_type_id;
164: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
165: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
166:
167: x_custom_output(3) := l_custom_rec;
168:
169: /*

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

168:
169: /*
170: l_custom_rec.attribute_name := ':l_minisite_id' ;
171: l_custom_rec.attribute_value:= l_minisite_id;
172: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
173: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
174:
175: x_custom_output(4) := l_custom_rec;
176: */

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

169: /*
170: l_custom_rec.attribute_name := ':l_minisite_id' ;
171: l_custom_rec.attribute_value:= l_minisite_id;
172: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
173: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
174:
175: x_custom_output(4) := l_custom_rec;
176: */
177:

Line 216: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;

212: END IF;
213:
214: -- initilization of variables
215:
216: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
217: l_assist_type := 'IBE_ORD_TOTAL';
218: l_g_p := '''FII_GLOBAL1''';
219: l_g_s := '''FII_GLOBAL2''';
220:

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

375: x_custom_output.Extend(8);
376:
377: l_custom_rec.attribute_name := ':l_asof_date' ;
378: l_custom_rec.attribute_value:= to_char(l_asof_date,'dd/mm/yyyy');
379: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
380: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
381:
382: x_custom_output(1) := l_custom_rec;
383:

Line 380: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;

376:
377: l_custom_rec.attribute_name := ':l_asof_date' ;
378: l_custom_rec.attribute_value:= to_char(l_asof_date,'dd/mm/yyyy');
379: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
380: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
381:
382: x_custom_output(1) := l_custom_rec;
383:
384: l_custom_rec.attribute_name := ':l_prev_date' ;

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

382: x_custom_output(1) := l_custom_rec;
383:
384: l_custom_rec.attribute_name := ':l_prev_date' ;
385: l_custom_rec.attribute_value:= to_char(l_prev_date,'dd/mm/yyyy');
386: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
387: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
388:
389: x_custom_output(2) := l_custom_rec;
390:

Line 387: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;

383:
384: l_custom_rec.attribute_name := ':l_prev_date' ;
385: l_custom_rec.attribute_value:= to_char(l_prev_date,'dd/mm/yyyy');
386: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
387: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
388:
389: x_custom_output(2) := l_custom_rec;
390:
391: l_custom_rec.attribute_name := ':l_c_d' ;

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

389: x_custom_output(2) := l_custom_rec;
390:
391: l_custom_rec.attribute_name := ':l_c_d' ;
392: l_custom_rec.attribute_value:= l_c_d;
393: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
394: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
395:
396: x_custom_output(3) := l_custom_rec;
397:

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

390:
391: l_custom_rec.attribute_name := ':l_c_d' ;
392: l_custom_rec.attribute_value:= l_c_d;
393: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
394: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
395:
396: x_custom_output(3) := l_custom_rec;
397:
398: l_custom_rec.attribute_name := ':l_assist_type' ;

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

396: x_custom_output(3) := l_custom_rec;
397:
398: l_custom_rec.attribute_name := ':l_assist_type' ;
399: l_custom_rec.attribute_value:= l_assist_type;
400: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
401: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
402:
403: x_custom_output(4) := l_custom_rec;
404:

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

397:
398: l_custom_rec.attribute_name := ':l_assist_type' ;
399: l_custom_rec.attribute_value:= l_assist_type;
400: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
401: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
402:
403: x_custom_output(4) := l_custom_rec;
404:
405: l_custom_rec.attribute_name := ':l_record_type_id' ;

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

403: x_custom_output(4) := l_custom_rec;
404:
405: l_custom_rec.attribute_name := ':l_record_type_id' ;
406: l_custom_rec.attribute_value:= l_record_type_id;
407: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
408: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
409:
410: x_custom_output(5) := l_custom_rec;
411:

Line 408: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;

404:
405: l_custom_rec.attribute_name := ':l_record_type_id' ;
406: l_custom_rec.attribute_value:= l_record_type_id;
407: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
408: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
409:
410: x_custom_output(5) := l_custom_rec;
411:
412: l_custom_rec.attribute_name := ':l_g_p' ;

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

410: x_custom_output(5) := l_custom_rec;
411:
412: l_custom_rec.attribute_name := ':l_g_p' ;
413: l_custom_rec.attribute_value:= l_g_p;
414: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
415: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
416:
417: x_custom_output(6) := l_custom_rec;
418:

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

411:
412: l_custom_rec.attribute_name := ':l_g_p' ;
413: l_custom_rec.attribute_value:= l_g_p;
414: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
415: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
416:
417: x_custom_output(6) := l_custom_rec;
418:
419: l_custom_rec.attribute_name := ':l_g_s' ;

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

417: x_custom_output(6) := l_custom_rec;
418:
419: l_custom_rec.attribute_name := ':l_g_s' ;
420: l_custom_rec.attribute_value:= l_g_s;
421: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
422: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
423:
424: x_custom_output(7) := l_custom_rec;
425: /*

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

418:
419: l_custom_rec.attribute_name := ':l_g_s' ;
420: l_custom_rec.attribute_value:= l_g_s;
421: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
422: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
423:
424: x_custom_output(7) := l_custom_rec;
425: /*
426: l_custom_rec.attribute_name := ':l_minisite_id' ;

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

424: x_custom_output(7) := l_custom_rec;
425: /*
426: l_custom_rec.attribute_name := ':l_minisite_id' ;
427: l_custom_rec.attribute_value:= l_minisite_id;
428: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
429: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
430:
431: x_custom_output(8) := l_custom_rec;
432: */

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

425: /*
426: l_custom_rec.attribute_name := ':l_minisite_id' ;
427: l_custom_rec.attribute_value:= l_minisite_id;
428: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
429: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
430:
431: x_custom_output(8) := l_custom_rec;
432: */
433: