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

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

Line: 57


    DELETE FROM OKL_BILLING_CHARGES_TL T
     WHERE NOT EXISTS (
        SELECT NULL
          FROM OKL_BLNG_CHARGES_ALL_B B    --fixed bug 3321017 by kmotepal
         WHERE B.ID = T.ID
        );

Line: 64


    UPDATE OKL_BILLING_CHARGES_TL T SET (
        CHARGE_TYPE,
        DESCRIPTION) = (SELECT
                                  B.CHARGE_TYPE,
                                  B.DESCRIPTION
                                FROM OKL_BILLING_CHARGES_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_BILLING_CHARGES_TL SUBB, OKL_BILLING_CHARGES_TL SUBT
               WHERE SUBB.ID = SUBT.ID
                 AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
                 AND (SUBB.CHARGE_TYPE <> SUBT.CHARGE_TYPE
                      OR SUBB.DESCRIPTION <> SUBT.DESCRIPTION
                      OR (SUBB.CHARGE_TYPE IS NULL AND SUBT.CHARGE_TYPE IS NOT NULL)
                      OR (SUBB.CHARGE_TYPE IS NOT NULL AND SUBT.CHARGE_TYPE IS NULL)
                      OR (SUBB.DESCRIPTION IS NULL AND SUBT.DESCRIPTION IS NOT NULL)
                      OR (SUBB.DESCRIPTION IS NOT NULL AND SUBT.DESCRIPTION IS NULL)
              ));

Line: 89


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

Line: 133


    SELECT
            ID,
            SEQUENCE_NUMBER,
            BGH_ID,
            OBJECT_VERSION_NUMBER,
            CONTRACT_ID,
            ASSET_ID,
            CHARGE_DATE,
            AMOUNT,
            CURRENCY_CODE,
            CUSTOMER_ID,
            CUSTOMER_REF,
            CUSTOMER_ADDRESS_ID,
            CUSTOMER_ADDRESS_REF,
            REQUEST_ID,
            PROGRAM_APPLICATION_ID,
            PROGRAM_ID,
            PROGRAM_UPDATE_DATE,
            ORG_ID,
			STY_ID,
			STY_NAME,
            ATTRIBUTE_CATEGORY,
            ATTRIBUTE1,
            ATTRIBUTE2,
            ATTRIBUTE3,
            ATTRIBUTE4,
            ATTRIBUTE5,
            ATTRIBUTE6,
            ATTRIBUTE7,
            ATTRIBUTE8,
            ATTRIBUTE9,
            ATTRIBUTE10,
            ATTRIBUTE11,
            ATTRIBUTE12,
            ATTRIBUTE13,
            ATTRIBUTE14,
            ATTRIBUTE15,
            INTERFACE_ATTRIBUTE1,
            INTERFACE_ATTRIBUTE2,
            INTERFACE_ATTRIBUTE3,
            INTERFACE_ATTRIBUTE4,
            INTERFACE_ATTRIBUTE5,
            INTERFACE_ATTRIBUTE6,
            INTERFACE_ATTRIBUTE7,
            INTERFACE_ATTRIBUTE8,
            INTERFACE_ATTRIBUTE9,
            INTERFACE_ATTRIBUTE10,
            INTERFACE_ATTRIBUTE11,
            INTERFACE_ATTRIBUTE12,
            INTERFACE_ATTRIBUTE13,
            INTERFACE_ATTRIBUTE14,
            INTERFACE_ATTRIBUTE15,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN
      FROM Okl_Billing_Charges_B
     WHERE okl_billing_charges_b.id = p_id;

