APPS.AS_INTEREST_PUB SQL Statements

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

Line: 77

    l_mode                      constant varchar2(30) := 'ON-INSERT';

Line: 254

PROCEDURE Update_Interest
(   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_identity_salesforce_id  IN    NUMBER := NULL,
    p_interest_rec      IN  INTEREST_REC_TYPE := G_MISS_INTEREST_REC,
    p_interest_use_code IN  VARCHAR2,
    p_check_access_flag   IN VARCHAR2,
    p_admin_flag          IN VARCHAR2,
    p_admin_group_id      IN NUMBER,
     p_access_profile_rec  IN  AS_ACCESS_PUB.ACCESS_PROFILE_REC_TYPE,
    x_return_status     OUT NOCOPY  VARCHAR2,
    x_msg_count     OUT NOCOPY  NUMBER,
    x_msg_data      OUT NOCOPY  VARCHAR2,
    x_interest_id       OUT NOCOPY     NUMBER
) is

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

Line: 281

    l_mode                      constant varchar2(30) := 'ON-UPDATE';

Line: 284

    l_module CONSTANT VARCHAR2(255) := 'as.plsql.intpb.Update_Interest';

Line: 290

    SAVEPOINT UPDATE_INTEREST_PUB;

Line: 346

    l_interest_rec.last_update_date := p_interest_rec.last_update_date;

Line: 347

    l_interest_rec.last_updated_by := p_interest_rec.last_updated_by;

Line: 350

    l_interest_rec.last_update_login := p_interest_rec.last_update_login;

Line: 370

    AS_INTEREST_PVT.Update_Interest ( p_api_version_number    => 2.0,
                                      p_init_msg_list         => FND_API.G_FALSE,
                                      p_commit                => FND_API.G_FALSE,
                                      p_validation_level      => p_validation_level,
                      p_identity_salesforce_id=> p_identity_salesforce_id,
                                      p_interest_rec          => l_interest_rec,
                                      p_interest_use_code     => p_interest_use_code,
                                 p_check_access_flag     => p_check_access_flag,
                                 p_admin_flag            => p_admin_flag,
                                 p_admin_group_id        => p_admin_group_id,
                               p_access_profile_rec    => p_access_profile_rec,
                                      x_return_status         => x_return_status,
                                      x_msg_count             => x_msg_count,
                                      x_msg_data              => x_msg_data,
                                      x_interest_id       => l_interest_id
    );

Line: 461

  END Update_Interest;

Line: 496

      SELECT  ais.interest_status_code
      FROM  as_interest_statuses ais, as_lookups lkp
      WHERE nls_upper(X_Int_Status) = nls_upper(lkp.meaning)
        and product_category_id = X_Product_Category_Id
        and product_cat_set_id = X_Product_Cat_Set_Id
        and ais.interest_status_code = lkp.lookup_code
        and lkp.lookup_type = 'INTEREST_STATUS';

Line: 695

      SELECT  interest_type_id
      FROM  as_interest_types_vl
      WHERE nls_upper(X_Int_Type) = nls_upper(interest_type)
      and (interest_type like nls_upper(substr(X_Int_Type, 1, 1) || '%') or
         interest_type like lower(substr(X_Int_Type, 1, 1) || '%'));

Line: 702

      SELECT  interest_code_id
      FROM  as_interest_codes_v
     WHERE nls_upper(X_Int_Code) = nls_upper(code)
      and   interest_type_id = X_Int_Type_Id;

Line: 710

      SELECT description
      FROM as_interest_codes_v
      WHERE interest_code_id = p_interest_code_id
      and interest_type_id = p_interest_type_id;

Line: 716

      SELECT description
      FROM as_interest_types_vl
      WHERE interest_type_id = p_interest_type_id;

Line: 955

PROCEDURE Delete_Interest
(   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_identity_salesforce_id  IN    NUMBER,
    p_interest_rec      IN  INTEREST_REC_TYPE := G_MISS_INTEREST_REC,
    p_interest_use_code IN  VARCHAR2,
     p_check_access_flag   in  varchar2,
     p_admin_flag          in  varchar2,
     p_admin_group_id      in  number,
     p_access_profile_rec  IN  AS_ACCESS_PUB.ACCESS_PROFILE_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) := 'Delete_Interest';

Line: 975

 l_module CONSTANT VARCHAR2(255) := 'as.plsql.intpb.Delete_Interest';

Line: 977

    SAVEPOINT DELETE_INTEREST_PUB;

Line: 1010

                   'Public API: Calling AS_ACCESS_PVT.delete_interest');

Line: 1018

    as_interest_pvt.Delete_Interest ( p_api_version_number    => 2.0,
                                      p_init_msg_list         => FND_API.G_FALSE,
                                      p_commit                => FND_API.G_FALSE,
                                      p_validation_level      => p_validation_level,
                      p_identity_salesforce_id=> p_identity_salesforce_id,
                                      p_interest_rec          => l_interest_rec,
                                      p_interest_use_code     => p_interest_use_code,
                                 p_check_access_flag     => p_check_access_flag,
                                 p_admin_flag            => p_admin_flag,
                                 p_admin_group_id        => p_admin_group_id,
                               p_access_profile_rec    => p_access_profile_rec,
                                      x_return_status         => x_return_status,
                                      x_msg_count             => x_msg_count,
                                      x_msg_data              => x_msg_data
                        );

Line: 1103

End delete_interest;