DBA Data[Home] [Help]

APPS.OKL_LLN_PVT SQL Statements

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

Line: 122

    SELECT '1'
	FROM OKL_CNSLD_AR_LINES_V
	WHERE id = p_llnv_rec.lln_id_parent;
Line: 160

    SELECT '1'
	FROM OKC_K_LINES_B
	WHERE id = p_llnv_rec.kle_id;
Line: 198

    SELECT '1'
	FROM OKL_K_HEADERS_V
	WHERE id = p_llnv_rec.khr_id;
Line: 236

    SELECT '1'
	FROM OKL_CNSLD_AR_HDRS_V
	WHERE id = p_llnv_rec.cnr_id;
Line: 274

    SELECT '1'
	FROM OKL_INVC_LINE_TYPES_V
	WHERE id = p_llnv_rec.ilt_id;
Line: 313

    SELECT '1'
	FROM fnd_currencies_vl
	WHERE currency_code = p_llnv_rec.currency_code;
Line: 381

    DELETE FROM OKL_CNSLD_AR_LINES_TL T
     WHERE NOT EXISTS (
        SELECT NULL
          FROM OKL_CNSLD_AR_LINES_B B
         WHERE B.ID = T.ID
         AND T.LANGUAGE = USERENV('LANG')
        );
Line: 395

       UPDATE statement is not complete.
     Please comment out WHERE condition if
       UPDATE statement is not present
     If new release has some columns in the table,
       this modification is not needed

    WHERE (
            T.ID,
            T.LANGUAGE)
        IN (SELECT
                SUBT.ID,
                SUBT.LANGUAGE
              FROM OKL_CNSLD_AR_LINES_TL SUBB, OKL_CNSLD_AR_LINES_TL SUBT
             WHERE SUBB.ID = SUBT.ID
               AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
  */

  INSERT INTO OKL_CNSLD_AR_LINES_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_CNSLD_AR_LINES_TL B, FND_LANGUAGES L
     WHERE L.INSTALLED_FLAG IN ('I', 'B')
       AND B.LANGUAGE = USERENV('LANG')
       AND NOT EXISTS(
                  SELECT NULL
                    FROM OKL_CNSLD_AR_LINES_TL T
                   WHERE T.ID = B.ID
                     AND T.LANGUAGE = L.LANGUAGE_CODE
                  );
Line: 452

  SELECT
          ID,
          SEQUENCE_NUMBER,
          LLN_ID_PARENT,
          KLE_ID,
          KHR_ID,
          CNR_ID,
          ILT_ID,
          LINE_TYPE,
          AMOUNT,
          OBJECT_VERSION_NUMBER,
          REQUEST_ID,
          PROGRAM_APPLICATION_ID,
          PROGRAM_ID,
          PROGRAM_UPDATE_DATE,
          ORG_ID,
		  TAX_AMOUNT,
          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_Cnsld_Ar_Lines_B
   WHERE okl_cnsld_ar_lines_b.id = p_id;
Line: 512

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

  SELECT
          ID,
          LANGUAGE,
          SOURCE_LANG,
          SFWT_FLAG,
          CREATED_BY,
          CREATION_DATE,
          LAST_UPDATED_BY,
          LAST_UPDATE_DATE,
          LAST_UPDATE_LOGIN
    FROM Okl_Cnsld_Ar_Lines_Tl
   WHERE okl_cnsld_ar_lines_tl.id = p_id
     AND okl_cnsld_ar_lines_tl.LANGUAGE = p_language;
Line: 584

            l_okl_cnsld_ar_lines_tl_rec.LAST_UPDATED_BY,
            l_okl_cnsld_ar_lines_tl_rec.LAST_UPDATE_DATE,
            l_okl_cnsld_ar_lines_tl_rec.LAST_UPDATE_LOGIN;
Line: 607

  SELECT
          ID,
          OBJECT_VERSION_NUMBER,
          SFWT_FLAG,
          KHR_ID,
          CNR_ID,
          KLE_ID,
          LLN_ID_PARENT,
          ILT_ID,
          SEQUENCE_NUMBER,
          AMOUNT,
          TAX_AMOUNT,
          ATTRIBUTE_CATEGORY,
          ATTRIBUTE1,
          ATTRIBUTE2,
          ATTRIBUTE3,
          ATTRIBUTE4,
          ATTRIBUTE5,
          ATTRIBUTE6,
          ATTRIBUTE7,
          ATTRIBUTE8,
          ATTRIBUTE9,
          ATTRIBUTE10,
          ATTRIBUTE11,
          ATTRIBUTE12,
          ATTRIBUTE13,
          ATTRIBUTE14,
          ATTRIBUTE15,
          LINE_TYPE,
          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_Cnsld_Ar_Lines_V
   WHERE okl_cnsld_ar_lines_v.id = p_id;
Line: 686

            l_llnv_rec.PROGRAM_UPDATE_DATE,
            l_llnv_rec.ORG_ID,
            l_llnv_rec.CREATED_BY,
            l_llnv_rec.CREATION_DATE,
            l_llnv_rec.LAST_UPDATED_BY,
            l_llnv_rec.LAST_UPDATE_DATE,
            l_llnv_rec.LAST_UPDATE_LOGIN;
Line: 804

  IF (l_llnv_rec.program_update_date = Okc_Api.G_MISS_DATE) THEN
    l_llnv_rec.program_update_date := NULL;
Line: 816

  IF (l_llnv_rec.last_updated_by = Okc_Api.G_MISS_NUM) THEN
    l_llnv_rec.last_updated_by := NULL;
Line: 819

  IF (l_llnv_rec.last_update_date = Okc_Api.G_MISS_DATE) THEN
    l_llnv_rec.last_update_date := NULL;
Line: 822

  IF (l_llnv_rec.last_update_login = Okc_Api.G_MISS_NUM) THEN
    l_llnv_rec.last_update_login := NULL;
Line: 1013

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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_lln_rec                      IN lln_rec_type,
  x_lln_rec                      OUT NOCOPY lln_rec_type) IS

  l_api_version                 CONSTANT NUMBER := 1;
Line: 1288

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

  INSERT INTO OKL_CNSLD_AR_LINES_B(
      id,
      sequence_number,
      lln_id_parent,
      kle_id,
      khr_id,
      cnr_id,
      ilt_id,
      line_type,
      amount,
      object_version_number,
      request_id,
      program_application_id,
      program_id,
      program_update_date,
      org_id,
      tax_amount,
      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_lln_rec.id,
      l_lln_rec.sequence_number,
      l_lln_rec.lln_id_parent,
      l_lln_rec.kle_id,
      l_lln_rec.khr_id,
      l_lln_rec.cnr_id,
      l_lln_rec.ilt_id,
      l_lln_rec.line_type,
      l_lln_rec.amount,
      l_lln_rec.object_version_number,
      l_lln_rec.request_id,
      l_lln_rec.program_application_id,
      l_lln_rec.program_id,
      l_lln_rec.program_update_date,
      l_lln_rec.org_id,
      l_lln_rec.tax_amount,
      l_lln_rec.attribute_category,
      l_lln_rec.attribute1,
      l_lln_rec.attribute2,
      l_lln_rec.attribute3,
      l_lln_rec.attribute4,
      l_lln_rec.attribute5,
      l_lln_rec.attribute6,
      l_lln_rec.attribute7,
      l_lln_rec.attribute8,
      l_lln_rec.attribute9,
      l_lln_rec.attribute10,
      l_lln_rec.attribute11,
      l_lln_rec.attribute12,
      l_lln_rec.attribute13,
      l_lln_rec.attribute14,
      l_lln_rec.attribute15,
      l_lln_rec.created_by,
      l_lln_rec.creation_date,
      l_lln_rec.last_updated_by,
      l_lln_rec.last_update_date,
      l_lln_rec.last_update_login);
Line: 1434

END insert_row;
Line: 1438

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_cnsld_ar_lines_tl_rec    IN okl_cnsld_ar_lines_tl_rec_type,
  x_okl_cnsld_ar_lines_tl_rec    OUT NOCOPY okl_cnsld_ar_lines_tl_rec_type) IS

  l_api_version                 CONSTANT NUMBER := 1;
