DBA Data[Home] [Help]

APPS.OKL_XCA_PVT SQL Statements

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

Line: 40

    DELETE FROM OKL_XTL_CSH_APPS_TL T
     WHERE NOT EXISTS (
        SELECT NULL
          FROM OKL_XTL_CSH_APPS_ALL_B B    --fixed bug 3321017 by kmotepal
         WHERE B.ID = T.ID
        );
Line: 50

        IN (SELECT
                SUBT.ID,
                SUBT.LANGUAGE
              FROM OKL_XTL_CSH_APPS_TL SUBB, OKL_XTL_CSH_APPS_TL SUBT
             WHERE SUBB.ID = SUBT.ID
               AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
*/
	 -- TAPI code generated code that doesn't compile.  Reason - no columns defined
	 -- in translation table.

  INSERT INTO OKL_XTL_CSH_APPS_TL (
      ID,
      LANGUAGE,
      SOURCE_LANG,
      SFWT_FLAG,
      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.CREATED_BY,
          B.CREATION_DATE,
          B.LAST_UPDATED_BY,
          B.LAST_UPDATE_DATE,
          B.LAST_UPDATE_LOGIN
      FROM OKL_XTL_CSH_APPS_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_CSH_APPS_TL T
                   WHERE T.ID = B.ID
                     AND T.LANGUAGE = L.LANGUAGE_CODE
                  );
Line: 100

  SELECT
          ID,
          XCR_ID_DETAILS,
          IRP_ID,
          LSM_ID,
          RCA_ID,
          CAT_ID,
          OBJECT_VERSION_NUMBER,
          INVOICE_NUMBER,
          AMOUNT_APPLIED,
          INVOICE_INSTALLMENT,
          AMOUNT_APPLIED_FROM,
          INVOICE_CURRENCY_CODE,
          TRANS_TO_RECEIPT_RATE,
          TRX_DATE,
          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_Csh_Apps_B
   WHERE okl_xtl_csh_apps_b.id = p_id;
Line: 167

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

  SELECT
          ID,
          LANGUAGE,
          SOURCE_LANG,
          SFWT_FLAG,
          CREATED_BY,
          CREATION_DATE,
          LAST_UPDATED_BY,
          LAST_UPDATE_DATE,
          LAST_UPDATE_LOGIN
    FROM Okl_Xtl_Csh_Apps_Tl
   WHERE okl_xtl_csh_apps_tl.id = p_id
     AND okl_xtl_csh_apps_tl.LANGUAGE = p_language;
Line: 238

            l_okl_xtl_csh_apps_tl_rec.LAST_UPDATED_BY,
            l_okl_xtl_csh_apps_tl_rec.LAST_UPDATE_DATE,
            l_okl_xtl_csh_apps_tl_rec.LAST_UPDATE_LOGIN;
Line: 261

  SELECT
          ID,
          OBJECT_VERSION_NUMBER,
          SFWT_FLAG,
          LSM_ID,
          RCA_ID,
          CAT_ID,
          IRP_ID,
          XCR_ID_DETAILS,
          INVOICE_NUMBER,
          AMOUNT_APPLIED,
          INVOICE_INSTALLMENT,
          AMOUNT_APPLIED_FROM,
          INVOICE_CURRENCY_CODE,
          TRANS_TO_RECEIPT_RATE,
          TRX_DATE,
          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_Csh_Apps_V
   WHERE okl_xtl_csh_apps_v.id = p_id;
Line: 346

            l_xcav_rec.PROGRAM_UPDATE_DATE,
            l_xcav_rec.ORG_ID,
            l_xcav_rec.CREATED_BY,
            l_xcav_rec.CREATION_DATE,
            l_xcav_rec.LAST_UPDATED_BY,
            l_xcav_rec.LAST_UPDATE_DATE,
            l_xcav_rec.LAST_UPDATE_LOGIN;
Line: 473

  IF (l_xcav_rec.program_update_date = Okl_Api.G_MISS_DATE) THEN
    l_xcav_rec.program_update_date := NULL;
Line: 485

  IF (l_xcav_rec.last_updated_by = Okl_Api.G_MISS_NUM) THEN
    l_xcav_rec.last_updated_by := NULL;
Line: 488

  IF (l_xcav_rec.last_update_date = Okl_Api.G_MISS_DATE) THEN
    l_xcav_rec.last_update_date := NULL;
Line: 491

  IF (l_xcav_rec.last_update_login = Okl_Api.G_MISS_NUM) THEN
    l_xcav_rec.last_update_login := NULL;
Line: 575

   SELECT '1'
   FROM   okl_cnsld_ar_strms_b
   WHERE  id = p_xcav_rec.lsm_id;
Line: 639

   SELECT '1'
   FROM   okl_txl_rcpt_apps_b
   WHERE  id = p_xcav_rec.rca_id;
Line: 703

   SELECT '1'
   FROM   okl_ext_csh_rcpts_b
   WHERE  id = p_xcav_rec.xcr_id_details;
Line: 892

  p_to.program_update_date := p_from.program_update_date;
Line: 912

  p_to.last_updated_by := p_from.last_updated_by;
Line: 913

  p_to.last_update_date := p_from.last_update_date;
Line: 914

  p_to.last_update_login := p_from.last_update_login;
Line: 938

  p_to.program_update_date := p_from.program_update_date;
Line: 958

  p_to.last_updated_by := p_from.last_updated_by;
Line: 959

  p_to.last_update_date := p_from.last_update_date;
Line: 960

  p_to.last_update_login := p_from.last_update_login;
Line: 971

  p_to.last_updated_by := p_from.last_updated_by;
Line: 972

  p_to.last_update_date := p_from.last_update_date;
Line: 973

  p_to.last_update_login := p_from.last_update_login;
Line: 984

  p_to.last_updated_by := p_from.last_updated_by;
Line: 985

  p_to.last_update_date := p_from.last_update_date;
Line: 986

  p_to.last_update_login := p_from.last_update_login;
Line: 1160

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_xca_rec                      IN xca_rec_type,
  x_xca_rec                      OUT NOCOPY xca_rec_type) IS

  l_api_version                 CONSTANT NUMBER := 1;