Line: 215


              l_bch_rec.PROGRAM_UPDATE_DATE,
              l_bch_rec.ORG_ID,
              l_bch_rec.STY_ID,
              l_bch_rec.STY_NAME,
              l_bch_rec.ATTRIBUTE_CATEGORY,
              l_bch_rec.ATTRIBUTE1,
              l_bch_rec.ATTRIBUTE2,
              l_bch_rec.ATTRIBUTE3,
              l_bch_rec.ATTRIBUTE4,
              l_bch_rec.ATTRIBUTE5,
              l_bch_rec.ATTRIBUTE6,
              l_bch_rec.ATTRIBUTE7,
              l_bch_rec.ATTRIBUTE8,
              l_bch_rec.ATTRIBUTE9,
              l_bch_rec.ATTRIBUTE10,
              l_bch_rec.ATTRIBUTE11,
              l_bch_rec.ATTRIBUTE12,
              l_bch_rec.ATTRIBUTE13,
              l_bch_rec.ATTRIBUTE14,
              l_bch_rec.ATTRIBUTE15,
              l_bch_rec.INTERFACE_ATTRIBUTE1,
              l_bch_rec.INTERFACE_ATTRIBUTE2,
              l_bch_rec.INTERFACE_ATTRIBUTE3,
              l_bch_rec.INTERFACE_ATTRIBUTE4,
              l_bch_rec.INTERFACE_ATTRIBUTE5,
              l_bch_rec.INTERFACE_ATTRIBUTE6,
              l_bch_rec.INTERFACE_ATTRIBUTE7,
              l_bch_rec.INTERFACE_ATTRIBUTE8,
              l_bch_rec.INTERFACE_ATTRIBUTE9,
              l_bch_rec.INTERFACE_ATTRIBUTE10,
              l_bch_rec.INTERFACE_ATTRIBUTE11,
              l_bch_rec.INTERFACE_ATTRIBUTE12,
              l_bch_rec.INTERFACE_ATTRIBUTE13,
              l_bch_rec.INTERFACE_ATTRIBUTE14,
              l_bch_rec.INTERFACE_ATTRIBUTE15,
              l_bch_rec.CREATED_BY,
              l_bch_rec.CREATION_DATE,
              l_bch_rec.LAST_UPDATED_BY,
              l_bch_rec.LAST_UPDATE_DATE,
              l_bch_rec.LAST_UPDATE_LOGIN;

Line: 276


    SELECT
            ID,
            Okl_Billing_Charges_Tl.LANGUAGE,
            SOURCE_LANG,
            SFWT_FLAG,
            CHARGE_TYPE,
            DESCRIPTION,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN
      FROM Okl_Billing_Charges_Tl
     WHERE okl_billing_charges_tl.id = p_id
       AND okl_billing_charges_tl.LANGUAGE = p_language;

Line: 307


              l_okl_billing_charges_tl_rec.LAST_UPDATED_BY,
              l_okl_billing_charges_tl_rec.LAST_UPDATE_DATE,
              l_okl_billing_charges_tl_rec.LAST_UPDATE_LOGIN;

Line: 330


    SELECT
            ID,
            OBJECT_VERSION_NUMBER,
            SFWT_FLAG,
            BGH_ID,
            SEQUENCE_NUMBER,
            CONTRACT_ID,
            ASSET_ID,
            CHARGE_TYPE,
            CHARGE_DATE,
            AMOUNT,
            CURRENCY_CODE,
            DESCRIPTION,
            CUSTOMER_ID,
            CUSTOMER_REF,
            CUSTOMER_ADDRESS_ID,
            CUSTOMER_ADDRESS_REF,
			STY_ID,
			STY_NAME,
            ATTRIBUTE_CATEGORY,
            ATTRIBUTE1,
            ATTRIBUTE2,
            ATTRIBUTE3,
            ATTRIBUTE4,
            ATTRIBUTE5,
            ATTRIBUTE6,
            ATTRIBUTE7,
            ATTRIBUTE8,
            ATTRIBUTE9,
            ATTRIBUTE10,
            ATTRIBUTE11,
            ATTRIBUTE12,
            ATTRIBUTE13,
            ATTRIBUTE14,
            ATTRIBUTE15,
            INTERFACE_ATTRIBUTE1,
            INTERFACE_ATTRIBUTE2,
            INTERFACE_ATTRIBUTE3,
            INTERFACE_ATTRIBUTE4,
            INTERFACE_ATTRIBUTE5,
            INTERFACE_ATTRIBUTE6,
            INTERFACE_ATTRIBUTE7,
            INTERFACE_ATTRIBUTE8,
            INTERFACE_ATTRIBUTE9,
            INTERFACE_ATTRIBUTE10,
            INTERFACE_ATTRIBUTE11,
            INTERFACE_ATTRIBUTE12,
            INTERFACE_ATTRIBUTE13,
            INTERFACE_ATTRIBUTE14,
            INTERFACE_ATTRIBUTE15,
            REQUEST_ID,
            PROGRAM_APPLICATION_ID,
            PROGRAM_ID,
            PROGRAM_UPDATE_DATE,
            ORG_ID,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN
      FROM Okl_Billing_Charges_V
     WHERE okl_billing_charges_v.id = p_id;

