1 package wip_validateMLHeader_pvt AUTHID CURRENT_USER as
2 /* $Header: wipmlhvs.pls 120.3 2011/05/19 10:36:20 shjindal ship $ */
3
4 -- do we need this? --
5 po_warning_flag number;
6
7 line_validation_error exception;
8
9 --
10 -- This procedure defaults and validates all the columns in wip_job_schedule_interface table.
11 -- It does group validation where it can and does line validation otherwise. For a particular
12 -- column, the default and validation logic might be splitted in two different places if it needs
13 -- both line and group validation.
14 -- The only exception is for column serialization_start_op. The default and validation has to be
15 -- done after the routing explosion. We have two seperate APIs for this purpose.
16 --
17 procedure validateMLHeader(p_groupID in number,
18 p_validationLevel in number,
19 x_returnStatus out nocopy varchar2,
20 x_errorMsg out nocopy varchar2);
21
22 --
23 -- This procedure is not called during validatoin phase. It must be called after the explosion
24 -- so work order will be populated with job operations.
25 --
26 procedure defaultSerializationStartOp(p_rowid in rowid,
27 p_rtgVal in number);
28
29 --
30 -- Unlike other procedure, this one has to be called after the explosion. We can only validate op related
31 -- after the explosion and the possible details loading.
32 --
33 procedure validateSerializationStartOp(p_rowid in rowid,
34 x_returnStatus out nocopy varchar2,
35 x_errorMsg out nocopy varchar2);
36
37 procedure setInterfaceError(p_rowid in rowid,
38 p_interfaceID in number,
39 p_text in varchar2,
40 p_type in number);
41 end wip_validateMLHeader_pvt;