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.CSF_DEBRIEF_HEADERS_PKG SQL Statements

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

Line: 12


PROCEDURE Insert_Row(
          px_DEBRIEF_HEADER_ID   IN OUT NOCOPY NUMBER,
          p_DEBRIEF_NUMBER    VARCHAR2,
          p_DEBRIEF_DATE    DATE,
          p_DEBRIEF_STATUS_ID    NUMBER,
          p_TASK_ASSIGNMENT_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_ATTRIBUTE1    VARCHAR2,
          p_ATTRIBUTE2    VARCHAR2,
          p_ATTRIBUTE3    VARCHAR2,
          p_ATTRIBUTE4    VARCHAR2,
          p_ATTRIBUTE5    VARCHAR2,
          p_ATTRIBUTE6    VARCHAR2,
          p_ATTRIBUTE7    VARCHAR2,
          p_ATTRIBUTE8    VARCHAR2,
          p_ATTRIBUTE9    VARCHAR2,
          p_ATTRIBUTE10    VARCHAR2,
          p_ATTRIBUTE11    VARCHAR2,
          p_ATTRIBUTE12    VARCHAR2,
          p_ATTRIBUTE13    VARCHAR2,
          p_ATTRIBUTE14    VARCHAR2,
          p_ATTRIBUTE15    VARCHAR2,
          p_ATTRIBUTE_CATEGORY    VARCHAR2,
	      p_commit         IN  VARCHAR2 DEFAULT Null, -- added for bug 3565704
           p_object_version_number    IN        NUMBER default null,
          p_TRAVEL_START_TIME        IN        DATE default null,
          p_TRAVEL_END_TIME          In        DATE default null,
          p_TRAVEL_DISTANCE_IN_KM    In        NUMBER default null,
          p_DML_mode                           VARCHAR2
          )

 IS
   CURSOR C2 IS SELECT CSF_DEBRIEF_HEADERS_S1.nextval FROM sys.dual;

Line: 49


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

Line: 64


          l_debrief_header.LAST_UPDATED_BY    := p_LAST_UPDATED_BY    ;

Line: 65


          l_debrief_header.LAST_UPDATE_DATE   := p_LAST_UPDATE_DATE    ;

Line: 66


          l_debrief_header.LAST_UPDATE_LOGIN  := p_LAST_UPDATE_LOGIN    ;

Line: 94


                                          'Insert_Row',
                                          'B', 'C')  THEN

                csf_debrief_headers_cuhk.Create_debrief_header_Pre
                    ( px_debrief_header     => l_debrief_header,
                      x_return_status          => l_return_status,
                      x_msg_count              => l_msg_count,
                      x_msg_data               => l_msg_data
                    ) ;

Line: 117


                                      'Insert_Row',
                                      'B', 'V')  THEN
    csf_debrief_headers_vuhk.Create_debrief_header_Pre
                ( px_debrief_header     => l_debrief_header,
                  x_return_status          => l_return_status,
                  x_msg_count              => l_msg_count,
                  x_msg_data               => l_msg_data
                ) ;

Line: 158


     INSERT INTO CSF_DEBRIEF_HEADERS(
             DEBRIEF_HEADER_ID,
             DEBRIEF_NUMBER,
             DEBRIEF_DATE,
             DEBRIEF_STATUS_ID,
             TASK_ASSIGNMENT_ID,
             CREATED_BY,
             CREATION_DATE,
             LAST_UPDATED_BY,
             LAST_UPDATE_DATE,
             LAST_UPDATE_LOGIN,
             ATTRIBUTE1,
             ATTRIBUTE2,
             ATTRIBUTE3,
             ATTRIBUTE4,
             ATTRIBUTE5,
             ATTRIBUTE6,
             ATTRIBUTE7,
             ATTRIBUTE8,
             ATTRIBUTE9,
             ATTRIBUTE10,
             ATTRIBUTE11,
             ATTRIBUTE12,
             ATTRIBUTE13,
             ATTRIBUTE14,
             ATTRIBUTE15,
             ATTRIBUTE_CATEGORY,
             OBJECT_VERSION_NUMBER,
             TRAVEL_START_TIME,
             TRAVEL_END_TIME,
             TRAVEL_DISTANCE_IN_KM,
             PROCESSED_FLAG
            ) VALUES (
             px_DEBRIEF_HEADER_ID,
             decode( l_debrief_header.DEBRIEF_NUMBER, FND_API.G_MISS_CHAR, NULL, l_debrief_header.DEBRIEF_NUMBER),
             decode( l_debrief_header.DEBRIEF_DATE, FND_API.G_MISS_DATE, to_date(null), l_debrief_header.DEBRIEF_DATE),
             decode( l_debrief_header.DEBRIEF_STATUS_ID, FND_API.G_MISS_NUM, NULL, l_debrief_header.DEBRIEF_STATUS_ID),
             decode( l_debrief_header.TASK_ASSIGNMENT_ID, FND_API.G_MISS_NUM, NULL, l_debrief_header.TASK_ASSIGNMENT_ID),
             decode( l_debrief_header.CREATED_BY, FND_API.G_MISS_NUM, fnd_global.user_id, l_debrief_header.CREATED_BY),
             decode( l_debrief_header.CREATION_DATE, FND_API.G_MISS_DATE, sysdate, l_debrief_header.CREATION_DATE),
             decode( l_debrief_header.LAST_UPDATED_BY, FND_API.G_MISS_NUM, fnd_global.user_id, l_debrief_header.LAST_UPDATED_BY),
             decode( l_debrief_header.LAST_UPDATE_DATE, FND_API.G_MISS_DATE, sysdate, l_debrief_header.LAST_UPDATE_DATE),
             decode( l_debrief_header.LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, fnd_global.conc_login_id, l_debrief_header.LAST_UPDATE_LOGIN),
             decode( l_debrief_header.ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, l_debrief_header.ATTRIBUTE1),
             decode( l_debrief_header.ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, l_debrief_header.ATTRIBUTE2),
             decode( l_debrief_header.ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, l_debrief_header.ATTRIBUTE3),
             decode( l_debrief_header.ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, l_debrief_header.ATTRIBUTE4),
             decode( l_debrief_header.ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, l_debrief_header.ATTRIBUTE5),
             decode( l_debrief_header.ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, l_debrief_header.ATTRIBUTE6),
             decode( l_debrief_header.ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, l_debrief_header.ATTRIBUTE7),
             decode( l_debrief_header.ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, l_debrief_header.ATTRIBUTE8),
             decode( l_debrief_header.ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, l_debrief_header.ATTRIBUTE9),
             decode( l_debrief_header.ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, l_debrief_header.ATTRIBUTE10),
             decode( l_debrief_header.ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, l_debrief_header.ATTRIBUTE11),
             decode( l_debrief_header.ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, l_debrief_header.ATTRIBUTE12),
             decode( l_debrief_header.ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, l_debrief_header.ATTRIBUTE13),
             decode( l_debrief_header.ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, l_debrief_header.ATTRIBUTE14),
             decode( l_debrief_header.ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, l_debrief_header.ATTRIBUTE15),
             decode( l_debrief_header.ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, l_debrief_header.ATTRIBUTE_CATEGORY),
             decode( l_debrief_header.OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL,l_debrief_header.OBJECT_VERSION_NUMBER),
             decode( l_debrief_header.TRAVEL_START_TIME, FND_API.G_MISS_DATE, to_date(null), l_debrief_header.TRAVEL_START_TIME),
             decode( l_debrief_header.TRAVEL_END_TIME, FND_API.G_MISS_DATE, to_date(null), l_debrief_header.TRAVEL_END_TIME),
             decode( l_debrief_header.TRAVEL_DISTANCE_IN_KM, FND_API.G_MISS_NUM, NULL, l_debrief_header.TRAVEL_DISTANCE_IN_KM),
             'UNPROCESSED'
             );

Line: 227


                                        'Insert_Row',
                                        'A', 'C')  THEN

              csf_debrief_headers_cuhk.Create_debrief_header_post
                  ( px_debrief_header     => l_debrief_header,
                    x_return_status          => l_return_status,
                    x_msg_count              => l_msg_count,
                    x_msg_data               => l_msg_data
                  ) ;

Line: 250


                                      'Insert_Row',
                                      'A', 'V')  THEN
    csf_debrief_headers_vuhk.Create_debrief_header_post
                ( px_debrief_header     => l_debrief_header,
                  x_return_status          => l_return_status,
                  x_msg_count              => l_msg_count,
                  x_msg_data               => l_msg_data
                ) ;

Line: 294


End Insert_Row;

Line: 296


