eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HZ_FINANCIAL_NUMBERS_PKG SQL Statements

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

Line: 6


PROCEDURE Insert_Row (
    x_rowid                                 IN OUT NOCOPY VARCHAR2,
    x_financial_number_id                   IN OUT NOCOPY NUMBER,
    x_financial_report_id                   IN     NUMBER,
    x_financial_number                      IN     NUMBER,
    x_financial_number_name                 IN     VARCHAR2,
    x_financial_units_applied               IN     NUMBER,
    x_financial_number_currency             IN     VARCHAR2,
    x_projected_actual_flag                 IN     VARCHAR2,
    x_content_source_type                   IN     VARCHAR2,
    x_status                                IN     VARCHAR2,
    x_object_version_number                 IN     NUMBER,
    x_created_by_module                     IN     VARCHAR2,
    x_actual_content_source                 IN     VARCHAR2
) IS

    l_success                               VARCHAR2(1) := 'N';

Line: 28


      INSERT INTO HZ_FINANCIAL_NUMBERS (
        financial_number_id,
        financial_report_id,
        financial_number,
        financial_number_name,
        financial_units_applied,
        financial_number_currency,
        projected_actual_flag,
        created_by,
        creation_date,
        last_update_login,
        last_update_date,
        last_updated_by,
        request_id,
        program_application_id,
        program_id,
        program_update_date,
        content_source_type,
        status,
        object_version_number,
        created_by_module,
        application_id,
        actual_content_source
      )
      VALUES (
        DECODE(x_financial_number_id,
               FND_API.G_MISS_NUM, HZ_FINANCIAL_NUMBERS_S.NEXTVAL,
               NULL, HZ_FINANCIAL_NUMBERS_S.NEXTVAL,
               x_financial_number_id),
        DECODE(x_financial_report_id,
               FND_API.G_MISS_NUM, NULL,
               x_financial_report_id),
        DECODE(x_financial_number,
               FND_API.G_MISS_NUM, NULL,
               x_financial_number),
        DECODE(x_financial_number_name,
               FND_API.G_MISS_CHAR, NULL,
               x_financial_number_name),
        DECODE(x_financial_units_applied,
               FND_API.G_MISS_NUM, NULL,
               x_financial_units_applied),
        DECODE(x_financial_number_currency,
               FND_API.G_MISS_CHAR, NULL,
               x_financial_number_currency),
        DECODE(x_projected_actual_flag,
               FND_API.G_MISS_CHAR, NULL,
               x_projected_actual_flag),
        hz_utility_v2pub.created_by,
        hz_utility_v2pub.creation_date,
        hz_utility_v2pub.last_update_login,
        hz_utility_v2pub.last_update_date,
        hz_utility_v2pub.last_updated_by,
        hz_utility_v2pub.request_id,
        hz_utility_v2pub.program_application_id,
        hz_utility_v2pub.program_id,
        hz_utility_v2pub.program_update_date,
        DECODE(x_content_source_type,
               FND_API.G_MISS_CHAR, G_MISS_CONTENT_SOURCE_TYPE,
               NULL, G_MISS_CONTENT_SOURCE_TYPE,
               x_content_source_type),
        DECODE(x_status,
               FND_API.G_MISS_CHAR, 'A',
               NULL, 'A',
               x_status),
        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),
        hz_utility_v2pub.application_id,
        DECODE(x_actual_content_source,
               FND_API.G_MISS_CHAR, G_MISS_CONTENT_SOURCE_TYPE,
               NULL, G_MISS_CONTENT_SOURCE_TYPE,
               x_actual_content_source)
      ) RETURNING
        rowid,
        financial_number_id
      INTO
        x_rowid,
        x_financial_number_id;

Line: 121


            SELECT HZ_FINANCIAL_NUMBERS_S.NEXTVAL
            INTO x_financial_number_id FROM dual;

