eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ONT_LINE_DEF_HDLR SQL Statements

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

Line: 64


  IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
    l_attr:=l_attr||' 3';

Line: 71


      OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

Line: 94


  IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
    l_attr:=l_attr||' 3';

Line: 101


      OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

Line: 128


  IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
    l_attr:=l_attr||' 3';

Line: 135


      OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

Line: 158


  IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
    l_attr:=l_attr||' 3';

Line: 165


      OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

Line: 188


  IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
    l_attr:=l_attr||' 3';

Line: 195


      OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

Line: 218


  IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
    l_attr:=l_attr||' 3';

Line: 225


      OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

Line: 248


  IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
    l_attr:=l_attr||' 3';

Line: 255


      OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

Line: 299


  IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
    l_attr:=l_attr||' 3';

Line: 306


      OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

Line: 329


  IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
    l_attr:=l_attr||' 3';

Line: 336


      OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

Line: 359


  IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
    l_attr:=l_attr||' 3';

Line: 366


      OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

Line: 389


  IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
    l_attr:=l_attr||' 3';

Line: 396


      OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

Line: 419


  IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
    l_attr:=l_attr||' 3';

Line: 426


      OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

Line: 455


  IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
    l_attr:=l_attr||' 3';

Line: 462


      OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

Line: 486


  IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
    l_attr:=l_attr||' 3';

Line: 493


      OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

Line: 664


l_attr:= 'AUTO_SELECTED_QUANTITY';

Line: 666


IF g_record.AUTO_SELECTED_QUANTITY = FND_API.G_MISS_NUM THEN
  -- Attribute is NOT defaulting enabled, return NULL if MISSING
  g_record.AUTO_SELECTED_QUANTITY := NULL;

Line: 678


  IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
    l_attr:=l_attr||' 3';

Line: 685


      OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

Line: 840


  IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
    l_attr:=l_attr||' 3';

Line: 847


      OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

Line: 886


  IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
    l_attr:=l_attr||' 3';

Line: 893


      OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

Line: 917


  IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
    l_attr:=l_attr||' 3';

Line: 924


      OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

Line: 982


  IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
    l_attr:=l_attr||' 3';

Line: 989


      OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

Line: 1024


  IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
    l_attr:=l_attr||' 3';

Line: 1031


      OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

Line: 1055


  IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
    l_attr:=l_attr||' 3';

Line: 1062


      OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

Line: 1086


  IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
    l_attr:=l_attr||' 3';

Line: 1093


      OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

Line: 1117


  IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
    l_attr:=l_attr||' 3';

Line: 1124


      OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

Line: 1141


  IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
    l_attr:=l_attr||' 3';

Line: 1148


      OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

Line: 1165


  IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
    l_attr:=l_attr||' 3';

Line: 1172


      OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

Line: 1216


  IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
    l_attr:=l_attr||' 3';

Line: 1223


      OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

Line: 1265


  IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
    l_attr:=l_attr||' 3';

Line: 1272


      OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

Line: 1648


  IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
    l_attr:=l_attr||' 3';

Line: 1655


      OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

Line: 1716


  IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
    l_attr:=l_attr||' 3';

Line: 1723


      OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

Line: 1757


  IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
    l_attr:=l_attr||' 3';

Line: 1764


      OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

Line: 1798


l_attr:= 'LAST_UPDATE_DATE';

Line: 1800


IF g_record.LAST_UPDATE_DATE = FND_API.G_MISS_DATE THEN
  -- Attribute is NOT defaulting enabled, return NULL if MISSING
  g_record.LAST_UPDATE_DATE := NULL;

Line: 1804


l_attr:= 'LAST_UPDATE_LOGIN';

Line: 1806


IF g_record.LAST_UPDATE_LOGIN = FND_API.G_MISS_NUM THEN
  -- Attribute is NOT defaulting enabled, return NULL if MISSING
  g_record.LAST_UPDATE_LOGIN := NULL;

Line: 1810


l_attr:= 'LAST_UPDATED_BY';

Line: 1812


IF g_record.LAST_UPDATED_BY = FND_API.G_MISS_NUM THEN
  -- Attribute is NOT defaulting enabled, return NULL if MISSING
  g_record.LAST_UPDATED_BY := NULL;

Line: 1824


  IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
    l_attr:=l_attr||' 3';

Line: 1831


      OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

Line: 1931


  IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
    l_attr:=l_attr||' 3';

