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_CC_RPT_PKG dependencies on BIS_PMV_PARAMETERS_PUB

Line 146: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

142: p_in_join_tables => NULL);
143:
144: -- prepare output for bind variables
145: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
146: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
147:
148: -- set the basic bind variables for the status SQL
149: poa_dbi_util_pkg.get_custom_status_binds (x_custom_output);
150:

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

150:
151: -- Passing OPI_AGGREGATION_LEVEL_FLAG to PMV
152: l_custom_rec.attribute_name := ':OPI_CCA_LEVEL_FLAG';
153: l_custom_rec.attribute_value := l_aggregation_level_flag;
154: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
155: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
156: x_custom_output.extend;
157: x_custom_output(x_custom_output.count) := l_custom_rec;
158:

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

151: -- Passing OPI_AGGREGATION_LEVEL_FLAG to PMV
152: l_custom_rec.attribute_name := ':OPI_CCA_LEVEL_FLAG';
153: l_custom_rec.attribute_value := l_aggregation_level_flag;
154: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
155: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
156: x_custom_output.extend;
157: x_custom_output(x_custom_output.count) := l_custom_rec;
158:
159:

Line 568: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

564:
565:
566: -- Prepare PMV bind variables
567: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
568: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
569:
570: -- get all the basic binds used by POA queries
571: -- Do this before adding any of our binds, since the procedure
572: -- reinitializes the output table

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

577:
578: -- Passing OPI_AGGREGATION_LEVEL_FLAG to PMV
579: l_custom_rec.attribute_name := ':OPI_CCA_LEVEL_FLAG';
580: l_custom_rec.attribute_value := l_aggregation_level_flag;
581: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
582: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
583: x_custom_output.extend;
584: x_custom_output(x_custom_output.count) := l_custom_rec;
585:

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

578: -- Passing OPI_AGGREGATION_LEVEL_FLAG to PMV
579: l_custom_rec.attribute_name := ':OPI_CCA_LEVEL_FLAG';
580: l_custom_rec.attribute_value := l_aggregation_level_flag;
581: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
582: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
583: x_custom_output.extend;
584: x_custom_output(x_custom_output.count) := l_custom_rec;
585:
586: x_custom_sql := l_query;

Line 758: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

754: p_in_join_tables => NULL);
755:
756: -- prepare output for bind variables
757: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
758: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
759:
760: -- set the basic bind variables for the status SQL
761: poa_dbi_util_pkg.get_custom_status_binds (x_custom_output);
762:

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

762:
763: -- Passing aggregation level flag to PMV
764: l_custom_rec.attribute_name := ':OPI_CCA_LEVEL_FLAG';
765: l_custom_rec.attribute_value := l_aggregation_level_flag;
766: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
767: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
768: x_custom_output.extend;
769: x_custom_output(x_custom_output.count) := l_custom_rec;
770:

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

763: -- Passing aggregation level flag to PMV
764: l_custom_rec.attribute_name := ':OPI_CCA_LEVEL_FLAG';
765: l_custom_rec.attribute_value := l_aggregation_level_flag;
766: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
767: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
768: x_custom_output.extend;
769: x_custom_output(x_custom_output.count) := l_custom_rec;
770:
771:

Line 1097: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

1093: p_in_join_tables => NULL);
1094:
1095: -- prepare output for bind variables
1096: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
1097: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
1098:
1099: -- set the basic bind variables for the status SQL
1100: poa_dbi_util_pkg.get_custom_status_binds (x_custom_output);
1101:

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

1101:
1102: -- Passing OPI_AGGREGATION_LEVEL_FLAG to PMV
1103: l_custom_rec.attribute_name := ':OPI_CCA_LEVEL_FLAG';
1104: l_custom_rec.attribute_value := l_aggregation_level_flag;
1105: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1106: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
1107: x_custom_output.extend;
1108: x_custom_output(x_custom_output.count) := l_custom_rec;
1109:

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

1102: -- Passing OPI_AGGREGATION_LEVEL_FLAG to PMV
1103: l_custom_rec.attribute_name := ':OPI_CCA_LEVEL_FLAG';
1104: l_custom_rec.attribute_value := l_aggregation_level_flag;
1105: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1106: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
1107: x_custom_output.extend;
1108: x_custom_output(x_custom_output.count) := l_custom_rec;
1109:
1110:

Line 1447: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

1443: p_in_join_tables => NULL);
1444:
1445: -- prepare output for bind variables
1446: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
1447: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
1448:
1449: -- set the basic bind variables for the status SQL
1450: poa_dbi_util_pkg.get_custom_status_binds (x_custom_output);
1451:

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

1451:
1452: -- Passing OPI_AGGREGATION_LEVEL_FLAG to PMV
1453: l_custom_rec.attribute_name := ':OPI_CCA_LEVEL_FLAG';
1454: l_custom_rec.attribute_value := l_aggregation_level_flag;
1455: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1456: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
1457: x_custom_output.extend;
1458: x_custom_output(x_custom_output.count) := l_custom_rec;
1459:

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

1452: -- Passing OPI_AGGREGATION_LEVEL_FLAG to PMV
1453: l_custom_rec.attribute_name := ':OPI_CCA_LEVEL_FLAG';
1454: l_custom_rec.attribute_value := l_aggregation_level_flag;
1455: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1456: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
1457: x_custom_output.extend;
1458: x_custom_output(x_custom_output.count) := l_custom_rec;
1459:
1460: