APPS.BSC_BIS_KPI_MEAS_PUB dependencies on BSC_SYS_PERIODICITIES

Line 7789: p_basePeriod IN BSC_SYS_PERIODICITIES.periodicity_id%TYPE

7785: /*****************************************************************/
7786:
7787: FUNCTION Find_Period_CircularRef
7788: (
7789: p_basePeriod IN BSC_SYS_PERIODICITIES.periodicity_id%TYPE
7790: , p_current_period IN BSC_SYS_PERIODICITIES.periodicity_id%TYPE
7791:
7792: ) RETURN BOOLEAN IS
7793:

Line 7790: , p_current_period IN BSC_SYS_PERIODICITIES.periodicity_id%TYPE

7786:
7787: FUNCTION Find_Period_CircularRef
7788: (
7789: p_basePeriod IN BSC_SYS_PERIODICITIES.periodicity_id%TYPE
7790: , p_current_period IN BSC_SYS_PERIODICITIES.periodicity_id%TYPE
7791:
7792: ) RETURN BOOLEAN IS
7793:
7794: l_baseperiod BSC_SYS_PERIODICITIES.periodicity_id%TYPE;

Line 7794: l_baseperiod BSC_SYS_PERIODICITIES.periodicity_id%TYPE;

7790: , p_current_period IN BSC_SYS_PERIODICITIES.periodicity_id%TYPE
7791:
7792: ) RETURN BOOLEAN IS
7793:
7794: l_baseperiod BSC_SYS_PERIODICITIES.periodicity_id%TYPE;
7795: l_count NUMBER;
7796: l_Source BSC_SYS_PERIODICITIES.Source%TYPE;
7797: l_period_values BSC_UTILITY.varchar_tabletype;
7798: l_period_number NUMBER;

Line 7796: l_Source BSC_SYS_PERIODICITIES.Source%TYPE;

7792: ) RETURN BOOLEAN IS
7793:
7794: l_baseperiod BSC_SYS_PERIODICITIES.periodicity_id%TYPE;
7795: l_count NUMBER;
7796: l_Source BSC_SYS_PERIODICITIES.Source%TYPE;
7797: l_period_values BSC_UTILITY.varchar_tabletype;
7798: l_period_number NUMBER;
7799: l_temp BOOLEAN;
7800:

Line 7811: FROM BSC_SYS_PERIODICITIES

7807: END IF;
7808:
7809: SELECT SOURCE
7810: INTO l_Source
7811: FROM BSC_SYS_PERIODICITIES
7812: WHERE PERIODICITY_ID =l_baseperiod;
7813:
7814: IF((l_Source IS NULL) OR (LENGTH(TRIM(l_Source))=0))THEN
7815: RETURN FALSE;

Line 7854: p_basePeriod IN BSC_SYS_PERIODICITIES.periodicity_id%TYPE

7850: /*****************************************************************/
7851:
7852: FUNCTION is_Period_Circular
7853: (
7854: p_basePeriod IN BSC_SYS_PERIODICITIES.periodicity_id%TYPE
7855: , p_current_period IN BSC_SYS_PERIODICITIES.periodicity_id%TYPE
7856: ) RETURN VARCHAR2 IS
7857:
7858: l_ifCircular BOOLEAN;

Line 7855: , p_current_period IN BSC_SYS_PERIODICITIES.periodicity_id%TYPE

7851:
7852: FUNCTION is_Period_Circular
7853: (
7854: p_basePeriod IN BSC_SYS_PERIODICITIES.periodicity_id%TYPE
7855: , p_current_period IN BSC_SYS_PERIODICITIES.periodicity_id%TYPE
7856: ) RETURN VARCHAR2 IS
7857:
7858: l_ifCircular BOOLEAN;
7859: