APPS.OZF_TRADE_PROFILE_PVT SQL Statements

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

Line: 21

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: 36

   SELECT *
     FROM ozf_cust_trd_prfls_all
     WHERE trade_profile_id = p_trade_profile_rec.trade_profile_id;

Line: 93

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

Line: 96

   IF p_trade_profile_rec.program_update_date is null THEN
      x_complete_rec.program_update_date := l_trade_profile_rec.program_update_date;

Line: 353

      SELECT cust_acct_site_id
      from   HZ_CUST_SITE_USES
      WHERE  site_use_id = a_id;

Line: 358

      SELECT vendor_site_code
      from   PO_VENDOR_SITES
      WHERE  vendor_site_id = a_id;

Line: 444

      SELECT ozf_cust_trd_prfls_all_s.NEXTVAL
      FROM dual;

Line: 448

      SELECT count(trade_profile_id)
      FROM   ozf_cust_trd_prfls_all
      WHERE  TRADE_PROFILE_ID = l_id;

Line: 453

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

Line: 459

      SELECT party_id
      from   HZ_CUST_ACCOUNTS
      WHERE  cust_account_id = c_id;

Line: 584

      OZF_cust_trd_prfls_PKG.Insert_Row(
         px_trade_profile_id  => l_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_trade_profile_rec.request_id,
         p_program_application_id  => l_trade_profile_rec.program_application_id,
         p_program_update_date  => l_trade_profile_rec.program_update_date,
         p_program_id  => l_trade_profile_rec.program_id,
         p_created_from  => l_trade_profile_rec.created_from,
         p_party_id  => l_trade_profile_rec.party_id,
         p_site_use_id  => l_trade_profile_rec.site_use_id,
         p_autopay_flag  => l_trade_profile_rec.autopay_flag,
         p_claim_threshold  => l_trade_profile_rec.claim_threshold,
         p_claim_currency  => l_trade_profile_rec.claim_currency,
         p_print_flag  => l_trade_profile_rec.print_flag,
         p_internet_deal_view_flag  => l_trade_profile_rec.internet_deal_view_flag,
         p_internet_claims_flag  => l_trade_profile_rec.internet_claims_flag,
         p_autopay_periodicity  => l_trade_profile_rec.autopay_periodicity,
         p_autopay_periodicity_type  => l_trade_profile_rec.autopay_periodicity_type,
         p_payment_method  => l_trade_profile_rec.payment_method,
         p_discount_type  => l_trade_profile_rec.discount_type,
         p_cust_account_id  => l_trade_profile_rec.cust_account_id,
         p_cust_acct_site_id  => l_trade_profile_rec.cust_acct_site_id,
         p_vendor_id  => l_trade_profile_rec.vendor_id,
         p_vendor_site_id  => l_trade_profile_rec.vendor_site_id,
         p_vendor_site_code  => l_trade_profile_rec.vendor_site_code,
         p_context  => l_trade_profile_rec.context,
         p_attribute_category  => l_trade_profile_rec.attribute_category,
         p_attribute1  => l_trade_profile_rec.attribute1,
         p_attribute2  => l_trade_profile_rec.attribute2,
         p_attribute3  => l_trade_profile_rec.attribute3,
         p_attribute4  => l_trade_profile_rec.attribute4,
         p_attribute5  => l_trade_profile_rec.attribute5,
         p_attribute6  => l_trade_profile_rec.attribute6,
         p_attribute7  => l_trade_profile_rec.attribute7,
         p_attribute8  => l_trade_profile_rec.attribute8,
         p_attribute9  => l_trade_profile_rec.attribute9,
         p_attribute10  => l_trade_profile_rec.attribute10,
         p_attribute11  => l_trade_profile_rec.attribute11,
         p_attribute12  => l_trade_profile_rec.attribute12,
         p_attribute13  => l_trade_profile_rec.attribute13,
         p_attribute14  => l_trade_profile_rec.attribute14,
         p_attribute15  => l_trade_profile_rec.attribute15,
         px_org_id  => l_trade_profile_rec.org_id,
         p_days_due  => l_trade_profile_rec.days_due,
	 p_pos_write_off_threshold	=>	l_trade_profile_rec.pos_write_off_threshold,
	 p_neg_write_off_threshold	=>	l_trade_profile_rec.neg_write_off_threshold,
	 p_un_earned_pay_allow_to	=>	l_trade_profile_rec.un_earned_pay_allow_to,
	 p_un_earned_pay_thold_type	=>	l_trade_profile_rec.un_earned_pay_thold_type,
	 p_un_earned_pay_threshold	=>	l_trade_profile_rec.un_earned_pay_threshold,
	 p_un_earned_pay_thold_flag	=>	l_trade_profile_rec.un_earned_pay_thold_flag,
   	 p_header_tolerance_calc_code	=>	l_trade_profile_rec.header_tolerance_calc_code,
	 p_header_tolerance_operand	=>	l_trade_profile_rec.header_tolerance_operand,
	 p_line_tolerance_calc_code	=>	l_trade_profile_rec.line_tolerance_calc_code,
	 p_line_tolerance_operand	=>	l_trade_profile_rec.line_tolerance_operand
         );

