Package Details

The package that needs to be called is ALC_HIER_LVL_INV_SNAPSHOT_SQL.

SQL> desc ALC_HIER_LVL_INV_SNAPSHOT_SQL
FUNCTION ROLLUP_ALLOC_IN RETURNS NUMBER
Argument Name                  Type                    In/Out Default?
------------------------------ ----------------------- ------ --------
O_ERROR_MESSAGE                VARCHAR2                IN/OUT
FUNCTION ROLLUP_CROSSLINK_IN RETURNS NUMBER
Argument Name                  Type                    In/Out Default?
------------------------------ ----------------------- ------ --------
O_ERROR_MESSAGE                VARCHAR2                IN/OUT
FUNCTION ROLLUP_IL_SOH RETURNS NUMBER
Argument Name                  Type                    In/Out Default?
------------------------------ ----------------------- ------ --------
O_ERROR_MESSAGE                VARCHAR2                IN/OUT
FUNCTION ROLLUP_ON_ORDER RETURNS NUMBER
Argument Name                  Type                    In/Out Default?
------------------------------ ----------------------- ------ --------
O_ERROR_MESSAGE                VARCHAR2                IN/OUT
------------------------------ ----------------------- ------ --------
ROLLUP_ALLOC_OUT (FUNCTION)<return value>  NUMBER   		   OUT 
ROLLUP_ALLOC_OUT                 
O_ERROR_MESSAGE                VARCHAR2                IN/OUT 
------------------------------ ----------------------- ------ --------
ROLLUP_CUSTOMER_ORDER (FUNCTION) <return value>  NUMBER   OUT 
ROLLUP_CUSTOMER_ORDER                 
O_ERROR_MESSAGE                VARCHAR2                IN/OUT 
------------------------------ ----------------------- ------ --------

There are six functions in the package. Each of the four functions in the package should be called by its own batch program.

• AlcSnapshotSOH

• AlcSnapshotAllocIn

• AlcSnapshotOnOrder

• AlcSnapshotCrosslink

• AlcSnapshotAllocOut

• AlcSnapshotCustomerOrder