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

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

Line: 145


      AST_RS_CAMPAIGNS_PKG.Insert_Row(
          px_RS_CAMPAIGN_ID  => x_RS_CAMPAIGN_ID,
          p_RESOURCE_ID  => p_rs_camp_rec.RESOURCE_ID,
          p_CAMPAIGN_ID  => p_rs_camp_rec.CAMPAIGN_ID,
          p_START_DATE  => p_rs_camp_rec.START_DATE,
          p_END_DATE  => p_rs_camp_rec.END_DATE,
          p_STATUS  => p_rs_camp_rec.STATUS,
          p_ENABLED_FLAG  => p_rs_camp_rec.ENABLED_FLAG,
          p_CREATED_BY  => G_USER_ID,
          p_CREATION_DATE  => SYSDATE,
          p_LAST_UPDATED_BY  => G_USER_ID,
          p_LAST_UPDATE_DATE  => SYSDATE,
          p_LAST_UPDATE_LOGIN  => p_rs_camp_rec.LAST_UPDATE_LOGIN);

Line: 237


PROCEDURE Update_rs_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_rs_camp_Rec     IN    rs_camp_Rec_Type,
    X_Return_Status              OUT NOCOPY /* file.sql.39 change */  VARCHAR2,
    X_Msg_Count                  OUT NOCOPY /* file.sql.39 change */  NUMBER,
    X_Msg_Data                   OUT NOCOPY /* file.sql.39 change */  VARCHAR2
    )

 IS

Cursor C_Get_rs_camp(p_RS_CAMPAIGN_ID Number) IS
    Select rowid,
           RS_CAMPAIGN_ID,
           RESOURCE_ID,
           CAMPAIGN_ID,
           START_DATE,
           END_DATE,
           STATUS,
           ENABLED_FLAG,
           CREATED_BY,
           CREATION_DATE,
           LAST_UPDATED_BY,
           LAST_UPDATE_DATE,
           LAST_UPDATE_LOGIN
    From  AST_RS_CAMPAIGNS
    Where rs_campaign_id = p_RS_CAMPAIGN_ID
    -- Hint: Developer need to provide Where clause
    For Update NOWAIT;

Line: 270


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

Line: 279


      SAVEPOINT UPDATE_rs_camp_PVT;

Line: 313


          AS_CALLOUT_PKG.Update_rs_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_rs_camp_Rec      =>  P_rs_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: 340


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

Line: 354


               l_ref_rs_camp_rec.LAST_UPDATED_BY,
               l_ref_rs_camp_rec.LAST_UPDATE_DATE,
               l_ref_rs_camp_rec.LAST_UPDATE_LOGIN;

Line: 361


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

Line: 374


     If (l_tar_rs_camp_rec.last_update_date is NULL or
          l_tar_rs_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: 379


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

Line: 385


/*      If (l_tar_rs_camp_rec.last_update_date <> l_ref_rs_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: 405


              p_validation_mode  => JTF_PLSQL_API.G_UPDATE,
              P_rs_camp_Rec  =>  P_rs_camp_Rec,
              x_return_status    => x_return_status,
              x_msg_count        => x_msg_count,
              x_msg_data         => x_msg_data);

Line: 419


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

Line: 423


      AST_RS_CAMPAIGNS_PKG.Update_Row(
          p_RS_CAMPAIGN_ID  => p_rs_camp_rec.RS_CAMPAIGN_ID,
          p_RESOURCE_ID  => p_rs_camp_rec.RESOURCE_ID,
          p_CAMPAIGN_ID  => p_rs_camp_rec.CAMPAIGN_ID,
          p_START_DATE  => p_rs_camp_rec.START_DATE,
          p_END_DATE  => p_rs_camp_rec.END_DATE,
          p_STATUS  => p_rs_camp_rec.STATUS,
          p_ENABLED_FLAG  => p_rs_camp_rec.ENABLED_FLAG,
          p_CREATED_BY  => G_USER_ID,
          p_CREATION_DATE  => SYSDATE,
          p_LAST_UPDATED_BY  => G_USER_ID,
          p_LAST_UPDATE_DATE  => SYSDATE,
          p_LAST_UPDATE_LOGIN  => p_rs_camp_rec.LAST_UPDATE_LOGIN);

Line: 461


          AS_CALLOUT_PKG.Update_rs_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_rs_camp_Rec      =>  P_rs_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: 504


End Update_rs_camp;

Line: 509


PROCEDURE Delete_rs_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_rs_camp_Rec     IN rs_camp_Rec_Type,
    X_Return_Status              OUT NOCOPY /* file.sql.39 change */  VARCHAR2,
    X_Msg_Count                  OUT NOCOPY /* file.sql.39 change */  NUMBER,
    X_Msg_Data                   OUT NOCOPY /* file.sql.39 change */  VARCHAR2
    )

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

Line: 527


      SAVEPOINT DELETE_rs_camp_PVT;

Line: 563


          AS_CALLOUT_PKG.Delete_rs_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_rs_camp_Rec      =>  P_rs_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: 590


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

Line: 594


      AST_RS_CAMPAIGNS_PKG.Delete_Row(
          p_RS_CAMPAIGN_ID  => p_rs_camp_rec.RS_CAMPAIGN_ID);

Line: 624


          AS_CALLOUT_PKG.Delete_rs_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_rs_camp_Rec      =>  P_rs_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: 667


End Delete_rs_camp;

Line: 793


PROCEDURE Gen_Select(
    x_select_cl   OUT NOCOPY /* file.sql.39 change */   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: 802


      x_select_cl := 'Select ' ||
                'AST_TEST.RS_CAMPAIGN_ID,' ||
                'AST_TEST.RESOURCE_ID,' ||
                'AST_TEST.CAMPAIGN_ID,' ||
                'AST_TEST.START_DATE,' ||
                'AST_TEST.END_DATE,' ||
                'AST_TEST.STATUS,' ||
                'AST_TEST.ENABLED_FLAG,' ||
                'AST_TEST.CREATED_BY,' ||
                'AST_TEST.CREATION_DATE,' ||
                'AST_TEST.LAST_UPDATED_BY,' ||
                'AST_TEST.LAST_UPDATE_DATE,' ||
                'AST_TEST.LAST_UPDATE_LOGIN,' ||
                'from AST_TEST';

Line: 817


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

Line: 820


END Gen_Select;

Line: 830


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

Line: 833


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

Line: 983


l_select_cl              VARCHAR2(2000) := '';

Line: 1050


      Gen_Select(l_select_cl);

Line: 1261


      ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
      THEN
          -- Hint: Validate data
          -- IF p_RS_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: 1317


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

Line: 1373


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


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


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


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

Line: 1581


      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;