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_DYNSQL dependencies on DBMS_SQL

Line 1836: sql_cur := dbms_sql.open_cursor;

1832: end if;
1833: --
1834: statem := 'BEGIN '||range_proc||'(:pactid, :sqlstr); END;';
1835: --
1836: sql_cur := dbms_sql.open_cursor;
1837: dbms_sql.parse(sql_cur,
1838: statem,
1839: dbms_sql.v7);
1840: dbms_sql.bind_variable(sql_cur, ':pactid', pactid);

Line 1837: dbms_sql.parse(sql_cur,

1833: --
1834: statem := 'BEGIN '||range_proc||'(:pactid, :sqlstr); END;';
1835: --
1836: sql_cur := dbms_sql.open_cursor;
1837: dbms_sql.parse(sql_cur,
1838: statem,
1839: dbms_sql.v7);
1840: dbms_sql.bind_variable(sql_cur, ':pactid', pactid);
1841: dbms_sql.bind_variable(sql_cur, ':sqlstr', sqlstr, max_dynsql_len);

Line 1839: dbms_sql.v7);

1835: --
1836: sql_cur := dbms_sql.open_cursor;
1837: dbms_sql.parse(sql_cur,
1838: statem,
1839: dbms_sql.v7);
1840: dbms_sql.bind_variable(sql_cur, ':pactid', pactid);
1841: dbms_sql.bind_variable(sql_cur, ':sqlstr', sqlstr, max_dynsql_len);
1842: ignore := dbms_sql.execute(sql_cur);
1843: dbms_sql.variable_value(sql_cur, ':sqlstr', sqlstr);

Line 1840: dbms_sql.bind_variable(sql_cur, ':pactid', pactid);

1836: sql_cur := dbms_sql.open_cursor;
1837: dbms_sql.parse(sql_cur,
1838: statem,
1839: dbms_sql.v7);
1840: dbms_sql.bind_variable(sql_cur, ':pactid', pactid);
1841: dbms_sql.bind_variable(sql_cur, ':sqlstr', sqlstr, max_dynsql_len);
1842: ignore := dbms_sql.execute(sql_cur);
1843: dbms_sql.variable_value(sql_cur, ':sqlstr', sqlstr);
1844: dbms_sql.close_cursor(sql_cur);

Line 1841: dbms_sql.bind_variable(sql_cur, ':sqlstr', sqlstr, max_dynsql_len);

1837: dbms_sql.parse(sql_cur,
1838: statem,
1839: dbms_sql.v7);
1840: dbms_sql.bind_variable(sql_cur, ':pactid', pactid);
1841: dbms_sql.bind_variable(sql_cur, ':sqlstr', sqlstr, max_dynsql_len);
1842: ignore := dbms_sql.execute(sql_cur);
1843: dbms_sql.variable_value(sql_cur, ':sqlstr', sqlstr);
1844: dbms_sql.close_cursor(sql_cur);
1845: --

Line 1842: ignore := dbms_sql.execute(sql_cur);

1838: statem,
1839: dbms_sql.v7);
1840: dbms_sql.bind_variable(sql_cur, ':pactid', pactid);
1841: dbms_sql.bind_variable(sql_cur, ':sqlstr', sqlstr, max_dynsql_len);
1842: ignore := dbms_sql.execute(sql_cur);
1843: dbms_sql.variable_value(sql_cur, ':sqlstr', sqlstr);
1844: dbms_sql.close_cursor(sql_cur);
1845: --
1846: return;

Line 1843: dbms_sql.variable_value(sql_cur, ':sqlstr', sqlstr);

1839: dbms_sql.v7);
1840: dbms_sql.bind_variable(sql_cur, ':pactid', pactid);
1841: dbms_sql.bind_variable(sql_cur, ':sqlstr', sqlstr, max_dynsql_len);
1842: ignore := dbms_sql.execute(sql_cur);
1843: dbms_sql.variable_value(sql_cur, ':sqlstr', sqlstr);
1844: dbms_sql.close_cursor(sql_cur);
1845: --
1846: return;
1847: --

Line 1844: dbms_sql.close_cursor(sql_cur);

