DBA Data[Home] [Help]

APPS.ISC_DBI_SHIP_LATE_TP_D_PKG dependencies on BIS_QUERY_ATTRIBUTES

Line 5: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS

1: PACKAGE BODY ISC_DBI_SHIP_LATE_TP_D_PKG AS
2: /* $Header: ISCRG91B.pls 120.1 2006/06/22 07:14:54 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:
8: l_stmt VARCHAR2(32000);
9: l_org VARCHAR2(32000);

Line 19: l_custom_rec BIS_QUERY_ATTRIBUTES ;

15: l_cust VARCHAR2(32000);
16: l_cust_where VARCHAR2(32000);
17: l_lang VARCHAR2(10);
18: l_late_promise_flag NUMBER :=1;
19: l_custom_rec BIS_QUERY_ATTRIBUTES ;
20:
21: BEGIN
22:
23: l_lang := userenv('LANG');

Line 91: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

87: AND f.customer_id in (&CUSTOMER+FII_CUSTOMERS)';
88: END IF;
89:
90: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
91: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
92:
93: l_stmt := 'SELECT ISC_ATTRIBUTE_2,
94: ISC_MEASURE_1,
95: org.name ISC_ATTRIBUTE_5,