DBA Data[Home] [Help]

APPS.ISC_DBI_BOOK_DETAIL_PKG dependencies on BIS_QUERY_ATTRIBUTES

Line 6: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS

2: /* $Header: ISCRGB9B.pls 120.1 2005/08/17 18:30:34 hprathur noship $ */
3:
4: PROCEDURE Get_Sql ( p_param IN BIS_PMV_PAGE_PARAMETER_TBL,
5: x_custom_sql OUT NOCOPY VARCHAR2,
6: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
7:
8: l_stmt VARCHAR2(10000);
9: l_org VARCHAR2(10000);
10: l_org_where VARCHAR2(10000);

Line 24: l_custom_rec BIS_QUERY_ATTRIBUTES;

20: l_curr_g1 VARCHAR2(15) := '''FII_GLOBAL2''';
21: l_curr_suffix VARCHAR2(120);
22: l_lang VARCHAR2(10);
23:
24: l_custom_rec BIS_QUERY_ATTRIBUTES;
25:
26: BEGIN
27:
28: l_lang := userenv('LANG');

Line 121: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

117:
118:
119:
120: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
121: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
122:
123: l_stmt := '
124: SELECT ISC_ATTRIBUTE_1, -- Order Number
125: ISC_ATTRIBUTE_2, -- Line Number