APPS.AD_MO_UTIL_PKG dependencies on DBMS_SQL

Line 56: handle := DBMS_SQL.OPEN_CURSOR;

52: );
53:
54: BEGIN
55:
56: handle := DBMS_SQL.OPEN_CURSOR;
57: v_synonym :=p_view_name ;
58:
59: --
60: -- get the product name

Line 85: dbms_sql.parse(handle,sql_stmt,DBMS_SQL.V7);

81: --
82:
83: IF (upper(p_action) = 'MOVW') THEN
84: sql_stmt:= 'drop view ' || p_apps_user_name || '.'|| p_view_name;
85: dbms_sql.parse(handle,sql_stmt,DBMS_SQL.V7);
86:
87: --
88: -- Replace db default
89: --

Line 94: dbms_sql.parse(handle,sql_stmt,DBMS_SQL.V7);

90:
91: ELSIF ( upper(p_action) = 'MODFV') THEN
92: sql_stmt:='alter table ' || v_sys_table ||
93: ' modify ( org_id DEFAULT NULL )';
94: dbms_sql.parse(handle,sql_stmt,DBMS_SQL.V7);
95:
96: -- NOTE:
97: -- sstomar: No need to (re)generate Editioning View if we are just
98: -- changing column with DEFAULT value.

Line 104: dbms_sql.parse(handle,sql_stmt,DBMS_SQL.V7);

100: -- column to a table is being added.
101: --
102: sql_stmt:='alter synonym ' || p_apps_user_name || '.' ||
103: p_prod_tab_name ||' compile';
104: dbms_sql.parse(handle,sql_stmt,DBMS_SQL.V7);
105:
106: --
107: -- Create synonym
108: --

Line 130: dbms_sql.parse(handle,sql_stmt,DBMS_SQL.V7);

126: -- SSTOMAR: Why we want to drop synonym ???
127: --
128: -- First drop synonym , needed to refresh VPD policy
129: sql_stmt:= 'drop synonym ' || p_apps_user_name || '.'||v_synonym;
130: dbms_sql.parse(handle,sql_stmt,DBMS_SQL.V7);
131:
132: -- Then create synonym
133: sql_stmt:='create or replace synonym ' || p_apps_user_name || '.' ||
134: v_synonym || ' for ' || v_target;

Line 135: dbms_sql.parse(handle,sql_stmt,DBMS_SQL.V7);

131:
132: -- Then create synonym
133: sql_stmt:='create or replace synonym ' || p_apps_user_name || '.' ||
134: v_synonym || ' for ' || v_target;
135: dbms_sql.parse(handle,sql_stmt,DBMS_SQL.V7);
136:
137: --
138: -- Delete view from AOL data dictionary
139: --

Line 237: dbms_sql.parse(handle,sql_stmt,DBMS_SQL.V7);

233: IF upper(p_action) = 'MOSYN' then
234: sql_stmt:='create or replace synonym ' || p_apps_user_name || '.' ||
235: v_synonym || ' for ' || v_target;
236:
237: dbms_sql.parse(handle,sql_stmt,DBMS_SQL.V7);
238: END IF;
239:
240: WHEN OTHERS THEN
241: