APPS.FEM_WEBADI_HIER_UTILS_PVT dependencies on FEM_HIER_DIM_GRPS_T

Line 71: -- Delete from fem_hier_dim_grps_t table

67: USING
68: p_hierarchy_object_name
69: , p_hierarchy_obj_def_disp_name;
70: --
71: -- Delete from fem_hier_dim_grps_t table
72: --
73: DELETE FROM
74: fem_hier_dim_grps_t dimgrp
75: WHERE

Line 74: fem_hier_dim_grps_t dimgrp

70: --
71: -- Delete from fem_hier_dim_grps_t table
72: --
73: DELETE FROM
74: fem_hier_dim_grps_t dimgrp
75: WHERE
76: dimgrp.hierarchy_object_name = p_hierarchy_object_name;
77:
78: END Delete_Old_Run;

Line 1015: -- Now do Insert/Update in fem_hier_dim_grps_t table

1011: p_child_display_code;
1012: --
1013: END ;
1014: --
1015: -- Now do Insert/Update in fem_hier_dim_grps_t table
1016: -- with l_child_grp_disp_code.
1017: BEGIN
1018: --
1019: INSERT

Line 1021: fem_hier_dim_grps_t

1017: BEGIN
1018: --
1019: INSERT
1020: INTO
1021: fem_hier_dim_grps_t
1022: ( hierarchy_object_name
1023: , language
1024: , status
1025: , dimension_group_display_code

Line 1038: fem_hier_dim_grps_t hiergrp

1034: EXCEPTION
1035: WHEN DUP_VAL_ON_INDEX THEN
1036: --
1037: UPDATE
1038: fem_hier_dim_grps_t hiergrp
1039: SET
1040: hiergrp.language = l_language
1041: , hiergrp.status = l_status
1042: WHERE

Line 1050: -- and do the DML in fem_hier_dim_grps_t.

1046: END ;
1047: --
1048: -- If p_parent_display_code and p_child_display_code
1049: -- are different, get the details for p_parent_display_code
1050: -- and do the DML in fem_hier_dim_grps_t.
1051: IF ( p_parent_display_code <> p_child_display_code )
1052: THEN
1053: --
1054: BEGIN

Line 1067: fem_hier_dim_grps_t

1063: p_parent_display_code ;
1064: --
1065: INSERT
1066: INTO
1067: fem_hier_dim_grps_t
1068: ( hierarchy_object_name
1069: , language
1070: , status
1071: , dimension_group_display_code

Line 1084: fem_hier_dim_grps_t hiergrp

1080: EXCEPTION
1081: WHEN DUP_VAL_ON_INDEX THEN
1082: --
1083: UPDATE
1084: fem_hier_dim_grps_t hiergrp
1085: SET
1086: hiergrp.language = l_language
1087: , hiergrp.status = l_status
1088: WHERE