APPS.OKE_NOTE_PVT SQL Statements

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

Line: 32

	SELECT 'x'
	FROM OKE_K_HEADERS
	WHERE K_HEADER_ID = p_note_rec.K_HEADER_ID;

Line: 102

	SELECT 'x'
	FROM OKE_K_LINES
	WHERE K_LINE_ID = p_note_rec.K_LINE_ID;

Line: 157

	SELECT 'x'
	FROM OKE_K_DELIVERABLES_B
	WHERE DELIVERABLE_ID = p_note_rec.DELIVERABLE_ID;

Line: 340

    IF	l_note_rec.LAST_UPDATED_BY = OKE_API.G_MISS_NUM THEN
	l_note_rec.LAST_UPDATED_BY := NULL;

Line: 344

    IF	l_note_rec.LAST_UPDATE_LOGIN = OKE_API.G_MISS_NUM THEN
	l_note_rec.LAST_UPDATE_LOGIN := NULL;

Line: 348

    IF	l_note_rec.LAST_UPDATE_DATE = OKE_API.G_MISS_DATE THEN
	l_note_rec.LAST_UPDATE_DATE := NULL;

Line: 380

    SELECT
		STANDARD_NOTES_ID		,
		CREATION_DATE			,
		CREATED_BY			,
		LAST_UPDATE_DATE		,
		LAST_UPDATED_BY			,
		LAST_UPDATE_LOGIN		,
		K_HEADER_ID			,
		K_LINE_ID			,
		DELIVERABLE_ID			,
		TYPE_CODE			,
		ATTRIBUTE_CATEGORY		,
		ATTRIBUTE1			,
		ATTRIBUTE2			,
		ATTRIBUTE3			,
		ATTRIBUTE4			,
		ATTRIBUTE5			,
		ATTRIBUTE6			,
		ATTRIBUTE7			,
		ATTRIBUTE8			,
		ATTRIBUTE9			,
		ATTRIBUTE10			,
		ATTRIBUTE11			,
		ATTRIBUTE12			,
		ATTRIBUTE13			,
		ATTRIBUTE14			,
		ATTRIBUTE15			,
		default_flag
    FROM OKE_K_STANDARD_NOTES_B
    WHERE OKE_K_STANDARD_NOTES_B.STANDARD_NOTES_ID = p_id;

Line: 412

    SELECT
		SFWT_FLAG	,
		DESCRIPTION	,
		NAME		,
		TEXT
    FROM OKE_K_STANDARD_NOTES_TL
    WHERE OKE_K_STANDARD_NOTES_TL.STANDARD_NOTES_ID = p_id;

Line: 435

		l_note_rec.LAST_UPDATE_DATE		,
		l_note_rec.LAST_UPDATED_BY		,
		l_note_rec.LAST_UPDATE_LOGIN		,
		l_note_rec.K_HEADER_ID			,
		l_note_rec.K_LINE_ID			,
		l_note_rec.DELIVERABLE_ID		,
		l_note_rec.TYPE_CODE			,
		l_note_rec.ATTRIBUTE_CATEGORY		,
		l_note_rec.ATTRIBUTE1			,
		l_note_rec.ATTRIBUTE2			,
		l_note_rec.ATTRIBUTE3			,
		l_note_rec.ATTRIBUTE4			,
		l_note_rec.ATTRIBUTE5			,
		l_note_rec.ATTRIBUTE6			,
		l_note_rec.ATTRIBUTE7			,
		l_note_rec.ATTRIBUTE8			,
		l_note_rec.ATTRIBUTE9			,
		l_note_rec.ATTRIBUTE10			,
		l_note_rec.ATTRIBUTE11			,
		l_note_rec.ATTRIBUTE12			,
		l_note_rec.ATTRIBUTE13			,
		l_note_rec.ATTRIBUTE14			,
		l_note_rec.ATTRIBUTE15			,
		l_note_rec.default_flag			;

Line: 489

	-- row level insert

  PROCEDURE insert_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_note_rec                      IN note_rec_type,
    x_note_rec                      OUT NOCOPY note_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 501

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