Line: 451


              l_bchv_rec.PROGRAM_UPDATE_DATE,
              l_bchv_rec.ORG_ID,
              l_bchv_rec.CREATED_BY,
              l_bchv_rec.CREATION_DATE,
              l_bchv_rec.LAST_UPDATED_BY,
              l_bchv_rec.LAST_UPDATE_DATE,
              l_bchv_rec.LAST_UPDATE_LOGIN;

Line: 632


    IF (l_bchv_rec.program_update_date = Okl_Api.G_MISS_DATE) THEN
      l_bchv_rec.program_update_date := NULL;

Line: 644


    IF (l_bchv_rec.last_updated_by = Okl_Api.G_MISS_NUM) THEN
      l_bchv_rec.last_updated_by := NULL;

Line: 647


    IF (l_bchv_rec.last_update_date = Okl_Api.G_MISS_DATE) THEN
      l_bchv_rec.last_update_date := NULL;

Line: 650


    IF (l_bchv_rec.last_update_login = Okl_Api.G_MISS_NUM) THEN
      l_bchv_rec.last_update_login := NULL;

Line: 778


		  SELECT 'x'
		  FROM   okl_bllng_chrg_hdrs_v
		  WHERE  id = p_bchv_rec.bgh_id;

Line: 956


		  SELECT 'x'
		  FROM   okl_billing_charges_v
		  WHERE  bgh_id          = p_bchv_rec.bgh_id
		  AND    sequence_number = p_bchv_rec.sequence_number
		  AND    id              <> NVL (p_bchv_rec.id, -99999);

Line: 1172


    p_to.program_update_date := p_from.program_update_date;

Line: 1209


    p_to.last_updated_by := p_from.last_updated_by;

Line: 1210


    p_to.last_update_date := p_from.last_update_date;

Line: 1211


    p_to.last_update_login := p_from.last_update_login;

Line: 1234


    p_to.program_update_date := p_from.program_update_date;

Line: 1271


    p_to.last_updated_by := p_from.last_updated_by;

Line: 1272


    p_to.last_update_date := p_from.last_update_date;

Line: 1273


    p_to.last_update_login := p_from.last_update_login;

Line: 1286


    p_to.last_updated_by := p_from.last_updated_by;

Line: 1287


    p_to.last_update_date := p_from.last_update_date;

Line: 1288


    p_to.last_update_login := p_from.last_update_login;

Line: 1301


    p_to.last_updated_by := p_from.last_updated_by;

Line: 1302


    p_to.last_update_date := p_from.last_update_date;

Line: 1303


    p_to.last_update_login := p_from.last_update_login;

Line: 1474


  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_bch_rec                      IN bch_rec_type,
    x_bch_rec                      OUT NOCOPY bch_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1483


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

