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.OKL_TAS_PVT SQL Statements

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

Line: 32


    SELECT 1
    FROM DUAL
    WHERE EXISTS (SELECT ID1
                  FROM OKX_CUSTOMER_ACCOUNTS_V
                  WHERE id1  = p_id
                  AND   id2  = G_ID2);

Line: 229


    SELECT 1
    FROM DUAl
    WHERE EXISTS (SELECT id
                  FROM OKL_TRX_TYPES_B
                  WHERE id = p_id);

Line: 310


    SELECT 1
    FROM DUAL
    WHERE EXISTS (SELECT Organization_id
                  FROM  HR_OPERATING_UNITS
                  WHERE Organization_id = p_id);

Line: 460


    SELECT
            ID,
            ICA_ID,
            TAS_TYPE,
            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,
            TSU_CODE,
            TRY_ID,
            DATE_TRANS_OCCURRED,
            TRANS_NUMBER,
            COMMENTS,
            REQ_ASSET_ID,
            TOTAL_MATCH_AMOUNT,
--Bug # 2697681 - 11.5.9 schema change
            ORG_ID,
	    --Added by dpsingh for LE uptake
           LEGAL_ENTITY_ID
           ,TRANSACTION_DATE
      FROM Okl_Trx_Assets
     WHERE okl_trx_assets.id    = p_id;

Line: 529


              l_tas_rec.LAST_UPDATED_BY,
              l_tas_rec.LAST_UPDATE_DATE,
              l_tas_rec.LAST_UPDATE_LOGIN,
              l_tas_rec.TSU_CODE,
              l_tas_rec.TRY_ID,
              l_tas_rec.DATE_TRANS_OCCURRED,
              l_tas_rec.TRANS_NUMBER,
              l_tas_rec.COMMENTS,
              l_tas_rec.REQ_ASSET_ID,
              l_tas_rec.TOTAL_MATCH_AMOUNT,
--Bug # 2697681 - 11.5.9 Schema change
              l_tas_rec.ORG_ID,
	      --Added by dpsingh for LE uptake
              l_tas_rec.LEGAL_ENTITY_ID
             ,l_tas_rec.TRANSACTION_DATE;

Line: 564


    SELECT
            ID,
            OBJECT_VERSION_NUMBER,
            ICA_ID,
            ATTRIBUTE_CATEGORY,
            ATTRIBUTE1,
            ATTRIBUTE2,
            ATTRIBUTE3,
            ATTRIBUTE4,
            ATTRIBUTE5,
            ATTRIBUTE6,
            ATTRIBUTE7,
            ATTRIBUTE8,
            ATTRIBUTE9,
            ATTRIBUTE10,
            ATTRIBUTE11,
            ATTRIBUTE12,
            ATTRIBUTE13,
            ATTRIBUTE14,
            ATTRIBUTE15,
            TAS_TYPE,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN,
            TSU_CODE,
            TRY_ID,
            DATE_TRANS_OCCURRED,
            TRANS_NUMBER,
            COMMENTS,
            REQ_ASSET_ID,
            TOTAL_MATCH_AMOUNT,
--Bug # 2697681 : 11.5.9 schema change
            ORG_ID ,
	    --Added by dpsingh for LE uptake
            LEGAL_ENTITY_ID
           ,TRANSACTION_DATE
      FROM OKL_TRX_ASSETS
     WHERE OKL_TRX_ASSETS.id  = p_id;

Line: 633


              l_tasv_rec.LAST_UPDATED_BY,
              l_tasv_rec.LAST_UPDATE_DATE,
              l_tasv_rec.LAST_UPDATE_LOGIN,
              l_tasv_rec.TSU_CODE,
              l_tasv_rec.TRY_ID,
              l_tasv_rec.DATE_TRANS_OCCURRED,
              l_tasv_rec.TRANS_NUMBER,
              l_tasv_rec.COMMENTS,
              l_tasv_rec.REQ_ASSET_ID,
              l_tasv_rec.TOTAL_MATCH_AMOUNT,