Line: 520

      l_note_rec.LAST_UPDATE_DATE := SYSDATE;

Line: 521

      l_note_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 522

      l_note_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 542

  BEGIN  -- insert

    l_return_status := OKE_API.START_ACTIVITY(l_api_name,
                                              G_PKG_NAME,
                                              p_init_msg_list,
                                              l_api_version,
                                              p_api_version,
                                              '_PVT',
                                              x_return_status);

Line: 609

    SELECT OKE_K_STANDARD_NOTES_S.nextval  INTO l_seq FROM dual;

Line: 611

    INSERT INTO OKE_K_STANDARD_NOTES_B(

	STANDARD_NOTES_ID    ,
 	CREATION_DATE        ,
 	CREATED_BY           ,
 	LAST_UPDATE_DATE     ,
 	LAST_UPDATED_BY      ,
 	LAST_UPDATE_LOGIN    ,
 	K_HEADER_ID          ,
 	K_LINE_ID            ,
 	DELIVERABLE_ID       ,
 	TYPE_CODE            ,
 	ATTRIBUTE_CATEGORY   ,
 	ATTRIBUTE1           ,
 	ATTRIBUTE2           ,
 	ATTRIBUTE3           ,
 	ATTRIBUTE4           ,
 	ATTRIBUTE5           ,
 	ATTRIBUTE6           ,
 	ATTRIBUTE7           ,
 	ATTRIBUTE8           ,
 	ATTRIBUTE9           ,
 	ATTRIBUTE10          ,
 	ATTRIBUTE11          ,
 	ATTRIBUTE12          ,
 	ATTRIBUTE13          ,
 	ATTRIBUTE14          ,
 	ATTRIBUTE15	     ,
	default_flag
	)
    VALUES(

	l_seq,
 	l_def_note_rec.CREATION_DATE        ,
 	l_def_note_rec.CREATED_BY           ,
 	l_def_note_rec.LAST_UPDATE_DATE     ,
 	l_def_note_rec.LAST_UPDATED_BY      ,
 	l_def_note_rec.LAST_UPDATE_LOGIN    ,
 	l_def_note_rec.K_HEADER_ID          ,
 	l_def_note_rec.K_LINE_ID            ,
 	l_def_note_rec.DELIVERABLE_ID       ,
 	l_def_note_rec.TYPE_CODE            ,
 	l_def_note_rec.ATTRIBUTE_CATEGORY   ,
 	l_def_note_rec.ATTRIBUTE1           ,
 	l_def_note_rec.ATTRIBUTE2           ,
 	l_def_note_rec.ATTRIBUTE3           ,
 	l_def_note_rec.ATTRIBUTE4           ,
 	l_def_note_rec.ATTRIBUTE5           ,
 	l_def_note_rec.ATTRIBUTE6           ,
 	l_def_note_rec.ATTRIBUTE7           ,
 	l_def_note_rec.ATTRIBUTE8           ,
 	l_def_note_rec.ATTRIBUTE9           ,
 	l_def_note_rec.ATTRIBUTE10          ,
 	l_def_note_rec.ATTRIBUTE11          ,
 	l_def_note_rec.ATTRIBUTE12          ,
 	l_def_note_rec.ATTRIBUTE13          ,
 	l_def_note_rec.ATTRIBUTE14          ,
 	l_def_note_rec.ATTRIBUTE15          ,
	l_def_note_rec.default_flag
	);

