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.AML_MONITOR_CONDITIONS_PVT SQL Statements

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

Line: 112


      AML_MONITOR_CONDITIONS_PKG.Insert_Row(
          px_MONITOR_CONDITION_ID  => x_MONITOR_CONDITION_ID
         ,p_LAST_UPDATE_DATE  => SYSDATE
         ,p_LAST_UPDATED_BY  => FND_GLOBAL.USER_ID
         ,p_CREATION_DATE  => SYSDATE
         ,p_CREATED_BY  => FND_GLOBAL.USER_ID
         ,p_LAST_UPDATE_LOGIN  => FND_GLOBAL.CONC_LOGIN_ID
         ,p_OBJECT_VERSION_NUMBER  => p_CONDITION_rec.OBJECT_VERSION_NUMBER
         ,p_REQUEST_ID  => p_CONDITION_rec.REQUEST_ID
         ,p_PROGRAM_APPLICATION_ID  => p_CONDITION_rec.PROGRAM_APPLICATION_ID
         ,p_PROGRAM_ID  => p_CONDITION_rec.PROGRAM_ID
         ,p_PROGRAM_UPDATE_DATE  => p_CONDITION_rec.PROGRAM_UPDATE_DATE
         ,p_PROCESS_RULE_ID  => p_CONDITION_rec.PROCESS_RULE_ID
         ,p_MONITOR_TYPE_CODE  => p_CONDITION_rec.MONITOR_TYPE_CODE
         ,p_TIME_LAG_NUM  => p_CONDITION_rec.TIME_LAG_NUM
         ,p_TIME_LAG_UOM_CODE  => p_CONDITION_rec.TIME_LAG_UOM_CODE
         ,p_TIME_LAG_FROM_STAGE  => p_CONDITION_rec.TIME_LAG_FROM_STAGE
         ,p_TIME_LAG_TO_STAGE  => p_CONDITION_rec.TIME_LAG_TO_STAGE
         ,p_Expiration_Relative     => p_CONDITION_rec.Expiration_Relative
         ,p_Reminder_Defined        => p_CONDITION_rec.Reminder_Defined
         ,p_Total_Reminders         => p_CONDITION_rec.Total_Reminders
         ,p_Reminder_Frequency      => p_CONDITION_rec.Reminder_Frequency
         ,p_Reminder_Freq_uom_code  => p_CONDITION_rec.Reminder_Freq_uom_code
         ,p_Timeout_Defined         => p_CONDITION_rec.Timeout_Defined
         ,p_Timeout_Duration        => p_CONDITION_rec.Timeout_Duration
         ,p_Timeout_uom_code        => p_CONDITION_rec.Timeout_uom_code
         ,p_Notify_Owner        => p_CONDITION_rec.Notify_Owner
         ,p_Notify_Owner_Manager    => p_CONDITION_rec.Notify_Owner_Manager
         ,p_ATTRIBUTE_CATEGORY  => p_CONDITION_rec.ATTRIBUTE_CATEGORY
         ,p_ATTRIBUTE1  => p_CONDITION_rec.ATTRIBUTE1
         ,p_ATTRIBUTE2  => p_CONDITION_rec.ATTRIBUTE2
         ,p_ATTRIBUTE3  => p_CONDITION_rec.ATTRIBUTE3
         ,p_ATTRIBUTE4  => p_CONDITION_rec.ATTRIBUTE4
         ,p_ATTRIBUTE5  => p_CONDITION_rec.ATTRIBUTE5
         ,p_ATTRIBUTE6  => p_CONDITION_rec.ATTRIBUTE6
         ,p_ATTRIBUTE7  => p_CONDITION_rec.ATTRIBUTE7
         ,p_ATTRIBUTE8  => p_CONDITION_rec.ATTRIBUTE8
         ,p_ATTRIBUTE9  => p_CONDITION_rec.ATTRIBUTE9
         ,p_ATTRIBUTE10  => p_CONDITION_rec.ATTRIBUTE10
         ,p_ATTRIBUTE11  => p_CONDITION_rec.ATTRIBUTE11
         ,p_ATTRIBUTE12  => p_CONDITION_rec.ATTRIBUTE12
         ,p_ATTRIBUTE13  => p_CONDITION_rec.ATTRIBUTE13
         ,p_ATTRIBUTE14  => p_CONDITION_rec.ATTRIBUTE14
         ,p_ATTRIBUTE15  => p_CONDITION_rec.ATTRIBUTE15
);      -- Hint: Primary key should be returned.

Line: 224


