1 PACKAGE wms_rule_extn_pvt AUTHID CURRENT_USER AS
2 /* $Header: WMSVRXTS.pls 120.7 2011/05/04 07:45:20 abasheer ship $ */
3 --
4 -- File : WMSVRXTS.pls
5 -- Content : WMS_Rule_Extn_Pvt package
6 -- Description : Extended API's using wms rules engine private API's
7 -- : such as creating reservations based on rule suggestions
8 -- Notes :
9 -- Modified : 05/18/05 rambrose created orginal file
10 --
11 g_create_reservations NUMBER := 1;
12 g_create_suggestions NUMBER := 2;
13 g_allocate NUMBER := 3;
14
15 TYPE numtabtype IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
16 TYPE datetabtype IS TABLE OF DATE INDEX BY BINARY_INTEGER;
17 TYPE chartabtype30 IS TABLE OF VARCHAR2(30) INDEX BY BINARY_INTEGER;
18 TYPE chartabtype3 IS TABLE OF VARCHAR2(3) INDEX BY BINARY_INTEGER;
19 TYPE chartabtype10 IS TABLE OF VARCHAR2(10) INDEX BY BINARY_INTEGER;
20 TYPE chartabtype80 IS TABLE OF VARCHAR2(80) INDEX BY BINARY_INTEGER;
21 TYPE chartabtype150 IS TABLE OF VARCHAR2(150) INDEX BY BINARY_INTEGER;
22
23 TYPE g_suggestion_list_rec_type is RECORD (
24 from_organization_id NUMTABTYPE
25 , revision CHARTABTYPE3
26 , serial_number CHARTABTYPE30
27 , transaction_quantity NUMTABTYPE
28 , primary_quantity NUMTABTYPE
29 , secondary_quantity NUMTABTYPE
30 , lot_number CHARTABTYPE80
31 , lot_expiration_date DATETABTYPE
32 , from_subinventory_code CHARTABTYPE10
33 , from_locator_id NUMTABTYPE
34 , rule_id NUMTABTYPE
35 , reservation_id NUMTABTYPE
36 , to_subinventory_code CHARTABTYPE10
37 , to_locator_id NUMTABTYPE
38 , to_organization_id NUMTABTYPE
39 , from_cost_group_id NUMTABTYPE
40 , to_cost_group_id NUMTABTYPE
41 , lpn_id NUMTABTYPE
42 , grade_code CHARTABTYPE150
43 );
44
45 PROCEDURE suggest_reservations(
46 p_api_version IN NUMBER
47 , p_init_msg_list IN VARCHAR2
48 , p_commit IN VARCHAR2
49 , p_validation_level IN NUMBER
50 , x_return_status OUT NOCOPY VARCHAR2
51 , x_msg_count OUT NOCOPY NUMBER
52 , x_msg_data OUT NOCOPY VARCHAR2
53 , p_transaction_temp_id IN NUMBER
54 , p_allow_partial_pick IN VARCHAR2
55 , p_suggest_serial IN VARCHAR2
56 , p_mo_line_rec IN OUT NOCOPY inv_move_order_pub.trolin_rec_type --bug 12314831
57 , p_demand_source_type IN NUMBER
58 , p_demand_source_header_id IN NUMBER
59 , p_demand_source_line_id IN NUMBER
60 , p_demand_source_detail IN NUMBER DEFAULT NULL
61 , p_demand_source_name IN VARCHAR2 DEFAULT NULL
62 , p_requirement_date IN DATE DEFAULT NULL
63 , p_suggestions OUT NOCOPY g_suggestion_list_rec_type
64 );
65
66 -- API Name : InitQtyTree
67 -- Function : Initializes quantity tree for picking and returns tree id.
68 -- Pre-reqs : none
69 -- Parameters :
70 -- x_return_status out varchar2(1)
71 -- x_msg_count out number
72 -- x_msg_data out varchar2(2000)
73 -- p_organization_id in number required
74 -- p_inventory_item_id in number required
75 -- p_transaction_source_type_id in number required
76 -- p_transaction_source_id in number required
77 -- p_trx_source_line_id in number required
78 -- p_trx_source_delivery_id in number required
79 -- p_transaction_source_name in varchar2 required
80 -- p_tree_mode in number required
81 -- x_tree_id out number
82
83 procedure InitQtyTree (
84 x_return_status out nocopy varchar2
85 ,x_msg_count out nocopy number
86 ,x_msg_data out nocopy varchar2
87 ,p_organization_id in number
88 ,p_inventory_item_id in number
89 ,p_transaction_source_type_id in number
90 ,p_transaction_source_id in number
91 ,p_trx_source_line_id in number
92 ,p_trx_source_delivery_id in number
93 ,p_transaction_source_name in varchar2
94 ,p_tree_mode in number
95 ,x_tree_id out nocopy number
96 );
97
98 end wms_rule_extn_pvt;