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

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

Line: 26


SELECT gs.currency_code
FROM   gl_sets_of_books gs,
       ozf_sys_parameters osp
WHERE  gs.set_of_books_id = osp.set_of_books_id
AND    osp.org_id = MO_GLOBAL.get_current_org_id();

Line: 40


   SELECT *
     FROM ozf_supp_trd_prfls_all
     WHERE supp_trade_profile_id = p_supp_trade_profile_rec.supp_trade_profile_id;

Line: 70


   IF p_supp_trade_profile_rec.program_update_date = FND_API.g_miss_date THEN
      x_complete_rec.program_update_date := null;

Line: 73


   IF p_supp_trade_profile_rec.program_update_date is null THEN
      x_complete_rec.program_update_date := l_supp_trade_profile_rec.program_update_date;

Line: 312


      SELECT cust_acct_site_id
      from   HZ_CUST_SITE_USES
      WHERE  site_use_id = a_id;

Line: 748


      SELECT ozf_supp_trd_prfls_all_s.NEXTVAL
      FROM dual;

Line: 752


      SELECT count(supp_trade_profile_id)
      FROM   ozf_supp_trd_prfls_all
      WHERE  SUPP_TRADE_PROFILE_ID = l_id;

Line: 757


      SELECT cust_account_id
      from   HZ_CUST_ACCOUNTS
      WHERE  party_id = p_id
      AND    status = 'A';

Line: 763


      SELECT party_id
      from   HZ_CUST_ACCOUNTS
      WHERE  cust_account_id = c_id;

