DBA Data[Home] [Help]

APPS.ENI_DBI_CFM_PKG dependencies on BIS_QUERY_ATTRIBUTES

Line 6: , x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL ) IS

2: /* $Header: ENICFMPB.pls 120.0 2005/05/26 19:35:02 appldev 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_measures VARCHAR2(10000);
10: l_select_stmt VARCHAR2(10000);

Line 47: l_custom_rec BIS_QUERY_ATTRIBUTES;

43: l_vb_prod BOOLEAN;
44: l_vb_org BOOLEAN;
45: l_vb_cust BOOLEAN;
46:
47: l_custom_rec BIS_QUERY_ATTRIBUTES;
48:
49: BEGIN
50:
51: l_lang := userenv('LANG');

Line 80: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

76: l_vb_cust := (l_view_by = 'CUSTOMER+FII_CUSTOMERS' );
77: l_vb_org := (l_view_by = 'ORGANIZATION+ORGANIZATION');
78:
79: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
80: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
81:
82: l_measures := '
83: , ENI_MEASURE1, ENI_MEASURE2, ENI_MEASURE3, ENI_MEASURE4, ENI_MEASURE5
84: , ENI_MEASURE6, ENI_MEASURE7, ENI_MEASURE8, ENI_MEASURE9, ENI_MEASURE10