DBA Data[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;