APPS.CSP_REQ_LINE_DETAILS_PKG SQL Statements

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

Line: 13

PROCEDURE Insert_Row(
          px_REQ_LINE_DETAIL_ID   IN OUT NOCOPY NUMBER,
          p_REQUIREMENT_LINE_ID   NUMBER,
          p_CREATED_BY    NUMBER,
          p_CREATION_DATE    DATE,
          p_LAST_UPDATED_BY    NUMBER,
          p_LAST_UPDATE_DATE    DATE,
          p_LAST_UPDATE_LOGIN    NUMBER,
          p_SOURCE_TYPE VARCHAR2,
          p_SOURCE_ID NUMBER)
 IS
   CURSOR C2 IS SELECT CSP_REQ_LINE_DETAILS_S1.nextval FROM sys.dual;

Line: 29

   l_api_name_full    varchar2(50) := 'CSP_REQ_LINE_DETAILS_PKG.INSERT_ROW';

Line: 38

          l_req_line_details.LAST_UPDATED_BY     :=p_LAST_UPDATED_BY;

Line: 39

          l_req_line_details.LAST_UPDATE_DATE    :=p_LAST_UPDATE_DATE;

Line: 40

          l_req_line_details.LAST_UPDATE_LOGIN   :=p_LAST_UPDATE_LOGIN ;

Line: 65

   INSERT INTO CSP_REQ_LINE_DETAILS(
           REQ_LINE_DETAIL_ID,
           REQUIREMENT_LINE_ID,
           CREATED_BY,
           CREATION_DATE,
           LAST_UPDATED_BY,
           LAST_UPDATE_DATE,
           LAST_UPDATE_LOGIN,
           SOURCE_TYPE,
           SOURCE_ID
           )
   VALUES (
           px_REQ_LINE_DETAIL_ID,
           decode( l_req_line_details.REQUIREMENT_LINE_ID, FND_API.G_MISS_NUM, NULL, l_req_line_details.REQUIREMENT_LINE_ID),
           decode( l_req_line_details.CREATED_BY, FND_API.G_MISS_NUM, NULL, l_req_line_details.CREATED_BY),
           decode( l_req_line_details.CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), l_req_line_details.CREATION_DATE),
           decode( l_req_line_details.LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, l_req_line_details.LAST_UPDATED_BY),
           decode( l_req_line_details.LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), l_req_line_details.LAST_UPDATE_DATE),
           decode( l_req_line_details.LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, l_req_line_details.LAST_UPDATE_LOGIN),
           decode( l_req_line_details.SOURCE_TYPE, FND_API.G_MISS_CHAR, NULL, l_req_line_details.SOURCE_TYPE),
           decode( l_req_line_details.SOURCE_ID, FND_API.G_MISS_NUM, NULL, l_req_line_details.SOURCE_ID)
            );

Line: 100

End Insert_Row;

Line: 102

PROCEDURE Update_Row(
          px_REQ_LINE_DETAIL_ID   IN OUT NOCOPY NUMBER,
          p_REQUIREMENT_LINE_ID   NUMBER,
          p_CREATED_BY    NUMBER,
          p_CREATION_DATE    DATE,
          p_LAST_UPDATED_BY    NUMBER,
          p_LAST_UPDATE_DATE    DATE,
          p_LAST_UPDATE_LOGIN    NUMBER,
          p_SOURCE_TYPE VARCHAR2,
          p_SOURCE_ID NUMBER)
 IS
  l_req_line_details CSP_REQ_line_details_PVT.Req_LINE_Details_Rec_Type;

Line: 114

  l_api_name_full    varchar2(50) := 'CSP_REQ_LINE_DETAILS_PKG.UPDATE_ROW';

Line: 123

          l_req_line_details.LAST_UPDATED_BY     :=p_LAST_UPDATED_BY;

Line: 124

          l_req_line_details.LAST_UPDATE_DATE    :=p_LAST_UPDATE_DATE;

Line: 125

          l_req_line_details.LAST_UPDATE_LOGIN   :=p_LAST_UPDATE_LOGIN ;

Line: 130

            csp_req_line_details_iuhk.Update_req_line_detail_Pre
                ( x_return_status          => l_return_status
                ) ;

