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

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

Line: 14


PROCEDURE Insert_Row(
          px_CSP_INV_LOC_ASSIGNMENT_ID   IN OUT NOCOPY 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_RESOURCE_ID    NUMBER,
          p_ORGANIZATION_ID    NUMBER,
          p_SUBINVENTORY_CODE    VARCHAR2,
          p_LOCATOR_ID    NUMBER,
          p_RESOURCE_TYPE    VARCHAR2,
          p_EFFECTIVE_DATE_START    DATE,
          p_EFFECTIVE_DATE_END    DATE,
          p_DEFAULT_CODE    VARCHAR2,
          p_ATTRIBUTE_CATEGORY    VARCHAR2,
          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)

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

Line: 52


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

Line: 57


          l_inv_loc_assignment.LAST_UPDATED_BY            := p_LAST_UPDATED_BY    ;

Line: 58


          l_inv_loc_assignment.LAST_UPDATE_DATE           := p_LAST_UPDATE_DATE    ;

Line: 59


          l_inv_loc_assignment.LAST_UPDATE_LOGIN          := p_LAST_UPDATE_LOGIN    ;

Line: 86


                                      'Insert_Row',
                                      'B', 'C')  THEN
    csp_inv_loc_assignments_cuhk.create_inventory_location_Pre
                ( px_inv_loc_assignment     => l_inv_loc_assignment ,
                  x_return_status          => l_return_status,
                  x_msg_count              => l_msg_count,
                  x_msg_data               => l_msg_data
                ) ;

Line: 106


                                      'Insert_Row',
                                      'B', 'V')  THEN
    csp_inv_loc_assignments_vuhk.create_inventory_location_Pre
                ( px_inv_loc_assignment     => l_inv_loc_assignment ,
                  x_return_status          => l_return_status,
                  x_msg_count              => l_msg_count,
                  x_msg_data               => l_msg_data
                ) ;

Line: 144


   INSERT INTO CSP_INV_LOC_ASSIGNMENTS(
           CSP_INV_LOC_ASSIGNMENT_ID,
           CREATED_BY,
           CREATION_DATE,
           LAST_UPDATED_BY,
           LAST_UPDATE_DATE,
           LAST_UPDATE_LOGIN,
           RESOURCE_ID,
           ORGANIZATION_ID,
           SUBINVENTORY_CODE,
           LOCATOR_ID,
           RESOURCE_TYPE,
           EFFECTIVE_DATE_START,
           EFFECTIVE_DATE_END,
           DEFAULT_CODE,
           ATTRIBUTE_CATEGORY,
           ATTRIBUTE1,
           ATTRIBUTE2,
           ATTRIBUTE3,
           ATTRIBUTE4,
           ATTRIBUTE5,
           ATTRIBUTE6,
           ATTRIBUTE7,
           ATTRIBUTE8,
           ATTRIBUTE9,
           ATTRIBUTE10,
           ATTRIBUTE11,
           ATTRIBUTE12,
           ATTRIBUTE13,
           ATTRIBUTE14,
           ATTRIBUTE15
          ) VALUES (
           px_CSP_INV_LOC_ASSIGNMENT_ID,
           decode( l_inv_loc_assignment.CREATED_BY, FND_API.G_MISS_NUM, NULL, l_inv_loc_assignment.CREATED_BY),
           decode(l_inv_loc_assignment.CREATION_DATE,fnd_api.g_miss_date,to_date(null),l_inv_loc_assignment.creation_date),
           decode( l_inv_loc_assignment.LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, l_inv_loc_assignment.LAST_UPDATED_BY),
           decode(l_inv_loc_assignment.LAST_UPDATE_DATE,fnd_api.g_miss_date,to_date(null),l_inv_loc_assignment.last_update_date),
           decode( l_inv_loc_assignment.LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, l_inv_loc_assignment.LAST_UPDATE_LOGIN),
           decode( l_inv_loc_assignment.RESOURCE_ID, FND_API.G_MISS_NUM, NULL, l_inv_loc_assignment.RESOURCE_ID),
           decode( l_inv_loc_assignment.ORGANIZATION_ID, FND_API.G_MISS_NUM, NULL, l_inv_loc_assignment.ORGANIZATION_ID),
           decode( l_inv_loc_assignment.SUBINVENTORY_CODE, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.SUBINVENTORY_CODE),
           decode( l_inv_loc_assignment.LOCATOR_ID, FND_API.G_MISS_NUM, NULL, l_inv_loc_assignment.LOCATOR_ID),
           decode( l_inv_loc_assignment.RESOURCE_TYPE, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.RESOURCE_TYPE),
           decode( l_inv_loc_assignment.EFFECTIVE_DATE_START, FND_API.G_MISS_DATE, to_date(null), l_inv_loc_assignment.EFFECTIVE_DATE_START),
           decode( l_inv_loc_assignment.EFFECTIVE_DATE_END, FND_API.G_MISS_DATE, to_date(null), l_inv_loc_assignment.EFFECTIVE_DATE_END),
           decode( l_inv_loc_assignment.DEFAULT_CODE, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.DEFAULT_CODE),
           decode( l_inv_loc_assignment.ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.ATTRIBUTE_CATEGORY),
           decode( l_inv_loc_assignment.ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.ATTRIBUTE1),
           decode( l_inv_loc_assignment.ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.ATTRIBUTE2),
           decode( l_inv_loc_assignment.ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.ATTRIBUTE3),
           decode( l_inv_loc_assignment.ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.ATTRIBUTE4),
           decode( l_inv_loc_assignment.ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.ATTRIBUTE5),
           decode( l_inv_loc_assignment.ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.ATTRIBUTE6),
           decode( l_inv_loc_assignment.ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.ATTRIBUTE7),
           decode( l_inv_loc_assignment.ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.ATTRIBUTE8),
           decode( l_inv_loc_assignment.ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.ATTRIBUTE9),
           decode( l_inv_loc_assignment.ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.ATTRIBUTE10),
           decode( l_inv_loc_assignment.ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.ATTRIBUTE11),
           decode( l_inv_loc_assignment.ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.ATTRIBUTE12),
           decode( l_inv_loc_assignment.ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.ATTRIBUTE13),
           decode( l_inv_loc_assignment.ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.ATTRIBUTE14),
           decode( l_inv_loc_assignment.ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.ATTRIBUTE15));

