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_QUERY_ATTRIBUTES

Line 43: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL

39:
40: PROCEDURE get_ro_mrg_tbl_sql(
41: p_param IN BIS_PMV_PAGE_PARAMETER_TBL,
42: x_custom_sql OUT NOCOPY VARCHAR2,
43: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL
44: ) IS
45:
46: l_query ISC_DEPOT_RPT_UTIL_PKG.g_query_typ%type;
47: l_view_by ISC_DEPOT_RPT_UTIL_PKG.g_view_by_typ%type;

Line 58: l_custom_rec BIS_QUERY_ATTRIBUTES;

54: l_where_clause ISC_DEPOT_RPT_UTIL_PKG.g_where_clause_typ%type;
55: l_mv ISC_DEPOT_RPT_UTIL_PKG.g_mv_typ%type;
56: l_mv_set VARCHAR2(50);
57: l_aggregation_flag NUMBER;
58: l_custom_rec BIS_QUERY_ATTRIBUTES;
59: l_mv_type VARCHAR2(10);
60: l_err_stage VARCHAR2(500);
61: l_debug_mode VARCHAR2(1);
62: l_module_name ISC_DEPOT_RPT_UTIL_PKG.g_module_name_typ%type;

Line 123: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

119: p_generate_viewby => 'Y',
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);

Line 278: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

274: Repair Order Margin Trend
275: ----------------------------------*/
276: PROCEDURE get_ro_mrg_trd_sql (p_param IN BIS_PMV_PAGE_PARAMETER_TBL,
277: x_custom_sql OUT NOCOPY VARCHAR2,
278: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
279: IS
280: l_query ISC_DEPOT_RPT_UTIL_PKG.g_query_typ%type;
281: l_view_by ISC_DEPOT_RPT_UTIL_PKG.g_view_by_typ%type;
282: l_view_by_col ISC_DEPOT_RPT_UTIL_PKG.g_view_by_col_typ%type;

Line 292: l_custom_rec BIS_QUERY_ATTRIBUTES;

288: l_where_clause ISC_DEPOT_RPT_UTIL_PKG.g_where_clause_typ%type;
289: l_mv ISC_DEPOT_RPT_UTIL_PKG.g_mv_typ%type;
290: l_mv_set VARCHAR2(50);
291: l_aggregation_flag NUMBER;
292: l_custom_rec BIS_QUERY_ATTRIBUTES;
293: l_mv_type VARCHAR2(10);
294: l_err_stage VARCHAR2(500);
295: l_debug_mode VARCHAR2(1);
296: l_module_name ISC_DEPOT_RPT_UTIL_PKG.g_module_name_typ%type;

Line 351: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

347: p_use_grpid => 'N',
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

Line 425: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL

421:
422: PROCEDURE get_chg_summ_tbl_sql(
423: p_param IN BIS_PMV_PAGE_PARAMETER_TBL,
424: x_custom_sql OUT NOCOPY VARCHAR2,
425: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL
426: ) IS
427:
428: l_query ISC_DEPOT_RPT_UTIL_PKG.g_query_typ%type;
429: l_view_by ISC_DEPOT_RPT_UTIL_PKG.g_view_by_typ%type;

Line 440: l_custom_rec BIS_QUERY_ATTRIBUTES;

436: l_where_clause ISC_DEPOT_RPT_UTIL_PKG.g_where_clause_typ%type;
437: l_mv ISC_DEPOT_RPT_UTIL_PKG.g_mv_typ%type;
438: l_mv_set VARCHAR2(50);
439: l_aggregation_flag NUMBER;
440: l_custom_rec BIS_QUERY_ATTRIBUTES;
441: l_mv_type VARCHAR2(10);
442: l_err_stage VARCHAR2(500);
443: l_debug_mode VARCHAR2(1);
444: l_module_name ISC_DEPOT_RPT_UTIL_PKG.g_module_name_typ%type;

Line 507: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

503: p_generate_viewby => 'Y',
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);

Line 634: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