1840: dbms_sql.bind_variable(sql_cur, ':pactid', pactid);
1841: dbms_sql.bind_variable(sql_cur, ':sqlstr', sqlstr, max_dynsql_len);
1842: ignore := dbms_sql.execute(sql_cur);
1843: dbms_sql.variable_value(sql_cur, ':sqlstr', sqlstr);
1844: dbms_sql.close_cursor(sql_cur);
1845: --
1846: return;
1847: --
1848: exception

Line 1850: if (dbms_sql.is_open(sql_cur)) then

1846: return;
1847: --
1848: exception
1849: when others then
1850: if (dbms_sql.is_open(sql_cur)) then
1851: dbms_sql.close_cursor(sql_cur);
1852: end if;
1853: raise;
1854: end archive_range;

Line 1851: dbms_sql.close_cursor(sql_cur);

1847: --
1848: exception
1849: when others then
1850: if (dbms_sql.is_open(sql_cur)) then
1851: dbms_sql.close_cursor(sql_cur);
1852: end if;
1853: raise;
1854: end archive_range;
1855: --

Line 1944: sql_cursor := dbms_sql.open_cursor;

1940: p_assignment_id =>:p_assignment_id,
1941: p_effective_date => :p_effective_date,
1942: p_local_unit_id => :l_local_unit_id); end;';
1943: --
1944: sql_cursor := dbms_sql.open_cursor;
1945: dbms_sql.parse(sql_cursor, plsql_state, dbms_sql.v7);
1946: dbms_sql.bind_variable(sql_cursor, 'p_assignment_id', p_assignment_id);
1947: dbms_sql.bind_variable(sql_cursor, 'p_effective_date', p_effective_date);
1948: dbms_sql.bind_variable(sql_cursor, 'l_local_unit_id', l_local_unit_id);

Line 1945: dbms_sql.parse(sql_cursor, plsql_state, dbms_sql.v7);

1941: p_effective_date => :p_effective_date,
1942: p_local_unit_id => :l_local_unit_id); end;';
1943: --
1944: sql_cursor := dbms_sql.open_cursor;
1945: dbms_sql.parse(sql_cursor, plsql_state, dbms_sql.v7);
1946: dbms_sql.bind_variable(sql_cursor, 'p_assignment_id', p_assignment_id);
1947: dbms_sql.bind_variable(sql_cursor, 'p_effective_date', p_effective_date);
1948: dbms_sql.bind_variable(sql_cursor, 'l_local_unit_id', l_local_unit_id);
1949: l_rows := dbms_sql.execute(sql_cursor);

Line 1946: dbms_sql.bind_variable(sql_cursor, 'p_assignment_id', p_assignment_id);

1942: p_local_unit_id => :l_local_unit_id); end;';
1943: --
1944: sql_cursor := dbms_sql.open_cursor;
1945: dbms_sql.parse(sql_cursor, plsql_state, dbms_sql.v7);
1946: dbms_sql.bind_variable(sql_cursor, 'p_assignment_id', p_assignment_id);
1947: dbms_sql.bind_variable(sql_cursor, 'p_effective_date', p_effective_date);
1948: dbms_sql.bind_variable(sql_cursor, 'l_local_unit_id', l_local_unit_id);
1949: l_rows := dbms_sql.execute(sql_cursor);
1950: if (l_rows = 1) then

Line 1947: dbms_sql.bind_variable(sql_cursor, 'p_effective_date', p_effective_date);

1943: --
1944: sql_cursor := dbms_sql.open_cursor;
1945: dbms_sql.parse(sql_cursor, plsql_state, dbms_sql.v7);
1946: dbms_sql.bind_variable(sql_cursor, 'p_assignment_id', p_assignment_id);
1947: dbms_sql.bind_variable(sql_cursor, 'p_effective_date', p_effective_date);
1948: dbms_sql.bind_variable(sql_cursor, 'l_local_unit_id', l_local_unit_id);
1949: l_rows := dbms_sql.execute(sql_cursor);
1950: if (l_rows = 1) then
1951: dbms_sql.variable_value(sql_cursor, 'l_local_unit_id',

Line 1948: dbms_sql.bind_variable(sql_cursor, 'l_local_unit_id', l_local_unit_id);

1944: sql_cursor := dbms_sql.open_cursor;
1945: dbms_sql.parse(sql_cursor, plsql_state, dbms_sql.v7);
1946: dbms_sql.bind_variable(sql_cursor, 'p_assignment_id', p_assignment_id);
1947: dbms_sql.bind_variable(sql_cursor, 'p_effective_date', p_effective_date);
1948: dbms_sql.bind_variable(sql_cursor, 'l_local_unit_id', l_local_unit_id);
1949: l_rows := dbms_sql.execute(sql_cursor);
1950: if (l_rows = 1) then
1951: dbms_sql.variable_value(sql_cursor, 'l_local_unit_id',
1952: l_local_unit_id);

Line 1949: l_rows := dbms_sql.execute(sql_cursor);

1945: dbms_sql.parse(sql_cursor, plsql_state, dbms_sql.v7);
1946: dbms_sql.bind_variable(sql_cursor, 'p_assignment_id', p_assignment_id);
1947: dbms_sql.bind_variable(sql_cursor, 'p_effective_date', p_effective_date);
1948: dbms_sql.bind_variable(sql_cursor, 'l_local_unit_id', l_local_unit_id);
1949: l_rows := dbms_sql.execute(sql_cursor);
1950: if (l_rows = 1) then
1951: dbms_sql.variable_value(sql_cursor, 'l_local_unit_id',
1952: l_local_unit_id);
1953: dbms_sql.close_cursor(sql_cursor);

Line 1951: dbms_sql.variable_value(sql_cursor, 'l_local_unit_id',

1947: dbms_sql.bind_variable(sql_cursor, 'p_effective_date', p_effective_date);
1948: dbms_sql.bind_variable(sql_cursor, 'l_local_unit_id', l_local_unit_id);
1949: l_rows := dbms_sql.execute(sql_cursor);
1950: if (l_rows = 1) then
1951: dbms_sql.variable_value(sql_cursor, 'l_local_unit_id',
1952: l_local_unit_id);
1953: dbms_sql.close_cursor(sql_cursor);
1954: --
1955: else

Line 1953: dbms_sql.close_cursor(sql_cursor);

1949: l_rows := dbms_sql.execute(sql_cursor);
1950: if (l_rows = 1) then
1951: dbms_sql.variable_value(sql_cursor, 'l_local_unit_id',
1952: l_local_unit_id);
1953: dbms_sql.close_cursor(sql_cursor);
1954: --
1955: else
1956: l_local_unit_id := null;
1957: dbms_sql.close_cursor(sql_cursor);

Line 1957: dbms_sql.close_cursor(sql_cursor);

1953: dbms_sql.close_cursor(sql_cursor);
1954: --
1955: else
1956: l_local_unit_id := null;
1957: dbms_sql.close_cursor(sql_cursor);
1958: end if;
1959: end if;
1960:
1961: --

Line 2115: sql_cursor := dbms_sql.open_cursor;

2111: p_assignment_id =>:p_assignment_id,
2112: p_effective_date => :p_effective_date,
2113: p_tax_unit_id => :l_tax_unit_id); end;';
2114: --
2115: sql_cursor := dbms_sql.open_cursor;
2116: dbms_sql.parse(sql_cursor, plsql_state, dbms_sql.v7);
2117: dbms_sql.bind_variable(sql_cursor, 'p_assignment_id', p_assignment_id);
2118: dbms_sql.bind_variable(sql_cursor, 'p_effective_date', p_effective_date);
2119: dbms_sql.bind_variable(sql_cursor, 'l_tax_unit_id', l_tax_unit_id);

Line 2116: dbms_sql.parse(sql_cursor, plsql_state, dbms_sql.v7);

2112: p_effective_date => :p_effective_date,
2113: p_tax_unit_id => :l_tax_unit_id); end;';
2114: --
2115: sql_cursor := dbms_sql.open_cursor;
2116: dbms_sql.parse(sql_cursor, plsql_state, dbms_sql.v7);
2117: dbms_sql.bind_variable(sql_cursor, 'p_assignment_id', p_assignment_id);
2118: dbms_sql.bind_variable(sql_cursor, 'p_effective_date', p_effective_date);
2119: dbms_sql.bind_variable(sql_cursor, 'l_tax_unit_id', l_tax_unit_id);
2120: l_rows := dbms_sql.execute(sql_cursor);

Line 2117: dbms_sql.bind_variable(sql_cursor, 'p_assignment_id', p_assignment_id);

