APPS.HR_PSF_BUS dependencies on DBMS_SQL

Line 7561: l_sql_cursor := dbms_sql.open_cursor;

7557: --
7558: if g_debug then
7559: hr_utility.set_location(l_proc, 150);
7560: end if;
7561: l_sql_cursor := dbms_sql.open_cursor;
7562: --
7563: -- Parse SQL statement.
7564: --
7565: dbms_sql.parse(l_sql_cursor, l_sql_text, dbms_sql.v7);

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

7561: l_sql_cursor := dbms_sql.open_cursor;
7562: --
7563: -- Parse SQL statement.
7564: --
7565: dbms_sql.parse(l_sql_cursor, l_sql_text, dbms_sql.v7);
7566: --
7567: -- Map the local variables to each returned Column
7568: --
7569: if g_debug then

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

7568: --
7569: if g_debug then
7570: hr_utility.set_location(l_proc, 160);
7571: end if;
7572: dbms_sql.define_column(l_sql_cursor, 1,l_oci_out,1);
7573: --
7574: -- Execute the SQL statement.
7575: --
7576: if g_debug then

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

7575: --
7576: if g_debug then
7577: hr_utility.set_location(l_proc, 170);
7578: end if;
7579: l_rows_fetched := dbms_sql.execute(l_sql_cursor);
7580: --
7581: if (dbms_sql.fetch_rows(l_sql_cursor) > 0)
7582: then
7583: hr_utility.set_message(800,'HR_6048_PO_POS_DEL_POS_CONT');

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

7577: hr_utility.set_location(l_proc, 170);
7578: end if;
7579: l_rows_fetched := dbms_sql.execute(l_sql_cursor);
7580: --
7581: if (dbms_sql.fetch_rows(l_sql_cursor) > 0)
7582: then
7583: hr_utility.set_message(800,'HR_6048_PO_POS_DEL_POS_CONT');
7584: hr_utility.raise_error;
7585: end if;

Line 7589: dbms_sql.close_cursor(l_sql_cursor);

7585: end if;
7586: --
7587: -- Close cursor used for processing SQL statement.
7588: --
7589: dbms_sql.close_cursor(l_sql_cursor);
7590: if g_debug then
7591: hr_utility.set_location(l_proc, 180);
7592: end if;
7593: end;