[Home] [Help]
PACKAGE: APPS.OE_SO_PLN_SERVER
Source
1 PACKAGE OE_SO_PLN_SERVER AUTHID CURRENT_USER AS
2 /* $Header: OESOPLNS.pls 115.1 99/07/16 08:11:09 porting shi $ */
3
4 PROCEDURE When_Validate_Record
5 (
6 X_Row_Id IN VARCHAR2,
7 P_Picking_Line_Id IN NUMBER,
8 P_Db_Schedule_Date IN OUT DATE,
9 P_Db_Demand_Class_Code IN OUT VARCHAR2,
10 P_Db_Ship_To_Site_Use_Id IN OUT NUMBER,
11 P_Db_Warehouse_Id IN OUT NUMBER,
12 P_Db_Ship_To_Contact_Id IN OUT NUMBER,
13 P_Db_Shipment_Priority_Code IN OUT VARCHAR2,
14 P_Db_Ship_Method_Code IN OUT VARCHAR2,
15 P_Db_Reserved_Quantity IN OUT NUMBER,
16 P_Schedule_Action_Code IN VARCHAR2,
17 P_Schedule_Date IN DATE,
18 P_Demand_Class_Code IN VARCHAR2,
19 P_Ship_To_Site_Use_Id IN NUMBER,
20 P_Warehouse_Id IN NUMBER,
21 P_Ship_To_Contact_Id IN NUMBER,
22 P_Shipment_Priority_Code IN VARCHAR2,
23 P_Ship_Method_Code IN VARCHAR2,
24 P_Reserved_Quantity IN NUMBER,
25 P_Result OUT VARCHAR2
26 );
27
28
29 FUNCTION complex_details (x_picking_line_id IN NUMBER) RETURN BOOLEAN;
30 pragma restrict_references( complex_details, WNPS, WNDS);
31
32 PROCEDURE Validate_Reserved_Qty (
33 P_Picking_Line_Id IN NUMBER,
34 P_Reserved_Qty IN NUMBER,
35 P_Original_Requested_Qty IN NUMBER,
36 P_Cancelled_Qty IN NUMBER,
37 P_Released_Qty IN NUMBER,
38 P_Result OUT VARCHAR2
39 );
40
41
42
43 FUNCTION DB_Reserved_Quantity(X_Picking_Line_Id IN NUMBER) return NUMBER;
44 pragma restrict_references (DB_Reserved_Quantity, WNPS, WNDS);
45
46 PROCEDURE Get_Schedule_DB_Values(
47 X_Row_Id IN VARCHAR2
48 , X_Picking_Line_Id IN NUMBER
49 , P_Db_Schedule_Date OUT DATE
50 , P_Db_Demand_Class_Code OUT VARCHAR2
51 , P_Db_Ship_To_Site_Use_Id OUT NUMBER
52 , P_Db_Warehouse_Id OUT NUMBER
53 , P_Db_Ship_To_Contact_Id OUT NUMBER
54 , P_Db_Shipment_Priority_Code OUT VARCHAR2
55 , P_Db_Ship_Method_Code OUT VARCHAR2
56 , P_Db_Reserved_Quantity OUT NUMBER
57 , Result OUT VARCHAR2
58 );
59
60
61 PROCEDURE Lock_Row(X_Rowid VARCHAR2,
62 X_ATTRIBUTE1 VARCHAR2,
63 X_ATTRIBUTE10 VARCHAR2,
64 X_ATTRIBUTE11 VARCHAR2,
65 X_ATTRIBUTE12 VARCHAR2,
66 X_ATTRIBUTE13 VARCHAR2,
67 X_ATTRIBUTE14 VARCHAR2,
68 X_ATTRIBUTE15 VARCHAR2,
69 X_ATTRIBUTE2 VARCHAR2,
70 X_ATTRIBUTE3 VARCHAR2,
71 X_ATTRIBUTE4 VARCHAR2,
72 X_ATTRIBUTE5 VARCHAR2,
73 X_ATTRIBUTE6 VARCHAR2,
74 X_ATTRIBUTE7 VARCHAR2,
75 X_ATTRIBUTE8 VARCHAR2,
76 X_ATTRIBUTE9 VARCHAR2,
77 X_CANCELLED_QUANTITY NUMBER,
78 X_COMPONENT_CODE VARCHAR2,
79 X_COMPONENT_RATIO NUMBER,
80 X_COMPONENT_SEQUENCE_ID NUMBER,
81 X_CONFIGURATION_ITEM_FLAG VARCHAR2,
82 X_CONTEXT VARCHAR2,
83 X_CREATED_BY NUMBER,
84 X_CREATION_DATE DATE,
85 X_DATE_CONFIRMED DATE,
86 X_DATE_REQUESTED DATE,
87 X_DEMAND_CLASS_CODE VARCHAR2,
88 X_INCLUDED_ITEM_FLAG VARCHAR2,
89 X_INVENTORY_ITEM_ID NUMBER,
90 X_INVENTORY_STATUS VARCHAR2,
91 X_INVOICED_QUANTITY NUMBER,
92 X_LAST_UPDATED_BY NUMBER,
93 X_LAST_UPDATE_DATE DATE,
94 X_LAST_UPDATE_LOGIN NUMBER,
95 X_LATEST_ACCEPTABLE_DATE DATE,
96 X_LINE_DETAIL_ID NUMBER,
97 X_ORDER_LINE_ID NUMBER,
98 X_ORGANIZATION_ID NUMBER,
99 X_ORIGINAL_REQUESTED_QUANTITY NUMBER,
100 X_PICKING_HEADER_ID NUMBER,
101 X_PICKING_LINE_ID NUMBER,
102 X_PROGRAM_APPLICATION_ID NUMBER,
103 X_PROGRAM_ID NUMBER,
104 X_PROGRAM_UPDATE_DATE DATE,
105 X_RA_INTERFACE_STATUS VARCHAR2,
106 X_REQUESTED_QUANTITY NUMBER,
107 X_REQUEST_ID NUMBER,
108 X_SCHEDULE_DATE DATE,
109 X_SEQUENCE_NUMBER NUMBER,
110 X_SHIPMENT_PRIORITY_CODE VARCHAR2,
111 X_SHIPPED_QUANTITY NUMBER,
112 X_SHIP_METHOD_CODE VARCHAR2,
113 X_SHIP_TO_CONTACT_ID NUMBER,
114 X_SHIP_TO_SITE_USE_ID NUMBER,
115 X_UNIT_CODE VARCHAR2,
116 X_WAREHOUSE_ID NUMBER,
117 Result OUT VARCHAR2);
118
119 PROCEDURE Update_Row(X_Rowid VARCHAR2,
120 X_ATTRIBUTE1 VARCHAR2,
121 X_ATTRIBUTE10 VARCHAR2,
122 X_ATTRIBUTE11 VARCHAR2,
123 X_ATTRIBUTE12 VARCHAR2,
124 X_ATTRIBUTE13 VARCHAR2,
125 X_ATTRIBUTE14 VARCHAR2,
126 X_ATTRIBUTE15 VARCHAR2,
127 X_ATTRIBUTE2 VARCHAR2,
128 X_ATTRIBUTE3 VARCHAR2,
129 X_ATTRIBUTE4 VARCHAR2,
130 X_ATTRIBUTE5 VARCHAR2,
131 X_ATTRIBUTE6 VARCHAR2,
132 X_ATTRIBUTE7 VARCHAR2,
133 X_ATTRIBUTE8 VARCHAR2,
134 X_ATTRIBUTE9 VARCHAR2,
135 X_CANCELLED_QUANTITY NUMBER,
136 X_COMPONENT_CODE VARCHAR2,
137 X_COMPONENT_RATIO NUMBER,
138 X_COMPONENT_SEQUENCE_ID NUMBER,
139 X_CONFIGURATION_ITEM_FLAG VARCHAR2,
140 X_CONTEXT VARCHAR2,
141 X_CREATED_BY NUMBER,
142 X_CREATION_DATE DATE,
143 X_DATE_CONFIRMED DATE,
144 X_DATE_REQUESTED DATE,
145 X_DEMAND_CLASS_CODE VARCHAR2,
146 X_INCLUDED_ITEM_FLAG VARCHAR2,
147 X_INVENTORY_ITEM_ID NUMBER,
148 X_INVENTORY_STATUS VARCHAR2,
149 X_INVOICED_QUANTITY NUMBER,
150 X_LAST_UPDATED_BY NUMBER,
151 X_LAST_UPDATE_DATE DATE,
152 X_LAST_UPDATE_LOGIN NUMBER,
153 X_LATEST_ACCEPTABLE_DATE DATE,
154 X_LINE_DETAIL_ID NUMBER,
155 X_ORDER_LINE_ID NUMBER,
156 X_ORGANIZATION_ID NUMBER,
157 X_ORIGINAL_REQUESTED_QUANTITY NUMBER,
158 X_PICKING_HEADER_ID NUMBER,
159 X_PICKING_LINE_ID NUMBER,
160 X_PROGRAM_APPLICATION_ID NUMBER,
161 X_PROGRAM_ID NUMBER,
162 X_PROGRAM_UPDATE_DATE DATE,
163 X_RA_INTERFACE_STATUS VARCHAR2,
164 X_REQUESTED_QUANTITY NUMBER,
165 X_REQUEST_ID NUMBER,
166 X_SCHEDULE_DATE DATE,
167 X_SEQUENCE_NUMBER NUMBER,
168 X_SHIPMENT_PRIORITY_CODE VARCHAR2,
169 X_SHIPPED_QUANTITY NUMBER,
170 X_SHIP_METHOD_CODE VARCHAR2,
171 X_SHIP_TO_CONTACT_ID NUMBER,
172 X_SHIP_TO_SITE_USE_ID NUMBER,
173 X_UNIT_CODE VARCHAR2,
174 X_WAREHOUSE_ID NUMBER
175 );
176
177 END OE_SO_PLN_SERVER;