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_CFO_PVT SQL Statements

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

Line: 101


    SELECT
            ID,
            OTY_CODE,
            SOURCE_TABLE,
            SOURCE_ID,
            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,
            OBJECT_VERSION_NUMBER
      FROM Okl_Cash_Flow_Objects_V
     WHERE okl_cash_flow_objects_v.id = p_id;

Line: 159


              l_cfov_rec.last_updated_by,
              l_cfov_rec.last_update_date,
              l_cfov_rec.last_update_login,
              l_cfov_rec.object_version_number;

Line: 204


    SELECT
            ID,
            OTY_CODE,
            SOURCE_TABLE,
            SOURCE_ID,
            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,
            OBJECT_VERSION_NUMBER
      FROM Okl_Cash_Flow_Objects
     WHERE okl_cash_flow_objects.id = p_id;

Line: 262


              l_cfo_rec.last_updated_by,
              l_cfo_rec.last_update_date,
              l_cfo_rec.last_update_login,
              l_cfo_rec.object_version_number;

Line: 373


    IF (l_cfov_rec.last_updated_by = OKL_API.G_MISS_NUM ) THEN
      l_cfov_rec.last_updated_by := NULL;

Line: 376


    IF (l_cfov_rec.last_update_date = OKL_API.G_MISS_DATE ) THEN
      l_cfov_rec.last_update_date := NULL;

Line: 379


    IF (l_cfov_rec.last_update_login = OKL_API.G_MISS_NUM ) THEN
      l_cfov_rec.last_update_login := NULL;

Line: 423


      SELECT 'x'
      FROM Fnd_Lookup_Values
      WHERE fnd_lookup_values.lookup_code = p_lookup_code
      AND   fnd_lookup_values.lookup_type = p_lookup_type;

Line: 621


      SELECT 'x'
        FROM Fnd_Lookup_Values
       WHERE fnd_lookup_values.lookup_code = p_lookup_code;

Line: 657


    SELECT 'x'
    FROM   okl_cash_flow_objects_v
    WHERE  source_table = p_source_table
    AND    source_id = p_source_id
    AND    id <> nvl(p_id, -99999);

Line: 732


    p_to.last_updated_by := p_from.last_updated_by;

Line: 733


    p_to.last_update_date := p_from.last_update_date;

Line: 734


    p_to.last_update_login := p_from.last_update_login;

Line: 764


    p_to.last_updated_by := p_from.last_updated_by;

Line: 765


    p_to.last_update_date := p_from.last_update_date;

Line: 766


    p_to.last_update_login := p_from.last_update_login;

