[Home] [Help]
PACKAGE BODY: APPS.RCV_TRX_INTERFACE_PRINT_PKG
Source
1 PACKAGE BODY RCV_TRX_INTERFACE_PRINT_PKG as
2 /* $Header: RCVTIR7B.pls 120.2 2005/06/21 18:57:09 wkunz noship $ */
3
4 PROCEDURE print_rcv_transaction (
5 X_interface_transaction_id IN NUMBER) IS
6
7 rcv_trx rcv_transactions_interface%ROWTYPE;
8 X_progress VARCHAR2(4) := '000';
9
10 BEGIN
11
12 dbms_output.enable (50000);
13
14 /*
15 ** get the transaction
16 */
17 X_progress := '010';
18
19 SELECT *
20 INTO rcv_trx
21 FROM rcv_transactions_interface
22 WHERE interface_transaction_id = X_interface_transaction_id;
23
24 /*
25 ** print the columns of the transaction
26 */
27 dbms_output.put_line('Interface_Transaction_Id : ' ||
28 TO_CHAR(rcv_trx.Interface_Transaction_Id));
29 dbms_output.put_line('Group_Id : ' ||
30 TO_CHAR(rcv_trx.Group_Id));
31 dbms_output.put_line('Last_Update_Date : ' ||
32 TO_CHAR(rcv_trx.Last_Update_Date));
33 dbms_output.put_line('Last_Updated_By : ' ||
34 TO_CHAR(rcv_trx.Last_Updated_By));
35 dbms_output.put_line('Last_Update_Login : ' ||
36 TO_CHAR(rcv_trx.Last_Update_Login));
37 dbms_output.put_line('Transaction_Type : ' ||
38 rcv_trx.Transaction_Type);
39 dbms_output.put_line('Transaction_Date : ' ||
40 TO_CHAR(rcv_trx.Transaction_Date));
41 dbms_output.put_line('Processing_Status_Code : ' ||
42 rcv_trx.Processing_Status_Code);
43 dbms_output.put_line('Processing_Mode_Code : ' ||
44 rcv_trx.Processing_Mode_Code);
45 dbms_output.put_line('Processing_Request_Id : ' ||
46 TO_CHAR(rcv_trx.Processing_Request_Id));
47 dbms_output.put_line('Transaction_Status_Code : ' ||
48 rcv_trx.Transaction_Status_Code);
49 dbms_output.put_line('Category_Id : ' ||
50 TO_CHAR(rcv_trx.Category_Id));
51 dbms_output.put_line('Quantity : ' ||
52 TO_CHAR(rcv_trx.Quantity));
53 dbms_output.put_line('Unit_Of_Measure : ' ||
54 rcv_trx.Unit_Of_Measure);
55 dbms_output.put_line('Interface_Source_Code : ' ||
56 rcv_trx.Interface_Source_Code);
57 dbms_output.put_line('Interface_Source_Line_Id : ' ||
58 TO_CHAR(rcv_trx.Interface_Source_Line_Id));
59 dbms_output.put_line('Inv_Transaction_Id : ' ||
60 TO_CHAR(rcv_trx.Inv_Transaction_Id));
61 dbms_output.put_line('Item_Id : ' ||
62 TO_CHAR(rcv_trx.Item_Id));
63 dbms_output.put_line('Item_Description : ' ||
64 rcv_trx.Item_Description);
65 dbms_output.put_line('Item_Revision : ' ||
66 rcv_trx.Item_Revision);
67 dbms_output.put_line('Uom_Code : ' ||
68 rcv_trx.Uom_Code);
69 dbms_output.put_line('Employee_Id : ' ||
70 TO_CHAR(rcv_trx.Employee_Id));
71 dbms_output.put_line('Auto_Transact_Code : ' ||
72 rcv_trx.Auto_Transact_Code);
73 dbms_output.put_line('Shipment_Header_Id : ' ||
74 TO_CHAR(rcv_trx.Shipment_Header_Id));
75 dbms_output.put_line('Shipment_Line_Id : ' ||
76 TO_CHAR(rcv_trx.Shipment_Line_Id));
77 dbms_output.put_line('Ship_To_Location_Id : ' ||
78 TO_CHAR(rcv_trx.Ship_To_Location_Id));
79 dbms_output.put_line('Primary_Quantity : ' ||
80 TO_CHAR(rcv_trx.Primary_Quantity));
81 dbms_output.put_line('Primary_Unit_Of_Measure : ' ||
82 rcv_trx.Primary_Unit_Of_Measure);
83 dbms_output.put_line('Receipt_Source_Code : ' ||
84 rcv_trx.Receipt_Source_Code);
85 dbms_output.put_line('Vendor_Id : ' ||
86 TO_CHAR(rcv_trx.Vendor_Id));
87 dbms_output.put_line('Vendor_Site_Id : ' ||
88 TO_CHAR(rcv_trx.Vendor_Site_Id));
89 dbms_output.put_line('From_Organization_Id : ' ||
90 TO_CHAR(rcv_trx.From_Organization_Id));
91 dbms_output.put_line('To_Organization_Id : ' ||
92 TO_CHAR(rcv_trx.To_Organization_Id));
93 dbms_output.put_line('Routing_Header_Id : ' ||
94 TO_CHAR(rcv_trx.Routing_Header_Id));
95 dbms_output.put_line('Routing_Step_Id : ' ||
96 TO_CHAR(rcv_trx.Routing_Step_Id));
97 dbms_output.put_line('Source_Document_Code : ' ||
98 rcv_trx.Source_Document_Code);
99 dbms_output.put_line('Parent_Transaction_Id : ' ||
100 TO_CHAR(rcv_trx.Parent_Transaction_Id));
101 dbms_output.put_line('Po_Header_Id : ' ||
102 TO_CHAR(rcv_trx.Po_Header_Id));
103 dbms_output.put_line('Po_Revision_Num : ' ||
104 TO_CHAR(rcv_trx.Po_Revision_Num));
105 dbms_output.put_line('Po_Release_Id : ' ||
106 TO_CHAR(rcv_trx.Po_Release_Id));
107 dbms_output.put_line('Po_Line_Id : ' ||
108 TO_CHAR(rcv_trx.Po_Line_Id));
109 dbms_output.put_line('Po_Line_Location_Id : ' ||
110 TO_CHAR(rcv_trx.Po_Line_Location_Id));
111 dbms_output.put_line('Po_Unit_Price : ' ||
112 TO_CHAR(rcv_trx.Po_Unit_Price));
113 dbms_output.put_line('Currency_Code : ' ||
114 rcv_trx.Currency_Code);
115 dbms_output.put_line('Currency_Conversion_Type : ' ||
116 rcv_trx.Currency_Conversion_Type);
117 dbms_output.put_line('Currency_Conversion_Rate : ' ||
118 TO_CHAR(rcv_trx.Currency_Conversion_Rate));
119 dbms_output.put_line('Currency_Conversion_Date : ' ||
120 TO_CHAR(rcv_trx.Currency_Conversion_Date));
121 dbms_output.put_line('Po_Distribution_Id : ' ||
122 TO_CHAR(rcv_trx.Po_Distribution_Id));
123 dbms_output.put_line('Requisition_Line_Id : ' ||
124 TO_CHAR(rcv_trx.Requisition_Line_Id));
125 dbms_output.put_line('Req_Distribution_Id : ' ||
126 TO_CHAR(rcv_trx.Req_Distribution_Id));
127 dbms_output.put_line('Charge_Account_Id : ' ||
128 TO_CHAR(rcv_trx.Charge_Account_Id));
129 dbms_output.put_line('Substitute_Unordered_Code : ' ||
130 rcv_trx.Substitute_Unordered_Code);
131 dbms_output.put_line('Receipt_Exception_Flag : ' ||
132 rcv_trx.Receipt_Exception_Flag);
133 dbms_output.put_line('Accrual_Status_Code : ' ||
134 rcv_trx.Accrual_Status_Code);
135 dbms_output.put_line('Inspection_Status_Code : ' ||
136 rcv_trx.Inspection_Status_Code);
137 dbms_output.put_line('Inspection_Quality_Code : ' ||
138 rcv_trx.Inspection_Quality_Code);
139 dbms_output.put_line('Destination_Type_Code : ' ||
140 rcv_trx.Destination_Type_Code);
141 dbms_output.put_line('Deliver_To_Person_Id : ' ||
142 TO_CHAR(rcv_trx.Deliver_To_Person_Id));
143 dbms_output.put_line('Location_Id : ' ||
144 TO_CHAR(rcv_trx.Location_Id));
145 dbms_output.put_line('Deliver_To_Location_Id : ' ||
146 TO_CHAR(rcv_trx.Deliver_To_Location_Id));
147 dbms_output.put_line('Subinventory : ' ||
148 rcv_trx.Subinventory);
149 dbms_output.put_line('Locator_Id : ' ||
150 TO_CHAR(rcv_trx.Locator_Id));
151 dbms_output.put_line('Wip_Entity_Id : ' ||
152 TO_CHAR(rcv_trx.Wip_Entity_Id));
153 dbms_output.put_line('Wip_Line_Id : ' ||
154 TO_CHAR(rcv_trx.Wip_Line_Id));
155 dbms_output.put_line('Department_Code : ' ||
156 rcv_trx.Department_Code);
157 dbms_output.put_line('Wip_Repetitive_Schedule_Id : ' ||
158 TO_CHAR(rcv_trx.Wip_Repetitive_Schedule_Id));
159 dbms_output.put_line('Wip_Operation_Seq_Num : ' ||
160 TO_CHAR(rcv_trx.Wip_Operation_Seq_Num));
161 dbms_output.put_line('Wip_Resource_Seq_Num : ' ||
162 TO_CHAR(rcv_trx.Wip_Resource_Seq_Num));
163 dbms_output.put_line('Bom_Resource_Id : ' ||
164 TO_CHAR(rcv_trx.Bom_Resource_Id));
165 dbms_output.put_line('Shipment_Num : ' ||
166 rcv_trx.Shipment_Num);
167 dbms_output.put_line('Freight_Carrier_Code : ' ||
168 rcv_trx.Freight_Carrier_Code);
169 dbms_output.put_line('Bill_Of_Lading : ' ||
170 rcv_trx.Bill_Of_Lading);
171 dbms_output.put_line('Packing_Slip : ' ||
172 rcv_trx.Packing_Slip);
173 dbms_output.put_line('Shipped_Date : ' ||
174 TO_CHAR(rcv_trx.Shipped_Date));
175 dbms_output.put_line('Expected_Receipt_Date : ' ||
176 TO_CHAR(rcv_trx.Expected_Receipt_Date));
177 dbms_output.put_line('Actual_Cost : ' ||
178 TO_CHAR(rcv_trx.Actual_Cost));
179 dbms_output.put_line('Transfer_Cost : ' ||
180 TO_CHAR(rcv_trx.Transfer_Cost));
181 dbms_output.put_line('Transportation_Cost : ' ||
182 TO_CHAR(rcv_trx.Transportation_Cost));
183 dbms_output.put_line('Transportation_Account_Id : ' ||
184 TO_CHAR(rcv_trx.Transportation_Account_Id));
185 dbms_output.put_line('Num_Of_Containers : ' ||
186 TO_CHAR(rcv_trx.Num_Of_Containers));
187 dbms_output.put_line('Waybill_Airbill_Num : ' ||
188 rcv_trx.Waybill_Airbill_Num);
189 dbms_output.put_line('Vendor_Item_Num : ' ||
190 rcv_trx.Vendor_Item_Num);
191 dbms_output.put_line('Vendor_Lot_Num : ' ||
192 rcv_trx.Vendor_Lot_Num);
193 dbms_output.put_line('Rma_Reference : ' ||
194 rcv_trx.Rma_Reference);
195 dbms_output.put_line('Comments : ' ||
196 rcv_trx.Comments);
197 dbms_output.put_line('Attribute_Category : ' ||
198 rcv_trx.Attribute_Category);
199 dbms_output.put_line('Attribute1 : ' ||
200 rcv_trx.Attribute1);
201 dbms_output.put_line('Attribute2 : ' ||
202 rcv_trx.Attribute2);
203 dbms_output.put_line('Attribute3 : ' ||
204 rcv_trx.Attribute3);
205 dbms_output.put_line('Attribute4 : ' ||
206 rcv_trx.Attribute4);
207 dbms_output.put_line('Attribute5 : ' ||
208 rcv_trx.Attribute5);
209 dbms_output.put_line('Attribute6 : ' ||
210 rcv_trx.Attribute6);
211 dbms_output.put_line('Attribute7 : ' ||
212 rcv_trx.Attribute7);
213 dbms_output.put_line('Attribute8 : ' ||
214 rcv_trx.Attribute8);
215 dbms_output.put_line('Attribute9 : ' ||
216 rcv_trx.Attribute9);
217 dbms_output.put_line('Attribute10 : ' ||
218 rcv_trx.Attribute10);
219 dbms_output.put_line('Attribute11 : ' ||
220 rcv_trx.Attribute11);
221 dbms_output.put_line('Attribute12 : ' ||
222 rcv_trx.Attribute12);
223 dbms_output.put_line('Attribute13 : ' ||
224 rcv_trx.Attribute13);
225 dbms_output.put_line('Attribute14 : ' ||
226 rcv_trx.Attribute14);
227 dbms_output.put_line('Attribute15 : ' ||
228 rcv_trx.Attribute15);
229 dbms_output.put_line('Ship_Head_Attribute_Category : ' ||
230 rcv_trx.Ship_Head_Attribute_Category);
231 dbms_output.put_line('Ship_Head_Attribute1 : ' ||
232 rcv_trx.Ship_Head_Attribute1);
233 dbms_output.put_line('Ship_Head_Attribute2 : ' ||
234 rcv_trx.Ship_Head_Attribute2);
235 dbms_output.put_line('Ship_Head_Attribute3 : ' ||
236 rcv_trx.Ship_Head_Attribute3);
237 dbms_output.put_line('Ship_Head_Attribute4 : ' ||
238 rcv_trx.Ship_Head_Attribute4);
239 dbms_output.put_line('Ship_Head_Attribute5 : ' ||
240 rcv_trx.Ship_Head_Attribute5);
241 dbms_output.put_line('Ship_Head_Attribute6 : ' ||
242 rcv_trx.Ship_Head_Attribute6);
243 dbms_output.put_line('Ship_Head_Attribute7 : ' ||
244 rcv_trx.Ship_Head_Attribute7);
245 dbms_output.put_line('Ship_Head_Attribute8 : ' ||
246 rcv_trx.Ship_Head_Attribute8);
247 dbms_output.put_line('Ship_Head_Attribute9 : ' ||
248 rcv_trx.Ship_Head_Attribute9);
249 dbms_output.put_line('Ship_Head_Attribute10 : ' ||
250 rcv_trx.Ship_Head_Attribute10);
251 dbms_output.put_line('Ship_Head_Attribute11 : ' ||
252 rcv_trx.Ship_Head_Attribute11);
253 dbms_output.put_line('Ship_Head_Attribute12 : ' ||
254 rcv_trx.Ship_Head_Attribute12);
255 dbms_output.put_line('Ship_Head_Attribute13 : ' ||
256 rcv_trx.Ship_Head_Attribute13);
257 dbms_output.put_line('Ship_Head_Attribute14 : ' ||
258 rcv_trx.Ship_Head_Attribute14);
259 dbms_output.put_line('Ship_Head_Attribute15 : ' ||
260 rcv_trx.Ship_Head_Attribute15);
261 dbms_output.put_line('Ship_Line_Attribute_Category : ' ||
262 rcv_trx.Ship_Line_Attribute_Category);
263 dbms_output.put_line('Ship_Line_Attribute1 : ' ||
264 rcv_trx.Ship_Line_Attribute1);
265 dbms_output.put_line('Ship_Line_Attribute2 : ' ||
266 rcv_trx.Ship_Line_Attribute2);
267 dbms_output.put_line('Ship_Line_Attribute3 : ' ||
268 rcv_trx.Ship_Line_Attribute3);
269 dbms_output.put_line('Ship_Line_Attribute4 : ' ||
270 rcv_trx.Ship_Line_Attribute4);
271 dbms_output.put_line('Ship_Line_Attribute5 : ' ||
272 rcv_trx.Ship_Line_Attribute5);
273 dbms_output.put_line('Ship_Line_Attribute6 : ' ||
274 rcv_trx.Ship_Line_Attribute6);
275 dbms_output.put_line('Ship_Line_Attribute7 : ' ||
276 rcv_trx.Ship_Line_Attribute7);
277 dbms_output.put_line('Ship_Line_Attribute8 : ' ||
278 rcv_trx.Ship_Line_Attribute8);
279 dbms_output.put_line('Ship_Line_Attribute9 : ' ||
280 rcv_trx.Ship_Line_Attribute9);
281 dbms_output.put_line('Ship_Line_Attribute10 : ' ||
282 rcv_trx.Ship_Line_Attribute10);
283 dbms_output.put_line('Ship_Line_Attribute11 : ' ||
284 rcv_trx.Ship_Line_Attribute11);
285 dbms_output.put_line('Ship_Line_Attribute12 : ' ||
286 rcv_trx.Ship_Line_Attribute12);
287 dbms_output.put_line('Ship_Line_Attribute13 : ' ||
288 rcv_trx.Ship_Line_Attribute13);
289 dbms_output.put_line('Ship_Line_Attribute14 : ' ||
290 rcv_trx.Ship_Line_Attribute14);
291 dbms_output.put_line('Ship_Line_Attribute15 : ' ||
292 rcv_trx.Ship_Line_Attribute15);
293 dbms_output.put_line('Ussgl_Transaction_Code : ' ||
294 rcv_trx.Ussgl_Transaction_Code);
295 dbms_output.put_line('Government_Context : ' ||
296 rcv_trx.Government_Context);
297 dbms_output.put_line('Reason_Id : ' ||
298 TO_CHAR(rcv_trx.Reason_Id));
299 dbms_output.put_line('Destination_Context : ' ||
300 rcv_trx.Destination_Context);
301 dbms_output.put_line('Source_Doc_Quantity : ' ||
302 TO_CHAR(rcv_trx.Source_Doc_Quantity));
303 dbms_output.put_line('Source_Doc_Unit_Of_Measure) : ' ||
304 rcv_trx.Source_Doc_Unit_Of_Measure);
305 dbms_output.put_line('---------------------------------' || ' END ' ||
306 '---------------------------------');
307 END print_rcv_transaction;
308
309 END RCV_TRX_INTERFACE_PRINT_PKG;