Line: 1447

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

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

    INSERT INTO OKL_CNSLD_AR_LINES_TL(
        id,
        LANGUAGE,
        source_lang,
        sfwt_flag,
        created_by,
        creation_date,
        last_updated_by,
        last_update_date,
        last_update_login)
      VALUES (
        l_okl_cnsld_ar_lines_tl_rec.id,
        l_okl_cnsld_ar_lines_tl_rec.LANGUAGE,
        l_okl_cnsld_ar_lines_tl_rec.source_lang,
        l_okl_cnsld_ar_lines_tl_rec.sfwt_flag,
        l_okl_cnsld_ar_lines_tl_rec.created_by,
        l_okl_cnsld_ar_lines_tl_rec.creation_date,
        l_okl_cnsld_ar_lines_tl_rec.last_updated_by,
        l_okl_cnsld_ar_lines_tl_rec.last_update_date,
        l_okl_cnsld_ar_lines_tl_rec.last_update_login);
Line: 1546

END insert_row;
Line: 1550

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_llnv_rec                     IN llnv_rec_type,
  x_llnv_rec                     OUT NOCOPY llnv_rec_type) IS

  l_api_version                 CONSTANT NUMBER := 1;
Line: 1560

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

    l_llnv_rec.LAST_UPDATE_DATE := SYSDATE;
Line: 1579

    l_llnv_rec.LAST_UPDATED_BY := Fnd_Global.USER_ID;
Line: 1580

    l_llnv_rec.LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
Line: 1597

	  SELECT
	  		DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
	  		DECODE(Fnd_Global.PROG_APPL_ID,-1,NULL,Fnd_Global.CONC_REQUEST_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_llnv_rec.request_id,
	  	   x_llnv_rec.program_application_id,
	  	   x_llnv_rec.program_id,
	  	   x_llnv_rec.program_update_date
	  FROM dual;
Line: 1662

  insert_row(
    p_init_msg_list,
    x_return_status,
    x_msg_count,
    x_msg_data,
    l_lln_rec,
    lx_lln_rec
  );
Line: 1676

  insert_row(
    p_init_msg_list,
    x_return_status,
    x_msg_count,
    x_msg_data,
    l_okl_cnsld_ar_lines_tl_rec,
    lx_okl_cnsld_ar_lines_tl_rec
  );
Line: 1724

END insert_row;
Line: 1728

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_llnv_tbl                     IN llnv_tbl_type,
  x_llnv_tbl                     OUT NOCOPY llnv_tbl_type) IS

  l_api_version                 CONSTANT NUMBER := 1;
Line: 1738

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

      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_llnv_rec                     => p_llnv_tbl(i),
        x_llnv_rec                     => x_llnv_tbl(i));
Line: 1807

END insert_row;
Line: 1825

  SELECT OBJECT_VERSION_NUMBER
    FROM OKL_CNSLD_AR_LINES_B
   WHERE ID = p_lln_rec.id
     AND OBJECT_VERSION_NUMBER = p_lln_rec.object_version_number
  FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
Line: 1832

  SELECT OBJECT_VERSION_NUMBER
    FROM OKL_CNSLD_AR_LINES_B
  WHERE ID = p_lln_rec.id;
Line: 1873

    Okc_Api.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
Line: 1882

    Okc_Api.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
Line: 1931

  SELECT *
    FROM OKL_CNSLD_AR_LINES_TL
   WHERE ID = p_okl_cnsld_ar_lines_tl_rec.id
  FOR UPDATE NOWAIT;
Line: 1967

    Okc_Api.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
Line: 2168

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_lln_rec                      IN lln_rec_type,
  x_lln_rec                      OUT NOCOPY lln_rec_type) IS

  l_api_version                 CONSTANT NUMBER := 1;
Line: 2177

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

    IF (x_lln_rec.program_update_date = Okc_Api.G_MISS_DATE)
    THEN
      x_lln_rec.program_update_date := l_lln_rec.program_update_date;
Line: 2335

    IF (x_lln_rec.last_updated_by = Okc_Api.G_MISS_NUM)
    THEN
      x_lln_rec.last_updated_by := l_lln_rec.last_updated_by;
Line: 2339

    IF (x_lln_rec.last_update_date = Okc_Api.G_MISS_DATE)
    THEN
      x_lln_rec.last_update_date := l_lln_rec.last_update_date;
Line: 2343

    IF (x_lln_rec.last_update_login = Okc_Api.G_MISS_NUM)
    THEN
      x_lln_rec.last_update_login := l_lln_rec.last_update_login;
