DBA Data[Home] [Help]

APPS.BSC_WEB_ADI_LOADER_PKG SQL Statements

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

Line: 42

  l_stmt := 'INSERT INTO BNE_INTERFACES_B (APPLICATION_ID, INTERFACE_CODE,
              OBJECT_VERSION_NUMBER, INTEGRATOR_APP_ID, INTEGRATOR_CODE,
              INTERFACE_NAME, UPLOAD_TYPE, UPLOAD_OBJ_NAME, UPLOAD_PARAM_LIST_APP_ID,
              UPLOAD_PARAM_LIST_CODE, UPLOAD_ORDER, CREATED_BY, CREATION_DATE,
              LAST_UPDATED_BY, 	LAST_UPDATE_LOGIN, LAST_UPDATE_DATE )
     	    VALUES ( 271,'''|| TABLE_NAME ||'_INTF'', 1, 271, '''|| TABLE_NAME ||'_INTG'', '''||TABLE_NAME ||''', 1, NULL, NULL
              , NULL, NULL, 1355,  sysdate, 1355, NULL,  sysdate)';
Line: 52

  l_stmt := 'INSERT INTO BNE_INTERFACES_TL ( APPLICATION_ID, INTERFACE_CODE, LANGUAGE,
              SOURCE_LANG, USER_NAME, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY,
              LAST_UPDATE_LOGIN,LAST_UPDATE_DATE )
             VALUES ( 271, '''|| TABLE_NAME ||'_INTF'', USERENV(''LANG''),USERENV(''LANG'') ,''Interface: BSC Loader'',
              1355,  sysdate, 1355, NULL,  sysdate)';
Line: 71

    SELECT COLUMN_NAME,
           DECODE(DATA_TYPE, 'VARCHAR2', 2, 'NUMBER', 1, 'DATE', 3) TYPE ,
           (DECODE( NULLABLE, 'N', '* ')) || (SELECT Meaning FROM bsc_lookups WHERE lookup_type = 'BSC_PMA_WEBADI_HINTS' and lookup_code = DATA_TYPE) HINT,
           DECODE( NULLABLE, 'N', 'Y', 'N') NOT_NULL_FLAG,
           DATA_LENGTH
    FROM ALL_TAB_COLUMNS
    WHERE OWNER=g_bsc_schema AND TABLE_NAME = TAB_NAME
    order by COLUMN_ID;
Line: 83

   l_stmt :='INSERT INTO BNE_INTERFACE_COLS_B ( APPLICATION_ID, INTERFACE_CODE, OBJECT_VERSION_NUMBER,
                 SEQUENCE_NUM, INTERFACE_COL_TYPE, INTERFACE_COL_NAME, ENABLED_FLAG, REQUIRED_FLAG, DISPLAY_FLAG,
                 READ_ONLY_FLAG, NOT_NULL_FLAG, SUMMARY_FLAG, MAPPING_ENABLED_FLAG, DATA_TYPE, FIELD_SIZE,
                 DEFAULT_TYPE, DEFAULT_VALUE, SEGMENT_NUMBER, GROUP_NAME, OA_FLEX_CODE, OA_CONCAT_FLEX, VAL_TYPE,
                 VAL_ID_COL, VAL_MEAN_COL, VAL_DESC_COL, VAL_OBJ_NAME, VAL_ADDL_W_C, VAL_COMPONENT_APP_ID,
                 VAL_COMPONENT_CODE, OA_FLEX_NUM, OA_FLEX_APPLICATION_ID, DISPLAY_ORDER, UPLOAD_PARAM_LIST_ITEM_NUM,
                 EXPANDED_SQL_QUERY, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, LAST_UPDATE_DATE,
                 LOV_TYPE, OFFLINE_LOV_ENABLED_FLAG, VARIABLE_DATA_TYPE_CLASS )
              VALUES ( 271,'''|| TAB_NAME ||'_INTF'', 1,
                       1, 2, ''TAB_NAME_HEADER'', ''Y'', ''N'', ''Y'',
                       ''Y'', ''N'', ''N'', ''Y'', 2, NULL,
                       NULL, NULL, NULL, NULL, NULL, NULL , NULL,
                       NULL, NULL, NULL, NULL , NULL, NULL,
                       NULL, NULL, NULL, 1, NULL,
                       NULL, 1355,  sysdate, 1355, 0, sysdate,
                       NULL , ''N'',NULL )';
Line: 101

    l_stmt :='INSERT INTO BNE_INTERFACE_COLS_TL ( APPLICATION_ID, INTERFACE_CODE, SEQUENCE_NUM, LANGUAGE,
                SOURCE_LANG, USER_HINT, PROMPT_LEFT, USER_HELP_TEXT, PROMPT_ABOVE, CREATED_BY, CREATION_DATE,
                LAST_UPDATED_BY, LAST_UPDATE_LOGIN, LAST_UPDATE_DATE )
              VALUES ( 271, '''|| TAB_NAME ||'_INTF'', 1, USERENV(''LANG''), USERENV(''LANG''), null,
                (select Meaning from bsc_lookups where lookup_type =''BSC_PMA_WEBADI_HINTS''
                 and lookup_Code = ''INTERFACE_TAB''), null, null, 1355,
                sysdate, 1355, 0, sysdate)';
Line: 120

    l_stmt :='INSERT INTO BNE_INTERFACE_COLS_B ( APPLICATION_ID, INTERFACE_CODE, OBJECT_VERSION_NUMBER,
                 SEQUENCE_NUM, INTERFACE_COL_TYPE, INTERFACE_COL_NAME, ENABLED_FLAG, REQUIRED_FLAG, DISPLAY_FLAG,
                 READ_ONLY_FLAG, NOT_NULL_FLAG, SUMMARY_FLAG, MAPPING_ENABLED_FLAG, DATA_TYPE, FIELD_SIZE,
                 DEFAULT_TYPE, DEFAULT_VALUE, SEGMENT_NUMBER, GROUP_NAME, OA_FLEX_CODE, OA_CONCAT_FLEX, VAL_TYPE,
                 VAL_ID_COL, VAL_MEAN_COL, VAL_DESC_COL, VAL_OBJ_NAME, VAL_ADDL_W_C, VAL_COMPONENT_APP_ID,
                 VAL_COMPONENT_CODE, OA_FLEX_NUM, OA_FLEX_APPLICATION_ID, DISPLAY_ORDER, UPLOAD_PARAM_LIST_ITEM_NUM,
                 EXPANDED_SQL_QUERY, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, LAST_UPDATE_DATE,
                 LOV_TYPE, OFFLINE_LOV_ENABLED_FLAG, VARIABLE_DATA_TYPE_CLASS )
              VALUES ( 271,'''|| TAB_NAME ||'_INTF'', 1,
                     '||sequence_num ||', 1, '''|| TAB_COL_REC.COLUMN_NAME ||''', ''Y'', ''Y'', ''Y'',
                     ''N'', '''||TAB_COL_REC.NOT_NULL_FLAG||''', ''N'', ''Y'', '|| TAB_COL_REC.TYPE ||', ' ||field_size||',
                     NULL, NULL, NULL, NULL, NULL, NULL, ''' || val_type || ''',
                     NULL, NULL, NULL,  '''|| val_obj_name ||''' , NULL, NULL,
                     NULL, NULL, NULL, '||sequence_num||', NULL,
                     NULL, 1355, sysdate, 1355, 0, sysdate,
                     NULL, ''N'', NULL )';
Line: 139

    l_stmt :='INSERT INTO BNE_INTERFACE_COLS_TL ( APPLICATION_ID, INTERFACE_CODE, SEQUENCE_NUM, LANGUAGE,
                SOURCE_LANG, USER_HINT, PROMPT_LEFT, USER_HELP_TEXT, PROMPT_ABOVE, CREATED_BY, CREATION_DATE,
                LAST_UPDATED_BY, LAST_UPDATE_LOGIN, LAST_UPDATE_DATE )
              VALUES ( 271, '''|| TAB_NAME ||'_INTF'', '||sequence_num ||', USERENV(''LANG''), USERENV(''LANG''), ''' || TAB_COL_REC.HINT ||''',
                '''|| TAB_COL_REC.COLUMN_NAME ||''', ''' || TAB_COL_REC.HINT ||''', '''|| TAB_COL_REC.COLUMN_NAME ||''', 1355,
                sysdate, 1355, 0, sysdate)';
Line: 166

    SELECT COLUMN_NAME,
           DECODE(DATA_TYPE, 'VARCHAR2', 2, 'NUMBER', 1, 'DATE', 3) TYPE
    FROM ALL_TAB_COLUMNS WHERE OWNER=g_bsc_schema AND TABLE_NAME = TAB_NAME
    order by COLUMN_ID;
Line: 172

  l_stmt:='INSERT INTO BNE_LAYOUTS_B ( APPLICATION_ID, LAYOUT_CODE, OBJECT_VERSION_NUMBER, STYLESHEET_APP_ID,
             STYLESHEET_CODE, INTEGRATOR_APP_ID, INTEGRATOR_CODE, STYLE, STYLE_CLASS, REPORTING_FLAG,
             REPORTING_INTERFACE_APP_ID, REPORTING_INTERFACE_CODE, CREATION_DATE, CREATED_BY, LAST_UPDATED_BY,
             LAST_UPDATE_LOGIN, LAST_UPDATE_DATE, CREATE_DOC_LIST_APP_ID, CREATE_DOC_LIST_CODE )
          VALUES ( 271,  '''|| TAB_NAME ||'_L'', 1, 231, ''DEFAULT'', 271, '''|| TAB_NAME ||'_INTG'', NULL,
            ''BNE_PAGE'', ''N'', NULL, NULL, sysdate, 1355, 1355, NULL,  sysdate, 271, NULL)';
Line: 181

  l_stmt:='INSERT INTO BNE_LAYOUTS_TL ( APPLICATION_ID, LAYOUT_CODE, LANGUAGE, SOURCE_LANG, USER_NAME,
             CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN,LAST_UPDATE_DATE )
           VALUES ( 271,'''|| TAB_NAME ||'_L'', USERENV(''LANG''), USERENV(''LANG''), ''BSC Default Layout'', 1355,
             sysdate, 1355, 0, sysdate)';
Line: 189

  l_stmt:='INSERT INTO BNE_LAYOUT_BLOCKS_B ( APPLICATION_ID, LAYOUT_CODE, BLOCK_ID, OBJECT_VERSION_NUMBER,
             PARENT_ID, LAYOUT_ELEMENT, STYLE_CLASS, STYLE, ROW_STYLE_CLASS, ROW_STYLE, COL_STYLE_CLASS,
             COL_STYLE, PROMPT_DISPLAYED_FLAG, PROMPT_STYLE_CLASS, PROMPT_STYLE, HINT_DISPLAYED_FLAG,
             HINT_STYLE_CLASS, HINT_STYLE, ORIENTATION, LAYOUT_CONTROL, DISPLAY_FLAG, BLOCKSIZE, MINSIZE,
             MAXSIZE, SEQUENCE_NUM, PROMPT_COLSPAN, HINT_COLSPAN, ROW_COLSPAN, SUMMARY_STYLE_CLASS,
             SUMMARY_STYLE, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, LAST_UPDATE_DATE )
           VALUES ( 271, '''|| TAB_NAME ||'_L'', 1, 1, NULL, ''CONTEXT'', ''BNE_CONTEXT'', NULL, ''BNE_CONTEXT_ROW'',
             NULL, NULL, NULL, ''Y'', ''BNE_CONTEXT_HEADER'', NULL, ''Y'', ''BNE_CONTEXT_HINT'', NULL, ''HORIZONTAL'',
             ''COLUMN_FLOW'', ''Y'', 1, 1, 1, 20, 2, 2, 2, ''BNE_LINES_TOTAL'', NULL, 1355,
             sysdate, 1355, 1355, sysdate)';
Line: 201

  l_stmt:='INSERT INTO BNE_LAYOUT_BLOCKS_TL ( APPLICATION_ID, LAYOUT_CODE, BLOCK_ID, USER_NAME, LANGUAGE,
             SOURCE_LANG, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, LAST_UPDATE_DATE )
           VALUES ( 271, '''|| TAB_NAME ||'_L'', 1, ''Context'', USERENV(''LANG''), USERENV(''LANG''), 1355,
             sysdate, 1355, 0, sysdate)';
Line: 208

  l_stmt:='INSERT INTO BNE_LAYOUT_BLOCKS_B ( APPLICATION_ID, LAYOUT_CODE, BLOCK_ID, OBJECT_VERSION_NUMBER,
             PARENT_ID, LAYOUT_ELEMENT, STYLE_CLASS, STYLE, ROW_STYLE_CLASS, ROW_STYLE, COL_STYLE_CLASS,
             COL_STYLE, PROMPT_DISPLAYED_FLAG, PROMPT_STYLE_CLASS, PROMPT_STYLE, HINT_DISPLAYED_FLAG,
             HINT_STYLE_CLASS, HINT_STYLE, ORIENTATION, LAYOUT_CONTROL, DISPLAY_FLAG, BLOCKSIZE, MINSIZE,
             MAXSIZE, SEQUENCE_NUM, PROMPT_COLSPAN, HINT_COLSPAN, ROW_COLSPAN, SUMMARY_STYLE_CLASS,
             SUMMARY_STYLE, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, LAST_UPDATE_DATE )
           VALUES ( 271, '''|| TAB_NAME ||'_L'', 2, 1, NULL, ''LINE'', ''BNE_LINES'', NULL, ''BNE_LINES_ROW'',
             NULL, NULL, NULL, ''Y'', ''BNE_LINES_HEADER'', NULL, ''Y'', ''BNE_LINES_HINT'', NULL, ''VERTICAL'',
             ''TABLE_FLOW'', ''Y'', 10, 1, 1, 10, NULL, NULL, NULL, ''BNE_LINES_TOTAL'', NULL, 1355,
             sysdate, 1355, 1355, sysdate)';
