APPS.AS_OPPORTUNITY_VUHK SQL Statements

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

Line: 97

PROCEDURE Update_Opp_Header_Pre
(   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,
    p_check_access_flag        IN     VARCHAR2,
    p_admin_flag               IN     VARCHAR2,
    p_admin_group_id           IN     NUMBER,
    p_identity_salesforce_id   IN     NUMBER,
    p_profile_tbl              IN     AS_UTILITY_PUB.PROFILE_TBL_TYPE,
    p_partner_cont_party_id    IN     NUMBER,
    p_header_rec               IN     AS_OPPORTUNITY_PUB.Header_Rec_Type,
    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_opp_header_pre';

Line: 118

       select fnd_profile.value('PV_USER_TYPE'),
              a.channel_code,
              decode(nvl(c.channel_lookup_code,'0'), '0', 'N', c.indirect_channel_flag ),
              a.prm_assignment_type
       from   as_leads_all a, pv_channel_types c
       where  a.lead_id                 = pc_lead_id
       and    a.channel_code            = c.channel_lookup_code(+)
       and    c.channel_lookup_type (+) = 'SALES_CHANNEL';

Line: 129

      select
             a.meaning,
             nvl(b.indirect_channel_flag, 'N')
      from   oe_lookups a, pv_channel_types b
      where  a.lookup_type  = 'SALES_CHANNEL'
      and    a.lookup_code  = pc_code
      and    a.lookup_type  = b.channel_lookup_type (+)
      and    a.lookup_code  = b.channel_lookup_code (+);

Line: 227

   PV_OPPORTUNITY_VHUK.Update_Opportunity_Pre (
      p_api_version_number      => 1.0,
      p_init_msg_list           => p_init_msg_list,
      p_commit                  => p_commit,
      p_validation_level        => p_validation_level,
      p_oppty_header_rec        => P_Header_Rec ,
      p_salesforce_id           => P_Identity_Salesforce_Id,
      x_return_status           => x_return_status,
      x_msg_count               => x_msg_count,
      x_msg_data                => x_msg_data);

Line: 267

END update_opp_header_pre;

Line: 271

PROCEDURE Update_Opp_Header_Post
(   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,
    p_check_access_flag        IN     VARCHAR2,
    p_admin_flag               IN     VARCHAR2,
    p_admin_group_id           IN     NUMBER,
    p_identity_salesforce_id   IN     NUMBER,
    p_profile_tbl              IN     AS_UTILITY_PUB.PROFILE_TBL_TYPE,
    p_partner_cont_party_id    IN     NUMBER,
    p_header_rec               IN     AS_OPPORTUNITY_PUB.Header_Rec_Type,
    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_opp_header_pre';

Line: 294

   PV_OPPORTUNITY_VHUK.Update_Opportunity_Post (
      p_api_version_number      => 1.0,
      p_init_msg_list           => p_init_msg_list,
      p_commit                  => p_commit,
      p_validation_level        => p_validation_level,
      p_oppty_header_rec        => P_Header_Rec ,
      p_salesforce_id           => P_Identity_Salesforce_Id,
      x_return_status           => x_return_status,
      x_msg_count               => x_msg_count,
      x_msg_data                => x_msg_data);

Line: 336

END update_opp_header_post;