Line: 2387

  UPDATE  OKL_CNSLD_AR_LINES_B
  SET SEQUENCE_NUMBER = l_def_lln_rec.sequence_number,
      LLN_ID_PARENT = l_def_lln_rec.lln_id_parent,
      KLE_ID = l_def_lln_rec.kle_id,
      KHR_ID = l_def_lln_rec.khr_id,
      CNR_ID = l_def_lln_rec.cnr_id,
      ILT_ID = l_def_lln_rec.ilt_id,
      LINE_TYPE = l_def_lln_rec.line_type,
      AMOUNT = l_def_lln_rec.amount,
      OBJECT_VERSION_NUMBER = l_def_lln_rec.object_version_number,
      REQUEST_ID = l_def_lln_rec.request_id,
      PROGRAM_APPLICATION_ID = l_def_lln_rec.program_application_id,
      PROGRAM_ID = l_def_lln_rec.program_id,
      PROGRAM_UPDATE_DATE = l_def_lln_rec.program_update_date,
      ORG_ID = l_def_lln_rec.org_id,
      TAX_AMOUNT = l_def_lln_rec.tax_amount,
      ATTRIBUTE_CATEGORY = l_def_lln_rec.attribute_category,
      ATTRIBUTE1 = l_def_lln_rec.attribute1,
      ATTRIBUTE2 = l_def_lln_rec.attribute2,
      ATTRIBUTE3 = l_def_lln_rec.attribute3,
      ATTRIBUTE4 = l_def_lln_rec.attribute4,
      ATTRIBUTE5 = l_def_lln_rec.attribute5,
      ATTRIBUTE6 = l_def_lln_rec.attribute6,
      ATTRIBUTE7 = l_def_lln_rec.attribute7,
      ATTRIBUTE8 = l_def_lln_rec.attribute8,
      ATTRIBUTE9 = l_def_lln_rec.attribute9,
      ATTRIBUTE10 = l_def_lln_rec.attribute10,
      ATTRIBUTE11 = l_def_lln_rec.attribute11,
      ATTRIBUTE12 = l_def_lln_rec.attribute12,
      ATTRIBUTE13 = l_def_lln_rec.attribute13,
      ATTRIBUTE14 = l_def_lln_rec.attribute14,
      ATTRIBUTE15 = l_def_lln_rec.attribute15,
      CREATED_BY = l_def_lln_rec.created_by,
      CREATION_DATE = l_def_lln_rec.creation_date,
      LAST_UPDATED_BY = l_def_lln_rec.last_updated_by,
      LAST_UPDATE_DATE = l_def_lln_rec.last_update_date,
      LAST_UPDATE_LOGIN = l_def_lln_rec.last_update_login
  WHERE ID = l_def_lln_rec.id;
Line: 2459

END update_row;
Line: 2463

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_cnsld_ar_lines_tl_rec    IN okl_cnsld_ar_lines_tl_rec_type,
  x_okl_cnsld_ar_lines_tl_rec    OUT NOCOPY okl_cnsld_ar_lines_tl_rec_type) IS

  l_api_version                 CONSTANT NUMBER := 1;
Line: 2472

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

    IF (x_okl_cnsld_ar_lines_tl_rec.last_updated_by = Okc_Api.G_MISS_NUM)
    THEN
      x_okl_cnsld_ar_lines_tl_rec.last_updated_by := l_okl_cnsld_ar_lines_tl_rec.last_updated_by;
Line: 2522

    IF (x_okl_cnsld_ar_lines_tl_rec.last_update_date = Okc_Api.G_MISS_DATE)
    THEN
      x_okl_cnsld_ar_lines_tl_rec.last_update_date := l_okl_cnsld_ar_lines_tl_rec.last_update_date;
Line: 2526

    IF (x_okl_cnsld_ar_lines_tl_rec.last_update_login = Okc_Api.G_MISS_NUM)
    THEN
      x_okl_cnsld_ar_lines_tl_rec.last_update_login := l_okl_cnsld_ar_lines_tl_rec.last_update_login;
Line: 2572

  UPDATE  OKL_CNSLD_AR_LINES_TL
  SET CREATED_BY = ldefoklcnsldarlinestlrec.created_by,
      CREATION_DATE = ldefoklcnsldarlinestlrec.creation_date,
      LAST_UPDATED_BY = ldefoklcnsldarlinestlrec.last_updated_by,
      LAST_UPDATE_DATE = ldefoklcnsldarlinestlrec.last_update_date,
      LAST_UPDATE_LOGIN = ldefoklcnsldarlinestlrec.last_update_login
  WHERE ID = ldefoklcnsldarlinestlrec.id
    --AND SOURCE_LANG = USERENV('LANG');