PROCEDURE Update_Row(
          p_DEBRIEF_HEADER_ID    NUMBER,
          p_DEBRIEF_NUMBER    VARCHAR2,
          p_DEBRIEF_DATE    DATE,
          p_DEBRIEF_STATUS_ID    NUMBER,
          p_TASK_ASSIGNMENT_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_ATTRIBUTE1    VARCHAR2,
          p_ATTRIBUTE2    VARCHAR2,
          p_ATTRIBUTE3    VARCHAR2,
          p_ATTRIBUTE4    VARCHAR2,
          p_ATTRIBUTE5    VARCHAR2,
          p_ATTRIBUTE6    VARCHAR2,
          p_ATTRIBUTE7    VARCHAR2,
          p_ATTRIBUTE8    VARCHAR2,
          p_ATTRIBUTE9    VARCHAR2,
          p_ATTRIBUTE10    VARCHAR2,
          p_ATTRIBUTE11    VARCHAR2,
          p_ATTRIBUTE12    VARCHAR2,
          p_ATTRIBUTE13    VARCHAR2,
          p_ATTRIBUTE14    VARCHAR2,
          p_ATTRIBUTE15    VARCHAR2,
          p_ATTRIBUTE_CATEGORY    VARCHAR2,
           p_object_version_number    IN        NUMBER default null,
          p_TRAVEL_START_TIME        IN        DATE default null,
          p_TRAVEL_END_TIME          In        DATE default null,
          p_TRAVEL_DISTANCE_IN_KM    In        NUMBER default null,
          p_DML_mode                           VARCHAR2
          )

 IS
          l_api_name_full varchar2(50) := 'CSF_DEBRIEF_HEADERS_PKG.UPDATE_ROW';

Line: 345


          l_debrief_header.LAST_UPDATED_BY    := p_LAST_UPDATED_BY    ;

Line: 346


          l_debrief_header.LAST_UPDATE_DATE   := p_LAST_UPDATE_DATE    ;

Line: 347


          l_debrief_header.LAST_UPDATE_LOGIN  := p_LAST_UPDATE_LOGIN    ;

Line: 375


                                        'Update_Row',
                                        'B', 'C')  THEN

              csf_debrief_headers_cuhk.update_debrief_header_Pre
                  ( px_debrief_header     => l_debrief_header,
                    x_return_status          => l_return_status,
                    x_msg_count              => l_msg_count,
                    x_msg_data               => l_msg_data
                  ) ;

Line: 398


                                      'Update_Row',
                                      'B', 'V')  THEN
    csf_debrief_headers_vuhk.update_debrief_header_Pre
                ( px_debrief_header     => l_debrief_header,
                  x_return_status          => l_return_status,
                  x_msg_count              => l_msg_count,
                  x_msg_data               => l_msg_data
                ) ;

Line: 416


    csf_debrief_headers_iuhk.update_debrief_header_Pre
               ( x_return_status          => l_return_status
                ) ;

