DBA Data[Home] [Help]

APPS.FLM_KANBAN_CONSOLIDATION dependencies on INV_GLOBALS

Line 231: l_trohdr_rec.header_status := INV_Globals.G_TO_STATUS_PREAPPROVED;

227: l_trohdr_rec.creation_date := sysdate;
228: l_trohdr_rec.date_required := p_need_by_date;
229: l_trohdr_rec.from_subinventory_code := l_Kanban_Card_Rec_Tbl(1).source_subinventory;
230: -- l_trohdr_rec.header_id := l_header_id;
231: l_trohdr_rec.header_status := INV_Globals.G_TO_STATUS_PREAPPROVED;
232: l_trohdr_rec.last_updated_by := FND_GLOBAL.USER_ID;
233: l_trohdr_rec.last_update_date := sysdate;
234: l_trohdr_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
235: l_trohdr_rec.organization_id := l_Kanban_Card_Rec_Tbl(1).organization_id;

Line 239: l_trohdr_rec.transaction_type_id := INV_GLOBALS.G_TYPE_TRANSFER_ORDER_SUBXFR;

235: l_trohdr_rec.organization_id := l_Kanban_Card_Rec_Tbl(1).organization_id;
236: -- l_trohdr_rec.request_number := to_char(l_header_id);
237: l_trohdr_rec.status_date := sysdate;
238: l_trohdr_rec.to_subinventory_code := l_Kanban_Card_Rec_Tbl(1).subinventory_name;
239: l_trohdr_rec.transaction_type_id := INV_GLOBALS.G_TYPE_TRANSFER_ORDER_SUBXFR;
240: l_trohdr_rec.move_order_type := INV_GLOBALS.G_MOVE_ORDER_REPLENISHMENT;
241: l_trohdr_rec.db_flag := FND_API.G_TRUE;
242: l_trohdr_rec.operation := INV_GLOBALS.G_OPR_CREATE;
243: fnd_file.put_line(fnd_file.log,'before loop');

Line 240: l_trohdr_rec.move_order_type := INV_GLOBALS.G_MOVE_ORDER_REPLENISHMENT;

236: -- l_trohdr_rec.request_number := to_char(l_header_id);
237: l_trohdr_rec.status_date := sysdate;
238: l_trohdr_rec.to_subinventory_code := l_Kanban_Card_Rec_Tbl(1).subinventory_name;
239: l_trohdr_rec.transaction_type_id := INV_GLOBALS.G_TYPE_TRANSFER_ORDER_SUBXFR;
240: l_trohdr_rec.move_order_type := INV_GLOBALS.G_MOVE_ORDER_REPLENISHMENT;
241: l_trohdr_rec.db_flag := FND_API.G_TRUE;
242: l_trohdr_rec.operation := INV_GLOBALS.G_OPR_CREATE;
243: fnd_file.put_line(fnd_file.log,'before loop');
244: For l_order_count in 1..l_Kanban_Card_Rec_Tbl.Count Loop

Line 242: l_trohdr_rec.operation := INV_GLOBALS.G_OPR_CREATE;

238: l_trohdr_rec.to_subinventory_code := l_Kanban_Card_Rec_Tbl(1).subinventory_name;
239: l_trohdr_rec.transaction_type_id := INV_GLOBALS.G_TYPE_TRANSFER_ORDER_SUBXFR;
240: l_trohdr_rec.move_order_type := INV_GLOBALS.G_MOVE_ORDER_REPLENISHMENT;
241: l_trohdr_rec.db_flag := FND_API.G_TRUE;
242: l_trohdr_rec.operation := INV_GLOBALS.G_OPR_CREATE;
243: fnd_file.put_line(fnd_file.log,'before loop');
244: For l_order_count in 1..l_Kanban_Card_Rec_Tbl.Count Loop
245: fnd_file.put_line(fnd_file.log,'inside loop');
246: select location_control_code,secondary_uom_code

Line 301: l_trolin_tbl(l_order_count).line_status := INV_Globals.G_TO_STATUS_PREAPPROVED;

297: l_trolin_tbl(l_order_count).last_update_date := sysdate;
298: l_trolin_tbl(l_order_count).last_update_login := FND_GLOBAL.LOGIN_ID;
299: l_trolin_tbl(l_order_count).line_id := FND_API.G_MISS_NUM;
300: l_trolin_tbl(l_order_count).line_number := l_line_num;
301: l_trolin_tbl(l_order_count).line_status := INV_Globals.G_TO_STATUS_PREAPPROVED;
302: l_trolin_tbl(l_order_count).organization_id := l_Kanban_Card_Rec_Tbl(l_order_count).organization_id;
303: l_trolin_tbl(l_order_count).quantity := l_Kanban_Card_Rec_Tbl(l_order_count).kanban_size;
304: l_trolin_tbl(l_order_count).reference_id := l_Kanban_Card_Rec_Tbl(l_order_count).kanban_card_id;
305: l_trolin_tbl(l_order_count).reference_type_code := INV_Transfer_Order_PVT.G_Ref_Type_Kanban;

Line 341: l_trolin_tbl(l_order_count).transaction_type_id := INV_GLOBALS.G_TYPE_TRANSFER_ORDER_SUBXFR;

337: END IF;
338:
339: l_trolin_tbl(l_order_count).to_subinventory_code:= l_Kanban_Card_Rec_Tbl(1).subinventory_name;
340: l_trolin_tbl(l_order_count).uom_code := p_primary_uom_code;
341: l_trolin_tbl(l_order_count).transaction_type_id := INV_GLOBALS.G_TYPE_TRANSFER_ORDER_SUBXFR;
342: l_trolin_tbl(l_order_count).db_flag := FND_API.G_TRUE;
343: l_trolin_tbl(l_order_count).operation := INV_GLOBALS.G_OPR_CREATE;
344: l_trolin_tbl(l_order_count).secondary_quantity := l_secondary_qty;
345: l_trolin_tbl(l_order_count).secondary_uom := l_secondary_uom_code;

Line 343: l_trolin_tbl(l_order_count).operation := INV_GLOBALS.G_OPR_CREATE;

339: l_trolin_tbl(l_order_count).to_subinventory_code:= l_Kanban_Card_Rec_Tbl(1).subinventory_name;
340: l_trolin_tbl(l_order_count).uom_code := p_primary_uom_code;
341: l_trolin_tbl(l_order_count).transaction_type_id := INV_GLOBALS.G_TYPE_TRANSFER_ORDER_SUBXFR;
342: l_trolin_tbl(l_order_count).db_flag := FND_API.G_TRUE;
343: l_trolin_tbl(l_order_count).operation := INV_GLOBALS.G_OPR_CREATE;
344: l_trolin_tbl(l_order_count).secondary_quantity := l_secondary_qty;
345: l_trolin_tbl(l_order_count).secondary_uom := l_secondary_uom_code;
346:
347: END LOOP;