[Home] [Help]
173: RETURN NULL;
174: END IF;
175: -- Default the locator only if there is locator control.
176: IF(g_DiscreteJob_rec.kanban_card_id IS NOT NULL) THEN
177: l_kanban_rec := INV_KanbanCard_PKG.Query_Row(p_kanban_card_id => g_DiscreteJob_rec.kanban_card_id);
178: RETURN(l_kanban_rec.locator_id);
179: END IF;
180: END IF;
181:
197: l_kanban_rec INV_Kanban_PVT.Kanban_Card_Rec_Type;
198: BEGIN
199: --bug14167405 Moving the order of defaulting logic for Kanban before Bom/Routing defaults, since this is Kanban flow
200: IF(g_DiscreteJob_rec.kanban_card_id IS NOT NULL) THEN
201: l_kanban_rec := INV_KanbanCard_PKG.Query_Row(p_kanban_card_id => g_DiscreteJob_rec.kanban_card_id);
202: RETURN(l_kanban_rec.subinventory_name);
203: END IF;
204:
205: IF(g_DiscreteJob_rec.completion_subinventory IS NOT NULL) THEN
331: RETURN g_DiscreteJob_rec.Line_id;
332: END IF;
333:
334: IF(g_DiscreteJob_rec.kanban_card_id IS NOT NULL) THEN
335: l_kanban_rec := INV_KanbanCard_PKG.Query_Row(p_kanban_card_id => g_DiscreteJob_rec.kanban_card_id);
336: RETURN(l_kanban_rec.wip_line_id);
337: END IF;
338:
339: EXCEPTION
534: RETURN g_DiscreteJob_rec.primary_item_id;
535: END IF;
536:
537: IF(g_DiscreteJob_rec.kanban_card_id IS NOT NULL) THEN
538: l_kanban_rec := INV_KanbanCard_PKG.Query_Row(p_kanban_card_id => g_DiscreteJob_rec.kanban_card_id);
539: RETURN(l_kanban_rec.inventory_item_id);
540: END IF;
541:
542: EXCEPTION
788: RETURN g_DiscreteJob_rec.start_quantity;
789: END IF;
790:
791: IF(g_DiscreteJob_rec.kanban_card_id IS NOT NULL) THEN
792: l_kanban_rec := INV_KanbanCard_PKG.Query_Row(p_kanban_card_id => g_DiscreteJob_rec.kanban_card_id);
793: RETURN(l_kanban_rec.kanban_size);
794: END IF;
795:
796: EXCEPTION