630: Charges Summary Trend
631: ----------------------------------*/
632: PROCEDURE get_chg_summ_trd_sql (p_param IN BIS_PMV_PAGE_PARAMETER_TBL,
633: x_custom_sql OUT NOCOPY VARCHAR2,
634: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
635: IS
636: l_query ISC_DEPOT_RPT_UTIL_PKG.g_query_typ%type;
637: l_view_by ISC_DEPOT_RPT_UTIL_PKG.g_view_by_typ%type;
638: l_view_by_col ISC_DEPOT_RPT_UTIL_PKG.g_view_by_col_typ%type;

Line 648: l_custom_rec BIS_QUERY_ATTRIBUTES;

644: l_where_clause ISC_DEPOT_RPT_UTIL_PKG.g_where_clause_typ%type;
645: l_mv ISC_DEPOT_RPT_UTIL_PKG.g_mv_typ%type;
646: l_mv_set VARCHAR2(50);
647: l_aggregation_flag NUMBER;
648: l_custom_rec BIS_QUERY_ATTRIBUTES;
649: l_mv_type VARCHAR2(10);
650: l_err_stage VARCHAR2(500);
651: l_debug_mode VARCHAR2(1);
652: l_module_name ISC_DEPOT_RPT_UTIL_PKG.g_module_name_typ%type;

Line 709: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

705: p_use_grpid => 'N',
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

Line 778: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL

774:
775: PROCEDURE get_cst_summ_tbl_sql(
776: p_param IN BIS_PMV_PAGE_PARAMETER_TBL,
777: x_custom_sql OUT NOCOPY VARCHAR2,
778: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL
779: ) IS
780:
781: l_query ISC_DEPOT_RPT_UTIL_PKG.g_query_typ%type;
782: l_view_by ISC_DEPOT_RPT_UTIL_PKG.g_view_by_typ%type;

Line 793: l_custom_rec BIS_QUERY_ATTRIBUTES;

789: l_where_clause ISC_DEPOT_RPT_UTIL_PKG.g_where_clause_typ%type;
790: l_mv ISC_DEPOT_RPT_UTIL_PKG.g_mv_typ%type;
791: l_mv_set VARCHAR2(50);
792: l_aggregation_flag NUMBER;
793: l_custom_rec BIS_QUERY_ATTRIBUTES;
794: l_mv_type VARCHAR2(10);
795: l_err_stage VARCHAR2(500);
796: l_debug_mode VARCHAR2(1);
797: l_module_name ISC_DEPOT_RPT_UTIL_PKG.g_module_name_typ%type;

Line 860: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

856: p_generate_viewby => 'Y',
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);

Line 986: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

982: Cost Summary Trend
983: ----------------------------------*/
984: PROCEDURE get_cst_summ_trd_sql (p_param IN BIS_PMV_PAGE_PARAMETER_TBL,
985: x_custom_sql OUT NOCOPY VARCHAR2,
986: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
987: IS
988: l_query ISC_DEPOT_RPT_UTIL_PKG.g_query_typ%type;
989: l_view_by ISC_DEPOT_RPT_UTIL_PKG.g_view_by_typ%type;
990: l_view_by_col ISC_DEPOT_RPT_UTIL_PKG.g_view_by_col_typ%type;

Line 1000: l_custom_rec BIS_QUERY_ATTRIBUTES;

996: l_where_clause ISC_DEPOT_RPT_UTIL_PKG.g_where_clause_typ%type;
997: l_mv ISC_DEPOT_RPT_UTIL_PKG.g_mv_typ%type;
998: l_mv_set VARCHAR2(50);
999: l_aggregation_flag NUMBER;
1000: l_custom_rec BIS_QUERY_ATTRIBUTES;
1001: l_mv_type VARCHAR2(10);
1002: l_err_stage VARCHAR2(500);
1003: l_debug_mode VARCHAR2(1);
1004: l_module_name ISC_DEPOT_RPT_UTIL_PKG.g_module_name_typ%type;

Line 1061: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

1057: p_use_grpid => 'N',
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

Line 1129: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL

1125:
1126: PROCEDURE get_mrg_summ_tbl_sql(
1127: p_param IN BIS_PMV_PAGE_PARAMETER_TBL,
1128: x_custom_sql OUT NOCOPY VARCHAR2,
1129: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL
1130: ) IS
1131:
1132: l_query ISC_DEPOT_RPT_UTIL_PKG.g_query_typ%type;
1133: l_view_by ISC_DEPOT_RPT_UTIL_PKG.g_view_by_typ%type;

Line 1144: l_custom_rec BIS_QUERY_ATTRIBUTES;

1140: l_where_clause ISC_DEPOT_RPT_UTIL_PKG.g_where_clause_typ%type;
1141: l_mv ISC_DEPOT_RPT_UTIL_PKG.g_mv_typ%type;
1142: l_mv_set VARCHAR2(50);
1143: l_aggregation_flag NUMBER;
1144: l_custom_rec BIS_QUERY_ATTRIBUTES;
1145: l_mv_type VARCHAR2(10);
1146: l_err_stage VARCHAR2(500);
1147: l_debug_mode VARCHAR2(1);
1148: l_module_name ISC_DEPOT_RPT_UTIL_PKG.g_module_name_typ%type;

Line 1220: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

1216: p_generate_viewby => 'Y',
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);

