APPS.IGI_SLS_UPG_PKG dependencies on IGI_SLS_UPG_ITF

Line 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

27: begin
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));

Line 34: AND A.table_name NOT IN (SELECT old_table_name FROM igi_sls_upg_itf)

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:
37: END populate_temp_table_old;
38:

Line 45: FROM igi_sls_upg_itf ORDER BY old_table_name;

41: l_list list_of_old_tables;
42: BEGIN
43:
44: SELECT distinct old_table_name BULK COLLECT INTO l_list
45: FROM igi_sls_upg_itf ORDER BY old_table_name;
46:
47: write_to_log (l_excep_level, 'get_changed_secured_list',SQL%ROWCOUNT ||' rows picked and ' );
48: -- Now work with data in the collections
49: RETURN l_list;

Line 56: SELECT new_table_name BULK COLLECT INTO l_list FROM igi_sls_upg_itf ORDER BY new_table_name;

52:
53: FUNCTION get_new_secured_list RETURN list_of_old_tables AS
54: l_list list_of_old_tables;
55: BEGIN
56: SELECT new_table_name BULK COLLECT INTO l_list FROM igi_sls_upg_itf ORDER BY new_table_name;
57:
58: write_to_log (l_excep_level, 'get_new_secured_list',SQL%ROWCOUNT ||' rows picked and ' );
59:
60: -- Now work with data in the collections

Line 103: SELECT sls_groups INTO param2(indx) FROM igi_sls_upg_itf WHERE old_table_name=param1(indx);

99: BEGIN
100: FOR indx IN param1.FIRST .. param1.LAST
101: LOOP
102:
103: SELECT sls_groups INTO param2(indx) FROM igi_sls_upg_itf WHERE old_table_name=param1(indx);
104:
105: END LOOP;
106:
107:

Line 182: UPDATE igi_sls_upg_itf SET new_table_name=l_table_name,new_owner=l_owner, new_allocation=l_sls_table_name WHERE old_table_name = l_old_table_name;

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:
182: UPDATE igi_sls_upg_itf SET new_table_name=l_table_name,new_owner=l_owner, new_allocation=l_sls_table_name WHERE old_table_name = l_old_table_name;
183:
184: END IF;
185: END LOOP;
186:

Line 272: UPDATE igi_sls_upg_itf SET from_clause=param2(indx) , where_clause=param3(indx)

268: PROCEDURE set_query_data(param1 in list_of_old_tables , param2 in list_of_from, param3 in list_of_where) IS
269: BEGIN
270: FOR indx IN param1.FIRST .. param2.LAST
271: LOOP
272: UPDATE igi_sls_upg_itf SET from_clause=param2(indx) , where_clause=param3(indx)
273: WHERE old_table_name=param1(indx) AND param3(indx) IS NOT NULL;
274:
275: write_to_log (l_excep_level, 'set_query_data',SQL%ROWCOUNT ||' rows updated' );
276:

Line 301: SELECT old_allocation, new_allocation INTO l_sls_tab_old, l_sls_tab_new FROM igi_sls_upg_itf

297:
298: FOR indx IN param1.FIRST .. param1.LAST
299: LOOP
300:
301: SELECT old_allocation, new_allocation INTO l_sls_tab_old, l_sls_tab_new FROM igi_sls_upg_itf
302: WHERE old_table_name=param1(indx);
303:
304: l_old_table := param1(indx);
305: l_new_table := param2(indx);