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_BASE_V2 dependencies on BSC_APPS

Line 207: IF BSC_APPS.bsc_mv AND (NOT x_aw_flag) THEN

203:
204: END IF;
205:
206: -- Create types needed to load input table in MV architecture. Need to be here outside each job.
207: IF BSC_APPS.bsc_mv AND (NOT x_aw_flag) THEN
208: Create_Types_For_MV_Load(x_base_table, h_key_columns, h_num_key_columns, h_data_columns, h_num_data_columns,
209: h_return_status, h_error_message);
210: IF h_return_status = 'error' THEN
211: RAISE e_create_types_for_mv_load;

Line 712: IF BSC_APPS.bsc_mv AND (NOT x_aw_flag) THEN

708: FOR h_i IN 1..x_num_key_columns LOOP
709: bsc_dbgen_utils.add_string(h_sql, x_key_columns(h_i)||', ');
710: END LOOP;
711: bsc_dbgen_utils.add_string(h_sql, 'year, type, period');
712: IF BSC_APPS.bsc_mv AND (NOT x_aw_flag) THEN
713: bsc_dbgen_utils.add_string(h_sql, ', periodicity_id');
714: END IF;
715: FOR h_i IN 1..x_num_data_columns LOOP
716: bsc_dbgen_utils.add_string(h_sql, ', '||x_data_columns(h_i));

Line 732: IF BSC_APPS.bsc_mv AND (NOT x_aw_flag) THEN

728: FOR h_i IN 1..x_num_key_columns LOOP
729: bsc_dbgen_utils.add_string(h_sql, 'p.key'||h_i||', ');
730: END LOOP;
731: bsc_dbgen_utils.add_string(h_sql, 'p.year, p.type, p.period');
732: IF BSC_APPS.bsc_mv AND (NOT x_aw_flag) THEN
733: bsc_dbgen_utils.add_string(h_sql, ', p.periodicity_id');
734: END IF;
735: FOR h_i IN 1..x_num_data_columns LOOP
736: bsc_dbgen_utils.add_string(h_sql, ', sum('||x_data_columns(h_i)||')');

Line 763: IF BSC_APPS.bsc_mv AND (NOT x_aw_flag) THEN

759: FOR h_i IN 1..x_num_key_columns LOOP
760: bsc_dbgen_utils.add_string(h_sql, 'p.key'||h_i||', ');
761: END LOOP;
762: bsc_dbgen_utils.add_string(h_sql, 'p.year, p.type, p.period');
763: IF BSC_APPS.bsc_mv AND (NOT x_aw_flag) THEN
764: bsc_dbgen_utils.add_string(h_sql, ', p.periodicity_id');
765: END IF;
766: FOR h_i IN 1..x_num_data_columns LOOP
767: IF x_data_proj_methods(h_i) = 3 THEN

Line 805: IF BSC_APPS.bsc_mv AND (NOT x_aw_flag) THEN

801: FOR h_i IN 1..x_num_key_columns LOOP
802: bsc_dbgen_utils.add_string(h_sql, 'a.'||x_key_columns(h_i)||' key'||h_i||', ');
803: END LOOP;
804: bsc_dbgen_utils.add_string(h_sql, 'bsc_tmp_all_periods.year, 0 type, bsc_tmp_all_periods.period');
805: IF BSC_APPS.bsc_mv AND (NOT x_aw_flag) THEN
806: bsc_dbgen_utils.add_string(h_sql, ', '||x_periodicity||' periodicity_id');
807: END IF;
808: bsc_dbgen_utils.add_string(h_sql, ' from (select');
809: IF BSC_UPDATE_UTIL.is_parallel AND x_parallel_jobs = 'N' THEN

Line 817: IF BSC_APPS.bsc_mv AND (NOT x_aw_flag) THEN

813: FOR h_i IN 1..x_num_key_columns LOOP
814: bsc_dbgen_utils.add_string(h_sql, ', '||x_key_columns(h_i));
815: END LOOP;
816: bsc_dbgen_utils.add_string(h_sql, ' from '||x_base_table);
817: IF BSC_APPS.bsc_mv AND (NOT x_aw_flag) THEN
818: bsc_dbgen_utils.add_string(h_sql, ' where periodicity_id = '||x_periodicity);
819: IF x_parallel_jobs = 'Y' THEN
820: bsc_dbgen_utils.add_string(h_sql, ' and '||BSC_DBGEN_STD_METADATA.BSC_BATCH_COLUMN_NAME||' = '||x_batch_value);
821: END IF;

Line 870: IF BSC_APPS.bsc_mv AND (NOT x_aw_flag) THEN

866: ' period >= '||h_per_ini||' and period <= '||x_current_period);
867: ELSE
868: bsc_dbgen_utils.add_string(h_sql, ' year >= '||h_year_ini||' and year <= '||x_current_fy||' and type = 1');
869: END IF;
870: IF BSC_APPS.bsc_mv AND (NOT x_aw_flag) THEN
871: bsc_dbgen_utils.add_string(h_sql, ' and periodicity_id = '||x_periodicity);
872: END IF;
873: IF x_parallel_jobs = 'Y' THEN
874: bsc_dbgen_utils.add_string(h_sql, ' and '||BSC_DBGEN_STD_METADATA.BSC_BATCH_COLUMN_NAME||' = '||x_batch_value);

Line 903: IF BSC_APPS.bsc_mv AND (NOT x_aw_flag) THEN

899: ' period >= '||h_per_ini||' and period <= '||x_current_period);
900: ELSE
901: bsc_dbgen_utils.add_string(h_sql, ' year >= '||h_year_ini||' and year <= '||x_current_fy||' and type = 0');
902: END IF;
903: IF BSC_APPS.bsc_mv AND (NOT x_aw_flag) THEN
904: bsc_dbgen_utils.add_string(h_sql, ' and periodicity_id = '||x_periodicity);
905: END IF;
906: IF x_parallel_jobs = 'Y' THEN
907: bsc_dbgen_utils.add_string(h_sql, ' and '||BSC_DBGEN_STD_METADATA.BSC_BATCH_COLUMN_NAME||' = '||x_batch_value);

Line 935: IF BSC_APPS.bsc_mv AND (NOT x_aw_flag) THEN

931: bsc_dbgen_utils.add_string(h_sql, ' year = '||x_current_fy||' and type = 1 and period > '||x_current_period);
932: ELSE
933: bsc_dbgen_utils.add_string(h_sql, ' year > '||x_current_fy||' and year <= '||h_max_year||' and type = 1');
934: END IF;
935: IF BSC_APPS.bsc_mv AND (NOT x_aw_flag) THEN
936: bsc_dbgen_utils.add_string(h_sql, ' and periodicity_id = '||x_periodicity);
937: END IF;
938: IF x_parallel_jobs = 'Y' THEN
939: bsc_dbgen_utils.add_string(h_sql, ' and '||BSC_DBGEN_STD_METADATA.BSC_BATCH_COLUMN_NAME||' = '||x_batch_value);

Line 972: IF BSC_APPS.bsc_mv AND (NOT x_aw_flag) THEN

968: FOR h_i IN 1..x_num_key_columns LOOP
969: bsc_dbgen_utils.add_string(h_sql, 'p.key'||h_i||', ');
970: END LOOP;
971: bsc_dbgen_utils.add_string(h_sql, 'p.year, p.type, p.period');
972: IF BSC_APPS.bsc_mv AND (NOT x_aw_flag) THEN
973: bsc_dbgen_utils.add_string(h_sql, ', p.periodicity_id');
974: END IF;
975: FOR h_i IN 1..x_num_data_columns LOOP
976: IF x_data_proj_methods(h_i) = 4 THEN

Line 994: IF BSC_APPS.bsc_mv AND (NOT x_aw_flag) THEN

990: FOR h_i IN 1..x_num_key_columns LOOP
991: bsc_dbgen_utils.add_string(h_sql, 'a.'||x_key_columns(h_i)||' key'||h_i||', ');
992: END LOOP;
993: bsc_dbgen_utils.add_string(h_sql, 'bsc_tmp_all_periods.year year, 0 type, bsc_tmp_all_periods.period period');
994: IF BSC_APPS.bsc_mv AND (NOT x_aw_flag) THEN
995: bsc_dbgen_utils.add_string(h_sql, ', '||x_periodicity||' periodicity_id');
996: END IF;
997: bsc_dbgen_utils.add_string(h_sql, ' from (select');
998: IF BSC_UPDATE_UTIL.is_parallel AND x_parallel_jobs = 'N' THEN

Line 1006: IF BSC_APPS.bsc_mv AND (NOT x_aw_flag) THEN

1002: FOR h_i IN 1..x_num_key_columns LOOP
1003: bsc_dbgen_utils.add_string(h_sql, ', '||x_key_columns(h_i));
1004: END LOOP;
1005: bsc_dbgen_utils.add_string(h_sql, ' from '||x_base_table);
1006: IF BSC_APPS.bsc_mv AND (NOT x_aw_flag) THEN
1007: bsc_dbgen_utils.add_string(h_sql, ' where periodicity_id = '||x_periodicity);
1008: IF x_parallel_jobs = 'Y' THEN
1009: bsc_dbgen_utils.add_string(h_sql, ' and '||BSC_DBGEN_STD_METADATA.BSC_BATCH_COLUMN_NAME||' = '||x_batch_value);
1010: END IF;

Line 1057: IF BSC_APPS.bsc_mv AND (NOT x_aw_flag) THEN

1053: bsc_dbgen_utils.add_string(h_sql, ' and year = '||x_current_fy||' and period > '||x_current_period);
1054: ELSE
1055: bsc_dbgen_utils.add_string(h_sql, ' and year > '||x_current_fy||' and year <= '||h_max_year);
1056: END IF;
1057: IF BSC_APPS.bsc_mv AND (NOT x_aw_flag) THEN
1058: bsc_dbgen_utils.add_string(h_sql, ' and periodicity_id = '||x_periodicity);
1059: END IF;
1060: IF x_parallel_jobs = 'Y' THEN
1061: bsc_dbgen_utils.add_string(h_sql, ' and '||BSC_DBGEN_STD_METADATA.BSC_BATCH_COLUMN_NAME||' = '||x_batch_value);

Line 1078: IF BSC_APPS.bsc_mv AND (NOT x_aw_flag) THEN

1074: FOR h_i IN 1..x_num_key_columns LOOP
1075: bsc_dbgen_utils.add_string(h_sql, ' p.key'||h_i||',');
1076: END LOOP;
1077: bsc_dbgen_utils.add_string(h_sql, ' p.year, p.type, p.period');
1078: IF BSC_APPS.bsc_mv AND (NOT x_aw_flag) THEN
1079: bsc_dbgen_utils.add_string(h_sql, ', p.periodicity_id');
1080: END IF;
1081: --Fix bug#5155388
1082: IF x_aw_flag THEN

Line 1128: IF BSC_APPS.bsc_mv AND (NOT x_aw_flag) THEN

1124: FOR h_i IN 1..x_num_key_columns LOOP
1125: bsc_dbgen_utils.add_string(h_sql, x_key_columns(h_i)||', ');
1126: END LOOP;
1127: bsc_dbgen_utils.add_string(h_sql, 'year, type, period');
1128: IF BSC_APPS.bsc_mv AND (NOT x_aw_flag) THEN
1129: bsc_dbgen_utils.add_string(h_sql, ', periodicity_id');
1130: END IF;
1131: FOR h_i IN 1..h_num_avg_cols LOOP
1132: bsc_dbgen_utils.add_string(h_sql, ', '||h_avg_cols(h_i));

Line 1136: IF BSC_APPS.bsc_mv AND (NOT x_aw_flag) THEN

