1 PACKAGE hr_api_utils AUTHID CURRENT_USER AS
2 /* $Header: hrapiutl.pkh 115.1 2002/11/29 12:22:34 apholt ship $ */
3 -- A procedure to parse the dynamic sql.
4 --
5 procedure call_parse(p_cursor IN OUT NOCOPY NUMBER
6 ,p_proc IN OUT NOCOPY varchar2
7 );
8 --
9 -- A procedure to bind a variable of type varchar2.
10 --
11 PROCEDURE bind_var(p_cursor IN NUMBER
12 ,p_bind_var IN VARCHAR2
13 ,p_out_val IN OUT NOCOPY VARCHAR2
14 );
15 --
16 -- A procedure to bind a variable of type number.
17 --
18 PROCEDURE bind_num(p_cursor IN NUMBER
19 ,p_bind_var IN VARCHAR2
20 ,p_out_val IN OUT NOCOPY NUMBER
21 );
22 --
23 -- A procedure to bind a variable of type date.
24 --
25 PROCEDURE bind_date(p_cursor IN NUMBER
26 ,p_bind_var IN VARCHAR2
27 ,p_out_val IN OUT NOCOPY DATE
28 );
29 --
30 -- A procedure to return a value from a bound variable of type varchar2.
31 --
32 PROCEDURE get_var(p_cursor IN NUMBER
33 ,p_bind_var IN VARCHAR2
34 ,p_out_val IN OUT NOCOPY VARCHAR2
35 );
36 --
37 -- A procedure to return a value from a bound variable of type number.
38 --
39 PROCEDURE get_num(p_cursor IN NUMBER
40 ,p_bind_var IN VARCHAR2
41 ,p_out_val IN OUT NOCOPY NUMBER
42 );
43 --
44 -- A procedure to return a value from a bound variable of type date.
45 --
46 PROCEDURE get_date(p_cursor IN NUMBER
47 ,p_bind_var IN VARCHAR2
48 ,p_out_val IN OUT NOCOPY DATE
49 );
50 --
51 --
52 end hr_api_utils;