--Bug#  2697681 : 11.5.9 Schema changes
              l_tasv_rec.ORG_ID,
	      --Added by dpsingh for LE uptake
              l_tasv_rec.LEGAL_ENTITY_ID
             ,l_tasv_rec.TRANSACTION_DATE;

Line: 732


    IF (l_tasv_rec.last_updated_by = OKC_API.G_MISS_NUM) THEN
      l_tasv_rec.last_updated_by := NULL;

Line: 735


    IF (l_tasv_rec.last_update_date = OKC_API.G_MISS_DATE) THEN
      l_tasv_rec.last_update_date := NULL;

Line: 738


    IF (l_tasv_rec.last_update_login = OKC_API.G_MISS_NUM) THEN
      l_tasv_rec.last_update_login := NULL;

Line: 923


    p_to.last_updated_by := p_from.last_updated_by;

Line: 924


    p_to.last_update_date := p_from.last_update_date;

Line: 925


    p_to.last_update_login := p_from.last_update_login;

Line: 966


    p_to.last_updated_by := p_from.last_updated_by;

Line: 967


    p_to.last_update_date := p_from.last_update_date;

Line: 968


    p_to.last_update_login := p_from.last_update_login;

Line: 1133


  PROCEDURE insert_row(
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_tas_rec                      IN tas_rec_type,
    x_tas_rec                      OUT NOCOPY tas_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1142


    l_api_name                     CONSTANT VARCHAR2(30) := 'ASSETS_insert_row';

Line: 1178


    INSERT INTO OKL_TRX_ASSETS(
        id,
        ica_id,
        tas_type,
        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,
        tsu_code,
        try_id,
        date_trans_occurred,
        trans_number,
        comments,
        req_asset_id,
        total_match_amount,
--Bug#  2697681 : 11.5.9 Schema changes
        org_id,
	--Added by dpsingh for LE uptake
        legal_entity_id
        ,transaction_date)
      VALUES (
        l_tas_rec.id,
        l_tas_rec.ica_id,
        l_tas_rec.tas_type,
        l_tas_rec.object_version_number,
        l_tas_rec.attribute_category,
        l_tas_rec.attribute1,
        l_tas_rec.attribute2,
        l_tas_rec.attribute3,
        l_tas_rec.attribute4,
        l_tas_rec.attribute5,
        l_tas_rec.attribute6,
        l_tas_rec.attribute7,
        l_tas_rec.attribute8,
        l_tas_rec.attribute9,
        l_tas_rec.attribute10,
        l_tas_rec.attribute11,
        l_tas_rec.attribute12,
        l_tas_rec.attribute13,
        l_tas_rec.attribute14,
        l_tas_rec.attribute15,
        l_tas_rec.created_by,
        l_tas_rec.creation_date,
        l_tas_rec.last_updated_by,
        l_tas_rec.last_update_date,
        l_tas_rec.last_update_login,
        l_tas_rec.tsu_code,
        l_tas_rec.try_id,
        l_tas_rec.date_trans_occurred,
        l_tas_rec.trans_number,
        l_tas_rec.comments,
        l_tas_rec.req_asset_id,
        l_tas_rec.total_match_amount,
--Bug#  2697681 : 11.5.9 Schema changes
        l_tas_rec.org_id,
	--Added by dpsingh for LE uptake
        l_tas_rec.legal_entity_id
        ,NVL(l_tas_rec.transaction_date,SYSDATE));

Line: 1288


  END insert_row;

Line: 1292


  PROCEDURE insert_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_tasv_rec                     IN tasv_rec_type,
    x_tasv_rec                     OUT NOCOPY tasv_rec_type) IS


    l_api_version                 CONSTANT NUMBER := 1;

Line: 1303


    l_api_name                     CONSTANT VARCHAR2(30) := 'V_insert_row';

Line: 1319


      l_tasv_rec.LAST_UPDATE_DATE := SYSDATE;

