DBA Data[Home] [Help]

APPS.OKL_LSM_PVT SQL Statements

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

Line: 74

    SELECT '1'
	FROM OKL_CNSLD_AR_LINES_V
	WHERE id = p_lsmv_rec.lln_id;
Line: 127

    SELECT '1'
	FROM OKL_STRM_TYPE_V
	WHERE id = p_lsmv_rec.sty_id;
Line: 180

    SELECT '1'
	FROM OKC_K_LINES_B
	WHERE id = p_lsmv_rec.kle_id;
Line: 247

    DELETE FROM OKL_CNSLD_AR_STRMS_TL T
     WHERE NOT EXISTS (
        SELECT NULL
          FROM OKL_CNSLD_AR_STRMS_B B
         WHERE B.ID = T.ID
         AND T.LANGUAGE = USERENV('LANG')
        );
Line: 258

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

  INSERT INTO OKL_CNSLD_AR_STRMS_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_STRMS_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_STRMS_TL T
                   WHERE T.ID = B.ID
                     AND T.LANGUAGE = L.LANGUAGE_CODE
                  );
Line: 306

  SELECT
          ID,
          LLN_ID,
          STY_ID,
          KLE_ID,
		  KHR_ID,
          AMOUNT,
          OBJECT_VERSION_NUMBER,
          RECEIVABLES_INVOICE_ID,
          REQUEST_ID,
          PROGRAM_APPLICATION_ID,
          PROGRAM_ID,
          PROGRAM_UPDATE_DATE,
          ORG_ID,
		  TAX_AMOUNT,
		  LATE_INT_ASSESS_DATE,
		  LATE_CHARGE_ASS_YN,
		  LATE_CHARGE_ASSESS_DATE,
		  LATE_INT_ASS_YN,
		  PAY_STATUS_CODE,
      DATE_DISBURSED,
          investor_disb_status,
          investor_disb_err_mg,
          sel_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_Cnsld_Ar_Strms_B
   WHERE okl_cnsld_ar_strms_b.id = p_id;
Line: 371

            l_lsm_rec.PROGRAM_UPDATE_DATE,
            l_lsm_rec.ORG_ID,
            l_lsm_rec.TAX_AMOUNT,
		  	l_lsm_rec.LATE_INT_ASSESS_DATE,
		  	l_lsm_rec.LATE_CHARGE_ASS_YN,
		  	l_lsm_rec.LATE_CHARGE_ASSESS_DATE,
		  	l_lsm_rec.LATE_INT_ASS_YN,
		  	l_lsm_rec.PAY_STATUS_CODE,
        l_lsm_rec.DATE_DISBURSED,
		  	l_lsm_rec.investor_disb_status,
		  	l_lsm_rec.investor_disb_err_mg,
            l_lsm_rec.sel_id,
            l_lsm_rec.ATTRIBUTE_CATEGORY,
            l_lsm_rec.ATTRIBUTE1,
            l_lsm_rec.ATTRIBUTE2,
            l_lsm_rec.ATTRIBUTE3,
            l_lsm_rec.ATTRIBUTE4,
            l_lsm_rec.ATTRIBUTE5,
            l_lsm_rec.ATTRIBUTE6,
            l_lsm_rec.ATTRIBUTE7,
            l_lsm_rec.ATTRIBUTE8,
            l_lsm_rec.ATTRIBUTE9,
            l_lsm_rec.ATTRIBUTE10,
            l_lsm_rec.ATTRIBUTE11,
            l_lsm_rec.ATTRIBUTE12,
            l_lsm_rec.ATTRIBUTE13,
            l_lsm_rec.ATTRIBUTE14,
            l_lsm_rec.ATTRIBUTE15,
            l_lsm_rec.CREATED_BY,
            l_lsm_rec.CREATION_DATE,
            l_lsm_rec.LAST_UPDATED_BY,
            l_lsm_rec.LAST_UPDATE_DATE,
            l_lsm_rec.LAST_UPDATE_LOGIN;
Line: 425

  SELECT
          ID,
          LANGUAGE,
          SOURCE_LANG,
          SFWT_FLAG,
          CREATED_BY,
          CREATION_DATE,
          LAST_UPDATED_BY,
          LAST_UPDATE_DATE,
          LAST_UPDATE_LOGIN
    FROM Okl_Cnsld_Ar_Strms_Tl
   WHERE okl_cnsld_ar_strms_tl.id = p_id
     AND okl_cnsld_ar_strms_tl.LANGUAGE = p_language;
