APPS.CSI_HZ_LOCATIONS_PVT SQL Statements

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

Line: 38

    p_last_update_date           IN   DATE    ,
    p_last_updated_by            IN   NUMBER  ,
    p_creation_date              IN   DATE    ,
    p_created_by                 IN   NUMBER  ,
    p_created_by_module          IN   VARCHAR2,
    x_location_id                OUT NOCOPY  NUMBER  ,
    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) := 'create_location';

Line: 124

          SELECT  'x'
          INTO    l_dummy
          FROM    hz_locations
          WHERE   clli_code = l_location_rec.clli_code;

Line: 179

PROCEDURE update_location(
    p_api_version                IN   NUMBER,
    p_commit                     IN   VARCHAR2   := fnd_api.g_false,
    p_init_msg_list              IN   VARCHAR2   := fnd_api.g_false,
    p_validation_level           IN   NUMBER     := fnd_api.g_valid_level_full,
    p_location_id                IN   NUMBER,
    p_country                    IN   VARCHAR2,
    p_address1                   IN   VARCHAR2,
    p_address2                   IN   VARCHAR2,
    p_address3                   IN   VARCHAR2,
    p_address4                   IN   VARCHAR2,
    p_city                       IN   VARCHAR2,
    p_postal_code                IN   VARCHAR2,
    p_state                      IN   VARCHAR2,
    p_province                   IN   VARCHAR2,
    p_county                     IN   VARCHAR2,
    p_clli_code                  IN   VARCHAR2,
    p_description                IN   VARCHAR2,
    p_last_update_date           IN   DATE    ,
    p_last_updated_by            IN   NUMBER  ,
    p_creation_date              IN   DATE    ,
    p_created_by                 IN   NUMBER  ,
    p_created_by_module          IN   VARCHAR2,
    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_location';

Line: 215

   SAVEPOINT update_location_pvt;

Line: 239

         csi_gen_utility_pvt.put_line( 'update_location');

Line: 293

           SELECT object_version_number
           INTO   l_object_version_number
           FROM   hz_locations
           WHERE  location_id = l_location_rec.location_id;

Line: 309

          SELECT  'x'
          INTO    l_dummy
          FROM    hz_locations
          WHERE   clli_code = l_location_rec.clli_code
          AND     location_id <> l_location_rec.location_id;

Line: 331

  hz_location_v2pub.update_location(p_init_msg_list     => p_init_msg_list
                                  ,p_location_rec      => l_location_rec
                                  ,p_object_version_number => l_object_version_number
                                  ,x_return_status     => x_return_status
                                  ,x_msg_count         => x_msg_count
                                  ,x_msg_data          => x_msg_data
                                  );

Line: 354

   ROLLBACK TO update_location_pvt;

Line: 360

END update_location;

Line: 368

    p_last_update_date              DATE    ,
    p_last_updated_by               NUMBER  ,
    p_creation_date                 DATE    ,
    p_created_by                    NUMBER  ,
    p_country                       VARCHAR2,
    p_address1                      VARCHAR2,
    p_address2                      VARCHAR2,
    p_address3                      VARCHAR2,
    p_address4                      VARCHAR2,
    p_city                          VARCHAR2,
    p_postal_code                   VARCHAR2,
    p_state                         VARCHAR2,
    p_province                      VARCHAR2,
    p_county                        VARCHAR2,
    p_clli_code                     VARCHAR2,
    p_description                   VARCHAR2,
    p_created_by_module             VARCHAR2
    )
   IS
   CURSOR C IS
        SELECT *
          FROM hz_locations
         WHERE location_id = p_location_id
         FOR UPDATE of location_id NOWAIT;

Line: 398

        FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');

Line: 407

       AND (    ( recinfo.last_update_date = p_last_update_date)
            OR (    ( recinfo.last_update_date IS NULL )
                AND (  p_last_update_date IS NULL )))
       AND (    ( recinfo.last_updated_by = p_last_updated_by)
            OR (    ( recinfo.last_updated_by IS NULL )
                AND (  p_last_updated_by IS NULL )))
       AND (    ( recinfo.creation_date = p_creation_date)
            OR (    ( recinfo.creation_date IS NULL )
                AND (  p_creation_date IS NULL )))
       AND (    ( recinfo.created_by = p_created_by)
            OR (    ( recinfo.created_by IS NULL )
                AND (  p_created_by IS NULL )))
       AND (    ( recinfo.country = p_country)
            OR (    ( recinfo.country IS NULL )
                AND (  p_country IS NULL )))
       AND (    ( recinfo.address1 = p_address1)
            OR (    ( recinfo.address1 IS NULL )
                AND (  p_address1 IS NULL )))
       AND (    ( recinfo.address2 = p_address2)
            OR (    ( recinfo.address2 IS NULL )
                AND (  p_address2 IS NULL )))
       AND (    ( recinfo.address3 = p_address3)
            OR (    ( recinfo.address3 IS NULL )
                AND (  p_address3 IS NULL )))
       AND (    ( recinfo.address4 = p_address4)
            OR (    ( recinfo.address4 IS NULL )
                AND (  p_address4 IS NULL )))
       AND (    ( recinfo.city = p_city)
            OR (    ( recinfo.city IS NULL )
                AND (  p_city IS NULL )))
       AND (    ( recinfo.postal_code = p_postal_code)
            OR (    ( recinfo.postal_code IS NULL )
                AND (  p_postal_code IS NULL )))
       AND (    ( recinfo.state = p_state)
            OR (    ( recinfo.state IS NULL )
                AND (  p_state IS NULL )))
       AND (    ( recinfo.province = p_province)
            OR (    ( recinfo.province IS NULL )
                AND (  p_province IS NULL )))
       AND (    ( recinfo.county = p_county)
            OR (    ( recinfo.county IS NULL )
                AND (  p_county IS NULL )))
       AND (    ( recinfo.clli_code = p_clli_code)
            OR (    ( recinfo.clli_code IS NULL )
                AND (  p_clli_code IS NULL )))
       AND (    ( recinfo.description = p_description)
            OR (    ( recinfo.description IS NULL )
                AND (  p_description IS NULL )))
       AND (    ( recinfo.created_by_module = p_created_by_module)
            OR (    ( recinfo.created_by_module IS NULL )
                AND (  p_created_by_module IS NULL )))
       ) THEN
       RETURN;

Line: 461

       FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');