PROCEDURE Update_monitor_condition(
    P_Api_Version_Number         IN   NUMBER,
    P_Init_Msg_List              IN   VARCHAR2   := FND_API.G_FALSE,
    P_Commit                     IN   VARCHAR2   := FND_API.G_FALSE,
    p_validation_level           IN   NUMBER     := FND_API.G_VALID_LEVEL_FULL,
    p_identity_salesforce_id     IN   NUMBER,
    P_CONDITION_Rec              IN   AML_MONITOR_CONDITIONS_PUB.CONDITION_Rec_Type,
    X_Return_Status              OUT  NOCOPY VARCHAR2,
    X_Msg_Count                  OUT  NOCOPY NUMBER,
    X_Msg_Data                   OUT  NOCOPY VARCHAR2
    )
 IS

Cursor C_Get_monitor_condition(C_MONITOR_CONDITION_ID Number) IS
    Select rowid,
           MONITOR_CONDITION_ID,
           LAST_UPDATE_DATE,
           LAST_UPDATED_BY,
           CREATION_DATE,
           CREATED_BY,
           LAST_UPDATE_LOGIN,
           OBJECT_VERSION_NUMBER,
           REQUEST_ID,
           PROGRAM_APPLICATION_ID,
           PROGRAM_ID,
           PROGRAM_UPDATE_DATE,
           PROCESS_RULE_ID,
           MONITOR_TYPE_CODE,
           TIME_LAG_NUM,
           TIME_LAG_UOM_CODE,
           TIME_LAG_FROM_STAGE,
           TIME_LAG_TO_STAGE,
           Expiration_Relative,
           Reminder_Defined,
           Total_Reminders,
           Reminder_Frequency,
           Reminder_Freq_uom_code,
           Timeout_Defined,
           Timeout_Duration,
           Timeout_uom_code,
           Notify_Owner,
           Notify_Owner_Manager,
           ATTRIBUTE_CATEGORY,
           ATTRIBUTE1,
           ATTRIBUTE2,
           ATTRIBUTE3,
           ATTRIBUTE4,
           ATTRIBUTE5,
           ATTRIBUTE6,
           ATTRIBUTE7,
           ATTRIBUTE8,
           ATTRIBUTE9,
           ATTRIBUTE10,
           ATTRIBUTE11,
           ATTRIBUTE12,
           ATTRIBUTE13,
           ATTRIBUTE14,
           ATTRIBUTE15
    From  AML_MONITOR_CONDITIONS
    where monitor_condition_id = c_monitor_condition_id
    For Update NOWAIT;

Line: 286


l_api_name                CONSTANT VARCHAR2(30) := 'Update_monitor_condition';

Line: 294


      SAVEPOINT UPDATE_MONITOR_CONDITION_PVT;

Line: 328


        AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: - Open Cursor to Select');

Line: 336


               l_ref_CONDITION_rec.LAST_UPDATE_DATE,
               l_ref_CONDITION_rec.LAST_UPDATED_BY,
               l_ref_CONDITION_rec.CREATION_DATE,
               l_ref_CONDITION_rec.CREATED_BY,
               l_ref_CONDITION_rec.LAST_UPDATE_LOGIN,
               l_ref_CONDITION_rec.OBJECT_VERSION_NUMBER,
               l_ref_CONDITION_rec.REQUEST_ID,
               l_ref_CONDITION_rec.PROGRAM_APPLICATION_ID,
               l_ref_CONDITION_rec.PROGRAM_ID,
               l_ref_CONDITION_rec.PROGRAM_UPDATE_DATE,
               l_ref_CONDITION_rec.PROCESS_RULE_ID,
               l_ref_CONDITION_rec.MONITOR_TYPE_CODE,
               l_ref_CONDITION_rec.TIME_LAG_NUM,
               l_ref_CONDITION_rec.TIME_LAG_UOM_CODE,
               l_ref_CONDITION_rec.TIME_LAG_FROM_STAGE,
               l_ref_CONDITION_rec.TIME_LAG_TO_STAGE,
               l_ref_CONDITION_rec.Expiration_Relative,
               l_ref_CONDITION_rec.Reminder_Defined,
               l_ref_CONDITION_rec.Total_Reminders,
               l_ref_CONDITION_rec.Reminder_Frequency,
               l_ref_CONDITION_rec.Reminder_Freq_uom_code,
               l_ref_CONDITION_rec.Timeout_Defined,
               l_ref_CONDITION_rec.Timeout_Duration,
               l_ref_CONDITION_rec.Timeout_uom_code,
               l_ref_CONDITION_rec.Notify_Owner,
               l_ref_CONDITION_rec.Notify_Owner_Manager,
               l_ref_CONDITION_rec.ATTRIBUTE_CATEGORY,
               l_ref_CONDITION_rec.ATTRIBUTE1,
               l_ref_CONDITION_rec.ATTRIBUTE2,
               l_ref_CONDITION_rec.ATTRIBUTE3,
               l_ref_CONDITION_rec.ATTRIBUTE4,
               l_ref_CONDITION_rec.ATTRIBUTE5,
               l_ref_CONDITION_rec.ATTRIBUTE6,
               l_ref_CONDITION_rec.ATTRIBUTE7,
               l_ref_CONDITION_rec.ATTRIBUTE8,
               l_ref_CONDITION_rec.ATTRIBUTE9,
               l_ref_CONDITION_rec.ATTRIBUTE10,
               l_ref_CONDITION_rec.ATTRIBUTE11,
               l_ref_CONDITION_rec.ATTRIBUTE12,
               l_ref_CONDITION_rec.ATTRIBUTE13,
               l_ref_CONDITION_rec.ATTRIBUTE14,
               l_ref_CONDITION_rec.ATTRIBUTE15;

