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.OKC_BUSINESS_VARIABLES_PVT SQL Statements

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

Line: 16


      Select Decode(format_type,'C','V','X','D',format_type) format_type
	 From fnd_flex_value_sets
	 Where flex_value_set_id = lc_value_set_id
	 And validation_type IN ('F','N','I');

Line: 36


   procedure INSERT_ROW (
     X_ROWID in out NOCOPY VARCHAR2,
     X_VARIABLE_CODE in VARCHAR2,
     X_VARIABLE_DEFAULT_VALUE in VARCHAR2,
     X_VARIABLE_DATATYPE in VARCHAR2,
     X_OBJECT_VERSION_NUMBER in NUMBER,
     X_VARIABLE_TYPE in VARCHAR2,
     X_EXTERNAL_YN in VARCHAR2,
     X_APPLICATION_ID in NUMBER,
     X_VARIABLE_INTENT in VARCHAR2,
     X_CONTRACT_EXPERT_YN in VARCHAR2,
     X_DISABLED_YN in VARCHAR2,
     X_VALUE_SET_ID in NUMBER,
     X_ORIG_SYSTEM_REFERENCE_CODE in VARCHAR2 DEFAULT NULL,
	X_ORIG_SYSTEM_REFERENCE_ID1 in VARCHAR2 DEFAULT NULL,
	X_ORIG_SYSTEM_REFERENCE_ID2 in VARCHAR2 DEFAULT NULL,
	X_DATE_PUBLISHED in DATE DEFAULT NULL,
     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,
     X_VARIABLE_NAME in VARCHAR2,
     X_DESCRIPTION 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_XPRT_VALUE_SET_NAME in VARCHAR2,
     X_LINE_LEVEL_FLAG in VARCHAR2,
     X_PROCEDURE_NAME in VARCHAR2,
     X_VARIABLE_SOURCE in VARCHAR2
   ) is
     cursor C is select ROWID from OKC_BUS_VARIABLES_B
       where VARIABLE_CODE = X_VARIABLE_CODE
       ;

Line: 90


     insert into OKC_BUS_VARIABLES_B (
       VARIABLE_DEFAULT_VALUE,
       VARIABLE_DATATYPE,
       VARIABLE_CODE,
       OBJECT_VERSION_NUMBER,
       VARIABLE_TYPE,
       EXTERNAL_YN,
       APPLICATION_ID,
       VARIABLE_INTENT,
       CONTRACT_EXPERT_YN,
       DISABLED_YN,
       VALUE_SET_ID,
       ORIG_SYSTEM_REFERENCE_CODE,
	  ORIG_SYSTEM_REFERENCE_ID1,
	  ORIG_SYSTEM_REFERENCE_ID2,
	  DATE_PUBLISHED,
       ATTRIBUTE_CATEGORY,
       ATTRIBUTE1,
       ATTRIBUTE2,
       ATTRIBUTE3,
       ATTRIBUTE4,
       ATTRIBUTE5,
       ATTRIBUTE6,
       ATTRIBUTE7,
       ATTRIBUTE8,
       ATTRIBUTE9,
       ATTRIBUTE10,
       ATTRIBUTE11,
       ATTRIBUTE12,
       ATTRIBUTE13,
       ATTRIBUTE14,
       ATTRIBUTE15,
       CREATION_DATE,
       CREATED_BY,
       LAST_UPDATE_DATE,
       LAST_UPDATED_BY,
       LAST_UPDATE_LOGIN,
       XPRT_VALUE_SET_NAME,
       LINE_LEVEL_FLAG,
       PROCEDURE_NAME,
       VARIABLE_SOURCE
     ) values (
       X_VARIABLE_DEFAULT_VALUE,
       L_VARIABLE_DATATYPE,
       X_VARIABLE_CODE,
       X_OBJECT_VERSION_NUMBER,
       X_VARIABLE_TYPE,
       X_EXTERNAL_YN,
       X_APPLICATION_ID,
       X_VARIABLE_INTENT,
       X_CONTRACT_EXPERT_YN,
       X_DISABLED_YN,
       X_VALUE_SET_ID,
       X_ORIG_SYSTEM_REFERENCE_CODE,
	  X_ORIG_SYSTEM_REFERENCE_ID1,
	  X_ORIG_SYSTEM_REFERENCE_ID2,
	  X_DATE_PUBLISHED,
       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,
       X_CREATION_DATE,
       X_CREATED_BY,
       X_LAST_UPDATE_DATE,
       X_LAST_UPDATED_BY,
       X_LAST_UPDATE_LOGIN,
       X_XPRT_VALUE_SET_NAME,
       X_LINE_LEVEL_FLAG,
       X_PROCEDURE_NAME,
       X_VARIABLE_SOURCE

     );

