DBA Data[Home] [Help]

APPS.BSC_PERIODICITIES_PUB dependencies on BIS_LEVELS

Line 60: l_Dimobj_Name BIS_LEVELS_TL.NAME%TYPE;

56: ) IS
57: l_Periodicities_Rec_Type BSC_PERIODICITIES_PUB.Periodicities_Rec_Type;
58: l_Dim_Short_Name BSC_SYS_CALENDARS_B.SHORT_NAME%TYPE;
59: l_Periodicity_View_Name VARCHAR2(30);
60: l_Dimobj_Name BIS_LEVELS_TL.NAME%TYPE;
61: l_Dim_Enabled VARCHAR2(10);
62: BEGIN
63: SAVEPOINT CreatePeriodicityPUB;
64: FND_MSG_PUB.Initialize;

Line 253: l_Dimobj_Name BIS_LEVELS_TL.NAME%TYPE;

249: l_Structural_Flag VARCHAR2(1);
250: l_Periodicity_View_Name VARCHAR2(30);
251: l_Message_Name BSC_MESSAGES.MESSAGE_NAME%TYPE;
252: l_Objective_List VARCHAR2(2000);
253: l_Dimobj_Name BIS_LEVELS_TL.NAME%TYPE;
254: l_Dim_Short_Name BSC_SYS_DIM_GROUPS_TL.SHORT_NAME%TYPE;
255: l_Dim_Enabled VARCHAR2(10);
256: BEGIN
257: SAVEPOINT UpdatePeriodicityPUB;

Line 480: FROM BIS_LEVELS L

476: l_regions VARCHAR2(32000);
477:
478: CURSOR c_Delete_View IS
479: SELECT L.LEVEL_VALUES_VIEW_NAME
480: FROM BIS_LEVELS L
481: WHERE L.SHORT_NAME = l_Dim_Object_SN
482: AND L.LEVEL_VALUES_VIEW_NAME IS NOT NULL;
483: BEGIN
484: SAVEPOINT DeletePeriodicityPUB;