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_VAL dependencies on BSC_UPDATE_UTIL

Line 227: l_bind_vars_values BSC_UPDATE_UTIL.t_array_of_number;

223: h_rel_table bsc_sys_dim_levels_b.level_table_name%TYPE;
224:
225:
226: -- Bind Var. fix for POSCO
227: l_bind_vars_values BSC_UPDATE_UTIL.t_array_of_number;
228: l_num_bind_vars NUMBER;
229:
230: h_num_rows NUMBER;
231:

Line 236: h_bind_vars_values BSC_UPDATE_UTIL.t_array_of_varchar2;

232: h_calendar_source VARCHAR2(20);
233:
234: h_table_for_precalc_kpi BOOLEAN;
235:
236: h_bind_vars_values BSC_UPDATE_UTIL.t_array_of_varchar2;
237: h_num_bind_vars NUMBER;
238:
239: BEGIN
240:

Line 247: h_target_flag := BSC_UPDATE_UTIL.Get_Table_Target_Flag(x_input_table);

243: h_calendar_source := NULL;
244: h_table_for_precalc_kpi := Is_Table_For_PreCalc_Kpi(x_input_table);
245:
246: -- Get Target_Flag of the table
247: h_target_flag := BSC_UPDATE_UTIL.Get_Table_Target_Flag(x_input_table);
248:
249: -- Delete the current invalid codes of input table
250: DELETE FROM bsc_db_validation
251: WHERE input_table_name = x_input_table;

Line 301: BSC_UPDATE_UTIL.Execute_Immediate(h_sql,h_bind_vars_values,h_num_bind_vars);

297: h_bind_vars_values(4) := h_column_name;
298: h_bind_vars_values(5) := '0';
299: h_num_bind_vars := 5;
300: END IF;
301: BSC_UPDATE_UTIL.Execute_Immediate(h_sql,h_bind_vars_values,h_num_bind_vars);
302: commit;
303:
304: FETCH c_dim_cols INTO h_column_name, h_level_table_name, h_level_short_name, h_level_source;
305: END LOOP;

Line 324: BSC_UPDATE_UTIL.Execute_Immediate(h_sql,h_bind_vars_values,2);

320: ' WHERE r.'||h_p1_pk_col||' = p1.code AND r.'||h_p2_pk_col||' = p2.code)';
321: h_bind_vars_values.delete;
322: h_bind_vars_values(1) := x_input_table;
323: h_bind_vars_values(2) := h_p1_pk_col||', '||h_p2_pk_col;
324: BSC_UPDATE_UTIL.Execute_Immediate(h_sql,h_bind_vars_values,2);
325:
326: FETCH c_mn_rels INTO h_p1_table, h_p1_pk_col, h_p2_table, h_p2_pk_col, h_rel_table;
327: END LOOP;
328: CLOSE c_mn_rels;

Line 336: h_periodicity := BSC_UPDATE_UTIL.Get_Table_Periodicity(x_input_table);

332: -- BSC-BIS-DIMENSIONS: If the periodicity of the input table is from BIS, then the
333: -- input table has a column called TIME_FK instead of YEAR+PERIOD.
334:
335: -- Get table periodicity
336: h_periodicity := BSC_UPDATE_UTIL.Get_Table_Periodicity(x_input_table);
337: IF h_periodicity IS NULL THEN
338: RAISE e_unexpected_error;
339: END IF;
340:

Line 341: h_calendar_id := BSC_UPDATE_UTIL.Get_Calendar_Id(h_periodicity);

337: IF h_periodicity IS NULL THEN
338: RAISE e_unexpected_error;
339: END IF;
340:
341: h_calendar_id := BSC_UPDATE_UTIL.Get_Calendar_Id(h_periodicity);
342: h_calendar_source := BSC_UPDATE_UTIL.Get_Calendar_Source(h_calendar_id);
343: h_periodicity_type := BSC_UPDATE_UTIL.Get_Periodicity_Type(h_periodicity);
344:
345: IF h_calendar_source = 'BSC' THEN

Line 342: h_calendar_source := BSC_UPDATE_UTIL.Get_Calendar_Source(h_calendar_id);

