APPS.BSC_DBGEN_BSC_READER dependencies on BSC_SYS_PERIODICITIES

Line 834: FROM BSC_SYS_PERIODICITIES_VL

830: l_table_name VARCHAR2(100) := 'bsc_tmp_per_circ_'||userenv('SESSIONID');
831: l_stmt VARCHAR2(1000) := 'CREATE TABLE '||l_table_name||'(periodicity NUMBER, source NUMBER)';
832: CURSOR cPeriods (p_periodicity NUMBER) IS
833: SELECT SOURCE
834: FROM BSC_SYS_PERIODICITIES_VL
835: WHERE PERIODICITY_ID=p_periodicity;
836: l_parents VARCHAR2(4000);
837: l_temp NUMBER;
838: l_periodicity_list BSC_DBGEN_STD_METADATA.tab_clsPeriodicity;

Line 1441: FROM BSC_KPI_PERIODICITIES kpi, bsc_sys_periodicities s

1437: FUNCTION Get_Periodicities_For_Fact(p_fact IN VARCHAR2) RETURN BSC_DBGEN_STD_METADATA.tab_ClsPeriodicity IS
1438: colPeriodicities BSC_DBGEN_STD_METADATA.tab_ClsPeriodicity;
1439: CURSOR cPeriodicities IS
1440: SELECT kpi.PERIODICITY_ID, NVL(TARGET_LEVEL, 1) AS TARGET_LEVEL, s.calendar_id
1441: FROM BSC_KPI_PERIODICITIES kpi, bsc_sys_periodicities s
1442: WHERE
1443: kpi.periodicity_id = s.periodicity_id
1444: AND kpi.INDICATOR = to_number(p_fact)
1445: ORDER BY PERIODICITY_ID;

Line 2033: SELECT db_column_name FROM bsc_sys_periodicities

2029: function get_db_calendar_column(
2030: p_calendar_id number,
2031: p_periodicity_id number) return varchar2 is
2032: CURSOR cDBColumn IS
2033: SELECT db_column_name FROM bsc_sys_periodicities
2034: WHERE periodicity_id = p_periodicity_id AND calendar_id = p_calendar_id;
2035: l_db_column VARCHAR2(100);
2036: Begin
2037: OPEN cDBColumn;

Line 2211: bsc_sys_periodicities p, bsc_kpis_vl k

2207:
2208: function get_year_periodicity_for_fact(p_fact varchar2) return number is
2209: cursor cYearPeriodicity IS
2210: select p.periodicity_id from
2211: bsc_sys_periodicities p, bsc_kpis_vl k
2212: where
2213: p.yearly_flag =1
2214: and p.calendar_id=k.calendar_id
2215: and k.indicator = to_number(p_fact);

Line 2276: , bsc_sys_periodicities per

2272: p_table_name varchar2) return number is
2273: cursor cPeriod is
2274: select current_year
2275: from bsc_sys_calendars_b cal
2276: , bsc_sys_periodicities per
2277: , bsc_db_tables dbtbl
2278: where dbtbl.table_name = p_table_name
2279: and dbtbl.periodicity_id = per.periodicity_id
2280: and per.calendar_id = cal.calendar_id;

Line 2300: select source, db_column_name, calendar_id from bsc_sys_periodicities

2296: and periodicity_id=p_periodicity;
2297: l_current_period NUMBER;
2298: ------------------------------
2299: cursor cSourcePeriodicities(pp_periodicity number) is
2300: select source, db_column_name, calendar_id from bsc_sys_periodicities
2301: where periodicity_id=pp_periodicity;
2302: ------------------------------
2303: cursor cKPIPeriodicity is
2304: select periodicity_id from bsc_kpi_periodicities