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

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

Line: 41


Cursor c2 is SELECT IEX_BANKRUPTCIES_S.nextval from dual;

Line: 128


      IEX_BANKRUPTCIES_PKG.Insert_Row(
          x_rowid                   =>v_rowid,
          p_BANKRUPTCY_ID           => v_BANKRUPTCY_ID,
          p_CAS_ID                  => p_bankruptcy_rec.CAS_ID,
          p_DELINQUENCY_ID          => p_bankruptcy_rec.DELINQUENCY_ID,
          p_PARTY_ID                => p_bankruptcy_rec.PARTY_ID,
          p_ACTIVE_FLAG             => v_ACTIVE_FLAG,
          p_TRUSTEE_CONTACT_ID      => p_bankruptcy_rec.TRUSTEE_CONTACT_ID,
          p_COURT_ID                => p_bankruptcy_rec.COURT_ID,
          p_FIRM_CONTACT_ID         => p_bankruptcy_rec.FIRM_CONTACT_ID,
          p_COUNSEL_CONTACT_ID      => p_bankruptcy_rec.COUNSEL_CONTACT_ID,
          p_OBJECT_VERSION_NUMBER   => v_OBJECT_VERSION_NUMBER,
          p_CHAPTER_CODE                 => p_bankruptcy_rec.CHAPTER_CODE,
          p_ASSET_AMOUNT            => p_bankruptcy_rec.ASSET_AMOUNT,
          p_ASSET_CURRENCY_CODE     => p_bankruptcy_rec.ASSET_CURRENCY_CODE,
          p_PAYOFF_AMOUNT           => p_bankruptcy_rec.PAYOFF_AMOUNT,
          p_PAYOFF_CURRENCY_CODE    => p_bankruptcy_rec.PAYOFF_CURRENCY_CODE,
          p_BANKRUPTCY_FILE_DATE    => p_bankruptcy_rec.BANKRUPTCY_FILE_DATE,
          p_COURT_ORDER_DATE        => p_bankruptcy_rec.COURT_ORDER_DATE,
          p_FUNDING_DATE            => p_bankruptcy_rec.FUNDING_DATE,
          p_OBJECT_BAR_DATE         => p_bankruptcy_rec.OBJECT_BAR_DATE,
          p_REPOSSESSION_DATE       => p_bankruptcy_rec.REPOSSESSION_DATE,
          p_DISMISSAL_DATE          => p_bankruptcy_rec.DISMISSAL_DATE,
          p_DATE_341A               => p_bankruptcy_rec.DATE_341A,
          p_DISCHARGE_DATE          => p_bankruptcy_rec.DISCHARGE_DATE,
          p_WITHDRAW_DATE           => p_bankruptcy_rec.WITHDRAW_DATE,
          p_CLOSE_DATE              => p_bankruptcy_rec.CLOSE_DATE,
          p_PROCEDURE_CODE              => p_bankruptcy_rec.PROCEDURE_CODE,
          p_MOTION_CODE                 => p_bankruptcy_rec.MOTION_CODE,
          p_CHECKLIST_CODE              => p_bankruptcy_rec.CHECKLIST_CODE,
          p_CEASE_COLLECTIONS_YN    => p_bankruptcy_rec.CEASE_COLLECTIONS_YN,
          p_TURN_OFF_INVOICING_YN   => p_bankruptcy_rec.TURN_OFF_INVOICING_YN,
          p_REQUEST_ID              => p_bankruptcy_rec.REQUEST_ID,
          p_PROGRAM_APPLICATION_ID  => p_bankruptcy_rec.PROGRAM_APPLICATION_ID,
          p_PROGRAM_ID              => p_bankruptcy_rec.PROGRAM_ID,
          p_PROGRAM_UPDATE_DATE     => p_bankruptcy_rec.PROGRAM_UPDATE_DATE,
          p_ATTRIBUTE_CATEGORY      => p_bankruptcy_rec.ATTRIBUTE_CATEGORY,
          p_ATTRIBUTE1              => p_bankruptcy_rec.ATTRIBUTE1,
          p_ATTRIBUTE2              => p_bankruptcy_rec.ATTRIBUTE2,
          p_ATTRIBUTE3              => p_bankruptcy_rec.ATTRIBUTE3,
          p_ATTRIBUTE4              => p_bankruptcy_rec.ATTRIBUTE4,
          p_ATTRIBUTE5              => p_bankruptcy_rec.ATTRIBUTE5,
          p_ATTRIBUTE6              => p_bankruptcy_rec.ATTRIBUTE6,
          p_ATTRIBUTE7              => p_bankruptcy_rec.ATTRIBUTE7,
          p_ATTRIBUTE8              => p_bankruptcy_rec.ATTRIBUTE8,
          p_ATTRIBUTE9              => p_bankruptcy_rec.ATTRIBUTE9,
          p_ATTRIBUTE10             => p_bankruptcy_rec.ATTRIBUTE10,
          p_ATTRIBUTE11             => p_bankruptcy_rec.ATTRIBUTE11,
          p_ATTRIBUTE12             => p_bankruptcy_rec.ATTRIBUTE12,
          p_ATTRIBUTE13             => p_bankruptcy_rec.ATTRIBUTE13,
          p_ATTRIBUTE14             => p_bankruptcy_rec.ATTRIBUTE14,
          p_ATTRIBUTE15             => p_bankruptcy_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       => p_bankruptcy_rec.LAST_UPDATE_LOGIN
         ,p_CREDIT_HOLD_REQUEST_FLAG   => p_bankruptcy_rec.CREDIT_HOLD_REQUEST_FLAG
         ,p_CREDIT_HOLD_APPROVED_FLAG  => p_bankruptcy_rec.CREDIT_HOLD_APPROVED_FLAG
         ,p_SERVICE_HOLD_REQUEST_FLAG  => p_bankruptcy_rec.SERVICE_HOLD_REQUEST_FLAG
         ,p_SERVICE_HOLD_APPROVED_FLAG => p_bankruptcy_rec.SERVICE_HOLD_APPROVED_FLAG
         ,p_DISPOSITION_CODE           => p_bankruptcy_rec.DISPOSITION_CODE
         ,p_TURN_OFF_INVOICE_YN        => p_bankruptcy_rec.TURN_OFF_INVOICE_YN
         ,p_NOTICE_ASSIGNMENT_YN       => p_bankruptcy_rec.NOTICE_ASSIGNMENT_YN
         ,p_FILE_PROOF_CLAIM_YN        => p_bankruptcy_rec.FILE_PROOF_CLAIM_YN
         ,p_REQUEST_REPURCHASE_YN      => p_bankruptcy_rec.REQUEST_REPURCHASE_YN
         ,p_FEE_PAID_DATE              => p_bankruptcy_rec.FEE_PAID_DATE
         ,p_REAFFIRMATION_DATE         => p_bankruptcy_rec.REAFFIRMATION_DATE
         ,p_RELIEF_STAY_DATE           => p_bankruptcy_rec.RELIEF_STAY_DATE
         ,p_FILE_CONTACT_ID            => p_bankruptcy_rec.FILE_CONTACT_ID
         ,p_CASE_NUMBER                => p_bankruptcy_rec.CASE_NUMBER
);