Line: 715

PROCEDURE Update_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_trade_profile_rec               IN    trade_profile_rec_type,
   x_object_version_number      OUT NOCOPY  NUMBER
                               )
IS
   L_API_NAME                  CONSTANT VARCHAR2(30) := 'Update_Trade_Profile';

Line: 738

   SELECT *
     FROM ozf_cust_trd_prfls_all
     WHERE trade_profile_id = p_trade_profile_rec.trade_profile_id;

Line: 743

     SELECT *
     FROM  ozf_cust_trd_prfls_all
     WHERE trade_profile_id = v_trade_profile_id;

Line: 748

      SELECT cust_acct_site_id
      from HZ_CUST_SITE_USES
      WHERE site_use_id = a_id;

Line: 760

   SELECT  cust_account_id
   FROM    ozf_cust_trd_prfls_all   -- R12 Enhancements
   WHERE   trade_profile_id = p_id;*/

Line: 765

   SELECT  site_use_id
   FROM    ozf_cust_trd_prfls_all   --For R12.1 Enhancements
   WHERE   trade_profile_id = p_id;

Line: 772

   SAVEPOINT UPDATE_Trade_Profile_PVT;

Line: 795

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

Line: 833

        OZF_UTILITY_PVT.debug_message('before create in update!!');

Line: 856

   ELSE -- update for existing trade profiles at party or account levels
      -- complete the record (get missing values filled from db)
      Complete_trade_profile_Rec(
         p_trade_profile_rec   => p_trade_profile_rec,
         x_complete_rec        => l_trade_profile_rec
      );

Line: 863

           OZF_UTILITY_PVT.debug_message('into update part');

Line: 880

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

