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,
          p_DML_MODE VARCHAR2)
 IS
   CURSOR C2 IS SELECT CSP_REQ_LINE_DETAILS_S1.nextval FROM sys.dual;

Line: 30

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

Line: 33

	l_module_name VARCHAR2(100)	:= 'csp.plsql.csp_req_line_details_pkg.insert_row';

Line: 47

          l_req_line_details.LAST_UPDATED_BY     :=p_LAST_UPDATED_BY;

Line: 48

          l_req_line_details.LAST_UPDATE_DATE    :=p_LAST_UPDATE_DATE;

Line: 49

          l_req_line_details.LAST_UPDATE_LOGIN   :=p_LAST_UPDATE_LOGIN ;

Line: 97

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

End Insert_Row;

Line: 150

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,
          p_DML_MODE VARCHAR2)
 IS
   l_req_line_details CSP_REQ_line_details_PVT.Req_LINE_Details_Rec_Type;

Line: 163

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

Line: 173

          l_req_line_details.LAST_UPDATED_BY     :=p_LAST_UPDATED_BY;

Line: 174

          l_req_line_details.LAST_UPDATE_DATE    :=p_LAST_UPDATE_DATE;

Line: 175

          l_req_line_details.LAST_UPDATE_LOGIN   :=p_LAST_UPDATE_LOGIN ;

Line: 185

            csp_req_line_details_iuhk.Update_req_line_detail_Pre
                ( x_return_status          => l_return_status
                ) ;

Line: 199

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

             csp_req_line_details_iuhk.Update_req_line_detail_post
                ( x_return_status          => l_return_status
                ) ;

Line: 228

END Update_Row;

Line: 230

PROCEDURE Delete_Row(
    px_REQ_LINE_DETAIL_ID  NUMBER,
    p_DML_MODE VARCHAR2)
 IS
   l_return_status    varchar2(100);

Line: 237

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

Line: 246

            csp_req_line_details_iuhk.delete_req_line_detail_Pre
                ( x_return_status          => l_return_status
                ) ;

Line: 259

     DELETE FROM CSP_REQ_LINE_DETAILS
      WHERE REQ_LINE_DETAIL_ID = px_REQ_LINE_DETAIL_ID;

Line: 264

      csp_req_line_details_iuhk.delete_req_line_detail_Post
                  ( x_return_status          => l_return_status
                  ) ;

Line: 278

END Delete_Row;

Line: 285

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

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

Line: 317

       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;