1 PACKAGE OE_BULK_VALIDATE AUTHID CURRENT_USER AS
2 /* $Header: OEBSVATS.pls 120.0.12010000.2 2008/11/18 03:28:10 smusanna ship $ */
3
4 -- Global to maintain Error Record Count
5 G_ERROR_COUNT NUMBER := 0;
6
7 ---------------------------------------------------------------------
8 -- PROCEDURE Pre_Process
9 --
10 -- This API does all the order import pre-processing validations on
11 -- the interface tables for orders in this batch.
12 -- It will insert error messages for all validation failures.
13 ---------------------------------------------------------------------
14
15 PROCEDURE PRE_PROCESS( p_batch_id IN NUMBER);
16
17
18 ---------------------------------------------------------------------
19 -- PROCEDURE Attributes
20 --
21 -- This API does all attribute validations on interface tables for
22 -- orders in this batch.
23 -- It will insert error messages for all validation failures.
24 ---------------------------------------------------------------------
25
26 PROCEDURE ATTRIBUTES
27 (p_batch_id IN NUMBER
28 ,p_adjustments_exist IN VARCHAR2 DEFAULT 'N');
29
30 ---------------------------------------------------------------------
31 -- PROCEDURE Validate_BOM
32 --
33 -- This API does BOM validations on the OE_CONFIG_DETAILS_TMP table
34 -- for lines in this batch.
35 -- It will insert error messages for all validation failures.
36 ---------------------------------------------------------------------
37
38 PROCEDURE Validate_BOM;
39
40 ---------------------------------------------------------------------
41 -- PROCEDURE Mark_Interface_Error
42 --
43 -- This procedure sets error_flag on order header interface table
44 -- if any entity of this order (header, line, adjustments etc.)
45 -- fail pre-processing checks or attribute validation.
46 ---------------------------------------------------------------------
47
48 PROCEDURE MARK_INTERFACE_ERROR(p_batch_id NUMBER);
49
50 END OE_BULK_VALIDATE;