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

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

Line: 76


      CSP_PRODUCT_TASKS_PKG.Insert_Row(
          px_PRODUCT_TASK_ID  => x_PRODUCT_TASK_ID,
          p_PRODUCT_ID  => p_PROD_TASK_rec.PRODUCT_ID,
          p_TASK_TEMPLATE_ID  => p_PROD_TASK_rec.TASK_TEMPLATE_ID,
          p_AUTO_MANUAL  => p_PROD_TASK_rec.AUTO_MANUAL,
          p_ACTUAL_TIMES_USED  => p_PROD_TASK_rec.ACTUAL_TIMES_USED,
          p_TASK_PERCENTAGE  => p_PROD_TASK_rec.TASK_PERCENTAGE,
          p_ATTRIBUTE_CATEGORY  => p_PROD_TASK_rec.ATTRIBUTE_CATEGORY,
          p_ATTRIBUTE1  => p_PROD_TASK_rec.ATTRIBUTE1,
          p_ATTRIBUTE2  => p_PROD_TASK_rec.ATTRIBUTE2,
          p_ATTRIBUTE3  => p_PROD_TASK_rec.ATTRIBUTE3,
          p_ATTRIBUTE4  => p_PROD_TASK_rec.ATTRIBUTE4,
          p_ATTRIBUTE5  => p_PROD_TASK_rec.ATTRIBUTE5,
          p_ATTRIBUTE6  => p_PROD_TASK_rec.ATTRIBUTE6,
          p_ATTRIBUTE7  => p_PROD_TASK_rec.ATTRIBUTE7,
          p_ATTRIBUTE8  => p_PROD_TASK_rec.ATTRIBUTE8,
          p_ATTRIBUTE9  => p_PROD_TASK_rec.ATTRIBUTE9,
          p_ATTRIBUTE10  => p_PROD_TASK_rec.ATTRIBUTE10,
          p_ATTRIBUTE11  => p_PROD_TASK_rec.ATTRIBUTE11,
          p_ATTRIBUTE12  => p_PROD_TASK_rec.ATTRIBUTE12,
          p_ATTRIBUTE13  => p_PROD_TASK_rec.ATTRIBUTE13,
          p_ATTRIBUTE14  => p_PROD_TASK_rec.ATTRIBUTE14,
          p_ATTRIBUTE15  => p_PROD_TASK_rec.ATTRIBUTE15,
          p_CREATED_BY  => FND_GLOBAL.USER_ID,
          p_CREATION_DATE  => SYSDATE,
          p_LAST_UPDATED_BY  => FND_GLOBAL.USER_ID,
          p_LAST_UPDATE_DATE  => SYSDATE,
          p_LAST_UPDATE_LOGIN  => p_PROD_TASK_rec.LAST_UPDATE_LOGIN);

Line: 154


PROCEDURE Update_product_task(
    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_PROD_TASK_Rec              IN   PROD_TASK_Rec_Type,
    X_Return_Status              OUT NOCOPY  VARCHAR2,
    X_Msg_Count                  OUT NOCOPY  NUMBER,
    X_Msg_Data                   OUT NOCOPY  VARCHAR2
    )
 IS

Cursor C_Get_product_task(L_PRODUCT_TASK_ID Number) IS
    Select rowid,
           PRODUCT_TASK_ID,
           PRODUCT_ID,
           TASK_TEMPLATE_ID,
           AUTO_MANUAL,
           ACTUAL_TIMES_USED,
           TASK_PERCENTAGE,
           ATTRIBUTE_CATEGORY,
           ATTRIBUTE1,
           ATTRIBUTE2,
           ATTRIBUTE3,
           ATTRIBUTE4,
           ATTRIBUTE5,
           ATTRIBUTE6,
           ATTRIBUTE7,
           ATTRIBUTE8,
           ATTRIBUTE9,
           ATTRIBUTE10,
           ATTRIBUTE11,
           ATTRIBUTE12,
           ATTRIBUTE13,
           ATTRIBUTE14,
           ATTRIBUTE15,
           CREATED_BY,
           CREATION_DATE,
           LAST_UPDATED_BY,
           LAST_UPDATE_DATE,
           LAST_UPDATE_LOGIN
    From  CSP_PRODUCT_TASKS
    WHERE PRODUCT_TASK_ID = L_PRODUCT_TASK_ID
    -- Hint: Developer need to provide Where clause
    For Update NOWAIT;

Line: 200


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

Line: 208


      SAVEPOINT UPDATE_PRODUCT_TASK_PVT;

Line: 256


               l_ref_PROD_TASK_rec.LAST_UPDATED_BY,
               l_ref_PROD_TASK_rec.LAST_UPDATE_DATE,
               l_ref_PROD_TASK_rec.LAST_UPDATE_LOGIN;

Line: 263


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

