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

Line 124: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

120: p_in_join_tables => NULL);
121:
122: -- prepare output for bind variables
123: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
124: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
125:
126: -- set the basic bind variables for the status SQL
127: poa_dbi_util_pkg.get_custom_status_binds (x_custom_output);
128:

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

127: poa_dbi_util_pkg.get_custom_status_binds (x_custom_output);
128:
129: l_custom_rec.attribute_name := ':AGGREGATION_FLAG';
130: l_custom_rec.attribute_value := l_aggregation_flag;
131: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
132: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
133: x_custom_output.extend;
134: x_custom_output(x_custom_output.count) := l_custom_rec;
135:

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

128:
129: l_custom_rec.attribute_name := ':AGGREGATION_FLAG';
130: l_custom_rec.attribute_value := l_aggregation_flag;
131: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
132: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
133: x_custom_output.extend;
134: x_custom_output(x_custom_output.count) := l_custom_rec;
135:
136: x_custom_sql := l_query;

Line 352: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

348: p_in_join_tables => NULL);
349:
350: -- Prepare PMV bind variables
351: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
352: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
353:
354: -- get all the basic binds used by POA queries
355: -- Do this before adding any of our binds, since the procedure
356: -- reinitializes the output table

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

359: x_custom_output => x_custom_output);
360:
361: l_custom_rec.attribute_name := ':AGGREGATION_FLAG';
362: l_custom_rec.attribute_value := l_aggregation_flag;
363: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
364: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
365: x_custom_output.extend;
366: x_custom_output(x_custom_output.count) := l_custom_rec;
367:

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

360:
361: l_custom_rec.attribute_name := ':AGGREGATION_FLAG';
362: l_custom_rec.attribute_value := l_aggregation_flag;
363: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
364: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
365: x_custom_output.extend;
366: x_custom_output(x_custom_output.count) := l_custom_rec;
367:
368: x_custom_sql := l_query;

Line 508: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

504: p_in_join_tables => NULL);
505:
506: -- prepare output for bind variables
507: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
508: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
509:
510: -- set the basic bind variables for the status SQL
511: poa_dbi_util_pkg.get_custom_status_binds (x_custom_output);
512:

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

511: poa_dbi_util_pkg.get_custom_status_binds (x_custom_output);
512:
513: l_custom_rec.attribute_name := ':AGGREGATION_FLAG';
514: l_custom_rec.attribute_value := l_aggregation_flag;
515: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
516: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
517: x_custom_output.extend;
518: x_custom_output(x_custom_output.count) := l_custom_rec;
519:

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

512:
513: l_custom_rec.attribute_name := ':AGGREGATION_FLAG';
514: l_custom_rec.attribute_value := l_aggregation_flag;
515: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
516: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
517: x_custom_output.extend;
518: x_custom_output(x_custom_output.count) := l_custom_rec;
519:
520: x_custom_sql := l_query;

Line 710: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

706: p_in_join_tables => NULL);
707:
708: -- Prepare PMV bind variables
709: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
710: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
711:
712: -- get all the basic binds used by POA queries
713: -- Do this before adding any of our binds, since the procedure
714: -- reinitializes the output table

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

718:
719:
720: l_custom_rec.attribute_name := ':AGGREGATION_FLAG';
721: l_custom_rec.attribute_value := l_aggregation_flag;
722: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
723: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
724: x_custom_output.extend;
725: x_custom_output(x_custom_output.count) := l_custom_rec;
726:

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

719:
720: l_custom_rec.attribute_name := ':AGGREGATION_FLAG';
721: l_custom_rec.attribute_value := l_aggregation_flag;
722: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
723: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
724: x_custom_output.extend;
725: x_custom_output(x_custom_output.count) := l_custom_rec;
726:
727: x_custom_sql := l_query;

Line 861: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

