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

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

Line: 139


      CSP_PACKLIST_HEADERS_PKG.Insert_Row(
          px_PACKLIST_HEADER_ID  => x_PACKLIST_HEADER_ID,
          p_CREATED_BY  => p_PLH_rec.CREATED_BY,
          p_CREATION_DATE  => p_PLH_rec.CREATION_DATE,
          p_LAST_UPDATED_BY  => p_PLH_rec.LAST_UPDATED_BY,
          p_LAST_UPDATE_DATE  => p_PLH_rec.LAST_UPDATE_DATE,
          p_LAST_UPDATE_LOGIN  => p_PLH_rec.LAST_UPDATE_LOGIN,
          p_ORGANIZATION_ID  => p_PLH_rec.ORGANIZATION_ID,
          p_PACKLIST_NUMBER  => p_PLH_rec.PACKLIST_NUMBER,
          p_SUBINVENTORY_CODE  => p_PLH_rec.SUBINVENTORY_CODE,
          p_PACKLIST_STATUS  => p_PLH_rec.PACKLIST_STATUS,
          p_DATE_CREATED  => p_PLH_rec.DATE_CREATED,
          p_DATE_PACKED  => p_PLH_rec.DATE_PACKED,
          p_DATE_SHIPPED  => p_PLH_rec.DATE_SHIPPED,
          p_DATE_RECEIVED  => p_PLH_rec.DATE_RECEIVED,
          p_CARRIER  => p_PLH_rec.CARRIER,
          p_SHIPMENT_METHOD  => p_PLH_rec.SHIPMENT_METHOD,
          p_WAYBILL  => p_PLH_rec.WAYBILL,
          p_COMMENTS  => p_PLH_rec.COMMENTS,
          p_LOCATION_ID  => p_PLH_rec.LOCATION_ID,
          p_PARTY_SITE_ID  => p_PLH_rec.PARTY_SITE_ID,
          p_ATTRIBUTE_CATEGORY  => p_PLH_rec.ATTRIBUTE_CATEGORY,
          p_ATTRIBUTE1  => p_PLH_rec.ATTRIBUTE1,
          p_ATTRIBUTE2  => p_PLH_rec.ATTRIBUTE2,
          p_ATTRIBUTE3  => p_PLH_rec.ATTRIBUTE3,
          p_ATTRIBUTE4  => p_PLH_rec.ATTRIBUTE4,
          p_ATTRIBUTE5  => p_PLH_rec.ATTRIBUTE5,
          p_ATTRIBUTE6  => p_PLH_rec.ATTRIBUTE6,
          p_ATTRIBUTE7  => p_PLH_rec.ATTRIBUTE7,
          p_ATTRIBUTE8  => p_PLH_rec.ATTRIBUTE8,
          p_ATTRIBUTE9  => p_PLH_rec.ATTRIBUTE9,
          p_ATTRIBUTE10  => p_PLH_rec.ATTRIBUTE10,
          p_ATTRIBUTE11  => p_PLH_rec.ATTRIBUTE11,
          p_ATTRIBUTE12  => p_PLH_rec.ATTRIBUTE12,
          p_ATTRIBUTE13  => p_PLH_rec.ATTRIBUTE13,
          p_ATTRIBUTE14  => p_PLH_rec.ATTRIBUTE14,
          p_ATTRIBUTE15  => p_PLH_rec.ATTRIBUTE15);

Line: 255


PROCEDURE Update_packlist_headers(
    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_Identity_Salesforce_Id     IN   NUMBER       := NULL,
    P_PLH_Rec     IN    PLH_Rec_Type,
    X_Return_Status              OUT NOCOPY  VARCHAR2,
    X_Msg_Count                  OUT NOCOPY  NUMBER,
    X_Msg_Data                   OUT NOCOPY  VARCHAR2
    )

 IS