Line: 1169

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

  INSERT INTO OKL_XTL_CSH_APPS_B(
      id,
      xcr_id_details,
      irp_id,
      lsm_id,
      rca_id,
      cat_id,
      object_version_number,
      invoice_number,
      amount_applied,
      invoice_installment,
      amount_applied_from,
      invoice_currency_code,
      trans_to_receipt_rate,
      trx_date,
      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_xca_rec.id,
      l_xca_rec.xcr_id_details,
      l_xca_rec.irp_id,
      l_xca_rec.lsm_id,
      l_xca_rec.rca_id,
      l_xca_rec.cat_id,
      l_xca_rec.object_version_number,
      l_xca_rec.invoice_number,
      l_xca_rec.amount_applied,
      l_xca_rec.invoice_installment,
      l_xca_rec.amount_applied_from,
      l_xca_rec.invoice_currency_code,
      l_xca_rec.TRANS_TO_RECEIPT_RATE,
      l_xca_rec.TRX_DATE,
      l_xca_rec.request_id,
      l_xca_rec.program_application_id,
      l_xca_rec.program_id,
      l_xca_rec.program_update_date,
      l_xca_rec.org_id,
      l_xca_rec.attribute_category,
      l_xca_rec.attribute1,
      l_xca_rec.attribute2,
      l_xca_rec.attribute3,
      l_xca_rec.attribute4,
      l_xca_rec.attribute5,
      l_xca_rec.attribute6,
      l_xca_rec.attribute7,
      l_xca_rec.attribute8,
      l_xca_rec.attribute9,
      l_xca_rec.attribute10,
      l_xca_rec.attribute11,
      l_xca_rec.attribute12,
      l_xca_rec.attribute13,
      l_xca_rec.attribute14,
      l_xca_rec.attribute15,
      l_xca_rec.created_by,
      l_xca_rec.creation_date,
      l_xca_rec.last_updated_by,
      l_xca_rec.last_update_date,
      l_xca_rec.last_update_login);
Line: 1321

END insert_row;
Line: 1325

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_csh_apps_tl_rec      IN okl_xtl_csh_apps_tl_rec_type,
  x_okl_xtl_csh_apps_tl_rec      OUT NOCOPY okl_xtl_csh_apps_tl_rec_type) IS

  l_api_version                 CONSTANT NUMBER := 1;