Line: 206


                            'Insert_Row and BANKRUPTCY_ID is => '||x_BANKRUPTCY_ID);

Line: 270


PROCEDURE Update_bankruptcy(
    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_bankruptcy_Rec             IN    bankruptcy_Rec_Type,
    X_Return_Status              OUT NOCOPY  VARCHAR2,
    X_Msg_Count                  OUT NOCOPY  NUMBER,
    X_Msg_Data                   OUT NOCOPY  VARCHAR2,
    xo_object_version_number     OUT NOCOPY NUMBER
    ) IS
l_api_name                CONSTANT VARCHAR2(30) := 'UPDATE_BANKRUPTCY';

Line: 289


        IEX_DEBUG_PUB.LogMessage ('Update_bankruptcy: ' || '********* start of Procedure =>'||
          'IEX_BANKRUPTCIES_PVT.update_BANKRUPTCY ******** ');

Line: 293


      SAVEPOINT UPDATE_BANKRUPTCY_PVT;

Line: 329


      IEX_BANKRUPTCIES_PKG.Update_Row(
          p_BANKRUPTCY_ID           => p_bankruptcy_rec.BANKRUPTCY_ID,
          p_CAS_ID                  => p_bankruptcy_rec.CAS_ID,
          p_DELINQUENCY_ID          => p_bankruptcy_rec.DELINQUENCY_ID,
          p_PARTY_ID                => p_bankruptcy_rec.PARTY_ID,
          p_ACTIVE_FLAG             => p_bankruptcy_rec.ACTIVE_FLAG,
          p_TRUSTEE_CONTACT_ID      => p_bankruptcy_rec.TRUSTEE_CONTACT_ID,
          p_COURT_ID                => p_bankruptcy_rec.COURT_ID,
          p_FIRM_CONTACT_ID         => p_bankruptcy_rec.FIRM_CONTACT_ID,
          p_COUNSEL_CONTACT_ID      => p_bankruptcy_rec.COUNSEL_CONTACT_ID,
          p_OBJECT_VERSION_NUMBER   => l_OBJECT_VERSION_NUMBER + 1,
          p_CHAPTER_CODE                => p_bankruptcy_rec.CHAPTER_CODE,
          p_ASSET_AMOUNT            => p_bankruptcy_rec.ASSET_AMOUNT,
          p_ASSET_CURRENCY_CODE     => p_bankruptcy_rec.ASSET_CURRENCY_CODE,
          p_PAYOFF_AMOUNT           => p_bankruptcy_rec.PAYOFF_AMOUNT,
          p_PAYOFF_CURRENCY_CODE   => p_bankruptcy_rec.PAYOFF_CURRENCY_CODE,
          p_BANKRUPTCY_FILE_DATE   => p_bankruptcy_rec.BANKRUPTCY_FILE_DATE,
          p_COURT_ORDER_DATE       => p_bankruptcy_rec.COURT_ORDER_DATE,
          p_FUNDING_DATE           => p_bankruptcy_rec.FUNDING_DATE,
          p_OBJECT_BAR_DATE        => p_bankruptcy_rec.OBJECT_BAR_DATE,
          p_REPOSSESSION_DATE      => p_bankruptcy_rec.REPOSSESSION_DATE,
          p_DISMISSAL_DATE         => p_bankruptcy_rec.DISMISSAL_DATE,
          p_DATE_341A              => p_bankruptcy_rec.DATE_341A,
          p_DISCHARGE_DATE         => p_bankruptcy_rec.DISCHARGE_DATE,
          p_WITHDRAW_DATE          => p_bankruptcy_rec.WITHDRAW_DATE,
          p_CLOSE_DATE             => p_bankruptcy_rec.CLOSE_DATE,
          p_PROCEDURE_CODE             => p_bankruptcy_rec.PROCEDURE_CODE,
          p_MOTION_CODE                => p_bankruptcy_rec.MOTION_CODE,
          p_CHECKLIST_CODE             => p_bankruptcy_rec.CHECKLIST_CODE,
          p_CEASE_COLLECTIONS_YN   => p_bankruptcy_rec.CEASE_COLLECTIONS_YN,
          p_TURN_OFF_INVOICING_YN  => p_bankruptcy_rec.TURN_OFF_INVOICING_YN,
          p_REQUEST_ID             => p_bankruptcy_rec.REQUEST_ID,
          p_PROGRAM_APPLICATION_ID => p_bankruptcy_rec.PROGRAM_APPLICATION_ID,
          p_PROGRAM_ID             => p_bankruptcy_rec.PROGRAM_ID,
          p_PROGRAM_UPDATE_DATE    => p_bankruptcy_rec.PROGRAM_UPDATE_DATE,
          p_ATTRIBUTE_CATEGORY     => p_bankruptcy_rec.ATTRIBUTE_CATEGORY,
          p_ATTRIBUTE1  => p_bankruptcy_rec.ATTRIBUTE1,
          p_ATTRIBUTE2  => p_bankruptcy_rec.ATTRIBUTE2,
          p_ATTRIBUTE3  => p_bankruptcy_rec.ATTRIBUTE3,
          p_ATTRIBUTE4  => p_bankruptcy_rec.ATTRIBUTE4,
          p_ATTRIBUTE5  => p_bankruptcy_rec.ATTRIBUTE5,
          p_ATTRIBUTE6  => p_bankruptcy_rec.ATTRIBUTE6,
          p_ATTRIBUTE7  => p_bankruptcy_rec.ATTRIBUTE7,
          p_ATTRIBUTE8  => p_bankruptcy_rec.ATTRIBUTE8,
          p_ATTRIBUTE9  => p_bankruptcy_rec.ATTRIBUTE9,
          p_ATTRIBUTE10  => p_bankruptcy_rec.ATTRIBUTE10,
          p_ATTRIBUTE11  => p_bankruptcy_rec.ATTRIBUTE11,
          p_ATTRIBUTE12  => p_bankruptcy_rec.ATTRIBUTE12,
          p_ATTRIBUTE13  => p_bankruptcy_rec.ATTRIBUTE13,
          p_ATTRIBUTE14  => p_bankruptcy_rec.ATTRIBUTE14,
          p_ATTRIBUTE15       => p_bankruptcy_rec.ATTRIBUTE15,
          p_LAST_UPDATED_BY   => FND_GLOBAL.USER_ID,
          p_LAST_UPDATE_DATE  => SYSDATE,
          p_LAST_UPDATE_LOGIN => p_bankruptcy_rec.LAST_UPDATE_LOGIN
         ,p_CREDIT_HOLD_REQUEST_FLAG   => p_bankruptcy_rec.CREDIT_HOLD_REQUEST_FLAG
         ,p_CREDIT_HOLD_APPROVED_FLAG  => p_bankruptcy_rec.CREDIT_HOLD_APPROVED_FLAG
         ,p_SERVICE_HOLD_REQUEST_FLAG  => p_bankruptcy_rec.SERVICE_HOLD_REQUEST_FLAG
         ,p_SERVICE_HOLD_APPROVED_FLAG => p_bankruptcy_rec.SERVICE_HOLD_APPROVED_FLAG
         ,p_DISPOSITION_CODE           => p_bankruptcy_rec.DISPOSITION_CODE
         ,p_TURN_OFF_INVOICE_YN        => p_bankruptcy_rec.TURN_OFF_INVOICE_YN
         ,p_NOTICE_ASSIGNMENT_YN       => p_bankruptcy_rec.NOTICE_ASSIGNMENT_YN
         ,p_FILE_PROOF_CLAIM_YN        => p_bankruptcy_rec.FILE_PROOF_CLAIM_YN
         ,p_REQUEST_REPURCHASE_YN      => p_bankruptcy_rec.REQUEST_REPURCHASE_YN
         ,p_FEE_PAID_DATE              => p_bankruptcy_rec.FEE_PAID_DATE
         ,p_REAFFIRMATION_DATE         => p_bankruptcy_rec.REAFFIRMATION_DATE
         ,p_RELIEF_STAY_DATE           => p_bankruptcy_rec.RELIEF_STAY_DATE
         ,p_FILE_CONTACT_ID            => p_bankruptcy_rec.FILE_CONTACT_ID
         ,p_CASE_NUMBER                => p_bankruptcy_rec.CASE_NUMBER
);

Line: 419


         IEX_DEBUG_PUB.LogMessage ('Update_bankruptcy: ' || '********* end of Procedure =>'||
             'IEX_BANKRUPTCIES_PVT.update_bankruptcy ******** ');

Line: 455


End Update_bankruptcy;

Line: 459


PROCEDURE Delete_bankruptcy(
    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_bankruptcy_id              IN   NUMBER,
    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_BANKRUPTCY';

Line: 478


          IEX_DEBUG_PUB.LogMessage ('Delete_bankruptcy: ' || '********* start of Procedure =>'||
             'IEX_BANKRUPTCIES_PVT.delete_bankruptcy ******** ');

Line: 483


      SAVEPOINT DELETE_BANKRUPTCY_PVT;

Line: 509


      IEX_BANKRUPTCIES_PKG.Delete_Row(
          p_BANKRUPTCY_ID  => p_BANKRUPTCY_ID);

Line: 528


         IEX_DEBUG_PUB.LogMessage ('Delete_bankruptcy: ' || '********* end of Procedure =>'||
             'IEX_BANKRUPTCIES_PVT.delete_bankruptcy ******** ');

Line: 564


End Delete_bankruptcy;