APPS.OPI_DBI_WMS_RTP_PKG dependencies on BIS_QUERY_ATTRIBUTES

Line 33: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

29: Receipt to Putaway Cycle Time
30: ----------------------------------------*/
31: PROCEDURE get_tbl_sql1 (p_param IN BIS_PMV_PAGE_PARAMETER_TBL,
32: x_custom_sql OUT NOCOPY VARCHAR2,
33: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
34: IS
35: l_query VARCHAR2(32767);
36: l_view_by VARCHAR2(120);
37: l_view_by_col VARCHAR2 (120);

Line 58: l_custom_rec BIS_QUERY_ATTRIBUTES;

54:
55: l_aggregation_level_flag1 VARCHAR2(10);
56: l_aggregation_level_flag2 VARCHAR2(10);
57:
58: l_custom_rec BIS_QUERY_ATTRIBUTES;
59: l_mv_tbl poa_dbi_util_pkg.poa_dbi_mv_tbl;
60:
61:
62: BEGIN

Line 208: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

204: p_in_join_tables => NULL);
205:
206: END IF;
207: -- prepare output for bind variables
208: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
209: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
210:
211: -- set the basic bind variables for the status SQL
212: poa_dbi_util_pkg.get_custom_status_binds (x_custom_output);

Line 671: BIS_QUERY_ATTRIBUTES_TBL)

667:
668: PROCEDURE get_trd_sql (p_param IN BIS_PMV_PAGE_PARAMETER_TBL,
669: x_custom_sql OUT NOCOPY VARCHAR2,
670: x_custom_output OUT NOCOPY
671: BIS_QUERY_ATTRIBUTES_TBL)
672: IS
673: l_query VARCHAR2(32767);
674: l_view_by VARCHAR2(120);
675: l_view_by_col VARCHAR2 (120);

Line 694: l_custom_rec BIS_QUERY_ATTRIBUTES;

690:
691: l_aggregation_level_flag1 VARCHAR2(10);
692: l_aggregation_level_flag2 VARCHAR2(10);
693:
694: l_custom_rec BIS_QUERY_ATTRIBUTES;
695: l_mv_tbl poa_dbi_util_pkg.poa_dbi_mv_tbl;
696:
697: BEGIN
698:

Line 825: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

821: );
822: END IF;
823:
824: -- Prepare PMV bind variables
825: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
826: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
827:
828: -- get all the basic binds used by POA queries
829: -- Do this before adding any of our binds, since the procedure