1 PACKAGE OE_SO_LIN_VALIDATE AUTHID CURRENT_USER AS
2 /* $Header: oesolins.pls 115.1 99/07/16 08:28:23 porting shi $ */
3
4 FUNCTION complex_details (x_line_id IN NUMBER) RETURN BOOLEAN;
5 pragma restrict_references( complex_details, WNPS, WNDS);
6
7 PROCEDURE Validate_Reserved_Qty (
8 P_Line_Id IN NUMBER,
9 P_Lines_Reserved_Qty IN NUMBER,
10 P_Lines_Ordered_Qty IN NUMBER,
11 P_Lines_Cancelled_Qty IN NUMBER,
12 P_Lines_Released_Qty IN NUMBER,
13 P_Result OUT VARCHAR2
14 );
15
16 PROCEDURE Load_Item_Warehouse_Attributes(
17 P_Inventory_Item_Id IN NUMBER,
18 P_Organization_id IN NUMBER,
19 P_Item_Desc OUT VARCHAR2,
20 P_SO_Xactions_Flag OUT VARCHAR2,
21 P_Reservable_Type OUT NUMBER,
22 P_ATP_Flag OUT VARCHAR2,
23 P_Result OUT VARCHAR2
24 );
25
26 PROCEDURE Get_Schedule_DB_Values(
27 X_Row_Id IN VARCHAR2
28 , X_Line_Id IN NUMBER
29 , P_Db_Schedule_Date OUT DATE
30 , P_Db_Demand_Class_Code OUT VARCHAR2
31 , P_Db_Ship_To_Site_Use_Id OUT NUMBER
32 , P_Db_Warehouse_Id OUT NUMBER
33 , P_Db_Ship_To_Contact_Id OUT NUMBER
34 , P_Db_Shipment_Priority_Code OUT VARCHAR2
35 , P_Db_Ship_Method_Code OUT VARCHAR2
36 , P_Db_Schedule_Date_Svrid OUT NUMBER
37 , P_Db_Demand_Class_Svrid OUT NUMBER
38 , P_Db_Ship_To_Svrid OUT NUMBER
39 , P_Db_Warehouse_Svrid OUT NUMBER
40 , P_Db_Ship_Set_Number OUT NUMBER
41 , P_Db_Ship_Set_Number_Svrid OUT NUMBER
42 , P_Db_Reserved_Quantity OUT NUMBER
43 , Result OUT VARCHAR2
44 );
45
46 PROCEDURE Query_Time_Stamps(
47 X_Row_Id IN VARCHAR2,
48 X_Creation_Date OUT DATE,
49 X_Creation_Date_Time OUT DATE,
50 X_Std_Component_Freeze_Date OUT DATE,
51 X_Tax_Code OUT VARCHAR2,
52 X_Tax_Code_SVRID OUT NUMBER,
53 Result OUT VARCHAR2
54 );
55
56 PROCEDURE Load_ATO_Model(
57 X_Line_Id IN NUMBER,
58 X_ATO_Model OUT VARCHAR2,
59 X_ATO_Flag IN VARCHAR2,
60 X_ATO_Line_Id IN NUMBER,
61 X_Item_Type_Code IN VARCHAR2,
62 X_Configuration_Item_Exists OUT VARCHAR2,
63 Result OUT VARCHAR2
64 );
65
66 PROCEDURE Load_Supply_Reserved(
67 X_Line_Id IN NUMBER,
68 X_Supply_Res_Details OUT VARCHAR2,
69 Result OUT VARCHAR2
70 );
71
72 FUNCTION DB_Reserved_Quantity(X_Line_Id IN NUMBER) return NUMBER;
73 pragma restrict_references (DB_Reserved_Quantity, WNPS, WNDS);
74
75
76 PROCEDURE Validate_Scheduling_Attributes
77 (
78 P_Row_Id VARCHAR2,
79 P_Line_Id NUMBER,
80 P_Ship_Set_Number NUMBER,
81 P_Reserved_Quantity NUMBER,
82 P_Warehouse_Id NUMBER,
83 P_Ship_To_Site_Use_Id NUMBER,
84 P_Schedule_Date DATE,
85 P_Demand_Class_Code VARCHAR2,
86 P_Ship_Method_Code VARCHAR2,
87 P_Shipment_Priority_Code VARCHAR2,
88 P_Schedule_Action_Code VARCHAR2,
89 P_Navigation_Context VARCHAR2,
90 P_Result IN OUT VARCHAR2
91 );
92
93 END OE_SO_LIN_VALIDATE;