Line: 452

            l_okl_cnsld_ar_strms_tl_rec.LAST_UPDATED_BY,
            l_okl_cnsld_ar_strms_tl_rec.LAST_UPDATE_DATE,
            l_okl_cnsld_ar_strms_tl_rec.LAST_UPDATE_LOGIN;
Line: 475

  SELECT
          ID,
          OBJECT_VERSION_NUMBER,
          SFWT_FLAG,
          LLN_ID,
          KLE_ID,
		  KHR_ID,
          STY_ID,
          AMOUNT,
          RECEIVABLES_INVOICE_ID,
          TAX_AMOUNT,
		  LATE_INT_ASSESS_DATE,
		  LATE_CHARGE_ASS_YN,
		  LATE_CHARGE_ASSESS_DATE,
		  LATE_INT_ASS_YN,
		  PAY_STATUS_CODE,
      DATE_DISBURSED,
          investor_disb_status,
          investor_disb_err_mg,
          sel_id,
          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_Cnsld_Ar_Strms_V
   WHERE okl_cnsld_ar_strms_v.id = p_id;
Line: 568

            l_lsmv_rec.PROGRAM_UPDATE_DATE,
            l_lsmv_rec.ORG_ID,
            l_lsmv_rec.CREATED_BY,
            l_lsmv_rec.CREATION_DATE,
            l_lsmv_rec.LAST_UPDATED_BY,
            l_lsmv_rec.LAST_UPDATE_DATE,
            l_lsmv_rec.LAST_UPDATE_LOGIN;
Line: 713

  IF (l_lsmv_rec.program_update_date = Okc_Api.G_MISS_DATE) THEN
    l_lsmv_rec.program_update_date := NULL;
Line: 725

  IF (l_lsmv_rec.last_updated_by = Okc_Api.G_MISS_NUM) THEN
    l_lsmv_rec.last_updated_by := NULL;
Line: 728

  IF (l_lsmv_rec.last_update_date = Okc_Api.G_MISS_DATE) THEN
    l_lsmv_rec.last_update_date := NULL;
Line: 731

  IF (l_lsmv_rec.last_update_login = Okc_Api.G_MISS_NUM) THEN
    l_lsmv_rec.last_update_login := NULL;
Line: 867

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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_lsm_rec                      IN lsm_rec_type,
  x_lsm_rec                      OUT NOCOPY lsm_rec_type) IS

  l_api_version                 CONSTANT NUMBER := 1;
Line: 1156

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

  INSERT INTO OKL_CNSLD_AR_STRMS_B(
      id,
      lln_id,
      sty_id,
      kle_id,
	  khr_id,
      amount,
      object_version_number,
      receivables_invoice_id,
      request_id,
      program_application_id,
      program_id,
      program_update_date,
      org_id,
      tax_amount,
	  LATE_INT_ASSESS_DATE,
	  LATE_CHARGE_ASS_YN,
	  LATE_CHARGE_ASSESS_DATE,
	  LATE_INT_ASS_YN,
	  PAY_STATUS_CODE,
    DATE_DISBURSED,
      investor_disb_status,
      investor_disb_err_mg,
      sel_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_lsm_rec.id,
      l_lsm_rec.lln_id,
      l_lsm_rec.sty_id,
      l_lsm_rec.kle_id,
	  l_lsm_rec.khr_id,
      l_lsm_rec.amount,
      l_lsm_rec.object_version_number,
      l_lsm_rec.receivables_invoice_id,
      l_lsm_rec.request_id,
      l_lsm_rec.program_application_id,
      l_lsm_rec.program_id,
      l_lsm_rec.program_update_date,
      l_lsm_rec.org_id,
      l_lsm_rec.tax_amount,
	  l_lsm_rec.LATE_INT_ASSESS_DATE,
	  l_lsm_rec.LATE_CHARGE_ASS_YN,
	  l_lsm_rec.LATE_CHARGE_ASSESS_DATE,
	  l_lsm_rec.LATE_INT_ASS_YN,
	  l_lsm_rec.PAY_STATUS_CODE,
	  l_lsm_rec.DATE_DISBURSED,
	  l_lsm_rec.investor_disb_status,
	  l_lsm_rec.investor_disb_err_mg,
      l_lsm_rec.sel_id,
      l_lsm_rec.attribute_category,
      l_lsm_rec.attribute1,
      l_lsm_rec.attribute2,
      l_lsm_rec.attribute3,
      l_lsm_rec.attribute4,
      l_lsm_rec.attribute5,
      l_lsm_rec.attribute6,
      l_lsm_rec.attribute7,
      l_lsm_rec.attribute8,
      l_lsm_rec.attribute9,
      l_lsm_rec.attribute10,
      l_lsm_rec.attribute11,
      l_lsm_rec.attribute12,
      l_lsm_rec.attribute13,
      l_lsm_rec.attribute14,
      l_lsm_rec.attribute15,
      l_lsm_rec.created_by,
      l_lsm_rec.creation_date,
      l_lsm_rec.last_updated_by,
      l_lsm_rec.last_update_date,
      l_lsm_rec.last_update_login);
