[Home] [Help]
PACKAGE: APPS.INV_RULE_GEN_PVT
Source
1 Package inv_rule_gen_pvt AUTHID CURRENT_USER AS
2 /* $Header: INVRLGNS.pls 120.0 2005/05/25 06:42:50 appldev noship $ */
3
4 --
5 -- File : INVRLGNB.pls
6 -- Content : INV_RULE_GEN_PVT
7 -- Description : wms rules engine private API's
8 -- Notes :
9 -- Modified : 08/30/04 ckuenzel created orginal file in inventory
10 --
11
12 Type picking_rule_rec is RECORD
13 (
14 INV_RULE_ID Number
15 , NAME Varchar2(80)
16 , description Varchar2(240)
17 , SHELF_DAYS number
18 , SINGLE_LOT VARchar2(1)
19 , PARTIAL_ALLOWED_FLAG varchar2(1)
20 , CUST_SPEC_MATCH_FLAG varchar2(1)
21 , LOT_SORT number
22 , LOT_SORT_RANK Number
23 , REVISION_SORT number
24 , REVISION_SORT_RANK Number
25 , SUBINVENTORY_SORT number
26 , SUBINVENTORY_SORT_RANK Number
27 , LOCATOR_SORT number
28 , LOCATOR_SORT_RANK Number
29 , WMS_RULE_ID Number
30 , WMS_STRATEGY_ID Number
31 , Apply_to_source Number -- 1,sales order, 2 GME, 3 WIP
32 , enabled_flag varchar2(1)
33 , CREATION_DATE date
34 , CREATED_BY number
35 , LAST_UPDATE_DATE date
36 , LAST_UPDATED_BY number
37 , LAST_UPDATE_LOGIN number
38 );
39
40 PROCEDURE Save
41 (p_mtl_picking_rule_rec IN OUT NOCOPY INV_RULE_GEN_PVT.picking_rule_rec
42 , x_return_status OUT NOCOPY VARCHAR2
43 , x_msg_data OUT NOCOPY VARCHAR2
44 , x_msg_count OUT NOCOPY NUMBER
45 );
46
47 PROCEDURE Save_to_mtl_picking_rules
48 (p_mtl_picking_rule_rec IN OUT NOCOPY INV_RULE_GEN_PVT.picking_rule_rec
49 , x_return_status OUT NOCOPY VARCHAR2
50 , x_msg_data OUT NOCOPY VARCHAR2
51 , x_msg_count OUT NOCOPY NUMBER
52 );
53
54 PROCEDURE Save_to_wms_rule
55 (p_mtl_picking_rule_rec IN OUT NOCOPY INV_RULE_GEN_PVT.picking_rule_rec
56 , x_return_status OUT NOCOPY VARCHAR2
57 , x_msg_data OUT NOCOPY VARCHAR2
58 , x_msg_count OUT NOCOPY NUMBER
59 );
60
61 PROCEDURE Restrictions_insert
62 (p_mtl_picking_rule_rec IN OUT NOCOPY INV_RULE_GEN_PVT.picking_rule_rec
63 , x_return_status OUT NOCOPY VARCHAR2
64 , x_msg_data OUT NOCOPY VARCHAR2
65 , x_msg_count OUT NOCOPY NUMBER
66 );
67
68 PROCEDURE Restrictions_update
69 (p_mtl_picking_rule_rec IN OUT NOCOPY INV_RULE_GEN_PVT.picking_rule_rec
70 , x_return_status OUT NOCOPY VARCHAR2
71 , x_msg_data OUT NOCOPY VARCHAR2
72 , x_msg_count OUT NOCOPY NUMBER
73 );
74
75 PROCEDURE Restrictions_delete
76 (p_mtl_picking_rule_rec IN OUT NOCOPY INV_RULE_GEN_PVT.picking_rule_rec
77 , x_return_status OUT NOCOPY VARCHAR2
78 , x_msg_data OUT NOCOPY VARCHAR2
79 , x_msg_count OUT NOCOPY NUMBER
80 );
81
82 PROCEDURE consistency_insert
83 (p_mtl_picking_rule_rec IN OUT NOCOPY INV_RULE_GEN_PVT.picking_rule_rec
84 , x_return_status OUT NOCOPY VARCHAR2
85 , x_msg_data OUT NOCOPY VARCHAR2
86 , x_msg_count OUT NOCOPY NUMBER
87 );
88
89 PROCEDURE consistency_update
90 (p_mtl_picking_rule_rec IN OUT NOCOPY INV_RULE_GEN_PVT.picking_rule_rec
91 , x_return_status OUT NOCOPY VARCHAR2
92 , x_msg_data OUT NOCOPY VARCHAR2
93 , x_msg_count OUT NOCOPY NUMBER
94 );
95
96 PROCEDURE consistency_delete
97 (p_mtl_picking_rule_rec IN OUT NOCOPY INV_RULE_GEN_PVT.picking_rule_rec
98 , x_return_status OUT NOCOPY VARCHAR2
99 , x_msg_data OUT NOCOPY VARCHAR2
100 , x_msg_count OUT NOCOPY NUMBER
101 );
102
103 PROCEDURE Sorting_criteria_insert
104 (p_mtl_picking_rule_rec IN OUT NOCOPY INV_RULE_GEN_PVT.picking_rule_rec
105 , x_return_status OUT NOCOPY VARCHAR2
106 , x_msg_data OUT NOCOPY VARCHAR2
107 , x_msg_count OUT NOCOPY NUMBER
108 );
109
110 PROCEDURE Sorting_criteria_update
111 (p_mtl_picking_rule_rec IN OUT NOCOPY INV_RULE_GEN_PVT.picking_rule_rec
112 , x_return_status OUT NOCOPY VARCHAR2
113 , x_msg_data OUT NOCOPY VARCHAR2
114 , x_msg_count OUT NOCOPY NUMBER
115 );
116
117 PROCEDURE Sorting_criteria_delete
118 (p_mtl_picking_rule_rec IN OUT NOCOPY INV_RULE_GEN_PVT.picking_rule_rec
119 , x_return_status OUT NOCOPY VARCHAR2
120 , x_msg_data OUT NOCOPY VARCHAR2
121 , x_msg_count OUT NOCOPY NUMBER
122 );
123
124 PROCEDURE Strategy_insert
125 (p_mtl_picking_rule_rec IN OUT NOCOPY INV_RULE_GEN_PVT.picking_rule_rec
126 , x_return_status OUT NOCOPY VARCHAR2
127 , x_msg_data OUT NOCOPY VARCHAR2
128 , x_msg_count OUT NOCOPY NUMBER
129 );
130
131 /* Only enabled flag can be updated. */
132 PROCEDURE Strategy_update
133 (p_mtl_picking_rule_rec IN OUT NOCOPY INV_RULE_GEN_PVT.picking_rule_rec
134 , x_return_status OUT NOCOPY VARCHAR2
135 , x_msg_data OUT NOCOPY VARCHAR2
136 , x_msg_count OUT NOCOPY NUMBER
137 );
138 PROCEDURE Rule_Enabled_Flag
139 (p_mtl_picking_rule_rec IN OUT NOCOPY INV_RULE_GEN_PVT.picking_rule_rec
140 , x_return_status OUT NOCOPY VARCHAR2
141 , x_msg_data OUT NOCOPY VARCHAR2
142 , x_msg_count OUT NOCOPY NUMBER
143 );
144 FUNCTION rule_assigned_to_strategy
145 (p_mtl_picking_rule_rec IN OUT NOCOPY INV_RULE_GEN_PVT.picking_rule_rec
146 , x_return_status OUT NOCOPY VARCHAR2
147 , x_msg_data OUT NOCOPY VARCHAR2
148 , x_msg_count OUT NOCOPY NUMBER)
149 RETURN BOOLEAN;
150
151 PROCEDURE GenerateRulePKG
152 (p_mtl_picking_rule_rec IN OUT NOCOPY INV_RULE_GEN_PVT.picking_rule_rec
153 , x_return_status OUT NOCOPY VARCHAR2
154 , x_msg_data OUT NOCOPY VARCHAR2
155 , x_msg_count OUT NOCOPY NUMBER
156 );
157
158 END; -- Package Specification inv_rule_gen_pvt