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;