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_TASK_PART_PVT SQL Statements

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

Line: 113


      CSP_TASK_PARTS_PKG.Insert_Row(
          px_TASK_PART_ID  => x_TASK_PART_ID,
          p_PRODUCT_TASK_ID  => p_TASK_PART_rec.PRODUCT_TASK_ID,
          p_INVENTORY_ITEM_ID  => p_TASK_PART_rec.INVENTORY_ITEM_ID,
          p_MANUAL_QUANTITY  => p_TASK_PART_rec.MANUAL_QUANTITY,
          p_MANUAL_PERCENTAGE  => p_TASK_PART_rec.MANUAL_PERCENTAGE,
          p_QUANTITY_USED  => p_TASK_PART_rec.QUANTITY_USED,
          p_ACTUAL_TIMES_USED  => p_TASK_PART_rec.ACTUAL_TIMES_USED,
          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  => FND_GLOBAL.CONC_LOGIN_ID,
          p_ATTRIBUTE_CATEGORY  => p_TASK_PART_rec.ATTRIBUTE_CATEGORY,
          p_ATTRIBUTE1  => p_TASK_PART_rec.ATTRIBUTE1,
          p_ATTRIBUTE2  => p_TASK_PART_rec.ATTRIBUTE2,
          p_ATTRIBUTE3  => p_TASK_PART_rec.ATTRIBUTE3,
          p_ATTRIBUTE4  => p_TASK_PART_rec.ATTRIBUTE4,
          p_ATTRIBUTE5  => p_TASK_PART_rec.ATTRIBUTE5,
          p_ATTRIBUTE6  => p_TASK_PART_rec.ATTRIBUTE6,
          p_ATTRIBUTE7  => p_TASK_PART_rec.ATTRIBUTE7,
          p_ATTRIBUTE8  => p_TASK_PART_rec.ATTRIBUTE8,
          p_ATTRIBUTE9  => p_TASK_PART_rec.ATTRIBUTE9,
          p_ATTRIBUTE10  => p_TASK_PART_rec.ATTRIBUTE10,
          p_ATTRIBUTE11  => p_TASK_PART_rec.ATTRIBUTE11,
          p_ATTRIBUTE12  => p_TASK_PART_rec.ATTRIBUTE12,
          p_ATTRIBUTE13  => p_TASK_PART_rec.ATTRIBUTE13,
          p_ATTRIBUTE14  => p_TASK_PART_rec.ATTRIBUTE14,
          p_ATTRIBUTE15  => p_TASK_PART_rec.ATTRIBUTE15,
          p_PRIMARY_UOM_CODE  => p_TASK_PART_rec.PRIMARY_UOM_CODE,
          p_REVISION  => p_TASK_PART_rec.REVISION,
          p_START_DATE  => p_TASK_PART_rec.START_DATE,
          p_END_DATE  => p_TASK_PART_rec.END_DATE,
          p_ROLLUP_QUANTITY_USED  => p_TASK_PART_rec.ROLLUP_QUANTITY_USED,
          p_ROLLUP_TIMES_USED  => p_TASK_PART_rec.ROLLUP_TIMES_USED,
          p_SUBSTITUTE_ITEM => p_TASK_PART_rec.SUBSTITUTE_ITEM );

Line: 201


PROCEDURE Update_task_part(
    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_TASK_PART_Rec     IN    TASK_PART_Rec_Type,
    X_Return_Status              OUT NOCOPY  VARCHAR2,
    X_Msg_Count                  OUT NOCOPY  NUMBER,
    X_Msg_Data                   OUT NOCOPY  VARCHAR2
    )
 IS
