APPS.FTP_CONDITION_PVT dependencies on FEM_XDIM_DIMENSIONS

Line 12: l_member_table fem_xdim_dimensions.member_vl_object_name%TYPE;

8: * @return object_id Object Identifier
9: */
10: FUNCTION get_dim_member_name(p_dimension_id IN NUMBER, p_member_id IN VARCHAR2)
11: RETURN VARCHAR2 IS
12: l_member_table fem_xdim_dimensions.member_vl_object_name%TYPE;
13: l_member_id_col fem_xdim_dimensions.member_col%TYPE;
14: l_member_name_col fem_xdim_dimensions.member_name_col%TYPE;
15: l_member_name VARCHAR2(150);
16: l_select_stmt VARCHAR2(500);

Line 13: l_member_id_col fem_xdim_dimensions.member_col%TYPE;

9: */
10: FUNCTION get_dim_member_name(p_dimension_id IN NUMBER, p_member_id IN VARCHAR2)
11: RETURN VARCHAR2 IS
12: l_member_table fem_xdim_dimensions.member_vl_object_name%TYPE;
13: l_member_id_col fem_xdim_dimensions.member_col%TYPE;
14: l_member_name_col fem_xdim_dimensions.member_name_col%TYPE;
15: l_member_name VARCHAR2(150);
16: l_select_stmt VARCHAR2(500);
17: l_cursor_id INTEGER;

Line 14: l_member_name_col fem_xdim_dimensions.member_name_col%TYPE;

10: FUNCTION get_dim_member_name(p_dimension_id IN NUMBER, p_member_id IN VARCHAR2)
11: RETURN VARCHAR2 IS
12: l_member_table fem_xdim_dimensions.member_vl_object_name%TYPE;
13: l_member_id_col fem_xdim_dimensions.member_col%TYPE;
14: l_member_name_col fem_xdim_dimensions.member_name_col%TYPE;
15: l_member_name VARCHAR2(150);
16: l_select_stmt VARCHAR2(500);
17: l_cursor_id INTEGER;
18: l_Dummy INTEGER;

Line 26: FROM fem_xdim_dimensions

22:
23: -- Create the query string.
24: SELECT member_vl_object_name, member_col, member_name_col
25: INTO l_member_table, l_member_id_col, l_member_name_col
26: FROM fem_xdim_dimensions
27: WHERE dimension_id = p_dimension_id;
28:
29: l_select_stmt := 'SELECT ' || l_member_name_col ||
30: ' FROM ' || l_member_table ||