Line: 220

  l_stmt:='INSERT INTO BNE_LAYOUT_BLOCKS_TL ( APPLICATION_ID, LAYOUT_CODE, BLOCK_ID, USER_NAME, LANGUAGE,
             SOURCE_LANG, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, LAST_UPDATE_DATE )
           VALUES ( 271, '''|| TAB_NAME ||'_L'', 2, ''Line'', USERENV(''LANG''),USERENV(''LANG''), 1355,
             sysdate, 1355, 0, sysdate)';
Line: 227

  l_stmt:='INSERT INTO BNE_LAYOUT_COLS ( APPLICATION_ID, LAYOUT_CODE, BLOCK_ID, OBJECT_VERSION_NUMBER,
             INTERFACE_APP_ID, INTERFACE_CODE, INTERFACE_SEQ_NUM, SEQUENCE_NUM, STYLE, STYLE_CLASS,
             HINT_STYLE, HINT_STYLE_CLASS, PROMPT_STYLE, PROMPT_STYLE_CLASS, DEFAULT_TYPE, DEFAULT_VALUE,
             CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, LAST_UPDATE_DATE )
           VALUES ( 271, '''|| TAB_NAME ||'_L'', 1, 1, 271, '''|| TAB_NAME ||'_INTF'',1 ,
              10, NULL, NULL, NULL, NULL, NULL, NULL, ''CONSTANT'', '''|| TAB_NAME ||''', 1355,
              sysdate, 1355, 1355, sysdate)';
Line: 238

    l_stmt:='INSERT INTO BNE_LAYOUT_COLS ( APPLICATION_ID, LAYOUT_CODE, BLOCK_ID, OBJECT_VERSION_NUMBER,
               INTERFACE_APP_ID, INTERFACE_CODE, INTERFACE_SEQ_NUM, SEQUENCE_NUM, STYLE, STYLE_CLASS,
               HINT_STYLE, HINT_STYLE_CLASS, PROMPT_STYLE, PROMPT_STYLE_CLASS, DEFAULT_TYPE, DEFAULT_VALUE,
               CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, LAST_UPDATE_DATE )
             VALUES ( 271, '''|| TAB_NAME ||'_L'', 2, 1, 271, '''|| TAB_NAME ||'_INTF'',' || counter ||' ,
                ' || (counter*10)||', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1355,
                sysdate, 1355, 1355, sysdate)';
Line: 262

    SELECT COLUMN_NAME
    FROM ALL_TAB_COLUMNS WHERE OWNER=g_bsc_schema AND TABLE_NAME = TAB_NAME
    order by COLUMN_ID;
Line: 281

  query := ' SELECT ' || col_list || ' FROM ' || TAB_NAME ;
Line: 298

    SELECT COLUMN_NAME
    FROM ALL_TAB_COLUMNS WHERE OWNER=g_bsc_schema AND TABLE_NAME = TAB_NAME
    order by COLUMN_ID;
Line: 304

  l_stmt := 'INSERT INTO BNE_MAPPINGS_B (APPLICATION_ID, MAPPING_CODE, OBJECT_VERSION_NUMBER, INTEGRATOR_APP_ID,
  INTEGRATOR_CODE, REPORTING_FLAG, REPORTING_INTERFACE_APP_ID, REPORTING_INTERFACE_CODE, LAST_UPDATE_DATE,
  LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN) VALUES (
  271, '''|| TAB_NAME ||'_MAP'' , 1, 271, '''|| TAB_NAME ||'_INTG'', ''N'', NULL, NULL, sysdate
  , 2, sysdate, 2, 0)';