1132: bsc_dbgen_utils.add_string(h_sql, ', '||h_avg_cols(h_i));
1133: END LOOP;
1134: bsc_dbgen_utils.add_string(h_sql, ' from '||x_base_table||
1135: ' where type = :1');
1136: IF BSC_APPS.bsc_mv AND (NOT x_aw_flag) THEN
1137: bsc_dbgen_utils.add_string(h_sql, ' and periodicity_id = :2');
1138: END IF;
1139: IF x_parallel_jobs = 'Y' THEN
1140: bsc_dbgen_utils.add_string(h_sql, ' and '||BSC_DBGEN_STD_METADATA.BSC_BATCH_COLUMN_NAME||' = :3');

Line 1151: IF BSC_APPS.bsc_mv AND (NOT x_aw_flag) THEN

1147: FOR h_i IN 1..x_num_key_columns LOOP
1148: bsc_dbgen_utils.add_string(h_sql, x_key_columns(h_i)||', ');
1149: END LOOP;
1150: bsc_dbgen_utils.add_string(h_sql, 'year, type, period');
1151: IF BSC_APPS.bsc_mv AND (NOT x_aw_flag) THEN
1152: bsc_dbgen_utils.add_string(h_sql, ', periodicity_id');
1153: END IF;
1154: FOR h_i IN 1..h_num_avg_cols LOOP
1155: bsc_dbgen_utils.add_string(h_sql, ', '||h_avg_cols(h_i));

Line 1159: IF BSC_APPS.bsc_mv AND (NOT x_aw_flag) THEN

1155: bsc_dbgen_utils.add_string(h_sql, ', '||h_avg_cols(h_i));
1156: END LOOP;
1157: bsc_dbgen_utils.add_string(h_sql, ' from '||x_proj_table||
1158: ' WHERE type = :4');
1159: IF BSC_APPS.bsc_mv AND (NOT x_aw_flag) THEN
1160: bsc_dbgen_utils.add_string(h_sql, ' and periodicity_id = :5');
1161: END IF;
1162: IF x_parallel_jobs = 'Y' THEN
1163: bsc_dbgen_utils.add_string(h_sql, ' and '||BSC_DBGEN_STD_METADATA.BSC_BATCH_COLUMN_NAME||' = :6');

Line 1176: IF BSC_APPS.bsc_mv AND (NOT x_aw_flag) THEN

1172: FOR h_i IN 1..x_num_key_columns LOOP
1173: bsc_dbgen_utils.add_string(h_sql, ' and p.'||x_key_columns(h_i)||' = u.'||x_key_columns(h_i));
1174: END LOOP;
1175: bsc_dbgen_utils.add_string(h_sql, ' and p.type = u.type');
1176: IF BSC_APPS.bsc_mv AND (NOT x_aw_flag) THEN
1177: bsc_dbgen_utils.add_string(h_sql, ' and p.periodicity_id = u.periodicity_id');
1178: END IF;
1179: bsc_dbgen_utils.add_string(h_sql, ')');
1180: IF h_yearly_flag = 1 THEN

Line 1185: IF BSC_APPS.bsc_mv AND (NOT x_aw_flag) THEN

1181: bsc_dbgen_utils.add_string(h_sql, ' where p.year = :11');
1182: ELSE
1183: bsc_dbgen_utils.add_string(h_sql, ' where p.year = :11 and p.period = :12');
1184: END IF;
1185: IF BSC_APPS.bsc_mv AND (NOT x_aw_flag) THEN
1186: bsc_dbgen_utils.add_string(h_sql, ' and p.periodicity_id = :13');
1187: END IF;
1188: IF x_parallel_jobs = 'Y' THEN
1189: bsc_dbgen_utils.add_string(h_sql, ' and '||BSC_DBGEN_STD_METADATA.BSC_BATCH_COLUMN_NAME||' = :14');

Line 1198: IF BSC_APPS.bsc_mv AND (NOT x_aw_flag) THEN

