1 PACKAGE MTL_INV_UTIL_GRP AS
2 /* $Header: INVGIVUS.pls 120.1.12010000.1 2008/07/24 01:33:32 appldev ship $ */
3
4 -- Gets the item cost for a specific item.
5 PROCEDURE get_item_cost
6 ( p_api_version IN NUMBER ,
7 p_init_msg_list IN VARCHAR2 DEFAULT 'FND_API.G_FALSE' ,
8 p_commit IN VARCHAR2 DEFAULT 'FND_API.G_FALSE' ,
9 p_validation_level IN NUMBER DEFAULT FND_API.g_valid_level_full ,
10 x_return_status OUT NOCOPY VARCHAR2 ,
11 x_msg_count OUT NOCOPY NUMBER ,
12 x_msg_data OUT NOCOPY VARCHAR2 ,
13 p_organization_id IN NUMBER ,
14 p_inventory_item_id IN NUMBER ,
15 p_locator_id IN NUMBER DEFAULT NULL ,
16 x_item_cost OUT NOCOPY NUMBER);
17
18 -- calculate the system quantity of an given item
19 PROCEDURE calculate_systemquantity
20 ( p_api_version IN NUMBER ,
21 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false ,
22 p_commit IN VARCHAR2 DEFAULT FND_API.g_false ,
23 p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
24 x_return_status OUT NOCOPY VARCHAR2 ,
25 x_msg_count OUT NOCOPY NUMBER ,
26 x_msg_data OUT NOCOPY VARCHAR2 ,
27 p_organization_id IN NUMBER ,
28 p_inventory_item_id IN NUMBER ,
29 p_subinventory IN VARCHAR2 ,
30 p_lot_number IN VARCHAR2 ,
31 p_revision IN VARCHAR2 ,
32 p_locator_id IN NUMBER ,
33 p_cost_group_id IN NUMBER DEFAULT NULL ,
34 p_serial_number IN VARCHAR2 ,
35 p_serial_number_control IN NUMBER ,
36 p_serial_count_option IN NUMBER ,
37 x_system_quantity OUT NOCOPY NUMBER);
38
39 -- BEGIN INVCONV
40 -- Overloaded procedure to return secondary quantity
41 PROCEDURE calculate_systemquantity
42 ( p_api_version IN NUMBER ,
43 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false ,
44 p_commit IN VARCHAR2 DEFAULT FND_API.g_false ,
45 p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
46 x_return_status OUT NOCOPY VARCHAR2 ,
47 x_msg_count OUT NOCOPY NUMBER ,
48 x_msg_data OUT NOCOPY VARCHAR2 ,
49 p_organization_id IN NUMBER ,
50 p_inventory_item_id IN NUMBER ,
51 p_subinventory IN VARCHAR2 ,
52 p_lot_number IN VARCHAR2 ,
53 p_revision IN VARCHAR2 ,
54 p_locator_id IN NUMBER ,
55 p_cost_group_id IN NUMBER DEFAULT NULL ,
56 p_serial_number IN VARCHAR2 ,
57 p_serial_number_control IN NUMBER ,
58 p_serial_count_option IN NUMBER ,
59 x_system_quantity OUT NOCOPY NUMBER ,
60 x_sec_system_quantity OUT NOCOPY NUMBER);
61 -- END INVCONV
62
63 FUNCTION CHECK_SERIAL_NUMBER_LOCATION
64 ( p_serial_number IN VARCHAR2,
65 p_item_id IN NUMBER,
66 p_organization_id IN NUMBER,
67 p_serial_number_type IN NUMBER,
68 p_serial_control IN NUMBER,
69 p_revision IN VARCHAR2,
70 p_lot_number IN VARCHAR2,
71 p_subinventory IN VARCHAR2,
72 p_locator_id IN NUMBER,
73 p_issue_receipt IN VARCHAR2 -- R -receipt I - issue
74 ) RETURN BOOLEAN;
75
76 -- Calculate system quantity from a LPN
77 PROCEDURE Get_LPN_Item_SysQty
78 ( p_api_version IN NUMBER ,
79 p_init_msg_lst IN VARCHAR2 := fnd_api.g_false ,
80 p_commit IN VARCHAR2 := fnd_api.g_false ,
81 x_return_status OUT NOCOPY VARCHAR2 ,
82 x_msg_count OUT NOCOPY NUMBER ,
83 x_msg_data OUT NOCOPY VARCHAR2 ,
84 p_organization_id IN NUMBER ,
85 p_lpn_id IN NUMBER ,
86 p_inventory_item_id IN NUMBER ,
87 p_lot_number IN VARCHAR2 ,
88 p_revision IN VARCHAR2 ,
89 p_serial_number IN VARCHAR2 ,
90 p_cost_group_id IN NUMBER DEFAULT NULL ,
91 x_lpn_systemqty OUT NOCOPY NUMBER);
92
93 -- BEGIN INVCONV
94 -- Overloaded procedure to return secondary quantity
95 PROCEDURE Get_LPN_Item_SysQty
96 ( p_api_version IN NUMBER ,
97 p_init_msg_lst IN VARCHAR2 := fnd_api.g_false ,
98 p_commit IN VARCHAR2 := fnd_api.g_false ,
99 x_return_status OUT NOCOPY VARCHAR2 ,
100 x_msg_count OUT NOCOPY NUMBER ,
101 x_msg_data OUT NOCOPY VARCHAR2 ,
102 p_organization_id IN NUMBER ,
103 p_lpn_id IN NUMBER ,
104 p_inventory_item_id IN NUMBER ,
105 p_lot_number IN VARCHAR2 ,
106 p_revision IN VARCHAR2 ,
107 p_serial_number IN VARCHAR2 ,
108 p_cost_group_id IN NUMBER DEFAULT NULL ,
109 x_lpn_systemqty OUT NOCOPY NUMBER ,
110 x_lpn_sec_systemqty OUT NOCOPY NUMBER);
111 -- END INVCONV
112
113 FUNCTION Exists_CC_Entries
114 ( p_organization_id IN NUMBER ,
115 p_parent_lpn_id IN NUMBER ,
116 p_inventory_item_id IN NUMBER ,
117 p_cost_group_id IN NUMBER DEFAULT NULL ,
118 p_lot_number IN VARCHAR2 ,
119 p_revision IN VARCHAR2 ,
120 p_serial_number IN VARCHAR2
121 ) RETURN BOOLEAN;
122
123 FUNCTION Exists_CC_Items
124 ( p_cc_header_id IN VARCHAR2 ,
125 p_inventory_item_id IN NUMBER
126 ) RETURN BOOLEAN;
127
128 --R12 Procedure to purge the mtl_item_bulkload_recs table
129 PROCEDURE purge_bulkloadrecs_table
130 ( p_request_id NUMBER ,
131 p_commit BOOLEAN DEFAULT TRUE
132 );
133
134 END MTL_INV_UTIL_GRP;