1 PACKAGE mtl_movement_stat_pkg AUTHID CURRENT_USER AS
2 /* $Header: INVMVSTS.pls 120.0 2005/05/25 05:27:32 appldev noship $ */
3
4 -- Public Declarations:
5 -- user_id number
6 -- pseudo_movement_id number
7
8 user_id NUMBER;
9 pseudo_movement_id NUMBER;
10
11 -- Package
12 -- mtl_movement_stat_pkg
13
14 -- Purpose
15 -- This package defines all procedures that are called from
16 -- Inventory and AR autoinvoice interface.
17
18 -- History
19 -- MAR-10-95 Rudolf F. Reichenberger Created
20
21
22 -- *************************************************************
23 -- Procedure
24 -- upd_inv_movements
25
26 -- Purpose
27 -- This procedure is called from the inventory or cost
28 -- processor to update either the item unit cost or the
29 -- status, item unit cost, primary quantity, transaction
30 -- quantity and transaction uom code for movement
31 -- records in MTL_MOVEMENT_STATISTICS table.
32
33 -- History
34 -- MAR-10-95 Rudolf F. Reichenberger Created
35
36 -- Arguments
37 -- p_movement_id number
38 -- p_transaction_quantity number
39 -- p_primary_quantity number
40 -- p_transaction_uom varchar2
41 -- p_actual_cost number
42 -- p_transaction_date number
43 -- p_call_type varchar2
44
45 -- Example
46 -- mtl_movement_stat_pkg.upd_inv_movements ()
47
48 -- Notes
49
50 PROCEDURE upd_inv_movements (p_movement_id IN NUMBER,
51 p_transaction_quantity IN NUMBER,
52 p_primary_quantity IN NUMBER,
53 p_transaction_uom IN VARCHAR2,
54 p_actual_cost IN NUMBER,
55 p_transaction_date IN DATE,
56 p_call_type IN VARCHAR2);
57
58 -- ****************************************************************
59 -- Procedure
60 -- upd_ins_rcv_movements
61
62 -- Purpose
63 -- This procedure is called from the receiving processor after the
64 -- processor generates the appropriate ids and before the final
65 -- commit; the procedure will update the shipment_header_id,
66 -- shipment_line_id, quantity, etc.. for adjustment entries, the
67 -- procedure will insert a corresponding adjusting movement record.
68
69 -- History
70 -- Apr-07-95 Rudolf F. Reichenberger Created
71
72 -- Arguments
73 -- p_movement_id number
74 -- p_parent_movement_id number
75 -- p_shipment_header_id number
76 -- p_shipment_line_id number
77 -- p_transaction_quantity number
78 -- p_transaction_uom_code varchar2
79 -- p_type varchar2
80
81 -- Example
82 -- mtl_movement_stat_pkg.upd_ins_rcv_movements ()
83
84 -- Notes
85
86 PROCEDURE upd_ins_rcv_movements (
87 p_movement_id IN NUMBER,
88 p_parent_movement_id IN NUMBER,
89 p_shipment_header_id IN NUMBER,
90 p_shipment_line_id IN NUMBER,
91 p_transaction_quantity IN NUMBER,
92 p_transaction_uom_code IN VARCHAR2,
93 p_type IN VARCHAR2,
94 p_transaction_date IN DATE);
95
96 -- *******************************************************************
97
98 END mtl_movement_stat_pkg;