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.FF_WRAPPER_SUP_PKG dependencies on DBMS_SQL

Line 293: ,p_chunks in out nocopy dbms_sql.varchar2s

289: -- Begin the wrapper body.
290: --
291: procedure start_wrapper_body
292: (p_pkg_name in varchar2
293: ,p_chunks in out nocopy dbms_sql.varchar2s
294: ) is
295: l_index binary_integer;
296: begin
297: l_index := p_chunks.count + 1;

Line 322: ,p_chunks in out nocopy dbms_sql.varchar2s

318: --
319: procedure end_wrapper_body
320: (p_package_name in varchar2
321: ,p_calls_added in boolean
322: ,p_chunks in out nocopy dbms_sql.varchar2s
323: ) is
324: l_index binary_integer;
325: begin
326: l_index := p_chunks.count + 1;

Line 700: l_chunks dbms_sql.varchar2s;

696: ,p_wrapper_num in varchar2
697: ,p_intermediates in boolean
698: ) is
699: l_debug boolean := hr_utility.debug_enabled;
700: l_chunks dbms_sql.varchar2s;
701: l_chunk_index binary_integer := 1;
702: l_range_start boolean;
703: l_range_size number;
704: l_end_range number;

Line 906: l_csr_sql := dbms_sql.open_cursor;

902: hr_utility.trace('Text complete, create package body...');
903: end if;
904:
905: begin
906: l_csr_sql := dbms_sql.open_cursor;
907: dbms_sql.parse
908: (l_csr_sql, l_chunks, 1, l_chunks.count, false, dbms_sql.native);
909: l_rows := dbms_sql.execute(l_csr_sql);
910: dbms_sql.close_cursor(l_csr_sql);

Line 907: dbms_sql.parse

903: end if;
904:
905: begin
906: l_csr_sql := dbms_sql.open_cursor;
907: dbms_sql.parse
908: (l_csr_sql, l_chunks, 1, l_chunks.count, false, dbms_sql.native);
909: l_rows := dbms_sql.execute(l_csr_sql);
910: dbms_sql.close_cursor(l_csr_sql);
911: exception

Line 908: (l_csr_sql, l_chunks, 1, l_chunks.count, false, dbms_sql.native);

904:
905: begin
906: l_csr_sql := dbms_sql.open_cursor;
907: dbms_sql.parse
908: (l_csr_sql, l_chunks, 1, l_chunks.count, false, dbms_sql.native);
909: l_rows := dbms_sql.execute(l_csr_sql);
910: dbms_sql.close_cursor(l_csr_sql);
911: exception
912: when others then

Line 909: l_rows := dbms_sql.execute(l_csr_sql);

905: begin
906: l_csr_sql := dbms_sql.open_cursor;
907: dbms_sql.parse
908: (l_csr_sql, l_chunks, 1, l_chunks.count, false, dbms_sql.native);
909: l_rows := dbms_sql.execute(l_csr_sql);
910: dbms_sql.close_cursor(l_csr_sql);
911: exception
912: when others then
913: if dbms_sql.is_open(l_csr_sql) then

Line 910: dbms_sql.close_cursor(l_csr_sql);

906: l_csr_sql := dbms_sql.open_cursor;
907: dbms_sql.parse
908: (l_csr_sql, l_chunks, 1, l_chunks.count, false, dbms_sql.native);
909: l_rows := dbms_sql.execute(l_csr_sql);
910: dbms_sql.close_cursor(l_csr_sql);
911: exception
912: when others then
913: if dbms_sql.is_open(l_csr_sql) then
914: dbms_sql.close_cursor(l_csr_sql);

Line 913: if dbms_sql.is_open(l_csr_sql) then

909: l_rows := dbms_sql.execute(l_csr_sql);
910: dbms_sql.close_cursor(l_csr_sql);
911: exception
912: when others then
913: if dbms_sql.is_open(l_csr_sql) then
914: dbms_sql.close_cursor(l_csr_sql);
915: end if;
916: raise;
917: end;

Line 914: dbms_sql.close_cursor(l_csr_sql);

910: dbms_sql.close_cursor(l_csr_sql);
911: exception
912: when others then
913: if dbms_sql.is_open(l_csr_sql) then
914: dbms_sql.close_cursor(l_csr_sql);
915: end if;
916: raise;
917: end;
918: l_generated := true;

Line 1380: l_chunks dbms_sql.varchar2s;

1376: procedure create_wrapper is
1377: l_debug boolean := hr_utility.debug_enabled;
1378: l_range_tbl t_range_tbl;
1379: l_ff_info_tbl t_ff_info_tbl;
1380: l_chunks dbms_sql.varchar2s;
1381: l_csr_sql integer;
1382: l_rows number;
1383: begin
1384: if l_debug then