Line: 208


                                      'Insert_Row',
                                      'A', 'C')  THEN
    csp_inv_loc_assignments_cuhk.create_inventory_location_Post
                ( px_inv_loc_assignment     => l_inv_loc_assignment ,
                  x_return_status          => l_return_status,
                  x_msg_count              => l_msg_count,
                  x_msg_data               => l_msg_data
                ) ;

Line: 228


                                      'Insert_Row',
                                      'A', 'V')  THEN
    csp_inv_loc_assignments_vuhk.create_inventory_location_Post
                ( px_inv_loc_assignment     => l_inv_loc_assignment ,
                  x_return_status          => l_return_status,
                  x_msg_count              => l_msg_count,
                  x_msg_data               => l_msg_data
                ) ;

Line: 256


End Insert_Row;

Line: 258


PROCEDURE Update_Row(
          p_CSP_INV_LOC_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_RESOURCE_ID    NUMBER,
          p_ORGANIZATION_ID    NUMBER,
          p_SUBINVENTORY_CODE    VARCHAR2,
          p_LOCATOR_ID    NUMBER,
          p_RESOURCE_TYPE    VARCHAR2,
          p_EFFECTIVE_DATE_START    DATE,
          p_EFFECTIVE_DATE_END    DATE,
          p_DEFAULT_CODE    VARCHAR2,
          p_ATTRIBUTE_CATEGORY    VARCHAR2,
          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)

 IS
     l_inv_loc_assignment  CSP_INV_LOC_ASSIGNMENTS_PKG.inv_loc_assignments_rec_type;

Line: 295


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

Line: 302


          l_inv_loc_assignment.LAST_UPDATED_BY            := p_LAST_UPDATED_BY    ;

Line: 303


          l_inv_loc_assignment.LAST_UPDATE_DATE           := p_LAST_UPDATE_DATE    ;

Line: 304


          l_inv_loc_assignment.LAST_UPDATE_LOGIN          := p_LAST_UPDATE_LOGIN    ;

