DBA Data[Home] [Help]

APPS.ISC_DBI_WMS_PTS_PKG dependencies on BIS_QUERY_ATTRIBUTES

Line 26: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

22: Report Query for Pick Release To Ship Cycle Time
23: -------------------------------------------------*/
24: PROCEDURE get_sql (p_param IN BIS_PMV_PAGE_PARAMETER_TBL,
25: x_custom_sql OUT NOCOPY VARCHAR2,
26: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
27: IS
28: l_query VARCHAR2(32767);
29: l_view_by VARCHAR2(120);
30: l_view_by_col VARCHAR2 (120);

Line 50: l_custom_rec BIS_QUERY_ATTRIBUTES;

46:
47: l_aggregation_level_flag1 VARCHAR2(10);
48: l_aggregation_level_flag2 VARCHAR2(10);
49:
50: l_custom_rec BIS_QUERY_ATTRIBUTES;
51:
52: BEGIN
53:
54: -- initialization block

Line 193: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

189: p_in_join_tables => NULL);
190: END IF;
191:
192: -- prepare output for bind variables
193: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
194: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
195:
196: -- set the basic bind variables for the status SQL
197: poa_dbi_util_pkg.get_custom_status_binds (x_custom_output);