[Home] [Help]
PACKAGE BODY: APPS.RCV_TRX_INTERFACE_TRX_INS_PKG
Source
1 PACKAGE BODY RCV_TRX_INTERFACE_TRX_INS_PKG as
2 /* $Header: RCVTIR5B.pls 120.0.12010000.2 2008/08/04 08:42:20 rramasam ship $ */
3
4 /*===========================================================================
5
6 PROCEDURE NAME: insert_rcv_transaction
7
8 ===========================================================================*/
9 PROCEDURE insert_rcv_transaction (
10 rcv_trx IN OUT NOCOPY rcv_transactions_interface%ROWTYPE) IS
11
12 X_progress VARCHAR2(3) := '000';
13 X_rowid VARCHAR2(40);
14 BEGIN
15
16 rcv_trx_interface_insert_pkg.Insert_Row(X_Rowid,
17 rcv_trx.Interface_Transaction_Id,
18 rcv_trx.Group_Id,
19 rcv_trx.Last_Update_Date,
20 rcv_trx.Last_Updated_By,
21 rcv_trx.Creation_Date,
22 rcv_trx.Created_By,
23 rcv_trx.Last_Update_Login,
24 rcv_trx.Transaction_Type,
25 rcv_trx.Transaction_Date,
26 rcv_trx.Processing_Status_Code,
27 rcv_trx.Processing_Mode_Code,
28 rcv_trx.Processing_Request_Id,
29 rcv_trx.Transaction_Status_Code,
30 rcv_trx.Category_Id,
31 rcv_trx.Quantity,
32 rcv_trx.Unit_Of_Measure,
33 rcv_trx.Interface_Source_Code,
34 rcv_trx.Interface_Source_Line_Id,
35 rcv_trx.Inv_Transaction_Id,
36 rcv_trx.Item_Id,
37 rcv_trx.Item_Description,
38 rcv_trx.Item_Revision,
39 rcv_trx.Uom_Code,
40 rcv_trx.Employee_Id,
41 rcv_trx.Auto_Transact_Code,
42 rcv_trx.Shipment_Header_Id,
43 rcv_trx.Shipment_Line_Id,
44 rcv_trx.Ship_To_Location_Id,
45 rcv_trx.Primary_Quantity,
46 rcv_trx.Primary_Unit_Of_Measure,
47 rcv_trx.Receipt_Source_Code,
48 rcv_trx.Vendor_Id,
49 rcv_trx.Vendor_Site_Id,
50 rcv_trx.From_Organization_Id,
51 rcv_trx.To_Organization_Id,
52 rcv_trx.Routing_Header_Id,
53 rcv_trx.Routing_Step_Id,
54 rcv_trx.Source_Document_Code,
55 rcv_trx.Parent_Transaction_Id,
56 rcv_trx.Po_Header_Id,
57 rcv_trx.Po_Revision_Num,
58 rcv_trx.Po_Release_Id,
59 rcv_trx.Po_Line_Id,
60 rcv_trx.Po_Line_Location_Id,
61 rcv_trx.Po_Unit_Price,
62 rcv_trx.Currency_Code,
63 rcv_trx.Currency_Conversion_Type,
64 rcv_trx.Currency_Conversion_Rate,
65 rcv_trx.Currency_Conversion_Date,
66 rcv_trx.Po_Distribution_Id,
67 rcv_trx.Requisition_Line_Id,
68 rcv_trx.Req_Distribution_Id,
69 rcv_trx.Charge_Account_Id,
70 rcv_trx.Substitute_Unordered_Code,
71 rcv_trx.Receipt_Exception_Flag,
72 rcv_trx.Accrual_Status_Code,
73 rcv_trx.Inspection_Status_Code,
74 rcv_trx.Inspection_Quality_Code,
75 rcv_trx.Destination_Type_Code,
76 rcv_trx.Deliver_To_Person_Id,
77 rcv_trx.Location_Id,
78 rcv_trx.Deliver_To_Location_Id,
79 rcv_trx.Subinventory,
80 rcv_trx.Locator_Id,
81 rcv_trx.Wip_Entity_Id,
82 rcv_trx.Wip_Line_Id,
83 rcv_trx.Department_Code,
84 rcv_trx.Wip_Repetitive_Schedule_Id,
85 rcv_trx.Wip_Operation_Seq_Num,
86 rcv_trx.Wip_Resource_Seq_Num,
87 rcv_trx.Bom_Resource_Id,
88 rcv_trx.Shipment_Num,
89 rcv_trx.Freight_Carrier_Code,
90 rcv_trx.Bill_Of_Lading,
91 rcv_trx.Packing_Slip,
92 rcv_trx.Shipped_Date,
93 rcv_trx.Expected_Receipt_Date,
94 rcv_trx.Actual_Cost,
95 rcv_trx.Transfer_Cost,
96 rcv_trx.Transportation_Cost,
97 rcv_trx.Transportation_Account_Id,
98 rcv_trx.Num_Of_Containers,
99 rcv_trx.Waybill_Airbill_Num,
100 rcv_trx.Vendor_Item_Num,
101 rcv_trx.Vendor_Lot_Num,
102 rcv_trx.Rma_Reference,
103 rcv_trx.Comments,
104 rcv_trx.Attribute_Category,
105 rcv_trx.Attribute1,
106 rcv_trx.Attribute2,
107 rcv_trx.Attribute3,
108 rcv_trx.Attribute4,
109 rcv_trx.Attribute5,
110 rcv_trx.Attribute6,
111 rcv_trx.Attribute7,
112 rcv_trx.Attribute8,
113 rcv_trx.Attribute9,
114 rcv_trx.Attribute10,
115 rcv_trx.Attribute11,
116 rcv_trx.Attribute12,
117 rcv_trx.Attribute13,
118 rcv_trx.Attribute14,
119 rcv_trx.Attribute15,
120 rcv_trx.Ship_Head_Attribute_Category,
121 rcv_trx.Ship_Head_Attribute1,
122 rcv_trx.Ship_Head_Attribute2,
123 rcv_trx.Ship_Head_Attribute3,
124 rcv_trx.Ship_Head_Attribute4,
125 rcv_trx.Ship_Head_Attribute5,
126 rcv_trx.Ship_Head_Attribute6,
127 rcv_trx.Ship_Head_Attribute7,
128 rcv_trx.Ship_Head_Attribute8,
129 rcv_trx.Ship_Head_Attribute9,
130 rcv_trx.Ship_Head_Attribute10,
131 rcv_trx.Ship_Head_Attribute11,
132 rcv_trx.Ship_Head_Attribute12,
133 rcv_trx.Ship_Head_Attribute13,
134 rcv_trx.Ship_Head_Attribute14,
135 rcv_trx.Ship_Head_Attribute15,
136 rcv_trx.Ship_Line_Attribute_Category,
137 rcv_trx.Ship_Line_Attribute1,
138 rcv_trx.Ship_Line_Attribute2,
139 rcv_trx.Ship_Line_Attribute3,
140 rcv_trx.Ship_Line_Attribute4,
141 rcv_trx.Ship_Line_Attribute5,
142 rcv_trx.Ship_Line_Attribute6,
143 rcv_trx.Ship_Line_Attribute7,
144 rcv_trx.Ship_Line_Attribute8,
145 rcv_trx.Ship_Line_Attribute9,
146 rcv_trx.Ship_Line_Attribute10,
147 rcv_trx.Ship_Line_Attribute11,
148 rcv_trx.Ship_Line_Attribute12,
149 rcv_trx.Ship_Line_Attribute13,
150 rcv_trx.Ship_Line_Attribute14,
151 rcv_trx.Ship_Line_Attribute15,
152 rcv_trx.Ussgl_Transaction_Code,
153 rcv_trx.Government_Context,
154 rcv_trx.Reason_Id,
155 rcv_trx.Destination_Context,
156 rcv_trx.Source_Doc_Quantity,
157 rcv_trx.Source_Doc_Unit_Of_Measure,
158 rcv_trx.Use_Mtl_Lot,
159 rcv_trx.Use_Mtl_Serial,
160 NULL,
161 rcv_trx.Country_of_origin_code,
162 rcv_trx.oe_order_header_id,
163 rcv_trx.oe_order_line_id,
164 rcv_trx.customer_item_num,
165 rcv_trx.customer_id,
166 rcv_trx.customer_site_id,
167 rcv_trx.put_away_rule_id,
168 rcv_trx.put_away_strategy_id,
169 rcv_trx.lpn_id,
170 rcv_trx.transfer_lpn_id,
171 rcv_trx.cost_group_id,
172 rcv_trx.mmtt_temp_id,
173 rcv_trx.mobile_txn,
174 rcv_trx.transfer_cost_group_id,
175 /* Bug# 1548597 */
176 rcv_trx.secondary_quantity,
177 rcv_trx.secondary_unit_of_measure,
178 /* Bug 4392483 */
179 rcv_trx.lpn_group_id,
180 rcv_trx.org_id );
181
182 RETURN;
183
184 EXCEPTION
185 WHEN OTHERS THEN
186 po_message_s.sql_error('insert_rcv_transaction', X_progress, sqlcode);
187 RAISE;
188
189 END insert_rcv_transaction;
190
191 END RCV_TRX_INTERFACE_TRX_INS_PKG;