Line: 1519


    INSERT INTO OKL_BILLING_CHARGES_B(
        id,
        sequence_number,
        bgh_id,
        object_version_number,
        contract_id,
        asset_id,
        charge_date,
        amount,
        currency_code,
        customer_id,
        customer_ref,
        customer_address_id,
        customer_address_ref,
        request_id,
        program_application_id,
        program_id,
        program_update_date,
        org_id,
        sty_id,
        sty_name,
        attribute_category,
        attribute1,
        attribute2,
        attribute3,
        attribute4,
        attribute5,
        attribute6,
        attribute7,
        attribute8,
        attribute9,
        attribute10,
        attribute11,
        attribute12,
        attribute13,
        attribute14,
        attribute15,
        interface_attribute1,
        interface_attribute2,
        interface_attribute3,
        interface_attribute4,
        interface_attribute5,
        interface_attribute6,
        interface_attribute7,
        interface_attribute8,
        interface_attribute9,
        interface_attribute10,
        interface_attribute11,
        interface_attribute12,
        interface_attribute13,
        interface_attribute14,
        interface_attribute15,
        created_by,
        creation_date,
        last_updated_by,
        last_update_date,
        last_update_login)
      VALUES (
        l_bch_rec.id,
        l_bch_rec.sequence_number,
        l_bch_rec.bgh_id,
        l_bch_rec.object_version_number,
        l_bch_rec.contract_id,
        l_bch_rec.asset_id,
        l_bch_rec.charge_date,
        l_bch_rec.amount,
        l_bch_rec.currency_code,
        l_bch_rec.customer_id,
        l_bch_rec.customer_ref,
        l_bch_rec.customer_address_id,
        l_bch_rec.customer_address_ref,
        l_bch_rec.request_id,
        l_bch_rec.program_application_id,
        l_bch_rec.program_id,
        l_bch_rec.program_update_date,
        l_bch_rec.org_id,
        l_bch_rec.sty_id,
        l_bch_rec.sty_name,
        l_bch_rec.attribute_category,
        l_bch_rec.attribute1,
        l_bch_rec.attribute2,
        l_bch_rec.attribute3,
        l_bch_rec.attribute4,
        l_bch_rec.attribute5,
        l_bch_rec.attribute6,
        l_bch_rec.attribute7,
        l_bch_rec.attribute8,
        l_bch_rec.attribute9,
        l_bch_rec.attribute10,
        l_bch_rec.attribute11,
        l_bch_rec.attribute12,
        l_bch_rec.attribute13,
        l_bch_rec.attribute14,
        l_bch_rec.attribute15,
        l_bch_rec.interface_attribute1,
        l_bch_rec.interface_attribute2,
        l_bch_rec.interface_attribute3,
        l_bch_rec.interface_attribute4,
        l_bch_rec.interface_attribute5,
        l_bch_rec.interface_attribute6,
        l_bch_rec.interface_attribute7,
        l_bch_rec.interface_attribute8,
        l_bch_rec.interface_attribute9,
        l_bch_rec.interface_attribute10,
        l_bch_rec.interface_attribute11,
        l_bch_rec.interface_attribute12,
        l_bch_rec.interface_attribute13,
        l_bch_rec.interface_attribute14,
        l_bch_rec.interface_attribute15,
        l_bch_rec.created_by,
        l_bch_rec.creation_date,
        l_bch_rec.last_updated_by,
        l_bch_rec.last_update_date,
        l_bch_rec.last_update_login);

Line: 1667


  END insert_row;

Line: 1671


  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_okl_billing_charges_tl_rec   IN OklBillingChargesTlRecType,
    x_okl_billing_charges_tl_rec   OUT NOCOPY OklBillingChargesTlRecType) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1680


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

Line: 1685


      SELECT *
        FROM FND_LANGUAGES
       WHERE INSTALLED_FLAG IN ('I', 'B');

Line: 1724


      INSERT INTO OKL_BILLING_CHARGES_TL(
          id,
          LANGUAGE,
          source_lang,
          sfwt_flag,
          charge_type,
          description,
          created_by,
          creation_date,
          last_updated_by,
          last_update_date,
          last_update_login)
        VALUES (
          l_okl_billing_charges_tl_rec.id,
          l_okl_billing_charges_tl_rec.LANGUAGE,
          l_okl_billing_charges_tl_rec.source_lang,
          l_okl_billing_charges_tl_rec.sfwt_flag,
          l_okl_billing_charges_tl_rec.charge_type,
          l_okl_billing_charges_tl_rec.description,
          l_okl_billing_charges_tl_rec.created_by,
          l_okl_billing_charges_tl_rec.creation_date,
          l_okl_billing_charges_tl_rec.last_updated_by,
          l_okl_billing_charges_tl_rec.last_update_date,
          l_okl_billing_charges_tl_rec.last_update_login);

Line: 1783


  END insert_row;

Line: 1787


  PROCEDURE insert_row(
    p_api_version                  IN NUMBER,
    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_bchv_rec                     IN bchv_rec_type,
    x_bchv_rec                     OUT NOCOPY bchv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1797


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

Line: 1815


      l_bchv_rec.LAST_UPDATE_DATE := l_bchv_rec.CREATION_DATE;

Line: 1816


      l_bchv_rec.LAST_UPDATED_BY := Fnd_Global.USER_ID;

Line: 1817


      l_bchv_rec.LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;

Line: 1833


      SELECT
        DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
        DECODE(Fnd_Global.PROG_APPL_ID,   -1,NULL,Fnd_Global.PROG_APPL_ID),
        DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),
        DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE)
      INTO
        x_bchv_rec.request_id,
        x_bchv_rec.program_application_id,
        x_bchv_rec.program_id,
        x_bchv_rec.program_update_date
      FROM   dual;