Line: 430


        Update CSF_DEBRIEF_HEADERS
        SET
                  DEBRIEF_NUMBER = decode( l_debrief_header.DEBRIEF_NUMBER, FND_API.G_MISS_CHAR, DEBRIEF_NUMBER, l_debrief_header.DEBRIEF_NUMBER),
                  DEBRIEF_DATE = decode( l_debrief_header.DEBRIEF_DATE, FND_API.G_MISS_DATE, DEBRIEF_DATE, l_debrief_header.DEBRIEF_DATE),
                  DEBRIEF_STATUS_ID = decode( l_debrief_header.DEBRIEF_STATUS_ID, FND_API.G_MISS_NUM, DEBRIEF_STATUS_ID, l_debrief_header.DEBRIEF_STATUS_ID),
                  TASK_ASSIGNMENT_ID = decode( l_debrief_header.TASK_ASSIGNMENT_ID, FND_API.G_MISS_NUM, TASK_ASSIGNMENT_ID, l_debrief_header.TASK_ASSIGNMENT_ID),
                  CREATED_BY = decode( l_debrief_header.CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, l_debrief_header.CREATED_BY),
                  CREATION_DATE = decode( l_debrief_header.CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, l_debrief_header.CREATION_DATE),
                  LAST_UPDATED_BY = decode( l_debrief_header.LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, l_debrief_header.LAST_UPDATED_BY),
                  LAST_UPDATE_DATE = decode( l_debrief_header.LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, l_debrief_header.LAST_UPDATE_DATE),
                  LAST_UPDATE_LOGIN = decode( l_debrief_header.LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, l_debrief_header.LAST_UPDATE_LOGIN),
                  ATTRIBUTE1 = decode( l_debrief_header.ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, l_debrief_header.ATTRIBUTE1),
                  ATTRIBUTE2 = decode( l_debrief_header.ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, l_debrief_header.ATTRIBUTE2),
                  ATTRIBUTE3 = decode( l_debrief_header.ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, l_debrief_header.ATTRIBUTE3),
                  ATTRIBUTE4 = decode( l_debrief_header.ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, l_debrief_header.ATTRIBUTE4),
                  ATTRIBUTE5 = decode( l_debrief_header.ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, l_debrief_header.ATTRIBUTE5),
                  ATTRIBUTE6 = decode( l_debrief_header.ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, l_debrief_header.ATTRIBUTE6),
                  ATTRIBUTE7 = decode( l_debrief_header.ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, l_debrief_header.ATTRIBUTE7),
                  ATTRIBUTE8 = decode( l_debrief_header.ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, l_debrief_header.ATTRIBUTE8),
                  ATTRIBUTE9 = decode( l_debrief_header.ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, l_debrief_header.ATTRIBUTE9),
                  ATTRIBUTE10 = decode( l_debrief_header.ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, l_debrief_header.ATTRIBUTE10),
                  ATTRIBUTE11 = decode( l_debrief_header.ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, l_debrief_header.ATTRIBUTE11),
                  ATTRIBUTE12 = decode( l_debrief_header.ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, l_debrief_header.ATTRIBUTE12),
                  ATTRIBUTE13 = decode( l_debrief_header.ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, l_debrief_header.ATTRIBUTE13),
                  ATTRIBUTE14 = decode( l_debrief_header.ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, l_debrief_header.ATTRIBUTE14),
                  ATTRIBUTE15 = decode( l_debrief_header.ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, l_debrief_header.ATTRIBUTE15),
                  ATTRIBUTE_CATEGORY = decode( l_debrief_header.ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, l_debrief_header.ATTRIBUTE_CATEGORY),
                  OBJECT_VERSION_NUMBER =  decode( l_debrief_header.OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER,l_debrief_header.OBJECT_VERSION_NUMBER),
                  TRAVEL_START_TIME  = decode( l_debrief_header.TRAVEL_START_TIME, FND_API.G_MISS_DATE, TRAVEL_START_TIME, l_debrief_header.TRAVEL_START_TIME),
                  TRAVEL_END_TIME  = decode( l_debrief_header.TRAVEL_END_TIME, FND_API.G_MISS_DATE, TRAVEL_END_TIME, l_debrief_header.TRAVEL_END_TIME),
                  TRAVEL_DISTANCE_IN_KM = decode( l_debrief_header.TRAVEL_DISTANCE_IN_KM, FND_API.G_MISS_NUM, TRAVEL_DISTANCE_IN_KM, l_debrief_header.TRAVEL_DISTANCE_IN_KM)

        where DEBRIEF_HEADER_ID = l_debrief_header.DEBRIEF_HEADER_ID;

Line: 471


                                          'Update_Row',
                                          'A', 'C')  THEN

                csf_debrief_headers_cuhk.update_debrief_header_post
                    ( px_debrief_header     => l_debrief_header,
                      x_return_status          => l_return_status,
                      x_msg_count              => l_msg_count,
                      x_msg_data               => l_msg_data
                    ) ;

Line: 494


                                      'Update_Row',
                                      'A', 'V')  THEN
    csf_debrief_headers_vuhk.update_debrief_header_post
                ( px_debrief_header     => l_debrief_header,
                  x_return_status          => l_return_status,
                  x_msg_count              => l_msg_count,
                  x_msg_data               => l_msg_data
                ) ;

Line: 511


    csf_debrief_headers_iuhk.update_debrief_header_post
                ( x_return_status          => l_return_status
                ) ;

Line: 522


END Update_Row;

Line: 524


PROCEDURE Delete_Row(
    p_DEBRIEF_HEADER_ID  NUMBER,
    p_DML_mode           VARCHAR2)
 IS
   l_return_status    varchar2(100);

Line: 531


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

