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

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

Line: 59


   SELECT PV_partner_profiles_S.NEXTVAL
   FROM DUAL;

Line: 64


   SELECT  'ANYTHING'
   FROM  PV_partner_profiles
   WHERE partner_profile_id = cv_partner_profile_id;

Line: 123


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

Line: 154


  INSERT INTO PV_partner_profiles (
       partner_profile_id
      ,last_update_date
      ,last_updated_by
      ,creation_date
      ,created_by
      ,last_update_login
      ,partner_id
      ,target_revenue_amt
      ,actual_revenue_amt
      ,target_revenue_pct
      ,actual_revenue_pct
      ,orig_system_reference
      ,orig_system_type
      ,capacity_size
      ,capacity_amount
      ,auto_match_allowed_flag
      ,purchase_method
      ,cm_id
      ,ph_support_rep
      --,security_group_id
      ,object_version_number
      ,lead_sharing_status
      ,lead_share_appr_flag
      ,partner_relationship_id
      ,partner_level
      ,preferred_vad_id
      ,partner_group_id
      ,partner_resource_id
      ,partner_group_number
      ,partner_resource_number
      ,sales_partner_flag
      ,indirectly_managed_flag
      ,channel_marketing_manager
      ,related_partner_id
      ,max_users
      ,partner_party_id
      ,status
      )
    VALUES (
       l_prtnr_prfls_rec.partner_profile_id
      ,SYSDATE                                -- LAST_UPDATE_DATE
      ,NVL(FND_GLOBAL.user_id,-1)             -- LAST_UPDATED_BY
      ,SYSDATE                                -- CREATION_DATE
      ,NVL(FND_GLOBAL.user_id,-1)             -- CREATED_BY
      ,NVL(FND_GLOBAL.conc_login_id,-1)       -- LAST_UPDATE_LOGIN
      ,l_prtnr_prfls_rec.partner_id
      ,l_prtnr_prfls_rec.target_revenue_amt
      ,l_prtnr_prfls_rec.actual_revenue_amt
      ,l_prtnr_prfls_rec.target_revenue_pct
      ,l_prtnr_prfls_rec.actual_revenue_pct
      ,l_prtnr_prfls_rec.orig_system_reference
      ,l_prtnr_prfls_rec.orig_system_type
      ,l_prtnr_prfls_rec.capacity_size
      ,l_prtnr_prfls_rec.capacity_amount
      ,l_prtnr_prfls_rec.auto_match_allowed_flag
      ,l_prtnr_prfls_rec.purchase_method
      ,l_prtnr_prfls_rec.cm_id
      ,l_prtnr_prfls_rec.ph_support_rep
      --,l_prtnr_prfls_rec.security_group_id
      ,l_object_version_number                -- object_version_number
      ,l_prtnr_prfls_rec.lead_sharing_status
      ,l_prtnr_prfls_rec.lead_share_appr_flag
      ,l_prtnr_prfls_rec.partner_relationship_id
      ,l_prtnr_prfls_rec.partner_level
      ,l_prtnr_prfls_rec.preferred_vad_id
      ,l_prtnr_prfls_rec.partner_group_id
      ,l_prtnr_prfls_rec.partner_resource_id
      ,l_prtnr_prfls_rec.partner_group_number
      ,l_prtnr_prfls_rec.partner_resource_number
      ,l_prtnr_prfls_rec.sales_partner_flag
      ,l_prtnr_prfls_rec.indirectly_managed_flag
      ,l_prtnr_prfls_rec.channel_marketing_manager
      ,l_prtnr_prfls_rec.related_partner_id
      ,l_prtnr_prfls_rec.max_users
      ,l_prtnr_prfls_rec.partner_party_id
      ,l_status
      );

Line: 302


PROCEDURE Delete_Prtnr_Prfls(
   p_api_version        IN  NUMBER
  ,p_init_msg_list      IN  VARCHAR2 := FND_API.g_false
  ,p_commit             IN  VARCHAR2 := FND_API.g_false

  ,x_return_status      OUT NOCOPY VARCHAR2
  ,x_msg_count          OUT NOCOPY NUMBER
  ,x_msg_data           OUT NOCOPY VARCHAR2

  ,p_partner_profile_id IN  NUMBER
  ,p_object_version     IN  NUMBER
  )
