426: *********************************************************************************/
427:
428: FUNCTION Find_Period_CircularRef
429: (
430: p_basePeriod IN BSC_SYS_PERIODICITIES.periodicity_id%TYPE
431: , p_current_period IN BSC_SYS_PERIODICITIES.periodicity_id%TYPE
432:
433: ) RETURN BOOLEAN;
434:
427:
428: FUNCTION Find_Period_CircularRef
429: (
430: p_basePeriod IN BSC_SYS_PERIODICITIES.periodicity_id%TYPE
431: , p_current_period IN BSC_SYS_PERIODICITIES.periodicity_id%TYPE
432:
433: ) RETURN BOOLEAN;
434:
435: FUNCTION is_Period_Circular
433: ) RETURN BOOLEAN;
434:
435: FUNCTION is_Period_Circular
436: (
437: p_basePeriod IN BSC_SYS_PERIODICITIES.periodicity_id%TYPE
438: , p_current_period IN BSC_SYS_PERIODICITIES.periodicity_id%TYPE
439: ) RETURN VARCHAR2;
440:
441: PROCEDURE check_pmf_validveiw_for_mes
434:
435: FUNCTION is_Period_Circular
436: (
437: p_basePeriod IN BSC_SYS_PERIODICITIES.periodicity_id%TYPE
438: , p_current_period IN BSC_SYS_PERIODICITIES.periodicity_id%TYPE
439: ) RETURN VARCHAR2;
440:
441: PROCEDURE check_pmf_validveiw_for_mes
442: (