APPS.ONT_HEADER_PAYMENT_DEF_HDLR SQL Statements

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

Line: 63

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

Line: 70

      OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

Line: 245

l_attr:= 'LAST_UPDATE_DATE';

Line: 247

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

l_attr:= 'LAST_UPDATE_LOGIN';

Line: 253

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

l_attr:= 'LAST_UPDATED_BY';

Line: 259

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

l_attr:= 'PROGRAM_UPDATE_DATE';

Line: 331

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

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

Line: 388

      OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'Y';

Line: 431

     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.LINE_ID = FND_API.G_MISS_NUM)  
     OR (g_record.OPERATION = FND_API.G_MISS_CHAR)  
     OR (g_record.PAYMENT_AMOUNT = FND_API.G_MISS_NUM)  
     OR (g_record.PAYMENT_COLLECTION_EVENT = FND_API.G_MISS_CHAR)  
     OR (g_record.PAYMENT_LEVEL_CODE = FND_API.G_MISS_CHAR)  
     OR (g_record.PAYMENT_NUMBER = FND_API.G_MISS_NUM)  
     OR (g_record.PAYMENT_SET_ID = FND_API.G_MISS_NUM)  
     OR (g_record.PAYMENT_TRX_ID = FND_API.G_MISS_NUM)  
     OR (g_record.PREPAID_AMOUNT = FND_API.G_MISS_NUM)  
     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.REQUEST_ID = FND_API.G_MISS_NUM)  
     OR (g_record.RETURN_STATUS = FND_API.G_MISS_CHAR)  
     OR (g_record.TANGIBLE_ID = FND_API.G_MISS_CHAR)  
     OR (g_record.CREDIT_CARD_EXPIRATION_DATE = FND_API.G_MISS_DATE)  
     OR (g_record.CREDIT_CARD_HOLDER_NAME = FND_API.G_MISS_CHAR)  
     OR (g_record.RECEIPT_METHOD_ID = FND_API.G_MISS_NUM)  
    ) THEN   
    ONT_HEADER_PAYMENT_Def_Hdlr.Default_Record(
     p_x_rec => g_record,
     p_in_old_rec => p_in_old_rec,
      p_iteration => p_iteration+1 );