1 PACKAGE OE_LIN_SCH AUTHID CURRENT_USER AS
2 /* $Header: OEXLNSHS.pls 115.1 99/07/16 08:13:20 porting shi $ */
3
4
5 PROCEDURE Get_Reserved_Quantity
6 (
7 P_Line_Id IN NUMBER,
8 P_Reserved_Quantity OUT NUMBER,
9 P_Return_Status OUT VARCHAR2
10 );
11
12 PROCEDURE Get_Released_Quantity
13 (
14 P_Line_Id IN NUMBER,
15 P_Config_Item_Exists IN VARCHAR2,
16 P_Line_Released_Quantity OUT NUMBER,
17 P_Return_Status OUT VARCHAR2
18 );
19
20 PROCEDURE Check_Details_Complexity
21 (
22 P_Line_Id IN NUMBER,
23 Details_Complexity_Count OUT NUMBER,
24 P_Return_Status OUT VARCHAR2
25 );
26
27 PROCEDURE Get_Scheduling_Quantity
28 (
29 P_Line_Id IN NUMBER,
30 P_Config_Item_Exists IN VARCHAR2,
31 P_Reserved_Quantity OUT NUMBER,
32 P_Line_Released_Quantity OUT NUMBER,
33 Details_Complexity_Count OUT NUMBER,
34 P_Return_Status IN OUT VARCHAR2
35 );
36
37 PROCEDURE Check_Scheduling_Quantity
38 (
39 P_Line_Id IN NUMBER,
40 P_Config_Item_Exists IN VARCHAR2,
41 P_Ordered_Quantity IN NUMBER,
42 P_Cancelled_Quantity IN NUMBER,
43 P_Reserved_Quantity IN OUT NUMBER,
44 Return_Status IN OUT VARCHAR2
45 );
46
47 PROCEDURE Get_Schedule_Status
48 (
49
50 P_Line_Id IN NUMBER,
51 P_Schedule_Status_Code IN OUT VARCHAR2,
52 P_Schedule_Status_Name OUT VARCHAR2,
53 P_Schedule_Action_Code OUT VARCHAR2,
54 P_Return_Status OUT VARCHAR2
55 );
56
57 PROCEDURE Get_Schedule_DB_Values
58 (
59 P_Row_Id IN VARCHAR2,
60 P_Line_Id IN NUMBER,
61 P_schedule_date OUT VARCHAR2,
62 P_demand_Class_Code OUT VARCHAR2,
63 P_Ship_To_Site_Use_Id OUT NUMBER,
64 P_Warehouse_id OUT Number,
65 P_Ship_To_Contact_Id OUT NUMBER,
66 P_Shipment_Priority_Code OUT VARCHAR2,
67 P_Ship_Method_Code OUT VARCHAR2,
68 P_Schedule_Date_Svrid OUT NUMBER,
69 P_Demand_Class_Svrid OUT NUMBER,
70 P_Ship_To_Svrid OUT NUMBER,
71 P_Warehouse_Svrid OUT NUMBER,
72 P_Ordered_Quantity OUT NUMBER,
73 P_Unit_Code OUT VARCHAR2,
74 P_Reserved_Quantity OUT NUMBER,
75 P_Return_Status OUT VARCHAR2
76
77 );
78
79 PROCEDURE Validate_Scheduling_Attributes
80 (
81 P_DB_Record_Flag IN VARCHAR2,
82 P_Lin_Obj_Schedule_Action_Code IN VARCHAR2,
83 P_Lin_Obj_Reserved_Quantity IN NUMBER,
84 P_Lin_Obj_Ordered_Quantity IN NUMBER,
85 P_Lin_Obj_Ship_To_Site_Use_Id IN NUMBER,
86 P_Lin_Obj_Warehouse_Id IN Number,
87 P_Lin_Obj_Schedule_Date IN DATE,
88 P_Lin_Obj_Demand_Class_Code IN VARCHAR2,
89 P_Row_Id IN VARCHAR2,
90 P_Line_Id IN NUMBER,
91 P_World_DB_schedule_date IN OUT VARCHAR2,
92 P_World_DB_demand_Class_Code IN OUT VARCHAR2,
93 P_World_DB_Ship_To_Site_Use_Id IN OUT NUMBER,
94 P_World_DB_Warehouse_id IN OUT Number,
95 P_World_DB_Ship_To_Contact_Id IN OUT NUMBER,
96 P_World_DB_Ship_Priority_Code IN OUT VARCHAR2,
97 P_World_DB_Ship_Method_Code IN OUT VARCHAR2,
98 P_World_DB_Schedule_Date_Svrid IN OUT NUMBER,
99 P_World_DB_Demand_Class_Svrid IN OUT NUMBER,
100 P_World_DB_Ship_To_Svrid IN OUT NUMBER,
101 P_World_DB_Warehouse_Svrid IN OUT NUMBER,
102 P_World_DB_Ordered_Quantity IN OUT NUMBER,
103 P_World_DB_Unit_Code IN OUT VARCHAR2,
104 P_World_DB_Reserved_Quantity IN OUT NUMBER,
105 P_Return_Status IN OUT VARCHAR2
106
107 );
108
109
110 PROCEDURE Scheduling_Security
111 (
112 Attribute IN VARCHAR2,
113 ATO_Model_Flag IN VARCHAR2,
114 ATO_Line_Id IN NUMBER,
115 Supply_Reservation_Exists IN VARCHAR2,
116 DB_Record_Flag IN VARCHAR2,
117 Source_Object IN VARCHAR2,
118 Order_Category IN VARCHAR2,
119 Row_Id IN VARCHAR2,
120 Return_Status OUT VARCHAR2
121 );
122
123 PROCEDURE Query_Reserved_Quantity
124 (
125
126 P_Line_Id IN NUMBER,
127 P_Reservations IN VARCHAR2,
128 P_Reserved_Quantity OUT NUMBER,
129 P_Return_Status OUT VARCHAR2
130 );
131
132
133 END OE_LIN_SCH;