1194: h_num_bind_vars := 0;
1195:
1196: h_num_bind_vars := h_num_bind_vars + 1;
1197: h_bind_vars_values(h_num_bind_vars) := '0';
1198: IF BSC_APPS.bsc_mv AND (NOT x_aw_flag) THEN
1199: h_num_bind_vars := h_num_bind_vars + 1;
1200: h_bind_vars_values(h_num_bind_vars) := x_periodicity;
1201: END IF;
1202: IF x_parallel_jobs = 'Y' THEN

Line 1208: IF BSC_APPS.bsc_mv AND (NOT x_aw_flag) THEN

1204: h_bind_vars_values(h_num_bind_vars) := x_batch_value;
1205: END IF;
1206: h_num_bind_vars := h_num_bind_vars + 1;
1207: h_bind_vars_values(h_num_bind_vars) := '0';
1208: IF BSC_APPS.bsc_mv AND (NOT x_aw_flag) THEN
1209: h_num_bind_vars := h_num_bind_vars + 1;
1210: h_bind_vars_values(h_num_bind_vars) := x_periodicity;
1211: END IF;
1212: IF x_parallel_jobs = 'Y' THEN

Line 1237: IF BSC_APPS.bsc_mv AND (NOT x_aw_flag) THEN

1233: h_bind_vars_values(h_num_bind_vars) := x_current_fy;
1234: h_num_bind_vars := h_num_bind_vars + 1;
1235: h_bind_vars_values(h_num_bind_vars) := h_j;
1236: END IF;
1237: IF BSC_APPS.bsc_mv AND (NOT x_aw_flag) THEN
1238: h_num_bind_vars := h_num_bind_vars + 1;
1239: h_bind_vars_values(h_num_bind_vars) := x_periodicity;
1240: END IF;
1241: IF x_parallel_jobs = 'Y' THEN

Line 1264: IF BSC_APPS.bsc_mv AND (NOT x_aw_flag) THEN

1260: FOR h_i IN 1..x_num_key_columns LOOP
1261: bsc_dbgen_utils.add_string(h_sql, x_key_columns(h_i)||', ');
1262: END LOOP;
1263: bsc_dbgen_utils.add_string(h_sql, 'year, type, period');
1264: IF BSC_APPS.bsc_mv AND (NOT x_aw_flag) THEN
1265: bsc_dbgen_utils.add_string(h_sql, ', periodicity_id');
1266: END IF;
1267: FOR h_i IN 1..h_num_avg_cols LOOP
1268: bsc_dbgen_utils.add_string(h_sql, ', '||h_avg_cols(h_i));

Line 1287: IF BSC_APPS.bsc_mv AND (NOT x_aw_flag) THEN

1283: bsc_dbgen_utils.add_string(h_sql, ':1, 0, 0');
1284: ELSE
1285: bsc_dbgen_utils.add_string(h_sql, ':1, 0, :2');
1286: END IF;
1287: IF BSC_APPS.bsc_mv AND (NOT x_aw_flag) THEN
1288: bsc_dbgen_utils.add_string(h_sql, ', periodicity_id');
1289: END IF;
1290: FOR h_i IN 1..h_num_avg_cols LOOP
1291: bsc_dbgen_utils.add_string(h_sql, ', avg('||h_avg_cols(h_i)||')');

Line 1306: IF BSC_APPS.bsc_mv AND (NOT x_aw_flag) THEN

1302: FOR h_i IN 1..x_num_key_columns LOOP
1303: bsc_dbgen_utils.add_string(h_sql, x_key_columns(h_i)||', ');
1304: END LOOP;
1305: bsc_dbgen_utils.add_string(h_sql, ' year, type, period');
1306: IF BSC_APPS.bsc_mv AND (NOT x_aw_flag) THEN
1307: bsc_dbgen_utils.add_string(h_sql, ', periodicity_id');
1308: END IF;
1309: FOR h_i IN 1..h_num_avg_cols LOOP
1310: bsc_dbgen_utils.add_string(h_sql, ', '||h_avg_cols(h_i));

Line 1314: IF BSC_APPS.bsc_mv AND (NOT x_aw_flag) THEN

1310: bsc_dbgen_utils.add_string(h_sql, ', '||h_avg_cols(h_i));
1311: END LOOP;
1312: bsc_dbgen_utils.add_string(h_sql, ' from '||x_base_table||
1313: ' WHERE type = :5');
1314: IF BSC_APPS.bsc_mv AND (NOT x_aw_flag) THEN
1315: bsc_dbgen_utils.add_string(h_sql, ' and periodicity_id = :6');
1316: END IF;
1317: IF x_parallel_jobs = 'Y' THEN
1318: bsc_dbgen_utils.add_string(h_sql, ' and '||BSC_DBGEN_STD_METADATA.BSC_BATCH_COLUMN_NAME||' = :7');

Line 1330: IF BSC_APPS.bsc_mv AND (NOT x_aw_flag) THEN

1326: FOR h_i IN 1..x_num_key_columns LOOP
1327: bsc_dbgen_utils.add_string(h_sql, x_key_columns(h_i)||', ');
1328: END LOOP;
1329: bsc_dbgen_utils.add_string(h_sql, 'year, type, period');
1330: IF BSC_APPS.bsc_mv AND (NOT x_aw_flag) THEN
1331: bsc_dbgen_utils.add_string(h_sql, ', periodicity_id');
1332: END IF;
1333: FOR h_i IN 1..h_num_avg_cols LOOP
1334: bsc_dbgen_utils.add_string(h_sql, ', '||h_avg_cols(h_i));

Line 1338: IF BSC_APPS.bsc_mv AND (NOT x_aw_flag) THEN

1334: bsc_dbgen_utils.add_string(h_sql, ', '||h_avg_cols(h_i));
1335: END LOOP;
1336: bsc_dbgen_utils.add_string(h_sql, ' from '||x_proj_table||
1337: ' WHERE type = :8');
1338: IF BSC_APPS.bsc_mv AND (NOT x_aw_flag) THEN
1339: bsc_dbgen_utils.add_string(h_sql, ' and periodicity_id = :9');
1340: END IF;
1341: IF x_parallel_jobs = 'Y' THEN
1342: bsc_dbgen_utils.add_string(h_sql, ' and '||BSC_DBGEN_STD_METADATA.BSC_BATCH_COLUMN_NAME||' = :10');

Line 1355: IF BSC_APPS.bsc_mv AND (NOT x_aw_flag) THEN

1351: bsc_dbgen_utils.add_string(h_sql, ' group by '||BSC_DBGEN_STD_METADATA.BSC_BATCH_COLUMN_NAME);
1352: FOR h_i IN 1..x_num_key_columns LOOP
1353: bsc_dbgen_utils.add_string(h_sql, ', '||x_key_columns(h_i));
1354: END LOOP;
1355: IF BSC_APPS.bsc_mv AND (NOT x_aw_flag) THEN
1356: bsc_dbgen_utils.add_string(h_sql, ', periodicity_id');
1357: END IF;
1358:
1359: FOR h_j IN h_init_per..h_end_per LOOP

Line 1380: IF BSC_APPS.bsc_mv AND (NOT x_aw_flag) THEN

1376: h_bind_vars_values(h_num_bind_vars) := x_change_vector_value;
1377: END IF;
1378: h_num_bind_vars := h_num_bind_vars + 1;
1379: h_bind_vars_values(h_num_bind_vars) := '0';
1380: IF BSC_APPS.bsc_mv AND (NOT x_aw_flag) THEN
1381: h_num_bind_vars := h_num_bind_vars + 1;
1382: h_bind_vars_values(h_num_bind_vars) := x_periodicity;
1383: END IF;
1384: IF x_parallel_jobs = 'Y' THEN

Line 1390: IF BSC_APPS.bsc_mv AND (NOT x_aw_flag) THEN