Line: 541


                                          'Delete_Row',
                                          'B', 'C')  THEN

                csf_debrief_headers_cuhk.delete_debrief_header_Pre
                    ( p_header_id     => p_DEBRIEF_HEADER_ID,
                      x_return_status          => l_return_status,
                      x_msg_count              => l_msg_count,
                      x_msg_data               => l_msg_data
                    ) ;

Line: 563


                                      'Delete_Row',
                                      'B', 'V')  THEN
    csf_debrief_headers_vuhk.delete_debrief_header_Pre
                ( p_header_id              => p_DEBRIEF_HEADER_ID,
                  x_return_status          => l_return_status,
                  x_msg_count              => l_msg_count,
                  x_msg_data               => l_msg_data
                ) ;

Line: 581


    csf_debrief_headers_iuhk.delete_debrief_header_Pre
                ( x_return_status          => l_return_status
                ) ;

Line: 594


       DELETE FROM CSF_DEBRIEF_HEADERS
        WHERE DEBRIEF_HEADER_ID = p_DEBRIEF_HEADER_ID;

Line: 603


                                          'Delete_Row',
                                          'A', 'C')  THEN

                csf_debrief_headers_cuhk.delete_debrief_header_Post
                    ( p_header_id     => p_DEBRIEF_HEADER_ID,
                      x_return_status          => l_return_status,
                      x_msg_count              => l_msg_count,
                      x_msg_data               => l_msg_data
                    ) ;

Line: 626


                                      'Delete_Row',
                                      'A', 'V')  THEN
    csf_debrief_headers_vuhk.delete_debrief_header_post
                ( p_header_id     => p_DEBRIEF_HEADER_ID,
                  x_return_status          => l_return_status,
                  x_msg_count              => l_msg_count,
                  x_msg_data               => l_msg_data
                ) ;

Line: 643


    csf_debrief_headers_iuhk.Delete_debrief_header_post
                ( x_return_status          => l_return_status
                ) ;

Line: 654


 END Delete_Row;

Line: 664


          p_LAST_UPDATED_BY    NUMBER,
          p_LAST_UPDATE_DATE    DATE,
          p_LAST_UPDATE_LOGIN    NUMBER,
          p_ATTRIBUTE1    VARCHAR2,
          p_ATTRIBUTE2    VARCHAR2,
          p_ATTRIBUTE3    VARCHAR2,
          p_ATTRIBUTE4    VARCHAR2,
          p_ATTRIBUTE5    VARCHAR2,
          p_ATTRIBUTE6    VARCHAR2,
          p_ATTRIBUTE7    VARCHAR2,
          p_ATTRIBUTE8    VARCHAR2,
          p_ATTRIBUTE9    VARCHAR2,
          p_ATTRIBUTE10    VARCHAR2,
          p_ATTRIBUTE11    VARCHAR2,
          p_ATTRIBUTE12    VARCHAR2,
          p_ATTRIBUTE13    VARCHAR2,
          p_ATTRIBUTE14    VARCHAR2,
          p_ATTRIBUTE15    VARCHAR2,
          p_ATTRIBUTE_CATEGORY    VARCHAR2,
           p_object_version_number    IN        NUMBER default null,
          p_TRAVEL_START_TIME        IN        DATE default null,
          p_TRAVEL_END_TIME          In        DATE default null,
          p_TRAVEL_DISTANCE_IN_KM    In        NUMBER default null
          )

 IS
   CURSOR C IS
        SELECT *
         FROM CSF_DEBRIEF_HEADERS
        WHERE DEBRIEF_HEADER_ID =  p_DEBRIEF_HEADER_ID
        FOR UPDATE of DEBRIEF_HEADER_ID NOWAIT;

Line: 701


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

