DBA Data[Home] [Help]

APPS.BSC_BIS_DIM_OBJ_PUB dependencies on BIS_LEVELS_TL

Line 831: 2. BIS_LEVELS_TL

827: /*
828: This procedure allow user to create a new dimension category whose records
829: will be inserted into the following tables.
830: 1 BIS_LEVELS.
831: 2. BIS_LEVELS_TL
832: 3. BSC_SYS_DIM_LEVELS_B
833: 4. BSC_SYS_DIM_LEVELS_TL
834:
835: Key

Line 883: l_bis_name BIS_LEVELS_TL.Name%TYPE;

879: l_bis_dim_level_rec BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type;
880: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
881: l_level_table_name BIS_LEVELS.LEVEL_VALUES_VIEW_NAME%TYPE;
882: l_bis_short_name BIS_LEVELS.Short_Name%TYPE;
883: l_bis_name BIS_LEVELS_TL.Name%TYPE;
884: l_user_id FND_USER.user_id%TYPE;
885: l_login_id NUMBER;
886: l_count NUMBER;
887: l_temp_var BSC_SYS_DIM_LEVELS_B.Short_Name%TYPE;

Line 2001: 2. BIS_LEVELS_TL

1997: /*
1998: This procedure allows user to update a dimension. These changes will
1999: be reflected into the following metadata: -
2000: 1 BIS_LEVELS.
2001: 2. BIS_LEVELS_TL
2002: 3. BSC_SYS_DIM_LEVELS_B
2003: 4. BSC_SYS_DIM_LEVELS_TL
2004:
2005: Key:

Line 2063: l_bis_name BIS_LEVELS_TL.Name%TYPE;

2059: l_dim_obj_name BSC_SYS_DIM_LEVELS_B.Short_Name%TYPE;
2060: l_dim_Grp_name BSC_SYS_DIM_GROUPS_TL.short_name%TYPE;
2061: l_application_id BIS_LEVELS.Application_Id%TYPE;
2062: l_bis_short_name BIS_LEVELS.Short_Name%TYPE;
2063: l_bis_name BIS_LEVELS_TL.Name%TYPE;
2064: l_flag BOOLEAN := FALSE;
2065: l_struct_change BOOLEAN := FALSE;
2066: l_child_struc BOOLEAN := FALSE;
2067: l_create_pmf BOOLEAN := FALSE;--must be false

Line 3194: 2. BIS_LEVELS_TL

3190: /*
3191: This procedure allows user to delete a dimension. Respective records will be
3192: deleted from the following metadata: -
3193: 1 BIS_LEVELS.
3194: 2. BIS_LEVELS_TL
3195: 3. BSC_SYS_DIM_LEVELS_B
3196: 4. BSC_SYS_DIM_LEVELS_TL
3197:
3198: Validations: