eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKE_K_TYPES_PKG SQL Statements

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

Line: 3


procedure INSERT_ROW (
  X_ROWID 			in out NOCOPY VARCHAR2
, X_K_TYPE_CODE 		in 	VARCHAR2
, X_CREATION_DATE 		in 	DATE
, X_CREATED_BY 			in 	NUMBER
, X_LAST_UPDATE_DATE 		in 	DATE
, X_LAST_UPDATED_BY 		in 	NUMBER
, X_LAST_UPDATE_LOGIN 		in 	NUMBER
, X_K_TYPE_NAME 		in 	VARCHAR2
, X_TYPE_CLASS_CODE 		in 	VARCHAR2
, X_INTENT       		in 	VARCHAR2
, X_APPROVAL_PATH_ID            in      NUMBER
, X_DESCRIPTION 		in 	VARCHAR2
, X_START_DATE_ACTIVE 		in 	DATE
, X_END_DATE_ACTIVE   		in 	DATE
, X_ATTRIBUTE_CATEGORY 		in 	VARCHAR2
, X_ATTRIBUTE1 			in 	VARCHAR2
, X_ATTRIBUTE2 			in 	VARCHAR2
, X_ATTRIBUTE3 			in 	VARCHAR2
, X_ATTRIBUTE4 			in 	VARCHAR2
, X_ATTRIBUTE5 			in 	VARCHAR2
, X_ATTRIBUTE6 			in 	VARCHAR2
, X_ATTRIBUTE7 			in 	VARCHAR2
, X_ATTRIBUTE8 			in 	VARCHAR2
, X_ATTRIBUTE9 			in 	VARCHAR2
, X_ATTRIBUTE10 		in 	VARCHAR2
, X_ATTRIBUTE11 		in 	VARCHAR2
, X_ATTRIBUTE12 		in 	VARCHAR2
, X_ATTRIBUTE13 		in 	VARCHAR2
, X_ATTRIBUTE14 		in 	VARCHAR2
, X_ATTRIBUTE15 		in 	VARCHAR2
) is
  cursor C is select ROWID from OKE_K_TYPES_B
    where K_TYPE_CODE = X_K_TYPE_CODE
    ;

Line: 42


  insert into OKE_K_TYPES_B (
  K_TYPE_CODE
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, TYPE_CLASS_CODE
, INTENT
, APPROVAL_PATH_ID
, START_DATE_ACTIVE
, END_DATE_ACTIVE
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
  ) values (
  X_K_TYPE_CODE
, X_CREATION_DATE
, X_CREATED_BY
, X_LAST_UPDATE_DATE
, X_LAST_UPDATED_BY
, X_LAST_UPDATE_LOGIN
, X_TYPE_CLASS_CODE
, X_INTENT
, X_APPROVAL_PATH_ID
, X_START_DATE_ACTIVE
, X_END_DATE_ACTIVE
, X_ATTRIBUTE_CATEGORY
, X_ATTRIBUTE1
, X_ATTRIBUTE2
, X_ATTRIBUTE3
, X_ATTRIBUTE4
, X_ATTRIBUTE5
, X_ATTRIBUTE6
, X_ATTRIBUTE7
, X_ATTRIBUTE8
, X_ATTRIBUTE9
, X_ATTRIBUTE10
, X_ATTRIBUTE11
, X_ATTRIBUTE12
, X_ATTRIBUTE13
, X_ATTRIBUTE14
, X_ATTRIBUTE15
);

Line: 100


  insert into OKE_K_TYPES_TL (
  K_TYPE_CODE
, LANGUAGE
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, K_TYPE_NAME
, DESCRIPTION
, SOURCE_LANG
  ) select
  X_K_TYPE_CODE
, L.LANGUAGE_CODE
, X_CREATION_DATE
, X_CREATED_BY
, X_LAST_UPDATE_DATE
, X_LAST_UPDATED_BY
, X_LAST_UPDATE_LOGIN
, X_K_TYPE_NAME
, X_DESCRIPTION
, userenv('LANG')
  from FND_LANGUAGES L
 where L.INSTALLED_FLAG in ('I', 'B')
   and not exists
    (select NULL
    from OKE_K_TYPES_TL T
   where T.K_TYPE_CODE = X_K_TYPE_CODE
     and T.LANGUAGE = L.LANGUAGE_CODE)
