APPS.FEM_WEBADI_HIER_UTILS_PVT dependencies on FEM_HIER_VALUE_SETS_T

Line 45: -- Delete from fem_hier_value_sets_t table

41: l_status VARCHAR2(4) := 'LOAD' ;
42: --
43: BEGIN
44: --
45: -- Delete from fem_hier_value_sets_t table
46: --
47: DELETE FROM
48: fem_hier_value_sets_t hiervset
49: WHERE

Line 48: fem_hier_value_sets_t hiervset

44: --
45: -- Delete from fem_hier_value_sets_t table
46: --
47: DELETE FROM
48: fem_hier_value_sets_t hiervset
49: WHERE
50: hiervset.hierarchy_object_name = p_hierarchy_object_name
51: AND hiervset.value_set_display_code = g_global_val_tbl(1).value_set_display_code;
52:

Line 662: -- fem_hier_value_sets_t is an interface table that designates

658: --
659: l_parent_vs_disp_code := g_global_val_tbl(1).value_set_display_code ;
660: l_child_vs_disp_code := g_global_val_tbl(1).value_set_display_code ;
661: --
662: -- fem_hier_value_sets_t is an interface table that designates
663: -- the value sets for Analytic dimension hierarchies that will
664: -- be loaded using the Dimension Hierarchy Loader.
665: -- This will be done only when creating new hierarchies of any
666: -- dimension except for the Calendar Period.

Line 671: fem_hier_value_sets_t

667: BEGIN
668: INSERT FIRST
669: WHEN ( cnt = 0 ) THEN
670: INTO
671: fem_hier_value_sets_t
672: ( hierarchy_object_name
673: , value_set_display_code
674: , language
675: , status

Line 686: fem_hier_value_sets_t hiervs

682: )
683: SELECT
684: COUNT(1) AS cnt
685: FROM
686: fem_hier_value_sets_t hiervs
687: WHERE
688: hiervs.hierarchy_object_name = p_hierarchy_object_name
689: AND hiervs.value_set_display_code = l_parent_vs_disp_code ;
690: --

Line 695: fem_hier_value_sets_t hiervset

691: IF ( SQL%ROWCOUNT = 0 ) -- Record already exists.
692: THEN
693: --
694: UPDATE
695: fem_hier_value_sets_t hiervset
696: SET
697: hiervset.language = p_language
698: , hiervset.status = l_status
699: WHERE