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

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

Line: 198


      SELECT 'x'
      FROM OKL_EXT_PAY_INVS_V
      WHERE id = p_xlpv_rec.xpi_id_details;

Line: 283


      SELECT 'x'
      FROM OKL_TXL_AP_INV_LNS_V
      WHERE id = p_xlpv_rec.tpl_id;

Line: 376


      SELECT 'x'
      FROM OKL_TRX_AP_INVOICES_V
      WHERE id = p_xlpv_rec.tap_id;

Line: 470


      SELECT 'x'
      FROM OKX_PYE_INV_DSTBTNS_V
      WHERE id = p_xlpv_rec.pid_id;

Line: 563


      SELECT 'x'
      FROM OKX_B_ORD_LN_DSTS_V
      WHERE id = p_xlpv_rec.ibi_id;

Line: 681


    DELETE FROM OKL_XTL_PAY_INVS_TL T
     WHERE NOT EXISTS (
        SELECT NULL
          FROM OKL_XTL_PAY_INVS_ALL_B B
         WHERE B.ID = T.ID
         AND T.LANGUAGE = USERENV('LANG')
        );

Line: 689


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

Line: 714


    INSERT INTO OKL_XTL_PAY_INVS_TL (
        ID,
        LANGUAGE,
        SOURCE_LANG,
        SFWT_FLAG,
        DESCRIPTION,
        STREAM_TYPE,
        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.DESCRIPTION,
            B.STREAM_TYPE,
            B.CREATED_BY,
            B.CREATION_DATE,
            B.LAST_UPDATED_BY,
            B.LAST_UPDATE_DATE,
            B.LAST_UPDATE_LOGIN
        FROM OKL_XTL_PAY_INVS_TL B, FND_LANGUAGES L
       WHERE L.INSTALLED_FLAG IN ('I', 'B')
         AND B.LANGUAGE = USERENV('LANG')
         AND NOT EXISTS(
                    SELECT NULL
                      FROM OKL_XTL_PAY_INVS_TL T
                     WHERE T.ID = B.ID
                       AND T.LANGUAGE = L.LANGUAGE_CODE
                    );

Line: 758


    SELECT
            ID,
            XPI_ID_DETAILS,
            PID_ID,
            IBI_ID,
            TPL_ID,
            TAP_ID,
            OBJECT_VERSION_NUMBER,
            INVOICE_LINE_ID,
            LINE_NUMBER,
            LINE_TYPE,
            AMOUNT,
            ACCOUNTING_DATE,
            DIST_CODE_COMBINATION_ID,
            TAX_CODE,
            REQUEST_ID,
            PROGRAM_APPLICATION_ID,
            PROGRAM_ID,
            PROGRAM_UPDATE_DATE,
            ORG_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
      FROM Okl_Xtl_Pay_Invs_B
     WHERE okl_xtl_pay_invs_b.id = p_id;

Line: 825


              l_xlp_rec.PROGRAM_UPDATE_DATE,
              l_xlp_rec.ORG_ID,
              l_xlp_rec.ATTRIBUTE_CATEGORY,
              l_xlp_rec.ATTRIBUTE1,
              l_xlp_rec.ATTRIBUTE2,
              l_xlp_rec.ATTRIBUTE3,
              l_xlp_rec.ATTRIBUTE4,
              l_xlp_rec.ATTRIBUTE5,
              l_xlp_rec.ATTRIBUTE6,
              l_xlp_rec.ATTRIBUTE7,
              l_xlp_rec.ATTRIBUTE8,
              l_xlp_rec.ATTRIBUTE9,
              l_xlp_rec.ATTRIBUTE10,
              l_xlp_rec.ATTRIBUTE11,
              l_xlp_rec.ATTRIBUTE12,
              l_xlp_rec.ATTRIBUTE13,
              l_xlp_rec.ATTRIBUTE14,
              l_xlp_rec.ATTRIBUTE15,
              l_xlp_rec.CREATED_BY,
              l_xlp_rec.CREATION_DATE,
              l_xlp_rec.LAST_UPDATED_BY,
              l_xlp_rec.LAST_UPDATE_DATE,
              l_xlp_rec.LAST_UPDATE_LOGIN;

Line: 869


    SELECT
            ID,
            LANGUAGE,
            SOURCE_LANG,
            SFWT_FLAG,
            DESCRIPTION,
            STREAM_TYPE,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN
      FROM Okl_Xtl_Pay_Invs_Tl
     WHERE okl_xtl_pay_invs_tl.id = p_id
       AND okl_xtl_pay_invs_tl.language = p_language;

Line: 900


              l_okl_xtl_pay_invs_tl_rec.LAST_UPDATED_BY,
              l_okl_xtl_pay_invs_tl_rec.LAST_UPDATE_DATE,
              l_okl_xtl_pay_invs_tl_rec.LAST_UPDATE_LOGIN;

Line: 923


    SELECT
            ID,
            OBJECT_VERSION_NUMBER,
            SFWT_FLAG,
            TPL_ID,
            TAP_ID,
            PID_ID,
            IBI_ID,
            XPI_ID_DETAILS,
            INVOICE_LINE_ID,
            LINE_NUMBER,
            LINE_TYPE,
            AMOUNT,
            ACCOUNTING_DATE,
            DESCRIPTION,
            DIST_CODE_COMBINATION_ID,
            TAX_CODE,
            STREAM_TYPE,
            ATTRIBUTE_CATEGORY,
            ATTRIBUTE1,
            ATTRIBUTE2,
            ATTRIBUTE3,
            ATTRIBUTE4,
            ATTRIBUTE5,
            ATTRIBUTE6,
            ATTRIBUTE7,
            ATTRIBUTE8,
            ATTRIBUTE9,
            ATTRIBUTE10,
            ATTRIBUTE11,
            ATTRIBUTE12,
            ATTRIBUTE13,
            ATTRIBUTE14,
            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_Xtl_Pay_Invs_V
     WHERE okl_xtl_pay_invs_v.id = p_id;

Line: 1012


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

Line: 1145


    IF (l_xlpv_rec.program_update_date = OKL_API.G_MISS_DATE) THEN
      l_xlpv_rec.program_update_date := NULL;

Line: 1157


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

Line: 1160


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

Line: 1163


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

Line: 1351


    p_to.program_update_date := p_from.program_update_date;

Line: 1371


    p_to.last_updated_by := p_from.last_updated_by;

Line: 1372


    p_to.last_update_date := p_from.last_update_date;

Line: 1373


    p_to.last_update_login := p_from.last_update_login;

Line: 1397


    p_to.program_update_date := p_from.program_update_date;

Line: 1417


    p_to.last_updated_by := p_from.last_updated_by;

Line: 1418


    p_to.last_update_date := p_from.last_update_date;

Line: 1419


    p_to.last_update_login := p_from.last_update_login;

Line: 1432


    p_to.last_updated_by := p_from.last_updated_by;

Line: 1433


    p_to.last_update_date := p_from.last_update_date;

Line: 1434


    p_to.last_update_login := p_from.last_update_login;

Line: 1447


    p_to.last_updated_by := p_from.last_updated_by;

Line: 1448


    p_to.last_update_date := p_from.last_update_date;

Line: 1449


    p_to.last_update_login := p_from.last_update_login;

Line: 1615


  PROCEDURE insert_row(
    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_xlp_rec                      IN xlp_rec_type,
    x_xlp_rec                      OUT NOCOPY xlp_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1624


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

Line: 1660


    INSERT INTO OKL_XTL_PAY_INVS_B(
        id,
        xpi_id_details,
        pid_id,
        ibi_id,
        tpl_id,
        tap_id,
        object_version_number,
        invoice_line_id,
        line_number,
        line_type,
        amount,
        accounting_date,
        dist_code_combination_id,
        tax_code,
        request_id,
        program_application_id,
        program_id,
        program_update_date,
        org_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)
      VALUES (
        l_xlp_rec.id,
        l_xlp_rec.xpi_id_details,
        l_xlp_rec.pid_id,
        l_xlp_rec.ibi_id,
        l_xlp_rec.tpl_id,
        l_xlp_rec.tap_id,
        l_xlp_rec.object_version_number,
        l_xlp_rec.invoice_line_id,
        l_xlp_rec.line_number,
        l_xlp_rec.line_type,
        l_xlp_rec.amount,
        l_xlp_rec.accounting_date,
        l_xlp_rec.dist_code_combination_id,
        l_xlp_rec.tax_code,
        l_xlp_rec.request_id,
        l_xlp_rec.program_application_id,
        l_xlp_rec.program_id,
        l_xlp_rec.program_update_date,
        l_xlp_rec.org_id,
        l_xlp_rec.attribute_category,
        l_xlp_rec.attribute1,
        l_xlp_rec.attribute2,
        l_xlp_rec.attribute3,
        l_xlp_rec.attribute4,
        l_xlp_rec.attribute5,
        l_xlp_rec.attribute6,
        l_xlp_rec.attribute7,
        l_xlp_rec.attribute8,
        l_xlp_rec.attribute9,
        l_xlp_rec.attribute10,
        l_xlp_rec.attribute11,
        l_xlp_rec.attribute12,
        l_xlp_rec.attribute13,
        l_xlp_rec.attribute14,
        l_xlp_rec.attribute15,
        l_xlp_rec.created_by,
        l_xlp_rec.creation_date,
        l_xlp_rec.last_updated_by,
        l_xlp_rec.last_update_date,
        l_xlp_rec.last_update_login);

Line: 1776


  END insert_row;

Line: 1780


  PROCEDURE insert_row(
    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_okl_xtl_pay_invs_tl_rec      IN okl_xtl_pay_invs_tl_rec_type,
    x_okl_xtl_pay_invs_tl_rec      OUT NOCOPY okl_xtl_pay_invs_tl_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1789


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

Line: 1794


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

Line: 1833


      INSERT INTO OKL_XTL_PAY_INVS_TL(
          id,
          language,
          source_lang,
          sfwt_flag,
          description,
          stream_type,
          created_by,
          creation_date,
          last_updated_by,
          last_update_date,
          last_update_login)
        VALUES (
          l_okl_xtl_pay_invs_tl_rec.id,
          l_okl_xtl_pay_invs_tl_rec.language,
          l_okl_xtl_pay_invs_tl_rec.source_lang,
          l_okl_xtl_pay_invs_tl_rec.sfwt_flag,
          l_okl_xtl_pay_invs_tl_rec.description,
          l_okl_xtl_pay_invs_tl_rec.stream_type,
          l_okl_xtl_pay_invs_tl_rec.created_by,
          l_okl_xtl_pay_invs_tl_rec.creation_date,
          l_okl_xtl_pay_invs_tl_rec.last_updated_by,
          l_okl_xtl_pay_invs_tl_rec.last_update_date,
          l_okl_xtl_pay_invs_tl_rec.last_update_login);

Line: 1892


  END insert_row;

Line: 1896


  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_xlpv_rec                     IN xlpv_rec_type,
    x_xlpv_rec                     OUT NOCOPY xlpv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1906


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

Line: 1924


      l_xlpv_rec.LAST_UPDATE_DATE := l_xlpv_rec.CREATION_DATE;     -- PostGen-10

Line: 1925


      l_xlpv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 1926


      l_xlpv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 1942


      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_xlpv_rec.request_id,
        x_xlpv_rec.program_application_id,
        x_xlpv_rec.program_id,
        x_xlpv_rec.program_update_date
      FROM   dual;

Line: 2006


    insert_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_xlp_rec,
      lx_xlp_rec
    );

Line: 2020


    insert_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_okl_xtl_pay_invs_tl_rec,
      lx_okl_xtl_pay_invs_tl_rec
    );

Line: 2068


  END insert_row;

Line: 2072


  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_xlpv_tbl                     IN xlpv_tbl_type,
    x_xlpv_tbl                     OUT NOCOPY xlpv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2082


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

Line: 2092


        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_xlpv_rec                     => p_xlpv_tbl(i),
          x_xlpv_rec                     => x_xlpv_tbl(i));

