[Home] [Help]
PACKAGE BODY: APPS.RCV_TRX_INTERFACE_TRX_UPD_PKG
Source
1 PACKAGE BODY RCV_TRX_INTERFACE_TRX_UPD_PKG as
2 /* $Header: RCVTIR6B.pls 115.1 2002/11/23 00:57:44 sbull ship $ */
3
4 PROCEDURE update_rcv_transaction (
5 rcv_trx IN OUT NOCOPY rcv_transactions_interface%ROWTYPE) IS
6
7 X_rowid ROWID;
8 X_progress VARCHAR2(4) := '000';
9
10 BEGIN
11
12 /*
13 ** get the rowid for this transaction
14 */
15 X_progress := '010';
16
17 SELECT rowid
18 INTO X_Rowid
19 FROM rcv_transactions_interface
20 WHERE interface_transaction_id = rcv_trx.interface_transaction_id;
21
22 /*
23 ** Update the columns of the transaction
24 */
25 RCV_TRX_INTERFACE_UPDATE_PKG.update_row(
26 X_Rowid,
27 rcv_trx.Interface_Transaction_Id,
28 rcv_trx.Group_Id,
29 rcv_trx.Last_Update_Date,
30 rcv_trx.Last_Updated_By,
31 rcv_trx.Last_Update_Login,
32 rcv_trx.Transaction_Type,
33 rcv_trx.Transaction_Date,
34 rcv_trx.Processing_Status_Code,
35 rcv_trx.Processing_Mode_Code,
36 rcv_trx.Processing_Request_Id,
37 rcv_trx.Transaction_Status_Code,
38 rcv_trx.Category_Id,
39 rcv_trx.Quantity,
40 rcv_trx.Unit_Of_Measure,
41 rcv_trx.Interface_Source_Code,
42 rcv_trx.Interface_Source_Line_Id,
43 rcv_trx.Inv_Transaction_Id,
44 rcv_trx.Item_Id,
45 rcv_trx.Item_Description,
46 rcv_trx.Item_Revision,
47 rcv_trx.Uom_Code,
48 rcv_trx.Employee_Id,
49 rcv_trx.Auto_Transact_Code,
50 rcv_trx.Shipment_Header_Id,
51 rcv_trx.Shipment_Line_Id,
52 rcv_trx.Ship_To_Location_Id,
53 rcv_trx.Primary_Quantity,
54 rcv_trx.Primary_Unit_Of_Measure,
55 rcv_trx.Receipt_Source_Code,
56 rcv_trx.Vendor_Id,
57 rcv_trx.Vendor_Site_Id,
58 rcv_trx.From_Organization_Id,
59 rcv_trx.To_Organization_Id,
60 rcv_trx.Routing_Header_Id,
61 rcv_trx.Routing_Step_Id,
62 rcv_trx.Source_Document_Code,
63 rcv_trx.Parent_Transaction_Id,
64 rcv_trx.Po_Header_Id,
65 rcv_trx.Po_Revision_Num,
66 rcv_trx.Po_Release_Id,
67 rcv_trx.Po_Line_Id,
68 rcv_trx.Po_Line_Location_Id,
69 rcv_trx.Po_Unit_Price,
70 rcv_trx.Currency_Code,
71 rcv_trx.Currency_Conversion_Type,
72 rcv_trx.Currency_Conversion_Rate,
73 rcv_trx.Currency_Conversion_Date,
74 rcv_trx.Po_Distribution_Id,
75 rcv_trx.Requisition_Line_Id,
76 rcv_trx.Req_Distribution_Id,
77 rcv_trx.Charge_Account_Id,
78 rcv_trx.Substitute_Unordered_Code,
79 rcv_trx.Receipt_Exception_Flag,
80 rcv_trx.Accrual_Status_Code,
81 rcv_trx.Inspection_Status_Code,
82 rcv_trx.Inspection_Quality_Code,
83 rcv_trx.Destination_Type_Code,
84 rcv_trx.Deliver_To_Person_Id,
85 rcv_trx.Location_Id,
86 rcv_trx.Deliver_To_Location_Id,
87 rcv_trx.Subinventory,
88 rcv_trx.Locator_Id,
89 rcv_trx.Wip_Entity_Id,
90 rcv_trx.Wip_Line_Id,
91 rcv_trx.Department_Code,
92 rcv_trx.Wip_Repetitive_Schedule_Id,
93 rcv_trx.Wip_Operation_Seq_Num,
94 rcv_trx.Wip_Resource_Seq_Num,
95 rcv_trx.Bom_Resource_Id,
96 rcv_trx.Shipment_Num,
97 rcv_trx.Freight_Carrier_Code,
98 rcv_trx.Bill_Of_Lading,
99 rcv_trx.Packing_Slip,
100 rcv_trx.Shipped_Date,
101 rcv_trx.Expected_Receipt_Date,
102 rcv_trx.Actual_Cost,
103 rcv_trx.Transfer_Cost,
104 rcv_trx.Transportation_Cost,
105 rcv_trx.Transportation_Account_Id,
106 rcv_trx.Num_Of_Containers,
107 rcv_trx.Waybill_Airbill_Num,
108 rcv_trx.Vendor_Item_Num,
109 rcv_trx.Vendor_Lot_Num,
110 rcv_trx.Rma_Reference,
111 rcv_trx.Comments,
112 rcv_trx.Attribute_Category,
113 rcv_trx.Attribute1,
114 rcv_trx.Attribute2,
115 rcv_trx.Attribute3,
116 rcv_trx.Attribute4,
117 rcv_trx.Attribute5,
118 rcv_trx.Attribute6,
119 rcv_trx.Attribute7,
120 rcv_trx.Attribute8,
121 rcv_trx.Attribute9,
122 rcv_trx.Attribute10,
123 rcv_trx.Attribute11,
124 rcv_trx.Attribute12,
125 rcv_trx.Attribute13,
126 rcv_trx.Attribute14,
127 rcv_trx.Attribute15,
128 rcv_trx.Ship_Head_Attribute_Category,
129 rcv_trx.Ship_Head_Attribute1,
130 rcv_trx.Ship_Head_Attribute2,
131 rcv_trx.Ship_Head_Attribute3,
132 rcv_trx.Ship_Head_Attribute4,
133 rcv_trx.Ship_Head_Attribute5,
134 rcv_trx.Ship_Head_Attribute6,
135 rcv_trx.Ship_Head_Attribute7,
136 rcv_trx.Ship_Head_Attribute8,
137 rcv_trx.Ship_Head_Attribute9,
138 rcv_trx.Ship_Head_Attribute10,
139 rcv_trx.Ship_Head_Attribute11,
140 rcv_trx.Ship_Head_Attribute12,
141 rcv_trx.Ship_Head_Attribute13,
142 rcv_trx.Ship_Head_Attribute14,
143 rcv_trx.Ship_Head_Attribute15,
144 rcv_trx.Ship_Line_Attribute_Category,
145 rcv_trx.Ship_Line_Attribute1,
146 rcv_trx.Ship_Line_Attribute2,
147 rcv_trx.Ship_Line_Attribute3,
148 rcv_trx.Ship_Line_Attribute4,
149 rcv_trx.Ship_Line_Attribute5,
150 rcv_trx.Ship_Line_Attribute6,
151 rcv_trx.Ship_Line_Attribute7,
152 rcv_trx.Ship_Line_Attribute8,
153 rcv_trx.Ship_Line_Attribute9,
154 rcv_trx.Ship_Line_Attribute10,
155 rcv_trx.Ship_Line_Attribute11,
156 rcv_trx.Ship_Line_Attribute12,
157 rcv_trx.Ship_Line_Attribute13,
158 rcv_trx.Ship_Line_Attribute14,
159 rcv_trx.Ship_Line_Attribute15,
160 rcv_trx.Ussgl_Transaction_Code,
161 rcv_trx.Government_Context,
162 rcv_trx.Reason_Id,
163 rcv_trx.Destination_Context,
164 rcv_trx.Source_Doc_Quantity,
165 rcv_trx.Source_Doc_Unit_Of_Measure,
166 rcv_trx.Use_Mtl_Lot,
167 rcv_trx.Use_Mtl_Serial);
168
169 END update_rcv_transaction;
170
171 END RCV_TRX_INTERFACE_TRX_UPD_PKG;