Line: 1020


  PROCEDURE insert_row(
    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_cfo_rec                      IN cfo_rec_type,
    x_cfo_rec                      OUT NOCOPY cfo_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1029


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

Line: 1065


    INSERT INTO OKL_CASH_FLOW_OBJECTS(
      id,
      oty_code,
      source_table,
      source_id,
      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,
      object_version_number)
    VALUES (
      l_cfo_rec.id,
      l_cfo_rec.oty_code,
      l_cfo_rec.source_table,
      l_cfo_rec.source_id,
      l_cfo_rec.attribute_category,
      l_cfo_rec.attribute1,
      l_cfo_rec.attribute2,
      l_cfo_rec.attribute3,
      l_cfo_rec.attribute4,
      l_cfo_rec.attribute5,
      l_cfo_rec.attribute6,
      l_cfo_rec.attribute7,
      l_cfo_rec.attribute8,
      l_cfo_rec.attribute9,
      l_cfo_rec.attribute10,
      l_cfo_rec.attribute11,
      l_cfo_rec.attribute12,
      l_cfo_rec.attribute13,
      l_cfo_rec.attribute14,
      l_cfo_rec.attribute15,
      l_cfo_rec.created_by,
      l_cfo_rec.creation_date,
      l_cfo_rec.last_updated_by,
      l_cfo_rec.last_update_date,
      l_cfo_rec.last_update_login,
      l_cfo_rec.object_version_number);

Line: 1154


  END insert_row;

Line: 1158


  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_cfov_rec                     IN cfov_rec_type,
    x_cfov_rec                     OUT NOCOPY cfov_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1168


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

Line: 1184


      l_cfov_rec.LAST_UPDATE_DATE := l_cfov_rec.CREATION_DATE;

Line: 1185


      l_cfov_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 1186


      l_cfov_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 1256


    insert_row(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      l_cfo_rec,
      lx_cfo_rec
    );

Line: 1305


  END insert_row;

Line: 1309


  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_cfov_tbl                     IN cfov_tbl_type,
    x_cfov_tbl                     OUT NOCOPY cfov_tbl_type,
    px_error_tbl                   IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1320


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

Line: 1334


          insert_row (
            p_api_version                  => p_api_version,
            p_init_msg_list                => OKL_API.G_FALSE,
            x_return_status                => l_error_rec.error_type,
            x_msg_count                    => l_error_rec.msg_count,
            x_msg_data                     => l_error_rec.msg_data,
            p_cfov_rec                     => p_cfov_tbl(i),
            x_cfov_rec                     => x_cfov_tbl(i));

Line: 1402


  END insert_row;

Line: 1409


  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_cfov_tbl                     IN cfov_tbl_type,
    x_cfov_tbl                     OUT NOCOPY cfov_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1419


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

Line: 1426


      insert_row (
        p_api_version                  => p_api_version,
        p_init_msg_list                => OKL_API.G_FALSE,
        x_return_status                => x_return_status,
        x_msg_count                    => x_msg_count,
        x_msg_data                     => x_msg_data,
        p_cfov_tbl                     => p_cfov_tbl,
        x_cfov_tbl                     => x_cfov_tbl,
        px_error_tbl                   => l_error_tbl);

Line: 1468


  END insert_row;

Line: 1475


  PROCEDURE insert_row_bulk(
    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_cfov_tbl                     IN cfov_tbl_type,
    x_cfov_tbl                     OUT NOCOPY cfov_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1485


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

Line: 1511


    in_last_updated_by Number15TabTyp;

Line: 1512


    in_last_update_date DateTabTyp;

Line: 1513


    in_last_update_login Number15TabTyp;

Line: 1556


      l_cfov_rec.LAST_UPDATE_DATE := l_cfov_rec.CREATION_DATE;

Line: 1557


      l_cfov_rec.LAST_UPDATED_BY := l_user_id;

Line: 1558


      l_cfov_rec.LAST_UPDATE_LOGIN := l_login_id;

Line: 1574


      in_last_updated_by(j) := l_cfov_rec.last_updated_by;

Line: 1575


      in_last_update_date(j) := l_cfov_rec.last_update_date;

Line: 1576


      in_last_update_login(j) := l_cfov_rec.last_update_login;

Line: 1604


    INSERT INTO OKL_CASH_FLOW_OBJECTS(
      id,
      oty_code,
      source_table,
      source_id,
      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,
      object_version_number)
    VALUES (
      in_id(i),
      in_oty_code(i),
      in_source_table(i),
      in_source_id(i),
      in_attribute_category(i),
      in_attribute1(i),
      in_attribute2(i),
      in_attribute3(i),
      in_attribute4(i),
      in_attribute5(i),
      in_attribute6(i),
      in_attribute7(i),
      in_attribute8(i),
      in_attribute9(i),
      in_attribute10(i),
      in_attribute11(i),
      in_attribute12(i),
      in_attribute13(i),
      in_attribute14(i),
      in_attribute15(i),
      in_created_by(i),
      in_creation_date(i),
      in_last_updated_by(i),
      in_last_update_date(i),
      in_last_update_login(i),
      in_object_version_number(i));

Line: 1693


  END insert_row_bulk;

Line: 1712


    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_CASH_FLOW_OBJECTS
     WHERE ID = p_cfo_rec.id
       AND OBJECT_VERSION_NUMBER = p_cfo_rec.object_version_number
    FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;

Line: 1719


    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_CASH_FLOW_OBJECTS
     WHERE ID = p_cfo_rec.id;

Line: 1760


      OKL_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);

Line: 1769


      OKL_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);

