APPS.AML_INTERACTION_LEADS_PKG SQL Statements

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

Line: 9

PROCEDURE INSERT_ROW (
  px_INTERACTION_LEAD_ID    IN OUT NOCOPY NUMBER,
  p_INTERACTION_ID          IN NUMBER,
  p_IMPORT_INTERFACE_ID     IN NUMBER,
  p_SALES_LEAD_ID           IN NUMBER,
  p_CREATION_DATE           IN DATE,
  p_CREATED_BY              IN NUMBER,
  p_LAST_UPDATE_DATE        IN DATE,
  p_LAST_UPDATED_BY         IN NUMBER,
  p_LAST_UPDATE_LOGIN       IN NUMBER,
  p_REQUEST_ID              IN NUMBER,
  p_PROGRAM_APPLICATION_ID  IN NUMBER,
  p_PROGRAM_ID              IN NUMBER,
  p_PROGRAM_UPDATE_DATE     IN DATE,
  p_OBJECT_VERSION_NUMBER   IN NUMBER,
  p_SCORE                   IN NUMBER
) IS
   CURSOR C2 IS SELECT AML_INTERACTION_LEADS_S.nextval FROM sys.dual;

Line: 36

  INSERT INTO AML_INTERACTION_LEADS (
      INTERACTION_LEAD_ID,
      INTERACTION_ID,
      IMPORT_INTERFACE_ID,
      SALES_LEAD_ID,
      CREATION_DATE,
      CREATED_BY,
      LAST_UPDATE_DATE,
      LAST_UPDATED_BY,
      LAST_UPDATE_LOGIN,
      REQUEST_ID,
      PROGRAM_APPLICATION_ID,
      PROGRAM_ID,
      PROGRAM_UPDATE_DATE,
      OBJECT_VERSION_NUMBER,
      SCORE
  ) VALUES (
      px_INTERACTION_LEAD_ID
     ,decode( p_INTERACTION_ID, FND_API.G_MISS_NUM, NULL, p_INTERACTION_ID)
     ,decode( p_IMPORT_INTERFACE_ID, FND_API.G_MISS_NUM, NULL, p_IMPORT_INTERFACE_ID)
     ,decode( p_SALES_LEAD_ID, FND_API.G_MISS_NUM, NULL, p_SALES_LEAD_ID)
     ,decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE)
     ,decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY)
     ,decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE)
     ,decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY)
     ,decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN)
     ,decode( p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID)
     ,decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_APPLICATION_ID)
     ,decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_ID)
     ,decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_PROGRAM_UPDATE_DATE)
     ,1
     ,decode( p_SCORE, FND_API.G_MISS_NUM, NULL, p_SCORE)
  );

Line: 70

END INSERT_ROW;

Line: 72

PROCEDURE UPDATE_ROW (
  p_INTERACTION_LEAD_ID     IN NUMBER,
  p_INTERACTION_ID          IN NUMBER,
  p_IMPORT_INTERFACE_ID     IN NUMBER,
  p_SALES_LEAD_ID           IN NUMBER,
  p_CREATION_DATE           IN DATE,
  p_CREATED_BY              IN NUMBER,
  p_LAST_UPDATE_DATE        IN DATE,
  p_LAST_UPDATED_BY         IN NUMBER,
  p_LAST_UPDATE_LOGIN       IN NUMBER,
  p_REQUEST_ID              IN NUMBER,
  p_PROGRAM_APPLICATION_ID  IN NUMBER,
  p_PROGRAM_ID              IN NUMBER,
  p_PROGRAM_UPDATE_DATE     IN DATE,
  p_OBJECT_VERSION_NUMBER   IN NUMBER,
  p_SCORE                   IN NUMBER
) is
BEGIN
  update AML_INTERACTION_LEADS set
      INTERACTION_ID = decode( p_INTERACTION_ID, FND_API.G_MISS_NUM, INTERACTION_ID, p_INTERACTION_ID)
     ,IMPORT_INTERFACE_ID = decode( p_IMPORT_INTERFACE_ID, FND_API.G_MISS_NUM, IMPORT_INTERFACE_ID, p_IMPORT_INTERFACE_ID)
     ,SALES_LEAD_ID = decode( p_SALES_LEAD_ID, FND_API.G_MISS_NUM, SALES_LEAD_ID, p_SALES_LEAD_ID)
     ,LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE)
     ,LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY)
     ,LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN)
     ,REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID, p_REQUEST_ID)
     ,PROGRAM_APPLICATION_ID = decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, PROGRAM_APPLICATION_ID, p_PROGRAM_APPLICATION_ID)
     ,PROGRAM_ID = decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, PROGRAM_ID, p_PROGRAM_ID)
     ,PROGRAM_UPDATE_DATE = decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, PROGRAM_UPDATE_DATE, p_PROGRAM_UPDATE_DATE)
     ,OBJECT_VERSION_NUMBER = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER+1)
     ,SCORE = decode( p_SCORE, FND_API.G_MISS_NUM, SCORE, p_SCORE)
  where INTERACTION_LEAD_ID = p_INTERACTION_LEAD_ID;

Line: 109

END UPDATE_ROW;

Line: 111

PROCEDURE DELETE_ROW (
    p_INTERACTION_LEAD_ID IN NUMBER
) is
BEGIN
  delete from AML_INTERACTION_LEADS
  where INTERACTION_LEAD_ID = p_INTERACTION_LEAD_ID;

Line: 122

END DELETE_ROW;

Line: 132

    select INTERACTION_LEAD_ID, INTERACTION_ID, IMPORT_INTERFACE_ID,
           SALES_LEAD_ID, SCORE
    from AML_INTERACTION_LEADS
    where INTERACTION_LEAD_ID = p_INTERACTION_LEAD_ID
    for update of INTERACTION_LEAD_ID nowait;

Line: 144

    fnd_message.set_name('FND', 'FORM_RECORD_DELETED');