Line: 1896


    insert_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_bch_rec,
      lx_bch_rec
    );

Line: 1910


    insert_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_okl_billing_charges_tl_rec,
      lx_okl_billing_charges_tl_rec
    );

Line: 1958


  END insert_row;

Line: 1962


  PROCEDURE insert_row(
    p_api_version                  IN NUMBER,
    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_bchv_tbl                     IN bchv_tbl_type,
    x_bchv_tbl                     OUT NOCOPY bchv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1972


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

Line: 1986


        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_bchv_rec                     => p_bchv_tbl(i),
          x_bchv_rec                     => x_bchv_tbl(i));

Line: 2041


  END insert_row;

Line: 2059


    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_BILLING_CHARGES_B
     WHERE ID = p_bch_rec.id
       AND OBJECT_VERSION_NUMBER = p_bch_rec.object_version_number
    FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;

Line: 2066


    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_BILLING_CHARGES_B
    WHERE ID = p_bch_rec.id;

Line: 2107


      Okl_Api.set_message(G_FND_APP,G_FORM_RECORD_DELETED);

Line: 2116


      Okl_Api.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);

Line: 2165


    SELECT *
      FROM OKL_BILLING_CHARGES_TL
     WHERE ID = p_okl_billing_charges_tl_rec.id
    FOR UPDATE NOWAIT;

Line: 2201


      Okl_Api.set_message(G_FND_APP,G_FORM_RECORD_DELETED);

Line: 2419


  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_bch_rec                      IN bch_rec_type,
    x_bch_rec                      OUT NOCOPY bch_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2428


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

Line: 2514


      IF (x_bch_rec.program_update_date = Okl_Api.G_MISS_DATE)
      THEN
        x_bch_rec.program_update_date := l_bch_rec.program_update_date;

Line: 2662


      IF (x_bch_rec.last_updated_by = Okl_Api.G_MISS_NUM)
      THEN
        x_bch_rec.last_updated_by := l_bch_rec.last_updated_by;

Line: 2666


      IF (x_bch_rec.last_update_date = Okl_Api.G_MISS_DATE)
      THEN
        x_bch_rec.last_update_date := l_bch_rec.last_update_date;

Line: 2670


      IF (x_bch_rec.last_update_login = Okl_Api.G_MISS_NUM)
      THEN
        x_bch_rec.last_update_login := l_bch_rec.last_update_login;