Line: 1334

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

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

    INSERT INTO OKL_XTL_CSH_APPS_TL(
        id,
        LANGUAGE,
        source_lang,
        sfwt_flag,
        created_by,
        creation_date,
        last_updated_by,
        last_update_date,
        last_update_login)
      VALUES (
        l_okl_xtl_csh_apps_tl_rec.id,
        l_okl_xtl_csh_apps_tl_rec.LANGUAGE,
        l_okl_xtl_csh_apps_tl_rec.source_lang,
        l_okl_xtl_csh_apps_tl_rec.sfwt_flag,
        l_okl_xtl_csh_apps_tl_rec.created_by,
        l_okl_xtl_csh_apps_tl_rec.creation_date,
        l_okl_xtl_csh_apps_tl_rec.last_updated_by,
        l_okl_xtl_csh_apps_tl_rec.last_update_date,
        l_okl_xtl_csh_apps_tl_rec.last_update_login);
Line: 1433

END insert_row;
Line: 1437

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_xcav_rec                     IN xcav_rec_type,
  x_xcav_rec                     OUT NOCOPY xcav_rec_type) IS

  l_api_version                 CONSTANT NUMBER := 1;
Line: 1447

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

    l_xcav_rec.LAST_UPDATE_DATE := l_xcav_rec.CREATION_DATE;
Line: 1466

    l_xcav_rec.LAST_UPDATED_BY := Fnd_Global.USER_ID;
Line: 1467

    l_xcav_rec.LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
Line: 1487

	     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_xcav_rec.request_id,
                x_xcav_rec.program_application_id,
                x_xcav_rec.program_id,
                x_xcav_rec.program_update_date
   		 FROM dual;
Line: 1555

  insert_row(
    p_init_msg_list,
    x_return_status,
    x_msg_count,
    x_msg_data,
    l_xca_rec,
    lx_xca_rec
  );
Line: 1569

  insert_row(
    p_init_msg_list,
    x_return_status,
    x_msg_count,
    x_msg_data,
    l_okl_xtl_csh_apps_tl_rec,
    lx_okl_xtl_csh_apps_tl_rec
  );
Line: 1617

END insert_row;
Line: 1621

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_xcav_tbl                     IN xcav_tbl_type,
  x_xcav_tbl                     OUT NOCOPY xcav_tbl_type) IS

  l_api_version                 CONSTANT NUMBER := 1;
Line: 1631

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

      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_xcav_rec                     => p_xcav_tbl(i),
        x_xcav_rec                     => x_xcav_tbl(i));
Line: 1703

END insert_row;
Line: 1721

  SELECT OBJECT_VERSION_NUMBER
    FROM OKL_XTL_CSH_APPS_B
   WHERE ID = p_xca_rec.id
     AND OBJECT_VERSION_NUMBER = p_xca_rec.object_version_number
  FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
Line: 1728

  SELECT OBJECT_VERSION_NUMBER
    FROM OKL_XTL_CSH_APPS_B
  WHERE ID = p_xca_rec.id;
Line: 1769

    Okl_Api.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
Line: 1778

    Okl_Api.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
Line: 1827

  SELECT *
    FROM OKL_XTL_CSH_APPS_TL
   WHERE ID = p_okl_xtl_csh_apps_tl_rec.id
  FOR UPDATE NOWAIT;
Line: 1863

    Okl_Api.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
Line: 2085

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_xca_rec                      IN xca_rec_type,
  x_xca_rec                      OUT NOCOPY xca_rec_type) IS

  l_api_version                 CONSTANT NUMBER := 1;
Line: 2094

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

    IF (x_xca_rec.program_update_date = Okl_Api.G_MISS_DATE)
    THEN
      x_xca_rec.program_update_date := l_xca_rec.program_update_date;
Line: 2264

    IF (x_xca_rec.last_updated_by = Okl_Api.G_MISS_NUM)
    THEN
      x_xca_rec.last_updated_by := l_xca_rec.last_updated_by;
Line: 2268

    IF (x_xca_rec.last_update_date = Okl_Api.G_MISS_DATE)
    THEN
      x_xca_rec.last_update_date := l_xca_rec.last_update_date;
Line: 2272

    IF (x_xca_rec.last_update_login = Okl_Api.G_MISS_NUM)
    THEN
      x_xca_rec.last_update_login := l_xca_rec.last_update_login;
