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

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

Line: 181


      SELECT   ozf_object_fund_summary_s.nextval
      FROM     dual;

Line: 185


      SELECT   COUNT(objfundsum_id)
      FROM     ozf_object_fund_summary
      WHERE    objfundsum_id = p_objfundsum_id;

Line: 190


      SELECT   currency_code_tc
      FROM     ozf_funds_all_b
      WHERE    fund_id = p_fund_id;

Line: 195


      SELECT arc_act_offer_used_by,act_offer_used_by_id
      FROM ozf_act_offers
      WHERE qp_list_header_id = p_offer_id;

Line: 398


       ozf_utility_pvt.debug_message(l_full_name ||': insert');

Line: 424


   INSERT INTO ozf_object_fund_summary(
         objfundsum_id,
         creation_date,
         created_by,
         last_update_date,
         last_updated_by,
         last_update_login,
         object_version_number,
         fund_id,
         fund_currency,
         object_type,
         object_id,
         object_currency,
         reference_object_type,
         reference_object_id,
         source_from_parent,
         planned_amt,
         committed_amt,
         recal_committed_amt,
         utilized_amt,
         earned_amt,
         paid_amt,
         plan_curr_planned_amt,
         plan_curr_committed_amt,
         plan_curr_recal_committed_amt,
         plan_curr_utilized_amt,
         plan_curr_earned_amt,
         plan_curr_paid_amt,
         univ_curr_planned_amt,
         univ_curr_committed_amt,
         univ_curr_recal_committed_amt,
         univ_curr_utilized_amt,
         univ_curr_earned_amt,
         univ_curr_paid_amt,
         attribute_category,
         attribute1,
         attribute2,
         attribute3,
         attribute4,
         attribute5,
         attribute6,
         attribute7,
         attribute8,
         attribute9,
         attribute10,
         attribute11,
         attribute12,
         attribute13,
         attribute14,
         attribute15
   )
   VALUES (
        l_objfundsum_rec.objfundsum_id,
        sysdate,
        Fnd_Global.User_ID,
        sysdate,
        Fnd_Global.User_ID,
        Fnd_Global.Conc_Login_ID,
        1, --Object Version Number
        l_objfundsum_rec.fund_id,
        l_objfundsum_rec.fund_currency,
        l_objfundsum_rec.object_type,
        l_objfundsum_rec.object_id,
        l_objfundsum_rec.object_currency,
        l_objfundsum_rec.reference_object_type,
        l_objfundsum_rec.reference_object_id,
        l_objfundsum_rec.source_from_parent,
        l_objfundsum_rec.planned_amt,
        l_objfundsum_rec.committed_amt,
        l_objfundsum_rec.recal_committed_amt,
        l_objfundsum_rec.utilized_amt,
        l_objfundsum_rec.earned_amt,
        l_objfundsum_rec.paid_amt,
        l_objfundsum_rec.plan_curr_planned_amt,
        l_objfundsum_rec.plan_curr_committed_amt,
        l_objfundsum_rec.plan_curr_recal_committed_amt,
        l_objfundsum_rec.plan_curr_utilized_amt,
        l_objfundsum_rec.plan_curr_earned_amt,
        l_objfundsum_rec.plan_curr_paid_amt,
        l_objfundsum_rec.univ_curr_planned_amt,
        l_objfundsum_rec.univ_curr_committed_amt,
        l_objfundsum_rec.univ_curr_recal_committed_amt,
        l_objfundsum_rec.univ_curr_utilized_amt,
        l_objfundsum_rec.univ_curr_earned_amt,
        l_objfundsum_rec.univ_curr_paid_amt,
        l_objfundsum_rec.attribute_category,
        l_objfundsum_rec.attribute1,
        l_objfundsum_rec.attribute2,
        l_objfundsum_rec.attribute3,
        l_objfundsum_rec.attribute4,
        l_objfundsum_rec.attribute5,
        l_objfundsum_rec.attribute6,
        l_objfundsum_rec.attribute7,
        l_objfundsum_rec.attribute8,
        l_objfundsum_rec.attribute9,
        l_objfundsum_rec.attribute10,
        l_objfundsum_rec.attribute11,
        l_objfundsum_rec.attribute12,
        l_objfundsum_rec.attribute13,
        l_objfundsum_rec.attribute14,
        l_objfundsum_rec.attribute15
     );

Line: 580


PROCEDURE Update_objfundsum (
   p_api_version                IN  NUMBER,
   p_init_msg_list              IN  VARCHAR2 := Fnd_Api.G_FALSE,
   p_validation_level           IN  NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
   p_objfundsum_rec             IN  objfundsum_rec_type,
   p_conv_date                  IN  DATE DEFAULT NULL, --bug 8532055
   x_return_status              OUT NOCOPY VARCHAR2,
   x_msg_count                  OUT NOCOPY NUMBER,
   x_msg_data                   OUT NOCOPY VARCHAR2
)
IS
   L_API_VERSION    CONSTANT NUMBER := 1.0;

Line: 592


   L_API_NAME       CONSTANT VARCHAR2(30) := 'UPDATE_objfundsum';

Line: 607


   SAVEPOINT sp_Update_objfundsum;

