1 PACKAGE WMS_REPLENISHMENT_PUB AS
2 /* $Header: WMSREPPS.pls 120.8 2008/04/01 01:44:45 satkumar noship $ */
3
4
5 PROCEDURE DYNAMIC_REPLENISHMENT_CP(
6 errbuf OUT NOCOPY VARCHAR2,
7 retcode OUT NOCOPY NUMBER,
8 P_Batch_id IN NUMBER,
9 p_organization_id IN NUMBER,
10 p_Plan_Tasks IN VARCHAR2,
11 p_Release_Sequence_Rule_Id IN NUMBER
12 );
13
14 PROCEDURE DYNAMIC_REPLENISHMENT(p_organization_id IN NUMBER,
15 P_Batch_id IN NUMBER,
16 p_Plan_Tasks IN VARCHAR2,
17 p_Release_Sequence_Rule_Id IN NUMBER,
18 P_repl_level IN NUMBER DEFAULT 1,
19 x_msg_count OUT NOCOPY NUMBER,
20 x_return_status OUT NOCOPY VARCHAR2,
21 x_msg_data OUT NOCOPY VARCHAR2);
22
23
24 PROCEDURE PUSH_REPLENISHMENT_CP(
25 errbuf OUT NOCOPY VARCHAR2,
26 retcode OUT NOCOPY NUMBER,
27 p_organization_id IN NUMBER,
28 p_Item_id IN NUMBER,
29 p_ABC_assignment_group_id IN NUMBER, -- For ABC Compile Group
30 p_abc_class_id IN NUMBER, -- For Item Classification
31 p_Order_Type_id IN NUMBER,
32 p_customer_class IN VARCHAR2,
33 p_customer_id IN NUMBER,
34 p_Carrier_id IN NUMBER,
35 p_Ship_Method_code IN VARCHAR2,
36 p_Scheduled_Ship_Date_To IN NUMBER,
37 p_Scheduled_Ship_Date_From IN NUMBER,
38 p_Forward_Pick_Sub IN VARCHAR2,
39 p_repl_UOM IN VARCHAR2,
40 p_Repl_Lot_Size IN NUMBER,
41 p_Min_Order_lines_threshold IN NUMBER,
42 p_Min_repl_qty_threshold IN NUMBER,
43 p_max_NUM_items_for_repl IN NUMBER,
44 p_Sort_Criteria IN NUMBER,
45 p_Release_Sequence_Rule_Id IN NUMBER,
46 p_Create_Reservation IN VARCHAR2,
47 p_Auto_Allocate IN VARCHAR2,
48 p_Plan_Tasks IN VARCHAR2);
49
50
51 PROCEDURE PUSH_REPLENISHMENT(P_repl_level IN NUMBER DEFAULT 1,
52 p_Item_id IN NUMBER,
53 p_organization_id IN NUMBER,
54 p_ABC_assignment_group_id IN NUMBER, -- For ABC Compile Group
55 p_abc_class_id IN NUMBER, -- For Item Classification
56 p_Order_Type_id IN NUMBER,
57 p_Carrier_id IN NUMBER,
58 p_customer_class IN VARCHAR2,
59 p_customer_id IN NUMBER,
60 p_Ship_Method_code IN VARCHAR2,
61 p_Scheduled_Ship_Date_To IN NUMBER,
62 p_Scheduled_Ship_Date_From IN NUMBER,
63 p_Forward_Pick_Sub IN VARCHAR2,
64 p_repl_UOM IN VARCHAR2,
65 p_Repl_Lot_Size IN NUMBER,
66 p_Min_Order_lines_threshold IN NUMBER,
67 p_Min_repl_qty_threshold IN NUMBER,
68 p_max_NUM_items_for_repl IN NUMBER,
69 p_Sort_Criteria IN NUMBER,
70 p_Auto_Allocate IN VARCHAR2,
71 p_Plan_Tasks IN VARCHAR2,
72 p_Release_Sequence_Rule_Id IN NUMBER,
73 p_Create_Reservation IN VARCHAR2,
74 x_return_status OUT NOCOPY VARCHAR2,
75 x_msg_count OUT NOCOPY NUMBER,
76 x_msg_data OUT NOCOPY VARCHAR2);
77
78
79 PROCEDURE UPDATE_DELIVERY_DETAIL (
80 p_delivery_detail_id IN NUMBER,
81 P_PRIMARY_QUANTITY IN NUMBER,
82 P_SPLIT_DELIVERY_DETAIL_ID IN NUMBER DEFAULT NULL,
83 p_split_source_line_id IN NUMBER DEFAULT NULL,
84 x_return_status OUT NOCOPY VARCHAR2
85 );
86
87 PROCEDURE allocate_repl_move_order_cp ( errbuf OUT NOCOPY VARCHAR2,
88 retcode OUT nocopy NUMBER,
89 p_Quantity_function_id IN VARCHAR2);
90
91
92
93 END wms_replenishment_pub;