DBA Data[Home] [Help]

APPS.AST_GRP_CAMP_PVT SQL Statements

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

Line: 148

      AST_GRP_CAMPAIGNS_PKG.Insert_Row(
          px_GROUP_CAMPAIGN_ID  => x_GROUP_CAMPAIGN_ID,
          p_GROUP_ID  => p_grp_camp_rec.GROUP_ID,
          p_CAMPAIGN_ID  => p_grp_camp_rec.CAMPAIGN_ID,
          p_START_DATE  => p_grp_camp_rec.START_DATE,
          p_END_DATE  => p_grp_camp_rec.END_DATE,
          p_ENABLED_FLAG  => p_grp_camp_rec.ENABLED_FLAG,
          p_LAST_UPDATE_DATE  => SYSDATE,
          p_LAST_UPDATED_BY  => G_USER_ID,
          p_LAST_UPDATE_LOGIN  => G_LOGIN_ID,
          p_CREATED_BY  => G_USER_ID,
          p_CREATION_DATE  => p_grp_camp_rec.CREATION_DATE);
Line: 239

PROCEDURE Update_grp_camp(
    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       := NULL,
    P_grp_camp_Rec     IN    grp_camp_Rec_Type,
    X_Return_Status              OUT  VARCHAR2,
    X_Msg_Count                  OUT  NUMBER,
    X_Msg_Data                   OUT  VARCHAR2
    )

 IS
Cursor C_Get_grp_camp(p_GROUP_CAMPAIGN_ID Number) IS
    Select rowid,
           GROUP_CAMPAIGN_ID,
           GROUP_ID,
           CAMPAIGN_ID,
           START_DATE,
           END_DATE,
           ENABLED_FLAG,
           LAST_UPDATE_DATE,
           LAST_UPDATED_BY,
           LAST_UPDATE_LOGIN,
           CREATED_BY,
           CREATION_DATE
    From  AST_GRP_CAMPAIGNS
    where group_campaign_id = p_group_campaign_id
    -- Hint: Developer need to provide Where clause
    For Update NOWAIT;
Line: 269

l_api_name                CONSTANT VARCHAR2(30) := 'Update_grp_camp';
Line: 278

      SAVEPOINT UPDATE_grp_camp_PVT;
Line: 312

          AS_CALLOUT_PKG.Update_grp_camp_BU(
                  p_api_version_number   =>  1.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_grp_camp_Rec      =>  P_grp_camp_Rec,
          -- Hint: Add detail tables as parameter lists if it's master-detail relationship.
                  x_return_status        =>  x_return_status,
                  x_msg_count            =>  x_msg_count,
                  x_msg_data             =>  x_msg_data);
Line: 339

      JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'ast', 'Private API: - Open Cursor to Select');
Line: 352

               l_ref_grp_camp_rec.LAST_UPDATE_DATE,
               l_ref_grp_camp_rec.LAST_UPDATED_BY,
               l_ref_grp_camp_rec.LAST_UPDATE_LOGIN,
               l_ref_grp_camp_rec.CREATED_BY,
               l_ref_grp_camp_rec.CREATION_DATE;
Line: 361

               FND_MESSAGE.Set_Name('ast', 'API_MISSING_UPDATE_TARGET');
Line: 373

      If (l_tar_grp_camp_rec.last_update_date is NULL or
          l_tar_grp_camp_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('ast', 'API_MISSING_ID');
Line: 378

              FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
Line: 385

      If (l_tar_grp_camp_rec.last_update_date <> l_ref_grp_camp_rec.last_update_date) Then
          IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
          THEN
              FND_MESSAGE.Set_Name('ast', 'API_RECORD_CHANGED');
Line: 404

              p_validation_mode  => JTF_PLSQL_API.G_UPDATE,
              P_grp_camp_Rec  =>  P_grp_camp_Rec,
              x_return_status    => x_return_status,
              x_msg_count        => x_msg_count,
              x_msg_data         => x_msg_data);
Line: 418

      JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'ast', 'Private API: Calling update table handler');
Line: 421

      AST_GRP_CAMPAIGNS_PKG.Update_Row(
          p_GROUP_CAMPAIGN_ID  => p_grp_camp_rec.GROUP_CAMPAIGN_ID,
          p_GROUP_ID  => p_grp_camp_rec.GROUP_ID,
          p_CAMPAIGN_ID  => p_grp_camp_rec.CAMPAIGN_ID,
          p_START_DATE  => p_grp_camp_rec.START_DATE,
          p_END_DATE  => p_grp_camp_rec.END_DATE,
          p_ENABLED_FLAG  => p_grp_camp_rec.ENABLED_FLAG,
          p_LAST_UPDATE_DATE  => SYSDATE,
          p_LAST_UPDATED_BY  => G_USER_ID,
          p_LAST_UPDATE_LOGIN  => G_LOGIN_ID,
          p_CREATED_BY  => G_USER_ID,
          p_CREATION_DATE  => p_grp_camp_rec.CREATION_DATE);
