DBA Data[Home] [Help]

APPS.ISC_DBI_BK_DETAIL_PKG dependencies on BIS_QUERY_ATTRIBUTES

Line 5: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS

1: PACKAGE BODY ISC_DBI_BK_DETAIL_PKG AS
2: /* $Header: ISCRGBJB.pls 120.1 2006/05/14 21:12:57 abhdixi noship $ */
3:
4: PROCEDURE GET_SQL(p_param IN BIS_PMV_PAGE_PARAMETER_TBL,x_custom_sql OUT NOCOPY VARCHAR2,
5: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
6:
7: l_stmt VARCHAR2(32000);
8: l_sgid VARCHAR2(32000);
9: l_sg_where VARCHAR2(32000);

Line 21: l_custom_rec BIS_QUERY_ATTRIBUTES ;

17: l_class VARCHAR2(32000);
18: l_class_where VARCHAR2(32000);
19: l_sg_sg NUMBER;
20: l_sg_res NUMBER;
21: l_custom_rec BIS_QUERY_ATTRIBUTES ;
22: l_curr VARCHAR2(10000);
23: l_curr_g VARCHAR2(15) := '''FII_GLOBAL1''';
24: l_curr_suffix VARCHAR2(120);
25:

Line 111: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

107: AND star.master_id IN (&ITEM+ENI_ITEM)';
108: END IF;
109:
110: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
111: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
112:
113: l_stmt := '
114: SELECT ISC_ATTRIBUTE_1, -- Order Number
115: ISC_ATTRIBUTE_2, -- Line Number