338: RAISE e_unexpected_error;
339: END IF;
340:
341: h_calendar_id := BSC_UPDATE_UTIL.Get_Calendar_Id(h_periodicity);
342: h_calendar_source := BSC_UPDATE_UTIL.Get_Calendar_Source(h_calendar_id);
343: h_periodicity_type := BSC_UPDATE_UTIL.Get_Periodicity_Type(h_periodicity);
344:
345: IF h_calendar_source = 'BSC' THEN
346: -- Get period column name and subperiod column name for that periodicity

Line 343: h_periodicity_type := BSC_UPDATE_UTIL.Get_Periodicity_Type(h_periodicity);

339: END IF;
340:
341: h_calendar_id := BSC_UPDATE_UTIL.Get_Calendar_Id(h_periodicity);
342: h_calendar_source := BSC_UPDATE_UTIL.Get_Calendar_Source(h_calendar_id);
343: h_periodicity_type := BSC_UPDATE_UTIL.Get_Periodicity_Type(h_periodicity);
344:
345: IF h_calendar_source = 'BSC' THEN
346: -- Get period column name and subperiod column name for that periodicity
347: IF NOT BSC_UPDATE_UTIL.Get_Period_Cols_Names(h_periodicity, h_period_col_name, h_subperiod_col_name) THEN

Line 347: IF NOT BSC_UPDATE_UTIL.Get_Period_Cols_Names(h_periodicity, h_period_col_name, h_subperiod_col_name) THEN

343: h_periodicity_type := BSC_UPDATE_UTIL.Get_Periodicity_Type(h_periodicity);
344:
345: IF h_calendar_source = 'BSC' THEN
346: -- Get period column name and subperiod column name for that periodicity
347: IF NOT BSC_UPDATE_UTIL.Get_Period_Cols_Names(h_periodicity, h_period_col_name, h_subperiod_col_name) THEN
348: RAISE e_unexpected_error;
349: END IF;
350:
351: -- Annually

Line 372: BSC_UPDATE_UTIL.Execute_Immediate(h_sql,h_bind_vars_values,6);

368: h_bind_vars_values(3) := h_calendar_id;
369: h_bind_vars_values(4) := x_input_table;
370: h_bind_vars_values(5) := 'YEAR, '||h_period_col_name;
371: h_bind_vars_values(6) := 0;
372: BSC_UPDATE_UTIL.Execute_Immediate(h_sql,h_bind_vars_values,6);
373:
374: -- Month Week
375: ELSIF h_periodicity_type = 11 THEN
376: l_bind_vars_values.delete;

Line 389: BSC_UPDATE_UTIL.Execute_Immediate(h_sql,h_bind_vars_values,3);

385: h_bind_vars_values.delete;
386: h_bind_vars_values(1) := x_input_table;
387: h_bind_vars_values(2) := 'YEAR, '||h_period_col_name||', '||h_subperiod_col_name;
388: h_bind_vars_values(3) := h_calendar_id;
389: BSC_UPDATE_UTIL.Execute_Immediate(h_sql,h_bind_vars_values,3);
390:
391: -- Month Day
392: ELSIF h_periodicity_type = 12 THEN
393: l_bind_vars_values.delete;

Line 406: BSC_UPDATE_UTIL.Execute_Immediate(h_sql,h_bind_vars_values,3);

402: h_bind_vars_values.delete;
403: h_bind_vars_values(1) := x_input_table;
404: h_bind_vars_values(2) := 'YEAR, '||h_period_col_name||', '||h_subperiod_col_name;
405: h_bind_vars_values(3) := h_calendar_id;
406: BSC_UPDATE_UTIL.Execute_Immediate(h_sql,h_bind_vars_values,3);
407:
408: -- Other periodicities: Monthly, Quarterly, Custom periodicities, etc
409: ELSE
410: l_bind_vars_values.delete;

Line 411: h_db_calendar_col_name := BSC_UPDATE_UTIL.Get_Calendar_Table_Col_Name(h_periodicity);