2113: p_tax_unit_id => :l_tax_unit_id); end;';
2114: --
2115: sql_cursor := dbms_sql.open_cursor;
2116: dbms_sql.parse(sql_cursor, plsql_state, dbms_sql.v7);
2117: dbms_sql.bind_variable(sql_cursor, 'p_assignment_id', p_assignment_id);
2118: dbms_sql.bind_variable(sql_cursor, 'p_effective_date', p_effective_date);
2119: dbms_sql.bind_variable(sql_cursor, 'l_tax_unit_id', l_tax_unit_id);
2120: l_rows := dbms_sql.execute(sql_cursor);
2121: if (l_rows = 1) then

Line 2118: dbms_sql.bind_variable(sql_cursor, 'p_effective_date', p_effective_date);

2114: --
2115: sql_cursor := dbms_sql.open_cursor;
2116: dbms_sql.parse(sql_cursor, plsql_state, dbms_sql.v7);
2117: dbms_sql.bind_variable(sql_cursor, 'p_assignment_id', p_assignment_id);
2118: dbms_sql.bind_variable(sql_cursor, 'p_effective_date', p_effective_date);
2119: dbms_sql.bind_variable(sql_cursor, 'l_tax_unit_id', l_tax_unit_id);
2120: l_rows := dbms_sql.execute(sql_cursor);
2121: if (l_rows = 1) then
2122: dbms_sql.variable_value(sql_cursor, 'l_tax_unit_id',

Line 2119: dbms_sql.bind_variable(sql_cursor, 'l_tax_unit_id', l_tax_unit_id);

2115: sql_cursor := dbms_sql.open_cursor;
2116: dbms_sql.parse(sql_cursor, plsql_state, dbms_sql.v7);
2117: dbms_sql.bind_variable(sql_cursor, 'p_assignment_id', p_assignment_id);
2118: dbms_sql.bind_variable(sql_cursor, 'p_effective_date', p_effective_date);
2119: dbms_sql.bind_variable(sql_cursor, 'l_tax_unit_id', l_tax_unit_id);
2120: l_rows := dbms_sql.execute(sql_cursor);
2121: if (l_rows = 1) then
2122: dbms_sql.variable_value(sql_cursor, 'l_tax_unit_id',
2123: l_tax_unit_id);

Line 2120: l_rows := dbms_sql.execute(sql_cursor);

2116: dbms_sql.parse(sql_cursor, plsql_state, dbms_sql.v7);
2117: dbms_sql.bind_variable(sql_cursor, 'p_assignment_id', p_assignment_id);
2118: dbms_sql.bind_variable(sql_cursor, 'p_effective_date', p_effective_date);
2119: dbms_sql.bind_variable(sql_cursor, 'l_tax_unit_id', l_tax_unit_id);
2120: l_rows := dbms_sql.execute(sql_cursor);
2121: if (l_rows = 1) then
2122: dbms_sql.variable_value(sql_cursor, 'l_tax_unit_id',
2123: l_tax_unit_id);
2124: dbms_sql.close_cursor(sql_cursor);

Line 2122: dbms_sql.variable_value(sql_cursor, 'l_tax_unit_id',

2118: dbms_sql.bind_variable(sql_cursor, 'p_effective_date', p_effective_date);
2119: dbms_sql.bind_variable(sql_cursor, 'l_tax_unit_id', l_tax_unit_id);
2120: l_rows := dbms_sql.execute(sql_cursor);
2121: if (l_rows = 1) then
2122: dbms_sql.variable_value(sql_cursor, 'l_tax_unit_id',
2123: l_tax_unit_id);
2124: dbms_sql.close_cursor(sql_cursor);
2125: --
2126: else

Line 2124: dbms_sql.close_cursor(sql_cursor);

2120: l_rows := dbms_sql.execute(sql_cursor);
2121: if (l_rows = 1) then
2122: dbms_sql.variable_value(sql_cursor, 'l_tax_unit_id',
2123: l_tax_unit_id);
2124: dbms_sql.close_cursor(sql_cursor);
2125: --
2126: else
2127: l_tax_unit_id := null;
2128: dbms_sql.close_cursor(sql_cursor);

Line 2128: dbms_sql.close_cursor(sql_cursor);

2124: dbms_sql.close_cursor(sql_cursor);
2125: --
2126: else
2127: l_tax_unit_id := null;
2128: dbms_sql.close_cursor(sql_cursor);
2129: end if;
2130:
2131: end if;
2132: --