APPS.FEM_CHECK_BR_DIS_MBRS_PKG dependencies on FEM_BR_DIS_MBR_HIER

Line 1644: --get dimension id and information for fem_br_dis_mbr_hier table

1640: p_module => C_MODULE,
1641: p_msg_text => 'p_global_vs_id is ' || p_global_vs_id);
1642: END IF;
1643:
1644: --get dimension id and information for fem_br_dis_mbr_hier table
1645: SELECT h.dimension_id, h.hierarchy_obj_id, a.object_name, od.display_name,
1646: h.flattened_rows_flag
1647: INTO v_dim_id, v_hier_obj_id, v_hier_obj_name, v_hier_obj_def_name,
1648: v_flat_flag

Line 1701: v_insert_stmt := 'INSERT INTO fem_br_dis_mbr_hier

1697: END IF;
1698:
1699: --whether or not the hier is flattened doesnt effect the first part of
1700: --the dynamic insert stmt.
1701: v_insert_stmt := 'INSERT INTO fem_br_dis_mbr_hier
1702: (request_id, hierarchy_object_id, hierarchy_object_name,
1703: hierarchy_obj_def_name, creation_date, created_by, last_updated_by,
1704: last_update_date, last_update_login, parent_value_set_name,
1705: child_value_set_name, parent_value_set_id, child_value_set_id,

Line 1777: 'UPDATE fem_br_dis_mbr_hier

1773: --need to be marked.
1774: --the other members are used to show the path from root to disabled
1775: --member
1776: v_insert_stmt :=
1777: 'UPDATE fem_br_dis_mbr_hier
1778: SET disabled_flag = ''Y''
1779: WHERE hierarchy_obj_def_id = :obj_def_id' ||
1780: ' AND child_member_id IN
1781: (SELECT ' || v_member_column ||

Line 2505: DELETE FROM FEM_BR_DIS_MBR_HIER WHERE REQUEST_ID = p_request_id;

2501:
2502: IF(p_request_id is not null) THEN
2503:
2504: DELETE FROM FEM_BR_DIS_MBR_CONTEXTS WHERE REQUEST_ID = p_request_id;
2505: DELETE FROM FEM_BR_DIS_MBR_HIER WHERE REQUEST_ID = p_request_id;
2506: DELETE FROM FEM_BR_DIS_MBR_REQUESTS WHERE REQUEST_ID = p_request_id;
2507:
2508:
2509: ELSIF(l_start_date IS NOT NULL AND l_end_date IS NOT NULL) THEN

Line 2515: DELETE FROM FEM_BR_DIS_MBR_HIER WHERE REQUEST_ID IN (SELECT REQUEST_ID FROM

2511: DELETE FROM FEM_BR_DIS_MBR_CONTEXTS WHERE REQUEST_ID IN (SELECT REQUEST_ID FROM
2512: FEM_BR_DIS_MBR_REQUESTS WHERE REQUEST_DATE BETWEEN l_start_date AND
2513: l_end_date);
2514:
2515: DELETE FROM FEM_BR_DIS_MBR_HIER WHERE REQUEST_ID IN (SELECT REQUEST_ID FROM
2516: FEM_BR_DIS_MBR_REQUESTS WHERE REQUEST_DATE BETWEEN l_start_date AND
2517: l_end_date);
2518:
2519: DELETE FROM FEM_BR_DIS_MBR_REQUESTS WHERE REQUEST_DATE BETWEEN l_start_date AND

Line 2527: DELETE FROM FEM_BR_DIS_MBR_HIER WHERE REQUEST_ID IN (SELECT REQUEST_ID FROM

2523:
2524: DELETE FROM FEM_BR_DIS_MBR_CONTEXTS WHERE REQUEST_ID IN (SELECT REQUEST_ID FROM
2525: FEM_BR_DIS_MBR_REQUESTS WHERE REQUEST_DATE > l_start_date);
2526:
2527: DELETE FROM FEM_BR_DIS_MBR_HIER WHERE REQUEST_ID IN (SELECT REQUEST_ID FROM
2528: FEM_BR_DIS_MBR_REQUESTS WHERE REQUEST_DATE > l_start_date);
2529:
2530: DELETE FROM FEM_BR_DIS_MBR_REQUESTS WHERE REQUEST_DATE > l_start_date;
2531:

Line 2537: DELETE FROM FEM_BR_DIS_MBR_HIER WHERE REQUEST_ID IN (SELECT REQUEST_ID FROM

2533:
2534: DELETE FROM FEM_BR_DIS_MBR_CONTEXTS WHERE REQUEST_ID IN (SELECT REQUEST_ID FROM
2535: FEM_BR_DIS_MBR_REQUESTS WHERE REQUEST_DATE < l_end_date);
2536:
2537: DELETE FROM FEM_BR_DIS_MBR_HIER WHERE REQUEST_ID IN (SELECT REQUEST_ID FROM
2538: FEM_BR_DIS_MBR_REQUESTS WHERE REQUEST_DATE < l_end_date);
2539:
2540: DELETE FROM FEM_BR_DIS_MBR_REQUESTS WHERE REQUEST_DATE < l_end_date;
2541:

Line 2545: DELETE FROM FEM_BR_DIS_MBR_HIER;

2541:
2542: ELSE -- Delete all :-(
2543:
2544: DELETE FROM FEM_BR_DIS_MBR_CONTEXTS;
2545: DELETE FROM FEM_BR_DIS_MBR_HIER;
2546: DELETE FROM FEM_BR_DIS_MBR_REQUESTS;
2547:
2548: END IF;
2549: