eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_API_USER_HOOKS dependencies on DBMS_SQL

Line 219: -- dbms_sql.execute

215: --
216: procedure execute_source is
217: l_dynamic_cursor integer; -- Dynamic sql cursor
218: l_execute integer; -- Value returned by
219: -- dbms_sql.execute
220: l_proc varchar2(72) := g_package||'execute_source';
221: begin
222: hr_utility.set_location('Entering:'|| l_proc, 10);
223: --

Line 227: l_dynamic_cursor := dbms_sql.open_cursor;

223: --
224: -- The whole of the new package body code has now been built,
225: -- use dynamic SQL to execute the create or replace package statement
226: --
227: l_dynamic_cursor := dbms_sql.open_cursor;
228: dbms_sql.parse(l_dynamic_cursor, g_source, dbms_sql.v7);
229: l_execute := dbms_sql.execute(l_dynamic_cursor);
230: dbms_sql.close_cursor(l_dynamic_cursor);
231: hr_utility.set_location(' Leaving:'|| l_proc, 20);

Line 228: dbms_sql.parse(l_dynamic_cursor, g_source, dbms_sql.v7);

224: -- The whole of the new package body code has now been built,
225: -- use dynamic SQL to execute the create or replace package statement
226: --
227: l_dynamic_cursor := dbms_sql.open_cursor;
228: dbms_sql.parse(l_dynamic_cursor, g_source, dbms_sql.v7);
229: l_execute := dbms_sql.execute(l_dynamic_cursor);
230: dbms_sql.close_cursor(l_dynamic_cursor);
231: hr_utility.set_location(' Leaving:'|| l_proc, 20);
232: exception

Line 229: l_execute := dbms_sql.execute(l_dynamic_cursor);

225: -- use dynamic SQL to execute the create or replace package statement
226: --
227: l_dynamic_cursor := dbms_sql.open_cursor;
228: dbms_sql.parse(l_dynamic_cursor, g_source, dbms_sql.v7);
229: l_execute := dbms_sql.execute(l_dynamic_cursor);
230: dbms_sql.close_cursor(l_dynamic_cursor);
231: hr_utility.set_location(' Leaving:'|| l_proc, 20);
232: exception
233: --

Line 230: dbms_sql.close_cursor(l_dynamic_cursor);

226: --
227: l_dynamic_cursor := dbms_sql.open_cursor;
228: dbms_sql.parse(l_dynamic_cursor, g_source, dbms_sql.v7);
229: l_execute := dbms_sql.execute(l_dynamic_cursor);
230: dbms_sql.close_cursor(l_dynamic_cursor);
231: hr_utility.set_location(' Leaving:'|| l_proc, 20);
232: exception
233: --
234: -- In case of an unexpected error close the dynamic cursor

Line 238: if (dbms_sql.is_open(l_dynamic_cursor)) then

234: -- In case of an unexpected error close the dynamic cursor
235: -- if it was successfully opened.
236: --
237: when others then
238: if (dbms_sql.is_open(l_dynamic_cursor)) then
239: dbms_sql.close_cursor(l_dynamic_cursor);
240: end if;
241: --
242: -- If a compilation error is expected then sliently trap the error.

Line 239: dbms_sql.close_cursor(l_dynamic_cursor);

235: -- if it was successfully opened.
236: --
237: when others then
238: if (dbms_sql.is_open(l_dynamic_cursor)) then
239: dbms_sql.close_cursor(l_dynamic_cursor);
240: end if;
241: --
242: -- If a compilation error is expected then sliently trap the error.
243: -- A user hook specific error has already been logged in the

Line 1857: l_execute integer; -- Value from dbms_sql.execute

1853: -- specific call has been processed
1854: -- for the current hook package
1855: -- procedure and sequence number
1856: -- range.
1857: l_execute integer; -- Value from dbms_sql.execute
1858: l_api_hook_call_id number(15); -- Value from Dynamic cursor
1859: l_object_version_number number(15); -- Value from Dynamic cursor
1860: l_call_package varchar2(30); -- Value from Dynamic cursor
1861: l_call_procedure varchar2(30); -- Value from Dynamic cursor

Line 1908: l_dynamic_cursor := dbms_sql.open_cursor;

1904: --
1905: -- Execute the Dynamic SQL statement which has been created
1906: --
1907: -- Open dynamic cursor
1908: l_dynamic_cursor := dbms_sql.open_cursor;
1909: hr_utility.set_location(l_proc, 30);
1910: --
1911: -- Parse dynamic SQL
1912: dbms_sql.parse(l_dynamic_cursor, l_dynamic_sql, dbms_sql.v7);

