[Home] [Help]
47: */
48: PROCEDURE inv_val_status_sql (p_param IN BIS_PMV_PAGE_PARAMETER_TBL,
49: x_custom_sql OUT NOCOPY VARCHAR2,
50: x_custom_output OUT NOCOPY
51: BIS_QUERY_ATTRIBUTES_TBL)
52: IS
53: l_query VARCHAR2(15000);
54: l_view_by VARCHAR2(120);
55: l_view_by_col VARCHAR2 (120);
65: l_mv VARCHAR2 (30);
66:
67: l_aggregation_level_flag varchar2(1);
68:
69: l_custom_rec BIS_QUERY_ATTRIBUTES;
70: l_filter_where VARCHAR2(120);
71:
72: BEGIN
73:
131: p_use_grpid => 'N',
132: p_filter_where => l_filter_where);
133:
134: -- prepare output for bind variables
135: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
136: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
137:
138: -- set the basic bind variables for the status SQL
139: poa_dbi_util_pkg.get_custom_status_binds (x_custom_output);
367: */
368: PROCEDURE inv_val_trend_sql (p_param IN BIS_PMV_PAGE_PARAMETER_TBL,
369: x_custom_sql OUT NOCOPY VARCHAR2,
370: x_custom_output OUT NOCOPY
371: BIS_QUERY_ATTRIBUTES_TBL)
372: IS
373: l_query VARCHAR2(15000);
374: l_view_by VARCHAR2(120);
375: l_view_by_col VARCHAR2 (120);
381: l_where_clause VARCHAR2 (4000);
382:
383: l_aggregation_level_flag VARCHAR2(1);
384:
385: l_custom_rec BIS_QUERY_ATTRIBUTES;
386:
387: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;
388: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;
389:
455:
456:
457:
458: -- Prepare PMV bind variables
459: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
460: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
461:
462: -- get all the basic binds used by POA queries
463: -- Do this before adding any of our binds, since the procedure
533:
534: PROCEDURE onhand_sql (p_param IN BIS_PMV_PAGE_PARAMETER_TBL,
535: x_custom_sql OUT NOCOPY VARCHAR2,
536: x_custom_output OUT NOCOPY
537: BIS_QUERY_ATTRIBUTES_TBL)
538: IS
539: l_query VARCHAR2(15000);
540: l_view_by VARCHAR2(120);
541: l_view_by_col VARCHAR2 (120);
550: l_where_clause VARCHAR2 (2000);
551: l_mv VARCHAR2 (30);
552:
553: l_aggregation_level_flag varchar2(1);
554: l_custom_rec BIS_QUERY_ATTRIBUTES;
555: l_filter_where VARCHAR2(120);
556:
557: BEGIN
558:
609: p_use_grpid => 'N',
610: p_filter_where => l_filter_where);
611:
612: -- prepare output for bind variables
613: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
614: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
615:
616: -- set the basic bind variables for the status SQL
617: poa_dbi_util_pkg.get_custom_status_binds (x_custom_output);
741:
742: PROCEDURE intransit_sql (p_param IN BIS_PMV_PAGE_PARAMETER_TBL,
743: x_custom_sql OUT NOCOPY VARCHAR2,
744: x_custom_output OUT NOCOPY
745: BIS_QUERY_ATTRIBUTES_TBL)
746: IS
747: l_query VARCHAR2(15000);
748: l_view_by VARCHAR2(120);
749: l_view_by_col VARCHAR2 (120);
758: l_where_clause VARCHAR2 (2000);
759: l_mv VARCHAR2 (30);
760:
761: l_aggregation_level_flag varchar2(1);
762: l_custom_rec BIS_QUERY_ATTRIBUTES;
763: l_filter_where VARCHAR2(120);
764:
765: BEGIN
766:
817: p_use_grpid => 'N',
818: p_filter_where => l_filter_where);
819:
820: -- prepare output for bind variables
821: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
822: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
823:
824: -- set the basic bind variables for the status SQL
825: poa_dbi_util_pkg.get_custom_status_binds (x_custom_output);
940: */
941: PROCEDURE inv_val_type_sql (p_param IN BIS_PMV_PAGE_PARAMETER_TBL,
942: x_custom_sql OUT NOCOPY VARCHAR2,
943: x_custom_output OUT NOCOPY
944: BIS_QUERY_ATTRIBUTES_TBL)
945: IS
946: -- {
947: l_query VARCHAR2(15000);
948: l_view_by VARCHAR2(120);
961: l_mv VARCHAR2 (30);
962:
963: l_aggregation_level_flag varchar2(1);
964:
965: l_custom_rec BIS_QUERY_ATTRIBUTES;
966: l_filter_where VARCHAR2(120);
967: -- }
968: BEGIN
969: -- {
1052: &ORDER_BY_CLAUSE nulls last';
1053:
1054:
1055: -- prepare output for bind variables
1056: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
1057: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
1058:
1059: -- set the basic bind variables for the status SQL
1060: poa_dbi_util_pkg.get_custom_status_binds (x_custom_output);