APPS.BSC_TEMPLATE dependencies on BSC_SYS_INIT

Line 43: From BSC_SYS_INIT

39: LOOKUP_VALUES_TABLE := 'FND_LOOKUP_VALUES';
40:
41: Select PROPERTY_VALUE
42: Into l_sys_type
43: From BSC_SYS_INIT
44: Where PROPERTY_CODE = 'MODEL_TYPE';
45:
46: -- DBMS_OUTPUT.PUT_LINE('sys_type=' || l_sys_type);
47:

Line 55: Update BSC_SYS_INIT

51: end if;
52:
53: -- set system name
54:
55: Update BSC_SYS_INIT
56: Set PROPERTY_VALUE = x_sys_name , LAST_UPDATED_BY =2,LAST_UPDATE_DATE=SYSDATE
57: Where PROPERTY_CODE = 'SYSTEM_NAME';
58:
59: Update BSC_SYS_INIT

Line 59: Update BSC_SYS_INIT

55: Update BSC_SYS_INIT
56: Set PROPERTY_VALUE = x_sys_name , LAST_UPDATED_BY =2,LAST_UPDATE_DATE=SYSDATE
57: Where PROPERTY_CODE = 'SYSTEM_NAME';
58:
59: Update BSC_SYS_INIT
60: Set PROPERTY_VALUE = to_char(x_template_type),LAST_UPDATED_BY =2,LAST_UPDATE_DATE=SYSDATE
61: Where PROPERTY_CODE = 'MODEL_TYPE';
62:
63:

Line 250: l_debug_stmt := 'Updating BSC_SYS_INIT.MODEL_TYPE';

246: l_debug_stmt := 'Deleting from BSC_TABS_TL table';
247: Delete From BSC_TABS_TL;
248:
249:
250: l_debug_stmt := 'Updating BSC_SYS_INIT.MODEL_TYPE';
251: Update BSC_SYS_INIT Set PROPERTY_VALUE= '-1',LAST_UPDATED_BY =2,LAST_UPDATE_DATE=SYSDATE
252: Where PROPERTY_CODE= 'MODEL_TYPE';
253:
254:

Line 251: Update BSC_SYS_INIT Set PROPERTY_VALUE= '-1',LAST_UPDATED_BY =2,LAST_UPDATE_DATE=SYSDATE

247: Delete From BSC_TABS_TL;
248:
249:
250: l_debug_stmt := 'Updating BSC_SYS_INIT.MODEL_TYPE';
251: Update BSC_SYS_INIT Set PROPERTY_VALUE= '-1',LAST_UPDATED_BY =2,LAST_UPDATE_DATE=SYSDATE
252: Where PROPERTY_CODE= 'MODEL_TYPE';
253:
254:
255: l_debug_stmt := 'Updating BSC_SYS_INIT.SYSTEM_NAME';

Line 255: l_debug_stmt := 'Updating BSC_SYS_INIT.SYSTEM_NAME';

251: Update BSC_SYS_INIT Set PROPERTY_VALUE= '-1',LAST_UPDATED_BY =2,LAST_UPDATE_DATE=SYSDATE
252: Where PROPERTY_CODE= 'MODEL_TYPE';
253:
254:
255: l_debug_stmt := 'Updating BSC_SYS_INIT.SYSTEM_NAME';
256: Update BSC_SYS_INIT Set PROPERTY_VALUE= 'NoSystem',LAST_UPDATED_BY =2,LAST_UPDATE_DATE=SYSDATE
257: Where PROPERTY_CODE= 'SYSTEM_NAME';
258:
259:

Line 256: Update BSC_SYS_INIT Set PROPERTY_VALUE= 'NoSystem',LAST_UPDATED_BY =2,LAST_UPDATE_DATE=SYSDATE

252: Where PROPERTY_CODE= 'MODEL_TYPE';
253:
254:
255: l_debug_stmt := 'Updating BSC_SYS_INIT.SYSTEM_NAME';
256: Update BSC_SYS_INIT Set PROPERTY_VALUE= 'NoSystem',LAST_UPDATED_BY =2,LAST_UPDATE_DATE=SYSDATE
257: Where PROPERTY_CODE= 'SYSTEM_NAME';
258:
259:
260: Select count(*)