Line: 124


              SELECT 'Y' INTO l_dummy
              FROM HZ_FINANCIAL_NUMBERS
              WHERE financial_number_id = x_financial_number_id;

Line: 139


END Insert_Row;

Line: 141


PROCEDURE Update_Row (
    x_rowid                                 IN OUT NOCOPY VARCHAR2,
    x_financial_number_id                   IN     NUMBER,
    x_financial_report_id                   IN     NUMBER,
    x_financial_number                      IN     NUMBER,
    x_financial_number_name                 IN     VARCHAR2,
    x_financial_units_applied               IN     NUMBER,
    x_financial_number_currency             IN     VARCHAR2,
    x_projected_actual_flag                 IN     VARCHAR2,
    x_content_source_type                   IN     VARCHAR2,
    x_status                                IN     VARCHAR2,
    x_object_version_number                 IN     NUMBER,
    x_created_by_module                     IN     VARCHAR2,
    x_actual_content_source                 IN     VARCHAR2
) IS
BEGIN

    UPDATE HZ_FINANCIAL_NUMBERS
    SET
      financial_number_id =
        DECODE(x_financial_number_id,
               NULL, financial_number_id,
               FND_API.G_MISS_NUM, NULL,
               x_financial_number_id),
      financial_report_id =
        DECODE(x_financial_report_id,
               NULL, financial_report_id,
               FND_API.G_MISS_NUM, NULL,
               x_financial_report_id),
      financial_number =
        DECODE(x_financial_number,
               NULL, financial_number,
               FND_API.G_MISS_NUM, NULL,
               x_financial_number),
      financial_number_name =
        DECODE(x_financial_number_name,
               NULL, financial_number_name,
               FND_API.G_MISS_CHAR, NULL,
               x_financial_number_name),
      financial_units_applied =
        DECODE(x_financial_units_applied,
               NULL, financial_units_applied,
               FND_API.G_MISS_NUM, NULL,
               x_financial_units_applied),
      financial_number_currency =
        DECODE(x_financial_number_currency,
               NULL, financial_number_currency,
               FND_API.G_MISS_CHAR, NULL,
               x_financial_number_currency),
      projected_actual_flag =
        DECODE(x_projected_actual_flag,
               NULL, projected_actual_flag,
               FND_API.G_MISS_CHAR, NULL,
               x_projected_actual_flag),
      created_by = created_by,
      creation_date = creation_date,
      last_update_login = hz_utility_v2pub.last_update_login,
      last_update_date = hz_utility_v2pub.last_update_date,
      last_updated_by = hz_utility_v2pub.last_updated_by,
      request_id = hz_utility_v2pub.request_id,
      program_application_id = hz_utility_v2pub.program_application_id,
      program_id = hz_utility_v2pub.program_id,
      program_update_date = hz_utility_v2pub.program_update_date,
      content_source_type =
        DECODE(x_content_source_type,
               NULL, content_source_type,
               FND_API.G_MISS_CHAR, NULL,
               x_content_source_type),
      status =
        DECODE(x_status,
               NULL, status,
               FND_API.G_MISS_CHAR, NULL,
               x_status),
      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 = hz_utility_v2pub.application_id/*,

      ** SSM SST Integration and Extension
      ** actual_content_source will not be updateable for non-SSM enabled entities.

      actual_content_source =
        DECODE(x_actual_content_source,
               NULL, actual_content_source,
               FND_API.G_MISS_CHAR, NULL,
               x_actual_content_source)    */
    WHERE rowid = x_rowid;

Line: 240


END Update_Row;

Line: 253


    x_last_update_login                     IN     NUMBER,
    x_last_update_date                      IN     DATE,
    x_last_updated_by                       IN     NUMBER,
    x_request_id                            IN     NUMBER,
    x_program_application_id                IN     NUMBER,
    x_program_id                            IN     NUMBER,
    x_program_update_date                   IN     DATE,
    x_content_source_type                   IN     VARCHAR2,
    x_status                                IN     VARCHAR2,
    x_object_version_number                 IN     NUMBER,
    x_created_by_module                     IN     VARCHAR2,
    x_application_id                        IN     NUMBER,
    x_actual_content_source                 IN     VARCHAR2
) IS

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

