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

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

Line: 117


      CSP_REQUIREMENT_HEADERS_PKG.Insert_Row(
          px_REQUIREMENT_HEADER_ID  => x_REQUIREMENT_HEADER_ID,
          p_CREATED_BY  => nvl(FND_GLOBAL.USER_ID, 1),
          p_CREATION_DATE  => SYSDATE,
          p_LAST_UPDATED_BY  => nvl(FND_GLOBAL.USER_ID, 1),
          p_LAST_UPDATE_DATE  => SYSDATE,
          p_LAST_UPDATE_LOGIN  => nvl(FND_GLOBAL.CONC_LOGIN_ID, -1),
          p_OPEN_REQUIREMENT  => p_REQUIREMENT_HEADER_rec.OPEN_REQUIREMENT,
          p_SHIP_TO_LOCATION_ID  => p_REQUIREMENT_HEADER_rec.SHIP_TO_LOCATION_ID,
          p_TASK_ID  => p_REQUIREMENT_HEADER_rec.TASK_ID,
          p_TASK_ASSIGNMENT_ID  => p_REQUIREMENT_HEADER_rec.TASK_ASSIGNMENT_ID,
          p_SHIPPING_METHOD_CODE  => p_REQUIREMENT_HEADER_rec.SHIPPING_METHOD_CODE,
          p_NEED_BY_DATE  => p_REQUIREMENT_HEADER_rec.NEED_BY_DATE,
          p_DESTINATION_ORGANIZATION_ID  => p_REQUIREMENT_HEADER_rec.DESTINATION_ORGANIZATION_ID,
          p_PARTS_DEFINED  => p_REQUIREMENT_HEADER_rec.PARTS_DEFINED,
          p_ATTRIBUTE_CATEGORY  => p_REQUIREMENT_HEADER_rec.ATTRIBUTE_CATEGORY,
          p_ATTRIBUTE1  => p_REQUIREMENT_HEADER_rec.ATTRIBUTE1,
          p_ATTRIBUTE2  => p_REQUIREMENT_HEADER_rec.ATTRIBUTE2,
          p_ATTRIBUTE3  => p_REQUIREMENT_HEADER_rec.ATTRIBUTE3,
          p_ATTRIBUTE4  => p_REQUIREMENT_HEADER_rec.ATTRIBUTE4,
          p_ATTRIBUTE5  => p_REQUIREMENT_HEADER_rec.ATTRIBUTE5,
          p_ATTRIBUTE6  => p_REQUIREMENT_HEADER_rec.ATTRIBUTE6,
          p_ATTRIBUTE7  => p_REQUIREMENT_HEADER_rec.ATTRIBUTE7,
          p_ATTRIBUTE8  => p_REQUIREMENT_HEADER_rec.ATTRIBUTE8,
          p_ATTRIBUTE9  => p_REQUIREMENT_HEADER_rec.ATTRIBUTE9,
          p_ATTRIBUTE10  => p_REQUIREMENT_HEADER_rec.ATTRIBUTE10,
          p_ATTRIBUTE11  => p_REQUIREMENT_HEADER_rec.ATTRIBUTE11,
          p_ATTRIBUTE12  => p_REQUIREMENT_HEADER_rec.ATTRIBUTE12,
          p_ATTRIBUTE13  => p_REQUIREMENT_HEADER_rec.ATTRIBUTE13,
          p_ATTRIBUTE14  => p_REQUIREMENT_HEADER_rec.ATTRIBUTE14,
          p_ATTRIBUTE15  => p_REQUIREMENT_HEADER_rec.ATTRIBUTE15,
          p_ORDER_TYPE_ID => p_REQUIREMENT_HEADER_rec.ORDER_TYPE_ID,
          p_ADDRESS_TYPE => p_REQUIREMENT_HEADER_rec.ADDRESS_TYPE,
          p_RESOURCE_ID => p_REQUIREMENT_HEADER_rec.RESOURCE_ID,
          p_RESOURCE_TYPE => p_REQUIREMENT_HEADER_rec.RESOURCE_TYPE,
          p_TIMEZONE_ID => p_REQUIREMENT_HEADER_rec.TIMEZONE_ID,
          p_DESTINATION_SUBINVENTORY => p_REQUIREMENT_HEADER_rec.DESTINATION_SUBINVENTORY
        );

Line: 217