Line: 857


      OZF_supp_trd_prfls_PKG.Insert_Row(
         px_supp_trade_profile_id  => l_supp_trade_profile_id,
         px_object_version_number  => l_object_version_number,
         p_last_update_date  => SYSDATE,
         p_last_updated_by  => FND_GLOBAL.USER_ID,
         p_creation_date  => SYSDATE,
         p_created_by  => FND_GLOBAL.USER_ID,
         p_last_update_login  => FND_GLOBAL.CONC_LOGIN_ID,
         p_request_id  => l_supp_trade_profile_rec.request_id,
         p_program_application_id  => l_supp_trade_profile_rec.program_application_id,
         p_program_update_date  => l_supp_trade_profile_rec.program_update_date,
         p_program_id  => l_supp_trade_profile_rec.program_id,
         p_created_from  => l_supp_trade_profile_rec.created_from,
         p_party_id  => l_supp_trade_profile_rec.party_id,
         p_site_use_id  => l_supp_trade_profile_rec.site_use_id,
         p_cust_account_id  => l_supp_trade_profile_rec.cust_account_id,
         p_cust_acct_site_id  => l_supp_trade_profile_rec.cust_acct_site_id,
         p_supplier_id  => l_supp_trade_profile_rec.supplier_id,
         p_supplier_site_id  => l_supp_trade_profile_rec.supplier_site_id,
         p_attribute_category  => l_supp_trade_profile_rec.attribute_category,
         p_attribute1  => l_supp_trade_profile_rec.attribute1,
         p_attribute2  => l_supp_trade_profile_rec.attribute2,
         p_attribute3  => l_supp_trade_profile_rec.attribute3,
         p_attribute4  => l_supp_trade_profile_rec.attribute4,
         p_attribute5  => l_supp_trade_profile_rec.attribute5,
         p_attribute6  => l_supp_trade_profile_rec.attribute6,
         p_attribute7  => l_supp_trade_profile_rec.attribute7,
         p_attribute8  => l_supp_trade_profile_rec.attribute8,
         p_attribute9  => l_supp_trade_profile_rec.attribute9,
         p_attribute10  => l_supp_trade_profile_rec.attribute10,
         p_attribute11  => l_supp_trade_profile_rec.attribute11,
         p_attribute12  => l_supp_trade_profile_rec.attribute12,
         p_attribute13  => l_supp_trade_profile_rec.attribute13,
         p_attribute14  => l_supp_trade_profile_rec.attribute14,
         p_attribute15  => l_supp_trade_profile_rec.attribute15,
         p_attribute16  => l_supp_trade_profile_rec.attribute16,
         p_attribute17  => l_supp_trade_profile_rec.attribute17,
         p_attribute18  => l_supp_trade_profile_rec.attribute18,
         p_attribute19  => l_supp_trade_profile_rec.attribute19,
         p_attribute20  => l_supp_trade_profile_rec.attribute20,
         p_attribute21  => l_supp_trade_profile_rec.attribute21,
         p_attribute22  => l_supp_trade_profile_rec.attribute22,
         p_attribute23  => l_supp_trade_profile_rec.attribute23,
         p_attribute24  => l_supp_trade_profile_rec.attribute24,
         p_attribute25  => l_supp_trade_profile_rec.attribute25,
         p_attribute26  => l_supp_trade_profile_rec.attribute26,
         p_attribute27  => l_supp_trade_profile_rec.attribute27,
         p_attribute28  => l_supp_trade_profile_rec.attribute28,
         p_attribute29  => l_supp_trade_profile_rec.attribute29,
         p_attribute30  => l_supp_trade_profile_rec.attribute30,
         p_dpp_attribute_category  => l_supp_trade_profile_rec.dpp_attribute_category,
         p_dpp_attribute1  => l_supp_trade_profile_rec.dpp_attribute1,
         p_dpp_attribute2  => l_supp_trade_profile_rec.dpp_attribute2,
         p_dpp_attribute3  => l_supp_trade_profile_rec.dpp_attribute3,
         p_dpp_attribute4  => l_supp_trade_profile_rec.dpp_attribute4,
         p_dpp_attribute5  => l_supp_trade_profile_rec.dpp_attribute5,
         p_dpp_attribute6  => l_supp_trade_profile_rec.dpp_attribute6,
         p_dpp_attribute7  => l_supp_trade_profile_rec.dpp_attribute7,
         p_dpp_attribute8  => l_supp_trade_profile_rec.dpp_attribute8,
         p_dpp_attribute9  => l_supp_trade_profile_rec.dpp_attribute9,
         p_dpp_attribute10  => l_supp_trade_profile_rec.dpp_attribute10,
         p_dpp_attribute11  => l_supp_trade_profile_rec.dpp_attribute11,
         p_dpp_attribute12  => l_supp_trade_profile_rec.dpp_attribute12,
         p_dpp_attribute13  => l_supp_trade_profile_rec.dpp_attribute13,
         p_dpp_attribute14  => l_supp_trade_profile_rec.dpp_attribute14,
         p_dpp_attribute15  => l_supp_trade_profile_rec.dpp_attribute15,
         p_dpp_attribute16  => l_supp_trade_profile_rec.dpp_attribute16,
         p_dpp_attribute17  => l_supp_trade_profile_rec.dpp_attribute17,
         p_dpp_attribute18  => l_supp_trade_profile_rec.dpp_attribute18,
         p_dpp_attribute19  => l_supp_trade_profile_rec.dpp_attribute19,
         p_dpp_attribute20  => l_supp_trade_profile_rec.dpp_attribute20,
         p_dpp_attribute21  => l_supp_trade_profile_rec.dpp_attribute21,
         p_dpp_attribute22  => l_supp_trade_profile_rec.dpp_attribute22,
         p_dpp_attribute23  => l_supp_trade_profile_rec.dpp_attribute23,
         p_dpp_attribute24  => l_supp_trade_profile_rec.dpp_attribute24,
         p_dpp_attribute25  => l_supp_trade_profile_rec.dpp_attribute25,
         p_dpp_attribute26  => l_supp_trade_profile_rec.dpp_attribute26,
         p_dpp_attribute27  => l_supp_trade_profile_rec.dpp_attribute27,
         p_dpp_attribute28  => l_supp_trade_profile_rec.dpp_attribute28,
         p_dpp_attribute29  => l_supp_trade_profile_rec.dpp_attribute29,
         p_dpp_attribute30  => l_supp_trade_profile_rec.dpp_attribute30,
         px_org_id  => l_supp_trade_profile_rec.org_id  ,
         p_pre_approval_flag            => l_supp_trade_profile_rec.pre_approval_flag          ,
         p_approval_communication       => l_supp_trade_profile_rec.approval_communication    ,
         p_gl_contra_liability_acct     => l_supp_trade_profile_rec.gl_contra_liability_acct  ,
         p_gl_cost_adjustment_acct      => l_supp_trade_profile_rec.gl_cost_adjustment_acct   ,
         p_default_days_covered         => l_supp_trade_profile_rec.default_days_covered      ,
         p_create_claim_price_increase  => l_supp_trade_profile_rec.create_claim_price_increase ,
         p_authorization_period         => l_supp_trade_profile_rec.authorization_period      ,
         p_grace_days                   => l_supp_trade_profile_rec.grace_days                ,
         p_allow_qty_increase           => l_supp_trade_profile_rec.allow_qty_increase        ,
         p_qty_increase_tolerance       => l_supp_trade_profile_rec.qty_increase_tolerance   ,
         p_request_communication        => l_supp_trade_profile_rec.request_communication     ,
         p_claim_communication          => l_supp_trade_profile_rec.claim_communication       ,
         p_claim_frequency              => l_supp_trade_profile_rec.claim_frequency          ,
         p_claim_frequency_unit         => l_supp_trade_profile_rec.claim_frequency_unit      ,
         p_claim_computation_basis      => l_supp_trade_profile_rec.claim_computation_basis   ,
         p_claim_currency_code          => l_supp_trade_profile_rec.claim_currency_code   ,
         p_min_claim_amt                => l_supp_trade_profile_rec.min_claim_amt   ,
         p_min_claim_amt_line_lvl       => l_supp_trade_profile_rec.min_claim_amt_line_lvl   ,
         p_auto_debit                   => l_supp_trade_profile_rec.auto_debit   ,
         p_days_before_claiming_debit   => l_supp_trade_profile_rec.days_before_claiming_debit

         );