Line: 1938


      OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

Line: 1973


  IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
    l_attr:=l_attr||' 3';

Line: 1980


      OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

Line: 2033


  IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
    l_attr:=l_attr||' 3';

Line: 2040


      OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

Line: 2084


  IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
    l_attr:=l_attr||' 3';

Line: 2091


      OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

Line: 2125


  IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
    l_attr:=l_attr||' 3';

Line: 2132


      OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

Line: 2221


  IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
    l_attr:=l_attr||' 3';

Line: 2228


      OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

Line: 2268


l_attr:= 'PROGRAM_UPDATE_DATE';

Line: 2270


IF g_record.PROGRAM_UPDATE_DATE = FND_API.G_MISS_DATE THEN
  -- Attribute is NOT defaulting enabled, return NULL if MISSING
  g_record.PROGRAM_UPDATE_DATE := NULL;

Line: 2426


  IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
    l_attr:=l_attr||' 3';

Line: 2433


      OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

Line: 2487


  IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
    l_attr:=l_attr||' 3';

Line: 2494


      OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

Line: 2527


  IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
    l_attr:=l_attr||' 3';

Line: 2534


      OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

Line: 2564


  IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
    l_attr:=l_attr||' 3';

Line: 2571


      OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

Line: 2613


  IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
    l_attr:=l_attr||' 3';

Line: 2620


      OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

Line: 2730


  IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
    l_attr:=l_attr||' 3';

Line: 2737


      OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

Line: 2773


  IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
    l_attr:=l_attr||' 3';

Line: 2780


      OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

Line: 2816


  IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
    l_attr:=l_attr||' 3';

Line: 2823


      OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

Line: 2847


  IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
    l_attr:=l_attr||' 3';

Line: 2854


      OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

Line: 2929


  IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
    l_attr:=l_attr||' 3';

Line: 2936


      OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

Line: 2959


  IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
    l_attr:=l_attr||' 3';

Line: 2966


      OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

Line: 2990


  IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
    l_attr:=l_attr||' 3';

Line: 2997


      OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

Line: 3027


  IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
    l_attr:=l_attr||' 3';

Line: 3034


      OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

Line: 3154


  IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
    l_attr:=l_attr||' 3';

Line: 3161


      OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

Line: 3230


  IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
    l_attr:=l_attr||' 3';

Line: 3237


      OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

Line: 3261


  IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN
    l_attr:=l_attr||' 3';

Line: 3268


      OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