Line: 2714


    UPDATE  OKL_BILLING_CHARGES_B
    SET SEQUENCE_NUMBER = l_def_bch_rec.sequence_number,
        BGH_ID = l_def_bch_rec.bgh_id,
        OBJECT_VERSION_NUMBER = l_def_bch_rec.object_version_number,
        CONTRACT_ID = l_def_bch_rec.contract_id,
        ASSET_ID = l_def_bch_rec.asset_id,
        CHARGE_DATE = l_def_bch_rec.charge_date,
        AMOUNT = l_def_bch_rec.amount,
        CURRENCY_CODE = l_def_bch_rec.currency_code,
        CUSTOMER_ID = l_def_bch_rec.customer_id,
        CUSTOMER_REF = l_def_bch_rec.customer_ref,
        CUSTOMER_ADDRESS_ID = l_def_bch_rec.customer_address_id,
        CUSTOMER_ADDRESS_REF = l_def_bch_rec.customer_address_ref,
        REQUEST_ID = l_def_bch_rec.request_id,
        PROGRAM_APPLICATION_ID = l_def_bch_rec.program_application_id,
        PROGRAM_ID = l_def_bch_rec.program_id,
        PROGRAM_UPDATE_DATE = l_def_bch_rec.program_update_date,
        ORG_ID = l_def_bch_rec.org_id,
        STY_ID = l_def_bch_rec.sty_id,
        STY_NAME = l_def_bch_rec.sty_name,
        ATTRIBUTE_CATEGORY = l_def_bch_rec.attribute_category,
        ATTRIBUTE1 = l_def_bch_rec.attribute1,
        ATTRIBUTE2 = l_def_bch_rec.attribute2,
        ATTRIBUTE3 = l_def_bch_rec.attribute3,
        ATTRIBUTE4 = l_def_bch_rec.attribute4,
        ATTRIBUTE5 = l_def_bch_rec.attribute5,
        ATTRIBUTE6 = l_def_bch_rec.attribute6,
        ATTRIBUTE7 = l_def_bch_rec.attribute7,
        ATTRIBUTE8 = l_def_bch_rec.attribute8,
        ATTRIBUTE9 = l_def_bch_rec.attribute9,
        ATTRIBUTE10 = l_def_bch_rec.attribute10,
        ATTRIBUTE11 = l_def_bch_rec.attribute11,
        ATTRIBUTE12 = l_def_bch_rec.attribute12,
        ATTRIBUTE13 = l_def_bch_rec.attribute13,
        ATTRIBUTE14 = l_def_bch_rec.attribute14,
        ATTRIBUTE15 = l_def_bch_rec.attribute15,
        interface_attribute1 = l_def_bch_rec.interface_attribute1,
        interface_attribute2 = l_def_bch_rec.interface_attribute2,
        interface_attribute3 = l_def_bch_rec.interface_attribute3,
        interface_attribute4 = l_def_bch_rec.interface_attribute4,
        interface_attribute5 = l_def_bch_rec.interface_attribute5,
        interface_attribute6 = l_def_bch_rec.interface_attribute6,
        interface_attribute7 = l_def_bch_rec.interface_attribute7,
        interface_attribute8 = l_def_bch_rec.interface_attribute8,
        interface_attribute9 = l_def_bch_rec.interface_attribute9,
        interface_attribute10 = l_def_bch_rec.interface_attribute10,
        interface_attribute11 = l_def_bch_rec.interface_attribute11,
        interface_attribute12 = l_def_bch_rec.interface_attribute12,
        interface_attribute13 = l_def_bch_rec.interface_attribute13,
        interface_attribute14 = l_def_bch_rec.interface_attribute14,
        interface_attribute15 = l_def_bch_rec.interface_attribute15,
        CREATED_BY = l_def_bch_rec.created_by,
        CREATION_DATE = l_def_bch_rec.creation_date,
        LAST_UPDATED_BY = l_def_bch_rec.last_updated_by,
        LAST_UPDATE_DATE = l_def_bch_rec.last_update_date,
        LAST_UPDATE_LOGIN = l_def_bch_rec.last_update_login
    WHERE ID = l_def_bch_rec.id;

Line: 2805


  END update_row;

Line: 2809


  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_okl_billing_charges_tl_rec   IN OklBillingChargesTlRecType,
    x_okl_billing_charges_tl_rec   OUT NOCOPY OklBillingChargesTlRecType) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2818


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

Line: 2872


      IF (x_okl_billing_charges_tl_rec.last_updated_by = Okl_Api.G_MISS_NUM)
      THEN
        x_okl_billing_charges_tl_rec.last_updated_by := l_okl_billing_charges_tl_rec.last_updated_by;

Line: 2876


      IF (x_okl_billing_charges_tl_rec.last_update_date = Okl_Api.G_MISS_DATE)
      THEN
        x_okl_billing_charges_tl_rec.last_update_date := l_okl_billing_charges_tl_rec.last_update_date;

Line: 2880


      IF (x_okl_billing_charges_tl_rec.last_update_login = Okl_Api.G_MISS_NUM)
      THEN
        x_okl_billing_charges_tl_rec.last_update_login := l_okl_billing_charges_tl_rec.last_update_login;

Line: 2926


    UPDATE  OKL_BILLING_CHARGES_TL
    SET CHARGE_TYPE = ldefoklbillingchargestlrec.charge_type,
        DESCRIPTION = ldefoklbillingchargestlrec.description,
        CREATED_BY = ldefoklbillingchargestlrec.created_by,
        CREATION_DATE = ldefoklbillingchargestlrec.creation_date,
        LAST_UPDATED_BY = ldefoklbillingchargestlrec.last_updated_by,
        LAST_UPDATE_DATE = ldefoklbillingchargestlrec.last_update_date,
        LAST_UPDATE_LOGIN = ldefoklbillingchargestlrec.last_update_login
    WHERE ID = ldefoklbillingchargestlrec.id
      --AND SOURCE_LANG = USERENV('LANG');

