[Home] [Help]
119: PROCEDURE get_consol_repl_demand_cust
120: (x_return_status OUT NOCOPY VARCHAR2,
121: x_msg_count OUT NOCOPY NUMBER,
122: x_msg_data OUT NOCOPY VARCHAR2,
123: x_consol_item_repl_tbl OUT NOCOPY WMS_REPLENISHMENT_PVT.consol_item_repl_tbl
124: ) IS
125: l_demand_line_detail_id NUMBER;
126: l_quantity NUMBER;
127: l_cnt NUMBER;
171:
172: -- STEP 3:
173:
174: --STEP 3.i)
175: l_cnt := wms_replenishment_pvt.g_backorder_deliv_tab.COUNT();
176:
177:
178: -- For each demand line that is removed from the table wms_repl_demand_gtmp, MUST do following:
179: -- *************************************************
186:
187: -- Add here to list of delivery_details to be backordered
188:
189: l_cnt := l_cnt+1; -- Do not reset the cnt counter value.
190: wms_replenishment_pvt.g_backorder_deliv_tab(l_cnt):= l_demand_line_detail_id;
191: wms_replenishment_pvt.g_backorder_qty_tab(l_cnt) := l_quantity;
192:
193: -- since we are backordering entire qty parameters
194: -- p_bo_qtys AND p_req_qtys will have same value
187: -- Add here to list of delivery_details to be backordered
188:
189: l_cnt := l_cnt+1; -- Do not reset the cnt counter value.
190: wms_replenishment_pvt.g_backorder_deliv_tab(l_cnt):= l_demand_line_detail_id;
191: wms_replenishment_pvt.g_backorder_qty_tab(l_cnt) := l_quantity;
192:
193: -- since we are backordering entire qty parameters
194: -- p_bo_qtys AND p_req_qtys will have same value
195:
192:
193: -- since we are backordering entire qty parameters
194: -- p_bo_qtys AND p_req_qtys will have same value
195:
196: wms_replenishment_pvt.g_dummy_table(l_cnt) := 0;
197: -- *************************************************
198:
199: --STEP 3.ii)
200: -- Decrement the quantity from x_consol_item_repl_tbl PL/SQL table based of inventory_item_id.