Line: 672

     INSERT INTO OKE_K_STANDARD_NOTES_TL(
 	STANDARD_NOTES_ID    ,
	LANGUAGE             ,
 	CREATION_DATE        ,
 	CREATED_BY           ,
 	LAST_UPDATE_DATE     ,
 	LAST_UPDATED_BY      ,
 	LAST_UPDATE_LOGIN    ,
 	SOURCE_LANG          ,
 	SFWT_FLAG            ,
 	DESCRIPTION          ,
 	NAME                 ,
 	TEXT
	)
	SELECT
	l_seq    ,
	L.language_code                     ,
 	l_def_note_rec.CREATION_DATE        ,
 	l_def_note_rec.CREATED_BY           ,
 	l_def_note_rec.LAST_UPDATE_DATE     ,
 	l_def_note_rec.LAST_UPDATED_BY      ,
 	l_def_note_rec.LAST_UPDATE_LOGIN    ,
 	oke_utils.get_userenv_lang          ,
 	l_def_note_rec.SFWT_FLAG            ,
 	l_def_note_rec.DESCRIPTION          ,
 	l_def_note_rec.NAME                 ,
 	l_def_note_rec.TEXT
        FROM fnd_languages L
	WHERE L.INSTALLED_FLAG in ('I', 'B')
	AND NOT EXISTS
	  (select NULL
	   from OKE_K_STANDARD_NOTES_TL T
	   where T.STANDARD_NOTES_ID = l_seq
	   and T.LANGUAGE = L.LANGUAGE_CODE);

Line: 744

  END insert_row;   -- row level

Line: 749

	-- table level insert

  PROCEDURE insert_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_note_tbl                      IN note_tbl_type,
    x_note_tbl                      OUT NOCOPY note_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 761

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

Line: 772

        insert_row (
          p_api_version                  => p_api_version,
          p_init_msg_list                => OKE_API.G_FALSE,
          x_return_status                => x_return_status,
          x_msg_count                    => x_msg_count,
          x_msg_data                     => x_msg_data,

          p_note_rec                      => p_note_tbl(i),
          x_note_rec                      => x_note_tbl(i));

Line: 828

  END insert_row; -- table level

Line: 837

  PROCEDURE update_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_note_rec                      IN note_rec_type,
    x_note_rec                      OUT NOCOPY note_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1.0;

Line: 847

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

Line: 863

      l_note_rec.LAST_UPDATE_DATE := SYSDATE;

Line: 864

      l_note_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 865

      l_note_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 909

	IF x_note_rec.LAST_UPDATE_DATE = OKE_API.G_MISS_DATE THEN
	  x_note_rec.LAST_UPDATE_DATE := l_note_rec.LAST_UPDATE_DATE;

Line: 913

	IF x_note_rec.LAST_UPDATED_BY = OKE_API.G_MISS_NUM THEN
	  x_note_rec.LAST_UPDATED_BY  := l_note_rec.LAST_UPDATED_BY ;

Line: 917

	IF x_note_rec.LAST_UPDATE_LOGIN = OKE_API.G_MISS_NUM THEN
	  x_note_rec.LAST_UPDATE_LOGIN := l_note_rec.LAST_UPDATE_LOGIN;

Line: 1029

  BEGIN  -- update row


    l_return_status := OKE_API.START_ACTIVITY(l_api_name,
                                              G_PKG_NAME,
                                              p_init_msg_list,
                                              l_api_version,
                                              p_api_version,
                                              '_PVT',
                                              x_return_status);

Line: 1094

    UPDATE OKE_K_STANDARD_NOTES_B
    SET
	CREATION_DATE	= l_def_note_rec.CREATION_DATE,
	CREATED_BY = l_def_note_rec.CREATED_BY,
	LAST_UPDATE_DATE = l_def_note_rec.LAST_UPDATE_DATE,
	LAST_UPDATED_BY = l_def_note_rec.LAST_UPDATED_BY,
	LAST_UPDATE_LOGIN = l_def_note_rec.LAST_UPDATE_LOGIN,
	K_HEADER_ID = l_def_note_rec.K_HEADER_ID,
	K_LINE_ID = l_def_note_rec.K_LINE_ID,
	DELIVERABLE_ID = l_def_note_rec.DELIVERABLE_ID,
	TYPE_CODE = l_def_note_rec.TYPE_CODE,
	ATTRIBUTE_CATEGORY = l_def_note_rec.ATTRIBUTE_CATEGORY,
	ATTRIBUTE1 = l_def_note_rec.ATTRIBUTE1,
	ATTRIBUTE2 = l_def_note_rec.ATTRIBUTE2,
	ATTRIBUTE3 = l_def_note_rec.ATTRIBUTE3,
	ATTRIBUTE4 = l_def_note_rec.ATTRIBUTE4,
	ATTRIBUTE5 = l_def_note_rec.ATTRIBUTE5,
	ATTRIBUTE6 = l_def_note_rec.ATTRIBUTE6,
	ATTRIBUTE7 = l_def_note_rec.ATTRIBUTE7,
	ATTRIBUTE8 = l_def_note_rec.ATTRIBUTE8,
	ATTRIBUTE9 = l_def_note_rec.ATTRIBUTE9,
	ATTRIBUTE10 = l_def_note_rec.ATTRIBUTE10,
	ATTRIBUTE11 = l_def_note_rec.ATTRIBUTE11,
	ATTRIBUTE12 = l_def_note_rec.ATTRIBUTE12,
	ATTRIBUTE13 = l_def_note_rec.ATTRIBUTE13,
	ATTRIBUTE14 = l_def_note_rec.ATTRIBUTE14,
	ATTRIBUTE15 = l_def_note_rec.ATTRIBUTE15,
	default_flag= l_def_note_rec.default_flag
    WHERE STANDARD_NOTES_ID = l_def_note_rec.STANDARD_NOTES_ID;