;

Line: 135


    OKE_NUMBER_OPTIONS_PKG.INSERT_ROW
    ( X_ROWID                     => Number_Option_ROWID
    , X_K_TYPE_CODE               => X_K_TYPE_CODE
    , X_BUY_OR_SELL               => 'B'
    , X_CREATION_DATE             => X_CREATION_DATE
    , X_CREATED_BY                => X_CREATED_BY
    , X_LAST_UPDATE_DATE          => X_LAST_UPDATE_DATE
    , X_LAST_UPDATED_BY           => X_LAST_UPDATED_BY
    , X_LAST_UPDATE_LOGIN         => X_LAST_UPDATE_LOGIN
    , X_CONTRACT_NUM_MODE         => 'MANUAL'
    , X_MANUAL_CONTRACT_NUM_TYPE  => 'ALPHANUMERIC'
    , X_NEXT_CONTRACT_NUM         => NULL
    , X_CONTRACT_NUM_INCREMENT    => NULL
    , X_CONTRACT_NUM_WIDTH        => NULL
    , X_CHGREQ_NUM_MODE           => 'MANUAL'
    , X_MANUAL_CHGREQ_NUM_TYPE    => 'ALPHANUMERIC'
    , X_CHGREQ_NUM_START_NUMBER   => NULL
    , X_CHGREQ_NUM_INCREMENT      => NULL
    , X_CHGREQ_NUM_WIDTH          => NULL
    , X_LINE_NUM_START_NUMBER     => 1
    , X_LINE_NUM_INCREMENT        => 1
    , X_LINE_NUM_WIDTH            => NULL
    , X_SUBLINE_NUM_START_NUMBER  => 1
    , X_SUBLINE_NUM_INCREMENT     => 1
    , X_SUBLINE_NUM_WIDTH         => NULL
    , X_DELV_NUM_START_NUMBER     => 1
    , X_DELV_NUM_INCREMENT        => 1
    , X_DELV_NUM_WIDTH            => NULL
    , X_ATTRIBUTE_CATEGORY        => NULL
    , X_ATTRIBUTE1                => NULL
    , X_ATTRIBUTE2                => NULL
    , X_ATTRIBUTE3                => NULL
    , X_ATTRIBUTE4                => NULL
    , X_ATTRIBUTE5                => NULL
    , X_ATTRIBUTE6                => NULL
    , X_ATTRIBUTE7                => NULL
    , X_ATTRIBUTE8                => NULL
    , X_ATTRIBUTE9                => NULL
    , X_ATTRIBUTE10               => NULL
    , X_ATTRIBUTE11               => NULL
    , X_ATTRIBUTE12               => NULL
    , X_ATTRIBUTE13               => NULL
    , X_ATTRIBUTE14               => NULL
    , X_ATTRIBUTE15               => NULL
    );

