1 PACKAGE IGI_SLS_UPG_PKG AUTHID CURRENT_USER AS
2 --$Header: igislsus.pls 120.3 2011/09/09 17:27:46 sasukuma ship $
3
4 TYPE list_of_old_tables IS TABLE OF igi_sls_upg_itf.old_table_name%TYPE
5 index BY PLS_INTEGER;
6
7 TYPE list_of_new_tables IS TABLE OF igi_sls_upg_itf.new_table_name%TYPE
8 INDEX BY PLS_INTEGER;
9
10 TYPE list_of_secured_groups IS TABLE OF igi_sls_upg_itf.sls_groups%TYPE
11 INDEX BY PLS_INTEGER;
12
13 TYPE list_of_from IS TABLE OF VARCHAR2(500) INDEX BY PLS_INTEGER;
14
15 TYPE list_of_where IS TABLE OF VARCHAR2(2000) INDEX BY PLS_INTEGER;
16
17 TYPE row_id_list IS TABLE OF ROWID INDEX BY PLS_INTEGER;
18
19 PROCEDURE populate_temp_table_old;
20 FUNCTION get_sls_grps(p_table_name varchar2) RETURN VARCHAR2;
21
22 FUNCTION get_changed_secured_list RETURN list_of_old_tables;
23 FUNCTION get_new_secured_list RETURN list_of_old_tables;
24
25
26 PROCEDURE get_security_groups_list(param1 IN list_of_old_tables, param2 OUT NOCOPY list_of_secured_groups);
27
28 PROCEDURE populate_temp_table_new(param1 IN list_of_old_tables, param2 IN list_of_new_tables, ret_code OUT NOCOPY NUMBER);
29 PROCEDURE set_sls_tables_data ( param1 IN list_of_old_tables, param2 IN list_of_new_tables);
30 PROCEDURE set_sls_allocations_data( param1 IN list_of_old_tables, param2 IN list_of_new_tables);
31
32
33 PROCEDURE set_query_data(param1 IN list_of_old_tables , param2 IN list_of_from, param3 IN list_of_where);
34
35 PROCEDURE migrate_data(param1 IN list_of_old_tables, param2 IN list_of_new_tables,
36 param3 IN list_of_from, param4 IN list_of_where) ;
37
38 PROCEDURE disable_old_tables;
39
40 PROCEDURE fnd_wait_for_request(req_id IN NUMBER, dev_status OUT NOCOPY VARCHAR2, dev_phase OUT NOCOPY VARCHAR2);
41
42 END; -- Package spec
[Home] [Help]