IS

   l_api_version CONSTANT NUMBER       := 1.0;

Line: 317


   l_api_name    CONSTANT VARCHAR2(30) := 'Delete_Prtnr_Prflss';

Line: 323


   SAVEPOINT Delete_Prtnr_Prfls;

Line: 346


      PVX_Utility_PVT.debug_message(l_full_name ||': delete');

Line: 349


   DELETE FROM PV_PARTNER_PROFILES
     WHERE partner_profile_id = p_partner_profile_id
     AND   object_version_number = p_object_version;

Line: 380


      ROLLBACK TO Delete_Prtnr_Prfls;

Line: 389


      ROLLBACK TO Delete_Prtnr_Prfls;

Line: 398


      ROLLBACK TO Delete_Prtnr_Prfls;

Line: 412


END Delete_Prtnr_Prfls;

Line: 440


   SELECT  partner_profile_id
     FROM  PV_PARTNER_PROFILES
     WHERE partner_profile_id = p_partner_profile_id
     AND   object_version_number = p_object_version
   FOR UPDATE OF partner_profile_id NOWAIT;

Line: 548


PROCEDURE Update_Prtnr_Prfls(
   p_api_version       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_prtnr_prfls_rec   IN  prtnr_prfls_rec_type
  )
IS

   l_api_version CONSTANT NUMBER := 1.0;

Line: 562


   l_api_name    CONSTANT VARCHAR2(30) := 'Update_Prtnr_Prfls';

Line: 567


   l_mode              VARCHAR2(30) := 'UPDATE';

Line: 578


    SELECT NVL(status, 'A') partner_status
      FROM pv_partner_profiles
      WHERE partner_profile_id = p_prtnr_prfls_rec.partner_profile_id;

Line: 584


  SELECT partner_id, partner_profile_id, object_version_number
  FROM pv_partner_profiles
  WHERE related_partner_id = var_partner_id;

Line: 593


  l_event_name                            VARCHAR2(240) := 'oracle.apps.pv.partner.Profile.updateStatus';

Line: 598


   SAVEPOINT Update_Prtnr_Prfls;

Line: 629


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

Line: 666


      PVX_Utility_PVT.debug_message(l_full_name ||': update');

Line: 719


     l_list.DELETE;

Line: 723


   UPDATE PV_PARTNER_PROFILES SET
       last_update_date           = SYSDATE
      ,last_updated_by            = NVL(FND_GLOBAL.user_id,-1)
      ,last_update_login          = NVL(FND_GLOBAL.conc_login_id,-1)
      ,PARTNER_ID                 = l_prtnr_prfls_rec.PARTNER_ID
      ,TARGET_REVENUE_AMT         = l_prtnr_prfls_rec.TARGET_REVENUE_AMT
      ,ACTUAL_REVENUE_AMT         = l_prtnr_prfls_rec.ACTUAL_REVENUE_AMT
      ,TARGET_REVENUE_PCT         = l_prtnr_prfls_rec.TARGET_REVENUE_PCT
      ,ACTUAL_REVENUE_PCT         = l_prtnr_prfls_rec.ACTUAL_REVENUE_PCT
      ,ORIG_SYSTEM_REFERENCE      = l_prtnr_prfls_rec.ORIG_SYSTEM_REFERENCE
      ,ORIG_SYSTEM_TYPE           = l_prtnr_prfls_rec.ORIG_SYSTEM_TYPE
      ,CAPACITY_SIZE              = l_prtnr_prfls_rec.CAPACITY_SIZE
      ,CAPACITY_AMOUNT            = l_prtnr_prfls_rec.CAPACITY_AMOUNT
      ,AUTO_MATCH_ALLOWED_FLAG    = l_prtnr_prfls_rec.AUTO_MATCH_ALLOWED_FLAG
      ,PURCHASE_METHOD            = l_prtnr_prfls_rec.PURCHASE_METHOD
      ,CM_ID                      = l_prtnr_prfls_rec.CM_ID
      ,PH_SUPPORT_REP             = l_prtnr_prfls_rec.PH_SUPPORT_REP
      --,security_group_id          = l_prtnr_prfls_rec.security_group_id
      ,object_version_number      = l_prtnr_prfls_rec.object_version_number + 1
      ,lead_sharing_status        = l_prtnr_prfls_rec.lead_sharing_status
      ,lead_share_appr_flag       = l_prtnr_prfls_rec.lead_share_appr_flag
      ,partner_relationship_id    = l_prtnr_prfls_rec.partner_relationship_id
      ,partner_level              = l_prtnr_prfls_rec.partner_level
      ,preferred_vad_id           = l_prtnr_prfls_rec.preferred_vad_id
      ,partner_group_id           = l_prtnr_prfls_rec.partner_group_id
      ,partner_resource_id        = l_prtnr_prfls_rec.partner_resource_id
      ,partner_group_number       = l_prtnr_prfls_rec.partner_group_number
      ,partner_resource_number    = l_prtnr_prfls_rec.partner_resource_number
      ,sales_partner_flag         = l_prtnr_prfls_rec.sales_partner_flag
      ,indirectly_managed_flag    = l_prtnr_prfls_rec.indirectly_managed_flag
      ,channel_marketing_manager  = l_prtnr_prfls_rec.channel_marketing_manager
      ,related_partner_id         = l_prtnr_prfls_rec.related_partner_id
      ,max_users                  = l_prtnr_prfls_rec.max_users
      ,partner_party_id           = l_prtnr_prfls_rec.partner_party_id
      ,status                     = l_status
   WHERE partner_profile_id    = l_prtnr_prfls_rec.partner_profile_id
   AND   object_version_number = l_prtnr_prfls_rec.object_version_number;