Line: 311

  l_stmt := 'INSERT INTO BNE_MAPPINGS_tl ( APPLICATION_ID, MAPPING_CODE, LANGUAGE, SOURCE_LANG, USER_NAME,
  LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN ) VALUES (
  271, '''|| TAB_NAME ||'_MAP'', USERENV(''LANG''), USERENV(''LANG''), ''None'',  sysdate, 2,  sysdate , 2, 0)';
Line: 319

    l_stmt := 'INSERT INTO BNE_MAPPING_LINES ( APPLICATION_ID, MAPPING_CODE, SEQUENCE_NUM, CONTENT_APP_ID, CONTENT_CODE,
               CONTENT_SEQ_NUM, INTERFACE_APP_ID, INTERFACE_CODE, INTERFACE_SEQ_NUM, OBJECT_VERSION_NUMBER,
               LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN ) VALUES
              ( 271, '''|| TAB_NAME ||'_MAP'', ' || seq || ', 271, '''|| TAB_NAME ||'_CNT'', ' || seq || ', 271
               , '''||TAB_NAME ||'_INTF'', ('||seq||'+1) ,1,  sysdate, 2,  sysdate , 2, 0)';
Line: 341

  query := ' SELECT APPLICATION_ID ||'''':''''||DUP_PROFILE_CODE, USER_NAME ' ||
           ' FROM BNE_DUPLICATE_PROFILES_VL ' ||
           ' WHERE INTEGRATOR_APP_ID = 271 AND INTEGRATOR_CODE = '''''|| TAB_NAME ||'_INTG''''';
Line: 345

  l_stmt := 'INSERT INTO BNE_RAW_QUERY (APPLICATION_ID, QUERY_CODE, SEQUENCE_NUM, OBJECT_VERSION_NUMBER, QUERY,
	     LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN) VALUES (
             271,'''|| TAB_NAME ||'_Q'', 1, 1, '''|| query ||''', sysdate, 2, sysdate, 2, 0)';
Line: 350

  l_stmt := 'INSERT INTO BNE_QUERIES_B( APPLICATION_ID, QUERY_CODE, OBJECT_VERSION_NUMBER, QUERY_CLASS,
             LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN ) VALUES (
             271,'''|| TAB_NAME ||'_Q'', 1, ''oracle.apps.bne.query.BneRawSQLQuery'', sysdate, 2, sysdate, 2, 0)';
Line: 355

  l_stmt := 'INSERT INTO BNE_QUERIES_TL( APPLICATION_ID, QUERY_CODE, LANGUAGE, SOURCE_LANG, USER_NAME,
             LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN ) VALUES (
             271,'''|| TAB_NAME ||'_Q'', USERENV(''LANG''), USERENV(''LANG''), ''Duplicate row Management'',  sysdate, 2,  sysdate , 2, 0)';
Line: 372

  l_stmt := 'INSERT INTO BNE_PARAM_DEFNS_B( APPLICATION_ID, PARAM_DEFN_CODE, OBJECT_VERSION_NUMBER, PARAM_NAME,
             PARAM_SOURCE, PARAM_CATEGORY, DATATYPE, ATTRIBUTE_APP_ID, ATTRIBUTE_CODE, PARAM_RESOLVER,
             DEFAULT_REQUIRED_FLAG, DEFAULT_VISIBLE_FLAG, DEFAULT_USER_MODIFYABLE_FLAG, DEFAULT_STRING,
             DEFAULT_DATE, DEFAULT_NUMBER, DEFAULT_BOOLEAN_FLAG, DEFAULT_FORMULA, VAL_TYPE, VAL_VALUE, MAX_SIZE,
             DISPLAY_TYPE, DISPLAY_STYLE, DISPLAY_SIZE, HELP_URL, FORMAT_MASK,
             LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN ) VALUES (
             271, '''|| TAB_NAME ||'_ROW'', 2, ''bne:rows'', ''WEBADI:Upload'',6,1,null,null,null, ''N'',''Y'',''Y'',''FLAGGED'',
             null, null, null, null, 3, ''BNE_ROWS'', 100, 3, 2, 100, null, null, sysdate, 2,  sysdate , 2, 0)';
Line: 383

    l_stmt := 'INSERT INTO BNE_PARAM_DEFNS_B( APPLICATION_ID, PARAM_DEFN_CODE, OBJECT_VERSION_NUMBER, PARAM_NAME,
               PARAM_SOURCE, PARAM_CATEGORY, DATATYPE, ATTRIBUTE_APP_ID, ATTRIBUTE_CODE, PARAM_RESOLVER,
               DEFAULT_REQUIRED_FLAG, DEFAULT_VISIBLE_FLAG, DEFAULT_USER_MODIFYABLE_FLAG, DEFAULT_STRING,
               DEFAULT_DATE, DEFAULT_NUMBER, DEFAULT_BOOLEAN_FLAG, DEFAULT_FORMULA, VAL_TYPE, VAL_VALUE, MAX_SIZE,
               DISPLAY_TYPE, DISPLAY_STYLE, DISPLAY_SIZE, HELP_URL, FORMAT_MASK,
               LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN ) VALUES (
               271, '''|| TAB_NAME ||'_DUP'' ,1 , ''Duplicate Parameter Query'', ''WEBADI: Upload'', 5, 1, null, null, null,
               ''N'', ''Y'', ''Y'', null, null, null, null, null, 4, ''271:'|| TAB_NAME ||'_Q'', 100,
               3, 2, 100, null, null, sysdate, 2, sysdate, 2, 0)';
Line: 395

  l_stmt := 'INSERT INTO BNE_PARAM_DEFNS_B( APPLICATION_ID, PARAM_DEFN_CODE, OBJECT_VERSION_NUMBER, PARAM_NAME,
             PARAM_SOURCE, PARAM_CATEGORY, DATATYPE, ATTRIBUTE_APP_ID, ATTRIBUTE_CODE, PARAM_RESOLVER,
             DEFAULT_REQUIRED_FLAG, DEFAULT_VISIBLE_FLAG, DEFAULT_USER_MODIFYABLE_FLAG, DEFAULT_STRING,
             DEFAULT_DATE, DEFAULT_NUMBER, DEFAULT_BOOLEAN_FLAG, DEFAULT_FORMULA, VAL_TYPE, VAL_VALUE, MAX_SIZE,
             DISPLAY_TYPE, DISPLAY_STYLE, DISPLAY_SIZE, HELP_URL, FORMAT_MASK,
             LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN ) VALUES (
             271, ''OBJECT_ID'', 1, ''OBJECT_ID'', ''WEBADI: Upload'',6,1,null,null,null, ''N'',''N'',''N'',
	     null, null, null, null, null, ''1'', null, 100, 2, 2, 100, null, null, sysdate, 2,  sysdate , 2, 0)';
Line: 405

  l_stmt := 'INSERT INTO BNE_PARAM_DEFNS_B( APPLICATION_ID, PARAM_DEFN_CODE, OBJECT_VERSION_NUMBER, PARAM_NAME,
             PARAM_SOURCE, PARAM_CATEGORY, DATATYPE, ATTRIBUTE_APP_ID, ATTRIBUTE_CODE, PARAM_RESOLVER,
             DEFAULT_REQUIRED_FLAG, DEFAULT_VISIBLE_FLAG, DEFAULT_USER_MODIFYABLE_FLAG, DEFAULT_STRING,
             DEFAULT_DATE, DEFAULT_NUMBER, DEFAULT_BOOLEAN_FLAG, DEFAULT_FORMULA, VAL_TYPE, VAL_VALUE, MAX_SIZE,
             DISPLAY_TYPE, DISPLAY_STYLE, DISPLAY_SIZE, HELP_URL, FORMAT_MASK,
             LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN ) VALUES (
             271, ''OBJECT_TYPE'', 1, ''OBJECT_TYPE'', ''WEBADI: Upload'',6,1,null,null,null, ''N'',''N'',''N'',
	     null, null, null, null, null, ''1'', null, 100, 2, 2, 100, null, null, sysdate, 2,  sysdate , 2, 0)';
Line: 415

  l_stmt := 'INSERT INTO BNE_PARAM_DEFNS_B( APPLICATION_ID, PARAM_DEFN_CODE, OBJECT_VERSION_NUMBER, PARAM_NAME,
             PARAM_SOURCE, PARAM_CATEGORY, DATATYPE, ATTRIBUTE_APP_ID, ATTRIBUTE_CODE, PARAM_RESOLVER,
             DEFAULT_REQUIRED_FLAG, DEFAULT_VISIBLE_FLAG, DEFAULT_USER_MODIFYABLE_FLAG, DEFAULT_STRING,
             DEFAULT_DATE, DEFAULT_NUMBER, DEFAULT_BOOLEAN_FLAG, DEFAULT_FORMULA, VAL_TYPE, VAL_VALUE, MAX_SIZE,
             DISPLAY_TYPE, DISPLAY_STYLE, DISPLAY_SIZE, HELP_URL, FORMAT_MASK,
             LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN ) VALUES (
             271, ''TABLE_NAME'', 1, ''TABLE_NAME'', ''WEBADI: Upload'',6,1,null,null,null, ''N'',''N'',''N'',
	     null, null, null, null, null, ''1'', null, 100, 2, 2, 100, null, null, sysdate, 2,  sysdate , 2, 0)';
Line: 425

  l_stmt := 'INSERT INTO BNE_PARAM_DEFNS_B( APPLICATION_ID, PARAM_DEFN_CODE, OBJECT_VERSION_NUMBER, PARAM_NAME,
             PARAM_SOURCE, PARAM_CATEGORY, DATATYPE, ATTRIBUTE_APP_ID, ATTRIBUTE_CODE, PARAM_RESOLVER,
             DEFAULT_REQUIRED_FLAG, DEFAULT_VISIBLE_FLAG, DEFAULT_USER_MODIFYABLE_FLAG, DEFAULT_STRING,
             DEFAULT_DATE, DEFAULT_NUMBER, DEFAULT_BOOLEAN_FLAG, DEFAULT_FORMULA, VAL_TYPE, VAL_VALUE, MAX_SIZE,
             DISPLAY_TYPE, DISPLAY_STYLE, DISPLAY_SIZE, HELP_URL, FORMAT_MASK,
             LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN ) VALUES (
             271, ''QUERY_TIME'', 1, ''QUERY_TIME'', ''WEBADI: Upload'',6,1,null,null,null, ''N'',''N'',''N'',
	     null, null, null, null, null, ''1'', null, 100, 2, 2, 100, null, null, sysdate, 2,  sysdate , 2, 0)';
Line: 436

  l_stmt := 'INSERT INTO BNE_PARAM_DEFNS_TL(APPLICATION_ID, PARAM_DEFN_CODE, LANGUAGE, SOURCE_LANG, USER_NAME,
             DEFAULT_STRING, DEFAULT_DESC, PROMPT_LEFT, PROMPT_ABOVE, USER_TIP, ACCESS_KEY,
             LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN ) VALUES (
             271,'''|| TAB_NAME ||'_ROW'',USERENV(''LANG''),USERENV(''LANG''),''Flagged rows'',null,''flagged rows'',
             BSC_WEB_ADI_LOADER_PKG.get_lookup_value(''BSC_PMA_WEBADI_UPL_ROW'',''ROWS_UPL''),null,
             null,null,sysdate, 2, sysdate, 2, 0)';