Line: 183


    OKE_NUMBER_OPTIONS_PKG.INSERT_ROW
    ( X_ROWID                     => Number_Option_ROWID
    , X_K_TYPE_CODE               => X_K_TYPE_CODE
    , X_BUY_OR_SELL               => 'S'
    , X_CREATION_DATE             => X_CREATION_DATE
    , X_CREATED_BY                => X_CREATED_BY
    , X_LAST_UPDATE_DATE          => X_LAST_UPDATE_DATE
    , X_LAST_UPDATED_BY           => X_LAST_UPDATED_BY
    , X_LAST_UPDATE_LOGIN         => X_LAST_UPDATE_LOGIN
    , X_CONTRACT_NUM_MODE         => 'MANUAL'
    , X_MANUAL_CONTRACT_NUM_TYPE  => 'ALPHANUMERIC'
    , X_NEXT_CONTRACT_NUM         => NULL
    , X_CONTRACT_NUM_INCREMENT    => NULL
    , X_CONTRACT_NUM_WIDTH        => NULL
    , X_CHGREQ_NUM_MODE           => 'MANUAL'
    , X_MANUAL_CHGREQ_NUM_TYPE    => 'ALPHANUMERIC'
    , X_CHGREQ_NUM_START_NUMBER   => NULL
    , X_CHGREQ_NUM_INCREMENT      => NULL
    , X_CHGREQ_NUM_WIDTH          => NULL
    , X_LINE_NUM_START_NUMBER     => 1
    , X_LINE_NUM_INCREMENT        => 1
    , X_LINE_NUM_WIDTH            => NULL
    , X_SUBLINE_NUM_START_NUMBER  => 1
    , X_SUBLINE_NUM_INCREMENT     => 1
    , X_SUBLINE_NUM_WIDTH         => NULL
    , X_DELV_NUM_START_NUMBER     => 1
    , X_DELV_NUM_INCREMENT        => 1
    , X_DELV_NUM_WIDTH            => NULL
    , X_ATTRIBUTE_CATEGORY        => NULL
    , X_ATTRIBUTE1                => NULL
    , X_ATTRIBUTE2                => NULL
    , X_ATTRIBUTE3                => NULL
    , X_ATTRIBUTE4                => NULL
    , X_ATTRIBUTE5                => NULL
    , X_ATTRIBUTE6                => NULL
    , X_ATTRIBUTE7                => NULL
    , X_ATTRIBUTE8                => NULL
    , X_ATTRIBUTE9                => NULL
    , X_ATTRIBUTE10               => NULL
    , X_ATTRIBUTE11               => NULL
    , X_ATTRIBUTE12               => NULL
    , X_ATTRIBUTE13               => NULL
    , X_ATTRIBUTE14               => NULL
    , X_ATTRIBUTE15               => NULL
    );

Line: 239


end INSERT_ROW;

Line: 267


  cursor c is select
       K_TYPE_CODE
     , TYPE_CLASS_CODE
     , INTENT
     , APPROVAL_PATH_ID
     , START_DATE_ACTIVE
     , END_DATE_ACTIVE
     , ATTRIBUTE_CATEGORY
     , ATTRIBUTE1
     , ATTRIBUTE2
     , ATTRIBUTE3
     , ATTRIBUTE4
     , ATTRIBUTE5
     , ATTRIBUTE6
     , ATTRIBUTE7
     , ATTRIBUTE8
     , ATTRIBUTE9
     , ATTRIBUTE10
     , ATTRIBUTE11
     , ATTRIBUTE12
     , ATTRIBUTE13
     , ATTRIBUTE14
     , ATTRIBUTE15
    from OKE_K_TYPES_B
    where K_TYPE_CODE = X_K_TYPE_CODE
    for update of K_TYPE_CODE nowait;

Line: 295


  cursor c1 is select
      K_TYPE_NAME
     ,DESCRIPTION
     ,decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
    from OKE_K_TYPES_TL
    where K_TYPE_CODE= X_K_TYPE_CODE
    and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
    for update of K_TYPE_CODE nowait;

Line: 310


    fnd_message.set_name('FND', 'FORM_RECORD_DELETED');

Line: 385


procedure UPDATE_ROW (
  X_K_TYPE_CODE 		in 	VARCHAR2
, X_LAST_UPDATE_DATE 		in 	DATE
, X_LAST_UPDATED_BY 		in 	NUMBER
, X_LAST_UPDATE_LOGIN 		in 	NUMBER
, X_K_TYPE_NAME 		in 	VARCHAR2
, X_TYPE_CLASS_CODE 		in 	VARCHAR2
, X_INTENT       		in 	VARCHAR2
, X_APPROVAL_PATH_ID            in      NUMBER
, X_DESCRIPTION 		in 	VARCHAR2
, X_START_DATE_ACTIVE 		in 	DATE
, X_END_DATE_ACTIVE   		in 	DATE
, X_ATTRIBUTE_CATEGORY 		in 	VARCHAR2
, X_ATTRIBUTE1 			in 	VARCHAR2
, X_ATTRIBUTE2 			in 	VARCHAR2
, X_ATTRIBUTE3 			in 	VARCHAR2
, X_ATTRIBUTE4 			in 	VARCHAR2
, X_ATTRIBUTE5 			in 	VARCHAR2
, X_ATTRIBUTE6 			in 	VARCHAR2
, X_ATTRIBUTE7 			in 	VARCHAR2
, X_ATTRIBUTE8 			in 	VARCHAR2
, X_ATTRIBUTE9 			in 	VARCHAR2
, X_ATTRIBUTE10 		in 	VARCHAR2
, X_ATTRIBUTE11 		in 	VARCHAR2
, X_ATTRIBUTE12 		in 	VARCHAR2
, X_ATTRIBUTE13 		in 	VARCHAR2
, X_ATTRIBUTE14 		in 	VARCHAR2
, X_ATTRIBUTE15 		in 	VARCHAR2
) is
begin
  update OKE_K_TYPES_B set
  LAST_UPDATE_DATE      	= X_LAST_UPDATE_DATE