Line: 1316

END insert_row;
Line: 1320

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_strms_tl_rec    IN okl_cnsld_ar_strms_tl_rec_type,
  x_okl_cnsld_ar_strms_tl_rec    OUT NOCOPY okl_cnsld_ar_strms_tl_rec_type) IS

  l_api_version                 CONSTANT NUMBER := 1;
Line: 1329

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

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

    INSERT INTO OKL_CNSLD_AR_STRMS_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_strms_tl_rec.id,
        l_okl_cnsld_ar_strms_tl_rec.LANGUAGE,
        l_okl_cnsld_ar_strms_tl_rec.source_lang,
        l_okl_cnsld_ar_strms_tl_rec.sfwt_flag,
        l_okl_cnsld_ar_strms_tl_rec.created_by,
        l_okl_cnsld_ar_strms_tl_rec.creation_date,
        l_okl_cnsld_ar_strms_tl_rec.last_updated_by,
        l_okl_cnsld_ar_strms_tl_rec.last_update_date,
        l_okl_cnsld_ar_strms_tl_rec.last_update_login);
Line: 1428

END insert_row;
Line: 1432

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_lsmv_rec                     IN lsmv_rec_type,
  x_lsmv_rec                     OUT NOCOPY lsmv_rec_type) IS

  l_api_version                 CONSTANT NUMBER := 1;
Line: 1442

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

    l_lsmv_rec.LAST_UPDATE_DATE := SYSDATE;
Line: 1461

    l_lsmv_rec.LAST_UPDATED_BY := Fnd_Global.USER_ID;
Line: 1462

    l_lsmv_rec.LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
Line: 1479

	  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_lsmv_rec.request_id,
	  	   x_lsmv_rec.program_application_id,
	  	   x_lsmv_rec.program_id,
	  	   x_lsmv_rec.program_update_date
	  FROM dual;
Line: 1543

  insert_row(
    p_init_msg_list,
    x_return_status,
    x_msg_count,
    x_msg_data,
    l_lsm_rec,
    lx_lsm_rec
  );
Line: 1557

  insert_row(
    p_init_msg_list,
    x_return_status,
    x_msg_count,
    x_msg_data,
    l_okl_cnsld_ar_strms_tl_rec,
    lx_okl_cnsld_ar_strms_tl_rec
  );
Line: 1605

END insert_row;
Line: 1609

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_lsmv_tbl                     IN lsmv_tbl_type,
  x_lsmv_tbl                     OUT NOCOPY lsmv_tbl_type) IS

  l_api_version                 CONSTANT NUMBER := 1;
Line: 1619

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

      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_lsmv_rec                     => p_lsmv_tbl(i),
        x_lsmv_rec                     => x_lsmv_tbl(i));
Line: 1689

END insert_row;
Line: 1707

  SELECT OBJECT_VERSION_NUMBER
    FROM OKL_CNSLD_AR_STRMS_B
   WHERE ID = p_lsm_rec.id
     AND OBJECT_VERSION_NUMBER = p_lsm_rec.object_version_number
  FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
Line: 1714

  SELECT OBJECT_VERSION_NUMBER
    FROM OKL_CNSLD_AR_STRMS_B
  WHERE ID = p_lsm_rec.id;
Line: 1755

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

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

  SELECT *
    FROM OKL_CNSLD_AR_STRMS_TL
   WHERE ID = p_okl_cnsld_ar_strms_tl_rec.id
  FOR UPDATE NOWAIT;
Line: 1849

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

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_lsm_rec                      IN lsm_rec_type,
  x_lsm_rec                      OUT NOCOPY lsm_rec_type) IS

  l_api_version                 CONSTANT NUMBER := 1;
Line: 2078

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

    IF (x_lsm_rec.program_update_date = Okc_Api.G_MISS_DATE)
    THEN
      x_lsm_rec.program_update_date := l_lsm_rec.program_update_date;
Line: 2266

    IF (x_lsm_rec.last_updated_by = Okc_Api.G_MISS_NUM)
    THEN
      x_lsm_rec.last_updated_by := l_lsm_rec.last_updated_by;
Line: 2270

    IF (x_lsm_rec.last_update_date = Okc_Api.G_MISS_DATE)
    THEN
      x_lsm_rec.last_update_date := l_lsm_rec.last_update_date;
