1 PACKAGE PJM_UNIT_EFF AUTHID CURRENT_USER AS
2 /* $Header: PJMUEFFS.pls 120.0.12010000.1 2008/07/30 04:24:46 appldev ship $ */
3 --
4 -- Name : Enabled
5 -- Pre-reqs : None
6 -- Function : This function returns a Y/N indicator whether
7 -- Model/Unit effectivity has been enabled or not
8 --
9 --
10 -- Parameters :
11 -- IN : None
12 --
13 -- Returns : Y/N
14 --
15 FUNCTION Enabled
16 RETURN VARCHAR2;
17
18
19 --
20 -- Name : Allow_Cross_UnitNum_Issues
21 -- Pre-reqs : None
22 -- Function : This function returns a Y/N indicator whether
23 -- Cross-Unit Number WIP Issues are allowed
24 --
25 --
26 -- Parameters :
27 -- IN : X_organization_id NUMBER
28 --
29 -- Returns : Y/N
30 --
31 FUNCTION Allow_Cross_UnitNum_Issues
32 ( X_organization_id IN NUMBER DEFAULT NULL
33 ) RETURN VARCHAR2;
34 PRAGMA RESTRICT_REFERENCES (Allow_Cross_UnitNum_Issues, WNDS, WNPS);
35
36
37 --
38 -- Name : Unit_Effective_Item
39 -- Pre-reqs : None
40 -- Function : This function checks the effectivity control for
41 -- the item
42 --
43 --
44 -- Parameters :
45 -- IN : X_item_id NUMBER
46 -- X_organization_id NUMBER
47 --
48 -- OUT : None
49 --
50 -- Returns : Y/N
51 --
52 FUNCTION Unit_Effective_Item
53 ( X_item_id IN NUMBER
54 , X_organization_id IN NUMBER
55 ) RETURN VARCHAR2;
56
57
58 --
59 -- Name : Set_Unit_Number
60 -- Pre-reqs : None
61 -- Function : This procedure sets the global variable
62 -- Current_Unit_Number
63 --
64 --
65 -- Parameters :
66 -- IN : X_Unit_Number NUMBER
67 --
68 -- Returns : None
69 --
70 PROCEDURE Set_Unit_Number
71 ( X_Unit_Number IN VARCHAR2
72 );
73
74
75 --
76 -- Name : Current_Unit_Number
77 -- Pre-reqs : None
78 -- Function : This procedure gets the value in global variable
79 -- G_Unit_Number
80 --
81 --
82 -- Parameters :
83 -- IN : None
84 --
85 -- Returns : VARCHAR2
86 --
87 FUNCTION Current_Unit_Number
88 RETURN VARCHAR2;
89 PRAGMA RESTRICT_REFERENCES (Current_Unit_Number, WNDS, WNPS);
90
91
92 --
93 -- Name : Prev_Unit_Number
94 -- Pre-reqs : None
95 -- Function : This function returns the previous unit number in
96 -- ascending order for the same end item
97 --
98 --
99 -- Parameters :
100 -- IN : X_Unit_Number NUMBER
101 --
102 -- Returns : VARCHAR2
103 --
104 FUNCTION Prev_Unit_Number
105 ( X_Unit_Number IN VARCHAR2
106 ) RETURN VARCHAR2;
107 PRAGMA RESTRICT_REFERENCES (Prev_Unit_Number, WNDS, WNPS);
108
109
110 --
111 -- Name : Next_Unit_Number
112 -- Pre-reqs : None
113 -- Function : This function returns the next unit number in
114 -- ascending order for the same end item
115 --
116 --
117 -- Parameters :
118 -- IN : X_Unit_Number NUMBER
119 --
120 -- Returns : VARCHAR2
121 --
122 FUNCTION Next_Unit_Number
123 ( X_Unit_Number IN VARCHAR2
124 ) RETURN VARCHAR2;
125 PRAGMA RESTRICT_REFERENCES (Next_Unit_Number, WNDS, WNPS);
126
127
128 --
129 -- Name : WIP_Unit_Number
130 -- Pre-reqs : None
131 -- Function : This function returns the unit number on a discrete
132 -- job or flow schedule
133 --
134 --
135 -- Parameters :
136 -- IN : X_wip_entity_id NUMBER
137 -- X_organization_id NUMBER
138 --
139 -- OUT : None
140 --
141 -- Returns : VARCHAR2
142 --
143 FUNCTION WIP_Unit_Number
144 ( X_wip_entity_id IN NUMBER
145 , X_organization_id IN NUMBER
146 ) RETURN VARCHAR2;
147
148 FUNCTION WIP_Unit_Number_Cached
149 ( X_wip_entity_id IN NUMBER
150 , X_organization_id IN NUMBER
151 ) RETURN VARCHAR2;
152
153
154 --
155 -- Name : RCV_Unit_Number
156 -- Pre-reqs : None
157 -- Function : This function returns the unit number on a PO
158 -- distribution or Internal Req distribution based on the
159 -- receiving transaction
160 --
161 --
162 -- Parameters :
163 -- IN : X_rcv_transaction_id NUMBER
164 --
165 -- OUT : None
166 --
167 -- Returns : VARCHAR2
168 --
169 FUNCTION RCV_Unit_Number
170 ( X_rcv_transaction_id IN NUMBER
171 ) RETURN VARCHAR2;
172
173
174 --
175 -- Name : OE_Line_Unit_Number
176 -- Pre-reqs : None
177 -- Function : This function returns the unit number on a sales order
178 -- line
179 --
180 --
181 -- Parameters :
182 -- IN : X_so_line_id NUMBER
183 --
184 -- OUT : None
185 --
186 -- Returns : VARCHAR2
187 --
188 FUNCTION OE_Line_Unit_Number
189 ( X_so_line_id IN NUMBER
190 ) RETURN VARCHAR2;
191
192 FUNCTION OE_Line_Unit_Number_Cached
193 ( X_so_line_id IN NUMBER
194 ) RETURN VARCHAR2;
195
196
197 --
198 -- Name : RMA_Rcpt_Unit_Number
199 -- Pre-reqs : None
200 -- Function : This function returns the unit number on a RMA
201 -- order line based on the receiving transaction
202 --
203 --
204 -- Parameters :
205 -- IN : X_rcv_transaction_id NUMBER
206 --
207 -- OUT : None
208 --
209 -- Returns : VARCHAR2
210 --
211 FUNCTION RMA_Rcpt_Unit_Number
212 ( X_rcv_transaction_id IN NUMBER
213 ) RETURN VARCHAR2;
214
215
216 --
217 -- Name : Validate_Serial
218 -- Pre-reqs : None
219 -- Function : This function validates the transaction serial numbers
220 -- against the unit number on the transaction entity
221 -- (e.g. WIP job)
222 --
223 --
224 -- Parameters :
225 -- IN : X_trx_source_type_id NUMBER
226 -- X_trx_action_id NUMBER
227 -- X_item_id NUMBER
228 -- X_organization_id NUMBER
229 -- X_serial_number VARCHAR2
230 -- X_unit_number VARCHAR2
231 --
232 -- OUT : X_error_code VARCHAR2
233 --
234 -- Returns : Boolean
235 --
236 FUNCTION Validate_Serial
237 ( X_trx_source_type_id IN NUMBER
238 , X_trx_action_id IN NUMBER
239 , X_item_id IN NUMBER
240 , X_organization_id IN NUMBER
241 , X_serial_number IN VARCHAR2
242 , X_unit_number IN VARCHAR2
243 , X_error_code OUT NOCOPY VARCHAR2
244 ) RETURN BOOLEAN;
245
246
247 --
248 -- Name : Serial_UnitNum_Link
249 -- Pre-reqs : None
250 -- Function : This function links the transaction serial numbers
251 -- to the unit number on the transaction entity
252 -- (e.g. WIP job)
253 --
254 --
255 -- Parameters :
256 -- IN : X_transaction_id NUMBER
257 --
258 -- OUT : X_error_code VARCHAR2
259 --
260 -- Returns : Boolean
261 --
262 FUNCTION Serial_UnitNum_Link
263 ( X_transaction_id IN NUMBER
264 , X_error_code OUT NOCOPY VARCHAR2
265 ) RETURN BOOLEAN;
266
267
268 --
269 -- Name : Unit_Serial_History
270 -- Pre-reqs : None
271 -- Function : This function creates audit trail information for
272 -- unit number changes to serial numbers
273 --
274 --
275 -- Parameters :
276 -- IN : X_serial_number VARCHAR2
277 -- X_item_id NUMBER
278 -- X_organization_id NUMBER
279 -- X_old_unit_number VARCHAR2
280 -- X_new_unit_number VARCHAR2
281 -- X_start_num NUMBER
282 -- X_counts NUMBER
283 --
284 -- OUT : X_error_code VARCHAR2
285 --
286 -- Returns : Boolean
287 --
288 FUNCTION Unit_Serial_History
289 ( X_serial_number IN VARCHAR2
290 , X_item_id IN NUMBER
291 , X_organization_id IN NUMBER
292 , X_old_unit_number IN VARCHAR2
293 , X_new_unit_number IN VARCHAR2
294 , X_error_code OUT NOCOPY VARCHAR2
295 ) return BOOLEAN;
296
297
298 --
299 -- Name : OE_Attribute
300 -- Pre-reqs : None
301 -- Function : This function returns the attribute column in the
302 -- SO_LINES descriptive flexfield that stores the unit
303 -- number value. The column name is captured in the
304 -- profile PJM_UEFF_OE_ATTRIBUTE.
305 --
306 --
307 -- Parameters :
308 -- IN : None
309 --
310 -- Returns : Boolean
311 --
312 FUNCTION OE_Attribute
313 RETURN VARCHAR2;
314 PRAGMA RESTRICT_REFERENCES (OE_Attribute, WNDS, WNPS);
315
316
317 END;