Line: 1128

    UPDATE OKE_K_STANDARD_NOTES_TL
    SET
	LAST_UPDATE_DATE = l_def_note_rec.LAST_UPDATE_DATE,
	LAST_UPDATED_BY = l_def_note_rec.LAST_UPDATED_BY,
	LAST_UPDATE_LOGIN = l_def_note_rec.LAST_UPDATE_LOGIN,
	SOURCE_LANG = oke_utils.get_userenv_lang,
	SFWT_FLAG = l_def_note_rec.SFWT_FLAG,
	DESCRIPTION = l_def_note_rec.DESCRIPTION,
	NAME = l_def_note_rec.NAME,
	TEXT = l_def_note_rec.TEXT
    WHERE STANDARD_NOTES_ID = l_def_note_rec.STANDARD_NOTES_ID
    AND userenv('LANG') in (language , source_lang);

Line: 1176

  END update_row;   -- row level update

Line: 1180

  PROCEDURE update_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_note_tbl                     IN note_tbl_type,
    x_note_tbl                     OUT NOCOPY note_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1.0;

Line: 1190

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

Line: 1204

        update_row (
          p_api_version                  => p_api_version,
          p_init_msg_list                => OKE_API.G_FALSE,
          x_return_status                => x_return_status,
          x_msg_count                    => x_msg_count,
          x_msg_data                     => x_msg_data,
          p_note_rec                      => p_note_tbl(i),
          x_note_rec                     => x_note_tbl(i));

Line: 1259

  END update_row;  -- table level update

Line: 1262

  PROCEDURE delete_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_del_id                     IN NUMBER) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1271

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

Line: 1290

    DELETE FROM OKE_K_STANDARD_NOTES_TL
    WHERE STANDARD_NOTES_ID IN (
	SELECT STANDARD_NOTES_ID FROM OKE_K_STANDARD_NOTES_B
	WHERE DELIVERABLE_ID = p_del_id);

Line: 1295

    DELETE FROM OKE_K_STANDARD_NOTES_B
    WHERE DELIVERABLE_ID = p_del_id;

Line: 1331

  END delete_row;

Line: 1334

  PROCEDURE delete_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_cle_id                     IN NUMBER) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1343

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

Line: 1362

    DELETE FROM OKE_K_STANDARD_NOTES_TL
    WHERE STANDARD_NOTES_ID IN (
	SELECT STANDARD_NOTES_ID FROM OKE_K_STANDARD_NOTES_B
	WHERE K_LINE_ID = p_cle_id);

Line: 1367

    DELETE FROM OKE_K_STANDARD_NOTES_B
    WHERE K_LINE_ID = p_cle_id;

Line: 1403

  END delete_row;

Line: 1405

  PROCEDURE delete_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_hdr_id                     IN NUMBER) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1414

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

