48: );
49:
50: BEGIN
51:
52: handle := DBMS_SQL.OPEN_CURSOR;
53: v_synonym :=p_view_name ;
54:
55: --
56: -- get the product name
70: --
71:
72: IF (upper(p_action) = 'MOVW') THEN
73: sql_stmt:= 'drop view ' || p_apps_user_name || '.'|| p_view_name;
74: dbms_sql.parse(handle,sql_stmt,DBMS_SQL.V7);
75:
76: --
77: -- Replace db default
78: --
79:
80: ELSIF ( upper(p_action) = 'MODFV') THEN
81: sql_stmt:='alter table ' || v_sys_table ||
82: ' modify ( org_id DEFAULT NULL )';
83: dbms_sql.parse(handle,sql_stmt,DBMS_SQL.V7);
84:
85: sql_stmt:='alter synonym ' || p_apps_user_name || '.' ||
86: p_prod_tab_name ||' compile';
87: dbms_sql.parse(handle,sql_stmt,DBMS_SQL.V7);
83: dbms_sql.parse(handle,sql_stmt,DBMS_SQL.V7);
84:
85: sql_stmt:='alter synonym ' || p_apps_user_name || '.' ||
86: p_prod_tab_name ||' compile';
87: dbms_sql.parse(handle,sql_stmt,DBMS_SQL.V7);
88:
89: --
90: -- Create synonym
91: --
94:
95: -- First drop synonym , needed to refresh VPD policy
96:
97: sql_stmt:= 'drop synonym ' || p_apps_user_name || '.'||v_synonym;
98: dbms_sql.parse(handle,sql_stmt,DBMS_SQL.V7);
99:
100: -- Then create synonym
101:
102: sql_stmt:='create or replace synonym ' || p_apps_user_name || '.' ||
100: -- Then create synonym
101:
102: sql_stmt:='create or replace synonym ' || p_apps_user_name || '.' ||
103: v_synonym || ' for ' || v_sys_table;
104: dbms_sql.parse(handle,sql_stmt,DBMS_SQL.V7);
105:
106: --
107: -- Delete view from AOL data dictionary
108: --
201:
202: IF upper(p_action) = 'MOSYN' then
203: sql_stmt:='create or replace synonym ' || p_apps_user_name || '.'||
204: v_synonym || ' for ' || v_sys_table;
205: dbms_sql.parse(handle,sql_stmt,DBMS_SQL.V7);
206: END IF;
207:
208: WHEN OTHERS THEN
209: