DBA Data[Home] [Help]

APPS.OKL_LAV_PVT SQL Statements

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

Line: 11

    DELETE FROM OKL_LEASEAPP_TEMPL_VERSIONS_TL T
    WHERE NOT EXISTS (SELECT NULL FROM OKL_LEASEAPP_TEMPL_VERSIONS_B B WHERE B.ID =T.ID);
Line: 14

    UPDATE OKL_LEASEAPP_TEMPL_VERSIONS_TL T
    SET (SHORT_DESCRIPTION) =
                     (SELECT
                      B.SHORT_DESCRIPTION
                      FROM
                      OKL_LEASEAPP_TEMPL_VERSIONS_TL B
                      WHERE
                      B.ID = T.ID
                      AND B.LANGUAGE = T.SOURCE_LANG)
    WHERE (T.ID, T.LANGUAGE) IN (SELECT
                                 SUBT.ID,
                                 SUBT.LANGUAGE
                                 FROM
                                 OKL_LEASEAPP_TEMPL_VERSIONS_TL SUBB,
                                 OKL_LEASEAPP_TEMPL_VERSIONS_TL SUBT
                                 WHERE
                                 SUBB.ID = SUBT.ID
                                 AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
                                 AND (SUBB.SHORT_DESCRIPTION <> SUBT.SHORT_DESCRIPTION)
                                      OR (SUBB.SHORT_DESCRIPTION IS NULL AND SUBT.SHORT_DESCRIPTION IS NOT NULL)
                                );
Line: 36

    INSERT INTO OKL_LEASEAPP_TEMPL_VERSIONS_TL (
        ID,
        LANGUAGE,
        SOURCE_LANG,
        SFWT_FLAG,
        CREATED_BY,
        CREATION_DATE,
        LAST_UPDATED_BY,
        LAST_UPDATE_DATE,
        LAST_UPDATE_LOGIN,
        SHORT_DESCRIPTION)
      SELECT
            B.ID,
            L.LANGUAGE_CODE,
            B.SOURCE_LANG,
            B.SFWT_FLAG,
            B.CREATED_BY,
            B.CREATION_DATE,
            B.LAST_UPDATED_BY,
            B.LAST_UPDATE_DATE,
            B.LAST_UPDATE_LOGIN,
            B.SHORT_DESCRIPTION
        FROM OKL_LEASEAPP_TEMPL_VERSIONS_TL B, FND_LANGUAGES L
       WHERE L.INSTALLED_FLAG IN ('I', 'B')
         AND B.LANGUAGE = USERENV('LANG')
         AND NOT EXISTS (
                    SELECT NULL
                      FROM OKL_LEASEAPP_TEMPL_VERSIONS_TL T
                     WHERE T.ID = B.ID
                       AND T.LANGUAGE = L.LANGUAGE_CODE
                    );
Line: 173

    SELECT
      id
      ,object_version_number
      ,attribute_category
      ,attribute1
      ,attribute2
      ,attribute3
      ,attribute4
      ,attribute5
      ,attribute6
      ,attribute7
      ,attribute8
      ,attribute9
      ,attribute10
      ,attribute11
      ,attribute12
      ,attribute13
      ,attribute14
      ,attribute15
      ,leaseapp_template_id
      ,version_status
      ,version_number
      ,valid_from
      ,valid_to
      ,checklist_id
      ,contract_template_id
      ,short_description
    INTO
      l_lavv_rec.id
      ,l_lavv_rec.object_version_number
      ,l_lavv_rec.attribute_category
      ,l_lavv_rec.attribute1
      ,l_lavv_rec.attribute2
      ,l_lavv_rec.attribute3
      ,l_lavv_rec.attribute4
      ,l_lavv_rec.attribute5
      ,l_lavv_rec.attribute6
      ,l_lavv_rec.attribute7
      ,l_lavv_rec.attribute8
      ,l_lavv_rec.attribute9
      ,l_lavv_rec.attribute10
      ,l_lavv_rec.attribute11
      ,l_lavv_rec.attribute12
      ,l_lavv_rec.attribute13
      ,l_lavv_rec.attribute14
      ,l_lavv_rec.attribute15
      ,l_lavv_rec.leaseapp_template_id
      ,l_lavv_rec.version_status
      ,l_lavv_rec.version_number
      ,l_lavv_rec.valid_from
      ,l_lavv_rec.valid_to
      ,l_lavv_rec.checklist_id
      ,l_lavv_rec.contract_template_id
      ,l_lavv_rec.short_description
    FROM okl_leaseapp_templ_versions_v
    WHERE id = p_id;