Line: 2316

  UPDATE  OKL_XTL_CSH_APPS_B
  SET XCR_ID_DETAILS = l_def_xca_rec.xcr_id_details,
      IRP_ID = l_def_xca_rec.irp_id,
      LSM_ID = l_def_xca_rec.lsm_id,
      RCA_ID = l_def_xca_rec.rca_id,
      CAT_ID = l_def_xca_rec.cat_id,
      OBJECT_VERSION_NUMBER = l_def_xca_rec.object_version_number,
      INVOICE_NUMBER = l_def_xca_rec.invoice_number,
      AMOUNT_APPLIED = l_def_xca_rec.amount_applied,
      INVOICE_INSTALLMENT = l_def_xca_rec.invoice_installment,
      AMOUNT_APPLIED_FROM = l_def_xca_rec.amount_applied_from,
      INVOICE_CURRENCY_CODE = l_def_xca_rec.invoice_currency_code,
      TRANS_TO_RECEIPT_RATE = l_def_xca_rec.TRANS_TO_RECEIPT_RATE,
      TRX_DATE = l_def_xca_rec.TRX_DATE,
      REQUEST_ID = l_def_xca_rec.request_id,
      PROGRAM_APPLICATION_ID = l_def_xca_rec.program_application_id,
      PROGRAM_ID = l_def_xca_rec.program_id,
      PROGRAM_UPDATE_DATE = l_def_xca_rec.program_update_date,
      ORG_ID = l_def_xca_rec.org_id,
      ATTRIBUTE_CATEGORY = l_def_xca_rec.attribute_category,
      ATTRIBUTE1 = l_def_xca_rec.attribute1,
      ATTRIBUTE2 = l_def_xca_rec.attribute2,
      ATTRIBUTE3 = l_def_xca_rec.attribute3,
      ATTRIBUTE4 = l_def_xca_rec.attribute4,
      ATTRIBUTE5 = l_def_xca_rec.attribute5,
      ATTRIBUTE6 = l_def_xca_rec.attribute6,
      ATTRIBUTE7 = l_def_xca_rec.attribute7,
      ATTRIBUTE8 = l_def_xca_rec.attribute8,
      ATTRIBUTE9 = l_def_xca_rec.attribute9,
      ATTRIBUTE10 = l_def_xca_rec.attribute10,
      ATTRIBUTE11 = l_def_xca_rec.attribute11,
      ATTRIBUTE12 = l_def_xca_rec.attribute12,
      ATTRIBUTE13 = l_def_xca_rec.attribute13,
      ATTRIBUTE14 = l_def_xca_rec.attribute14,
      ATTRIBUTE15 = l_def_xca_rec.attribute15,
      CREATED_BY = l_def_xca_rec.created_by,
      CREATION_DATE = l_def_xca_rec.creation_date,
      LAST_UPDATED_BY = l_def_xca_rec.last_updated_by,
      LAST_UPDATE_DATE = l_def_xca_rec.last_update_date,
      LAST_UPDATE_LOGIN = l_def_xca_rec.last_update_login
  WHERE ID = l_def_xca_rec.id;
Line: 2391

END update_row;
Line: 2395

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_csh_apps_tl_rec      IN okl_xtl_csh_apps_tl_rec_type,
  x_okl_xtl_csh_apps_tl_rec      OUT NOCOPY okl_xtl_csh_apps_tl_rec_type) IS

  l_api_version                 CONSTANT NUMBER := 1;
Line: 2404

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

    IF (x_okl_xtl_csh_apps_tl_rec.last_updated_by = Okl_Api.G_MISS_NUM)
    THEN
      x_okl_xtl_csh_apps_tl_rec.last_updated_by := l_okl_xtl_csh_apps_tl_rec.last_updated_by;
Line: 2454

    IF (x_okl_xtl_csh_apps_tl_rec.last_update_date = Okl_Api.G_MISS_DATE)
    THEN
      x_okl_xtl_csh_apps_tl_rec.last_update_date := l_okl_xtl_csh_apps_tl_rec.last_update_date;
Line: 2458

    IF (x_okl_xtl_csh_apps_tl_rec.last_update_login = Okl_Api.G_MISS_NUM)
    THEN
      x_okl_xtl_csh_apps_tl_rec.last_update_login := l_okl_xtl_csh_apps_tl_rec.last_update_login;
