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

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

Line: 151


      IEX_REPOSSESSIONS_PKG.Insert_Row(
          px_REPOSSESSION_ID  => x_REPOSSESSION_ID
         ,p_DELINQUENCY_ID  => p_RPS_rec.DELINQUENCY_ID
         ,p_PARTY_ID  => p_RPS_rec.PARTY_ID
         ,p_CUST_ACCOUNT_ID  => p_RPS_rec.CUST_ACCOUNT_ID
         ,p_UNPAID_REASON_CODE  => p_RPS_rec.UNPAID_REASON_CODE
         ,p_REMARKET_FLAG  => p_RPS_rec.REMARKET_FLAG
         ,p_REPOSSESSION_DATE  => p_RPS_rec.REPOSSESSION_DATE
         ,p_ASSET_ID  => p_RPS_rec.ASSET_ID
         ,p_ASSET_VALUE  => p_RPS_rec.ASSET_VALUE
         ,p_ASSET_NUMBER  => p_RPS_rec.ASSET_NUMBER
         ,p_REQUEST_ID  => p_RPS_rec.REQUEST_ID
         ,p_PROGRAM_APPLICATION_ID  => p_RPS_rec.PROGRAM_APPLICATION_ID
         ,p_PROGRAM_ID  => p_RPS_rec.PROGRAM_ID
         ,p_PROGRAM_UPDATE_DATE  => p_RPS_rec.PROGRAM_UPDATE_DATE
         ,p_ATTRIBUTE_CATEGORY  => p_RPS_rec.ATTRIBUTE_CATEGORY
         ,p_ATTRIBUTE1  => p_RPS_rec.ATTRIBUTE1
         ,p_ATTRIBUTE2  => p_RPS_rec.ATTRIBUTE2
         ,p_ATTRIBUTE3  => p_RPS_rec.ATTRIBUTE3
         ,p_ATTRIBUTE4  => p_RPS_rec.ATTRIBUTE4
         ,p_ATTRIBUTE5  => p_RPS_rec.ATTRIBUTE5
         ,p_ATTRIBUTE6  => p_RPS_rec.ATTRIBUTE6
         ,p_ATTRIBUTE7  => p_RPS_rec.ATTRIBUTE7
         ,p_ATTRIBUTE8  => p_RPS_rec.ATTRIBUTE8
         ,p_ATTRIBUTE9  => p_RPS_rec.ATTRIBUTE9
         ,p_ATTRIBUTE10  => p_RPS_rec.ATTRIBUTE10
         ,p_ATTRIBUTE11  => p_RPS_rec.ATTRIBUTE11
         ,p_ATTRIBUTE12  => p_RPS_rec.ATTRIBUTE12
         ,p_ATTRIBUTE13  => p_RPS_rec.ATTRIBUTE13
         ,p_ATTRIBUTE14  => p_RPS_rec.ATTRIBUTE14
         ,p_ATTRIBUTE15  => p_RPS_rec.ATTRIBUTE15
         ,p_CREATED_BY  => FND_GLOBAL.USER_ID
         ,p_CREATION_DATE  => SYSDATE
         ,p_LAST_UPDATED_BY  => FND_GLOBAL.USER_ID
         ,p_LAST_UPDATE_DATE  => SYSDATE
         --,p_LAST_UPDATE_LOGIN  => FND_GLOBAL.CONC_LOGIN_ID   --commented for bug 10034220 gnramasa 24th Sep 10
	 ,p_LAST_UPDATE_LOGIN  => FND_GLOBAL.USER_ID
         ,p_CREDIT_HOLD_REQUEST_FLAG  => p_RPS_rec.CREDIT_HOLD_REQUEST_FLAG
         ,p_CREDIT_HOLD_APPROVED_FLAG  => p_RPS_rec.CREDIT_HOLD_APPROVED_FLAG
         ,p_SERVICE_HOLD_REQUEST_FLAG  => p_RPS_rec.SERVICE_HOLD_REQUEST_FLAG
         ,p_SERVICE_HOLD_APPROVED_FLAG  => p_RPS_rec.SERVICE_HOLD_APPROVED_FLAG
         ,p_SUGGESTION_APPROVED_FLAG  => p_RPS_rec.SUGGESTION_APPROVED_FLAG
         ,p_DISPOSITION_CODE          => P_RPS_REC.DISPOSITION_CODE
         ,p_CUSTOMER_SITE_USE_ID      => p_rps_rec.CUSTOMER_SITE_USE_ID
         ,p_ORG_ID                    => p_rps_rec.ORG_ID
         ,p_CONTRACT_ID               => p_rps_rec.CONTRACT_ID
         ,p_CONTRACT_NUMBER           => p_rps_rec.CONTRACT_NUMBER
         );

