APPS.CSP_REQ_LINE_DETAILS_PVT SQL Statements

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

Line: 67

        CSP_req_line_details_PKG.Insert_Row(
          px_REQ_LINE_DETAIL_ID  => l_req_line_details_rec.req_line_detail_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_LINE_ID  => l_Req_Line_details_rec.REQUIREMENT_LINE_ID,
          p_SOURCE_TYPE  => l_Req_Line_details_rec.SOURCE_TYPE,
          p_SOURCE_ID  => l_Req_Line_details_rec.source_id
          );

Line: 140

PROCEDURE Update_req_line_details(
    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_Req_Line_Details_Tbl       IN   Req_Line_Details_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) := 'Update_req_line_details';

Line: 160

      SAVEPOINT UPDATE_Req_Line_Details_PUB;

Line: 191

        CSP_REQ_LINE_DETAILS_PKG.Update_Row(
          px_REQ_LINE_DETAIL_ID  => l_req_line_details_rec.REQ_LINE_DETAIL_ID,
          p_REQUIREMENT_LINE_ID  => l_req_line_details_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_SOURCE_TYPE  => l_req_line_details_rec.SOURCE_TYPE,
          p_SOURCE_ID  => l_req_line_details_rec.SOURCE_ID
          );

Line: 235

          Rollback to UPDATE_Req_Line_Details_PUB;

Line: 244

End Update_req_line_details;

Line: 249

PROCEDURE Delete_req_line_details(
    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_req_line_details_tbl       IN   Req_Line_Details_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_req_line_details';

Line: 266

      SAVEPOINT DELETE_Req_Line_Details_PUB;

Line: 296

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

Line: 302

        CSP_REQ_LINE_DETAILS_PKG.Delete_Row(
          px_REQ_LINE_DETAIL_ID  => l_req_line_details_rec.REQ_LINE_DETAIL_ID);

Line: 347

          Rollback to DELETE_Req_Line_Details_PUB;

Line: 356

End Delete_req_line_details;