[Home] [Help]
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;
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);
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;
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
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;
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);
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;
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
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;
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);
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;
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
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;
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);
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;
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
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;