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

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

Line: 107


        CSP_REQUIREMENT_LINES_PKG.Insert_Row(
          px_REQUIREMENT_LINE_ID  => l_requirement_line_rec.requirement_line_id,
          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_REQUIREMENT_HEADER_ID  => l_Requirement_Line_rec.REQUIREMENT_HEADER_ID,
          p_INVENTORY_ITEM_ID  => l_Requirement_Line_rec.INVENTORY_ITEM_ID,
          p_UOM_CODE  => l_Requirement_Line_rec.UOM_CODE,
          p_REQUIRED_QUANTITY  => l_Requirement_Line_rec.REQUIRED_QUANTITY,
          p_SHIP_COMPLETE_FLAG  => l_Requirement_Line_rec.SHIP_COMPLETE_FLAG,
          p_LIKELIHOOD  => l_Requirement_Line_rec.LIKELIHOOD,
          p_REVISION  => l_Requirement_Line_rec.REVISION,
          p_SOURCE_ORGANIZATION_ID  => l_Requirement_Line_rec.SOURCE_ORGANIZATION_ID,
          p_SOURCE_SUBINVENTORY  => l_Requirement_Line_rec.SOURCE_SUBINVENTORY,
          p_ORDERED_QUANTITY  => l_Requirement_Line_rec.ORDERED_QUANTITY,
          p_ORDER_LINE_ID  => l_Requirement_Line_rec.ORDER_LINE_ID,
          p_RESERVATION_ID  => l_Requirement_Line_rec.RESERVATION_ID,
          p_ORDER_BY_DATE  => l_Requirement_Line_rec.ORDER_BY_DATE,
          p_ATTRIBUTE_CATEGORY  => l_Requirement_Line_rec.ATTRIBUTE_CATEGORY,
          p_ATTRIBUTE1  => l_Requirement_Line_rec.ATTRIBUTE1,
          p_ATTRIBUTE2  => l_Requirement_Line_rec.ATTRIBUTE2,
          p_ATTRIBUTE3  => l_Requirement_Line_rec.ATTRIBUTE3,
          p_ATTRIBUTE4  => l_Requirement_Line_rec.ATTRIBUTE4,
          p_ATTRIBUTE5  => l_Requirement_Line_rec.ATTRIBUTE5,
          p_ATTRIBUTE6  => l_Requirement_Line_rec.ATTRIBUTE6,
          p_ATTRIBUTE7  => l_Requirement_Line_rec.ATTRIBUTE7,
          p_ATTRIBUTE8  => l_Requirement_Line_rec.ATTRIBUTE8,
          p_ATTRIBUTE9  => l_Requirement_Line_rec.ATTRIBUTE9,
          p_ATTRIBUTE10  => l_Requirement_Line_rec.ATTRIBUTE10,
          p_ATTRIBUTE11  => l_Requirement_Line_rec.ATTRIBUTE11,
          p_ATTRIBUTE12  => l_Requirement_Line_rec.ATTRIBUTE12,
          p_ATTRIBUTE13  => l_Requirement_Line_rec.ATTRIBUTE13,
          p_ATTRIBUTE14  => l_Requirement_Line_rec.ATTRIBUTE14,
          p_ATTRIBUTE15  => l_Requirement_Line_rec.ATTRIBUTE15,
          p_ARRIVAL_DATE => l_Requirement_line_rec.ARRIVAL_DATE,
          p_ITEM_SCRATCHPAD => l_requirement_line_rec.item_scratchpad,
          p_SHIPPING_METHOD_CODE => l_requirement_line_rec.shipping_method_code,
          p_LOCAL_RESERVATION_ID => l_requirement_line_rec.LOCAL_RESERVATION_ID,
          p_SOURCED_FROM => l_requirement_line_rec.SOURCED_FROM
          );

Line: 211


PROCEDURE Update_requirement_lines(
    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_Requirement_Line_Tbl       IN   Requirement_Line_Tbl_Type,
    X_Return_Status              OUT NOCOPY  VARCHAR2,
    X_Msg_Count                  OUT NOCOPY  NUMBER,
    X_Msg_Data                   OUT NOCOPY  VARCHAR2
    )

 IS
