1 PACKAGE CST_Inventory_PUB AS
2 /* $Header: CSTPIVTS.pls 120.1 2005/10/06 22:35:51 rajagraw noship $ */
3 -- Start of comments
4 -- API name : Calculate_InventoryValue
5 -- Type : Public
6 -- Pre-reqs : None
7 -- Function : Populates temporary tables CST_INV_QTY_TEMP and
8 -- CST_INV_COST_TEMP with the relevant quantities and
9 -- costs based on the specifications
10 -- Parameters : p_api_version IN NUMBER Required
11 -- p_init_msg_list IN NUMBER
12 -- p_commit IN VARCHAR2
13 -- Default value is true because this procedure includes
14 -- an fnd call to gather statistics that does an implicit
15 -- commit. Since non-existence of this parameter implies
16 -- that the API does not commit, this is being added to
17 -- ensure that users of this API realize the implicit commit.
18 -- The API will return an error if it is called with this
19 -- value set to false.
20 -- p_organization_id IN NUMBER Required
21 -- p_onhand_value IN NUMBER
22 -- This parameter indicates whether onhand quantities
23 -- and costs needs to be calculated
24 -- p_intransit_value IN NUMBER
25 -- This parameter indicates whether intransit quantities
26 -- and costs needs to be calculated
27 -- p_receiving_value IN NUMBER
28 -- This parameter indicates whether receiving quantities
29 -- and costs needs to be calculated
30 -- p_valuation_date IN DATE
31 -- This paramater indicates the date at which the
32 -- quantities and costs need to be calculated. It is not
33 -- valid for receiving value calculations. If no date is
34 -- specified, the procedure will calculate the current
35 -- values.
36 --. p_cost_type_id IN NUMBER
37 -- This parameter indicates the cost type against which
38 -- the asset status of the item is verified.
39 -- p_item_from IN VARCHAR2
40 -- p_item_to IN VARCHAR2
41 -- p_category_set_id IN NUMBER Required
42 -- p_category_from IN VARCHAR2
43 -- p_category_to IN VARCHAR2
44 -- p_cost_group_from IN VARCHAR2
45 -- p_cost_group_to IN VARCHAR2
46 -- p_subinventory_from IN VARCHAR2
47 -- p_subinventory_to IN VARCHAR2
48 -- p_qty_by_revision IN NUMBER
49 -- This parameter indicates whether the item revision
50 -- information needs to be gathered.
51 -- p_zero_cost_only IN NUMBER
52 -- This parameter restricts the range of items to
53 -- those with zero item costs.
54 -- p_zero_qty IN NUMBER
55 -- This parameter is valid only for current valuation
56 -- (p_valuation_date is NULL) to include items with zero
57 -- onhand quantity.
58 -- p_expense_item IN NUMBER
59 -- This parameter indicates whether to include expense
60 -- items.
61 -- p_expense_sub IN NUMBER
62 -- This parameter indicates whether to include expense
63 -- subinventories for onhand quantity calculations.
64 -- p_unvalued_txns IN NUMBER
65 -- This parameter indicates whether to include uncosted
66 -- transactions in the calculation for onhand quantity.
67 -- p_receipt IN NUMBER
68 -- This paramter indicates whether to calculate the
69 -- intransit quantity that is coming to the current
70 -- organization
71 -- p_shipment IN NUMBER
72 -- This parameter indicates whether to calculate the
73 -- intransit quantity that is coming from the current
74 -- organization
75 -- p_detail IN NUMBER
76 -- This parameter indicates whether to calculate the
77 -- the intransit quantity in shipment line level
78 -- p_own IN NUMBER
79 -- This parameter indicates whether to calculate the
80 -- intransit quantity that belongs to other
81 -- organizations
82 -- p_cost_enabled_only IN NUMBER
83 -- If 1, this parameter indicates to calculate qty and value
84 -- for cost enabled items only.
85 -- p_one_time_item IN NUMBER
86 -- This parameter indicates whether to calculate the
87 -- receiving quantity for null items, as in the case
88 -- of one-time items. If 1, include null items.
89 -- p_include_period_end IN NUMBER
90 -- This parameter indicates whether to include receiving
91 -- quantity for period-end accrual PO shipments. If 1,
92 -- include period-end PO shipments; otherwise only include
93 -- online accrual PO shipments.
94 -- x_return_status OUT NOCOPY VARCHAR2 REQUIRED
95 -- x_msg_count OUT NOCOPY NUMBER REQUIRED
96 -- x_msg_data OUT NOCOPY VARCHAR2 REQUIRED
97 -- Version : Current version 1.0
98 -- Initial version 1.0
99 -- End of comments
100 PROCEDURE Calculate_InventoryValue (
101 p_api_version IN NUMBER,
102 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
103 p_commit IN VARCHAR2 := CST_Utility_PUB.get_true,
104 p_organization_id IN NUMBER,
105 p_onhand_value IN NUMBER := NULL,
106 p_intransit_value IN NUMBER := NULL,
107 p_receiving_value IN NUMBER := NULL,
108 p_valuation_date IN DATE := NULL,
109 p_cost_type_id IN NUMBER := NULL,
110 p_item_from IN VARCHAR2 := NULL,
111 p_item_to IN VARCHAR2 := NULL,
112 p_category_set_id IN NUMBER,
113 p_category_from IN VARCHAR2 := NULL,
114 p_category_to IN VARCHAR2 := NULL,
115 p_cost_group_from IN VARCHAR2 := NULL,
116 p_cost_group_to IN VARCHAR2 := NULL,
117 p_subinventory_from IN VARCHAR2 := NULL,
118 p_subinventory_to IN VARCHAR2 := NULL,
119 p_qty_by_revision IN NUMBER := NULL,
120 p_zero_cost_only IN NUMBER := NULL,
121 p_zero_qty IN NUMBER := NULL,
122 p_expense_item IN NUMBER := NULL,
123 p_expense_sub IN NUMBER := NULL,
124 p_unvalued_txns IN NUMBER := NULL,
125 p_receipt IN NUMBER := NULL,
126 p_shipment IN NUMBER := NULL,
127 p_detail IN NUMBER := NULL,
128 p_own IN NUMBER := 1,
129 p_cost_enabled_only IN NUMBER := 1,
130 p_one_time_item IN NUMBER := NULL,
131 p_include_period_end IN NUMBER := NULL,
132 x_return_status OUT NOCOPY VARCHAR2,
133 x_msg_count OUT NOCOPY NUMBER,
134 x_msg_data OUT NOCOPY VARCHAR2
135 );
136
137 END CST_Inventory_PUB;