Line: 2146


  END insert_row;

Line: 2164


    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_XTL_PAY_INVS_B
     WHERE ID = p_xlp_rec.id
       AND OBJECT_VERSION_NUMBER = p_xlp_rec.object_version_number
    FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;

Line: 2171


    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_XTL_PAY_INVS_B
    WHERE ID = p_xlp_rec.id;

Line: 2212


      OKL_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);

Line: 2221


      OKL_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);

Line: 2270


    SELECT *
      FROM OKL_XTL_PAY_INVS_TL
     WHERE ID = p_okl_xtl_pay_invs_tl_rec.id
    FOR UPDATE NOWAIT;

Line: 2306


      OKL_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);

Line: 2519


  PROCEDURE update_row(
    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_xlp_rec                      IN xlp_rec_type,
    x_xlp_rec                      OUT NOCOPY xlp_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2528


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

Line: 2618


      IF (x_xlp_rec.program_update_date = OKL_API.G_MISS_DATE)
      THEN
        x_xlp_rec.program_update_date := l_xlp_rec.program_update_date;

Line: 2698


      IF (x_xlp_rec.last_updated_by = OKL_API.G_MISS_NUM)
      THEN
        x_xlp_rec.last_updated_by := l_xlp_rec.last_updated_by;

Line: 2702


      IF (x_xlp_rec.last_update_date = OKL_API.G_MISS_DATE)
      THEN
        x_xlp_rec.last_update_date := l_xlp_rec.last_update_date;

Line: 2706


      IF (x_xlp_rec.last_update_login = OKL_API.G_MISS_NUM)
      THEN
        x_xlp_rec.last_update_login := l_xlp_rec.last_update_login;

Line: 2750


    UPDATE  OKL_XTL_PAY_INVS_B
    SET XPI_ID_DETAILS = l_def_xlp_rec.xpi_id_details,
        PID_ID = l_def_xlp_rec.pid_id,
        IBI_ID = l_def_xlp_rec.ibi_id,
        TPL_ID = l_def_xlp_rec.tpl_id,
        TAP_ID = l_def_xlp_rec.tap_id,
        OBJECT_VERSION_NUMBER = l_def_xlp_rec.object_version_number,
        INVOICE_LINE_ID = l_def_xlp_rec.invoice_line_id,
        LINE_NUMBER = l_def_xlp_rec.line_number,
        LINE_TYPE = l_def_xlp_rec.line_type,
        AMOUNT = l_def_xlp_rec.amount,
        ACCOUNTING_DATE = l_def_xlp_rec.accounting_date,
        DIST_CODE_COMBINATION_ID = l_def_xlp_rec.dist_code_combination_id,
        TAX_CODE = l_def_xlp_rec.tax_code,
        REQUEST_ID = l_def_xlp_rec.request_id,
        PROGRAM_APPLICATION_ID = l_def_xlp_rec.program_application_id,
        PROGRAM_ID = l_def_xlp_rec.program_id,
        PROGRAM_UPDATE_DATE = l_def_xlp_rec.program_update_date,
        ORG_ID = l_def_xlp_rec.org_id,
        ATTRIBUTE_CATEGORY = l_def_xlp_rec.attribute_category,
        ATTRIBUTE1 = l_def_xlp_rec.attribute1,
        ATTRIBUTE2 = l_def_xlp_rec.attribute2,
        ATTRIBUTE3 = l_def_xlp_rec.attribute3,
        ATTRIBUTE4 = l_def_xlp_rec.attribute4,
        ATTRIBUTE5 = l_def_xlp_rec.attribute5,
        ATTRIBUTE6 = l_def_xlp_rec.attribute6,
        ATTRIBUTE7 = l_def_xlp_rec.attribute7,
        ATTRIBUTE8 = l_def_xlp_rec.attribute8,
        ATTRIBUTE9 = l_def_xlp_rec.attribute9,
        ATTRIBUTE10 = l_def_xlp_rec.attribute10,
        ATTRIBUTE11 = l_def_xlp_rec.attribute11,
        ATTRIBUTE12 = l_def_xlp_rec.attribute12,
        ATTRIBUTE13 = l_def_xlp_rec.attribute13,
        ATTRIBUTE14 = l_def_xlp_rec.attribute14,
        ATTRIBUTE15 = l_def_xlp_rec.attribute15,
        CREATED_BY = l_def_xlp_rec.created_by,
        CREATION_DATE = l_def_xlp_rec.creation_date,
        LAST_UPDATED_BY = l_def_xlp_rec.last_updated_by,
        LAST_UPDATE_DATE = l_def_xlp_rec.last_update_date,
        LAST_UPDATE_LOGIN = l_def_xlp_rec.last_update_login
    WHERE ID = l_def_xlp_rec.id;

Line: 2825


  END update_row;

Line: 2829


  PROCEDURE update_row(
    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_okl_xtl_pay_invs_tl_rec      IN okl_xtl_pay_invs_tl_rec_type,
    x_okl_xtl_pay_invs_tl_rec      OUT NOCOPY okl_xtl_pay_invs_tl_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2838


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

Line: 2892


      IF (x_okl_xtl_pay_invs_tl_rec.last_updated_by = OKL_API.G_MISS_NUM)
      THEN
        x_okl_xtl_pay_invs_tl_rec.last_updated_by := l_okl_xtl_pay_invs_tl_rec.last_updated_by;

Line: 2896


      IF (x_okl_xtl_pay_invs_tl_rec.last_update_date = OKL_API.G_MISS_DATE)
      THEN
        x_okl_xtl_pay_invs_tl_rec.last_update_date := l_okl_xtl_pay_invs_tl_rec.last_update_date;

Line: 2900


      IF (x_okl_xtl_pay_invs_tl_rec.last_update_login = OKL_API.G_MISS_NUM)
      THEN
        x_okl_xtl_pay_invs_tl_rec.last_update_login := l_okl_xtl_pay_invs_tl_rec.last_update_login;

Line: 2946


    UPDATE  OKL_XTL_PAY_INVS_TL
    SET DESCRIPTION = ldefoklxtlpayinvstlrec.description,
        STREAM_TYPE = ldefoklxtlpayinvstlrec.stream_type,
        SOURCE_LANG = ldefoklxtlpayinvstlrec.source_lang,
        CREATED_BY = ldefoklxtlpayinvstlrec.created_by,
        CREATION_DATE = ldefoklxtlpayinvstlrec.creation_date,
        LAST_UPDATED_BY = ldefoklxtlpayinvstlrec.last_updated_by,
        LAST_UPDATE_DATE = ldefoklxtlpayinvstlrec.last_update_date,
        LAST_UPDATE_LOGIN = ldefoklxtlpayinvstlrec.last_update_login
    WHERE ID = ldefoklxtlpayinvstlrec.id
    AND USERENV('LANG') in (SOURCE_LANG, LANGUAGE);

Line: 2958


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

Line: 2996


  END update_row;

Line: 3000


  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_xlpv_rec                     IN xlpv_rec_type,
    x_xlpv_rec                     OUT NOCOPY xlpv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 3010


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

Line: 3026


      l_xlpv_rec.LAST_UPDATE_DATE := SYSDATE;

Line: 3027


      l_xlpv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 3028


      l_xlpv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 3192


      IF (x_xlpv_rec.program_update_date = OKL_API.G_MISS_DATE)
      THEN
        x_xlpv_rec.program_update_date := l_xlpv_rec.program_update_date;

Line: 3208


      IF (x_xlpv_rec.last_updated_by = OKL_API.G_MISS_NUM)
      THEN
        x_xlpv_rec.last_updated_by := l_xlpv_rec.last_updated_by;

Line: 3212


      IF (x_xlpv_rec.last_update_date = OKL_API.G_MISS_DATE)
      THEN
        x_xlpv_rec.last_update_date := l_xlpv_rec.last_update_date;

Line: 3216


      IF (x_xlpv_rec.last_update_login = OKL_API.G_MISS_NUM)
      THEN
        x_xlpv_rec.last_update_login := l_xlpv_rec.last_update_login;

Line: 3235


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

Line: 3307


    update_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_okl_xtl_pay_invs_tl_rec,
      lx_okl_xtl_pay_invs_tl_rec
    );

Line: 3321


    update_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_xlp_rec,
      lx_xlp_rec
    );

