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.BSC_WEB_ADI_LOADER_PKG dependencies on BSC_WEB_ADI_LOADER_PKG

Line 1: package body BSC_WEB_ADI_LOADER_PKG AS

1: package body BSC_WEB_ADI_LOADER_PKG AS
2: /*$Header: BSCWADIB.pls 120.8.12000000.2 2007/06/08 12:41:25 karthmoh ship $*/
3:
4: g_bsc_schema VARCHAR2(32);
5:

Line 440: BSC_WEB_ADI_LOADER_PKG.get_lookup_value(''BSC_PMA_WEBADI_UPL_ROW'',''ROWS_UPL''),null,

436: l_stmt := 'INSERT INTO BNE_PARAM_DEFNS_TL(APPLICATION_ID, PARAM_DEFN_CODE, LANGUAGE, SOURCE_LANG, USER_NAME,
437: DEFAULT_STRING, DEFAULT_DESC, PROMPT_LEFT, PROMPT_ABOVE, USER_TIP, ACCESS_KEY,
438: LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN ) VALUES (
439: 271,'''|| TAB_NAME ||'_ROW'',USERENV(''LANG''),USERENV(''LANG''),''Flagged rows'',null,''flagged rows'',
440: BSC_WEB_ADI_LOADER_PKG.get_lookup_value(''BSC_PMA_WEBADI_UPL_ROW'',''ROWS_UPL''),null,
441: null,null,sysdate, 2, sysdate, 2, 0)';
442: EXECUTE IMMEDIATE L_STMT;
443:
444: IF (key_cols > 0) then

Line 449: BSC_WEB_ADI_LOADER_PKG.get_lookup_value(''BSC_PMA_WEBADI_UPL_DUP'',''DUPLICATE_REC''),

445: l_stmt := 'INSERT INTO BNE_PARAM_DEFNS_TL(APPLICATION_ID, PARAM_DEFN_CODE, LANGUAGE, SOURCE_LANG, USER_NAME,
446: DEFAULT_STRING, DEFAULT_DESC, PROMPT_LEFT, PROMPT_ABOVE, USER_TIP, ACCESS_KEY,
447: LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN ) VALUES (
448: 271,'''|| TAB_NAME ||'_DUP'',USERENV(''LANG''),USERENV(''LANG''),''Duplicate Parameter Query'' ,null,''Update Columns'',
449: BSC_WEB_ADI_LOADER_PKG.get_lookup_value(''BSC_PMA_WEBADI_UPL_DUP'',''DUPLICATE_REC''),
450: null,null,null,sysdate, 2, sysdate, 2, 0)'; --BSC_LOOKUPS
451: EXECUTE IMMEDIATE L_STMT;
452: end if;
453:

Line 606: BSC_WEB_ADI_LOADER_PKG.get_lookup_value(''BSC_PMA_WEBADI_UPL_ERR'',''ERROR_DUP''),sysdate, 2, sysdate, 2, 0)';

602: -- Duplicate Profile TL
603: l_stmt := 'INSERT INTO BNE_DUPLICATE_PROFILES_TL(APPLICATION_ID, DUP_PROFILE_CODE, LANGUAGE, SOURCE_LANG, USER_NAME,
604: LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN ) VALUES (
605: 271,'''|| TAB_NAME ||'_ERR'',USERENV(''LANG''),USERENV(''LANG''),
606: BSC_WEB_ADI_LOADER_PKG.get_lookup_value(''BSC_PMA_WEBADI_UPL_ERR'',''ERROR_DUP''),sysdate, 2, sysdate, 2, 0)';
607: EXECUTE IMMEDIATE L_STMT;
608:
609: -- Associating Duplicate Profile with Interface list
610: l_stmt := 'INSERT INTO BNE_DUP_INTERFACE_PROFILES(INTERFACE_APP_ID, INTERFACE_CODE, DUP_PROFILE_APP_ID,

Line 628: BSC_WEB_ADI_LOADER_PKG.get_lookup_value(''BSC_PMA_WEBADI_UPL_REP'',''REPLACE_DUP''),sysdate, 2, sysdate, 2, 0)'; --BSC_LOOKUPS

624: -- Duplicate Profile TL
625: l_stmt := 'INSERT INTO BNE_DUPLICATE_PROFILES_TL(APPLICATION_ID, DUP_PROFILE_CODE, LANGUAGE, SOURCE_LANG, USER_NAME,
626: LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN ) VALUES (
627: 271,'''|| TAB_NAME ||'_REP'',USERENV(''LANG''),USERENV(''LANG''),
628: BSC_WEB_ADI_LOADER_PKG.get_lookup_value(''BSC_PMA_WEBADI_UPL_REP'',''REPLACE_DUP''),sysdate, 2, sysdate, 2, 0)'; --BSC_LOOKUPS
629: EXECUTE IMMEDIATE L_STMT;
630:
631: -- Associating Duplicate Profile with Interface list
632: l_stmt := 'INSERT INTO BNE_DUP_INTERFACE_PROFILES(INTERFACE_APP_ID, INTERFACE_CODE, DUP_PROFILE_APP_ID,

Line 954: END BSC_WEB_ADI_LOADER_PKG;

950: delete bne_layout_blocks_tl where application_id = 271;
951: delete bne_layout_cols where application_id = 271;
952: END;*/
953:
954: END BSC_WEB_ADI_LOADER_PKG;