DBA Data[Home] [Help]

APPS.HZ_ELOCATION_PKG dependencies on FND_INSTALLATION

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

2758: l_debug_prefix VARCHAR2(30) := '';
2759:
2760: BEGIN
2761: --enable_debug;
2762: x_dummy := fnd_installation.GET_APP_INFO('AR',x_status,x_ind,x_index_owner);
2763: OPEN c_policies(x_index_owner);
2764: FETCH c_policies BULK COLLECT INTO l_owners, l_objects, l_policies;
2765: CLOSE c_policies;
2766: -- disable currently enabled policies

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

2927: x_index_owner varchar2(50);
2928: check_tspace_exist varchar2(100); --Bug 3299301
2929: physical_tspace_name varchar2(100); --Bug 3299301
2930: BEGIN
2931: x_dummy := fnd_installation.GET_APP_INFO('AR',x_status,x_ind,x_index_owner);
2932: AD_TSPACE_UTIL.get_tablespace_name('AR','TRANSACTION_INDEXES','Y',check_tspace_exist,physical_tspace_name);
2933: l_exec_string := 'CREATE INDEX '||x_index_owner||'.'|| 'hz_locations_n15 ON '||x_index_owner||'.'||
2934: 'hz_locations(geometry) INDEXTYPE IS mdsys.spatial_index parameters(''TABLESPACE='||
2935: physical_tspace_name||''')'; --Bug 3299301