1 PACKAGE WMS_OPP_CYC_COUNT AUTHID CURRENT_USER AS
2 /* $Header: WMSOPCCS.pls 120.1.12010000.3 2010/03/08 12:00:04 abasheer noship $ */
3
4 TYPE t_genref IS REF CURSOR;
5
6 FUNCTION is_cyc_count_enabled
7 ( p_organization_id IN NUMBER
8 , p_subinventory_code IN VARCHAR2
9 , p_loc_id IN NUMBER
10 , p_inventory_item_id IN NUMBER
11 )
12 RETURN NUMBER;
13
14 PROCEDURE process_entry
15 (p_cycle_count_header_id IN NUMBER ,
16 p_organization_id IN NUMBER ,
17 p_subinventory IN VARCHAR2 ,
18 p_locator_id IN NUMBER := NULL ,
19 p_parent_lpn_id IN NUMBER := NULL ,
20 p_inventory_item_id IN NUMBER ,
21 p_revision IN VARCHAR2 := NULL ,
22 p_lot_number IN VARCHAR2 := NULL ,
23 p_from_serial_number IN VARCHAR2 := NULL ,
24 p_to_serial_number IN VARCHAR2 := NULL ,
25 p_sys_quantity IN NUMBER ,
26 p_count_quantity IN NUMBER ,
27 p_count_uom IN VARCHAR2 ,
28 p_unscheduled_count_entry IN NUMBER ,
29 p_user_id IN NUMBER ,
30 p_cost_group_id IN NUMBER := NULL ,
31 p_secondary_uom IN VARCHAR2 := NULL ,
32 p_secondary_qty IN NUMBER := NULL
33 );
34
35 PROCEDURE process_summary
36 (p_cycle_count_header_id IN NUMBER ,
37 p_organization_id IN NUMBER ,
38 p_subinventory IN VARCHAR2 ,
39 p_locator_id IN NUMBER := NULL ,
40 p_parent_lpn_id IN NUMBER := NULL ,
41 p_inventory_item_id IN NUMBER ,
42 p_unscheduled_count_entry IN NUMBER ,
43 p_user_id IN NUMBER
44 );
45
46
47 END wms_opp_cyc_count;