1 PACKAGE wms_rule_extn_pvt AS
2 /* $Header: WMSVRXTS.pls 120.4.12010000.1 2008/07/28 18:38:11 appldev 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 inv_move_order_pub.trolin_rec_type
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
67 end wms_rule_extn_pvt;