APPS.FEM_DIS_HIER_PKG dependencies on FEM_DIS_DIMENSIONS_V

Line 2630: FROM FEM_DIS_DIMENSIONS_V

2626: ) IS
2627:
2628: CURSOR CurDim IS
2629: SELECT *
2630: FROM FEM_DIS_DIMENSIONS_V
2631: WHERE DIMENSION_VARCHAR_LABEL <> 'ALL';
2632:
2633: CURSOR CurReq(p_parent_request_id NUMBER) IS
2634: SELECT *

Line 2638: TYPE DisDims IS TABLE OF FEM_DIS_DIMENSIONS_V%ROWTYPE;

2634: SELECT *
2635: FROM FND_CONCURRENT_REQUESTS
2636: WHERE PARENT_REQUEST_ID = p_parent_request_id;
2637:
2638: TYPE DisDims IS TABLE OF FEM_DIS_DIMENSIONS_V%ROWTYPE;
2639: TYPE ChildReqs IS TABLE OF FND_CONCURRENT_REQUESTS%ROWTYPE;
2640:
2641: v_dis_dims DisDims;
2642: v_child_requests ChildReqs;

Line 2704: FROM FEM_DIS_DIMENSIONS_V

2700: -- Validate input parameter
2701: --
2702: BEGIN
2703: SELECT 1 INTO v_dummy_number
2704: FROM FEM_DIS_DIMENSIONS_V
2705: WHERE DIMENSION_VARCHAR_LABEL = p_dimension_varchar_label;
2706: EXCEPTION
2707: WHEN NO_DATA_FOUND THEN
2708: RAISE HIER_TRANS_INVALID_DIMENSION;