3288: -- will store the Correct qty (rounded up) to create replenishment MO for each Item
3289:
3290: l_src_sub := NULL;
3291:
3292: l_trohdr_rec.created_by := fnd_global.user_id;
3293: l_trohdr_rec.creation_date := sysdate;
3294: l_trohdr_rec.header_status := INV_Globals.g_to_status_preapproved;
3295: l_trohdr_rec.last_updated_by := fnd_global.user_id;
3296: l_trohdr_rec.last_update_date := sysdate;
3291:
3292: l_trohdr_rec.created_by := fnd_global.user_id;
3293: l_trohdr_rec.creation_date := sysdate;
3294: l_trohdr_rec.header_status := INV_Globals.g_to_status_preapproved;
3295: l_trohdr_rec.last_updated_by := fnd_global.user_id;
3296: l_trohdr_rec.last_update_date := sysdate;
3297: l_trohdr_rec.last_update_login := fnd_global.user_id;
3298: l_trohdr_rec.organization_id := NULL; -- assigned inside the loop
3299: l_trohdr_rec.status_date := sysdate;
3293: l_trohdr_rec.creation_date := sysdate;
3294: l_trohdr_rec.header_status := INV_Globals.g_to_status_preapproved;
3295: l_trohdr_rec.last_updated_by := fnd_global.user_id;
3296: l_trohdr_rec.last_update_date := sysdate;
3297: l_trohdr_rec.last_update_login := fnd_global.user_id;
3298: l_trohdr_rec.organization_id := NULL; -- assigned inside the loop
3299: l_trohdr_rec.status_date := sysdate;
3300: l_trohdr_rec.move_order_type := INV_GLOBALS.G_MOVE_ORDER_REPLENISHMENT;
3301: l_trohdr_rec.transaction_type_id := INV_GLOBALS.G_TYPE_TRANSFER_ORDER_SUBXFR;
3607: print_debug('CALLING INV_Move_Order_PUB.Create_Move_Order_Lines');
3608: END IF;
3609: l_line_num := l_line_num + 1;
3610: l_trolin_tbl(l_order_count).header_id := l_x_trohdr_rec.header_id;
3611: l_trolin_tbl(l_order_count).created_by := fnd_global.user_id;
3612: l_trolin_tbl(l_order_count).creation_date := sysdate;
3613: l_trolin_tbl(l_order_count).date_required := p_consol_item_repl_tbl(i).date_required;
3614: l_trolin_tbl(l_order_count).from_subinventory_code := l_src_sub;
3615: l_trolin_tbl(l_order_count).line_number := l_line_num;
3613: l_trolin_tbl(l_order_count).date_required := p_consol_item_repl_tbl(i).date_required;
3614: l_trolin_tbl(l_order_count).from_subinventory_code := l_src_sub;
3615: l_trolin_tbl(l_order_count).line_number := l_line_num;
3616: l_trolin_tbl(l_order_count).inventory_item_id := p_consol_item_repl_tbl(i).Item_id;
3617: l_trolin_tbl(l_order_count).last_updated_by := fnd_global.user_id;
3618: l_trolin_tbl(l_order_count).last_update_date := sysdate;
3619: l_trolin_tbl(l_order_count).last_update_login := fnd_global.user_id;
3620: l_trolin_tbl(l_order_count).line_status := INV_Globals.g_to_status_preapproved;
3621: l_trolin_tbl(l_order_count).organization_id := p_consol_item_repl_tbl(i).ORGANIZATION_ID;
3615: l_trolin_tbl(l_order_count).line_number := l_line_num;
3616: l_trolin_tbl(l_order_count).inventory_item_id := p_consol_item_repl_tbl(i).Item_id;
3617: l_trolin_tbl(l_order_count).last_updated_by := fnd_global.user_id;
3618: l_trolin_tbl(l_order_count).last_update_date := sysdate;
3619: l_trolin_tbl(l_order_count).last_update_login := fnd_global.user_id;
3620: l_trolin_tbl(l_order_count).line_status := INV_Globals.g_to_status_preapproved;
3621: l_trolin_tbl(l_order_count).organization_id := p_consol_item_repl_tbl(i).ORGANIZATION_ID;
3622: l_trolin_tbl(l_order_count).quantity := p_consol_item_repl_tbl(i).final_replenishment_qty;
3623: l_trolin_tbl(l_order_count).uom_code := p_consol_item_repl_tbl(i).Repl_UOM_Code;
3901: l_repl_level_tab(k),
3902: l_repl_type_tab(k),
3903: Sysdate,
3904: Sysdate,
3905: fnd_global.user_id,
3906: fnd_global.user_id,
3907: fnd_global.user_id);
3908:
3909: -- CLEAR all entries in the tables
3902: l_repl_type_tab(k),
3903: Sysdate,
3904: Sysdate,
3905: fnd_global.user_id,
3906: fnd_global.user_id,
3907: fnd_global.user_id);
3908:
3909: -- CLEAR all entries in the tables
3910: l_organization_id_tab.DELETE;
3903: Sysdate,
3904: Sysdate,
3905: fnd_global.user_id,
3906: fnd_global.user_id,
3907: fnd_global.user_id);
3908:
3909: -- CLEAR all entries in the tables
3910: l_organization_id_tab.DELETE;
3911: l_mo_header_id_tab.DELETE;
3989: repl_level,
3990: repl_type,
3991: Sysdate,
3992: Sysdate,
3993: fnd_global.user_id,
3994: fnd_global.user_id,
3995: fnd_global.user_id
3996: FROM WMS_REPL_DEMAND_GTMP
3997: WHERE ORGANIZATION_ID = p_consol_item_repl_tbl(i).ORGANIZATION_ID
3990: repl_type,
3991: Sysdate,
3992: Sysdate,
3993: fnd_global.user_id,
3994: fnd_global.user_id,
3995: fnd_global.user_id
3996: FROM WMS_REPL_DEMAND_GTMP
3997: WHERE ORGANIZATION_ID = p_consol_item_repl_tbl(i).ORGANIZATION_ID
3998: AND inventory_item_id = p_consol_item_repl_tbl(i).item_id
3991: Sysdate,
3992: Sysdate,
3993: fnd_global.user_id,
3994: fnd_global.user_id,
3995: fnd_global.user_id
3996: FROM WMS_REPL_DEMAND_GTMP
3997: WHERE ORGANIZATION_ID = p_consol_item_repl_tbl(i).ORGANIZATION_ID
3998: AND inventory_item_id = p_consol_item_repl_tbl(i).item_id
3999: AND REPL_TO_SUBINVENTORY_CODE = p_consol_item_repl_tbl(i).repl_to_subinventory_code;
4818: l_repl_level_tab(k),
4819: l_repl_type_tab(k),
4820: Sysdate,
4821: Sysdate,
4822: fnd_global.user_id,
4823: fnd_global.user_id,
4824: fnd_global.user_id
4825: );
4826:
4819: l_repl_type_tab(k),
4820: Sysdate,
4821: Sysdate,
4822: fnd_global.user_id,
4823: fnd_global.user_id,
4824: fnd_global.user_id
4825: );
4826:
4827: -- CLEAR all entries in the tables
4820: Sysdate,
4821: Sysdate,
4822: fnd_global.user_id,
4823: fnd_global.user_id,
4824: fnd_global.user_id
4825: );
4826:
4827: -- CLEAR all entries in the tables
4828: l_organization_id_tab.DELETE;
7567: L_repl_type,
7568: l_repl_level,
7569: Sysdate,
7570: Sysdate,
7571: fnd_global.user_id,
7572: fnd_global.user_id,
7573: fnd_global.user_id);
7574:
7575: END IF; -- FOR l_orig_pri_qty <> -9999
7568: l_repl_level,
7569: Sysdate,
7570: Sysdate,
7571: fnd_global.user_id,
7572: fnd_global.user_id,
7573: fnd_global.user_id);
7574:
7575: END IF; -- FOR l_orig_pri_qty <> -9999
7576:
7569: Sysdate,
7570: Sysdate,
7571: fnd_global.user_id,
7572: fnd_global.user_id,
7573: fnd_global.user_id);
7574:
7575: END IF; -- FOR l_orig_pri_qty <> -9999
7576:
7577: END IF; -- MEANS DELIVERY IS SPLIT