Line: 802


      PVX_PRTNR_PRFLS_PVT.Update_Prtnr_Prfls(
       p_api_version       => p_api_version
      ,p_init_msg_list     => p_init_msg_list
      ,p_commit            => p_commit
      ,p_validation_level  => p_validation_level

      ,x_return_status     => x_return_status
      ,x_msg_count         => x_msg_count
      ,x_msg_data          => x_msg_data
      ,p_prtnr_prfls_rec   => rel_prtnr_prfls_rec
      );

Line: 853


      ROLLBACK TO Update_Prtnr_Prfls;

Line: 862


      ROLLBACK TO Update_Prtnr_Prfls;

Line: 871


      ROLLBACK TO Update_Prtnr_Prfls;

Line: 885


END Update_Prtnr_Prfls;

Line: 1028


      SELECT subject_id vendor_party_id,
             start_date,
             end_date,
             status
        FROM hz_relationships
        WHERE party_id = p_party_id
          AND object_id = p_partner_party_id;

Line: 1037


      SELECT NVL(status, 'A') party_status
        FROM hz_parties
        WHERE party_id = p_party_id;

Line: 1042


      SELECT start_date_active,
             end_date_active
        FROM jtf_rs_resource_extns
        WHERE resource_id = p_resource_id;

Line: 1362


  ,p_mode            IN  VARCHAR2 := 'INSERT'
  ,x_return_status   OUT NOCOPY VARCHAR2
)
IS
BEGIN

   x_return_status := FND_API.g_ret_sts_success;

Line: 1369


   /* Raise an error if already NOT NULL value for CM_ID is being updated to null.
   */
   IF p_complete_rec.cm_id IS NOT NULL THEN
     IF p_prtnr_prfls_rec.cm_id IS NULL THEN
       --OR p_prtnr_prfls_rec.cm_id = FND_API.G_MISS_NUM
       FND_MESSAGE.Set_name('PV','PV_CM_ID_UPDATE_VIOLATION');

Line: 1398


      x_prtnr_prfls_rec.LAST_UPDATE_DATE          := FND_API.G_MISS_DATE;

Line: 1399


      x_prtnr_prfls_rec.LAST_UPDATED_BY           := FND_API.G_MISS_NUM;

Line: 1402


      x_prtnr_prfls_rec.LAST_UPDATE_LOGIN         := FND_API.G_MISS_NUM;

Line: 1450


   SELECT *
     FROM  PV_PARTNER_PROFILES
     WHERE partner_profile_id = p_prtnr_prfls_rec.partner_profile_id;