Line: 1320


      l_tasv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 1321


      l_tasv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 1334


      SELECT OKL_TRN_SEQ.NEXTVAL
      FROM dual;

Line: 1397


    insert_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_tas_rec,
      lx_tas_rec
    );

Line: 1445


  END insert_row;

Line: 1449


  PROCEDURE insert_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_tasv_tbl                     IN tasv_tbl_type,
    x_tasv_tbl                     OUT NOCOPY tasv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1459


    l_api_name                     CONSTANT VARCHAR2(30) := 'V_tbl_insert_row';

Line: 1468


        insert_row (
          p_api_version                  => p_api_version,
          p_init_msg_list                => OKC_API.G_FALSE,
          x_return_status                => x_return_status,
          x_msg_count                    => x_msg_count,
          x_msg_data                     => x_msg_data,
          p_tasv_rec                     => p_tasv_tbl(i),
          x_tasv_rec                     => x_tasv_tbl(i));

Line: 1511


  END insert_row;

Line: 1529


    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_TRX_ASSETS
     WHERE ID = p_tas_rec.id
       AND OBJECT_VERSION_NUMBER = p_tas_rec.object_version_number
    FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;

Line: 1536


    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_TRX_ASSETS
    WHERE ID = p_tas_rec.id;

Line: 1577


      OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);

Line: 1586


      OKC_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);

Line: 1773


  PROCEDURE update_row(
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_tas_rec                      IN tas_rec_type,
    x_tas_rec                      OUT NOCOPY tas_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1782


    l_api_name                     CONSTANT VARCHAR2(30) := 'ASSETS_update_row';

Line: 1892


      IF (x_tas_rec.last_updated_by = OKC_API.G_MISS_NUM)
      THEN
        x_tas_rec.last_updated_by := l_tas_rec.last_updated_by;

Line: 1896


      IF (x_tas_rec.last_update_date = OKC_API.G_MISS_DATE)
      THEN
        x_tas_rec.last_update_date := l_tas_rec.last_update_date;

Line: 1900


      IF (x_tas_rec.last_update_login = OKC_API.G_MISS_NUM)
      THEN
        x_tas_rec.last_update_login := l_tas_rec.last_update_login;

Line: 1986


    UPDATE  OKL_TRX_ASSETS
    SET ICA_ID = l_def_tas_rec.ica_id,
        TAS_TYPE = l_def_tas_rec.tas_type,
        OBJECT_VERSION_NUMBER = l_def_tas_rec.object_version_number,
        ATTRIBUTE_CATEGORY = l_def_tas_rec.attribute_category,
        ATTRIBUTE1 = l_def_tas_rec.attribute1,
        ATTRIBUTE2 = l_def_tas_rec.attribute2,
        ATTRIBUTE3 = l_def_tas_rec.attribute3,
        ATTRIBUTE4 = l_def_tas_rec.attribute4,
        ATTRIBUTE5 = l_def_tas_rec.attribute5,
        ATTRIBUTE6 = l_def_tas_rec.attribute6,
        ATTRIBUTE7 = l_def_tas_rec.attribute7,
        ATTRIBUTE8 = l_def_tas_rec.attribute8,
        ATTRIBUTE9 = l_def_tas_rec.attribute9,
        ATTRIBUTE10 = l_def_tas_rec.attribute10,
        ATTRIBUTE11 = l_def_tas_rec.attribute11,
        ATTRIBUTE12 = l_def_tas_rec.attribute12,
        ATTRIBUTE13 = l_def_tas_rec.attribute13,
        ATTRIBUTE14 = l_def_tas_rec.attribute14,
        ATTRIBUTE15 = l_def_tas_rec.attribute15,
        CREATED_BY = l_def_tas_rec.created_by,
        CREATION_DATE = l_def_tas_rec.creation_date,
        LAST_UPDATED_BY = l_def_tas_rec.last_updated_by,
        LAST_UPDATE_DATE = l_def_tas_rec.last_update_date,
        LAST_UPDATE_LOGIN = l_def_tas_rec.last_update_login,
        TSU_CODE = l_def_tas_rec.tsu_code,
        TRY_ID = l_def_tas_rec.try_id,
        DATE_TRANS_OCCURRED = l_def_tas_rec.date_trans_occurred,
        TRANS_NUMBER = l_def_tas_rec.trans_number,
        COMMENTS = l_def_tas_rec.comments,
        REQ_ASSET_ID = l_def_tas_rec.req_asset_id,
        TOTAL_MATCH_AMOUNT = l_def_tas_rec.total_match_amount,
--Bug#  2697681 : 11.5.9 Schema changes
        ORG_ID = l_def_tas_rec.org_id ,
	--Added by dpsingh for LE uptake
        LEGAL_ENTITY_ID = l_def_tas_rec.legal_entity_id
        ,TRANSACTION_DATE = l_def_tas_rec.transaction_date
     WHERE ID = l_def_tas_rec.id;

Line: 2058


  END update_row;

Line: 2062


  PROCEDURE update_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_tasv_rec                     IN tasv_rec_type,
    x_tasv_rec                     OUT NOCOPY tasv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2072


    l_api_name                     CONSTANT VARCHAR2(30) := 'V_update_row';

Line: 2086


      l_tasv_rec.LAST_UPDATE_DATE := SYSDATE;

Line: 2087


      l_tasv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 2088


      l_tasv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 2196


      IF (x_tasv_rec.last_updated_by = OKC_API.G_MISS_NUM)
      THEN
        x_tasv_rec.last_updated_by := l_tasv_rec.last_updated_by;

Line: 2200


      IF (x_tasv_rec.last_update_date = OKC_API.G_MISS_DATE)
      THEN
        x_tasv_rec.last_update_date := l_tasv_rec.last_update_date;

Line: 2204


      IF (x_tasv_rec.last_update_login = OKC_API.G_MISS_NUM)
      THEN
        x_tasv_rec.last_update_login := l_tasv_rec.last_update_login;

Line: 2317


    update_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_tas_rec,
      lx_tas_rec
    );