PROCEDURE Update_requirement_headers(
    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_HEADER_Rec     IN    REQUIREMENT_HEADER_Rec_Type,
    X_Return_Status              OUT NOCOPY  VARCHAR2,
    X_Msg_Count                  OUT NOCOPY  NUMBER,
    X_Msg_Data                   OUT NOCOPY  VARCHAR2
    )

 IS
/*
Cursor C_Get_requirement_headers(REQUIREMENT_HEADER_ID Number) IS
    Select rowid,
           REQUIREMENT_HEADER_ID,
           CREATED_BY,
           CREATION_DATE,
           LAST_UPDATED_BY,
           LAST_UPDATE_DATE,
           LAST_UPDATE_LOGIN,
           OPEN_REQUIREMENT,
           SHIP_TO_LOCATION_ID,
           TASK_ID,
           TASK_ASSIGNMENT_ID,
           SHIPPING_METHOD_CODE,
           NEED_BY_DATE,
           DESTINATION_ORGANIZATION_ID,
           PARTS_DEFINED,
           ATTRIBUTE_CATEGORY,
           ATTRIBUTE1,
           ATTRIBUTE2,
           ATTRIBUTE3,
           ATTRIBUTE4,
           ATTRIBUTE5,
           ATTRIBUTE6,
           ATTRIBUTE7,
           ATTRIBUTE8,
           ATTRIBUTE9,
           ATTRIBUTE10,
           ATTRIBUTE11,
           ATTRIBUTE12,
           ATTRIBUTE13,
           ATTRIBUTE14,
           ATTRIBUTE15,
    From  CSP_REQUIREMENT_HEADERS
    -- Hint: Developer need to provide Where clause
    For Update NOWAIT;

Line: 266


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

Line: 274


      SAVEPOINT UPDATE_Requirement_headers_PUB;

Line: 334


               l_ref_REQUIREMENT_HEADER_rec.LAST_UPDATED_BY,
               l_ref_REQUIREMENT_HEADER_rec.LAST_UPDATE_DATE,
               l_ref_REQUIREMENT_HEADER_rec.LAST_UPDATE_LOGIN,
               l_ref_REQUIREMENT_HEADER_rec.OPEN_REQUIREMENT,
               l_ref_REQUIREMENT_HEADER_rec.SHIP_TO_LOCATION_ID,
               l_ref_REQUIREMENT_HEADER_rec.TASK_ID,
               l_ref_REQUIREMENT_HEADER_rec.TASK_ASSIGNMENT_ID,
               l_ref_REQUIREMENT_HEADER_rec.SHIPPING_METHOD_CODE,
               l_ref_REQUIREMENT_HEADER_rec.NEED_BY_DATE,
               l_ref_REQUIREMENT_HEADER_rec.DESTINATION_ORGANIZATION_ID,
               l_ref_REQUIREMENT_HEADER_rec.PARTS_DEFINED,
               l_ref_REQUIREMENT_HEADER_rec.ATTRIBUTE_CATEGORY,
               l_ref_REQUIREMENT_HEADER_rec.ATTRIBUTE1,
               l_ref_REQUIREMENT_HEADER_rec.ATTRIBUTE2,
               l_ref_REQUIREMENT_HEADER_rec.ATTRIBUTE3,
               l_ref_REQUIREMENT_HEADER_rec.ATTRIBUTE4,
               l_ref_REQUIREMENT_HEADER_rec.ATTRIBUTE5,
               l_ref_REQUIREMENT_HEADER_rec.ATTRIBUTE6,
               l_ref_REQUIREMENT_HEADER_rec.ATTRIBUTE7,
               l_ref_REQUIREMENT_HEADER_rec.ATTRIBUTE8,
               l_ref_REQUIREMENT_HEADER_rec.ATTRIBUTE9,
               l_ref_REQUIREMENT_HEADER_rec.ATTRIBUTE10,
               l_ref_REQUIREMENT_HEADER_rec.ATTRIBUTE11,
               l_ref_REQUIREMENT_HEADER_rec.ATTRIBUTE12,
               l_ref_REQUIREMENT_HEADER_rec.ATTRIBUTE13,
               l_ref_REQUIREMENT_HEADER_rec.ATTRIBUTE14,
               l_ref_REQUIREMENT_HEADER_rec.ATTRIBUTE15,

       If ( C_Get_requirement_headers%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: 378


  /*    If (l_tar_REQUIREMENT_HEADER_rec.last_update_date is NULL or
          l_tar_REQUIREMENT_HEADER_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: 383


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

Line: 389


      If (l_tar_REQUIREMENT_HEADER_rec.last_update_date <> l_ref_REQUIREMENT_HEADER_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: 406


          p_validation_mode  => JTF_UTILITY_PVT.G_UPDATE,
          P_REQUIREMENT_HEADER_Rec  =>  P_REQUIREMENT_HEADER_Rec,
          x_return_status    => x_return_status,
          x_msg_count        => x_msg_count,
          x_msg_data         => x_msg_data);

Line: 425


      CSP_REQUIREMENT_HEADERS_PKG.Update_Row(
          p_REQUIREMENT_HEADER_ID  => p_REQUIREMENT_HEADER_rec.REQUIREMENT_HEADER_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_OPEN_REQUIREMENT  => p_REQUIREMENT_HEADER_rec.OPEN_REQUIREMENT,
          p_SHIP_TO_LOCATION_ID  => p_REQUIREMENT_HEADER_rec.SHIP_TO_LOCATION_ID,
          p_TASK_ID  => p_REQUIREMENT_HEADER_rec.TASK_ID,
          p_TASK_ASSIGNMENT_ID  => p_REQUIREMENT_HEADER_rec.TASK_ASSIGNMENT_ID,
          p_SHIPPING_METHOD_CODE  => p_REQUIREMENT_HEADER_rec.SHIPPING_METHOD_CODE,
          p_NEED_BY_DATE  => p_REQUIREMENT_HEADER_rec.NEED_BY_DATE,
          p_DESTINATION_ORGANIZATION_ID  => p_REQUIREMENT_HEADER_rec.DESTINATION_ORGANIZATION_ID,
          p_PARTS_DEFINED  => p_REQUIREMENT_HEADER_rec.PARTS_DEFINED,
          p_ATTRIBUTE_CATEGORY  => p_REQUIREMENT_HEADER_rec.ATTRIBUTE_CATEGORY,
          p_ATTRIBUTE1  => p_REQUIREMENT_HEADER_rec.ATTRIBUTE1,
          p_ATTRIBUTE2  => p_REQUIREMENT_HEADER_rec.ATTRIBUTE2,
          p_ATTRIBUTE3  => p_REQUIREMENT_HEADER_rec.ATTRIBUTE3,
          p_ATTRIBUTE4  => p_REQUIREMENT_HEADER_rec.ATTRIBUTE4,
          p_ATTRIBUTE5  => p_REQUIREMENT_HEADER_rec.ATTRIBUTE5,
          p_ATTRIBUTE6  => p_REQUIREMENT_HEADER_rec.ATTRIBUTE6,
          p_ATTRIBUTE7  => p_REQUIREMENT_HEADER_rec.ATTRIBUTE7,
          p_ATTRIBUTE8  => p_REQUIREMENT_HEADER_rec.ATTRIBUTE8,
          p_ATTRIBUTE9  => p_REQUIREMENT_HEADER_rec.ATTRIBUTE9,
          p_ATTRIBUTE10  => p_REQUIREMENT_HEADER_rec.ATTRIBUTE10,
          p_ATTRIBUTE11  => p_REQUIREMENT_HEADER_rec.ATTRIBUTE11,
          p_ATTRIBUTE12  => p_REQUIREMENT_HEADER_rec.ATTRIBUTE12,
          p_ATTRIBUTE13  => p_REQUIREMENT_HEADER_rec.ATTRIBUTE13,
          p_ATTRIBUTE14  => p_REQUIREMENT_HEADER_rec.ATTRIBUTE14,
          p_ATTRIBUTE15  => p_REQUIREMENT_HEADER_rec.ATTRIBUTE15,
          p_ORDER_TYPE_ID => p_REQUIREMENT_HEADER_rec.ORDER_TYPE_ID,
          p_ADDRESS_TYPE  => p_REQUIREMENT_HEADER_rec.ADDRESS_TYPE,
          p_RESOURCE_ID => p_REQUIREMENT_HEADER_rec.RESOURCE_ID,
          p_RESOURCE_TYPE => p_REQUIREMENT_HEADER_rec.RESOURCE_TYPE,
          p_TIMEZONE_ID => p_REQUIREMENT_HEADER_rec.TIMEZONE_ID,
          p_DESTINATION_SUBINVENTORY => p_REQUIREMENT_HEADER_rec.DESTINATION_SUBINVENTORY
          );

Line: 504


          Rollback to UPDATE_Requirement_headers_PUB;

Line: 513


End Update_requirement_headers;

Line: 518


PROCEDURE Delete_requirement_headers(
    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_HEADER_Rec     IN REQUIREMENT_HEADER_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_requirement_headers';

Line: 534


      SAVEPOINT DELETE_Requirement_headers_PUB;

Line: 572


      CSP_REQUIREMENT_HEADERS_PKG.Delete_Row(
          p_REQUIREMENT_HEADER_ID  => p_REQUIREMENT_HEADER_rec.REQUIREMENT_HEADER_ID);

Line: 615


          Rollback to DELETE_Requirement_headers_PUB;

Line: 624


End Delete_requirement_headers;

Line: 733


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

Line: 741


      x_select_cl := 'Select ' ||
                'CSP_REQUIREMENT_HEADERS.REQUIREMENT_HEADER_ID,' ||
                'CSP_REQUIREMENT_HEADERS.CREATED_BY,' ||
                'CSP_REQUIREMENT_HEADERS.CREATION_DATE,' ||
                'CSP_REQUIREMENT_HEADERS.LAST_UPDATED_BY,' ||
                'CSP_REQUIREMENT_HEADERS.LAST_UPDATE_DATE,' ||
                'CSP_REQUIREMENT_HEADERS.LAST_UPDATE_LOGIN,' ||
                'CSP_REQUIREMENT_HEADERS.OPEN_REQUIREMENT,' ||
                'CSP_REQUIREMENT_HEADERS.SHIP_TO_LOCATION_ID,' ||
                'CSP_REQUIREMENT_HEADERS.TASK_ID,' ||
                'CSP_REQUIREMENT_HEADERS.TASK_ASSIGNMENT_ID,' ||
                'CSP_REQUIREMENT_HEADERS.SHIPPING_METHOD_CODE,' ||
                'CSP_REQUIREMENT_HEADERS.NEED_BY_DATE,' ||
                'CSP_REQUIREMENT_HEADERS.DESTINATION_ORGANIZATION_ID,' ||
                'CSP_REQUIREMENT_HEADERS.PARTS_DEFINED,' ||
                'CSP_REQUIREMENT_HEADERS.ATTRIBUTE_CATEGORY,' ||
                'CSP_REQUIREMENT_HEADERS.ATTRIBUTE1,' ||
                'CSP_REQUIREMENT_HEADERS.ATTRIBUTE2,' ||
                'CSP_REQUIREMENT_HEADERS.ATTRIBUTE3,' ||
                'CSP_REQUIREMENT_HEADERS.ATTRIBUTE4,' ||
                'CSP_REQUIREMENT_HEADERS.ATTRIBUTE5,' ||
                'CSP_REQUIREMENT_HEADERS.ATTRIBUTE6,' ||
                'CSP_REQUIREMENT_HEADERS.ATTRIBUTE7,' ||
                'CSP_REQUIREMENT_HEADERS.ATTRIBUTE8,' ||
                'CSP_REQUIREMENT_HEADERS.ATTRIBUTE9,' ||
                'CSP_REQUIREMENT_HEADERS.ATTRIBUTE10,' ||
                'CSP_REQUIREMENT_HEADERS.ATTRIBUTE11,' ||
                'CSP_REQUIREMENT_HEADERS.ATTRIBUTE12,' ||
                'CSP_REQUIREMENT_HEADERS.ATTRIBUTE13,' ||
                'CSP_REQUIREMENT_HEADERS.ATTRIBUTE14,' ||
                'CSP_REQUIREMENT_HEADERS.ATTRIBUTE15,' ||
                'from CSP_REQUIREMENT_HEADERS';

Line: 774


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

Line: 776


END Gen_Select;

Line: 786


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

Line: 789


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

Line: 925


      ELSIF(p_validation_mode = JTF_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: 972


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

Line: 1019


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

Line: 1066


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


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

Line: 1160


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

Line: 1207


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

Line: 1254


      ELSIF(p_validation_mode = JTF_UTILITY_PVT.G_UPDATE)
      THEN
          -- Hint: Validate data
          -- IF p_DESTINATION_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: 1301


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