The following lines contain the word 'select', 'insert', 'update' or 'delete':
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)';
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)';
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;
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 )';
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)';
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 )';
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)';
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;
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)';
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)';
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)';
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)';
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)';
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)';
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)';
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)';
SELECT COLUMN_NAME
FROM ALL_TAB_COLUMNS WHERE OWNER=g_bsc_schema AND TABLE_NAME = TAB_NAME
order by COLUMN_ID;
query := ' SELECT ' || col_list || ' FROM ' || TAB_NAME ;
SELECT COLUMN_NAME
FROM ALL_TAB_COLUMNS WHERE OWNER=g_bsc_schema AND TABLE_NAME = TAB_NAME
order by COLUMN_ID;
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)';
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)';
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)';
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''''';
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)';
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)';
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)';
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)';
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)';
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)';
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)';
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)';
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)';
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)';
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
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)';
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)';
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)';
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)';
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)';
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)';
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)';
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)';
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)';
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)';
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)';
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)';
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';
'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';
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)';
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)';
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)';
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)';
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
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)';
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)';
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;
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)';
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)';
l_stmt := 'delete bne_integrators_b where application_id = 271 and INTEGRATOR_CODE = :1';
l_stmt := 'delete bne_integrators_tl
where application_id = 271 and INTEGRATOR_CODE = :1' ;
l_stmt := 'delete BNE_SECURED_OBJECTS
where application_id = 271 and OBJECT_CODE = :1' ;
l_stmt := 'delete BNE_SECURITY_RULES
where application_id = 271 and SECURITY_CODE = :1' ;
l_stmt := 'delete bne_interfaces_b
where application_id = 271 and INTERFACE_CODE = :1' ;
l_stmt := 'delete bne_interfaces_tl
where application_id = 271 and INTERFACE_CODE = :1' ;
l_stmt := 'delete bne_interface_cols_b
where application_id = 271 and INTERFACE_CODE = :1' ;
l_stmt := 'delete bne_interface_cols_tl
where application_id = 271 and INTERFACE_CODE = :1' ;
l_stmt := 'delete bne_layouts_b
where application_id = 271 and LAYOUT_CODE = :1' ;
l_stmt := 'delete bne_layouts_tl
where application_id = 271 and LAYOUT_CODE = :1' ;
l_stmt := 'delete bne_layout_blocks_b
where application_id = 271 and LAYOUT_CODE = :1' ;
l_stmt := 'delete bne_layout_blocks_tl
where application_id = 271 and LAYOUT_CODE = :1' ;
l_stmt := 'delete bne_layout_cols
where application_id = 271 and LAYOUT_CODE = :1' ;
l_stmt := 'delete BNE_CONTENTS_b
where application_id = 271 and CONTENT_CODE = :1' ;
l_stmt := 'delete BNE_CONTENTS_TL
where application_id = 271 and CONTENT_CODE = :1' ;
l_stmt := 'delete BNE_MAPPINGS_B
where application_id = 271 and MAPPING_CODE = :1' ;
l_stmt := 'delete BNE_MAPPINGS_TL
where application_id = 271 and MAPPING_CODE = :1' ;
l_stmt := 'delete BNE_MAPPING_LINES
where application_id = 271 and MAPPING_CODE = :1' ;
l_stmt := 'delete BNE_RAW_QUERY
where application_id = 271 and QUERY_CODE = :1' ;
l_stmt := 'delete BNE_QUERIES_B
where application_id = 271 and QUERY_CODE = :1' ;
l_stmt := 'delete BNE_QUERIES_TL
where application_id = 271 and QUERY_CODE = :1' ;
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'')' ;
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'')' ;
l_stmt := 'delete BNE_PARAM_LISTS_B
where application_id = 271 and PARAM_LIST_CODE = :1' ;
l_stmt := 'delete BNE_PARAM_LISTS_TL
where application_id = 271 and PARAM_LIST_CODE = :1' ;
l_stmt := 'delete BNE_PARAM_LIST_ITEMS
where application_id = 271 and PARAM_LIST_CODE = :1' ;
l_stmt := 'delete BNE_DUPLICATE_PROFILES_B
where application_id = 271 and (DUP_PROFILE_CODE = :1
or DUP_PROFILE_CODE = :2)' ;
l_stmt := 'delete BNE_DUPLICATE_PROFILES_TL
where application_id = 271 and (DUP_PROFILE_CODE = :1
or DUP_PROFILE_CODE = :2)' ;
l_stmt := 'delete BNE_DUP_INTERFACE_PROFILES
where INTERFACE_APP_ID = 271 and INTERFACE_CODE = :1' ;
l_stmt := 'delete BNE_DUP_INTERFACE_COLS
where INTERFACE_APP_ID = 271 and INTERFACE_CODE = :1' ;
l_stmt := 'delete BNE_INTERFACE_KEYS
where application_id = 271 and KEY_CODE = :1' ;
l_stmt := 'delete BNE_INTERFACE_KEY_COLS
where application_id = 271 and KEY_CODE = :1' ;
SELECT meaning
INTO lookup_value
FROM bsc_lookups
WHERE APPLICATION_ID=271 and lookup_type = type AND lookup_code = code ;
delete bne_integrators_b where application_id = 271;
delete bne_integrators_tl where application_id = 271;
delete BNE_SECURITY_RULES WHERE application_id = 271;
delete BNE_SECURED_OBJECTS WHERE application_id = 271;
delete bne_interfaces_b where application_id = 271;
delete bne_interfaces_tl where application_id = 271;
delete bne_interface_cols_b where application_id = 271;
delete bne_interface_cols_tl where application_id = 271;
delete bne_layouts_b where application_id = 271;
delete bne_layouts_tl where application_id = 271;
delete bne_contents_b where application_id = 271;
delete bne_contents_tl where application_id = 271;
delete bne_layout_blocks_b where application_id = 271;
delete bne_layout_blocks_tl where application_id = 271;
delete bne_layout_cols where application_id = 271;