Line: 331


                                      'Update_Row',
                                      'B', 'C')  THEN
    csp_inv_loc_assignments_cuhk.update_inventory_location_Pre
                ( px_inv_loc_assignment     => l_inv_loc_assignment ,
                  x_return_status          => l_return_status,
                  x_msg_count              => l_msg_count,
                  x_msg_data               => l_msg_data
                ) ;

Line: 351


                                      'Update_Row',
                                      'B', 'V')  THEN
    csp_inv_loc_assignments_vuhk.update_inventory_location_Pre
                ( px_inv_loc_assignment     => l_inv_loc_assignment ,
                  x_return_status          => l_return_status,
                  x_msg_count              => l_msg_count,
                  x_msg_data               => l_msg_data
                ) ;

Line: 369


    csp_inv_loc_assignments_iuhk.update_inventory_location_Pre
                ( x_return_status          => l_return_status
                ) ;

Line: 381


    Update CSP_INV_LOC_ASSIGNMENTS
    SET
              CREATED_BY = decode( l_inv_loc_assignment.CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, l_inv_loc_assignment.CREATED_BY),
              CREATION_DATE = decode(l_inv_loc_assignment.CREATION_DATE,fnd_api.g_miss_date,creation_date,l_inv_loc_assignment.creation_date),
              LAST_UPDATED_BY = decode( l_inv_loc_assignment.LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, l_inv_loc_assignment.LAST_UPDATED_BY),
              LAST_UPDATE_DATE = decode(l_inv_loc_assignment.LAST_UPDATE_DATE,fnd_api.g_miss_date,last_update_date,l_inv_loc_assignment.last_update_date),
              LAST_UPDATE_LOGIN = decode( l_inv_loc_assignment.LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, l_inv_loc_assignment.LAST_UPDATE_LOGIN),
              RESOURCE_ID = decode( l_inv_loc_assignment.RESOURCE_ID, FND_API.G_MISS_NUM, RESOURCE_ID, l_inv_loc_assignment.RESOURCE_ID),
              ORGANIZATION_ID = decode( l_inv_loc_assignment.ORGANIZATION_ID, FND_API.G_MISS_NUM, ORGANIZATION_ID, l_inv_loc_assignment.ORGANIZATION_ID),
              SUBINVENTORY_CODE = decode( l_inv_loc_assignment.SUBINVENTORY_CODE, FND_API.G_MISS_CHAR, SUBINVENTORY_CODE, l_inv_loc_assignment.SUBINVENTORY_CODE),
              LOCATOR_ID = decode( l_inv_loc_assignment.LOCATOR_ID, FND_API.G_MISS_NUM, LOCATOR_ID, l_inv_loc_assignment.LOCATOR_ID),
              RESOURCE_TYPE = decode( l_inv_loc_assignment.RESOURCE_TYPE, FND_API.G_MISS_CHAR, RESOURCE_TYPE, l_inv_loc_assignment.RESOURCE_TYPE),
              EFFECTIVE_DATE_START = decode( l_inv_loc_assignment.EFFECTIVE_DATE_START, FND_API.G_MISS_DATE, EFFECTIVE_DATE_START, l_inv_loc_assignment.EFFECTIVE_DATE_START),
              EFFECTIVE_DATE_END = decode( l_inv_loc_assignment.EFFECTIVE_DATE_END, FND_API.G_MISS_DATE, EFFECTIVE_DATE_END, l_inv_loc_assignment.EFFECTIVE_DATE_END),
              DEFAULT_CODE = decode( l_inv_loc_assignment.DEFAULT_CODE, FND_API.G_MISS_CHAR, DEFAULT_CODE, l_inv_loc_assignment.DEFAULT_CODE),
              ATTRIBUTE_CATEGORY = decode( l_inv_loc_assignment.ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, l_inv_loc_assignment.ATTRIBUTE_CATEGORY),
              ATTRIBUTE1 = decode( l_inv_loc_assignment.ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, l_inv_loc_assignment.ATTRIBUTE1),
              ATTRIBUTE2 = decode( l_inv_loc_assignment.ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, l_inv_loc_assignment.ATTRIBUTE2),
              ATTRIBUTE3 = decode( l_inv_loc_assignment.ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, l_inv_loc_assignment.ATTRIBUTE3),
              ATTRIBUTE4 = decode( l_inv_loc_assignment.ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, l_inv_loc_assignment.ATTRIBUTE4),
              ATTRIBUTE5 = decode( l_inv_loc_assignment.ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, l_inv_loc_assignment.ATTRIBUTE5),
              ATTRIBUTE6 = decode( l_inv_loc_assignment.ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, l_inv_loc_assignment.ATTRIBUTE6),
              ATTRIBUTE7 = decode( l_inv_loc_assignment.ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, l_inv_loc_assignment.ATTRIBUTE7),
              ATTRIBUTE8 = decode( l_inv_loc_assignment.ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, l_inv_loc_assignment.ATTRIBUTE8),
              ATTRIBUTE9 = decode( l_inv_loc_assignment.ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, l_inv_loc_assignment.ATTRIBUTE9),
              ATTRIBUTE10 = decode( l_inv_loc_assignment.ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, l_inv_loc_assignment.ATTRIBUTE10),
              ATTRIBUTE11 = decode( l_inv_loc_assignment.ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, l_inv_loc_assignment.ATTRIBUTE11),
              ATTRIBUTE12 = decode( l_inv_loc_assignment.ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, l_inv_loc_assignment.ATTRIBUTE12),
              ATTRIBUTE13 = decode( l_inv_loc_assignment.ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, l_inv_loc_assignment.ATTRIBUTE13),
              ATTRIBUTE14 = decode( l_inv_loc_assignment.ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, l_inv_loc_assignment.ATTRIBUTE14),
              ATTRIBUTE15 = decode( l_inv_loc_assignment.ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, l_inv_loc_assignment.ATTRIBUTE15)
    where CSP_INV_LOC_ASSIGNMENT_ID = l_inv_loc_assignment.CSP_INV_LOC_ASSIGNMENT_ID;

Line: 419


                                      'Update_Row',
                                      'A', 'C')  THEN
    csp_inv_loc_assignments_cuhk.update_inventory_location_post
                ( px_inv_loc_assignment     => l_inv_loc_assignment ,
                  x_return_status          => l_return_status,
                  x_msg_count              => l_msg_count,
                  x_msg_data               => l_msg_data
                ) ;

Line: 439


                                      'Update_Row',
                                      'A', 'V')  THEN
    csp_inv_loc_assignments_vuhk.update_inventory_location_Post
                ( px_inv_loc_assignment     => l_inv_loc_assignment ,
                  x_return_status          => l_return_status,
                  x_msg_count              => l_msg_count,
                  x_msg_data               => l_msg_data
                ) ;

Line: 456


    csp_inv_loc_assignments_iuhk.update_inventory_location_post
                ( x_return_status          => l_return_status
                ) ;

Line: 467


END Update_Row;

Line: 469


PROCEDURE Delete_Row(
    p_CSP_INV_LOC_ASSIGNMENT_ID  NUMBER)
 IS
     l_inv_loc_assignment_id NUMBER;

Line: 476


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

Line: 480


                                      'Delete_Row',
                                      'B', 'C')  THEN
    csp_inv_loc_assignments_cuhk.delete_inventory_location_pre
                ( p_inv_loc_assignment_id     => p_CSP_INV_LOC_ASSIGNMENT_ID ,
                  x_return_status          => l_return_status,
                  x_msg_count              => l_msg_count,
                  x_msg_data               => l_msg_data
                ) ;

Line: 500


                                      'Update_Row',
                                      'B', 'V')  THEN
    csp_inv_loc_assignments_vuhk.delete_inventory_location_pre
                ( p_inv_loc_assignment_id     => p_CSP_INV_LOC_ASSIGNMENT_ID ,
                  x_return_status          => l_return_status,
                  x_msg_count              => l_msg_count,
                  x_msg_data               => l_msg_data
                ) ;

Line: 517


    csp_inv_loc_assignments_iuhk.delete_inventory_location_Pre
                ( x_return_status          => l_return_status
                ) ;

Line: 529


   DELETE FROM CSP_INV_LOC_ASSIGNMENTS
    WHERE CSP_INV_LOC_ASSIGNMENT_ID = p_CSP_INV_LOC_ASSIGNMENT_ID;

