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.

[Home] [Help]

APPS.BSC_UTILITY dependencies on BSC_SYS_INIT

Line 580: -- Purpose: To ENABLE/DISABLE bsc_sys_init.property_code = 'EDW_INSTALLED'.

576: -----------------------------------------------------------------------------
577: -- Procedure: update_edw_flag (for BSC v5.0)
578: -----------------------------------------------------------------------------
579:
580: -- Purpose: To ENABLE/DISABLE bsc_sys_init.property_code = 'EDW_INSTALLED'.
581: -- This procedure is called by BUILDER.
582: --
583: -- We do the same checks as in is_edw_installed() function since
584: -- from the time EDW is installed/implemented, the objects

Line 612: l_property_code bsc_sys_init.property_code%TYPE := 'EDW_INSTALLED';

608: l_count NUMBER := 0;
609: l_message VARCHAR2(1024) := NULL;
610: l_call_proc VARCHAR2(1024) := NULL;
611: l_object_name VARCHAR2(30) := NULL;
612: l_property_code bsc_sys_init.property_code%TYPE := 'EDW_INSTALLED';
613: l_property_value bsc_sys_init.property_value%TYPE;
614:
615: l_sql_stmt VARCHAR2(512);
616:

Line 613: l_property_value bsc_sys_init.property_value%TYPE;

609: l_message VARCHAR2(1024) := NULL;
610: l_call_proc VARCHAR2(1024) := NULL;
611: l_object_name VARCHAR2(30) := NULL;
612: l_property_code bsc_sys_init.property_code%TYPE := 'EDW_INSTALLED';
613: l_property_value bsc_sys_init.property_value%TYPE;
614:
615: l_sql_stmt VARCHAR2(512);
616:
617: BEGIN

Line 719: UPDATE bsc_sys_init

715: -- Now, we can update property_value for EDW_INSTALLED property_code.
716:
717: BEGIN -- Update EDW_INSTALLED flag
718:
719: UPDATE bsc_sys_init
720: SET property_value = 'TRUE'
721: WHERE property_code = l_property_code
722: AND property_value = 'FALSE';
723:

Line 744: --dbms_output.put_line('Updated bsc_sys_init.EDW_INSTALLED = TRUE.');

740: -- EDW_TIME_M synonym from BSC schema. This is done only once.
741: --
742: create_synonym_for_edw_time_m(l_call_proc);
743:
744: --dbms_output.put_line('Updated bsc_sys_init.EDW_INSTALLED = TRUE.');
745:
746:
747: <>
748: NULL;

Line 790: UPDATE bsc_sys_init

786: IF (l_count = 0) THEN
787:
788: BEGIN -- Update EDW_INSTALLED flag
789:
790: UPDATE bsc_sys_init
791: SET property_value = 'FALSE'
792: WHERE property_code = l_property_code
793: AND property_value = 'TRUE';
794:

Line 795: --dbms_output.put_line('Updated bsc_sys_init.EDW_INSTALLED = FALSE.');

791: SET property_value = 'FALSE'
792: WHERE property_code = l_property_code
793: AND property_value = 'TRUE';
794:
795: --dbms_output.put_line('Updated bsc_sys_init.EDW_INSTALLED = FALSE.');
796:
797: EXCEPTION
798: WHEN OTHERS THEN
799:

Line 978: from BSC_SYS_INIT

974: begin
975:
976: select to_char(last_update_date, 'DD-MON-YYYY-HH24-MI-SS')
977: into l_timestamp
978: from BSC_SYS_INIT
979: where property_code = 'LOCK_SYSTEM';
980:
981: return l_timestamp;
982:

Line 1314: l_property_value BSC_SYS_INIT.Property_Value%TYPE;

1310: *********************************************************************************/
1311: FUNCTION isBscInProductionMode
1312: RETURN BOOLEAN
1313: IS
1314: l_property_value BSC_SYS_INIT.Property_Value%TYPE;
1315:
1316: CURSOR c_isBscInProductionMode IS
1317: SELECT Property_Value
1318: FROM BSC_SYS_INIT

Line 1318: FROM BSC_SYS_INIT

1314: l_property_value BSC_SYS_INIT.Property_Value%TYPE;
1315:
1316: CURSOR c_isBscInProductionMode IS
1317: SELECT Property_Value
1318: FROM BSC_SYS_INIT
1319: WHERE PROPERTY_CODE ='SYSTEM_STAGE';
1320: BEGIN
1321: --DBMS_OUTPUT.PUT_LINE('Entered inside BSC_BIS_DIM_OBJ_PUB.isBscInProductionMode Function');
1322: IF (c_isBscInProductionMode%ISOPEN) THEN

Line 1618: This API returns 'T' if table BSC_SYS_INIT.adv_sum_level is set >= 0, else returns 'F'

1614:
1615:
1616: /*********************************************************************************
1617:
1618: This API returns 'T' if table BSC_SYS_INIT.adv_sum_level is set >= 0, else returns 'F'
1619:
1620: Added for Start-to-End KPI Project.
1621: *********************************************************************************/
1622:

Line 1630: FROM BSC_SYS_INIT

1626: BEGIN
1627:
1628: SELECT property_value
1629: INTO l_Profile_Value
1630: FROM BSC_SYS_INIT
1631: WHERE property_code = 'ADV_SUM_LEVEL';
1632:
1633: IF (TO_NUMBER(NVL(l_Profile_Value, '-1')) >= 0) THEN
1634: RETURN FND_API.G_TRUE;

Line 1652: if table BSC_SYS_INIT.adv_sum_level is set >= 0, else returns 'F'

1648:
1649: /*********************************************************************************
1650:
1651: This API returns 'T' if the Advance Summarization is set >= 0 or
1652: if table BSC_SYS_INIT.adv_sum_level is set >= 0, else returns 'F'
1653:
1654: Added for Start-to-End KPI Project.
1655: *********************************************************************************/
1656:

Line 1910: FROM BSC_SYS_INIT B

1906: l_Count := 0;
1907: l_Return := FND_API.G_FALSE;
1908:
1909: SELECT COUNT(1) INTO l_Count
1910: FROM BSC_SYS_INIT B
1911: WHERE B.PROPERTY_CODE = c_MIXED_DIM_OBJS
1912: AND B.PROPERTY_VALUE > 0;
1913:
1914: IF (l_Count > 0) THEN