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

Line 216: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;

212: ELSE l_item_cat_flag := 0; -- Product Category
213: END IF;
214:
215:
216: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
217: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
218:
219: IF (l_invalid_curr)
220: THEN l_stmt := '

Line 421: l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.View_By_Value;

417: END IF;
418:
419: x_custom_sql := l_stmt;
420:
421: l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.View_By_Value;
422: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.View_By_Type;
423: IF l_period_type = 'FII_TIME_ENT_YEAR' THEN
424: l_custom_rec.attribute_value := 'TIME+FII_TIME_ENT_PERIOD';
425: ELSE -- l_period_type = 'FII_TIME_ENT_QTR', 'FII_TIME_ENT_PERIOD', 'FII_TIME_WEEK'

Line 422: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.View_By_Type;

418:
419: x_custom_sql := l_stmt;
420:
421: l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.View_By_Value;
422: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.View_By_Type;
423: IF l_period_type = 'FII_TIME_ENT_YEAR' THEN
424: l_custom_rec.attribute_value := 'TIME+FII_TIME_ENT_PERIOD';
425: ELSE -- l_period_type = 'FII_TIME_ENT_QTR', 'FII_TIME_ENT_PERIOD', 'FII_TIME_WEEK'
426: l_custom_rec.attribute_value := 'TIME+FII_TIME_DAY';

Line 433: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

429: x_custom_output(1) := l_custom_rec;
430:
431: l_custom_rec.attribute_name := ':ISC_CUST';
432: l_custom_rec.attribute_value := l_cust_flag;
433: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
434: l_custom_Rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
435: x_custom_output.EXTEND;
436: x_custom_output(2) := l_custom_rec;
437:

Line 434: l_custom_Rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;

430:
431: l_custom_rec.attribute_name := ':ISC_CUST';
432: l_custom_rec.attribute_value := l_cust_flag;
433: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
434: l_custom_Rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
435: x_custom_output.EXTEND;
436: x_custom_output(2) := l_custom_rec;
437:
438: l_custom_rec.attribute_name := ':ISC_SG';

Line 440: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

436: x_custom_output(2) := l_custom_rec;
437:
438: l_custom_rec.attribute_name := ':ISC_SG';
439: l_custom_rec.attribute_value := to_char(l_sg_sg);
440: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
441: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
442: x_custom_output.extend;
443: x_custom_output(3) := l_custom_rec;
444:

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

437:
438: l_custom_rec.attribute_name := ':ISC_SG';
439: l_custom_rec.attribute_value := to_char(l_sg_sg);
440: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
441: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
442: x_custom_output.extend;
443: x_custom_output(3) := l_custom_rec;
444:
445: l_custom_rec.attribute_name := ':ISC_RES';

Line 447: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

443: x_custom_output(3) := l_custom_rec;
444:
445: l_custom_rec.attribute_name := ':ISC_RES';
446: l_custom_rec.attribute_value := to_char(l_sg_res);
447: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
448: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
449: x_custom_output.extend;
450: x_custom_output(4) := l_custom_rec;
451:

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

444:
445: l_custom_rec.attribute_name := ':ISC_RES';
446: l_custom_rec.attribute_value := to_char(l_sg_res);
447: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
448: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
449: x_custom_output.extend;
450: x_custom_output(4) := l_custom_rec;
451:
452: l_custom_rec.attribute_name := ':ISC_ITEM_CAT_FLAG';

Line 454: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;

450: x_custom_output(4) := l_custom_rec;
451:
452: l_custom_rec.attribute_name := ':ISC_ITEM_CAT_FLAG';
453: l_custom_rec.attribute_value := to_char(l_item_cat_flag);
454: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
455: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.integer_bind;
456: x_custom_output.extend;
457: x_custom_output(5) := l_custom_rec;
458:

Line 455: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.integer_bind;

451:
452: l_custom_rec.attribute_name := ':ISC_ITEM_CAT_FLAG';
453: l_custom_rec.attribute_value := to_char(l_item_cat_flag);
454: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
455: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.integer_bind;
456: x_custom_output.extend;
457: x_custom_output(5) := l_custom_rec;
458:
459: l_custom_rec.attribute_name := ':ISC_CURR_START';