Line: 445

    l_stmt := 'INSERT INTO BNE_PARAM_DEFNS_TL(APPLICATION_ID, PARAM_DEFN_CODE, LANGUAGE, SOURCE_LANG, USER_NAME,
               DEFAULT_STRING, DEFAULT_DESC, PROMPT_LEFT, PROMPT_ABOVE, USER_TIP, ACCESS_KEY,
               LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN ) VALUES (
               271,'''|| TAB_NAME ||'_DUP'',USERENV(''LANG''),USERENV(''LANG''),''Duplicate Parameter Query'' ,null,''Update Columns'',
               BSC_WEB_ADI_LOADER_PKG.get_lookup_value(''BSC_PMA_WEBADI_UPL_DUP'',''DUPLICATE_REC''),
               null,null,null,sysdate, 2, sysdate, 2, 0)'; --BSC_LOOKUPS
Line: 454

  l_stmt := 'INSERT INTO BNE_PARAM_DEFNS_TL(APPLICATION_ID, PARAM_DEFN_CODE, LANGUAGE, SOURCE_LANG, USER_NAME,
             DEFAULT_STRING, DEFAULT_DESC, PROMPT_LEFT, PROMPT_ABOVE, USER_TIP, ACCESS_KEY,
             LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN ) VALUES (
             271,''OBJECT_ID'',USERENV(''LANG''),USERENV(''LANG''),''Object Id'' ,null,''Object Id'',
             ''Object Id'',null,''Object Id'',null,sysdate, 2, sysdate, 2, 0)';
Line: 461

  l_stmt := 'INSERT INTO BNE_PARAM_DEFNS_TL(APPLICATION_ID, PARAM_DEFN_CODE, LANGUAGE, SOURCE_LANG, USER_NAME,
             DEFAULT_STRING, DEFAULT_DESC, PROMPT_LEFT, PROMPT_ABOVE, USER_TIP, ACCESS_KEY,
             LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN ) VALUES (
             271,''OBJECT_TYPE'',USERENV(''LANG''),USERENV(''LANG''),''Object Type'' ,null,''Object Type'',
             ''Object Type'',null,''Object Type'',null,sysdate, 2, sysdate, 2, 0)';
Line: 468

  l_stmt := 'INSERT INTO BNE_PARAM_DEFNS_TL(APPLICATION_ID, PARAM_DEFN_CODE, LANGUAGE, SOURCE_LANG, USER_NAME,
             DEFAULT_STRING, DEFAULT_DESC, PROMPT_LEFT, PROMPT_ABOVE, USER_TIP, ACCESS_KEY,
             LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN ) VALUES (
             271,''TABLE_NAME'',USERENV(''LANG''),USERENV(''LANG''),''Table Name'' ,null,''Table Name'',
             ''Table Name'',null,''Table Name'',null,sysdate, 2, sysdate, 2, 0)';
Line: 475

  l_stmt := 'INSERT INTO BNE_PARAM_DEFNS_TL(APPLICATION_ID, PARAM_DEFN_CODE, LANGUAGE, SOURCE_LANG, USER_NAME,
             DEFAULT_STRING, DEFAULT_DESC, PROMPT_LEFT, PROMPT_ABOVE, USER_TIP, ACCESS_KEY,
             LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN ) VALUES (
             271,''QUERY_TIME'',USERENV(''LANG''),USERENV(''LANG''),''Query Time'' ,null,''Query Time'',
             ''Query Time'',null,''Query Time'',null,sysdate, 2, sysdate, 2, 0)';
Line: 494

  l_stmt := 'INSERT INTO BNE_PARAM_LISTS_B( APPLICATION_ID, PARAM_LIST_CODE, OBJECT_VERSION_NUMBER, PERSISTENT_FLAG,
             COMMENTS, ATTRIBUTE_APP_ID, ATTRIBUTE_CODE, LIST_RESOLVER,
             LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN ) VALUES (
             271,'''|| TAB_NAME ||'_UPL'',3,''Y'',''WebADI: Upload Parameter List'',null,null,null,
             sysdate, 2,  sysdate , 2, 0)';
