APPS.BSC_UPDATE_UTIL dependencies on BSC_SYS_INIT

Line 2488: ' FROM bsc_sys_init'||

2484:
2485: /*
2486: c_init t_cursor; -- x_variable_name
2487: c_init_sql VARCHAR2(2000) := 'SELECT property_value'||
2488: ' FROM bsc_sys_init'||
2489: ' WHERE property_code = :1';
2490: */
2491:
2492: h_message VARCHAR2(4000);

Line 2510: FROM bsc_sys_init

2506: */
2507: BEGIN
2508: SELECT property_value
2509: INTO x_variable_value
2510: FROM bsc_sys_init
2511: WHERE property_code = x_variable_name;
2512: EXCEPTION
2513: WHEN NO_DATA_FOUND THEN
2514: h_message := BSC_UPDATE_UTIL.Get_Message('BSC_VAR_NOT_FOUND');

Line 5431: h_sql := 'UPDATE bsc_sys_init'||

5427: -- Vinod and Kris and Venu, we should use FNG_GLOBAL.user_id
5428: h_user_id := BSC_APPS.fnd_global_user_id;
5429:
5430: /*
5431: h_sql := 'UPDATE bsc_sys_init'||
5432: ' SET last_updated_by = :1,'||
5433: ' last_update_date = SYSDATE'||
5434: ' WHERE property_code = :2';
5435: EXECUTE IMMEDIATE h_sql USING h_user_id, h_lock_property_code;

Line 5437: UPDATE bsc_sys_init

5433: ' last_update_date = SYSDATE'||
5434: ' WHERE property_code = :2';
5435: EXECUTE IMMEDIATE h_sql USING h_user_id, h_lock_property_code;
5436: */
5437: UPDATE bsc_sys_init
5438: SET last_updated_by = h_user_id,
5439: last_update_date = SYSDATE
5440: WHERE property_code = h_lock_property_code;
5441:

Line 5948: h_sql := 'UPDATE bsc_sys_init'||

5944: -- Vinod and Kris and Venu, we should use FNG_GLOBAL.user_id
5945: h_user_id := BSC_APPS.fnd_global_user_id;
5946:
5947: /*
5948: h_sql := 'UPDATE bsc_sys_init'||
5949: ' SET property_value = :1,'||
5950: ' last_updated_by = :2,'||
5951: ' last_update_date = SYSDATE'||
5952: ' WHERE property_code = :3';

Line 5955: UPDATE bsc_sys_init

5951: ' last_update_date = SYSDATE'||
5952: ' WHERE property_code = :3';
5953: EXECUTE IMMEDIATE h_sql USING x_variable_value, h_user_id, x_variable_name;
5954: */
5955: UPDATE bsc_sys_init
5956: SET property_value = x_variable_value,
5957: last_updated_by = h_user_id,
5958: last_update_date = SYSDATE
5959: WHERE property_code = x_variable_name;

Line 5963: h_sql := 'INSERT INTO bsc_sys_init (property_code, property_value,'||

5959: WHERE property_code = x_variable_name;
5960:
5961: IF SQL%NOTFOUND THEN
5962: /*
5963: h_sql := 'INSERT INTO bsc_sys_init (property_code, property_value,'||
5964: ' created_by, creation_date, last_updated_by, last_update_date)'||
5965: ' VALUES (:1, :2, :3, SYSDATE, :4 , SYSDATE)';
5966: EXECUTE IMMEDIATE h_sql USING x_variable_name, x_variable_value, h_user_id, h_user_id;
5967: */

Line 5968: INSERT INTO bsc_sys_init (property_code, property_value,

5964: ' created_by, creation_date, last_updated_by, last_update_date)'||
5965: ' VALUES (:1, :2, :3, SYSDATE, :4 , SYSDATE)';
5966: EXECUTE IMMEDIATE h_sql USING x_variable_name, x_variable_value, h_user_id, h_user_id;
5967: */
5968: INSERT INTO bsc_sys_init (property_code, property_value,
5969: created_by, creation_date, last_updated_by, last_update_date)
5970: VALUES (x_variable_name, x_variable_value, h_user_id, SYSDATE, h_user_id , SYSDATE);
5971: END IF;
5972:

Line 6006: l_variable BSC_SYS_INIT.Property_Code%TYPE;

6002: (
6003: p_Product IN VARCHAR2
6004: ) RETURN VARCHAR2
6005: IS
6006: l_variable BSC_SYS_INIT.Property_Code%TYPE;
6007: l_version BSC_SYS_INIT.Property_Value%TYPE;
6008: BEGIN
6009: l_variable := NULL;
6010: l_version := NULL;

Line 6007: l_version BSC_SYS_INIT.Property_Value%TYPE;

6003: p_Product IN VARCHAR2
6004: ) RETURN VARCHAR2
6005: IS
6006: l_variable BSC_SYS_INIT.Property_Code%TYPE;
6007: l_version BSC_SYS_INIT.Property_Value%TYPE;
6008: BEGIN
6009: l_variable := NULL;
6010: l_version := NULL;
6011:

Line 6045: l_variable BSC_SYS_INIT.Property_Code%TYPE;

6041: p_Product IN VARCHAR2
6042: , p_Version IN VARCHAR2
6043: ) RETURN BOOLEAN
6044: IS
6045: l_variable BSC_SYS_INIT.Property_Code%TYPE;
6046: BEGIN
6047: l_variable := NULL;
6048:
6049: IF (p_Product = BSC_UPDATE_UTIL.G_BIA) THEN