Line: 725


       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.ATTRIBUTE1 = p_ATTRIBUTE1)
            OR (    ( Recinfo.ATTRIBUTE1 IS NULL )
                AND (  p_ATTRIBUTE1 IS NULL )))
       AND (    ( Recinfo.ATTRIBUTE2 = p_ATTRIBUTE2)
            OR (    ( Recinfo.ATTRIBUTE2 IS NULL )
                AND (  p_ATTRIBUTE2 IS NULL )))
       AND (    ( Recinfo.ATTRIBUTE3 = p_ATTRIBUTE3)
            OR (    ( Recinfo.ATTRIBUTE3 IS NULL )
                AND (  p_ATTRIBUTE3 IS NULL )))
       AND (    ( Recinfo.ATTRIBUTE4 = p_ATTRIBUTE4)
            OR (    ( Recinfo.ATTRIBUTE4 IS NULL )
                AND (  p_ATTRIBUTE4 IS NULL )))
       AND (    ( Recinfo.ATTRIBUTE5 = p_ATTRIBUTE5)
            OR (    ( Recinfo.ATTRIBUTE5 IS NULL )
                AND (  p_ATTRIBUTE5 IS NULL )))
       AND (    ( Recinfo.ATTRIBUTE6 = p_ATTRIBUTE6)
            OR (    ( Recinfo.ATTRIBUTE6 IS NULL )
                AND (  p_ATTRIBUTE6 IS NULL )))
       AND (    ( Recinfo.ATTRIBUTE7 = p_ATTRIBUTE7)
            OR (    ( Recinfo.ATTRIBUTE7 IS NULL )
                AND (  p_ATTRIBUTE7 IS NULL )))
       AND (    ( Recinfo.ATTRIBUTE8 = p_ATTRIBUTE8)
            OR (    ( Recinfo.ATTRIBUTE8 IS NULL )
                AND (  p_ATTRIBUTE8 IS NULL )))
       AND (    ( Recinfo.ATTRIBUTE9 = p_ATTRIBUTE9)
            OR (    ( Recinfo.ATTRIBUTE9 IS NULL )
                AND (  p_ATTRIBUTE9 IS NULL )))
       AND (    ( Recinfo.ATTRIBUTE10 = p_ATTRIBUTE10)
            OR (    ( Recinfo.ATTRIBUTE10 IS NULL )
                AND (  p_ATTRIBUTE10 IS NULL )))
       AND (    ( Recinfo.ATTRIBUTE11 = p_ATTRIBUTE11)
            OR (    ( Recinfo.ATTRIBUTE11 IS NULL )
                AND (  p_ATTRIBUTE11 IS NULL )))
       AND (    ( Recinfo.ATTRIBUTE12 = p_ATTRIBUTE12)
            OR (    ( Recinfo.ATTRIBUTE12 IS NULL )
                AND (  p_ATTRIBUTE12 IS NULL )))
       AND (    ( Recinfo.ATTRIBUTE13 = p_ATTRIBUTE13)
            OR (    ( Recinfo.ATTRIBUTE13 IS NULL )
                AND (  p_ATTRIBUTE13 IS NULL )))
       AND (    ( Recinfo.ATTRIBUTE14 = p_ATTRIBUTE14)
            OR (    ( Recinfo.ATTRIBUTE14 IS NULL )
                AND (  p_ATTRIBUTE14 IS NULL )))
       AND (    ( Recinfo.ATTRIBUTE15 = p_ATTRIBUTE15)
            OR (    ( Recinfo.ATTRIBUTE15 IS NULL )
                AND (  p_ATTRIBUTE15 IS NULL )))
       AND (    ( Recinfo.ATTRIBUTE_CATEGORY = p_ATTRIBUTE_CATEGORY)
            OR (    ( Recinfo.ATTRIBUTE_CATEGORY IS NULL )
                AND (  p_ATTRIBUTE_CATEGORY IS NULL )))
       AND (    ( Recinfo.OBJECT_VERSION_NUMBER = p_OBJECT_VERSION_NUMBER)
            OR (    ( Recinfo.OBJECT_VERSION_NUMBER IS NULL )
                AND (  p_OBJECT_VERSION_NUMBER IS NULL )))
       AND (    ( Recinfo.TRAVEL_START_TIME = p_TRAVEL_START_TIME)
            OR (    ( Recinfo.TRAVEL_START_TIME IS NULL )
                AND (  p_TRAVEL_START_TIME IS NULL )))
       AND (    ( Recinfo.TRAVEL_END_TIME = p_TRAVEL_END_TIME)
            OR (    ( Recinfo.TRAVEL_END_TIME IS NULL )
                AND (  p_TRAVEL_END_TIME IS NULL )))
       AND (    ( Recinfo.TRAVEL_DISTANCE_IN_KM = p_TRAVEL_DISTANCE_IN_KM)
            OR (    ( Recinfo.TRAVEL_DISTANCE_IN_KM IS NULL )
                AND (  p_TRAVEL_DISTANCE_IN_KM IS NULL )))
       ) then
       return;

Line: 808


    select resource_name from jtf_rs_all_resources_vl
    where  resource_id = p_resource_id
    and    resource_type = p_resource_type;