Line: 272


      If (l_tar_PROD_TASK_rec.last_update_date is NULL or
          l_tar_PROD_TASK_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
          DBMS_OUTPUT.PUT_LINE('UPDATE DATE2 '||l_tar_PROD_TASK_rec.last_update_date);

Line: 278


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

Line: 285


      If (l_tar_PROD_TASK_rec.last_update_date <> l_ref_PROD_TASK_rec.last_update_date) Then
          IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
          THEN
              FND_MESSAGE.Set_Name('CSP', 'API_RECORD_CHANGED');

Line: 301


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

Line: 312


      CSP_PRODUCT_TASKS_PKG.Update_Row(
          p_PRODUCT_TASK_ID  => p_PROD_TASK_rec.PRODUCT_TASK_ID,
          p_PRODUCT_ID  => p_PROD_TASK_rec.PRODUCT_ID,
          p_TASK_TEMPLATE_ID  => p_PROD_TASK_rec.TASK_TEMPLATE_ID,
          p_AUTO_MANUAL  => p_PROD_TASK_rec.AUTO_MANUAL,
          p_ACTUAL_TIMES_USED  => p_PROD_TASK_rec.ACTUAL_TIMES_USED,
          p_TASK_PERCENTAGE  => p_PROD_TASK_rec.TASK_PERCENTAGE,
          p_ATTRIBUTE_CATEGORY  => p_PROD_TASK_rec.ATTRIBUTE_CATEGORY,
          p_ATTRIBUTE1  => p_PROD_TASK_rec.ATTRIBUTE1,
          p_ATTRIBUTE2  => p_PROD_TASK_rec.ATTRIBUTE2,
          p_ATTRIBUTE3  => p_PROD_TASK_rec.ATTRIBUTE3,
          p_ATTRIBUTE4  => p_PROD_TASK_rec.ATTRIBUTE4,
          p_ATTRIBUTE5  => p_PROD_TASK_rec.ATTRIBUTE5,
          p_ATTRIBUTE6  => p_PROD_TASK_rec.ATTRIBUTE6,
          p_ATTRIBUTE7  => p_PROD_TASK_rec.ATTRIBUTE7,
          p_ATTRIBUTE8  => p_PROD_TASK_rec.ATTRIBUTE8,
          p_ATTRIBUTE9  => p_PROD_TASK_rec.ATTRIBUTE9,
          p_ATTRIBUTE10  => p_PROD_TASK_rec.ATTRIBUTE10,
          p_ATTRIBUTE11  => p_PROD_TASK_rec.ATTRIBUTE11,
          p_ATTRIBUTE12  => p_PROD_TASK_rec.ATTRIBUTE12,
          p_ATTRIBUTE13  => p_PROD_TASK_rec.ATTRIBUTE13,
          p_ATTRIBUTE14  => p_PROD_TASK_rec.ATTRIBUTE14,
          p_ATTRIBUTE15  => p_PROD_TASK_rec.ATTRIBUTE15,
          p_CREATED_BY     => FND_API.G_MISS_NUM,
          p_CREATION_DATE  => FND_API.G_MISS_DATE,
          p_LAST_UPDATED_BY  => FND_GLOBAL.USER_ID,
          p_LAST_UPDATE_DATE  => SYSDATE,
          p_LAST_UPDATE_LOGIN  => p_PROD_TASK_rec.LAST_UPDATE_LOGIN);

Line: 384


End Update_product_task;

Line: 387


PROCEDURE Delete_product_task(
    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_PROD_TASK_Rec     IN PROD_TASK_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_product_task';

Line: 402


      SAVEPOINT DELETE_PRODUCT_TASK_PVT;

Line: 422


      CSP_PRODUCT_TASKS_PKG.Delete_Row(
          p_PRODUCT_TASK_ID  => p_PROD_TASK_rec.PRODUCT_TASK_ID);

Line: 467


End Delete_product_task;

Line: 547


PROCEDURE Gen_Select(
    x_select_cl   OUT NOCOPY   VARCHAR2
)
IS
BEGIN
      x_select_cl := 'Select ' ||
                'CSP_PRODUCT_TASKS.PRODUCT_TASK_ID,' ||
                'CSP_PRODUCT_TASKS.PRODUCT_ID,' ||
                'CSP_PRODUCT_TASKS.TASK_TEMPLATE_ID,' ||
                'CSP_PRODUCT_TASKS.AUTO_MANUAL,' ||
                'CSP_PRODUCT_TASKS.ACTUAL_TIMES_USED,' ||
                'CSP_PRODUCT_TASKS.TASK_PERCENTAGE,' ||
                'CSP_PRODUCT_TASKS.ATTRIBUTE_CATEGORY,' ||
                'CSP_PRODUCT_TASKS.ATTRIBUTE1,' ||
                'CSP_PRODUCT_TASKS.ATTRIBUTE2,' ||
                'CSP_PRODUCT_TASKS.ATTRIBUTE3,' ||
                'CSP_PRODUCT_TASKS.ATTRIBUTE4,' ||
                'CSP_PRODUCT_TASKS.ATTRIBUTE5,' ||
                'CSP_PRODUCT_TASKS.ATTRIBUTE6,' ||
                'CSP_PRODUCT_TASKS.ATTRIBUTE7,' ||
                'CSP_PRODUCT_TASKS.ATTRIBUTE8,' ||
                'CSP_PRODUCT_TASKS.ATTRIBUTE9,' ||
                'CSP_PRODUCT_TASKS.ATTRIBUTE10,' ||
                'CSP_PRODUCT_TASKS.ATTRIBUTE11,' ||
                'CSP_PRODUCT_TASKS.ATTRIBUTE12,' ||
                'CSP_PRODUCT_TASKS.ATTRIBUTE13,' ||
                'CSP_PRODUCT_TASKS.ATTRIBUTE14,' ||
                'CSP_PRODUCT_TASKS.ATTRIBUTE15,' ||
                'CSP_PRODUCT_TASKS.CREATED_BY,' ||
                'CSP_PRODUCT_TASKS.CREATION_DATE,' ||
                'CSP_PRODUCT_TASKS.LAST_UPDATED_BY,' ||
                'CSP_PRODUCT_TASKS.LAST_UPDATE_DATE,' ||
                'CSP_PRODUCT_TASKS.LAST_UPDATE_LOGIN,' ||
                'from CSP_PRODUCT_TASKS';

Line: 581


END Gen_Select;

Line: 590


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

Line: 593


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

Line: 703


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

Line: 747


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

Line: 791


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

Line: 835


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

Line: 874


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

Line: 913


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