Line: 2364


  END update_row;

Line: 2368


  PROCEDURE update_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_tasv_tbl                     IN tasv_tbl_type,
    x_tasv_tbl                     OUT NOCOPY tasv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2378


    l_api_name                     CONSTANT VARCHAR2(30) := 'V_tbl_update_row';

Line: 2387


        update_row (
          p_api_version                  => p_api_version,
          p_init_msg_list                => OKC_API.G_FALSE,
          x_return_status                => x_return_status,
          x_msg_count                    => x_msg_count,
          x_msg_data                     => x_msg_data,
          p_tasv_rec                     => p_tasv_tbl(i),
          x_tasv_rec                     => x_tasv_tbl(i));

Line: 2430


  END update_row;

Line: 2438


  PROCEDURE delete_row(
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_tas_rec                      IN tas_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2446


    l_api_name                     CONSTANT VARCHAR2(30) := 'ASSETS_delete_row';

Line: 2460


    DELETE FROM OKL_TRX_ASSETS
     WHERE ID = l_tas_rec.id;

Line: 2495


  END delete_row;

Line: 2499


  PROCEDURE delete_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_tasv_rec                     IN tasv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2508


    l_api_name                     CONSTANT VARCHAR2(30) := 'V_delete_row';

Line: 2532


    delete_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_tas_rec
    );

Line: 2576


  END delete_row;

Line: 2580


  PROCEDURE delete_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_tasv_tbl                     IN tasv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2589


    l_api_name                     CONSTANT VARCHAR2(30) := 'V_tbl_delete_row';

Line: 2598


        delete_row (
          p_api_version                  => p_api_version,
          p_init_msg_list                => OKC_API.G_FALSE,
          x_return_status                => x_return_status,
          x_msg_count                    => x_msg_count,
          x_msg_data                     => x_msg_data,
          p_tasv_rec                     => p_tasv_tbl(i));

Line: 2640


  END delete_row;