1386: h_bind_vars_values(h_num_bind_vars) := x_batch_value;
1387: END IF;
1388: h_num_bind_vars := h_num_bind_vars + 1;
1389: h_bind_vars_values(h_num_bind_vars) := '0';
1390: IF BSC_APPS.bsc_mv AND (NOT x_aw_flag) THEN
1391: h_num_bind_vars := h_num_bind_vars + 1;
1392: h_bind_vars_values(h_num_bind_vars) := x_periodicity;
1393: END IF;
1394: IF x_parallel_jobs = 'Y' THEN

Line 2758: IF BSC_APPS.bsc_mv THEN

2754: -- BSC-BIS-DIMENSIONS: If the dimension is a DBI dimension and it is materialized and
2755: -- the table exists then we use the table created in BSC to materialize
2756: -- the DBI dimension to translate from USER_CODE into CODE.
2757: -- Note that is only in MV Architecture.
2758: IF BSC_APPS.bsc_mv THEN
2759: SELECT short_name, source
2760: INTO h_level_short_name, h_level_source
2761: FROM bsc_sys_dim_levels_b
2762: WHERE level_view_name = h_level_table_name;

Line 2769: IF BSC_APPS.Table_Exists(h_dbi_dim_data.table_name) THEN

2765: BSC_UPDATE_DIM.Get_Dbi_Dim_Data(h_level_short_name, h_dbi_dim_data);
2766: IF (h_dbi_dim_data.short_name IS NOT NULL) AND
2767: (h_dbi_dim_data.table_name IS NOT NULL) AND
2768: (h_dbi_dim_data.materialized='YES') THEN
2769: IF BSC_APPS.Table_Exists(h_dbi_dim_data.table_name) THEN
2770: h_level_table_name := h_dbi_dim_data.table_name;
2771: END IF;
2772: END IF;
2773: END IF;

Line 2813: IF BSC_APPS.bsc_mv AND (NOT x_aw_flag) THEN

