APPS.BSC_UPDATE_SUM dependencies on BSC_DB_TABLES

Line 447: bsc_db_tables

443: END IF;
444:
445: -- Store the update period of summary table
446: UPDATE
447: bsc_db_tables
448: SET
449: current_period = h_period
450: WHERE
451: table_name = x_sum_table;

Line 572: FROM bsc_kpi_data_tables kt, bsc_db_tables t

568: h_num_origin_pts NUMBER;
569:
570: CURSOR c_other_tables (p_pt_name VARCHAR2, p_table_name VARCHAR2) IS
571: SELECT DISTINCT kt.table_name, t.project_flag
572: FROM bsc_kpi_data_tables kt, bsc_db_tables t
573: WHERE kt.projection_data = p_pt_name AND
574: kt.table_name <> p_table_name AND
575: kt.table_name = t.table_name;
576:

Line 600: FROM bsc_kpi_data_tables kt, bsc_sys_periodicities p, bsc_db_tables t

596: h_num_pt_periodicities NUMBER;
597:
598: CURSOR c_pt_periodicities (p_pt_name VARCHAR2) IS
599: SELECT DISTINCT p.periodicity_id, p.yearly_flag, t.current_period
600: FROM bsc_kpi_data_tables kt, bsc_sys_periodicities p, bsc_db_tables t
601: WHERE kt.projection_data = p_pt_name AND
602: kt.periodicity_id = p.periodicity_id AND
603: kt.table_name = t.table_name;
604:

Line 707: bsc_db_tables

703: END IF;
704:
705: -- Store the update period of summary table
706: UPDATE
707: bsc_db_tables
708: SET
709: current_period = h_period
710: WHERE
711: table_name = x_sum_table;

Line 741: FROM bsc_db_tables

737: h_process_pt := TRUE;
738:
739: -- Get the projection flag of this table
740: SELECT project_flag INTO h_project_flag
741: FROM bsc_db_tables
742: WHERE table_name = x_sum_table;
743:
744: IF h_project_flag = 1 THEN
745: h_projection_flag := 'YES';

Line 1177: bsc_db_tables

1173: END IF;
1174:
1175: -- Store the update period of summary table
1176: UPDATE
1177: bsc_db_tables
1178: SET
1179: current_period = h_period
1180: WHERE
1181: table_name = x_sum_table;

Line 2147: ' FROM bsc_db_tables'||

2143:
2144: /*
2145: c_current_period t_cursor; -- h_table_name
2146: c_current_period_sql VARCHAR2(2000) := 'SELECT NVL(current_period, 0)'||
2147: ' FROM bsc_db_tables'||
2148: ' WHERE table_name = :1';
2149: */
2150:
2151: h_current_period NUMBER;

Line 2172: FROM bsc_db_tables

2168: */
2169: BEGIN
2170: SELECT NVL(current_period, 0)
2171: INTO h_current_period
2172: FROM bsc_db_tables
2173: WHERE table_name = h_table_name;
2174: EXCEPTION
2175: WHEN NO_DATA_FOUND THEN
2176: h_current_period := 0;

Line 2196: FROM bsc_db_tables

2192: */
2193: BEGIN
2194: SELECT NVL(current_period, 0)
2195: INTO h_current_period
2196: FROM bsc_db_tables
2197: WHERE table_name = h_table_name;
2198: EXCEPTION
2199: WHEN NO_DATA_FOUND THEN
2200: h_current_period := 0;

Line 2234: ' FROM bsc_db_tables_rels'||

2230:
2231: /*
2232: c_origin_tables t_cursor; -- x_table_name, 0
2233: c_origin_tables_sql VARCHAR2(2000) := 'SELECT source_table_name'||
2234: ' FROM bsc_db_tables_rels'||
2235: ' WHERE table_name = :1 AND relation_type = :2';
2236: */
2237: CURSOR c_origin_tables (p_table_name VARCHAR2, p_relation_type NUMBER) IS
2238: SELECT source_table_name

Line 2239: FROM bsc_db_tables_rels

2235: ' WHERE table_name = :1 AND relation_type = :2';
2236: */
2237: CURSOR c_origin_tables (p_table_name VARCHAR2, p_relation_type NUMBER) IS
2238: SELECT source_table_name
2239: FROM bsc_db_tables_rels
2240: WHERE table_name = p_table_name AND relation_type = p_relation_type;
2241:
2242: h_origin_table bsc_db_tables_rels.source_table_name%TYPE;
2243:

Line 2242: h_origin_table bsc_db_tables_rels.source_table_name%TYPE;

2238: SELECT source_table_name
2239: FROM bsc_db_tables_rels
2240: WHERE table_name = p_table_name AND relation_type = p_relation_type;
2241:
2242: h_origin_table bsc_db_tables_rels.source_table_name%TYPE;
2243:
2244: BEGIN
2245: --OPEN c_origin_tables FOR c_origin_tables_sql USING x_table_name, 0;
2246: OPEN c_origin_tables(x_table_name, 0);