Line 1347: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

1343: Margin Summary Trend
1344: ----------------------------------*/
1345: PROCEDURE get_mrg_summ_trd_sql (p_param IN BIS_PMV_PAGE_PARAMETER_TBL,
1346: x_custom_sql OUT NOCOPY VARCHAR2,
1347: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
1348: IS
1349: l_query ISC_DEPOT_RPT_UTIL_PKG.g_query_typ%type;
1350: l_view_by ISC_DEPOT_RPT_UTIL_PKG.g_view_by_typ%type;
1351: l_view_by_col ISC_DEPOT_RPT_UTIL_PKG.g_view_by_col_typ%type;

Line 1361: l_custom_rec BIS_QUERY_ATTRIBUTES;

1357: l_where_clause ISC_DEPOT_RPT_UTIL_PKG.g_where_clause_typ%type;
1358: l_mv ISC_DEPOT_RPT_UTIL_PKG.g_mv_typ%type;
1359: l_mv_set VARCHAR2(50);
1360: l_aggregation_flag NUMBER;
1361: l_custom_rec BIS_QUERY_ATTRIBUTES;
1362: l_mv_type VARCHAR2(10);
1363: l_err_stage VARCHAR2(500);
1364: l_debug_mode VARCHAR2(1);
1365: l_module_name ISC_DEPOT_RPT_UTIL_PKG.g_module_name_typ%type;

Line 1426: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

1422: p_use_grpid => 'N',
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

Line 1494: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL

1490:
1491: PROCEDURE get_mrg_dtl_tbl_sql(
1492: p_param IN BIS_PMV_PAGE_PARAMETER_TBL,
1493: x_custom_sql OUT NOCOPY VARCHAR2,
1494: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL
1495: ) IS
1496:
1497: l_query ISC_DEPOT_RPT_UTIL_PKG.g_query_typ%type;
1498: l_view_by ISC_DEPOT_RPT_UTIL_PKG.g_view_by_typ%type;

Line 1509: l_custom_rec BIS_QUERY_ATTRIBUTES;

1505: l_where_clause ISC_DEPOT_RPT_UTIL_PKG.g_where_clause_typ%type;
1506: l_mv ISC_DEPOT_RPT_UTIL_PKG.g_mv_typ%type;
1507: l_mv_set VARCHAR2(50);
1508: l_aggregation_flag NUMBER;
1509: l_custom_rec BIS_QUERY_ATTRIBUTES;
1510: l_mv_type VARCHAR2(10);
1511: l_err_stage VARCHAR2(500);
1512: l_debug_mode VARCHAR2(1);
1513: l_module_name ISC_DEPOT_RPT_UTIL_PKG.g_module_name_typ%type;