2809: close h_cursor;
2810: END LOOP;
2811: h_proc_name := h_proc_temp; --rkumar:this is the final procedure name, now create it in the next line
2812:
2813: IF BSC_APPS.bsc_mv AND (NOT x_aw_flag) THEN
2814: -- MV architecture
2815: Create_Proc_Load_Tbl_MV(h_proc_name,
2816: x_base_table,
2817: x_input_table,

Line 2964: IF BSC_APPS.bsc_mv THEN

2960: -- BSC-BIS-DIMENSIONS: If the dimension is a DBI dimension and it is materialized and
2961: -- the table exists then we use the table created in BSC to materialize
2962: -- the DBI dimension to translate from USER_CODE into CODE.
2963: -- Note that is only in MV Architecture.
2964: IF BSC_APPS.bsc_mv THEN
2965: SELECT short_name, source
2966: INTO h_level_short_name, h_level_source
2967: FROM bsc_sys_dim_levels_b
2968: WHERE level_view_name = h_level_table_name;

Line 2975: IF BSC_APPS.Table_Exists(h_dbi_dim_data.table_name) THEN

2971: BSC_UPDATE_DIM.Get_Dbi_Dim_Data(h_level_short_name, h_dbi_dim_data);
2972: IF (h_dbi_dim_data.short_name IS NOT NULL) AND
2973: (h_dbi_dim_data.table_name IS NOT NULL) AND
2974: (h_dbi_dim_data.materialized='YES') THEN
2975: IF BSC_APPS.Table_Exists(h_dbi_dim_data.table_name) THEN
2976: h_level_table_name := h_dbi_dim_data.table_name;
2977: END IF;
2978: END IF;
2979: END IF;

Line 2984: IF BSC_APPS.bsc_mv AND (NOT x_aw_flag) THEN

2980: END IF;
2981: h_key_dim_tables(h_i) := h_level_table_name;
2982: END LOOP;
2983:
2984: IF BSC_APPS.bsc_mv AND (NOT x_aw_flag) THEN
2985: -- MV Architecture
2986: h_num_bind_vars := 0;
2987: h_bind_vars_values.delete;
2988:

Line 3530: -- Initialize BSC/APPS global variables

3526: --- Note that each job runs in a new session, we need to initialized session variables
3527: h_num_key_columns := 0;
3528: h_num_data_columns := 0;
3529:
3530: -- Initialize BSC/APPS global variables
3531: BSC_APPS.Init_Bsc_Apps;
3532:
3533: -- Initialize the temporal table used for big 'in' conditions
3534: BSC_APPS.Init_Big_In_Cond_Table;

Line 3531: BSC_APPS.Init_Bsc_Apps;

3527: h_num_key_columns := 0;
3528: h_num_data_columns := 0;
3529:
3530: -- Initialize BSC/APPS global variables
3531: BSC_APPS.Init_Bsc_Apps;
3532:
3533: -- Initialize the temporal table used for big 'in' conditions
3534: BSC_APPS.Init_Big_In_Cond_Table;
3535: BSC_MESSAGE.Init('NO');

Line 3534: BSC_APPS.Init_Big_In_Cond_Table;

3530: -- Initialize BSC/APPS global variables
3531: BSC_APPS.Init_Bsc_Apps;
3532:
3533: -- Initialize the temporal table used for big 'in' conditions
3534: BSC_APPS.Init_Big_In_Cond_Table;
3535: BSC_MESSAGE.Init('NO');
3536:
3537: -- Initializes g_session_id, g_user_id and g_schema_name
3538: IF NOT BSC_UPDATE.Init_Env_Values THEN

Line 3702: IF BSC_APPS.bsc_mv AND (NOT x_aw_flag) THEN

3698: h_num_rows := 0;
3699:
3700: -- Init temporary table BSC_DB_CALENDAR_TEMP to do the rollup to higher periodicities
3701: -- in MV architecture
3702: IF BSC_APPS.bsc_mv AND (NOT x_aw_flag) THEN
3703: Init_Bsc_Db_Calendar_Temp(x_base_table,
3704: x_periodicity,
3705: x_calendar_id,
3706: x_current_period,

Line 3819: IF BSC_APPS.bsc_mv AND (NOT x_aw_flag) THEN

3815: END IF;
3816: END IF;
3817: ELSE
3818: -- No data coming from the input table
3819: IF BSC_APPS.bsc_mv AND (NOT x_aw_flag) THEN
3820: -- In MV architecture we need to re-rollup to higher periodicities since the aggregation function
3821: -- or the balance type could have changed. We re-rollup the entire table
3822:
3823: -- Delete rows for highwer periodicities

Line 3863: ownname => BSC_APPS.BSC_APPS_SCHEMA,

3859:
3860: -- Analyze the B table partition
3861: IF x_parallel_jobs = 'Y' THEN
3862: dbms_stats.gather_table_stats(
3863: ownname => BSC_APPS.BSC_APPS_SCHEMA,
3864: tabname => x_base_table,
3865: partname => x_partition_name,
3866: estimate_percent => 1);
3867: ELSE

Line 3869: ownname => BSC_APPS.BSC_APPS_SCHEMA,

3865: partname => x_partition_name,
3866: estimate_percent => 1);
3867: ELSE
3868: dbms_stats.gather_table_stats(
3869: ownname => BSC_APPS.BSC_APPS_SCHEMA,
3870: tabname => x_base_table);
3871: END IF;
3872: commit;
3873:

Line 3900: IF BSC_APPS.bsc_mv AND (NOT x_aw_flag) THEN

3896: IF h_return_status = 'error' THEN
3897: RAISE e_calc_projection;
3898: END IF;
3899:
3900: IF BSC_APPS.bsc_mv AND (NOT x_aw_flag) THEN
3901: -- Init temporary table BSC_DB_CALENDAR_TEMP to do the rollup to higher periodicities
3902: -- for projection.
3903: Init_Bsc_Db_Calendar_Temp_Proj(x_base_table,
3904: x_periodicity,