1 PACKAGE pos_revision_differences AUTHID CURRENT_USER AS
2 /* $Header: POSPORVS.pls 115.4 2003/12/10 06:18:33 ammitra 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 p_comparison_flag_org IN VARCHAR2);
90
91 PROCEDURE compare_ga_assignments(
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
98 PROCEDURE compare_pdiffs_line(
99 p_header_id IN NUMBER,
100 p_revision_num IN NUMBER,
101 p_comparison_flag IN VARCHAR2,
102 p_sequence_num IN NUMBER
103 ) ;
104
105 PROCEDURE compare_pdiffs_ship(
106 p_header_id IN NUMBER,
107 p_revision_num IN NUMBER,
108 p_comparison_flag IN VARCHAR2,
109 p_sequence_num IN NUMBER
110 ) ;
111
112 /* Compare all lines for a PO */
113 PROCEDURE compare_lines(
114 p_header_id IN NUMBER,
115 p_revision_num IN NUMBER,
116 p_comparison_flag IN VARCHAR2,
117 p_sequence_num IN NUMBER );
118
119 /* Compare all locations for a PO */
120 PROCEDURE compare_locations(
121 p_header_id IN NUMBER,
122 p_release_id IN NUMBER,
123 p_revision_num IN NUMBER,
124 p_comparison_flag IN VARCHAR2,
125 p_sequence_num IN NUMBER );
126
127 /* Compare all distributions for a PO */
128 PROCEDURE compare_distributions(
129 p_header_id IN NUMBER,
130 p_release_id IN NUMBER,
131 p_revision_num IN NUMBER,
132 p_comparison_flag IN VARCHAR2,
133 p_sequence_num IN NUMBER );
134
135 /* Compare one line in a PO and all its sub-components */
136 PROCEDURE compare_line_to_all(
137 p_line_id IN NUMBER,
138 p_release_id IN NUMBER,
139 p_revision_num IN NUMBER,
140 p_dummy_in4 IN NUMBER DEFAULT NULL,
141 p_dummy_in5 IN NUMBER DEFAULT NULL,
142 p_dummy_in6 IN NUMBER DEFAULT NULL,
143 p_dummy_in7 IN NUMBER DEFAULT NULL,
144 p_dummy_in8 IN NUMBER DEFAULT NULL,
145 p_dummy_in9 IN NUMBER DEFAULT NULL,
146 p_dummy_in10 IN NUMBER DEFAULT NULL,
147 p_sequence_num OUT NOCOPY NUMBER,
148 p_dummy_out2 OUT NOCOPY NUMBER,
149 p_dummy_out3 OUT NOCOPY NUMBER,
150 p_dummy_out4 OUT NOCOPY NUMBER,
151 p_dummy_out5 OUT NOCOPY NUMBER,
152 p_dummy_out6 OUT NOCOPY NUMBER,
153 p_dummy_out7 OUT NOCOPY NUMBER,
154 p_dummy_out8 OUT NOCOPY NUMBER,
155 p_dummy_out9 OUT NOCOPY NUMBER,
156 p_dummy_out10 OUT NOCOPY NUMBER
157 );
158
159 PROCEDURE compare_line_to_original(
160 p_line_id IN NUMBER,
161 p_release_id IN NUMBER,
162 p_revision_num IN NUMBER,
163 p_dummy_in4 IN NUMBER DEFAULT NULL,
164 p_dummy_in5 IN NUMBER DEFAULT NULL,
165 p_dummy_in6 IN NUMBER DEFAULT NULL,
166 p_dummy_in7 IN NUMBER DEFAULT NULL,
167 p_dummy_in8 IN NUMBER DEFAULT NULL,
168 p_dummy_in9 IN NUMBER DEFAULT NULL,
169 p_dummy_in10 IN NUMBER DEFAULT NULL,
170 p_sequence_num OUT NOCOPY NUMBER,
171 p_dummy_out2 OUT NOCOPY NUMBER,
172 p_dummy_out3 OUT NOCOPY NUMBER,
173 p_dummy_out4 OUT NOCOPY NUMBER,
174 p_dummy_out5 OUT NOCOPY NUMBER,
175 p_dummy_out6 OUT NOCOPY NUMBER,
176 p_dummy_out7 OUT NOCOPY NUMBER,
177 p_dummy_out8 OUT NOCOPY NUMBER,
178 p_dummy_out9 OUT NOCOPY NUMBER,
179 p_dummy_out10 OUT NOCOPY NUMBER
180 );
181
182 PROCEDURE compare_line_to_previous(
183 p_line_id IN NUMBER,
184 p_release_id IN NUMBER,
185 p_revision_num IN NUMBER,
186 p_dummy_in4 IN NUMBER DEFAULT NULL,
187 p_dummy_in5 IN NUMBER DEFAULT NULL,
188 p_dummy_in6 IN NUMBER DEFAULT NULL,
189 p_dummy_in7 IN NUMBER DEFAULT NULL,
190 p_dummy_in8 IN NUMBER DEFAULT NULL,
191 p_dummy_in9 IN NUMBER DEFAULT NULL,
192 p_dummy_in10 IN NUMBER DEFAULT NULL,
193 p_sequence_num OUT NOCOPY NUMBER,
194 p_dummy_out2 OUT NOCOPY NUMBER,
195 p_dummy_out3 OUT NOCOPY NUMBER,
196 p_dummy_out4 OUT NOCOPY NUMBER,
197 p_dummy_out5 OUT NOCOPY NUMBER,
198 p_dummy_out6 OUT NOCOPY NUMBER,
199 p_dummy_out7 OUT NOCOPY NUMBER,
200 p_dummy_out8 OUT NOCOPY NUMBER,
201 p_dummy_out9 OUT NOCOPY NUMBER,
202 p_dummy_out10 OUT NOCOPY NUMBER
203 );
204
205 PROCEDURE compare_po_line(
206 p_line_id IN NUMBER,
207 p_release_id IN NUMBER,
208 p_revision_num IN NUMBER,
209 p_comparison_flag IN VARCHAR2,
210 p_sequence_num OUT NOCOPY NUMBER
211 );
212
213
214
215 /* Compare a line in a PO with a previous revision */
216 PROCEDURE compare_line(
217 p_line_id IN NUMBER,
218 p_revision_num IN NUMBER,
219 p_comparison_flag IN VARCHAR2,
220 p_sequence_num IN NUMBER );
221
222 /* Compare all locations for a PO line */
223 PROCEDURE compare_line_locs(
224 p_line_id IN NUMBER,
225 p_release_id IN NUMBER,
226 p_revision_num IN NUMBER,
227 p_comparison_flag IN VARCHAR2,
228 p_sequence_num IN NUMBER );
229
230 /* Compare all distributions for a PO line */
231 PROCEDURE compare_line_dists(
232 p_line_id IN NUMBER,
233 p_release_id IN NUMBER,
234 p_revision_num IN NUMBER,
235 p_comparison_flag IN VARCHAR2,
236 p_sequence_num IN NUMBER );
237
238 END pos_revision_differences;