APPS.BIS_DIMENSION_LEVEL_PVT dependencies on BISFV_DIMENSION_LEVELS

Line 409: from bisfv_dimension_levels

405: , default_values_api
406: , enabled
407: , drill_to_form_function
408: , hide_in_design
409: from bisfv_dimension_levels
410: where dimension_id = p_Dimension_Rec.dimension_id;
411:
412: cursor cr_dim_short_name is
413: select dimension_id

Line 434: from bisfv_dimension_levels

430: , default_values_api
431: , enabled
432: , drill_to_form_function
433: , hide_in_design
434: from bisfv_dimension_levels
435: where dimension_short_name = p_Dimension_Rec.dimension_short_name;
436:
437: cursor cr_dim_name is
438: select dimension_id

Line 459: from bisfv_dimension_levels

455: , default_values_api
456: , enabled
457: , drill_to_form_function
458: , hide_in_design
459: from bisfv_dimension_levels
460: where dimension_name = p_Dimension_Rec.dimension_name;
461:
462: BEGIN
463:

Line 660: from bisfv_dimension_levels

656: , default_values_api
657: , enabled
658: , drill_to_form_function
659: , hide_in_design
660: from bisfv_dimension_levels
661: where dimension_level_id = p_Dimension_level_Rec.dimension_level_id;
662:
663: cursor cr_lev_short_name is
664: select dimension_id

Line 685: from bisfv_dimension_levels

681: , default_values_api
682: , enabled
683: , drill_to_form_function
684: , hide_in_design
685: from bisfv_dimension_levels
686: where dimension_level_short_name
687: = p_Dimension_level_Rec.dimension_level_short_name;
688:
689: cursor cr_lev_name is

Line 711: from bisfv_dimension_levels

707: , default_values_api
708: , enabled
709: , drill_to_form_function
710: , hide_in_design
711: from bisfv_dimension_levels
712: where dimension_level_name = p_Dimension_level_Rec.dimension_level_name;
713:
714: BEGIN
715:

Line 874: -- level ids from bisfv_dimension_levels.

870:
871: --===================================================================
872: -- p_all_dim_levels_tbl contains different dimension level ids.
873: -- x_all_dim_levels_tbl contains all records for the input dimension
874: -- level ids from bisfv_dimension_levels.
875: -- The output plsql table will be indexed by dimension level id
876:
877: PROCEDURE retrieve_mult_dim_levels(
878: p_api_version IN NUMBER

Line 1014: FROM bisfv_dimension_levels

1010: , default_values_api
1011: , enabled
1012: , drill_to_form_function
1013: , hide_in_design
1014: FROM bisfv_dimension_levels
1015: WHERE dimension_level_id IN (';
1016:
1017: IF (p_all_dim_levels_tbl.COUNT <= 10) THEN -- lesser than 10 use bind variables
1018: l_index := 1;