APPS.OPI_DBI_INV_MGMT_RPT_PKG dependencies on BIS_QUERY_ATTRIBUTES_TBL

Line 51: BIS_QUERY_ATTRIBUTES_TBL)

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);

Line 135: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

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);

Line 371: BIS_QUERY_ATTRIBUTES_TBL)

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);

Line 459: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

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

Line 537: BIS_QUERY_ATTRIBUTES_TBL)

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);

Line 613: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

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);

Line 745: BIS_QUERY_ATTRIBUTES_TBL)

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);

Line 821: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

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);

Line 944: BIS_QUERY_ATTRIBUTES_TBL)

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);

Line 1056: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

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);