APPS.BSC_PERIODS_PUB dependencies on BSC_SYS_PERIODICITIES

Line 582: , p_periodicity_Type IN BSC_SYS_PERIODICITIES.periodicity_type%TYPE

578: (
579: p_Periodicity_Id IN NUMBER
580: , p_Short_Name IN VARCHAR2
581: , p_Calendar_Id IN NUMBER
582: , p_periodicity_Type IN BSC_SYS_PERIODICITIES.periodicity_type%TYPE
583: , x_Periodicity_View_Name OUT NOCOPY VARCHAR2
584: , x_Return_Status OUT NOCOPY VARCHAR2
585: , x_Msg_Count OUT NOCOPY NUMBER
586: , x_Msg_Data OUT NOCOPY VARCHAR2

Line 590: l_Period_DB_Col BSC_SYS_PERIODICITIES.DB_COLUMN_NAME%TYPE;

586: , x_Msg_Data OUT NOCOPY VARCHAR2
587: )IS
588: l_Sql_Stmt VARCHAR2(32000);
589: l_View_Name BIS_LEVELS.LEVEL_VALUES_VIEW_NAME%TYPE;
590: l_Period_DB_Col BSC_SYS_PERIODICITIES.DB_COLUMN_NAME%TYPE;
591:
592: BEGIN
593: --dbms_output.put_line('START :Create_Periodicity_View :- ' ||DBMS_UTILITY.GET_TIME);
594: FND_MSG_PUB.Initialize;

Line 705: SELECT P.SOURCE FROM BSC_SYS_PERIODICITIES P

701: WHERE P.PERIODICITY_ID = p_Periodicity_Id
702: ORDER BY P.PERIOD_ID;
703:
704: CURSOR c_Source_Type IS
705: SELECT P.SOURCE FROM BSC_SYS_PERIODICITIES P
706: WHERE P.PERIODICITY_ID = p_Periodicity_Id;
707:
708: l_Comma_List VARCHAR2(12228);
709: l_Source BSC_SYS_PERIODICITIES.SOURCE%TYPE;

Line 709: l_Source BSC_SYS_PERIODICITIES.SOURCE%TYPE;

705: SELECT P.SOURCE FROM BSC_SYS_PERIODICITIES P
706: WHERE P.PERIODICITY_ID = p_Periodicity_Id;
707:
708: l_Comma_List VARCHAR2(12228);
709: l_Source BSC_SYS_PERIODICITIES.SOURCE%TYPE;
710: BEGIN
711:
712: FOR Cst IN c_Source_Type LOOP
713: l_Source := Cst.SOURCE;