Line: 459

          AS_CALLOUT_PKG.Update_grp_camp_AU(
                  p_api_version_number   =>  1.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_grp_camp_Rec      =>  P_grp_camp_Rec,
          -- Hint: Add detail tables as parameter lists if it's master-detail relationship.
                  x_return_status        =>  x_return_status,
                  x_msg_count            =>  x_msg_count,
                  x_msg_data             =>  x_msg_data);
Line: 502

End Update_grp_camp;
Line: 507

PROCEDURE Delete_grp_camp(
    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       := NULL,
    P_grp_camp_Rec     IN grp_camp_Rec_Type,
    X_Return_Status              OUT  VARCHAR2,
    X_Msg_Count                  OUT  NUMBER,
    X_Msg_Data                   OUT  VARCHAR2
    )

 IS
l_api_name                CONSTANT VARCHAR2(30) := 'Delete_grp_camp';
Line: 525

      SAVEPOINT DELETE_grp_camp_PVT;
Line: 559

          AS_CALLOUT_PKG.Delete_grp_camp_BD(
                  p_api_version_number   =>  1.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_grp_camp_Rec      =>  P_grp_camp_Rec,
          -- Hint: Add detail tables as parameter lists if it's master-detail relationship.
                  x_return_status        =>  x_return_status,
                  x_msg_count            =>  x_msg_count,
                  x_msg_data             =>  x_msg_data);
Line: 586

      JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'ast',  'Private API: Calling delete table handler');
Line: 591

      AST_GRP_CAMPAIGNS_PKG.Delete_Row(
          p_GROUP_CAMPAIGN_ID  => p_grp_camp_rec.GROUP_CAMPAIGN_ID);
Line: 619

          AS_CALLOUT_PKG.Delete_grp_camp_AD(
                  p_api_version_number   =>  1.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_grp_camp_Rec      =>  P_grp_camp_Rec,
          -- Hint: Add detail tables as parameter lists if it's master-detail relationship.
                  x_return_status        =>  x_return_status,
                  x_msg_count            =>  x_msg_count,
                  x_msg_data             =>  x_msg_data);
Line: 662

End Delete_grp_camp;
Line: 775

PROCEDURE Gen_Select(
    x_select_cl   OUT   VARCHAR2
)
IS
BEGIN
      -- Debug Message
      JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'ast', 'Private API: Generate Select Begins');
Line: 783

      x_select_cl := 'Select ' ||
                'AST_GRP_TEST.GROUP_CAMPAIGN_ID,' ||
                'AST_GRP_TEST.GROUP_ID,' ||
                'AST_GRP_TEST.CAMPAIGN_ID,' ||
                'AST_GRP_TEST.START_DATE,' ||
                'AST_GRP_TEST.END_DATE,' ||
                'AST_GRP_TEST.ENABLED_FLAG,' ||
                'AST_GRP_TEST.LAST_UPDATE_DATE,' ||
                'AST_GRP_TEST.LAST_UPDATED_BY,' ||
                'AST_GRP_TEST.LAST_UPDATE_LOGIN,' ||
                'AST_GRP_TEST.CREATED_BY,' ||
                'AST_GRP_TEST.CREATION_DATE,' ||
                'from AST_GRP_TEST';
Line: 797

      JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'ast', 'Private API: Generate Select Ends');
Line: 799

END Gen_Select;
Line: 809

    SELECT INSTR(p_rec_item, '%', 1, 1)
    FROM DUAL;
Line: 812

    SELECT INSTR(p_rec_item, '_', 1, 1)
    FROM DUAL;
Line: 956

l_select_cl              VARCHAR2(2000) := '';
Line: 1020

      Gen_Select(l_select_cl);
Line: 1218

      ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
      THEN
          -- Hint: Validate data
          -- IF p_GROUP_CAMPAIGN_ID <> G_MISS_CHAR
          -- verify if data is valid
          -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
Line: 1274

      ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
      THEN
          -- Hint: Validate data
          -- IF p_GROUP_ID <> G_MISS_CHAR
          -- verify if data is valid
          -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
Line: 1330

      ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
      THEN
          -- Hint: Validate data
          -- IF p_CAMPAIGN_ID <> G_MISS_CHAR
          -- verify if data is valid
          -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
Line: 1378

      ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
      THEN
          -- Hint: Validate data
          -- IF p_START_DATE <> G_MISS_CHAR
          -- verify if data is valid
          -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
Line: 1426

      ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
      THEN
          -- Hint: Validate data
          -- IF p_END_DATE <> G_MISS_CHAR
          -- verify if data is valid
          -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
Line: 1482

      ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
      THEN
          -- Hint: Validate data
          -- IF p_ENABLED_FLAG <> G_MISS_CHAR
          -- verify if data is valid
          -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;