APPS.AML_MONITOR_CONDITIONS_PUB SQL Statements

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

Line: 151

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    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) := 'Update_monitor_condition';

Line: 169

      SAVEPOINT UPDATE_MONITOR_CONDITION_PUB;

Line: 191

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

Line: 202

      AML_MONITOR_CONDITIONS_PVT.Update_Monitor_Condition(
            P_Api_Version_Number         => 2.0,
            P_Init_Msg_List              => FND_API.G_FALSE,
            P_Commit                     => FND_API.G_FALSE,
            P_Validation_Level           => P_Validation_Level,
            P_identity_salesforce_id     => P_identity_salesforce_id,
            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: 268

End Update_monitor_condition;

Line: 271

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

      SAVEPOINT DELETE_MONITOR_CONDITION_PVT;

Line: 312

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

Line: 323

      AML_MONITOR_CONDITIONS_PVT.Delete_Monitor_Condition(
            P_Api_Version_Number         => 2.0,
            P_Init_Msg_List              => FND_API.G_FALSE,
            P_Commit                     => FND_API.G_FALSE,
            P_Validation_Level           => P_Validation_Level,
            P_identity_salesforce_id     => P_identity_salesforce_id,
            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: 387

End Delete_monitor_condition;