Line: 3368


  END update_row;

Line: 3372


  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_xlpv_tbl                     IN xlpv_tbl_type,
    x_xlpv_tbl                     OUT NOCOPY xlpv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 3382


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

Line: 3392


        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_xlpv_rec                     => p_xlpv_tbl(i),
          x_xlpv_rec                     => x_xlpv_tbl(i));

Line: 3446


  END update_row;

Line: 3454


  PROCEDURE delete_row(
    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_xlp_rec                      IN xlp_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 3462


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

Line: 3476


    DELETE FROM OKL_XTL_PAY_INVS_B
     WHERE ID = l_xlp_rec.id;

Line: 3511


  END delete_row;

Line: 3515


  PROCEDURE delete_row(
    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_okl_xtl_pay_invs_tl_rec      IN okl_xtl_pay_invs_tl_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 3523


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

Line: 3560


    DELETE FROM OKL_XTL_PAY_INVS_TL
     WHERE ID = l_okl_xtl_pay_invs_tl_rec.id;

Line: 3595


  END delete_row;

Line: 3599


  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_xlpv_rec                     IN xlpv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 3608


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

Line: 3634


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

Line: 3646


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

Line: 3690


  END delete_row;

Line: 3694


  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_xlpv_tbl                     IN xlpv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 3703


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

Line: 3713


        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_xlpv_rec                     => p_xlpv_tbl(i));

Line: 3766


  END delete_row;