Line: 3416


     OR (g_record.AUTO_SELECTED_QUANTITY = FND_API.G_MISS_NUM)  
     OR (g_record.INVOICE_TO_CONTACT_ID = FND_API.G_MISS_NUM)  
     OR (g_record.BOOKED_FLAG = FND_API.G_MISS_CHAR)  
     OR (g_record.CALCULATE_PRICE_FLAG = FND_API.G_MISS_CHAR)  
     OR (g_record.CANCELLED_FLAG = FND_API.G_MISS_CHAR)  
     OR (g_record.CANCELLED_QUANTITY = FND_API.G_MISS_NUM)  
     OR (g_record.CHANGE_COMMENTS = FND_API.G_MISS_CHAR)  
     OR (g_record.CHANGE_REASON = FND_API.G_MISS_CHAR)  
     OR (g_record.CHARGE_PERIODICITY_CODE = FND_API.G_MISS_CHAR)  
     OR (g_record.COMMITMENT_ID = FND_API.G_MISS_NUM)  
     OR (g_record.COMPONENT_CODE = FND_API.G_MISS_CHAR)  
     OR (g_record.COMPONENT_NUMBER = FND_API.G_MISS_NUM)  
     OR (g_record.COMPONENT_SEQUENCE_ID = FND_API.G_MISS_NUM)  
     OR (g_record.CONFIG_DISPLAY_SEQUENCE = FND_API.G_MISS_NUM)  
     OR (g_record.CONFIG_HEADER_ID = FND_API.G_MISS_NUM)  
     OR (g_record.CONFIG_REV_NBR = FND_API.G_MISS_NUM)  
     OR (g_record.CONFIGURATION_ID = FND_API.G_MISS_NUM)  
     OR (g_record.CONTEXT = FND_API.G_MISS_CHAR)  
     OR (g_record.CONTINGENCY_ID = FND_API.G_MISS_NUM)  
     OR (g_record.CREATED_BY = FND_API.G_MISS_NUM)  
     OR (g_record.CREATION_DATE = FND_API.G_MISS_DATE)  
     OR (g_record.CREDIT_INVOICE_LINE_ID = FND_API.G_MISS_NUM)  
     OR (g_record.IB_CURRENT_LOCATION = FND_API.G_MISS_CHAR)  
     OR (g_record.CUST_MODEL_SERIAL_NUMBER = FND_API.G_MISS_CHAR)  
     OR (g_record.CUSTOMER_DOCK_CODE = FND_API.G_MISS_CHAR)  
     OR (g_record.CUSTOMER_JOB = FND_API.G_MISS_CHAR)  
     OR (g_record.CUST_PO_NUMBER = FND_API.G_MISS_CHAR)  
     OR (g_record.CUSTOMER_LINE_NUMBER = FND_API.G_MISS_CHAR)  
     OR (g_record.CUSTOMER_PRODUCTION_LINE = FND_API.G_MISS_CHAR)  
     OR (g_record.CUST_PRODUCTION_SEQ_NUM = FND_API.G_MISS_CHAR)  
     OR (g_record.CUSTOMER_SHIPMENT_NUMBER = FND_API.G_MISS_CHAR)  
     OR (g_record.CUSTOMER_TRX_LINE_ID = FND_API.G_MISS_NUM)  
     OR (g_record.DB_FLAG = FND_API.G_MISS_CHAR)  
     OR (g_record.DELIVER_TO_CONTACT_ID = FND_API.G_MISS_NUM)  
     OR (g_record.DELIVERY_LEAD_TIME = FND_API.G_MISS_NUM)  
     OR (g_record.DEMAND_BUCKET_TYPE_CODE = FND_API.G_MISS_CHAR)  
     OR (g_record.DEMAND_CLASS_CODE = FND_API.G_MISS_CHAR)  
     OR (g_record.DEP_PLAN_REQUIRED_FLAG = FND_API.G_MISS_CHAR)  
     OR (g_record.EARLIEST_ACCEPTABLE_DATE = FND_API.G_MISS_DATE)  
     OR (g_record.END_CUSTOMER_ID = FND_API.G_MISS_NUM)  
     OR (g_record.END_CUSTOMER_CONTACT_ID = FND_API.G_MISS_NUM)  
     OR (g_record.END_CUSTOMER_SITE_USE_ID = FND_API.G_MISS_NUM)  
     OR (g_record.END_ITEM_UNIT_NUMBER = FND_API.G_MISS_CHAR)  
     OR (g_record.EXPLOSION_DATE = FND_API.G_MISS_DATE)  
     OR (g_record.FOB_POINT_CODE = FND_API.G_MISS_CHAR)  
     OR (g_record.FIRST_ACK_CODE = FND_API.G_MISS_CHAR)  
     OR (g_record.FIRST_ACK_DATE = FND_API.G_MISS_DATE)  
     OR (g_record.FREIGHT_CARRIER_CODE = FND_API.G_MISS_CHAR)  
     OR (g_record.FREIGHT_TERMS_CODE = FND_API.G_MISS_CHAR)  
     OR (g_record.FULFILLED_FLAG = FND_API.G_MISS_CHAR)  
     OR (g_record.FULFILLED_QUANTITY = FND_API.G_MISS_NUM)  
     OR (g_record.FULFILLMENT_DATE = FND_API.G_MISS_DATE)  
     OR (g_record.FULFILLMENT_METHOD_CODE = FND_API.G_MISS_CHAR)  
     OR (g_record.GLOBAL_ATTRIBUTE_CATEGORY = FND_API.G_MISS_CHAR)  
     OR (g_record.GLOBAL_ATTRIBUTE1 = FND_API.G_MISS_CHAR)  
     OR (g_record.GLOBAL_ATTRIBUTE10 = FND_API.G_MISS_CHAR)  
     OR (g_record.GLOBAL_ATTRIBUTE11 = FND_API.G_MISS_CHAR)  
     OR (g_record.GLOBAL_ATTRIBUTE12 = FND_API.G_MISS_CHAR)  
     OR (g_record.GLOBAL_ATTRIBUTE13 = FND_API.G_MISS_CHAR)  
     OR (g_record.GLOBAL_ATTRIBUTE14 = FND_API.G_MISS_CHAR)  
     OR (g_record.GLOBAL_ATTRIBUTE15 = FND_API.G_MISS_CHAR)  
     OR (g_record.GLOBAL_ATTRIBUTE16 = FND_API.G_MISS_CHAR)  
     OR (g_record.GLOBAL_ATTRIBUTE17 = FND_API.G_MISS_CHAR)  
     OR (g_record.GLOBAL_ATTRIBUTE18 = FND_API.G_MISS_CHAR)  
     OR (g_record.GLOBAL_ATTRIBUTE19 = FND_API.G_MISS_CHAR)  
     OR (g_record.GLOBAL_ATTRIBUTE2 = FND_API.G_MISS_CHAR)  
     OR (g_record.GLOBAL_ATTRIBUTE20 = FND_API.G_MISS_CHAR)  
     OR (g_record.GLOBAL_ATTRIBUTE3 = FND_API.G_MISS_CHAR)  
     OR (g_record.GLOBAL_ATTRIBUTE4 = FND_API.G_MISS_CHAR)  
     OR (g_record.GLOBAL_ATTRIBUTE5 = FND_API.G_MISS_CHAR)  
     OR (g_record.GLOBAL_ATTRIBUTE6 = FND_API.G_MISS_CHAR)  
     OR (g_record.GLOBAL_ATTRIBUTE7 = FND_API.G_MISS_CHAR)  
     OR (g_record.GLOBAL_ATTRIBUTE8 = FND_API.G_MISS_CHAR)  
     OR (g_record.GLOBAL_ATTRIBUTE9 = FND_API.G_MISS_CHAR)  
     OR (g_record.PREFERRED_GRADE = FND_API.G_MISS_CHAR)  
     OR (g_record.HEADER_ID = FND_API.G_MISS_NUM)  
     OR (g_record.INDUSTRY_ATTRIBUTE16 = FND_API.G_MISS_CHAR)  
     OR (g_record.INDUSTRY_ATTRIBUTE17 = FND_API.G_MISS_CHAR)  
     OR (g_record.INDUSTRY_ATTRIBUTE18 = FND_API.G_MISS_CHAR)  
     OR (g_record.INDUSTRY_ATTRIBUTE19 = FND_API.G_MISS_CHAR)  
     OR (g_record.INDUSTRY_ATTRIBUTE20 = FND_API.G_MISS_CHAR)  
     OR (g_record.INDUSTRY_ATTRIBUTE21 = FND_API.G_MISS_CHAR)  
     OR (g_record.INDUSTRY_ATTRIBUTE22 = FND_API.G_MISS_CHAR)  
     OR (g_record.INDUSTRY_ATTRIBUTE23 = FND_API.G_MISS_CHAR)  
     OR (g_record.INDUSTRY_ATTRIBUTE24 = FND_API.G_MISS_CHAR)  
     OR (g_record.INDUSTRY_ATTRIBUTE25 = FND_API.G_MISS_CHAR)  
     OR (g_record.INDUSTRY_ATTRIBUTE26 = FND_API.G_MISS_CHAR)  
     OR (g_record.INDUSTRY_ATTRIBUTE27 = FND_API.G_MISS_CHAR)  
     OR (g_record.INDUSTRY_ATTRIBUTE28 = FND_API.G_MISS_CHAR)  
     OR (g_record.INDUSTRY_ATTRIBUTE29 = FND_API.G_MISS_CHAR)  
     OR (g_record.INDUSTRY_ATTRIBUTE30 = FND_API.G_MISS_CHAR)  
     OR (g_record.INDUSTRY_ATTRIBUTE1 = FND_API.G_MISS_CHAR)  
     OR (g_record.INDUSTRY_ATTRIBUTE10 = FND_API.G_MISS_CHAR)  
     OR (g_record.INDUSTRY_ATTRIBUTE11 = FND_API.G_MISS_CHAR)  
     OR (g_record.INDUSTRY_ATTRIBUTE12 = FND_API.G_MISS_CHAR)  
     OR (g_record.INDUSTRY_ATTRIBUTE13 = FND_API.G_MISS_CHAR)  
     OR (g_record.INDUSTRY_ATTRIBUTE14 = FND_API.G_MISS_CHAR)  
     OR (g_record.INDUSTRY_ATTRIBUTE15 = FND_API.G_MISS_CHAR)  
     OR (g_record.INDUSTRY_ATTRIBUTE2 = FND_API.G_MISS_CHAR)  
     OR (g_record.INDUSTRY_ATTRIBUTE3 = FND_API.G_MISS_CHAR)  
     OR (g_record.INDUSTRY_ATTRIBUTE4 = FND_API.G_MISS_CHAR)  
     OR (g_record.INDUSTRY_ATTRIBUTE5 = FND_API.G_MISS_CHAR)  
     OR (g_record.INDUSTRY_ATTRIBUTE6 = FND_API.G_MISS_CHAR)  
     OR (g_record.INDUSTRY_ATTRIBUTE7 = FND_API.G_MISS_CHAR)  
     OR (g_record.INDUSTRY_ATTRIBUTE8 = FND_API.G_MISS_CHAR)  
     OR (g_record.INDUSTRY_ATTRIBUTE9 = FND_API.G_MISS_CHAR)  
     OR (g_record.INDUSTRY_CONTEXT = FND_API.G_MISS_CHAR)  
     OR (g_record.IB_INSTALLED_AT_LOCATION = FND_API.G_MISS_CHAR)  
     OR (g_record.INTERMED_SHIP_TO_CONTACT_ID = FND_API.G_MISS_NUM)  
     OR (g_record.INTERMED_SHIP_TO_ORG_ID = FND_API.G_MISS_NUM)  
     OR (g_record.INVENTORY_ITEM_ID = FND_API.G_MISS_NUM)  
     OR (g_record.INVOICE_INTERFACE_STATUS_CODE = FND_API.G_MISS_CHAR)  
     OR (g_record.INVOICED_QUANTITY = FND_API.G_MISS_NUM)  
     OR (g_record.INVOICING_RULE_ID = FND_API.G_MISS_NUM)  
     OR (g_record.ITEM_IDENTIFIER_TYPE = FND_API.G_MISS_CHAR)  
     OR (g_record.ITEM_REVISION = FND_API.G_MISS_CHAR)  
     OR (g_record.ITEM_TYPE_CODE = FND_API.G_MISS_CHAR)  
     OR (g_record.LAST_ACK_CODE = FND_API.G_MISS_CHAR)  
     OR (g_record.LAST_ACK_DATE = FND_API.G_MISS_DATE)  
     OR (g_record.LAST_UPDATE_DATE = FND_API.G_MISS_DATE)  
     OR (g_record.LAST_UPDATE_LOGIN = FND_API.G_MISS_NUM)  
     OR (g_record.LAST_UPDATED_BY = FND_API.G_MISS_NUM)  
     OR (g_record.LATEST_ACCEPTABLE_DATE = FND_API.G_MISS_DATE)  
     OR (g_record.LINE_ID = FND_API.G_MISS_NUM)  
     OR (g_record.LINE_CATEGORY_CODE = FND_API.G_MISS_CHAR)  
     OR (g_record.LINE_NUMBER = FND_API.G_MISS_NUM)  
     OR (g_record.LINE_SET_ID = FND_API.G_MISS_NUM)  
     OR (g_record.LINK_TO_LINE_ID = FND_API.G_MISS_NUM)  
     OR (g_record.MFG_COMPONENT_SEQUENCE_ID = FND_API.G_MISS_NUM)  
     OR (g_record.MODEL_GROUP_NUMBER = FND_API.G_MISS_NUM)  
     OR (g_record.OPEN_FLAG = FND_API.G_MISS_CHAR)  
     OR (g_record.OPERATION = FND_API.G_MISS_CHAR)  
     OR (g_record.OPTION_FLAG = FND_API.G_MISS_CHAR)  
     OR (g_record.OPTION_NUMBER = FND_API.G_MISS_NUM)  
     OR (g_record.ORDER_FIRMED_DATE = FND_API.G_MISS_DATE)  
     OR (g_record.ORDER_QUANTITY_UOM = FND_API.G_MISS_CHAR)  
     OR (g_record.ORDERED_ITEM = FND_API.G_MISS_CHAR)  
     OR (g_record.ORDERED_ITEM_ID = FND_API.G_MISS_NUM)  
     OR (g_record.ORDERED_QUANTITY = FND_API.G_MISS_NUM)  
     OR (g_record.ORG_ID = FND_API.G_MISS_NUM)  
     OR (g_record.ORIG_SYS_DOCUMENT_REF = FND_API.G_MISS_CHAR)  
     OR (g_record.ORIG_SYS_LINE_REF = FND_API.G_MISS_CHAR)  
     OR (g_record.OVER_SHIP_REASON_CODE = FND_API.G_MISS_CHAR)  
     OR (g_record.OVER_SHIP_RESOLVED_FLAG = FND_API.G_MISS_CHAR)  
     OR (g_record.IB_OWNER = FND_API.G_MISS_CHAR)  
     OR (g_record.PACKING_INSTRUCTIONS = FND_API.G_MISS_CHAR)  
     OR (g_record.PARTY_TYPE = FND_API.G_MISS_CHAR)  
     OR (g_record.PAYMENT_TERM_ID = FND_API.G_MISS_NUM)  
     OR (g_record.PLANNING_PRIORITY = FND_API.G_MISS_NUM)  
     OR (g_record.PRICE_LIST_ID = FND_API.G_MISS_NUM)  
     OR (g_record.PRICING_ATTRIBUTE1 = FND_API.G_MISS_CHAR)  
     OR (g_record.PRICING_ATTRIBUTE10 = FND_API.G_MISS_CHAR)  
     OR (g_record.PRICING_ATTRIBUTE2 = FND_API.G_MISS_CHAR)  
     OR (g_record.PRICING_ATTRIBUTE3 = FND_API.G_MISS_CHAR)  
     OR (g_record.PRICING_ATTRIBUTE4 = FND_API.G_MISS_CHAR)  
     OR (g_record.PRICING_ATTRIBUTE5 = FND_API.G_MISS_CHAR)  
     OR (g_record.PRICING_ATTRIBUTE6 = FND_API.G_MISS_CHAR)  
     OR (g_record.PRICING_ATTRIBUTE7 = FND_API.G_MISS_CHAR)  
     OR (g_record.PRICING_ATTRIBUTE8 = FND_API.G_MISS_CHAR)  
     OR (g_record.PRICING_ATTRIBUTE9 = FND_API.G_MISS_CHAR)  
     OR (g_record.PRICING_CONTEXT = FND_API.G_MISS_CHAR)  
     OR (g_record.PRICING_DATE = FND_API.G_MISS_DATE)  
     OR (g_record.PRICING_QUANTITY = FND_API.G_MISS_NUM)  
     OR (g_record.PRICING_QUANTITY_UOM = FND_API.G_MISS_CHAR)  
     OR (g_record.PROGRAM_ID = FND_API.G_MISS_NUM)  
     OR (g_record.PROGRAM_APPLICATION_ID = FND_API.G_MISS_NUM)  
     OR (g_record.PROGRAM_UPDATE_DATE = FND_API.G_MISS_DATE)  
     OR (g_record.PROJECT_ID = FND_API.G_MISS_NUM)  
     OR (g_record.REFERENCE_CUSTOMER_TRX_LINE_ID = FND_API.G_MISS_NUM)  
     OR (g_record.REFERENCE_HEADER_ID = FND_API.G_MISS_NUM)  
     OR (g_record.REFERENCE_LINE_ID = FND_API.G_MISS_NUM)  
     OR (g_record.REFERENCE_TYPE = FND_API.G_MISS_CHAR)  
     OR (g_record.REQUEST_ID = FND_API.G_MISS_NUM)  
     OR (g_record.RESERVED_QUANTITY = FND_API.G_MISS_NUM)  
     OR (g_record.RETROBILL_REQUEST_ID = FND_API.G_MISS_NUM)  
     OR (g_record.RETURN_ATTRIBUTE1 = FND_API.G_MISS_CHAR)  
     OR (g_record.RETURN_ATTRIBUTE10 = FND_API.G_MISS_CHAR)  
     OR (g_record.RETURN_ATTRIBUTE11 = FND_API.G_MISS_CHAR)  
     OR (g_record.RETURN_ATTRIBUTE12 = FND_API.G_MISS_CHAR)  
     OR (g_record.RETURN_ATTRIBUTE13 = FND_API.G_MISS_CHAR)  
     OR (g_record.RETURN_ATTRIBUTE14 = FND_API.G_MISS_CHAR)  
     OR (g_record.RETURN_ATTRIBUTE15 = FND_API.G_MISS_CHAR)  
     OR (g_record.RETURN_ATTRIBUTE2 = FND_API.G_MISS_CHAR)  
     OR (g_record.RETURN_ATTRIBUTE3 = FND_API.G_MISS_CHAR)  
     OR (g_record.RETURN_ATTRIBUTE4 = FND_API.G_MISS_CHAR)  
     OR (g_record.RETURN_ATTRIBUTE5 = FND_API.G_MISS_CHAR)  
     OR (g_record.RETURN_ATTRIBUTE6 = FND_API.G_MISS_CHAR)  
     OR (g_record.RETURN_ATTRIBUTE7 = FND_API.G_MISS_CHAR)  
     OR (g_record.RETURN_ATTRIBUTE8 = FND_API.G_MISS_CHAR)  
     OR (g_record.RETURN_ATTRIBUTE9 = FND_API.G_MISS_CHAR)  
     OR (g_record.RETURN_CONTEXT = FND_API.G_MISS_CHAR)  
     OR (g_record.RETURN_REASON_CODE = FND_API.G_MISS_CHAR)  
     OR (g_record.RETURN_STATUS = FND_API.G_MISS_CHAR)  
     OR (g_record.REVENUE_AMOUNT = FND_API.G_MISS_NUM)  
     OR (g_record.REVREC_EXPIRATION_DAYS = FND_API.G_MISS_NUM)  
     OR (g_record.RLA_SCHEDULE_TYPE_CODE = FND_API.G_MISS_CHAR)  
     OR (g_record.BLANKET_LINE_NUMBER = FND_API.G_MISS_NUM)  
     OR (g_record.BLANKET_NUMBER = FND_API.G_MISS_NUM)  
     OR (g_record.BLANKET_VERSION_NUMBER = FND_API.G_MISS_NUM)  
     OR (g_record.SALESREP_ID = FND_API.G_MISS_NUM)  
     OR (g_record.SCHEDULE_ACTION_CODE = FND_API.G_MISS_CHAR)  
     OR (g_record.SCHEDULE_ARRIVAL_DATE = FND_API.G_MISS_DATE)  
     OR (g_record.SCHEDULE_STATUS_CODE = FND_API.G_MISS_CHAR)  
     OR (g_record.CANCELLED_QUANTITY2 = FND_API.G_MISS_NUM)  
     OR (g_record.FULFILLED_QUANTITY2 = FND_API.G_MISS_NUM)  
     OR (g_record.ORDERED_QUANTITY2 = FND_API.G_MISS_NUM)  
     OR (g_record.SHIPPED_QUANTITY2 = FND_API.G_MISS_NUM)  
     OR (g_record.SHIPPING_QUANTITY2 = FND_API.G_MISS_NUM)  
     OR (g_record.SHIPPING_QUANTITY_UOM2 = FND_API.G_MISS_CHAR)  
     OR (g_record.ORDERED_QUANTITY_UOM2 = FND_API.G_MISS_CHAR)  
     OR (g_record.SERVICE_BILL_OPTION_CODE = FND_API.G_MISS_CHAR)  
     OR (g_record.SERVICE_BILL_PROFILE_ID = FND_API.G_MISS_NUM)  
     OR (g_record.SERVICE_COTERMINATE_FLAG = FND_API.G_MISS_CHAR)  
     OR (g_record.SERVICE_COV_TEMPLATE_ID = FND_API.G_MISS_NUM)  
     OR (g_record.SERVICE_DURATION = FND_API.G_MISS_NUM)  
     OR (g_record.SERVICE_END_DATE = FND_API.G_MISS_DATE)  
     OR (g_record.SERVICE_NUMBER = FND_API.G_MISS_NUM)  
     OR (g_record.SERVICE_PERIOD = FND_API.G_MISS_CHAR)  
     OR (g_record.SERVICE_REFERENCE_LINE_ID = FND_API.G_MISS_NUM)  
     OR (g_record.SERVICE_REFERENCE_SYSTEM_ID = FND_API.G_MISS_NUM)  
     OR (g_record.SERVICE_REFERENCE_TYPE_CODE = FND_API.G_MISS_CHAR)  
     OR (g_record.SERVICE_START_DATE = FND_API.G_MISS_DATE)  
     OR (g_record.SERVICE_SUBS_TEMPLATE_ID = FND_API.G_MISS_NUM)  
     OR (g_record.SERVICE_TXN_COMMENTS = FND_API.G_MISS_CHAR)  
     OR (g_record.SERVICE_TXN_REASON_CODE = FND_API.G_MISS_CHAR)  
     OR (g_record.SHIP_MODEL_COMPLETE_FLAG = FND_API.G_MISS_CHAR)  
     OR (g_record.SHIP_SET_ID = FND_API.G_MISS_NUM)  
     OR (g_record.SHIP_SET = FND_API.G_MISS_CHAR)  
     OR (g_record.SHIP_TO_CONTACT_ID = FND_API.G_MISS_NUM)  
     OR (g_record.SHIP_TOLERANCE_ABOVE = FND_API.G_MISS_NUM)  
     OR (g_record.SHIP_TOLERANCE_BELOW = FND_API.G_MISS_NUM)  
     OR (g_record.SHIPMENT_NUMBER = FND_API.G_MISS_NUM)  
     OR (g_record.SHIPMENT_PRIORITY_CODE = FND_API.G_MISS_CHAR)  
     OR (g_record.SHIPPED_QUANTITY = FND_API.G_MISS_NUM)  
     OR (g_record.SHIPPING_INSTRUCTIONS = FND_API.G_MISS_CHAR)  
     OR (g_record.SHIPPING_INTERFACED_FLAG = FND_API.G_MISS_CHAR)  
     OR (g_record.SHIPPING_METHOD_CODE = FND_API.G_MISS_CHAR)  
     OR (g_record.SHIPPING_QUANTITY = FND_API.G_MISS_NUM)  
     OR (g_record.SHIPPING_QUANTITY_UOM = FND_API.G_MISS_CHAR)  
     OR (g_record.SORT_ORDER = FND_API.G_MISS_CHAR)  
     OR (g_record.SOURCE_DOCUMENT_ID = FND_API.G_MISS_NUM)  
     OR (g_record.SOURCE_DOCUMENT_LINE_ID = FND_API.G_MISS_NUM)  
     OR (g_record.SOURCE_DOCUMENT_TYPE_ID = FND_API.G_MISS_NUM)  
     OR (g_record.SOURCE_DOCUMENT_VERSION_NUMBER = FND_API.G_MISS_NUM)  
     OR (g_record.SOURCE_TYPE_CODE = FND_API.G_MISS_CHAR)  
     OR (g_record.SPLIT_BY = FND_API.G_MISS_CHAR)  
     OR (g_record.SPLIT_FROM_LINE_ID = FND_API.G_MISS_NUM)  
     OR (g_record.SUBINVENTORY = FND_API.G_MISS_CHAR)  
     OR (g_record.SUBSCRIPTION_ENABLE_FLAG = FND_API.G_MISS_CHAR)  
     OR (g_record.TASK_ID = FND_API.G_MISS_NUM)  
     OR (g_record.TAX_EXEMPT_NUMBER = FND_API.G_MISS_CHAR)  
     OR (g_record.TAX_EXEMPT_REASON_CODE = FND_API.G_MISS_CHAR)  
     OR (g_record.TAX_POINT_CODE = FND_API.G_MISS_CHAR)  
     OR (g_record.TAX_RATE = FND_API.G_MISS_NUM)  
     OR (g_record.TAX_VALUE = FND_API.G_MISS_NUM)  
     OR (g_record.TOP_MODEL_LINE_ID = FND_API.G_MISS_NUM)  
     OR (g_record.TRANSACTION_PHASE_CODE = FND_API.G_MISS_CHAR)  
     OR (g_record.UNIT_LIST_PERCENT = FND_API.G_MISS_NUM)  
     OR (g_record.UNIT_LIST_PRICE = FND_API.G_MISS_NUM)  
     OR (g_record.UNIT_PERCENT_BASE_PRICE = FND_API.G_MISS_NUM)  
     OR (g_record.UNIT_SELLING_PERCENT = FND_API.G_MISS_NUM)  
     OR (g_record.UNIT_SELLING_PRICE = FND_API.G_MISS_NUM)  
     OR (g_record.UPGRADED_FLAG = FND_API.G_MISS_CHAR)  
     OR (g_record.USER_ITEM_DESCRIPTION = FND_API.G_MISS_CHAR)  
     OR (g_record.VEH_CUS_ITEM_CUM_KEY_ID = FND_API.G_MISS_NUM)  
     OR (g_record.VISIBLE_DEMAND_FLAG = FND_API.G_MISS_CHAR)  
    ) THEN   
    ONT_LINE_Def_Hdlr.Default_Record(
     p_x_rec => g_record,
     p_initial_rec => p_initial_rec,
     p_in_old_rec => p_in_old_rec,
      p_iteration => p_iteration+1 );