Line: 280


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

Line: 313


    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.last_update_date = x_last_update_date )
        OR ( ( Recinfo.last_update_date IS NULL )
          AND (  x_last_update_date IS NULL ) ) )
    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.request_id = x_request_id )
        OR ( ( Recinfo.request_id IS NULL )
          AND (  x_request_id IS NULL ) ) )
    AND ( ( Recinfo.program_application_id = x_program_application_id )
        OR ( ( Recinfo.program_application_id IS NULL )
          AND (  x_program_application_id IS NULL ) ) )
    AND ( ( Recinfo.program_id = x_program_id )
        OR ( ( Recinfo.program_id IS NULL )
          AND (  x_program_id IS NULL ) ) )
    AND ( ( Recinfo.program_update_date = x_program_update_date )
        OR ( ( Recinfo.program_update_date IS NULL )
          AND (  x_program_update_date IS NULL ) ) )
    AND ( ( Recinfo.content_source_type = x_content_source_type )
        OR ( ( Recinfo.content_source_type IS NULL )
          AND (  x_content_source_type IS NULL ) ) )
    AND ( ( Recinfo.status = x_status )
        OR ( ( Recinfo.status IS NULL )
          AND (  x_status 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 ) ) )
    AND ( ( Recinfo.actual_content_source = x_actual_content_source )
        OR ( ( Recinfo.actual_content_source IS NULL )
          AND (  x_actual_content_source IS NULL ) ) )
    ) THEN
      RETURN;

Line: 355


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

Line: 361


PROCEDURE Select_Row (
    x_financial_number_id                   IN OUT NOCOPY NUMBER,
    x_financial_report_id                   OUT    NOCOPY NUMBER,
    x_financial_number                      OUT    NOCOPY NUMBER,
    x_financial_number_name                 OUT    NOCOPY VARCHAR2,
    x_financial_units_applied               OUT    NOCOPY NUMBER,
    x_financial_number_currency             OUT    NOCOPY VARCHAR2,
    x_projected_actual_flag                 OUT    NOCOPY VARCHAR2,
    x_content_source_type                   OUT    NOCOPY VARCHAR2,
    x_status                                OUT    NOCOPY VARCHAR2,
    x_actual_content_source                 OUT    NOCOPY VARCHAR2
) IS
BEGIN

    SELECT
      NVL(financial_number_id, FND_API.G_MISS_NUM),
      NVL(financial_report_id, FND_API.G_MISS_NUM),
      NVL(financial_number, FND_API.G_MISS_NUM),
      NVL(financial_number_name, FND_API.G_MISS_CHAR),
      NVL(financial_units_applied, FND_API.G_MISS_NUM),
      NVL(financial_number_currency, FND_API.G_MISS_CHAR),
      NVL(projected_actual_flag, FND_API.G_MISS_CHAR),
      NVL(content_source_type, FND_API.G_MISS_CHAR),
      NVL(status, FND_API.G_MISS_CHAR),
      NVL(actual_content_source, FND_API.G_MISS_CHAR)
    INTO
      x_financial_number_id,
      x_financial_report_id,
      x_financial_number,
      x_financial_number_name,
      x_financial_units_applied,
      x_financial_number_currency,
      x_projected_actual_flag,
      x_content_source_type,
      x_status,
      x_actual_content_source
    FROM HZ_FINANCIAL_NUMBERS
    WHERE financial_number_id = x_financial_number_id;

Line: 408


END Select_Row;

Line: 410


PROCEDURE Delete_Row (
    x_financial_number_id                   IN     NUMBER
) IS
BEGIN

    DELETE FROM HZ_FINANCIAL_NUMBERS
    WHERE financial_number_id = x_financial_number_id;

Line: 422


END Delete_Row;