DBA Data[Home] [Help]

APPS.HZ_ELOCATION_PKG dependencies on FND_INSTALLATION

Line 1839: x_dummy := fnd_installation.GET_APP_INFO('AR',x_status,x_ind,x_index_owner);

1835: l_debug_prefix VARCHAR2(30) := '';
1836:
1837: BEGIN
1838: --enable_debug;
1839: x_dummy := fnd_installation.GET_APP_INFO('AR',x_status,x_ind,x_index_owner);
1840: OPEN c_policies(x_index_owner);
1841: FETCH c_policies BULK COLLECT INTO l_owners, l_objects, l_policies;
1842: CLOSE c_policies;
1843: -- disable currently enabled policies

Line 2003: x_dummy := fnd_installation.GET_APP_INFO('AR',x_status,x_ind,x_index_owner);

1999: x_index_owner varchar2(50);
2000: check_tspace_exist varchar2(100); --Bug 3299301
2001: physical_tspace_name varchar2(100); --Bug 3299301
2002: BEGIN
2003: x_dummy := fnd_installation.GET_APP_INFO('AR',x_status,x_ind,x_index_owner);
2004: AD_TSPACE_UTIL.get_tablespace_name('AR','TRANSACTION_INDEXES','Y',check_tspace_exist,physical_tspace_name);
2005: l_exec_string := 'CREATE INDEX '||x_index_owner||'.'|| 'hz_locations_n15 ON '||x_index_owner||'.'||
2006: 'hz_locations(geometry) INDEXTYPE IS mdsys.spatial_index parameters(''TABLESPACE='||
2007: physical_tspace_name||''')'; --Bug 3299301