Line: 175


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

Line: 213


   end INSERT_ROW;

Line: 254


     cursor c is select
         VARIABLE_DEFAULT_VALUE,
         VARIABLE_DATATYPE,
         OBJECT_VERSION_NUMBER,
         VARIABLE_TYPE,
         EXTERNAL_YN,
         APPLICATION_ID,
         VARIABLE_INTENT,
         CONTRACT_EXPERT_YN,
         DISABLED_YN,
         VALUE_SET_ID,
         ORIG_SYSTEM_REFERENCE_CODE,
	    ORIG_SYSTEM_REFERENCE_ID1,
	    ORIG_SYSTEM_REFERENCE_ID2,
	    DATE_PUBLISHED,
         ATTRIBUTE_CATEGORY,
         ATTRIBUTE1,
         ATTRIBUTE2,
         ATTRIBUTE3,
         ATTRIBUTE4,
         ATTRIBUTE5,
         ATTRIBUTE6,
         ATTRIBUTE7,
         ATTRIBUTE8,
         ATTRIBUTE9,
         ATTRIBUTE10,
         ATTRIBUTE11,
         ATTRIBUTE12,
         ATTRIBUTE13,
         ATTRIBUTE14,
         ATTRIBUTE15,
         XPRT_VALUE_SET_NAME,
         LINE_LEVEL_FLAG,
         PROCEDURE_NAME,
         VARIABLE_SOURCE
       from OKC_BUS_VARIABLES_B
       where VARIABLE_CODE = X_VARIABLE_CODE
       for update of VARIABLE_CODE nowait;

Line: 294


     cursor c1 is select
         VARIABLE_NAME,
         DESCRIPTION,
         decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
       from OKC_BUS_VARIABLES_TL
       where VARIABLE_CODE = X_VARIABLE_CODE
       and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
       for update of VARIABLE_CODE nowait;

Line: 307


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

Line: 396


   procedure UPDATE_ROW (
     X_VARIABLE_CODE in VARCHAR2,
     X_VARIABLE_DEFAULT_VALUE in VARCHAR2,
     X_VARIABLE_DATATYPE in VARCHAR2,
     X_OBJECT_VERSION_NUMBER in NUMBER,
     X_VARIABLE_TYPE in VARCHAR2,
     X_EXTERNAL_YN in VARCHAR2,
     X_APPLICATION_ID in NUMBER,
     X_VARIABLE_INTENT in VARCHAR2,
     X_CONTRACT_EXPERT_YN in VARCHAR2,
     X_DISABLED_YN in VARCHAR2,
     X_VALUE_SET_ID in NUMBER,
     X_ORIG_SYSTEM_REFERENCE_CODE in VARCHAR2,
	X_ORIG_SYSTEM_REFERENCE_ID1 in VARCHAR2,
	X_ORIG_SYSTEM_REFERENCE_ID2 in VARCHAR2,
	X_DATE_PUBLISHED 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,
     X_VARIABLE_NAME in VARCHAR2,
     X_DESCRIPTION in VARCHAR2,
     X_LAST_UPDATE_DATE in DATE,
     X_LAST_UPDATED_BY in NUMBER,
     X_LAST_UPDATE_LOGIN in NUMBER,
     X_XPRT_VALUE_SET_NAME in VARCHAR2,
     X_LINE_LEVEL_FLAG in VARCHAR2,
     X_PROCEDURE_NAME in VARCHAR2,
     X_VARIABLE_SOURCE in VARCHAR2
   ) is
     L_VARIABLE_DATATYPE OKC_BUS_VARIABLES_B.VARIABLE_DATATYPE%TYPE;

