[Home] [Help]
27: -- Description: Generate query for Picks and Exception Analysis Report
28: -- -------------------------------------------------------------------
29: PROCEDURE GET_PICK_EX_SQL(p_param IN BIS_PMV_PAGE_PARAMETER_TBL,
30: x_custom_sql OUT NOCOPY VARCHAR2,
31: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
32:
33: IS
34:
35: l_query VARCHAR2(15000);
117: p_generate_viewby => 'Y',
118: p_in_join_tables => NULL);
119:
120: -- prepare output for bind variables
121: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
122: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
123:
124: -- set the basic bind variables for the status SQL
125: poa_dbi_util_pkg.get_custom_status_binds (x_custom_output);
349: -- Description: Generate query for Picks Exception By Reason Report
350: -- -------------------------------------------------------------------
351: PROCEDURE GET_EX_REASON_SQL(p_param IN BIS_PMV_PAGE_PARAMETER_TBL,
352: x_custom_sql OUT NOCOPY VARCHAR2,
353: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
354:
355: IS
356: l_query VARCHAR2(15000);
357: l_view_by VARCHAR2(120);
420: p_generate_viewby => 'Y',
421: p_in_join_tables => NULL);
422:
423: -- prepare output for bind variables
424: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
425: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
426:
427: -- set the basic bind variables for the status SQL
428: poa_dbi_util_pkg.get_custom_status_binds (x_custom_output);
521: -- -------------------------------------------------------------
522: PROCEDURE get_pick_trd_sql (p_param IN BIS_PMV_PAGE_PARAMETER_TBL,
523: x_custom_sql OUT NOCOPY VARCHAR2,
524: x_custom_output OUT NOCOPY
525: BIS_QUERY_ATTRIBUTES_TBL)
526: IS
527: l_query VARCHAR2(32767);
528: l_view_by VARCHAR2(120);
529: l_view_by_col VARCHAR2 (120);
604: p_fact_hint => poa_dbi_sutil_pkg.get_fact_hint(l_mv)
605: );
606:
607: -- prepare output for bind variables
608: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
609: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
610:
611: -- set the basic bind variables for the trend SQL
612: poa_dbi_util_pkg.get_custom_trend_binds (p_xtd => l_xtd,
695: -- Description: Generate query for Picks and Exception Analysis Report
696: -- -------------------------------------------------------------------
697: PROCEDURE GET_OPP_SQL(p_param IN BIS_PMV_PAGE_PARAMETER_TBL,
698: x_custom_sql OUT NOCOPY VARCHAR2,
699: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
700:
701: IS
702: l_query VARCHAR2(15000);
703: l_view_by VARCHAR2(120);
792: p_generate_viewby => 'Y',
793: p_in_join_tables => NULL);
794:
795: -- prepare output for bind variables
796: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
797: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
798:
799: -- set the basic bind variables for the status SQL
800: poa_dbi_util_pkg.get_custom_status_binds (x_custom_output);
974: -- Description: Generate query for Op Plan Exception by Reason Report
975: -- -------------------------------------------------------------------
976: PROCEDURE GET_OP_EX_REASON_SQL(p_param IN BIS_PMV_PAGE_PARAMETER_TBL,
977: x_custom_sql OUT NOCOPY VARCHAR2,
978: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
979:
980: IS
981: l_query VARCHAR2(15000);
982: l_view_by VARCHAR2(120);
1046: p_filter_where => l_filter_where,
1047: p_generate_viewby => 'Y',
1048: p_in_join_tables => NULL);
1049: -- prepare output for bind variables
1050: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
1051: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
1052:
1053: -- set the basic bind variables for the status SQL
1054: poa_dbi_util_pkg.get_custom_status_binds (x_custom_output);