Line: 2504

  UPDATE  OKL_XTL_CSH_APPS_TL
  SET SOURCE_LANG = ldefoklxtlcshappstlrec.source_lang,
      CREATED_BY = ldefoklxtlcshappstlrec.created_by,
      CREATION_DATE = ldefoklxtlcshappstlrec.creation_date,
      LAST_UPDATED_BY = ldefoklxtlcshappstlrec.last_updated_by,
      LAST_UPDATE_DATE = ldefoklxtlcshappstlrec.last_update_date,
      LAST_UPDATE_LOGIN = ldefoklxtlcshappstlrec.last_update_login
  WHERE ID = ldefoklxtlcshappstlrec.id
  AND USERENV('LANG') in (SOURCE_LANG, LANGUAGE);
Line: 2514

  UPDATE  OKL_XTL_CSH_APPS_TL
  SET SFWT_FLAG = 'Y'
  WHERE ID = ldefoklxtlcshappstlrec.id
    AND SOURCE_LANG <> USERENV('LANG');
Line: 2552

END update_row;
Line: 2556

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_xcav_rec                     IN xcav_rec_type,
  x_xcav_rec                     OUT NOCOPY xcav_rec_type) IS

  l_api_version                 CONSTANT NUMBER := 1;
Line: 2566

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

    l_xcav_rec.LAST_UPDATE_DATE := SYSDATE;
Line: 2583

    l_xcav_rec.LAST_UPDATED_BY := Fnd_Global.USER_ID;
Line: 2584

    l_xcav_rec.LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
Line: 2740

    IF (x_xcav_rec.program_update_date = Okl_Api.G_MISS_DATE)
    THEN
      x_xcav_rec.program_update_date := l_xcav_rec.program_update_date;
Line: 2756

    IF (x_xcav_rec.last_updated_by = Okl_Api.G_MISS_NUM)
    THEN
      x_xcav_rec.last_updated_by := l_xcav_rec.last_updated_by;
Line: 2760

    IF (x_xcav_rec.last_update_date = Okl_Api.G_MISS_DATE)
    THEN
      x_xcav_rec.last_update_date := l_xcav_rec.last_update_date;
Line: 2764

    IF (x_xcav_rec.last_update_login = Okl_Api.G_MISS_NUM)
    THEN
      x_xcav_rec.last_update_login := l_xcav_rec.last_update_login;
Line: 2785

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

  update_row(
    p_init_msg_list,
    x_return_status,
    x_msg_count,
    x_msg_data,
    l_okl_xtl_csh_apps_tl_rec,
    lx_okl_xtl_csh_apps_tl_rec
  );
Line: 2872

  update_row(
    p_init_msg_list,
    x_return_status,
    x_msg_count,
    x_msg_data,
    l_xca_rec,
    lx_xca_rec
  );
Line: 2919

END update_row;
Line: 2923

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_xcav_tbl                     IN xcav_tbl_type,
  x_xcav_tbl                     OUT NOCOPY xcav_tbl_type) IS

  l_api_version                 CONSTANT NUMBER := 1;
Line: 2933

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

      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_xcav_rec                     => p_xcav_tbl(i),
        x_xcav_rec                     => x_xcav_tbl(i));
Line: 3005

END update_row;
Line: 3013

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_xca_rec                      IN xca_rec_type) IS

  l_api_version                 CONSTANT NUMBER := 1;
Line: 3021

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

  DELETE FROM OKL_XTL_CSH_APPS_B
   WHERE ID = l_xca_rec.id;
Line: 3070

END delete_row;
Line: 3074

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_csh_apps_tl_rec      IN okl_xtl_csh_apps_tl_rec_type) IS

  l_api_version                 CONSTANT NUMBER := 1;
Line: 3082

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

  DELETE FROM OKL_XTL_CSH_APPS_TL
   WHERE ID = l_okl_xtl_csh_apps_tl_rec.id;
Line: 3154

END delete_row;
Line: 3158

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_xcav_rec                     IN xcav_rec_type) IS

  l_api_version                 CONSTANT NUMBER := 1;
Line: 3167

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

  delete_row(
    p_init_msg_list,
    x_return_status,
    x_msg_count,
    x_msg_data,
    l_okl_xtl_csh_apps_tl_rec
  );
Line: 3205

  delete_row(
    p_init_msg_list,
    x_return_status,
    x_msg_count,
    x_msg_data,
    l_xca_rec
  );
Line: 3249

END delete_row;
Line: 3253

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_xcav_tbl                     IN xcav_tbl_type) IS

  l_api_version                 CONSTANT NUMBER := 1;
Line: 3262

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

      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_xcav_rec                     => p_xcav_tbl(i));
Line: 3333

END delete_row;