Line: 1032


PROCEDURE Update_Supp_Trade_Profile(
   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,
   x_return_status              OUT NOCOPY  VARCHAR2,
   x_msg_count                  OUT NOCOPY  NUMBER,
   x_msg_data                   OUT NOCOPY  VARCHAR2,
   p_supp_trade_profile_rec               IN    supp_trade_profile_rec_type,
   x_object_version_number      OUT NOCOPY  NUMBER
                               )
IS
   L_API_NAME                  CONSTANT VARCHAR2(30) := 'Update_Supp_Trade_Profile';

Line: 1056


   SELECT *
     FROM ozf_supp_trd_prfls_all
     WHERE supp_trade_profile_id = p_supp_trade_profile_rec.supp_trade_profile_id;

Line: 1061


     SELECT *
     FROM  ozf_supp_trd_prfls_all
     WHERE supp_trade_profile_id = v_supp_trade_profile_id;

Line: 1074


   SELECT  supplier_id , supplier_site_id
   FROM    ozf_supp_trd_prfls_all   -- R12 Enhancements
   WHERE   supp_trade_profile_id = p_id;

Line: 1081


   SAVEPOINT UPDATE_Supp_Trade_Profile_PVT;

Line: 1106


      OZF_UTILITY_PVT.debug_message('Private API: - Open Cursor to Select');

Line: 1151


            OZF_UTILITY_PVT.debug_message('Calling create in update method');

Line: 1170


   ELSE -- update mode
      -- complete the record (get missing values filled from db)
      Complete_supp_trade_prfl_rec(
         p_supp_trade_profile_rec   => p_supp_trade_profile_rec,
         x_complete_rec        => l_supp_trade_profile_rec
      );

Line: 1177


           OZF_UTILITY_PVT.debug_message('In the update');

Line: 1195


                                 p_validation_mode   => JTF_PLSQL_API.g_update,
                                 x_return_status     => x_return_status
                                  );

