[Home] [Help]
PACKAGE: APPS.GML_BATCH_OM_UTIL
Source
1 PACKAGE GML_BATCH_OM_UTIL AUTHID CURRENT_USER AS
2 /* $Header: GMLOUTLS.pls 120.0 2005/05/25 16:25:24 appldev noship $
3 +=========================================================================+
4 | Copyright (c) 2000 Oracle Corporation |
5 | TVP, Reading, England |
6 | All rights reserved |
7 +=========================================================================+
8 | FILENAME |
9 | GMIURSVS.pls |
10 | |
11 | DESCRIPTION |
12 | This package contains private utilities relating to OPM |
13 | reservation. |
14 | |
15 | |
16 | HISTORY |
17 | Aug-18-2003 Liping Gao Created |
18 +=========================================================================+
19 API Name : GML_BATCH_OM_UTIL
20 Type : Private
21 Function : This package contains Private Utilities procedures used to
22 OPM reservation for a batch.
23 Pre-reqs : N/A
24 Parameters: Per function
25
26 Current Vers : 1.0
27
28 */
29
30 G_DEFAULT_LOCT CONSTANT VARCHAR2(16):= FND_PROFILE.VALUE('IC$DEFAULT_LOCT');
31
32 TYPE Gme_om_reservation_rec IS RECORD
33 ( Batch_res_id Number
34 , Whse_code Varchar2(5)
35 , Item_id Number(15)
36 , So_line_id Number(15)
37 , Batch_line_id Number(15)
38 , Batch_id Number(15)
39 , order_id Number(15)
40 , delivery_detail_id Number(15)
41 , mo_line_id Number(15)
42 , rule_id Number(15)
43 , organization_id Number(15)
44 , Reserved_qty Number
45 , Reserved_qty2 Number
46 , Uom1 Varchar2(4)
47 , Uom2 Varchar2(4)
48 , Sched_ship_date date
49 , shipment_priority varchar2(32)
50 , batch_type number
51 , delete_mark number
52 );
53 TYPE Gme_om_config_assign IS RECORD
54 ( Rule_assign_id Number
55 , Whse_code Varchar2(5)
56 , Item_id Number(15)
57 , allocation_class Varchar2(30)
58 , Customer_id Number(15)
59 , Site_use_id Number(15)
60 );
61 TYPE Gme_om_rule_rec IS RECORD
62 ( Rule_id Number
63 , Rule_name Varchar2(30)
64 , DAYS_BEFORE_SHIP_DATE number
65 , DAYS_AFTER_SHIP_DATE number
66 , BATCH_STATUS varchar2(30)
67 , ALLOCATION_TOLERANCE number
68 , ALLOCATION_PRIORITY number
69 , AUTO_PICK_CONFIRM varchar2(1)
70 , BATCH_NOTIFICATION varchar2(1)
71 , ORDER_NOTIFICATION varchar2(1)
72 , Enable_FPO varchar2(1)
73 , RULE_TYPE number
74 , BATCH_TYPE_TO_CREATE number
75 , BATCH_CREATION_USER number
76 , CHECK_AVAILABILITY varchar2(1)
77 , AUTO_LOT_GENERATION varchar2(1)
78 , FIRMED_IND varchar2(1)
79 , RESERVE_MAX_TOLERANCE varchar2(1)
80 , COPY_ATTACHMENTS varchar2(1)
81 , SALES_ORDER_ATTACHMENT number
82 , BATCH_ATTACHMENT number
83 , BATCH_CREATION_NOTIFICATION varchar2(1)
84 );
85 TYPE So_line_rec IS RECORD
86 ( So_line_id Number
87 , Ship_from_org_id Number
88 , Customer_id Number
89 , Site_use_id Number
90 , Inventory_item_id Number
91 , Ordered_qty Number
92 , Ordered_qty2 Number
93 , Ordered_uom Varchar2(5)
94 , whse_code Varchar2(5)
95 );
96 TYPE Batch_line_rec is RECORD
97 ( Batch_line_id Number
98 , Batch_id Number
99 , Batch_type Number(5)
100 , Planned_qty Number
101 , Planned_uom Varchar2(5)
102 , Actual_qty Number
103 , Batch_status Number
104 , Trans_id Number -- for update, it is the from_trans_id
105 , Release_type Number
106 , Cmplt_date Date
107 );
108 TYPE Alloc_history_rec is RECORD
109 ( Alloc_rec_id Number
110 , Batch_line_id Number
111 , Batch_id Number
112 , So_line_id Number
113 , Batch_res_id Number
114 , Batch_trans_id Number
115 , trans_id Number
116 , rule_id Number
117 , lot_id Number
118 , location Varchar2(32)
119 , Whse_code Varchar2(5)
120 , Reserved_qty Number
121 , Reserved_qty2 Number
122 , Trans_um Varchar2(5)
123 , Trans_um2 Varchar2(5)
124 , failure_reason Varchar2(3000)
125 );
126
127 TYPE so_lineRecTyp IS RECORD (
128 customer_id NUMBER,
129 site_use_id NUMBER,
130 organization_id NUMBER);
131
132 TYPE so_lineTabTyp IS TABLE OF so_lineRecTyp INDEX BY BINARY_INTEGER;
133
134 PROCEDURE query_reservation
135 (
136 P_So_line_rec IN GML_BATCH_OM_UTIL.so_line_rec
137 , P_Batch_line_rec IN GML_BATCH_OM_UTIL.batch_line_rec
138 , P_Gme_om_reservation_rec IN OUT NOCOPY GML_BATCH_OM_UTIL.gme_om_reservation_rec
139 , X_return_status OUT NOCOPY VARCHAR2
140 , X_msg_cont OUT NOCOPY NUMBER
141 , X_msg_data OUT NOCOPY VARCHAR2
142 );
143 PROCEDURE insert_reservation
144 (
145 P_Gme_om_reservation_rec IN GML_BATCH_OM_UTIL.gme_om_reservation_rec
146 , X_return_status OUT NOCOPY VARCHAR2
147 , X_msg_cont OUT NOCOPY NUMBER
148 , X_msg_data OUT NOCOPY VARCHAR2
149 );
150 PROCEDURE update_reservation
151 (
152 P_Gme_om_reservation_rec IN GML_BATCH_OM_UTIL.gme_om_reservation_rec
153 , X_return_status OUT NOCOPY VARCHAR2
154 , X_msg_cont OUT NOCOPY NUMBER
155 , X_msg_data OUT NOCOPY VARCHAR2
156 );
157 PROCEDURE delete_reservation
158 (
159 P_Batch_res_id IN NUMBER default null
160 , P_Batch_line_id IN NUMBER default null
161 , P_Batch_id IN NUMBER default null
162 , X_return_status OUT NOCOPY VARCHAR2
163 , X_msg_cont OUT NOCOPY NUMBER
164 , X_msg_data OUT NOCOPY VARCHAR2
165 );
166 PROCEDURE query_alloc_history
167 (
168 P_alloc_history_rec IN OUT NOCOPY GML_BATCH_OM_UTIL.alloc_history_rec
169 , X_return_status OUT NOCOPY VARCHAR2
170 , X_msg_cont OUT NOCOPY NUMBER
171 , X_msg_data OUT NOCOPY VARCHAR2
172 ) ;
173 PROCEDURE insert_alloc_history
174 (
175 P_alloc_history_rec IN GML_BATCH_OM_UTIL.alloc_history_rec
176 , X_return_status OUT NOCOPY VARCHAR2
177 , X_msg_cont OUT NOCOPY NUMBER
178 , X_msg_data OUT NOCOPY VARCHAR2
179 );
180 FUNCTION check_reservation
181 (
182 P_Batch_res_id IN NUMBER default null
183 , P_Batch_line_id IN NUMBER default null
184 , P_Batch_id IN NUMBER default null
185 , P_so_line_id IN NUMBER default null
186 , P_delivery_detail_id IN NUMBER default null
187 , X_return_status OUT NOCOPY VARCHAR2
188 , X_msg_cont OUT NOCOPY NUMBER
189 , X_msg_data OUT NOCOPY VARCHAR2
190 ) Return boolean;
191 PROCEDURE get_rule
192 (
193 P_so_line_rec IN GML_BATCH_OM_UTIL.so_line_rec
194 , P_batch_line_rec IN GML_BATCH_OM_UTIL.batch_line_rec
195 , X_gme_om_rule_rec OUT NOCOPY GML_BATCH_OM_UTIL.gme_om_rule_rec
196 , X_return_status OUT NOCOPY VARCHAR2
197 , X_msg_cont OUT NOCOPY NUMBER
198 , X_msg_data OUT NOCOPY VARCHAR2
199 );
200 PROCEDURE check_rules
201 (
202 P_Gme_om_config_assign IN GML_BATCH_OM_UTIL.gme_om_config_assign
203 , X_count OUT NOCOPY NUMBER
204 , X_rule_id OUT NOCOPY NUMBER
205 , X_return_status OUT NOCOPY VARCHAR2
206 , X_msg_cont OUT NOCOPY NUMBER
207 , X_msg_data OUT NOCOPY VARCHAR2
208 );
209 END GML_BATCH_OM_UTIL;