APPS.PER_POSITION_STRUCTURES_PKG dependencies on DBMS_SQL

Line 211: l_sql_cursor := dbms_sql.open_cursor;

207: ||' ) ';
208: --
209: -- Open Cursor for Processing Sql statment.
210: --
211: l_sql_cursor := dbms_sql.open_cursor;
212: --
213: -- Parse SQL statement.
214: --
215: dbms_sql.parse(l_sql_cursor, l_sql_text, dbms_sql.v7);

Line 215: dbms_sql.parse(l_sql_cursor, l_sql_text, dbms_sql.v7);

211: l_sql_cursor := dbms_sql.open_cursor;
212: --
213: -- Parse SQL statement.
214: --
215: dbms_sql.parse(l_sql_cursor, l_sql_text, dbms_sql.v7);
216: --
217: -- Map the local variables to each returned Column
218: --
219: dbms_sql.define_column(l_sql_cursor, 1,l_oci_out,1);

Line 219: dbms_sql.define_column(l_sql_cursor, 1,l_oci_out,1);

215: dbms_sql.parse(l_sql_cursor, l_sql_text, dbms_sql.v7);
216: --
217: -- Map the local variables to each returned Column
218: --
219: dbms_sql.define_column(l_sql_cursor, 1,l_oci_out,1);
220: --
221: -- Execute the SQL statement.
222: --
223: l_rows_fetched := dbms_sql.execute(l_sql_cursor);

Line 223: l_rows_fetched := dbms_sql.execute(l_sql_cursor);

219: dbms_sql.define_column(l_sql_cursor, 1,l_oci_out,1);
220: --
221: -- Execute the SQL statement.
222: --
223: l_rows_fetched := dbms_sql.execute(l_sql_cursor);
224: --
225: if (dbms_sql.fetch_rows(l_sql_cursor) > 0)
226: then
227: fnd_message.set_name('PER','HR_6048_PO_POS_DEL_POS_CONT');

Line 225: if (dbms_sql.fetch_rows(l_sql_cursor) > 0)

221: -- Execute the SQL statement.
222: --
223: l_rows_fetched := dbms_sql.execute(l_sql_cursor);
224: --
225: if (dbms_sql.fetch_rows(l_sql_cursor) > 0)
226: then
227: fnd_message.set_name('PER','HR_6048_PO_POS_DEL_POS_CONT');
228: fnd_message.raise_error;
229: end if;

Line 233: dbms_sql.close_cursor(l_sql_cursor);

229: end if;
230: --
231: -- Close cursor used for processing SQL statement.
232: --
233: dbms_sql.close_cursor(l_sql_cursor);
234: end;
235: end if;
236: end;
237: