The following lines contain the word 'select', 'insert', 'update' or 'delete':
IF l_mo_hdr_rec.operation = INV_GLOBALS.G_OPR_DELETE THEN
/* physically delete this row */
/* */
WSH_Util_Core.PrintLn('Calling Delete Row');
GMI_Move_Order_Header_Util.delete_Row( l_mo_hdr_rec.header_id);
WSH_Util_Core.PrintLn('Calling Insert / Update Row');
l_mo_hdr_rec.last_update_date := SYSDATE;
l_mo_hdr_rec.last_updated_by := FND_GLOBAL.USER_ID;
l_mo_hdr_rec.last_update_login := FND_GLOBAL.USER_ID;
IF l_mo_hdr_rec.operation = INV_GLOBALS.G_OPR_UPDATE THEN
WSH_Util_Core.PrintLn('Calling Update Row');
gmi_reservation_util.PrintLn('Calling Update Row in move_order hdr pvt');
GMI_Move_Order_Header_Util.update_Row( l_mo_hdr_rec);
select MTL_TXN_REQUEST_HEADERS_S.nextval
-- END Bug 2628244
INTO l_mo_hdr_rec.header_id
FROM DUAL;
WSH_Util_Core.PrintLn('Calling Insert Row');
gmi_reservation_util.println('Going to insert row in move_order_hdr_pvt');
GMI_Move_Order_Header_Util.Insert_Row( l_mo_hdr_rec);
ELSIF ( p_mo_hdr_rec.operation = INV_GLOBALS.G_OPR_UPDATE) THEN
IF p_mo_hdr_rec.header_id is NULL OR
p_mo_hdr_rec.REQUEST_NUMBER is NULL OR
p_mo_hdr_rec.organization_id is NULL THEN
RETURN TRUE;
/* This should Catch DELETE, LOCK_ROW and QUERY */
/* Which all need a HEADER ID. */
ELSE
IF p_mo_hdr_rec.header_id is NULL THEN
RETURN TRUE;