eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE: APPS.OE_SO_PLD_TABLE

Source


1 PACKAGE OE_SO_PLD_TABLE AUTHID CURRENT_USER AS
2 /* $Header: oespdtbs.pls 115.1 99/07/16 08:28:29 porting shi $ */
3 
4 PROCEDURE Insert_Row(X_Rowid IN OUT VARCHAR2,
5     X_ATTRIBUTE1    VARCHAR2,
6     X_ATTRIBUTE10    VARCHAR2,
7     X_ATTRIBUTE11    VARCHAR2,
8     X_ATTRIBUTE12    VARCHAR2,
9     X_ATTRIBUTE13    VARCHAR2,
10     X_ATTRIBUTE14    VARCHAR2,
11     X_ATTRIBUTE15    VARCHAR2,
12     X_ATTRIBUTE2    VARCHAR2,
13     X_ATTRIBUTE3    VARCHAR2,
14     X_ATTRIBUTE4    VARCHAR2,
15     X_ATTRIBUTE5    VARCHAR2,
16     X_ATTRIBUTE6    VARCHAR2,
17     X_ATTRIBUTE7    VARCHAR2,
18     X_ATTRIBUTE8    VARCHAR2,
19     X_ATTRIBUTE9    VARCHAR2,
20     X_AUTOSCHEDULED_FLAG    VARCHAR2,
21     X_CONTEXT    VARCHAR2,
22     X_CREATED_BY    NUMBER,
23     X_CREATION_DATE    DATE,
24     X_CUSTOMER_REQUESTED_LOT_FLAG    VARCHAR2,
25     X_DELIVERY    NUMBER,
26     X_DEMAND_CLASS_CODE    VARCHAR2,
27     X_DEMAND_ID    NUMBER,
28     X_DETAIL_TYPE_CODE    VARCHAR2,
29     X_INVENTORY_LOCATION_ID    NUMBER,
30     X_INVENTORY_LOCATION_SEGMENTS    VARCHAR2,
31     X_LAST_UPDATED_BY    NUMBER,
32     X_LAST_UPDATE_DATE    DATE,
33     X_LAST_UPDATE_LOGIN    NUMBER,
34     X_LATEST_ACCEPTABLE_DATE    DATE,
35     X_LOT_NUMBER    VARCHAR2,
36     X_PICKING_LINE_DETAIL_ID    NUMBER,
37     X_PICKING_LINE_ID    NUMBER,
38     X_PROGRAM_APPLICATION_ID    NUMBER,
39     X_PROGRAM_ID    NUMBER,
40     X_PROGRAM_UPDATE_DATE    DATE,
41     X_RELEASED_FLAG    VARCHAR2,
42     X_REQUESTED_QUANTITY    NUMBER,
43     X_REQUEST_ID    NUMBER,
44     X_RESERVABLE_FLAG    VARCHAR2,
45     X_REVISION    VARCHAR2,
46     X_SCHEDULE_DATE    DATE,
47     X_SCHEDULE_LEVEL    NUMBER,
48     X_SCHEDULE_STATUS_CODE    VARCHAR2,
49     X_SEGMENT1    VARCHAR2,
50     X_SEGMENT10    VARCHAR2,
51     X_SEGMENT11    VARCHAR2,
52     X_SEGMENT12    VARCHAR2,
53     X_SEGMENT13    VARCHAR2,
54     X_SEGMENT14    VARCHAR2,
55     X_SEGMENT15    VARCHAR2,
56     X_SEGMENT16    VARCHAR2,
57     X_SEGMENT17    VARCHAR2,
58     X_SEGMENT18    VARCHAR2,
59     X_SEGMENT19    VARCHAR2,
60     X_SEGMENT2    VARCHAR2,
61     X_SEGMENT20    VARCHAR2,
62     X_SEGMENT3    VARCHAR2,
63     X_SEGMENT4    VARCHAR2,
64     X_SEGMENT5    VARCHAR2,
65     X_SEGMENT6    VARCHAR2,
66     X_SEGMENT7    VARCHAR2,
67     X_SEGMENT8    VARCHAR2,
68     X_SEGMENT9    VARCHAR2,
69     X_SERIAL_NUMBER    VARCHAR2,
70     X_SHIPPED_QUANTITY    NUMBER,
71     X_SUBINVENTORY    VARCHAR2,
72     X_SUPPLY_SOURCE_HEADER_ID    NUMBER,
73     X_SUPPLY_SOURCE_TYPE    NUMBER,
74     X_TRANSACTABLE_FLAG    VARCHAR2,
75     X_UPDATE_FLAG    VARCHAR2,
76     X_WAREHOUSE_ID    NUMBER,
77     X_WIP_COMPLETED_QUANTITY    NUMBER,
78     X_WIP_RESERVED_QUANTITY    NUMBER
79 );
80 PROCEDURE Lock_Row(X_Rowid VARCHAR2,
81     X_ATTRIBUTE1    VARCHAR2,
82     X_ATTRIBUTE10    VARCHAR2,
83     X_ATTRIBUTE11    VARCHAR2,
84     X_ATTRIBUTE12    VARCHAR2,
85     X_ATTRIBUTE13    VARCHAR2,
86     X_ATTRIBUTE14    VARCHAR2,
87     X_ATTRIBUTE15    VARCHAR2,
88     X_ATTRIBUTE2    VARCHAR2,
89     X_ATTRIBUTE3    VARCHAR2,
90     X_ATTRIBUTE4    VARCHAR2,
91     X_ATTRIBUTE5    VARCHAR2,
92     X_ATTRIBUTE6    VARCHAR2,
93     X_ATTRIBUTE7    VARCHAR2,
94     X_ATTRIBUTE8    VARCHAR2,
95     X_ATTRIBUTE9    VARCHAR2,
96     X_AUTOSCHEDULED_FLAG    VARCHAR2,
97     X_CONTEXT    VARCHAR2,
98     X_CREATED_BY    NUMBER,
99     X_CREATION_DATE    DATE,
100     X_CUSTOMER_REQUESTED_LOT_FLAG    VARCHAR2,
101     X_DELIVERY    NUMBER,
102     X_DEMAND_CLASS_CODE    VARCHAR2,
103     X_DEMAND_ID    NUMBER,
104     X_DETAIL_TYPE_CODE    VARCHAR2,
105     X_INVENTORY_LOCATION_ID    NUMBER,
106     X_INVENTORY_LOCATION_SEGMENTS    VARCHAR2,
107     X_LAST_UPDATED_BY    NUMBER,
108     X_LAST_UPDATE_DATE    DATE,
109     X_LAST_UPDATE_LOGIN    NUMBER,
110     X_LATEST_ACCEPTABLE_DATE    DATE,
111     X_LOT_NUMBER    VARCHAR2,
112     X_PICKING_LINE_DETAIL_ID    NUMBER,
113     X_PICKING_LINE_ID    NUMBER,
114     X_PROGRAM_APPLICATION_ID    NUMBER,
115     X_PROGRAM_ID    NUMBER,
116     X_PROGRAM_UPDATE_DATE    DATE,
117     X_RELEASED_FLAG    VARCHAR2,
118     X_REQUESTED_QUANTITY    NUMBER,
119     X_REQUEST_ID    NUMBER,
120     X_RESERVABLE_FLAG    VARCHAR2,
121     X_REVISION    VARCHAR2,
122     X_SCHEDULE_DATE    DATE,
123     X_SCHEDULE_LEVEL    NUMBER,
124     X_SCHEDULE_STATUS_CODE    VARCHAR2,
125     X_SEGMENT1    VARCHAR2,
126     X_SEGMENT10    VARCHAR2,
127     X_SEGMENT11    VARCHAR2,
128     X_SEGMENT12    VARCHAR2,
129     X_SEGMENT13    VARCHAR2,
130     X_SEGMENT14    VARCHAR2,
131     X_SEGMENT15    VARCHAR2,
132     X_SEGMENT16    VARCHAR2,
133     X_SEGMENT17    VARCHAR2,
134     X_SEGMENT18    VARCHAR2,
135     X_SEGMENT19    VARCHAR2,
136     X_SEGMENT2    VARCHAR2,
137     X_SEGMENT20    VARCHAR2,
138     X_SEGMENT3    VARCHAR2,
139     X_SEGMENT4    VARCHAR2,
140     X_SEGMENT5    VARCHAR2,
141     X_SEGMENT6    VARCHAR2,
142     X_SEGMENT7    VARCHAR2,
143     X_SEGMENT8    VARCHAR2,
144     X_SEGMENT9    VARCHAR2,
145     X_SERIAL_NUMBER    VARCHAR2,
146     X_SHIPPED_QUANTITY    NUMBER,
147     X_SUBINVENTORY    VARCHAR2,
148     X_SUPPLY_SOURCE_HEADER_ID    NUMBER,
149     X_SUPPLY_SOURCE_TYPE    NUMBER,
150     X_TRANSACTABLE_FLAG    VARCHAR2,
151     X_UPDATE_FLAG    VARCHAR2,
152     X_WAREHOUSE_ID    NUMBER,
153     X_WIP_COMPLETED_QUANTITY    NUMBER,
154     X_WIP_RESERVED_QUANTITY    NUMBER,
155     Result OUT VARCHAR2);
156 
157 PROCEDURE Update_Row(X_Rowid VARCHAR2,
158     X_ATTRIBUTE1    VARCHAR2,
159     X_ATTRIBUTE10    VARCHAR2,
160     X_ATTRIBUTE11    VARCHAR2,
161     X_ATTRIBUTE12    VARCHAR2,
162     X_ATTRIBUTE13    VARCHAR2,
163     X_ATTRIBUTE14    VARCHAR2,
164     X_ATTRIBUTE15    VARCHAR2,
165     X_ATTRIBUTE2    VARCHAR2,
166     X_ATTRIBUTE3    VARCHAR2,
167     X_ATTRIBUTE4    VARCHAR2,
168     X_ATTRIBUTE5    VARCHAR2,
169     X_ATTRIBUTE6    VARCHAR2,
170     X_ATTRIBUTE7    VARCHAR2,
171     X_ATTRIBUTE8    VARCHAR2,
172     X_ATTRIBUTE9    VARCHAR2,
173     X_AUTOSCHEDULED_FLAG    VARCHAR2,
174     X_CONTEXT    VARCHAR2,
175     X_CREATED_BY    NUMBER,
176     X_CREATION_DATE    DATE,
177     X_CUSTOMER_REQUESTED_LOT_FLAG    VARCHAR2,
178     X_DELIVERY    NUMBER,
179     X_DEMAND_CLASS_CODE    VARCHAR2,
180     X_DEMAND_ID    NUMBER,
181     X_DETAIL_TYPE_CODE    VARCHAR2,
182     X_INVENTORY_LOCATION_ID    NUMBER,
183     X_INVENTORY_LOCATION_SEGMENTS    VARCHAR2,
184     X_LAST_UPDATED_BY    NUMBER,
185     X_LAST_UPDATE_DATE    DATE,
186     X_LAST_UPDATE_LOGIN    NUMBER,
187     X_LATEST_ACCEPTABLE_DATE    DATE,
188     X_LOT_NUMBER    VARCHAR2,
189     X_PICKING_LINE_DETAIL_ID    NUMBER,
190     X_PICKING_LINE_ID    NUMBER,
191     X_PROGRAM_APPLICATION_ID    NUMBER,
192     X_PROGRAM_ID    NUMBER,
193     X_PROGRAM_UPDATE_DATE    DATE,
194     X_RELEASED_FLAG    VARCHAR2,
195     X_REQUESTED_QUANTITY    NUMBER,
196     X_REQUEST_ID    NUMBER,
197     X_RESERVABLE_FLAG    VARCHAR2,
198     X_REVISION    VARCHAR2,
199     X_SCHEDULE_DATE    DATE,
200     X_SCHEDULE_LEVEL    NUMBER,
201     X_SCHEDULE_STATUS_CODE    VARCHAR2,
202     X_SEGMENT1    VARCHAR2,
203     X_SEGMENT10    VARCHAR2,
204     X_SEGMENT11    VARCHAR2,
205     X_SEGMENT12    VARCHAR2,
206     X_SEGMENT13    VARCHAR2,
207     X_SEGMENT14    VARCHAR2,
208     X_SEGMENT15    VARCHAR2,
209     X_SEGMENT16    VARCHAR2,
210     X_SEGMENT17    VARCHAR2,
211     X_SEGMENT18    VARCHAR2,
212     X_SEGMENT19    VARCHAR2,
213     X_SEGMENT2    VARCHAR2,
214     X_SEGMENT20    VARCHAR2,
215     X_SEGMENT3    VARCHAR2,
216     X_SEGMENT4    VARCHAR2,
217     X_SEGMENT5    VARCHAR2,
218     X_SEGMENT6    VARCHAR2,
219     X_SEGMENT7    VARCHAR2,
220     X_SEGMENT8    VARCHAR2,
221     X_SEGMENT9    VARCHAR2,
222     X_SERIAL_NUMBER    VARCHAR2,
223     X_SHIPPED_QUANTITY    NUMBER,
224     X_SUBINVENTORY    VARCHAR2,
225     X_SUPPLY_SOURCE_HEADER_ID    NUMBER,
226     X_SUPPLY_SOURCE_TYPE    NUMBER,
227     X_TRANSACTABLE_FLAG    VARCHAR2,
228     X_UPDATE_FLAG    VARCHAR2,
229     X_WAREHOUSE_ID    NUMBER,
230     X_WIP_COMPLETED_QUANTITY    NUMBER,
231     X_WIP_RESERVED_QUANTITY    NUMBER
232 );
233 
234 PROCEDURE Delete_Row(X_Rowid VARCHAR2);
235 
236 END OE_SO_PLD_TABLE;