DBA Data[Home] [Help]

APPS.ISC_DBI_BACKORDER_DETAIL_PKG dependencies on BIS_QUERY_ATTRIBUTES

Line 7: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS

3:
4:
5: PROCEDURE Get_Sql ( p_param IN BIS_PMV_PAGE_PARAMETER_TBL,
6: x_custom_sql OUT NOCOPY VARCHAR2,
7: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
8:
9:
10: l_sql_stmt VARCHAR2(10000);
11: l_stmt VARCHAR2(10000);

Line 22: l_custom_rec BIS_QUERY_ATTRIBUTES;

18: l_inv_cat_where VARCHAR2(10000);
19: l_cust VARCHAR2(10000);
20: l_cust_where VARCHAR2(10000);
21: l_lang VARCHAR2(10);
22: l_custom_rec BIS_QUERY_ATTRIBUTES;
23:
24: BEGIN
25:
26: FOR i IN 1..p_param.COUNT

Line 88: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

84:
85: l_lang := USERENV('LANG');
86:
87: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
88: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
89:
90: l_outer_sql:= 'ISC_ATTRIBUTE_1, ISC_ATTRIBUTE_2, ISC_ATTRIBUTE_7, ISC_ATTRIBUTE_8,
91: ISC_MEASURE_1, ISC_MEASURE_2, ISC_MEASURE_3, ISC_MEASURE_4';
92: