1 PACKAGE hr_api_params AUTHID CURRENT_USER AS
2 /* $Header: hrapiprm.pkh 115.1 2002/11/29 12:22:03 apholt ship $ */
3
4 -- ---------------------------------------------------------------------------
5 -- |-------------------------< set_up_param_info >---------------------------|
6 -- ---------------------------------------------------------------------------
7 -- {Start of comments}
8 --
9 -- Description:
10 -- Makes the call to the packaged procedure dbms_describe.describe_procedure,
11 -- which will create tables holding the details of the given procedure from
12 -- the given package. This procedure takes this information, and stores it
13 -- globally, thus making it retrievable by the retrieve_param_details
14 -- procedure.
15 --
16 -- Should the package not exist, or indeed the procedure not exist within the
17 -- package, then p_exists will be set appropriately.
18 --
19 -- Pre-Requisites:
20 -- Called from the form, prior to attempting to retieve parameter details.
21 --
22 -- In Parameters:
23 -- p_pkg_name -> The name of the package, in which the procedure exists.
24 -- p_proc_name -> The name of the procedure whose parameter details we are
25 -- trying to retrieve.
26 --
27 -- Out Parameters:
28 -- None.
29 --
30 -- Post Success:
31 -- The appropriate parameter details will be held in global variables.
32 --
33 -- Post Failure:
34 -- None.
35 --
36 -- Developer Implementation Notes:
37 -- None
38 --
39 -- Access Status:
40 -- Internal Development Use Only.
41 --
42 -- {End Of Comments}
43 -- ---------------------------------------------------------------------------
44 procedure setup_param_info
45 (p_pkg_name in varchar2
46 ,p_proc_name in varchar2
47 );
48 -- ---------------------------------------------------------------------------
49 -- |----------------------< retrieve_param_details >-------------------------|
50 -- ---------------------------------------------------------------------------
51 -- {Start of comments}
52 --
53 -- Description:
54 -- This procedure will return the parameter details of the previously
55 -- specified procedure, from the previously specified package, having read
56 -- them from the global tables.
57 -- The last record will have its flag set appropriately.
58 --
59 -- Pre-Requisites:
60 -- Called from the form, only after the setup_param_info has
61 -- deposited info within the global tables.
62 --
63 -- In Parameters:
64 -- None
65 --
66 -- Out Parameters:
67 -- p_name* -> The name of the corresponding parameter for the specified
68 -- procedure.
69 -- p_in_out* -> A number, depending on whether the parameter is IN, OUT or
70 -- IN OUT.
71 -- p_datatype* -> A number, depending on the datatype of the parameter.
72 -- p_default* -> A number, depending on whether the parameter has a default
73 -- or not.
74 -- p_overload* -> A number which indicates whether the procedure is
75 -- overloaded or not.
76 --
77 -- p_last_param -> A flag, which is true when the last parameters details
78 -- have been dealt with (ie. copied from the global tables)
79 --
80 -- Post Success:
81 -- This procedure will have returned to the form, all possible parameter
82 -- details for the packaged procedure, as specified in setup_param_info.
83 --
84 -- Post Failure:
85 -- None.
86 --
87 -- Developer Implementation Notes:
88 -- None
89 --
90 -- Access Status:
91 -- Internal Development Use Only.
92 --
93 -- {End Of Comments}
94 -- ---------------------------------------------------------------------------
95 procedure retrieve_param_details
96 (p_name1 out nocopy varchar2
97 ,p_name2 out nocopy varchar2
98 ,p_name3 out nocopy varchar2
99 ,p_name4 out nocopy varchar2
100 ,p_name5 out nocopy varchar2
101 ,p_name6 out nocopy varchar2
102 ,p_name7 out nocopy varchar2
103 ,p_name8 out nocopy varchar2
104 ,p_name9 out nocopy varchar2
105 ,p_name10 out nocopy varchar2
106 ,p_in_out1 out nocopy number
107 ,p_in_out2 out nocopy number
108 ,p_in_out3 out nocopy number
109 ,p_in_out4 out nocopy number
110 ,p_in_out5 out nocopy number
111 ,p_in_out6 out nocopy number
112 ,p_in_out7 out nocopy number
113 ,p_in_out8 out nocopy number
114 ,p_in_out9 out nocopy number
115 ,p_in_out10 out nocopy number
116 ,p_datatype1 out nocopy number
117 ,p_datatype2 out nocopy number
118 ,p_datatype3 out nocopy number
119 ,p_datatype4 out nocopy number
120 ,p_datatype5 out nocopy number
121 ,p_datatype6 out nocopy number
122 ,p_datatype7 out nocopy number
123 ,p_datatype8 out nocopy number
124 ,p_datatype9 out nocopy number
125 ,p_datatype10 out nocopy number
126 ,p_default1 out nocopy number
127 ,p_default2 out nocopy number
128 ,p_default3 out nocopy number
129 ,p_default4 out nocopy number
130 ,p_default5 out nocopy number
131 ,p_default6 out nocopy number
132 ,p_default7 out nocopy number
133 ,p_default8 out nocopy number
134 ,p_default9 out nocopy number
135 ,p_default10 out nocopy number
136 ,p_overload1 out nocopy number
137 ,p_overload2 out nocopy number
138 ,p_overload3 out nocopy number
139 ,p_overload4 out nocopy number
140 ,p_overload5 out nocopy number
141 ,p_overload6 out nocopy number
142 ,p_overload7 out nocopy number
143 ,p_overload8 out nocopy number
144 ,p_overload9 out nocopy number
145 ,p_overload10 out nocopy number
146 ,p_last_param out nocopy boolean
147 );
148 procedure retrieve_param_details
149 (p_name1 out nocopy varchar2
150 ,p_name2 out nocopy varchar2
151 ,p_name3 out nocopy varchar2
152 ,p_name4 out nocopy varchar2
153 ,p_name5 out nocopy varchar2
154 ,p_name6 out nocopy varchar2
155 ,p_name7 out nocopy varchar2
156 ,p_name8 out nocopy varchar2
157 ,p_name9 out nocopy varchar2
158 ,p_name10 out nocopy varchar2
159 ,p_in_out1 out nocopy number
160 ,p_in_out2 out nocopy number
161 ,p_in_out3 out nocopy number
162 ,p_in_out4 out nocopy number
163 ,p_in_out5 out nocopy number
164 ,p_in_out6 out nocopy number
165 ,p_in_out7 out nocopy number
166 ,p_in_out8 out nocopy number
167 ,p_in_out9 out nocopy number
168 ,p_in_out10 out nocopy number
169 ,p_datatype1 out nocopy number
170 ,p_datatype2 out nocopy number
171 ,p_datatype3 out nocopy number
172 ,p_datatype4 out nocopy number
173 ,p_datatype5 out nocopy number
174 ,p_datatype6 out nocopy number
175 ,p_datatype7 out nocopy number
176 ,p_datatype8 out nocopy number
177 ,p_datatype9 out nocopy number
178 ,p_datatype10 out nocopy number
179 ,p_default1 out nocopy number
180 ,p_default2 out nocopy number
181 ,p_default3 out nocopy number
182 ,p_default4 out nocopy number
183 ,p_default5 out nocopy number
184 ,p_default6 out nocopy number
185 ,p_default7 out nocopy number
186 ,p_default8 out nocopy number
187 ,p_default9 out nocopy number
188 ,p_default10 out nocopy number
189 ,p_overload1 out nocopy number
190 ,p_overload2 out nocopy number
191 ,p_overload3 out nocopy number
192 ,p_overload4 out nocopy number
193 ,p_overload5 out nocopy number
194 ,p_overload6 out nocopy number
195 ,p_overload7 out nocopy number
196 ,p_overload8 out nocopy number
197 ,p_overload9 out nocopy number
198 ,p_overload10 out nocopy number
199 ,p_last_param out nocopy number
200 );
201 end hr_api_params;