/*
Cursor C_Get_requirement_lines(REQUIREMENT_LINE_ID Number) IS
    Select rowid,
           REQUIREMENT_LINE_ID,
           CREATED_BY,
           CREATION_DATE,
           LAST_UPDATED_BY,
           LAST_UPDATE_DATE,
           LAST_UPDATE_LOGIN,
           REQUIREMENT_HEADER_ID,
           INVENTORY_ITEM_ID,
           UOM_CODE,
           REQUIRED_QUANTITY,
           SHIP_COMPLETE_FLAG,
           LIKELIHOOD,
           REVISION,
           SOURCE_ORGANIZATION_ID,
           SOURCE_SUBINVENTORY,
           ORDERED_QUANTITY,
           ORDER_LINE_ID,
           RESERVATION_ID,
           ORDER_BY_DATE,
           ATTRIBUTE_CATEGORY,
           ATTRIBUTE1,
           ATTRIBUTE2,
           ATTRIBUTE3,
           ATTRIBUTE4,
           ATTRIBUTE5,
           ATTRIBUTE6,
           ATTRIBUTE7,
           ATTRIBUTE8,
           ATTRIBUTE9,
           ATTRIBUTE10,
           ATTRIBUTE11,
           ATTRIBUTE12,
           ATTRIBUTE13,
           ATTRIBUTE14,
           ATTRIBUTE15,
    From  CSP_REQUIREMENT_LINES
    -- Hint: Developer need to provide Where clause
    For Update NOWAIT;

Line: 265


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

Line: 273


      SAVEPOINT UPDATE_Requirement_Lines_PUB;

Line: 310


               l_ref_Requirement_Lines_rec.LAST_UPDATED_BY,
               l_ref_Requirement_Lines_rec.LAST_UPDATE_DATE,
               l_ref_Requirement_Lines_rec.LAST_UPDATE_LOGIN,
               l_ref_Requirement_Lines_rec.REQUIREMENT_HEADER_ID,
               l_ref_Requirement_Lines_rec.INVENTORY_ITEM_ID,
               l_ref_Requirement_Lines_rec.UOM_CODE,
               l_ref_Requirement_Lines_rec.REQUIRED_QUANTITY,
               l_ref_Requirement_Lines_rec.SHIP_COMPLETE_FLAG,
               l_ref_Requirement_Lines_rec.LIKELIHOOD,
               l_ref_Requirement_Lines_rec.REVISION,
               l_ref_Requirement_Lines_rec.SOURCE_ORGANIZATION_ID,
               l_ref_Requirement_Lines_rec.SOURCE_SUBINVENTORY,
               l_ref_Requirement_Lines_rec.ORDERED_QUANTITY,
               l_ref_Requirement_Lines_rec.ORDER_LINE_ID,
               l_ref_Requirement_Lines_rec.RESERVATION_ID,
               l_ref_Requirement_Lines_rec.ORDER_BY_DATE,
               l_ref_Requirement_Lines_rec.ATTRIBUTE_CATEGORY,
               l_ref_Requirement_Lines_rec.ATTRIBUTE1,
               l_ref_Requirement_Lines_rec.ATTRIBUTE2,
               l_ref_Requirement_Lines_rec.ATTRIBUTE3,
               l_ref_Requirement_Lines_rec.ATTRIBUTE4,
               l_ref_Requirement_Lines_rec.ATTRIBUTE5,
               l_ref_Requirement_Lines_rec.ATTRIBUTE6,
               l_ref_Requirement_Lines_rec.ATTRIBUTE7,
               l_ref_Requirement_Lines_rec.ATTRIBUTE8,
               l_ref_Requirement_Lines_rec.ATTRIBUTE9,
               l_ref_Requirement_Lines_rec.ATTRIBUTE10,
               l_ref_Requirement_Lines_rec.ATTRIBUTE11,
               l_ref_Requirement_Lines_rec.ATTRIBUTE12,
               l_ref_Requirement_Lines_rec.ATTRIBUTE13,
               l_ref_Requirement_Lines_rec.ATTRIBUTE14,
               l_ref_Requirement_Lines_rec.ATTRIBUTE15,

       If ( C_Get_requirement_lines%NOTFOUND) Then
           IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
           THEN
               FND_MESSAGE.Set_Name('CSP', 'API_MISSING_UPDATE_TARGET');

Line: 359


      If (l_tar_Requirement_Lines_rec.last_update_date is NULL or
          l_tar_Requirement_Lines_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: 364


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

Line: 370


      If (l_tar_Requirement_Lines_rec.last_update_date <> l_ref_Requirement_Lines_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: 387


          p_validation_mode  => AS_UTILITY_PVT.G_UPDATE,
          p_requirement_line_rec  =>  p_requirement_line_rec,
          x_return_status    => x_return_status,
          x_msg_count        => x_msg_count,
          x_msg_data         => x_msg_data);

Line: 438


        CSP_REQUIREMENT_LINES_PKG.Update_Row(
          p_REQUIREMENT_LINE_ID  => l_requirement_line_rec.REQUIREMENT_LINE_ID,
          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_REQUIREMENT_HEADER_ID  => l_requirement_line_rec.REQUIREMENT_HEADER_ID,
          p_INVENTORY_ITEM_ID  => l_requirement_line_rec.INVENTORY_ITEM_ID,
          p_UOM_CODE  => l_requirement_line_rec.UOM_CODE,
          p_REQUIRED_QUANTITY  => l_requirement_line_rec.REQUIRED_QUANTITY,
          p_SHIP_COMPLETE_FLAG  => l_requirement_line_rec.SHIP_COMPLETE_FLAG,
          p_LIKELIHOOD  => l_requirement_line_rec.LIKELIHOOD,
          p_REVISION  => l_requirement_line_rec.REVISION,
          p_SOURCE_ORGANIZATION_ID  => l_requirement_line_rec.SOURCE_ORGANIZATION_ID,
          p_SOURCE_SUBINVENTORY  => l_requirement_line_rec.SOURCE_SUBINVENTORY,
          p_ORDERED_QUANTITY  => l_requirement_line_rec.ORDERED_QUANTITY,
          p_ORDER_LINE_ID  => l_requirement_line_rec.ORDER_LINE_ID,
          p_RESERVATION_ID  => l_requirement_line_rec.RESERVATION_ID,
          p_ORDER_BY_DATE  => l_requirement_line_rec.ORDER_BY_DATE,
          p_ATTRIBUTE_CATEGORY  => l_requirement_line_rec.ATTRIBUTE_CATEGORY,
          p_ATTRIBUTE1  => l_requirement_line_rec.ATTRIBUTE1,
          p_ATTRIBUTE2  => l_requirement_line_rec.ATTRIBUTE2,
          p_ATTRIBUTE3  => l_requirement_line_rec.ATTRIBUTE3,
          p_ATTRIBUTE4  => l_requirement_line_rec.ATTRIBUTE4,
          p_ATTRIBUTE5  => l_requirement_line_rec.ATTRIBUTE5,
          p_ATTRIBUTE6  => l_requirement_line_rec.ATTRIBUTE6,
          p_ATTRIBUTE7  => l_requirement_line_rec.ATTRIBUTE7,
          p_ATTRIBUTE8  => l_requirement_line_rec.ATTRIBUTE8,
          p_ATTRIBUTE9  => l_requirement_line_rec.ATTRIBUTE9,
          p_ATTRIBUTE10  => l_requirement_line_rec.ATTRIBUTE10,
          p_ATTRIBUTE11  => l_requirement_line_rec.ATTRIBUTE11,
          p_ATTRIBUTE12  => l_requirement_line_rec.ATTRIBUTE12,
          p_ATTRIBUTE13  => l_requirement_line_rec.ATTRIBUTE13,
          p_ATTRIBUTE14  => l_requirement_line_rec.ATTRIBUTE14,
          p_ATTRIBUTE15  => l_requirement_line_rec.ATTRIBUTE15,
          p_ARRIVAL_DATE => l_requirement_line_rec.arrival_date,
          p_ITEM_SCRATCHPAD => l_requirement_line_rec.item_scratchpad,
          p_SHIPPING_METHOD_CODE => l_requirement_line_rec.shipping_method_code,
          p_LOCAL_RESERVATION_ID => l_requirement_line_rec.LOCAL_RESERVATION_ID,
          p_SOURCED_FROM => l_requirement_line_rec.SOURCED_FROM
          );

Line: 523


          Rollback to UPDATE_Requirement_Lines_PUB;

Line: 532


End Update_requirement_lines;

Line: 537


PROCEDURE Delete_requirement_lines(
    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_requirement_line_tbl       IN   Requirement_Line_Tbl_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_requirement_lines';

Line: 554


      SAVEPOINT DELETE_Requirement_Lines_PUB;

Line: 584


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

Line: 590


        CSP_REQUIREMENT_LINES_PKG.Delete_Row(
          p_REQUIREMENT_LINE_ID  => l_requirement_line_rec.REQUIREMENT_LINE_ID);

Line: 635


          Rollback to DELETE_Requirement_Lines_PUB;

Line: 644


End Delete_requirement_lines;

Line: 805


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

Line: 813


      x_select_cl := 'Select ' ||
                'CSP_REQUIREMENT_LINES.REQUIREMENT_LINE_ID,' ||
                'CSP_REQUIREMENT_LINES.CREATED_BY,' ||
                'CSP_REQUIREMENT_LINES.CREATION_DATE,' ||
                'CSP_REQUIREMENT_LINES.LAST_UPDATED_BY,' ||
                'CSP_REQUIREMENT_LINES.LAST_UPDATE_DATE,' ||
                'CSP_REQUIREMENT_LINES.LAST_UPDATE_LOGIN,' ||
                'CSP_REQUIREMENT_LINES.REQUIREMENT_HEADER_ID,' ||
                'CSP_REQUIREMENT_LINES.INVENTORY_ITEM_ID,' ||
                'CSP_REQUIREMENT_LINES.UOM_CODE,' ||
                'CSP_REQUIREMENT_LINES.REQUIRED_QUANTITY,' ||
                'CSP_REQUIREMENT_LINES.SHIP_COMPLETE_FLAG,' ||
                'CSP_REQUIREMENT_LINES.LIKELIHOOD,' ||
                'CSP_REQUIREMENT_LINES.REVISION,' ||
                'CSP_REQUIREMENT_LINES.SOURCE_ORGANIZATION_ID,' ||
                'CSP_REQUIREMENT_LINES.SOURCE_SUBINVENTORY,' ||
                'CSP_REQUIREMENT_LINES.ORDERED_QUANTITY,' ||
                'CSP_REQUIREMENT_LINES.ORDER_LINE_ID,' ||
                'CSP_REQUIREMENT_LINES.RESERVATION_ID,' ||
                'CSP_REQUIREMENT_LINES.ORDER_BY_DATE,' ||
                'CSP_REQUIREMENT_LINES.ATTRIBUTE_CATEGORY,' ||
                'CSP_REQUIREMENT_LINES.ATTRIBUTE1,' ||
                'CSP_REQUIREMENT_LINES.ATTRIBUTE2,' ||
                'CSP_REQUIREMENT_LINES.ATTRIBUTE3,' ||
                'CSP_REQUIREMENT_LINES.ATTRIBUTE4,' ||
                'CSP_REQUIREMENT_LINES.ATTRIBUTE5,' ||
                'CSP_REQUIREMENT_LINES.ATTRIBUTE6,' ||
                'CSP_REQUIREMENT_LINES.ATTRIBUTE7,' ||
                'CSP_REQUIREMENT_LINES.ATTRIBUTE8,' ||
                'CSP_REQUIREMENT_LINES.ATTRIBUTE9,' ||
                'CSP_REQUIREMENT_LINES.ATTRIBUTE10,' ||
                'CSP_REQUIREMENT_LINES.ATTRIBUTE11,' ||
                'CSP_REQUIREMENT_LINES.ATTRIBUTE12,' ||
                'CSP_REQUIREMENT_LINES.ATTRIBUTE13,' ||
                'CSP_REQUIREMENT_LINES.ATTRIBUTE14,' ||
                'CSP_REQUIREMENT_LINES.ATTRIBUTE15,' ||
                'from CSP_REQUIREMENT_LINES';

Line: 851


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

Line: 853


END Gen_Select;

Line: 863


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

Line: 866


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

Line: 1002


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

Line: 1056


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

Line: 1110


      ELSIF(p_validation_mode = AS_UTILITY_PVT.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: 1164


      ELSIF(p_validation_mode = AS_UTILITY_PVT.G_UPDATE)
      THEN
          -- Hint: Validate data
          -- IF p_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: 1218


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

Line: 1265


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

Line: 1312


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

Line: 1359


      ELSIF(p_validation_mode = AS_UTILITY_PVT.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: 1406


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

Line: 1453


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

Line: 1500


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

Line: 1547


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

Line: 1594


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

Line: 1641


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