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_UPDATE_CALC dependencies on BSC_DB_CALCULATIONS

Line 26: ' FROM bsc_db_calculations'||

22: ' FROM bsc_kpi_data_tables'||
23: ' WHERE table_name = :1 OR'||
24: ' table_name = ('||
25: ' SELECT DISTINCT table_name'||
26: ' FROM bsc_db_calculations'||
27: ' WHERE parameter1 = :2 AND'||
28: ' calculation_type = :3)'; */
29: cursor c_indicator( pTableName varchar2, pParam1 varchar2,pCalcType number) is
30: SELECT indicator, dim_set_id

Line 35: FROM bsc_db_calculations

31: FROM bsc_kpi_data_tables
32: WHERE table_name = pTableName
33: OR table_name = (
34: SELECT DISTINCT table_name
35: FROM bsc_db_calculations
36: WHERE parameter1 = pParam1
37: AND calculation_type = pCalcType );
38: h_calculation_type NUMBER;
39:

Line 150: FROM bsc_db_calculations

146: h_sql VARCHAR2(32700);
147:
148: cursor c_account_key( pTableName varchar2,pCalcType number) is
149: SELECT parameter1
150: FROM bsc_db_calculations
151: WHERE table_name = pTableName AND
152: calculation_type = pCalcType ;
153:
154: h_calculation_type NUMBER;

Line 1621: -- Meaning of parameters in bsc_db_calculations

1617: -- x_zero_code_calc_method = 4
1618: -- Calculate the zero code for one or more key columns that
1619: -- are independents (Example: region_code, product_code)
1620:
1621: -- Meaning of parameters in bsc_db_calculations
1622: -- parameter1 = key column name
1623: -- parameter2 = order
1624: -- parameter3 = data column name
1625: -- parameter4 = condition

Line 1638: FROM bsc_db_calculations

1634:
1635: cursor c_key_columns(pTableName varchar2, pCalcType number,
1636: pSrcTableName varchar2, pSrcCalcType number) is
1637: SELECT parameter1
1638: FROM bsc_db_calculations
1639: WHERE table_name = pTableName
1640: AND calculation_type = pCalcType
1641: AND parameter1 NOT IN (
1642: SELECT parameter1

Line 1643: FROM bsc_db_calculations

1639: WHERE table_name = pTableName
1640: AND calculation_type = pCalcType
1641: AND parameter1 NOT IN (
1642: SELECT parameter1
1643: FROM bsc_db_calculations
1644: WHERE table_name = pSrcTableName
1645: AND calculation_type = pSrcCalcType
1646: )
1647: GROUP BY parameter1, TO_NUMBER(parameter2)

Line 1650: h_key_zero_code bsc_db_calculations.parameter1%TYPE;

1646: )
1647: GROUP BY parameter1, TO_NUMBER(parameter2)
1648: ORDER BY TO_NUMBER(parameter2);
1649:
1650: h_key_zero_code bsc_db_calculations.parameter1%TYPE;
1651:
1652: cursor c_keys_needing_zero_code(pTableName varchar2) is
1653: SELECT DISTINCT c.parameter1
1654: FROM bsc_db_calculations c, bsc_kpi_data_tables kt, bsc_kpi_data_tables ktp

Line 1654: FROM bsc_db_calculations c, bsc_kpi_data_tables kt, bsc_kpi_data_tables ktp

1650: h_key_zero_code bsc_db_calculations.parameter1%TYPE;
1651:
1652: cursor c_keys_needing_zero_code(pTableName varchar2) is
1653: SELECT DISTINCT c.parameter1
1654: FROM bsc_db_calculations c, bsc_kpi_data_tables kt, bsc_kpi_data_tables ktp
1655: WHERE c.table_name = kt.table_name AND
1656: c.calculation_type = 4 AND
1657: kt.indicator = ktp.indicator AND
1658: kt.dim_set_id = ktp.dim_set_id AND

Line 1727: -- Keys needing zero code may not be configured in bsc_db_calculations for this table,

1723: CLOSE c_key_columns;
1724:
1725: -- Bug#3542344: Only in summary tables architecture, when this table receives targets,
1726: -- we need to re-calculate the zero code on keys needing zero.
1727: -- Keys needing zero code may not be configured in bsc_db_calculations for this table,
1728: -- for this reason we need to look in the origin tables until the base table looking
1729: -- for the keys that calcualted zero code.
1730: IF NOT BSC_APPS.bsc_mv THEN
1731: -- Only for summary tables architecture

Line 1734: FROM bsc_db_calculations

1730: IF NOT BSC_APPS.bsc_mv THEN
1731: -- Only for summary tables architecture
1732: SELECT count(table_name)
1733: INTO h_count
1734: FROM bsc_db_calculations
1735: WHERE table_name = x_table_name AND calculation_type = 5;
1736:
1737: IF h_count > 0 THEN
1738: -- This table receives targets

Line 2533: ' FROM bsc_db_calculations'||

2529: TYPE t_cursor IS REF CURSOR;
2530:
2531: /* c_calculation_type t_cursor;
2532: c_calculation_type_sql VARCHAR2(2000) := 'SELECT calculation_type'||
2533: ' FROM bsc_db_calculations'||
2534: ' WHERE table_name = :1 AND'||
2535: ' (calculation_type = :2 OR calculation_type = :3)'; */
2536: cursor c_calculation_type ( pTableName varchar2, pCalcType number, pCalcType2 number ) is
2537: SELECT calculation_type

Line 2538: FROM bsc_db_calculations

2534: ' WHERE table_name = :1 AND'||
2535: ' (calculation_type = :2 OR calculation_type = :3)'; */
2536: cursor c_calculation_type ( pTableName varchar2, pCalcType number, pCalcType2 number ) is
2537: SELECT calculation_type
2538: FROM bsc_db_calculations
2539: WHERE table_name = pTableName
2540: AND (calculation_type = pCalcType OR calculation_type = pCalcType2) ;
2541:
2542: h_calculation_type NUMBER;

Line 2582: ' FROM bsc_db_calculations'||

2578: TYPE t_cursor IS REF CURSOR;
2579:
2580: /* c_source_tables t_cursor;
2581: c_source_tables_sql VARCHAR2(2000) := 'SELECT DISTINCT parameter1'||
2582: ' FROM bsc_db_calculations'||
2583: ' WHERE table_name = :1 AND'||
2584: ' calculation_type = :2'; */
2585: cursor c_source_tables(pTableName varchar2, pCalcType number) is
2586: SELECT DISTINCT parameter1

Line 2587: FROM bsc_db_calculations

2583: ' WHERE table_name = :1 AND'||
2584: ' calculation_type = :2'; */
2585: cursor c_source_tables(pTableName varchar2, pCalcType number) is
2586: SELECT DISTINCT parameter1
2587: FROM bsc_db_calculations
2588: WHERE table_name = pTableName
2589: AND calculation_type = pCalcType ;
2590:
2591: h_source_table VARCHAR2(30);

Line 2595: ' FROM bsc_db_calculations'||

2591: h_source_table VARCHAR2(30);
2592:
2593: /* c_data_columns t_cursor;
2594: c_data_columns_sql VARCHAR2(2000) := 'SELECT parameter2'||
2595: ' FROM bsc_db_calculations'||
2596: ' WHERE table_name = :1 AND'||
2597: ' calculation_type = :2 AND'||
2598: ' parameter1 = :3'; */
2599: cursor c_data_columns(pTableName varchar2,pCalcType number, pParam1 varchar2) is

Line 2601: FROM bsc_db_calculations

2597: ' calculation_type = :2 AND'||
2598: ' parameter1 = :3'; */
2599: cursor c_data_columns(pTableName varchar2,pCalcType number, pParam1 varchar2) is
2600: SELECT parameter2
2601: FROM bsc_db_calculations
2602: WHERE table_name = pTableName
2603: AND calculation_type = pCalcType
2604: AND parameter1 = pParam1 ;
2605:

Line 3384: FROM bsc_db_calculations

3380: ) RETURN BOOLEAN IS
3381:
3382: cursor c_profit_calc (pTableName varchar2,pCalcType number) is
3383: SELECT calculation_type
3384: FROM bsc_db_calculations
3385: WHERE table_name = pTableName
3386: AND calculation_type = pCalcType;
3387:
3388: h_profit_calc bsc_db_calculations.calculation_type%TYPE;

Line 3388: h_profit_calc bsc_db_calculations.calculation_type%TYPE;

3384: FROM bsc_db_calculations
3385: WHERE table_name = pTableName
3386: AND calculation_type = pCalcType;
3387:
3388: h_profit_calc bsc_db_calculations.calculation_type%TYPE;
3389: h_ret BOOLEAN;
3390:
3391: BEGIN
3392: -- OPEN c_profit_calc FOR c_profit_calc_sql USING x_table_name, 1;