Line: 1433

    DELETE FROM OKE_K_STANDARD_NOTES_TL
    WHERE STANDARD_NOTES_ID IN (
	SELECT STANDARD_NOTES_ID FROM OKE_K_STANDARD_NOTES_B
	WHERE
		(K_HEADER_ID = p_hdr_id) AND
		(K_LINE_ID IS NULL) AND
		(DELIVERABLE_ID IS NULL));

Line: 1441

    DELETE FROM OKE_K_STANDARD_NOTES_B
    WHERE (K_HEADER_ID = p_hdr_id) AND
	  (K_LINE_ID IS NULL) AND
	  (DELIVERABLE_ID IS NULL);

Line: 1479

  END delete_row;

Line: 1481

	-- row level delete
  PROCEDURE delete_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_note_rec                     IN note_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1491

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

Line: 1509

    DELETE FROM OKE_K_STANDARD_NOTES_B
    WHERE STANDARD_NOTES_ID = l_note_rec.STANDARD_NOTES_ID;

Line: 1512

    DELETE FROM OKE_K_STANDARD_NOTES_TL
    WHERE STANDARD_NOTES_ID = l_note_rec.STANDARD_NOTES_ID;

Line: 1548

  END delete_row;

Line: 1553

  PROCEDURE delete_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_note_tbl                     IN note_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1562

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

Line: 1573

        delete_row (
          p_api_version                  => p_api_version,
          p_init_msg_list                => OKE_API.G_FALSE,
          x_return_status                => x_return_status,
          x_msg_count                    => x_msg_count,
          x_msg_data                     => x_msg_data,
          p_note_rec                      => p_note_tbl(i));

Line: 1629

  END delete_row; -- table level delete

Line: 1811

	SELECT standard_notes_id FROM oke_k_standard_notes_b
	WHERE standard_notes_id = p_note_rec.standard_notes_id
	FOR UPDATE NOWAIT;

Line: 1816

	SELECT standard_notes_id FROM oke_k_standard_notes_tl
	WHERE standard_notes_id = p_note_rec.standard_notes_id
	FOR UPDATE NOWAIT;

Line: 1858

      OKE_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);

Line: 1904

  delete from OKE_K_STANDARD_NOTES_TL T
  where not exists
    (select NULL
    from OKE_K_STANDARD_NOTES_B B
    where B.STANDARD_NOTES_ID = T.STANDARD_NOTES_ID
    );

Line: 1911

  update OKE_K_STANDARD_NOTES_TL T set (
      NAME,
      DESCRIPTION,
      TEXT
    ) = (select
      B.NAME,
      B.DESCRIPTION,
      B.TEXT
    from OKE_K_STANDARD_NOTES_TL B
    where B.STANDARD_NOTES_ID = T.STANDARD_NOTES_ID
    and B.LANGUAGE = T.SOURCE_LANG)
  where (
      T.STANDARD_NOTES_ID,
      T.LANGUAGE
  ) in (select
      SUBT.STANDARD_NOTES_ID,
      SUBT.LANGUAGE
    from OKE_K_STANDARD_NOTES_TL SUBB, OKE_K_STANDARD_NOTES_TL SUBT
    where SUBB.STANDARD_NOTES_ID = SUBT.STANDARD_NOTES_ID
    and SUBB.LANGUAGE = SUBT.SOURCE_LANG
    and (SUBB.NAME <> SUBT.NAME
      or (SUBB.NAME is null and SUBT.NAME is not null)
      or (SUBB.NAME is not null and SUBT.NAME is null)
      or SUBB.DESCRIPTION <> SUBT.DESCRIPTION
      or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
      or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
      or SUBB.TEXT <> SUBT.TEXT
      or (SUBB.TEXT is null and SUBT.TEXT is not null)
      or (SUBB.TEXT is not null and SUBT.TEXT is null)
  ));

