APPS.GCS_WEBADI_PKG dependencies on FEM_HIER_VALUE_SETS_T

Line 1639: DELETE FROM fem_hier_value_sets_t

1635: p_version_start_date,
1636: nvl(p_version_end_date, p_version_start_date + 365 * 20),
1637: null);
1638:
1639: DELETE FROM fem_hier_value_sets_t
1640: WHERE hierarchy_object_name = p_hierarchy_name;
1641:
1642: INSERT INTO fem_hier_value_sets_t
1643: (hierarchy_object_name, value_set_display_code, language, status)

Line 1642: INSERT INTO fem_hier_value_sets_t

1638:
1639: DELETE FROM fem_hier_value_sets_t
1640: WHERE hierarchy_object_name = p_hierarchy_name;
1641:
1642: INSERT INTO fem_hier_value_sets_t
1643: (hierarchy_object_name, value_set_display_code, language, status)
1644: SELECT DISTINCT p_hierarchy_name,
1645: child_vs_display_code,
1646: USERENV('LANG'),

Line 1652: INSERT INTO fem_hier_value_sets_t

1648: FROM gcs_hier_members_t
1649: WHERE sequence_num = p_sequence_num;
1650:
1651: BEGIN
1652: INSERT INTO fem_hier_value_sets_t
1653: (hierarchy_object_name, value_set_display_code, language, status)
1654: SELECT DISTINCT p_hierarchy_name,
1655: parent_vs_display_code,
1656: USERENV('LANG'),

Line 1762: DELETE FROM fem_hier_value_sets_t

1758: DELETE FROM fem_hierarchies_t
1759: WHERE hierarchy_object_name = p_hierarchy_name
1760: AND hier_obj_def_display_name = p_version_name;
1761:
1762: DELETE FROM fem_hier_value_sets_t
1763: WHERE hierarchy_object_name = p_hierarchy_name;
1764:
1765: FORALL i IN l_err_parent_display_code.FIRST .. l_err_parent_display_code.LAST
1766: EXECUTE IMMEDIATE