APPS.PER_POSITIONS_PKG dependencies on DBMS_SQL

Line 342: l_sql_cursor := dbms_sql.open_cursor;

338: ||' ) ';
339: --
340: -- Open Cursor for Processing Sql statment.
341: --
342: l_sql_cursor := dbms_sql.open_cursor;
343: --
344: -- Parse SQL statement.
345: --
346: dbms_sql.parse(l_sql_cursor, l_sql_text, dbms_sql.v7);

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

342: l_sql_cursor := dbms_sql.open_cursor;
343: --
344: -- Parse SQL statement.
345: --
346: dbms_sql.parse(l_sql_cursor, l_sql_text, dbms_sql.v7);
347: --
348: -- Map the local variables to each returned Column
349: --
350: dbms_sql.define_column(l_sql_cursor, 1,l_oci_out,1);

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

346: dbms_sql.parse(l_sql_cursor, l_sql_text, dbms_sql.v7);
347: --
348: -- Map the local variables to each returned Column
349: --
350: dbms_sql.define_column(l_sql_cursor, 1,l_oci_out,1);
351: --
352: -- Execute the SQL statement.
353: --
354: l_rows_fetched := dbms_sql.execute(l_sql_cursor);

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

350: dbms_sql.define_column(l_sql_cursor, 1,l_oci_out,1);
351: --
352: -- Execute the SQL statement.
353: --
354: l_rows_fetched := dbms_sql.execute(l_sql_cursor);
355: --
356: if (dbms_sql.fetch_rows(l_sql_cursor) > 0)
357: then
358: fnd_message.set_name('PER','HR_6048_PO_POS_DEL_POS_CONT');

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

352: -- Execute the SQL statement.
353: --
354: l_rows_fetched := dbms_sql.execute(l_sql_cursor);
355: --
356: if (dbms_sql.fetch_rows(l_sql_cursor) > 0)
357: then
358: fnd_message.set_name('PER','HR_6048_PO_POS_DEL_POS_CONT');
359: fnd_message.raise_error;
360: end if;

Line 364: dbms_sql.close_cursor(l_sql_cursor);

360: end if;
361: --
362: -- Close cursor used for processing SQL statement.
363: --
364: dbms_sql.close_cursor(l_sql_cursor);
365: end;
366: end if;
367: --
368: -- Ref Int check for OTA.