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_HEADER_DEF_HDLR SQL Statements

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

Line: 68


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

Line: 75


      OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

Line: 98


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

Line: 105


      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: 222


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

Line: 229


      OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

Line: 258


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

Line: 265


      OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

Line: 298


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

Line: 305


      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: 479


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

Line: 486


      OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

Line: 545


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

Line: 552


      OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

Line: 593


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

Line: 600


      OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

Line: 624


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

Line: 631


      OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

Line: 699


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

Line: 706


      OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

Line: 730


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

Line: 737


      OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

Line: 754


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

Line: 761


      OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

Line: 778


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

Line: 785


      OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

Line: 839


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

Line: 846


      OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

Line: 869


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

Line: 876


      OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

Line: 927


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

Line: 934


      OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

Line: 951


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

Line: 958


      OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

Line: 975


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

Line: 982


      OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

Line: 999


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

Line: 1006


      OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

Line: 1029


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

Line: 1036


      OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

Line: 1078


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

Line: 1085


      OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

Line: 1261


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

Line: 1268


      OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

Line: 1285


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

Line: 1292


      OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

Line: 1320


l_attr:= 'LAST_UPDATE_DATE';

Line: 1322


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: 1326


l_attr:= 'LAST_UPDATE_LOGIN';

Line: 1328


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: 1332


l_attr:= 'LAST_UPDATED_BY';

Line: 1334


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: 1458


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

Line: 1465


      OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

Line: 1488


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

Line: 1495


      OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

Line: 1531


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

Line: 1538


      OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

Line: 1594


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

Line: 1601


      OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

Line: 1625


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

Line: 1632


      OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

Line: 1660


l_attr:= 'PROGRAM_UPDATE_DATE';

Line: 1662


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: 1674


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

Line: 1681


      OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

Line: 1718


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

Line: 1725


      OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

Line: 1748


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

Line: 1755


      OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

Line: 1783


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

Line: 1790


      OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

Line: 1820


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

Line: 1827


      OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

Line: 1850


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

Line: 1857


      OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

Line: 1881


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

Line: 1888


      OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

Line: 1912


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

Line: 1919


      OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

Line: 2021


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

Line: 2028


      OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

Line: 2051


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

Line: 2058


      OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

Line: 2082


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

Line: 2089


      OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

Line: 2123


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

Line: 2130


      OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

Line: 2171


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

Line: 2178


      OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

Line: 2298


     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_SCHEDULE_LIMIT = FND_API.G_MISS_NUM)  
     OR (g_record.CUSTOMER_PREFERENCE_SET_CODE = FND_API.G_MISS_CHAR)  
     OR (g_record.SALES_DOCUMENT_NAME = FND_API.G_MISS_CHAR)  
     OR (g_record.OPEN_FLAG = FND_API.G_MISS_CHAR)  
     OR (g_record.OPERATION = FND_API.G_MISS_CHAR)  
     OR (g_record.ORDER_CATEGORY_CODE = FND_API.G_MISS_CHAR)  
     OR (g_record.ORDER_DATE_TYPE_CODE = FND_API.G_MISS_CHAR)  
     OR (g_record.ORDER_FIRMED_DATE = FND_API.G_MISS_DATE)  
     OR (g_record.ORDER_NUMBER = FND_API.G_MISS_NUM)  
     OR (g_record.ORDER_SOURCE_ID = FND_API.G_MISS_NUM)  
     OR (g_record.ORDER_TYPE_ID = FND_API.G_MISS_NUM)  
     OR (g_record.ORDERED_DATE = FND_API.G_MISS_DATE)  
     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.IB_OWNER = FND_API.G_MISS_CHAR)  
     OR (g_record.PACKING_INSTRUCTIONS = FND_API.G_MISS_CHAR)  
     OR (g_record.PARTIAL_SHIPMENTS_ALLOWED = FND_API.G_MISS_CHAR)  
     OR (g_record.PARTY_TYPE = FND_API.G_MISS_CHAR)  
     OR (g_record.PAYMENT_AMOUNT = FND_API.G_MISS_NUM)  
     OR (g_record.PAYMENT_TERM_ID = FND_API.G_MISS_NUM)  
     OR (g_record.PRICING_DATE = FND_API.G_MISS_DATE)  
     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.QUOTE_DATE = FND_API.G_MISS_DATE)  
     OR (g_record.QUOTE_NUMBER = FND_API.G_MISS_NUM)  
     OR (g_record.REQUEST_ID = FND_API.G_MISS_NUM)  
     OR (g_record.RETURN_REASON_CODE = FND_API.G_MISS_CHAR)  
     OR (g_record.RETURN_STATUS = FND_API.G_MISS_CHAR)  
     OR (g_record.BLANKET_NUMBER = FND_API.G_MISS_NUM)  
     OR (g_record.SALES_CHANNEL_CODE = FND_API.G_MISS_CHAR)  
     OR (g_record.SALESREP_ID = FND_API.G_MISS_NUM)  
     OR (g_record.SOLD_FROM_ORG_ID = FND_API.G_MISS_NUM)  
     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_PRIORITY_CODE = FND_API.G_MISS_CHAR)  
     OR (g_record.SHIPPING_INSTRUCTIONS = FND_API.G_MISS_CHAR)  
     OR (g_record.SHIPPING_METHOD_CODE = FND_API.G_MISS_CHAR)  
     OR (g_record.SOURCE_DOCUMENT_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.FLOW_STATUS_CODE = FND_API.G_MISS_CHAR)  
     OR (g_record.SUPPLIER_SIGNATURE = FND_API.G_MISS_CHAR)  
     OR (g_record.SUPPLIER_SIGNATURE_DATE = FND_API.G_MISS_DATE)  
     OR (g_record.TAX_EXEMPT_FLAG = FND_API.G_MISS_CHAR)  
     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.TRANSACTION_PHASE_CODE = FND_API.G_MISS_CHAR)  
     OR (g_record.UPGRADED_FLAG = FND_API.G_MISS_CHAR)  
     OR (g_record.USER_STATUS_CODE = FND_API.G_MISS_CHAR)  
     OR (g_record.VERSION_NUMBER = FND_API.G_MISS_NUM)  
     OR (g_record.SHIP_FROM_ORG_ID = FND_API.G_MISS_NUM)  
    ) THEN   
    ONT_HEADER_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 );