DBA Data[Home] [Help]

APPS.HR_LEG_INSTALLATION_PKG dependencies on DBMS_SQL

Line 113: sql_curs := dbms_sql.open_cursor;

109: where view_name = l_view_name
110: and rownum=1;
111:
112: statem := 'DROP VIEW ' || l_view_name ;
113: sql_curs := dbms_sql.open_cursor;
114: dbms_sql.parse(sql_curs,
115: statem,
116: dbms_sql.v7);
117: rows_processed := dbms_sql.execute(sql_curs);

Line 114: dbms_sql.parse(sql_curs,

110: and rownum=1;
111:
112: statem := 'DROP VIEW ' || l_view_name ;
113: sql_curs := dbms_sql.open_cursor;
114: dbms_sql.parse(sql_curs,
115: statem,
116: dbms_sql.v7);
117: rows_processed := dbms_sql.execute(sql_curs);
118: dbms_sql.close_cursor(sql_curs);

Line 116: dbms_sql.v7);

112: statem := 'DROP VIEW ' || l_view_name ;
113: sql_curs := dbms_sql.open_cursor;
114: dbms_sql.parse(sql_curs,
115: statem,
116: dbms_sql.v7);
117: rows_processed := dbms_sql.execute(sql_curs);
118: dbms_sql.close_cursor(sql_curs);
119:
120:

Line 117: rows_processed := dbms_sql.execute(sql_curs);

113: sql_curs := dbms_sql.open_cursor;
114: dbms_sql.parse(sql_curs,
115: statem,
116: dbms_sql.v7);
117: rows_processed := dbms_sql.execute(sql_curs);
118: dbms_sql.close_cursor(sql_curs);
119:
120:
121: exception

Line 118: dbms_sql.close_cursor(sql_curs);

114: dbms_sql.parse(sql_curs,
115: statem,
116: dbms_sql.v7);
117: rows_processed := dbms_sql.execute(sql_curs);
118: dbms_sql.close_cursor(sql_curs);
119:
120:
121: exception
122: when no_data_found then return;

Line 141: sql_curs := dbms_sql.open_cursor;

137: where application_short_name=p_product
138: and nvl(p_legislation,'x')=nvl(legislation_code,'x');
139:
140: statem := 'CREATE OR REPLACE FORCE VIEW ' || l_view_name ||'(product_implemented) AS SELECT ''product_implemented'' from dual';
141: sql_curs := dbms_sql.open_cursor;
142: dbms_sql.parse(sql_curs,
143: statem,
144: dbms_sql.v7);
145: rows_processed := dbms_sql.execute(sql_curs);

Line 142: dbms_sql.parse(sql_curs,

138: and nvl(p_legislation,'x')=nvl(legislation_code,'x');
139:
140: statem := 'CREATE OR REPLACE FORCE VIEW ' || l_view_name ||'(product_implemented) AS SELECT ''product_implemented'' from dual';
141: sql_curs := dbms_sql.open_cursor;
142: dbms_sql.parse(sql_curs,
143: statem,
144: dbms_sql.v7);
145: rows_processed := dbms_sql.execute(sql_curs);
146: dbms_sql.close_cursor(sql_curs);

Line 144: dbms_sql.v7);

140: statem := 'CREATE OR REPLACE FORCE VIEW ' || l_view_name ||'(product_implemented) AS SELECT ''product_implemented'' from dual';
141: sql_curs := dbms_sql.open_cursor;
142: dbms_sql.parse(sql_curs,
143: statem,
144: dbms_sql.v7);
145: rows_processed := dbms_sql.execute(sql_curs);
146: dbms_sql.close_cursor(sql_curs);
147:
148: exception

Line 145: rows_processed := dbms_sql.execute(sql_curs);

141: sql_curs := dbms_sql.open_cursor;
142: dbms_sql.parse(sql_curs,
143: statem,
144: dbms_sql.v7);
145: rows_processed := dbms_sql.execute(sql_curs);
146: dbms_sql.close_cursor(sql_curs);
147:
148: exception
149: when no_data_found then return;

Line 146: dbms_sql.close_cursor(sql_curs);

142: dbms_sql.parse(sql_curs,
143: statem,
144: dbms_sql.v7);
145: rows_processed := dbms_sql.execute(sql_curs);
146: dbms_sql.close_cursor(sql_curs);
147:
148: exception
149: when no_data_found then return;
150: end;

Line 225: s_curs := dbms_sql.open_cursor;

221: l_statement varchar2(1000);
222: l_ret_row integer;
223: begin
224: l_statement := 'drop public synonym '||p_syn_name;
225: s_curs := dbms_sql.open_cursor;
226: dbms_sql.parse(s_curs,
227: l_statement,
228: dbms_sql.v7);
229: l_ret_row := dbms_sql.execute(s_curs);

Line 226: dbms_sql.parse(s_curs,

222: l_ret_row integer;
223: begin
224: l_statement := 'drop public synonym '||p_syn_name;
225: s_curs := dbms_sql.open_cursor;
226: dbms_sql.parse(s_curs,
227: l_statement,
228: dbms_sql.v7);
229: l_ret_row := dbms_sql.execute(s_curs);
230: dbms_sql.close_cursor(s_curs);

Line 228: dbms_sql.v7);

224: l_statement := 'drop public synonym '||p_syn_name;
225: s_curs := dbms_sql.open_cursor;
226: dbms_sql.parse(s_curs,
227: l_statement,
228: dbms_sql.v7);
229: l_ret_row := dbms_sql.execute(s_curs);
230: dbms_sql.close_cursor(s_curs);
231: exception
232: when others then return;

Line 229: l_ret_row := dbms_sql.execute(s_curs);

225: s_curs := dbms_sql.open_cursor;
226: dbms_sql.parse(s_curs,
227: l_statement,
228: dbms_sql.v7);
229: l_ret_row := dbms_sql.execute(s_curs);
230: dbms_sql.close_cursor(s_curs);
231: exception
232: when others then return;
233: end drop_pubsyn;

Line 230: dbms_sql.close_cursor(s_curs);

226: dbms_sql.parse(s_curs,
227: l_statement,
228: dbms_sql.v7);
229: l_ret_row := dbms_sql.execute(s_curs);
230: dbms_sql.close_cursor(s_curs);
231: exception
232: when others then return;
233: end drop_pubsyn;
234: