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

Line 134: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

130: ELSE
131: l_item_cat_flag := 0; -- item
132: END IF;
133:
134: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
135: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
136:
137: l_formula_sql :='CURR_PLANNED_QUANTITY OPI_MEASURE1,
138: PREV_PLANNED_STANDARD_VALUE OPI_MEASURE2,

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

356: x_custom_sql := l_stmt;
357:
358: l_custom_rec.attribute_name := ':OPI_ITEM_CAT_FLAG';
359: l_custom_rec.attribute_value := to_char(l_item_cat_flag);
360: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
361: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
362: x_custom_output.EXTEND;
363: x_custom_output(1) := l_custom_rec;
364:

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

357:
358: l_custom_rec.attribute_name := ':OPI_ITEM_CAT_FLAG';
359: l_custom_rec.attribute_value := to_char(l_item_cat_flag);
360: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
361: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
362: x_custom_output.EXTEND;
363: x_custom_output(1) := l_custom_rec;
364:
365: l_custom_rec.attribute_name := ':OPI_LANG_CODE';

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

363: x_custom_output(1) := l_custom_rec;
364:
365: l_custom_rec.attribute_name := ':OPI_LANG_CODE';
366: l_custom_rec.attribute_value := l_lang_code;
367: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
368: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
369: x_custom_output.EXTEND;
370: x_custom_output(2) := l_custom_rec;
371:

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

364:
365: l_custom_rec.attribute_name := ':OPI_LANG_CODE';
366: l_custom_rec.attribute_value := l_lang_code;
367: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
368: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
369: x_custom_output.EXTEND;
370: x_custom_output(2) := l_custom_rec;
371:
372: END GET_TBL_SQL;

Line 505: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

501: l_item_cat_flag := 0; -- item is needed
502: END IF;
503: END IF;
504:
505: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
506: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
507:
508: l_stmt :=
509: 'SELECT

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

761: x_custom_sql := l_stmt;
762:
763: l_custom_rec.attribute_name := ':OPI_ITEM_CAT_FLAG';
764: l_custom_rec.attribute_value := to_char(l_item_cat_flag);
765: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
766: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
767: x_custom_output.EXTEND;
768: x_custom_output(1) := l_custom_rec;
769:

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

762:
763: l_custom_rec.attribute_name := ':OPI_ITEM_CAT_FLAG';
764: l_custom_rec.attribute_value := to_char(l_item_cat_flag);
765: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
766: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
767: x_custom_output.EXTEND;
768: x_custom_output(1) := l_custom_rec;
769:
770: END GET_TRD_SQL;

Line 931: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

927: l_item_cat_flag := 0; -- item is needed
928: END IF;
929: END IF;
930:
931: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
932: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
933:
934: l_stmt :='SELECT fact.name VIEWBY,
935: CURR_ACTUAL_STANDARD_VALUE OPI_MEASURE1,

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

1046: x_custom_sql := l_stmt;
1047:
1048: l_custom_rec.attribute_name := ':OPI_ITEM_CAT_FLAG';
1049: l_custom_rec.attribute_value := to_char(l_item_cat_flag);
1050: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1051: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
1052: x_custom_output.EXTEND;
1053: x_custom_output(1) := l_custom_rec;
1054:

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

1047:
1048: l_custom_rec.attribute_name := ':OPI_ITEM_CAT_FLAG';
1049: l_custom_rec.attribute_value := to_char(l_item_cat_flag);
1050: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1051: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
1052: x_custom_output.EXTEND;
1053: x_custom_output(1) := l_custom_rec;
1054:
1055: l_custom_rec.attribute_name := ':OPI_NESTED_PATTERN';

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

1053: x_custom_output(1) := l_custom_rec;
1054:
1055: l_custom_rec.attribute_name := ':OPI_NESTED_PATTERN';
1056: l_custom_rec.attribute_value := l_nested_pattern;
1057: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1058: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1059: x_custom_output.EXTEND;
1060: x_custom_output(2) := l_custom_rec;
1061:

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

1054:
1055: l_custom_rec.attribute_name := ':OPI_NESTED_PATTERN';
1056: l_custom_rec.attribute_value := l_nested_pattern;
1057: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1058: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1059: x_custom_output.EXTEND;
1060: x_custom_output(2) := l_custom_rec;
1061:
1062: l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;

Line 1062: l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;

1058: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1059: x_custom_output.EXTEND;
1060: x_custom_output(2) := l_custom_rec;
1061:
1062: l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;
1063: l_custom_rec.attribute_value := 'TIME+'||substrb(l_period_detail, 1, instrb(l_period_detail, '_', -1, 1)-1);
1064: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.VIEW_BY_TYPE;
1065: x_custom_output.EXTEND;
1066: x_custom_output(3) := l_custom_rec;

Line 1064: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.VIEW_BY_TYPE;

1060: x_custom_output(2) := l_custom_rec;
1061:
1062: l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;
1063: l_custom_rec.attribute_value := 'TIME+'||substrb(l_period_detail, 1, instrb(l_period_detail, '_', -1, 1)-1);
1064: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.VIEW_BY_TYPE;
1065: x_custom_output.EXTEND;
1066: x_custom_output(3) := l_custom_rec;
1067:
1068: END GET_CMLTV_TRD_SQL;