Line: 2274

    IF (x_lsm_rec.last_update_login = Okc_Api.G_MISS_NUM)
    THEN
      x_lsm_rec.last_update_login := l_lsm_rec.last_update_login;
Line: 2318

  UPDATE  OKL_CNSLD_AR_STRMS_B
  SET LLN_ID = l_def_lsm_rec.lln_id,
      STY_ID = l_def_lsm_rec.sty_id,
      KLE_ID = l_def_lsm_rec.kle_id,
      KHR_ID = l_def_lsm_rec.khr_id,
      AMOUNT = l_def_lsm_rec.amount,
      OBJECT_VERSION_NUMBER = l_def_lsm_rec.object_version_number,
      RECEIVABLES_INVOICE_ID = l_def_lsm_rec.receivables_invoice_id,
      REQUEST_ID = l_def_lsm_rec.request_id,
      PROGRAM_APPLICATION_ID = l_def_lsm_rec.program_application_id,
      PROGRAM_ID = l_def_lsm_rec.program_id,
      PROGRAM_UPDATE_DATE = l_def_lsm_rec.program_update_date,
      ORG_ID = l_def_lsm_rec.org_id,
      TAX_AMOUNT = l_def_lsm_rec.tax_amount,
      LATE_INT_ASSESS_DATE = l_def_lsm_rec.LATE_INT_ASSESS_DATE,
      LATE_CHARGE_ASS_YN = l_def_lsm_rec.LATE_CHARGE_ASS_YN,
      LATE_CHARGE_ASSESS_DATE = l_def_lsm_rec.LATE_CHARGE_ASSESS_DATE,
      LATE_INT_ASS_YN = l_def_lsm_rec.LATE_INT_ASS_YN,
      PAY_STATUS_CODE = l_def_lsm_rec.PAY_STATUS_CODE,
      DATE_DISBURSED = l_def_lsm_rec.DATE_DISBURSED,
      investor_disb_status = l_def_lsm_rec.investor_disb_status,
      investor_disb_err_mg = l_def_lsm_rec.investor_disb_err_mg,
      SEL_ID = l_def_lsm_rec.sel_id,
      ATTRIBUTE_CATEGORY = l_def_lsm_rec.attribute_category,
      ATTRIBUTE1 = l_def_lsm_rec.attribute1,
      ATTRIBUTE2 = l_def_lsm_rec.attribute2,
      ATTRIBUTE3 = l_def_lsm_rec.attribute3,
      ATTRIBUTE4 = l_def_lsm_rec.attribute4,
      ATTRIBUTE5 = l_def_lsm_rec.attribute5,
      ATTRIBUTE6 = l_def_lsm_rec.attribute6,
      ATTRIBUTE7 = l_def_lsm_rec.attribute7,
      ATTRIBUTE8 = l_def_lsm_rec.attribute8,
      ATTRIBUTE9 = l_def_lsm_rec.attribute9,
      ATTRIBUTE10 = l_def_lsm_rec.attribute10,
      ATTRIBUTE11 = l_def_lsm_rec.attribute11,
      ATTRIBUTE12 = l_def_lsm_rec.attribute12,
      ATTRIBUTE13 = l_def_lsm_rec.attribute13,
      ATTRIBUTE14 = l_def_lsm_rec.attribute14,
      ATTRIBUTE15 = l_def_lsm_rec.attribute15,
      CREATED_BY = l_def_lsm_rec.created_by,
      CREATION_DATE = l_def_lsm_rec.creation_date,
      LAST_UPDATED_BY = l_def_lsm_rec.last_updated_by,
      LAST_UPDATE_DATE = l_def_lsm_rec.last_update_date,
      LAST_UPDATE_LOGIN = l_def_lsm_rec.last_update_login
  WHERE ID = l_def_lsm_rec.id;
Line: 2397

END update_row;
Line: 2401

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_strms_tl_rec    IN okl_cnsld_ar_strms_tl_rec_type,
  x_okl_cnsld_ar_strms_tl_rec    OUT NOCOPY okl_cnsld_ar_strms_tl_rec_type) IS

  l_api_version                 CONSTANT NUMBER := 1;
Line: 2410

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

    IF (x_okl_cnsld_ar_strms_tl_rec.last_updated_by = Okc_Api.G_MISS_NUM)
    THEN
      x_okl_cnsld_ar_strms_tl_rec.last_updated_by := l_okl_cnsld_ar_strms_tl_rec.last_updated_by;