Line: 260


PROCEDURE Update_repossession(
    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_Check_Access_Flag          IN   VARCHAR2   := FND_API.G_FALSE,
    P_Admin_Flag                 IN   VARCHAR2   := FND_API.G_FALSE,
    P_Admin_Group_Id             IN   NUMBER,
    P_Identity_Salesforce_Id     IN   NUMBER,
    --P_profile_tbl                IN   AS_UTILITY_PUB.PROFILE_TBL_TYPE,
    P_RPS_Rec     IN    RPS_Rec_Type,
    X_Return_Status              OUT NOCOPY  VARCHAR2,
    X_Msg_Count                  OUT NOCOPY  NUMBER,
    X_Msg_Data                   OUT NOCOPY  VARCHAR2
    )

 IS
/*
Cursor C_Get_repossession(REPOSSESSION_ID Number) IS
    Select rowid,
           REPOSSESSION_ID,
           DELINQUENCY_ID,
           PARTY_ID,
           CUST_ACCOUNT_ID,
           UNPAID_REASON_CODE,
           REMARKET_FLAG,
           REPOSSESSION_DATE,
           ASSET_ID,
           ASSET_VALUE,
           ASSET_NUMBER,
           REQUEST_ID,
           PROGRAM_APPLICATION_ID,
           PROGRAM_ID,
           PROGRAM_UPDATE_DATE,
           ATTRIBUTE_CATEGORY,
           ATTRIBUTE1,
           ATTRIBUTE2,
           ATTRIBUTE3,
           ATTRIBUTE4,
           ATTRIBUTE5,
           ATTRIBUTE6,
           ATTRIBUTE7,
           ATTRIBUTE8,
           ATTRIBUTE9,
           ATTRIBUTE10,
           ATTRIBUTE11,
           ATTRIBUTE12,
           ATTRIBUTE13,
           ATTRIBUTE14,
           ATTRIBUTE15,
           CREATED_BY,
           CREATION_DATE,
           LAST_UPDATED_BY,
           LAST_UPDATE_DATE,
           LAST_UPDATE_LOGIN,
           CREDIT_HOLD_REQUEST_FLAG,
           CREDIT_HOLD_APPROVED_FLAG,
           SERVICE_HOLD_REQUEST_FLAG,
           SERVICE_HOLD_APPROVED_FLAG,
           SUGGESTION_APPROVED_FLAG,
           DISPOSITION_CODE
    From  IEX_REPOSSESSIONS
    -- Hint: Developer need to provide Where clause
    For Update NOWAIT;

Line: 325


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

Line: 334


      SAVEPOINT UPDATE_REPOSSESSION_PVT;

Line: 398


               l_ref_RPS_rec.PROGRAM_UPDATE_DATE,
               l_ref_RPS_rec.ATTRIBUTE_CATEGORY,
               l_ref_RPS_rec.ATTRIBUTE1,
               l_ref_RPS_rec.ATTRIBUTE2,
               l_ref_RPS_rec.ATTRIBUTE3,
               l_ref_RPS_rec.ATTRIBUTE4,
               l_ref_RPS_rec.ATTRIBUTE5,
               l_ref_RPS_rec.ATTRIBUTE6,
               l_ref_RPS_rec.ATTRIBUTE7,
               l_ref_RPS_rec.ATTRIBUTE8,
               l_ref_RPS_rec.ATTRIBUTE9,
               l_ref_RPS_rec.ATTRIBUTE10,
               l_ref_RPS_rec.ATTRIBUTE11,
               l_ref_RPS_rec.ATTRIBUTE12,
               l_ref_RPS_rec.ATTRIBUTE13,
               l_ref_RPS_rec.ATTRIBUTE14,
               l_ref_RPS_rec.ATTRIBUTE15,
               l_ref_RPS_rec.CREATED_BY,
               l_ref_RPS_rec.CREATION_DATE,
               l_ref_RPS_rec.LAST_UPDATED_BY,
               l_ref_RPS_rec.LAST_UPDATE_DATE,
               l_ref_RPS_rec.LAST_UPDATE_LOGIN,
               l_ref_RPS_rec.CREDIT_HOLD_REQUEST_FLAG,
               l_ref_RPS_rec.CREDIT_HOLD_APPROVED_FLAG,
               l_ref_RPS_rec.SERVICE_HOLD_REQUEST_FLAG,
               l_ref_RPS_rec.SERVICE_HOLD_APPROVED_FLAG,
               l_ref_RPS_rec.SUGGESTION_APPROVED_FLAG,
               l_ref_rps_rec.DISPOSITION_CODE;

Line: 430


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

Line: 441


      If (l_tar_RPS_rec.last_update_date is NULL or
          l_tar_RPS_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('IEX', 'API_MISSING_ID');

Line: 446


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

Line: 453


      If (l_tar_RPS_rec.last_update_date <> l_ref_RPS_rec.last_update_date) Then
          IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
          THEN
              FND_MESSAGE.Set_Name('IEX', 'API_RECORD_CHANGED');

Line: 468


          p_validation_mode  => AS_UTILITY_PVT.G_UPDATE,
          P_RPS_Rec  =>  P_RPS_Rec,
          x_return_status    => x_return_status,
          x_msg_count        => x_msg_count,
          x_msg_data         => x_msg_data);

Line: 511


      IEX_REPOSSESSIONS_PKG.Update_Row(
          p_REPOSSESSION_ID  => p_RPS_rec.REPOSSESSION_ID
         ,p_DELINQUENCY_ID  => p_RPS_rec.DELINQUENCY_ID
         ,p_PARTY_ID  => p_RPS_rec.PARTY_ID
         ,p_CUST_ACCOUNT_ID  => p_RPS_rec.CUST_ACCOUNT_ID
         ,p_UNPAID_REASON_CODE  => p_RPS_rec.UNPAID_REASON_CODE
         ,p_REMARKET_FLAG  => p_RPS_rec.REMARKET_FLAG
         ,p_REPOSSESSION_DATE  => p_RPS_rec.REPOSSESSION_DATE
         ,p_ASSET_ID  => p_RPS_rec.ASSET_ID
         ,p_ASSET_VALUE  => p_RPS_rec.ASSET_VALUE
         ,p_ASSET_NUMBER  => p_RPS_rec.ASSET_NUMBER
         ,p_REQUEST_ID  => p_RPS_rec.REQUEST_ID
         ,p_PROGRAM_APPLICATION_ID  => p_RPS_rec.PROGRAM_APPLICATION_ID
         ,p_PROGRAM_ID  => p_RPS_rec.PROGRAM_ID
         ,p_PROGRAM_UPDATE_DATE  => p_RPS_rec.PROGRAM_UPDATE_DATE
         ,p_ATTRIBUTE_CATEGORY  => p_RPS_rec.ATTRIBUTE_CATEGORY
         ,p_ATTRIBUTE1  => p_RPS_rec.ATTRIBUTE1
         ,p_ATTRIBUTE2  => p_RPS_rec.ATTRIBUTE2
         ,p_ATTRIBUTE3  => p_RPS_rec.ATTRIBUTE3
         ,p_ATTRIBUTE4  => p_RPS_rec.ATTRIBUTE4
         ,p_ATTRIBUTE5  => p_RPS_rec.ATTRIBUTE5
         ,p_ATTRIBUTE6  => p_RPS_rec.ATTRIBUTE6
         ,p_ATTRIBUTE7  => p_RPS_rec.ATTRIBUTE7
         ,p_ATTRIBUTE8  => p_RPS_rec.ATTRIBUTE8
         ,p_ATTRIBUTE9  => p_RPS_rec.ATTRIBUTE9
         ,p_ATTRIBUTE10  => p_RPS_rec.ATTRIBUTE10
         ,p_ATTRIBUTE11  => p_RPS_rec.ATTRIBUTE11
         ,p_ATTRIBUTE12  => p_RPS_rec.ATTRIBUTE12
         ,p_ATTRIBUTE13  => p_RPS_rec.ATTRIBUTE13
         ,p_ATTRIBUTE14  => p_RPS_rec.ATTRIBUTE14
         ,p_ATTRIBUTE15  => p_RPS_rec.ATTRIBUTE15
         ,p_CREATED_BY     => FND_API.G_MISS_NUM
         ,p_CREATION_DATE  => FND_API.G_MISS_DATE
         ,p_LAST_UPDATED_BY  => FND_GLOBAL.USER_ID
         ,p_LAST_UPDATE_DATE  => SYSDATE
         --,p_LAST_UPDATE_LOGIN  => FND_GLOBAL.CONC_LOGIN_ID   --commented for bug 10034220 gnramasa 24th Sep 10
         ,p_LAST_UPDATE_LOGIN  => FND_GLOBAL.USER_ID
	 ,p_CREDIT_HOLD_REQUEST_FLAG  => p_RPS_rec.CREDIT_HOLD_REQUEST_FLAG
         ,p_CREDIT_HOLD_APPROVED_FLAG  => p_RPS_rec.CREDIT_HOLD_APPROVED_FLAG
         ,p_SERVICE_HOLD_REQUEST_FLAG  => p_RPS_rec.SERVICE_HOLD_REQUEST_FLAG
         ,p_SERVICE_HOLD_APPROVED_FLAG  => p_RPS_rec.SERVICE_HOLD_APPROVED_FLAG
         ,p_SUGGESTION_APPROVED_FLAG  => p_RPS_rec.SUGGESTION_APPROVED_FLAG
         ,p_DISPOSITION_CODE          => p_RPS_REC.DISPOSITION_CODE
         ,p_CUSTOMER_SITE_USE_ID      => p_rps_rec.CUSTOMER_SITE_USE_ID
         ,p_ORG_ID                    => p_rps_rec.ORG_ID
         ,p_CONTRACT_ID               => p_rps_rec.CONTRACT_ID
         ,p_CONTRACT_NUMBER           => p_rps_rec.CONTRACT_NUMBER
         );

Line: 609


End Update_repossession;

Line: 614


PROCEDURE Delete_repossession(
    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_Check_Access_Flag          IN   VARCHAR2   := FND_API.G_FALSE,
    P_Admin_Flag                 IN   VARCHAR2   := FND_API.G_FALSE,
    P_Admin_Group_Id             IN   NUMBER,
    P_Identity_Salesforce_Id     IN   NUMBER,
    P_Profile_Tbl                IN   AS_UTILITY_PUB.PROFILE_TBL_TYPE,
    P_RPS_Rec     IN RPS_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_repossession';

Line: 636


      SAVEPOINT DELETE_REPOSSESSION_PVT;

Line: 711


      IEX_REPOSSESSIONS_PKG.Delete_Row(
          p_REPOSSESSION_ID  => p_RPS_rec.REPOSSESSION_ID);

Line: 763


End Delete_repossession;

Line: 920


PROCEDURE Gen_Select(
    x_select_cl   OUT NOCOPY   VARCHAR2
)
IS
BEGIN

      x_select_cl := 'Select ' ||
                'IEX_REPOSSESSIONS.REPOSSESSION_ID,' ||
                'IEX_REPOSSESSIONS.DELINQUENCY_ID,' ||
                'IEX_REPOSSESSIONS.PARTY_ID,' ||
                'IEX_REPOSSESSIONS.CUST_ACCOUNT_ID,' ||
                'IEX_REPOSSESSIONS.UNPAID_REASON_CODE,' ||
                'IEX_REPOSSESSIONS.REMARKET_FLAG,' ||
                'IEX_REPOSSESSIONS.REPOSSESSION_DATE,' ||
                'IEX_REPOSSESSIONS.ASSET_ID,' ||
                'IEX_REPOSSESSIONS.ASSET_VALUE,' ||
                'IEX_REPOSSESSIONS.ASSET_NUMBER,' ||
                'IEX_REPOSSESSIONS.REQUEST_ID,' ||
                'IEX_REPOSSESSIONS.PROGRAM_APPLICATION_ID,' ||
                'IEX_REPOSSESSIONS.PROGRAM_ID,' ||
                'IEX_REPOSSESSIONS.PROGRAM_UPDATE_DATE,' ||
                'IEX_REPOSSESSIONS.ATTRIBUTE_CATEGORY,' ||
                'IEX_REPOSSESSIONS.ATTRIBUTE1,' ||
                'IEX_REPOSSESSIONS.ATTRIBUTE2,' ||
                'IEX_REPOSSESSIONS.ATTRIBUTE3,' ||
                'IEX_REPOSSESSIONS.ATTRIBUTE4,' ||
                'IEX_REPOSSESSIONS.ATTRIBUTE5,' ||
                'IEX_REPOSSESSIONS.ATTRIBUTE6,' ||
                'IEX_REPOSSESSIONS.ATTRIBUTE7,' ||
                'IEX_REPOSSESSIONS.ATTRIBUTE8,' ||
                'IEX_REPOSSESSIONS.ATTRIBUTE9,' ||
                'IEX_REPOSSESSIONS.ATTRIBUTE10,' ||
                'IEX_REPOSSESSIONS.ATTRIBUTE11,' ||
                'IEX_REPOSSESSIONS.ATTRIBUTE12,' ||
                'IEX_REPOSSESSIONS.ATTRIBUTE13,' ||
                'IEX_REPOSSESSIONS.ATTRIBUTE14,' ||
                'IEX_REPOSSESSIONS.ATTRIBUTE15,' ||
                'IEX_REPOSSESSIONS.CREATED_BY,' ||
                'IEX_REPOSSESSIONS.CREATION_DATE,' ||
                'IEX_REPOSSESSIONS.LAST_UPDATED_BY,' ||
                'IEX_REPOSSESSIONS.LAST_UPDATE_DATE,' ||
                'IEX_REPOSSESSIONS.LAST_UPDATE_LOGIN,' ||
                'IEX_REPOSSESSIONS.SECURITY_GROUP_ID,' ||
                'IEX_REPOSSESSIONS.CREDIT_HOLD_REQUEST_FLAG,' ||
                'IEX_REPOSSESSIONS.CREDIT_HOLD_APPROVED_FLAG,' ||
                'IEX_REPOSSESSIONS.SERVICE_HOLD_REQUEST_FLAG,' ||
                'IEX_REPOSSESSIONS.SERVICE_HOLD_APPROVED_FLAG,' ||
                'IEX_REPOSSESSIONS.SUGGESTION_APPROVED_FLAG,' ||
                'IEX_REPOSSESSIONS.DISPOSITION_CODE,' ||
                'IEX_REPOSSESSIONS.CUSTOMER_SITE_USE_ID,' ||
                'IEX_REPOSSESSIONS.ORG_ID,' ||
                'IEX_REPOSSESSIONS.CONTRACT_ID,' ||
                'IEX_REPOSSESSIONS.CONTRACT_NUMBER' ||
                'from IEX_REPOSSESSIONS';

Line: 975


END Gen_Select;

Line: 985


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

Line: 988


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

Line: 1129


l_select_cl              VARCHAR2(2000) := '';

Line: 1195


      Gen_Select(l_select_cl);

Line: 1382


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

Line: 1429


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

Line: 1476


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

Line: 1523


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

Line: 1570


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

Line: 1617


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

Line: 1664


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

Line: 1711


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

Line: 1758


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

Line: 1811


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

Line: 1858


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

Line: 1905


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

Line: 1952


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

Line: 1999


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

Line: 2046


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