Line: 1942

  insert into OKE_K_STANDARD_NOTES_TL (
    STANDARD_NOTES_ID,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN,
    SFWT_FLAG,
    DESCRIPTION,
    NAME,
    TEXT,
    LANGUAGE,
    SOURCE_LANG
  ) select
    B.STANDARD_NOTES_ID,
    B.CREATION_DATE,
    B.CREATED_BY,
    B.LAST_UPDATE_DATE,
    B.LAST_UPDATED_BY,
    B.LAST_UPDATE_LOGIN,
    B.SFWT_FLAG,
    B.DESCRIPTION,
    B.NAME,
    B.TEXT,
    L.LANGUAGE_CODE,
    B.SOURCE_LANG
  from OKE_K_STANDARD_NOTES_TL B, FND_LANGUAGES L
  where L.INSTALLED_FLAG in ('I', 'B')
  and B.LANGUAGE = userenv('LANG')
  and not exists
    (select NULL
    from OKE_K_STANDARD_NOTES_TL T
    where T.STANDARD_NOTES_ID = B.STANDARD_NOTES_ID
    and T.LANGUAGE = L.LANGUAGE_CODE);

Line: 1980

  delete from OKE_K_STANDARD_NOTES_TLH T
  where not exists
    (select NULL
    from OKE_K_STANDARD_NOTES_BH B
    where B.STANDARD_NOTES_ID = T.STANDARD_NOTES_ID
    AND B.MAJOR_VERSION = T.MAJOR_VERSION
    );

Line: 1988

  update OKE_K_STANDARD_NOTES_TLH T set (
      NAME,
      DESCRIPTION,
      TEXT
    ) = (select
      B.NAME,
      B.DESCRIPTION,
      B.TEXT
    from OKE_K_STANDARD_NOTES_TLH B
    where B.STANDARD_NOTES_ID = T.STANDARD_NOTES_ID
    and B.MAJOR_VERSION = T.MAJOR_VERSION
    and B.LANGUAGE = T.SOURCE_LANG)
  where (
      T.STANDARD_NOTES_ID,
      T.MAJOR_VERSION,
      T.LANGUAGE
  ) in (select
      SUBT.STANDARD_NOTES_ID,
      SUBT.MAJOR_VERSION,
      SUBT.LANGUAGE
    from OKE_K_STANDARD_NOTES_TLH SUBB, OKE_K_STANDARD_NOTES_TLH SUBT
    where SUBB.STANDARD_NOTES_ID = SUBT.STANDARD_NOTES_ID
    and SUBB.MAJOR_VERSION = SUBT.MAJOR_VERSION
    and SUBB.LANGUAGE = SUBT.SOURCE_LANG
    and (SUBB.NAME <> SUBT.NAME
      or (SUBB.NAME is null and SUBT.NAME is not null)
      or (SUBB.NAME is not null and SUBT.NAME is null)
      or SUBB.DESCRIPTION <> SUBT.DESCRIPTION
      or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
      or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
      or SUBB.TEXT <> SUBT.TEXT
      or (SUBB.TEXT is null and SUBT.TEXT is not null)
      or (SUBB.TEXT is not null and SUBT.TEXT is null)
  ));

Line: 2023

  insert into OKE_K_STANDARD_NOTES_TLH (
    STANDARD_NOTES_ID,
    MAJOR_VERSION,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN,
    SFWT_FLAG,
    DESCRIPTION,
    NAME,
    TEXT,
    LANGUAGE,
    SOURCE_LANG
  ) select
    B.STANDARD_NOTES_ID,
    B.MAJOR_VERSION,
    B.CREATION_DATE,
    B.CREATED_BY,
    B.LAST_UPDATE_DATE,
    B.LAST_UPDATED_BY,
    B.LAST_UPDATE_LOGIN,
    B.SFWT_FLAG,
    B.DESCRIPTION,
    B.NAME,
    B.TEXT,
    L.LANGUAGE_CODE,
    B.SOURCE_LANG
  from OKE_K_STANDARD_NOTES_TLH B, FND_LANGUAGES L
  where L.INSTALLED_FLAG in ('I', 'B')
  and B.LANGUAGE = userenv('LANG')
  and not exists
    (select NULL
    from OKE_K_STANDARD_NOTES_TLH T
    where T.STANDARD_NOTES_ID = B.STANDARD_NOTES_ID
    and T.MAJOR_VERSION = B.MAJOR_VERSION
    and T.LANGUAGE = L.LANGUAGE_CODE);