Line: 536


                                      'Delete_Row',
                                      'A', 'C')  THEN
    csp_inv_loc_assignments_cuhk.delete_inventory_location_post
                ( p_inv_loc_assignment_id     => p_CSP_INV_LOC_ASSIGNMENT_ID ,
                  x_return_status          => l_return_status,
                  x_msg_count              => l_msg_count,
                  x_msg_data               => l_msg_data
                ) ;

Line: 556


                                      'Delete_Row',
                                      'A', 'V')  THEN
    csp_inv_loc_assignments_vuhk.delete_inventory_location_Post
                ( p_inv_loc_assignment_id    => p_CSP_INV_LOC_ASSIGNMENT_ID ,
                  x_return_status          => l_return_status,
                  x_msg_count              => l_msg_count,
                  x_msg_data               => l_msg_data
                ) ;

Line: 574


  csp_inv_loc_assignments_iuhk.delete_inventory_location_post
                ( x_return_status          => l_return_status
                ) ;

Line: 586


 END Delete_Row;

Line: 592


          p_LAST_UPDATED_BY    NUMBER,
          p_LAST_UPDATE_DATE    DATE,
          p_LAST_UPDATE_LOGIN    NUMBER,
          p_RESOURCE_ID    NUMBER,
          p_ORGANIZATION_ID    NUMBER,
          p_SUBINVENTORY_CODE    VARCHAR2,
          p_LOCATOR_ID    NUMBER,
          p_RESOURCE_TYPE    VARCHAR2,
          p_EFFECTIVE_DATE_START    DATE,
          p_EFFECTIVE_DATE_END    DATE,
          p_DEFAULT_CODE    VARCHAR2,
          p_ATTRIBUTE_CATEGORY    VARCHAR2,
          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)

 IS
   CURSOR C IS
        SELECT *
         FROM CSP_INV_LOC_ASSIGNMENTS
        WHERE CSP_INV_LOC_ASSIGNMENT_ID =  p_CSP_INV_LOC_ASSIGNMENT_ID
        FOR UPDATE of CSP_INV_LOC_ASSIGNMENT_ID NOWAIT;

Line: 632


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

Line: 644


       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.RESOURCE_ID = p_RESOURCE_ID)
            OR (    ( Recinfo.RESOURCE_ID IS NULL )
                AND (  p_RESOURCE_ID IS NULL )))
       AND (    ( Recinfo.ORGANIZATION_ID = p_ORGANIZATION_ID)
            OR (    ( Recinfo.ORGANIZATION_ID IS NULL )
                AND (  p_ORGANIZATION_ID IS NULL )))
       AND (    ( Recinfo.SUBINVENTORY_CODE = p_SUBINVENTORY_CODE)
            OR (    ( Recinfo.SUBINVENTORY_CODE IS NULL )
                AND (  p_SUBINVENTORY_CODE IS NULL )))
       AND (    ( Recinfo.LOCATOR_ID = p_LOCATOR_ID)
            OR (    ( Recinfo.LOCATOR_ID IS NULL )
                AND (  p_LOCATOR_ID IS NULL )))
       AND (    ( Recinfo.RESOURCE_TYPE = p_RESOURCE_TYPE)
            OR (    ( Recinfo.RESOURCE_TYPE IS NULL )
                AND (  p_RESOURCE_TYPE IS NULL )))
       AND (    ( Recinfo.EFFECTIVE_DATE_START = p_EFFECTIVE_DATE_START)
            OR (    ( Recinfo.EFFECTIVE_DATE_START IS NULL )
                AND (  p_EFFECTIVE_DATE_START IS NULL )))
       AND (    ( Recinfo.EFFECTIVE_DATE_END = p_EFFECTIVE_DATE_END)
            OR (    ( Recinfo.EFFECTIVE_DATE_END IS NULL )
                AND (  p_EFFECTIVE_DATE_END IS NULL )))
       AND (    ( Recinfo.DEFAULT_CODE = p_DEFAULT_CODE)
            OR (    ( Recinfo.DEFAULT_CODE IS NULL )
                AND (  p_DEFAULT_CODE IS NULL )))
       AND (    ( Recinfo.ATTRIBUTE_CATEGORY = p_ATTRIBUTE_CATEGORY)
            OR (    ( Recinfo.ATTRIBUTE_CATEGORY IS NULL )
                AND (  p_ATTRIBUTE_CATEGORY 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 )))
       ) then
       return;