1 PACKAGE po_revision_differences AUTHID CURRENT_USER AS
2 /* $Header: POXPORVS.pls 115.1 2002/11/25 22:39:41 sbull ship $ */
3
4 /* Compare the entire PO */
5 PROCEDURE compare_po_to_all(
6 p_header_id IN NUMBER,
7 p_release_id IN NUMBER,
8 p_revision_num IN NUMBER,
9 p_dummy_in4 IN NUMBER DEFAULT NULL,
10 p_dummy_in5 IN NUMBER DEFAULT NULL,
11 p_dummy_in6 IN NUMBER DEFAULT NULL,
12 p_dummy_in7 IN NUMBER DEFAULT NULL,
13 p_dummy_in8 IN NUMBER DEFAULT NULL,
14 p_dummy_in9 IN NUMBER DEFAULT NULL,
15 p_dummy_in10 IN NUMBER DEFAULT NULL,
16 p_sequence_num OUT NOCOPY NUMBER,
17 p_dummy_out2 OUT NOCOPY NUMBER,
18 p_dummy_out3 OUT NOCOPY NUMBER,
19 p_dummy_out4 OUT NOCOPY NUMBER,
20 p_dummy_out5 OUT NOCOPY NUMBER,
21 p_dummy_out6 OUT NOCOPY NUMBER,
22 p_dummy_out7 OUT NOCOPY NUMBER,
23 p_dummy_out8 OUT NOCOPY NUMBER,
24 p_dummy_out9 OUT NOCOPY NUMBER,
25 p_dummy_out10 OUT NOCOPY NUMBER
26 );
27
28 PROCEDURE compare_po_to_original(
29 p_header_id IN NUMBER,
30 p_release_id IN NUMBER,
31 p_revision_num IN NUMBER,
32 p_dummy_in4 IN NUMBER DEFAULT NULL,
33 p_dummy_in5 IN NUMBER DEFAULT NULL,
34 p_dummy_in6 IN NUMBER DEFAULT NULL,
35 p_dummy_in7 IN NUMBER DEFAULT NULL,
36 p_dummy_in8 IN NUMBER DEFAULT NULL,
37 p_dummy_in9 IN NUMBER DEFAULT NULL,
38 p_dummy_in10 IN NUMBER DEFAULT NULL,
39 p_sequence_num OUT NOCOPY NUMBER,
40 p_dummy_out2 OUT NOCOPY NUMBER,
41 p_dummy_out3 OUT NOCOPY NUMBER,
42 p_dummy_out4 OUT NOCOPY NUMBER,
43 p_dummy_out5 OUT NOCOPY NUMBER,
44 p_dummy_out6 OUT NOCOPY NUMBER,
45 p_dummy_out7 OUT NOCOPY NUMBER,
46 p_dummy_out8 OUT NOCOPY NUMBER,
47 p_dummy_out9 OUT NOCOPY NUMBER,
48 p_dummy_out10 OUT NOCOPY NUMBER
49 );
50
51 PROCEDURE compare_po_to_previous(
52 p_header_id IN NUMBER,
53 p_release_id IN NUMBER,
54 p_revision_num IN NUMBER,
55 p_dummy_in4 IN NUMBER DEFAULT NULL,
56 p_dummy_in5 IN NUMBER DEFAULT NULL,
57 p_dummy_in6 IN NUMBER DEFAULT NULL,
58 p_dummy_in7 IN NUMBER DEFAULT NULL,
59 p_dummy_in8 IN NUMBER DEFAULT NULL,
60 p_dummy_in9 IN NUMBER DEFAULT NULL,
61 p_dummy_in10 IN NUMBER DEFAULT NULL,
62 p_sequence_num OUT NOCOPY NUMBER,
63 p_dummy_out2 OUT NOCOPY NUMBER,
64 p_dummy_out3 OUT NOCOPY NUMBER,
65 p_dummy_out4 OUT NOCOPY NUMBER,
66 p_dummy_out5 OUT NOCOPY NUMBER,
67 p_dummy_out6 OUT NOCOPY NUMBER,
68 p_dummy_out7 OUT NOCOPY NUMBER,
69 p_dummy_out8 OUT NOCOPY NUMBER,
70 p_dummy_out9 OUT NOCOPY NUMBER,
71 p_dummy_out10 OUT NOCOPY NUMBER
72 );
73
74 PROCEDURE compare_po(
75 p_header_id IN NUMBER,
76 p_release_id IN NUMBER,
77 p_revision_num IN NUMBER,
78 p_comparison_flag IN VARCHAR2,
79 p_sequence_num OUT NOCOPY NUMBER
80 );
81
82 /* Compare PO header with a previous revision */
83 PROCEDURE compare_headers(
84 p_header_id IN NUMBER,
85 p_release_id IN NUMBER,
86 p_revision_num IN NUMBER,
87 p_comparison_flag IN VARCHAR2,
88 p_sequence_num IN NUMBER );
89
90 /* Compare all lines for a PO */
91 PROCEDURE compare_lines(
92 p_header_id IN NUMBER,
93 p_revision_num IN NUMBER,
94 p_comparison_flag IN VARCHAR2,
95 p_sequence_num IN NUMBER );
96
97 /* Compare all locations for a PO */
98 PROCEDURE compare_locations(
99 p_header_id IN NUMBER,
100 p_release_id IN NUMBER,
101 p_revision_num IN NUMBER,
102 p_comparison_flag IN VARCHAR2,
103 p_sequence_num IN NUMBER );
104
105 /* Compare all distributions for a PO */
106 PROCEDURE compare_distributions(
107 p_header_id IN NUMBER,
108 p_release_id IN NUMBER,
109 p_revision_num IN NUMBER,
110 p_comparison_flag IN VARCHAR2,
111 p_sequence_num IN NUMBER );
112
113 /* Compare one line in a PO and all its sub-components */
114 PROCEDURE compare_line_to_all(
115 p_line_id IN NUMBER,
116 p_release_id IN NUMBER,
117 p_revision_num IN NUMBER,
118 p_dummy_in4 IN NUMBER DEFAULT NULL,
119 p_dummy_in5 IN NUMBER DEFAULT NULL,
120 p_dummy_in6 IN NUMBER DEFAULT NULL,
121 p_dummy_in7 IN NUMBER DEFAULT NULL,
122 p_dummy_in8 IN NUMBER DEFAULT NULL,
123 p_dummy_in9 IN NUMBER DEFAULT NULL,
124 p_dummy_in10 IN NUMBER DEFAULT NULL,
125 p_sequence_num OUT NOCOPY NUMBER,
126 p_dummy_out2 OUT NOCOPY NUMBER,
127 p_dummy_out3 OUT NOCOPY NUMBER,
128 p_dummy_out4 OUT NOCOPY NUMBER,
129 p_dummy_out5 OUT NOCOPY NUMBER,
130 p_dummy_out6 OUT NOCOPY NUMBER,
131 p_dummy_out7 OUT NOCOPY NUMBER,
132 p_dummy_out8 OUT NOCOPY NUMBER,
133 p_dummy_out9 OUT NOCOPY NUMBER,
134 p_dummy_out10 OUT NOCOPY NUMBER
135 );
136
137 PROCEDURE compare_line_to_original(
138 p_line_id IN NUMBER,
139 p_release_id IN NUMBER,
140 p_revision_num IN NUMBER,
141 p_dummy_in4 IN NUMBER DEFAULT NULL,
142 p_dummy_in5 IN NUMBER DEFAULT NULL,
143 p_dummy_in6 IN NUMBER DEFAULT NULL,
144 p_dummy_in7 IN NUMBER DEFAULT NULL,
145 p_dummy_in8 IN NUMBER DEFAULT NULL,
146 p_dummy_in9 IN NUMBER DEFAULT NULL,
147 p_dummy_in10 IN NUMBER DEFAULT NULL,
148 p_sequence_num OUT NOCOPY NUMBER,
149 p_dummy_out2 OUT NOCOPY NUMBER,
150 p_dummy_out3 OUT NOCOPY NUMBER,
151 p_dummy_out4 OUT NOCOPY NUMBER,
152 p_dummy_out5 OUT NOCOPY NUMBER,
153 p_dummy_out6 OUT NOCOPY NUMBER,
154 p_dummy_out7 OUT NOCOPY NUMBER,
155 p_dummy_out8 OUT NOCOPY NUMBER,
156 p_dummy_out9 OUT NOCOPY NUMBER,
157 p_dummy_out10 OUT NOCOPY NUMBER
158 );
159
160 PROCEDURE compare_line_to_previous(
161 p_line_id IN NUMBER,
162 p_release_id IN NUMBER,
163 p_revision_num IN NUMBER,
164 p_dummy_in4 IN NUMBER DEFAULT NULL,
165 p_dummy_in5 IN NUMBER DEFAULT NULL,
166 p_dummy_in6 IN NUMBER DEFAULT NULL,
167 p_dummy_in7 IN NUMBER DEFAULT NULL,
168 p_dummy_in8 IN NUMBER DEFAULT NULL,
169 p_dummy_in9 IN NUMBER DEFAULT NULL,
170 p_dummy_in10 IN NUMBER DEFAULT NULL,
171 p_sequence_num OUT NOCOPY NUMBER,
172 p_dummy_out2 OUT NOCOPY NUMBER,
173 p_dummy_out3 OUT NOCOPY NUMBER,
174 p_dummy_out4 OUT NOCOPY NUMBER,
175 p_dummy_out5 OUT NOCOPY NUMBER,
176 p_dummy_out6 OUT NOCOPY NUMBER,
177 p_dummy_out7 OUT NOCOPY NUMBER,
178 p_dummy_out8 OUT NOCOPY NUMBER,
179 p_dummy_out9 OUT NOCOPY NUMBER,
180 p_dummy_out10 OUT NOCOPY NUMBER
181 );
182
183 PROCEDURE compare_po_line(
184 p_line_id IN NUMBER,
185 p_release_id IN NUMBER,
186 p_revision_num IN NUMBER,
187 p_comparison_flag IN VARCHAR2,
188 p_sequence_num OUT NOCOPY NUMBER
189 );
190
191
192
193 /* Compare a line in a PO with a previous revision */
194 PROCEDURE compare_line(
195 p_line_id IN NUMBER,
196 p_revision_num IN NUMBER,
197 p_comparison_flag IN VARCHAR2,
198 p_sequence_num IN NUMBER );
199
200 /* Compare all locations for a PO line */
201 PROCEDURE compare_line_locs(
202 p_line_id IN NUMBER,
203 p_release_id IN NUMBER,
204 p_revision_num IN NUMBER,
205 p_comparison_flag IN VARCHAR2,
206 p_sequence_num IN NUMBER );
207
208 /* Compare all distributions for a PO line */
209 PROCEDURE compare_line_dists(
210 p_line_id IN NUMBER,
211 p_release_id IN NUMBER,
212 p_revision_num IN NUMBER,
213 p_comparison_flag IN VARCHAR2,
214 p_sequence_num IN NUMBER );
215
216 END po_revision_differences;