APPS.GMI_MOVE_ORDER_HEADER_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 97

  IF l_mo_hdr_rec.operation = INV_GLOBALS.G_OPR_DELETE THEN
	/*  physically delete this row */
	/*   */
  WSH_Util_Core.PrintLn('Calling Delete Row');

Line: 101

     GMI_Move_Order_Header_Util.delete_Row( l_mo_hdr_rec.header_id);

Line: 105

  WSH_Util_Core.PrintLn('Calling Insert / Update Row');

Line: 108

     l_mo_hdr_rec.last_update_date   := SYSDATE;

Line: 109

     l_mo_hdr_rec.last_updated_by    := FND_GLOBAL.USER_ID;

Line: 110

     l_mo_hdr_rec.last_update_login  := FND_GLOBAL.USER_ID;

Line: 112

     IF l_mo_hdr_rec.operation = INV_GLOBALS.G_OPR_UPDATE THEN
  WSH_Util_Core.PrintLn('Calling Update Row');

Line: 114

    gmi_reservation_util.PrintLn('Calling Update Row in move_order hdr pvt');

Line: 115

        GMI_Move_Order_Header_Util.update_Row( l_mo_hdr_rec);

Line: 128

           select MTL_TXN_REQUEST_HEADERS_S.nextval
           -- END Bug 2628244
	   INTO   l_mo_hdr_rec.header_id
	   FROM   DUAL;

Line: 135

  WSH_Util_Core.PrintLn('Calling Insert Row');

Line: 137

gmi_reservation_util.println('Going to insert row in move_order_hdr_pvt');

Line: 140

        GMI_Move_Order_Header_Util.Insert_Row( l_mo_hdr_rec);

Line: 204

 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;

Line: 217

  /*  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;