, LAST_UPDATED_BY 		= X_LAST_UPDATED_BY
, LAST_UPDATE_LOGIN   		= X_LAST_UPDATE_LOGIN
, TYPE_CLASS_CODE 	        = X_TYPE_CLASS_CODE
, INTENT	        	= X_INTENT
, APPROVAL_PATH_ID              = X_APPROVAL_PATH_ID
, START_DATE_ACTIVE 		= X_START_DATE_ACTIVE
, END_DATE_ACTIVE   		= X_END_DATE_ACTIVE
, ATTRIBUTE_CATEGORY		= X_ATTRIBUTE_CATEGORY
, ATTRIBUTE1            	= X_ATTRIBUTE1
, ATTRIBUTE2			= X_ATTRIBUTE2
, ATTRIBUTE3    		= X_ATTRIBUTE3
, ATTRIBUTE4        		= X_ATTRIBUTE4
, ATTRIBUTE5            	= X_ATTRIBUTE5
, ATTRIBUTE6			= X_ATTRIBUTE6
, ATTRIBUTE7    		= X_ATTRIBUTE7
, ATTRIBUTE8        		= X_ATTRIBUTE8
, ATTRIBUTE9            	= X_ATTRIBUTE9
, ATTRIBUTE10           	= X_ATTRIBUTE10
, ATTRIBUTE11			= X_ATTRIBUTE11
, ATTRIBUTE12    		= X_ATTRIBUTE12
, ATTRIBUTE13        		= X_ATTRIBUTE13
, ATTRIBUTE14           	= X_ATTRIBUTE14
, ATTRIBUTE15           	= X_ATTRIBUTE15
where K_TYPE_CODE 		= X_K_TYPE_CODE
;

Line: 447


  update OKE_K_TYPES_TL set
  LAST_UPDATE_DATE      = X_LAST_UPDATE_DATE
, LAST_UPDATED_BY 	= X_LAST_UPDATED_BY
, LAST_UPDATE_LOGIN   	= X_LAST_UPDATE_LOGIN
, K_TYPE_NAME 	        = X_K_TYPE_NAME
, DESCRIPTION       	= X_DESCRIPTION
, SOURCE_LANG 		= userenv('LANG')
where K_TYPE_CODE       = X_K_TYPE_CODE
  and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
;

