APPS.AZ_PLSQL_XML dependencies on DBMS_SQL

Line 137: -- dbms_sql.execute

133: (p_source in varchar2
134: ) is
135: l_dynamic_cursor integer; -- Dynamic sql cursor
136: l_execute integer; -- Value returned by
137: -- dbms_sql.execute
138: l_proc varchar2(72) := g_package||'execute_source';
139: begin
140: hr_utility.set_location('Entering:'|| l_proc, 10);
141: --

Line 146: l_dynamic_cursor := dbms_sql.open_cursor;

142: -- The whole of the new package body code has now been built,
143: -- use dynamic SQL to execute the create or replace package statement
144: --
145: hr_utility.set_location(l_proc, 11);
146: l_dynamic_cursor := dbms_sql.open_cursor;
147: dbms_sql.parse(l_dynamic_cursor, p_source, dbms_sql.v7);
148: l_execute := dbms_sql.execute(l_dynamic_cursor);
149: dbms_sql.close_cursor(l_dynamic_cursor);
150: hr_utility.set_location(' Leaving:'|| l_proc, 20);

Line 147: dbms_sql.parse(l_dynamic_cursor, p_source, dbms_sql.v7);

143: -- use dynamic SQL to execute the create or replace package statement
144: --
145: hr_utility.set_location(l_proc, 11);
146: l_dynamic_cursor := dbms_sql.open_cursor;
147: dbms_sql.parse(l_dynamic_cursor, p_source, dbms_sql.v7);
148: l_execute := dbms_sql.execute(l_dynamic_cursor);
149: dbms_sql.close_cursor(l_dynamic_cursor);
150: hr_utility.set_location(' Leaving:'|| l_proc, 20);
151: exception

Line 148: l_execute := dbms_sql.execute(l_dynamic_cursor);

144: --
145: hr_utility.set_location(l_proc, 11);
146: l_dynamic_cursor := dbms_sql.open_cursor;
147: dbms_sql.parse(l_dynamic_cursor, p_source, dbms_sql.v7);
148: l_execute := dbms_sql.execute(l_dynamic_cursor);
149: dbms_sql.close_cursor(l_dynamic_cursor);
150: hr_utility.set_location(' Leaving:'|| l_proc, 20);
151: exception
152: --

Line 149: dbms_sql.close_cursor(l_dynamic_cursor);

145: hr_utility.set_location(l_proc, 11);
146: l_dynamic_cursor := dbms_sql.open_cursor;
147: dbms_sql.parse(l_dynamic_cursor, p_source, dbms_sql.v7);
148: l_execute := dbms_sql.execute(l_dynamic_cursor);
149: dbms_sql.close_cursor(l_dynamic_cursor);
150: hr_utility.set_location(' Leaving:'|| l_proc, 20);
151: exception
152: --
153: -- In case of an unexpected error close the dynamic cursor

Line 157: if (dbms_sql.is_open(l_dynamic_cursor)) then

153: -- In case of an unexpected error close the dynamic cursor
154: -- if it was successfully opened.
155: --
156: when others then
157: if (dbms_sql.is_open(l_dynamic_cursor)) then
158: dbms_sql.close_cursor(l_dynamic_cursor);
159: end if;
160: raise;
161: end execute_source;

Line 158: dbms_sql.close_cursor(l_dynamic_cursor);

154: -- if it was successfully opened.
155: --
156: when others then
157: if (dbms_sql.is_open(l_dynamic_cursor)) then
158: dbms_sql.close_cursor(l_dynamic_cursor);
159: end if;
160: raise;
161: end execute_source;
162: --