[Home] [Help]
PACKAGE BODY: APPS.MTL_MOVEMENT_STATISTICS3_PKG
Source
1 PACKAGE BODY MTL_MOVEMENT_STATISTICS3_PKG as
2 /* $Header: INVTTM3B.pls 120.1 2005/07/01 13:29:31 appldev ship $ */
3
4 procedure update_row( v_rowid varchar2,
5 v_movement_id number,
6 v_parent_movement_id number,
7 v_Organization_Id number,
8 v_Last_Update_Date date,
9 v_Last_Updated_By number,
10 v_Last_Update_Login number,
11 v_movement_type varchar2,
12 v_document_source_type varchar2,
13 v_entity_org_id number,
14 v_Transaction_date date,
15 v_movement_status varchar2,
16 v_go_detail varchar2,
17 v_from_org_id number,
18 v_from_org_name varchar2,
19 v_to_org_id number,
20 v_to_org_name varchar2,
21 v_customer_name varchar2,
22 v_customer_number varchar2,
23 v_customer_location varchar2,
24 v_ship_to_customer_id number,
25 v_ship_to_site_use_id number,
26 v_vendor_name varchar2,
27 v_vendor_number varchar2,
28 v_vendor_site varchar2,
29 v_vendor_id number,
30 v_vendor_site_id number,
31 v_po_header_id number,
32 v_order_header_id number,
33 v_requisition_header_id number,
34 v_doc_reference varchar2,
35 v_po_line_id number,
36 v_order_line_id number,
37 v_requisition_line_id number,
38 v_doc_line_reference varchar2,
39 v_shipment_header_id number,
40 v_shipment_reference varchar2,
41 v_shipment_line_id number,
42 v_shipment_line_reference varchar2,
43 v_po_line_location_id number,
44 v_picking_line_id number,
45 v_picking_line_detail_id number,
46 v_pick_slip_reference varchar2,
47 v_bill_to_name varchar2,
48 v_bill_to_number varchar2,
49 v_bill_to_site varchar2,
50 v_bill_to_customer_id number,
51 v_bill_to_site_use_id number,
52 v_invoice_batch_id number,
53 v_invoice_batch_reference varchar2,
54 v_invoice_id number,
55 v_invoice_reference varchar2,
56 v_customer_trx_line_id number,
57 v_invoice_line_reference varchar2,
58 v_invoice_qty number,
59 v_invoice_unit_price number,
60 v_invoice_line_ext_val number,
61 v_invoice_date_reference date,
62 v_inventory_item_id number,
63 v_item_cost number,
64 v_item_desc varchar2,
65 v_commodity_code varchar2,
66 v_commodity_code_description varchar2,
67 v_category_id number,
68 v_transaction_uom_code varchar2,
69 v_transaction_qty number,
70 v_document_unit_price number,
71 v_document_line_ext_value number,
72 v_primary_qty number,
73 v_dispatch_terr_code varchar2,
74 v_destination_terr_code varchar2,
75 v_origin_terr_code varchar2,
76 v_txn_nature varchar2,
77 v_delivery_terms varchar2,
78 v_transport_mode varchar2,
79 v_area varchar2,
80 v_port varchar2,
81 v_stat_type varchar2,
82 v_weight_method varchar2,
83 v_unit_weight number ,
84 v_total_weight number ,
85 v_stat_adj_pct number ,
86 v_stat_adj_amt number ,
87 v_stat_ext_val number ,
88 v_stat_method varchar2,
89 v_comments varchar2,
90 v_alt_qty number,
91 v_alt_uom_code varchar2,
92 v_outside_code varchar2,
93 v_outside_unit_price number,
94 v_outside_ext_val number,
95 v_currency_code varchar2,
96 v_attribute_category varchar2,
97 v_attribute1 varchar2 ,
98 v_attribute2 varchar2 ,
99 v_attribute3 varchar2 ,
100 v_attribute4 varchar2 ,
101 v_attribute5 varchar2 ,
102 v_attribute6 varchar2 ,
103 v_attribute7 varchar2 ,
104 v_attribute8 varchar2 ,
105 v_attribute9 varchar2 ,
106 v_attribute10 varchar2 ,
107 v_attribute11 varchar2 ,
108 v_attribute12 varchar2 ,
109 v_attribute13 varchar2 ,
110 v_attribute14 varchar2 ,
111 v_attribute15 varchar2) is
112
113 begin
114 update mtl_movement_statistics
115 set
116 MOVEMENT_ID = v_movement_id,
117 ORGANIZATION_ID = v_organization_id,
118 ENTITY_ORG_ID = v_entity_org_id,
119 MOVEMENT_TYPE = v_movement_type,
120 MOVEMENT_STATUS = v_movement_status,
121 TRANSACTION_DATE = v_transaction_date,
122 LAST_UPDATE_DATE = v_last_update_date,
123 LAST_UPDATED_BY = v_last_updated_by,
124 LAST_UPDATE_LOGIN = v_last_update_login,
125 DOCUMENT_SOURCE_TYPE = v_document_source_type,
126 CREATION_METHOD = decode(v_go_detail, null, 'M', 'Z'),
127 DOCUMENT_REFERENCE = v_doc_reference,
128 DOCUMENT_LINE_REFERENCE = v_doc_line_reference,
129 DOCUMENT_UNIT_PRICE = v_document_unit_price,
130 DOCUMENT_LINE_EXT_VALUE = v_document_line_ext_value,
131 RECEIPT_REFERENCE = null,
132 SHIPMENT_REFERENCE = v_shipment_reference,
133 SHIPMENT_LINE_REFERENCE = v_shipment_line_reference,
134 PICK_SLIP_REFERENCE = v_pick_slip_reference,
135 CUSTOMER_NAME = v_customer_name,
136 CUSTOMER_NUMBER = v_customer_number,
137 CUSTOMER_LOCATION = v_customer_location,
138 TRANSACTING_FROM_ORG = v_from_org_name,
139 TRANSACTING_TO_ORG = v_to_org_name,
140 VENDOR_NAME = v_vendor_name,
141 VENDOR_NUMBER = v_vendor_number,
142 VENDOR_SITE = v_vendor_site,
143 BILL_TO_NAME = v_bill_to_name,
144 BILL_TO_NUMBER = v_bill_to_number,
145 BILL_TO_SITE = v_bill_to_site,
146 PO_HEADER_ID = v_po_header_id,
147 PO_LINE_ID = v_po_line_id,
148 PO_LINE_LOCATION_ID = v_po_line_location_id,
149 PICKING_LINE_ID = v_picking_line_id,
150 PICKING_LINE_DETAIL_ID = v_picking_line_detail_id,
151 ORDER_HEADER_ID = v_order_header_id,
152 ORDER_LINE_ID = v_order_line_id,
153 REQUISITION_HEADER_ID = v_requisition_header_id,
154 REQUISITION_LINE_ID = v_requisition_line_id,
155 SHIPMENT_HEADER_ID = v_shipment_header_id,
156 SHIPMENT_LINE_ID = v_shipment_line_id,
157 SHIP_TO_CUSTOMER_ID = v_ship_to_customer_id,
158 SHIP_TO_SITE_USE_ID = v_ship_to_site_use_id,
159 BILL_TO_CUSTOMER_ID = v_bill_to_customer_id,
160 BILL_TO_SITE_USE_ID = v_bill_to_site_use_id,
161 VENDOR_ID = v_vendor_id,
162 VENDOR_SITE_ID = v_vendor_site_id,
163 INVENTORY_ITEM_ID = v_inventory_item_id,
164 FROM_ORGANIZATION_ID = v_from_org_id,
165 TO_ORGANIZATION_ID = v_to_org_id,
166 ITEM_DESCRIPTION = v_item_desc,
167 ITEM_COST = v_item_cost,
168 TRANSACTION_QUANTITY = v_transaction_qty,
169 TRANSACTION_UOM_CODE = v_transaction_uom_code,
170 PRIMARY_QUANTITY = v_primary_qty,
171 INVOICE_BATCH_ID = v_invoice_batch_id,
172 INVOICE_ID = v_invoice_id,
173 CUSTOMER_TRX_LINE_ID = v_customer_trx_line_id,
174 INVOICE_BATCH_REFERENCE = v_invoice_batch_reference,
175 INVOICE_REFERENCE = v_invoice_reference,
176 INVOICE_LINE_REFERENCE = v_invoice_line_reference,
177 INVOICE_DATE_REFERENCE = v_invoice_date_reference,
178 INVOICE_QUANTITY = v_invoice_qty,
179 INVOICE_UNIT_PRICE = v_invoice_unit_price,
180 INVOICE_LINE_EXT_VALUE = v_invoice_line_ext_val,
181 OUTSIDE_CODE = v_outside_code,
182 OUTSIDE_EXT_VALUE = v_outside_ext_val,
183 OUTSIDE_UNIT_PRICE = v_outside_unit_price,
184 CURRENCY_CODE = v_currency_code,
185 CATEGORY_ID = v_category_id,
186 COMMODITY_CODE = v_commodity_code,
187 COMMODITY_DESCRIPTION = v_commodity_code_description,
188 WEIGHT_METHOD = v_weight_method,
189 UNIT_WEIGHT = v_unit_weight,
190 TOTAL_WEIGHT = v_total_weight,
191 TRANSACTION_NATURE = v_txn_nature,
192 DELIVERY_TERMS = v_delivery_terms,
193 TRANSPORT_MODE = v_transport_mode,
194 ALTERNATE_QUANTITY = v_alt_qty,
195 ALTERNATE_UOM_CODE = v_alt_uom_code,
196 DISPATCH_TERRITORY_CODE = v_dispatch_terr_code,
197 DESTINATION_TERRITORY_CODE = v_destination_terr_code,
198 ORIGIN_TERRITORY_CODE = v_origin_terr_code,
199 STAT_METHOD = v_stat_method,
200 STAT_ADJ_PERCENT = v_stat_adj_pct,
201 STAT_ADJ_AMOUNT = v_stat_adj_amt,
202 STAT_EXT_VALUE = v_stat_ext_val,
203 AREA = v_area,
204 PORT = v_port,
205 STAT_TYPE = v_stat_type,
206 COMMENTS = v_comments,
207 ATTRIBUTE_CATEGORY = v_attribute_category,
208 ATTRIBUTE1 = v_attribute1,
209 ATTRIBUTE2 = v_attribute2,
210 ATTRIBUTE3 = v_attribute3,
211 ATTRIBUTE4 = v_attribute4,
212 ATTRIBUTE5 = v_attribute5,
213 ATTRIBUTE6 = v_attribute6,
214 ATTRIBUTE7 = v_attribute7,
215 ATTRIBUTE8 = v_attribute8,
216 ATTRIBUTE9 = v_attribute9,
217 ATTRIBUTE10 = v_attribute10,
218 ATTRIBUTE11 = v_attribute11,
219 ATTRIBUTE12 = v_attribute12,
220 ATTRIBUTE13 = v_attribute13,
221 ATTRIBUTE14 = v_attribute14,
222 ATTRIBUTE15 = v_attribute15
223 where rowid = v_rowid;
224
225 if (SQL%NOTFOUND) then
226 Raise NO_DATA_FOUND;
227 end if;
228
229
230 end update_row;
231
232 END MTL_MOVEMENT_STATISTICS3_PKG;