Line: 502

  l_stmt := 'INSERT INTO BNE_PARAM_LISTS_TL(APPLICATION_ID, PARAM_LIST_CODE, LANGUAGE, SOURCE_LANG,
             USER_NAME, USER_TIP, PROMPT_LEFT, PROMPT_ABOVE,
             LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN ) VALUES (
             271,'''|| TAB_NAME ||'_UPL'',USERENV(''LANG''),USERENV(''LANG''),''Web ADI: Upload Parameter List'', null, null,
             ''Upload Parameters'',sysdate, 2, sysdate, 2, 0)';
Line: 510

  l_stmt := 'INSERT INTO BNE_PARAM_LIST_ITEMS(APPLICATION_ID, PARAM_LIST_CODE, SEQUENCE_NUM, OBJECT_VERSION_NUMBER,
             PARAM_DEFN_APP_ID, PARAM_DEFN_CODE, PARAM_NAME, ATTRIBUTE_APP_ID, ATTRIBUTE_CODE, STRING_VALUE,
             DATE_VALUE, NUMBER_VALUE, BOOLEAN_VALUE_FLAG, FORMULA_VALUE, DESC_VALUE,
             LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN ) VALUES (
             271,'''|| TAB_NAME ||'_UPL'',1,2,271,'''|| TAB_NAME ||'_ROW'',''bne:rows'',null,null,null,null,null,null,null,null
             ,sysdate, 2, sysdate, 2, 0)';
Line: 520

    l_stmt := 'INSERT INTO BNE_PARAM_LIST_ITEMS(APPLICATION_ID, PARAM_LIST_CODE, SEQUENCE_NUM, OBJECT_VERSION_NUMBER,
               PARAM_DEFN_APP_ID, PARAM_DEFN_CODE, PARAM_NAME, ATTRIBUTE_APP_ID, ATTRIBUTE_CODE, STRING_VALUE,
               DATE_VALUE, NUMBER_VALUE, BOOLEAN_VALUE_FLAG, FORMULA_VALUE, DESC_VALUE,
               LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN ) VALUES (
               271,'''|| TAB_NAME ||'_UPL'', 2, 1, 271, '''|| TAB_NAME ||'_DUP'', ''bne:duplicateProfile'', null, null,
                null, null, null, null, null, null, sysdate, 2, sysdate, 2, 0)';
Line: 530

  l_stmt := 'INSERT INTO BNE_PARAM_LIST_ITEMS(APPLICATION_ID, PARAM_LIST_CODE, SEQUENCE_NUM, OBJECT_VERSION_NUMBER,
             PARAM_DEFN_APP_ID, PARAM_DEFN_CODE, PARAM_NAME, ATTRIBUTE_APP_ID, ATTRIBUTE_CODE, STRING_VALUE,
             DATE_VALUE, NUMBER_VALUE, BOOLEAN_VALUE_FLAG, FORMULA_VALUE, DESC_VALUE,
             LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN ) VALUES (
             271,'''|| TAB_NAME ||'_UPL'', 3, 1, 271, ''OBJECT_TYPE'', ''OBJECT_TYPE'', null, null,
              null, null, null, null, null, null, sysdate, 2, sysdate, 2, 0)';
Line: 539

  l_stmt := 'INSERT INTO BNE_PARAM_LIST_ITEMS(APPLICATION_ID, PARAM_LIST_CODE, SEQUENCE_NUM, OBJECT_VERSION_NUMBER,
             PARAM_DEFN_APP_ID, PARAM_DEFN_CODE, PARAM_NAME, ATTRIBUTE_APP_ID, ATTRIBUTE_CODE, STRING_VALUE,
             DATE_VALUE, NUMBER_VALUE, BOOLEAN_VALUE_FLAG, FORMULA_VALUE, DESC_VALUE,
             LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN ) VALUES (
             271,'''|| TAB_NAME ||'_UPL'', 4, 1, 271, ''OBJECT_ID'', ''OBJECT_ID'', null, null,
              null, null, null, null, null, null, sysdate, 2, sysdate, 2, 0)';
Line: 548

  l_stmt := 'INSERT INTO BNE_PARAM_LIST_ITEMS(APPLICATION_ID, PARAM_LIST_CODE, SEQUENCE_NUM, OBJECT_VERSION_NUMBER,
             PARAM_DEFN_APP_ID, PARAM_DEFN_CODE, PARAM_NAME, ATTRIBUTE_APP_ID, ATTRIBUTE_CODE, STRING_VALUE,
             DATE_VALUE, NUMBER_VALUE, BOOLEAN_VALUE_FLAG, FORMULA_VALUE, DESC_VALUE,
             LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN ) VALUES (
             271,'''|| TAB_NAME ||'_UPL'', 5, 1, 271, ''TABLE_NAME'', ''TABLE_NAME'', null, null,
              null, null, null, null, null, null, sysdate, 2, sysdate, 2, 0)';
Line: 557

  l_stmt := 'INSERT INTO BNE_PARAM_LIST_ITEMS(APPLICATION_ID, PARAM_LIST_CODE, SEQUENCE_NUM, OBJECT_VERSION_NUMBER,
             PARAM_DEFN_APP_ID, PARAM_DEFN_CODE, PARAM_NAME, ATTRIBUTE_APP_ID, ATTRIBUTE_CODE, STRING_VALUE,
             DATE_VALUE, NUMBER_VALUE, BOOLEAN_VALUE_FLAG, FORMULA_VALUE, DESC_VALUE,
             LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN ) VALUES (
             271,'''|| TAB_NAME ||'_UPL'', 6, 1, 271, ''QUERY_TIME'', ''QUERY_TIME'', null, null,
              null, null, null, null, null, null, sysdate, 2, sysdate, 2, 0)';
Line: 568

  l_stmt := 'update bne_integrators_b set UPLOAD_PARAM_LIST_APP_ID=271, UPLOAD_PARAM_LIST_CODE= :1
             where integrator_code = :2 and APPLICATION_ID = 271';