Line: 2049


  PROCEDURE update_row(
    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_cfo_rec                      IN cfo_rec_type,
    x_cfo_rec                      OUT NOCOPY cfo_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2058


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

Line: 2166


        IF (x_cfo_rec.last_updated_by = OKL_API.G_MISS_NUM)
        THEN
          x_cfo_rec.last_updated_by := l_cfo_rec.last_updated_by;

Line: 2170


        IF (x_cfo_rec.last_update_date = OKL_API.G_MISS_DATE)
        THEN
          x_cfo_rec.last_update_date := l_cfo_rec.last_update_date;

Line: 2174


        IF (x_cfo_rec.last_update_login = OKL_API.G_MISS_NUM)
        THEN
          x_cfo_rec.last_update_login := l_cfo_rec.last_update_login;

Line: 2224


    UPDATE OKL_CASH_FLOW_OBJECTS
    SET OTY_CODE = l_def_cfo_rec.oty_code,
        SOURCE_TABLE = l_def_cfo_rec.source_table,
        SOURCE_ID = l_def_cfo_rec.source_id,
        ATTRIBUTE_CATEGORY = l_def_cfo_rec.attribute_category,
        ATTRIBUTE1 = l_def_cfo_rec.attribute1,
        ATTRIBUTE2 = l_def_cfo_rec.attribute2,
        ATTRIBUTE3 = l_def_cfo_rec.attribute3,
        ATTRIBUTE4 = l_def_cfo_rec.attribute4,
        ATTRIBUTE5 = l_def_cfo_rec.attribute5,
        ATTRIBUTE6 = l_def_cfo_rec.attribute6,
        ATTRIBUTE7 = l_def_cfo_rec.attribute7,
        ATTRIBUTE8 = l_def_cfo_rec.attribute8,
        ATTRIBUTE9 = l_def_cfo_rec.attribute9,
        ATTRIBUTE10 = l_def_cfo_rec.attribute10,
        ATTRIBUTE11 = l_def_cfo_rec.attribute11,
        ATTRIBUTE12 = l_def_cfo_rec.attribute12,
        ATTRIBUTE13 = l_def_cfo_rec.attribute13,
        ATTRIBUTE14 = l_def_cfo_rec.attribute14,
        ATTRIBUTE15 = l_def_cfo_rec.attribute15,
        CREATED_BY = l_def_cfo_rec.created_by,
        CREATION_DATE = l_def_cfo_rec.creation_date,
        LAST_UPDATED_BY = l_def_cfo_rec.last_updated_by,
        LAST_UPDATE_DATE = l_def_cfo_rec.last_update_date,
        LAST_UPDATE_LOGIN = l_def_cfo_rec.last_update_login,
        OBJECT_VERSION_NUMBER = l_def_cfo_rec.object_version_number
    WHERE ID = l_def_cfo_rec.id;

Line: 2286


  END update_row;

Line: 2290


  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_cfov_rec                     IN cfov_rec_type,
    x_cfov_rec                     OUT NOCOPY cfov_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2300


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

Line: 2315


      l_cfov_rec.LAST_UPDATE_DATE := SYSDATE;

Line: 2316


      l_cfov_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 2317


      l_cfov_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 2424


        IF (x_cfov_rec.last_updated_by = OKL_API.G_MISS_NUM)
        THEN
          x_cfov_rec.last_updated_by := l_db_cfov_rec.last_updated_by;

Line: 2428


        IF (x_cfov_rec.last_update_date = OKL_API.G_MISS_DATE)
        THEN
          x_cfov_rec.last_update_date := l_db_cfov_rec.last_update_date;

Line: 2432


        IF (x_cfov_rec.last_update_login = OKL_API.G_MISS_NUM)
        THEN
          x_cfov_rec.last_update_login := l_db_cfov_rec.last_update_login;

Line: 2523


    update_row(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      l_cfo_rec,
      lx_cfo_rec
    );

Line: 2571


  END update_row;

Line: 2575


  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_cfov_tbl                     IN cfov_tbl_type,
    x_cfov_tbl                     OUT NOCOPY cfov_tbl_type,
    px_error_tbl                   IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2586


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

Line: 2600


          update_row (
            p_api_version                  => p_api_version,
            p_init_msg_list                => OKL_API.G_FALSE,
            x_return_status                => l_error_rec.error_type,
            x_msg_count                    => l_error_rec.msg_count,
            x_msg_data                     => l_error_rec.msg_data,
            p_cfov_rec                     => p_cfov_tbl(i),
            x_cfov_rec                     => x_cfov_tbl(i));

Line: 2668


  END update_row;

Line: 2675


  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_cfov_tbl                     IN cfov_tbl_type,
    x_cfov_tbl                     OUT NOCOPY cfov_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2685


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

Line: 2692


      update_row (
        p_api_version                  => p_api_version,
        p_init_msg_list                => OKL_API.G_FALSE,
        x_return_status                => x_return_status,
        x_msg_count                    => x_msg_count,
        x_msg_data                     => x_msg_data,
        p_cfov_tbl                     => p_cfov_tbl,
        x_cfov_tbl                     => x_cfov_tbl,
        px_error_tbl                   => l_error_tbl);

Line: 2734


  END update_row;

Line: 2742


  PROCEDURE delete_row(
    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_cfo_rec                      IN cfo_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2750


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

Line: 2765


    DELETE FROM OKL_CASH_FLOW_OBJECTS
     WHERE ID = p_cfo_rec.id;

Line: 2801


  END delete_row;

Line: 2805


  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_cfov_rec                     IN cfov_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2814


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

Line: 2838


    delete_row(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      l_cfo_rec
    );

Line: 2883


  END delete_row;

Line: 2887


  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_cfov_tbl                     IN cfov_tbl_type,
    px_error_tbl                   IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2897


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

Line: 2911


          delete_row (
            p_api_version                  => p_api_version,
            p_init_msg_list                => OKL_API.G_FALSE,
            x_return_status                => l_error_rec.error_type,
            x_msg_count                    => l_error_rec.msg_count,
            x_msg_data                     => l_error_rec.msg_data,
            p_cfov_rec                     => p_cfov_tbl(i));

Line: 2978


  END delete_row;

Line: 2983


  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_cfov_tbl                     IN cfov_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2992


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

Line: 2999


      delete_row (
        p_api_version                  => p_api_version,
        p_init_msg_list                => OKL_API.G_FALSE,
        x_return_status                => x_return_status,
        x_msg_count                    => x_msg_count,
        x_msg_data                     => x_msg_data,
        p_cfov_tbl                     => p_cfov_tbl,
        px_error_tbl                   => l_error_tbl);

Line: 3040


  END delete_row;