Line: 2938


    UPDATE  OKL_BILLING_CHARGES_TL
    SET SFWT_FLAG = 'Y'
    WHERE ID = ldefoklbillingchargestlrec.id
      AND SOURCE_LANG <> USERENV('LANG');

Line: 2976


  END update_row;

Line: 2980


  PROCEDURE update_row(
    p_api_version                  IN NUMBER,
    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_bchv_rec                     IN bchv_rec_type,
    x_bchv_rec                     OUT NOCOPY bchv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2990


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

Line: 3006


      l_bchv_rec.LAST_UPDATE_DATE := SYSDATE;

Line: 3007


      l_bchv_rec.LAST_UPDATED_BY := Fnd_Global.USER_ID;

Line: 3008


      l_bchv_rec.LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;

Line: 3236


      IF (x_bchv_rec.program_update_date = Okl_Api.G_MISS_DATE)
      THEN
        x_bchv_rec.program_update_date := l_bchv_rec.program_update_date;

Line: 3252


      IF (x_bchv_rec.last_updated_by = Okl_Api.G_MISS_NUM)
      THEN
        x_bchv_rec.last_updated_by := l_bchv_rec.last_updated_by;

Line: 3256


      IF (x_bchv_rec.last_update_date = Okl_Api.G_MISS_DATE)
      THEN
        x_bchv_rec.last_update_date := l_bchv_rec.last_update_date;

Line: 3260


      IF (x_bchv_rec.last_update_login = Okl_Api.G_MISS_NUM)
      THEN
        x_bchv_rec.last_update_login := l_bchv_rec.last_update_login;

Line: 3278


      SELECT
        NVL(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
            x_bchv_rec.request_id),
        NVL(DECODE(Fnd_Global.PROG_APPL_ID,   -1,NULL,Fnd_Global.PROG_APPL_ID),
            x_bchv_rec.program_application_id),
        NVL(DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),
            x_bchv_rec.program_id),
        DECODE(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE),
            NULL,x_bchv_rec.program_update_date,SYSDATE)
      INTO
        x_bchv_rec.request_id,
        x_bchv_rec.program_application_id,
        x_bchv_rec.program_id,
        x_bchv_rec.program_update_date
      FROM   dual;

Line: 3349


    update_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_okl_billing_charges_tl_rec,
      lx_okl_billing_charges_tl_rec
    );

Line: 3363


    update_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_bch_rec,
      lx_bch_rec
    );

Line: 3410


  END update_row;

Line: 3414


  PROCEDURE update_row(
    p_api_version                  IN NUMBER,
    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_bchv_tbl                     IN bchv_tbl_type,
    x_bchv_tbl                     OUT NOCOPY bchv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 3424


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

Line: 3438


        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_bchv_rec                     => p_bchv_tbl(i),
          x_bchv_rec                     => x_bchv_tbl(i));

Line: 3493


  END update_row;

Line: 3501


  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_bch_rec                      IN bch_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 3509


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

Line: 3523


    DELETE FROM OKL_BILLING_CHARGES_B
     WHERE ID = l_bch_rec.id;

Line: 3558


  END delete_row;

Line: 3562


  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_okl_billing_charges_tl_rec   IN OklBillingChargesTlRecType) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 3570


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

Line: 3607


    DELETE FROM OKL_BILLING_CHARGES_TL
     WHERE ID = l_okl_billing_charges_tl_rec.id;

Line: 3642


  END delete_row;

Line: 3646


  PROCEDURE delete_row(
    p_api_version                  IN NUMBER,
    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_bchv_rec                     IN bchv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 3655


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

Line: 3681


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

Line: 3693


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

Line: 3737


  END delete_row;

Line: 3741


  PROCEDURE delete_row(
    p_api_version                  IN NUMBER,
    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_bchv_tbl                     IN bchv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 3750


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

Line: 3764


        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_bchv_rec                     => p_bchv_tbl(i));

Line: 3818


  END delete_row;