Line 461: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;

457: x_custom_output(5) := l_custom_rec;
458:
459: l_custom_rec.attribute_name := ':ISC_CURR_START';
460: l_custom_rec.attribute_value := to_char(l_curr_start,'DD-MM-YYYY');
461: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
462: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.date_bind;
463: x_custom_output.extend;
464: x_custom_output(6) := l_custom_rec;
465:

Line 462: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.date_bind;

458:
459: l_custom_rec.attribute_name := ':ISC_CURR_START';
460: l_custom_rec.attribute_value := to_char(l_curr_start,'DD-MM-YYYY');
461: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
462: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.date_bind;
463: x_custom_output.extend;
464: x_custom_output(6) := l_custom_rec;
465:
466: l_custom_rec.attribute_name := ':ISC_CURR_END';

Line 468: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;

464: x_custom_output(6) := l_custom_rec;
465:
466: l_custom_rec.attribute_name := ':ISC_CURR_END';
467: l_custom_rec.attribute_value := to_char(l_curr_end,'DD-MM-YYYY');
468: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
469: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.date_bind;
470: x_custom_output.extend;
471: x_custom_output(7) := l_custom_rec;
472:

Line 469: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.date_bind;

465:
466: l_custom_rec.attribute_name := ':ISC_CURR_END';
467: l_custom_rec.attribute_value := to_char(l_curr_end,'DD-MM-YYYY');
468: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
469: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.date_bind;
470: x_custom_output.extend;
471: x_custom_output(7) := l_custom_rec;
472:
473: l_custom_rec.attribute_name := ':ISC_PRIOR_START';

Line 475: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;

471: x_custom_output(7) := l_custom_rec;
472:
473: l_custom_rec.attribute_name := ':ISC_PRIOR_START';
474: l_custom_rec.attribute_value := to_char(l_prior_start,'DD-MM-YYYY');
475: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
476: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.date_bind;
477: x_custom_output.extend;
478: x_custom_output(8) := l_custom_rec;
479:

Line 476: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.date_bind;

472:
473: l_custom_rec.attribute_name := ':ISC_PRIOR_START';
474: l_custom_rec.attribute_value := to_char(l_prior_start,'DD-MM-YYYY');
475: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
476: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.date_bind;
477: x_custom_output.extend;
478: x_custom_output(8) := l_custom_rec;
479:
480: l_custom_rec.attribute_name := ':ISC_PRIOR_END';

Line 482: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;

478: x_custom_output(8) := l_custom_rec;
479:
480: l_custom_rec.attribute_name := ':ISC_PRIOR_END';
481: l_custom_rec.attribute_value := to_char(l_prior_end,'DD-MM-YYYY');
482: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
483: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.date_bind;
484: x_custom_output.extend;
485: x_custom_output(9) := l_custom_rec;
486:

Line 483: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.date_bind;

479:
480: l_custom_rec.attribute_name := ':ISC_PRIOR_END';
481: l_custom_rec.attribute_value := to_char(l_prior_end,'DD-MM-YYYY');
482: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
483: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.date_bind;
484: x_custom_output.extend;
485: x_custom_output(9) := l_custom_rec;
486:
487: l_custom_rec.attribute_name := ':ISC_TEMP';

Line 489: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;

485: x_custom_output(9) := l_custom_rec;
486:
487: l_custom_rec.attribute_name := ':ISC_TEMP';
488: l_custom_rec.attribute_value := to_char(l_temp,'DD-MM-YYYY');
489: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
490: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.date_bind;
491: x_custom_output.extend;
492: x_custom_output(10) := l_custom_rec;
493:

Line 490: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.date_bind;

486:
487: l_custom_rec.attribute_name := ':ISC_TEMP';
488: l_custom_rec.attribute_value := to_char(l_temp,'DD-MM-YYYY');
489: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
490: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.date_bind;
491: x_custom_output.extend;
492: x_custom_output(10) := l_custom_rec;
493:
494: END get_sql;