Line: 815


     ozf_utility_pvt.debug_message(l_full_name ||': update object fund summary Table');

Line: 818


   UPDATE ozf_object_fund_summary
      SET object_version_number= object_version_number + 1,
          last_update_date         = SYSDATE,
          last_updated_by          = Fnd_Global.User_ID,
          last_update_login        = Fnd_Global.Conc_Login_ID,
          fund_id                  = l_objfundsum_rec.fund_id,
          fund_currency            = l_objfundsum_rec.fund_currency,
          object_type              = l_objfundsum_rec.object_type,
          object_id                = l_objfundsum_rec.object_id,
          object_currency          = l_objfundsum_rec.object_currency,
          reference_object_type    = l_objfundsum_rec.reference_object_type,
          reference_object_id      = l_objfundsum_rec.reference_object_id,
          source_from_parent       = l_objfundsum_rec.source_from_parent,
          planned_amt              = l_objfundsum_rec.planned_amt,
          committed_amt            = l_objfundsum_rec.committed_amt,
          recal_committed_amt      = l_objfundsum_rec.recal_committed_amt,
          utilized_amt             = l_objfundsum_rec.utilized_amt,
          earned_amt               = l_objfundsum_rec.earned_amt,
          paid_amt                 = l_objfundsum_rec.paid_amt,
          plan_curr_planned_amt    = l_objfundsum_rec.plan_curr_planned_amt,
          plan_curr_committed_amt  = l_objfundsum_rec.plan_curr_committed_amt,
          plan_curr_recal_committed_amt  = l_objfundsum_rec.plan_curr_recal_committed_amt,
          plan_curr_utilized_amt   = l_objfundsum_rec.plan_curr_utilized_amt,
          plan_curr_earned_amt     = l_objfundsum_rec.plan_curr_earned_amt,
          plan_curr_paid_amt       = l_objfundsum_rec.plan_curr_paid_amt,
          univ_curr_planned_amt    = l_objfundsum_rec.univ_curr_planned_amt,
          univ_curr_committed_amt  = l_objfundsum_rec.univ_curr_committed_amt,
          univ_curr_recal_committed_amt  = l_objfundsum_rec.univ_curr_recal_committed_amt,
          univ_curr_utilized_amt   = l_objfundsum_rec.univ_curr_utilized_amt,
          univ_curr_earned_amt     = l_objfundsum_rec.univ_curr_earned_amt,
          univ_curr_paid_amt       = l_objfundsum_rec.univ_curr_paid_amt,
          attribute_category       = l_objfundsum_rec.attribute_category,
          attribute1               = l_objfundsum_rec.attribute1,
          attribute2               = l_objfundsum_rec.attribute2,
          attribute3               = l_objfundsum_rec.attribute3,
          attribute4               = l_objfundsum_rec.attribute4,
          attribute5               = l_objfundsum_rec.attribute5,
          attribute6               = l_objfundsum_rec.attribute6,
          attribute7               = l_objfundsum_rec.attribute7,
          attribute8               = l_objfundsum_rec.attribute8,
          attribute9               = l_objfundsum_rec.attribute9,
          attribute10              = l_objfundsum_rec.attribute10,
          attribute11              = l_objfundsum_rec.attribute11,
          attribute12              = l_objfundsum_rec.attribute12,
          attribute13              = l_objfundsum_rec.attribute13,
          attribute14              = l_objfundsum_rec.attribute14,
          attribute15              = l_objfundsum_rec.attribute15
    WHERE objfundsum_id = l_objfundsum_rec.objfundsum_id
    AND   object_version_number = l_objfundsum_rec.object_version_number;

Line: 889


      ROLLBACK TO SP_Update_objfundsum;

Line: 897


      ROLLBACK TO SP_Update_objfundsum;

Line: 905


      ROLLBACK TO SP_Update_objfundsum;

Line: 915


END Update_objfundsum;

Line: 950


     SELECT objfundsum_id
          , object_version_number
          , planned_amt
          , plan_curr_planned_amt
          , univ_curr_planned_amt
          , committed_amt
          , plan_curr_committed_amt
          , univ_curr_committed_amt
          , recal_committed_amt
          , plan_curr_recal_committed_amt
          , univ_curr_recal_committed_amt
          , utilized_amt
          , plan_curr_utilized_amt
          , univ_curr_utilized_amt
          , earned_amt
          , plan_curr_earned_amt
          , univ_curr_earned_amt
          , paid_amt
          , plan_curr_paid_amt
          , univ_curr_paid_amt
     FROM   ozf_object_fund_summary
     WHERE  object_type = p_object_type
     AND    object_id = p_object_id
     AND    fund_id = p_fund_id;

Line: 1095


   ozf_objfundsum_pvt.update_objfundsum(
       p_api_version                => p_api_version,
       p_init_msg_list              => p_init_msg_list,
       p_validation_level           => p_validation_level,
       p_objfundsum_rec             => l_objfundsum_rec,
       x_return_status              => x_return_status,
       x_msg_count                  => x_msg_count,
       x_msg_data                   => x_msg_data
   );

Line: 1376


   SELECT *
     FROM ozf_object_fund_summary
    WHERE objfundsum_id = p_objfundsum_rec.objfundsum_id;