Line: 1222


   OZF_supp_trd_prfls_PKG.Update_Row(
        p_supp_trade_profile_id  => l_supp_trade_profile_rec.supp_trade_profile_id,
        p_object_version_number  => l_supp_trade_profile_rec.object_version_number,
        p_last_update_date  => SYSDATE,
        p_last_updated_by  => FND_GLOBAL.USER_ID,
        p_last_update_login  => FND_GLOBAL.CONC_LOGIN_ID,
        p_request_id  => l_supp_trade_profile_rec.request_id,
        p_program_application_id  => l_supp_trade_profile_rec.program_application_id,
        p_program_update_date  => l_supp_trade_profile_rec.program_update_date,
        p_program_id  => l_supp_trade_profile_rec.program_id,
        p_created_from  => l_supp_trade_profile_rec.created_from,
        p_party_id  => l_supp_trade_profile_rec.party_id,
        p_site_use_id  => l_supp_trade_profile_rec.site_use_id,
        p_cust_account_id  => l_supp_trade_profile_rec.cust_account_id,
        p_cust_acct_site_id  => l_supp_trade_profile_rec.cust_acct_site_id,
        p_supplier_id  => l_supp_trade_profile_rec.supplier_id,
        p_supplier_site_id  => l_supp_trade_profile_rec.supplier_site_id,
        p_attribute_category  => l_supp_trade_profile_rec.attribute_category,
        p_attribute1  => l_supp_trade_profile_rec.attribute1,
        p_attribute2  => l_supp_trade_profile_rec.attribute2,
        p_attribute3  => l_supp_trade_profile_rec.attribute3,
        p_attribute4  => l_supp_trade_profile_rec.attribute4,
        p_attribute5  => l_supp_trade_profile_rec.attribute5,
        p_attribute6  => l_supp_trade_profile_rec.attribute6,
        p_attribute7  => l_supp_trade_profile_rec.attribute7,
        p_attribute8  => l_supp_trade_profile_rec.attribute8,
        p_attribute9  => l_supp_trade_profile_rec.attribute9,
        p_attribute10  => l_supp_trade_profile_rec.attribute10,
        p_attribute11  => l_supp_trade_profile_rec.attribute11,
        p_attribute12  => l_supp_trade_profile_rec.attribute12,
        p_attribute13  => l_supp_trade_profile_rec.attribute13,
        p_attribute14  => l_supp_trade_profile_rec.attribute14,
        p_attribute15  => l_supp_trade_profile_rec.attribute15,
        p_attribute16  => l_supp_trade_profile_rec.attribute16,
        p_attribute17  => l_supp_trade_profile_rec.attribute17,
        p_attribute18  => l_supp_trade_profile_rec.attribute18,
        p_attribute19  => l_supp_trade_profile_rec.attribute19,
        p_attribute20  => l_supp_trade_profile_rec.attribute20,
        p_attribute21  => l_supp_trade_profile_rec.attribute21,
        p_attribute22 => l_supp_trade_profile_rec.attribute22,
        p_attribute23 => l_supp_trade_profile_rec.attribute23,
        p_attribute24  => l_supp_trade_profile_rec.attribute24,
        p_attribute25  => l_supp_trade_profile_rec.attribute25,
        p_attribute26  => l_supp_trade_profile_rec.attribute26,
        p_attribute27  => l_supp_trade_profile_rec.attribute27,
        p_attribute28  => l_supp_trade_profile_rec.attribute28,
        p_attribute29  => l_supp_trade_profile_rec.attribute29,
        p_attribute30  => l_supp_trade_profile_rec.attribute30,
        p_dpp_attribute_category  => l_supp_trade_profile_rec.dpp_attribute_category,
        p_dpp_attribute1  => l_supp_trade_profile_rec.dpp_attribute1,
        p_dpp_attribute2  => l_supp_trade_profile_rec.dpp_attribute2,
        p_dpp_attribute3  => l_supp_trade_profile_rec.dpp_attribute3,
        p_dpp_attribute4  => l_supp_trade_profile_rec.dpp_attribute4,
        p_dpp_attribute5  => l_supp_trade_profile_rec.dpp_attribute5,
        p_dpp_attribute6  => l_supp_trade_profile_rec.dpp_attribute6,
        p_dpp_attribute7  => l_supp_trade_profile_rec.dpp_attribute7,
        p_dpp_attribute8  => l_supp_trade_profile_rec.dpp_attribute8,
        p_dpp_attribute9  => l_supp_trade_profile_rec.dpp_attribute9,
        p_dpp_attribute10 => l_supp_trade_profile_rec.dpp_attribute10,
        p_dpp_attribute11 => l_supp_trade_profile_rec.dpp_attribute11,
        p_dpp_attribute12 => l_supp_trade_profile_rec.dpp_attribute12,
        p_dpp_attribute13 => l_supp_trade_profile_rec.dpp_attribute13,
        p_dpp_attribute14 => l_supp_trade_profile_rec.dpp_attribute14,
        p_dpp_attribute15 => l_supp_trade_profile_rec.dpp_attribute15,
        p_dpp_attribute16 => l_supp_trade_profile_rec.dpp_attribute16,
        p_dpp_attribute17 => l_supp_trade_profile_rec.dpp_attribute17,
        p_dpp_attribute18 => l_supp_trade_profile_rec.dpp_attribute18,
        p_dpp_attribute19 => l_supp_trade_profile_rec.dpp_attribute19,
        p_dpp_attribute20 => l_supp_trade_profile_rec.dpp_attribute20,
        p_dpp_attribute21 => l_supp_trade_profile_rec.dpp_attribute21,
        p_dpp_attribute22 => l_supp_trade_profile_rec.dpp_attribute22,
        p_dpp_attribute23 => l_supp_trade_profile_rec.dpp_attribute23,
        p_dpp_attribute24 => l_supp_trade_profile_rec.dpp_attribute24,
        p_dpp_attribute25 => l_supp_trade_profile_rec.dpp_attribute25,
        p_dpp_attribute26 => l_supp_trade_profile_rec.dpp_attribute26,
        p_dpp_attribute27 => l_supp_trade_profile_rec.dpp_attribute27,
        p_dpp_attribute28 => l_supp_trade_profile_rec.dpp_attribute28,
        p_dpp_attribute29 => l_supp_trade_profile_rec.dpp_attribute29,
        p_dpp_attribute30 => l_supp_trade_profile_rec.dpp_attribute30,
        p_org_id       => l_org_id ,
        p_pre_approval_flag             =>      l_supp_trade_profile_rec.pre_approval_flag          ,
        p_approval_communication        =>      l_supp_trade_profile_rec.approval_communication    ,
        p_gl_contra_liability_acct      =>      l_supp_trade_profile_rec.gl_contra_liability_acct  ,
        p_gl_cost_adjustment_acct       =>      l_supp_trade_profile_rec.gl_cost_adjustment_acct   ,
        p_default_days_covered          =>      l_supp_trade_profile_rec.default_days_covered      ,
        p_create_claim_price_increase   =>      l_supp_trade_profile_rec.create_claim_price_increase ,
        p_authorization_period          =>      l_supp_trade_profile_rec.authorization_period      ,
        p_grace_days                    =>      l_supp_trade_profile_rec.grace_days                ,
        p_allow_qty_increase            =>      l_supp_trade_profile_rec.allow_qty_increase        ,
        p_qty_increase_tolerance        =>      l_supp_trade_profile_rec.qty_increase_tolerance   ,
        p_request_communication         =>      l_supp_trade_profile_rec.request_communication     ,
        p_claim_communication           =>      l_supp_trade_profile_rec.claim_communication       ,
        p_claim_frequency               =>      l_supp_trade_profile_rec.claim_frequency          ,
        p_claim_frequency_unit          =>      l_supp_trade_profile_rec.claim_frequency_unit      ,
        p_claim_computation_basis       =>      l_supp_trade_profile_rec.claim_computation_basis  ,
        p_claim_currency_code           =>      l_supp_trade_profile_rec.claim_currency_code,
        p_min_claim_amt                     =>  l_supp_trade_profile_rec.min_claim_amt,
        p_min_claim_amt_line_lvl        =>      l_supp_trade_profile_rec.min_claim_amt_line_lvl,
        p_auto_debit                        =>  l_supp_trade_profile_rec.auto_debit,
        p_days_before_claiming_debit => l_supp_trade_profile_rec.days_before_claiming_debit
 );