Line: 457

  PROCEDURE insert_row (x_return_status OUT NOCOPY VARCHAR2, p_lav_rec IN lav_rec_type) IS

    l_prog_name  VARCHAR2(61);
Line: 463

    l_prog_name := G_PKG_NAME||'.insert_row (B)';
Line: 465

    INSERT INTO okl_leaseapp_templ_versions_b (
      id
      ,object_version_number
      ,attribute_category
      ,attribute1
      ,attribute2
      ,attribute3
      ,attribute4
      ,attribute5
      ,attribute6
      ,attribute7
      ,attribute8
      ,attribute9
      ,attribute10
      ,attribute11
      ,attribute12
      ,attribute13
      ,attribute14
      ,attribute15
      ,created_by
      ,creation_date
      ,last_updated_by
      ,last_update_date
      ,last_update_login
      ,leaseapp_template_id
      ,version_status
      ,version_number
      ,valid_from
      ,valid_to
      ,checklist_id
      ,contract_template_id
      )
    VALUES
      (
       p_lav_rec.id
      ,p_lav_rec.object_version_number
      ,p_lav_rec.attribute_category
      ,p_lav_rec.attribute1
      ,p_lav_rec.attribute2
      ,p_lav_rec.attribute3
      ,p_lav_rec.attribute4
      ,p_lav_rec.attribute5
      ,p_lav_rec.attribute6
      ,p_lav_rec.attribute7
      ,p_lav_rec.attribute8
      ,p_lav_rec.attribute9
      ,p_lav_rec.attribute10
      ,p_lav_rec.attribute11
      ,p_lav_rec.attribute12
      ,p_lav_rec.attribute13
      ,p_lav_rec.attribute14
      ,p_lav_rec.attribute15
      ,G_USER_ID
      ,SYSDATE
      ,G_USER_ID
      ,SYSDATE
      ,G_LOGIN_ID
      ,p_lav_rec.leaseapp_template_id
      ,p_lav_rec.version_status
      ,p_lav_rec.version_number
      ,p_lav_rec.valid_from
      ,p_lav_rec.valid_to
      ,p_lav_rec.checklist_id
      ,p_lav_rec.contract_template_id
    );
Line: 548

  END insert_row;
Line: 554

  PROCEDURE insert_row (x_return_status OUT NOCOPY VARCHAR2, p_lavtl_rec IN lavtl_rec_type) IS

    CURSOR get_languages IS
      SELECT language_code
        FROM FND_LANGUAGES
       WHERE INSTALLED_FLAG IN ('I', 'B');
Line: 566

    l_prog_name := G_PKG_NAME||'.insert_row (TL)';
Line: 576

      INSERT INTO OKL_LEASEAPP_TEMPL_VERSIONS_TL (
        id
       ,language
       ,source_lang
       ,sfwt_flag
       ,created_by
       ,creation_date
       ,last_updated_by
       ,last_update_date
       ,last_update_login
       ,short_description)
      VALUES (
        p_lavtl_rec.id
       ,l_lang_rec.language_code
       ,USERENV('LANG')
       ,l_sfwt_flag
       ,G_USER_ID
       ,SYSDATE
       ,G_USER_ID
       ,SYSDATE
       ,G_LOGIN_ID
       ,p_lavtl_rec.short_description);
Line: 618

  END insert_row;