Line: 2582

  UPDATE  OKL_CNSLD_AR_LINES_TL
  SET SFWT_FLAG = 'Y'
  WHERE ID = ldefoklcnsldarlinestlrec.id
    AND SOURCE_LANG <> USERENV('LANG');
Line: 2620

END update_row;
Line: 2624

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_llnv_rec                     IN llnv_rec_type,
  x_llnv_rec                     OUT NOCOPY llnv_rec_type) IS

  l_api_version                 CONSTANT NUMBER := 1;
Line: 2634

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

    l_llnv_rec.LAST_UPDATE_DATE := SYSDATE;
Line: 2651

    l_llnv_rec.LAST_UPDATED_BY := Fnd_Global.USER_ID;
Line: 2652

    l_llnv_rec.LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
Line: 2796

    IF (x_llnv_rec.program_update_date = Okc_Api.G_MISS_DATE)
    THEN
      x_llnv_rec.program_update_date := l_llnv_rec.program_update_date;
Line: 2812

    IF (x_llnv_rec.last_updated_by = Okc_Api.G_MISS_NUM)
    THEN
      x_llnv_rec.last_updated_by := l_llnv_rec.last_updated_by;
Line: 2816

    IF (x_llnv_rec.last_update_date = Okc_Api.G_MISS_DATE)
    THEN
      x_llnv_rec.last_update_date := l_llnv_rec.last_update_date;
Line: 2820

    IF (x_llnv_rec.last_update_login = Okc_Api.G_MISS_NUM)
    THEN
      x_llnv_rec.last_update_login := l_llnv_rec.last_update_login;
Line: 2840

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

  update_row(
    p_init_msg_list,
    x_return_status,
    x_msg_count,
    x_msg_data,
    l_okl_cnsld_ar_lines_tl_rec,
    lx_okl_cnsld_ar_lines_tl_rec
  );
Line: 2928

  update_row(
    p_init_msg_list,
    x_return_status,
    x_msg_count,
    x_msg_data,
    l_lln_rec,
    lx_lln_rec
  );
Line: 2975

END update_row;
Line: 2979

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_llnv_tbl                     IN llnv_tbl_type,
  x_llnv_tbl                     OUT NOCOPY llnv_tbl_type) IS

  l_api_version                 CONSTANT NUMBER := 1;
Line: 2989

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

      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_llnv_rec                     => p_llnv_tbl(i),
        x_llnv_rec                     => x_llnv_tbl(i));
Line: 3041

END update_row;
Line: 3049

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_lln_rec                      IN lln_rec_type) IS

  l_api_version                 CONSTANT NUMBER := 1;
Line: 3057

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

  DELETE FROM OKL_CNSLD_AR_LINES_B
   WHERE ID = l_lln_rec.id;
Line: 3106

END delete_row;
Line: 3110

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_cnsld_ar_lines_tl_rec    IN okl_cnsld_ar_lines_tl_rec_type) IS

  l_api_version                 CONSTANT NUMBER := 1;
Line: 3118

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

  DELETE FROM OKL_CNSLD_AR_LINES_TL
   WHERE ID = l_okl_cnsld_ar_lines_tl_rec.id;
Line: 3190

END delete_row;
Line: 3194

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_llnv_rec                     IN llnv_rec_type) IS

  l_api_version                 CONSTANT NUMBER := 1;
Line: 3203

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

  delete_row(
    p_init_msg_list,
    x_return_status,
    x_msg_count,
    x_msg_data,
    l_okl_cnsld_ar_lines_tl_rec
  );
Line: 3241

  delete_row(
    p_init_msg_list,
    x_return_status,
    x_msg_count,
    x_msg_data,
    l_lln_rec
  );
Line: 3285

END delete_row;
Line: 3289

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_llnv_tbl                     IN llnv_tbl_type) IS

  l_api_version                 CONSTANT NUMBER := 1;
Line: 3298

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

      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_llnv_rec                     => p_llnv_tbl(i));
Line: 3349

END delete_row;