APPS.HR_PSF_DEL dependencies on DBMS_SQL

Line 458: l_sql_cursor := dbms_sql.open_cursor;

454: --
455: if g_debug then
456: hr_utility.set_location(l_proc, 150);
457: end if;
458: l_sql_cursor := dbms_sql.open_cursor;
459: --
460: -- Parse SQL statement.
461: --
462: dbms_sql.parse(l_sql_cursor, l_sql_text, dbms_sql.v7);

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

458: l_sql_cursor := dbms_sql.open_cursor;
459: --
460: -- Parse SQL statement.
461: --
462: dbms_sql.parse(l_sql_cursor, l_sql_text, dbms_sql.v7);
463: --
464: -- Map the local variables to each returned Column
465: --
466: if g_debug then

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

465: --
466: if g_debug then
467: hr_utility.set_location(l_proc, 160);
468: end if;
469: dbms_sql.define_column(l_sql_cursor, 1,l_oci_out,1);
470: --
471: -- Execute the SQL statement.
472: --
473: if g_debug then

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

472: --
473: if g_debug then
474: hr_utility.set_location(l_proc, 170);
475: end if;
476: l_rows_fetched := dbms_sql.execute(l_sql_cursor);
477: --
478: if (dbms_sql.fetch_rows(l_sql_cursor) > 0)
479: then
480: hr_utility.set_message(800,'HR_6048_PO_POS_DEL_POS_CONT');

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

474: hr_utility.set_location(l_proc, 170);
475: end if;
476: l_rows_fetched := dbms_sql.execute(l_sql_cursor);
477: --
478: if (dbms_sql.fetch_rows(l_sql_cursor) > 0)
479: then
480: hr_utility.set_message(800,'HR_6048_PO_POS_DEL_POS_CONT');
481: hr_utility.raise_error;
482: end if;

Line 486: dbms_sql.close_cursor(l_sql_cursor);

482: end if;
483: --
484: -- Close cursor used for processing SQL statement.
485: --
486: dbms_sql.close_cursor(l_sql_cursor);
487: if g_debug then
488: hr_utility.set_location(l_proc, 180);
489: end if;
490: end;