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_ALLOCATIONS

Line 35: AND a.table_name IN (SELECT sls_allocation FROM igi_sls_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:
37: END populate_temp_table_old;
38:
39:

Line 69: SELECT COUNT(*) INTO l_count FROM igi_sls_allocations WHERE sls_allocation = p_table_name ;

65: FUNCTION get_sls_grps(p_table_name varchar2) RETURN VARCHAR2 IS
66: l_count NUMBER;
67: l_dummy VARCHAR2(2000);
68: BEGIN
69: SELECT COUNT(*) INTO l_count FROM igi_sls_allocations WHERE sls_allocation = p_table_name ;
70:
71: FOR sec_grp_rec IN
72: (SELECT sls_group FROM igi_sls_allocations WHERE sls_allocation = p_table_name)
73: LOOP

Line 72: (SELECT sls_group FROM igi_sls_allocations WHERE sls_allocation = p_table_name)

68: BEGIN
69: SELECT COUNT(*) INTO l_count FROM igi_sls_allocations WHERE sls_allocation = p_table_name ;
70:
71: FOR sec_grp_rec IN
72: (SELECT sls_group FROM igi_sls_allocations WHERE sls_allocation = p_table_name)
73: LOOP
74: IF l_count=1 THEN
75: l_dummy:= l_dummy || sec_grp_rec.sls_group;
76: RETURN l_dummy;

Line 195: /*** Procedure to set data in IGI_SLS_ALLOCATIONS */

191:
192:
193:
194:
195: /***** Procedure to set data in IGI_SLS_ALLOCATIONS ***/
196: PROCEDURE set_sls_allocations_data( param1 IN list_of_old_tables, param2 IN list_of_new_tables) is
197: l_old_table_name VARCHAR2(50);
198: l_table_name VARCHAR2(50);
199: l_sls_group VARCHAR2(50);

Line 214: SELECT ROWID BULK COLLECT INTO l_list FROM igi_sls_allocations WHERE sls_allocation =l_old_table_name;

210:
211: /** This table has a index attached on 4 columns and no primary key.. hence using rowid to
212: uniquely picking up rows */
213:
214: SELECT ROWID BULK COLLECT INTO l_list FROM igi_sls_allocations WHERE sls_allocation =l_old_table_name;
215:
216: FOR indx1 IN l_list.FIRST .. l_list.LAST
217: LOOP
218: l_rowid:=l_list(indx1);

Line 219: SELECT sls_group INTO l_sls_group FROM igi_sls_allocations WHERE ROWID=l_rowid;

215:
216: FOR indx1 IN l_list.FIRST .. l_list.LAST
217: LOOP
218: l_rowid:=l_list(indx1);
219: SELECT sls_group INTO l_sls_group FROM igi_sls_allocations WHERE ROWID=l_rowid;
220:
221: /** Check if this entry is already there in the table **/
222: SELECT COUNT(*) INTO l_count FROM igi_sls_allocations WHERE sls_group=l_sls_group
223: AND sls_allocation = l_table_name;

Line 222: SELECT COUNT(*) INTO l_count FROM igi_sls_allocations WHERE sls_group=l_sls_group

218: l_rowid:=l_list(indx1);
219: SELECT sls_group INTO l_sls_group FROM igi_sls_allocations WHERE ROWID=l_rowid;
220:
221: /** Check if this entry is already there in the table **/
222: SELECT COUNT(*) INTO l_count FROM igi_sls_allocations WHERE sls_group=l_sls_group
223: AND sls_allocation = l_table_name;
224:
225: /** Insert only if the entry is not present.. */
226: IF(l_count =0)THEN

Line 227: INSERT INTO igi_sls_allocations (SELECT SLS_GROUP ,SLS_GROUP_TYPE ,l_table_name ,SLS_ALLOCATION_TYPE,

223: AND sls_allocation = l_table_name;
224:
225: /** Insert only if the entry is not present.. */
226: IF(l_count =0)THEN
227: INSERT INTO igi_sls_allocations (SELECT SLS_GROUP ,SLS_GROUP_TYPE ,l_table_name ,SLS_ALLOCATION_TYPE,
228: SYSDATE ,null,null,null,SYSDATE ,CREATED_BY,1,sysdate,1 FROM
229: igi_sls_allocations WHERE ROWID=l_rowid) ;
230:
231: END IF;

Line 229: igi_sls_allocations WHERE ROWID=l_rowid) ;

225: /** Insert only if the entry is not present.. */
226: IF(l_count =0)THEN
227: INSERT INTO igi_sls_allocations (SELECT SLS_GROUP ,SLS_GROUP_TYPE ,l_table_name ,SLS_ALLOCATION_TYPE,
228: SYSDATE ,null,null,null,SYSDATE ,CREATED_BY,1,sysdate,1 FROM
229: igi_sls_allocations WHERE ROWID=l_rowid) ;
230:
231: END IF;
232: END LOOP;
233:

Line 237: /*** Procedure to set data in IGI_SLS_ALLOCATIONS */

233:
234: END LOOP;
235: END set_sls_allocations_data;
236:
237: /***** Procedure to set data in IGI_SLS_ALLOCATIONS ***/
238:
239:
240:
241: /********** Very imp. procedure... Final Steps that are to be done...******/

Line 252: update igi_sls_allocations set sls_allocation='PO_VENDORS_OBS'

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'
255: where sls_allocation='PO_VENDOR_CONTACTS';
256: update igi_sls_allocations set sls_allocation='PO_VENDOR_SITES_OBS'

Line 254: update igi_sls_allocations set sls_allocation='PO_VENDOR_CONTACTS_OBS'

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'
255: where sls_allocation='PO_VENDOR_CONTACTS';
256: update igi_sls_allocations set sls_allocation='PO_VENDOR_SITES_OBS'
257: where sls_allocation='PO_VENDOR_SITES_ALL';
258:

Line 256: update igi_sls_allocations set sls_allocation='PO_VENDOR_SITES_OBS'

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'
255: where sls_allocation='PO_VENDOR_CONTACTS';
256: update igi_sls_allocations set sls_allocation='PO_VENDOR_SITES_OBS'
257: where sls_allocation='PO_VENDOR_SITES_ALL';
258:
259: delete from IGI_GCC_INST_OPTIONS_ALL where OPTION_NAME='SLS';
260: