DBA Data[Home] [Help]

APPS.ISC_DBI_BACKORDER_SUM_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: l_formula_sql VARCHAR2(10000);
10: l_inner_sql VARCHAR2(10000);
11: l_outer_sql VARCHAR2(10000);

Line 31: l_custom_rec BIS_QUERY_ATTRIBUTES;

27: l_effective_start_date DATE;
28: l_cursor_id NUMBER;
29: l_dummy NUMBER;
30: l_lang VARCHAR2(10);
31: l_custom_rec BIS_QUERY_ATTRIBUTES;
32:
33: BEGIN
34:
35: FOR i IN 1..p_param.COUNT

Line 162: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

158:
159: l_lang := USERENV('LANG');
160:
161: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
162: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
163:
164: -- SQL statement generation: SELECT
165:
166: IF NOT(l_snapshot_taken)