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.

[Home] [Help]

APPS.HR_GENERAL dependencies on DBMS_DESCRIBE

Line 148: DBMS_DESCRIBE.DESCRIBE_PROCEDURE to

144: mbocutt 06/06/2000 115.29 Fixed error in function descriptions
145: for get_work/home_phone
146: tclewis 29-feb-2000 115.30 added function maintain_tax_Records.
147: arashid 13-OCT-00 115.22 Added a cover routine for:
148: DBMS_DESCRIBE.DESCRIBE_PROCEDURE to
149: compile an invalid package. The new
150: routine is called: DESCRIBE_PROCEDURE
151: pattwood 16-NOV-2000 115.32 Changed DESCRIBE_PROCEDURE so it
152: only attempts to compile the package

Line 228: -- Invalid package exception returned from DBMS_DESCRIBE.DESCRIBE_PROCEDURE.

224:
225: --------------------------------------------------------------------------------
226: */
227: --
228: -- Invalid package exception returned from DBMS_DESCRIBE.DESCRIBE_PROCEDURE.
229: --
230: invalid_package exception;
231: pragma exception_init(invalid_package, -20003);
232: --

Line 256: ,overload out nocopy dbms_describe.number_table

252: procedure describe_procedure
253: (object_name in varchar2
254: ,reserved1 in varchar2
255: ,reserved2 in varchar2
256: ,overload out nocopy dbms_describe.number_table
257: ,position out nocopy dbms_describe.number_table
258: ,level out nocopy dbms_describe.number_table
259: ,argument_name out nocopy dbms_describe.varchar2_table
260: ,datatype out nocopy dbms_describe.number_table

Line 257: ,position out nocopy dbms_describe.number_table

253: (object_name in varchar2
254: ,reserved1 in varchar2
255: ,reserved2 in varchar2
256: ,overload out nocopy dbms_describe.number_table
257: ,position out nocopy dbms_describe.number_table
258: ,level out nocopy dbms_describe.number_table
259: ,argument_name out nocopy dbms_describe.varchar2_table
260: ,datatype out nocopy dbms_describe.number_table
261: ,default_value out nocopy dbms_describe.number_table

Line 258: ,level out nocopy dbms_describe.number_table

254: ,reserved1 in varchar2
255: ,reserved2 in varchar2
256: ,overload out nocopy dbms_describe.number_table
257: ,position out nocopy dbms_describe.number_table
258: ,level out nocopy dbms_describe.number_table
259: ,argument_name out nocopy dbms_describe.varchar2_table
260: ,datatype out nocopy dbms_describe.number_table
261: ,default_value out nocopy dbms_describe.number_table
262: ,in_out out nocopy dbms_describe.number_table

Line 259: ,argument_name out nocopy dbms_describe.varchar2_table

255: ,reserved2 in varchar2
256: ,overload out nocopy dbms_describe.number_table
257: ,position out nocopy dbms_describe.number_table
258: ,level out nocopy dbms_describe.number_table
259: ,argument_name out nocopy dbms_describe.varchar2_table
260: ,datatype out nocopy dbms_describe.number_table
261: ,default_value out nocopy dbms_describe.number_table
262: ,in_out out nocopy dbms_describe.number_table
263: ,length out nocopy dbms_describe.number_table

Line 260: ,datatype out nocopy dbms_describe.number_table

256: ,overload out nocopy dbms_describe.number_table
257: ,position out nocopy dbms_describe.number_table
258: ,level out nocopy dbms_describe.number_table
259: ,argument_name out nocopy dbms_describe.varchar2_table
260: ,datatype out nocopy dbms_describe.number_table
261: ,default_value out nocopy dbms_describe.number_table
262: ,in_out out nocopy dbms_describe.number_table
263: ,length out nocopy dbms_describe.number_table
264: ,precision out nocopy dbms_describe.number_table

Line 261: ,default_value out nocopy dbms_describe.number_table

257: ,position out nocopy dbms_describe.number_table
258: ,level out nocopy dbms_describe.number_table
259: ,argument_name out nocopy dbms_describe.varchar2_table
260: ,datatype out nocopy dbms_describe.number_table
261: ,default_value out nocopy dbms_describe.number_table
262: ,in_out out nocopy dbms_describe.number_table
263: ,length out nocopy dbms_describe.number_table
264: ,precision out nocopy dbms_describe.number_table
265: ,scale out nocopy dbms_describe.number_table

Line 262: ,in_out out nocopy dbms_describe.number_table

258: ,level out nocopy dbms_describe.number_table
259: ,argument_name out nocopy dbms_describe.varchar2_table
260: ,datatype out nocopy dbms_describe.number_table
261: ,default_value out nocopy dbms_describe.number_table
262: ,in_out out nocopy dbms_describe.number_table
263: ,length out nocopy dbms_describe.number_table
264: ,precision out nocopy dbms_describe.number_table
265: ,scale out nocopy dbms_describe.number_table
266: ,radix out nocopy dbms_describe.number_table

Line 263: ,length out nocopy dbms_describe.number_table

259: ,argument_name out nocopy dbms_describe.varchar2_table
260: ,datatype out nocopy dbms_describe.number_table
261: ,default_value out nocopy dbms_describe.number_table
262: ,in_out out nocopy dbms_describe.number_table
263: ,length out nocopy dbms_describe.number_table
264: ,precision out nocopy dbms_describe.number_table
265: ,scale out nocopy dbms_describe.number_table
266: ,radix out nocopy dbms_describe.number_table
267: ,spare out nocopy dbms_describe.number_table

Line 264: ,precision out nocopy dbms_describe.number_table

260: ,datatype out nocopy dbms_describe.number_table
261: ,default_value out nocopy dbms_describe.number_table
262: ,in_out out nocopy dbms_describe.number_table
263: ,length out nocopy dbms_describe.number_table
264: ,precision out nocopy dbms_describe.number_table
265: ,scale out nocopy dbms_describe.number_table
266: ,radix out nocopy dbms_describe.number_table
267: ,spare out nocopy dbms_describe.number_table
268: ) is

Line 265: ,scale out nocopy dbms_describe.number_table

261: ,default_value out nocopy dbms_describe.number_table
262: ,in_out out nocopy dbms_describe.number_table
263: ,length out nocopy dbms_describe.number_table
264: ,precision out nocopy dbms_describe.number_table
265: ,scale out nocopy dbms_describe.number_table
266: ,radix out nocopy dbms_describe.number_table
267: ,spare out nocopy dbms_describe.number_table
268: ) is
269: l_package varchar2(128);

