DBA Data[Home] [Help]

APPS.INV_KANBAN_PVT dependencies on INV_GLOBALS

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

2211: l_trohdr_rec.creation_date := sysdate;
2212: l_trohdr_rec.date_required := p_need_by_date;
2213: l_trohdr_rec.from_subinventory_code := p_kanban_card_rec_tbl(1).source_subinventory;
2214: -- l_trohdr_rec.header_id := l_header_id;
2215: l_trohdr_rec.header_status := INV_Globals.G_TO_STATUS_PREAPPROVED;
2216: l_trohdr_rec.last_updated_by := FND_GLOBAL.USER_ID;
2217: l_trohdr_rec.last_update_date := sysdate;
2218: l_trohdr_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
2219: l_trohdr_rec.organization_id := p_kanban_card_rec_tbl(1).organization_id;

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

2219: l_trohdr_rec.organization_id := p_kanban_card_rec_tbl(1).organization_id;
2220: -- l_trohdr_rec.request_number := to_char(l_header_id);
2221: l_trohdr_rec.status_date := sysdate;
2222: l_trohdr_rec.to_subinventory_code := p_kanban_card_rec_tbl(1).subinventory_name;
2223: l_trohdr_rec.transaction_type_id := INV_GLOBALS.G_TYPE_TRANSFER_ORDER_SUBXFR;
2224: l_trohdr_rec.move_order_type := INV_GLOBALS.G_MOVE_ORDER_REPLENISHMENT;
2225: l_trohdr_rec.db_flag := FND_API.G_TRUE;
2226: l_trohdr_rec.operation := INV_GLOBALS.G_OPR_CREATE;
2227:

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

2220: -- l_trohdr_rec.request_number := to_char(l_header_id);
2221: l_trohdr_rec.status_date := sysdate;
2222: l_trohdr_rec.to_subinventory_code := p_kanban_card_rec_tbl(1).subinventory_name;
2223: l_trohdr_rec.transaction_type_id := INV_GLOBALS.G_TYPE_TRANSFER_ORDER_SUBXFR;
2224: l_trohdr_rec.move_order_type := INV_GLOBALS.G_MOVE_ORDER_REPLENISHMENT;
2225: l_trohdr_rec.db_flag := FND_API.G_TRUE;
2226: l_trohdr_rec.operation := INV_GLOBALS.G_OPR_CREATE;
2227:
2228: select location_control_code,secondary_uom_code

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

2222: l_trohdr_rec.to_subinventory_code := p_kanban_card_rec_tbl(1).subinventory_name;
2223: l_trohdr_rec.transaction_type_id := INV_GLOBALS.G_TYPE_TRANSFER_ORDER_SUBXFR;
2224: l_trohdr_rec.move_order_type := INV_GLOBALS.G_MOVE_ORDER_REPLENISHMENT;
2225: l_trohdr_rec.db_flag := FND_API.G_TRUE;
2226: l_trohdr_rec.operation := INV_GLOBALS.G_OPR_CREATE;
2227:
2228: select location_control_code,secondary_uom_code
2229: into l_item_locator_control_code,l_secondary_uom_code
2230: from mtl_system_items

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

2293: l_trolin_tbl(l_order_count).last_update_date := sysdate;
2294: l_trolin_tbl(l_order_count).last_update_login := FND_GLOBAL.LOGIN_ID;
2295: l_trolin_tbl(l_order_count).line_id := FND_API.G_MISS_NUM;
2296: l_trolin_tbl(l_order_count).line_number := l_line_num;
2297: l_trolin_tbl(l_order_count).line_status := INV_Globals.G_TO_STATUS_PREAPPROVED;
2298: l_trolin_tbl(l_order_count).organization_id := p_kanban_card_rec_tbl(1).organization_id;
2299: l_trolin_tbl(l_order_count).quantity := p_kanban_card_rec_tbl(l_order_count).kanban_size;
2300: l_trolin_tbl(l_order_count).reference_id := p_kanban_card_rec_tbl(l_order_count).kanban_card_id;
2301: l_trolin_tbl(l_order_count).reference_type_code := INV_Transfer_Order_PVT.G_Ref_Type_Kanban;

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

2339:
2340:
2341: l_trolin_tbl(l_order_count).to_subinventory_code:= p_kanban_card_rec_tbl(1).subinventory_name;
2342: l_trolin_tbl(l_order_count).uom_code := p_primary_uom_code;
2343: l_trolin_tbl(l_order_count).transaction_type_id := INV_GLOBALS.G_TYPE_TRANSFER_ORDER_SUBXFR;
2344: l_trolin_tbl(l_order_count).db_flag := FND_API.G_TRUE;
2345: l_trolin_tbl(l_order_count).operation := INV_GLOBALS.G_OPR_CREATE;
2346: l_trolin_tbl(l_order_count).secondary_quantity := l_secondary_qty;
2347: l_trolin_tbl(l_order_count).secondary_uom := l_secondary_uom_code;

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

2341: l_trolin_tbl(l_order_count).to_subinventory_code:= p_kanban_card_rec_tbl(1).subinventory_name;
2342: l_trolin_tbl(l_order_count).uom_code := p_primary_uom_code;
2343: l_trolin_tbl(l_order_count).transaction_type_id := INV_GLOBALS.G_TYPE_TRANSFER_ORDER_SUBXFR;
2344: l_trolin_tbl(l_order_count).db_flag := FND_API.G_TRUE;
2345: l_trolin_tbl(l_order_count).operation := INV_GLOBALS.G_OPR_CREATE;
2346: l_trolin_tbl(l_order_count).secondary_quantity := l_secondary_qty;
2347: l_trolin_tbl(l_order_count).secondary_uom := l_secondary_uom_code;
2348:
2349: END LOOP;

Line 4352: l_move_order_type NUMBER := INV_GLOBALS.G_MOVE_ORDER_REPLENISHMENT;

4348: -- Increased lot size to 80 Char - Mercy Thomas - B4625329
4349: l_lot_number VARCHAR2(80);
4350: l_expiration_date DATE;
4351: l_serial_control_code VARCHAR2(1) ;
4352: l_move_order_type NUMBER := INV_GLOBALS.G_MOVE_ORDER_REPLENISHMENT;
4353: l_failed_lines NUMBER := 0;
4354: l_return_status VARCHAR2(1);
4355: l_msg_count NUMBER ;
4356: l_msg_data VARCHAR2(2000);