APPS.HR_PSF_DEL dependencies on DBMS_SQL

Line 467: l_sql_cursor := dbms_sql.open_cursor;

463: -- fix for bug 8439584
464: if g_debug then
465: hr_utility.set_location(l_proc, 150);
466: end if;
467: l_sql_cursor := dbms_sql.open_cursor;
468: --
469: -- Parse SQL statement.
470: --
471: dbms_sql.parse(l_sql_cursor, l_sql_text, dbms_sql.v7);

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

467: l_sql_cursor := dbms_sql.open_cursor;
468: --
469: -- Parse SQL statement.
470: --
471: dbms_sql.parse(l_sql_cursor, l_sql_text, dbms_sql.v7);
472: --
473: -- Map the local variables to each returned Column
474: --
475: if g_debug then

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

474: --
475: if g_debug then
476: hr_utility.set_location(l_proc, 160);
477: end if;
478: dbms_sql.define_column(l_sql_cursor, 1,l_oci_out,1);
479: --
480: -- Execute the SQL statement.
481: --
482: if g_debug then

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

481: --
482: if g_debug then
483: hr_utility.set_location(l_proc, 170);
484: end if;
485: l_rows_fetched := dbms_sql.execute(l_sql_cursor);
486: --
487: if (dbms_sql.fetch_rows(l_sql_cursor) > 0)
488: then
489: hr_utility.set_message(800,'HR_6048_PO_POS_DEL_POS_CONT');

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

483: hr_utility.set_location(l_proc, 170);
484: end if;
485: l_rows_fetched := dbms_sql.execute(l_sql_cursor);
486: --
487: if (dbms_sql.fetch_rows(l_sql_cursor) > 0)
488: then
489: hr_utility.set_message(800,'HR_6048_PO_POS_DEL_POS_CONT');
490: hr_utility.raise_error;
491: end if;

Line 495: dbms_sql.close_cursor(l_sql_cursor);

491: end if;
492: --
493: -- Close cursor used for processing SQL statement.
494: --
495: dbms_sql.close_cursor(l_sql_cursor);
496: if g_debug then
497: hr_utility.set_location(l_proc, 180);
498: end if;
499: end;