/*
Cursor C_Get_packlist_headers(PACKLIST_HEADER_ID Number) IS
    Select rowid,
           PACKLIST_HEADER_ID,
           CREATED_BY,
           CREATION_DATE,
           LAST_UPDATED_BY,
           LAST_UPDATE_DATE,
           LAST_UPDATE_LOGIN,
           ORGANIZATION_ID,
           PACKLIST_NUMBER,
           SUBINVENTORY_CODE,
           PACKLIST_STATUS,
           DATE_CREATED,
           DATE_PACKED,
           DATE_SHIPPED,
           DATE_RECEIVED,
           CARRIER,
           SHIPMENT_METHOD,
           WAYBILL,
           COMMENTS,
           LOCATION_ID,
           ATTRIBUTE_CATEGORY,
           ATTRIBUTE1,
           ATTRIBUTE2,
           ATTRIBUTE3,
           ATTRIBUTE4,
           ATTRIBUTE5,
           ATTRIBUTE6,
           ATTRIBUTE7,
           ATTRIBUTE8,
           ATTRIBUTE9,
           ATTRIBUTE10,
           ATTRIBUTE11,
           ATTRIBUTE12,
           ATTRIBUTE13,
           ATTRIBUTE14,
           ATTRIBUTE15
    From  CSP_PACKLIST_HEADERS
    -- Hint: Developer need to provide Where clause
    For Update NOWAIT;

Line: 310


l_api_name                CONSTANT VARCHAR2(30) := 'Update_packlist_headers';

Line: 319


      SAVEPOINT UPDATE_Packlist_Headers_PVT;

Line: 352


          AS_CALLOUT_PKG.Update_packlist_headers_BU(
                  p_api_version_number => 1.0,
                  p_init_msg_list        =>  FND_API.G_FALSE,
                  p_commit               =>  FND_API.G_FALSE,
                  p_validation_level     =>  p_validation_level,
                  p_identity_salesforce_id => p_identity_salesforce_id,
                  P_PLH_Rec      =>  P_PLH_Rec,
          -- Hint: Add detail tables as parameter lists if it's master-detail relationship.
                  x_return_status        =>  x_return_status,
                  x_msg_count            =>  x_msg_count,
                  x_msg_data             =>  x_msg_data);

Line: 379


      JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: - Open Cursor to Select');

Line: 389


               l_ref_PLH_rec.LAST_UPDATED_BY,
               l_ref_PLH_rec.LAST_UPDATE_DATE,
               l_ref_PLH_rec.LAST_UPDATE_LOGIN,
               l_ref_PLH_rec.ORGANIZATION_ID,
               l_ref_PLH_rec.PACKLIST_NUMBER,
               l_ref_PLH_rec.SUBINVENTORY_CODE,
               l_ref_PLH_rec.PACKLIST_STATUS,
               l_ref_PLH_rec.DATE_CREATED,
               l_ref_PLH_rec.DATE_PACKED,
               l_ref_PLH_rec.DATE_SHIPPED,
               l_ref_PLH_rec.DATE_RECEIVED,
               l_ref_PLH_rec.CARRIER,
               l_ref_PLH_rec.SHIPMENT_METHOD,
               l_ref_PLH_rec.WAYBILL,
               l_ref_PLH_rec.COMMENTS,
               l_ref_PLH_rec.LOCATION_ID,
               l_ref_PLH_rec.ATTRIBUTE_CATEGORY,
               l_ref_PLH_rec.ATTRIBUTE1,
               l_ref_PLH_rec.ATTRIBUTE2,
               l_ref_PLH_rec.ATTRIBUTE3,
               l_ref_PLH_rec.ATTRIBUTE4,
               l_ref_PLH_rec.ATTRIBUTE5,
               l_ref_PLH_rec.ATTRIBUTE6,
               l_ref_PLH_rec.ATTRIBUTE7,
               l_ref_PLH_rec.ATTRIBUTE8,
               l_ref_PLH_rec.ATTRIBUTE9,
               l_ref_PLH_rec.ATTRIBUTE10,
               l_ref_PLH_rec.ATTRIBUTE11,
               l_ref_PLH_rec.ATTRIBUTE12,
               l_ref_PLH_rec.ATTRIBUTE13,
               l_ref_PLH_rec.ATTRIBUTE14,
               l_ref_PLH_rec.ATTRIBUTE15;

Line: 425


               FND_MESSAGE.Set_Name('CSP', 'API_MISSING_UPDATE_TARGET');

Line: 437


      If (l_tar_PLH_rec.last_update_date is NULL or
          l_tar_PLH_rec.last_update_date = FND_API.G_MISS_Date ) Then
          IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
          THEN
              FND_MESSAGE.Set_Name('CSP', 'API_MISSING_ID');

Line: 442


              FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);

Line: 449


      If (l_tar_PLH_rec.last_update_date <> l_ref_PLH_rec.last_update_date) Then
          IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
          THEN

              FND_MESSAGE.Set_Name('CSP', 'API_RECORD_CHANGED');

Line: 469


              p_validation_mode  => JTF_PLSQL_API.G_UPDATE,
              P_PLH_Rec  =>  P_PLH_Rec,
              x_return_status    => x_return_status,
              x_msg_count        => x_msg_count,
              x_msg_data         => x_msg_data);

Line: 483


      JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Calling update table handler');

Line: 486


      CSP_PACKLIST_HEADERS_PKG.Update_Row(
          p_PACKLIST_HEADER_ID  => p_PLH_rec.PACKLIST_HEADER_ID,
          p_CREATED_BY  => p_PLH_rec.CREATED_BY,
          p_CREATION_DATE  => p_PLH_rec.CREATION_DATE,
          p_LAST_UPDATED_BY  => p_PLH_rec.LAST_UPDATED_BY,
          p_LAST_UPDATE_DATE  => p_PLH_rec.LAST_UPDATE_DATE,
          p_LAST_UPDATE_LOGIN  => p_PLH_rec.LAST_UPDATE_LOGIN,
          p_ORGANIZATION_ID  => p_PLH_rec.ORGANIZATION_ID,
          p_PACKLIST_NUMBER  => p_PLH_rec.PACKLIST_NUMBER,
          p_SUBINVENTORY_CODE  => p_PLH_rec.SUBINVENTORY_CODE,
          p_PACKLIST_STATUS  => p_PLH_rec.PACKLIST_STATUS,
          p_DATE_CREATED  => p_PLH_rec.DATE_CREATED,
          p_DATE_PACKED  => p_PLH_rec.DATE_PACKED,
          p_DATE_SHIPPED  => p_PLH_rec.DATE_SHIPPED,
          p_DATE_RECEIVED  => p_PLH_rec.DATE_RECEIVED,
          p_CARRIER  => p_PLH_rec.CARRIER,
          p_SHIPMENT_METHOD  => p_PLH_rec.SHIPMENT_METHOD,
          p_WAYBILL  => p_PLH_rec.WAYBILL,
          p_COMMENTS  => p_PLH_rec.COMMENTS,
          p_LOCATION_ID  => p_PLH_rec.LOCATION_ID,
          p_PARTY_SITE_ID  => p_PLH_rec.PARTY_SITE_ID,
          p_ATTRIBUTE_CATEGORY  => p_PLH_rec.ATTRIBUTE_CATEGORY,
          p_ATTRIBUTE1  => p_PLH_rec.ATTRIBUTE1,
          p_ATTRIBUTE2  => p_PLH_rec.ATTRIBUTE2,
          p_ATTRIBUTE3  => p_PLH_rec.ATTRIBUTE3,
          p_ATTRIBUTE4  => p_PLH_rec.ATTRIBUTE4,
          p_ATTRIBUTE5  => p_PLH_rec.ATTRIBUTE5,
          p_ATTRIBUTE6  => p_PLH_rec.ATTRIBUTE6,
          p_ATTRIBUTE7  => p_PLH_rec.ATTRIBUTE7,
          p_ATTRIBUTE8  => p_PLH_rec.ATTRIBUTE8,
          p_ATTRIBUTE9  => p_PLH_rec.ATTRIBUTE9,
          p_ATTRIBUTE10  => p_PLH_rec.ATTRIBUTE10,
          p_ATTRIBUTE11  => p_PLH_rec.ATTRIBUTE11,
          p_ATTRIBUTE12  => p_PLH_rec.ATTRIBUTE12,
          p_ATTRIBUTE13  => p_PLH_rec.ATTRIBUTE13,
          p_ATTRIBUTE14  => p_PLH_rec.ATTRIBUTE14,
          p_ATTRIBUTE15  => p_PLH_rec.ATTRIBUTE15);

Line: 548


          AS_CALLOUT_PKG.Update_packlist_headers_AU(
                  p_api_version_number => 1.0,
                  p_init_msg_list        =>  FND_API.G_FALSE,
                  p_commit               =>  FND_API.G_FALSE,
                  p_validation_level     =>  p_validation_level,
                  p_identity_salesforce_id => p_identity_salesforce_id,
                  P_PLH_Rec      =>  P_PLH_Rec,
          -- Hint: Add detail tables as parameter lists if it's master-detail relationship.
                  x_return_status        =>  x_return_status,
                  x_msg_count            =>  x_msg_count,
                  x_msg_data             =>  x_msg_data);

Line: 591


End Update_packlist_headers;

Line: 596


PROCEDURE Delete_packlist_headers(
    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_identity_salesforce_id     IN   NUMBER       := NULL,
    P_PLH_Rec     IN PLH_Rec_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_packlist_headers';

Line: 614


      SAVEPOINT DELETE_Packlist_Headers_PVT;

Line: 648


          AS_CALLOUT_PKG.Delete_packlist_headers_BD(
                  p_api_version_number => 1.0,
                  p_init_msg_list        =>  FND_API.G_FALSE,
                  p_commit               =>  FND_API.G_FALSE,
                  p_validation_level     =>  p_validation_level,
                  p_identity_salesforce_id => p_identity_salesforce_id,
                  P_PLH_Rec      =>  P_PLH_Rec,
          -- Hint: Add detail tables as parameter lists if it's master-detail relationship.
                  x_return_status        =>  x_return_status,
                  x_msg_count            =>  x_msg_count,
                  x_msg_data             =>  x_msg_data);

Line: 675


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

Line: 678


      CSP_PACKLIST_HEADERS_PKG.Delete_Row(
          p_PACKLIST_HEADER_ID  => p_PLH_rec.PACKLIST_HEADER_ID);

Line: 706


          AS_CALLOUT_PKG.Delete_packlist_headers_AD(
                  p_api_version_number => 1.0,
                  p_init_msg_list        =>  FND_API.G_FALSE,
                  p_commit               =>  FND_API.G_FALSE,
                  p_validation_level     =>  p_validation_level,
                  p_identity_salesforce_id => p_identity_salesforce_id,
                  P_PLH_Rec      =>  P_PLH_Rec,
          -- Hint: Add detail tables as parameter lists if it's master-detail relationship.
                  x_return_status        =>  x_return_status,
                  x_msg_count            =>  x_msg_count,
                  x_msg_data             =>  x_msg_data);

Line: 749


End Delete_packlist_headers;

Line: 913


PROCEDURE Gen_Select(
    x_select_cl   OUT NOCOPY   VARCHAR2
)
IS
BEGIN
      -- Debug Message
      JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Generate Select Begins');

Line: 921


      x_select_cl := 'Select ' ||
                'CSP_PACKLIST_HEADERS_V.ROW_ID,' ||
                'CSP_PACKLIST_HEADERS_V.PACKLIST_HEADER_ID,' ||
                'CSP_PACKLIST_HEADERS_V.CREATED_BY,' ||
                'CSP_PACKLIST_HEADERS_V.CREATION_DATE,' ||
                'CSP_PACKLIST_HEADERS_V.LAST_UPDATED_BY,' ||
                'CSP_PACKLIST_HEADERS_V.LAST_UPDATE_DATE,' ||
                'CSP_PACKLIST_HEADERS_V.LAST_UPDATE_LOGIN,' ||
                'CSP_PACKLIST_HEADERS_V.ORGANIZATION_ID,' ||
                'CSP_PACKLIST_HEADERS_V.PACKLIST_NUMBER,' ||
                'CSP_PACKLIST_HEADERS_V.SUBINVENTORY_CODE,' ||
                'CSP_PACKLIST_HEADERS_V.PACKLIST_STATUS,' ||
                'CSP_PACKLIST_HEADERS_V.DATE_CREATED,' ||
                'CSP_PACKLIST_HEADERS_V.DATE_PACKED,' ||
                'CSP_PACKLIST_HEADERS_V.DATE_SHIPPED,' ||
                'CSP_PACKLIST_HEADERS_V.DATE_RECEIVED,' ||
                'CSP_PACKLIST_HEADERS_V.CARRIER,' ||
                'CSP_PACKLIST_HEADERS_V.SHIPMENT_METHOD,' ||
                'CSP_PACKLIST_HEADERS_V.WAYBILL,' ||
                'CSP_PACKLIST_HEADERS_V.COMMENTS,' ||
                'CSP_PACKLIST_HEADERS_V.LOCATION_ID,' ||
                'CSP_PACKLIST_HEADERS_V.PARTY_SITE_ID,' ||
                'CSP_PACKLIST_HEADERS_V.ATTRIBUTE_CATEGORY,' ||
                'CSP_PACKLIST_HEADERS_V.ATTRIBUTE1,' ||
                'CSP_PACKLIST_HEADERS_V.ATTRIBUTE2,' ||
                'CSP_PACKLIST_HEADERS_V.ATTRIBUTE3,' ||
                'CSP_PACKLIST_HEADERS_V.ATTRIBUTE4,' ||
                'CSP_PACKLIST_HEADERS_V.ATTRIBUTE5,' ||
                'CSP_PACKLIST_HEADERS_V.ATTRIBUTE6,' ||
                'CSP_PACKLIST_HEADERS_V.ATTRIBUTE7,' ||
                'CSP_PACKLIST_HEADERS_V.ATTRIBUTE8,' ||
                'CSP_PACKLIST_HEADERS_V.ATTRIBUTE9,' ||
                'CSP_PACKLIST_HEADERS_V.ATTRIBUTE10,' ||
                'CSP_PACKLIST_HEADERS_V.ATTRIBUTE11,' ||
                'CSP_PACKLIST_HEADERS_V.ATTRIBUTE12,' ||
                'CSP_PACKLIST_HEADERS_V.ATTRIBUTE13,' ||
                'CSP_PACKLIST_HEADERS_V.ATTRIBUTE14,' ||
                'CSP_PACKLIST_HEADERS_V.ATTRIBUTE15,' ||
                'from CSP_PACKLIST_HEADERS_V';

Line: 961


      JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Generate Select Ends');

Line: 963


END Gen_Select;

Line: 973


    SELECT INSTR(p_rec_item, '%', 1, 1)
    FROM DUAL;

Line: 976


    SELECT INSTR(p_rec_item, '_', 1, 1)
    FROM DUAL;

Line: 1113


      ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
      THEN
          -- Hint: Validate data
          -- IF p_PACKLIST_HEADER_ID <> G_MISS_CHAR
          -- verify if data is valid
          -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;

Line: 1168


      ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
      THEN
          -- Hint: Validate data
          -- IF p_ORGANIZATION_ID <> G_MISS_CHAR
          -- verify if data is valid
          -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;

Line: 1223


      ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
      THEN
          -- Hint: Validate data
          -- IF p_PACKLIST_NUMBER <> G_MISS_CHAR
          -- verify if data is valid
          -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;

Line: 1278


      ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
      THEN
          -- Hint: Validate data
          -- IF p_SUBINVENTORY_CODE <> G_MISS_CHAR
          -- verify if data is valid
          -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;

Line: 1333


      ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
      THEN
          -- Hint: Validate data
          -- IF p_PACKLIST_STATUS <> G_MISS_CHAR
          -- verify if data is valid
          -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;

Line: 1388


      ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
      THEN
          -- Hint: Validate data
          -- IF p_DATE_CREATED <> G_MISS_CHAR
          -- verify if data is valid
          -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;

Line: 1435


      ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
      THEN
          -- Hint: Validate data
          -- IF p_DATE_PACKED <> G_MISS_CHAR
          -- verify if data is valid
          -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;

Line: 1482


      ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
      THEN
          -- Hint: Validate data
          -- IF p_DATE_SHIPPED <> G_MISS_CHAR
          -- verify if data is valid
          -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;

Line: 1529


      ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
      THEN
          -- Hint: Validate data
          -- IF p_DATE_RECEIVED <> G_MISS_CHAR
          -- verify if data is valid
          -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;

Line: 1576


      ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
      THEN
          -- Hint: Validate data
          -- IF p_CARRIER <> G_MISS_CHAR
          -- verify if data is valid
          -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;

Line: 1623


      ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
      THEN
          -- Hint: Validate data
          -- IF p_SHIPMENT_METHOD <> G_MISS_CHAR
          -- verify if data is valid
          -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;

Line: 1670


      ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
      THEN
          -- Hint: Validate data
          -- IF p_WAYBILL <> G_MISS_CHAR
          -- verify if data is valid
          -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;

Line: 1717


      ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
      THEN
          -- Hint: Validate data
          -- IF p_COMMENTS <> G_MISS_CHAR
          -- verify if data is valid
          -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;