Line 266: ,radix out nocopy dbms_describe.number_table

262: ,in_out out nocopy dbms_describe.number_table
263: ,length out nocopy dbms_describe.number_table
264: ,precision out nocopy dbms_describe.number_table
265: ,scale out nocopy dbms_describe.number_table
266: ,radix out nocopy dbms_describe.number_table
267: ,spare out nocopy dbms_describe.number_table
268: ) is
269: l_package varchar2(128);
270: l_dotpos number;

Line 267: ,spare out nocopy dbms_describe.number_table

263: ,length out nocopy dbms_describe.number_table
264: ,precision out nocopy dbms_describe.number_table
265: ,scale out nocopy dbms_describe.number_table
266: ,radix out nocopy dbms_describe.number_table
267: ,spare out nocopy dbms_describe.number_table
268: ) is
269: l_package varchar2(128);
270: l_dotpos number;
271: compile boolean := false;

Line 277: dbms_describe.describe_procedure

273: l_rows integer;
274: begin
275: loop
276: begin
277: dbms_describe.describe_procedure
278: (object_name => object_name
279: ,reserved1 => reserved1
280: ,reserved2 => reserved2
281: ,overload => overload

Line 348: -- DBMS_DESCRIBE.DESCRIBE_PROCEDURE succeeded so exit the loop.

344: --
345: raise invalid_package;
346: end;
347: --
348: -- DBMS_DESCRIBE.DESCRIBE_PROCEDURE succeeded so exit the loop.
349: --
350: else
351: exit;
352: end if;