407:
408: -- Other periodicities: Monthly, Quarterly, Custom periodicities, etc
409: ELSE
410: l_bind_vars_values.delete;
411: h_db_calendar_col_name := BSC_UPDATE_UTIL.Get_Calendar_Table_Col_Name(h_periodicity);
412: h_sql := 'INSERT INTO bsc_db_validation (input_table_name, column_name, invalid_code) '||
413: 'SELECT DISTINCT :1, :2, '||
414: 't.year||'', ''||t.'||h_period_col_name||' '||
415: 'FROM '||x_input_table||' t, bsc_db_calendar d '||

Line 423: BSC_UPDATE_UTIL.Execute_Immediate(h_sql,h_bind_vars_values,3);

419: h_bind_vars_values.delete;
420: h_bind_vars_values(1) := x_input_table;
421: h_bind_vars_values(2) := 'YEAR, '||h_period_col_name;
422: h_bind_vars_values(3) := h_calendar_id;
423: BSC_UPDATE_UTIL.Execute_Immediate(h_sql,h_bind_vars_values,3);
424: END IF;
425: ELSE
426: -- BIS Calendar
427: -- The input table has a column called TIME_FK. We need to validate against BSC_SYS_PERIODS.TIME_FK

Line 446: BSC_UPDATE_UTIL.Execute_Immediate(h_sql,h_bind_vars_values,4);

442: h_bind_vars_values(1) := x_input_table;
443: h_bind_vars_values(2) := 'TIME_FK';
444: h_bind_vars_values(3) := 'MM/DD/YYYY';
445: h_bind_vars_values(4) := h_periodicity;
446: BSC_UPDATE_UTIL.Execute_Immediate(h_sql,h_bind_vars_values,4);
447: ELSE
448: -- Other periodicity, TIME_FK is VARCHAR2
449: l_bind_vars_values.delete;
450: h_sql := 'INSERT INTO bsc_db_validation (input_table_name, column_name, invalid_code) '||

Line 459: BSC_UPDATE_UTIL.Execute_Immediate(h_sql,h_bind_vars_values,3);

455: h_bind_vars_values.delete;
456: h_bind_vars_values(1) := x_input_table;
457: h_bind_vars_values(2) := 'TIME_FK';
458: h_bind_vars_values(3) := h_periodicity;
459: BSC_UPDATE_UTIL.Execute_Immediate(h_sql,h_bind_vars_values,3);
460: END IF;
461: END IF;
462:
463: -- Validate type.

Line 474: BSC_UPDATE_UTIL.Execute_Immediate(h_sql,h_bind_vars_values,3);

470: h_bind_vars_values.delete;
471: h_bind_vars_values(1) := x_input_table;
472: h_bind_vars_values(2) := 'TYPE';
473: h_bind_vars_values(3) := 90;
474: BSC_UPDATE_UTIL.Execute_Immediate(h_sql,h_bind_vars_values,3);
475:
476: -- User should not enter actuals in target only tables
477: IF h_target_flag = 1 THEN
478: l_bind_vars_values.delete;

Line 487: BSC_UPDATE_UTIL.Execute_Immediate(h_sql,h_bind_vars_values,3);

483: h_bind_vars_values.delete;
484: h_bind_vars_values(1) := x_input_table;
485: h_bind_vars_values(2) := 'TYPE';
486: h_bind_vars_values(3) := 0;
487: BSC_UPDATE_UTIL.Execute_Immediate(h_sql,h_bind_vars_values,3);
488: END IF;
489:
490: COMMIT;
491:

Line 508: BSC_MESSAGE.Add(x_message => BSC_UPDATE_UTIL.Get_Message('BSC_ITABLE_VALID_FAILED'),

504: RETURN NOT h_invalid;
505:
506: EXCEPTION
507: WHEN e_unexpected_error THEN
508: BSC_MESSAGE.Add(x_message => BSC_UPDATE_UTIL.Get_Message('BSC_ITABLE_VALID_FAILED'),
509: x_source => 'BSC_UPDATE_VAL.Validate_Codes');
510: RETURN NULL;
511:
512: WHEN OTHERS THEN