Line: 382


               FND_MESSAGE.Set_Name('AMS', 'API_MISSING_UPDATE_TARGET');

Line: 399


      If (l_tar_CONDITION_rec.last_update_date is NULL or
          l_tar_CONDITION_rec.last_update_date = FND_API.G_MISS_Date ) Then
          IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
          THEN
              FND_MESSAGE.Set_Name('AMS', 'API_MISSING_ID');

Line: 404


              FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);

Line: 410


      If (l_tar_CONDITION_rec.last_update_date <> l_ref_CONDITION_rec.last_update_date) Then
          IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
          THEN
              FND_MESSAGE.Set_Name('AMS', 'API_RECORD_CHANGED');

Line: 429


          p_validation_mode  => AS_UTILITY_PVT.G_UPDATE,
          P_CONDITION_Rec  =>  P_CONDITION_Rec,
          x_return_status    => x_return_status,
          x_msg_count        => x_msg_count,
          x_msg_data         => x_msg_data);

Line: 445


        AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler');

Line: 449


      AML_MONITOR_CONDITIONS_PKG.Update_Row(
          p_MONITOR_CONDITION_ID  => p_CONDITION_rec.MONITOR_CONDITION_ID
         ,p_LAST_UPDATE_DATE  => SYSDATE
         ,p_LAST_UPDATED_BY  => FND_GLOBAL.USER_ID
         ,p_CREATION_DATE  => FND_API.G_MISS_DATE
         ,p_CREATED_BY     => FND_API.G_MISS_NUM
         ,p_LAST_UPDATE_LOGIN  => FND_GLOBAL.CONC_LOGIN_ID
         ,p_OBJECT_VERSION_NUMBER  => p_CONDITION_rec.OBJECT_VERSION_NUMBER
         ,p_REQUEST_ID  => p_CONDITION_rec.REQUEST_ID
         ,p_PROGRAM_APPLICATION_ID  => p_CONDITION_rec.PROGRAM_APPLICATION_ID
         ,p_PROGRAM_ID  => p_CONDITION_rec.PROGRAM_ID
         ,p_PROGRAM_UPDATE_DATE  => p_CONDITION_rec.PROGRAM_UPDATE_DATE
         ,p_PROCESS_RULE_ID  => p_CONDITION_rec.PROCESS_RULE_ID
         ,p_MONITOR_TYPE_CODE  => p_CONDITION_rec.MONITOR_TYPE_CODE
         ,p_TIME_LAG_NUM  => p_CONDITION_rec.TIME_LAG_NUM
         ,p_TIME_LAG_UOM_CODE  => p_CONDITION_rec.TIME_LAG_UOM_CODE
         ,p_TIME_LAG_FROM_STAGE  => p_CONDITION_rec.TIME_LAG_FROM_STAGE
         ,p_TIME_LAG_TO_STAGE  => p_CONDITION_rec.TIME_LAG_TO_STAGE
         ,p_Expiration_Relative          => p_CONDITION_rec.Expiration_Relative
         ,p_Reminder_Defined             => p_CONDITION_rec.Reminder_Defined
         ,p_Total_Reminders              => p_CONDITION_rec.Total_Reminders
         ,p_Reminder_Frequency           => p_CONDITION_rec.Reminder_Frequency
         ,p_Reminder_Freq_uom_code       => p_CONDITION_rec.Reminder_Freq_uom_code
         ,p_Timeout_Defined              => p_CONDITION_rec.Timeout_Defined
         ,p_Timeout_Duration             => p_CONDITION_rec.Timeout_Duration
         ,p_Timeout_uom_code             => p_CONDITION_rec.Timeout_uom_code
         ,p_Notify_Owner             => p_CONDITION_rec.Notify_Owner
         ,p_Notify_Owner_Manager     => p_CONDITION_rec.Notify_Owner_Manager
         ,p_ATTRIBUTE_CATEGORY  => p_CONDITION_rec.ATTRIBUTE_CATEGORY
         ,p_ATTRIBUTE1  => p_CONDITION_rec.ATTRIBUTE1
         ,p_ATTRIBUTE2  => p_CONDITION_rec.ATTRIBUTE2
         ,p_ATTRIBUTE3  => p_CONDITION_rec.ATTRIBUTE3
         ,p_ATTRIBUTE4  => p_CONDITION_rec.ATTRIBUTE4
         ,p_ATTRIBUTE5  => p_CONDITION_rec.ATTRIBUTE5
         ,p_ATTRIBUTE6  => p_CONDITION_rec.ATTRIBUTE6
         ,p_ATTRIBUTE7  => p_CONDITION_rec.ATTRIBUTE7
         ,p_ATTRIBUTE8  => p_CONDITION_rec.ATTRIBUTE8
         ,p_ATTRIBUTE9  => p_CONDITION_rec.ATTRIBUTE9
         ,p_ATTRIBUTE10  => p_CONDITION_rec.ATTRIBUTE10
         ,p_ATTRIBUTE11  => p_CONDITION_rec.ATTRIBUTE11
         ,p_ATTRIBUTE12  => p_CONDITION_rec.ATTRIBUTE12
         ,p_ATTRIBUTE13  => p_CONDITION_rec.ATTRIBUTE13
         ,p_ATTRIBUTE14  => p_CONDITION_rec.ATTRIBUTE14
         ,p_ATTRIBUTE15  => p_CONDITION_rec.ATTRIBUTE15
);      --