Line: 910

      OZF_cust_trd_prfls_PKG.Update_Row(
             p_trade_profile_id  => l_trade_profile_rec.trade_profile_id,
             p_object_version_number  => l_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_trade_profile_rec.request_id,
             p_program_application_id  => l_trade_profile_rec.program_application_id,
             p_program_update_date  => l_trade_profile_rec.program_update_date,
             p_program_id  => l_trade_profile_rec.program_id,
             p_created_from  => l_trade_profile_rec.created_from,
             p_party_id  => l_trade_profile_rec.party_id,
             p_site_use_id  => l_trade_profile_rec.site_use_id,
             p_autopay_flag  => l_trade_profile_rec.autopay_flag,
             p_claim_threshold  => l_trade_profile_rec.claim_threshold,
             p_claim_currency  => l_trade_profile_rec.claim_currency,
             p_print_flag  => l_trade_profile_rec.print_flag,
             p_internet_deal_view_flag  => l_trade_profile_rec.internet_deal_view_flag,
             p_internet_claims_flag  => l_trade_profile_rec.internet_claims_flag,
             p_autopay_periodicity  => l_trade_profile_rec.autopay_periodicity,
             p_autopay_periodicity_type  => l_trade_profile_rec.autopay_periodicity_type,
             p_payment_method  => p_trade_profile_rec.payment_method,
             p_discount_type  => l_trade_profile_rec.discount_type,
             p_cust_account_id  => l_trade_profile_rec.cust_account_id,
             p_cust_acct_site_id  => l_trade_profile_rec.cust_acct_site_id,
             p_vendor_id  => l_trade_profile_rec.vendor_id,
             p_vendor_site_id  => l_trade_profile_rec.vendor_site_id,
             p_vendor_site_code  => l_trade_profile_rec.vendor_site_code,
             p_context  => l_trade_profile_rec.context,
             p_attribute_category  => l_trade_profile_rec.attribute_category,
             p_attribute1  => l_trade_profile_rec.attribute1,
             p_attribute2  => l_trade_profile_rec.attribute2,
             p_attribute3  => l_trade_profile_rec.attribute3,
             p_attribute4  => l_trade_profile_rec.attribute4,
             p_attribute5  => l_trade_profile_rec.attribute5,
             p_attribute6  => p_trade_profile_rec.attribute6,
             p_attribute7  => l_trade_profile_rec.attribute7,
             p_attribute8  => l_trade_profile_rec.attribute8,
             p_attribute9  => l_trade_profile_rec.attribute9,
             p_attribute10  => l_trade_profile_rec.attribute10,
             p_attribute11  => l_trade_profile_rec.attribute11,
             p_attribute12  => l_trade_profile_rec.attribute12,
             p_attribute13  => l_trade_profile_rec.attribute13,
             p_attribute14  => l_trade_profile_rec.attribute14,
             p_attribute15  => l_trade_profile_rec.attribute15,
             p_org_id  => l_org_id,
             p_days_due  => l_trade_profile_rec.days_due,
    	     p_pos_write_off_threshold	=>	l_trade_profile_rec.pos_write_off_threshold,
	     p_neg_write_off_threshold	=>	l_trade_profile_rec.neg_write_off_threshold,
	     p_un_earned_pay_allow_to	=>	l_trade_profile_rec.un_earned_pay_allow_to,
    	     p_un_earned_pay_thold_type	=>	l_trade_profile_rec.un_earned_pay_thold_type,
	     p_un_earned_pay_threshold	=>	l_trade_profile_rec.un_earned_pay_threshold,
	     p_un_earned_pay_thold_flag	=>	l_trade_profile_rec.un_earned_pay_thold_flag,
    	     p_header_tolerance_calc_code	=>	l_trade_profile_rec.header_tolerance_calc_code,
	     p_header_tolerance_operand	=>	l_trade_profile_rec.header_tolerance_operand,
	     p_line_tolerance_calc_code	=>	l_trade_profile_rec.line_tolerance_calc_code,
    	     p_line_tolerance_operand	=>	l_trade_profile_rec.line_tolerance_operand
 );

Line: 970

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

Line: 994

     ROLLBACK TO UPDATE_Trade_Profile_PVT;

Line: 1003

      ROLLBACK TO UPDATE_Trade_Profile_PVT;

Line: 1012

      ROLLBACK TO UPDATE_Trade_Profile_PVT;

Line: 1024

End Update_Trade_Profile;

Line: 1026

PROCEDURE Delete_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_trade_profile_id                   IN  NUMBER,
   p_object_version_number      IN   NUMBER
                              )

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

Line: 1045

   SAVEPOINT DELETE_Trade_Profile_PVT;

Line: 1069

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

Line: 1072

   OZF_cust_trd_prfls_PKG.Delete_Row(
          p_TRADE_PROFILE_ID  => p_TRADE_PROFILE_ID);

Line: 1097

     ROLLBACK TO DELETE_Trade_Profile_PVT;

Line: 1107

      ROLLBACK TO DELETE_Trade_Profile_PVT;

Line: 1116

      ROLLBACK TO DELETE_Trade_Profile_PVT;

Line: 1128

End Delete_Trade_Profile;

Line: 1146

   SELECT TRADE_PROFILE_ID
   FROM ozf_cust_trd_prfls_all
   WHERE TRADE_PROFILE_ID = p_TRADE_PROFILE_ID
   AND object_version_number = p_object_version
   FOR UPDATE NOWAIT;

Line: 1253

SELECT count(cust_account_id)
FROM ozf_cust_trd_prfls
WHERE CUST_ACCOUNT_ID = l_id;*/

Line: 1261

SELECT count(party_id)
FROM ozf_cust_trd_prfls
WHERE CUST_ACCOUNT_ID is NULL
AND   PARTY_ID = l_id;

Line: 1269

SELECT count(site_use_id)
FROM ozf_cust_trd_prfls
WHERE site_use_id = l_id;

Line: 1340

SELECT party_id
from   HZ_CUST_ACCOUNTS
WHERE  cust_account_id = c_id;