/*
Cursor C_Get_task_part(TASK_PART_ID Number) IS
    Select rowid,
           TASK_PART_ID,
           PRODUCT_TASK_ID,
           INVENTORY_ITEM_ID,
           MANUAL_QUANTITY,
           MANUAL_PERCENTAGE,
           QUANTITY_USED,
           ACTUAL_TIMES_USED,
           CALCULATED_QUANTITY,
           PART_PERCENTAGE,
           CREATED_BY,
           CREATION_DATE,
           LAST_UPDATED_BY,
           LAST_UPDATE_DATE,
           LAST_UPDATE_LOGIN,
           ATTRIBUTE_CATEGORY,
           ATTRIBUTE1,
           ATTRIBUTE2,
           ATTRIBUTE3,
           ATTRIBUTE4,
           ATTRIBUTE5,
           ATTRIBUTE6,
           ATTRIBUTE7,
           ATTRIBUTE8,
           ATTRIBUTE9,
           ATTRIBUTE10,
           ATTRIBUTE11,
           ATTRIBUTE12,
           ATTRIBUTE13,
           ATTRIBUTE14,
           ATTRIBUTE15,
           PRIMARY_UOM_CODE,
           REVISION,
           START_DATE,
           END_DATE
    From  CSP_TASK_PARTS
    -- Hint: Developer need to provide Where clause
    For Update NOWAIT;

Line: 253


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

Line: 262


      SAVEPOINT UPDATE_TASK_PART_PVT;

Line: 284


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

Line: 300


               l_ref_TASK_PART_rec.LAST_UPDATED_BY,
               l_ref_TASK_PART_rec.LAST_UPDATE_DATE,
               l_ref_TASK_PART_rec.LAST_UPDATE_LOGIN,
               l_ref_TASK_PART_rec.ATTRIBUTE_CATEGORY,
               l_ref_TASK_PART_rec.ATTRIBUTE1,
               l_ref_TASK_PART_rec.ATTRIBUTE2,
               l_ref_TASK_PART_rec.ATTRIBUTE3,
               l_ref_TASK_PART_rec.ATTRIBUTE4,
               l_ref_TASK_PART_rec.ATTRIBUTE5,
               l_ref_TASK_PART_rec.ATTRIBUTE6,
               l_ref_TASK_PART_rec.ATTRIBUTE7,
               l_ref_TASK_PART_rec.ATTRIBUTE8,
               l_ref_TASK_PART_rec.ATTRIBUTE9,
               l_ref_TASK_PART_rec.ATTRIBUTE10,
               l_ref_TASK_PART_rec.ATTRIBUTE11,
               l_ref_TASK_PART_rec.ATTRIBUTE12,
               l_ref_TASK_PART_rec.ATTRIBUTE13,
               l_ref_TASK_PART_rec.ATTRIBUTE14,
               l_ref_TASK_PART_rec.ATTRIBUTE15,
               l_ref_TASK_PART_rec.PRIMARY_UOM_CODE,
               l_ref_TASK_PART_rec.REVISION,
               l_ref_TASK_PART_rec.START_DATE,
               l_ref_TASK_PART_rec.END_DATE;

Line: 326


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

Line: 336


      If (l_tar_TASK_PART_rec.last_update_date is NULL or
          l_tar_TASK_PART_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('CSP', 'API_MISSING_ID');

Line: 341


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

Line: 347


      If (l_tar_TASK_PART_rec.last_update_date <> l_ref_TASK_PART_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: 363


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

Line: 402


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

Line: 404


      CSP_TASK_PARTS_PKG.Update_Row(
          p_TASK_PART_ID  => p_TASK_PART_rec.TASK_PART_ID,
          p_PRODUCT_TASK_ID  => p_TASK_PART_rec.PRODUCT_TASK_ID,
          p_INVENTORY_ITEM_ID  => p_TASK_PART_rec.INVENTORY_ITEM_ID,
          p_MANUAL_QUANTITY  => p_TASK_PART_rec.MANUAL_QUANTITY,
          p_MANUAL_PERCENTAGE  => p_TASK_PART_rec.MANUAL_PERCENTAGE,
          p_QUANTITY_USED  => p_TASK_PART_rec.QUANTITY_USED,
          p_ACTUAL_TIMES_USED  => p_TASK_PART_rec.ACTUAL_TIMES_USED,
          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  => FND_GLOBAL.CONC_LOGIN_ID,
          p_ATTRIBUTE_CATEGORY  => p_TASK_PART_rec.ATTRIBUTE_CATEGORY,
          p_ATTRIBUTE1  => p_TASK_PART_rec.ATTRIBUTE1,
          p_ATTRIBUTE2  => p_TASK_PART_rec.ATTRIBUTE2,
          p_ATTRIBUTE3  => p_TASK_PART_rec.ATTRIBUTE3,
          p_ATTRIBUTE4  => p_TASK_PART_rec.ATTRIBUTE4,
          p_ATTRIBUTE5  => p_TASK_PART_rec.ATTRIBUTE5,
          p_ATTRIBUTE6  => p_TASK_PART_rec.ATTRIBUTE6,
          p_ATTRIBUTE7  => p_TASK_PART_rec.ATTRIBUTE7,
          p_ATTRIBUTE8  => p_TASK_PART_rec.ATTRIBUTE8,
          p_ATTRIBUTE9  => p_TASK_PART_rec.ATTRIBUTE9,
          p_ATTRIBUTE10  => p_TASK_PART_rec.ATTRIBUTE10,
          p_ATTRIBUTE11  => p_TASK_PART_rec.ATTRIBUTE11,
          p_ATTRIBUTE12  => p_TASK_PART_rec.ATTRIBUTE12,
          p_ATTRIBUTE13  => p_TASK_PART_rec.ATTRIBUTE13,
          p_ATTRIBUTE14  => p_TASK_PART_rec.ATTRIBUTE14,
          p_ATTRIBUTE15  => p_TASK_PART_rec.ATTRIBUTE15,
          p_PRIMARY_UOM_CODE  => p_TASK_PART_rec.PRIMARY_UOM_CODE,
          p_REVISION  => p_TASK_PART_rec.REVISION,
          p_START_DATE  => p_TASK_PART_rec.START_DATE,
          p_END_DATE  => p_TASK_PART_rec.END_DATE,
          p_ROLLUP_QUANTITY_USED  => p_TASK_PART_rec.ROLLUP_QUANTITY_USED,
          p_ROLLUP_TIMES_USED  => p_TASK_PART_rec.ROLLUP_TIMES_USED,
          p_SUBSTITUTE_ITEM => p_TASK_PART_rec.SUBSTITUTE_ITEM );

Line: 486


End Update_task_part;

Line: 489


PROCEDURE Delete_task_part(
    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_TASK_PART_Rec     IN TASK_PART_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_task_part';

Line: 505


      SAVEPOINT DELETE_TASK_PART_PVT;

Line: 556


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

Line: 558


      CSP_TASK_PARTS_PKG.Delete_Row(
          p_TASK_PART_ID  => p_TASK_PART_rec.TASK_PART_ID);

Line: 605


End Delete_task_part;

Line: 750


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

Line: 757


      x_select_cl := 'Select ' ||
                'CSP_TASK_PARTS.TASK_PART_ID,' ||
                'CSP_TASK_PARTS.PRODUCT_TASK_ID,' ||
                'CSP_TASK_PARTS.INVENTORY_ITEM_ID,' ||
                'CSP_TASK_PARTS.MANUAL_QUANTITY,' ||
                'CSP_TASK_PARTS.MANUAL_PERCENTAGE,' ||
                'CSP_TASK_PARTS.QUANTITY_USED,' ||
                'CSP_TASK_PARTS.ACTUAL_TIMES_USED,' ||
                'CSP_TASK_PARTS.CREATED_BY,' ||
                'CSP_TASK_PARTS.CREATION_DATE,' ||
                'CSP_TASK_PARTS.LAST_UPDATED_BY,' ||
                'CSP_TASK_PARTS.LAST_UPDATE_DATE,' ||
                'CSP_TASK_PARTS.LAST_UPDATE_LOGIN,' ||
                'CSP_TASK_PARTS.ATTRIBUTE_CATEGORY,' ||
                'CSP_TASK_PARTS.ATTRIBUTE1,' ||
                'CSP_TASK_PARTS.ATTRIBUTE2,' ||
                'CSP_TASK_PARTS.ATTRIBUTE3,' ||
                'CSP_TASK_PARTS.ATTRIBUTE4,' ||
                'CSP_TASK_PARTS.ATTRIBUTE5,' ||
                'CSP_TASK_PARTS.ATTRIBUTE6,' ||
                'CSP_TASK_PARTS.ATTRIBUTE7,' ||
                'CSP_TASK_PARTS.ATTRIBUTE8,' ||
                'CSP_TASK_PARTS.ATTRIBUTE9,' ||
                'CSP_TASK_PARTS.ATTRIBUTE10,' ||
                'CSP_TASK_PARTS.ATTRIBUTE11,' ||
                'CSP_TASK_PARTS.ATTRIBUTE12,' ||
                'CSP_TASK_PARTS.ATTRIBUTE13,' ||
                'CSP_TASK_PARTS.ATTRIBUTE14,' ||
                'CSP_TASK_PARTS.ATTRIBUTE15,' ||
                'CSP_TASK_PARTS.PRIMARY_UOM_CODE,' ||
                'CSP_TASK_PARTS.REVISION,' ||
                'CSP_TASK_PARTS.START_DATE,' ||
                'CSP_TASK_PARTS.END_DATE,' ||
                'from CSP_TASK_PARTS';

Line: 792


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

Line: 793


END Gen_Select;

Line: 802


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

Line: 805


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

Line: 920


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

Line: 965


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


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

Line: 1049


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

Line: 1088


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

Line: 1127


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

Line: 1166


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


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

Line: 1245


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

Line: 1284


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


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


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

Line: 1403


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


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