Line 1912: dbms_sql.parse(l_dynamic_cursor, l_dynamic_sql, dbms_sql.v7);

1908: l_dynamic_cursor := dbms_sql.open_cursor;
1909: hr_utility.set_location(l_proc, 30);
1910: --
1911: -- Parse dynamic SQL
1912: dbms_sql.parse(l_dynamic_cursor, l_dynamic_sql, dbms_sql.v7);
1913: hr_utility.set_location(l_proc, 40);
1914: --
1915: -- Bind dynamic SQL variable
1916: dbms_sql.bind_variable(l_dynamic_cursor, ':p_api_hook_id', p_api_hook_id);

Line 1916: dbms_sql.bind_variable(l_dynamic_cursor, ':p_api_hook_id', p_api_hook_id);

1912: dbms_sql.parse(l_dynamic_cursor, l_dynamic_sql, dbms_sql.v7);
1913: hr_utility.set_location(l_proc, 40);
1914: --
1915: -- Bind dynamic SQL variable
1916: dbms_sql.bind_variable(l_dynamic_cursor, ':p_api_hook_id', p_api_hook_id);
1917: hr_utility.set_location(l_proc, 50);
1918: --
1919: -- Define dynamic SQL columns
1920: dbms_sql.define_column(l_dynamic_cursor, 1, l_api_hook_call_id);

Line 1920: dbms_sql.define_column(l_dynamic_cursor, 1, l_api_hook_call_id);

1916: dbms_sql.bind_variable(l_dynamic_cursor, ':p_api_hook_id', p_api_hook_id);
1917: hr_utility.set_location(l_proc, 50);
1918: --
1919: -- Define dynamic SQL columns
1920: dbms_sql.define_column(l_dynamic_cursor, 1, l_api_hook_call_id);
1921: dbms_sql.define_column(l_dynamic_cursor, 2, l_object_version_number);
1922: dbms_sql.define_column(l_dynamic_cursor, 3, l_call_package, 30);
1923: dbms_sql.define_column(l_dynamic_cursor, 4, l_call_procedure, 30);
1924: hr_utility.set_location(l_proc, 60);

Line 1921: dbms_sql.define_column(l_dynamic_cursor, 2, l_object_version_number);

1917: hr_utility.set_location(l_proc, 50);
1918: --
1919: -- Define dynamic SQL columns
1920: dbms_sql.define_column(l_dynamic_cursor, 1, l_api_hook_call_id);
1921: dbms_sql.define_column(l_dynamic_cursor, 2, l_object_version_number);
1922: dbms_sql.define_column(l_dynamic_cursor, 3, l_call_package, 30);
1923: dbms_sql.define_column(l_dynamic_cursor, 4, l_call_procedure, 30);
1924: hr_utility.set_location(l_proc, 60);
1925: --

Line 1922: dbms_sql.define_column(l_dynamic_cursor, 3, l_call_package, 30);

1918: --
1919: -- Define dynamic SQL columns
1920: dbms_sql.define_column(l_dynamic_cursor, 1, l_api_hook_call_id);
1921: dbms_sql.define_column(l_dynamic_cursor, 2, l_object_version_number);
1922: dbms_sql.define_column(l_dynamic_cursor, 3, l_call_package, 30);
1923: dbms_sql.define_column(l_dynamic_cursor, 4, l_call_procedure, 30);
1924: hr_utility.set_location(l_proc, 60);
1925: --
1926: -- Execute and fetch dynamic SQL

Line 1923: dbms_sql.define_column(l_dynamic_cursor, 4, l_call_procedure, 30);

1919: -- Define dynamic SQL columns
1920: dbms_sql.define_column(l_dynamic_cursor, 1, l_api_hook_call_id);
1921: dbms_sql.define_column(l_dynamic_cursor, 2, l_object_version_number);
1922: dbms_sql.define_column(l_dynamic_cursor, 3, l_call_package, 30);
1923: dbms_sql.define_column(l_dynamic_cursor, 4, l_call_procedure, 30);
1924: hr_utility.set_location(l_proc, 60);
1925: --
1926: -- Execute and fetch dynamic SQL
1927: --

Line 1929: l_execute := dbms_sql.execute(l_dynamic_cursor);