Line: 623

  PROCEDURE insert_row (
    x_return_status                OUT NOCOPY VARCHAR2,
    p_lavv_rec                     IN lavv_rec_type,
    x_lavv_rec                     OUT NOCOPY lavv_rec_type) IS

    l_return_status                VARCHAR2(1);
Line: 638

    l_prog_name := G_PKG_NAME||'.insert_row (V)';
Line: 642

    SELECT okl_lav_seq.nextval INTO l_lavv_rec.ID FROM DUAL;
Line: 665

    insert_row (x_return_status => l_return_status, p_lav_rec => l_lav_rec);
Line: 673

    insert_row (x_return_status => l_return_status, p_lavtl_rec => l_lavtl_rec);
Line: 707

  END insert_row;
Line: 712

  PROCEDURE insert_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_lavv_rec                     IN lavv_rec_type,
    x_lavv_rec                     OUT NOCOPY lavv_rec_type) IS

    l_return_status              VARCHAR2(1);
Line: 727

    l_prog_name := G_PKG_NAME||'.insert_row (REC)';
Line: 733

    insert_row (x_return_status                => l_return_status,
                p_lavv_rec                     => p_lavv_rec,
                x_lavv_rec                     => x_lavv_rec);
Line: 768

  END insert_row;
Line: 773

  PROCEDURE insert_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_lavv_tbl                     IN lavv_tbl_type,
    x_lavv_tbl                     OUT NOCOPY lavv_tbl_type) IS

    l_return_status              VARCHAR2(1);
Line: 789

    l_prog_name := G_PKG_NAME||'.insert_row (TBL)';
Line: 800

          insert_row (x_return_status                => l_return_status,
                      p_lavv_rec                     => p_lavv_tbl(i),
                      x_lavv_rec                     => x_lavv_tbl(i));
Line: 848

  END insert_row;
Line: 860

    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_LEASEAPP_TEMPL_VERSIONS_B
     WHERE ID = p_lav_rec.id
       AND OBJECT_VERSION_NUMBER = p_lav_rec.object_version_number
    FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
Line: 867

    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_LEASEAPP_TEMPL_VERSIONS_B
     WHERE ID = p_lav_rec.id;
Line: 953

  PROCEDURE update_row(x_return_status OUT NOCOPY VARCHAR2, p_lav_rec IN lav_rec_type) IS

    l_return_status           VARCHAR2(1);
Line: 961

    l_prog_name := G_PKG_NAME||'.update_row (B)';
Line: 971

    UPDATE okl_leaseapp_templ_versions_b
    SET
      object_version_number = p_lav_rec.object_version_number+1
      ,attribute_category = p_lav_rec.attribute_category
      ,attribute1 = p_lav_rec.attribute1
      ,attribute2 = p_lav_rec.attribute2
      ,attribute3 = p_lav_rec.attribute3
      ,attribute4 = p_lav_rec.attribute4
      ,attribute5 = p_lav_rec.attribute5
      ,attribute6 = p_lav_rec.attribute6
      ,attribute7 = p_lav_rec.attribute7
      ,attribute8 = p_lav_rec.attribute8
      ,attribute9 = p_lav_rec.attribute9
      ,attribute10 = p_lav_rec.attribute10
      ,attribute11 = p_lav_rec.attribute11
      ,attribute12 = p_lav_rec.attribute12
      ,attribute13 = p_lav_rec.attribute13
      ,attribute14 = p_lav_rec.attribute14
      ,attribute15 = p_lav_rec.attribute15
      ,leaseapp_template_id = p_lav_rec.leaseapp_template_id
      ,version_status = p_lav_rec.version_status
      ,version_number = p_lav_rec.version_number
      ,valid_from = p_lav_rec.valid_from
      ,valid_to = p_lav_rec.valid_to
      ,checklist_id = p_lav_rec.checklist_id
      ,contract_template_id = p_lav_rec.contract_template_id
    WHERE id = p_lav_rec.id;
Line: 1021

  END update_row;
Line: 1026

  PROCEDURE update_row(x_return_status OUT NOCOPY VARCHAR2, p_lavtl_rec IN lavtl_rec_type) IS

    l_prog_name               VARCHAR2(61);
Line: 1032

    l_prog_name := G_PKG_NAME||'.update_row (TL)';
Line: 1034

    UPDATE OKL_LEASEAPP_TEMPL_VERSIONS_TL
    SET
      source_lang = USERENV('LANG')
      ,sfwt_flag = 'Y'
      ,last_updated_by = G_USER_ID
      ,last_update_date = SYSDATE
      ,last_update_login = G_LOGIN_ID
      ,short_description = p_lavtl_rec.short_description
    WHERE ID = p_lavtl_rec.id;
Line: 1044

    UPDATE OKL_LEASEAPP_TEMPL_VERSIONS_TL
    SET SFWT_FLAG = 'N'
    WHERE ID = p_lavtl_rec.id
    AND SOURCE_LANG = LANGUAGE;
Line: 1066

  END update_row;
Line: 1071

  PROCEDURE update_row (
    x_return_status                OUT NOCOPY VARCHAR2,
    p_lavv_rec                     IN lavv_rec_type,
    x_lavv_rec                     OUT NOCOPY lavv_rec_type) IS

    l_prog_name                    VARCHAR2(61);
Line: 1205

    l_prog_name := G_PKG_NAME||'.update_row (V)';
Line: 1235

    update_row (x_return_status => l_return_status, p_lav_rec => l_lav_rec);
Line: 1243

    update_row (x_return_status => l_return_status, p_lavtl_rec => l_lavtl_rec);
Line: 1277

  END update_row;
Line: 1282

  PROCEDURE update_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_lavv_rec                     IN lavv_rec_type,
    x_lavv_rec                     OUT NOCOPY lavv_rec_type) IS

    l_return_status              VARCHAR2(1);
Line: 1297

    l_prog_name := G_PKG_NAME||'.update_row (REC)';
Line: 1303

    update_row (x_return_status                => l_return_status,
                p_lavv_rec                     => p_lavv_rec,
                x_lavv_rec                     => x_lavv_rec);
Line: 1338

  END update_row;
Line: 1343

  PROCEDURE update_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_lavv_tbl                     IN lavv_tbl_type,
    x_lavv_tbl                     OUT NOCOPY lavv_tbl_type) IS

    l_return_status              VARCHAR2(1);
Line: 1358

    l_prog_name := G_PKG_NAME||'.update_row (TBL)';
Line: 1373

          update_row (x_return_status                => l_return_status,
                      p_lavv_rec                     => p_lavv_tbl(i),
                      x_lavv_rec                     => x_lavv_tbl(i));
Line: 1421

  END update_row;
Line: 1426

  PROCEDURE delete_row(
    x_return_status                OUT NOCOPY VARCHAR2,
    p_id                           IN NUMBER) IS

    l_prog_name                  VARCHAR2(61);
Line: 1434

    l_prog_name := G_PKG_NAME||'.delete_row (V)';
Line: 1436

    DELETE FROM OKL_LEASEAPP_TEMPL_VERSIONS_B WHERE id = p_id;
Line: 1437

    DELETE FROM OKL_LEASEAPP_TEMPL_VERSIONS_TL WHERE id = p_id;
Line: 1456

  END delete_row;
Line: 1461

  PROCEDURE delete_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_lavv_rec                     IN lavv_rec_type) IS

    l_return_status              VARCHAR2(1);
Line: 1475

    l_prog_name := G_PKG_NAME||'.delete_row (REC)';
Line: 1481

    delete_row (x_return_status                => l_return_status,
                p_id                           => p_lavv_rec.id);
Line: 1515

  END delete_row;
Line: 1520

  PROCEDURE delete_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_lavv_tbl                     IN lavv_tbl_type) IS

    l_return_status                VARCHAR2(1);
Line: 1535

    l_prog_name := G_PKG_NAME||'.delete_row (TBL)';
Line: 1549

          delete_row (x_return_status                => l_return_status,
                      p_id                           => p_lavv_tbl(i).id);
Line: 1588

  END delete_row;