Line: 1325


      END IF; -- end of check for create or update of trade profile

Line: 1349


     ROLLBACK TO UPDATE_Supp_Trade_Profile_PVT;

Line: 1358


      ROLLBACK TO UPDATE_Supp_Trade_Profile_PVT;

Line: 1367


      ROLLBACK TO UPDATE_Supp_Trade_Profile_PVT;

Line: 1379


End Update_Supp_Trade_Profile;

Line: 1381


PROCEDURE Delete_Supp_Trade_Profile(
   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,
   x_return_status              OUT NOCOPY  VARCHAR2,
   x_msg_count                  OUT NOCOPY  NUMBER,
   x_msg_data                   OUT NOCOPY  VARCHAR2,
   p_supp_trade_profile_id                   IN  NUMBER,
   p_object_version_number      IN   NUMBER
                              )

IS
L_API_NAME                  CONSTANT VARCHAR2(30) := 'Delete_Supp_Trade_Profile';

Line: 1400


   SAVEPOINT Delete_Supp_Trade_Profile_PVT;

Line: 1424


      OZF_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');

Line: 1427


   OZF_supp_trd_prfls_PKG.Delete_Row(
          p_SUPP_TRADE_PROFILE_ID  => p_SUPP_TRADE_PROFILE_ID);

Line: 1453


     ROLLBACK TO Delete_Supp_Trade_Profile_PVT;

Line: 1463


      ROLLBACK TO Delete_Supp_Trade_Profile_PVT;

Line: 1472


      ROLLBACK TO Delete_Supp_Trade_Profile_PVT;

Line: 1484


End Delete_Supp_Trade_Profile;

Line: 1502


   SELECT SUPP_TRADE_PROFILE_ID
   FROM ozf_supp_trd_prfls_all
   WHERE SUPP_TRADE_PROFILE_ID = p_SUPP_TRADE_PROFILE_ID
   AND object_version_number = p_object_version
   FOR UPDATE NOWAIT;

Line: 1606


SELECT supp_trade_profile_id
FROM ozf_supp_trd_prfls
WHERE SUPPLIER_SITE_ID = l_supp_site_id
AND   SUPPLIER_ID = l_id;

Line: 1663


SELECT party_id
from   HZ_CUST_ACCOUNTS
WHERE  cust_account_id = c_id;