APPS.HZ_ADDRESS_USAGE_DTLS_PKG SQL Statements

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

Line: 4

PROCEDURE Insert_Row (
    x_rowid                                 IN OUT NOCOPY VARCHAR2,
    x_usage_dtl_id                          IN OUT NOCOPY NUMBER,
    x_usage_id                              IN     NUMBER,
    x_geography_type                        IN     VARCHAR2,
    x_object_version_number                 IN     NUMBER,
    x_created_by_module                     IN     VARCHAR2,
    x_application_id                        IN     NUMBER
) IS

    l_success                               VARCHAR2(1) := 'N';

Line: 20

      INSERT INTO HZ_ADDRESS_USAGE_DTLS (
        usage_dtl_id,
        usage_id,
        geography_type,
        created_by,
        creation_date,
        last_updated_by,
        last_update_date,
        last_update_login,
        object_version_number,
        created_by_module,
        application_id
      )
      VALUES (
        DECODE(x_usage_dtl_id,
               FND_API.G_MISS_NUM, HZ_ADDRESS_USAGE_DTLS_S.NEXTVAL,
               NULL, HZ_ADDRESS_USAGE_DTLS_S.NEXTVAL,
               x_usage_dtl_id),
        DECODE(x_usage_id,
               FND_API.G_MISS_NUM, NULL,
               x_usage_id),
        DECODE(x_geography_type,
               FND_API.G_MISS_CHAR, NULL,
               x_geography_type),
        hz_utility_v2pub.created_by,
        hz_utility_v2pub.creation_date,
        hz_utility_v2pub.last_updated_by,
        hz_utility_v2pub.last_update_date,
        hz_utility_v2pub.last_update_login,
        DECODE(x_object_version_number,
               FND_API.G_MISS_NUM, NULL,
               x_object_version_number),
        DECODE(x_created_by_module,
               FND_API.G_MISS_CHAR, NULL,
               x_created_by_module),
        DECODE(x_application_id,
               FND_API.G_MISS_NUM, NULL,
               x_application_id)
      ) RETURNING
        rowid,
        usage_dtl_id
      INTO
        x_rowid,
        x_usage_dtl_id;

Line: 76

            SELECT HZ_ADDRESS_USAGE_DTLS_S.NEXTVAL
            INTO x_usage_dtl_id FROM dual;

Line: 79

              SELECT 'Y' INTO l_dummy
              FROM HZ_ADDRESS_USAGE_DTLS
              WHERE usage_dtl_id = x_usage_dtl_id;

Line: 94

END Insert_Row;

Line: 96

PROCEDURE Update_Row (
    x_rowid                                 IN OUT NOCOPY VARCHAR2,
    x_usage_dtl_id                          IN     NUMBER,
    x_usage_id                              IN     NUMBER,
    x_geography_type                        IN     VARCHAR2,
    x_object_version_number                 IN     NUMBER,
    x_created_by_module                     IN     VARCHAR2,
    x_application_id                        IN     NUMBER
) IS
BEGIN

    UPDATE HZ_ADDRESS_USAGE_DTLS
    SET
      usage_dtl_id =
        DECODE(x_usage_dtl_id,
               NULL, usage_dtl_id,
               FND_API.G_MISS_NUM, NULL,
               x_usage_dtl_id),
      usage_id =
        DECODE(x_usage_id,
               NULL, usage_id,
               FND_API.G_MISS_NUM, NULL,
               x_usage_id),
      geography_type =
        DECODE(x_geography_type,
               NULL, geography_type,
               FND_API.G_MISS_CHAR, NULL,
               x_geography_type),
      created_by = created_by,
      creation_date = creation_date,
      last_updated_by = hz_utility_v2pub.last_updated_by,
      last_update_date = hz_utility_v2pub.last_update_date,
      last_update_login = hz_utility_v2pub.last_update_login,
      object_version_number =
        DECODE(x_object_version_number,
               NULL, object_version_number,
               FND_API.G_MISS_NUM, NULL,
               x_object_version_number),
      created_by_module =
        DECODE(x_created_by_module,
               NULL, created_by_module,
               FND_API.G_MISS_CHAR, NULL,
               x_created_by_module),
      application_id =
        DECODE(x_application_id,
               NULL, application_id,
               FND_API.G_MISS_NUM, NULL,
               x_application_id)
    WHERE rowid = x_rowid;

Line: 150

END Update_Row;

Line: 159

    x_last_updated_by                       IN     NUMBER,
    x_last_update_date                      IN     DATE,
    x_last_update_login                     IN     NUMBER,
    x_object_version_number                 IN     NUMBER,
    x_created_by_module                     IN     VARCHAR2,
    x_application_id                        IN     NUMBER
) IS

    CURSOR c IS
      SELECT * FROM hz_address_usage_dtls
      WHERE rowid = x_rowid
      FOR UPDATE NOWAIT;

Line: 179

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

Line: 200

    AND ( ( Recinfo.last_updated_by = x_last_updated_by )
        OR ( ( Recinfo.last_updated_by IS NULL )
          AND (  x_last_updated_by IS NULL ) ) )
    AND ( ( Recinfo.last_update_date = x_last_update_date )
        OR ( ( Recinfo.last_update_date IS NULL )
          AND (  x_last_update_date IS NULL ) ) )
    AND ( ( Recinfo.last_update_login = x_last_update_login )
        OR ( ( Recinfo.last_update_login IS NULL )
          AND (  x_last_update_login IS NULL ) ) )
    AND ( ( Recinfo.object_version_number = x_object_version_number )
        OR ( ( Recinfo.object_version_number IS NULL )
          AND (  x_object_version_number IS NULL ) ) )
    AND ( ( Recinfo.created_by_module = x_created_by_module )
        OR ( ( Recinfo.created_by_module IS NULL )
          AND (  x_created_by_module IS NULL ) ) )
    AND ( ( Recinfo.application_id = x_application_id )
        OR ( ( Recinfo.application_id IS NULL )
          AND (  x_application_id IS NULL ) ) )
    ) THEN
      RETURN;

Line: 221

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

Line: 227

PROCEDURE Select_Row (
    x_usage_dtl_id                          IN OUT NOCOPY NUMBER,
    x_usage_id                              OUT    NOCOPY NUMBER,
    x_geography_type                        OUT    NOCOPY VARCHAR2,
    x_object_version_number                 OUT    NOCOPY NUMBER,
    x_created_by_module                     OUT    NOCOPY VARCHAR2,
    x_application_id                        OUT    NOCOPY NUMBER
) IS
BEGIN

    SELECT
      NVL(usage_dtl_id, FND_API.G_MISS_NUM),
      NVL(usage_id, FND_API.G_MISS_NUM),
      NVL(geography_type, FND_API.G_MISS_CHAR),
      NVL(created_by_module, FND_API.G_MISS_CHAR),
      NVL(application_id, FND_API.G_MISS_NUM)
    INTO
      x_usage_dtl_id,
      x_usage_id,
      x_geography_type,
      x_created_by_module,
      x_application_id
    FROM HZ_ADDRESS_USAGE_DTLS
    WHERE usage_dtl_id = x_usage_dtl_id;

Line: 260

END Select_Row;

Line: 262

PROCEDURE Delete_Row (
    x_usage_dtl_id                          IN     NUMBER
) IS
BEGIN

    DELETE FROM HZ_ADDRESS_USAGE_DTLS
    WHERE usage_dtl_id = x_usage_dtl_id;

Line: 274

END Delete_Row;