APPS.HR_PSF_BUS dependencies on DBMS_SQL

Line 7686: l_sql_cursor := dbms_sql.open_cursor;

7682: --
7683: if g_debug then
7684: hr_utility.set_location(l_proc, 150);
7685: end if;
7686: l_sql_cursor := dbms_sql.open_cursor;
7687: --
7688: -- Parse SQL statement.
7689: --
7690: dbms_sql.parse(l_sql_cursor, l_sql_text, dbms_sql.v7);

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

7686: l_sql_cursor := dbms_sql.open_cursor;
7687: --
7688: -- Parse SQL statement.
7689: --
7690: dbms_sql.parse(l_sql_cursor, l_sql_text, dbms_sql.v7);
7691: --
7692: -- Map the local variables to each returned Column
7693: --
7694: if g_debug then

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

7693: --
7694: if g_debug then
7695: hr_utility.set_location(l_proc, 160);
7696: end if;
7697: dbms_sql.define_column(l_sql_cursor, 1,l_oci_out,1);
7698: --
7699: -- Execute the SQL statement.
7700: --
7701: if g_debug then

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

7700: --
7701: if g_debug then
7702: hr_utility.set_location(l_proc, 170);
7703: end if;
7704: l_rows_fetched := dbms_sql.execute(l_sql_cursor);
7705: --
7706: if (dbms_sql.fetch_rows(l_sql_cursor) > 0)
7707: then
7708: hr_utility.set_message(800,'HR_6048_PO_POS_DEL_POS_CONT');

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

7702: hr_utility.set_location(l_proc, 170);
7703: end if;
7704: l_rows_fetched := dbms_sql.execute(l_sql_cursor);
7705: --
7706: if (dbms_sql.fetch_rows(l_sql_cursor) > 0)
7707: then
7708: hr_utility.set_message(800,'HR_6048_PO_POS_DEL_POS_CONT');
7709: hr_utility.raise_error;
7710: end if;

Line 7714: dbms_sql.close_cursor(l_sql_cursor);

7710: end if;
7711: --
7712: -- Close cursor used for processing SQL statement.
7713: --
7714: dbms_sql.close_cursor(l_sql_cursor);
7715: if g_debug then
7716: hr_utility.set_location(l_proc, 180);
7717: end if;
7718: end;