1 package ams_approvers_pvt_w AUTHID CURRENT_USER as
2 /* $Header: amswaprs.pls 115.7 2002/12/29 08:44:57 vmodur ship $ */
3 procedure create_approvers(p_api_version NUMBER
4 , p_init_msg_list VARCHAR2
5 , p_commit VARCHAR2
6 , p_validation_level NUMBER
7 , x_return_status OUT NOCOPY VARCHAR2
8 , x_msg_count OUT NOCOPY NUMBER
9 , x_msg_data OUT NOCOPY VARCHAR2
10 , p7_a0 NUMBER
11 , p7_a1 DATE
12 , p7_a2 NUMBER
13 , p7_a3 DATE
14 , p7_a4 NUMBER
15 , p7_a5 NUMBER
16 , p7_a6 NUMBER
17 , p7_a7 NUMBER
18 , p7_a8 NUMBER
19 , p7_a9 NUMBER
20 , p7_a10 VARCHAR2
21 , p7_a11 NUMBER
22 , p7_a12 VARCHAR2
23 , p7_a13 NUMBER
24 , p7_a14 VARCHAR2
25 , p7_a15 VARCHAR2
26 , p7_a16 DATE
27 , p7_a17 DATE
28 , x_approver_id OUT NOCOPY NUMBER
29 );
30 procedure update_approvers(p_api_version NUMBER
31 , p_init_msg_list VARCHAR2
32 , p_commit VARCHAR2
33 , p_validation_level NUMBER
34 , x_return_status OUT NOCOPY VARCHAR2
35 , x_msg_count OUT NOCOPY NUMBER
36 , x_msg_data OUT NOCOPY VARCHAR2
37 , p7_a0 NUMBER
38 , p7_a1 DATE
39 , p7_a2 NUMBER
40 , p7_a3 DATE
41 , p7_a4 NUMBER
42 , p7_a5 NUMBER
43 , p7_a6 NUMBER
44 , p7_a7 NUMBER
45 , p7_a8 NUMBER
46 , p7_a9 NUMBER
47 , p7_a10 VARCHAR2
48 , p7_a11 NUMBER
49 , p7_a12 VARCHAR2
50 , p7_a13 NUMBER
51 , p7_a14 VARCHAR2
52 , p7_a15 VARCHAR2
53 , p7_a16 DATE
54 , p7_a17 DATE
55 );
56 procedure validate_approvers(p_api_version NUMBER
57 , p_init_msg_list VARCHAR2
58 , p_commit VARCHAR2
59 , p_validation_level NUMBER
60 , x_return_status OUT NOCOPY VARCHAR2
61 , x_msg_count OUT NOCOPY NUMBER
62 , x_msg_data OUT NOCOPY VARCHAR2
63 , p7_a0 NUMBER
64 , p7_a1 DATE
65 , p7_a2 NUMBER
66 , p7_a3 DATE
67 , p7_a4 NUMBER
68 , p7_a5 NUMBER
69 , p7_a6 NUMBER
70 , p7_a7 NUMBER
71 , p7_a8 NUMBER
72 , p7_a9 NUMBER
73 , p7_a10 VARCHAR2
74 , p7_a11 NUMBER
75 , p7_a12 VARCHAR2
76 , p7_a13 NUMBER
77 , p7_a14 VARCHAR2
78 , p7_a15 VARCHAR2
79 , p7_a16 DATE
80 , p7_a17 DATE
81 );
82 procedure check_approvers_items(p0_a0 NUMBER
83 , p0_a1 DATE
84 , p0_a2 NUMBER
85 , p0_a3 DATE
86 , p0_a4 NUMBER
87 , p0_a5 NUMBER
88 , p0_a6 NUMBER
89 , p0_a7 NUMBER
90 , p0_a8 NUMBER
91 , p0_a9 NUMBER
92 , p0_a10 VARCHAR2
93 , p0_a11 NUMBER
94 , p0_a12 VARCHAR2
95 , p0_a13 NUMBER
96 , p0_a14 VARCHAR2
97 , p0_a15 VARCHAR2
98 , p0_a16 DATE
99 , p0_a17 DATE
100 , p_validation_mode VARCHAR2
101 , x_return_status OUT NOCOPY VARCHAR2
102 );
103 procedure check_approvers_record(p0_a0 NUMBER
104 , p0_a1 DATE
105 , p0_a2 NUMBER
106 , p0_a3 DATE
107 , p0_a4 NUMBER
108 , p0_a5 NUMBER
109 , p0_a6 NUMBER
110 , p0_a7 NUMBER
111 , p0_a8 NUMBER
112 , p0_a9 NUMBER
113 , p0_a10 VARCHAR2
114 , p0_a11 NUMBER
115 , p0_a12 VARCHAR2
116 , p0_a13 NUMBER
117 , p0_a14 VARCHAR2
118 , p0_a15 VARCHAR2
119 , p0_a16 DATE
120 , p0_a17 DATE
121 , p1_a0 NUMBER
122 , p1_a1 DATE
123 , p1_a2 NUMBER
124 , p1_a3 DATE
125 , p1_a4 NUMBER
126 , p1_a5 NUMBER
127 , p1_a6 NUMBER
128 , p1_a7 NUMBER
129 , p1_a8 NUMBER
130 , p1_a9 NUMBER
131 , p1_a10 VARCHAR2
132 , p1_a11 NUMBER
133 , p1_a12 VARCHAR2
134 , p1_a13 NUMBER
135 , p1_a14 VARCHAR2
136 , p1_a15 VARCHAR2
137 , p1_a16 DATE
138 , p1_a17 DATE
139 , x_return_status OUT NOCOPY VARCHAR2
140 );
141 procedure init_approvers_rec(p0_a0 OUT NOCOPY NUMBER
142 , p0_a1 OUT NOCOPY DATE
143 , p0_a2 OUT NOCOPY NUMBER
144 , p0_a3 OUT NOCOPY DATE
145 , p0_a4 OUT NOCOPY NUMBER
146 , p0_a5 OUT NOCOPY NUMBER
147 , p0_a6 OUT NOCOPY NUMBER
148 , p0_a7 OUT NOCOPY NUMBER
149 , p0_a8 OUT NOCOPY NUMBER
150 , p0_a9 OUT NOCOPY NUMBER
151 , p0_a10 OUT NOCOPY VARCHAR2
152 , p0_a11 OUT NOCOPY NUMBER
153 , p0_a12 OUT NOCOPY VARCHAR2
154 , p0_a13 OUT NOCOPY NUMBER
155 , p0_a14 OUT NOCOPY VARCHAR2
156 , p0_a15 OUT NOCOPY VARCHAR2
157 , p0_a16 OUT NOCOPY DATE
158 , p0_a17 OUT NOCOPY DATE
159 );
160 procedure complete_approvers_rec(p0_a0 NUMBER
161 , p0_a1 DATE
162 , p0_a2 NUMBER
163 , p0_a3 DATE
164 , p0_a4 NUMBER
165 , p0_a5 NUMBER
166 , p0_a6 NUMBER
167 , p0_a7 NUMBER
168 , p0_a8 NUMBER
169 , p0_a9 NUMBER
170 , p0_a10 VARCHAR2
171 , p0_a11 NUMBER
172 , p0_a12 VARCHAR2
173 , p0_a13 NUMBER
174 , p0_a14 VARCHAR2
175 , p0_a15 VARCHAR2
176 , p0_a16 DATE
177 , p0_a17 DATE
178 , p1_a0 OUT NOCOPY NUMBER
179 , p1_a1 OUT NOCOPY DATE
180 , p1_a2 OUT NOCOPY NUMBER
181 , p1_a3 OUT NOCOPY DATE
182 , p1_a4 OUT NOCOPY NUMBER
183 , p1_a5 OUT NOCOPY NUMBER
184 , p1_a6 OUT NOCOPY NUMBER
185 , p1_a7 OUT NOCOPY NUMBER
186 , p1_a8 OUT NOCOPY NUMBER
187 , p1_a9 OUT NOCOPY NUMBER
188 , p1_a10 OUT NOCOPY VARCHAR2
189 , p1_a11 OUT NOCOPY NUMBER
190 , p1_a12 OUT NOCOPY VARCHAR2
191 , p1_a13 OUT NOCOPY NUMBER
192 , p1_a14 OUT NOCOPY VARCHAR2
193 , p1_a15 OUT NOCOPY VARCHAR2
194 , p1_a16 OUT NOCOPY DATE
195 , p1_a17 OUT NOCOPY DATE
196 );
197 end ams_approvers_pvt_w;