857: p_in_join_tables => NULL);
858:
859: -- prepare output for bind variables
860: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
861: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
862:
863: -- set the basic bind variables for the status SQL
864: poa_dbi_util_pkg.get_custom_status_binds (x_custom_output);
865:

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

864: poa_dbi_util_pkg.get_custom_status_binds (x_custom_output);
865:
866: l_custom_rec.attribute_name := ':AGGREGATION_FLAG';
867: l_custom_rec.attribute_value := l_aggregation_flag;
868: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
869: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
870: x_custom_output.extend;
871: x_custom_output(x_custom_output.count) := l_custom_rec;
872:

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

865:
866: l_custom_rec.attribute_name := ':AGGREGATION_FLAG';
867: l_custom_rec.attribute_value := l_aggregation_flag;
868: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
869: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
870: x_custom_output.extend;
871: x_custom_output(x_custom_output.count) := l_custom_rec;
872:
873: x_custom_sql := l_query;

Line 1062: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

1058: p_in_join_tables => NULL);
1059:
1060: -- Prepare PMV bind variables
1061: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
1062: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
1063:
1064: -- get all the basic binds used by POA queries
1065: -- Do this before adding any of our binds, since the procedure
1066: -- reinitializes the output table

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

1069: x_custom_output => x_custom_output);
1070:
1071: l_custom_rec.attribute_name := ':AGGREGATION_FLAG';
1072: l_custom_rec.attribute_value := l_aggregation_flag;
1073: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1074: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
1075: x_custom_output.extend;
1076: x_custom_output(x_custom_output.count) := l_custom_rec;
1077:

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

1070:
1071: l_custom_rec.attribute_name := ':AGGREGATION_FLAG';
1072: l_custom_rec.attribute_value := l_aggregation_flag;
1073: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1074: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
1075: x_custom_output.extend;
1076: x_custom_output(x_custom_output.count) := l_custom_rec;
1077:
1078: x_custom_sql := l_query;

Line 1221: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

1217: p_in_join_tables => NULL);
1218:
1219: -- prepare output for bind variables
1220: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
1221: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
1222:
1223: -- set the basic bind variables for the status SQL
1224: poa_dbi_util_pkg.get_custom_status_binds (x_custom_output);
1225:

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

1224: poa_dbi_util_pkg.get_custom_status_binds (x_custom_output);
1225:
1226: l_custom_rec.attribute_name := ':AGGREGATION_FLAG';
1227: l_custom_rec.attribute_value := l_aggregation_flag;
1228: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1229: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
1230: x_custom_output.extend;
1231: x_custom_output(x_custom_output.count) := l_custom_rec;
1232:

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

1225:
1226: l_custom_rec.attribute_name := ':AGGREGATION_FLAG';
1227: l_custom_rec.attribute_value := l_aggregation_flag;
1228: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1229: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
1230: x_custom_output.extend;
1231: x_custom_output(x_custom_output.count) := l_custom_rec;
1232:
1233: x_custom_sql := l_query;

Line 1427: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

1423: p_in_join_tables => NULL);
1424:
1425: -- Prepare PMV bind variables
1426: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
1427: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
1428:
1429: -- get all the basic binds used by POA queries
1430: -- Do this before adding any of our binds, since the procedure
1431: -- reinitializes the output table

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

1434: x_custom_output => x_custom_output);
1435:
1436: l_custom_rec.attribute_name := ':AGGREGATION_FLAG';
1437: l_custom_rec.attribute_value := l_aggregation_flag;
1438: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1439: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
1440: x_custom_output.extend;
1441: x_custom_output(x_custom_output.count) := l_custom_rec;
1442:

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

1435:
1436: l_custom_rec.attribute_name := ':AGGREGATION_FLAG';
1437: l_custom_rec.attribute_value := l_aggregation_flag;
1438: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1439: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
1440: x_custom_output.extend;
1441: x_custom_output(x_custom_output.count) := l_custom_rec;
1442:
1443: x_custom_sql := l_query;