Line: 142

    Update CSP_REQ_LINE_DETAILS
    SET
              REQUIREMENT_LINE_ID = decode( l_req_line_details.REQUIREMENT_LINE_ID, FND_API.G_MISS_NUM, REQUIREMENT_LINE_ID, l_req_line_details.REQUIREMENT_LINE_ID),
              CREATED_BY = decode( l_req_line_details.CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, l_req_line_details.CREATED_BY),
              CREATION_DATE = decode( l_req_line_details.CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, l_req_line_details.CREATION_DATE),
              LAST_UPDATED_BY = decode( l_req_line_details.LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, l_req_line_details.LAST_UPDATED_BY),
              LAST_UPDATE_DATE = decode( l_req_line_details.LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, l_req_line_details.LAST_UPDATE_DATE),
              LAST_UPDATE_LOGIN = decode( l_req_line_details.LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, l_req_line_details.LAST_UPDATE_LOGIN),
              SOURCE_TYPE = decode( l_req_line_details.SOURCE_TYPE, FND_API.G_MISS_CHAR, SOURCE_TYPE, l_req_line_details.SOURCE_TYPE),
              SOURCE_ID = decode( l_req_line_details.SOURCE_ID, FND_API.G_MISS_NUM, SOURCE_ID, l_req_line_details.SOURCE_ID)
    where REQ_LINE_DETAIL_ID = l_req_line_details.REQ_LINE_DETAIL_ID;

Line: 154

             csp_req_line_details_iuhk.Update_req_line_detail_post
                ( x_return_status          => l_return_status
                ) ;

Line: 169

END Update_Row;

Line: 171

PROCEDURE Delete_Row(
    px_REQ_LINE_DETAIL_ID  NUMBER)
 IS
   l_return_status    varchar2(100);

Line: 177

   l_api_name_full    varchar2(50) := 'CSP_REQ_LINE_DETAILS_PKG.DELETE_ROW';

Line: 181

            csp_req_line_details_iuhk.delete_req_line_detail_Pre
                ( x_return_status          => l_return_status
                ) ;

Line: 191

   DELETE FROM CSP_REQ_LINE_DETAILS
    WHERE REQ_LINE_DETAIL_ID = px_REQ_LINE_DETAIL_ID;

Line: 193

    csp_req_line_details_iuhk.delete_req_line_detail_Post
                ( x_return_status          => l_return_status
                ) ;

Line: 206

END Delete_Row;

Line: 213

          p_LAST_UPDATED_BY    NUMBER,
          p_LAST_UPDATE_DATE    DATE,
          p_LAST_UPDATE_LOGIN    NUMBER,
          p_SOURCE_TYPE VARCHAR2,
          p_SOURCE_ID NUMBER)
 IS
   CURSOR C IS
        SELECT *
         FROM CSP_REQ_LINE_DETAILS
        WHERE REQ_LINE_DETAIL_ID =  px_REQ_LINE_DETAIL_ID
        FOR UPDATE of REQ_LINE_DETAIL_ID NOWAIT;

Line: 230

        FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');

Line: 245

       AND (    ( Recinfo.LAST_UPDATED_BY = p_LAST_UPDATED_BY)
            OR (    ( Recinfo.LAST_UPDATED_BY IS NULL )
                AND (  p_LAST_UPDATED_BY IS NULL )))
       AND (    ( Recinfo.LAST_UPDATE_DATE = p_LAST_UPDATE_DATE)
            OR (    ( Recinfo.LAST_UPDATE_DATE IS NULL )
                AND (  p_LAST_UPDATE_DATE IS NULL )))
       AND (    ( Recinfo.LAST_UPDATE_LOGIN = p_LAST_UPDATE_LOGIN)
            OR (    ( Recinfo.LAST_UPDATE_LOGIN IS NULL )
                AND (  p_LAST_UPDATE_LOGIN IS NULL )))
       AND (    ( Recinfo.SOURCE_TYPE = p_SOURCE_TYPE)
            OR (    ( Recinfo.SOURCE_TYPE IS NULL )
                AND (  p_SOURCE_TYPE IS NULL )))
       AND (    ( Recinfo.SOURCE_ID = p_SOURCE_ID)
            OR (    ( Recinfo.SOURCE_ID IS NULL )
                AND (  p_SOURCE_ID IS NULL )))
       ) then
       return;