1 PACKAGE OE_SO_PLD_PACKAGE AUTHID CURRENT_USER AS
2 /* $Header: oexsplds.pls 115.1 99/07/16 08:30:20 porting shi $ */
3
4 PROCEDURE Get_Schedule_DB_Values(
5 X_Row_Id IN VARCHAR2
6 , P_Db_Requested_Quantity OUT NUMBER
7 , P_Db_Warehouse_Id OUT NUMBER
8 , P_Db_Schedule_Date OUT DATE
9 , P_Db_Subinventory OUT VARCHAR2
10 , P_Db_Lot_Number OUT VARCHAR2
11 , P_Db_Revision OUT VARCHAR2
12 , P_Db_Demand_Class_Code OUT VARCHAR2
13 , Result OUT VARCHAR2
14 );
15 PROCEDURE When_Validate_Record
16 (
17 X_Row_Id IN VARCHAR2,
18 P_Db_Record_Flag IN VARCHAR2,
19 P_Db_Requested_Quantity IN OUT NUMBER,
20 P_Db_Warehouse_Id IN OUT NUMBER,
21 P_Db_Schedule_Date IN OUT DATE,
22 P_Db_Subinventory IN OUT VARCHAR2,
23 P_Db_Lot_Number IN OUT VARCHAR2,
24 P_Db_Revision IN OUT VARCHAR2,
25 P_Db_Demand_Class_Code IN OUT VARCHAR2,
26 P_Requested_Quantity IN NUMBER,
27 P_Warehouse_Id IN NUMBER,
28 P_Schedule_Date IN DATE,
29 P_Subinventory IN VARCHAR2,
30 P_Revision IN VARCHAR2,
31 P_Lot_Number IN VARCHAR2,
32 P_Demand_Class_Code IN VARCHAR2,
33 P_Revision_Control_Flag IN VARCHAR2,
34 P_Lot_Control_Flag IN VARCHAR2,
35 P_Schedule_Action_Code IN VARCHAR2,
36 P_Schedule_Status_Code IN VARCHAR2,
37 P_Result OUT VARCHAR2
38 );
39
40 END OE_SO_PLD_PACKAGE;