Line: 548


End Update_monitor_condition;

Line: 552


PROCEDURE Delete_monitor_condition(
    P_Api_Version_Number         IN   NUMBER,
    P_Init_Msg_List              IN   VARCHAR2   := FND_API.G_FALSE,
    P_Commit                     IN   VARCHAR2   := FND_API.G_FALSE,
    p_validation_level           IN   NUMBER     := FND_API.G_VALID_LEVEL_FULL,
    p_identity_salesforce_id     IN   NUMBER,
    P_CONDITION_Rec              IN   AML_MONITOR_CONDITIONS_PUB.CONDITION_Rec_Type,
    X_Return_Status              OUT  NOCOPY VARCHAR2,
    X_Msg_Count                  OUT  NOCOPY NUMBER,
    X_Msg_Data                   OUT  NOCOPY VARCHAR2
    )


 IS
l_api_name                CONSTANT VARCHAR2(30) := 'Delete_monitor_condition';

Line: 571


      SAVEPOINT DELETE_MONITOR_CONDITION_PVT;

Line: 605


        AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling delete table handler');

Line: 609


      AML_MONITOR_CONDITIONS_PKG.Delete_Row(
          p_process_rule_id  => p_CONDITION_rec.PROCESS_RULE_ID);

Line: 665


End Delete_monitor_condition;

Line: 678


      SELECT 'X'
      FROM  aml_monitor_conditions
      WHERE MONITOR_CONDITION_ID = C_MONITOR_CONDITION_ID;

Line: 718


      ELSIF(p_validation_mode = AS_UTILITY_PVT.G_UPDATE)
      THEN
          -- validate NOT NULL column
          IF (p_monitor_condition_id IS NULL) OR
             (p_monitor_condition_id = FND_API.G_MISS_NUM)
          THEN
              AS_UTILITY_PVT.Set_Message(
                  p_msg_level     => FND_MSG_PUB.G_MSG_LVL_ERROR,
                  p_msg_name      => 'API_MISSING_ID',
                  p_token1        => 'COLUMN',
                  p_token1_value  => 'MONITOR_CONDITION_ID');

Line: 775


   SELECT 'X'
   FROM (
      SELECT status_code time_lag_to_stage
      FROM  as_statuses_b
      WHERE lead_flag = 'Y' and enabled_flag = 'Y'
        UNION ALL
      SELECT  lookup_code time_lag_to_stage
      FROM  fnd_lookup_values
      WHERE lookup_type = 'TIME_LAG_TO_STAGE'
      AND enabled_flag = 'Y'
      AND (start_date_active IS NULL OR start_date_active < SYSDATE)
      AND (end_date_active IS NULL OR end_date_active > SYSDATE))
   WHERE time_lag_to_stage = c_time_lag_to_stage;