Line: 442


     update OKC_BUS_VARIABLES_B set
       VARIABLE_DEFAULT_VALUE = X_VARIABLE_DEFAULT_VALUE,
       VARIABLE_DATATYPE = L_VARIABLE_DATATYPE,
       OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
       VARIABLE_TYPE = X_VARIABLE_TYPE,
       EXTERNAL_YN = X_EXTERNAL_YN,
       APPLICATION_ID = X_APPLICATION_ID,
       VARIABLE_INTENT = X_VARIABLE_INTENT,
       CONTRACT_EXPERT_YN = X_CONTRACT_EXPERT_YN,
       DISABLED_YN = X_DISABLED_YN,
       VALUE_SET_ID = X_VALUE_SET_ID,
       ORIG_SYSTEM_REFERENCE_CODE = X_ORIG_SYSTEM_REFERENCE_CODE,
	  ORIG_SYSTEM_REFERENCE_ID1  = X_ORIG_SYSTEM_REFERENCE_ID1,
	  ORIG_SYSTEM_REFERENCE_ID2  = X_ORIG_SYSTEM_REFERENCE_ID2,
	  DATE_PUBLISHED = X_DATE_PUBLISHED,
       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,
       LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
       LAST_UPDATED_BY = X_LAST_UPDATED_BY,
       LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
       XPRT_VALUE_SET_NAME =X_XPRT_VALUE_SET_NAME,
       LINE_LEVEL_FLAG = X_LINE_LEVEL_FLAG,
       PROCEDURE_NAME = X_PROCEDURE_NAME,
       VARIABLE_SOURCE = X_VARIABLE_SOURCE
     where VARIABLE_CODE = X_VARIABLE_CODE;

Line: 486


     update OKC_BUS_VARIABLES_TL set
       VARIABLE_NAME = X_VARIABLE_NAME,
       DESCRIPTION = X_DESCRIPTION,
       LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
       LAST_UPDATED_BY = X_LAST_UPDATED_BY,
       LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
       SOURCE_LANG = userenv('LANG')
     where VARIABLE_CODE = X_VARIABLE_CODE
     and userenv('LANG') in (LANGUAGE, SOURCE_LANG);

Line: 499


   end UPDATE_ROW;

Line: 501


   procedure DELETE_ROW (
     X_VARIABLE_CODE in VARCHAR2
   ) is
   l_existing_variables_tbl     variable_code_tbl_type;

Line: 507


          SELECT VARIABLE_CODE FROM OKC_VARIABLE_DOC_TYPES
             WHERE VARIABLE_CODE = cp_variable_code;

Line: 510


     delete from OKC_BUS_VARIABLES_TL
     where VARIABLE_CODE = X_VARIABLE_CODE;

Line: 518


     delete from OKC_BUS_VARIABLES_B
     where VARIABLE_CODE = X_VARIABLE_CODE;

Line: 531


                DELETE FROM OKC_VARIABLE_DOC_TYPES
                 WHERE VARIABLE_CODE = l_existing_variables_tbl(i);

Line: 542


        okc_debug.log('1750: Leaving DELETE_ROW in OKC_BUSINESS_VARIABLES_PVT because of EXCEPTION: '||sqlerrm, 2);

Line: 554


   end DELETE_ROW;

Line: 559


     delete from OKC_BUS_VARIABLES_TL T
     where not exists
       (select NULL
       from OKC_BUS_VARIABLES_B B
       where B.VARIABLE_CODE = T.VARIABLE_CODE
       );

Line: 566


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

Line: 590


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