APPS.BSC_PMF_UI_WRAPPER dependencies on BSC_SYS_PERIODICITIES

Line 5318: bsc_sys_periodicities_vl p

5314: p.periodicity_type,
5315: DECODE(p.periodicity_type, 1 , kp.num_of_years, p.num_of_periods) max_periods
5316: FROM
5317: bsc_kpi_periodicities kp,
5318: bsc_sys_periodicities_vl p
5319: WHERE
5320: kp.indicator = p_Indicator
5321: AND kp.periodicity_id = p.periodicity_id
5322: AND p.calendar_id = p_calendar_id;

Line 5475: l_Periodicity_Type BSC_SYS_PERIODICITIES.PERIODICITY_ID%TYPE;

5471: l_periodicities_tbl BSC_BIS_LOCKS_PUB.t_numberTable;
5472: l_current_periods BSC_BIS_LOCKS_PUB.t_numberTable;
5473: l_Indic_Type BSC_KPIS_B.INDICATOR_TYPE%TYPE;
5474: l_Indic_Config_Type BSC_KPIS_B.CONFIG_TYPE%TYPE;
5475: l_Periodicity_Type BSC_SYS_PERIODICITIES.PERIODICITY_ID%TYPE;
5476: l_Is_Invalid_Per_Sim BOOLEAN := FALSE;
5477: l_Period_Name BSC_SYS_PERIODICITIES_TL.NAME%TYPE;
5478: l_Invalid_Period_Name BSC_SYS_PERIODICITIES_TL.NAME%TYPE;
5479: l_Count_Tables NUMBER;

Line 5477: l_Period_Name BSC_SYS_PERIODICITIES_TL.NAME%TYPE;

5473: l_Indic_Type BSC_KPIS_B.INDICATOR_TYPE%TYPE;
5474: l_Indic_Config_Type BSC_KPIS_B.CONFIG_TYPE%TYPE;
5475: l_Periodicity_Type BSC_SYS_PERIODICITIES.PERIODICITY_ID%TYPE;
5476: l_Is_Invalid_Per_Sim BOOLEAN := FALSE;
5477: l_Period_Name BSC_SYS_PERIODICITIES_TL.NAME%TYPE;
5478: l_Invalid_Period_Name BSC_SYS_PERIODICITIES_TL.NAME%TYPE;
5479: l_Count_Tables NUMBER;
5480: l_action_flag NUMBER;
5481: l_old_periodicities NUMBER;

Line 5478: l_Invalid_Period_Name BSC_SYS_PERIODICITIES_TL.NAME%TYPE;

5474: l_Indic_Config_Type BSC_KPIS_B.CONFIG_TYPE%TYPE;
5475: l_Periodicity_Type BSC_SYS_PERIODICITIES.PERIODICITY_ID%TYPE;
5476: l_Is_Invalid_Per_Sim BOOLEAN := FALSE;
5477: l_Period_Name BSC_SYS_PERIODICITIES_TL.NAME%TYPE;
5478: l_Invalid_Period_Name BSC_SYS_PERIODICITIES_TL.NAME%TYPE;
5479: l_Count_Tables NUMBER;
5480: l_action_flag NUMBER;
5481: l_old_periodicities NUMBER;
5482: l_new_periodicities NUMBER;

Line 5503: bsc_sys_periodicities_vl p

5499: NVL(kp.num_of_years,0),
5500: NVL(kp.previous_years,0)
5501: FROM
5502: bsc_kpi_periodicities kp,
5503: bsc_sys_periodicities_vl p
5504: WHERE
5505: kp.indicator(+) = p_kpi_id
5506: AND kp.periodicity_id(+) = p.periodicity_id
5507: AND p.calendar_id = p_calendar_id;

Line 5546: FROM bsc_sys_periodicities_vl P

5542: /*IF(l_Indic_Type = 1 AND l_Indic_Config_Type = 7) THEN
5543:
5544: l_sql :='
5545: SELECT COUNT(1)
5546: FROM bsc_sys_periodicities_vl P
5547: , bsc_sys_calendars_b C
5548: WHERE C.calendar_id =:1
5549: AND P.calendar_id = C.calendar_id';
5550: l_sql := l_sql || ' AND periodicity_id IN (' || l_periodicity_ids || ')';

Line 5570: FROM bsc_sys_periodicities_vl P

5566: SELECT P.periodicity_id
5567: ,DECODE (P.yearly_flag, 1, C.fiscal_year, 1 )
5568: ,P.periodicity_type
5569: ,P.name
5570: FROM bsc_sys_periodicities_vl P
5571: , bsc_sys_calendars_b C
5572: WHERE C.calendar_id =:1
5573: AND P.calendar_id = C.calendar_id
5574: AND periodicity_id NOT IN (

Line 5631: FROM bsc_sys_periodicities_vl P

5627: -- p_Dft_periodicity_id is null in case of Report Designer Create flow Bug #5629309
5628: IF (p_Dft_periodicity_id IS NOT NULL) THEN
5629: l_sql :='
5630: SELECT COUNT(1)
5631: FROM bsc_sys_periodicities_vl P
5632: , bsc_sys_calendars_b C
5633: WHERE C.calendar_id =:1
5634: AND P.calendar_id = C.calendar_id
5635: AND periodicity_id = :2';

Line 5688: FROM bsc_sys_periodicities_vl P

5684: SELECT P.periodicity_id
5685: ,DECODE (P.yearly_flag, 1, C.fiscal_year, 1 )
5686: ,P.periodicity_type
5687: ,P.name
5688: FROM bsc_sys_periodicities_vl P
5689: , bsc_sys_calendars_b C
5690: WHERE C.calendar_id =:1
5691: AND P.calendar_id = C.calendar_id';
5692: l_sql := l_sql || ' AND periodicity_id IN (' || l_periodicity_ids || ')';