Line: 472


    OKE_NUMBER_OPTIONS_PKG.INSERT_ROW
    ( X_ROWID                     => Number_Option_ROWID
    , X_K_TYPE_CODE               => X_K_TYPE_CODE
    , X_BUY_OR_SELL               => 'S'
    , X_CREATION_DATE             => X_LAST_UPDATE_DATE
    , X_CREATED_BY                => X_LAST_UPDATED_BY
    , X_LAST_UPDATE_DATE          => X_LAST_UPDATE_DATE
    , X_LAST_UPDATED_BY           => X_LAST_UPDATED_BY
    , X_LAST_UPDATE_LOGIN         => X_LAST_UPDATE_LOGIN
    , X_CONTRACT_NUM_MODE         => 'MANUAL'
    , X_MANUAL_CONTRACT_NUM_TYPE  => 'ALPHANUMERIC'
    , X_NEXT_CONTRACT_NUM         => NULL
    , X_CONTRACT_NUM_INCREMENT    => NULL
    , X_CONTRACT_NUM_WIDTH        => NULL
    , X_CHGREQ_NUM_MODE           => 'MANUAL'
    , X_MANUAL_CHGREQ_NUM_TYPE    => 'ALPHANUMERIC'
    , X_CHGREQ_NUM_START_NUMBER   => NULL
    , X_CHGREQ_NUM_INCREMENT      => NULL
    , X_CHGREQ_NUM_WIDTH          => NULL
    , X_LINE_NUM_START_NUMBER     => 1
    , X_LINE_NUM_INCREMENT        => 1
    , X_LINE_NUM_WIDTH            => NULL
    , X_SUBLINE_NUM_START_NUMBER  => 1
    , X_SUBLINE_NUM_INCREMENT     => 1
    , X_SUBLINE_NUM_WIDTH         => NULL
    , X_DELV_NUM_START_NUMBER     => 1
    , X_DELV_NUM_INCREMENT        => 1
    , X_DELV_NUM_WIDTH            => NULL
    , X_ATTRIBUTE_CATEGORY        => NULL
    , X_ATTRIBUTE1                => NULL
    , X_ATTRIBUTE2                => NULL
    , X_ATTRIBUTE3                => NULL
    , X_ATTRIBUTE4                => NULL
    , X_ATTRIBUTE5                => NULL
    , X_ATTRIBUTE6                => NULL
    , X_ATTRIBUTE7                => NULL
    , X_ATTRIBUTE8                => NULL
    , X_ATTRIBUTE9                => NULL
    , X_ATTRIBUTE10               => NULL
    , X_ATTRIBUTE11               => NULL
    , X_ATTRIBUTE12               => NULL
    , X_ATTRIBUTE13               => NULL
    , X_ATTRIBUTE14               => NULL
    , X_ATTRIBUTE15               => NULL
    );

Line: 523


    OKE_NUMBER_OPTIONS_PKG.INSERT_ROW
    ( X_ROWID                     => Number_Option_ROWID
    , X_K_TYPE_CODE               => X_K_TYPE_CODE
    , X_BUY_OR_SELL               => 'B'
    , X_CREATION_DATE             => X_LAST_UPDATE_DATE
    , X_CREATED_BY                => X_LAST_UPDATED_BY
    , X_LAST_UPDATE_DATE          => X_LAST_UPDATE_DATE
    , X_LAST_UPDATED_BY           => X_LAST_UPDATED_BY
    , X_LAST_UPDATE_LOGIN         => X_LAST_UPDATE_LOGIN
    , X_CONTRACT_NUM_MODE         => 'MANUAL'
    , X_MANUAL_CONTRACT_NUM_TYPE  => 'ALPHANUMERIC'
    , X_NEXT_CONTRACT_NUM         => NULL
    , X_CONTRACT_NUM_INCREMENT    => NULL
    , X_CONTRACT_NUM_WIDTH        => NULL
    , X_CHGREQ_NUM_MODE           => 'MANUAL'
    , X_MANUAL_CHGREQ_NUM_TYPE    => 'ALPHANUMERIC'
    , X_CHGREQ_NUM_START_NUMBER   => NULL
    , X_CHGREQ_NUM_INCREMENT      => NULL
    , X_CHGREQ_NUM_WIDTH          => NULL
    , X_LINE_NUM_START_NUMBER     => 1
    , X_LINE_NUM_INCREMENT        => 1
    , X_LINE_NUM_WIDTH            => NULL
    , X_SUBLINE_NUM_START_NUMBER  => 1
    , X_SUBLINE_NUM_INCREMENT     => 1
    , X_SUBLINE_NUM_WIDTH         => NULL
    , X_DELV_NUM_START_NUMBER     => 1
    , X_DELV_NUM_INCREMENT        => 1
    , X_DELV_NUM_WIDTH            => NULL
    , X_ATTRIBUTE_CATEGORY        => NULL
    , X_ATTRIBUTE1                => NULL
    , X_ATTRIBUTE2                => NULL
    , X_ATTRIBUTE3                => NULL
    , X_ATTRIBUTE4                => NULL
    , X_ATTRIBUTE5                => NULL
    , X_ATTRIBUTE6                => NULL
    , X_ATTRIBUTE7                => NULL
    , X_ATTRIBUTE8                => NULL
    , X_ATTRIBUTE9                => NULL
    , X_ATTRIBUTE10               => NULL
    , X_ATTRIBUTE11               => NULL
    , X_ATTRIBUTE12               => NULL
    , X_ATTRIBUTE13               => NULL
    , X_ATTRIBUTE14               => NULL
    , X_ATTRIBUTE15               => NULL
    );

Line: 578


    OKE_NUMBER_OPTIONS_PKG.INSERT_ROW
    ( X_ROWID                     => Number_Option_ROWID
    , X_K_TYPE_CODE               => X_K_TYPE_CODE
    , X_BUY_OR_SELL               => 'S'
    , X_CREATION_DATE             => X_LAST_UPDATE_DATE
    , X_CREATED_BY                => X_LAST_UPDATED_BY
    , X_LAST_UPDATE_DATE          => X_LAST_UPDATE_DATE
    , X_LAST_UPDATED_BY           => X_LAST_UPDATED_BY
    , X_LAST_UPDATE_LOGIN         => X_LAST_UPDATE_LOGIN
    , X_CONTRACT_NUM_MODE         => 'MANUAL'
    , X_MANUAL_CONTRACT_NUM_TYPE  => 'ALPHANUMERIC'
    , X_NEXT_CONTRACT_NUM         => NULL
    , X_CONTRACT_NUM_INCREMENT    => NULL
    , X_CONTRACT_NUM_WIDTH        => NULL
    , X_CHGREQ_NUM_MODE           => 'MANUAL'
    , X_MANUAL_CHGREQ_NUM_TYPE    => 'ALPHANUMERIC'
    , X_CHGREQ_NUM_START_NUMBER   => NULL
    , X_CHGREQ_NUM_INCREMENT      => NULL
    , X_CHGREQ_NUM_WIDTH          => NULL
    , X_LINE_NUM_START_NUMBER     => 1
    , X_LINE_NUM_INCREMENT        => 1
    , X_LINE_NUM_WIDTH            => NULL
    , X_SUBLINE_NUM_START_NUMBER  => 1
    , X_SUBLINE_NUM_INCREMENT     => 1
    , X_SUBLINE_NUM_WIDTH         => NULL
    , X_DELV_NUM_START_NUMBER     => 1
    , X_DELV_NUM_INCREMENT        => 1
    , X_DELV_NUM_WIDTH            => NULL
    , X_ATTRIBUTE_CATEGORY        => NULL
    , X_ATTRIBUTE1                => NULL
    , X_ATTRIBUTE2                => NULL
    , X_ATTRIBUTE3                => NULL
    , X_ATTRIBUTE4                => NULL
    , X_ATTRIBUTE5                => NULL
    , X_ATTRIBUTE6                => NULL
    , X_ATTRIBUTE7                => NULL
    , X_ATTRIBUTE8                => NULL
    , X_ATTRIBUTE9                => NULL
    , X_ATTRIBUTE10               => NULL
    , X_ATTRIBUTE11               => NULL
    , X_ATTRIBUTE12               => NULL
    , X_ATTRIBUTE13               => NULL
    , X_ATTRIBUTE14               => NULL
    , X_ATTRIBUTE15               => NULL
    );