1925: --
1926: -- Execute and fetch dynamic SQL
1927: --
1928: l_first_cus_call := true;
1929: l_execute := dbms_sql.execute(l_dynamic_cursor);
1930: hr_utility.set_location(l_proc, 70);
1931: while dbms_sql.fetch_rows(l_dynamic_cursor) > 0 loop
1932: --
1933: -- Get the column values for the current row

Line 1931: while dbms_sql.fetch_rows(l_dynamic_cursor) > 0 loop

1927: --
1928: l_first_cus_call := true;
1929: l_execute := dbms_sql.execute(l_dynamic_cursor);
1930: hr_utility.set_location(l_proc, 70);
1931: while dbms_sql.fetch_rows(l_dynamic_cursor) > 0 loop
1932: --
1933: -- Get the column values for the current row
1934: --
1935: dbms_sql.column_value(l_dynamic_cursor, 1, l_api_hook_call_id);

Line 1935: dbms_sql.column_value(l_dynamic_cursor, 1, l_api_hook_call_id);

1931: while dbms_sql.fetch_rows(l_dynamic_cursor) > 0 loop
1932: --
1933: -- Get the column values for the current row
1934: --
1935: dbms_sql.column_value(l_dynamic_cursor, 1, l_api_hook_call_id);
1936: dbms_sql.column_value(l_dynamic_cursor, 2, l_object_version_number);
1937: dbms_sql.column_value(l_dynamic_cursor, 3, l_call_package);
1938: dbms_sql.column_value(l_dynamic_cursor, 4, l_call_procedure);
1939: if l_first_cus_call then

Line 1936: dbms_sql.column_value(l_dynamic_cursor, 2, l_object_version_number);

1932: --
1933: -- Get the column values for the current row
1934: --
1935: dbms_sql.column_value(l_dynamic_cursor, 1, l_api_hook_call_id);
1936: dbms_sql.column_value(l_dynamic_cursor, 2, l_object_version_number);
1937: dbms_sql.column_value(l_dynamic_cursor, 3, l_call_package);
1938: dbms_sql.column_value(l_dynamic_cursor, 4, l_call_procedure);
1939: if l_first_cus_call then
1940: --

Line 1937: dbms_sql.column_value(l_dynamic_cursor, 3, l_call_package);

1933: -- Get the column values for the current row
1934: --
1935: dbms_sql.column_value(l_dynamic_cursor, 1, l_api_hook_call_id);
1936: dbms_sql.column_value(l_dynamic_cursor, 2, l_object_version_number);
1937: dbms_sql.column_value(l_dynamic_cursor, 3, l_call_package);
1938: dbms_sql.column_value(l_dynamic_cursor, 4, l_call_procedure);
1939: if l_first_cus_call then
1940: --
1941: -- Add support call to allow for customer hook switch off

Line 1938: dbms_sql.column_value(l_dynamic_cursor, 4, l_call_procedure);

1934: --
1935: dbms_sql.column_value(l_dynamic_cursor, 1, l_api_hook_call_id);
1936: dbms_sql.column_value(l_dynamic_cursor, 2, l_object_version_number);
1937: dbms_sql.column_value(l_dynamic_cursor, 3, l_call_package);
1938: dbms_sql.column_value(l_dynamic_cursor, 4, l_call_procedure);
1939: if l_first_cus_call then
1940: --
1941: -- Add support call to allow for customer hook switch off
1942: --

Line 1965: dbms_sql.close_cursor(l_dynamic_cursor);

1961: hr_utility.set_location(l_proc, 90);
1962: --
1963: -- Close Dynamic Cursor
1964: --
1965: dbms_sql.close_cursor(l_dynamic_cursor);
1966: --
1967: -- Close the support if statement
1968: --
1969: if not l_first_cus_call then

Line 1979: if dbms_sql.is_open(l_dynamic_cursor) then

1975: -- In case of an unexpected error ensure
1976: -- that the Dynamic Cursor is closed.
1977: --
1978: when others then
1979: if dbms_sql.is_open(l_dynamic_cursor) then
1980: dbms_sql.close_cursor(l_dynamic_cursor);
1981: end if;
1982: raise;
1983: end make_customer_calls;

Line 1980: dbms_sql.close_cursor(l_dynamic_cursor);

1976: -- that the Dynamic Cursor is closed.
1977: --
1978: when others then
1979: if dbms_sql.is_open(l_dynamic_cursor) then
1980: dbms_sql.close_cursor(l_dynamic_cursor);
1981: end if;
1982: raise;
1983: end make_customer_calls;
1984: --