eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGI_SLS_UPG_PKG dependencies on IGI_SLS_SECURE_TABLES

Line 32: FROM igi_sls_secure_tables a

28:
29: /*** Note the where clause.. we are taking care of tables that are secured and allocated to
30: security groups, and not tables that are seucred and have no allocations.. ***/
31: INSERT INTO igi_sls_upg_itf(SELECT a.table_name, a.owner , a.sls_table_name, NULL,NULL,NULL,get_sls_grps(a.table_name),NULL,NULL
32: FROM igi_sls_secure_tables a
33: WHERE a.table_name IN( 'PO_VENDORS','PO_VENDOR_CONTACTS', 'PO_VENDOR_SITES_ALL')
34: AND A.table_name NOT IN (SELECT old_table_name FROM igi_sls_upg_itf)
35: AND a.table_name IN (SELECT sls_allocation FROM igi_sls_allocations));
36:

Line 132: /* This procedure sets data in the table IGI_SLS_SECURE_TABLES*/

128: END populate_temp_table_new;
129:
130:
131: /******** This proc. popluates the remaining entries of the interface table ****/
132: /*********** This procedure sets data in the table IGI_SLS_SECURE_TABLES***********/
133:
134: PROCEDURE set_sls_tables_data(param1 IN list_of_old_tables,
135: param2 IN list_of_new_tables)
136: IS

Line 150: /* To check if this entry is already there in the igi_sls_secure_tables table

146: LOOP
147: l_table_name:=param2(indx);
148: l_old_table_name := param1(indx);
149:
150: /* To check if this entry is already there in the igi_sls_secure_tables table
151: So as to prevent duplicate entry*/
152: SELECT COUNT(*) INTO l_count FROM igi_sls_secure_tables WHERE table_name =l_table_name ;
153: write_to_log (l_excep_level, 'set_sls_tables_data','Count: '||l_count );
154:

Line 152: SELECT COUNT(*) INTO l_count FROM igi_sls_secure_tables WHERE table_name =l_table_name ;

148: l_old_table_name := param1(indx);
149:
150: /* To check if this entry is already there in the igi_sls_secure_tables table
151: So as to prevent duplicate entry*/
152: SELECT COUNT(*) INTO l_count FROM igi_sls_secure_tables WHERE table_name =l_table_name ;
153: write_to_log (l_excep_level, 'set_sls_tables_data','Count: '||l_count );
154:
155:
156: IF l_count=0 THEN

Line 170: SELECT OPTIMISE_SQL INTO l_optimise_sql FROM igi_sls_secure_tables WHERE table_name =l_old_table_name;

166:
167: write_to_log (l_excep_level, 'set_sls_tables_data','l_sls_table_name: '||l_sls_table_name );
168:
169:
170: SELECT OPTIMISE_SQL INTO l_optimise_sql FROM igi_sls_secure_tables WHERE table_name =l_old_table_name;
171: write_to_log (l_excep_level, 'set_sls_tables_data','l_optimise_sql: '||l_optimise_sql );
172:
173:
174: write_to_log (l_excep_level, 'set_sls_tables_data','Before insert' );

Line 177: INSERT INTO igi_sls_secure_tables(owner, table_name, sls_table_name, update_allowed, creation_date, created_by,

173:
174: write_to_log (l_excep_level, 'set_sls_tables_data','Before insert' );
175:
176: /* insert statement... core to this procedure..*/
177: INSERT INTO igi_sls_secure_tables(owner, table_name, sls_table_name, update_allowed, creation_date, created_by,
178: last_update_login,last_update_date, last_updated_by, optimise_sql) VALUES(l_owner, l_table_name,l_sls_table_name, 'N', sysdate,1,1,sysdate,1, l_optimise_sql );
179:
180: write_to_log (l_excep_level, 'set_sls_tables_data','After Insert..' ||SQL%ROWCOUNT ||'row inserted');
181:

Line 190: /* This procedure sets data in the table IGI_SLS_SECURE_TABLES*/

186:
187:
188: END set_sls_tables_data;
189:
190: /*********** This procedure sets data in the table IGI_SLS_SECURE_TABLES***********/
191:
192:
193:
194:

Line 246: update igi_sls_secure_tables set table_name='PO_VENDORS_OBS'

242: /**** Make a few changes needed in R12*************/
243: PROCEDURE disable_old_tables IS
244: BEGIN
245:
246: update igi_sls_secure_tables set table_name='PO_VENDORS_OBS'
247: where table_name='PO_VENDORS';
248: update igi_sls_secure_tables set table_name='PO_VENDOR_CONTACTS_OBS'
249: where table_name='PO_VENDOR_CONTACTS';
250: update igi_sls_secure_tables set table_name='PO_VENDOR_SITES_OBS'

Line 248: update igi_sls_secure_tables set table_name='PO_VENDOR_CONTACTS_OBS'

244: BEGIN
245:
246: update igi_sls_secure_tables set table_name='PO_VENDORS_OBS'
247: where table_name='PO_VENDORS';
248: update igi_sls_secure_tables set table_name='PO_VENDOR_CONTACTS_OBS'
249: where table_name='PO_VENDOR_CONTACTS';
250: update igi_sls_secure_tables set table_name='PO_VENDOR_SITES_OBS'
251: where table_name='PO_VENDOR_SITES_ALL';
252: update igi_sls_allocations set sls_allocation='PO_VENDORS_OBS'

Line 250: update igi_sls_secure_tables set table_name='PO_VENDOR_SITES_OBS'

246: update igi_sls_secure_tables set table_name='PO_VENDORS_OBS'
247: where table_name='PO_VENDORS';
248: update igi_sls_secure_tables set table_name='PO_VENDOR_CONTACTS_OBS'
249: where table_name='PO_VENDOR_CONTACTS';
250: update igi_sls_secure_tables set table_name='PO_VENDOR_SITES_OBS'
251: where table_name='PO_VENDOR_SITES_ALL';
252: update igi_sls_allocations set sls_allocation='PO_VENDORS_OBS'
253: where sls_allocation='PO_VENDORS';
254: update igi_sls_allocations set sls_allocation='PO_VENDOR_CONTACTS_OBS'