Line: 631


    OKE_NUMBER_OPTIONS_PKG.INSERT_ROW
    ( X_ROWID                     => Number_Option_ROWID
    , X_K_TYPE_CODE               => X_K_TYPE_CODE
    , X_BUY_OR_SELL               => 'B'
    , X_CREATION_DATE             => X_LAST_UPDATE_DATE
    , X_CREATED_BY                => X_LAST_UPDATED_BY
    , X_LAST_UPDATE_DATE          => X_LAST_UPDATE_DATE
    , X_LAST_UPDATED_BY           => X_LAST_UPDATED_BY
    , X_LAST_UPDATE_LOGIN         => X_LAST_UPDATE_LOGIN
    , X_CONTRACT_NUM_MODE         => 'MANUAL'
    , X_MANUAL_CONTRACT_NUM_TYPE  => 'ALPHANUMERIC'
    , X_NEXT_CONTRACT_NUM         => NULL
    , X_CONTRACT_NUM_INCREMENT    => NULL
    , X_CONTRACT_NUM_WIDTH        => NULL
    , X_CHGREQ_NUM_MODE           => 'MANUAL'
    , X_MANUAL_CHGREQ_NUM_TYPE    => 'ALPHANUMERIC'
    , X_CHGREQ_NUM_START_NUMBER   => NULL
    , X_CHGREQ_NUM_INCREMENT      => NULL
    , X_CHGREQ_NUM_WIDTH          => NULL
    , X_LINE_NUM_START_NUMBER     => 1
    , X_LINE_NUM_INCREMENT        => 1
    , X_LINE_NUM_WIDTH            => NULL
    , X_SUBLINE_NUM_START_NUMBER  => 1
    , X_SUBLINE_NUM_INCREMENT     => 1
    , X_SUBLINE_NUM_WIDTH         => NULL
    , X_DELV_NUM_START_NUMBER     => 1
    , X_DELV_NUM_INCREMENT        => 1
    , X_DELV_NUM_WIDTH            => NULL
    , X_ATTRIBUTE_CATEGORY        => NULL
    , X_ATTRIBUTE1                => NULL
    , X_ATTRIBUTE2                => NULL
    , X_ATTRIBUTE3                => NULL
    , X_ATTRIBUTE4                => NULL
    , X_ATTRIBUTE5                => NULL
    , X_ATTRIBUTE6                => NULL
    , X_ATTRIBUTE7                => NULL
    , X_ATTRIBUTE8                => NULL
    , X_ATTRIBUTE9                => NULL
    , X_ATTRIBUTE10               => NULL
    , X_ATTRIBUTE11               => NULL
    , X_ATTRIBUTE12               => NULL
    , X_ATTRIBUTE13               => NULL
    , X_ATTRIBUTE14               => NULL
    , X_ATTRIBUTE15               => NULL
    );

Line: 679


end UPDATE_ROW;

Line: 684


  delete from OKE_K_TYPES_TL T
  where not exists
    (select NULL
    from OKE_K_TYPES_B B
    where B.K_TYPE_CODE = T.K_TYPE_CODE
    );

Line: 691


  update OKE_K_TYPES_TL T set (
      K_TYPE_NAME,
      DESCRIPTION
    ) = (select
      B.K_TYPE_NAME,
      B.DESCRIPTION
    from OKE_K_TYPES_TL B
    where B.K_TYPE_CODE = T.K_TYPE_CODE
    and B.LANGUAGE = T.SOURCE_LANG)
  where (
      T.K_TYPE_CODE,
      T.LANGUAGE
  ) in (select
      SUBT.K_TYPE_CODE,
      SUBT.LANGUAGE
    from OKE_K_TYPES_TL SUBB, OKE_K_TYPES_TL SUBT
    where SUBB.K_TYPE_CODE = SUBT.K_TYPE_CODE
    and SUBB.LANGUAGE = SUBT.SOURCE_LANG
    and (SUBB.K_TYPE_NAME <> SUBT.K_TYPE_NAME
      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)
  ));

Line: 715


  insert into OKE_K_TYPES_TL (
    K_TYPE_CODE,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN,
    K_TYPE_NAME,
    DESCRIPTION,
    LANGUAGE,
    SOURCE_LANG
  ) select
    B.K_TYPE_CODE,
    B.CREATION_DATE,
    B.CREATED_BY,
    B.LAST_UPDATE_DATE,
    B.LAST_UPDATED_BY,
    B.LAST_UPDATE_LOGIN,
    B.K_TYPE_NAME,
    B.DESCRIPTION,
    L.LANGUAGE_CODE,
    B.SOURCE_LANG
  from OKE_K_TYPES_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_TYPES_TL T
    where T.K_TYPE_CODE = B.K_TYPE_CODE
    and T.LANGUAGE = L.LANGUAGE_CODE);