Line: 588

    'SELECT SEQUENCE_NUM FROM BNE_INTERFACE_COLS_B
    WHERE  APPLICATION_ID=271 AND INTERFACE_CODE= :1  AND SEQUENCE_NUM >1
    AND SEQUENCE_NUM NOT IN(SELECT INTERFACE_SEQ_NUM
    FROM BNE_INTERFACE_KEY_COLS WHERE INTERFACE_APP_ID=271 AND INTERFACE_CODE= :2)
    order by SEQUENCE_NUM';
Line: 596

  l_stmt := 'INSERT INTO BNE_DUPLICATE_PROFILES_B( APPLICATION_ID, DUP_PROFILE_CODE, OBJECT_VERSION_NUMBER,
             INTEGRATOR_APP_ID, INTEGRATOR_CODE,
             LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN ) VALUES (
             271,'''|| TAB_NAME ||'_ERR'',1,271,'''|| TAB_NAME ||'_INTG'',sysdate, 2,  sysdate , 2, 0)';
Line: 603

  l_stmt := 'INSERT INTO BNE_DUPLICATE_PROFILES_TL(APPLICATION_ID, DUP_PROFILE_CODE, LANGUAGE, SOURCE_LANG, USER_NAME,
             LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN ) VALUES (
             271,'''|| TAB_NAME ||'_ERR'',USERENV(''LANG''),USERENV(''LANG''),
             BSC_WEB_ADI_LOADER_PKG.get_lookup_value(''BSC_PMA_WEBADI_UPL_ERR'',''ERROR_DUP''),sysdate, 2, sysdate, 2, 0)';
Line: 610

  l_stmt := 'INSERT INTO BNE_DUP_INTERFACE_PROFILES(INTERFACE_APP_ID, INTERFACE_CODE, DUP_PROFILE_APP_ID,
             DUP_PROFILE_CODE, OBJECT_VERSION_NUMBER, DUP_HANDLING_CODE, DEFAULT_RESOLVER_CLASSNAME,
             LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN ) VALUES (
             271,'''|| TAB_NAME ||'_INTF'',271,'''|| TAB_NAME ||'_ERR'',1,''ROW_ERROR'',
             NULL, sysdate, 2, sysdate, 2, 0)';
Line: 618

  l_stmt := 'INSERT INTO BNE_DUPLICATE_PROFILES_B( APPLICATION_ID, DUP_PROFILE_CODE, OBJECT_VERSION_NUMBER,
             INTEGRATOR_APP_ID, INTEGRATOR_CODE,
             LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN ) VALUES (
             271,'''|| TAB_NAME ||'_REP'',1,271,'''|| TAB_NAME ||'_INTG'',sysdate, 2,  sysdate , 2, 0)';
Line: 625

  l_stmt := 'INSERT INTO BNE_DUPLICATE_PROFILES_TL(APPLICATION_ID, DUP_PROFILE_CODE, LANGUAGE, SOURCE_LANG, USER_NAME,
             LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN ) VALUES (
             271,'''|| TAB_NAME ||'_REP'',USERENV(''LANG''),USERENV(''LANG''),
             BSC_WEB_ADI_LOADER_PKG.get_lookup_value(''BSC_PMA_WEBADI_UPL_REP'',''REPLACE_DUP''),sysdate, 2, sysdate, 2, 0)'; --BSC_LOOKUPS
Line: 632

  l_stmt := 'INSERT INTO BNE_DUP_INTERFACE_PROFILES(INTERFACE_APP_ID, INTERFACE_CODE, DUP_PROFILE_APP_ID,
             DUP_PROFILE_CODE, OBJECT_VERSION_NUMBER, DUP_HANDLING_CODE, DEFAULT_RESOLVER_CLASSNAME,
             LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN ) VALUES (
             271,'''|| TAB_NAME ||'_INTF'',271,'''|| TAB_NAME ||'_REP'',1,''TRANSFORM'',
             ''oracle.apps.bne.integrator.upload.BneKeepResolver'', sysdate, 2, sysdate, 2, 0)';
Line: 644

    l_stmt := 'INSERT INTO BNE_DUP_INTERFACE_COLS( INTERFACE_APP_ID, INTERFACE_CODE, INTERFACE_SEQ_NUM,
               DUP_PROFILE_APP_ID, DUP_PROFILE_CODE, OBJECT_VERSION_NUMBER, RESOLVER_CLASSNAME,
               LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN ) VALUES (
               271,'''|| TAB_NAME ||'_INTF'','||l_seq_num||',271, '''|| TAB_NAME ||'_REP'',
               1,''oracle.apps.bne.integrator.upload.BneReplaceResolver'', sysdate, 2, sysdate, 2, 0)';
Line: 662

    SELECT COLUMN_POSITION+1 Interface_seq
    FROM ALL_INDEXES i, ALL_IND_COLUMNS c
    WHERE i.TABLE_OWNER=g_bsc_schema AND i.TABLE_NAME=TAB_NAME AND
          i.UNIQUENESS ='UNIQUE' AND i.OWNER=c.INDEX_OWNER AND I.INDEX_NAME = C.INDEX_NAME;
Line: 673

      l_stmt := 'INSERT INTO BNE_INTERFACE_KEYS( APPLICATION_ID, KEY_CODE, OBJECT_VERSION_NUMBER, INTERFACE_APP_ID,
                 INTERFACE_CODE, KEY_TYPE, KEY_CLASS,
                 LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN ) VALUES (
                 271,'''|| TAB_NAME ||'_UK'',1,271,'''|| TAB_NAME ||'_INTF'',''DUP_UNIQUE'',
                 ''oracle.apps.bne.integrator.upload.BneTableInterfaceKey'',sysdate, 2,  sysdate , 2, 0)';
Line: 680

    l_stmt := 'INSERT INTO BNE_INTERFACE_KEY_COLS( APPLICATION_ID, KEY_CODE, SEQUENCE_NUM, OBJECT_VERSION_NUMBER,
               INTERFACE_APP_ID, INTERFACE_CODE, INTERFACE_SEQ_NUM,
               LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN ) VALUES (
               271,'''|| TAB_NAME ||'_UK'','||to_char(unique_ind_col_rec.Interface_seq-1) ||', 1, 271, '''|| TAB_NAME ||'_INTF'','
               ||to_char(unique_ind_col_rec.Interface_seq)||',sysdate, 2,  sysdate , 2, 0)';
Line: 702

  l_stmt := 'delete bne_integrators_b where application_id = 271 and INTEGRATOR_CODE =  :1';
Line: 705

  l_stmt := 'delete bne_integrators_tl
             where application_id = 271 and INTEGRATOR_CODE = :1' ;
Line: 709

  l_stmt := 'delete BNE_SECURED_OBJECTS
             where application_id = 271 and OBJECT_CODE = :1' ;
Line: 715

  l_stmt := 'delete BNE_SECURITY_RULES
             where application_id = 271 and SECURITY_CODE = :1' ;
Line: 721

  l_stmt := 'delete bne_interfaces_b
             where application_id = 271 and INTERFACE_CODE = :1' ;
Line: 725

  l_stmt := 'delete bne_interfaces_tl
             where application_id = 271 and INTERFACE_CODE = :1' ;
Line: 729

  l_stmt := 'delete bne_interface_cols_b
             where application_id = 271 and INTERFACE_CODE = :1' ;
Line: 733

  l_stmt := 'delete bne_interface_cols_tl
             where application_id = 271 and INTERFACE_CODE = :1' ;
Line: 739

  l_stmt := 'delete bne_layouts_b
             where application_id = 271 and LAYOUT_CODE = :1' ;
Line: 743

  l_stmt := 'delete bne_layouts_tl
             where application_id = 271 and LAYOUT_CODE = :1' ;
Line: 747

  l_stmt := 'delete bne_layout_blocks_b
             where application_id = 271 and LAYOUT_CODE = :1' ;
Line: 751

  l_stmt := 'delete bne_layout_blocks_tl
             where application_id = 271 and LAYOUT_CODE = :1' ;
Line: 755

  l_stmt := 'delete bne_layout_cols
             where application_id = 271 and LAYOUT_CODE = :1' ;
Line: 761

  l_stmt := 'delete BNE_CONTENTS_b
             where application_id = 271 and CONTENT_CODE = :1' ;
Line: 765

  l_stmt := 'delete BNE_CONTENTS_TL
             where application_id = 271 and CONTENT_CODE = :1' ;
Line: 771

  l_stmt := 'delete BNE_MAPPINGS_B
             where application_id = 271 and MAPPING_CODE = :1' ;
Line: 775

  l_stmt := 'delete BNE_MAPPINGS_TL
             where application_id = 271 and MAPPING_CODE = :1' ;
Line: 779

  l_stmt := 'delete BNE_MAPPING_LINES
             where application_id = 271 and MAPPING_CODE = :1' ;
Line: 785

  l_stmt := 'delete BNE_RAW_QUERY
             where application_id = 271 and QUERY_CODE =  :1' ;
Line: 789

  l_stmt := 'delete BNE_QUERIES_B
             where application_id = 271 and QUERY_CODE =  :1' ;
Line: 793

  l_stmt := 'delete BNE_QUERIES_TL
             where application_id = 271 and QUERY_CODE =  :1' ;
Line: 800

  l_stmt := 'delete BNE_PARAM_DEFNS_B
             where application_id = 271 and (PARAM_DEFN_CODE = :1 OR
                                             PARAM_DEFN_CODE = :2 OR
                                             PARAM_DEFN_CODE = ''OBJECT_TYPE''  OR
                                             PARAM_DEFN_CODE = ''OBJECT_ID''  OR
                                             PARAM_DEFN_CODE = ''TABLE_NAME'' OR
                                             PARAM_DEFN_CODE = ''QUERY_TIME'')' ;
Line: 810

  l_stmt := 'delete BNE_PARAM_DEFNS_TL
             where application_id = 271 and (PARAM_DEFN_CODE = :1  OR
                                             PARAM_DEFN_CODE = :2  OR
                                             PARAM_DEFN_CODE = ''OBJECT_TYPE''  OR
                                             PARAM_DEFN_CODE = ''OBJECT_ID''  OR
                                             PARAM_DEFN_CODE = ''TABLE_NAME'' OR
                                             PARAM_DEFN_CODE = ''QUERY_TIME'')' ;
Line: 821

  l_stmt := 'delete BNE_PARAM_LISTS_B
             where application_id = 271 and PARAM_LIST_CODE = :1' ;
Line: 825

  l_stmt := 'delete BNE_PARAM_LISTS_TL
             where application_id = 271 and PARAM_LIST_CODE = :1' ;
Line: 829

  l_stmt := 'delete BNE_PARAM_LIST_ITEMS
             where application_id = 271 and PARAM_LIST_CODE = :1' ;
Line: 836

  l_stmt := 'delete BNE_DUPLICATE_PROFILES_B
             where application_id = 271 and (DUP_PROFILE_CODE = :1
                                           or DUP_PROFILE_CODE = :2)' ;
Line: 841

  l_stmt := 'delete BNE_DUPLICATE_PROFILES_TL
             where application_id = 271 and (DUP_PROFILE_CODE = :1
                                           or DUP_PROFILE_CODE = :2)' ;
Line: 848

  l_stmt := 'delete BNE_DUP_INTERFACE_PROFILES
             where INTERFACE_APP_ID = 271 and INTERFACE_CODE = :1' ;
Line: 852

  l_stmt := 'delete BNE_DUP_INTERFACE_COLS
             where INTERFACE_APP_ID = 271 and INTERFACE_CODE = :1' ;
Line: 858

  l_stmt := 'delete BNE_INTERFACE_KEYS
             where application_id = 271 and KEY_CODE = :1' ;
Line: 862

  l_stmt := 'delete BNE_INTERFACE_KEY_COLS
             where application_id = 271 and KEY_CODE = :1' ;
Line: 888

  SELECT meaning
  INTO lookup_value
  FROM bsc_lookups
  WHERE  APPLICATION_ID=271 and lookup_type = type AND lookup_code = code ;
Line: 937

  delete bne_integrators_b where application_id = 271;
Line: 938

  delete bne_integrators_tl where application_id = 271;
Line: 939

  delete BNE_SECURITY_RULES WHERE application_id = 271;
Line: 940

  delete BNE_SECURED_OBJECTS  WHERE application_id = 271;
Line: 941

  delete bne_interfaces_b where application_id = 271;
Line: 942

  delete bne_interfaces_tl where application_id = 271;
Line: 943

  delete bne_interface_cols_b where application_id = 271;
Line: 944

  delete bne_interface_cols_tl where application_id = 271;
Line: 945

  delete bne_layouts_b where application_id = 271;
Line: 946

  delete bne_layouts_tl where application_id = 271;
Line: 947

  delete bne_contents_b where application_id = 271;
Line: 948

  delete bne_contents_tl where application_id = 271;
Line: 949

  delete bne_layout_blocks_b where application_id = 271;
Line: 950

  delete bne_layout_blocks_tl where application_id = 271;
Line: 951

  delete bne_layout_cols where application_id = 271;