Line: 2460

    IF (x_okl_cnsld_ar_strms_tl_rec.last_update_date = Okc_Api.G_MISS_DATE)
    THEN
      x_okl_cnsld_ar_strms_tl_rec.last_update_date := l_okl_cnsld_ar_strms_tl_rec.last_update_date;
Line: 2464

    IF (x_okl_cnsld_ar_strms_tl_rec.last_update_login = Okc_Api.G_MISS_NUM)
    THEN
      x_okl_cnsld_ar_strms_tl_rec.last_update_login := l_okl_cnsld_ar_strms_tl_rec.last_update_login;
Line: 2510

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

  UPDATE  OKL_CNSLD_AR_STRMS_TL
  SET SFWT_FLAG = 'Y'
  WHERE ID = ldefoklcnsldarstrmstlrec.id
    AND SOURCE_LANG <> USERENV('LANG');
Line: 2558

END update_row;
Line: 2562

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_lsmv_rec                     IN lsmv_rec_type,
  x_lsmv_rec                     OUT NOCOPY lsmv_rec_type) IS

  l_api_version                 CONSTANT NUMBER := 1;
Line: 2572

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

    l_lsmv_rec.LAST_UPDATE_DATE := SYSDATE;
Line: 2589

    l_lsmv_rec.LAST_UPDATED_BY := Fnd_Global.USER_ID;
Line: 2590

    l_lsmv_rec.LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
Line: 2764

    IF (x_lsmv_rec.program_update_date = Okc_Api.G_MISS_DATE)
    THEN
      x_lsmv_rec.program_update_date := l_lsmv_rec.program_update_date;
Line: 2780

    IF (x_lsmv_rec.last_updated_by = Okc_Api.G_MISS_NUM)
    THEN
      x_lsmv_rec.last_updated_by := l_lsmv_rec.last_updated_by;
Line: 2784

    IF (x_lsmv_rec.last_update_date = Okc_Api.G_MISS_DATE)
    THEN
      x_lsmv_rec.last_update_date := l_lsmv_rec.last_update_date;
Line: 2788

    IF (x_lsmv_rec.last_update_login = Okc_Api.G_MISS_NUM)
    THEN
      x_lsmv_rec.last_update_login := l_lsmv_rec.last_update_login;
Line: 2808

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

  update_row(
    p_init_msg_list,
    x_return_status,
    x_msg_count,
    x_msg_data,
    l_okl_cnsld_ar_strms_tl_rec,
    lx_okl_cnsld_ar_strms_tl_rec
  );
Line: 2895

  update_row(
    p_init_msg_list,
    x_return_status,
    x_msg_count,
    x_msg_data,
    l_lsm_rec,
    lx_lsm_rec
  );
Line: 2942

END update_row;
Line: 2946

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_lsmv_tbl                     IN lsmv_tbl_type,
  x_lsmv_tbl                     OUT NOCOPY lsmv_tbl_type) IS

  l_api_version                 CONSTANT NUMBER := 1;
Line: 2956

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

      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_lsmv_rec                     => p_lsmv_tbl(i),
        x_lsmv_rec                     => x_lsmv_tbl(i));
Line: 3027

END update_row;
Line: 3035

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_lsm_rec                      IN lsm_rec_type) IS

  l_api_version                 CONSTANT NUMBER := 1;
Line: 3043

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

  DELETE FROM OKL_CNSLD_AR_STRMS_B
   WHERE ID = l_lsm_rec.id;
Line: 3092

END delete_row;
Line: 3096

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_strms_tl_rec    IN okl_cnsld_ar_strms_tl_rec_type) IS

  l_api_version                 CONSTANT NUMBER := 1;
Line: 3104

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

  DELETE FROM OKL_CNSLD_AR_STRMS_TL
   WHERE ID = l_okl_cnsld_ar_strms_tl_rec.id;
Line: 3176

END delete_row;
Line: 3180

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_lsmv_rec                     IN lsmv_rec_type) IS

  l_api_version                 CONSTANT NUMBER := 1;
Line: 3189

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

  delete_row(
    p_init_msg_list,
    x_return_status,
    x_msg_count,
    x_msg_data,
    l_okl_cnsld_ar_strms_tl_rec
  );
Line: 3227

  delete_row(
    p_init_msg_list,
    x_return_status,
    x_msg_count,
    x_msg_data,
    l_lsm_rec
  );
Line: 3271

END delete_row;
Line: 3275

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_lsmv_tbl                     IN lsmv_tbl_type) IS

  l_api_version                 CONSTANT NUMBER := 1;
Line: 3284

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

      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_lsmv_rec                     => p_lsmv_tbl(i));
Line: 3335

END delete_row;