APPS.OPI_DBI_WMS_STOR_UTZ_RPT_PKG dependencies on BIS_QUERY_ATTRIBUTES

Line 285: BIS_QUERY_ATTRIBUTES_TBL)

281: */
282: PROCEDURE get_stor_tbl_sql (p_param IN BIS_PMV_PAGE_PARAMETER_TBL,
283: x_custom_sql OUT NOCOPY VARCHAR2,
284: x_custom_output OUT NOCOPY
285: BIS_QUERY_ATTRIBUTES_TBL)
286: IS
287:
288: l_query VARCHAR2 (32767);
289: l_custom_sql VARCHAR2 (32767);

Line 304: l_custom_rec BIS_QUERY_ATTRIBUTES;

300: l_mv VARCHAR2 (30);
301:
302: l_aggr_level_flag VARCHAR2(1);
303:
304: l_custom_rec BIS_QUERY_ATTRIBUTES;
305:
306: -- Of no use, but needed for process parameters.
307: l_cur_suffix VARCHAR2 (5);
308:

Line 315: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL ();

311: BEGIN
312:
313: -- initialization block
314: x_custom_sql := NULL;
315: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL ();
316: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
317: l_query := NULL;
318: l_custom_sql := NULL;
319: l_view_by := NULL;

Line 500: BIS_QUERY_ATTRIBUTES_TBL)

496: */
497: PROCEDURE get_stor_trd_sql (p_param IN BIS_PMV_PAGE_PARAMETER_TBL,
498: x_custom_sql OUT NOCOPY VARCHAR2,
499: x_custom_output OUT NOCOPY
500: BIS_QUERY_ATTRIBUTES_TBL)
501: IS
502:
503: l_query VARCHAR2 (32767);
504: l_custom_sql VARCHAR2 (32767);

Line 519: l_custom_rec BIS_QUERY_ATTRIBUTES;

515: l_mv VARCHAR2 (30);
516:
517: l_aggr_level_flag VARCHAR2(1);
518:
519: l_custom_rec BIS_QUERY_ATTRIBUTES;
520:
521: -- Of no use, but needed for process parameters.
522: l_cur_suffix VARCHAR2 (5);
523:

Line 528: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL ();

524: BEGIN
525:
526: -- initialization block
527: x_custom_sql := NULL;
528: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL ();
529: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
530: l_query := NULL;
531: l_custom_sql := NULL;
532: l_view_by := NULL;

Line 938: BIS_QUERY_ATTRIBUTES_TBL)

934: */
935: PROCEDURE get_curr_utz_sql (p_param IN BIS_PMV_PAGE_PARAMETER_TBL,
936: x_custom_sql OUT NOCOPY VARCHAR2,
937: x_custom_output OUT NOCOPY
938: BIS_QUERY_ATTRIBUTES_TBL)
939: IS
940:
941: l_query VARCHAR2 (32767);
942: l_custom_sql VARCHAR2 (32767);

Line 964: l_custom_rec BIS_QUERY_ATTRIBUTES;

960: -- Common to item and sub side of the queries
961: l_view_by VARCHAR2(120);
962: l_view_by_col VARCHAR2 (120);
963: l_xtd VARCHAR2(10);
964: l_custom_rec BIS_QUERY_ATTRIBUTES;
965: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;
966: l_mv_tbl poa_dbi_util_pkg.POA_DBI_MV_TBL;
967: l_sel_clause VARCHAR2 (32767);
968: l_filter_clause VARCHAR2 (20000);

Line 997: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL ();

993: l_sub_item_outer_join := NULL;
994:
995: -- Common
996: x_custom_sql := NULL;
997: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL ();
998: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
999: l_view_by := NULL;
1000: l_view_by_col := NULL;
1001: l_xtd := NULL;