APPS.IGW_INSTALLMENTS_PVT SQL Statements

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

Line: 28

         SELECT 'N'
         INTO   l_locked
         FROM   igw_installments
         WHERE  rowid = p_rowid;

Line: 68

         SELECT lookup_code
         INTO   l_lookup_code
         FROM   gms_lookups
         WHERE  lookup_type = p_lookup_type
         AND    meaning = p_meaning;

Line: 195

      **   Invoke Table Handler to insert data
      */

      Igw_Installments_Tbh.Insert_Row
      (
         x_rowid                   => x_rowid,
         x_proposal_installment_id => x_proposal_installment_id,
         p_proposal_award_id       => p_proposal_award_id,
         p_installment_id          => p_installment_id,
         p_installment_number      => p_installment_number,
         p_installment_type_code   => l_installment_type_code,
         p_issue_date              => p_issue_date,
         p_close_date              => p_close_date,
         p_start_date              => p_start_date,
         p_end_date                => p_end_date,
         p_direct_cost             => p_direct_cost,
         p_indirect_cost           => p_indirect_cost,
         p_billable_flag           => p_billable_flag,
         p_description             => p_description,
         x_return_status           => l_return_status
      );

Line: 276

   PROCEDURE Update_Installment
   (
      p_init_msg_list           IN VARCHAR2   := Fnd_Api.G_False,
      p_validate_only           IN VARCHAR2   := Fnd_Api.G_False,
      p_commit                  IN VARCHAR2   := Fnd_Api.G_False,
      p_rowid                   IN VARCHAR2,
      p_proposal_installment_id IN NUMBER,
      p_record_version_number   IN NUMBER,
      p_proposal_award_id       IN NUMBER,
      p_installment_id          IN NUMBER,
      p_installment_number      IN VARCHAR2,
      p_installment_type_desc   IN VARCHAR2,
      p_installment_type_code   IN VARCHAR2,
      p_issue_date              IN DATE,
      p_close_date              IN DATE,
      p_start_date              IN DATE,
      p_end_date                IN DATE,
      p_direct_cost             IN NUMBER,
      p_indirect_cost           IN NUMBER,
      p_billable_flag           IN VARCHAR2,
      p_description             IN VARCHAR2,
      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) := 'Update_Installment';

Line: 315

      SAVEPOINT Update_Installment_Pvt;

Line: 389

      **   Invoke Table Handler to Update data
      */

      Igw_Installments_Tbh.Update_Row
      (
         p_rowid                   => p_rowid,
         p_proposal_installment_id => p_proposal_installment_id,
         p_proposal_award_id       => p_proposal_award_id,
         p_installment_id          => p_installment_id,
         p_installment_number      => p_installment_number,
         p_installment_type_code   => l_installment_type_code,
         p_issue_date              => p_issue_date,
         p_close_date              => p_close_date,
         p_start_date              => p_start_date,
         p_end_date                => p_end_date,
         p_direct_cost             => p_direct_cost,
         p_indirect_cost           => p_indirect_cost,
         p_billable_flag           => p_billable_flag,
         p_description             => p_description,
         x_return_status           => x_return_status
      );

Line: 427

         ROLLBACK TO Update_Installment_Pvt;

Line: 439

         ROLLBACK TO Update_Installment_Pvt;

Line: 451

         ROLLBACK TO Update_Installment_Pvt;

Line: 467

   END Update_Installment;

Line: 471

   PROCEDURE Delete_Installment
   (
      p_init_msg_list         IN VARCHAR2   := Fnd_Api.G_False,
      p_validate_only         IN VARCHAR2   := Fnd_Api.G_False,
      p_commit                IN VARCHAR2   := Fnd_Api.G_False,
      p_rowid                 IN VARCHAR2,
      p_record_version_number 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_Installment';

Line: 493

      SAVEPOINT Delete_Installment_Pvt;

Line: 543

      **   Invoke Table Handler to Delete data
      */

      Igw_Installments_Tbh.Delete_Row
      (
         p_rowid                  => p_rowid,
         x_return_status          => x_return_status
      );

Line: 568

         ROLLBACK TO Delete_Installment_Pvt;

Line: 580

         ROLLBACK TO Delete_Installment_Pvt;

Line: 592

         ROLLBACK TO Delete_Installment_Pvt;

Line: 608

   END Delete_Installment;