APPS.HZ_DSS_SETUP_PUB SQL Statements

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

Line: 132

    HZ_DSS_ENTITIES_PKG.Insert_Row (
        x_rowid                 => row_id,
        x_entity_id             => x_entity_id,
        x_status                => nvl(p_dss_entity_profile.status,'A') ,
        x_object_id             => p_dss_entity_profile.object_id,
        x_instance_set_id       => p_dss_entity_profile.instance_set_id,
        x_parent_entity_id      => p_dss_entity_profile.parent_entity_id,
        x_parent_fk_column1     => p_dss_entity_profile.parent_fk_column1,
        x_parent_fk_column2     => p_dss_entity_profile.parent_fk_column2,
        x_parent_fk_column3     => p_dss_entity_profile.parent_fk_column3,
        x_parent_fk_column4     => p_dss_entity_profile.parent_fk_column4,
        x_parent_fk_column5     => p_dss_entity_profile.parent_fk_column5,
        x_group_assignment_level=> p_dss_entity_profile.group_assignment_level ,
        x_object_version_number  => 1
    );

Line: 189

 * PROCEDURE update_entity_profile
 *
 * DESCRIPTION
 *     Updates entity profile.
 *
 * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
 *
 *
 * ARGUMENTS
 *
 *
 * NOTES
 *
 * MODIFICATION HISTORY
 *
 *   08-06 -2002    Colathur Vijayan ("VJN")        o Created.
 *
 */

PROCEDURE update_entity_profile(
    p_init_msg_list           IN        VARCHAR2,
    p_dss_entity_profile      IN        DSS_ENTITY_PROFILE_TYPE,
    x_object_version_number   IN OUT NOCOPY    NUMBER,
    x_return_status           OUT NOCOPY       VARCHAR2,
    x_msg_count               OUT NOCOPY       NUMBER,
    x_msg_data                OUT NOCOPY       VARCHAR2
) IS
    l_object_version_number           NUMBER;

Line: 224

    SAVEPOINT update_entity_profile;

Line: 237

        SELECT object_version_number, rowid , object_id, instance_set_id
        INTO   l_object_version_number, l_rowid , l_object_id , l_instance_set_id
        FROM   HZ_DSS_ENTITIES
        WHERE  entity_id = p_dss_entity_profile.entity_id
        FOR UPDATE NOWAIT;

Line: 277

       FND_MESSAGE.SET_NAME('AR', 'HZ_API_NONUPDATEABLE_TO_NULL');

Line: 300

        FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NONUPDATEABLE_COLUMN' );

Line: 310

        FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NONUPDATEABLE_COLUMN' );

Line: 329

    HZ_DSS_ENTITIES_PKG.Update_Row (
        x_rowid                 => l_rowid,
        x_status                => p_dss_entity_profile.status,
        x_object_id             => p_dss_entity_profile.object_id,
        x_instance_set_id       => p_dss_entity_profile.instance_set_id,
        x_parent_entity_id      => p_dss_entity_profile.parent_entity_id,
        x_parent_fk_column1     => p_dss_entity_profile.parent_fk_column1,
        x_parent_fk_column2     => p_dss_entity_profile.parent_fk_column2,
        x_parent_fk_column3     => p_dss_entity_profile.parent_fk_column3,
        x_parent_fk_column4     => p_dss_entity_profile.parent_fk_column4,
        x_parent_fk_column5     => p_dss_entity_profile.parent_fk_column5,
        x_group_assignment_level=> p_dss_entity_profile.group_assignment_level ,
        x_object_version_number => x_object_version_number );

Line: 352

        ROLLBACK TO update_entity_profile;

Line: 360

        ROLLBACK TO update_entity_profile;

Line: 368

        ROLLBACK TO update_entity_profile;

Line: 377

END update_entity_profile ;

Line: 433

     select count(*) into l_duplicate_count
     from HZ_DSS_SCHEME_FUNCTIONS
     where security_scheme_code = p_dss_scheme_function.security_scheme_code
     and   data_operation_code  = p_dss_scheme_function.data_operation_code;

Line: 509

    HZ_DSS_SCHEME_FUNCTIONS_PKG.Insert_Row (
           x_rowid => row_id,
           x_security_scheme_code => p_dss_scheme_function.security_scheme_code,
           x_data_operation_code => p_dss_scheme_function.data_operation_code,
           x_function_id => p_dss_scheme_function.function_id,
           x_status => nvl(p_dss_scheme_function.status, 'A'),
           x_object_version_number => 1 );

Line: 557

 * PROCEDURE update_scheme_function
 *
 * DESCRIPTION
 *     Updates Security Scheme.
 *
 * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
 *
 *
 * ARGUMENTS
 *
 *
 * NOTES
 *
 * MODIFICATION HISTORY
 *
 *   08-06 -2002    Colathur Vijayan ("VJN")        o Created.
 *
 */
PROCEDURE update_scheme_function (
  p_init_msg_list          IN  VARCHAR2,
  p_dss_scheme_function    IN  dss_scheme_function_type,
  x_object_version_number  IN OUT NOCOPY NUMBER,
  x_return_status          OUT NOCOPY VARCHAR2,
  x_msg_count              OUT NOCOPY NUMBER,
  x_msg_data               OUT NOCOPY VARCHAR2
)
 IS
    l_object_version_number           NUMBER;

Line: 589

    SAVEPOINT update_scheme_function ;

Line: 603

        SELECT object_version_number, rowid
        INTO   l_object_version_number, l_rowid
        FROM   HZ_DSS_SCHEME_FUNCTIONS
        WHERE  security_scheme_code = p_dss_scheme_function.security_scheme_code and
               data_operation_code  = p_dss_scheme_function.data_operation_code and
               function_id = p_dss_scheme_function.function_id
        FOR UPDATE NOWAIT;

Line: 642

    HZ_DSS_SCHEME_FUNCTIONS_PKG.Update_Row (
            x_rowid                      => l_rowid,
            x_status                     => p_dss_scheme_function.status,
            x_object_version_number      => x_object_version_number
) ;

Line: 657

        ROLLBACK TO update_scheme_function ;

Line: 665

        ROLLBACK TO update_scheme_function ;

Line: 673

        ROLLBACK TO update_scheme_function ;

Line: 682

END update_scheme_function ;